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 2022-01-24 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 |
---|---|---|---|---|---|---|---|
2145158 | 2145158 | 2022-01-24 | Adams | Colorado | 8001 | 122812 | 1182 |
2145159 | 2145159 | 2022-01-24 | Alamosa | Colorado | 8003 | 3814 | 58 |
2145160 | 2145160 | 2022-01-24 | Arapahoe | Colorado | 8005 | 139127 | 1142 |
2145161 | 2145161 | 2022-01-24 | Archuleta | Colorado | 8007 | 2609 | 9 |
2145162 | 2145162 | 2022-01-24 | Baca | Colorado | 8009 | 667 | 8 |
2145163 | 2145163 | 2022-01-24 | Bent | Colorado | 8011 | 2118 | 46 |
2145164 | 2145164 | 2022-01-24 | Boulder | Colorado | 8013 | 55422 | 344 |
2145165 | 2145165 | 2022-01-24 | Broomfield | Colorado | 8014 | 11857 | 102 |
2145166 | 2145166 | 2022-01-24 | Chaffee | Colorado | 8015 | 3848 | 39 |
2145167 | 2145167 | 2022-01-24 | Cheyenne | Colorado | 8017 | 282 | 9 |
2145168 | 2145168 | 2022-01-24 | Clear Creek | Colorado | 8019 | 1394 | 10 |
2145169 | 2145169 | 2022-01-24 | Conejos | Colorado | 8021 | 1463 | 49 |
2145170 | 2145170 | 2022-01-24 | Costilla | Colorado | 8023 | 575 | 14 |
2145171 | 2145171 | 2022-01-24 | Crowley | Colorado | 8025 | 2750 | 27 |
2145172 | 2145172 | 2022-01-24 | Custer | Colorado | 8027 | 565 | 16 |
2145173 | 2145173 | 2022-01-24 | Delta | Colorado | 8029 | 5283 | 124 |
2145174 | 2145174 | 2022-01-24 | Denver | Colorado | 8031 | 153846 | 1145 |
2145175 | 2145175 | 2022-01-24 | Dolores | Colorado | 8033 | 323 | 7 |
2145176 | 2145176 | 2022-01-24 | Douglas | Colorado | 8035 | 70842 | 397 |
2145177 | 2145177 | 2022-01-24 | Eagle | Colorado | 8037 | 14689 | 33 |
2145178 | 2145178 | 2022-01-24 | El Paso | Colorado | 8041 | 163517 | 1486 |
2145179 | 2145179 | 2022-01-24 | Elbert | Colorado | 8039 | 4290 | 32 |
2145180 | 2145180 | 2022-01-24 | Fremont | Colorado | 8043 | 12299 | 165 |
2145181 | 2145181 | 2022-01-24 | Garfield | Colorado | 8045 | 13041 | 80 |
2145182 | 2145182 | 2022-01-24 | Gilpin | Colorado | 8047 | 865 | 4 |
2145183 | 2145183 | 2022-01-24 | Grand | Colorado | 8049 | 3219 | 22 |
2145184 | 2145184 | 2022-01-24 | Gunnison | Colorado | 8051 | 3002 | 13 |
2145185 | 2145185 | 2022-01-24 | Hinsdale | Colorado | 8053 | 109 | 0 |
2145186 | 2145186 | 2022-01-24 | Huerfano | Colorado | 8055 | 1209 | 28 |
2145187 | 2145187 | 2022-01-24 | Jackson | Colorado | 8057 | 141 | 0 |
2145188 | 2145188 | 2022-01-24 | Jefferson | Colorado | 8059 | 108745 | 1167 |
2145189 | 2145189 | 2022-01-24 | Kiowa | Colorado | 8061 | 306 | 4 |
2145190 | 2145190 | 2022-01-24 | Kit Carson | Colorado | 8063 | 1450 | 29 |
2145191 | 2145191 | 2022-01-24 | La Plata | Colorado | 8067 | 11076 | 74 |
2145192 | 2145192 | 2022-01-24 | Lake | Colorado | 8065 | 1680 | 2 |
2145193 | 2145193 | 2022-01-24 | Larimer | Colorado | 8069 | 66175 | 420 |
2145194 | 2145194 | 2022-01-24 | Las Animas | Colorado | 8071 | 2960 | 37 |
2145195 | 2145195 | 2022-01-24 | Lincoln | Colorado | 8073 | 1814 | 9 |
2145196 | 2145196 | 2022-01-24 | Logan | Colorado | 8075 | 6057 | 102 |
2145197 | 2145197 | 2022-01-24 | Mesa | Colorado | 8077 | 36623 | 490 |
2145198 | 2145198 | 2022-01-24 | Mineral | Colorado | 8079 | 202 | 1 |
2145199 | 2145199 | 2022-01-24 | Moffat | Colorado | 8081 | 2630 | 50 |
2145200 | 2145200 | 2022-01-24 | Montezuma | Colorado | 8083 | 5066 | 60 |
2145201 | 2145201 | 2022-01-24 | Montrose | Colorado | 8085 | 8137 | 152 |
2145202 | 2145202 | 2022-01-24 | Morgan | Colorado | 8087 | 5028 | 128 |
2145203 | 2145203 | 2022-01-24 | Otero | Colorado | 8089 | 3831 | 118 |
2145204 | 2145204 | 2022-01-24 | Ouray | Colorado | 8091 | 777 | 6 |
2145205 | 2145205 | 2022-01-24 | Park | Colorado | 8093 | 2550 | 17 |
2145206 | 2145206 | 2022-01-24 | Phillips | Colorado | 8095 | 742 | 15 |
2145207 | 2145207 | 2022-01-24 | Pitkin | Colorado | 8097 | 5853 | 6 |
2145208 | 2145208 | 2022-01-24 | Prowers | Colorado | 8099 | 2308 | 45 |
2145209 | 2145209 | 2022-01-24 | Pueblo | Colorado | 8101 | 40270 | 710 |
2145210 | 2145210 | 2022-01-24 | Rio Blanco | Colorado | 8103 | 1411 | 13 |
2145211 | 2145211 | 2022-01-24 | Rio Grande | Colorado | 8105 | 2353 | 41 |
2145212 | 2145212 | 2022-01-24 | Routt | Colorado | 8107 | 5813 | 24 |
2145213 | 2145213 | 2022-01-24 | Saguache | Colorado | 8109 | 993 | 10 |
2145214 | 2145214 | 2022-01-24 | San Juan | Colorado | 8111 | 182 | 0 |
2145215 | 2145215 | 2022-01-24 | San Miguel | Colorado | 8113 | 2049 | 7 |
2145216 | 2145216 | 2022-01-24 | Sedgwick | Colorado | 8115 | 412 | 7 |
2145217 | 2145217 | 2022-01-24 | Summit | Colorado | 8117 | 9133 | 12 |
2145218 | 2145218 | 2022-01-24 | Teller | Colorado | 8119 | 4332 | 54 |
2145219 | 2145219 | 2022-01-24 | Washington | Colorado | 8121 | 861 | 26 |
2145220 | 2145220 | 2022-01-24 | Weld | Colorado | 8123 | 73945 | 620 |
2145221 | 2145221 | 2022-01-24 | Yuma | Colorado | 8125 | 1663 | 22 |
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);