ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22093 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1486456 | 1486456 | 2021-07-05 | St. James | Louisiana | 22093 | 2048 | 51 |
1483210 | 1483210 | 2021-07-04 | St. James | Louisiana | 22093 | 2048 | 51 |
1479963 | 1479963 | 2021-07-03 | St. James | Louisiana | 22093 | 2048 | 51 |
1476717 | 1476717 | 2021-07-02 | St. James | Louisiana | 22093 | 2048 | 51 |
1473471 | 1473471 | 2021-07-01 | St. James | Louisiana | 22093 | 2045 | 51 |
1470225 | 1470225 | 2021-06-30 | St. James | Louisiana | 22093 | 2038 | 51 |
1466980 | 1466980 | 2021-06-29 | St. James | Louisiana | 22093 | 2039 | 51 |
1463735 | 1463735 | 2021-06-28 | St. James | Louisiana | 22093 | 2036 | 51 |
1460490 | 1460490 | 2021-06-27 | St. James | Louisiana | 22093 | 2033 | 50 |
1457245 | 1457245 | 2021-06-26 | St. James | Louisiana | 22093 | 2033 | 50 |
1454000 | 1454000 | 2021-06-25 | St. James | Louisiana | 22093 | 2033 | 50 |
1450754 | 1450754 | 2021-06-24 | St. James | Louisiana | 22093 | 2032 | 50 |
1447509 | 1447509 | 2021-06-23 | St. James | Louisiana | 22093 | 2030 | 50 |
1444264 | 1444264 | 2021-06-22 | St. James | Louisiana | 22093 | 2029 | 50 |
1441019 | 1441019 | 2021-06-21 | St. James | Louisiana | 22093 | 2027 | 50 |
1437772 | 1437772 | 2021-06-20 | St. James | Louisiana | 22093 | 2029 | 50 |
1434525 | 1434525 | 2021-06-19 | St. James | Louisiana | 22093 | 2029 | 50 |
1431279 | 1431279 | 2021-06-18 | St. James | Louisiana | 22093 | 2029 | 50 |
1428034 | 1428034 | 2021-06-17 | St. James | Louisiana | 22093 | 2023 | 50 |
1424789 | 1424789 | 2021-06-16 | St. James | Louisiana | 22093 | 2023 | 50 |
1421541 | 1421541 | 2021-06-15 | St. James | Louisiana | 22093 | 2022 | 50 |
1418296 | 1418296 | 2021-06-14 | St. James | Louisiana | 22093 | 2017 | 50 |
1415050 | 1415050 | 2021-06-13 | St. James | Louisiana | 22093 | 2016 | 50 |
1411805 | 1411805 | 2021-06-12 | St. James | Louisiana | 22093 | 2016 | 50 |
1408560 | 1408560 | 2021-06-11 | St. James | Louisiana | 22093 | 2016 | 50 |
1405314 | 1405314 | 2021-06-10 | St. James | Louisiana | 22093 | 2012 | 50 |
1402069 | 1402069 | 2021-06-09 | St. James | Louisiana | 22093 | 2012 | 50 |
1398824 | 1398824 | 2021-06-08 | St. James | Louisiana | 22093 | 2013 | 50 |
1395577 | 1395577 | 2021-06-07 | St. James | Louisiana | 22093 | 2014 | 50 |
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);