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 195
- Jefferson 195
- Denver 194
- Eagle 194
- El Paso 194
- Arapahoe 191
- Larimer 191
- Gunnison 190
- Pitkin 189
- Adams 188
- Clear Creek 187
- Pueblo 187
- Routt 187
- Summit 187
- Weld 187
- Boulder 186
- Mesa 186
- Garfield 185
- Yuma 182
- Crowley 181
- Grand 181
- Morgan 181
- Broomfield 180
- Park 180
- San Miguel 180
- Chaffee 179
- Elbert 179
- Hinsdale 179
- Montrose 179
- La Plata 177
- …
state 1
- Colorado · 10,815 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534667 | 534667 | 2020-09-15 | Adams | Colorado | 8001 | 8206 | 213 |
534668 | 534668 | 2020-09-15 | Alamosa | Colorado | 8003 | 240 | 9 |
534669 | 534669 | 2020-09-15 | Arapahoe | Colorado | 8005 | 8748 | 370 |
534670 | 534670 | 2020-09-15 | Archuleta | Colorado | 8007 | 48 | 0 |
534671 | 534671 | 2020-09-15 | Baca | Colorado | 8009 | 17 | 0 |
534672 | 534672 | 2020-09-15 | Bent | Colorado | 8011 | 11 | 0 |
534673 | 534673 | 2020-09-15 | Boulder | Colorado | 8013 | 2989 | 79 |
534674 | 534674 | 2020-09-15 | Broomfield | Colorado | 8014 | 572 | 33 |
534675 | 534675 | 2020-09-15 | Chaffee | Colorado | 8015 | 319 | 19 |
534676 | 534676 | 2020-09-15 | Cheyenne | Colorado | 8017 | 10 | 0 |
534677 | 534677 | 2020-09-15 | Clear Creek | Colorado | 8019 | 36 | 1 |
534678 | 534678 | 2020-09-15 | Conejos | Colorado | 8021 | 31 | 0 |
534679 | 534679 | 2020-09-15 | Costilla | Colorado | 8023 | 32 | 1 |
534680 | 534680 | 2020-09-15 | Crowley | Colorado | 8025 | 73 | 1 |
534681 | 534681 | 2020-09-15 | Custer | Colorado | 8027 | 17 | 0 |
534682 | 534682 | 2020-09-15 | Delta | Colorado | 8029 | 176 | 3 |
534683 | 534683 | 2020-09-15 | Denver | Colorado | 8031 | 11976 | 437 |
534684 | 534684 | 2020-09-15 | Dolores | Colorado | 8033 | 3 | 0 |
534685 | 534685 | 2020-09-15 | Douglas | Colorado | 8035 | 2350 | 60 |
534686 | 534686 | 2020-09-15 | Eagle | Colorado | 8037 | 1215 | 9 |
534687 | 534687 | 2020-09-15 | El Paso | Colorado | 8041 | 6522 | 163 |
534688 | 534688 | 2020-09-15 | Elbert | Colorado | 8039 | 141 | 3 |
534689 | 534689 | 2020-09-15 | Fremont | Colorado | 8043 | 167 | 1 |
534690 | 534690 | 2020-09-15 | Garfield | Colorado | 8045 | 900 | 5 |
534691 | 534691 | 2020-09-15 | Gilpin | Colorado | 8047 | 18 | 0 |
534692 | 534692 | 2020-09-15 | Grand | Colorado | 8049 | 69 | 1 |
534693 | 534693 | 2020-09-15 | Gunnison | Colorado | 8051 | 296 | 7 |
534694 | 534694 | 2020-09-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
534695 | 534695 | 2020-09-15 | Huerfano | Colorado | 8055 | 10 | 1 |
534696 | 534696 | 2020-09-15 | Jackson | Colorado | 8057 | 9 | 0 |
534697 | 534697 | 2020-09-15 | Jefferson | Colorado | 8059 | 5160 | 246 |
534698 | 534698 | 2020-09-15 | Kit Carson | Colorado | 8063 | 78 | 3 |
534699 | 534699 | 2020-09-15 | La Plata | Colorado | 8067 | 248 | 2 |
534700 | 534700 | 2020-09-15 | Lake | Colorado | 8065 | 87 | 0 |
534701 | 534701 | 2020-09-15 | Larimer | Colorado | 8069 | 2220 | 47 |
534702 | 534702 | 2020-09-15 | Las Animas | Colorado | 8071 | 21 | 0 |
534703 | 534703 | 2020-09-15 | Lincoln | Colorado | 8073 | 8 | 0 |
534704 | 534704 | 2020-09-15 | Logan | Colorado | 8075 | 792 | 5 |
534705 | 534705 | 2020-09-15 | Mesa | Colorado | 8077 | 500 | 6 |
534706 | 534706 | 2020-09-15 | Mineral | Colorado | 8079 | 20 | 0 |
534707 | 534707 | 2020-09-15 | Moffat | Colorado | 8081 | 38 | 1 |
534708 | 534708 | 2020-09-15 | Montezuma | Colorado | 8083 | 128 | 5 |
534709 | 534709 | 2020-09-15 | Montrose | Colorado | 8085 | 358 | 13 |
534710 | 534710 | 2020-09-15 | Morgan | Colorado | 8087 | 726 | 48 |
534711 | 534711 | 2020-09-15 | Otero | Colorado | 8089 | 84 | 6 |
534712 | 534712 | 2020-09-15 | Ouray | Colorado | 8091 | 25 | 1 |
534713 | 534713 | 2020-09-15 | Park | Colorado | 8093 | 46 | 1 |
534714 | 534714 | 2020-09-15 | Phillips | Colorado | 8095 | 32 | 0 |
534715 | 534715 | 2020-09-15 | Pitkin | Colorado | 8097 | 208 | 2 |
534716 | 534716 | 2020-09-15 | Prowers | Colorado | 8099 | 91 | 0 |
534717 | 534717 | 2020-09-15 | Pueblo | Colorado | 8101 | 989 | 34 |
534718 | 534718 | 2020-09-15 | Rio Blanco | Colorado | 8103 | 24 | 0 |
534719 | 534719 | 2020-09-15 | Rio Grande | Colorado | 8105 | 95 | 2 |
534720 | 534720 | 2020-09-15 | Routt | Colorado | 8107 | 139 | 8 |
534721 | 534721 | 2020-09-15 | Saguache | Colorado | 8109 | 111 | 2 |
534722 | 534722 | 2020-09-15 | San Juan | Colorado | 8111 | 6 | 0 |
534723 | 534723 | 2020-09-15 | San Miguel | Colorado | 8113 | 93 | 0 |
534724 | 534724 | 2020-09-15 | Sedgwick | Colorado | 8115 | 12 | 1 |
534725 | 534725 | 2020-09-15 | Summit | Colorado | 8117 | 377 | 4 |
534726 | 534726 | 2020-09-15 | Teller | Colorado | 8119 | 168 | 4 |
534727 | 534727 | 2020-09-15 | Washington | Colorado | 8121 | 56 | 0 |
534728 | 534728 | 2020-09-15 | Weld | Colorado | 8123 | 4356 | 149 |
534729 | 534729 | 2020-09-15 | Yuma | Colorado | 8125 | 75 | 0 |
531432 | 531432 | 2020-09-14 | Adams | Colorado | 8001 | 8143 | 211 |
531433 | 531433 | 2020-09-14 | Alamosa | Colorado | 8003 | 240 | 9 |
531434 | 531434 | 2020-09-14 | Arapahoe | Colorado | 8005 | 8692 | 370 |
531435 | 531435 | 2020-09-14 | Archuleta | Colorado | 8007 | 48 | 0 |
531436 | 531436 | 2020-09-14 | Baca | Colorado | 8009 | 17 | 0 |
531437 | 531437 | 2020-09-14 | Bent | Colorado | 8011 | 11 | 0 |
531438 | 531438 | 2020-09-14 | Boulder | Colorado | 8013 | 2877 | 79 |
531439 | 531439 | 2020-09-14 | Broomfield | Colorado | 8014 | 571 | 33 |
531440 | 531440 | 2020-09-14 | Chaffee | Colorado | 8015 | 318 | 19 |
531441 | 531441 | 2020-09-14 | Cheyenne | Colorado | 8017 | 10 | 0 |
531442 | 531442 | 2020-09-14 | Clear Creek | Colorado | 8019 | 36 | 1 |
531443 | 531443 | 2020-09-14 | Conejos | Colorado | 8021 | 31 | 0 |
531444 | 531444 | 2020-09-14 | Costilla | Colorado | 8023 | 32 | 1 |
531445 | 531445 | 2020-09-14 | Crowley | Colorado | 8025 | 73 | 1 |
531446 | 531446 | 2020-09-14 | Custer | Colorado | 8027 | 17 | 0 |
531447 | 531447 | 2020-09-14 | Delta | Colorado | 8029 | 175 | 3 |
531448 | 531448 | 2020-09-14 | Denver | Colorado | 8031 | 11883 | 437 |
531449 | 531449 | 2020-09-14 | Dolores | Colorado | 8033 | 3 | 0 |
531450 | 531450 | 2020-09-14 | Douglas | Colorado | 8035 | 2326 | 60 |
531451 | 531451 | 2020-09-14 | Eagle | Colorado | 8037 | 1210 | 9 |
531452 | 531452 | 2020-09-14 | El Paso | Colorado | 8041 | 6444 | 162 |
531453 | 531453 | 2020-09-14 | Elbert | Colorado | 8039 | 140 | 2 |
531454 | 531454 | 2020-09-14 | Fremont | Colorado | 8043 | 167 | 1 |
531455 | 531455 | 2020-09-14 | Garfield | Colorado | 8045 | 892 | 5 |
531456 | 531456 | 2020-09-14 | Gilpin | Colorado | 8047 | 18 | 0 |
531457 | 531457 | 2020-09-14 | Grand | Colorado | 8049 | 69 | 1 |
531458 | 531458 | 2020-09-14 | Gunnison | Colorado | 8051 | 296 | 7 |
531459 | 531459 | 2020-09-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
531460 | 531460 | 2020-09-14 | Huerfano | Colorado | 8055 | 10 | 1 |
531461 | 531461 | 2020-09-14 | Jackson | Colorado | 8057 | 9 | 0 |
531462 | 531462 | 2020-09-14 | Jefferson | Colorado | 8059 | 5146 | 245 |
531463 | 531463 | 2020-09-14 | Kit Carson | Colorado | 8063 | 78 | 3 |
531464 | 531464 | 2020-09-14 | La Plata | Colorado | 8067 | 247 | 2 |
531465 | 531465 | 2020-09-14 | Lake | Colorado | 8065 | 87 | 0 |
531466 | 531466 | 2020-09-14 | Larimer | Colorado | 8069 | 2204 | 46 |
531467 | 531467 | 2020-09-14 | Las Animas | Colorado | 8071 | 21 | 0 |
531468 | 531468 | 2020-09-14 | 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);