ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8 rows where deaths = 562 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Orleans 5
- Calcasieu 1
- Ouachita 1
- Tangipahoa 1
state 1
- Louisiana · 8 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2191631 | 2191631 | 2022-02-07 | Tangipahoa | Louisiana | 22105 | 33785 | 562 |
1765785 | 1765785 | 2021-09-29 | Ouachita | Louisiana | 22073 | 30432 | 562 |
1739768 | 1739768 | 2021-09-21 | Calcasieu | Louisiana | 22019 | 32917 | 562 |
422491 | 422491 | 2020-08-11 | Orleans | Louisiana | 22071 | 10805 | 562 |
419269 | 419269 | 2020-08-10 | Orleans | Louisiana | 22071 | 10768 | 562 |
416048 | 416048 | 2020-08-09 | Orleans | Louisiana | 22071 | 10735 | 562 |
412828 | 412828 | 2020-08-08 | Orleans | Louisiana | 22071 | 10637 | 562 |
409608 | 409608 | 2020-08-07 | Orleans | Louisiana | 22071 | 10637 | 562 |
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);