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 559
- Jefferson 559
- Denver 558
- Eagle 558
- El Paso 558
- Arapahoe 555
- Larimer 555
- Gunnison 554
- Pitkin 553
- Adams 552
- Clear Creek 551
- Pueblo 551
- Routt 551
- Summit 551
- Weld 551
- Boulder 550
- Mesa 550
- Garfield 549
- Yuma 546
- Crowley 545
- Grand 545
- Morgan 545
- Broomfield 544
- Park 544
- San Miguel 544
- Chaffee 543
- Elbert 543
- Hinsdale 543
- Montrose 543
- La Plata 541
- …
state 1
- Colorado · 34,103 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716137 | 1716137 | 2021-09-14 | Adams | Colorado | 8001 | 69856 | 819 |
1716138 | 1716138 | 2021-09-14 | Alamosa | Colorado | 8003 | 2000 | 42 |
1716139 | 1716139 | 2021-09-14 | Arapahoe | Colorado | 8005 | 72899 | 866 |
1716140 | 1716140 | 2021-09-14 | Archuleta | Colorado | 8007 | 1305 | 3 |
1716141 | 1716141 | 2021-09-14 | Baca | Colorado | 8009 | 371 | 5 |
1716142 | 1716142 | 2021-09-14 | Bent | Colorado | 8011 | 1580 | 22 |
1716143 | 1716143 | 2021-09-14 | Boulder | Colorado | 8013 | 27588 | 267 |
1716144 | 1716144 | 2021-09-14 | Broomfield | Colorado | 8014 | 5883 | 77 |
1716145 | 1716145 | 2021-09-14 | Chaffee | Colorado | 8015 | 2010 | 26 |
1716146 | 1716146 | 2021-09-14 | Cheyenne | Colorado | 8017 | 148 | 7 |
1716147 | 1716147 | 2021-09-14 | Clear Creek | Colorado | 8019 | 649 | 4 |
1716148 | 1716148 | 2021-09-14 | Conejos | Colorado | 8021 | 818 | 28 |
1716149 | 1716149 | 2021-09-14 | Costilla | Colorado | 8023 | 297 | 6 |
1716150 | 1716150 | 2021-09-14 | Crowley | Colorado | 8025 | 2242 | 18 |
1716151 | 1716151 | 2021-09-14 | Custer | Colorado | 8027 | 274 | 6 |
1716152 | 1716152 | 2021-09-14 | Delta | Colorado | 8029 | 3336 | 78 |
1716153 | 1716153 | 2021-09-14 | Denver | Colorado | 8031 | 83127 | 884 |
1716154 | 1716154 | 2021-09-14 | Dolores | Colorado | 8033 | 157 | 1 |
1716155 | 1716155 | 2021-09-14 | Douglas | Colorado | 8035 | 36357 | 280 |
1716156 | 1716156 | 2021-09-14 | Eagle | Colorado | 8037 | 7640 | 29 |
1716157 | 1716157 | 2021-09-14 | El Paso | Colorado | 8041 | 86922 | 970 |
1716158 | 1716158 | 2021-09-14 | Elbert | Colorado | 8039 | 2251 | 18 |
1716159 | 1716159 | 2021-09-14 | Fremont | Colorado | 8043 | 7070 | 71 |
1716160 | 1716160 | 2021-09-14 | Garfield | Colorado | 8045 | 6993 | 58 |
1716161 | 1716161 | 2021-09-14 | Gilpin | Colorado | 8047 | 359 | 3 |
1716162 | 1716162 | 2021-09-14 | Grand | Colorado | 8049 | 1780 | 8 |
1716163 | 1716163 | 2021-09-14 | Gunnison | Colorado | 8051 | 1657 | 8 |
1716164 | 1716164 | 2021-09-14 | Hinsdale | Colorado | 8053 | 52 | 0 |
1716165 | 1716165 | 2021-09-14 | Huerfano | Colorado | 8055 | 530 | 17 |
1716166 | 1716166 | 2021-09-14 | Jackson | Colorado | 8057 | 74 | 0 |
1716167 | 1716167 | 2021-09-14 | Jefferson | Colorado | 8059 | 55675 | 848 |
1716168 | 1716168 | 2021-09-14 | Kiowa | Colorado | 8061 | 113 | 3 |
1716169 | 1716169 | 2021-09-14 | Kit Carson | Colorado | 8063 | 809 | 14 |
1716170 | 1716170 | 2021-09-14 | La Plata | Colorado | 8067 | 4875 | 48 |
1716171 | 1716171 | 2021-09-14 | Lake | Colorado | 8065 | 938 | 1 |
1716172 | 1716172 | 2021-09-14 | Larimer | Colorado | 8069 | 33364 | 268 |
1716173 | 1716173 | 2021-09-14 | Las Animas | Colorado | 8071 | 1567 | 19 |
1716174 | 1716174 | 2021-09-14 | Lincoln | Colorado | 8073 | 1165 | 6 |
1716175 | 1716175 | 2021-09-14 | Logan | Colorado | 8075 | 4304 | 72 |
1716176 | 1716176 | 2021-09-14 | Mesa | Colorado | 8077 | 20299 | 286 |
1716177 | 1716177 | 2021-09-14 | Mineral | Colorado | 8079 | 105 | 1 |
1716178 | 1716178 | 2021-09-14 | Moffat | Colorado | 8081 | 1484 | 30 |
1716179 | 1716179 | 2021-09-14 | Montezuma | Colorado | 8083 | 2458 | 33 |
1716180 | 1716180 | 2021-09-14 | Montrose | Colorado | 8085 | 4442 | 75 |
1716181 | 1716181 | 2021-09-14 | Morgan | Colorado | 8087 | 3030 | 97 |
1716182 | 1716182 | 2021-09-14 | Otero | Colorado | 8089 | 2252 | 71 |
1716183 | 1716183 | 2021-09-14 | Ouray | Colorado | 8091 | 368 | 5 |
1716184 | 1716184 | 2021-09-14 | Park | Colorado | 8093 | 1090 | 7 |
1716185 | 1716185 | 2021-09-14 | Phillips | Colorado | 8095 | 445 | 14 |
1716186 | 1716186 | 2021-09-14 | Pitkin | Colorado | 8097 | 2918 | 4 |
1716187 | 1716187 | 2021-09-14 | Prowers | Colorado | 8099 | 1417 | 25 |
1716188 | 1716188 | 2021-09-14 | Pueblo | Colorado | 8101 | 21636 | 448 |
1716189 | 1716189 | 2021-09-14 | Rio Blanco | Colorado | 8103 | 801 | 7 |
1716190 | 1716190 | 2021-09-14 | Rio Grande | Colorado | 8105 | 1103 | 20 |
1716191 | 1716191 | 2021-09-14 | Routt | Colorado | 8107 | 2906 | 22 |
1716192 | 1716192 | 2021-09-14 | Saguache | Colorado | 8109 | 523 | 8 |
1716193 | 1716193 | 2021-09-14 | San Juan | Colorado | 8111 | 86 | 1 |
1716194 | 1716194 | 2021-09-14 | San Miguel | Colorado | 8113 | 1072 | 3 |
1716195 | 1716195 | 2021-09-14 | Sedgwick | Colorado | 8115 | 266 | 4 |
1716196 | 1716196 | 2021-09-14 | Summit | Colorado | 8117 | 4410 | 9 |
1716197 | 1716197 | 2021-09-14 | Teller | Colorado | 8119 | 2227 | 21 |
1716198 | 1716198 | 2021-09-14 | Washington | Colorado | 8121 | 505 | 14 |
1716199 | 1716199 | 2021-09-14 | Weld | Colorado | 8123 | 39804 | 375 |
1716200 | 1716200 | 2021-09-14 | Yuma | Colorado | 8125 | 1037 | 18 |
1712891 | 1712891 | 2021-09-13 | Adams | Colorado | 8001 | 69515 | 817 |
1712892 | 1712892 | 2021-09-13 | Alamosa | Colorado | 8003 | 1999 | 41 |
1712893 | 1712893 | 2021-09-13 | Arapahoe | Colorado | 8005 | 72484 | 865 |
1712894 | 1712894 | 2021-09-13 | Archuleta | Colorado | 8007 | 1299 | 3 |
1712895 | 1712895 | 2021-09-13 | Baca | Colorado | 8009 | 369 | 5 |
1712896 | 1712896 | 2021-09-13 | Bent | Colorado | 8011 | 1578 | 22 |
1712897 | 1712897 | 2021-09-13 | Boulder | Colorado | 8013 | 27495 | 267 |
1712898 | 1712898 | 2021-09-13 | Broomfield | Colorado | 8014 | 5855 | 77 |
1712899 | 1712899 | 2021-09-13 | Chaffee | Colorado | 8015 | 2007 | 26 |
1712900 | 1712900 | 2021-09-13 | Cheyenne | Colorado | 8017 | 148 | 7 |
1712901 | 1712901 | 2021-09-13 | Clear Creek | Colorado | 8019 | 645 | 4 |
1712902 | 1712902 | 2021-09-13 | Conejos | Colorado | 8021 | 815 | 27 |
1712903 | 1712903 | 2021-09-13 | Costilla | Colorado | 8023 | 294 | 6 |
1712904 | 1712904 | 2021-09-13 | Crowley | Colorado | 8025 | 2241 | 18 |
1712905 | 1712905 | 2021-09-13 | Custer | Colorado | 8027 | 273 | 6 |
1712906 | 1712906 | 2021-09-13 | Delta | Colorado | 8029 | 3330 | 76 |
1712907 | 1712907 | 2021-09-13 | Denver | Colorado | 8031 | 82961 | 882 |
1712908 | 1712908 | 2021-09-13 | Dolores | Colorado | 8033 | 156 | 1 |
1712909 | 1712909 | 2021-09-13 | Douglas | Colorado | 8035 | 36110 | 279 |
1712910 | 1712910 | 2021-09-13 | Eagle | Colorado | 8037 | 7621 | 29 |
1712911 | 1712911 | 2021-09-13 | El Paso | Colorado | 8041 | 86531 | 968 |
1712912 | 1712912 | 2021-09-13 | Elbert | Colorado | 8039 | 2241 | 18 |
1712913 | 1712913 | 2021-09-13 | Fremont | Colorado | 8043 | 7052 | 71 |
1712914 | 1712914 | 2021-09-13 | Garfield | Colorado | 8045 | 6973 | 58 |
1712915 | 1712915 | 2021-09-13 | Gilpin | Colorado | 8047 | 352 | 3 |
1712916 | 1712916 | 2021-09-13 | Grand | Colorado | 8049 | 1773 | 8 |
1712917 | 1712917 | 2021-09-13 | Gunnison | Colorado | 8051 | 1651 | 8 |
1712918 | 1712918 | 2021-09-13 | Hinsdale | Colorado | 8053 | 51 | 0 |
1712919 | 1712919 | 2021-09-13 | Huerfano | Colorado | 8055 | 525 | 17 |
1712920 | 1712920 | 2021-09-13 | Jackson | Colorado | 8057 | 74 | 0 |
1712921 | 1712921 | 2021-09-13 | Jefferson | Colorado | 8059 | 55529 | 844 |
1712922 | 1712922 | 2021-09-13 | Kiowa | Colorado | 8061 | 112 | 3 |
1712923 | 1712923 | 2021-09-13 | Kit Carson | Colorado | 8063 | 802 | 14 |
1712924 | 1712924 | 2021-09-13 | La Plata | Colorado | 8067 | 4863 | 48 |
1712925 | 1712925 | 2021-09-13 | Lake | Colorado | 8065 | 936 | 1 |
1712926 | 1712926 | 2021-09-13 | Larimer | Colorado | 8069 | 33250 | 267 |
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);