ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where date = "2020-03-20" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5262 | 5262 | 2020-03-20 | Adams | Colorado | 8001 | 12 | 0 |
5263 | 5263 | 2020-03-20 | Arapahoe | Colorado | 8005 | 29 | 0 |
5264 | 5264 | 2020-03-20 | Boulder | Colorado | 8013 | 24 | 0 |
5265 | 5265 | 2020-03-20 | Broomfield | Colorado | 8014 | 1 | 0 |
5266 | 5266 | 2020-03-20 | Clear Creek | Colorado | 8019 | 2 | 0 |
5267 | 5267 | 2020-03-20 | Crowley | Colorado | 8025 | 1 | 1 |
5268 | 5268 | 2020-03-20 | Denver | Colorado | 8031 | 79 | 0 |
5269 | 5269 | 2020-03-20 | Douglas | Colorado | 8035 | 17 | 0 |
5270 | 5270 | 2020-03-20 | Eagle | Colorado | 8037 | 61 | 0 |
5271 | 5271 | 2020-03-20 | El Paso | Colorado | 8041 | 27 | 3 |
5272 | 5272 | 2020-03-20 | Garfield | Colorado | 8045 | 4 | 0 |
5273 | 5273 | 2020-03-20 | Grand | Colorado | 8049 | 2 | 0 |
5274 | 5274 | 2020-03-20 | Gunnison | Colorado | 8051 | 13 | 0 |
5275 | 5275 | 2020-03-20 | Jefferson | Colorado | 8059 | 37 | 0 |
5276 | 5276 | 2020-03-20 | Larimer | Colorado | 8069 | 7 | 0 |
5277 | 5277 | 2020-03-20 | Mesa | Colorado | 8077 | 1 | 0 |
5278 | 5278 | 2020-03-20 | Morgan | Colorado | 8087 | 2 | 0 |
5279 | 5279 | 2020-03-20 | Park | Colorado | 8093 | 1 | 0 |
5280 | 5280 | 2020-03-20 | Pitkin | Colorado | 8097 | 15 | 0 |
5281 | 5281 | 2020-03-20 | Pueblo | Colorado | 8101 | 3 | 0 |
5282 | 5282 | 2020-03-20 | Routt | Colorado | 8107 | 2 | 0 |
5283 | 5283 | 2020-03-20 | San Miguel | Colorado | 8113 | 1 | 0 |
5284 | 5284 | 2020-03-20 | Summit | Colorado | 8117 | 7 | 0 |
5285 | 5285 | 2020-03-20 | Weld | Colorado | 8123 | 15 | 1 |
5286 | 5286 | 2020-03-20 | Yuma | Colorado | 8125 | 1 | 0 |
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);