ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-08-27" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
473217 | 473217 | 2020-08-27 | Adams | Colorado | 8001 | 7407 | 196 |
473218 | 473218 | 2020-08-27 | Alamosa | Colorado | 8003 | 237 | 9 |
473219 | 473219 | 2020-08-27 | Arapahoe | Colorado | 8005 | 8114 | 367 |
473220 | 473220 | 2020-08-27 | Archuleta | Colorado | 8007 | 46 | 0 |
473221 | 473221 | 2020-08-27 | Baca | Colorado | 8009 | 16 | 0 |
473222 | 473222 | 2020-08-27 | Bent | Colorado | 8011 | 11 | 0 |
473223 | 473223 | 2020-08-27 | Boulder | Colorado | 8013 | 2271 | 79 |
473224 | 473224 | 2020-08-27 | Broomfield | Colorado | 8014 | 522 | 33 |
473225 | 473225 | 2020-08-27 | Chaffee | Colorado | 8015 | 315 | 19 |
473226 | 473226 | 2020-08-27 | Cheyenne | Colorado | 8017 | 9 | 0 |
473227 | 473227 | 2020-08-27 | Clear Creek | Colorado | 8019 | 34 | 1 |
473228 | 473228 | 2020-08-27 | Conejos | Colorado | 8021 | 31 | 0 |
473229 | 473229 | 2020-08-27 | Costilla | Colorado | 8023 | 32 | 0 |
473230 | 473230 | 2020-08-27 | Crowley | Colorado | 8025 | 73 | 1 |
473231 | 473231 | 2020-08-27 | Custer | Colorado | 8027 | 15 | 0 |
473232 | 473232 | 2020-08-27 | Delta | Colorado | 8029 | 152 | 2 |
473233 | 473233 | 2020-08-27 | Denver | Colorado | 8031 | 11077 | 428 |
473234 | 473234 | 2020-08-27 | Dolores | Colorado | 8033 | 2 | 0 |
473235 | 473235 | 2020-08-27 | Douglas | Colorado | 8035 | 2057 | 60 |
473236 | 473236 | 2020-08-27 | Eagle | Colorado | 8037 | 1169 | 9 |
473237 | 473237 | 2020-08-27 | El Paso | Colorado | 8041 | 5950 | 151 |
473238 | 473238 | 2020-08-27 | Elbert | Colorado | 8039 | 120 | 2 |
473239 | 473239 | 2020-08-27 | Fremont | Colorado | 8043 | 155 | 0 |
473240 | 473240 | 2020-08-27 | Garfield | Colorado | 8045 | 830 | 4 |
473241 | 473241 | 2020-08-27 | Gilpin | Colorado | 8047 | 17 | 0 |
473242 | 473242 | 2020-08-27 | Grand | Colorado | 8049 | 62 | 1 |
473243 | 473243 | 2020-08-27 | Gunnison | Colorado | 8051 | 289 | 7 |
473244 | 473244 | 2020-08-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
473245 | 473245 | 2020-08-27 | Huerfano | Colorado | 8055 | 8 | 1 |
473246 | 473246 | 2020-08-27 | Jackson | Colorado | 8057 | 9 | 0 |
473247 | 473247 | 2020-08-27 | Jefferson | Colorado | 8059 | 4694 | 236 |
473248 | 473248 | 2020-08-27 | Kit Carson | Colorado | 8063 | 74 | 3 |
473249 | 473249 | 2020-08-27 | La Plata | Colorado | 8067 | 233 | 2 |
473250 | 473250 | 2020-08-27 | Lake | Colorado | 8065 | 80 | 0 |
473251 | 473251 | 2020-08-27 | Larimer | Colorado | 8069 | 1880 | 39 |
473252 | 473252 | 2020-08-27 | Las Animas | Colorado | 8071 | 20 | 0 |
473253 | 473253 | 2020-08-27 | Lincoln | Colorado | 8073 | 8 | 0 |
473254 | 473254 | 2020-08-27 | Logan | Colorado | 8075 | 675 | 5 |
473255 | 473255 | 2020-08-27 | Mesa | Colorado | 8077 | 397 | 5 |
473256 | 473256 | 2020-08-27 | Mineral | Colorado | 8079 | 19 | 0 |
473257 | 473257 | 2020-08-27 | Moffat | Colorado | 8081 | 34 | 1 |
473258 | 473258 | 2020-08-27 | Montezuma | Colorado | 8083 | 123 | 5 |
473259 | 473259 | 2020-08-27 | Montrose | Colorado | 8085 | 339 | 13 |
473260 | 473260 | 2020-08-27 | Morgan | Colorado | 8087 | 711 | 48 |
473261 | 473261 | 2020-08-27 | Otero | Colorado | 8089 | 81 | 6 |
473262 | 473262 | 2020-08-27 | Ouray | Colorado | 8091 | 22 | 1 |
473263 | 473263 | 2020-08-27 | Park | Colorado | 8093 | 43 | 1 |
473264 | 473264 | 2020-08-27 | Phillips | Colorado | 8095 | 19 | 0 |
473265 | 473265 | 2020-08-27 | Pitkin | Colorado | 8097 | 196 | 2 |
473266 | 473266 | 2020-08-27 | Prowers | Colorado | 8099 | 79 | 0 |
473267 | 473267 | 2020-08-27 | Pueblo | Colorado | 8101 | 841 | 34 |
473268 | 473268 | 2020-08-27 | Rio Blanco | Colorado | 8103 | 23 | 0 |
473269 | 473269 | 2020-08-27 | Rio Grande | Colorado | 8105 | 94 | 2 |
473270 | 473270 | 2020-08-27 | Routt | Colorado | 8107 | 132 | 8 |
473271 | 473271 | 2020-08-27 | Saguache | Colorado | 8109 | 110 | 2 |
473272 | 473272 | 2020-08-27 | San Juan | Colorado | 8111 | 2 | 0 |
473273 | 473273 | 2020-08-27 | San Miguel | Colorado | 8113 | 94 | 0 |
473274 | 473274 | 2020-08-27 | Sedgwick | Colorado | 8115 | 12 | 1 |
473275 | 473275 | 2020-08-27 | Summit | Colorado | 8117 | 361 | 4 |
473276 | 473276 | 2020-08-27 | Teller | Colorado | 8119 | 160 | 3 |
473277 | 473277 | 2020-08-27 | Washington | Colorado | 8121 | 53 | 0 |
473278 | 473278 | 2020-08-27 | Weld | Colorado | 8123 | 4001 | 146 |
473279 | 473279 | 2020-08-27 | Yuma | Colorado | 8125 | 63 | 0 |
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);