ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where "date" is on date 2020-06-28 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281026 | 281026 | 2020-06-28 | Adams | Colorado | 8001 | 4148 | 154 |
281027 | 281027 | 2020-06-28 | Alamosa | Colorado | 8003 | 187 | 3 |
281028 | 281028 | 2020-06-28 | Arapahoe | Colorado | 8005 | 5157 | 342 |
281029 | 281029 | 2020-06-28 | Archuleta | Colorado | 8007 | 8 | 0 |
281030 | 281030 | 2020-06-28 | Baca | Colorado | 8009 | 13 | 0 |
281031 | 281031 | 2020-06-28 | Bent | Colorado | 8011 | 4 | 0 |
281032 | 281032 | 2020-06-28 | Boulder | Colorado | 8013 | 1360 | 71 |
281033 | 281033 | 2020-06-28 | Broomfield | Colorado | 8014 | 295 | 29 |
281034 | 281034 | 2020-06-28 | Chaffee | Colorado | 8015 | 78 | 19 |
281035 | 281035 | 2020-06-28 | Cheyenne | Colorado | 8017 | 5 | 0 |
281036 | 281036 | 2020-06-28 | Clear Creek | Colorado | 8019 | 18 | 1 |
281037 | 281037 | 2020-06-28 | Conejos | Colorado | 8021 | 13 | 0 |
281038 | 281038 | 2020-06-28 | Costilla | Colorado | 8023 | 20 | 0 |
281039 | 281039 | 2020-06-28 | Crowley | Colorado | 8025 | 70 | 1 |
281040 | 281040 | 2020-06-28 | Custer | Colorado | 8027 | 2 | 0 |
281041 | 281041 | 2020-06-28 | Delta | Colorado | 8029 | 82 | 1 |
281042 | 281042 | 2020-06-28 | Denver | Colorado | 8031 | 7007 | 375 |
281043 | 281043 | 2020-06-28 | Douglas | Colorado | 8035 | 939 | 52 |
281044 | 281044 | 2020-06-28 | Eagle | Colorado | 8037 | 686 | 8 |
281045 | 281045 | 2020-06-28 | El Paso | Colorado | 8041 | 2327 | 119 |
281046 | 281046 | 2020-06-28 | Elbert | Colorado | 8039 | 57 | 2 |
281047 | 281047 | 2020-06-28 | Fremont | Colorado | 8043 | 36 | 0 |
281048 | 281048 | 2020-06-28 | Garfield | Colorado | 8045 | 273 | 2 |
281049 | 281049 | 2020-06-28 | Gilpin | Colorado | 8047 | 7 | 0 |
281050 | 281050 | 2020-06-28 | Grand | Colorado | 8049 | 19 | 0 |
281051 | 281051 | 2020-06-28 | Gunnison | Colorado | 8051 | 186 | 6 |
281052 | 281052 | 2020-06-28 | Hinsdale | Colorado | 8053 | 3 | 0 |
281053 | 281053 | 2020-06-28 | Huerfano | Colorado | 8055 | 4 | 0 |
281054 | 281054 | 2020-06-28 | Jackson | Colorado | 8057 | 1 | 0 |
281055 | 281055 | 2020-06-28 | Jefferson | Colorado | 8059 | 2656 | 208 |
281056 | 281056 | 2020-06-28 | Kit Carson | Colorado | 8063 | 31 | 3 |
281057 | 281057 | 2020-06-28 | La Plata | Colorado | 8067 | 101 | 1 |
281058 | 281058 | 2020-06-28 | Lake | Colorado | 8065 | 51 | 0 |
281059 | 281059 | 2020-06-28 | Larimer | Colorado | 8069 | 718 | 29 |
281060 | 281060 | 2020-06-28 | Las Animas | Colorado | 8071 | 7 | 0 |
281061 | 281061 | 2020-06-28 | Lincoln | Colorado | 8073 | 4 | 0 |
281062 | 281062 | 2020-06-28 | Logan | Colorado | 8075 | 637 | 5 |
281063 | 281063 | 2020-06-28 | Mesa | Colorado | 8077 | 89 | 0 |
281064 | 281064 | 2020-06-28 | Mineral | Colorado | 8079 | 5 | 0 |
281065 | 281065 | 2020-06-28 | Moffat | Colorado | 8081 | 10 | 0 |
281066 | 281066 | 2020-06-28 | Montezuma | Colorado | 8083 | 70 | 3 |
281067 | 281067 | 2020-06-28 | Montrose | Colorado | 8085 | 204 | 12 |
281068 | 281068 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
281069 | 281069 | 2020-06-28 | Otero | Colorado | 8089 | 22 | 1 |
281070 | 281070 | 2020-06-28 | Ouray | Colorado | 8091 | 10 | 1 |
281071 | 281071 | 2020-06-28 | Park | Colorado | 8093 | 27 | 0 |
281072 | 281072 | 2020-06-28 | Phillips | Colorado | 8095 | 16 | 0 |
281073 | 281073 | 2020-06-28 | Pitkin | Colorado | 8097 | 93 | 2 |
281074 | 281074 | 2020-06-28 | Prowers | Colorado | 8099 | 19 | 0 |
281075 | 281075 | 2020-06-28 | Pueblo | Colorado | 8101 | 383 | 28 |
281076 | 281076 | 2020-06-28 | Rio Blanco | Colorado | 8103 | 3 | 0 |
281077 | 281077 | 2020-06-28 | Rio Grande | Colorado | 8105 | 73 | 2 |
281078 | 281078 | 2020-06-28 | Routt | Colorado | 8107 | 72 | 6 |
281079 | 281079 | 2020-06-28 | Saguache | Colorado | 8109 | 102 | 2 |
281080 | 281080 | 2020-06-28 | San Juan | Colorado | 8111 | 1 | 0 |
281081 | 281081 | 2020-06-28 | San Miguel | Colorado | 8113 | 36 | 0 |
281082 | 281082 | 2020-06-28 | Summit | Colorado | 8117 | 269 | 3 |
281083 | 281083 | 2020-06-28 | Teller | Colorado | 8119 | 41 | 2 |
281084 | 281084 | 2020-06-28 | Washington | Colorado | 8121 | 44 | 0 |
281085 | 281085 | 2020-06-28 | Weld | Colorado | 8123 | 2788 | 137 |
281086 | 281086 | 2020-06-28 | Yuma | Colorado | 8125 | 51 | 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);