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 191
- Jefferson 191
- Denver 190
- Eagle 190
- El Paso 190
- Arapahoe 187
- Larimer 187
- Gunnison 186
- Pitkin 185
- Adams 184
- Clear Creek 183
- Pueblo 183
- Routt 183
- Summit 183
- Weld 183
- Boulder 182
- Mesa 182
- Garfield 181
- Yuma 178
- Crowley 177
- Grand 177
- Morgan 177
- Broomfield 176
- Park 176
- San Miguel 176
- Chaffee 175
- Elbert 175
- Hinsdale 175
- Montrose 175
- La Plata 173
- …
state 1
- Colorado · 10,563 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
521723 | 521723 | 2020-09-11 | Adams | Colorado | 8001 | 8025 | 211 |
521724 | 521724 | 2020-09-11 | Alamosa | Colorado | 8003 | 240 | 9 |
521725 | 521725 | 2020-09-11 | Arapahoe | Colorado | 8005 | 8575 | 370 |
521726 | 521726 | 2020-09-11 | Archuleta | Colorado | 8007 | 48 | 0 |
521727 | 521727 | 2020-09-11 | Baca | Colorado | 8009 | 17 | 0 |
521728 | 521728 | 2020-09-11 | Bent | Colorado | 8011 | 11 | 0 |
521729 | 521729 | 2020-09-11 | Boulder | Colorado | 8013 | 2671 | 79 |
521730 | 521730 | 2020-09-11 | Broomfield | Colorado | 8014 | 555 | 33 |
521731 | 521731 | 2020-09-11 | Chaffee | Colorado | 8015 | 318 | 19 |
521732 | 521732 | 2020-09-11 | Cheyenne | Colorado | 8017 | 9 | 0 |
521733 | 521733 | 2020-09-11 | Clear Creek | Colorado | 8019 | 36 | 1 |
521734 | 521734 | 2020-09-11 | Conejos | Colorado | 8021 | 31 | 0 |
521735 | 521735 | 2020-09-11 | Costilla | Colorado | 8023 | 32 | 1 |
521736 | 521736 | 2020-09-11 | Crowley | Colorado | 8025 | 73 | 1 |
521737 | 521737 | 2020-09-11 | Custer | Colorado | 8027 | 17 | 0 |
521738 | 521738 | 2020-09-11 | Delta | Colorado | 8029 | 175 | 2 |
521739 | 521739 | 2020-09-11 | Denver | Colorado | 8031 | 11685 | 434 |
521740 | 521740 | 2020-09-11 | Dolores | Colorado | 8033 | 2 | 0 |
521741 | 521741 | 2020-09-11 | Douglas | Colorado | 8035 | 2287 | 60 |
521742 | 521742 | 2020-09-11 | Eagle | Colorado | 8037 | 1203 | 9 |
521743 | 521743 | 2020-09-11 | El Paso | Colorado | 8041 | 6342 | 160 |
521744 | 521744 | 2020-09-11 | Elbert | Colorado | 8039 | 136 | 2 |
521745 | 521745 | 2020-09-11 | Fremont | Colorado | 8043 | 166 | 1 |
521746 | 521746 | 2020-09-11 | Garfield | Colorado | 8045 | 884 | 5 |
521747 | 521747 | 2020-09-11 | Gilpin | Colorado | 8047 | 18 | 0 |
521748 | 521748 | 2020-09-11 | Grand | Colorado | 8049 | 69 | 1 |
521749 | 521749 | 2020-09-11 | Gunnison | Colorado | 8051 | 296 | 7 |
521750 | 521750 | 2020-09-11 | Hinsdale | Colorado | 8053 | 3 | 0 |
521751 | 521751 | 2020-09-11 | Huerfano | Colorado | 8055 | 10 | 1 |
521752 | 521752 | 2020-09-11 | Jackson | Colorado | 8057 | 9 | 0 |
521753 | 521753 | 2020-09-11 | Jefferson | Colorado | 8059 | 5052 | 244 |
521754 | 521754 | 2020-09-11 | Kit Carson | Colorado | 8063 | 76 | 3 |
521755 | 521755 | 2020-09-11 | La Plata | Colorado | 8067 | 247 | 2 |
521756 | 521756 | 2020-09-11 | Lake | Colorado | 8065 | 85 | 0 |
521757 | 521757 | 2020-09-11 | Larimer | Colorado | 8069 | 2137 | 45 |
521758 | 521758 | 2020-09-11 | Las Animas | Colorado | 8071 | 21 | 0 |
521759 | 521759 | 2020-09-11 | Lincoln | Colorado | 8073 | 8 | 0 |
521760 | 521760 | 2020-09-11 | Logan | Colorado | 8075 | 731 | 5 |
521761 | 521761 | 2020-09-11 | Mesa | Colorado | 8077 | 485 | 5 |
521762 | 521762 | 2020-09-11 | Mineral | Colorado | 8079 | 20 | 0 |
521763 | 521763 | 2020-09-11 | Moffat | Colorado | 8081 | 35 | 1 |
521764 | 521764 | 2020-09-11 | Montezuma | Colorado | 8083 | 127 | 5 |
521765 | 521765 | 2020-09-11 | Montrose | Colorado | 8085 | 353 | 13 |
521766 | 521766 | 2020-09-11 | Morgan | Colorado | 8087 | 724 | 48 |
521767 | 521767 | 2020-09-11 | Otero | Colorado | 8089 | 83 | 6 |
521768 | 521768 | 2020-09-11 | Ouray | Colorado | 8091 | 25 | 1 |
521769 | 521769 | 2020-09-11 | Park | Colorado | 8093 | 46 | 1 |
521770 | 521770 | 2020-09-11 | Phillips | Colorado | 8095 | 29 | 0 |
521771 | 521771 | 2020-09-11 | Pitkin | Colorado | 8097 | 204 | 2 |
521772 | 521772 | 2020-09-11 | Prowers | Colorado | 8099 | 90 | 0 |
521773 | 521773 | 2020-09-11 | Pueblo | Colorado | 8101 | 965 | 34 |
521774 | 521774 | 2020-09-11 | Rio Blanco | Colorado | 8103 | 24 | 0 |
521775 | 521775 | 2020-09-11 | Rio Grande | Colorado | 8105 | 95 | 2 |
521776 | 521776 | 2020-09-11 | Routt | Colorado | 8107 | 136 | 8 |
521777 | 521777 | 2020-09-11 | Saguache | Colorado | 8109 | 111 | 2 |
521778 | 521778 | 2020-09-11 | San Juan | Colorado | 8111 | 6 | 0 |
521779 | 521779 | 2020-09-11 | San Miguel | Colorado | 8113 | 93 | 0 |
521780 | 521780 | 2020-09-11 | Sedgwick | Colorado | 8115 | 12 | 1 |
521781 | 521781 | 2020-09-11 | Summit | Colorado | 8117 | 370 | 4 |
521782 | 521782 | 2020-09-11 | Teller | Colorado | 8119 | 166 | 4 |
521783 | 521783 | 2020-09-11 | Washington | Colorado | 8121 | 55 | 0 |
521784 | 521784 | 2020-09-11 | Weld | Colorado | 8123 | 4257 | 149 |
521785 | 521785 | 2020-09-11 | Yuma | Colorado | 8125 | 70 | 0 |
518486 | 518486 | 2020-09-10 | Adams | Colorado | 8001 | 7997 | 209 |
518487 | 518487 | 2020-09-10 | Alamosa | Colorado | 8003 | 240 | 9 |
518488 | 518488 | 2020-09-10 | Arapahoe | Colorado | 8005 | 8549 | 370 |
518489 | 518489 | 2020-09-10 | Archuleta | Colorado | 8007 | 48 | 0 |
518490 | 518490 | 2020-09-10 | Baca | Colorado | 8009 | 17 | 0 |
518491 | 518491 | 2020-09-10 | Bent | Colorado | 8011 | 11 | 0 |
518492 | 518492 | 2020-09-10 | Boulder | Colorado | 8013 | 2621 | 79 |
518493 | 518493 | 2020-09-10 | Broomfield | Colorado | 8014 | 553 | 33 |
518494 | 518494 | 2020-09-10 | Chaffee | Colorado | 8015 | 318 | 19 |
518495 | 518495 | 2020-09-10 | Cheyenne | Colorado | 8017 | 9 | 0 |
518496 | 518496 | 2020-09-10 | Clear Creek | Colorado | 8019 | 36 | 1 |
518497 | 518497 | 2020-09-10 | Conejos | Colorado | 8021 | 31 | 0 |
518498 | 518498 | 2020-09-10 | Costilla | Colorado | 8023 | 32 | 1 |
518499 | 518499 | 2020-09-10 | Crowley | Colorado | 8025 | 73 | 1 |
518500 | 518500 | 2020-09-10 | Custer | Colorado | 8027 | 17 | 0 |
518501 | 518501 | 2020-09-10 | Delta | Colorado | 8029 | 172 | 2 |
518502 | 518502 | 2020-09-10 | Denver | Colorado | 8031 | 11627 | 434 |
518503 | 518503 | 2020-09-10 | Dolores | Colorado | 8033 | 2 | 0 |
518504 | 518504 | 2020-09-10 | Douglas | Colorado | 8035 | 2277 | 60 |
518505 | 518505 | 2020-09-10 | Eagle | Colorado | 8037 | 1197 | 9 |
518506 | 518506 | 2020-09-10 | El Paso | Colorado | 8041 | 6317 | 160 |
518507 | 518507 | 2020-09-10 | Elbert | Colorado | 8039 | 134 | 2 |
518508 | 518508 | 2020-09-10 | Fremont | Colorado | 8043 | 165 | 1 |
518509 | 518509 | 2020-09-10 | Garfield | Colorado | 8045 | 879 | 4 |
518510 | 518510 | 2020-09-10 | Gilpin | Colorado | 8047 | 18 | 0 |
518511 | 518511 | 2020-09-10 | Grand | Colorado | 8049 | 69 | 1 |
518512 | 518512 | 2020-09-10 | Gunnison | Colorado | 8051 | 296 | 7 |
518513 | 518513 | 2020-09-10 | Hinsdale | Colorado | 8053 | 3 | 0 |
518514 | 518514 | 2020-09-10 | Huerfano | Colorado | 8055 | 10 | 1 |
518515 | 518515 | 2020-09-10 | Jackson | Colorado | 8057 | 10 | 0 |
518516 | 518516 | 2020-09-10 | Jefferson | Colorado | 8059 | 5019 | 244 |
518517 | 518517 | 2020-09-10 | Kit Carson | Colorado | 8063 | 76 | 3 |
518518 | 518518 | 2020-09-10 | La Plata | Colorado | 8067 | 246 | 2 |
518519 | 518519 | 2020-09-10 | Lake | Colorado | 8065 | 84 | 0 |
518520 | 518520 | 2020-09-10 | Larimer | Colorado | 8069 | 2120 | 45 |
518521 | 518521 | 2020-09-10 | Las Animas | Colorado | 8071 | 20 | 0 |
518522 | 518522 | 2020-09-10 | Lincoln | Colorado | 8073 | 8 | 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);