ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2021-07-28 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1560214 | 1560214 | 2021-07-28 | Adams | Colorado | 8001 | 63353 | 766 |
1560215 | 1560215 | 2021-07-28 | Alamosa | Colorado | 8003 | 1792 | 38 |
1560216 | 1560216 | 2021-07-28 | Arapahoe | Colorado | 8005 | 65444 | 844 |
1560217 | 1560217 | 2021-07-28 | Archuleta | Colorado | 8007 | 1132 | 2 |
1560218 | 1560218 | 2021-07-28 | Baca | Colorado | 8009 | 328 | 4 |
1560219 | 1560219 | 2021-07-28 | Bent | Colorado | 8011 | 1550 | 22 |
1560220 | 1560220 | 2021-07-28 | Boulder | Colorado | 8013 | 24698 | 261 |
1560221 | 1560221 | 2021-07-28 | Broomfield | Colorado | 8014 | 5140 | 77 |
1560222 | 1560222 | 2021-07-28 | Chaffee | Colorado | 8015 | 1828 | 25 |
1560223 | 1560223 | 2021-07-28 | Cheyenne | Colorado | 8017 | 132 | 6 |
1560224 | 1560224 | 2021-07-28 | Clear Creek | Colorado | 8019 | 502 | 3 |
1560225 | 1560225 | 2021-07-28 | Conejos | Colorado | 8021 | 761 | 25 |
1560226 | 1560226 | 2021-07-28 | Costilla | Colorado | 8023 | 254 | 5 |
1560227 | 1560227 | 2021-07-28 | Crowley | Colorado | 8025 | 2218 | 17 |
1560228 | 1560228 | 2021-07-28 | Custer | Colorado | 8027 | 237 | 2 |
1560229 | 1560229 | 2021-07-28 | Delta | Colorado | 8029 | 3117 | 70 |
1560230 | 1560230 | 2021-07-28 | Denver | Colorado | 8031 | 75819 | 851 |
1560231 | 1560231 | 2021-07-28 | Dolores | Colorado | 8033 | 131 | 1 |
1560232 | 1560232 | 2021-07-28 | Douglas | Colorado | 8035 | 31876 | 273 |
1560233 | 1560233 | 2021-07-28 | Eagle | Colorado | 8037 | 6505 | 23 |
1560234 | 1560234 | 2021-07-28 | El Paso | Colorado | 8041 | 75870 | 899 |
1560235 | 1560235 | 2021-07-28 | Elbert | Colorado | 8039 | 1938 | 14 |
1560236 | 1560236 | 2021-07-28 | Fremont | Colorado | 8043 | 6630 | 64 |
1560237 | 1560237 | 2021-07-28 | Garfield | Colorado | 8045 | 6444 | 52 |
1560238 | 1560238 | 2021-07-28 | Gilpin | Colorado | 8047 | 288 | 3 |
1560239 | 1560239 | 2021-07-28 | Grand | Colorado | 8049 | 1529 | 7 |
1560240 | 1560240 | 2021-07-28 | Gunnison | Colorado | 8051 | 1415 | 6 |
1560241 | 1560241 | 2021-07-28 | Hinsdale | Colorado | 8053 | 32 | 0 |
1560242 | 1560242 | 2021-07-28 | Huerfano | Colorado | 8055 | 453 | 18 |
1560243 | 1560243 | 2021-07-28 | Jackson | Colorado | 8057 | 67 | 0 |
1560244 | 1560244 | 2021-07-28 | Jefferson | Colorado | 8059 | 50039 | 813 |
1560245 | 1560245 | 2021-07-28 | Kiowa | Colorado | 8061 | 95 | 3 |
1560246 | 1560246 | 2021-07-28 | Kit Carson | Colorado | 8063 | 663 | 12 |
1560247 | 1560247 | 2021-07-28 | La Plata | Colorado | 8067 | 4286 | 42 |
1560248 | 1560248 | 2021-07-28 | Lake | Colorado | 8065 | 846 | 1 |
1560249 | 1560249 | 2021-07-28 | Larimer | Colorado | 8069 | 28652 | 248 |
1560250 | 1560250 | 2021-07-28 | Las Animas | Colorado | 8071 | 1263 | 14 |
1560251 | 1560251 | 2021-07-28 | Lincoln | Colorado | 8073 | 1043 | 4 |
1560252 | 1560252 | 2021-07-28 | Logan | Colorado | 8075 | 4072 | 69 |
1560253 | 1560253 | 2021-07-28 | Mesa | Colorado | 8077 | 18185 | 266 |
1560254 | 1560254 | 2021-07-28 | Mineral | Colorado | 8079 | 98 | 1 |
1560255 | 1560255 | 2021-07-28 | Moffat | Colorado | 8081 | 1204 | 27 |
1560256 | 1560256 | 2021-07-28 | Montezuma | Colorado | 8083 | 2171 | 28 |
1560257 | 1560257 | 2021-07-28 | Montrose | Colorado | 8085 | 4001 | 69 |
1560258 | 1560258 | 2021-07-28 | Morgan | Colorado | 8087 | 2776 | 96 |
1560259 | 1560259 | 2021-07-28 | Otero | Colorado | 8089 | 2101 | 67 |
1560260 | 1560260 | 2021-07-28 | Ouray | Colorado | 8091 | 311 | 4 |
1560261 | 1560261 | 2021-07-28 | Park | Colorado | 8093 | 875 | 5 |
1560262 | 1560262 | 2021-07-28 | Phillips | Colorado | 8095 | 401 | 13 |
1560263 | 1560263 | 2021-07-28 | Pitkin | Colorado | 8097 | 2667 | 4 |
1560264 | 1560264 | 2021-07-28 | Prowers | Colorado | 8099 | 1291 | 22 |
1560265 | 1560265 | 2021-07-28 | Pueblo | Colorado | 8101 | 19884 | 427 |
1560266 | 1560266 | 2021-07-28 | Rio Blanco | Colorado | 8103 | 694 | 5 |
1560267 | 1560267 | 2021-07-28 | Rio Grande | Colorado | 8105 | 947 | 18 |
1560268 | 1560268 | 2021-07-28 | Routt | Colorado | 8107 | 2416 | 21 |
1560269 | 1560269 | 2021-07-28 | Saguache | Colorado | 8109 | 474 | 7 |
1560270 | 1560270 | 2021-07-28 | San Juan | Colorado | 8111 | 47 | 0 |
1560271 | 1560271 | 2021-07-28 | San Miguel | Colorado | 8113 | 948 | 1 |
1560272 | 1560272 | 2021-07-28 | Sedgwick | Colorado | 8115 | 236 | 3 |
1560273 | 1560273 | 2021-07-28 | Summit | Colorado | 8117 | 3925 | 8 |
1560274 | 1560274 | 2021-07-28 | Teller | Colorado | 8119 | 1980 | 18 |
1560275 | 1560275 | 2021-07-28 | Washington | Colorado | 8121 | 477 | 13 |
1560276 | 1560276 | 2021-07-28 | Weld | Colorado | 8123 | 34345 | 356 |
1560277 | 1560277 | 2021-07-28 | Yuma | Colorado | 8125 | 979 | 17 |
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);