ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. James" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811285 | 1811285 | 2021-10-13 | St. James | Louisiana | 22093 | 3433 | 70 |
1808036 | 1808036 | 2021-10-12 | St. James | Louisiana | 22093 | 3433 | 70 |
1804785 | 1804785 | 2021-10-11 | St. James | Louisiana | 22093 | 3427 | 70 |
1801536 | 1801536 | 2021-10-10 | St. James | Louisiana | 22093 | 3426 | 70 |
1798287 | 1798287 | 2021-10-09 | St. James | Louisiana | 22093 | 3426 | 70 |
1795038 | 1795038 | 2021-10-08 | St. James | Louisiana | 22093 | 3426 | 70 |
1791790 | 1791790 | 2021-10-07 | St. James | Louisiana | 22093 | 3424 | 70 |
1788541 | 1788541 | 2021-10-06 | St. James | Louisiana | 22093 | 3412 | 70 |
1785292 | 1785292 | 2021-10-05 | St. James | Louisiana | 22093 | 3411 | 70 |
1782043 | 1782043 | 2021-10-04 | St. James | Louisiana | 22093 | 3400 | 70 |
1778793 | 1778793 | 2021-10-03 | St. James | Louisiana | 22093 | 3398 | 68 |
1775543 | 1775543 | 2021-10-02 | St. James | Louisiana | 22093 | 3398 | 68 |
1772293 | 1772293 | 2021-10-01 | St. James | Louisiana | 22093 | 3398 | 68 |
1769044 | 1769044 | 2021-09-30 | St. James | Louisiana | 22093 | 3390 | 68 |
1765795 | 1765795 | 2021-09-29 | St. James | Louisiana | 22093 | 3388 | 68 |
1762546 | 1762546 | 2021-09-28 | St. James | Louisiana | 22093 | 3383 | 68 |
1759298 | 1759298 | 2021-09-27 | St. James | Louisiana | 22093 | 3380 | 67 |
1756050 | 1756050 | 2021-09-26 | St. James | Louisiana | 22093 | 3373 | 67 |
1752802 | 1752802 | 2021-09-25 | St. James | Louisiana | 22093 | 3373 | 67 |
1749553 | 1749553 | 2021-09-24 | St. James | Louisiana | 22093 | 3373 | 67 |
1746303 | 1746303 | 2021-09-23 | St. James | Louisiana | 22093 | 3369 | 67 |
1743054 | 1743054 | 2021-09-22 | St. James | Louisiana | 22093 | 3366 | 65 |
1739805 | 1739805 | 2021-09-21 | St. James | Louisiana | 22093 | 3353 | 64 |
1736556 | 1736556 | 2021-09-20 | St. James | Louisiana | 22093 | 3348 | 64 |
1733306 | 1733306 | 2021-09-19 | St. James | Louisiana | 22093 | 3332 | 62 |
1730056 | 1730056 | 2021-09-18 | St. James | Louisiana | 22093 | 3332 | 62 |
1726806 | 1726806 | 2021-09-17 | St. James | Louisiana | 22093 | 3332 | 62 |
1723557 | 1723557 | 2021-09-16 | St. James | Louisiana | 22093 | 3317 | 62 |
1720308 | 1720308 | 2021-09-15 | St. James | Louisiana | 22093 | 3307 | 62 |
1717060 | 1717060 | 2021-09-14 | St. James | Louisiana | 22093 | 3294 | 62 |
1713814 | 1713814 | 2021-09-13 | St. James | Louisiana | 22093 | 3285 | 62 |
1710567 | 1710567 | 2021-09-12 | St. James | Louisiana | 22093 | 3257 | 62 |
1707320 | 1707320 | 2021-09-11 | St. James | Louisiana | 22093 | 3257 | 62 |
1704072 | 1704072 | 2021-09-10 | St. James | Louisiana | 22093 | 3257 | 62 |
1700822 | 1700822 | 2021-09-09 | St. James | Louisiana | 22093 | 3253 | 62 |
1697573 | 1697573 | 2021-09-08 | St. James | Louisiana | 22093 | 3239 | 61 |
1694325 | 1694325 | 2021-09-07 | St. James | Louisiana | 22093 | 3239 | 61 |
1691076 | 1691076 | 2021-09-06 | St. James | Louisiana | 22093 | 3217 | 61 |
1687826 | 1687826 | 2021-09-05 | St. James | Louisiana | 22093 | 3217 | 61 |
1684576 | 1684576 | 2021-09-04 | St. James | Louisiana | 22093 | 3217 | 61 |
1681325 | 1681325 | 2021-09-03 | St. James | Louisiana | 22093 | 3217 | 61 |
1678077 | 1678077 | 2021-09-02 | St. James | Louisiana | 22093 | 3215 | 61 |
1674830 | 1674830 | 2021-09-01 | St. James | Louisiana | 22093 | 3210 | 61 |
1671581 | 1671581 | 2021-08-31 | St. James | Louisiana | 22093 | 3041 | 60 |
1668334 | 1668334 | 2021-08-30 | St. James | Louisiana | 22093 | 3041 | 60 |
1665087 | 1665087 | 2021-08-29 | St. James | Louisiana | 22093 | 3041 | 60 |
1661839 | 1661839 | 2021-08-28 | St. James | Louisiana | 22093 | 3041 | 60 |
1658591 | 1658591 | 2021-08-27 | St. James | Louisiana | 22093 | 3041 | 60 |
1655343 | 1655343 | 2021-08-26 | St. James | Louisiana | 22093 | 3027 | 59 |
1652096 | 1652096 | 2021-08-25 | St. James | Louisiana | 22093 | 2993 | 58 |
1648847 | 1648847 | 2021-08-24 | St. James | Louisiana | 22093 | 2965 | 58 |
1645599 | 1645599 | 2021-08-23 | St. James | Louisiana | 22093 | 2935 | 57 |
1642350 | 1642350 | 2021-08-22 | St. James | Louisiana | 22093 | 2881 | 57 |
1639100 | 1639100 | 2021-08-21 | St. James | Louisiana | 22093 | 2881 | 57 |
1635850 | 1635850 | 2021-08-20 | St. James | Louisiana | 22093 | 2881 | 57 |
1632600 | 1632600 | 2021-08-19 | St. James | Louisiana | 22093 | 2857 | 57 |
1629353 | 1629353 | 2021-08-18 | St. James | Louisiana | 22093 | 2813 | 57 |
1626106 | 1626106 | 2021-08-17 | St. James | Louisiana | 22093 | 2773 | 55 |
1622859 | 1622859 | 2021-08-16 | St. James | Louisiana | 22093 | 2765 | 55 |
1619612 | 1619612 | 2021-08-15 | St. James | Louisiana | 22093 | 2718 | 55 |
1616364 | 1616364 | 2021-08-14 | St. James | Louisiana | 22093 | 2718 | 55 |
1613115 | 1613115 | 2021-08-13 | St. James | Louisiana | 22093 | 2718 | 55 |
1609867 | 1609867 | 2021-08-12 | St. James | Louisiana | 22093 | 2699 | 55 |
1606618 | 1606618 | 2021-08-11 | St. James | Louisiana | 22093 | 2661 | 55 |
1603369 | 1603369 | 2021-08-10 | St. James | Louisiana | 22093 | 2638 | 53 |
1600120 | 1600120 | 2021-08-09 | St. James | Louisiana | 22093 | 2604 | 52 |
1596872 | 1596872 | 2021-08-08 | St. James | Louisiana | 22093 | 2557 | 52 |
1593623 | 1593623 | 2021-08-07 | St. James | Louisiana | 22093 | 2557 | 52 |
1590374 | 1590374 | 2021-08-06 | St. James | Louisiana | 22093 | 2557 | 52 |
1587125 | 1587125 | 2021-08-05 | St. James | Louisiana | 22093 | 2504 | 52 |
1583875 | 1583875 | 2021-08-04 | St. James | Louisiana | 22093 | 2459 | 52 |
1580625 | 1580625 | 2021-08-03 | St. James | Louisiana | 22093 | 2447 | 52 |
1577376 | 1577376 | 2021-08-02 | St. James | Louisiana | 22093 | 2407 | 52 |
1574128 | 1574128 | 2021-08-01 | St. James | Louisiana | 22093 | 2346 | 52 |
1570880 | 1570880 | 2021-07-31 | St. James | Louisiana | 22093 | 2346 | 52 |
1567632 | 1567632 | 2021-07-30 | St. James | Louisiana | 22093 | 2346 | 52 |
1564384 | 1564384 | 2021-07-29 | St. James | Louisiana | 22093 | 2301 | 52 |
1561136 | 1561136 | 2021-07-28 | St. James | Louisiana | 22093 | 2279 | 52 |
1557889 | 1557889 | 2021-07-27 | St. James | Louisiana | 22093 | 2230 | 52 |
1554642 | 1554642 | 2021-07-26 | St. James | Louisiana | 22093 | 2206 | 52 |
1551395 | 1551395 | 2021-07-25 | St. James | Louisiana | 22093 | 2165 | 52 |
1548148 | 1548148 | 2021-07-24 | St. James | Louisiana | 22093 | 2165 | 52 |
1544901 | 1544901 | 2021-07-23 | St. James | Louisiana | 22093 | 2165 | 52 |
1541653 | 1541653 | 2021-07-22 | St. James | Louisiana | 22093 | 2152 | 52 |
1538406 | 1538406 | 2021-07-21 | St. James | Louisiana | 22093 | 2138 | 52 |
1535158 | 1535158 | 2021-07-20 | St. James | Louisiana | 22093 | 2123 | 52 |
1531911 | 1531911 | 2021-07-19 | St. James | Louisiana | 22093 | 2106 | 52 |
1528664 | 1528664 | 2021-07-18 | St. James | Louisiana | 22093 | 2088 | 52 |
1525417 | 1525417 | 2021-07-17 | St. James | Louisiana | 22093 | 2088 | 52 |
1522169 | 1522169 | 2021-07-16 | St. James | Louisiana | 22093 | 2088 | 52 |
1518921 | 1518921 | 2021-07-15 | St. James | Louisiana | 22093 | 2086 | 52 |
1515674 | 1515674 | 2021-07-14 | St. James | Louisiana | 22093 | 2077 | 52 |
1512428 | 1512428 | 2021-07-13 | St. James | Louisiana | 22093 | 2070 | 51 |
1509181 | 1509181 | 2021-07-12 | St. James | Louisiana | 22093 | 2067 | 51 |
1505935 | 1505935 | 2021-07-11 | St. James | Louisiana | 22093 | 2066 | 51 |
1502689 | 1502689 | 2021-07-10 | St. James | Louisiana | 22093 | 2066 | 51 |
1499443 | 1499443 | 2021-07-09 | St. James | Louisiana | 22093 | 2066 | 51 |
1496196 | 1496196 | 2021-07-08 | St. James | Louisiana | 22093 | 2058 | 51 |
1492950 | 1492950 | 2021-07-07 | St. James | Louisiana | 22093 | 2056 | 51 |
1489703 | 1489703 | 2021-07-06 | St. James | Louisiana | 22093 | 2049 | 51 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);