ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-05-04" 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 |
---|---|---|---|---|---|---|---|
1284282 | 1284282 | 2021-05-04 | Adams | Colorado | 8001 | 57532 | 704 |
1284283 | 1284283 | 2021-05-04 | Alamosa | Colorado | 8003 | 1469 | 30 |
1284284 | 1284284 | 2021-05-04 | Arapahoe | Colorado | 8005 | 59134 | 774 |
1284285 | 1284285 | 2021-05-04 | Archuleta | Colorado | 8007 | 918 | 1 |
1284286 | 1284286 | 2021-05-04 | Baca | Colorado | 8009 | 290 | 4 |
1284287 | 1284287 | 2021-05-04 | Bent | Colorado | 8011 | 1526 | 21 |
1284288 | 1284288 | 2021-05-04 | Boulder | Colorado | 8013 | 23150 | 255 |
1284289 | 1284289 | 2021-05-04 | Broomfield | Colorado | 8014 | 4714 | 75 |
1284290 | 1284290 | 2021-05-04 | Chaffee | Colorado | 8015 | 1639 | 25 |
1284291 | 1284291 | 2021-05-04 | Cheyenne | Colorado | 8017 | 127 | 6 |
1284292 | 1284292 | 2021-05-04 | Clear Creek | Colorado | 8019 | 439 | 3 |
1284293 | 1284293 | 2021-05-04 | Conejos | Colorado | 8021 | 522 | 10 |
1284294 | 1284294 | 2021-05-04 | Costilla | Colorado | 8023 | 211 | 2 |
1284295 | 1284295 | 2021-05-04 | Crowley | Colorado | 8025 | 2182 | 15 |
1284296 | 1284296 | 2021-05-04 | Custer | Colorado | 8027 | 191 | 1 |
1284297 | 1284297 | 2021-05-04 | Delta | Colorado | 8029 | 2676 | 61 |
1284298 | 1284298 | 2021-05-04 | Denver | Colorado | 8031 | 70885 | 806 |
1284299 | 1284299 | 2021-05-04 | Dolores | Colorado | 8033 | 80 | 0 |
1284300 | 1284300 | 2021-05-04 | Douglas | Colorado | 8035 | 28578 | 253 |
1284301 | 1284301 | 2021-05-04 | Eagle | Colorado | 8037 | 6240 | 22 |
1284302 | 1284302 | 2021-05-04 | El Paso | Colorado | 8041 | 64849 | 792 |
1284303 | 1284303 | 2021-05-04 | Elbert | Colorado | 8039 | 1691 | 13 |
1284304 | 1284304 | 2021-05-04 | Fremont | Colorado | 8043 | 6127 | 55 |
1284305 | 1284305 | 2021-05-04 | Garfield | Colorado | 8045 | 5787 | 38 |
1284306 | 1284306 | 2021-05-04 | Gilpin | Colorado | 8047 | 233 | 3 |
1284307 | 1284307 | 2021-05-04 | Grand | Colorado | 8049 | 1467 | 7 |
1284308 | 1284308 | 2021-05-04 | Gunnison | Colorado | 8051 | 1326 | 6 |
1284309 | 1284309 | 2021-05-04 | Hinsdale | Colorado | 8053 | 17 | 0 |
1284310 | 1284310 | 2021-05-04 | Huerfano | Colorado | 8055 | 398 | 17 |
1284311 | 1284311 | 2021-05-04 | Jackson | Colorado | 8057 | 57 | 0 |
1284312 | 1284312 | 2021-05-04 | Jefferson | Colorado | 8059 | 45620 | 754 |
1284313 | 1284313 | 2021-05-04 | Kiowa | Colorado | 8061 | 95 | 3 |
1284314 | 1284314 | 2021-05-04 | Kit Carson | Colorado | 8063 | 609 | 11 |
1284315 | 1284315 | 2021-05-04 | La Plata | Colorado | 8067 | 3861 | 39 |
1284316 | 1284316 | 2021-05-04 | Lake | Colorado | 8065 | 778 | 0 |
1284317 | 1284317 | 2021-05-04 | Larimer | Colorado | 8069 | 25741 | 233 |
1284318 | 1284318 | 2021-05-04 | Las Animas | Colorado | 8071 | 1121 | 11 |
1284319 | 1284319 | 2021-05-04 | Lincoln | Colorado | 8073 | 1023 | 4 |
1284320 | 1284320 | 2021-05-04 | Logan | Colorado | 8075 | 3944 | 67 |
1284321 | 1284321 | 2021-05-04 | Mesa | Colorado | 8077 | 14514 | 213 |
1284322 | 1284322 | 2021-05-04 | Mineral | Colorado | 8079 | 87 | 1 |
1284323 | 1284323 | 2021-05-04 | Moffat | Colorado | 8081 | 758 | 22 |
1284324 | 1284324 | 2021-05-04 | Montezuma | Colorado | 8083 | 1891 | 24 |
1284325 | 1284325 | 2021-05-04 | Montrose | Colorado | 8085 | 3440 | 58 |
1284326 | 1284326 | 2021-05-04 | Morgan | Colorado | 8087 | 2631 | 93 |
1284327 | 1284327 | 2021-05-04 | Otero | Colorado | 8089 | 1978 | 65 |
1284328 | 1284328 | 2021-05-04 | Ouray | Colorado | 8091 | 283 | 3 |
1284329 | 1284329 | 2021-05-04 | Park | Colorado | 8093 | 742 | 5 |
1284330 | 1284330 | 2021-05-04 | Phillips | Colorado | 8095 | 375 | 13 |
1284331 | 1284331 | 2021-05-04 | Pitkin | Colorado | 8097 | 2578 | 4 |
1284332 | 1284332 | 2021-05-04 | Prowers | Colorado | 8099 | 1213 | 21 |
1284333 | 1284333 | 2021-05-04 | Pueblo | Colorado | 8101 | 18151 | 382 |
1284334 | 1284334 | 2021-05-04 | Rio Blanco | Colorado | 8103 | 567 | 4 |
1284335 | 1284335 | 2021-05-04 | Rio Grande | Colorado | 8105 | 795 | 14 |
1284336 | 1284336 | 2021-05-04 | Routt | Colorado | 8107 | 2188 | 20 |
1284337 | 1284337 | 2021-05-04 | Saguache | Colorado | 8109 | 376 | 4 |
1284338 | 1284338 | 2021-05-04 | San Juan | Colorado | 8111 | 50 | 0 |
1284339 | 1284339 | 2021-05-04 | San Miguel | Colorado | 8113 | 875 | 0 |
1284340 | 1284340 | 2021-05-04 | Sedgwick | Colorado | 8115 | 214 | 2 |
1284341 | 1284341 | 2021-05-04 | Summit | Colorado | 8117 | 3690 | 7 |
1284342 | 1284342 | 2021-05-04 | Teller | Colorado | 8119 | 1674 | 15 |
1284343 | 1284343 | 2021-05-04 | Washington | Colorado | 8121 | 450 | 12 |
1284344 | 1284344 | 2021-05-04 | Weld | Colorado | 8123 | 30878 | 336 |
1284345 | 1284345 | 2021-05-04 | Yuma | Colorado | 8125 | 885 | 17 |
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);