ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where date = "2020-07-16" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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
- Jackson 1
- Jefferson 1
- …
state 1
- Colorado · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
338075 | 338075 | 2020-07-16 | Adams | Colorado | 8001 | 4972 | 159 |
338076 | 338076 | 2020-07-16 | Alamosa | Colorado | 8003 | 206 | 7 |
338077 | 338077 | 2020-07-16 | Arapahoe | Colorado | 8005 | 5854 | 351 |
338078 | 338078 | 2020-07-16 | Archuleta | Colorado | 8007 | 15 | 0 |
338079 | 338079 | 2020-07-16 | Baca | Colorado | 8009 | 14 | 0 |
338080 | 338080 | 2020-07-16 | Bent | Colorado | 8011 | 5 | 0 |
338081 | 338081 | 2020-07-16 | Boulder | Colorado | 8013 | 1618 | 74 |
338082 | 338082 | 2020-07-16 | Broomfield | Colorado | 8014 | 354 | 30 |
338083 | 338083 | 2020-07-16 | Chaffee | Colorado | 8015 | 124 | 19 |
338084 | 338084 | 2020-07-16 | Cheyenne | Colorado | 8017 | 5 | 0 |
338085 | 338085 | 2020-07-16 | Clear Creek | Colorado | 8019 | 23 | 1 |
338086 | 338086 | 2020-07-16 | Conejos | Colorado | 8021 | 19 | 0 |
338087 | 338087 | 2020-07-16 | Costilla | Colorado | 8023 | 22 | 0 |
338088 | 338088 | 2020-07-16 | Crowley | Colorado | 8025 | 71 | 1 |
338089 | 338089 | 2020-07-16 | Custer | Colorado | 8027 | 7 | 0 |
338090 | 338090 | 2020-07-16 | Delta | Colorado | 8029 | 86 | 1 |
338091 | 338091 | 2020-07-16 | Denver | Colorado | 8031 | 8164 | 398 |
338092 | 338092 | 2020-07-16 | Douglas | Colorado | 8035 | 1263 | 54 |
338093 | 338093 | 2020-07-16 | Eagle | Colorado | 8037 | 812 | 9 |
338094 | 338094 | 2020-07-16 | El Paso | Colorado | 8041 | 3370 | 119 |
338095 | 338095 | 2020-07-16 | Elbert | Colorado | 8039 | 67 | 2 |
338096 | 338096 | 2020-07-16 | Fremont | Colorado | 8043 | 68 | 0 |
338097 | 338097 | 2020-07-16 | Garfield | Colorado | 8045 | 469 | 4 |
338098 | 338098 | 2020-07-16 | Gilpin | Colorado | 8047 | 12 | 0 |
338099 | 338099 | 2020-07-16 | Grand | Colorado | 8049 | 32 | 1 |
338100 | 338100 | 2020-07-16 | Gunnison | Colorado | 8051 | 193 | 6 |
338101 | 338101 | 2020-07-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
338102 | 338102 | 2020-07-16 | Huerfano | Colorado | 8055 | 5 | 1 |
338103 | 338103 | 2020-07-16 | Jackson | Colorado | 8057 | 8 | 0 |
338104 | 338104 | 2020-07-16 | Jefferson | Colorado | 8059 | 3174 | 217 |
338105 | 338105 | 2020-07-16 | Kit Carson | Colorado | 8063 | 36 | 3 |
338106 | 338106 | 2020-07-16 | La Plata | Colorado | 8067 | 151 | 1 |
338107 | 338107 | 2020-07-16 | Lake | Colorado | 8065 | 57 | 0 |
338108 | 338108 | 2020-07-16 | Larimer | Colorado | 8069 | 1009 | 30 |
338109 | 338109 | 2020-07-16 | Las Animas | Colorado | 8071 | 11 | 0 |
338110 | 338110 | 2020-07-16 | Lincoln | Colorado | 8073 | 4 | 0 |
338111 | 338111 | 2020-07-16 | Logan | Colorado | 8075 | 641 | 5 |
338112 | 338112 | 2020-07-16 | Mesa | Colorado | 8077 | 163 | 0 |
338113 | 338113 | 2020-07-16 | Mineral | Colorado | 8079 | 17 | 0 |
338114 | 338114 | 2020-07-16 | Moffat | Colorado | 8081 | 16 | 1 |
338115 | 338115 | 2020-07-16 | Montezuma | Colorado | 8083 | 85 | 3 |
338116 | 338116 | 2020-07-16 | Montrose | Colorado | 8085 | 225 | 12 |
338117 | 338117 | 2020-07-16 | Morgan | Colorado | 8087 | 663 | 46 |
338118 | 338118 | 2020-07-16 | Otero | Colorado | 8089 | 24 | 1 |
338119 | 338119 | 2020-07-16 | Ouray | Colorado | 8091 | 12 | 1 |
338120 | 338120 | 2020-07-16 | Park | Colorado | 8093 | 33 | 0 |
338121 | 338121 | 2020-07-16 | Phillips | Colorado | 8095 | 16 | 0 |
338122 | 338122 | 2020-07-16 | Pitkin | Colorado | 8097 | 144 | 2 |
338123 | 338123 | 2020-07-16 | Prowers | Colorado | 8099 | 42 | 0 |
338124 | 338124 | 2020-07-16 | Pueblo | Colorado | 8101 | 469 | 32 |
338125 | 338125 | 2020-07-16 | Rio Blanco | Colorado | 8103 | 6 | 0 |
338126 | 338126 | 2020-07-16 | Rio Grande | Colorado | 8105 | 82 | 2 |
338127 | 338127 | 2020-07-16 | Routt | Colorado | 8107 | 86 | 6 |
338128 | 338128 | 2020-07-16 | Saguache | Colorado | 8109 | 104 | 2 |
338129 | 338129 | 2020-07-16 | San Juan | Colorado | 8111 | 2 | 0 |
338130 | 338130 | 2020-07-16 | San Miguel | Colorado | 8113 | 60 | 0 |
338131 | 338131 | 2020-07-16 | Sedgwick | Colorado | 8115 | 4 | 0 |
338132 | 338132 | 2020-07-16 | Summit | Colorado | 8117 | 298 | 4 |
338133 | 338133 | 2020-07-16 | Teller | Colorado | 8119 | 66 | 2 |
338134 | 338134 | 2020-07-16 | Washington | Colorado | 8121 | 46 | 0 |
338135 | 338135 | 2020-07-16 | Weld | Colorado | 8123 | 3155 | 139 |
338136 | 338136 | 2020-07-16 | Yuma | Colorado | 8125 | 55 | 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);