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 586
- Jefferson 586
- Denver 585
- Eagle 585
- El Paso 585
- Arapahoe 582
- Larimer 582
- Gunnison 581
- Pitkin 581
- Adams 579
- Pueblo 579
- Routt 579
- Summit 579
- Weld 579
- Clear Creek 578
- Mesa 578
- Boulder 577
- Garfield 576
- Yuma 574
- Morgan 573
- Crowley 572
- Grand 572
- Park 572
- San Miguel 572
- Broomfield 571
- Montrose 571
- Chaffee 570
- Elbert 570
- Hinsdale 570
- Logan 569
- …
state 1
- Colorado · 35,859 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1807149 | 1807149 | 2021-10-12 | Las Animas | Colorado | 8071 | 1708 | 21 |
1807150 | 1807150 | 2021-10-12 | Lincoln | Colorado | 8073 | 1269 | 6 |
1807151 | 1807151 | 2021-10-12 | Logan | Colorado | 8075 | 4535 | 79 |
1807152 | 1807152 | 2021-10-12 | Mesa | Colorado | 8077 | 22620 | 308 |
1807153 | 1807153 | 2021-10-12 | Mineral | Colorado | 8079 | 123 | 1 |
1807154 | 1807154 | 2021-10-12 | Moffat | Colorado | 8081 | 1862 | 36 |
1807155 | 1807155 | 2021-10-12 | Montezuma | Colorado | 8083 | 2854 | 34 |
1807156 | 1807156 | 2021-10-12 | Montrose | Colorado | 8085 | 4977 | 78 |
1807157 | 1807157 | 2021-10-12 | Morgan | Colorado | 8087 | 3228 | 98 |
1807158 | 1807158 | 2021-10-12 | Otero | Colorado | 8089 | 2441 | 77 |
1807159 | 1807159 | 2021-10-12 | Ouray | Colorado | 8091 | 407 | 5 |
1807160 | 1807160 | 2021-10-12 | Park | Colorado | 8093 | 1297 | 7 |
1807161 | 1807161 | 2021-10-12 | Phillips | Colorado | 8095 | 491 | 14 |
1807162 | 1807162 | 2021-10-12 | Pitkin | Colorado | 8097 | 3062 | 5 |
1807163 | 1807163 | 2021-10-12 | Prowers | Colorado | 8099 | 1537 | 27 |
1807164 | 1807164 | 2021-10-12 | Pueblo | Colorado | 8101 | 23576 | 467 |
1807165 | 1807165 | 2021-10-12 | Rio Blanco | Colorado | 8103 | 905 | 8 |
1807166 | 1807166 | 2021-10-12 | Rio Grande | Colorado | 8105 | 1384 | 21 |
1807167 | 1807167 | 2021-10-12 | Routt | Colorado | 8107 | 3216 | 23 |
1807168 | 1807168 | 2021-10-12 | Saguache | Colorado | 8109 | 630 | 8 |
1807169 | 1807169 | 2021-10-12 | San Juan | Colorado | 8111 | 94 | 1 |
1807170 | 1807170 | 2021-10-12 | San Miguel | Colorado | 8113 | 1148 | 3 |
1807171 | 1807171 | 2021-10-12 | Sedgwick | Colorado | 8115 | 283 | 4 |
1807172 | 1807172 | 2021-10-12 | Summit | Colorado | 8117 | 4656 | 10 |
1807173 | 1807173 | 2021-10-12 | Teller | Colorado | 8119 | 2623 | 25 |
1807174 | 1807174 | 2021-10-12 | Washington | Colorado | 8121 | 587 | 15 |
1807175 | 1807175 | 2021-10-12 | Weld | Colorado | 8123 | 43847 | 420 |
1807176 | 1807176 | 2021-10-12 | Yuma | Colorado | 8125 | 1156 | 18 |
1803862 | 1803862 | 2021-10-11 | Adams | Colorado | 8001 | 73788 | 859 |
1803863 | 1803863 | 2021-10-11 | Alamosa | Colorado | 8003 | 2278 | 43 |
1803864 | 1803864 | 2021-10-11 | Arapahoe | Colorado | 8005 | 77571 | 906 |
1803865 | 1803865 | 2021-10-11 | Archuleta | Colorado | 8007 | 1397 | 4 |
1803866 | 1803866 | 2021-10-11 | Baca | Colorado | 8009 | 407 | 5 |
1803867 | 1803867 | 2021-10-11 | Bent | Colorado | 8011 | 1641 | 23 |
1803868 | 1803868 | 2021-10-11 | Boulder | Colorado | 8013 | 29636 | 273 |
1803869 | 1803869 | 2021-10-11 | Broomfield | Colorado | 8014 | 6380 | 79 |
1803870 | 1803870 | 2021-10-11 | Chaffee | Colorado | 8015 | 2148 | 30 |
1803871 | 1803871 | 2021-10-11 | Cheyenne | Colorado | 8017 | 163 | 7 |
1803872 | 1803872 | 2021-10-11 | Clear Creek | Colorado | 8019 | 735 | 5 |
1803873 | 1803873 | 2021-10-11 | Conejos | Colorado | 8021 | 937 | 32 |
1803874 | 1803874 | 2021-10-11 | Costilla | Colorado | 8023 | 353 | 9 |
1803875 | 1803875 | 2021-10-11 | Crowley | Colorado | 8025 | 2332 | 20 |
1803876 | 1803876 | 2021-10-11 | Custer | Colorado | 8027 | 333 | 6 |
1803877 | 1803877 | 2021-10-11 | Delta | Colorado | 8029 | 3641 | 80 |
1803878 | 1803878 | 2021-10-11 | Denver | Colorado | 8031 | 87991 | 920 |
1803879 | 1803879 | 2021-10-11 | Dolores | Colorado | 8033 | 221 | 2 |
1803880 | 1803880 | 2021-10-11 | Douglas | Colorado | 8035 | 39223 | 308 |
1803881 | 1803881 | 2021-10-11 | Eagle | Colorado | 8037 | 8058 | 31 |
1803882 | 1803882 | 2021-10-11 | El Paso | Colorado | 8041 | 95581 | 1047 |
1803883 | 1803883 | 2021-10-11 | Elbert | Colorado | 8039 | 2546 | 21 |
1803884 | 1803884 | 2021-10-11 | Fremont | Colorado | 8043 | 7885 | 82 |
1803885 | 1803885 | 2021-10-11 | Garfield | Colorado | 8045 | 7526 | 60 |
1803886 | 1803886 | 2021-10-11 | Gilpin | Colorado | 8047 | 410 | 3 |
1803887 | 1803887 | 2021-10-11 | Grand | Colorado | 8049 | 2078 | 10 |
1803888 | 1803888 | 2021-10-11 | Gunnison | Colorado | 8051 | 1785 | 9 |
1803889 | 1803889 | 2021-10-11 | Hinsdale | Colorado | 8053 | 54 | 0 |
1803890 | 1803890 | 2021-10-11 | Huerfano | Colorado | 8055 | 593 | 19 |
1803891 | 1803891 | 2021-10-11 | Jackson | Colorado | 8057 | 100 | 0 |
1803892 | 1803892 | 2021-10-11 | Jefferson | Colorado | 8059 | 59947 | 886 |
1803893 | 1803893 | 2021-10-11 | Kiowa | Colorado | 8061 | 130 | 4 |
1803894 | 1803894 | 2021-10-11 | Kit Carson | Colorado | 8063 | 900 | 14 |
1803895 | 1803895 | 2021-10-11 | La Plata | Colorado | 8067 | 5481 | 52 |
1803896 | 1803896 | 2021-10-11 | Lake | Colorado | 8065 | 973 | 1 |
1803897 | 1803897 | 2021-10-11 | Larimer | Colorado | 8069 | 36692 | 288 |
1803898 | 1803898 | 2021-10-11 | Las Animas | Colorado | 8071 | 1705 | 21 |
1803899 | 1803899 | 2021-10-11 | Lincoln | Colorado | 8073 | 1263 | 6 |
1803900 | 1803900 | 2021-10-11 | Logan | Colorado | 8075 | 4527 | 79 |
1803901 | 1803901 | 2021-10-11 | Mesa | Colorado | 8077 | 22574 | 306 |
1803902 | 1803902 | 2021-10-11 | Mineral | Colorado | 8079 | 123 | 1 |
1803903 | 1803903 | 2021-10-11 | Moffat | Colorado | 8081 | 1844 | 36 |
1803904 | 1803904 | 2021-10-11 | Montezuma | Colorado | 8083 | 2851 | 34 |
1803905 | 1803905 | 2021-10-11 | Montrose | Colorado | 8085 | 4956 | 78 |
1803906 | 1803906 | 2021-10-11 | Morgan | Colorado | 8087 | 3220 | 98 |
1803907 | 1803907 | 2021-10-11 | Otero | Colorado | 8089 | 2429 | 76 |
1803908 | 1803908 | 2021-10-11 | Ouray | Colorado | 8091 | 407 | 5 |
1803909 | 1803909 | 2021-10-11 | Park | Colorado | 8093 | 1287 | 7 |
1803910 | 1803910 | 2021-10-11 | Phillips | Colorado | 8095 | 489 | 14 |
1803911 | 1803911 | 2021-10-11 | Pitkin | Colorado | 8097 | 3058 | 5 |
1803912 | 1803912 | 2021-10-11 | Prowers | Colorado | 8099 | 1531 | 27 |
1803913 | 1803913 | 2021-10-11 | Pueblo | Colorado | 8101 | 23473 | 467 |
1803914 | 1803914 | 2021-10-11 | Rio Blanco | Colorado | 8103 | 895 | 8 |
1803915 | 1803915 | 2021-10-11 | Rio Grande | Colorado | 8105 | 1368 | 21 |
1803916 | 1803916 | 2021-10-11 | Routt | Colorado | 8107 | 3203 | 22 |
1803917 | 1803917 | 2021-10-11 | Saguache | Colorado | 8109 | 624 | 8 |
1803918 | 1803918 | 2021-10-11 | San Juan | Colorado | 8111 | 94 | 1 |
1803919 | 1803919 | 2021-10-11 | San Miguel | Colorado | 8113 | 1147 | 3 |
1803920 | 1803920 | 2021-10-11 | Sedgwick | Colorado | 8115 | 283 | 4 |
1803921 | 1803921 | 2021-10-11 | Summit | Colorado | 8117 | 4653 | 10 |
1803922 | 1803922 | 2021-10-11 | Teller | Colorado | 8119 | 2613 | 25 |
1803923 | 1803923 | 2021-10-11 | Washington | Colorado | 8121 | 577 | 15 |
1803924 | 1803924 | 2021-10-11 | Weld | Colorado | 8123 | 43692 | 416 |
1803925 | 1803925 | 2021-10-11 | Yuma | Colorado | 8125 | 1142 | 18 |
1800613 | 1800613 | 2021-10-10 | Adams | Colorado | 8001 | 73451 | 857 |
1800614 | 1800614 | 2021-10-10 | Alamosa | Colorado | 8003 | 2250 | 42 |
1800615 | 1800615 | 2021-10-10 | Arapahoe | Colorado | 8005 | 77113 | 904 |
1800616 | 1800616 | 2021-10-10 | Archuleta | Colorado | 8007 | 1389 | 4 |
1800617 | 1800617 | 2021-10-10 | Baca | Colorado | 8009 | 405 | 5 |
1800618 | 1800618 | 2021-10-10 | Bent | Colorado | 8011 | 1635 | 23 |
1800619 | 1800619 | 2021-10-10 | Boulder | Colorado | 8013 | 29427 | 271 |
1800620 | 1800620 | 2021-10-10 | Broomfield | Colorado | 8014 | 6335 | 79 |
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);