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-05 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 |
---|---|---|---|---|---|---|---|
599457 | 599457 | 2020-10-05 | Adams | Colorado | 8001 | 9943 | 231 |
599458 | 599458 | 2020-10-05 | Alamosa | Colorado | 8003 | 252 | 9 |
599459 | 599459 | 2020-10-05 | Arapahoe | Colorado | 8005 | 9935 | 374 |
599460 | 599460 | 2020-10-05 | Archuleta | Colorado | 8007 | 54 | 0 |
599461 | 599461 | 2020-10-05 | Baca | Colorado | 8009 | 18 | 0 |
599462 | 599462 | 2020-10-05 | Bent | Colorado | 8011 | 11 | 0 |
599463 | 599463 | 2020-10-05 | Boulder | Colorado | 8013 | 4658 | 81 |
599464 | 599464 | 2020-10-05 | Broomfield | Colorado | 8014 | 695 | 34 |
599465 | 599465 | 2020-10-05 | Chaffee | Colorado | 8015 | 337 | 20 |
599466 | 599466 | 2020-10-05 | Cheyenne | Colorado | 8017 | 14 | 0 |
599467 | 599467 | 2020-10-05 | Clear Creek | Colorado | 8019 | 47 | 1 |
599468 | 599468 | 2020-10-05 | Conejos | Colorado | 8021 | 36 | 0 |
599469 | 599469 | 2020-10-05 | Costilla | Colorado | 8023 | 33 | 1 |
599470 | 599470 | 2020-10-05 | Crowley | Colorado | 8025 | 74 | 1 |
599471 | 599471 | 2020-10-05 | Custer | Colorado | 8027 | 18 | 0 |
599472 | 599472 | 2020-10-05 | Delta | Colorado | 8029 | 191 | 3 |
599473 | 599473 | 2020-10-05 | Denver | Colorado | 8031 | 13956 | 447 |
599474 | 599474 | 2020-10-05 | Dolores | Colorado | 8033 | 3 | 0 |
599475 | 599475 | 2020-10-05 | Douglas | Colorado | 8035 | 2947 | 61 |
599476 | 599476 | 2020-10-05 | Eagle | Colorado | 8037 | 1275 | 10 |
599477 | 599477 | 2020-10-05 | El Paso | Colorado | 8041 | 7265 | 179 |
599478 | 599478 | 2020-10-05 | Elbert | Colorado | 8039 | 168 | 3 |
599479 | 599479 | 2020-10-05 | Fremont | Colorado | 8043 | 185 | 1 |
599480 | 599480 | 2020-10-05 | Garfield | Colorado | 8045 | 972 | 5 |
599481 | 599481 | 2020-10-05 | Gilpin | Colorado | 8047 | 19 | 0 |
599482 | 599482 | 2020-10-05 | Grand | Colorado | 8049 | 96 | 1 |
599483 | 599483 | 2020-10-05 | Gunnison | Colorado | 8051 | 296 | 7 |
599484 | 599484 | 2020-10-05 | Hinsdale | Colorado | 8053 | 3 | 0 |
599485 | 599485 | 2020-10-05 | Huerfano | Colorado | 8055 | 25 | 1 |
599486 | 599486 | 2020-10-05 | Jackson | Colorado | 8057 | 9 | 0 |
599487 | 599487 | 2020-10-05 | Jefferson | Colorado | 8059 | 6095 | 255 |
599488 | 599488 | 2020-10-05 | Kiowa | Colorado | 8061 | 1 | 0 |
599489 | 599489 | 2020-10-05 | Kit Carson | Colorado | 8063 | 81 | 3 |
599490 | 599490 | 2020-10-05 | La Plata | Colorado | 8067 | 268 | 2 |
599491 | 599491 | 2020-10-05 | Lake | Colorado | 8065 | 99 | 0 |
599492 | 599492 | 2020-10-05 | Larimer | Colorado | 8069 | 2775 | 55 |
599493 | 599493 | 2020-10-05 | Las Animas | Colorado | 8071 | 25 | 0 |
599494 | 599494 | 2020-10-05 | Lincoln | Colorado | 8073 | 20 | 0 |
599495 | 599495 | 2020-10-05 | Logan | Colorado | 8075 | 943 | 6 |
599496 | 599496 | 2020-10-05 | Mesa | Colorado | 8077 | 712 | 7 |
599497 | 599497 | 2020-10-05 | Mineral | Colorado | 8079 | 20 | 0 |
599498 | 599498 | 2020-10-05 | Moffat | Colorado | 8081 | 44 | 1 |
599499 | 599499 | 2020-10-05 | Montezuma | Colorado | 8083 | 147 | 5 |
599500 | 599500 | 2020-10-05 | Montrose | Colorado | 8085 | 388 | 13 |
599501 | 599501 | 2020-10-05 | Morgan | Colorado | 8087 | 763 | 48 |
599502 | 599502 | 2020-10-05 | Otero | Colorado | 8089 | 107 | 6 |
599503 | 599503 | 2020-10-05 | Ouray | Colorado | 8091 | 28 | 1 |
599504 | 599504 | 2020-10-05 | Park | Colorado | 8093 | 59 | 1 |
599505 | 599505 | 2020-10-05 | Phillips | Colorado | 8095 | 33 | 0 |
599506 | 599506 | 2020-10-05 | Pitkin | Colorado | 8097 | 227 | 2 |
599507 | 599507 | 2020-10-05 | Prowers | Colorado | 8099 | 95 | 0 |
599508 | 599508 | 2020-10-05 | Pueblo | Colorado | 8101 | 1213 | 37 |
599509 | 599509 | 2020-10-05 | Rio Blanco | Colorado | 8103 | 25 | 0 |
599510 | 599510 | 2020-10-05 | Rio Grande | Colorado | 8105 | 99 | 2 |
599511 | 599511 | 2020-10-05 | Routt | Colorado | 8107 | 163 | 8 |
599512 | 599512 | 2020-10-05 | Saguache | Colorado | 8109 | 112 | 2 |
599513 | 599513 | 2020-10-05 | San Juan | Colorado | 8111 | 6 | 0 |
599514 | 599514 | 2020-10-05 | San Miguel | Colorado | 8113 | 95 | 0 |
599515 | 599515 | 2020-10-05 | Sedgwick | Colorado | 8115 | 15 | 1 |
599516 | 599516 | 2020-10-05 | Summit | Colorado | 8117 | 489 | 4 |
599517 | 599517 | 2020-10-05 | Teller | Colorado | 8119 | 178 | 4 |
599518 | 599518 | 2020-10-05 | Washington | Colorado | 8121 | 68 | 0 |
599519 | 599519 | 2020-10-05 | Weld | Colorado | 8123 | 4962 | 151 |
599520 | 599520 | 2020-10-05 | Yuma | Colorado | 8125 | 139 | 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);