ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where cases = 383 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 11
- Madison 2
- Assumption 1
- Catahoula 1
- East Feliciana 1
- Franklin 1
- Jackson 1
- Lincoln 1
- St. Bernard 1
- Union 1
- Unknown 1
- Washington 1
state 1
- Louisiana · 12 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
778819 | 778819 | 2020-11-29 | Unknown | Louisiana | 383 | 0 | |
496738 | 496738 | 2020-09-03 | Catahoula | Louisiana | 22025 | 383 | 6 |
425701 | 425701 | 2020-08-12 | Jackson | Louisiana | 22049 | 383 | 18 |
338961 | 338961 | 2020-07-16 | East Feliciana | Louisiana | 22037 | 383 | 34 |
316674 | 316674 | 2020-07-09 | Lincoln | Louisiana | 22061 | 383 | 19 |
307135 | 307135 | 2020-07-06 | Assumption | Louisiana | 22007 | 383 | 15 |
300833 | 300833 | 2020-07-04 | Madison | Louisiana | 22065 | 383 | 2 |
297671 | 297671 | 2020-07-03 | Madison | Louisiana | 22065 | 383 | 2 |
228850 | 228850 | 2020-06-11 | Union | Louisiana | 22111 | 383 | 20 |
210258 | 210258 | 2020-06-05 | Franklin | Louisiana | 22041 | 383 | 12 |
164422 | 164422 | 2020-05-21 | Washington | Louisiana | 22117 | 383 | 36 |
60197 | 60197 | 2020-04-15 | St. Bernard | Louisiana | 22087 | 383 | 10 |
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);