ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lafourche" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717043 | 1717043 | 2021-09-14 | Lafourche | Louisiana | 22057 | 17051 | 269 |
1713797 | 1713797 | 2021-09-13 | Lafourche | Louisiana | 22057 | 17007 | 267 |
1710550 | 1710550 | 2021-09-12 | Lafourche | Louisiana | 22057 | 16933 | 266 |
1707303 | 1707303 | 2021-09-11 | Lafourche | Louisiana | 22057 | 16933 | 266 |
1704055 | 1704055 | 2021-09-10 | Lafourche | Louisiana | 22057 | 16933 | 266 |
1700805 | 1700805 | 2021-09-09 | Lafourche | Louisiana | 22057 | 16837 | 266 |
1697556 | 1697556 | 2021-09-08 | Lafourche | Louisiana | 22057 | 16714 | 263 |
1694308 | 1694308 | 2021-09-07 | Lafourche | Louisiana | 22057 | 16673 | 261 |
1691059 | 1691059 | 2021-09-06 | Lafourche | Louisiana | 22057 | 16616 | 258 |
1687809 | 1687809 | 2021-09-05 | Lafourche | Louisiana | 22057 | 16616 | 258 |
1684559 | 1684559 | 2021-09-04 | Lafourche | Louisiana | 22057 | 16616 | 258 |
1681308 | 1681308 | 2021-09-03 | Lafourche | Louisiana | 22057 | 16616 | 258 |
1678060 | 1678060 | 2021-09-02 | Lafourche | Louisiana | 22057 | 16603 | 258 |
1674813 | 1674813 | 2021-09-01 | Lafourche | Louisiana | 22057 | 16580 | 256 |
1671564 | 1671564 | 2021-08-31 | Lafourche | Louisiana | 22057 | 16391 | 251 |
1668317 | 1668317 | 2021-08-30 | Lafourche | Louisiana | 22057 | 16391 | 251 |
1665070 | 1665070 | 2021-08-29 | Lafourche | Louisiana | 22057 | 16391 | 251 |
1661822 | 1661822 | 2021-08-28 | Lafourche | Louisiana | 22057 | 16391 | 251 |
1658574 | 1658574 | 2021-08-27 | Lafourche | Louisiana | 22057 | 16391 | 251 |
1655326 | 1655326 | 2021-08-26 | Lafourche | Louisiana | 22057 | 16330 | 250 |
1652079 | 1652079 | 2021-08-25 | Lafourche | Louisiana | 22057 | 16137 | 248 |
1648830 | 1648830 | 2021-08-24 | Lafourche | Louisiana | 22057 | 15923 | 247 |
1645582 | 1645582 | 2021-08-23 | Lafourche | Louisiana | 22057 | 15869 | 244 |
1642333 | 1642333 | 2021-08-22 | Lafourche | Louisiana | 22057 | 15566 | 242 |
1639083 | 1639083 | 2021-08-21 | Lafourche | Louisiana | 22057 | 15566 | 242 |
1635833 | 1635833 | 2021-08-20 | Lafourche | Louisiana | 22057 | 15566 | 242 |
1632583 | 1632583 | 2021-08-19 | Lafourche | Louisiana | 22057 | 15342 | 242 |
1629336 | 1629336 | 2021-08-18 | Lafourche | Louisiana | 22057 | 15186 | 241 |
1626089 | 1626089 | 2021-08-17 | Lafourche | Louisiana | 22057 | 14998 | 237 |
1622842 | 1622842 | 2021-08-16 | Lafourche | Louisiana | 22057 | 14936 | 229 |
1619595 | 1619595 | 2021-08-15 | Lafourche | Louisiana | 22057 | 14605 | 229 |
1616347 | 1616347 | 2021-08-14 | Lafourche | Louisiana | 22057 | 14605 | 229 |
1613098 | 1613098 | 2021-08-13 | Lafourche | Louisiana | 22057 | 14605 | 229 |
1609850 | 1609850 | 2021-08-12 | Lafourche | Louisiana | 22057 | 14467 | 219 |
1606601 | 1606601 | 2021-08-11 | Lafourche | Louisiana | 22057 | 14258 | 216 |
1603352 | 1603352 | 2021-08-10 | Lafourche | Louisiana | 22057 | 14065 | 216 |
1600103 | 1600103 | 2021-08-09 | Lafourche | Louisiana | 22057 | 13914 | 215 |
1596855 | 1596855 | 2021-08-08 | Lafourche | Louisiana | 22057 | 13283 | 215 |
1593606 | 1593606 | 2021-08-07 | Lafourche | Louisiana | 22057 | 13283 | 215 |
1590357 | 1590357 | 2021-08-06 | Lafourche | Louisiana | 22057 | 13283 | 215 |
1587108 | 1587108 | 2021-08-05 | Lafourche | Louisiana | 22057 | 13125 | 213 |
1583858 | 1583858 | 2021-08-04 | Lafourche | Louisiana | 22057 | 12951 | 213 |
1580608 | 1580608 | 2021-08-03 | Lafourche | Louisiana | 22057 | 12781 | 211 |
1577359 | 1577359 | 2021-08-02 | Lafourche | Louisiana | 22057 | 12499 | 209 |
1574111 | 1574111 | 2021-08-01 | Lafourche | Louisiana | 22057 | 12232 | 209 |
1570863 | 1570863 | 2021-07-31 | Lafourche | Louisiana | 22057 | 12232 | 209 |
1567615 | 1567615 | 2021-07-30 | Lafourche | Louisiana | 22057 | 12232 | 209 |
1564367 | 1564367 | 2021-07-29 | Lafourche | Louisiana | 22057 | 12055 | 209 |
1561119 | 1561119 | 2021-07-28 | Lafourche | Louisiana | 22057 | 11881 | 209 |
1557872 | 1557872 | 2021-07-27 | Lafourche | Louisiana | 22057 | 11776 | 209 |
1554625 | 1554625 | 2021-07-26 | Lafourche | Louisiana | 22057 | 11537 | 209 |
1551378 | 1551378 | 2021-07-25 | Lafourche | Louisiana | 22057 | 11336 | 208 |
1548131 | 1548131 | 2021-07-24 | Lafourche | Louisiana | 22057 | 11336 | 208 |
1544884 | 1544884 | 2021-07-23 | Lafourche | Louisiana | 22057 | 11336 | 208 |
1541636 | 1541636 | 2021-07-22 | Lafourche | Louisiana | 22057 | 11253 | 207 |
1538389 | 1538389 | 2021-07-21 | Lafourche | Louisiana | 22057 | 11121 | 207 |
1535141 | 1535141 | 2021-07-20 | Lafourche | Louisiana | 22057 | 10911 | 207 |
1531894 | 1531894 | 2021-07-19 | Lafourche | Louisiana | 22057 | 10857 | 206 |
1528647 | 1528647 | 2021-07-18 | Lafourche | Louisiana | 22057 | 10705 | 205 |
1525400 | 1525400 | 2021-07-17 | Lafourche | Louisiana | 22057 | 10705 | 205 |
1522152 | 1522152 | 2021-07-16 | Lafourche | Louisiana | 22057 | 10705 | 205 |
1518904 | 1518904 | 2021-07-15 | Lafourche | Louisiana | 22057 | 10656 | 205 |
1515657 | 1515657 | 2021-07-14 | Lafourche | Louisiana | 22057 | 10606 | 205 |
1512411 | 1512411 | 2021-07-13 | Lafourche | Louisiana | 22057 | 10554 | 206 |
1509164 | 1509164 | 2021-07-12 | Lafourche | Louisiana | 22057 | 10472 | 206 |
1505918 | 1505918 | 2021-07-11 | Lafourche | Louisiana | 22057 | 10396 | 205 |
1502672 | 1502672 | 2021-07-10 | Lafourche | Louisiana | 22057 | 10396 | 205 |
1499426 | 1499426 | 2021-07-09 | Lafourche | Louisiana | 22057 | 10396 | 205 |
1496179 | 1496179 | 2021-07-08 | Lafourche | Louisiana | 22057 | 10371 | 205 |
1492933 | 1492933 | 2021-07-07 | Lafourche | Louisiana | 22057 | 10353 | 205 |
1489686 | 1489686 | 2021-07-06 | Lafourche | Louisiana | 22057 | 10321 | 205 |
1486439 | 1486439 | 2021-07-05 | Lafourche | Louisiana | 22057 | 10254 | 205 |
1483193 | 1483193 | 2021-07-04 | Lafourche | Louisiana | 22057 | 10254 | 205 |
1479946 | 1479946 | 2021-07-03 | Lafourche | Louisiana | 22057 | 10254 | 205 |
1476700 | 1476700 | 2021-07-02 | Lafourche | Louisiana | 22057 | 10254 | 205 |
1473454 | 1473454 | 2021-07-01 | Lafourche | Louisiana | 22057 | 10222 | 205 |
1470208 | 1470208 | 2021-06-30 | Lafourche | Louisiana | 22057 | 10211 | 205 |
1466963 | 1466963 | 2021-06-29 | Lafourche | Louisiana | 22057 | 10187 | 206 |
1463718 | 1463718 | 2021-06-28 | Lafourche | Louisiana | 22057 | 10169 | 206 |
1460473 | 1460473 | 2021-06-27 | Lafourche | Louisiana | 22057 | 10122 | 206 |
1457228 | 1457228 | 2021-06-26 | Lafourche | Louisiana | 22057 | 10122 | 206 |
1453983 | 1453983 | 2021-06-25 | Lafourche | Louisiana | 22057 | 10122 | 206 |
1450737 | 1450737 | 2021-06-24 | Lafourche | Louisiana | 22057 | 10113 | 206 |
1447492 | 1447492 | 2021-06-23 | Lafourche | Louisiana | 22057 | 10105 | 206 |
1444247 | 1444247 | 2021-06-22 | Lafourche | Louisiana | 22057 | 10078 | 206 |
1441002 | 1441002 | 2021-06-21 | Lafourche | Louisiana | 22057 | 10054 | 206 |
1437755 | 1437755 | 2021-06-20 | Lafourche | Louisiana | 22057 | 10022 | 205 |
1434508 | 1434508 | 2021-06-19 | Lafourche | Louisiana | 22057 | 10022 | 205 |
1431262 | 1431262 | 2021-06-18 | Lafourche | Louisiana | 22057 | 10022 | 205 |
1428017 | 1428017 | 2021-06-17 | Lafourche | Louisiana | 22057 | 10006 | 205 |
1424772 | 1424772 | 2021-06-16 | Lafourche | Louisiana | 22057 | 9991 | 205 |
1421524 | 1421524 | 2021-06-15 | Lafourche | Louisiana | 22057 | 9980 | 205 |
1418279 | 1418279 | 2021-06-14 | Lafourche | Louisiana | 22057 | 9959 | 205 |
1415033 | 1415033 | 2021-06-13 | Lafourche | Louisiana | 22057 | 9936 | 205 |
1411788 | 1411788 | 2021-06-12 | Lafourche | Louisiana | 22057 | 9936 | 205 |
1408543 | 1408543 | 2021-06-11 | Lafourche | Louisiana | 22057 | 9936 | 205 |
1405297 | 1405297 | 2021-06-10 | Lafourche | Louisiana | 22057 | 9928 | 205 |
1402052 | 1402052 | 2021-06-09 | Lafourche | Louisiana | 22057 | 9916 | 205 |
1398807 | 1398807 | 2021-06-08 | Lafourche | Louisiana | 22057 | 9918 | 205 |
1395560 | 1395560 | 2021-06-07 | Lafourche | Louisiana | 22057 | 9907 | 205 |
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);