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 267
- Jefferson 267
- Denver 266
- Eagle 266
- El Paso 266
- Arapahoe 263
- Larimer 263
- Gunnison 262
- Pitkin 261
- Adams 260
- Clear Creek 259
- Pueblo 259
- Routt 259
- Summit 259
- Weld 259
- Boulder 258
- Mesa 258
- Garfield 257
- Yuma 254
- Crowley 253
- Grand 253
- Morgan 253
- Broomfield 252
- Park 252
- San Miguel 252
- Chaffee 251
- Elbert 251
- Hinsdale 251
- Montrose 251
- La Plata 249
- …
state 1
- Colorado · 15,415 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
768153 | 768153 | 2020-11-26 | Adams | Colorado | 8001 | 27856 | 329 |
768154 | 768154 | 2020-11-26 | Alamosa | Colorado | 8003 | 575 | 13 |
768155 | 768155 | 2020-11-26 | Arapahoe | Colorado | 8005 | 25652 | 450 |
768156 | 768156 | 2020-11-26 | Archuleta | Colorado | 8007 | 210 | 0 |
768157 | 768157 | 2020-11-26 | Baca | Colorado | 8009 | 101 | 0 |
768158 | 768158 | 2020-11-26 | Bent | Colorado | 8011 | 117 | 1 |
768159 | 768159 | 2020-11-26 | Boulder | Colorado | 8013 | 10585 | 117 |
768160 | 768160 | 2020-11-26 | Broomfield | Colorado | 8014 | 1921 | 49 |
768161 | 768161 | 2020-11-26 | Chaffee | Colorado | 8015 | 604 | 21 |
768162 | 768162 | 2020-11-26 | Cheyenne | Colorado | 8017 | 56 | 0 |
768163 | 768163 | 2020-11-26 | Clear Creek | Colorado | 8019 | 182 | 2 |
768164 | 768164 | 2020-11-26 | Conejos | Colorado | 8021 | 160 | 3 |
768165 | 768165 | 2020-11-26 | Costilla | Colorado | 8023 | 83 | 1 |
768166 | 768166 | 2020-11-26 | Crowley | Colorado | 8025 | 1087 | 3 |
768167 | 768167 | 2020-11-26 | Custer | Colorado | 8027 | 67 | 0 |
768168 | 768168 | 2020-11-26 | Delta | Colorado | 8029 | 553 | 8 |
768169 | 768169 | 2020-11-26 | Denver | Colorado | 8031 | 35075 | 521 |
768170 | 768170 | 2020-11-26 | Dolores | Colorado | 8033 | 14 | 0 |
768171 | 768171 | 2020-11-26 | Douglas | Colorado | 8035 | 10140 | 101 |
768172 | 768172 | 2020-11-26 | Eagle | Colorado | 8037 | 2237 | 11 |
768173 | 768173 | 2020-11-26 | El Paso | Colorado | 8041 | 25313 | 266 |
768174 | 768174 | 2020-11-26 | Elbert | Colorado | 8039 | 557 | 5 |
768175 | 768175 | 2020-11-26 | Fremont | Colorado | 8043 | 2528 | 5 |
768176 | 768176 | 2020-11-26 | Garfield | Colorado | 8045 | 2071 | 6 |
768177 | 768177 | 2020-11-26 | Gilpin | Colorado | 8047 | 80 | 0 |
768178 | 768178 | 2020-11-26 | Grand | Colorado | 8049 | 373 | 1 |
768179 | 768179 | 2020-11-26 | Gunnison | Colorado | 8051 | 451 | 7 |
768180 | 768180 | 2020-11-26 | Hinsdale | Colorado | 8053 | 9 | 0 |
768181 | 768181 | 2020-11-26 | Huerfano | Colorado | 8055 | 137 | 4 |
768182 | 768182 | 2020-11-26 | Jackson | Colorado | 8057 | 18 | 0 |
768183 | 768183 | 2020-11-26 | Jefferson | Colorado | 8059 | 19348 | 433 |
768184 | 768184 | 2020-11-26 | Kiowa | Colorado | 8061 | 22 | 0 |
768185 | 768185 | 2020-11-26 | Kit Carson | Colorado | 8063 | 293 | 7 |
768186 | 768186 | 2020-11-26 | La Plata | Colorado | 8067 | 1209 | 3 |
768187 | 768187 | 2020-11-26 | Lake | Colorado | 8065 | 265 | 0 |
768188 | 768188 | 2020-11-26 | Larimer | Colorado | 8069 | 9545 | 73 |
768189 | 768189 | 2020-11-26 | Las Animas | Colorado | 8071 | 205 | 0 |
768190 | 768190 | 2020-11-26 | Lincoln | Colorado | 8073 | 132 | 0 |
768191 | 768191 | 2020-11-26 | Logan | Colorado | 8075 | 2146 | 33 |
768192 | 768192 | 2020-11-26 | Mesa | Colorado | 8077 | 5435 | 55 |
768193 | 768193 | 2020-11-26 | Mineral | Colorado | 8079 | 35 | 0 |
768194 | 768194 | 2020-11-26 | Moffat | Colorado | 8081 | 264 | 3 |
768195 | 768195 | 2020-11-26 | Montezuma | Colorado | 8083 | 638 | 6 |
768196 | 768196 | 2020-11-26 | Montrose | Colorado | 8085 | 977 | 15 |
768197 | 768197 | 2020-11-26 | Morgan | Colorado | 8087 | 1570 | 52 |
768198 | 768198 | 2020-11-26 | Otero | Colorado | 8089 | 506 | 10 |
768199 | 768199 | 2020-11-26 | Ouray | Colorado | 8091 | 117 | 2 |
768200 | 768200 | 2020-11-26 | Park | Colorado | 8093 | 214 | 4 |
768201 | 768201 | 2020-11-26 | Phillips | Colorado | 8095 | 178 | 2 |
768202 | 768202 | 2020-11-26 | Pitkin | Colorado | 8097 | 458 | 2 |
768203 | 768203 | 2020-11-26 | Prowers | Colorado | 8099 | 561 | 12 |
768204 | 768204 | 2020-11-26 | Pueblo | Colorado | 8101 | 7602 | 115 |
768205 | 768205 | 2020-11-26 | Rio Blanco | Colorado | 8103 | 137 | 1 |
768206 | 768206 | 2020-11-26 | Rio Grande | Colorado | 8105 | 216 | 4 |
768207 | 768207 | 2020-11-26 | Routt | Colorado | 8107 | 615 | 10 |
768208 | 768208 | 2020-11-26 | Saguache | Colorado | 8109 | 209 | 2 |
768209 | 768209 | 2020-11-26 | San Juan | Colorado | 8111 | 20 | 0 |
768210 | 768210 | 2020-11-26 | San Miguel | Colorado | 8113 | 190 | 0 |
768211 | 768211 | 2020-11-26 | Sedgwick | Colorado | 8115 | 106 | 1 |
768212 | 768212 | 2020-11-26 | Summit | Colorado | 8117 | 1426 | 4 |
768213 | 768213 | 2020-11-26 | Teller | Colorado | 8119 | 575 | 4 |
768214 | 768214 | 2020-11-26 | Washington | Colorado | 8121 | 204 | 6 |
768215 | 768215 | 2020-11-26 | Weld | Colorado | 8123 | 13111 | 192 |
768216 | 768216 | 2020-11-26 | Yuma | Colorado | 8125 | 314 | 2 |
764907 | 764907 | 2020-11-25 | Adams | Colorado | 8001 | 27259 | 321 |
764908 | 764908 | 2020-11-25 | Alamosa | Colorado | 8003 | 542 | 12 |
764909 | 764909 | 2020-11-25 | Arapahoe | Colorado | 8005 | 25067 | 448 |
764910 | 764910 | 2020-11-25 | Archuleta | Colorado | 8007 | 180 | 0 |
764911 | 764911 | 2020-11-25 | Baca | Colorado | 8009 | 88 | 0 |
764912 | 764912 | 2020-11-25 | Bent | Colorado | 8011 | 81 | 1 |
764913 | 764913 | 2020-11-25 | Boulder | Colorado | 8013 | 10450 | 117 |
764914 | 764914 | 2020-11-25 | Broomfield | Colorado | 8014 | 1872 | 48 |
764915 | 764915 | 2020-11-25 | Chaffee | Colorado | 8015 | 595 | 21 |
764916 | 764916 | 2020-11-25 | Cheyenne | Colorado | 8017 | 55 | 0 |
764917 | 764917 | 2020-11-25 | Clear Creek | Colorado | 8019 | 178 | 2 |
764918 | 764918 | 2020-11-25 | Conejos | Colorado | 8021 | 154 | 3 |
764919 | 764919 | 2020-11-25 | Costilla | Colorado | 8023 | 83 | 1 |
764920 | 764920 | 2020-11-25 | Crowley | Colorado | 8025 | 1015 | 2 |
764921 | 764921 | 2020-11-25 | Custer | Colorado | 8027 | 59 | 0 |
764922 | 764922 | 2020-11-25 | Delta | Colorado | 8029 | 523 | 8 |
764923 | 764923 | 2020-11-25 | Denver | Colorado | 8031 | 34816 | 515 |
764924 | 764924 | 2020-11-25 | Dolores | Colorado | 8033 | 14 | 0 |
764925 | 764925 | 2020-11-25 | Douglas | Colorado | 8035 | 9791 | 100 |
764926 | 764926 | 2020-11-25 | Eagle | Colorado | 8037 | 2214 | 11 |
764927 | 764927 | 2020-11-25 | El Paso | Colorado | 8041 | 24567 | 265 |
764928 | 764928 | 2020-11-25 | Elbert | Colorado | 8039 | 540 | 5 |
764929 | 764929 | 2020-11-25 | Fremont | Colorado | 8043 | 2358 | 4 |
764930 | 764930 | 2020-11-25 | Garfield | Colorado | 8045 | 2014 | 6 |
764931 | 764931 | 2020-11-25 | Gilpin | Colorado | 8047 | 78 | 0 |
764932 | 764932 | 2020-11-25 | Grand | Colorado | 8049 | 352 | 1 |
764933 | 764933 | 2020-11-25 | Gunnison | Colorado | 8051 | 448 | 7 |
764934 | 764934 | 2020-11-25 | Hinsdale | Colorado | 8053 | 8 | 0 |
764935 | 764935 | 2020-11-25 | Huerfano | Colorado | 8055 | 126 | 4 |
764936 | 764936 | 2020-11-25 | Jackson | Colorado | 8057 | 18 | 0 |
764937 | 764937 | 2020-11-25 | Jefferson | Colorado | 8059 | 18779 | 427 |
764938 | 764938 | 2020-11-25 | Kiowa | Colorado | 8061 | 22 | 0 |
764939 | 764939 | 2020-11-25 | Kit Carson | Colorado | 8063 | 262 | 7 |
764940 | 764940 | 2020-11-25 | La Plata | Colorado | 8067 | 1125 | 3 |
764941 | 764941 | 2020-11-25 | Lake | Colorado | 8065 | 255 | 0 |
764942 | 764942 | 2020-11-25 | Larimer | Colorado | 8069 | 9275 | 69 |
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);