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 680
- Jefferson 680
- Denver 679
- Eagle 679
- El Paso 679
- Arapahoe 676
- Larimer 676
- Gunnison 675
- Pitkin 674
- Adams 673
- Clear Creek 672
- Pueblo 672
- Routt 672
- Summit 672
- Weld 672
- Boulder 671
- Mesa 671
- Garfield 670
- Yuma 667
- Crowley 666
- Grand 666
- Morgan 666
- Broomfield 665
- Park 665
- San Miguel 665
- Chaffee 664
- Elbert 664
- Hinsdale 664
- Montrose 664
- La Plata 662
- …
state 1
- Colorado · 41,847 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109374 | 2109374 | 2022-01-13 | Adams | Colorado | 8001 | 111905 | 1137 |
2109375 | 2109375 | 2022-01-13 | Alamosa | Colorado | 8003 | 3404 | 58 |
2109376 | 2109376 | 2022-01-13 | Arapahoe | Colorado | 8005 | 125573 | 1107 |
2109377 | 2109377 | 2022-01-13 | Archuleta | Colorado | 8007 | 2342 | 9 |
2109378 | 2109378 | 2022-01-13 | Baca | Colorado | 8009 | 610 | 8 |
2109379 | 2109379 | 2022-01-13 | Bent | Colorado | 8011 | 2003 | 45 |
2109380 | 2109380 | 2022-01-13 | Boulder | Colorado | 8013 | 48602 | 333 |
2109381 | 2109381 | 2022-01-13 | Broomfield | Colorado | 8014 | 10493 | 99 |
2109382 | 2109382 | 2022-01-13 | Chaffee | Colorado | 8015 | 3520 | 38 |
2109383 | 2109383 | 2022-01-13 | Cheyenne | Colorado | 8017 | 268 | 9 |
2109384 | 2109384 | 2022-01-13 | Clear Creek | Colorado | 8019 | 1227 | 10 |
2109385 | 2109385 | 2022-01-13 | Conejos | Colorado | 8021 | 1298 | 48 |
2109386 | 2109386 | 2022-01-13 | Costilla | Colorado | 8023 | 508 | 14 |
2109387 | 2109387 | 2022-01-13 | Crowley | Colorado | 8025 | 2597 | 27 |
2109388 | 2109388 | 2022-01-13 | Custer | Colorado | 8027 | 525 | 16 |
2109389 | 2109389 | 2022-01-13 | Delta | Colorado | 8029 | 4938 | 124 |
2109390 | 2109390 | 2022-01-13 | Denver | Colorado | 8031 | 140752 | 1117 |
2109391 | 2109391 | 2022-01-13 | Dolores | Colorado | 8033 | 297 | 6 |
2109392 | 2109392 | 2022-01-13 | Douglas | Colorado | 8035 | 63077 | 382 |
2109393 | 2109393 | 2022-01-13 | Eagle | Colorado | 8037 | 13794 | 32 |
2109394 | 2109394 | 2022-01-13 | El Paso | Colorado | 8041 | 146181 | 1456 |
2109395 | 2109395 | 2022-01-13 | Elbert | Colorado | 8039 | 3861 | 31 |
2109396 | 2109396 | 2022-01-13 | Fremont | Colorado | 8043 | 11304 | 163 |
2109397 | 2109397 | 2022-01-13 | Garfield | Colorado | 8045 | 11675 | 80 |
2109398 | 2109398 | 2022-01-13 | Gilpin | Colorado | 8047 | 758 | 4 |
2109399 | 2109399 | 2022-01-13 | Grand | Colorado | 8049 | 2995 | 20 |
2109400 | 2109400 | 2022-01-13 | Gunnison | Colorado | 8051 | 2685 | 13 |
2109401 | 2109401 | 2022-01-13 | Hinsdale | Colorado | 8053 | 94 | 0 |
2109402 | 2109402 | 2022-01-13 | Huerfano | Colorado | 8055 | 1050 | 28 |
2109403 | 2109403 | 2022-01-13 | Jackson | Colorado | 8057 | 132 | 0 |
2109404 | 2109404 | 2022-01-13 | Jefferson | Colorado | 8059 | 98226 | 1138 |
2109405 | 2109405 | 2022-01-13 | Kiowa | Colorado | 8061 | 293 | 4 |
2109406 | 2109406 | 2022-01-13 | Kit Carson | Colorado | 8063 | 1366 | 28 |
2109407 | 2109407 | 2022-01-13 | La Plata | Colorado | 8067 | 9639 | 68 |
2109408 | 2109408 | 2022-01-13 | Lake | Colorado | 8065 | 1564 | 2 |
2109409 | 2109409 | 2022-01-13 | Larimer | Colorado | 8069 | 58661 | 410 |
2109410 | 2109410 | 2022-01-13 | Las Animas | Colorado | 8071 | 2686 | 35 |
2109411 | 2109411 | 2022-01-13 | Lincoln | Colorado | 8073 | 1643 | 9 |
2109412 | 2109412 | 2022-01-13 | Logan | Colorado | 8075 | 5642 | 98 |
2109413 | 2109413 | 2022-01-13 | Mesa | Colorado | 8077 | 32998 | 481 |
2109414 | 2109414 | 2022-01-13 | Mineral | Colorado | 8079 | 169 | 1 |
2109415 | 2109415 | 2022-01-13 | Moffat | Colorado | 8081 | 2455 | 49 |
2109416 | 2109416 | 2022-01-13 | Montezuma | Colorado | 8083 | 4598 | 58 |
2109417 | 2109417 | 2022-01-13 | Montrose | Colorado | 8085 | 7544 | 149 |
2109418 | 2109418 | 2022-01-13 | Morgan | Colorado | 8087 | 4632 | 128 |
2109419 | 2109419 | 2022-01-13 | Otero | Colorado | 8089 | 3544 | 118 |
2109420 | 2109420 | 2022-01-13 | Ouray | Colorado | 8091 | 718 | 6 |
2109421 | 2109421 | 2022-01-13 | Park | Colorado | 8093 | 2336 | 16 |
2109422 | 2109422 | 2022-01-13 | Phillips | Colorado | 8095 | 666 | 15 |
2109423 | 2109423 | 2022-01-13 | Pitkin | Colorado | 8097 | 5454 | 6 |
2109424 | 2109424 | 2022-01-13 | Prowers | Colorado | 8099 | 2153 | 44 |
2109425 | 2109425 | 2022-01-13 | Pueblo | Colorado | 8101 | 35565 | 695 |
2109426 | 2109426 | 2022-01-13 | Rio Blanco | Colorado | 8103 | 1357 | 13 |
2109427 | 2109427 | 2022-01-13 | Rio Grande | Colorado | 8105 | 2152 | 41 |
2109428 | 2109428 | 2022-01-13 | Routt | Colorado | 8107 | 5355 | 24 |
2109429 | 2109429 | 2022-01-13 | Saguache | Colorado | 8109 | 916 | 10 |
2109430 | 2109430 | 2022-01-13 | San Juan | Colorado | 8111 | 165 | 0 |
2109431 | 2109431 | 2022-01-13 | San Miguel | Colorado | 8113 | 1947 | 7 |
2109432 | 2109432 | 2022-01-13 | Sedgwick | Colorado | 8115 | 385 | 6 |
2109433 | 2109433 | 2022-01-13 | Summit | Colorado | 8117 | 8528 | 12 |
2109434 | 2109434 | 2022-01-13 | Teller | Colorado | 8119 | 3953 | 54 |
2109435 | 2109435 | 2022-01-13 | Washington | Colorado | 8121 | 815 | 25 |
2109436 | 2109436 | 2022-01-13 | Weld | Colorado | 8123 | 66308 | 604 |
2109437 | 2109437 | 2022-01-13 | Yuma | Colorado | 8125 | 1574 | 22 |
2106123 | 2106123 | 2022-01-12 | Adams | Colorado | 8001 | 110399 | 1132 |
2106124 | 2106124 | 2022-01-12 | Alamosa | Colorado | 8003 | 3341 | 57 |
2106125 | 2106125 | 2022-01-12 | Arapahoe | Colorado | 8005 | 123482 | 1102 |
2106126 | 2106126 | 2022-01-12 | Archuleta | Colorado | 8007 | 2289 | 9 |
2106127 | 2106127 | 2022-01-12 | Baca | Colorado | 8009 | 608 | 8 |
2106128 | 2106128 | 2022-01-12 | Bent | Colorado | 8011 | 1996 | 44 |
2106129 | 2106129 | 2022-01-12 | Boulder | Colorado | 8013 | 47784 | 333 |
2106130 | 2106130 | 2022-01-12 | Broomfield | Colorado | 8014 | 10366 | 99 |
2106131 | 2106131 | 2022-01-12 | Chaffee | Colorado | 8015 | 3420 | 38 |
2106132 | 2106132 | 2022-01-12 | Cheyenne | Colorado | 8017 | 266 | 9 |
2106133 | 2106133 | 2022-01-12 | Clear Creek | Colorado | 8019 | 1193 | 9 |
2106134 | 2106134 | 2022-01-12 | Conejos | Colorado | 8021 | 1278 | 48 |
2106135 | 2106135 | 2022-01-12 | Costilla | Colorado | 8023 | 494 | 14 |
2106136 | 2106136 | 2022-01-12 | Crowley | Colorado | 8025 | 2586 | 27 |
2106137 | 2106137 | 2022-01-12 | Custer | Colorado | 8027 | 523 | 16 |
2106138 | 2106138 | 2022-01-12 | Delta | Colorado | 8029 | 4909 | 124 |
2106139 | 2106139 | 2022-01-12 | Denver | Colorado | 8031 | 139149 | 1117 |
2106140 | 2106140 | 2022-01-12 | Dolores | Colorado | 8033 | 297 | 6 |
2106141 | 2106141 | 2022-01-12 | Douglas | Colorado | 8035 | 62028 | 382 |
2106142 | 2106142 | 2022-01-12 | Eagle | Colorado | 8037 | 13651 | 32 |
2106143 | 2106143 | 2022-01-12 | El Paso | Colorado | 8041 | 144217 | 1454 |
2106144 | 2106144 | 2022-01-12 | Elbert | Colorado | 8039 | 3815 | 31 |
2106145 | 2106145 | 2022-01-12 | Fremont | Colorado | 8043 | 11224 | 163 |
2106146 | 2106146 | 2022-01-12 | Garfield | Colorado | 8045 | 11505 | 80 |
2106147 | 2106147 | 2022-01-12 | Gilpin | Colorado | 8047 | 740 | 4 |
2106148 | 2106148 | 2022-01-12 | Grand | Colorado | 8049 | 2894 | 20 |
2106149 | 2106149 | 2022-01-12 | Gunnison | Colorado | 8051 | 2648 | 13 |
2106150 | 2106150 | 2022-01-12 | Hinsdale | Colorado | 8053 | 94 | 0 |
2106151 | 2106151 | 2022-01-12 | Huerfano | Colorado | 8055 | 1023 | 27 |
2106152 | 2106152 | 2022-01-12 | Jackson | Colorado | 8057 | 130 | 0 |
2106153 | 2106153 | 2022-01-12 | Jefferson | Colorado | 8059 | 96975 | 1131 |
2106154 | 2106154 | 2022-01-12 | Kiowa | Colorado | 8061 | 290 | 4 |
2106155 | 2106155 | 2022-01-12 | Kit Carson | Colorado | 8063 | 1358 | 28 |
2106156 | 2106156 | 2022-01-12 | La Plata | Colorado | 8067 | 9336 | 68 |
2106157 | 2106157 | 2022-01-12 | Lake | Colorado | 8065 | 1552 | 2 |
2106158 | 2106158 | 2022-01-12 | Larimer | Colorado | 8069 | 57778 | 410 |
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);