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-12-26 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
865512 | 865512 | 2020-12-26 | Adams | Colorado | 8001 | 39094 | 505 |
865513 | 865513 | 2020-12-26 | Alamosa | Colorado | 8003 | 907 | 22 |
865514 | 865514 | 2020-12-26 | Arapahoe | Colorado | 8005 | 37348 | 568 |
865515 | 865515 | 2020-12-26 | Archuleta | Colorado | 8007 | 463 | 0 |
865516 | 865516 | 2020-12-26 | Baca | Colorado | 8009 | 170 | 1 |
865517 | 865517 | 2020-12-26 | Bent | Colorado | 8011 | 1025 | 13 |
865518 | 865518 | 2020-12-26 | Boulder | Colorado | 8013 | 14299 | 174 |
865519 | 865519 | 2020-12-26 | Broomfield | Colorado | 8014 | 2711 | 63 |
865520 | 865520 | 2020-12-26 | Chaffee | Colorado | 8015 | 998 | 20 |
865521 | 865521 | 2020-12-26 | Cheyenne | Colorado | 8017 | 87 | 4 |
865522 | 865522 | 2020-12-26 | Clear Creek | Colorado | 8019 | 263 | 2 |
865523 | 865523 | 2020-12-26 | Conejos | Colorado | 8021 | 301 | 3 |
865524 | 865524 | 2020-12-26 | Costilla | Colorado | 8023 | 157 | 2 |
865525 | 865525 | 2020-12-26 | Crowley | Colorado | 8025 | 1630 | 12 |
865526 | 865526 | 2020-12-26 | Custer | Colorado | 8027 | 146 | 0 |
865527 | 865527 | 2020-12-26 | Delta | Colorado | 8029 | 1478 | 21 |
865528 | 865528 | 2020-12-26 | Denver | Colorado | 8031 | 46455 | 658 |
865529 | 865529 | 2020-12-26 | Dolores | Colorado | 8033 | 49 | 0 |
865530 | 865530 | 2020-12-26 | Douglas | Colorado | 8035 | 15381 | 186 |
865531 | 865531 | 2020-12-26 | Eagle | Colorado | 8037 | 3200 | 14 |
865532 | 865532 | 2020-12-26 | El Paso | Colorado | 8041 | 39831 | 528 |
865533 | 865533 | 2020-12-26 | Elbert | Colorado | 8039 | 954 | 8 |
865534 | 865534 | 2020-12-26 | Fremont | Colorado | 8043 | 4475 | 17 |
865535 | 865535 | 2020-12-26 | Garfield | Colorado | 8045 | 3687 | 26 |
865536 | 865536 | 2020-12-26 | Gilpin | Colorado | 8047 | 121 | 1 |
865537 | 865537 | 2020-12-26 | Grand | Colorado | 8049 | 619 | 4 |
865538 | 865538 | 2020-12-26 | Gunnison | Colorado | 8051 | 667 | 5 |
865539 | 865539 | 2020-12-26 | Hinsdale | Colorado | 8053 | 12 | 0 |
865540 | 865540 | 2020-12-26 | Huerfano | Colorado | 8055 | 272 | 17 |
865541 | 865541 | 2020-12-26 | Jackson | Colorado | 8057 | 31 | 0 |
865542 | 865542 | 2020-12-26 | Jefferson | Colorado | 8059 | 28695 | 595 |
865543 | 865543 | 2020-12-26 | Kiowa | Colorado | 8061 | 73 | 2 |
865544 | 865544 | 2020-12-26 | Kit Carson | Colorado | 8063 | 430 | 9 |
865545 | 865545 | 2020-12-26 | La Plata | Colorado | 8067 | 2176 | 28 |
865546 | 865546 | 2020-12-26 | Lake | Colorado | 8065 | 401 | 0 |
865547 | 865547 | 2020-12-26 | Larimer | Colorado | 8069 | 14619 | 128 |
865548 | 865548 | 2020-12-26 | Las Animas | Colorado | 8071 | 487 | 4 |
865549 | 865549 | 2020-12-26 | Lincoln | Colorado | 8073 | 777 | 3 |
865550 | 865550 | 2020-12-26 | Logan | Colorado | 8075 | 3194 | 53 |
865551 | 865551 | 2020-12-26 | Mesa | Colorado | 8077 | 8760 | 127 |
865552 | 865552 | 2020-12-26 | Mineral | Colorado | 8079 | 41 | 1 |
865553 | 865553 | 2020-12-26 | Moffat | Colorado | 8081 | 525 | 19 |
865554 | 865554 | 2020-12-26 | Montezuma | Colorado | 8083 | 1189 | 14 |
865555 | 865555 | 2020-12-26 | Montrose | Colorado | 8085 | 1961 | 29 |
865556 | 865556 | 2020-12-26 | Morgan | Colorado | 8087 | 2085 | 74 |
865557 | 865557 | 2020-12-26 | Otero | Colorado | 8089 | 1576 | 34 |
865558 | 865558 | 2020-12-26 | Ouray | Colorado | 8091 | 149 | 3 |
865559 | 865559 | 2020-12-26 | Park | Colorado | 8093 | 369 | 4 |
865560 | 865560 | 2020-12-26 | Phillips | Colorado | 8095 | 241 | 6 |
865561 | 865561 | 2020-12-26 | Pitkin | Colorado | 8097 | 925 | 3 |
865562 | 865562 | 2020-12-26 | Prowers | Colorado | 8099 | 969 | 20 |
865563 | 865563 | 2020-12-26 | Pueblo | Colorado | 8101 | 12854 | 288 |
865564 | 865564 | 2020-12-26 | Rio Blanco | Colorado | 8103 | 262 | 2 |
865565 | 865565 | 2020-12-26 | Rio Grande | Colorado | 8105 | 371 | 5 |
865566 | 865566 | 2020-12-26 | Routt | Colorado | 8107 | 1004 | 18 |
865567 | 865567 | 2020-12-26 | Saguache | Colorado | 8109 | 251 | 4 |
865568 | 865568 | 2020-12-26 | San Juan | Colorado | 8111 | 29 | 0 |
865569 | 865569 | 2020-12-26 | San Miguel | Colorado | 8113 | 384 | 0 |
865570 | 865570 | 2020-12-26 | Sedgwick | Colorado | 8115 | 125 | 2 |
865571 | 865571 | 2020-12-26 | Summit | Colorado | 8117 | 2073 | 5 |
865572 | 865572 | 2020-12-26 | Teller | Colorado | 8119 | 951 | 7 |
865573 | 865573 | 2020-12-26 | Washington | Colorado | 8121 | 340 | 10 |
865574 | 865574 | 2020-12-26 | Weld | Colorado | 8123 | 19228 | 271 |
865575 | 865575 | 2020-12-26 | Yuma | Colorado | 8125 | 524 | 10 |
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);