ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where cases = 466 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
county 9
- Catahoula 2
- Grant 2
- Natchitoches 2
- West Feliciana 2
- Cameron 1
- LaSalle 1
- Lafayette 1
- Red River 1
- Terrebonne 1
state 1
- Louisiana · 13 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
960514 | 960514 | 2021-01-24 | Cameron | Louisiana | 22023 | 466 | 4 |
700901 | 700901 | 2020-11-05 | Catahoula | Louisiana | 22025 | 466 | 15 |
700929 | 700929 | 2020-11-05 | Red River | Louisiana | 22081 | 466 | 24 |
694414 | 694414 | 2020-11-03 | Catahoula | Louisiana | 22025 | 466 | 15 |
632786 | 632786 | 2020-10-15 | LaSalle | Louisiana | 22059 | 466 | 10 |
525854 | 525854 | 2020-09-12 | Grant | Louisiana | 22043 | 466 | 30 |
522618 | 522618 | 2020-09-11 | Grant | Louisiana | 22043 | 466 | 30 |
458006 | 458006 | 2020-08-22 | West Feliciana | Louisiana | 22125 | 466 | 18 |
454778 | 454778 | 2020-08-21 | West Feliciana | Louisiana | 22125 | 466 | 18 |
345373 | 345373 | 2020-07-18 | Natchitoches | Louisiana | 22069 | 466 | 14 |
342173 | 342173 | 2020-07-17 | Natchitoches | Louisiana | 22069 | 466 | 14 |
113571 | 113571 | 2020-05-04 | Terrebonne | Louisiana | 22109 | 466 | 33 |
110668 | 110668 | 2020-05-03 | Lafayette | Louisiana | 22055 | 466 | 20 |
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);