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-09-23 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 |
---|---|---|---|---|---|---|---|
1745380 | 1745380 | 2021-09-23 | Adams | Colorado | 8001 | 71189 | 834 |
1745381 | 1745381 | 2021-09-23 | Alamosa | Colorado | 8003 | 2062 | 42 |
1745382 | 1745382 | 2021-09-23 | Arapahoe | Colorado | 8005 | 74344 | 878 |
1745383 | 1745383 | 2021-09-23 | Archuleta | Colorado | 8007 | 1338 | 3 |
1745384 | 1745384 | 2021-09-23 | Baca | Colorado | 8009 | 385 | 5 |
1745385 | 1745385 | 2021-09-23 | Bent | Colorado | 8011 | 1601 | 23 |
1745386 | 1745386 | 2021-09-23 | Boulder | Colorado | 8013 | 28283 | 269 |
1745387 | 1745387 | 2021-09-23 | Broomfield | Colorado | 8014 | 6064 | 78 |
1745388 | 1745388 | 2021-09-23 | Chaffee | Colorado | 8015 | 2054 | 28 |
1745389 | 1745389 | 2021-09-23 | Cheyenne | Colorado | 8017 | 155 | 7 |
1745390 | 1745390 | 2021-09-23 | Clear Creek | Colorado | 8019 | 682 | 4 |
1745391 | 1745391 | 2021-09-23 | Conejos | Colorado | 8021 | 847 | 29 |
1745392 | 1745392 | 2021-09-23 | Costilla | Colorado | 8023 | 324 | 6 |
1745393 | 1745393 | 2021-09-23 | Crowley | Colorado | 8025 | 2278 | 18 |
1745394 | 1745394 | 2021-09-23 | Custer | Colorado | 8027 | 295 | 6 |
1745395 | 1745395 | 2021-09-23 | Delta | Colorado | 8029 | 3402 | 79 |
1745396 | 1745396 | 2021-09-23 | Denver | Colorado | 8031 | 84625 | 899 |
1745397 | 1745397 | 2021-09-23 | Dolores | Colorado | 8033 | 171 | 1 |
1745398 | 1745398 | 2021-09-23 | Douglas | Colorado | 8035 | 37271 | 285 |
1745399 | 1745399 | 2021-09-23 | Eagle | Colorado | 8037 | 7807 | 30 |
1745400 | 1745400 | 2021-09-23 | El Paso | Colorado | 8041 | 89681 | 991 |
1745401 | 1745401 | 2021-09-23 | Elbert | Colorado | 8039 | 2340 | 18 |
1745402 | 1745402 | 2021-09-23 | Fremont | Colorado | 8043 | 7297 | 72 |
1745403 | 1745403 | 2021-09-23 | Garfield | Colorado | 8045 | 7140 | 59 |
1745404 | 1745404 | 2021-09-23 | Gilpin | Colorado | 8047 | 386 | 3 |
1745405 | 1745405 | 2021-09-23 | Grand | Colorado | 8049 | 1924 | 10 |
1745406 | 1745406 | 2021-09-23 | Gunnison | Colorado | 8051 | 1711 | 8 |
1745407 | 1745407 | 2021-09-23 | Hinsdale | Colorado | 8053 | 53 | 0 |
1745408 | 1745408 | 2021-09-23 | Huerfano | Colorado | 8055 | 547 | 17 |
1745409 | 1745409 | 2021-09-23 | Jackson | Colorado | 8057 | 83 | 0 |
1745410 | 1745410 | 2021-09-23 | Jefferson | Colorado | 8059 | 57195 | 859 |
1745411 | 1745411 | 2021-09-23 | Kiowa | Colorado | 8061 | 116 | 4 |
1745412 | 1745412 | 2021-09-23 | Kit Carson | Colorado | 8063 | 829 | 14 |
1745413 | 1745413 | 2021-09-23 | La Plata | Colorado | 8067 | 5132 | 50 |
1745414 | 1745414 | 2021-09-23 | Lake | Colorado | 8065 | 950 | 1 |
1745415 | 1745415 | 2021-09-23 | Larimer | Colorado | 8069 | 34429 | 277 |
1745416 | 1745416 | 2021-09-23 | Las Animas | Colorado | 8071 | 1613 | 20 |
1745417 | 1745417 | 2021-09-23 | Lincoln | Colorado | 8073 | 1194 | 6 |
1745418 | 1745418 | 2021-09-23 | Logan | Colorado | 8075 | 4358 | 72 |
1745419 | 1745419 | 2021-09-23 | Mesa | Colorado | 8077 | 20981 | 291 |
1745420 | 1745420 | 2021-09-23 | Mineral | Colorado | 8079 | 109 | 1 |
1745421 | 1745421 | 2021-09-23 | Moffat | Colorado | 8081 | 1607 | 31 |
1745422 | 1745422 | 2021-09-23 | Montezuma | Colorado | 8083 | 2552 | 33 |
1745423 | 1745423 | 2021-09-23 | Montrose | Colorado | 8085 | 4577 | 76 |
1745424 | 1745424 | 2021-09-23 | Morgan | Colorado | 8087 | 3091 | 98 |
1745425 | 1745425 | 2021-09-23 | Otero | Colorado | 8089 | 2301 | 71 |
1745426 | 1745426 | 2021-09-23 | Ouray | Colorado | 8091 | 376 | 5 |
1745427 | 1745427 | 2021-09-23 | Park | Colorado | 8093 | 1146 | 7 |
1745428 | 1745428 | 2021-09-23 | Phillips | Colorado | 8095 | 464 | 14 |
1745429 | 1745429 | 2021-09-23 | Pitkin | Colorado | 8097 | 2968 | 5 |
1745430 | 1745430 | 2021-09-23 | Prowers | Colorado | 8099 | 1459 | 25 |
1745431 | 1745431 | 2021-09-23 | Pueblo | Colorado | 8101 | 22181 | 451 |
1745432 | 1745432 | 2021-09-23 | Rio Blanco | Colorado | 8103 | 830 | 8 |
1745433 | 1745433 | 2021-09-23 | Rio Grande | Colorado | 8105 | 1148 | 21 |
1745434 | 1745434 | 2021-09-23 | Routt | Colorado | 8107 | 3020 | 22 |
1745435 | 1745435 | 2021-09-23 | Saguache | Colorado | 8109 | 550 | 8 |
1745436 | 1745436 | 2021-09-23 | San Juan | Colorado | 8111 | 87 | 1 |
1745437 | 1745437 | 2021-09-23 | San Miguel | Colorado | 8113 | 1103 | 3 |
1745438 | 1745438 | 2021-09-23 | Sedgwick | Colorado | 8115 | 274 | 4 |
1745439 | 1745439 | 2021-09-23 | Summit | Colorado | 8117 | 4482 | 9 |
1745440 | 1745440 | 2021-09-23 | Teller | Colorado | 8119 | 2338 | 23 |
1745441 | 1745441 | 2021-09-23 | Washington | Colorado | 8121 | 520 | 14 |
1745442 | 1745442 | 2021-09-23 | Weld | Colorado | 8123 | 41072 | 390 |
1745443 | 1745443 | 2021-09-23 | Yuma | Colorado | 8125 | 1060 | 18 |
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);