ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where deaths = 77 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Union 68
- Grant 31
- Beauregard 29
- St. James 25
- De Soto 23
- St. John the Baptist 15
- St. Mary 14
- West Baton Rouge 14
- Natchitoches 13
- Evangeline 8
- Claiborne 7
- Richland 7
- Iberville 6
- Jefferson Davis 6
- Lafourche 6
- Morehouse 6
- Concordia 5
- St. Bernard 5
- Allen 4
- Bienville 4
- Acadia 3
- Pointe Coupee 3
- East Feliciana 2
- Lincoln 2
- Vermilion 2
- Washington 2
- Webster 2
- Ascension 1
- Avoyelles 1
- Franklin 1
- …
state 1
- Louisiana · 318 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500745 | 2500745 | 2022-05-13 | St. James | Louisiana | 22093 | 5805 | 77 |
2497487 | 2497487 | 2022-05-12 | St. James | Louisiana | 22093 | 5804 | 77 |
2494229 | 2494229 | 2022-05-11 | St. James | Louisiana | 22093 | 5801 | 77 |
2490938 | 2490938 | 2022-05-10 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2490971 | 2490971 | 2022-05-10 | St. James | Louisiana | 22093 | 5799 | 77 |
2487681 | 2487681 | 2022-05-09 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2487714 | 2487714 | 2022-05-09 | St. James | Louisiana | 22093 | 5795 | 77 |
2484423 | 2484423 | 2022-05-08 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2484456 | 2484456 | 2022-05-08 | St. James | Louisiana | 22093 | 5791 | 77 |
2481165 | 2481165 | 2022-05-07 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2481198 | 2481198 | 2022-05-07 | St. James | Louisiana | 22093 | 5791 | 77 |
2477907 | 2477907 | 2022-05-06 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2477940 | 2477940 | 2022-05-06 | St. James | Louisiana | 22093 | 5791 | 77 |
2474649 | 2474649 | 2022-05-05 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2474682 | 2474682 | 2022-05-05 | St. James | Louisiana | 22093 | 5788 | 77 |
2471392 | 2471392 | 2022-05-04 | Claiborne | Louisiana | 22027 | 3280 | 77 |
2471425 | 2471425 | 2022-05-04 | St. James | Louisiana | 22093 | 5786 | 77 |
2468169 | 2468169 | 2022-05-03 | St. James | Louisiana | 22093 | 5786 | 77 |
2464914 | 2464914 | 2022-05-02 | St. James | Louisiana | 22093 | 5785 | 77 |
2461658 | 2461658 | 2022-05-01 | St. James | Louisiana | 22093 | 5785 | 77 |
2458402 | 2458402 | 2022-04-30 | St. James | Louisiana | 22093 | 5785 | 77 |
2455146 | 2455146 | 2022-04-29 | St. James | Louisiana | 22093 | 5785 | 77 |
2451890 | 2451890 | 2022-04-28 | St. James | Louisiana | 22093 | 5784 | 77 |
2448634 | 2448634 | 2022-04-27 | St. James | Louisiana | 22093 | 5780 | 77 |
2445378 | 2445378 | 2022-04-26 | St. James | Louisiana | 22093 | 5778 | 77 |
2442122 | 2442122 | 2022-04-25 | St. James | Louisiana | 22093 | 5777 | 77 |
2438866 | 2438866 | 2022-04-24 | St. James | Louisiana | 22093 | 5776 | 77 |
2435610 | 2435610 | 2022-04-23 | St. James | Louisiana | 22093 | 5776 | 77 |
2432354 | 2432354 | 2022-04-22 | St. James | Louisiana | 22093 | 5776 | 77 |
2429098 | 2429098 | 2022-04-21 | St. James | Louisiana | 22093 | 5776 | 77 |
2425842 | 2425842 | 2022-04-20 | St. James | Louisiana | 22093 | 5776 | 77 |
2422586 | 2422586 | 2022-04-19 | St. James | Louisiana | 22093 | 5776 | 77 |
1941278 | 1941278 | 2021-11-22 | West Baton Rouge | Louisiana | 22121 | 4427 | 77 |
1938028 | 1938028 | 2021-11-21 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1934778 | 1934778 | 2021-11-20 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1931527 | 1931527 | 2021-11-19 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1928276 | 1928276 | 2021-11-18 | West Baton Rouge | Louisiana | 22121 | 4419 | 77 |
1925026 | 1925026 | 2021-11-17 | West Baton Rouge | Louisiana | 22121 | 4418 | 77 |
1921777 | 1921777 | 2021-11-16 | West Baton Rouge | Louisiana | 22121 | 4414 | 77 |
1918527 | 1918527 | 2021-11-15 | West Baton Rouge | Louisiana | 22121 | 4411 | 77 |
1915277 | 1915277 | 2021-11-14 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1912027 | 1912027 | 2021-11-13 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1908778 | 1908778 | 2021-11-12 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1905529 | 1905529 | 2021-11-11 | West Baton Rouge | Louisiana | 22121 | 4407 | 77 |
1902279 | 1902279 | 2021-11-10 | West Baton Rouge | Louisiana | 22121 | 4407 | 77 |
1899029 | 1899029 | 2021-11-09 | West Baton Rouge | Louisiana | 22121 | 4403 | 77 |
1882740 | 1882740 | 2021-11-04 | Grant | Louisiana | 22043 | 3835 | 77 |
1879491 | 1879491 | 2021-11-03 | Grant | Louisiana | 22043 | 3829 | 77 |
1876242 | 1876242 | 2021-11-02 | Grant | Louisiana | 22043 | 3824 | 77 |
1872993 | 1872993 | 2021-11-01 | Grant | Louisiana | 22043 | 3822 | 77 |
1869744 | 1869744 | 2021-10-31 | Grant | Louisiana | 22043 | 3821 | 77 |
1866495 | 1866495 | 2021-10-30 | Grant | Louisiana | 22043 | 3821 | 77 |
1863246 | 1863246 | 2021-10-29 | Grant | Louisiana | 22043 | 3821 | 77 |
1859997 | 1859997 | 2021-10-28 | Grant | Louisiana | 22043 | 3819 | 77 |
1856748 | 1856748 | 2021-10-27 | Grant | Louisiana | 22043 | 3819 | 77 |
1853499 | 1853499 | 2021-10-26 | Grant | Louisiana | 22043 | 3815 | 77 |
1850250 | 1850250 | 2021-10-25 | Grant | Louisiana | 22043 | 3815 | 77 |
1847000 | 1847000 | 2021-10-24 | Grant | Louisiana | 22043 | 3814 | 77 |
1843750 | 1843750 | 2021-10-23 | Grant | Louisiana | 22043 | 3814 | 77 |
1840500 | 1840500 | 2021-10-22 | Grant | Louisiana | 22043 | 3814 | 77 |
1837251 | 1837251 | 2021-10-21 | Grant | Louisiana | 22043 | 3810 | 77 |
1834002 | 1834002 | 2021-10-20 | Grant | Louisiana | 22043 | 3808 | 77 |
1834022 | 1834022 | 2021-10-20 | Richland | Louisiana | 22083 | 4283 | 77 |
1830753 | 1830753 | 2021-10-19 | Grant | Louisiana | 22043 | 3804 | 77 |
1830773 | 1830773 | 2021-10-19 | Richland | Louisiana | 22083 | 4278 | 77 |
1827497 | 1827497 | 2021-10-18 | Concordia | Louisiana | 22029 | 3185 | 77 |
1827504 | 1827504 | 2021-10-18 | Grant | Louisiana | 22043 | 3800 | 77 |
1827524 | 1827524 | 2021-10-18 | Richland | Louisiana | 22083 | 4277 | 77 |
1824248 | 1824248 | 2021-10-17 | Concordia | Louisiana | 22029 | 3185 | 77 |
1824255 | 1824255 | 2021-10-17 | Grant | Louisiana | 22043 | 3794 | 77 |
1824275 | 1824275 | 2021-10-17 | Richland | Louisiana | 22083 | 4269 | 77 |
1820999 | 1820999 | 2021-10-16 | Concordia | Louisiana | 22029 | 3185 | 77 |
1821006 | 1821006 | 2021-10-16 | Grant | Louisiana | 22043 | 3794 | 77 |
1821026 | 1821026 | 2021-10-16 | Richland | Louisiana | 22083 | 4269 | 77 |
1817750 | 1817750 | 2021-10-15 | Concordia | Louisiana | 22029 | 3185 | 77 |
1817757 | 1817757 | 2021-10-15 | Grant | Louisiana | 22043 | 3794 | 77 |
1817777 | 1817777 | 2021-10-15 | Richland | Louisiana | 22083 | 4269 | 77 |
1814502 | 1814502 | 2021-10-14 | Concordia | Louisiana | 22029 | 3182 | 77 |
1814509 | 1814509 | 2021-10-14 | Grant | Louisiana | 22043 | 3792 | 77 |
1814529 | 1814529 | 2021-10-14 | Richland | Louisiana | 22083 | 4266 | 77 |
1811260 | 1811260 | 2021-10-13 | Grant | Louisiana | 22043 | 3785 | 77 |
1808011 | 1808011 | 2021-10-12 | Grant | Louisiana | 22043 | 3782 | 77 |
1804760 | 1804760 | 2021-10-11 | Grant | Louisiana | 22043 | 3776 | 77 |
1801511 | 1801511 | 2021-10-10 | Grant | Louisiana | 22043 | 3769 | 77 |
1798262 | 1798262 | 2021-10-09 | Grant | Louisiana | 22043 | 3769 | 77 |
1795013 | 1795013 | 2021-10-08 | Grant | Louisiana | 22043 | 3769 | 77 |
1791765 | 1791765 | 2021-10-07 | Grant | Louisiana | 22043 | 3760 | 77 |
1788516 | 1788516 | 2021-10-06 | Grant | Louisiana | 22043 | 3752 | 77 |
1785267 | 1785267 | 2021-10-05 | Grant | Louisiana | 22043 | 3747 | 77 |
1671578 | 1671578 | 2021-08-31 | St. Bernard | Louisiana | 22087 | 6351 | 77 |
1668331 | 1668331 | 2021-08-30 | St. Bernard | Louisiana | 22087 | 6351 | 77 |
1665084 | 1665084 | 2021-08-29 | St. Bernard | Louisiana | 22087 | 6351 | 77 |
1661836 | 1661836 | 2021-08-28 | St. Bernard | Louisiana | 22087 | 6351 | 77 |
1658588 | 1658588 | 2021-08-27 | St. Bernard | Louisiana | 22087 | 6351 | 77 |
1642342 | 1642342 | 2021-08-22 | Pointe Coupee | Louisiana | 22077 | 3441 | 77 |
1639092 | 1639092 | 2021-08-21 | Pointe Coupee | Louisiana | 22077 | 3441 | 77 |
1635842 | 1635842 | 2021-08-20 | Pointe Coupee | Louisiana | 22077 | 3441 | 77 |
1427993 | 1427993 | 2021-06-17 | Beauregard | Louisiana | 22011 | 3295 | 77 |
1424748 | 1424748 | 2021-06-16 | Beauregard | Louisiana | 22011 | 3292 | 77 |
1421500 | 1421500 | 2021-06-15 | Beauregard | Louisiana | 22011 | 3287 | 77 |
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);