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-11-07 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
706499 | 706499 | 2020-11-07 | Adams | Colorado | 8001 | 17894 | 273 |
706500 | 706500 | 2020-11-07 | Alamosa | Colorado | 8003 | 389 | 9 |
706501 | 706501 | 2020-11-07 | Arapahoe | Colorado | 8005 | 16062 | 405 |
706502 | 706502 | 2020-11-07 | Archuleta | Colorado | 8007 | 73 | 0 |
706503 | 706503 | 2020-11-07 | Baca | Colorado | 8009 | 39 | 0 |
706504 | 706504 | 2020-11-07 | Bent | Colorado | 8011 | 24 | 0 |
706505 | 706505 | 2020-11-07 | Boulder | Colorado | 8013 | 6801 | 97 |
706506 | 706506 | 2020-11-07 | Broomfield | Colorado | 8014 | 1242 | 43 |
706507 | 706507 | 2020-11-07 | Chaffee | Colorado | 8015 | 461 | 20 |
706508 | 706508 | 2020-11-07 | Cheyenne | Colorado | 8017 | 16 | 0 |
706509 | 706509 | 2020-11-07 | Clear Creek | Colorado | 8019 | 100 | 1 |
706510 | 706510 | 2020-11-07 | Conejos | Colorado | 8021 | 102 | 1 |
706511 | 706511 | 2020-11-07 | Costilla | Colorado | 8023 | 47 | 1 |
706512 | 706512 | 2020-11-07 | Crowley | Colorado | 8025 | 202 | 1 |
706513 | 706513 | 2020-11-07 | Custer | Colorado | 8027 | 32 | 0 |
706514 | 706514 | 2020-11-07 | Delta | Colorado | 8029 | 261 | 3 |
706515 | 706515 | 2020-11-07 | Denver | Colorado | 8031 | 22908 | 468 |
706516 | 706516 | 2020-11-07 | Dolores | Colorado | 8033 | 3 | 0 |
706517 | 706517 | 2020-11-07 | Douglas | Colorado | 8035 | 5394 | 69 |
706518 | 706518 | 2020-11-07 | Eagle | Colorado | 8037 | 1659 | 10 |
706519 | 706519 | 2020-11-07 | El Paso | Colorado | 8041 | 13954 | 210 |
706520 | 706520 | 2020-11-07 | Elbert | Colorado | 8039 | 292 | 3 |
706521 | 706521 | 2020-11-07 | Fremont | Colorado | 8043 | 1084 | 2 |
706522 | 706522 | 2020-11-07 | Garfield | Colorado | 8045 | 1383 | 5 |
706523 | 706523 | 2020-11-07 | Gilpin | Colorado | 8047 | 44 | 0 |
706524 | 706524 | 2020-11-07 | Grand | Colorado | 8049 | 172 | 1 |
706525 | 706525 | 2020-11-07 | Gunnison | Colorado | 8051 | 344 | 7 |
706526 | 706526 | 2020-11-07 | Hinsdale | Colorado | 8053 | 4 | 0 |
706527 | 706527 | 2020-11-07 | Huerfano | Colorado | 8055 | 49 | 2 |
706528 | 706528 | 2020-11-07 | Jackson | Colorado | 8057 | 9 | 0 |
706529 | 706529 | 2020-11-07 | Jefferson | Colorado | 8059 | 11268 | 345 |
706530 | 706530 | 2020-11-07 | Kiowa | Colorado | 8061 | 6 | 0 |
706531 | 706531 | 2020-11-07 | Kit Carson | Colorado | 8063 | 191 | 3 |
706532 | 706532 | 2020-11-07 | La Plata | Colorado | 8067 | 454 | 2 |
706533 | 706533 | 2020-11-07 | Lake | Colorado | 8065 | 162 | 0 |
706534 | 706534 | 2020-11-07 | Larimer | Colorado | 8069 | 5294 | 60 |
706535 | 706535 | 2020-11-07 | Las Animas | Colorado | 8071 | 96 | 0 |
706536 | 706536 | 2020-11-07 | Lincoln | Colorado | 8073 | 27 | 0 |
706537 | 706537 | 2020-11-07 | Logan | Colorado | 8075 | 1503 | 14 |
706538 | 706538 | 2020-11-07 | Mesa | Colorado | 8077 | 2238 | 26 |
706539 | 706539 | 2020-11-07 | Mineral | Colorado | 8079 | 21 | 0 |
706540 | 706540 | 2020-11-07 | Moffat | Colorado | 8081 | 96 | 1 |
706541 | 706541 | 2020-11-07 | Montezuma | Colorado | 8083 | 287 | 5 |
706542 | 706542 | 2020-11-07 | Montrose | Colorado | 8085 | 533 | 14 |
706543 | 706543 | 2020-11-07 | Morgan | Colorado | 8087 | 1033 | 50 |
706544 | 706544 | 2020-11-07 | Otero | Colorado | 8089 | 218 | 7 |
706545 | 706545 | 2020-11-07 | Ouray | Colorado | 8091 | 52 | 2 |
706546 | 706546 | 2020-11-07 | Park | Colorado | 8093 | 122 | 1 |
706547 | 706547 | 2020-11-07 | Phillips | Colorado | 8095 | 92 | 1 |
706548 | 706548 | 2020-11-07 | Pitkin | Colorado | 8097 | 323 | 2 |
706549 | 706549 | 2020-11-07 | Prowers | Colorado | 8099 | 251 | 11 |
706550 | 706550 | 2020-11-07 | Pueblo | Colorado | 8101 | 3081 | 54 |
706551 | 706551 | 2020-11-07 | Rio Blanco | Colorado | 8103 | 36 | 0 |
706552 | 706552 | 2020-11-07 | Rio Grande | Colorado | 8105 | 143 | 3 |
706553 | 706553 | 2020-11-07 | Routt | Colorado | 8107 | 278 | 9 |
706554 | 706554 | 2020-11-07 | Saguache | Colorado | 8109 | 165 | 2 |
706555 | 706555 | 2020-11-07 | San Juan | Colorado | 8111 | 12 | 0 |
706556 | 706556 | 2020-11-07 | San Miguel | Colorado | 8113 | 116 | 0 |
706557 | 706557 | 2020-11-07 | Sedgwick | Colorado | 8115 | 59 | 1 |
706558 | 706558 | 2020-11-07 | Summit | Colorado | 8117 | 937 | 4 |
706559 | 706559 | 2020-11-07 | Teller | Colorado | 8119 | 311 | 4 |
706560 | 706560 | 2020-11-07 | Washington | Colorado | 8121 | 126 | 1 |
706561 | 706561 | 2020-11-07 | Weld | Colorado | 8123 | 7790 | 163 |
706562 | 706562 | 2020-11-07 | Yuma | Colorado | 8125 | 246 | 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);