ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,527 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Douglas 354
- Jefferson 354
- Denver 353
- Eagle 353
- El Paso 353
- Arapahoe 350
- Larimer 350
- Gunnison 349
- Pitkin 348
- Adams 347
- Summit 347
- Weld 347
- Clear Creek 346
- Pueblo 346
- Routt 346
- Boulder 345
- Mesa 345
- Garfield 344
- Yuma 342
- Crowley 340
- Grand 340
- Morgan 340
- San Miguel 340
- Broomfield 339
- Park 339
- Chaffee 338
- Elbert 338
- Hinsdale 338
- Montrose 338
- Teller 337
- …
state 1
- Colorado · 20,991 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053806 | 1053806 | 2021-02-22 | San Juan | Colorado | 8111 | 41 | 0 |
1053807 | 1053807 | 2021-02-22 | San Miguel | Colorado | 8113 | 802 | 0 |
1053808 | 1053808 | 2021-02-22 | Sedgwick | Colorado | 8115 | 191 | 2 |
1053809 | 1053809 | 2021-02-22 | Summit | Colorado | 8117 | 2961 | 7 |
1053810 | 1053810 | 2021-02-22 | Teller | Colorado | 8119 | 1252 | 14 |
1053811 | 1053811 | 2021-02-22 | Washington | Colorado | 8121 | 378 | 12 |
1053812 | 1053812 | 2021-02-22 | Weld | Colorado | 8123 | 25137 | 316 |
1053813 | 1053813 | 2021-02-22 | Yuma | Colorado | 8125 | 700 | 17 |
1050503 | 1050503 | 2021-02-21 | Adams | Colorado | 8001 | 48643 | 627 |
1050504 | 1050504 | 2021-02-21 | Alamosa | Colorado | 8003 | 1257 | 28 |
1050505 | 1050505 | 2021-02-21 | Arapahoe | Colorado | 8005 | 48627 | 688 |
1050506 | 1050506 | 2021-02-21 | Archuleta | Colorado | 8007 | 629 | 1 |
1050507 | 1050507 | 2021-02-21 | Baca | Colorado | 8009 | 270 | 4 |
1050508 | 1050508 | 2021-02-21 | Bent | Colorado | 8011 | 1469 | 21 |
1050509 | 1050509 | 2021-02-21 | Boulder | Colorado | 8013 | 18599 | 245 |
1050510 | 1050510 | 2021-02-21 | Broomfield | Colorado | 8014 | 3654 | 74 |
1050511 | 1050511 | 2021-02-21 | Chaffee | Colorado | 8015 | 1411 | 23 |
1050512 | 1050512 | 2021-02-21 | Cheyenne | Colorado | 8017 | 125 | 5 |
1050513 | 1050513 | 2021-02-21 | Clear Creek | Colorado | 8019 | 357 | 2 |
1050514 | 1050514 | 2021-02-21 | Conejos | Colorado | 8021 | 432 | 7 |
1050515 | 1050515 | 2021-02-21 | Costilla | Colorado | 8023 | 178 | 2 |
1050516 | 1050516 | 2021-02-21 | Crowley | Colorado | 8025 | 1959 | 14 |
1050517 | 1050517 | 2021-02-21 | Custer | Colorado | 8027 | 164 | 1 |
1050518 | 1050518 | 2021-02-21 | Delta | Colorado | 8029 | 2439 | 58 |
1050519 | 1050519 | 2021-02-21 | Denver | Colorado | 8031 | 58628 | 766 |
1050520 | 1050520 | 2021-02-21 | Dolores | Colorado | 8033 | 67 | 0 |
1050521 | 1050521 | 2021-02-21 | Douglas | Colorado | 8035 | 21290 | 230 |
1050522 | 1050522 | 2021-02-21 | Eagle | Colorado | 8037 | 4897 | 20 |
1050523 | 1050523 | 2021-02-21 | El Paso | Colorado | 8041 | 50951 | 741 |
1050524 | 1050524 | 2021-02-21 | Elbert | Colorado | 8039 | 1254 | 12 |
1050525 | 1050525 | 2021-02-21 | Fremont | Colorado | 8043 | 5403 | 48 |
1050526 | 1050526 | 2021-02-21 | Garfield | Colorado | 8045 | 5022 | 38 |
1050527 | 1050527 | 2021-02-21 | Gilpin | Colorado | 8047 | 165 | 3 |
1050528 | 1050528 | 2021-02-21 | Grand | Colorado | 8049 | 1241 | 5 |
1050529 | 1050529 | 2021-02-21 | Gunnison | Colorado | 8051 | 1181 | 6 |
1050530 | 1050530 | 2021-02-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
1050531 | 1050531 | 2021-02-21 | Huerfano | Colorado | 8055 | 300 | 17 |
1050532 | 1050532 | 2021-02-21 | Jackson | Colorado | 8057 | 51 | 0 |
1050533 | 1050533 | 2021-02-21 | Jefferson | Colorado | 8059 | 36523 | 706 |
1050534 | 1050534 | 2021-02-21 | Kiowa | Colorado | 8061 | 91 | 3 |
1050535 | 1050535 | 2021-02-21 | Kit Carson | Colorado | 8063 | 524 | 10 |
1050536 | 1050536 | 2021-02-21 | La Plata | Colorado | 8067 | 2879 | 37 |
1050537 | 1050537 | 2021-02-21 | Lake | Colorado | 8065 | 651 | 0 |
1050538 | 1050538 | 2021-02-21 | Larimer | Colorado | 8069 | 19532 | 219 |
1050539 | 1050539 | 2021-02-21 | Las Animas | Colorado | 8071 | 982 | 11 |
1050540 | 1050540 | 2021-02-21 | Lincoln | Colorado | 8073 | 996 | 3 |
1050541 | 1050541 | 2021-02-21 | Logan | Colorado | 8075 | 3705 | 63 |
1050542 | 1050542 | 2021-02-21 | Mesa | Colorado | 8077 | 13072 | 190 |
1050543 | 1050543 | 2021-02-21 | Mineral | Colorado | 8079 | 61 | 1 |
1050544 | 1050544 | 2021-02-21 | Moffat | Colorado | 8081 | 657 | 22 |
1050545 | 1050545 | 2021-02-21 | Montezuma | Colorado | 8083 | 1704 | 22 |
1050546 | 1050546 | 2021-02-21 | Montrose | Colorado | 8085 | 3188 | 52 |
1050547 | 1050547 | 2021-02-21 | Morgan | Colorado | 8087 | 2415 | 90 |
1050548 | 1050548 | 2021-02-21 | Otero | Colorado | 8089 | 1839 | 61 |
1050549 | 1050549 | 2021-02-21 | Ouray | Colorado | 8091 | 247 | 3 |
1050550 | 1050550 | 2021-02-21 | Park | Colorado | 8093 | 539 | 5 |
1050551 | 1050551 | 2021-02-21 | Phillips | Colorado | 8095 | 333 | 12 |
1050552 | 1050552 | 2021-02-21 | Pitkin | Colorado | 8097 | 1941 | 4 |
1050553 | 1050553 | 2021-02-21 | Prowers | Colorado | 8099 | 1157 | 21 |
1050554 | 1050554 | 2021-02-21 | Pueblo | Colorado | 8101 | 14879 | 362 |
1050555 | 1050555 | 2021-02-21 | Rio Blanco | Colorado | 8103 | 455 | 3 |
1050556 | 1050556 | 2021-02-21 | Rio Grande | Colorado | 8105 | 683 | 12 |
1050557 | 1050557 | 2021-02-21 | Routt | Colorado | 8107 | 1830 | 19 |
1050558 | 1050558 | 2021-02-21 | Saguache | Colorado | 8109 | 312 | 4 |
1050559 | 1050559 | 2021-02-21 | San Juan | Colorado | 8111 | 41 | 0 |
1050560 | 1050560 | 2021-02-21 | San Miguel | Colorado | 8113 | 803 | 0 |
1050561 | 1050561 | 2021-02-21 | Sedgwick | Colorado | 8115 | 191 | 2 |
1050562 | 1050562 | 2021-02-21 | Summit | Colorado | 8117 | 2958 | 7 |
1050563 | 1050563 | 2021-02-21 | Teller | Colorado | 8119 | 1248 | 14 |
1050564 | 1050564 | 2021-02-21 | Washington | Colorado | 8121 | 378 | 12 |
1050565 | 1050565 | 2021-02-21 | Weld | Colorado | 8123 | 25018 | 316 |
1050566 | 1050566 | 2021-02-21 | Yuma | Colorado | 8125 | 697 | 17 |
1047256 | 1047256 | 2021-02-20 | Adams | Colorado | 8001 | 48525 | 626 |
1047257 | 1047257 | 2021-02-20 | Alamosa | Colorado | 8003 | 1252 | 28 |
1047258 | 1047258 | 2021-02-20 | Arapahoe | Colorado | 8005 | 48494 | 688 |
1047259 | 1047259 | 2021-02-20 | Archuleta | Colorado | 8007 | 629 | 1 |
1047260 | 1047260 | 2021-02-20 | Baca | Colorado | 8009 | 270 | 4 |
1047261 | 1047261 | 2021-02-20 | Bent | Colorado | 8011 | 1469 | 21 |
1047262 | 1047262 | 2021-02-20 | Boulder | Colorado | 8013 | 18560 | 245 |
1047263 | 1047263 | 2021-02-20 | Broomfield | Colorado | 8014 | 3646 | 74 |
1047264 | 1047264 | 2021-02-20 | Chaffee | Colorado | 8015 | 1411 | 23 |
1047265 | 1047265 | 2021-02-20 | Cheyenne | Colorado | 8017 | 125 | 5 |
1047266 | 1047266 | 2021-02-20 | Clear Creek | Colorado | 8019 | 356 | 2 |
1047267 | 1047267 | 2021-02-20 | Conejos | Colorado | 8021 | 430 | 7 |
1047268 | 1047268 | 2021-02-20 | Costilla | Colorado | 8023 | 178 | 2 |
1047269 | 1047269 | 2021-02-20 | Crowley | Colorado | 8025 | 1957 | 14 |
1047270 | 1047270 | 2021-02-20 | Custer | Colorado | 8027 | 164 | 1 |
1047271 | 1047271 | 2021-02-20 | Delta | Colorado | 8029 | 2437 | 58 |
1047272 | 1047272 | 2021-02-20 | Denver | Colorado | 8031 | 58432 | 765 |
1047273 | 1047273 | 2021-02-20 | Dolores | Colorado | 8033 | 67 | 0 |
1047274 | 1047274 | 2021-02-20 | Douglas | Colorado | 8035 | 21225 | 230 |
1047275 | 1047275 | 2021-02-20 | Eagle | Colorado | 8037 | 4878 | 20 |
1047276 | 1047276 | 2021-02-20 | El Paso | Colorado | 8041 | 50831 | 741 |
1047277 | 1047277 | 2021-02-20 | Elbert | Colorado | 8039 | 1251 | 12 |
1047278 | 1047278 | 2021-02-20 | Fremont | Colorado | 8043 | 5397 | 48 |
1047279 | 1047279 | 2021-02-20 | Garfield | Colorado | 8045 | 5017 | 38 |
1047280 | 1047280 | 2021-02-20 | Gilpin | Colorado | 8047 | 164 | 3 |
1047281 | 1047281 | 2021-02-20 | Grand | Colorado | 8049 | 1234 | 5 |
1047282 | 1047282 | 2021-02-20 | Gunnison | Colorado | 8051 | 1182 | 6 |
1047283 | 1047283 | 2021-02-20 | Hinsdale | Colorado | 8053 | 17 | 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);