ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2020-10-21 and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
651358 | 651358 | 2020-10-21 | Adams | Colorado | 8001 | 12414 | 249 |
651359 | 651359 | 2020-10-21 | Alamosa | Colorado | 8003 | 292 | 9 |
651360 | 651360 | 2020-10-21 | Arapahoe | Colorado | 8005 | 11621 | 394 |
651361 | 651361 | 2020-10-21 | Archuleta | Colorado | 8007 | 61 | 0 |
651362 | 651362 | 2020-10-21 | Baca | Colorado | 8009 | 25 | 0 |
651363 | 651363 | 2020-10-21 | Bent | Colorado | 8011 | 12 | 0 |
651364 | 651364 | 2020-10-21 | Boulder | Colorado | 8013 | 5189 | 85 |
651365 | 651365 | 2020-10-21 | Broomfield | Colorado | 8014 | 846 | 41 |
651366 | 651366 | 2020-10-21 | Chaffee | Colorado | 8015 | 374 | 20 |
651367 | 651367 | 2020-10-21 | Cheyenne | Colorado | 8017 | 14 | 0 |
651368 | 651368 | 2020-10-21 | Clear Creek | Colorado | 8019 | 63 | 1 |
651369 | 651369 | 2020-10-21 | Conejos | Colorado | 8021 | 61 | 0 |
651370 | 651370 | 2020-10-21 | Costilla | Colorado | 8023 | 35 | 1 |
651371 | 651371 | 2020-10-21 | Crowley | Colorado | 8025 | 83 | 1 |
651372 | 651372 | 2020-10-21 | Custer | Colorado | 8027 | 19 | 0 |
651373 | 651373 | 2020-10-21 | Delta | Colorado | 8029 | 196 | 4 |
651374 | 651374 | 2020-10-21 | Denver | Colorado | 8031 | 16455 | 450 |
651375 | 651375 | 2020-10-21 | Dolores | Colorado | 8033 | 3 | 0 |
651376 | 651376 | 2020-10-21 | Douglas | Colorado | 8035 | 3510 | 64 |
651377 | 651377 | 2020-10-21 | Eagle | Colorado | 8037 | 1366 | 10 |
651379 | 651379 | 2020-10-21 | Elbert | Colorado | 8039 | 190 | 3 |
651378 | 651378 | 2020-10-21 | El Paso | Colorado | 8041 | 9130 | 194 |
651380 | 651380 | 2020-10-21 | Fremont | Colorado | 8043 | 549 | 1 |
651381 | 651381 | 2020-10-21 | Garfield | Colorado | 8045 | 1087 | 5 |
651382 | 651382 | 2020-10-21 | Gilpin | Colorado | 8047 | 26 | 0 |
651383 | 651383 | 2020-10-21 | Grand | Colorado | 8049 | 141 | 1 |
651384 | 651384 | 2020-10-21 | Gunnison | Colorado | 8051 | 304 | 7 |
651385 | 651385 | 2020-10-21 | Hinsdale | Colorado | 8053 | 3 | 0 |
651386 | 651386 | 2020-10-21 | Huerfano | Colorado | 8055 | 29 | 2 |
651387 | 651387 | 2020-10-21 | Jackson | Colorado | 8057 | 9 | 0 |
651388 | 651388 | 2020-10-21 | Jefferson | Colorado | 8059 | 7492 | 301 |
651389 | 651389 | 2020-10-21 | Kiowa | Colorado | 8061 | 3 | 0 |
651390 | 651390 | 2020-10-21 | Kit Carson | Colorado | 8063 | 109 | 3 |
651392 | 651392 | 2020-10-21 | Lake | Colorado | 8065 | 122 | 0 |
651391 | 651391 | 2020-10-21 | La Plata | Colorado | 8067 | 331 | 2 |
651393 | 651393 | 2020-10-21 | Larimer | Colorado | 8069 | 3640 | 55 |
651394 | 651394 | 2020-10-21 | Las Animas | Colorado | 8071 | 65 | 1 |
651395 | 651395 | 2020-10-21 | Lincoln | Colorado | 8073 | 24 | 0 |
651396 | 651396 | 2020-10-21 | Logan | Colorado | 8075 | 1118 | 10 |
651397 | 651397 | 2020-10-21 | Mesa | Colorado | 8077 | 1091 | 8 |
651398 | 651398 | 2020-10-21 | Mineral | Colorado | 8079 | 21 | 0 |
651399 | 651399 | 2020-10-21 | Moffat | Colorado | 8081 | 56 | 1 |
651400 | 651400 | 2020-10-21 | Montezuma | Colorado | 8083 | 185 | 5 |
651401 | 651401 | 2020-10-21 | Montrose | Colorado | 8085 | 428 | 13 |
651402 | 651402 | 2020-10-21 | Morgan | Colorado | 8087 | 827 | 48 |
651403 | 651403 | 2020-10-21 | Otero | Colorado | 8089 | 119 | 6 |
651404 | 651404 | 2020-10-21 | Ouray | Colorado | 8091 | 34 | 2 |
651405 | 651405 | 2020-10-21 | Park | Colorado | 8093 | 85 | 1 |
651406 | 651406 | 2020-10-21 | Phillips | Colorado | 8095 | 40 | 0 |
651407 | 651407 | 2020-10-21 | Pitkin | Colorado | 8097 | 261 | 2 |
651408 | 651408 | 2020-10-21 | Prowers | Colorado | 8099 | 137 | 0 |
651409 | 651409 | 2020-10-21 | Pueblo | Colorado | 8101 | 1697 | 40 |
651410 | 651410 | 2020-10-21 | Rio Blanco | Colorado | 8103 | 26 | 0 |
651411 | 651411 | 2020-10-21 | Rio Grande | Colorado | 8105 | 115 | 2 |
651412 | 651412 | 2020-10-21 | Routt | Colorado | 8107 | 196 | 8 |
651413 | 651413 | 2020-10-21 | Saguache | Colorado | 8109 | 124 | 2 |
651414 | 651414 | 2020-10-21 | San Juan | Colorado | 8111 | 7 | 0 |
651415 | 651415 | 2020-10-21 | San Miguel | Colorado | 8113 | 100 | 0 |
651416 | 651416 | 2020-10-21 | Sedgwick | Colorado | 8115 | 34 | 1 |
651417 | 651417 | 2020-10-21 | Summit | Colorado | 8117 | 605 | 4 |
651418 | 651418 | 2020-10-21 | Teller | Colorado | 8119 | 200 | 4 |
651419 | 651419 | 2020-10-21 | Washington | Colorado | 8121 | 82 | 0 |
651420 | 651420 | 2020-10-21 | Weld | Colorado | 8123 | 5563 | 158 |
651421 | 651421 | 2020-10-21 | Yuma | Colorado | 8125 | 201 | 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);