ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-11-22" 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 |
---|---|---|---|---|---|---|---|
1940340 | 1940340 | 2021-11-22 | Adams | Colorado | 8001 | 84508 | 959 |
1940341 | 1940341 | 2021-11-22 | Alamosa | Colorado | 8003 | 2834 | 47 |
1940342 | 1940342 | 2021-11-22 | Arapahoe | Colorado | 8005 | 88980 | 983 |
1940343 | 1940343 | 2021-11-22 | Archuleta | Colorado | 8007 | 1798 | 7 |
1940344 | 1940344 | 2021-11-22 | Baca | Colorado | 8009 | 543 | 5 |
1940345 | 1940345 | 2021-11-22 | Bent | Colorado | 8011 | 1851 | 31 |
1940346 | 1940346 | 2021-11-22 | Boulder | Colorado | 8013 | 34208 | 306 |
1940347 | 1940347 | 2021-11-22 | Broomfield | Colorado | 8014 | 7428 | 84 |
1940348 | 1940348 | 2021-11-22 | Chaffee | Colorado | 8015 | 2637 | 34 |
1940349 | 1940349 | 2021-11-22 | Cheyenne | Colorado | 8017 | 228 | 7 |
1940350 | 1940350 | 2021-11-22 | Clear Creek | Colorado | 8019 | 875 | 6 |
1940351 | 1940351 | 2021-11-22 | Conejos | Colorado | 8021 | 1112 | 41 |
1940352 | 1940352 | 2021-11-22 | Costilla | Colorado | 8023 | 422 | 13 |
1940353 | 1940353 | 2021-11-22 | Crowley | Colorado | 8025 | 2457 | 26 |
1940354 | 1940354 | 2021-11-22 | Custer | Colorado | 8027 | 455 | 11 |
1940355 | 1940355 | 2021-11-22 | Delta | Colorado | 8029 | 4474 | 95 |
1940356 | 1940356 | 2021-11-22 | Denver | Colorado | 8031 | 99909 | 993 |
1940357 | 1940357 | 2021-11-22 | Dolores | Colorado | 8033 | 255 | 5 |
1940358 | 1940358 | 2021-11-22 | Douglas | Colorado | 8035 | 45455 | 339 |
1940359 | 1940359 | 2021-11-22 | Eagle | Colorado | 8037 | 9114 | 32 |
1940360 | 1940360 | 2021-11-22 | El Paso | Colorado | 8041 | 112103 | 1226 |
1940361 | 1940361 | 2021-11-22 | Elbert | Colorado | 8039 | 2946 | 26 |
1940362 | 1940362 | 2021-11-22 | Fremont | Colorado | 8043 | 9749 | 121 |
1940363 | 1940363 | 2021-11-22 | Garfield | Colorado | 8045 | 8560 | 68 |
1940364 | 1940364 | 2021-11-22 | Gilpin | Colorado | 8047 | 522 | 3 |
1940365 | 1940365 | 2021-11-22 | Grand | Colorado | 8049 | 2268 | 16 |
1940366 | 1940366 | 2021-11-22 | Gunnison | Colorado | 8051 | 1961 | 12 |
1940367 | 1940367 | 2021-11-22 | Hinsdale | Colorado | 8053 | 64 | 0 |
1940368 | 1940368 | 2021-11-22 | Huerfano | Colorado | 8055 | 783 | 21 |
1940369 | 1940369 | 2021-11-22 | Jackson | Colorado | 8057 | 118 | 0 |
1940370 | 1940370 | 2021-11-22 | Jefferson | Colorado | 8059 | 71001 | 972 |
1940371 | 1940371 | 2021-11-22 | Kiowa | Colorado | 8061 | 259 | 4 |
1940372 | 1940372 | 2021-11-22 | Kit Carson | Colorado | 8063 | 1097 | 20 |
1940373 | 1940373 | 2021-11-22 | La Plata | Colorado | 8067 | 6767 | 58 |
1940374 | 1940374 | 2021-11-22 | Lake | Colorado | 8065 | 1104 | 1 |
1940375 | 1940375 | 2021-11-22 | Larimer | Colorado | 8069 | 44161 | 355 |
1940376 | 1940376 | 2021-11-22 | Las Animas | Colorado | 8071 | 2113 | 27 |
1940377 | 1940377 | 2021-11-22 | Lincoln | Colorado | 8073 | 1353 | 8 |
1940378 | 1940378 | 2021-11-22 | Logan | Colorado | 8075 | 5014 | 91 |
1940379 | 1940379 | 2021-11-22 | Mesa | Colorado | 8077 | 27282 | 386 |
1940380 | 1940380 | 2021-11-22 | Mineral | Colorado | 8079 | 148 | 1 |
1940381 | 1940381 | 2021-11-22 | Moffat | Colorado | 8081 | 2133 | 47 |
1940382 | 1940382 | 2021-11-22 | Montezuma | Colorado | 8083 | 3791 | 45 |
1940383 | 1940383 | 2021-11-22 | Montrose | Colorado | 8085 | 6459 | 104 |
1940384 | 1940384 | 2021-11-22 | Morgan | Colorado | 8087 | 3869 | 106 |
1940385 | 1940385 | 2021-11-22 | Otero | Colorado | 8089 | 3095 | 91 |
1940386 | 1940386 | 2021-11-22 | Ouray | Colorado | 8091 | 502 | 6 |
1940387 | 1940387 | 2021-11-22 | Park | Colorado | 8093 | 1638 | 11 |
1940388 | 1940388 | 2021-11-22 | Phillips | Colorado | 8095 | 568 | 15 |
1940389 | 1940389 | 2021-11-22 | Pitkin | Colorado | 8097 | 3284 | 6 |
1940390 | 1940390 | 2021-11-22 | Prowers | Colorado | 8099 | 1871 | 35 |
1940391 | 1940391 | 2021-11-22 | Pueblo | Colorado | 8101 | 28867 | 560 |
1940392 | 1940392 | 2021-11-22 | Rio Blanco | Colorado | 8103 | 1183 | 9 |
1940393 | 1940393 | 2021-11-22 | Rio Grande | Colorado | 8105 | 1759 | 27 |
1940394 | 1940394 | 2021-11-22 | Routt | Colorado | 8107 | 3784 | 23 |
1940395 | 1940395 | 2021-11-22 | Saguache | Colorado | 8109 | 781 | 8 |
1940396 | 1940396 | 2021-11-22 | San Juan | Colorado | 8111 | 104 | 0 |
1940397 | 1940397 | 2021-11-22 | San Miguel | Colorado | 8113 | 1259 | 5 |
1940398 | 1940398 | 2021-11-22 | Sedgwick | Colorado | 8115 | 350 | 5 |
1940399 | 1940399 | 2021-11-22 | Summit | Colorado | 8117 | 5235 | 12 |
1940400 | 1940400 | 2021-11-22 | Teller | Colorado | 8119 | 3212 | 39 |
1940401 | 1940401 | 2021-11-22 | Washington | Colorado | 8121 | 737 | 23 |
1940402 | 1940402 | 2021-11-22 | Weld | Colorado | 8123 | 51760 | 512 |
1940403 | 1940403 | 2021-11-22 | Yuma | Colorado | 8125 | 1351 | 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);