ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-07-22" 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 |
---|---|---|---|---|---|---|---|
357276 | 357276 | 2020-07-22 | Adams | Colorado | 8001 | 5248 | 164 |
357277 | 357277 | 2020-07-22 | Alamosa | Colorado | 8003 | 214 | 7 |
357278 | 357278 | 2020-07-22 | Arapahoe | Colorado | 8005 | 6197 | 352 |
357279 | 357279 | 2020-07-22 | Archuleta | Colorado | 8007 | 24 | 0 |
357280 | 357280 | 2020-07-22 | Baca | Colorado | 8009 | 14 | 0 |
357281 | 357281 | 2020-07-22 | Bent | Colorado | 8011 | 5 | 0 |
357282 | 357282 | 2020-07-22 | Boulder | Colorado | 8013 | 1702 | 74 |
357283 | 357283 | 2020-07-22 | Broomfield | Colorado | 8014 | 371 | 32 |
357284 | 357284 | 2020-07-22 | Chaffee | Colorado | 8015 | 220 | 19 |
357285 | 357285 | 2020-07-22 | Cheyenne | Colorado | 8017 | 7 | 0 |
357286 | 357286 | 2020-07-22 | Clear Creek | Colorado | 8019 | 24 | 1 |
357287 | 357287 | 2020-07-22 | Conejos | Colorado | 8021 | 21 | 0 |
357288 | 357288 | 2020-07-22 | Costilla | Colorado | 8023 | 22 | 0 |
357289 | 357289 | 2020-07-22 | Crowley | Colorado | 8025 | 73 | 1 |
357290 | 357290 | 2020-07-22 | Custer | Colorado | 8027 | 10 | 0 |
357291 | 357291 | 2020-07-22 | Delta | Colorado | 8029 | 92 | 1 |
357292 | 357292 | 2020-07-22 | Denver | Colorado | 8031 | 8650 | 402 |
357293 | 357293 | 2020-07-22 | Dolores | Colorado | 8033 | 2 | 0 |
357294 | 357294 | 2020-07-22 | Douglas | Colorado | 8035 | 1410 | 54 |
357295 | 357295 | 2020-07-22 | Eagle | Colorado | 8037 | 884 | 9 |
357296 | 357296 | 2020-07-22 | El Paso | Colorado | 8041 | 3819 | 123 |
357297 | 357297 | 2020-07-22 | Elbert | Colorado | 8039 | 75 | 2 |
357298 | 357298 | 2020-07-22 | Fremont | Colorado | 8043 | 82 | 0 |
357299 | 357299 | 2020-07-22 | Garfield | Colorado | 8045 | 561 | 4 |
357300 | 357300 | 2020-07-22 | Gilpin | Colorado | 8047 | 13 | 0 |
357301 | 357301 | 2020-07-22 | Grand | Colorado | 8049 | 39 | 1 |
357302 | 357302 | 2020-07-22 | Gunnison | Colorado | 8051 | 216 | 6 |
357303 | 357303 | 2020-07-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
357304 | 357304 | 2020-07-22 | Huerfano | Colorado | 8055 | 5 | 1 |
357305 | 357305 | 2020-07-22 | Jackson | Colorado | 8057 | 8 | 0 |
357306 | 357306 | 2020-07-22 | Jefferson | Colorado | 8059 | 3395 | 219 |
357307 | 357307 | 2020-07-22 | Kit Carson | Colorado | 8063 | 36 | 3 |
357308 | 357308 | 2020-07-22 | La Plata | Colorado | 8067 | 174 | 2 |
357309 | 357309 | 2020-07-22 | Lake | Colorado | 8065 | 60 | 0 |
357310 | 357310 | 2020-07-22 | Larimer | Colorado | 8069 | 1158 | 32 |
357311 | 357311 | 2020-07-22 | Las Animas | Colorado | 8071 | 11 | 0 |
357312 | 357312 | 2020-07-22 | Lincoln | Colorado | 8073 | 6 | 0 |
357313 | 357313 | 2020-07-22 | Logan | Colorado | 8075 | 643 | 5 |
357314 | 357314 | 2020-07-22 | Mesa | Colorado | 8077 | 199 | 0 |
357315 | 357315 | 2020-07-22 | Mineral | Colorado | 8079 | 17 | 0 |
357316 | 357316 | 2020-07-22 | Moffat | Colorado | 8081 | 20 | 1 |
357317 | 357317 | 2020-07-22 | Montezuma | Colorado | 8083 | 91 | 4 |
357318 | 357318 | 2020-07-22 | Montrose | Colorado | 8085 | 245 | 13 |
357319 | 357319 | 2020-07-22 | Morgan | Colorado | 8087 | 666 | 46 |
357320 | 357320 | 2020-07-22 | Otero | Colorado | 8089 | 30 | 2 |
357321 | 357321 | 2020-07-22 | Ouray | Colorado | 8091 | 12 | 1 |
357322 | 357322 | 2020-07-22 | Park | Colorado | 8093 | 35 | 1 |
357323 | 357323 | 2020-07-22 | Phillips | Colorado | 8095 | 17 | 0 |
357324 | 357324 | 2020-07-22 | Pitkin | Colorado | 8097 | 162 | 2 |
357325 | 357325 | 2020-07-22 | Prowers | Colorado | 8099 | 45 | 0 |
357326 | 357326 | 2020-07-22 | Pueblo | Colorado | 8101 | 535 | 33 |
357327 | 357327 | 2020-07-22 | Rio Blanco | Colorado | 8103 | 6 | 0 |
357328 | 357328 | 2020-07-22 | Rio Grande | Colorado | 8105 | 84 | 2 |
357329 | 357329 | 2020-07-22 | Routt | Colorado | 8107 | 93 | 6 |
357330 | 357330 | 2020-07-22 | Saguache | Colorado | 8109 | 106 | 2 |
357331 | 357331 | 2020-07-22 | San Juan | Colorado | 8111 | 2 | 0 |
357332 | 357332 | 2020-07-22 | San Miguel | Colorado | 8113 | 69 | 0 |
357333 | 357333 | 2020-07-22 | Sedgwick | Colorado | 8115 | 11 | 0 |
357334 | 357334 | 2020-07-22 | Summit | Colorado | 8117 | 311 | 4 |
357335 | 357335 | 2020-07-22 | Teller | Colorado | 8119 | 87 | 2 |
357336 | 357336 | 2020-07-22 | Washington | Colorado | 8121 | 46 | 0 |
357337 | 357337 | 2020-07-22 | Weld | Colorado | 8123 | 3308 | 139 |
357338 | 357338 | 2020-07-22 | Yuma | Colorado | 8125 | 56 | 0 |
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);