ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 310 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Bossier 20
- Lafourche 6
- Tangipahoa 3
- Caddo 2
- Calcasieu 2
- East Baton Rouge 1
- Lafayette 1
- St. Tammany 1
state 1
- Louisiana · 36 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1869752 | 1869752 | 2021-10-31 | Lafourche | Louisiana | 22057 | 17887 | 310 |
1866503 | 1866503 | 2021-10-30 | Lafourche | Louisiana | 22057 | 17887 | 310 |
1863254 | 1863254 | 2021-10-29 | Lafourche | Louisiana | 22057 | 17887 | 310 |
1860005 | 1860005 | 2021-10-28 | Lafourche | Louisiana | 22057 | 17884 | 310 |
1856756 | 1856756 | 2021-10-27 | Lafourche | Louisiana | 22057 | 17871 | 310 |
1853507 | 1853507 | 2021-10-26 | Lafourche | Louisiana | 22057 | 17843 | 310 |
1577358 | 1577358 | 2021-08-02 | Lafayette | Louisiana | 22055 | 28250 | 310 |
1505896 | 1505896 | 2021-07-11 | Bossier | Louisiana | 22015 | 14610 | 310 |
1505941 | 1505941 | 2021-07-11 | Tangipahoa | Louisiana | 22105 | 13518 | 310 |
1502650 | 1502650 | 2021-07-10 | Bossier | Louisiana | 22015 | 14610 | 310 |
1502695 | 1502695 | 2021-07-10 | Tangipahoa | Louisiana | 22105 | 13518 | 310 |
1499404 | 1499404 | 2021-07-09 | Bossier | Louisiana | 22015 | 14610 | 310 |
1499449 | 1499449 | 2021-07-09 | Tangipahoa | Louisiana | 22105 | 13518 | 310 |
1496157 | 1496157 | 2021-07-08 | Bossier | Louisiana | 22015 | 14578 | 310 |
1492911 | 1492911 | 2021-07-07 | Bossier | Louisiana | 22015 | 14569 | 310 |
1489664 | 1489664 | 2021-07-06 | Bossier | Louisiana | 22015 | 14544 | 310 |
1486417 | 1486417 | 2021-07-05 | Bossier | Louisiana | 22015 | 14488 | 310 |
1483171 | 1483171 | 2021-07-04 | Bossier | Louisiana | 22015 | 14488 | 310 |
1479924 | 1479924 | 2021-07-03 | Bossier | Louisiana | 22015 | 14488 | 310 |
1476678 | 1476678 | 2021-07-02 | Bossier | Louisiana | 22015 | 14488 | 310 |
1470186 | 1470186 | 2021-06-30 | Bossier | Louisiana | 22015 | 14478 | 310 |
1466941 | 1466941 | 2021-06-29 | Bossier | Louisiana | 22015 | 14464 | 310 |
1463696 | 1463696 | 2021-06-28 | Bossier | Louisiana | 22015 | 14438 | 310 |
1460451 | 1460451 | 2021-06-27 | Bossier | Louisiana | 22015 | 14409 | 310 |
1457206 | 1457206 | 2021-06-26 | Bossier | Louisiana | 22015 | 14409 | 310 |
1453961 | 1453961 | 2021-06-25 | Bossier | Louisiana | 22015 | 14409 | 310 |
1450715 | 1450715 | 2021-06-24 | Bossier | Louisiana | 22015 | 14407 | 310 |
1447470 | 1447470 | 2021-06-23 | Bossier | Louisiana | 22015 | 14403 | 310 |
1444225 | 1444225 | 2021-06-22 | Bossier | Louisiana | 22015 | 14400 | 310 |
1440980 | 1440980 | 2021-06-21 | Bossier | Louisiana | 22015 | 14388 | 310 |
947530 | 947530 | 2021-01-20 | Calcasieu | Louisiana | 22019 | 16456 | 310 |
944283 | 944283 | 2021-01-19 | Calcasieu | Louisiana | 22019 | 16266 | 310 |
833987 | 833987 | 2020-12-16 | St. Tammany | Louisiana | 22103 | 12904 | 310 |
464409 | 464409 | 2020-08-24 | Caddo | Louisiana | 22017 | 7180 | 310 |
461178 | 461178 | 2020-08-23 | Caddo | Louisiana | 22017 | 7156 | 310 |
374202 | 374202 | 2020-07-27 | East Baton Rouge | Louisiana | 22033 | 9985 | 310 |
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);