ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-09-26" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
570286 | 570286 | 2020-09-26 | Adams | Colorado | 8001 | 9011 | 225 |
570287 | 570287 | 2020-09-26 | Alamosa | Colorado | 8003 | 242 | 9 |
570288 | 570288 | 2020-09-26 | Arapahoe | Colorado | 8005 | 9341 | 372 |
570289 | 570289 | 2020-09-26 | Archuleta | Colorado | 8007 | 54 | 0 |
570290 | 570290 | 2020-09-26 | Baca | Colorado | 8009 | 18 | 0 |
570291 | 570291 | 2020-09-26 | Bent | Colorado | 8011 | 11 | 0 |
570292 | 570292 | 2020-09-26 | Boulder | Colorado | 8013 | 4319 | 79 |
570293 | 570293 | 2020-09-26 | Broomfield | Colorado | 8014 | 636 | 33 |
570294 | 570294 | 2020-09-26 | Chaffee | Colorado | 8015 | 332 | 19 |
570295 | 570295 | 2020-09-26 | Cheyenne | Colorado | 8017 | 14 | 0 |
570296 | 570296 | 2020-09-26 | Clear Creek | Colorado | 8019 | 37 | 1 |
570297 | 570297 | 2020-09-26 | Conejos | Colorado | 8021 | 33 | 0 |
570298 | 570298 | 2020-09-26 | Costilla | Colorado | 8023 | 32 | 1 |
570299 | 570299 | 2020-09-26 | Crowley | Colorado | 8025 | 73 | 1 |
570300 | 570300 | 2020-09-26 | Custer | Colorado | 8027 | 17 | 0 |
570301 | 570301 | 2020-09-26 | Delta | Colorado | 8029 | 188 | 3 |
570302 | 570302 | 2020-09-26 | Denver | Colorado | 8031 | 13011 | 440 |
570303 | 570303 | 2020-09-26 | Dolores | Colorado | 8033 | 3 | 0 |
570304 | 570304 | 2020-09-26 | Douglas | Colorado | 8035 | 2686 | 60 |
570305 | 570305 | 2020-09-26 | Eagle | Colorado | 8037 | 1250 | 10 |
570306 | 570306 | 2020-09-26 | El Paso | Colorado | 8041 | 6931 | 173 |
570307 | 570307 | 2020-09-26 | Elbert | Colorado | 8039 | 157 | 3 |
570308 | 570308 | 2020-09-26 | Fremont | Colorado | 8043 | 175 | 1 |
570309 | 570309 | 2020-09-26 | Garfield | Colorado | 8045 | 944 | 5 |
570310 | 570310 | 2020-09-26 | Gilpin | Colorado | 8047 | 18 | 0 |
570311 | 570311 | 2020-09-26 | Grand | Colorado | 8049 | 74 | 1 |
570312 | 570312 | 2020-09-26 | Gunnison | Colorado | 8051 | 296 | 7 |
570313 | 570313 | 2020-09-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
570314 | 570314 | 2020-09-26 | Huerfano | Colorado | 8055 | 23 | 1 |
570315 | 570315 | 2020-09-26 | Jackson | Colorado | 8057 | 9 | 0 |
570316 | 570316 | 2020-09-26 | Jefferson | Colorado | 8059 | 5654 | 248 |
570317 | 570317 | 2020-09-26 | Kiowa | Colorado | 8061 | 1 | 0 |
570318 | 570318 | 2020-09-26 | Kit Carson | Colorado | 8063 | 79 | 3 |
570319 | 570319 | 2020-09-26 | La Plata | Colorado | 8067 | 260 | 2 |
570320 | 570320 | 2020-09-26 | Lake | Colorado | 8065 | 94 | 0 |
570321 | 570321 | 2020-09-26 | Larimer | Colorado | 8069 | 2515 | 52 |
570322 | 570322 | 2020-09-26 | Las Animas | Colorado | 8071 | 24 | 0 |
570323 | 570323 | 2020-09-26 | Lincoln | Colorado | 8073 | 11 | 0 |
570324 | 570324 | 2020-09-26 | Logan | Colorado | 8075 | 864 | 6 |
570325 | 570325 | 2020-09-26 | Mesa | Colorado | 8077 | 607 | 7 |
570326 | 570326 | 2020-09-26 | Mineral | Colorado | 8079 | 20 | 0 |
570327 | 570327 | 2020-09-26 | Moffat | Colorado | 8081 | 41 | 1 |
570328 | 570328 | 2020-09-26 | Montezuma | Colorado | 8083 | 138 | 5 |
570329 | 570329 | 2020-09-26 | Montrose | Colorado | 8085 | 380 | 13 |
570330 | 570330 | 2020-09-26 | Morgan | Colorado | 8087 | 746 | 48 |
570331 | 570331 | 2020-09-26 | Otero | Colorado | 8089 | 96 | 6 |
570332 | 570332 | 2020-09-26 | Ouray | Colorado | 8091 | 25 | 1 |
570333 | 570333 | 2020-09-26 | Park | Colorado | 8093 | 56 | 1 |
570334 | 570334 | 2020-09-26 | Phillips | Colorado | 8095 | 34 | 0 |
570335 | 570335 | 2020-09-26 | Pitkin | Colorado | 8097 | 223 | 2 |
570336 | 570336 | 2020-09-26 | Prowers | Colorado | 8099 | 94 | 0 |
570337 | 570337 | 2020-09-26 | Pueblo | Colorado | 8101 | 1079 | 37 |
570338 | 570338 | 2020-09-26 | Rio Blanco | Colorado | 8103 | 26 | 0 |
570339 | 570339 | 2020-09-26 | Rio Grande | Colorado | 8105 | 96 | 2 |
570340 | 570340 | 2020-09-26 | Routt | Colorado | 8107 | 153 | 8 |
570341 | 570341 | 2020-09-26 | Saguache | Colorado | 8109 | 111 | 2 |
570342 | 570342 | 2020-09-26 | San Juan | Colorado | 8111 | 6 | 0 |
570343 | 570343 | 2020-09-26 | San Miguel | Colorado | 8113 | 97 | 0 |
570344 | 570344 | 2020-09-26 | Sedgwick | Colorado | 8115 | 15 | 1 |
570345 | 570345 | 2020-09-26 | Summit | Colorado | 8117 | 458 | 4 |
570346 | 570346 | 2020-09-26 | Teller | Colorado | 8119 | 176 | 4 |
570347 | 570347 | 2020-09-26 | Washington | Colorado | 8121 | 61 | 0 |
570348 | 570348 | 2020-09-26 | Weld | Colorado | 8123 | 4682 | 149 |
570349 | 570349 | 2020-09-26 | Yuma | Colorado | 8125 | 113 | 1 |
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);