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 353
- Jefferson 353
- Denver 352
- Eagle 352
- El Paso 352
- Arapahoe 349
- Larimer 349
- Gunnison 348
- Pitkin 348
- Adams 346
- Pueblo 346
- Routt 346
- Summit 346
- Weld 346
- Clear Creek 345
- Mesa 345
- Boulder 344
- Garfield 343
- Yuma 341
- Morgan 340
- Crowley 339
- Grand 339
- Park 339
- San Miguel 339
- Broomfield 338
- Montrose 338
- Chaffee 337
- Elbert 337
- Hinsdale 337
- Logan 336
- …
state 1
- Colorado · 20,947 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050539 | 1050539 | 2021-02-21 | Las Animas | Colorado | 8071 | 982 | 11 |
1050540 | 1050540 | 2021-02-21 | Lincoln | Colorado | 8073 | 996 | 3 |
1050541 | 1050541 | 2021-02-21 | Logan | Colorado | 8075 | 3705 | 63 |
1050542 | 1050542 | 2021-02-21 | Mesa | Colorado | 8077 | 13072 | 190 |
1050543 | 1050543 | 2021-02-21 | Mineral | Colorado | 8079 | 61 | 1 |
1050544 | 1050544 | 2021-02-21 | Moffat | Colorado | 8081 | 657 | 22 |
1050545 | 1050545 | 2021-02-21 | Montezuma | Colorado | 8083 | 1704 | 22 |
1050546 | 1050546 | 2021-02-21 | Montrose | Colorado | 8085 | 3188 | 52 |
1050547 | 1050547 | 2021-02-21 | Morgan | Colorado | 8087 | 2415 | 90 |
1050548 | 1050548 | 2021-02-21 | Otero | Colorado | 8089 | 1839 | 61 |
1050549 | 1050549 | 2021-02-21 | Ouray | Colorado | 8091 | 247 | 3 |
1050550 | 1050550 | 2021-02-21 | Park | Colorado | 8093 | 539 | 5 |
1050551 | 1050551 | 2021-02-21 | Phillips | Colorado | 8095 | 333 | 12 |
1050552 | 1050552 | 2021-02-21 | Pitkin | Colorado | 8097 | 1941 | 4 |
1050553 | 1050553 | 2021-02-21 | Prowers | Colorado | 8099 | 1157 | 21 |
1050554 | 1050554 | 2021-02-21 | Pueblo | Colorado | 8101 | 14879 | 362 |
1050555 | 1050555 | 2021-02-21 | Rio Blanco | Colorado | 8103 | 455 | 3 |
1050556 | 1050556 | 2021-02-21 | Rio Grande | Colorado | 8105 | 683 | 12 |
1050557 | 1050557 | 2021-02-21 | Routt | Colorado | 8107 | 1830 | 19 |
1050558 | 1050558 | 2021-02-21 | Saguache | Colorado | 8109 | 312 | 4 |
1050559 | 1050559 | 2021-02-21 | San Juan | Colorado | 8111 | 41 | 0 |
1050560 | 1050560 | 2021-02-21 | San Miguel | Colorado | 8113 | 803 | 0 |
1050561 | 1050561 | 2021-02-21 | Sedgwick | Colorado | 8115 | 191 | 2 |
1050562 | 1050562 | 2021-02-21 | Summit | Colorado | 8117 | 2958 | 7 |
1050563 | 1050563 | 2021-02-21 | Teller | Colorado | 8119 | 1248 | 14 |
1050564 | 1050564 | 2021-02-21 | Washington | Colorado | 8121 | 378 | 12 |
1050565 | 1050565 | 2021-02-21 | Weld | Colorado | 8123 | 25018 | 316 |
1050566 | 1050566 | 2021-02-21 | Yuma | Colorado | 8125 | 697 | 17 |
1047256 | 1047256 | 2021-02-20 | Adams | Colorado | 8001 | 48525 | 626 |
1047257 | 1047257 | 2021-02-20 | Alamosa | Colorado | 8003 | 1252 | 28 |
1047258 | 1047258 | 2021-02-20 | Arapahoe | Colorado | 8005 | 48494 | 688 |
1047259 | 1047259 | 2021-02-20 | Archuleta | Colorado | 8007 | 629 | 1 |
1047260 | 1047260 | 2021-02-20 | Baca | Colorado | 8009 | 270 | 4 |
1047261 | 1047261 | 2021-02-20 | Bent | Colorado | 8011 | 1469 | 21 |
1047262 | 1047262 | 2021-02-20 | Boulder | Colorado | 8013 | 18560 | 245 |
1047263 | 1047263 | 2021-02-20 | Broomfield | Colorado | 8014 | 3646 | 74 |
1047264 | 1047264 | 2021-02-20 | Chaffee | Colorado | 8015 | 1411 | 23 |
1047265 | 1047265 | 2021-02-20 | Cheyenne | Colorado | 8017 | 125 | 5 |
1047266 | 1047266 | 2021-02-20 | Clear Creek | Colorado | 8019 | 356 | 2 |
1047267 | 1047267 | 2021-02-20 | Conejos | Colorado | 8021 | 430 | 7 |
1047268 | 1047268 | 2021-02-20 | Costilla | Colorado | 8023 | 178 | 2 |
1047269 | 1047269 | 2021-02-20 | Crowley | Colorado | 8025 | 1957 | 14 |
1047270 | 1047270 | 2021-02-20 | Custer | Colorado | 8027 | 164 | 1 |
1047271 | 1047271 | 2021-02-20 | Delta | Colorado | 8029 | 2437 | 58 |
1047272 | 1047272 | 2021-02-20 | Denver | Colorado | 8031 | 58432 | 765 |
1047273 | 1047273 | 2021-02-20 | Dolores | Colorado | 8033 | 67 | 0 |
1047274 | 1047274 | 2021-02-20 | Douglas | Colorado | 8035 | 21225 | 230 |
1047275 | 1047275 | 2021-02-20 | Eagle | Colorado | 8037 | 4878 | 20 |
1047276 | 1047276 | 2021-02-20 | El Paso | Colorado | 8041 | 50831 | 741 |
1047277 | 1047277 | 2021-02-20 | Elbert | Colorado | 8039 | 1251 | 12 |
1047278 | 1047278 | 2021-02-20 | Fremont | Colorado | 8043 | 5397 | 48 |
1047279 | 1047279 | 2021-02-20 | Garfield | Colorado | 8045 | 5017 | 38 |
1047280 | 1047280 | 2021-02-20 | Gilpin | Colorado | 8047 | 164 | 3 |
1047281 | 1047281 | 2021-02-20 | Grand | Colorado | 8049 | 1234 | 5 |
1047282 | 1047282 | 2021-02-20 | Gunnison | Colorado | 8051 | 1182 | 6 |
1047283 | 1047283 | 2021-02-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1047284 | 1047284 | 2021-02-20 | Huerfano | Colorado | 8055 | 300 | 17 |
1047285 | 1047285 | 2021-02-20 | Jackson | Colorado | 8057 | 51 | 0 |
1047286 | 1047286 | 2021-02-20 | Jefferson | Colorado | 8059 | 36435 | 705 |
1047287 | 1047287 | 2021-02-20 | Kiowa | Colorado | 8061 | 91 | 3 |
1047288 | 1047288 | 2021-02-20 | Kit Carson | Colorado | 8063 | 524 | 10 |
1047289 | 1047289 | 2021-02-20 | La Plata | Colorado | 8067 | 2876 | 36 |
1047290 | 1047290 | 2021-02-20 | Lake | Colorado | 8065 | 651 | 0 |
1047291 | 1047291 | 2021-02-20 | Larimer | Colorado | 8069 | 19494 | 218 |
1047292 | 1047292 | 2021-02-20 | Las Animas | Colorado | 8071 | 982 | 11 |
1047293 | 1047293 | 2021-02-20 | Lincoln | Colorado | 8073 | 996 | 3 |
1047294 | 1047294 | 2021-02-20 | Logan | Colorado | 8075 | 3704 | 63 |
1047295 | 1047295 | 2021-02-20 | Mesa | Colorado | 8077 | 13062 | 190 |
1047296 | 1047296 | 2021-02-20 | Mineral | Colorado | 8079 | 61 | 1 |
1047297 | 1047297 | 2021-02-20 | Moffat | Colorado | 8081 | 656 | 22 |
1047298 | 1047298 | 2021-02-20 | Montezuma | Colorado | 8083 | 1700 | 22 |
1047299 | 1047299 | 2021-02-20 | Montrose | Colorado | 8085 | 3186 | 52 |
1047300 | 1047300 | 2021-02-20 | Morgan | Colorado | 8087 | 2412 | 90 |
1047301 | 1047301 | 2021-02-20 | Otero | Colorado | 8089 | 1836 | 61 |
1047302 | 1047302 | 2021-02-20 | Ouray | Colorado | 8091 | 243 | 3 |
1047303 | 1047303 | 2021-02-20 | Park | Colorado | 8093 | 537 | 5 |
1047304 | 1047304 | 2021-02-20 | Phillips | Colorado | 8095 | 333 | 12 |
1047305 | 1047305 | 2021-02-20 | Pitkin | Colorado | 8097 | 1939 | 4 |
1047306 | 1047306 | 2021-02-20 | Prowers | Colorado | 8099 | 1157 | 21 |
1047307 | 1047307 | 2021-02-20 | Pueblo | Colorado | 8101 | 14874 | 362 |
1047308 | 1047308 | 2021-02-20 | Rio Blanco | Colorado | 8103 | 455 | 3 |
1047309 | 1047309 | 2021-02-20 | Rio Grande | Colorado | 8105 | 680 | 12 |
1047310 | 1047310 | 2021-02-20 | Routt | Colorado | 8107 | 1823 | 19 |
1047311 | 1047311 | 2021-02-20 | Saguache | Colorado | 8109 | 312 | 4 |
1047312 | 1047312 | 2021-02-20 | San Juan | Colorado | 8111 | 41 | 0 |
1047313 | 1047313 | 2021-02-20 | San Miguel | Colorado | 8113 | 801 | 0 |
1047314 | 1047314 | 2021-02-20 | Sedgwick | Colorado | 8115 | 191 | 2 |
1047315 | 1047315 | 2021-02-20 | Summit | Colorado | 8117 | 2948 | 7 |
1047316 | 1047316 | 2021-02-20 | Teller | Colorado | 8119 | 1242 | 14 |
1047317 | 1047317 | 2021-02-20 | Washington | Colorado | 8121 | 377 | 12 |
1047318 | 1047318 | 2021-02-20 | Weld | Colorado | 8123 | 24974 | 316 |
1047319 | 1047319 | 2021-02-20 | Yuma | Colorado | 8125 | 698 | 17 |
1044011 | 1044011 | 2021-02-19 | Adams | Colorado | 8001 | 48380 | 625 |
1044012 | 1044012 | 2021-02-19 | Alamosa | Colorado | 8003 | 1248 | 28 |
1044013 | 1044013 | 2021-02-19 | Arapahoe | Colorado | 8005 | 48362 | 688 |
1044014 | 1044014 | 2021-02-19 | Archuleta | Colorado | 8007 | 629 | 1 |
1044015 | 1044015 | 2021-02-19 | Baca | Colorado | 8009 | 270 | 4 |
1044016 | 1044016 | 2021-02-19 | Bent | Colorado | 8011 | 1469 | 21 |
1044017 | 1044017 | 2021-02-19 | Boulder | Colorado | 8013 | 18508 | 245 |
1044018 | 1044018 | 2021-02-19 | Broomfield | Colorado | 8014 | 3636 | 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);