ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-07-26" 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 |
---|---|---|---|---|---|---|---|
370105 | 370105 | 2020-07-26 | Adams | Colorado | 8001 | 5587 | 167 |
370106 | 370106 | 2020-07-26 | Alamosa | Colorado | 8003 | 219 | 7 |
370107 | 370107 | 2020-07-26 | Arapahoe | Colorado | 8005 | 6541 | 360 |
370108 | 370108 | 2020-07-26 | Archuleta | Colorado | 8007 | 27 | 0 |
370109 | 370109 | 2020-07-26 | Baca | Colorado | 8009 | 14 | 0 |
370110 | 370110 | 2020-07-26 | Bent | Colorado | 8011 | 5 | 0 |
370111 | 370111 | 2020-07-26 | Boulder | Colorado | 8013 | 1787 | 74 |
370112 | 370112 | 2020-07-26 | Broomfield | Colorado | 8014 | 382 | 32 |
370113 | 370113 | 2020-07-26 | Chaffee | Colorado | 8015 | 277 | 19 |
370114 | 370114 | 2020-07-26 | Cheyenne | Colorado | 8017 | 8 | 0 |
370115 | 370115 | 2020-07-26 | Clear Creek | Colorado | 8019 | 26 | 1 |
370116 | 370116 | 2020-07-26 | Conejos | Colorado | 8021 | 21 | 0 |
370117 | 370117 | 2020-07-26 | Costilla | Colorado | 8023 | 22 | 0 |
370118 | 370118 | 2020-07-26 | Crowley | Colorado | 8025 | 72 | 1 |
370119 | 370119 | 2020-07-26 | Custer | Colorado | 8027 | 10 | 0 |
370120 | 370120 | 2020-07-26 | Delta | Colorado | 8029 | 97 | 1 |
370121 | 370121 | 2020-07-26 | Denver | Colorado | 8031 | 9205 | 405 |
370122 | 370122 | 2020-07-26 | Dolores | Colorado | 8033 | 1 | 0 |
370123 | 370123 | 2020-07-26 | Douglas | Colorado | 8035 | 1519 | 56 |
370124 | 370124 | 2020-07-26 | Eagle | Colorado | 8037 | 964 | 9 |
370125 | 370125 | 2020-07-26 | El Paso | Colorado | 8041 | 4159 | 126 |
370126 | 370126 | 2020-07-26 | Elbert | Colorado | 8039 | 77 | 2 |
370127 | 370127 | 2020-07-26 | Fremont | Colorado | 8043 | 91 | 0 |
370128 | 370128 | 2020-07-26 | Garfield | Colorado | 8045 | 624 | 4 |
370129 | 370129 | 2020-07-26 | Gilpin | Colorado | 8047 | 13 | 0 |
370130 | 370130 | 2020-07-26 | Grand | Colorado | 8049 | 39 | 1 |
370131 | 370131 | 2020-07-26 | Gunnison | Colorado | 8051 | 219 | 6 |
370132 | 370132 | 2020-07-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
370133 | 370133 | 2020-07-26 | Huerfano | Colorado | 8055 | 6 | 1 |
370134 | 370134 | 2020-07-26 | Jackson | Colorado | 8057 | 8 | 0 |
370135 | 370135 | 2020-07-26 | Jefferson | Colorado | 8059 | 3654 | 221 |
370136 | 370136 | 2020-07-26 | Kit Carson | Colorado | 8063 | 42 | 3 |
370137 | 370137 | 2020-07-26 | La Plata | Colorado | 8067 | 187 | 2 |
370138 | 370138 | 2020-07-26 | Lake | Colorado | 8065 | 61 | 0 |
370139 | 370139 | 2020-07-26 | Larimer | Colorado | 8069 | 1255 | 32 |
370140 | 370140 | 2020-07-26 | Las Animas | Colorado | 8071 | 13 | 0 |
370141 | 370141 | 2020-07-26 | Lincoln | Colorado | 8073 | 6 | 0 |
370142 | 370142 | 2020-07-26 | Logan | Colorado | 8075 | 645 | 5 |
370143 | 370143 | 2020-07-26 | Mesa | Colorado | 8077 | 231 | 1 |
370144 | 370144 | 2020-07-26 | Mineral | Colorado | 8079 | 18 | 0 |
370145 | 370145 | 2020-07-26 | Moffat | Colorado | 8081 | 23 | 1 |
370146 | 370146 | 2020-07-26 | Montezuma | Colorado | 8083 | 101 | 4 |
370147 | 370147 | 2020-07-26 | Montrose | Colorado | 8085 | 262 | 13 |
370148 | 370148 | 2020-07-26 | Morgan | Colorado | 8087 | 672 | 46 |
370149 | 370149 | 2020-07-26 | Otero | Colorado | 8089 | 38 | 3 |
370150 | 370150 | 2020-07-26 | Ouray | Colorado | 8091 | 12 | 1 |
370151 | 370151 | 2020-07-26 | Park | Colorado | 8093 | 40 | 1 |
370152 | 370152 | 2020-07-26 | Phillips | Colorado | 8095 | 19 | 0 |
370153 | 370153 | 2020-07-26 | Pitkin | Colorado | 8097 | 153 | 2 |
370154 | 370154 | 2020-07-26 | Prowers | Colorado | 8099 | 46 | 0 |
370155 | 370155 | 2020-07-26 | Pueblo | Colorado | 8101 | 559 | 33 |
370156 | 370156 | 2020-07-26 | Rio Blanco | Colorado | 8103 | 6 | 0 |
370157 | 370157 | 2020-07-26 | Rio Grande | Colorado | 8105 | 87 | 2 |
370158 | 370158 | 2020-07-26 | Routt | Colorado | 8107 | 94 | 6 |
370159 | 370159 | 2020-07-26 | Saguache | Colorado | 8109 | 107 | 2 |
370160 | 370160 | 2020-07-26 | San Juan | Colorado | 8111 | 2 | 0 |
370161 | 370161 | 2020-07-26 | San Miguel | Colorado | 8113 | 73 | 0 |
370162 | 370162 | 2020-07-26 | Sedgwick | Colorado | 8115 | 11 | 0 |
370163 | 370163 | 2020-07-26 | Summit | Colorado | 8117 | 316 | 4 |
370164 | 370164 | 2020-07-26 | Teller | Colorado | 8119 | 97 | 2 |
370165 | 370165 | 2020-07-26 | Washington | Colorado | 8121 | 46 | 0 |
370166 | 370166 | 2020-07-26 | Weld | Colorado | 8123 | 3408 | 139 |
370167 | 370167 | 2020-07-26 | Yuma | Colorado | 8125 | 57 | 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);