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 2021-02-12 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1021293 | 1021293 | 2021-02-12 | Adams | Colorado | 8001 | 47784 | 623 |
1021294 | 1021294 | 2021-02-12 | Alamosa | Colorado | 8003 | 1227 | 28 |
1021295 | 1021295 | 2021-02-12 | Arapahoe | Colorado | 8005 | 47617 | 681 |
1021296 | 1021296 | 2021-02-12 | Archuleta | Colorado | 8007 | 625 | 1 |
1021297 | 1021297 | 2021-02-12 | Baca | Colorado | 8009 | 269 | 3 |
1021298 | 1021298 | 2021-02-12 | Bent | Colorado | 8011 | 1400 | 21 |
1021299 | 1021299 | 2021-02-12 | Boulder | Colorado | 8013 | 18098 | 242 |
1021300 | 1021300 | 2021-02-12 | Broomfield | Colorado | 8014 | 3580 | 73 |
1021301 | 1021301 | 2021-02-12 | Chaffee | Colorado | 8015 | 1372 | 23 |
1021302 | 1021302 | 2021-02-12 | Cheyenne | Colorado | 8017 | 124 | 5 |
1021303 | 1021303 | 2021-02-12 | Clear Creek | Colorado | 8019 | 354 | 2 |
1021304 | 1021304 | 2021-02-12 | Conejos | Colorado | 8021 | 423 | 7 |
1021305 | 1021305 | 2021-02-12 | Costilla | Colorado | 8023 | 176 | 2 |
1021306 | 1021306 | 2021-02-12 | Crowley | Colorado | 8025 | 1918 | 14 |
1021307 | 1021307 | 2021-02-12 | Custer | Colorado | 8027 | 163 | 1 |
1021308 | 1021308 | 2021-02-12 | Delta | Colorado | 8029 | 2408 | 56 |
1021309 | 1021309 | 2021-02-12 | Denver | Colorado | 8031 | 57582 | 752 |
1021310 | 1021310 | 2021-02-12 | Dolores | Colorado | 8033 | 64 | 0 |
1021311 | 1021311 | 2021-02-12 | Douglas | Colorado | 8035 | 20560 | 230 |
1021312 | 1021312 | 2021-02-12 | Eagle | Colorado | 8037 | 4700 | 20 |
1021313 | 1021313 | 2021-02-12 | El Paso | Colorado | 8041 | 49727 | 725 |
1021314 | 1021314 | 2021-02-12 | Elbert | Colorado | 8039 | 1222 | 12 |
1021315 | 1021315 | 2021-02-12 | Fremont | Colorado | 8043 | 5272 | 41 |
1021316 | 1021316 | 2021-02-12 | Garfield | Colorado | 8045 | 4957 | 38 |
1021317 | 1021317 | 2021-02-12 | Gilpin | Colorado | 8047 | 161 | 3 |
1021318 | 1021318 | 2021-02-12 | Grand | Colorado | 8049 | 1159 | 5 |
1021319 | 1021319 | 2021-02-12 | Gunnison | Colorado | 8051 | 1138 | 6 |
1021320 | 1021320 | 2021-02-12 | Hinsdale | Colorado | 8053 | 16 | 0 |
1021321 | 1021321 | 2021-02-12 | Huerfano | Colorado | 8055 | 298 | 17 |
1021322 | 1021322 | 2021-02-12 | Jackson | Colorado | 8057 | 48 | 0 |
1021323 | 1021323 | 2021-02-12 | Jefferson | Colorado | 8059 | 35803 | 692 |
1021324 | 1021324 | 2021-02-12 | Kiowa | Colorado | 8061 | 90 | 3 |
1021325 | 1021325 | 2021-02-12 | Kit Carson | Colorado | 8063 | 518 | 10 |
1021326 | 1021326 | 2021-02-12 | La Plata | Colorado | 8067 | 2830 | 35 |
1021327 | 1021327 | 2021-02-12 | Lake | Colorado | 8065 | 617 | 0 |
1021328 | 1021328 | 2021-02-12 | Larimer | Colorado | 8069 | 18877 | 212 |
1021329 | 1021329 | 2021-02-12 | Las Animas | Colorado | 8071 | 960 | 11 |
1021330 | 1021330 | 2021-02-12 | Lincoln | Colorado | 8073 | 969 | 3 |
1021331 | 1021331 | 2021-02-12 | Logan | Colorado | 8075 | 3683 | 63 |
1021332 | 1021332 | 2021-02-12 | Mesa | Colorado | 8077 | 12854 | 182 |
1021333 | 1021333 | 2021-02-12 | Mineral | Colorado | 8079 | 61 | 1 |
1021334 | 1021334 | 2021-02-12 | Moffat | Colorado | 8081 | 646 | 22 |
1021335 | 1021335 | 2021-02-12 | Montezuma | Colorado | 8083 | 1685 | 22 |
1021336 | 1021336 | 2021-02-12 | Montrose | Colorado | 8085 | 3133 | 51 |
1021337 | 1021337 | 2021-02-12 | Morgan | Colorado | 8087 | 2402 | 90 |
1021338 | 1021338 | 2021-02-12 | Otero | Colorado | 8089 | 1811 | 60 |
1021339 | 1021339 | 2021-02-12 | Ouray | Colorado | 8091 | 236 | 3 |
1021340 | 1021340 | 2021-02-12 | Park | Colorado | 8093 | 523 | 5 |
1021341 | 1021341 | 2021-02-12 | Phillips | Colorado | 8095 | 329 | 11 |
1021342 | 1021342 | 2021-02-12 | Pitkin | Colorado | 8097 | 1904 | 4 |
1021343 | 1021343 | 2021-02-12 | Prowers | Colorado | 8099 | 1153 | 21 |
1021344 | 1021344 | 2021-02-12 | Pueblo | Colorado | 8101 | 14727 | 361 |
1021345 | 1021345 | 2021-02-12 | Rio Blanco | Colorado | 8103 | 433 | 3 |
1021346 | 1021346 | 2021-02-12 | Rio Grande | Colorado | 8105 | 662 | 10 |
1021347 | 1021347 | 2021-02-12 | Routt | Colorado | 8107 | 1773 | 19 |
1021348 | 1021348 | 2021-02-12 | Saguache | Colorado | 8109 | 300 | 4 |
1021349 | 1021349 | 2021-02-12 | San Juan | Colorado | 8111 | 43 | 0 |
1021350 | 1021350 | 2021-02-12 | San Miguel | Colorado | 8113 | 786 | 0 |
1021351 | 1021351 | 2021-02-12 | Sedgwick | Colorado | 8115 | 189 | 2 |
1021352 | 1021352 | 2021-02-12 | Summit | Colorado | 8117 | 2859 | 7 |
1021353 | 1021353 | 2021-02-12 | Teller | Colorado | 8119 | 1221 | 14 |
1021354 | 1021354 | 2021-02-12 | Washington | Colorado | 8121 | 365 | 12 |
1021355 | 1021355 | 2021-02-12 | Weld | Colorado | 8123 | 24599 | 313 |
1021356 | 1021356 | 2021-02-12 | Yuma | Colorado | 8125 | 688 | 16 |
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);