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 355
- Jefferson 355
- Denver 354
- Eagle 354
- El Paso 354
- Arapahoe 351
- Larimer 351
- Gunnison 350
- Pitkin 349
- Adams 348
- Clear Creek 347
- Pueblo 347
- Routt 347
- Summit 347
- Weld 347
- Boulder 346
- Mesa 346
- Garfield 345
- Yuma 342
- Crowley 341
- Grand 341
- Morgan 341
- Broomfield 340
- Park 340
- San Miguel 340
- Chaffee 339
- Elbert 339
- Hinsdale 339
- Montrose 339
- La Plata 337
- …
state 1
- Colorado · 21,047 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053750 | 1053750 | 2021-02-22 | Adams | Colorado | 8001 | 48712 | 627 |
1053751 | 1053751 | 2021-02-22 | Alamosa | Colorado | 8003 | 1255 | 28 |
1053752 | 1053752 | 2021-02-22 | Arapahoe | Colorado | 8005 | 48730 | 688 |
1053753 | 1053753 | 2021-02-22 | Archuleta | Colorado | 8007 | 630 | 1 |
1053754 | 1053754 | 2021-02-22 | Baca | Colorado | 8009 | 270 | 4 |
1053755 | 1053755 | 2021-02-22 | Bent | Colorado | 8011 | 1468 | 21 |
1053756 | 1053756 | 2021-02-22 | Boulder | Colorado | 8013 | 18633 | 245 |
1053757 | 1053757 | 2021-02-22 | Broomfield | Colorado | 8014 | 3665 | 74 |
1053758 | 1053758 | 2021-02-22 | Chaffee | Colorado | 8015 | 1411 | 23 |
1053759 | 1053759 | 2021-02-22 | Cheyenne | Colorado | 8017 | 125 | 5 |
1053760 | 1053760 | 2021-02-22 | Clear Creek | Colorado | 8019 | 359 | 2 |
1053761 | 1053761 | 2021-02-22 | Conejos | Colorado | 8021 | 433 | 7 |
1053762 | 1053762 | 2021-02-22 | Costilla | Colorado | 8023 | 182 | 2 |
1053763 | 1053763 | 2021-02-22 | Crowley | Colorado | 8025 | 1959 | 14 |
1053764 | 1053764 | 2021-02-22 | Custer | Colorado | 8027 | 164 | 1 |
1053765 | 1053765 | 2021-02-22 | Delta | Colorado | 8029 | 2444 | 58 |
1053766 | 1053766 | 2021-02-22 | Denver | Colorado | 8031 | 58688 | 766 |
1053767 | 1053767 | 2021-02-22 | Dolores | Colorado | 8033 | 67 | 0 |
1053768 | 1053768 | 2021-02-22 | Douglas | Colorado | 8035 | 21347 | 230 |
1053769 | 1053769 | 2021-02-22 | Eagle | Colorado | 8037 | 4907 | 20 |
1053770 | 1053770 | 2021-02-22 | El Paso | Colorado | 8041 | 51145 | 742 |
1053771 | 1053771 | 2021-02-22 | Elbert | Colorado | 8039 | 1257 | 12 |
1053772 | 1053772 | 2021-02-22 | Fremont | Colorado | 8043 | 5418 | 48 |
1053773 | 1053773 | 2021-02-22 | Garfield | Colorado | 8045 | 5026 | 38 |
1053774 | 1053774 | 2021-02-22 | Gilpin | Colorado | 8047 | 165 | 3 |
1053775 | 1053775 | 2021-02-22 | Grand | Colorado | 8049 | 1242 | 5 |
1053776 | 1053776 | 2021-02-22 | Gunnison | Colorado | 8051 | 1182 | 6 |
1053777 | 1053777 | 2021-02-22 | Hinsdale | Colorado | 8053 | 16 | 0 |
1053778 | 1053778 | 2021-02-22 | Huerfano | Colorado | 8055 | 300 | 17 |
1053779 | 1053779 | 2021-02-22 | Jackson | Colorado | 8057 | 51 | 0 |
1053780 | 1053780 | 2021-02-22 | Jefferson | Colorado | 8059 | 36588 | 706 |
1053781 | 1053781 | 2021-02-22 | Kiowa | Colorado | 8061 | 91 | 3 |
1053782 | 1053782 | 2021-02-22 | Kit Carson | Colorado | 8063 | 524 | 10 |
1053783 | 1053783 | 2021-02-22 | La Plata | Colorado | 8067 | 2890 | 37 |
1053784 | 1053784 | 2021-02-22 | Lake | Colorado | 8065 | 651 | 0 |
1053785 | 1053785 | 2021-02-22 | Larimer | Colorado | 8069 | 19594 | 219 |
1053786 | 1053786 | 2021-02-22 | Las Animas | Colorado | 8071 | 982 | 11 |
1053787 | 1053787 | 2021-02-22 | Lincoln | Colorado | 8073 | 996 | 3 |
1053788 | 1053788 | 2021-02-22 | Logan | Colorado | 8075 | 3705 | 63 |
1053789 | 1053789 | 2021-02-22 | Mesa | Colorado | 8077 | 13097 | 190 |
1053790 | 1053790 | 2021-02-22 | Mineral | Colorado | 8079 | 61 | 1 |
1053791 | 1053791 | 2021-02-22 | Moffat | Colorado | 8081 | 657 | 22 |
1053792 | 1053792 | 2021-02-22 | Montezuma | Colorado | 8083 | 1708 | 22 |
1053793 | 1053793 | 2021-02-22 | Montrose | Colorado | 8085 | 3195 | 52 |
1053794 | 1053794 | 2021-02-22 | Morgan | Colorado | 8087 | 2415 | 90 |
1053795 | 1053795 | 2021-02-22 | Otero | Colorado | 8089 | 1840 | 61 |
1053796 | 1053796 | 2021-02-22 | Ouray | Colorado | 8091 | 247 | 3 |
1053797 | 1053797 | 2021-02-22 | Park | Colorado | 8093 | 540 | 5 |
1053798 | 1053798 | 2021-02-22 | Phillips | Colorado | 8095 | 333 | 12 |
1053799 | 1053799 | 2021-02-22 | Pitkin | Colorado | 8097 | 1947 | 4 |
1053800 | 1053800 | 2021-02-22 | Prowers | Colorado | 8099 | 1157 | 21 |
1053801 | 1053801 | 2021-02-22 | Pueblo | Colorado | 8101 | 14881 | 362 |
1053802 | 1053802 | 2021-02-22 | Rio Blanco | Colorado | 8103 | 455 | 3 |
1053803 | 1053803 | 2021-02-22 | Rio Grande | Colorado | 8105 | 685 | 12 |
1053804 | 1053804 | 2021-02-22 | Routt | Colorado | 8107 | 1832 | 19 |
1053805 | 1053805 | 2021-02-22 | Saguache | Colorado | 8109 | 313 | 4 |
1053806 | 1053806 | 2021-02-22 | San Juan | Colorado | 8111 | 41 | 0 |
1053807 | 1053807 | 2021-02-22 | San Miguel | Colorado | 8113 | 802 | 0 |
1053808 | 1053808 | 2021-02-22 | Sedgwick | Colorado | 8115 | 191 | 2 |
1053809 | 1053809 | 2021-02-22 | Summit | Colorado | 8117 | 2961 | 7 |
1053810 | 1053810 | 2021-02-22 | Teller | Colorado | 8119 | 1252 | 14 |
1053811 | 1053811 | 2021-02-22 | Washington | Colorado | 8121 | 378 | 12 |
1053812 | 1053812 | 2021-02-22 | Weld | Colorado | 8123 | 25137 | 316 |
1053813 | 1053813 | 2021-02-22 | Yuma | Colorado | 8125 | 700 | 17 |
1050503 | 1050503 | 2021-02-21 | Adams | Colorado | 8001 | 48643 | 627 |
1050504 | 1050504 | 2021-02-21 | Alamosa | Colorado | 8003 | 1257 | 28 |
1050505 | 1050505 | 2021-02-21 | Arapahoe | Colorado | 8005 | 48627 | 688 |
1050506 | 1050506 | 2021-02-21 | Archuleta | Colorado | 8007 | 629 | 1 |
1050507 | 1050507 | 2021-02-21 | Baca | Colorado | 8009 | 270 | 4 |
1050508 | 1050508 | 2021-02-21 | Bent | Colorado | 8011 | 1469 | 21 |
1050509 | 1050509 | 2021-02-21 | Boulder | Colorado | 8013 | 18599 | 245 |
1050510 | 1050510 | 2021-02-21 | Broomfield | Colorado | 8014 | 3654 | 74 |
1050511 | 1050511 | 2021-02-21 | Chaffee | Colorado | 8015 | 1411 | 23 |
1050512 | 1050512 | 2021-02-21 | Cheyenne | Colorado | 8017 | 125 | 5 |
1050513 | 1050513 | 2021-02-21 | Clear Creek | Colorado | 8019 | 357 | 2 |
1050514 | 1050514 | 2021-02-21 | Conejos | Colorado | 8021 | 432 | 7 |
1050515 | 1050515 | 2021-02-21 | Costilla | Colorado | 8023 | 178 | 2 |
1050516 | 1050516 | 2021-02-21 | Crowley | Colorado | 8025 | 1959 | 14 |
1050517 | 1050517 | 2021-02-21 | Custer | Colorado | 8027 | 164 | 1 |
1050518 | 1050518 | 2021-02-21 | Delta | Colorado | 8029 | 2439 | 58 |
1050519 | 1050519 | 2021-02-21 | Denver | Colorado | 8031 | 58628 | 766 |
1050520 | 1050520 | 2021-02-21 | Dolores | Colorado | 8033 | 67 | 0 |
1050521 | 1050521 | 2021-02-21 | Douglas | Colorado | 8035 | 21290 | 230 |
1050522 | 1050522 | 2021-02-21 | Eagle | Colorado | 8037 | 4897 | 20 |
1050523 | 1050523 | 2021-02-21 | El Paso | Colorado | 8041 | 50951 | 741 |
1050524 | 1050524 | 2021-02-21 | Elbert | Colorado | 8039 | 1254 | 12 |
1050525 | 1050525 | 2021-02-21 | Fremont | Colorado | 8043 | 5403 | 48 |
1050526 | 1050526 | 2021-02-21 | Garfield | Colorado | 8045 | 5022 | 38 |
1050527 | 1050527 | 2021-02-21 | Gilpin | Colorado | 8047 | 165 | 3 |
1050528 | 1050528 | 2021-02-21 | Grand | Colorado | 8049 | 1241 | 5 |
1050529 | 1050529 | 2021-02-21 | Gunnison | Colorado | 8051 | 1181 | 6 |
1050530 | 1050530 | 2021-02-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
1050531 | 1050531 | 2021-02-21 | Huerfano | Colorado | 8055 | 300 | 17 |
1050532 | 1050532 | 2021-02-21 | Jackson | Colorado | 8057 | 51 | 0 |
1050533 | 1050533 | 2021-02-21 | Jefferson | Colorado | 8059 | 36523 | 706 |
1050534 | 1050534 | 2021-02-21 | Kiowa | Colorado | 8061 | 91 | 3 |
1050535 | 1050535 | 2021-02-21 | Kit Carson | Colorado | 8063 | 524 | 10 |
1050536 | 1050536 | 2021-02-21 | La Plata | Colorado | 8067 | 2879 | 37 |
1050537 | 1050537 | 2021-02-21 | Lake | Colorado | 8065 | 651 | 0 |
1050538 | 1050538 | 2021-02-21 | Larimer | Colorado | 8069 | 19532 | 219 |
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);