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 322
- Jefferson 322
- Denver 321
- Eagle 321
- El Paso 321
- Arapahoe 318
- Larimer 318
- Gunnison 317
- Pitkin 317
- Adams 315
- Pueblo 315
- Routt 315
- Summit 315
- Weld 315
- Clear Creek 314
- Mesa 314
- Boulder 313
- Garfield 312
- Yuma 310
- Morgan 309
- Crowley 308
- Grand 308
- Park 308
- San Miguel 308
- Broomfield 307
- Montrose 307
- Chaffee 306
- Elbert 306
- Hinsdale 306
- Logan 305
- …
state 1
- Colorado · 18,963 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
949927 | 949927 | 2021-01-21 | Las Animas | Colorado | 8071 | 887 | 10 |
949928 | 949928 | 2021-01-21 | Lincoln | Colorado | 8073 | 835 | 3 |
949929 | 949929 | 2021-01-21 | Logan | Colorado | 8075 | 3550 | 57 |
949930 | 949930 | 2021-01-21 | Mesa | Colorado | 8077 | 11266 | 157 |
949931 | 949931 | 2021-01-21 | Mineral | Colorado | 8079 | 55 | 1 |
949932 | 949932 | 2021-01-21 | Moffat | Colorado | 8081 | 605 | 23 |
949933 | 949933 | 2021-01-21 | Montezuma | Colorado | 8083 | 1555 | 19 |
949934 | 949934 | 2021-01-21 | Montrose | Colorado | 8085 | 2805 | 41 |
949935 | 949935 | 2021-01-21 | Morgan | Colorado | 8087 | 2330 | 86 |
949936 | 949936 | 2021-01-21 | Otero | Colorado | 8089 | 1763 | 57 |
949937 | 949937 | 2021-01-21 | Ouray | Colorado | 8091 | 180 | 3 |
949938 | 949938 | 2021-01-21 | Park | Colorado | 8093 | 461 | 5 |
949939 | 949939 | 2021-01-21 | Phillips | Colorado | 8095 | 316 | 10 |
949940 | 949940 | 2021-01-21 | Pitkin | Colorado | 8097 | 1732 | 4 |
949941 | 949941 | 2021-01-21 | Prowers | Colorado | 8099 | 1088 | 21 |
949942 | 949942 | 2021-01-21 | Pueblo | Colorado | 8101 | 14113 | 355 |
949943 | 949943 | 2021-01-21 | Rio Blanco | Colorado | 8103 | 349 | 3 |
949944 | 949944 | 2021-01-21 | Rio Grande | Colorado | 8105 | 560 | 11 |
949945 | 949945 | 2021-01-21 | Routt | Colorado | 8107 | 1415 | 19 |
949946 | 949946 | 2021-01-21 | Saguache | Colorado | 8109 | 286 | 4 |
949947 | 949947 | 2021-01-21 | San Juan | Colorado | 8111 | 35 | 0 |
949948 | 949948 | 2021-01-21 | San Miguel | Colorado | 8113 | 532 | 0 |
949949 | 949949 | 2021-01-21 | Sedgwick | Colorado | 8115 | 182 | 2 |
949950 | 949950 | 2021-01-21 | Summit | Colorado | 8117 | 2460 | 5 |
949951 | 949951 | 2021-01-21 | Teller | Colorado | 8119 | 1129 | 13 |
949952 | 949952 | 2021-01-21 | Washington | Colorado | 8121 | 364 | 11 |
949953 | 949953 | 2021-01-21 | Weld | Colorado | 8123 | 22913 | 299 |
949954 | 949954 | 2021-01-21 | Yuma | Colorado | 8125 | 632 | 14 |
946645 | 946645 | 2021-01-20 | Adams | Colorado | 8001 | 44980 | 578 |
946646 | 946646 | 2021-01-20 | Alamosa | Colorado | 8003 | 1088 | 27 |
946647 | 946647 | 2021-01-20 | Arapahoe | Colorado | 8005 | 43837 | 639 |
946648 | 946648 | 2021-01-20 | Archuleta | Colorado | 8007 | 570 | 1 |
946649 | 946649 | 2021-01-20 | Baca | Colorado | 8009 | 248 | 2 |
946650 | 946650 | 2021-01-20 | Bent | Colorado | 8011 | 1269 | 18 |
946651 | 946651 | 2021-01-20 | Boulder | Colorado | 8013 | 16546 | 217 |
946652 | 946652 | 2021-01-20 | Broomfield | Colorado | 8014 | 3219 | 68 |
946653 | 946653 | 2021-01-20 | Chaffee | Colorado | 8015 | 1235 | 23 |
946654 | 946654 | 2021-01-20 | Cheyenne | Colorado | 8017 | 112 | 5 |
946655 | 946655 | 2021-01-20 | Clear Creek | Colorado | 8019 | 337 | 2 |
946656 | 946656 | 2021-01-20 | Conejos | Colorado | 8021 | 375 | 3 |
946657 | 946657 | 2021-01-20 | Costilla | Colorado | 8023 | 175 | 2 |
946658 | 946658 | 2021-01-20 | Crowley | Colorado | 8025 | 1743 | 14 |
946659 | 946659 | 2021-01-20 | Custer | Colorado | 8027 | 156 | 1 |
946660 | 946660 | 2021-01-20 | Delta | Colorado | 8029 | 2146 | 41 |
946661 | 946661 | 2021-01-20 | Denver | Colorado | 8031 | 53777 | 725 |
946662 | 946662 | 2021-01-20 | Dolores | Colorado | 8033 | 56 | 0 |
946663 | 946663 | 2021-01-20 | Douglas | Colorado | 8035 | 18411 | 222 |
946664 | 946664 | 2021-01-20 | Eagle | Colorado | 8037 | 4063 | 17 |
946665 | 946665 | 2021-01-20 | El Paso | Colorado | 8041 | 46258 | 675 |
946666 | 946666 | 2021-01-20 | Elbert | Colorado | 8039 | 1099 | 12 |
946667 | 946667 | 2021-01-20 | Fremont | Colorado | 8043 | 5016 | 33 |
946668 | 946668 | 2021-01-20 | Garfield | Colorado | 8045 | 4558 | 37 |
946669 | 946669 | 2021-01-20 | Gilpin | Colorado | 8047 | 140 | 2 |
946670 | 946670 | 2021-01-20 | Grand | Colorado | 8049 | 819 | 4 |
946671 | 946671 | 2021-01-20 | Gunnison | Colorado | 8051 | 940 | 6 |
946672 | 946672 | 2021-01-20 | Hinsdale | Colorado | 8053 | 15 | 0 |
946673 | 946673 | 2021-01-20 | Huerfano | Colorado | 8055 | 287 | 18 |
946674 | 946674 | 2021-01-20 | Jackson | Colorado | 8057 | 44 | 0 |
946675 | 946675 | 2021-01-20 | Jefferson | Colorado | 8059 | 33216 | 671 |
946676 | 946676 | 2021-01-20 | Kiowa | Colorado | 8061 | 83 | 2 |
946677 | 946677 | 2021-01-20 | Kit Carson | Colorado | 8063 | 479 | 10 |
946678 | 946678 | 2021-01-20 | La Plata | Colorado | 8067 | 2616 | 30 |
946679 | 946679 | 2021-01-20 | Lake | Colorado | 8065 | 479 | 0 |
946680 | 946680 | 2021-01-20 | Larimer | Colorado | 8069 | 17130 | 177 |
946681 | 946681 | 2021-01-20 | Las Animas | Colorado | 8071 | 882 | 10 |
946682 | 946682 | 2021-01-20 | Lincoln | Colorado | 8073 | 835 | 3 |
946683 | 946683 | 2021-01-20 | Logan | Colorado | 8075 | 3505 | 56 |
946684 | 946684 | 2021-01-20 | Mesa | Colorado | 8077 | 11137 | 155 |
946685 | 946685 | 2021-01-20 | Mineral | Colorado | 8079 | 55 | 1 |
946686 | 946686 | 2021-01-20 | Moffat | Colorado | 8081 | 601 | 23 |
946687 | 946687 | 2021-01-20 | Montezuma | Colorado | 8083 | 1541 | 20 |
946688 | 946688 | 2021-01-20 | Montrose | Colorado | 8085 | 2776 | 41 |
946689 | 946689 | 2021-01-20 | Morgan | Colorado | 8087 | 2313 | 86 |
946690 | 946690 | 2021-01-20 | Otero | Colorado | 8089 | 1758 | 56 |
946691 | 946691 | 2021-01-20 | Ouray | Colorado | 8091 | 180 | 3 |
946692 | 946692 | 2021-01-20 | Park | Colorado | 8093 | 461 | 5 |
946693 | 946693 | 2021-01-20 | Phillips | Colorado | 8095 | 315 | 10 |
946694 | 946694 | 2021-01-20 | Pitkin | Colorado | 8097 | 1720 | 4 |
946695 | 946695 | 2021-01-20 | Prowers | Colorado | 8099 | 1088 | 20 |
946696 | 946696 | 2021-01-20 | Pueblo | Colorado | 8101 | 14086 | 352 |
946697 | 946697 | 2021-01-20 | Rio Blanco | Colorado | 8103 | 340 | 3 |
946698 | 946698 | 2021-01-20 | Rio Grande | Colorado | 8105 | 560 | 10 |
946699 | 946699 | 2021-01-20 | Routt | Colorado | 8107 | 1381 | 19 |
946700 | 946700 | 2021-01-20 | Saguache | Colorado | 8109 | 286 | 4 |
946701 | 946701 | 2021-01-20 | San Juan | Colorado | 8111 | 34 | 0 |
946702 | 946702 | 2021-01-20 | San Miguel | Colorado | 8113 | 484 | 0 |
946703 | 946703 | 2021-01-20 | Sedgwick | Colorado | 8115 | 180 | 2 |
946704 | 946704 | 2021-01-20 | Summit | Colorado | 8117 | 2441 | 6 |
946705 | 946705 | 2021-01-20 | Teller | Colorado | 8119 | 1126 | 12 |
946706 | 946706 | 2021-01-20 | Washington | Colorado | 8121 | 363 | 11 |
946707 | 946707 | 2021-01-20 | Weld | Colorado | 8123 | 22821 | 301 |
946708 | 946708 | 2021-01-20 | Yuma | Colorado | 8125 | 623 | 14 |
943398 | 943398 | 2021-01-19 | Adams | Colorado | 8001 | 44877 | 577 |
943399 | 943399 | 2021-01-19 | Alamosa | Colorado | 8003 | 1081 | 27 |
943400 | 943400 | 2021-01-19 | Arapahoe | Colorado | 8005 | 43706 | 637 |
943401 | 943401 | 2021-01-19 | Archuleta | Colorado | 8007 | 569 | 0 |
943402 | 943402 | 2021-01-19 | Baca | Colorado | 8009 | 247 | 2 |
943403 | 943403 | 2021-01-19 | Bent | Colorado | 8011 | 1269 | 18 |
943404 | 943404 | 2021-01-19 | Boulder | Colorado | 8013 | 16479 | 217 |
943405 | 943405 | 2021-01-19 | Broomfield | Colorado | 8014 | 3198 | 68 |
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);