ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2020-10-16 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635129 | 635129 | 2020-10-16 | Adams | Colorado | 8001 | 11507 | 247 |
635130 | 635130 | 2020-10-16 | Alamosa | Colorado | 8003 | 272 | 9 |
635131 | 635131 | 2020-10-16 | Arapahoe | Colorado | 8005 | 11017 | 390 |
635132 | 635132 | 2020-10-16 | Archuleta | Colorado | 8007 | 58 | 0 |
635133 | 635133 | 2020-10-16 | Baca | Colorado | 8009 | 23 | 0 |
635134 | 635134 | 2020-10-16 | Bent | Colorado | 8011 | 12 | 0 |
635135 | 635135 | 2020-10-16 | Boulder | Colorado | 8013 | 4998 | 84 |
635136 | 635136 | 2020-10-16 | Broomfield | Colorado | 8014 | 767 | 39 |
635137 | 635137 | 2020-10-16 | Chaffee | Colorado | 8015 | 359 | 20 |
635138 | 635138 | 2020-10-16 | Cheyenne | Colorado | 8017 | 14 | 0 |
635139 | 635139 | 2020-10-16 | Clear Creek | Colorado | 8019 | 61 | 1 |
635140 | 635140 | 2020-10-16 | Conejos | Colorado | 8021 | 48 | 0 |
635141 | 635141 | 2020-10-16 | Costilla | Colorado | 8023 | 34 | 1 |
635142 | 635142 | 2020-10-16 | Crowley | Colorado | 8025 | 80 | 1 |
635143 | 635143 | 2020-10-16 | Custer | Colorado | 8027 | 19 | 0 |
635144 | 635144 | 2020-10-16 | Delta | Colorado | 8029 | 195 | 4 |
635145 | 635145 | 2020-10-16 | Denver | Colorado | 8031 | 15645 | 449 |
635146 | 635146 | 2020-10-16 | Dolores | Colorado | 8033 | 3 | 0 |
635147 | 635147 | 2020-10-16 | Douglas | Colorado | 8035 | 3335 | 63 |
635148 | 635148 | 2020-10-16 | Eagle | Colorado | 8037 | 1338 | 10 |
635149 | 635149 | 2020-10-16 | El Paso | Colorado | 8041 | 8352 | 188 |
635150 | 635150 | 2020-10-16 | Elbert | Colorado | 8039 | 179 | 3 |
635151 | 635151 | 2020-10-16 | Fremont | Colorado | 8043 | 453 | 1 |
635152 | 635152 | 2020-10-16 | Garfield | Colorado | 8045 | 1053 | 5 |
635153 | 635153 | 2020-10-16 | Gilpin | Colorado | 8047 | 21 | 0 |
635154 | 635154 | 2020-10-16 | Grand | Colorado | 8049 | 127 | 1 |
635155 | 635155 | 2020-10-16 | Gunnison | Colorado | 8051 | 296 | 7 |
635156 | 635156 | 2020-10-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
635157 | 635157 | 2020-10-16 | Huerfano | Colorado | 8055 | 28 | 2 |
635158 | 635158 | 2020-10-16 | Jackson | Colorado | 8057 | 9 | 0 |
635159 | 635159 | 2020-10-16 | Jefferson | Colorado | 8059 | 6991 | 298 |
635160 | 635160 | 2020-10-16 | Kiowa | Colorado | 8061 | 2 | 0 |
635161 | 635161 | 2020-10-16 | Kit Carson | Colorado | 8063 | 98 | 3 |
635162 | 635162 | 2020-10-16 | La Plata | Colorado | 8067 | 318 | 2 |
635163 | 635163 | 2020-10-16 | Lake | Colorado | 8065 | 116 | 0 |
635164 | 635164 | 2020-10-16 | Larimer | Colorado | 8069 | 3390 | 55 |
635165 | 635165 | 2020-10-16 | Las Animas | Colorado | 8071 | 33 | 1 |
635166 | 635166 | 2020-10-16 | Lincoln | Colorado | 8073 | 24 | 0 |
635167 | 635167 | 2020-10-16 | Logan | Colorado | 8075 | 1051 | 10 |
635168 | 635168 | 2020-10-16 | Mesa | Colorado | 8077 | 956 | 8 |
635169 | 635169 | 2020-10-16 | Mineral | Colorado | 8079 | 21 | 0 |
635170 | 635170 | 2020-10-16 | Moffat | Colorado | 8081 | 49 | 1 |
635171 | 635171 | 2020-10-16 | Montezuma | Colorado | 8083 | 173 | 5 |
635172 | 635172 | 2020-10-16 | Montrose | Colorado | 8085 | 412 | 13 |
635173 | 635173 | 2020-10-16 | Morgan | Colorado | 8087 | 804 | 48 |
635174 | 635174 | 2020-10-16 | Otero | Colorado | 8089 | 114 | 6 |
635175 | 635175 | 2020-10-16 | Ouray | Colorado | 8091 | 32 | 1 |
635176 | 635176 | 2020-10-16 | Park | Colorado | 8093 | 69 | 1 |
635177 | 635177 | 2020-10-16 | Phillips | Colorado | 8095 | 36 | 0 |
635178 | 635178 | 2020-10-16 | Pitkin | Colorado | 8097 | 255 | 2 |
635179 | 635179 | 2020-10-16 | Prowers | Colorado | 8099 | 104 | 0 |
635180 | 635180 | 2020-10-16 | Pueblo | Colorado | 8101 | 1514 | 40 |
635181 | 635181 | 2020-10-16 | Rio Blanco | Colorado | 8103 | 25 | 0 |
635182 | 635182 | 2020-10-16 | Rio Grande | Colorado | 8105 | 112 | 2 |
635183 | 635183 | 2020-10-16 | Routt | Colorado | 8107 | 180 | 8 |
635184 | 635184 | 2020-10-16 | Saguache | Colorado | 8109 | 118 | 2 |
635185 | 635185 | 2020-10-16 | San Juan | Colorado | 8111 | 6 | 0 |
635186 | 635186 | 2020-10-16 | San Miguel | Colorado | 8113 | 99 | 0 |
635187 | 635187 | 2020-10-16 | Sedgwick | Colorado | 8115 | 16 | 1 |
635188 | 635188 | 2020-10-16 | Summit | Colorado | 8117 | 540 | 4 |
635189 | 635189 | 2020-10-16 | Teller | Colorado | 8119 | 187 | 4 |
635190 | 635190 | 2020-10-16 | Washington | Colorado | 8121 | 78 | 0 |
635191 | 635191 | 2020-10-16 | Weld | Colorado | 8123 | 5307 | 155 |
635192 | 635192 | 2020-10-16 | Yuma | Colorado | 8125 | 176 | 1 |
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);