ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22109 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717068 | 1717068 | 2021-09-14 | Terrebonne | Louisiana | 22109 | 18598 | 286 |
1713822 | 1713822 | 2021-09-13 | Terrebonne | Louisiana | 22109 | 18522 | 279 |
1710575 | 1710575 | 2021-09-12 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1707328 | 1707328 | 2021-09-11 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1704080 | 1704080 | 2021-09-10 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1700830 | 1700830 | 2021-09-09 | Terrebonne | Louisiana | 22109 | 18324 | 276 |
1697581 | 1697581 | 2021-09-08 | Terrebonne | Louisiana | 22109 | 18259 | 276 |
1694333 | 1694333 | 2021-09-07 | Terrebonne | Louisiana | 22109 | 18217 | 273 |
1691084 | 1691084 | 2021-09-06 | Terrebonne | Louisiana | 22109 | 18110 | 273 |
1687834 | 1687834 | 2021-09-05 | Terrebonne | Louisiana | 22109 | 18110 | 273 |
1684584 | 1684584 | 2021-09-04 | Terrebonne | Louisiana | 22109 | 18110 | 273 |
1681333 | 1681333 | 2021-09-03 | Terrebonne | Louisiana | 22109 | 18110 | 273 |
1678085 | 1678085 | 2021-09-02 | Terrebonne | Louisiana | 22109 | 18076 | 272 |
1674838 | 1674838 | 2021-09-01 | Terrebonne | Louisiana | 22109 | 18024 | 269 |
1671589 | 1671589 | 2021-08-31 | Terrebonne | Louisiana | 22109 | 17784 | 267 |
1668342 | 1668342 | 2021-08-30 | Terrebonne | Louisiana | 22109 | 17784 | 267 |
1665095 | 1665095 | 2021-08-29 | Terrebonne | Louisiana | 22109 | 17784 | 267 |
1661847 | 1661847 | 2021-08-28 | Terrebonne | Louisiana | 22109 | 17784 | 267 |
1658599 | 1658599 | 2021-08-27 | Terrebonne | Louisiana | 22109 | 17784 | 267 |
1655351 | 1655351 | 2021-08-26 | Terrebonne | Louisiana | 22109 | 17654 | 267 |
1652104 | 1652104 | 2021-08-25 | Terrebonne | Louisiana | 22109 | 17393 | 264 |
1648855 | 1648855 | 2021-08-24 | Terrebonne | Louisiana | 22109 | 17188 | 263 |
1645607 | 1645607 | 2021-08-23 | Terrebonne | Louisiana | 22109 | 17026 | 259 |
1642358 | 1642358 | 2021-08-22 | Terrebonne | Louisiana | 22109 | 16606 | 258 |
1639108 | 1639108 | 2021-08-21 | Terrebonne | Louisiana | 22109 | 16606 | 258 |
1635858 | 1635858 | 2021-08-20 | Terrebonne | Louisiana | 22109 | 16606 | 258 |
1632608 | 1632608 | 2021-08-19 | Terrebonne | Louisiana | 22109 | 16288 | 258 |
1629361 | 1629361 | 2021-08-18 | Terrebonne | Louisiana | 22109 | 16058 | 256 |
1626114 | 1626114 | 2021-08-17 | Terrebonne | Louisiana | 22109 | 15891 | 253 |
1622867 | 1622867 | 2021-08-16 | Terrebonne | Louisiana | 22109 | 15733 | 251 |
1619620 | 1619620 | 2021-08-15 | Terrebonne | Louisiana | 22109 | 15082 | 250 |
1616372 | 1616372 | 2021-08-14 | Terrebonne | Louisiana | 22109 | 15082 | 250 |
1613123 | 1613123 | 2021-08-13 | Terrebonne | Louisiana | 22109 | 15082 | 250 |
1609875 | 1609875 | 2021-08-12 | Terrebonne | Louisiana | 22109 | 14888 | 250 |
1606626 | 1606626 | 2021-08-11 | Terrebonne | Louisiana | 22109 | 14738 | 251 |
1603377 | 1603377 | 2021-08-10 | Terrebonne | Louisiana | 22109 | 14566 | 248 |
1600128 | 1600128 | 2021-08-09 | Terrebonne | Louisiana | 22109 | 14402 | 244 |
1596880 | 1596880 | 2021-08-08 | Terrebonne | Louisiana | 22109 | 13834 | 236 |
1593631 | 1593631 | 2021-08-07 | Terrebonne | Louisiana | 22109 | 13834 | 236 |
1590382 | 1590382 | 2021-08-06 | Terrebonne | Louisiana | 22109 | 13834 | 236 |
1587133 | 1587133 | 2021-08-05 | Terrebonne | Louisiana | 22109 | 13587 | 235 |
1583883 | 1583883 | 2021-08-04 | Terrebonne | Louisiana | 22109 | 13407 | 234 |
1580633 | 1580633 | 2021-08-03 | Terrebonne | Louisiana | 22109 | 13244 | 234 |
1577384 | 1577384 | 2021-08-02 | Terrebonne | Louisiana | 22109 | 13134 | 234 |
1574136 | 1574136 | 2021-08-01 | Terrebonne | Louisiana | 22109 | 12666 | 233 |
1570888 | 1570888 | 2021-07-31 | Terrebonne | Louisiana | 22109 | 12666 | 233 |
1567640 | 1567640 | 2021-07-30 | Terrebonne | Louisiana | 22109 | 12666 | 233 |
1564392 | 1564392 | 2021-07-29 | Terrebonne | Louisiana | 22109 | 12504 | 233 |
1561144 | 1561144 | 2021-07-28 | Terrebonne | Louisiana | 22109 | 12341 | 233 |
1557897 | 1557897 | 2021-07-27 | Terrebonne | Louisiana | 22109 | 12252 | 232 |
1554650 | 1554650 | 2021-07-26 | Terrebonne | Louisiana | 22109 | 12093 | 231 |
1551403 | 1551403 | 2021-07-25 | Terrebonne | Louisiana | 22109 | 11836 | 231 |
1548156 | 1548156 | 2021-07-24 | Terrebonne | Louisiana | 22109 | 11836 | 231 |
1544909 | 1544909 | 2021-07-23 | Terrebonne | Louisiana | 22109 | 11836 | 231 |
1541661 | 1541661 | 2021-07-22 | Terrebonne | Louisiana | 22109 | 11758 | 230 |
1538414 | 1538414 | 2021-07-21 | Terrebonne | Louisiana | 22109 | 11654 | 230 |
1535166 | 1535166 | 2021-07-20 | Terrebonne | Louisiana | 22109 | 11554 | 230 |
1531919 | 1531919 | 2021-07-19 | Terrebonne | Louisiana | 22109 | 11537 | 229 |
1528672 | 1528672 | 2021-07-18 | Terrebonne | Louisiana | 22109 | 11404 | 229 |
1525425 | 1525425 | 2021-07-17 | Terrebonne | Louisiana | 22109 | 11404 | 229 |
1522177 | 1522177 | 2021-07-16 | Terrebonne | Louisiana | 22109 | 11404 | 229 |
1518929 | 1518929 | 2021-07-15 | Terrebonne | Louisiana | 22109 | 11361 | 229 |
1515682 | 1515682 | 2021-07-14 | Terrebonne | Louisiana | 22109 | 11324 | 229 |
1512436 | 1512436 | 2021-07-13 | Terrebonne | Louisiana | 22109 | 11269 | 228 |
1509189 | 1509189 | 2021-07-12 | Terrebonne | Louisiana | 22109 | 11239 | 227 |
1505943 | 1505943 | 2021-07-11 | Terrebonne | Louisiana | 22109 | 11170 | 228 |
1502697 | 1502697 | 2021-07-10 | Terrebonne | Louisiana | 22109 | 11170 | 228 |
1499451 | 1499451 | 2021-07-09 | Terrebonne | Louisiana | 22109 | 11170 | 228 |
1496204 | 1496204 | 2021-07-08 | Terrebonne | Louisiana | 22109 | 11134 | 228 |
1492958 | 1492958 | 2021-07-07 | Terrebonne | Louisiana | 22109 | 11107 | 228 |
1489711 | 1489711 | 2021-07-06 | Terrebonne | Louisiana | 22109 | 11078 | 228 |
1486464 | 1486464 | 2021-07-05 | Terrebonne | Louisiana | 22109 | 11036 | 228 |
1483218 | 1483218 | 2021-07-04 | Terrebonne | Louisiana | 22109 | 11036 | 228 |
1479971 | 1479971 | 2021-07-03 | Terrebonne | Louisiana | 22109 | 11036 | 228 |
1476725 | 1476725 | 2021-07-02 | Terrebonne | Louisiana | 22109 | 11036 | 228 |
1473479 | 1473479 | 2021-07-01 | Terrebonne | Louisiana | 22109 | 10993 | 228 |
1470233 | 1470233 | 2021-06-30 | Terrebonne | Louisiana | 22109 | 10983 | 228 |
1466988 | 1466988 | 2021-06-29 | Terrebonne | Louisiana | 22109 | 10964 | 226 |
1463743 | 1463743 | 2021-06-28 | Terrebonne | Louisiana | 22109 | 10947 | 226 |
1460498 | 1460498 | 2021-06-27 | Terrebonne | Louisiana | 22109 | 10913 | 226 |
1457253 | 1457253 | 2021-06-26 | Terrebonne | Louisiana | 22109 | 10913 | 226 |
1454008 | 1454008 | 2021-06-25 | Terrebonne | Louisiana | 22109 | 10913 | 226 |
1450762 | 1450762 | 2021-06-24 | Terrebonne | Louisiana | 22109 | 10908 | 226 |
1447517 | 1447517 | 2021-06-23 | Terrebonne | Louisiana | 22109 | 10902 | 226 |
1444272 | 1444272 | 2021-06-22 | Terrebonne | Louisiana | 22109 | 10892 | 226 |
1441027 | 1441027 | 2021-06-21 | Terrebonne | Louisiana | 22109 | 10886 | 225 |
1437780 | 1437780 | 2021-06-20 | Terrebonne | Louisiana | 22109 | 10856 | 225 |
1434533 | 1434533 | 2021-06-19 | Terrebonne | Louisiana | 22109 | 10856 | 225 |
1431287 | 1431287 | 2021-06-18 | Terrebonne | Louisiana | 22109 | 10856 | 225 |
1428042 | 1428042 | 2021-06-17 | Terrebonne | Louisiana | 22109 | 10843 | 225 |
1424797 | 1424797 | 2021-06-16 | Terrebonne | Louisiana | 22109 | 10812 | 225 |
1421549 | 1421549 | 2021-06-15 | Terrebonne | Louisiana | 22109 | 10806 | 225 |
1418304 | 1418304 | 2021-06-14 | Terrebonne | Louisiana | 22109 | 10790 | 225 |
1415058 | 1415058 | 2021-06-13 | Terrebonne | Louisiana | 22109 | 10759 | 225 |
1411813 | 1411813 | 2021-06-12 | Terrebonne | Louisiana | 22109 | 10759 | 225 |
1408568 | 1408568 | 2021-06-11 | Terrebonne | Louisiana | 22109 | 10759 | 225 |
1405322 | 1405322 | 2021-06-10 | Terrebonne | Louisiana | 22109 | 10749 | 225 |
1402077 | 1402077 | 2021-06-09 | Terrebonne | Louisiana | 22109 | 10733 | 224 |
1398832 | 1398832 | 2021-06-08 | Terrebonne | Louisiana | 22109 | 10707 | 224 |
1395585 | 1395585 | 2021-06-07 | Terrebonne | Louisiana | 22109 | 10714 | 225 |
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);