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 224
- Jefferson 224
- Denver 223
- Eagle 223
- El Paso 223
- Arapahoe 220
- Larimer 220
- Gunnison 219
- Pitkin 219
- Adams 217
- Pueblo 217
- Routt 217
- Summit 217
- Weld 217
- Clear Creek 216
- Mesa 216
- Boulder 215
- Garfield 214
- Yuma 212
- Morgan 211
- Crowley 210
- Grand 210
- Park 210
- San Miguel 210
- Broomfield 209
- Montrose 209
- Chaffee 208
- Elbert 208
- Hinsdale 208
- Logan 207
- …
state 1
- Colorado · 12,691 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631919 | 631919 | 2020-10-15 | Las Animas | Colorado | 8071 | 31 | 0 |
631920 | 631920 | 2020-10-15 | Lincoln | Colorado | 8073 | 24 | 0 |
631921 | 631921 | 2020-10-15 | Logan | Colorado | 8075 | 1038 | 10 |
631922 | 631922 | 2020-10-15 | Mesa | Colorado | 8077 | 847 | 8 |
631923 | 631923 | 2020-10-15 | Mineral | Colorado | 8079 | 21 | 0 |
631924 | 631924 | 2020-10-15 | Moffat | Colorado | 8081 | 49 | 1 |
631925 | 631925 | 2020-10-15 | Montezuma | Colorado | 8083 | 173 | 5 |
631926 | 631926 | 2020-10-15 | Montrose | Colorado | 8085 | 412 | 13 |
631927 | 631927 | 2020-10-15 | Morgan | Colorado | 8087 | 800 | 48 |
631928 | 631928 | 2020-10-15 | Otero | Colorado | 8089 | 114 | 6 |
631929 | 631929 | 2020-10-15 | Ouray | Colorado | 8091 | 32 | 1 |
631930 | 631930 | 2020-10-15 | Park | Colorado | 8093 | 65 | 1 |
631931 | 631931 | 2020-10-15 | Phillips | Colorado | 8095 | 35 | 0 |
631932 | 631932 | 2020-10-15 | Pitkin | Colorado | 8097 | 253 | 2 |
631933 | 631933 | 2020-10-15 | Prowers | Colorado | 8099 | 102 | 0 |
631934 | 631934 | 2020-10-15 | Pueblo | Colorado | 8101 | 1492 | 39 |
631935 | 631935 | 2020-10-15 | Rio Blanco | Colorado | 8103 | 25 | 0 |
631936 | 631936 | 2020-10-15 | Rio Grande | Colorado | 8105 | 112 | 2 |
631937 | 631937 | 2020-10-15 | Routt | Colorado | 8107 | 175 | 8 |
631938 | 631938 | 2020-10-15 | Saguache | Colorado | 8109 | 117 | 2 |
631939 | 631939 | 2020-10-15 | San Juan | Colorado | 8111 | 6 | 0 |
631940 | 631940 | 2020-10-15 | San Miguel | Colorado | 8113 | 99 | 0 |
631941 | 631941 | 2020-10-15 | Sedgwick | Colorado | 8115 | 16 | 1 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
631943 | 631943 | 2020-10-15 | Teller | Colorado | 8119 | 186 | 4 |
631944 | 631944 | 2020-10-15 | Washington | Colorado | 8121 | 77 | 0 |
631945 | 631945 | 2020-10-15 | Weld | Colorado | 8123 | 5264 | 155 |
631946 | 631946 | 2020-10-15 | Yuma | Colorado | 8125 | 173 | 1 |
628639 | 628639 | 2020-10-14 | Adams | Colorado | 8001 | 11127 | 244 |
628640 | 628640 | 2020-10-14 | Alamosa | Colorado | 8003 | 267 | 9 |
628641 | 628641 | 2020-10-14 | Arapahoe | Colorado | 8005 | 10786 | 390 |
628642 | 628642 | 2020-10-14 | Archuleta | Colorado | 8007 | 58 | 0 |
628643 | 628643 | 2020-10-14 | Baca | Colorado | 8009 | 23 | 0 |
628644 | 628644 | 2020-10-14 | Bent | Colorado | 8011 | 12 | 0 |
628645 | 628645 | 2020-10-14 | Boulder | Colorado | 8013 | 4910 | 83 |
628646 | 628646 | 2020-10-14 | Broomfield | Colorado | 8014 | 756 | 37 |
628647 | 628647 | 2020-10-14 | Chaffee | Colorado | 8015 | 358 | 20 |
628648 | 628648 | 2020-10-14 | Cheyenne | Colorado | 8017 | 14 | 0 |
628649 | 628649 | 2020-10-14 | Clear Creek | Colorado | 8019 | 61 | 1 |
628650 | 628650 | 2020-10-14 | Conejos | Colorado | 8021 | 44 | 0 |
628651 | 628651 | 2020-10-14 | Costilla | Colorado | 8023 | 33 | 1 |
628652 | 628652 | 2020-10-14 | Crowley | Colorado | 8025 | 77 | 1 |
628653 | 628653 | 2020-10-14 | Custer | Colorado | 8027 | 19 | 0 |
628654 | 628654 | 2020-10-14 | Delta | Colorado | 8029 | 194 | 4 |
628655 | 628655 | 2020-10-14 | Denver | Colorado | 8031 | 15251 | 449 |
628656 | 628656 | 2020-10-14 | Dolores | Colorado | 8033 | 3 | 0 |
628657 | 628657 | 2020-10-14 | Douglas | Colorado | 8035 | 3241 | 63 |
628658 | 628658 | 2020-10-14 | Eagle | Colorado | 8037 | 1331 | 10 |
628659 | 628659 | 2020-10-14 | El Paso | Colorado | 8041 | 8001 | 188 |
628660 | 628660 | 2020-10-14 | Elbert | Colorado | 8039 | 177 | 3 |
628661 | 628661 | 2020-10-14 | Fremont | Colorado | 8043 | 275 | 1 |
628662 | 628662 | 2020-10-14 | Garfield | Colorado | 8045 | 1028 | 5 |
628663 | 628663 | 2020-10-14 | Gilpin | Colorado | 8047 | 21 | 0 |
628664 | 628664 | 2020-10-14 | Grand | Colorado | 8049 | 118 | 1 |
628665 | 628665 | 2020-10-14 | Gunnison | Colorado | 8051 | 297 | 7 |
628666 | 628666 | 2020-10-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
628667 | 628667 | 2020-10-14 | Huerfano | Colorado | 8055 | 27 | 2 |
628668 | 628668 | 2020-10-14 | Jackson | Colorado | 8057 | 9 | 0 |
628669 | 628669 | 2020-10-14 | Jefferson | Colorado | 8059 | 6806 | 296 |
628670 | 628670 | 2020-10-14 | Kiowa | Colorado | 8061 | 1 | 0 |
628671 | 628671 | 2020-10-14 | Kit Carson | Colorado | 8063 | 98 | 3 |
628672 | 628672 | 2020-10-14 | La Plata | Colorado | 8067 | 302 | 2 |
628673 | 628673 | 2020-10-14 | Lake | Colorado | 8065 | 112 | 0 |
628674 | 628674 | 2020-10-14 | Larimer | Colorado | 8069 | 3259 | 55 |
628675 | 628675 | 2020-10-14 | Las Animas | Colorado | 8071 | 30 | 0 |
628676 | 628676 | 2020-10-14 | Lincoln | Colorado | 8073 | 24 | 0 |
628677 | 628677 | 2020-10-14 | Logan | Colorado | 8075 | 1035 | 10 |
628678 | 628678 | 2020-10-14 | Mesa | Colorado | 8077 | 837 | 8 |
628679 | 628679 | 2020-10-14 | Mineral | Colorado | 8079 | 20 | 0 |
628680 | 628680 | 2020-10-14 | Moffat | Colorado | 8081 | 48 | 1 |
628681 | 628681 | 2020-10-14 | Montezuma | Colorado | 8083 | 172 | 5 |
628682 | 628682 | 2020-10-14 | Montrose | Colorado | 8085 | 405 | 13 |
628683 | 628683 | 2020-10-14 | Morgan | Colorado | 8087 | 788 | 48 |
628684 | 628684 | 2020-10-14 | Otero | Colorado | 8089 | 113 | 6 |
628685 | 628685 | 2020-10-14 | Ouray | Colorado | 8091 | 32 | 1 |
628686 | 628686 | 2020-10-14 | Park | Colorado | 8093 | 65 | 1 |
628687 | 628687 | 2020-10-14 | Phillips | Colorado | 8095 | 35 | 0 |
628688 | 628688 | 2020-10-14 | Pitkin | Colorado | 8097 | 250 | 2 |
628689 | 628689 | 2020-10-14 | Prowers | Colorado | 8099 | 99 | 0 |
628690 | 628690 | 2020-10-14 | Pueblo | Colorado | 8101 | 1439 | 39 |
628691 | 628691 | 2020-10-14 | Rio Blanco | Colorado | 8103 | 25 | 0 |
628692 | 628692 | 2020-10-14 | Rio Grande | Colorado | 8105 | 110 | 2 |
628693 | 628693 | 2020-10-14 | Routt | Colorado | 8107 | 172 | 8 |
628694 | 628694 | 2020-10-14 | Saguache | Colorado | 8109 | 116 | 2 |
628695 | 628695 | 2020-10-14 | San Juan | Colorado | 8111 | 6 | 0 |
628696 | 628696 | 2020-10-14 | San Miguel | Colorado | 8113 | 97 | 0 |
628697 | 628697 | 2020-10-14 | Sedgwick | Colorado | 8115 | 16 | 1 |
628698 | 628698 | 2020-10-14 | Summit | Colorado | 8117 | 529 | 4 |
628699 | 628699 | 2020-10-14 | Teller | Colorado | 8119 | 184 | 4 |
628700 | 628700 | 2020-10-14 | Washington | Colorado | 8121 | 74 | 0 |
628701 | 628701 | 2020-10-14 | Weld | Colorado | 8123 | 5227 | 155 |
628702 | 628702 | 2020-10-14 | Yuma | Colorado | 8125 | 158 | 1 |
625396 | 625396 | 2020-10-13 | Adams | Colorado | 8001 | 10962 | 243 |
625397 | 625397 | 2020-10-13 | Alamosa | Colorado | 8003 | 265 | 9 |
625398 | 625398 | 2020-10-13 | Arapahoe | Colorado | 8005 | 10706 | 390 |
625399 | 625399 | 2020-10-13 | Archuleta | Colorado | 8007 | 58 | 0 |
625400 | 625400 | 2020-10-13 | Baca | Colorado | 8009 | 19 | 0 |
625401 | 625401 | 2020-10-13 | Bent | Colorado | 8011 | 11 | 0 |
625402 | 625402 | 2020-10-13 | Boulder | Colorado | 8013 | 4884 | 83 |
625403 | 625403 | 2020-10-13 | Broomfield | Colorado | 8014 | 749 | 37 |
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);