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 223
- Jefferson 223
- Denver 222
- Eagle 222
- El Paso 222
- Larimer 219
- Arapahoe 218
- Gunnison 218
- Pitkin 217
- Adams 215
- Clear Creek 215
- Pueblo 215
- Routt 215
- Summit 215
- Weld 215
- Mesa 214
- Boulder 213
- Garfield 213
- Yuma 210
- Crowley 209
- Grand 209
- Morgan 209
- Park 208
- San Miguel 208
- Broomfield 207
- Chaffee 207
- Elbert 207
- Hinsdale 207
- Montrose 207
- La Plata 205
- …
state 1
- Colorado · 12,591 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
625404 | 625404 | 2020-10-13 | Chaffee | Colorado | 8015 | 358 | 20 |
625405 | 625405 | 2020-10-13 | Cheyenne | Colorado | 8017 | 14 | 0 |
625406 | 625406 | 2020-10-13 | Clear Creek | Colorado | 8019 | 59 | 1 |
625407 | 625407 | 2020-10-13 | Conejos | Colorado | 8021 | 42 | 0 |
625408 | 625408 | 2020-10-13 | Costilla | Colorado | 8023 | 33 | 1 |
625409 | 625409 | 2020-10-13 | Crowley | Colorado | 8025 | 77 | 1 |
625410 | 625410 | 2020-10-13 | Custer | Colorado | 8027 | 19 | 0 |
625411 | 625411 | 2020-10-13 | Delta | Colorado | 8029 | 194 | 4 |
625412 | 625412 | 2020-10-13 | Denver | Colorado | 8031 | 15103 | 449 |
625413 | 625413 | 2020-10-13 | Dolores | Colorado | 8033 | 3 | 0 |
625414 | 625414 | 2020-10-13 | Douglas | Colorado | 8035 | 3208 | 63 |
625415 | 625415 | 2020-10-13 | Eagle | Colorado | 8037 | 1325 | 10 |
625416 | 625416 | 2020-10-13 | El Paso | Colorado | 8041 | 7897 | 188 |
625417 | 625417 | 2020-10-13 | Elbert | Colorado | 8039 | 175 | 3 |
625418 | 625418 | 2020-10-13 | Fremont | Colorado | 8043 | 273 | 1 |
625419 | 625419 | 2020-10-13 | Garfield | Colorado | 8045 | 1022 | 5 |
625420 | 625420 | 2020-10-13 | Gilpin | Colorado | 8047 | 20 | 0 |
625421 | 625421 | 2020-10-13 | Grand | Colorado | 8049 | 116 | 1 |
625422 | 625422 | 2020-10-13 | Gunnison | Colorado | 8051 | 297 | 7 |
625423 | 625423 | 2020-10-13 | Hinsdale | Colorado | 8053 | 3 | 0 |
625424 | 625424 | 2020-10-13 | Huerfano | Colorado | 8055 | 27 | 2 |
625425 | 625425 | 2020-10-13 | Jackson | Colorado | 8057 | 9 | 0 |
625426 | 625426 | 2020-10-13 | Jefferson | Colorado | 8059 | 6754 | 295 |
625427 | 625427 | 2020-10-13 | Kiowa | Colorado | 8061 | 1 | 0 |
625428 | 625428 | 2020-10-13 | Kit Carson | Colorado | 8063 | 98 | 3 |
625429 | 625429 | 2020-10-13 | La Plata | Colorado | 8067 | 301 | 2 |
625430 | 625430 | 2020-10-13 | Lake | Colorado | 8065 | 110 | 0 |
625431 | 625431 | 2020-10-13 | Larimer | Colorado | 8069 | 3217 | 55 |
625432 | 625432 | 2020-10-13 | Las Animas | Colorado | 8071 | 28 | 0 |
625433 | 625433 | 2020-10-13 | Lincoln | Colorado | 8073 | 24 | 0 |
625434 | 625434 | 2020-10-13 | Logan | Colorado | 8075 | 1025 | 9 |
625435 | 625435 | 2020-10-13 | Mesa | Colorado | 8077 | 823 | 7 |
625436 | 625436 | 2020-10-13 | Mineral | Colorado | 8079 | 20 | 0 |
625437 | 625437 | 2020-10-13 | Moffat | Colorado | 8081 | 48 | 1 |
625438 | 625438 | 2020-10-13 | Montezuma | Colorado | 8083 | 172 | 5 |
625439 | 625439 | 2020-10-13 | Montrose | Colorado | 8085 | 404 | 13 |
625440 | 625440 | 2020-10-13 | Morgan | Colorado | 8087 | 789 | 48 |
625441 | 625441 | 2020-10-13 | Otero | Colorado | 8089 | 113 | 6 |
625442 | 625442 | 2020-10-13 | Ouray | Colorado | 8091 | 32 | 1 |
625443 | 625443 | 2020-10-13 | Park | Colorado | 8093 | 64 | 1 |
625444 | 625444 | 2020-10-13 | Phillips | Colorado | 8095 | 34 | 0 |
625445 | 625445 | 2020-10-13 | Pitkin | Colorado | 8097 | 248 | 2 |
625446 | 625446 | 2020-10-13 | Prowers | Colorado | 8099 | 98 | 0 |
625447 | 625447 | 2020-10-13 | Pueblo | Colorado | 8101 | 1406 | 38 |
625448 | 625448 | 2020-10-13 | Rio Blanco | Colorado | 8103 | 25 | 0 |
625449 | 625449 | 2020-10-13 | Rio Grande | Colorado | 8105 | 109 | 2 |
625450 | 625450 | 2020-10-13 | Routt | Colorado | 8107 | 171 | 8 |
625451 | 625451 | 2020-10-13 | Saguache | Colorado | 8109 | 116 | 2 |
625452 | 625452 | 2020-10-13 | San Juan | Colorado | 8111 | 6 | 0 |
625453 | 625453 | 2020-10-13 | San Miguel | Colorado | 8113 | 97 | 0 |
625454 | 625454 | 2020-10-13 | Sedgwick | Colorado | 8115 | 16 | 1 |
625455 | 625455 | 2020-10-13 | Summit | Colorado | 8117 | 525 | 4 |
625456 | 625456 | 2020-10-13 | Teller | Colorado | 8119 | 184 | 4 |
625457 | 625457 | 2020-10-13 | Washington | Colorado | 8121 | 74 | 0 |
625458 | 625458 | 2020-10-13 | Weld | Colorado | 8123 | 5197 | 155 |
625459 | 625459 | 2020-10-13 | Yuma | Colorado | 8125 | 157 | 1 |
622153 | 622153 | 2020-10-12 | Adams | Colorado | 8001 | 10797 | 242 |
622154 | 622154 | 2020-10-12 | Alamosa | Colorado | 8003 | 265 | 9 |
622155 | 622155 | 2020-10-12 | Arapahoe | Colorado | 8005 | 10585 | 390 |
622156 | 622156 | 2020-10-12 | Archuleta | Colorado | 8007 | 58 | 0 |
622157 | 622157 | 2020-10-12 | Baca | Colorado | 8009 | 19 | 0 |
622158 | 622158 | 2020-10-12 | Bent | Colorado | 8011 | 11 | 0 |
622159 | 622159 | 2020-10-12 | Boulder | Colorado | 8013 | 4845 | 82 |
622160 | 622160 | 2020-10-12 | Broomfield | Colorado | 8014 | 743 | 37 |
622161 | 622161 | 2020-10-12 | Chaffee | Colorado | 8015 | 357 | 20 |
622162 | 622162 | 2020-10-12 | Cheyenne | Colorado | 8017 | 14 | 0 |
622163 | 622163 | 2020-10-12 | Clear Creek | Colorado | 8019 | 59 | 1 |
622164 | 622164 | 2020-10-12 | Conejos | Colorado | 8021 | 42 | 0 |
622165 | 622165 | 2020-10-12 | Costilla | Colorado | 8023 | 33 | 1 |
622166 | 622166 | 2020-10-12 | Crowley | Colorado | 8025 | 77 | 1 |
622167 | 622167 | 2020-10-12 | Custer | Colorado | 8027 | 19 | 0 |
622168 | 622168 | 2020-10-12 | Delta | Colorado | 8029 | 194 | 4 |
622169 | 622169 | 2020-10-12 | Denver | Colorado | 8031 | 14970 | 449 |
622170 | 622170 | 2020-10-12 | Dolores | Colorado | 8033 | 3 | 0 |
622171 | 622171 | 2020-10-12 | Douglas | Colorado | 8035 | 3178 | 63 |
622172 | 622172 | 2020-10-12 | Eagle | Colorado | 8037 | 1319 | 10 |
622173 | 622173 | 2020-10-12 | El Paso | Colorado | 8041 | 7838 | 187 |
622174 | 622174 | 2020-10-12 | Elbert | Colorado | 8039 | 174 | 3 |
622175 | 622175 | 2020-10-12 | Fremont | Colorado | 8043 | 240 | 1 |
622176 | 622176 | 2020-10-12 | Garfield | Colorado | 8045 | 1016 | 5 |
622177 | 622177 | 2020-10-12 | Gilpin | Colorado | 8047 | 20 | 0 |
622178 | 622178 | 2020-10-12 | Grand | Colorado | 8049 | 116 | 1 |
622179 | 622179 | 2020-10-12 | Gunnison | Colorado | 8051 | 297 | 7 |
622180 | 622180 | 2020-10-12 | Hinsdale | Colorado | 8053 | 3 | 0 |
622181 | 622181 | 2020-10-12 | Huerfano | Colorado | 8055 | 26 | 1 |
622182 | 622182 | 2020-10-12 | Jackson | Colorado | 8057 | 9 | 0 |
622183 | 622183 | 2020-10-12 | Jefferson | Colorado | 8059 | 6637 | 265 |
622184 | 622184 | 2020-10-12 | Kiowa | Colorado | 8061 | 1 | 0 |
622185 | 622185 | 2020-10-12 | Kit Carson | Colorado | 8063 | 98 | 3 |
622186 | 622186 | 2020-10-12 | La Plata | Colorado | 8067 | 301 | 2 |
622187 | 622187 | 2020-10-12 | Lake | Colorado | 8065 | 105 | 0 |
622188 | 622188 | 2020-10-12 | Larimer | Colorado | 8069 | 3159 | 55 |
622189 | 622189 | 2020-10-12 | Las Animas | Colorado | 8071 | 28 | 0 |
622190 | 622190 | 2020-10-12 | Lincoln | Colorado | 8073 | 24 | 0 |
622191 | 622191 | 2020-10-12 | Logan | Colorado | 8075 | 1012 | 9 |
622192 | 622192 | 2020-10-12 | Mesa | Colorado | 8077 | 804 | 7 |
622193 | 622193 | 2020-10-12 | Mineral | Colorado | 8079 | 20 | 0 |
622194 | 622194 | 2020-10-12 | Moffat | Colorado | 8081 | 46 | 1 |
622195 | 622195 | 2020-10-12 | Montezuma | Colorado | 8083 | 170 | 5 |
622196 | 622196 | 2020-10-12 | Montrose | Colorado | 8085 | 400 | 13 |
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);