ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-07-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 |
---|---|---|---|---|---|---|---|
1534236 | 1534236 | 2021-07-20 | Adams | Colorado | 8001 | 62915 | 764 |
1534237 | 1534237 | 2021-07-20 | Alamosa | Colorado | 8003 | 1773 | 37 |
1534238 | 1534238 | 2021-07-20 | Arapahoe | Colorado | 8005 | 64974 | 843 |
1534239 | 1534239 | 2021-07-20 | Archuleta | Colorado | 8007 | 1106 | 3 |
1534240 | 1534240 | 2021-07-20 | Baca | Colorado | 8009 | 325 | 4 |
1534241 | 1534241 | 2021-07-20 | Bent | Colorado | 8011 | 1547 | 22 |
1534242 | 1534242 | 2021-07-20 | Boulder | Colorado | 8013 | 24466 | 261 |
1534243 | 1534243 | 2021-07-20 | Broomfield | Colorado | 8014 | 5071 | 76 |
1534244 | 1534244 | 2021-07-20 | Chaffee | Colorado | 8015 | 1799 | 25 |
1534245 | 1534245 | 2021-07-20 | Cheyenne | Colorado | 8017 | 130 | 6 |
1534246 | 1534246 | 2021-07-20 | Clear Creek | Colorado | 8019 | 488 | 3 |
1534247 | 1534247 | 2021-07-20 | Conejos | Colorado | 8021 | 754 | 24 |
1534248 | 1534248 | 2021-07-20 | Costilla | Colorado | 8023 | 253 | 5 |
1534249 | 1534249 | 2021-07-20 | Crowley | Colorado | 8025 | 2216 | 17 |
1534250 | 1534250 | 2021-07-20 | Custer | Colorado | 8027 | 235 | 2 |
1534251 | 1534251 | 2021-07-20 | Delta | Colorado | 8029 | 3073 | 70 |
1534252 | 1534252 | 2021-07-20 | Denver | Colorado | 8031 | 75170 | 848 |
1534253 | 1534253 | 2021-07-20 | Dolores | Colorado | 8033 | 131 | 1 |
1534254 | 1534254 | 2021-07-20 | Douglas | Colorado | 8035 | 31637 | 272 |
1534255 | 1534255 | 2021-07-20 | Eagle | Colorado | 8037 | 6434 | 23 |
1534256 | 1534256 | 2021-07-20 | El Paso | Colorado | 8041 | 74816 | 890 |
1534257 | 1534257 | 2021-07-20 | Elbert | Colorado | 8039 | 1911 | 14 |
1534258 | 1534258 | 2021-07-20 | Fremont | Colorado | 8043 | 6607 | 64 |
1534259 | 1534259 | 2021-07-20 | Garfield | Colorado | 8045 | 6370 | 51 |
1534260 | 1534260 | 2021-07-20 | Gilpin | Colorado | 8047 | 285 | 3 |
1534261 | 1534261 | 2021-07-20 | Grand | Colorado | 8049 | 1516 | 7 |
1534262 | 1534262 | 2021-07-20 | Gunnison | Colorado | 8051 | 1408 | 6 |
1534263 | 1534263 | 2021-07-20 | Hinsdale | Colorado | 8053 | 30 | 0 |
1534264 | 1534264 | 2021-07-20 | Huerfano | Colorado | 8055 | 448 | 18 |
1534265 | 1534265 | 2021-07-20 | Jackson | Colorado | 8057 | 67 | 0 |
1534266 | 1534266 | 2021-07-20 | Jefferson | Colorado | 8059 | 49480 | 810 |
1534267 | 1534267 | 2021-07-20 | Kiowa | Colorado | 8061 | 95 | 3 |
1534268 | 1534268 | 2021-07-20 | Kit Carson | Colorado | 8063 | 654 | 12 |
1534269 | 1534269 | 2021-07-20 | La Plata | Colorado | 8067 | 4239 | 41 |
1534270 | 1534270 | 2021-07-20 | Lake | Colorado | 8065 | 841 | 0 |
1534271 | 1534271 | 2021-07-20 | Larimer | Colorado | 8069 | 28263 | 248 |
1534272 | 1534272 | 2021-07-20 | Las Animas | Colorado | 8071 | 1229 | 14 |
1534273 | 1534273 | 2021-07-20 | Lincoln | Colorado | 8073 | 1041 | 4 |
1534274 | 1534274 | 2021-07-20 | Logan | Colorado | 8075 | 4071 | 69 |
1534275 | 1534275 | 2021-07-20 | Mesa | Colorado | 8077 | 17879 | 260 |
1534276 | 1534276 | 2021-07-20 | Mineral | Colorado | 8079 | 94 | 1 |
1534277 | 1534277 | 2021-07-20 | Moffat | Colorado | 8081 | 1136 | 26 |
1534278 | 1534278 | 2021-07-20 | Montezuma | Colorado | 8083 | 2142 | 27 |
1534279 | 1534279 | 2021-07-20 | Montrose | Colorado | 8085 | 3925 | 67 |
1534280 | 1534280 | 2021-07-20 | Morgan | Colorado | 8087 | 2768 | 96 |
1534281 | 1534281 | 2021-07-20 | Otero | Colorado | 8089 | 2092 | 67 |
1534282 | 1534282 | 2021-07-20 | Ouray | Colorado | 8091 | 309 | 4 |
1534283 | 1534283 | 2021-07-20 | Park | Colorado | 8093 | 851 | 5 |
1534284 | 1534284 | 2021-07-20 | Phillips | Colorado | 8095 | 401 | 13 |
1534285 | 1534285 | 2021-07-20 | Pitkin | Colorado | 8097 | 2640 | 4 |
1534286 | 1534286 | 2021-07-20 | Prowers | Colorado | 8099 | 1282 | 22 |
1534287 | 1534287 | 2021-07-20 | Pueblo | Colorado | 8101 | 19753 | 423 |
1534288 | 1534288 | 2021-07-20 | Rio Blanco | Colorado | 8103 | 669 | 5 |
1534289 | 1534289 | 2021-07-20 | Rio Grande | Colorado | 8105 | 938 | 18 |
1534290 | 1534290 | 2021-07-20 | Routt | Colorado | 8107 | 2381 | 21 |
1534291 | 1534291 | 2021-07-20 | Saguache | Colorado | 8109 | 466 | 7 |
1534292 | 1534292 | 2021-07-20 | San Juan | Colorado | 8111 | 47 | 0 |
1534293 | 1534293 | 2021-07-20 | San Miguel | Colorado | 8113 | 937 | 1 |
1534294 | 1534294 | 2021-07-20 | Sedgwick | Colorado | 8115 | 235 | 3 |
1534295 | 1534295 | 2021-07-20 | Summit | Colorado | 8117 | 3827 | 8 |
1534296 | 1534296 | 2021-07-20 | Teller | Colorado | 8119 | 1944 | 18 |
1534297 | 1534297 | 2021-07-20 | Washington | Colorado | 8121 | 475 | 13 |
1534298 | 1534298 | 2021-07-20 | Weld | Colorado | 8123 | 34019 | 354 |
1534299 | 1534299 | 2021-07-20 | Yuma | Colorado | 8125 | 973 | 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);