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 132
- Jefferson 132
- Denver 131
- Eagle 131
- El Paso 131
- Arapahoe 128
- Larimer 128
- Gunnison 127
- Pitkin 126
- Adams 125
- Clear Creek 124
- Pueblo 124
- Routt 124
- Summit 124
- Weld 124
- Boulder 123
- Mesa 123
- Garfield 122
- Yuma 119
- Crowley 118
- Grand 118
- Morgan 118
- Broomfield 117
- Park 117
- San Miguel 117
- Chaffee 116
- Elbert 116
- Hinsdale 116
- Montrose 116
- La Plata 114
- …
state 1
- Colorado · 6,848 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
331687 | 331687 | 2020-07-14 | Adams | Colorado | 8001 | 4847 | 159 |
331688 | 331688 | 2020-07-14 | Alamosa | Colorado | 8003 | 204 | 7 |
331689 | 331689 | 2020-07-14 | Arapahoe | Colorado | 8005 | 5734 | 352 |
331690 | 331690 | 2020-07-14 | Archuleta | Colorado | 8007 | 12 | 0 |
331691 | 331691 | 2020-07-14 | Baca | Colorado | 8009 | 14 | 0 |
331692 | 331692 | 2020-07-14 | Bent | Colorado | 8011 | 4 | 0 |
331693 | 331693 | 2020-07-14 | Boulder | Colorado | 8013 | 1572 | 74 |
331694 | 331694 | 2020-07-14 | Broomfield | Colorado | 8014 | 348 | 30 |
331695 | 331695 | 2020-07-14 | Chaffee | Colorado | 8015 | 123 | 19 |
331696 | 331696 | 2020-07-14 | Cheyenne | Colorado | 8017 | 5 | 0 |
331697 | 331697 | 2020-07-14 | Clear Creek | Colorado | 8019 | 21 | 1 |
331698 | 331698 | 2020-07-14 | Conejos | Colorado | 8021 | 18 | 0 |
331699 | 331699 | 2020-07-14 | Costilla | Colorado | 8023 | 22 | 0 |
331700 | 331700 | 2020-07-14 | Crowley | Colorado | 8025 | 71 | 1 |
331701 | 331701 | 2020-07-14 | Custer | Colorado | 8027 | 7 | 0 |
331702 | 331702 | 2020-07-14 | Delta | Colorado | 8029 | 84 | 1 |
331703 | 331703 | 2020-07-14 | Denver | Colorado | 8031 | 8011 | 395 |
331704 | 331704 | 2020-07-14 | Douglas | Colorado | 8035 | 1201 | 53 |
331705 | 331705 | 2020-07-14 | Eagle | Colorado | 8037 | 783 | 8 |
331706 | 331706 | 2020-07-14 | El Paso | Colorado | 8041 | 3224 | 118 |
331707 | 331707 | 2020-07-14 | Elbert | Colorado | 8039 | 65 | 2 |
331708 | 331708 | 2020-07-14 | Fremont | Colorado | 8043 | 46 | 0 |
331709 | 331709 | 2020-07-14 | Garfield | Colorado | 8045 | 441 | 3 |
331710 | 331710 | 2020-07-14 | Gilpin | Colorado | 8047 | 8 | 0 |
331711 | 331711 | 2020-07-14 | Grand | Colorado | 8049 | 29 | 1 |
331712 | 331712 | 2020-07-14 | Gunnison | Colorado | 8051 | 193 | 6 |
331713 | 331713 | 2020-07-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
331714 | 331714 | 2020-07-14 | Huerfano | Colorado | 8055 | 5 | 1 |
331715 | 331715 | 2020-07-14 | Jackson | Colorado | 8057 | 8 | 0 |
331716 | 331716 | 2020-07-14 | Jefferson | Colorado | 8059 | 3089 | 217 |
331717 | 331717 | 2020-07-14 | Kit Carson | Colorado | 8063 | 37 | 3 |
331718 | 331718 | 2020-07-14 | La Plata | Colorado | 8067 | 146 | 1 |
331719 | 331719 | 2020-07-14 | Lake | Colorado | 8065 | 54 | 0 |
331720 | 331720 | 2020-07-14 | Larimer | Colorado | 8069 | 959 | 30 |
331721 | 331721 | 2020-07-14 | Las Animas | Colorado | 8071 | 10 | 0 |
331722 | 331722 | 2020-07-14 | Lincoln | Colorado | 8073 | 4 | 0 |
331723 | 331723 | 2020-07-14 | Logan | Colorado | 8075 | 641 | 5 |
331724 | 331724 | 2020-07-14 | Mesa | Colorado | 8077 | 153 | 0 |
331725 | 331725 | 2020-07-14 | Mineral | Colorado | 8079 | 17 | 0 |
331726 | 331726 | 2020-07-14 | Moffat | Colorado | 8081 | 16 | 1 |
331727 | 331727 | 2020-07-14 | Montezuma | Colorado | 8083 | 81 | 3 |
331728 | 331728 | 2020-07-14 | Montrose | Colorado | 8085 | 223 | 12 |
331729 | 331729 | 2020-07-14 | Morgan | Colorado | 8087 | 661 | 46 |
331730 | 331730 | 2020-07-14 | Otero | Colorado | 8089 | 23 | 1 |
331731 | 331731 | 2020-07-14 | Ouray | Colorado | 8091 | 12 | 1 |
331732 | 331732 | 2020-07-14 | Park | Colorado | 8093 | 33 | 0 |
331733 | 331733 | 2020-07-14 | Phillips | Colorado | 8095 | 16 | 0 |
331734 | 331734 | 2020-07-14 | Pitkin | Colorado | 8097 | 138 | 2 |
331735 | 331735 | 2020-07-14 | Prowers | Colorado | 8099 | 38 | 0 |
331736 | 331736 | 2020-07-14 | Pueblo | Colorado | 8101 | 450 | 32 |
331737 | 331737 | 2020-07-14 | Rio Blanco | Colorado | 8103 | 6 | 0 |
331738 | 331738 | 2020-07-14 | Rio Grande | Colorado | 8105 | 82 | 2 |
331739 | 331739 | 2020-07-14 | Routt | Colorado | 8107 | 84 | 6 |
331740 | 331740 | 2020-07-14 | Saguache | Colorado | 8109 | 103 | 2 |
331741 | 331741 | 2020-07-14 | San Juan | Colorado | 8111 | 2 | 0 |
331742 | 331742 | 2020-07-14 | San Miguel | Colorado | 8113 | 50 | 0 |
331743 | 331743 | 2020-07-14 | Sedgwick | Colorado | 8115 | 2 | 0 |
331744 | 331744 | 2020-07-14 | Summit | Colorado | 8117 | 293 | 4 |
331745 | 331745 | 2020-07-14 | Teller | Colorado | 8119 | 65 | 2 |
331746 | 331746 | 2020-07-14 | Washington | Colorado | 8121 | 46 | 0 |
331747 | 331747 | 2020-07-14 | Weld | Colorado | 8123 | 3070 | 138 |
331748 | 331748 | 2020-07-14 | Yuma | Colorado | 8125 | 54 | 0 |
328501 | 328501 | 2020-07-13 | Adams | Colorado | 8001 | 4788 | 158 |
328502 | 328502 | 2020-07-13 | Alamosa | Colorado | 8003 | 204 | 6 |
328503 | 328503 | 2020-07-13 | Arapahoe | Colorado | 8005 | 5682 | 349 |
328504 | 328504 | 2020-07-13 | Archuleta | Colorado | 8007 | 12 | 0 |
328505 | 328505 | 2020-07-13 | Baca | Colorado | 8009 | 14 | 0 |
328506 | 328506 | 2020-07-13 | Bent | Colorado | 8011 | 4 | 0 |
328507 | 328507 | 2020-07-13 | Boulder | Colorado | 8013 | 1542 | 73 |
328508 | 328508 | 2020-07-13 | Broomfield | Colorado | 8014 | 342 | 30 |
328509 | 328509 | 2020-07-13 | Chaffee | Colorado | 8015 | 121 | 19 |
328510 | 328510 | 2020-07-13 | Cheyenne | Colorado | 8017 | 5 | 0 |
328511 | 328511 | 2020-07-13 | Clear Creek | Colorado | 8019 | 21 | 1 |
328512 | 328512 | 2020-07-13 | Conejos | Colorado | 8021 | 18 | 0 |
328513 | 328513 | 2020-07-13 | Costilla | Colorado | 8023 | 22 | 0 |
328514 | 328514 | 2020-07-13 | Crowley | Colorado | 8025 | 71 | 1 |
328515 | 328515 | 2020-07-13 | Custer | Colorado | 8027 | 7 | 0 |
328516 | 328516 | 2020-07-13 | Delta | Colorado | 8029 | 84 | 1 |
328517 | 328517 | 2020-07-13 | Denver | Colorado | 8031 | 7952 | 394 |
328518 | 328518 | 2020-07-13 | Douglas | Colorado | 8035 | 1178 | 52 |
328519 | 328519 | 2020-07-13 | Eagle | Colorado | 8037 | 766 | 8 |
328520 | 328520 | 2020-07-13 | El Paso | Colorado | 8041 | 3155 | 117 |
328521 | 328521 | 2020-07-13 | Elbert | Colorado | 8039 | 63 | 2 |
328522 | 328522 | 2020-07-13 | Fremont | Colorado | 8043 | 45 | 0 |
328523 | 328523 | 2020-07-13 | Garfield | Colorado | 8045 | 423 | 3 |
328524 | 328524 | 2020-07-13 | Gilpin | Colorado | 8047 | 8 | 0 |
328525 | 328525 | 2020-07-13 | Grand | Colorado | 8049 | 29 | 1 |
328526 | 328526 | 2020-07-13 | Gunnison | Colorado | 8051 | 193 | 6 |
328527 | 328527 | 2020-07-13 | Hinsdale | Colorado | 8053 | 3 | 0 |
328528 | 328528 | 2020-07-13 | Huerfano | Colorado | 8055 | 5 | 1 |
328529 | 328529 | 2020-07-13 | Jackson | Colorado | 8057 | 8 | 0 |
328530 | 328530 | 2020-07-13 | Jefferson | Colorado | 8059 | 3055 | 216 |
328531 | 328531 | 2020-07-13 | Kit Carson | Colorado | 8063 | 37 | 3 |
328532 | 328532 | 2020-07-13 | La Plata | Colorado | 8067 | 136 | 1 |
328533 | 328533 | 2020-07-13 | Lake | Colorado | 8065 | 54 | 0 |
328534 | 328534 | 2020-07-13 | Larimer | Colorado | 8069 | 946 | 30 |
328535 | 328535 | 2020-07-13 | Las Animas | Colorado | 8071 | 10 | 0 |
328536 | 328536 | 2020-07-13 | Lincoln | Colorado | 8073 | 4 | 0 |
328537 | 328537 | 2020-07-13 | Logan | Colorado | 8075 | 641 | 5 |
328538 | 328538 | 2020-07-13 | Mesa | Colorado | 8077 | 146 | 0 |
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);