ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 188 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 14
county 14
- Tensas 6
- Avoyelles 2
- Allen 1
- Bossier 1
- Catahoula 1
- East Baton Rouge 1
- Franklin 1
- Grant 1
- Morehouse 1
- Natchitoches 1
- Pointe Coupee 1
- Richland 1
- Washington 1
- West Feliciana 1
state 1
- Louisiana · 20 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
713915 | 713915 | 2020-11-09 | Tensas | Louisiana | 22107 | 188 | 3 |
710671 | 710671 | 2020-11-08 | Tensas | Louisiana | 22107 | 188 | 3 |
707427 | 707427 | 2020-11-07 | Tensas | Louisiana | 22107 | 188 | 3 |
704184 | 704184 | 2020-11-06 | Tensas | Louisiana | 22107 | 188 | 3 |
700942 | 700942 | 2020-11-05 | Tensas | Louisiana | 22107 | 188 | 2 |
697698 | 697698 | 2020-11-04 | Tensas | Louisiana | 22107 | 188 | 2 |
361371 | 361371 | 2020-07-23 | Grant | Louisiana | 22043 | 188 | 3 |
288217 | 288217 | 2020-06-30 | Richland | Louisiana | 22083 | 188 | 4 |
281893 | 281893 | 2020-06-28 | Catahoula | Louisiana | 22025 | 188 | 3 |
263079 | 263079 | 2020-06-22 | Morehouse | Louisiana | 22067 | 188 | 7 |
244335 | 244335 | 2020-06-16 | Avoyelles | Louisiana | 22009 | 188 | 9 |
241224 | 241224 | 2020-06-15 | Avoyelles | Louisiana | 22009 | 188 | 9 |
231933 | 231933 | 2020-06-12 | Natchitoches | Louisiana | 22069 | 188 | 13 |
219503 | 219503 | 2020-06-08 | Allen | Louisiana | 22003 | 188 | 10 |
179604 | 179604 | 2020-05-26 | Pointe Coupee | Louisiana | 22077 | 188 | 22 |
155353 | 155353 | 2020-05-18 | West Feliciana | Louisiana | 22125 | 188 | 8 |
128320 | 128320 | 2020-05-09 | Franklin | Louisiana | 22041 | 188 | 4 |
68422 | 68422 | 2020-04-18 | Washington | Louisiana | 22117 | 188 | 11 |
54755 | 54755 | 2020-04-13 | Bossier | Louisiana | 22015 | 188 | 10 |
20415 | 20415 | 2020-03-30 | East Baton Rouge | Louisiana | 22033 | 188 | 9 |
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);