ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-10-29" 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 |
---|---|---|---|---|---|---|---|
677309 | 677309 | 2020-10-29 | Adams | Colorado | 8001 | 14523 | 261 |
677310 | 677310 | 2020-10-29 | Alamosa | Colorado | 8003 | 327 | 9 |
677311 | 677311 | 2020-10-29 | Arapahoe | Colorado | 8005 | 13165 | 400 |
677312 | 677312 | 2020-10-29 | Archuleta | Colorado | 8007 | 68 | 0 |
677313 | 677313 | 2020-10-29 | Baca | Colorado | 8009 | 32 | 0 |
677314 | 677314 | 2020-10-29 | Bent | Colorado | 8011 | 16 | 0 |
677315 | 677315 | 2020-10-29 | Boulder | Colorado | 8013 | 5680 | 85 |
677316 | 677316 | 2020-10-29 | Broomfield | Colorado | 8014 | 997 | 42 |
677317 | 677317 | 2020-10-29 | Chaffee | Colorado | 8015 | 417 | 20 |
677318 | 677318 | 2020-10-29 | Cheyenne | Colorado | 8017 | 15 | 0 |
677319 | 677319 | 2020-10-29 | Clear Creek | Colorado | 8019 | 74 | 1 |
677320 | 677320 | 2020-10-29 | Conejos | Colorado | 8021 | 69 | 0 |
677321 | 677321 | 2020-10-29 | Costilla | Colorado | 8023 | 36 | 1 |
677322 | 677322 | 2020-10-29 | Crowley | Colorado | 8025 | 95 | 1 |
677323 | 677323 | 2020-10-29 | Custer | Colorado | 8027 | 22 | 0 |
677324 | 677324 | 2020-10-29 | Delta | Colorado | 8029 | 211 | 3 |
677325 | 677325 | 2020-10-29 | Denver | Colorado | 8031 | 18745 | 459 |
677326 | 677326 | 2020-10-29 | Dolores | Colorado | 8033 | 3 | 0 |
677327 | 677327 | 2020-10-29 | Douglas | Colorado | 8035 | 4168 | 65 |
677328 | 677328 | 2020-10-29 | Eagle | Colorado | 8037 | 1465 | 10 |
677329 | 677329 | 2020-10-29 | El Paso | Colorado | 8041 | 10557 | 204 |
677330 | 677330 | 2020-10-29 | Elbert | Colorado | 8039 | 226 | 3 |
677331 | 677331 | 2020-10-29 | Fremont | Colorado | 8043 | 695 | 2 |
677332 | 677332 | 2020-10-29 | Garfield | Colorado | 8045 | 1202 | 5 |
677333 | 677333 | 2020-10-29 | Gilpin | Colorado | 8047 | 29 | 0 |
677334 | 677334 | 2020-10-29 | Grand | Colorado | 8049 | 153 | 1 |
677335 | 677335 | 2020-10-29 | Gunnison | Colorado | 8051 | 310 | 7 |
677336 | 677336 | 2020-10-29 | Hinsdale | Colorado | 8053 | 3 | 0 |
677337 | 677337 | 2020-10-29 | Huerfano | Colorado | 8055 | 33 | 2 |
677338 | 677338 | 2020-10-29 | Jackson | Colorado | 8057 | 9 | 0 |
677339 | 677339 | 2020-10-29 | Jefferson | Colorado | 8059 | 8783 | 314 |
677340 | 677340 | 2020-10-29 | Kiowa | Colorado | 8061 | 4 | 0 |
677341 | 677341 | 2020-10-29 | Kit Carson | Colorado | 8063 | 135 | 3 |
677342 | 677342 | 2020-10-29 | La Plata | Colorado | 8067 | 375 | 2 |
677343 | 677343 | 2020-10-29 | Lake | Colorado | 8065 | 135 | 0 |
677344 | 677344 | 2020-10-29 | Larimer | Colorado | 8069 | 4183 | 57 |
677345 | 677345 | 2020-10-29 | Las Animas | Colorado | 8071 | 79 | 1 |
677346 | 677346 | 2020-10-29 | Lincoln | Colorado | 8073 | 25 | 0 |
677347 | 677347 | 2020-10-29 | Logan | Colorado | 8075 | 1258 | 13 |
677348 | 677348 | 2020-10-29 | Mesa | Colorado | 8077 | 1504 | 15 |
677349 | 677349 | 2020-10-29 | Mineral | Colorado | 8079 | 21 | 0 |
677350 | 677350 | 2020-10-29 | Moffat | Colorado | 8081 | 70 | 1 |
677351 | 677351 | 2020-10-29 | Montezuma | Colorado | 8083 | 215 | 5 |
677352 | 677352 | 2020-10-29 | Montrose | Colorado | 8085 | 477 | 13 |
677353 | 677353 | 2020-10-29 | Morgan | Colorado | 8087 | 879 | 48 |
677354 | 677354 | 2020-10-29 | Otero | Colorado | 8089 | 158 | 7 |
677355 | 677355 | 2020-10-29 | Ouray | Colorado | 8091 | 39 | 2 |
677356 | 677356 | 2020-10-29 | Park | Colorado | 8093 | 101 | 1 |
677357 | 677357 | 2020-10-29 | Phillips | Colorado | 8095 | 56 | 0 |
677358 | 677358 | 2020-10-29 | Pitkin | Colorado | 8097 | 288 | 2 |
677359 | 677359 | 2020-10-29 | Prowers | Colorado | 8099 | 189 | 4 |
677360 | 677360 | 2020-10-29 | Pueblo | Colorado | 8101 | 2141 | 44 |
677361 | 677361 | 2020-10-29 | Rio Blanco | Colorado | 8103 | 29 | 0 |
677362 | 677362 | 2020-10-29 | Rio Grande | Colorado | 8105 | 124 | 3 |
677363 | 677363 | 2020-10-29 | Routt | Colorado | 8107 | 219 | 8 |
677364 | 677364 | 2020-10-29 | Saguache | Colorado | 8109 | 142 | 2 |
677365 | 677365 | 2020-10-29 | San Juan | Colorado | 8111 | 7 | 0 |
677366 | 677366 | 2020-10-29 | San Miguel | Colorado | 8113 | 104 | 0 |
677367 | 677367 | 2020-10-29 | Sedgwick | Colorado | 8115 | 41 | 1 |
677368 | 677368 | 2020-10-29 | Summit | Colorado | 8117 | 731 | 4 |
677369 | 677369 | 2020-10-29 | Teller | Colorado | 8119 | 232 | 4 |
677370 | 677370 | 2020-10-29 | Washington | Colorado | 8121 | 102 | 0 |
677371 | 677371 | 2020-10-29 | Weld | Colorado | 8123 | 6255 | 159 |
677372 | 677372 | 2020-10-29 | Yuma | Colorado | 8125 | 219 | 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);