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 2021-03-20 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1138148 | 1138148 | 2021-03-20 | Adams | Colorado | 8001 | 51273 | 639 |
1138149 | 1138149 | 2021-03-20 | Alamosa | Colorado | 8003 | 1338 | 29 |
1138150 | 1138150 | 2021-03-20 | Arapahoe | Colorado | 8005 | 51616 | 711 |
1138151 | 1138151 | 2021-03-20 | Archuleta | Colorado | 8007 | 724 | 1 |
1138152 | 1138152 | 2021-03-20 | Baca | Colorado | 8009 | 276 | 4 |
1138153 | 1138153 | 2021-03-20 | Bent | Colorado | 8011 | 1484 | 21 |
1138154 | 1138154 | 2021-03-20 | Boulder | Colorado | 8013 | 20033 | 250 |
1138155 | 1138155 | 2021-03-20 | Broomfield | Colorado | 8014 | 4052 | 74 |
1138156 | 1138156 | 2021-03-20 | Chaffee | Colorado | 8015 | 1484 | 24 |
1138157 | 1138157 | 2021-03-20 | Cheyenne | Colorado | 8017 | 126 | 6 |
1138158 | 1138158 | 2021-03-20 | Clear Creek | Colorado | 8019 | 387 | 2 |
1138159 | 1138159 | 2021-03-20 | Conejos | Colorado | 8021 | 460 | 10 |
1138160 | 1138160 | 2021-03-20 | Costilla | Colorado | 8023 | 197 | 2 |
1138161 | 1138161 | 2021-03-20 | Crowley | Colorado | 8025 | 2124 | 14 |
1138162 | 1138162 | 2021-03-20 | Custer | Colorado | 8027 | 165 | 1 |
1138163 | 1138163 | 2021-03-20 | Delta | Colorado | 8029 | 2509 | 60 |
1138164 | 1138164 | 2021-03-20 | Denver | Colorado | 8031 | 62475 | 779 |
1138165 | 1138165 | 2021-03-20 | Dolores | Colorado | 8033 | 67 | 0 |
1138166 | 1138166 | 2021-03-20 | Douglas | Colorado | 8035 | 23332 | 234 |
1138167 | 1138167 | 2021-03-20 | Eagle | Colorado | 8037 | 5497 | 22 |
1138168 | 1138168 | 2021-03-20 | El Paso | Colorado | 8041 | 54889 | 753 |
1138169 | 1138169 | 2021-03-20 | Elbert | Colorado | 8039 | 1368 | 12 |
1138170 | 1138170 | 2021-03-20 | Fremont | Colorado | 8043 | 5589 | 52 |
1138171 | 1138171 | 2021-03-20 | Garfield | Colorado | 8045 | 5272 | 38 |
1138172 | 1138172 | 2021-03-20 | Gilpin | Colorado | 8047 | 184 | 3 |
1138173 | 1138173 | 2021-03-20 | Grand | Colorado | 8049 | 1310 | 6 |
1138174 | 1138174 | 2021-03-20 | Gunnison | Colorado | 8051 | 1225 | 6 |
1138175 | 1138175 | 2021-03-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1138176 | 1138176 | 2021-03-20 | Huerfano | Colorado | 8055 | 327 | 17 |
1138177 | 1138177 | 2021-03-20 | Jackson | Colorado | 8057 | 52 | 0 |
1138178 | 1138178 | 2021-03-20 | Jefferson | Colorado | 8059 | 39306 | 730 |
1138179 | 1138179 | 2021-03-20 | Kiowa | Colorado | 8061 | 91 | 3 |
1138180 | 1138180 | 2021-03-20 | Kit Carson | Colorado | 8063 | 566 | 11 |
1138181 | 1138181 | 2021-03-20 | La Plata | Colorado | 8067 | 3220 | 37 |
1138182 | 1138182 | 2021-03-20 | Lake | Colorado | 8065 | 686 | 0 |
1138183 | 1138183 | 2021-03-20 | Larimer | Colorado | 8069 | 21400 | 227 |
1138184 | 1138184 | 2021-03-20 | Las Animas | Colorado | 8071 | 1028 | 11 |
1138185 | 1138185 | 2021-03-20 | Lincoln | Colorado | 8073 | 1002 | 4 |
1138186 | 1138186 | 2021-03-20 | Logan | Colorado | 8075 | 3782 | 65 |
1138187 | 1138187 | 2021-03-20 | Mesa | Colorado | 8077 | 13618 | 208 |
1138188 | 1138188 | 2021-03-20 | Mineral | Colorado | 8079 | 85 | 1 |
1138189 | 1138189 | 2021-03-20 | Moffat | Colorado | 8081 | 694 | 22 |
1138190 | 1138190 | 2021-03-20 | Montezuma | Colorado | 8083 | 1770 | 23 |
1138191 | 1138191 | 2021-03-20 | Montrose | Colorado | 8085 | 3301 | 56 |
1138192 | 1138192 | 2021-03-20 | Morgan | Colorado | 8087 | 2504 | 92 |
1138193 | 1138193 | 2021-03-20 | Otero | Colorado | 8089 | 1875 | 63 |
1138194 | 1138194 | 2021-03-20 | Ouray | Colorado | 8091 | 267 | 3 |
1138195 | 1138195 | 2021-03-20 | Park | Colorado | 8093 | 582 | 5 |
1138196 | 1138196 | 2021-03-20 | Phillips | Colorado | 8095 | 346 | 13 |
1138197 | 1138197 | 2021-03-20 | Pitkin | Colorado | 8097 | 2259 | 4 |
1138198 | 1138198 | 2021-03-20 | Prowers | Colorado | 8099 | 1167 | 21 |
1138199 | 1138199 | 2021-03-20 | Pueblo | Colorado | 8101 | 15479 | 365 |
1138200 | 1138200 | 2021-03-20 | Rio Blanco | Colorado | 8103 | 503 | 4 |
1138201 | 1138201 | 2021-03-20 | Rio Grande | Colorado | 8105 | 746 | 13 |
1138202 | 1138202 | 2021-03-20 | Routt | Colorado | 8107 | 2019 | 19 |
1138203 | 1138203 | 2021-03-20 | Saguache | Colorado | 8109 | 328 | 4 |
1138204 | 1138204 | 2021-03-20 | San Juan | Colorado | 8111 | 43 | 0 |
1138205 | 1138205 | 2021-03-20 | San Miguel | Colorado | 8113 | 845 | 0 |
1138206 | 1138206 | 2021-03-20 | Sedgwick | Colorado | 8115 | 198 | 2 |
1138207 | 1138207 | 2021-03-20 | Summit | Colorado | 8117 | 3203 | 7 |
1138208 | 1138208 | 2021-03-20 | Teller | Colorado | 8119 | 1364 | 14 |
1138209 | 1138209 | 2021-03-20 | Washington | Colorado | 8121 | 428 | 12 |
1138210 | 1138210 | 2021-03-20 | Weld | Colorado | 8123 | 26800 | 322 |
1138211 | 1138211 | 2021-03-20 | Yuma | Colorado | 8125 | 817 | 17 |
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);