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 65
- 8035 467
- 8059 467
- 8031 466
- 8037 466
- 8041 466
- 8005 463
- 8069 463
- 8051 462
- 8097 461
- 8001 460
- 8019 459
- 8101 459
- 8107 459
- 8117 459
- 8123 459
- 8013 458
- 8077 458
- 8045 457
- 8125 454
- 8025 453
- 8049 453
- 8087 453
- 8014 452
- 8093 452
- 8113 452
- 8015 451
- 8039 451
- 8053 451
- 8085 451
- 8067 449
- 8075 449
- 8119 449
- 8029 448
- 8043 448
- 8055 448
- 8089 447
- 8063 446
- 8105 446
- 8121 446
- 8003 445
- 8023 445
- 8073 445
- 8009 444
- 8081 444
- 8079 443
- 8083 443
- 8007 442
- 8095 442
- 8065 441
- 8109 441
- 8027 439
- 8071 438
- 8103 438
- 8091 437
- 8047 432
- 8099 432
- 8111 405
- 8017 404
- 8021 404
- 8011 401
- 8057 355
- 8115 336
- 8033 333
- 8061 264
- - 64
county 65
- Douglas 467
- Jefferson 467
- Denver 466
- Eagle 466
- El Paso 466
- Arapahoe 463
- Larimer 463
- Gunnison 462
- Pitkin 461
- Adams 460
- Clear Creek 459
- Pueblo 459
- Routt 459
- Summit 459
- Weld 459
- Boulder 458
- Mesa 458
- Garfield 457
- Yuma 454
- Crowley 453
- Grand 453
- Morgan 453
- Broomfield 452
- Park 452
- San Miguel 452
- Chaffee 451
- Elbert 451
- Hinsdale 451
- Montrose 451
- La Plata 449
- Logan 449
- Teller 449
- Delta 448
- Fremont 448
- Huerfano 448
- Otero 447
- Kit Carson 446
- Rio Grande 446
- Washington 446
- Alamosa 445
- Costilla 445
- Lincoln 445
- Baca 444
- Moffat 444
- Mineral 443
- Montezuma 443
- Archuleta 442
- Phillips 442
- Lake 441
- Saguache 441
- Custer 439
- Las Animas 438
- Rio Blanco 438
- Ouray 437
- Gilpin 432
- Prowers 432
- San Juan 405
- Cheyenne 404
- Conejos 404
- Bent 401
- Jackson 355
- Sedgwick 336
- Dolores 333
- Kiowa 264
- Unknown 64
state 1
- Colorado · 28,215 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417374 | 1417374 | 2021-06-14 | Adams | Colorado | 8001 | 61498 | 748 |
1417375 | 1417375 | 2021-06-14 | Alamosa | Colorado | 8003 | 1711 | 36 |
1417376 | 1417376 | 2021-06-14 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1417377 | 1417377 | 2021-06-14 | Archuleta | Colorado | 8007 | 1008 | 2 |
1417378 | 1417378 | 2021-06-14 | Baca | Colorado | 8009 | 319 | 4 |
1417379 | 1417379 | 2021-06-14 | Bent | Colorado | 8011 | 1545 | 22 |
1417380 | 1417380 | 2021-06-14 | Boulder | Colorado | 8013 | 23893 | 260 |
1417381 | 1417381 | 2021-06-14 | Broomfield | Colorado | 8014 | 4950 | 77 |
1417382 | 1417382 | 2021-06-14 | Chaffee | Colorado | 8015 | 1747 | 25 |
1417383 | 1417383 | 2021-06-14 | Cheyenne | Colorado | 8017 | 130 | 6 |
1417384 | 1417384 | 2021-06-14 | Clear Creek | Colorado | 8019 | 471 | 3 |
1417385 | 1417385 | 2021-06-14 | Conejos | Colorado | 8021 | 703 | 17 |
1417386 | 1417386 | 2021-06-14 | Costilla | Colorado | 8023 | 249 | 4 |
1417387 | 1417387 | 2021-06-14 | Crowley | Colorado | 8025 | 2210 | 16 |
1417388 | 1417388 | 2021-06-14 | Custer | Colorado | 8027 | 220 | 2 |
1417389 | 1417389 | 2021-06-14 | Delta | Colorado | 8029 | 2844 | 64 |
1417390 | 1417390 | 2021-06-14 | Denver | Colorado | 8031 | 73893 | 834 |
1417391 | 1417391 | 2021-06-14 | Dolores | Colorado | 8033 | 123 | 1 |
1417392 | 1417392 | 2021-06-14 | Douglas | Colorado | 8035 | 30696 | 264 |
1417393 | 1417393 | 2021-06-14 | Eagle | Colorado | 8037 | 6341 | 23 |
1417394 | 1417394 | 2021-06-14 | El Paso | Colorado | 8041 | 72148 | 857 |
1417395 | 1417395 | 2021-06-14 | Elbert | Colorado | 8039 | 1857 | 13 |
1417396 | 1417396 | 2021-06-14 | Fremont | Colorado | 8043 | 6505 | 63 |
1417397 | 1417397 | 2021-06-14 | Garfield | Colorado | 8045 | 6055 | 43 |
1417398 | 1417398 | 2021-06-14 | Gilpin | Colorado | 8047 | 278 | 3 |
1417399 | 1417399 | 2021-06-14 | Grand | Colorado | 8049 | 1500 | 7 |
1417400 | 1417400 | 2021-06-14 | Gunnison | Colorado | 8051 | 1370 | 6 |
1417401 | 1417401 | 2021-06-14 | Hinsdale | Colorado | 8053 | 19 | 0 |
1417402 | 1417402 | 2021-06-14 | Huerfano | Colorado | 8055 | 431 | 17 |
1417403 | 1417403 | 2021-06-14 | Jackson | Colorado | 8057 | 65 | 0 |
1417404 | 1417404 | 2021-06-14 | Jefferson | Colorado | 8059 | 48510 | 793 |
1417405 | 1417405 | 2021-06-14 | Kiowa | Colorado | 8061 | 95 | 3 |
1417406 | 1417406 | 2021-06-14 | Kit Carson | Colorado | 8063 | 637 | 11 |
1417407 | 1417407 | 2021-06-14 | La Plata | Colorado | 8067 | 4074 | 41 |
1417408 | 1417408 | 2021-06-14 | Lake | Colorado | 8065 | 824 | 0 |
1417409 | 1417409 | 2021-06-14 | Larimer | Colorado | 8069 | 27356 | 245 |
1417410 | 1417410 | 2021-06-14 | Las Animas | Colorado | 8071 | 1159 | 14 |
1417411 | 1417411 | 2021-06-14 | Lincoln | Colorado | 8073 | 1033 | 4 |
1417412 | 1417412 | 2021-06-14 | Logan | Colorado | 8075 | 4035 | 68 |
1417413 | 1417413 | 2021-06-14 | Mesa | Colorado | 8077 | 16516 | 239 |
1417414 | 1417414 | 2021-06-14 | Mineral | Colorado | 8079 | 93 | 1 |
1417415 | 1417415 | 2021-06-14 | Moffat | Colorado | 8081 | 916 | 23 |
1417416 | 1417416 | 2021-06-14 | Montezuma | Colorado | 8083 | 2035 | 25 |
1417417 | 1417417 | 2021-06-14 | Montrose | Colorado | 8085 | 3665 | 62 |
1417418 | 1417418 | 2021-06-14 | Morgan | Colorado | 8087 | 2720 | 95 |
1417419 | 1417419 | 2021-06-14 | Otero | Colorado | 8089 | 2071 | 67 |
1417420 | 1417420 | 2021-06-14 | Ouray | Colorado | 8091 | 289 | 3 |
1417421 | 1417421 | 2021-06-14 | Park | Colorado | 8093 | 826 | 5 |
1417422 | 1417422 | 2021-06-14 | Phillips | Colorado | 8095 | 398 | 13 |
1417423 | 1417423 | 2021-06-14 | Pitkin | Colorado | 8097 | 2604 | 4 |
1417424 | 1417424 | 2021-06-14 | Prowers | Colorado | 8099 | 1271 | 22 |
1417425 | 1417425 | 2021-06-14 | Pueblo | Colorado | 8101 | 19409 | 414 |
1417426 | 1417426 | 2021-06-14 | Rio Blanco | Colorado | 8103 | 589 | 5 |
1417427 | 1417427 | 2021-06-14 | Rio Grande | Colorado | 8105 | 888 | 16 |
1417428 | 1417428 | 2021-06-14 | Routt | Colorado | 8107 | 2267 | 21 |
1417429 | 1417429 | 2021-06-14 | Saguache | Colorado | 8109 | 426 | 5 |
1417430 | 1417430 | 2021-06-14 | San Juan | Colorado | 8111 | 48 | 0 |
1417431 | 1417431 | 2021-06-14 | San Miguel | Colorado | 8113 | 911 | 0 |
1417432 | 1417432 | 2021-06-14 | Sedgwick | Colorado | 8115 | 236 | 3 |
1417433 | 1417433 | 2021-06-14 | Summit | Colorado | 8117 | 3742 | 8 |
1417434 | 1417434 | 2021-06-14 | Teller | Colorado | 8119 | 1886 | 17 |
1417435 | 1417435 | 2021-06-14 | Washington | Colorado | 8121 | 471 | 13 |
1417436 | 1417436 | 2021-06-14 | Weld | Colorado | 8123 | 33104 | 346 |
1417437 | 1417437 | 2021-06-14 | Yuma | Colorado | 8125 | 963 | 17 |
1414128 | 1414128 | 2021-06-13 | Adams | Colorado | 8001 | 61498 | 748 |
1414129 | 1414129 | 2021-06-13 | Alamosa | Colorado | 8003 | 1712 | 36 |
1414130 | 1414130 | 2021-06-13 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1414131 | 1414131 | 2021-06-13 | Archuleta | Colorado | 8007 | 1008 | 2 |
1414132 | 1414132 | 2021-06-13 | Baca | Colorado | 8009 | 319 | 4 |
1414133 | 1414133 | 2021-06-13 | Bent | Colorado | 8011 | 1545 | 22 |
1414134 | 1414134 | 2021-06-13 | Boulder | Colorado | 8013 | 23880 | 260 |
1414135 | 1414135 | 2021-06-13 | Broomfield | Colorado | 8014 | 4948 | 77 |
1414136 | 1414136 | 2021-06-13 | Chaffee | Colorado | 8015 | 1747 | 25 |
1414137 | 1414137 | 2021-06-13 | Cheyenne | Colorado | 8017 | 130 | 6 |
1414138 | 1414138 | 2021-06-13 | Clear Creek | Colorado | 8019 | 471 | 3 |
1414139 | 1414139 | 2021-06-13 | Conejos | Colorado | 8021 | 703 | 17 |
1414140 | 1414140 | 2021-06-13 | Costilla | Colorado | 8023 | 249 | 4 |
1414141 | 1414141 | 2021-06-13 | Crowley | Colorado | 8025 | 2210 | 16 |
1414142 | 1414142 | 2021-06-13 | Custer | Colorado | 8027 | 219 | 2 |
1414143 | 1414143 | 2021-06-13 | Delta | Colorado | 8029 | 2844 | 64 |
1414144 | 1414144 | 2021-06-13 | Denver | Colorado | 8031 | 73876 | 834 |
1414145 | 1414145 | 2021-06-13 | Dolores | Colorado | 8033 | 123 | 1 |
1414146 | 1414146 | 2021-06-13 | Douglas | Colorado | 8035 | 30696 | 264 |
1414147 | 1414147 | 2021-06-13 | Eagle | Colorado | 8037 | 6341 | 23 |
1414148 | 1414148 | 2021-06-13 | El Paso | Colorado | 8041 | 72095 | 857 |
1414149 | 1414149 | 2021-06-13 | Elbert | Colorado | 8039 | 1856 | 13 |
1414150 | 1414150 | 2021-06-13 | Fremont | Colorado | 8043 | 6505 | 63 |
1414151 | 1414151 | 2021-06-13 | Garfield | Colorado | 8045 | 6053 | 43 |
1414152 | 1414152 | 2021-06-13 | Gilpin | Colorado | 8047 | 277 | 3 |
1414153 | 1414153 | 2021-06-13 | Grand | Colorado | 8049 | 1500 | 7 |
1414154 | 1414154 | 2021-06-13 | Gunnison | Colorado | 8051 | 1371 | 6 |
1414155 | 1414155 | 2021-06-13 | Hinsdale | Colorado | 8053 | 19 | 0 |
1414156 | 1414156 | 2021-06-13 | Huerfano | Colorado | 8055 | 431 | 17 |
1414157 | 1414157 | 2021-06-13 | Jackson | Colorado | 8057 | 65 | 0 |
1414158 | 1414158 | 2021-06-13 | Jefferson | Colorado | 8059 | 48497 | 793 |
1414159 | 1414159 | 2021-06-13 | Kiowa | Colorado | 8061 | 95 | 3 |
1414160 | 1414160 | 2021-06-13 | Kit Carson | Colorado | 8063 | 637 | 11 |
1414161 | 1414161 | 2021-06-13 | La Plata | Colorado | 8067 | 4074 | 41 |
1414162 | 1414162 | 2021-06-13 | Lake | Colorado | 8065 | 824 | 0 |
1414163 | 1414163 | 2021-06-13 | Larimer | Colorado | 8069 | 27338 | 245 |
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);