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 362
- Jefferson 362
- Denver 361
- Eagle 361
- El Paso 361
- Arapahoe 358
- Larimer 358
- Gunnison 357
- Pitkin 357
- Adams 355
- Pueblo 355
- Routt 355
- Summit 355
- Weld 355
- Clear Creek 354
- Mesa 354
- Boulder 353
- Garfield 352
- Yuma 350
- Morgan 349
- Crowley 348
- Grand 348
- Park 348
- San Miguel 348
- Broomfield 347
- Montrose 347
- Chaffee 346
- Elbert 346
- Hinsdale 346
- Logan 345
- …
state 1
- Colorado · 21,523 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1079750 | 1079750 | 2021-03-02 | Las Animas | Colorado | 8071 | 997 | 11 |
1079751 | 1079751 | 2021-03-02 | Lincoln | Colorado | 8073 | 998 | 3 |
1079752 | 1079752 | 2021-03-02 | Logan | Colorado | 8075 | 3741 | 65 |
1079753 | 1079753 | 2021-03-02 | Mesa | Colorado | 8077 | 13368 | 199 |
1079754 | 1079754 | 2021-03-02 | Mineral | Colorado | 8079 | 61 | 1 |
1079755 | 1079755 | 2021-03-02 | Moffat | Colorado | 8081 | 676 | 22 |
1079756 | 1079756 | 2021-03-02 | Montezuma | Colorado | 8083 | 1731 | 22 |
1079757 | 1079757 | 2021-03-02 | Montrose | Colorado | 8085 | 3265 | 53 |
1079758 | 1079758 | 2021-03-02 | Morgan | Colorado | 8087 | 2433 | 90 |
1079759 | 1079759 | 2021-03-02 | Otero | Colorado | 8089 | 1865 | 62 |
1079760 | 1079760 | 2021-03-02 | Ouray | Colorado | 8091 | 258 | 3 |
1079761 | 1079761 | 2021-03-02 | Park | Colorado | 8093 | 552 | 5 |
1079762 | 1079762 | 2021-03-02 | Phillips | Colorado | 8095 | 337 | 12 |
1079763 | 1079763 | 2021-03-02 | Pitkin | Colorado | 8097 | 2031 | 4 |
1079764 | 1079764 | 2021-03-02 | Prowers | Colorado | 8099 | 1161 | 21 |
1079765 | 1079765 | 2021-03-02 | Pueblo | Colorado | 8101 | 15058 | 363 |
1079766 | 1079766 | 2021-03-02 | Rio Blanco | Colorado | 8103 | 475 | 3 |
1079767 | 1079767 | 2021-03-02 | Rio Grande | Colorado | 8105 | 705 | 13 |
1079768 | 1079768 | 2021-03-02 | Routt | Colorado | 8107 | 1896 | 19 |
1079769 | 1079769 | 2021-03-02 | Saguache | Colorado | 8109 | 323 | 4 |
1079770 | 1079770 | 2021-03-02 | San Juan | Colorado | 8111 | 43 | 0 |
1079771 | 1079771 | 2021-03-02 | San Miguel | Colorado | 8113 | 821 | 0 |
1079772 | 1079772 | 2021-03-02 | Sedgwick | Colorado | 8115 | 191 | 2 |
1079773 | 1079773 | 2021-03-02 | Summit | Colorado | 8117 | 3047 | 7 |
1079774 | 1079774 | 2021-03-02 | Teller | Colorado | 8119 | 1275 | 14 |
1079775 | 1079775 | 2021-03-02 | Washington | Colorado | 8121 | 389 | 12 |
1079776 | 1079776 | 2021-03-02 | Weld | Colorado | 8123 | 25645 | 319 |
1079777 | 1079777 | 2021-03-02 | Yuma | Colorado | 8125 | 716 | 17 |
1076469 | 1076469 | 2021-03-01 | Adams | Colorado | 8001 | 49444 | 628 |
1076470 | 1076470 | 2021-03-01 | Alamosa | Colorado | 8003 | 1286 | 28 |
1076471 | 1076471 | 2021-03-01 | Arapahoe | Colorado | 8005 | 49560 | 695 |
1076472 | 1076472 | 2021-03-01 | Archuleta | Colorado | 8007 | 650 | 1 |
1076473 | 1076473 | 2021-03-01 | Baca | Colorado | 8009 | 272 | 4 |
1076474 | 1076474 | 2021-03-01 | Bent | Colorado | 8011 | 1479 | 21 |
1076475 | 1076475 | 2021-03-01 | Boulder | Colorado | 8013 | 18965 | 246 |
1076476 | 1076476 | 2021-03-01 | Broomfield | Colorado | 8014 | 3759 | 74 |
1076477 | 1076477 | 2021-03-01 | Chaffee | Colorado | 8015 | 1454 | 24 |
1076478 | 1076478 | 2021-03-01 | Cheyenne | Colorado | 8017 | 125 | 5 |
1076479 | 1076479 | 2021-03-01 | Clear Creek | Colorado | 8019 | 363 | 2 |
1076480 | 1076480 | 2021-03-01 | Conejos | Colorado | 8021 | 442 | 9 |
1076481 | 1076481 | 2021-03-01 | Costilla | Colorado | 8023 | 187 | 2 |
1076482 | 1076482 | 2021-03-01 | Crowley | Colorado | 8025 | 2048 | 14 |
1076483 | 1076483 | 2021-03-01 | Custer | Colorado | 8027 | 164 | 1 |
1076484 | 1076484 | 2021-03-01 | Delta | Colorado | 8029 | 2473 | 60 |
1076485 | 1076485 | 2021-03-01 | Denver | Colorado | 8031 | 59779 | 768 |
1076486 | 1076486 | 2021-03-01 | Dolores | Colorado | 8033 | 68 | 0 |
1076487 | 1076487 | 2021-03-01 | Douglas | Colorado | 8035 | 21894 | 230 |
1076488 | 1076488 | 2021-03-01 | Eagle | Colorado | 8037 | 5088 | 20 |
1076489 | 1076489 | 2021-03-01 | El Paso | Colorado | 8041 | 52145 | 746 |
1076490 | 1076490 | 2021-03-01 | Elbert | Colorado | 8039 | 1288 | 12 |
1076491 | 1076491 | 2021-03-01 | Fremont | Colorado | 8043 | 5473 | 50 |
1076492 | 1076492 | 2021-03-01 | Garfield | Colorado | 8045 | 5110 | 38 |
1076493 | 1076493 | 2021-03-01 | Gilpin | Colorado | 8047 | 168 | 3 |
1076494 | 1076494 | 2021-03-01 | Grand | Colorado | 8049 | 1272 | 5 |
1076495 | 1076495 | 2021-03-01 | Gunnison | Colorado | 8051 | 1203 | 6 |
1076496 | 1076496 | 2021-03-01 | Hinsdale | Colorado | 8053 | 17 | 0 |
1076497 | 1076497 | 2021-03-01 | Huerfano | Colorado | 8055 | 310 | 16 |
1076498 | 1076498 | 2021-03-01 | Jackson | Colorado | 8057 | 51 | 0 |
1076499 | 1076499 | 2021-03-01 | Jefferson | Colorado | 8059 | 37323 | 720 |
1076500 | 1076500 | 2021-03-01 | Kiowa | Colorado | 8061 | 91 | 3 |
1076501 | 1076501 | 2021-03-01 | Kit Carson | Colorado | 8063 | 536 | 10 |
1076502 | 1076502 | 2021-03-01 | La Plata | Colorado | 8067 | 2980 | 37 |
1076503 | 1076503 | 2021-03-01 | Lake | Colorado | 8065 | 659 | 0 |
1076504 | 1076504 | 2021-03-01 | Larimer | Colorado | 8069 | 20153 | 222 |
1076505 | 1076505 | 2021-03-01 | Las Animas | Colorado | 8071 | 997 | 11 |
1076506 | 1076506 | 2021-03-01 | Lincoln | Colorado | 8073 | 998 | 3 |
1076507 | 1076507 | 2021-03-01 | Logan | Colorado | 8075 | 3740 | 65 |
1076508 | 1076508 | 2021-03-01 | Mesa | Colorado | 8077 | 13355 | 199 |
1076509 | 1076509 | 2021-03-01 | Mineral | Colorado | 8079 | 61 | 1 |
1076510 | 1076510 | 2021-03-01 | Moffat | Colorado | 8081 | 672 | 22 |
1076511 | 1076511 | 2021-03-01 | Montezuma | Colorado | 8083 | 1731 | 22 |
1076512 | 1076512 | 2021-03-01 | Montrose | Colorado | 8085 | 3250 | 53 |
1076513 | 1076513 | 2021-03-01 | Morgan | Colorado | 8087 | 2434 | 90 |
1076514 | 1076514 | 2021-03-01 | Otero | Colorado | 8089 | 1865 | 62 |
1076515 | 1076515 | 2021-03-01 | Ouray | Colorado | 8091 | 258 | 3 |
1076516 | 1076516 | 2021-03-01 | Park | Colorado | 8093 | 551 | 5 |
1076517 | 1076517 | 2021-03-01 | Phillips | Colorado | 8095 | 337 | 12 |
1076518 | 1076518 | 2021-03-01 | Pitkin | Colorado | 8097 | 2018 | 4 |
1076519 | 1076519 | 2021-03-01 | Prowers | Colorado | 8099 | 1160 | 21 |
1076520 | 1076520 | 2021-03-01 | Pueblo | Colorado | 8101 | 15046 | 363 |
1076521 | 1076521 | 2021-03-01 | Rio Blanco | Colorado | 8103 | 473 | 3 |
1076522 | 1076522 | 2021-03-01 | Rio Grande | Colorado | 8105 | 702 | 13 |
1076523 | 1076523 | 2021-03-01 | Routt | Colorado | 8107 | 1890 | 19 |
1076524 | 1076524 | 2021-03-01 | Saguache | Colorado | 8109 | 320 | 4 |
1076525 | 1076525 | 2021-03-01 | San Juan | Colorado | 8111 | 42 | 0 |
1076526 | 1076526 | 2021-03-01 | San Miguel | Colorado | 8113 | 821 | 0 |
1076527 | 1076527 | 2021-03-01 | Sedgwick | Colorado | 8115 | 191 | 2 |
1076528 | 1076528 | 2021-03-01 | Summit | Colorado | 8117 | 3036 | 7 |
1076529 | 1076529 | 2021-03-01 | Teller | Colorado | 8119 | 1275 | 14 |
1076530 | 1076530 | 2021-03-01 | Washington | Colorado | 8121 | 387 | 12 |
1076531 | 1076531 | 2021-03-01 | Weld | Colorado | 8123 | 25585 | 319 |
1076532 | 1076532 | 2021-03-01 | Yuma | Colorado | 8125 | 712 | 17 |
1073223 | 1073223 | 2021-02-28 | Adams | Colorado | 8001 | 49369 | 628 |
1073224 | 1073224 | 2021-02-28 | Alamosa | Colorado | 8003 | 1278 | 28 |
1073225 | 1073225 | 2021-02-28 | Arapahoe | Colorado | 8005 | 49453 | 695 |
1073226 | 1073226 | 2021-02-28 | Archuleta | Colorado | 8007 | 649 | 1 |
1073227 | 1073227 | 2021-02-28 | Baca | Colorado | 8009 | 271 | 4 |
1073228 | 1073228 | 2021-02-28 | Bent | Colorado | 8011 | 1477 | 21 |
1073229 | 1073229 | 2021-02-28 | Boulder | Colorado | 8013 | 18945 | 246 |
1073230 | 1073230 | 2021-02-28 | Broomfield | Colorado | 8014 | 3737 | 74 |
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);