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-05 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
700013 | 700013 | 2020-11-05 | Adams | Colorado | 8001 | 17107 | 267 |
700014 | 700014 | 2020-11-05 | Alamosa | Colorado | 8003 | 374 | 9 |
700015 | 700015 | 2020-11-05 | Arapahoe | Colorado | 8005 | 15354 | 404 |
700016 | 700016 | 2020-11-05 | Archuleta | Colorado | 8007 | 69 | 0 |
700017 | 700017 | 2020-11-05 | Baca | Colorado | 8009 | 39 | 0 |
700018 | 700018 | 2020-11-05 | Bent | Colorado | 8011 | 21 | 0 |
700019 | 700019 | 2020-11-05 | Boulder | Colorado | 8013 | 6590 | 95 |
700020 | 700020 | 2020-11-05 | Broomfield | Colorado | 8014 | 1185 | 43 |
700021 | 700021 | 2020-11-05 | Chaffee | Colorado | 8015 | 445 | 20 |
700022 | 700022 | 2020-11-05 | Cheyenne | Colorado | 8017 | 16 | 0 |
700023 | 700023 | 2020-11-05 | Clear Creek | Colorado | 8019 | 96 | 1 |
700024 | 700024 | 2020-11-05 | Conejos | Colorado | 8021 | 94 | 0 |
700025 | 700025 | 2020-11-05 | Costilla | Colorado | 8023 | 43 | 1 |
700026 | 700026 | 2020-11-05 | Crowley | Colorado | 8025 | 199 | 1 |
700027 | 700027 | 2020-11-05 | Custer | Colorado | 8027 | 32 | 0 |
700028 | 700028 | 2020-11-05 | Delta | Colorado | 8029 | 240 | 3 |
700029 | 700029 | 2020-11-05 | Denver | Colorado | 8031 | 21885 | 468 |
700030 | 700030 | 2020-11-05 | Dolores | Colorado | 8033 | 3 | 0 |
700031 | 700031 | 2020-11-05 | Douglas | Colorado | 8035 | 5061 | 68 |
700032 | 700032 | 2020-11-05 | Eagle | Colorado | 8037 | 1605 | 10 |
700033 | 700033 | 2020-11-05 | El Paso | Colorado | 8041 | 13245 | 209 |
700034 | 700034 | 2020-11-05 | Elbert | Colorado | 8039 | 274 | 3 |
700035 | 700035 | 2020-11-05 | Fremont | Colorado | 8043 | 976 | 2 |
700036 | 700036 | 2020-11-05 | Garfield | Colorado | 8045 | 1307 | 5 |
700037 | 700037 | 2020-11-05 | Gilpin | Colorado | 8047 | 36 | 0 |
700038 | 700038 | 2020-11-05 | Grand | Colorado | 8049 | 165 | 1 |
700039 | 700039 | 2020-11-05 | Gunnison | Colorado | 8051 | 332 | 7 |
700040 | 700040 | 2020-11-05 | Hinsdale | Colorado | 8053 | 4 | 0 |
700041 | 700041 | 2020-11-05 | Huerfano | Colorado | 8055 | 47 | 2 |
700042 | 700042 | 2020-11-05 | Jackson | Colorado | 8057 | 9 | 0 |
700043 | 700043 | 2020-11-05 | Jefferson | Colorado | 8059 | 10607 | 336 |
700044 | 700044 | 2020-11-05 | Kiowa | Colorado | 8061 | 6 | 0 |
700045 | 700045 | 2020-11-05 | Kit Carson | Colorado | 8063 | 184 | 3 |
700046 | 700046 | 2020-11-05 | La Plata | Colorado | 8067 | 416 | 2 |
700047 | 700047 | 2020-11-05 | Lake | Colorado | 8065 | 155 | 0 |
700048 | 700048 | 2020-11-05 | Larimer | Colorado | 8069 | 4975 | 60 |
700049 | 700049 | 2020-11-05 | Las Animas | Colorado | 8071 | 95 | 1 |
700050 | 700050 | 2020-11-05 | Lincoln | Colorado | 8073 | 26 | 0 |
700051 | 700051 | 2020-11-05 | Logan | Colorado | 8075 | 1416 | 14 |
700052 | 700052 | 2020-11-05 | Mesa | Colorado | 8077 | 2036 | 19 |
700053 | 700053 | 2020-11-05 | Mineral | Colorado | 8079 | 21 | 0 |
700054 | 700054 | 2020-11-05 | Moffat | Colorado | 8081 | 83 | 1 |
700055 | 700055 | 2020-11-05 | Montezuma | Colorado | 8083 | 260 | 5 |
700056 | 700056 | 2020-11-05 | Montrose | Colorado | 8085 | 510 | 14 |
700057 | 700057 | 2020-11-05 | Morgan | Colorado | 8087 | 973 | 49 |
700058 | 700058 | 2020-11-05 | Otero | Colorado | 8089 | 199 | 7 |
700059 | 700059 | 2020-11-05 | Ouray | Colorado | 8091 | 49 | 2 |
700060 | 700060 | 2020-11-05 | Park | Colorado | 8093 | 114 | 1 |
700061 | 700061 | 2020-11-05 | Phillips | Colorado | 8095 | 83 | 0 |
700062 | 700062 | 2020-11-05 | Pitkin | Colorado | 8097 | 313 | 2 |
700063 | 700063 | 2020-11-05 | Prowers | Colorado | 8099 | 232 | 10 |
700064 | 700064 | 2020-11-05 | Pueblo | Colorado | 8101 | 2826 | 52 |
700065 | 700065 | 2020-11-05 | Rio Blanco | Colorado | 8103 | 31 | 0 |
700066 | 700066 | 2020-11-05 | Rio Grande | Colorado | 8105 | 137 | 3 |
700067 | 700067 | 2020-11-05 | Routt | Colorado | 8107 | 248 | 9 |
700068 | 700068 | 2020-11-05 | Saguache | Colorado | 8109 | 155 | 2 |
700069 | 700069 | 2020-11-05 | San Juan | Colorado | 8111 | 11 | 0 |
700070 | 700070 | 2020-11-05 | San Miguel | Colorado | 8113 | 114 | 0 |
700071 | 700071 | 2020-11-05 | Sedgwick | Colorado | 8115 | 53 | 1 |
700072 | 700072 | 2020-11-05 | Summit | Colorado | 8117 | 874 | 4 |
700073 | 700073 | 2020-11-05 | Teller | Colorado | 8119 | 294 | 4 |
700074 | 700074 | 2020-11-05 | Washington | Colorado | 8121 | 124 | 1 |
700075 | 700075 | 2020-11-05 | Weld | Colorado | 8123 | 7458 | 161 |
700076 | 700076 | 2020-11-05 | Yuma | Colorado | 8125 | 239 | 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);