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 398
- Jefferson 398
- Denver 397
- Eagle 397
- El Paso 397
- Arapahoe 394
- Larimer 394
- Gunnison 393
- Pitkin 392
- Adams 391
- Clear Creek 390
- Pueblo 390
- Routt 390
- Summit 390
- Weld 390
- Boulder 389
- Mesa 389
- Garfield 388
- Yuma 385
- Crowley 384
- Grand 384
- Morgan 384
- Broomfield 383
- Park 383
- San Miguel 383
- Chaffee 382
- Elbert 382
- Hinsdale 382
- Montrose 382
- La Plata 380
- …
state 1
- Colorado · 23,799 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193353 | 1193353 | 2021-04-06 | Adams | Colorado | 8001 | 53068 | 643 |
1193354 | 1193354 | 2021-04-06 | Alamosa | Colorado | 8003 | 1355 | 29 |
1193355 | 1193355 | 2021-04-06 | Arapahoe | Colorado | 8005 | 53828 | 717 |
1193356 | 1193356 | 2021-04-06 | Archuleta | Colorado | 8007 | 770 | 1 |
1193357 | 1193357 | 2021-04-06 | Baca | Colorado | 8009 | 278 | 4 |
1193358 | 1193358 | 2021-04-06 | Bent | Colorado | 8011 | 1485 | 21 |
1193359 | 1193359 | 2021-04-06 | Boulder | Colorado | 8013 | 21177 | 250 |
1193360 | 1193360 | 2021-04-06 | Broomfield | Colorado | 8014 | 4275 | 74 |
1193361 | 1193361 | 2021-04-06 | Chaffee | Colorado | 8015 | 1516 | 24 |
1193362 | 1193362 | 2021-04-06 | Cheyenne | Colorado | 8017 | 126 | 6 |
1193363 | 1193363 | 2021-04-06 | Clear Creek | Colorado | 8019 | 410 | 3 |
1193364 | 1193364 | 2021-04-06 | Conejos | Colorado | 8021 | 464 | 10 |
1193365 | 1193365 | 2021-04-06 | Costilla | Colorado | 8023 | 204 | 2 |
1193366 | 1193366 | 2021-04-06 | Crowley | Colorado | 8025 | 2145 | 14 |
1193367 | 1193367 | 2021-04-06 | Custer | Colorado | 8027 | 176 | 1 |
1193368 | 1193368 | 2021-04-06 | Delta | Colorado | 8029 | 2570 | 61 |
1193369 | 1193369 | 2021-04-06 | Denver | Colorado | 8031 | 65448 | 790 |
1193370 | 1193370 | 2021-04-06 | Dolores | Colorado | 8033 | 67 | 0 |
1193371 | 1193371 | 2021-04-06 | Douglas | Colorado | 8035 | 24993 | 235 |
1193372 | 1193372 | 2021-04-06 | Eagle | Colorado | 8037 | 5842 | 22 |
1193373 | 1193373 | 2021-04-06 | El Paso | Colorado | 8041 | 57917 | 761 |
1193374 | 1193374 | 2021-04-06 | Elbert | Colorado | 8039 | 1455 | 12 |
1193375 | 1193375 | 2021-04-06 | Fremont | Colorado | 8043 | 5679 | 53 |
1193376 | 1193376 | 2021-04-06 | Garfield | Colorado | 8045 | 5497 | 38 |
1193377 | 1193377 | 2021-04-06 | Gilpin | Colorado | 8047 | 196 | 3 |
1193378 | 1193378 | 2021-04-06 | Grand | Colorado | 8049 | 1351 | 6 |
1193379 | 1193379 | 2021-04-06 | Gunnison | Colorado | 8051 | 1262 | 6 |
1193380 | 1193380 | 2021-04-06 | Hinsdale | Colorado | 8053 | 17 | 0 |
1193381 | 1193381 | 2021-04-06 | Huerfano | Colorado | 8055 | 338 | 16 |
1193382 | 1193382 | 2021-04-06 | Jackson | Colorado | 8057 | 53 | 0 |
1193383 | 1193383 | 2021-04-06 | Jefferson | Colorado | 8059 | 41129 | 733 |
1193384 | 1193384 | 2021-04-06 | Kiowa | Colorado | 8061 | 92 | 3 |
1193385 | 1193385 | 2021-04-06 | Kit Carson | Colorado | 8063 | 589 | 11 |
1193386 | 1193386 | 2021-04-06 | La Plata | Colorado | 8067 | 3430 | 37 |
1193387 | 1193387 | 2021-04-06 | Lake | Colorado | 8065 | 705 | 0 |
1193388 | 1193388 | 2021-04-06 | Larimer | Colorado | 8069 | 22892 | 229 |
1193389 | 1193389 | 2021-04-06 | Las Animas | Colorado | 8071 | 1048 | 11 |
1193390 | 1193390 | 2021-04-06 | Lincoln | Colorado | 8073 | 1008 | 4 |
1193391 | 1193391 | 2021-04-06 | Logan | Colorado | 8075 | 3851 | 65 |
1193392 | 1193392 | 2021-04-06 | Mesa | Colorado | 8077 | 13772 | 209 |
1193393 | 1193393 | 2021-04-06 | Mineral | Colorado | 8079 | 86 | 1 |
1193394 | 1193394 | 2021-04-06 | Moffat | Colorado | 8081 | 709 | 22 |
1193395 | 1193395 | 2021-04-06 | Montezuma | Colorado | 8083 | 1813 | 23 |
1193396 | 1193396 | 2021-04-06 | Montrose | Colorado | 8085 | 3335 | 57 |
1193397 | 1193397 | 2021-04-06 | Morgan | Colorado | 8087 | 2545 | 92 |
1193398 | 1193398 | 2021-04-06 | Otero | Colorado | 8089 | 1891 | 63 |
1193399 | 1193399 | 2021-04-06 | Ouray | Colorado | 8091 | 276 | 3 |
1193400 | 1193400 | 2021-04-06 | Park | Colorado | 8093 | 616 | 5 |
1193401 | 1193401 | 2021-04-06 | Phillips | Colorado | 8095 | 352 | 13 |
1193402 | 1193402 | 2021-04-06 | Pitkin | Colorado | 8097 | 2493 | 4 |
1193403 | 1193403 | 2021-04-06 | Prowers | Colorado | 8099 | 1171 | 21 |
1193404 | 1193404 | 2021-04-06 | Pueblo | Colorado | 8101 | 16093 | 366 |
1193405 | 1193405 | 2021-04-06 | Rio Blanco | Colorado | 8103 | 535 | 4 |
1193406 | 1193406 | 2021-04-06 | Rio Grande | Colorado | 8105 | 760 | 14 |
1193407 | 1193407 | 2021-04-06 | Routt | Colorado | 8107 | 2101 | 19 |
1193408 | 1193408 | 2021-04-06 | Saguache | Colorado | 8109 | 337 | 4 |
1193409 | 1193409 | 2021-04-06 | San Juan | Colorado | 8111 | 46 | 0 |
1193410 | 1193410 | 2021-04-06 | San Miguel | Colorado | 8113 | 852 | 0 |
1193411 | 1193411 | 2021-04-06 | Sedgwick | Colorado | 8115 | 201 | 2 |
1193412 | 1193412 | 2021-04-06 | Summit | Colorado | 8117 | 3494 | 7 |
1193413 | 1193413 | 2021-04-06 | Teller | Colorado | 8119 | 1474 | 14 |
1193414 | 1193414 | 2021-04-06 | Washington | Colorado | 8121 | 437 | 12 |
1193415 | 1193415 | 2021-04-06 | Weld | Colorado | 8123 | 28000 | 327 |
1193416 | 1193416 | 2021-04-06 | Yuma | Colorado | 8125 | 846 | 17 |
1190103 | 1190103 | 2021-04-05 | Adams | Colorado | 8001 | 52982 | 642 |
1190104 | 1190104 | 2021-04-05 | Alamosa | Colorado | 8003 | 1351 | 29 |
1190105 | 1190105 | 2021-04-05 | Arapahoe | Colorado | 8005 | 53735 | 717 |
1190106 | 1190106 | 2021-04-05 | Archuleta | Colorado | 8007 | 764 | 1 |
1190107 | 1190107 | 2021-04-05 | Baca | Colorado | 8009 | 278 | 4 |
1190108 | 1190108 | 2021-04-05 | Bent | Colorado | 8011 | 1483 | 21 |
1190109 | 1190109 | 2021-04-05 | Boulder | Colorado | 8013 | 21145 | 250 |
1190110 | 1190110 | 2021-04-05 | Broomfield | Colorado | 8014 | 4258 | 74 |
1190111 | 1190111 | 2021-04-05 | Chaffee | Colorado | 8015 | 1516 | 24 |
1190112 | 1190112 | 2021-04-05 | Cheyenne | Colorado | 8017 | 126 | 6 |
1190113 | 1190113 | 2021-04-05 | Clear Creek | Colorado | 8019 | 409 | 3 |
1190114 | 1190114 | 2021-04-05 | Conejos | Colorado | 8021 | 462 | 10 |
1190115 | 1190115 | 2021-04-05 | Costilla | Colorado | 8023 | 204 | 2 |
1190116 | 1190116 | 2021-04-05 | Crowley | Colorado | 8025 | 2145 | 14 |
1190117 | 1190117 | 2021-04-05 | Custer | Colorado | 8027 | 176 | 1 |
1190118 | 1190118 | 2021-04-05 | Delta | Colorado | 8029 | 2563 | 61 |
1190119 | 1190119 | 2021-04-05 | Denver | Colorado | 8031 | 65148 | 789 |
1190120 | 1190120 | 2021-04-05 | Dolores | Colorado | 8033 | 67 | 0 |
1190121 | 1190121 | 2021-04-05 | Douglas | Colorado | 8035 | 24911 | 235 |
1190122 | 1190122 | 2021-04-05 | Eagle | Colorado | 8037 | 5809 | 22 |
1190123 | 1190123 | 2021-04-05 | El Paso | Colorado | 8041 | 57731 | 761 |
1190124 | 1190124 | 2021-04-05 | Elbert | Colorado | 8039 | 1447 | 12 |
1190125 | 1190125 | 2021-04-05 | Fremont | Colorado | 8043 | 5675 | 53 |
1190126 | 1190126 | 2021-04-05 | Garfield | Colorado | 8045 | 5489 | 38 |
1190127 | 1190127 | 2021-04-05 | Gilpin | Colorado | 8047 | 191 | 3 |
1190128 | 1190128 | 2021-04-05 | Grand | Colorado | 8049 | 1350 | 6 |
1190129 | 1190129 | 2021-04-05 | Gunnison | Colorado | 8051 | 1262 | 6 |
1190130 | 1190130 | 2021-04-05 | Hinsdale | Colorado | 8053 | 18 | 0 |
1190131 | 1190131 | 2021-04-05 | Huerfano | Colorado | 8055 | 337 | 16 |
1190132 | 1190132 | 2021-04-05 | Jackson | Colorado | 8057 | 52 | 0 |
1190133 | 1190133 | 2021-04-05 | Jefferson | Colorado | 8059 | 41024 | 733 |
1190134 | 1190134 | 2021-04-05 | Kiowa | Colorado | 8061 | 92 | 3 |
1190135 | 1190135 | 2021-04-05 | Kit Carson | Colorado | 8063 | 587 | 11 |
1190136 | 1190136 | 2021-04-05 | La Plata | Colorado | 8067 | 3420 | 37 |
1190137 | 1190137 | 2021-04-05 | Lake | Colorado | 8065 | 703 | 0 |
1190138 | 1190138 | 2021-04-05 | Larimer | Colorado | 8069 | 22805 | 229 |
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);