ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where "date" is on date 2020-06-22 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Adams 1
- Alamosa 1
- Arapahoe 1
- Archuleta 1
- Baca 1
- Bent 1
- Boulder 1
- Broomfield 1
- Chaffee 1
- Cheyenne 1
- Clear Creek 1
- Conejos 1
- Costilla 1
- Crowley 1
- Custer 1
- Delta 1
- Denver 1
- Douglas 1
- Eagle 1
- El Paso 1
- Elbert 1
- Fremont 1
- Garfield 1
- Gilpin 1
- Grand 1
- Gunnison 1
- Hinsdale 1
- Huerfano 1
- Jefferson 1
- Kit Carson 1
- …
state 1
- Colorado · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
262198 | 262198 | 2020-06-22 | Adams | Colorado | 8001 | 3932 | 153 |
262199 | 262199 | 2020-06-22 | Alamosa | Colorado | 8003 | 169 | 3 |
262200 | 262200 | 2020-06-22 | Arapahoe | Colorado | 8005 | 4975 | 339 |
262201 | 262201 | 2020-06-22 | Archuleta | Colorado | 8007 | 8 | 0 |
262202 | 262202 | 2020-06-22 | Baca | Colorado | 8009 | 12 | 0 |
262203 | 262203 | 2020-06-22 | Bent | Colorado | 8011 | 4 | 0 |
262204 | 262204 | 2020-06-22 | Boulder | Colorado | 8013 | 1259 | 71 |
262205 | 262205 | 2020-06-22 | Broomfield | Colorado | 8014 | 280 | 28 |
262206 | 262206 | 2020-06-22 | Chaffee | Colorado | 8015 | 78 | 20 |
262207 | 262207 | 2020-06-22 | Cheyenne | Colorado | 8017 | 5 | 0 |
262208 | 262208 | 2020-06-22 | Clear Creek | Colorado | 8019 | 18 | 1 |
262209 | 262209 | 2020-06-22 | Conejos | Colorado | 8021 | 12 | 0 |
262210 | 262210 | 2020-06-22 | Costilla | Colorado | 8023 | 17 | 0 |
262211 | 262211 | 2020-06-22 | Crowley | Colorado | 8025 | 69 | 1 |
262212 | 262212 | 2020-06-22 | Custer | Colorado | 8027 | 2 | 0 |
262213 | 262213 | 2020-06-22 | Delta | Colorado | 8029 | 80 | 1 |
262214 | 262214 | 2020-06-22 | Denver | Colorado | 8031 | 6663 | 367 |
262215 | 262215 | 2020-06-22 | Douglas | Colorado | 8035 | 864 | 51 |
262216 | 262216 | 2020-06-22 | Eagle | Colorado | 8037 | 656 | 8 |
262217 | 262217 | 2020-06-22 | El Paso | Colorado | 8041 | 2113 | 116 |
262218 | 262218 | 2020-06-22 | Elbert | Colorado | 8039 | 54 | 2 |
262219 | 262219 | 2020-06-22 | Fremont | Colorado | 8043 | 31 | 0 |
262220 | 262220 | 2020-06-22 | Garfield | Colorado | 8045 | 224 | 2 |
262221 | 262221 | 2020-06-22 | Gilpin | Colorado | 8047 | 6 | 0 |
262222 | 262222 | 2020-06-22 | Grand | Colorado | 8049 | 18 | 0 |
262223 | 262223 | 2020-06-22 | Gunnison | Colorado | 8051 | 182 | 6 |
262224 | 262224 | 2020-06-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
262225 | 262225 | 2020-06-22 | Huerfano | Colorado | 8055 | 4 | 0 |
262226 | 262226 | 2020-06-22 | Jefferson | Colorado | 8059 | 2543 | 205 |
262227 | 262227 | 2020-06-22 | Kit Carson | Colorado | 8063 | 31 | 3 |
262228 | 262228 | 2020-06-22 | La Plata | Colorado | 8067 | 86 | 1 |
262229 | 262229 | 2020-06-22 | Lake | Colorado | 8065 | 48 | 0 |
262230 | 262230 | 2020-06-22 | Larimer | Colorado | 8069 | 680 | 29 |
262231 | 262231 | 2020-06-22 | Las Animas | Colorado | 8071 | 8 | 0 |
262232 | 262232 | 2020-06-22 | Lincoln | Colorado | 8073 | 4 | 0 |
262233 | 262233 | 2020-06-22 | Logan | Colorado | 8075 | 635 | 5 |
262234 | 262234 | 2020-06-22 | Mesa | Colorado | 8077 | 80 | 0 |
262235 | 262235 | 2020-06-22 | Mineral | Colorado | 8079 | 2 | 0 |
262236 | 262236 | 2020-06-22 | Moffat | Colorado | 8081 | 9 | 0 |
262237 | 262237 | 2020-06-22 | Montezuma | Colorado | 8083 | 68 | 3 |
262238 | 262238 | 2020-06-22 | Montrose | Colorado | 8085 | 201 | 12 |
262239 | 262239 | 2020-06-22 | Morgan | Colorado | 8087 | 649 | 46 |
262240 | 262240 | 2020-06-22 | Otero | Colorado | 8089 | 22 | 1 |
262241 | 262241 | 2020-06-22 | Ouray | Colorado | 8091 | 10 | 1 |
262242 | 262242 | 2020-06-22 | Park | Colorado | 8093 | 25 | 0 |
262243 | 262243 | 2020-06-22 | Phillips | Colorado | 8095 | 15 | 0 |
262244 | 262244 | 2020-06-22 | Pitkin | Colorado | 8097 | 80 | 2 |
262245 | 262245 | 2020-06-22 | Prowers | Colorado | 8099 | 16 | 0 |
262246 | 262246 | 2020-06-22 | Pueblo | Colorado | 8101 | 358 | 24 |
262247 | 262247 | 2020-06-22 | Rio Blanco | Colorado | 8103 | 2 | 0 |
262248 | 262248 | 2020-06-22 | Rio Grande | Colorado | 8105 | 65 | 1 |
262249 | 262249 | 2020-06-22 | Routt | Colorado | 8107 | 65 | 6 |
262250 | 262250 | 2020-06-22 | Saguache | Colorado | 8109 | 99 | 2 |
262251 | 262251 | 2020-06-22 | San Juan | Colorado | 8111 | 1 | 0 |
262252 | 262252 | 2020-06-22 | San Miguel | Colorado | 8113 | 28 | 0 |
262253 | 262253 | 2020-06-22 | Summit | Colorado | 8117 | 263 | 3 |
262254 | 262254 | 2020-06-22 | Teller | Colorado | 8119 | 40 | 2 |
262255 | 262255 | 2020-06-22 | Washington | Colorado | 8121 | 44 | 0 |
262256 | 262256 | 2020-06-22 | Weld | Colorado | 8123 | 2724 | 136 |
262257 | 262257 | 2020-06-22 | Yuma | Colorado | 8125 | 50 | 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);