ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-09-02" 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 |
---|---|---|---|---|---|---|---|
1677154 | 1677154 | 2021-09-02 | Adams | Colorado | 8001 | 67977 | 802 |
1677155 | 1677155 | 2021-09-02 | Alamosa | Colorado | 8003 | 1929 | 39 |
1677156 | 1677156 | 2021-09-02 | Arapahoe | Colorado | 8005 | 70657 | 850 |
1677157 | 1677157 | 2021-09-02 | Archuleta | Colorado | 8007 | 1263 | 3 |
1677158 | 1677158 | 2021-09-02 | Baca | Colorado | 8009 | 360 | 5 |
1677159 | 1677159 | 2021-09-02 | Bent | Colorado | 8011 | 1562 | 22 |
1677160 | 1677160 | 2021-09-02 | Boulder | Colorado | 8013 | 26637 | 266 |
1677161 | 1677161 | 2021-09-02 | Broomfield | Colorado | 8014 | 5664 | 77 |
1677162 | 1677162 | 2021-09-02 | Chaffee | Colorado | 8015 | 1959 | 26 |
1677163 | 1677163 | 2021-09-02 | Cheyenne | Colorado | 8017 | 146 | 7 |
1677164 | 1677164 | 2021-09-02 | Clear Creek | Colorado | 8019 | 592 | 4 |
1677165 | 1677165 | 2021-09-02 | Conejos | Colorado | 8021 | 800 | 27 |
1677166 | 1677166 | 2021-09-02 | Costilla | Colorado | 8023 | 272 | 6 |
1677167 | 1677167 | 2021-09-02 | Crowley | Colorado | 8025 | 2232 | 18 |
1677168 | 1677168 | 2021-09-02 | Custer | Colorado | 8027 | 259 | 6 |
1677169 | 1677169 | 2021-09-02 | Delta | Colorado | 8029 | 3246 | 76 |
1677170 | 1677170 | 2021-09-02 | Denver | Colorado | 8031 | 81229 | 872 |
1677171 | 1677171 | 2021-09-02 | Dolores | Colorado | 8033 | 150 | 1 |
1677172 | 1677172 | 2021-09-02 | Douglas | Colorado | 8035 | 34978 | 278 |
1677173 | 1677173 | 2021-09-02 | Eagle | Colorado | 8037 | 7304 | 29 |
1677174 | 1677174 | 2021-09-02 | El Paso | Colorado | 8041 | 83187 | 944 |
1677175 | 1677175 | 2021-09-02 | Elbert | Colorado | 8039 | 2126 | 16 |
1677176 | 1677176 | 2021-09-02 | Fremont | Colorado | 8043 | 6878 | 70 |
1677177 | 1677177 | 2021-09-02 | Garfield | Colorado | 8045 | 6764 | 57 |
1677178 | 1677178 | 2021-09-02 | Gilpin | Colorado | 8047 | 331 | 3 |
1677179 | 1677179 | 2021-09-02 | Grand | Colorado | 8049 | 1691 | 7 |
1677180 | 1677180 | 2021-09-02 | Gunnison | Colorado | 8051 | 1575 | 8 |
1677181 | 1677181 | 2021-09-02 | Hinsdale | Colorado | 8053 | 47 | 0 |
1677182 | 1677182 | 2021-09-02 | Huerfano | Colorado | 8055 | 492 | 17 |
1677183 | 1677183 | 2021-09-02 | Jackson | Colorado | 8057 | 70 | 0 |
1677184 | 1677184 | 2021-09-02 | Jefferson | Colorado | 8059 | 53902 | 833 |
1677185 | 1677185 | 2021-09-02 | Kiowa | Colorado | 8061 | 109 | 3 |
1677186 | 1677186 | 2021-09-02 | Kit Carson | Colorado | 8063 | 750 | 14 |
1677187 | 1677187 | 2021-09-02 | La Plata | Colorado | 8067 | 4746 | 47 |
1677188 | 1677188 | 2021-09-02 | Lake | Colorado | 8065 | 919 | 1 |
1677189 | 1677189 | 2021-09-02 | Larimer | Colorado | 8069 | 31892 | 261 |
1677190 | 1677190 | 2021-09-02 | Las Animas | Colorado | 8071 | 1495 | 17 |
1677191 | 1677191 | 2021-09-02 | Lincoln | Colorado | 8073 | 1109 | 5 |
1677192 | 1677192 | 2021-09-02 | Logan | Colorado | 8075 | 4193 | 69 |
1677193 | 1677193 | 2021-09-02 | Mesa | Colorado | 8077 | 19551 | 282 |
1677194 | 1677194 | 2021-09-02 | Mineral | Colorado | 8079 | 100 | 1 |
1677195 | 1677195 | 2021-09-02 | Moffat | Colorado | 8081 | 1302 | 30 |
1677196 | 1677196 | 2021-09-02 | Montezuma | Colorado | 8083 | 2400 | 29 |
1677197 | 1677197 | 2021-09-02 | Montrose | Colorado | 8085 | 4296 | 74 |
1677198 | 1677198 | 2021-09-02 | Morgan | Colorado | 8087 | 2919 | 96 |
1677199 | 1677199 | 2021-09-02 | Otero | Colorado | 8089 | 2168 | 69 |
1677200 | 1677200 | 2021-09-02 | Ouray | Colorado | 8091 | 357 | 5 |
1677201 | 1677201 | 2021-09-02 | Park | Colorado | 8093 | 1036 | 7 |
1677202 | 1677202 | 2021-09-02 | Phillips | Colorado | 8095 | 427 | 13 |
1677203 | 1677203 | 2021-09-02 | Pitkin | Colorado | 8097 | 2838 | 4 |
1677204 | 1677204 | 2021-09-02 | Prowers | Colorado | 8099 | 1377 | 25 |
1677205 | 1677205 | 2021-09-02 | Pueblo | Colorado | 8101 | 20963 | 440 |
1677206 | 1677206 | 2021-09-02 | Rio Blanco | Colorado | 8103 | 752 | 7 |
1677207 | 1677207 | 2021-09-02 | Rio Grande | Colorado | 8105 | 1049 | 20 |
1677208 | 1677208 | 2021-09-02 | Routt | Colorado | 8107 | 2702 | 21 |
1677209 | 1677209 | 2021-09-02 | Saguache | Colorado | 8109 | 495 | 8 |
1677210 | 1677210 | 2021-09-02 | San Juan | Colorado | 8111 | 86 | 0 |
1677211 | 1677211 | 2021-09-02 | San Miguel | Colorado | 8113 | 1041 | 3 |
1677212 | 1677212 | 2021-09-02 | Sedgwick | Colorado | 8115 | 262 | 3 |
1677213 | 1677213 | 2021-09-02 | Summit | Colorado | 8117 | 4326 | 9 |
1677214 | 1677214 | 2021-09-02 | Teller | Colorado | 8119 | 2123 | 19 |
1677215 | 1677215 | 2021-09-02 | Washington | Colorado | 8121 | 487 | 13 |
1677216 | 1677216 | 2021-09-02 | Weld | Colorado | 8123 | 37994 | 364 |
1677217 | 1677217 | 2021-09-02 | Yuma | Colorado | 8125 | 1017 | 18 |
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);