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 588
- 8059 588
- 8031 587
- 8037 587
- 8041 587
- 8005 584
- 8069 584
- 8051 583
- 8097 582
- 8001 581
- 8019 580
- 8101 580
- 8107 580
- 8117 580
- 8123 580
- 8013 579
- 8077 579
- 8045 578
- 8125 575
- 8025 574
- 8049 574
- 8087 574
- 8014 573
- 8093 573
- 8113 573
- 8015 572
- 8039 572
- 8053 572
- 8085 572
- 8067 570
- 8075 570
- 8119 570
- 8029 569
- 8043 569
- 8055 569
- 8089 568
- 8063 567
- 8105 567
- 8121 567
- 8003 566
- 8023 566
- 8073 566
- 8009 565
- 8081 565
- 8079 564
- 8083 564
- 8007 563
- 8095 563
- 8065 562
- 8109 562
- 8027 560
- 8071 559
- 8103 559
- 8091 558
- 8047 553
- 8099 553
- 8111 526
- 8017 525
- 8021 525
- 8011 522
- 8057 476
- 8115 457
- 8033 454
- 8061 385
- - 64
county 65
- Douglas 588
- Jefferson 588
- Denver 587
- Eagle 587
- El Paso 587
- Arapahoe 584
- Larimer 584
- Gunnison 583
- Pitkin 582
- Adams 581
- Clear Creek 580
- Pueblo 580
- Routt 580
- Summit 580
- Weld 580
- Boulder 579
- Mesa 579
- Garfield 578
- Yuma 575
- Crowley 574
- Grand 574
- Morgan 574
- Broomfield 573
- Park 573
- San Miguel 573
- Chaffee 572
- Elbert 572
- Hinsdale 572
- Montrose 572
- La Plata 570
- Logan 570
- Teller 570
- Delta 569
- Fremont 569
- Huerfano 569
- Otero 568
- Kit Carson 567
- Rio Grande 567
- Washington 567
- Alamosa 566
- Costilla 566
- Lincoln 566
- Baca 565
- Moffat 565
- Mineral 564
- Montezuma 564
- Archuleta 563
- Phillips 563
- Lake 562
- Saguache 562
- Custer 560
- Las Animas 559
- Rio Blanco 559
- Ouray 558
- Gilpin 553
- Prowers 553
- San Juan 526
- Cheyenne 525
- Conejos 525
- Bent 522
- Jackson 476
- Sedgwick 457
- Dolores 454
- Kiowa 385
- Unknown 64
state 1
- Colorado · 35,959 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810362 | 1810362 | 2021-10-13 | Adams | Colorado | 8001 | 74013 | 861 |
1810363 | 1810363 | 2021-10-13 | Alamosa | Colorado | 8003 | 2293 | 43 |
1810364 | 1810364 | 2021-10-13 | Arapahoe | Colorado | 8005 | 77970 | 907 |
1810365 | 1810365 | 2021-10-13 | Archuleta | Colorado | 8007 | 1418 | 4 |
1810366 | 1810366 | 2021-10-13 | Baca | Colorado | 8009 | 413 | 5 |
1810367 | 1810367 | 2021-10-13 | Bent | Colorado | 8011 | 1656 | 23 |
1810368 | 1810368 | 2021-10-13 | Boulder | Colorado | 8013 | 29831 | 273 |
1810369 | 1810369 | 2021-10-13 | Broomfield | Colorado | 8014 | 6437 | 80 |
1810370 | 1810370 | 2021-10-13 | Chaffee | Colorado | 8015 | 2159 | 30 |
1810371 | 1810371 | 2021-10-13 | Cheyenne | Colorado | 8017 | 164 | 7 |
1810372 | 1810372 | 2021-10-13 | Clear Creek | Colorado | 8019 | 742 | 5 |
1810373 | 1810373 | 2021-10-13 | Conejos | Colorado | 8021 | 953 | 32 |
1810374 | 1810374 | 2021-10-13 | Costilla | Colorado | 8023 | 354 | 10 |
1810375 | 1810375 | 2021-10-13 | Crowley | Colorado | 8025 | 2337 | 22 |
1810376 | 1810376 | 2021-10-13 | Custer | Colorado | 8027 | 340 | 6 |
1810377 | 1810377 | 2021-10-13 | Delta | Colorado | 8029 | 3727 | 81 |
1810378 | 1810378 | 2021-10-13 | Denver | Colorado | 8031 | 88415 | 921 |
1810379 | 1810379 | 2021-10-13 | Dolores | Colorado | 8033 | 227 | 2 |
1810380 | 1810380 | 2021-10-13 | Douglas | Colorado | 8035 | 39406 | 308 |
1810381 | 1810381 | 2021-10-13 | Eagle | Colorado | 8037 | 8082 | 31 |
1810382 | 1810382 | 2021-10-13 | El Paso | Colorado | 8041 | 96167 | 1059 |
1810383 | 1810383 | 2021-10-13 | Elbert | Colorado | 8039 | 2567 | 22 |
1810384 | 1810384 | 2021-10-13 | Fremont | Colorado | 8043 | 7936 | 84 |
1810385 | 1810385 | 2021-10-13 | Garfield | Colorado | 8045 | 7597 | 60 |
1810386 | 1810386 | 2021-10-13 | Gilpin | Colorado | 8047 | 412 | 3 |
1810387 | 1810387 | 2021-10-13 | Grand | Colorado | 8049 | 2093 | 10 |
1810388 | 1810388 | 2021-10-13 | Gunnison | Colorado | 8051 | 1794 | 10 |
1810389 | 1810389 | 2021-10-13 | Hinsdale | Colorado | 8053 | 54 | 0 |
1810390 | 1810390 | 2021-10-13 | Huerfano | Colorado | 8055 | 596 | 19 |
1810391 | 1810391 | 2021-10-13 | Jackson | Colorado | 8057 | 101 | 0 |
1810392 | 1810392 | 2021-10-13 | Jefferson | Colorado | 8059 | 60330 | 888 |
1810393 | 1810393 | 2021-10-13 | Kiowa | Colorado | 8061 | 134 | 4 |
1810394 | 1810394 | 2021-10-13 | Kit Carson | Colorado | 8063 | 909 | 14 |
1810395 | 1810395 | 2021-10-13 | La Plata | Colorado | 8067 | 5529 | 52 |
1810396 | 1810396 | 2021-10-13 | Lake | Colorado | 8065 | 978 | 1 |
1810397 | 1810397 | 2021-10-13 | Larimer | Colorado | 8069 | 37010 | 291 |
1810398 | 1810398 | 2021-10-13 | Las Animas | Colorado | 8071 | 1715 | 21 |
1810399 | 1810399 | 2021-10-13 | Lincoln | Colorado | 8073 | 1274 | 7 |
1810400 | 1810400 | 2021-10-13 | Logan | Colorado | 8075 | 4548 | 79 |
1810401 | 1810401 | 2021-10-13 | Mesa | Colorado | 8077 | 22687 | 309 |
1810402 | 1810402 | 2021-10-13 | Mineral | Colorado | 8079 | 124 | 1 |
1810403 | 1810403 | 2021-10-13 | Moffat | Colorado | 8081 | 1881 | 37 |
1810404 | 1810404 | 2021-10-13 | Montezuma | Colorado | 8083 | 2866 | 34 |
1810405 | 1810405 | 2021-10-13 | Montrose | Colorado | 8085 | 5011 | 79 |
1810406 | 1810406 | 2021-10-13 | Morgan | Colorado | 8087 | 3244 | 98 |
1810407 | 1810407 | 2021-10-13 | Otero | Colorado | 8089 | 2453 | 78 |
1810408 | 1810408 | 2021-10-13 | Ouray | Colorado | 8091 | 416 | 5 |
1810409 | 1810409 | 2021-10-13 | Park | Colorado | 8093 | 1305 | 8 |
1810410 | 1810410 | 2021-10-13 | Phillips | Colorado | 8095 | 491 | 14 |
1810411 | 1810411 | 2021-10-13 | Pitkin | Colorado | 8097 | 3065 | 5 |
1810412 | 1810412 | 2021-10-13 | Prowers | Colorado | 8099 | 1550 | 29 |
1810413 | 1810413 | 2021-10-13 | Pueblo | Colorado | 8101 | 23681 | 469 |
1810414 | 1810414 | 2021-10-13 | Rio Blanco | Colorado | 8103 | 908 | 8 |
1810415 | 1810415 | 2021-10-13 | Rio Grande | Colorado | 8105 | 1395 | 21 |
1810416 | 1810416 | 2021-10-13 | Routt | Colorado | 8107 | 3224 | 23 |
1810417 | 1810417 | 2021-10-13 | Saguache | Colorado | 8109 | 633 | 8 |
1810418 | 1810418 | 2021-10-13 | San Juan | Colorado | 8111 | 94 | 1 |
1810419 | 1810419 | 2021-10-13 | San Miguel | Colorado | 8113 | 1151 | 4 |
1810420 | 1810420 | 2021-10-13 | Sedgwick | Colorado | 8115 | 285 | 4 |
1810421 | 1810421 | 2021-10-13 | Summit | Colorado | 8117 | 4665 | 10 |
1810422 | 1810422 | 2021-10-13 | Teller | Colorado | 8119 | 2662 | 25 |
1810423 | 1810423 | 2021-10-13 | Washington | Colorado | 8121 | 589 | 15 |
1810424 | 1810424 | 2021-10-13 | Weld | Colorado | 8123 | 44051 | 422 |
1810425 | 1810425 | 2021-10-13 | Yuma | Colorado | 8125 | 1165 | 18 |
1807113 | 1807113 | 2021-10-12 | Adams | Colorado | 8001 | 73788 | 859 |
1807114 | 1807114 | 2021-10-12 | Alamosa | Colorado | 8003 | 2288 | 43 |
1807115 | 1807115 | 2021-10-12 | Arapahoe | Colorado | 8005 | 77571 | 906 |
1807116 | 1807116 | 2021-10-12 | Archuleta | Colorado | 8007 | 1399 | 4 |
1807117 | 1807117 | 2021-10-12 | Baca | Colorado | 8009 | 410 | 5 |
1807118 | 1807118 | 2021-10-12 | Bent | Colorado | 8011 | 1648 | 23 |
1807119 | 1807119 | 2021-10-12 | Boulder | Colorado | 8013 | 29740 | 273 |
1807120 | 1807120 | 2021-10-12 | Broomfield | Colorado | 8014 | 6397 | 79 |
1807121 | 1807121 | 2021-10-12 | Chaffee | Colorado | 8015 | 2154 | 30 |
1807122 | 1807122 | 2021-10-12 | Cheyenne | Colorado | 8017 | 163 | 7 |
1807123 | 1807123 | 2021-10-12 | Clear Creek | Colorado | 8019 | 739 | 5 |
1807124 | 1807124 | 2021-10-12 | Conejos | Colorado | 8021 | 949 | 32 |
1807125 | 1807125 | 2021-10-12 | Costilla | Colorado | 8023 | 353 | 10 |
1807126 | 1807126 | 2021-10-12 | Crowley | Colorado | 8025 | 2333 | 21 |
1807127 | 1807127 | 2021-10-12 | Custer | Colorado | 8027 | 339 | 6 |
1807128 | 1807128 | 2021-10-12 | Delta | Colorado | 8029 | 3672 | 80 |
1807129 | 1807129 | 2021-10-12 | Denver | Colorado | 8031 | 88190 | 920 |
1807130 | 1807130 | 2021-10-12 | Dolores | Colorado | 8033 | 221 | 2 |
1807131 | 1807131 | 2021-10-12 | Douglas | Colorado | 8035 | 39223 | 308 |
1807132 | 1807132 | 2021-10-12 | Eagle | Colorado | 8037 | 8070 | 31 |
1807133 | 1807133 | 2021-10-12 | El Paso | Colorado | 8041 | 95848 | 1050 |
1807134 | 1807134 | 2021-10-12 | Elbert | Colorado | 8039 | 2555 | 21 |
1807135 | 1807135 | 2021-10-12 | Fremont | Colorado | 8043 | 7906 | 82 |
1807136 | 1807136 | 2021-10-12 | Garfield | Colorado | 8045 | 7562 | 60 |
1807137 | 1807137 | 2021-10-12 | Gilpin | Colorado | 8047 | 410 | 3 |
1807138 | 1807138 | 2021-10-12 | Grand | Colorado | 8049 | 2083 | 10 |
1807139 | 1807139 | 2021-10-12 | Gunnison | Colorado | 8051 | 1788 | 10 |
1807140 | 1807140 | 2021-10-12 | Hinsdale | Colorado | 8053 | 54 | 0 |
1807141 | 1807141 | 2021-10-12 | Huerfano | Colorado | 8055 | 594 | 19 |
1807142 | 1807142 | 2021-10-12 | Jackson | Colorado | 8057 | 100 | 0 |
1807143 | 1807143 | 2021-10-12 | Jefferson | Colorado | 8059 | 60164 | 888 |
1807144 | 1807144 | 2021-10-12 | Kiowa | Colorado | 8061 | 133 | 4 |
1807145 | 1807145 | 2021-10-12 | Kit Carson | Colorado | 8063 | 903 | 14 |
1807146 | 1807146 | 2021-10-12 | La Plata | Colorado | 8067 | 5496 | 52 |
1807147 | 1807147 | 2021-10-12 | Lake | Colorado | 8065 | 974 | 1 |
1807148 | 1807148 | 2021-10-12 | Larimer | Colorado | 8069 | 36835 | 290 |
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);