ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
219 rows where deaths = 59 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Madison 38
- West Baton Rouge 22
- Jackson 17
- LaSalle 11
- St. Charles 10
- Washington 10
- Beauregard 8
- Calcasieu 8
- Grant 7
- Union 7
- Claiborne 6
- Webster 6
- Winn 6
- St. Landry 5
- West Carroll 5
- Lincoln 4
- Ouachita 4
- Sabine 4
- Unknown 4
- De Soto 3
- Lafourche 3
- Natchitoches 3
- St. Mary 3
- Allen 2
- Avoyelles 2
- Lafayette 2
- Livingston 2
- Morehouse 2
- St. Martin 2
- Acadia 1
- …
state 1
- Louisiana · 219 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500731 | 2500731 | 2022-05-13 | Madison | Louisiana | 22065 | 3264 | 59 |
2497473 | 2497473 | 2022-05-12 | Madison | Louisiana | 22065 | 3264 | 59 |
2494215 | 2494215 | 2022-05-11 | Madison | Louisiana | 22065 | 3262 | 59 |
2490957 | 2490957 | 2022-05-10 | Madison | Louisiana | 22065 | 3261 | 59 |
2487700 | 2487700 | 2022-05-09 | Madison | Louisiana | 22065 | 3260 | 59 |
2484442 | 2484442 | 2022-05-08 | Madison | Louisiana | 22065 | 3259 | 59 |
2481184 | 2481184 | 2022-05-07 | Madison | Louisiana | 22065 | 3259 | 59 |
2477926 | 2477926 | 2022-05-06 | Madison | Louisiana | 22065 | 3259 | 59 |
2474668 | 2474668 | 2022-05-05 | Madison | Louisiana | 22065 | 3259 | 59 |
2471411 | 2471411 | 2022-05-04 | Madison | Louisiana | 22065 | 3259 | 59 |
2468155 | 2468155 | 2022-05-03 | Madison | Louisiana | 22065 | 3258 | 59 |
2464900 | 2464900 | 2022-05-02 | Madison | Louisiana | 22065 | 3258 | 59 |
2461644 | 2461644 | 2022-05-01 | Madison | Louisiana | 22065 | 3257 | 59 |
2458388 | 2458388 | 2022-04-30 | Madison | Louisiana | 22065 | 3257 | 59 |
2455132 | 2455132 | 2022-04-29 | Madison | Louisiana | 22065 | 3257 | 59 |
2451876 | 2451876 | 2022-04-28 | Madison | Louisiana | 22065 | 3257 | 59 |
2448620 | 2448620 | 2022-04-27 | Madison | Louisiana | 22065 | 3257 | 59 |
2445364 | 2445364 | 2022-04-26 | Madison | Louisiana | 22065 | 3257 | 59 |
2442108 | 2442108 | 2022-04-25 | Madison | Louisiana | 22065 | 3257 | 59 |
2438847 | 2438847 | 2022-04-24 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2438852 | 2438852 | 2022-04-24 | Madison | Louisiana | 22065 | 3256 | 59 |
2435591 | 2435591 | 2022-04-23 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2435596 | 2435596 | 2022-04-23 | Madison | Louisiana | 22065 | 3256 | 59 |
2432335 | 2432335 | 2022-04-22 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2432340 | 2432340 | 2022-04-22 | Madison | Louisiana | 22065 | 3256 | 59 |
2429079 | 2429079 | 2022-04-21 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2429084 | 2429084 | 2022-04-21 | Madison | Louisiana | 22065 | 3256 | 59 |
2425823 | 2425823 | 2022-04-20 | LaSalle | Louisiana | 22059 | 4249 | 59 |
2425828 | 2425828 | 2022-04-20 | Madison | Louisiana | 22065 | 3256 | 59 |
2422567 | 2422567 | 2022-04-19 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2422572 | 2422572 | 2022-04-19 | Madison | Louisiana | 22065 | 3256 | 59 |
2419311 | 2419311 | 2022-04-18 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2419316 | 2419316 | 2022-04-18 | Madison | Louisiana | 22065 | 3256 | 59 |
2416055 | 2416055 | 2022-04-17 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2416060 | 2416060 | 2022-04-17 | Madison | Louisiana | 22065 | 3256 | 59 |
2412799 | 2412799 | 2022-04-16 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2412804 | 2412804 | 2022-04-16 | Madison | Louisiana | 22065 | 3256 | 59 |
2409543 | 2409543 | 2022-04-15 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2409548 | 2409548 | 2022-04-15 | Madison | Louisiana | 22065 | 3256 | 59 |
2406287 | 2406287 | 2022-04-14 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2406292 | 2406292 | 2022-04-14 | Madison | Louisiana | 22065 | 3256 | 59 |
2403036 | 2403036 | 2022-04-13 | Madison | Louisiana | 22065 | 3256 | 59 |
2399782 | 2399782 | 2022-04-12 | Madison | Louisiana | 22065 | 3256 | 59 |
2396526 | 2396526 | 2022-04-11 | Madison | Louisiana | 22065 | 3256 | 59 |
2393271 | 2393271 | 2022-04-10 | Madison | Louisiana | 22065 | 3256 | 59 |
2390015 | 2390015 | 2022-04-09 | Madison | Louisiana | 22065 | 3256 | 59 |
2386759 | 2386759 | 2022-04-08 | Madison | Louisiana | 22065 | 3256 | 59 |
2383504 | 2383504 | 2022-04-07 | Madison | Louisiana | 22065 | 3256 | 59 |
2380249 | 2380249 | 2022-04-06 | Madison | Louisiana | 22065 | 3255 | 59 |
2263179 | 2263179 | 2022-03-01 | West Carroll | Louisiana | 22123 | 3592 | 59 |
2259928 | 2259928 | 2022-02-28 | West Carroll | Louisiana | 22123 | 3592 | 59 |
2256677 | 2256677 | 2022-02-27 | West Carroll | Louisiana | 22123 | 3592 | 59 |
2253426 | 2253426 | 2022-02-26 | West Carroll | Louisiana | 22123 | 3592 | 59 |
2250175 | 2250175 | 2022-02-25 | West Carroll | Louisiana | 22123 | 3592 | 59 |
2217667 | 2217667 | 2022-02-15 | Winn | Louisiana | 22127 | 4338 | 59 |
2214416 | 2214416 | 2022-02-14 | Winn | Louisiana | 22127 | 4325 | 59 |
2211164 | 2211164 | 2022-02-13 | Winn | Louisiana | 22127 | 4300 | 59 |
2207911 | 2207911 | 2022-02-12 | Winn | Louisiana | 22127 | 4300 | 59 |
2204658 | 2204658 | 2022-02-11 | Winn | Louisiana | 22127 | 4300 | 59 |
2201405 | 2201405 | 2022-02-10 | Winn | Louisiana | 22127 | 4285 | 59 |
1769022 | 1769022 | 2021-09-30 | Jackson | Louisiana | 22049 | 2721 | 59 |
1765773 | 1765773 | 2021-09-29 | Jackson | Louisiana | 22049 | 2716 | 59 |
1762524 | 1762524 | 2021-09-28 | Jackson | Louisiana | 22049 | 2713 | 59 |
1759276 | 1759276 | 2021-09-27 | Jackson | Louisiana | 22049 | 2711 | 59 |
1756028 | 1756028 | 2021-09-26 | Jackson | Louisiana | 22049 | 2688 | 59 |
1752780 | 1752780 | 2021-09-25 | Jackson | Louisiana | 22049 | 2688 | 59 |
1749531 | 1749531 | 2021-09-24 | Jackson | Louisiana | 22049 | 2688 | 59 |
1746281 | 1746281 | 2021-09-23 | Jackson | Louisiana | 22049 | 2676 | 59 |
1743032 | 1743032 | 2021-09-22 | Jackson | Louisiana | 22049 | 2662 | 59 |
1739783 | 1739783 | 2021-09-21 | Jackson | Louisiana | 22049 | 2644 | 59 |
1736523 | 1736523 | 2021-09-20 | Claiborne | Louisiana | 22027 | 1947 | 59 |
1736534 | 1736534 | 2021-09-20 | Jackson | Louisiana | 22049 | 2637 | 59 |
1733273 | 1733273 | 2021-09-19 | Claiborne | Louisiana | 22027 | 1940 | 59 |
1733284 | 1733284 | 2021-09-19 | Jackson | Louisiana | 22049 | 2626 | 59 |
1730023 | 1730023 | 2021-09-18 | Claiborne | Louisiana | 22027 | 1940 | 59 |
1730034 | 1730034 | 2021-09-18 | Jackson | Louisiana | 22049 | 2626 | 59 |
1726773 | 1726773 | 2021-09-17 | Claiborne | Louisiana | 22027 | 1940 | 59 |
1726784 | 1726784 | 2021-09-17 | Jackson | Louisiana | 22049 | 2626 | 59 |
1723524 | 1723524 | 2021-09-16 | Claiborne | Louisiana | 22027 | 1934 | 59 |
1723535 | 1723535 | 2021-09-16 | Jackson | Louisiana | 22049 | 2620 | 59 |
1720275 | 1720275 | 2021-09-15 | Claiborne | Louisiana | 22027 | 1932 | 59 |
1720286 | 1720286 | 2021-09-15 | Jackson | Louisiana | 22049 | 2607 | 59 |
1717038 | 1717038 | 2021-09-14 | Jackson | Louisiana | 22049 | 2603 | 59 |
1655343 | 1655343 | 2021-08-26 | St. James | Louisiana | 22093 | 3027 | 59 |
1626081 | 1626081 | 2021-08-17 | Grant | Louisiana | 22043 | 2948 | 59 |
1622834 | 1622834 | 2021-08-16 | Grant | Louisiana | 22043 | 2937 | 59 |
1619587 | 1619587 | 2021-08-15 | Grant | Louisiana | 22043 | 2831 | 59 |
1616339 | 1616339 | 2021-08-14 | Grant | Louisiana | 22043 | 2831 | 59 |
1613090 | 1613090 | 2021-08-13 | Grant | Louisiana | 22043 | 2831 | 59 |
1609842 | 1609842 | 2021-08-12 | Grant | Louisiana | 22043 | 2801 | 59 |
1606593 | 1606593 | 2021-08-11 | Grant | Louisiana | 22043 | 2767 | 59 |
1587122 | 1587122 | 2021-08-05 | St. Bernard | Louisiana | 22087 | 5119 | 59 |
1304697 | 1304697 | 2021-05-10 | West Baton Rouge | Louisiana | 22121 | 2872 | 59 |
1301450 | 1301450 | 2021-05-09 | West Baton Rouge | Louisiana | 22121 | 2860 | 59 |
1298203 | 1298203 | 2021-05-08 | West Baton Rouge | Louisiana | 22121 | 2860 | 59 |
1294957 | 1294957 | 2021-05-07 | West Baton Rouge | Louisiana | 22121 | 2860 | 59 |
1291711 | 1291711 | 2021-05-06 | West Baton Rouge | Louisiana | 22121 | 2853 | 59 |
1288465 | 1288465 | 2021-05-05 | West Baton Rouge | Louisiana | 22121 | 2857 | 59 |
1285219 | 1285219 | 2021-05-04 | West Baton Rouge | Louisiana | 22121 | 2854 | 59 |
1281972 | 1281972 | 2021-05-03 | West Baton Rouge | Louisiana | 22121 | 2844 | 59 |
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);