ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where deaths = 278 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 7
- Ascension 3
- Calcasieu 3
- Terrebonne 3
- Bossier 2
- Tangipahoa 2
- East Baton Rouge 1
- Lafayette 1
state 1
- Louisiana · 15 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2220856 | 2220856 | 2022-02-16 | Ascension | Louisiana | 22005 | 34446 | 278 |
2217605 | 2217605 | 2022-02-15 | Ascension | Louisiana | 22005 | 34432 | 278 |
2201343 | 2201343 | 2022-02-10 | Ascension | Louisiana | 22005 | 34183 | 278 |
1710575 | 1710575 | 2021-09-12 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1707328 | 1707328 | 2021-09-11 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1704080 | 1704080 | 2021-09-10 | Terrebonne | Louisiana | 22109 | 18379 | 278 |
1311156 | 1311156 | 2021-05-12 | Lafayette | Louisiana | 22055 | 23623 | 278 |
1129336 | 1129336 | 2021-03-17 | Tangipahoa | Louisiana | 22105 | 12183 | 278 |
1126090 | 1126090 | 2021-03-16 | Tangipahoa | Louisiana | 22105 | 12172 | 278 |
1122799 | 1122799 | 2021-03-15 | Bossier | Louisiana | 22015 | 13151 | 278 |
1119552 | 1119552 | 2021-03-14 | Bossier | Louisiana | 22015 | 13138 | 278 |
866397 | 866397 | 2020-12-26 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
863152 | 863152 | 2020-12-25 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
859907 | 859907 | 2020-12-24 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
323014 | 323014 | 2020-07-11 | East Baton Rouge | Louisiana | 22033 | 6989 | 278 |
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);