ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where deaths = 140 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 23
county 23
- Franklin 19
- Evangeline 18
- East Feliciana 15
- Lafayette 11
- Allen 10
- Beauregard 10
- St. Mary 7
- Avoyelles 6
- Washington 6
- St. John the Baptist 5
- St. Martin 5
- Iberia 4
- St. Charles 4
- Terrebonne 4
- Natchitoches 3
- St. Landry 3
- Lafourche 2
- Caddo 1
- Iberville 1
- Jefferson Davis 1
- Lincoln 1
- Livingston 1
- Vernon 1
state 1
- Louisiana · 138 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497442 | 2497442 | 2022-05-12 | Allen | Louisiana | 22003 | 7878 | 140 |
2494184 | 2494184 | 2022-05-11 | Allen | Louisiana | 22003 | 7877 | 140 |
2490926 | 2490926 | 2022-05-10 | Allen | Louisiana | 22003 | 7877 | 140 |
2487669 | 2487669 | 2022-05-09 | Allen | Louisiana | 22003 | 7877 | 140 |
2484411 | 2484411 | 2022-05-08 | Allen | Louisiana | 22003 | 7876 | 140 |
2481153 | 2481153 | 2022-05-07 | Allen | Louisiana | 22003 | 7876 | 140 |
2477895 | 2477895 | 2022-05-06 | Allen | Louisiana | 22003 | 7876 | 140 |
2474637 | 2474637 | 2022-05-05 | Allen | Louisiana | 22003 | 7876 | 140 |
2471380 | 2471380 | 2022-05-04 | Allen | Louisiana | 22003 | 7876 | 140 |
2468124 | 2468124 | 2022-05-03 | Allen | Louisiana | 22003 | 7876 | 140 |
2311929 | 2311929 | 2022-03-16 | Lincoln | Louisiana | 22061 | 12196 | 140 |
2302148 | 2302148 | 2022-03-13 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2298896 | 2298896 | 2022-03-12 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2295644 | 2295644 | 2022-03-11 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2292392 | 2292392 | 2022-03-10 | Beauregard | Louisiana | 22011 | 9230 | 140 |
2289140 | 2289140 | 2022-03-09 | Beauregard | Louisiana | 22011 | 9230 | 140 |
2285889 | 2285889 | 2022-03-08 | Beauregard | Louisiana | 22011 | 9228 | 140 |
2282637 | 2282637 | 2022-03-07 | Beauregard | Louisiana | 22011 | 9226 | 140 |
2279384 | 2279384 | 2022-03-06 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2276131 | 2276131 | 2022-03-05 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2272878 | 2272878 | 2022-03-04 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2237153 | 2237153 | 2022-02-21 | St. Charles | Louisiana | 22089 | 13700 | 140 |
2233902 | 2233902 | 2022-02-20 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2230651 | 2230651 | 2022-02-19 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2227400 | 2227400 | 2022-02-18 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2178593 | 2178593 | 2022-02-03 | Iberville | Louisiana | 22047 | 8676 | 140 |
2172090 | 2172090 | 2022-02-01 | Jefferson Davis | Louisiana | 22053 | 6614 | 140 |
2084274 | 2084274 | 2022-01-05 | Natchitoches | Louisiana | 22069 | 7477 | 140 |
2081022 | 2081022 | 2022-01-04 | Natchitoches | Louisiana | 22069 | 7453 | 140 |
2077770 | 2077770 | 2022-01-03 | Natchitoches | Louisiana | 22069 | 7418 | 140 |
1986744 | 1986744 | 2021-12-06 | Franklin | Louisiana | 22041 | 4803 | 140 |
1983494 | 1983494 | 2021-12-05 | Franklin | Louisiana | 22041 | 4799 | 140 |
1980244 | 1980244 | 2021-12-04 | Franklin | Louisiana | 22041 | 4799 | 140 |
1976994 | 1976994 | 2021-12-03 | Franklin | Louisiana | 22041 | 4799 | 140 |
1973745 | 1973745 | 2021-12-02 | Franklin | Louisiana | 22041 | 4796 | 140 |
1970495 | 1970495 | 2021-12-01 | Franklin | Louisiana | 22041 | 4792 | 140 |
1967245 | 1967245 | 2021-11-30 | Franklin | Louisiana | 22041 | 4780 | 140 |
1963993 | 1963993 | 2021-11-29 | Franklin | Louisiana | 22041 | 4776 | 140 |
1960742 | 1960742 | 2021-11-28 | Franklin | Louisiana | 22041 | 4768 | 140 |
1957491 | 1957491 | 2021-11-27 | Franklin | Louisiana | 22041 | 4768 | 140 |
1954240 | 1954240 | 2021-11-26 | Franklin | Louisiana | 22041 | 4768 | 140 |
1950989 | 1950989 | 2021-11-25 | Franklin | Louisiana | 22041 | 4768 | 140 |
1947738 | 1947738 | 2021-11-24 | Franklin | Louisiana | 22041 | 4768 | 140 |
1944487 | 1944487 | 2021-11-23 | Franklin | Louisiana | 22041 | 4764 | 140 |
1941237 | 1941237 | 2021-11-22 | Franklin | Louisiana | 22041 | 4758 | 140 |
1937987 | 1937987 | 2021-11-21 | Franklin | Louisiana | 22041 | 4750 | 140 |
1934737 | 1934737 | 2021-11-20 | Franklin | Louisiana | 22041 | 4750 | 140 |
1931486 | 1931486 | 2021-11-19 | Franklin | Louisiana | 22041 | 4750 | 140 |
1928235 | 1928235 | 2021-11-18 | Franklin | Louisiana | 22041 | 4745 | 140 |
1895737 | 1895737 | 2021-11-08 | Evangeline | Louisiana | 22039 | 5862 | 140 |
1892487 | 1892487 | 2021-11-07 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1889237 | 1889237 | 2021-11-06 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1885987 | 1885987 | 2021-11-05 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1882738 | 1882738 | 2021-11-04 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1879489 | 1879489 | 2021-11-03 | Evangeline | Louisiana | 22039 | 5855 | 140 |
1876240 | 1876240 | 2021-11-02 | Evangeline | Louisiana | 22039 | 5853 | 140 |
1872991 | 1872991 | 2021-11-01 | Evangeline | Louisiana | 22039 | 5853 | 140 |
1869742 | 1869742 | 2021-10-31 | Evangeline | Louisiana | 22039 | 5845 | 140 |
1866493 | 1866493 | 2021-10-30 | Evangeline | Louisiana | 22039 | 5845 | 140 |
1863244 | 1863244 | 2021-10-29 | Evangeline | Louisiana | 22039 | 5845 | 140 |
1859995 | 1859995 | 2021-10-28 | Evangeline | Louisiana | 22039 | 5843 | 140 |
1856746 | 1856746 | 2021-10-27 | Evangeline | Louisiana | 22039 | 5836 | 140 |
1853497 | 1853497 | 2021-10-26 | Evangeline | Louisiana | 22039 | 5828 | 140 |
1850248 | 1850248 | 2021-10-25 | Evangeline | Louisiana | 22039 | 5811 | 140 |
1846998 | 1846998 | 2021-10-24 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1843748 | 1843748 | 2021-10-23 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1840498 | 1840498 | 2021-10-22 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1785264 | 1785264 | 2021-10-05 | East Feliciana | Louisiana | 22037 | 4449 | 140 |
1782015 | 1782015 | 2021-10-04 | East Feliciana | Louisiana | 22037 | 4447 | 140 |
1778765 | 1778765 | 2021-10-03 | East Feliciana | Louisiana | 22037 | 4439 | 140 |
1775515 | 1775515 | 2021-10-02 | East Feliciana | Louisiana | 22037 | 4439 | 140 |
1772265 | 1772265 | 2021-10-01 | East Feliciana | Louisiana | 22037 | 4439 | 140 |
1769016 | 1769016 | 2021-09-30 | East Feliciana | Louisiana | 22037 | 4438 | 140 |
1765767 | 1765767 | 2021-09-29 | East Feliciana | Louisiana | 22037 | 4435 | 140 |
1762518 | 1762518 | 2021-09-28 | East Feliciana | Louisiana | 22037 | 4434 | 140 |
1759270 | 1759270 | 2021-09-27 | East Feliciana | Louisiana | 22037 | 4429 | 140 |
1756022 | 1756022 | 2021-09-26 | East Feliciana | Louisiana | 22037 | 4419 | 140 |
1752774 | 1752774 | 2021-09-25 | East Feliciana | Louisiana | 22037 | 4419 | 140 |
1749525 | 1749525 | 2021-09-24 | East Feliciana | Louisiana | 22037 | 4419 | 140 |
1746275 | 1746275 | 2021-09-23 | East Feliciana | Louisiana | 22037 | 4418 | 140 |
1743026 | 1743026 | 2021-09-22 | East Feliciana | Louisiana | 22037 | 4407 | 140 |
1739777 | 1739777 | 2021-09-21 | East Feliciana | Louisiana | 22037 | 4394 | 140 |
1713825 | 1713825 | 2021-09-13 | Vernon | Louisiana | 22115 | 5531 | 140 |
1691079 | 1691079 | 2021-09-06 | St. Martin | Louisiana | 22099 | 7783 | 140 |
1687829 | 1687829 | 2021-09-05 | St. Martin | Louisiana | 22099 | 7783 | 140 |
1684579 | 1684579 | 2021-09-04 | St. Martin | Louisiana | 22099 | 7783 | 140 |
1681328 | 1681328 | 2021-09-03 | St. Martin | Louisiana | 22099 | 7783 | 140 |
1678080 | 1678080 | 2021-09-02 | St. Martin | Louisiana | 22099 | 7761 | 140 |
1671539 | 1671539 | 2021-08-31 | Avoyelles | Louisiana | 22009 | 6247 | 140 |
1668292 | 1668292 | 2021-08-30 | Avoyelles | Louisiana | 22009 | 6247 | 140 |
1665045 | 1665045 | 2021-08-29 | Avoyelles | Louisiana | 22009 | 6247 | 140 |
1661797 | 1661797 | 2021-08-28 | Avoyelles | Louisiana | 22009 | 6247 | 140 |
1658549 | 1658549 | 2021-08-27 | Avoyelles | Louisiana | 22009 | 6247 | 140 |
1655301 | 1655301 | 2021-08-26 | Avoyelles | Louisiana | 22009 | 6219 | 140 |
1580638 | 1580638 | 2021-08-03 | Washington | Louisiana | 22117 | 5387 | 140 |
1577389 | 1577389 | 2021-08-02 | Washington | Louisiana | 22117 | 5349 | 140 |
1574141 | 1574141 | 2021-08-01 | Washington | Louisiana | 22117 | 5186 | 140 |
1570893 | 1570893 | 2021-07-31 | Washington | Louisiana | 22117 | 5186 | 140 |
1567645 | 1567645 | 2021-07-30 | Washington | Louisiana | 22117 | 5186 | 140 |
1564397 | 1564397 | 2021-07-29 | Washington | Louisiana | 22117 | 5142 | 140 |
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);