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-12-13 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 |
---|---|---|---|---|---|---|---|
2008602 | 2008602 | 2021-12-13 | Adams | Colorado | 8001 | 89314 | 1029 |
2008603 | 2008603 | 2021-12-13 | Alamosa | Colorado | 8003 | 3014 | 51 |
2008604 | 2008604 | 2021-12-13 | Arapahoe | Colorado | 8005 | 94331 | 1032 |
2008605 | 2008605 | 2021-12-13 | Archuleta | Colorado | 8007 | 1978 | 8 |
2008606 | 2008606 | 2021-12-13 | Baca | Colorado | 8009 | 578 | 6 |
2008607 | 2008607 | 2021-12-13 | Bent | Colorado | 8011 | 1924 | 34 |
2008608 | 2008608 | 2021-12-13 | Boulder | Colorado | 8013 | 36135 | 318 |
2008609 | 2008609 | 2021-12-13 | Broomfield | Colorado | 8014 | 7892 | 90 |
2008610 | 2008610 | 2021-12-13 | Chaffee | Colorado | 8015 | 2764 | 38 |
2008611 | 2008611 | 2021-12-13 | Cheyenne | Colorado | 8017 | 240 | 7 |
2008612 | 2008612 | 2021-12-13 | Clear Creek | Colorado | 8019 | 920 | 7 |
2008613 | 2008613 | 2021-12-13 | Conejos | Colorado | 8021 | 1168 | 43 |
2008614 | 2008614 | 2021-12-13 | Costilla | Colorado | 8023 | 436 | 13 |
2008615 | 2008615 | 2021-12-13 | Crowley | Colorado | 8025 | 2486 | 27 |
2008616 | 2008616 | 2021-12-13 | Custer | Colorado | 8027 | 480 | 13 |
2008617 | 2008617 | 2021-12-13 | Delta | Colorado | 8029 | 4683 | 111 |
2008618 | 2008618 | 2021-12-13 | Denver | Colorado | 8031 | 105104 | 1048 |
2008619 | 2008619 | 2021-12-13 | Dolores | Colorado | 8033 | 272 | 5 |
2008620 | 2008620 | 2021-12-13 | Douglas | Colorado | 8035 | 48124 | 356 |
2008621 | 2008621 | 2021-12-13 | Eagle | Colorado | 8037 | 9429 | 32 |
2008622 | 2008622 | 2021-12-13 | El Paso | Colorado | 8041 | 118247 | 1317 |
2008623 | 2008623 | 2021-12-13 | Elbert | Colorado | 8039 | 3113 | 29 |
2008624 | 2008624 | 2021-12-13 | Fremont | Colorado | 8043 | 10365 | 145 |
2008625 | 2008625 | 2021-12-13 | Garfield | Colorado | 8045 | 9119 | 75 |
2008626 | 2008626 | 2021-12-13 | Gilpin | Colorado | 8047 | 552 | 4 |
2008627 | 2008627 | 2021-12-13 | Grand | Colorado | 8049 | 2364 | 17 |
2008628 | 2008628 | 2021-12-13 | Gunnison | Colorado | 8051 | 2062 | 12 |
2008629 | 2008629 | 2021-12-13 | Hinsdale | Colorado | 8053 | 65 | 0 |
2008630 | 2008630 | 2021-12-13 | Huerfano | Colorado | 8055 | 876 | 23 |
2008631 | 2008631 | 2021-12-13 | Jackson | Colorado | 8057 | 126 | 0 |
2008632 | 2008632 | 2021-12-13 | Jefferson | Colorado | 8059 | 75689 | 1031 |
2008633 | 2008633 | 2021-12-13 | Kiowa | Colorado | 8061 | 276 | 4 |
2008634 | 2008634 | 2021-12-13 | Kit Carson | Colorado | 8063 | 1208 | 24 |
2008635 | 2008635 | 2021-12-13 | La Plata | Colorado | 8067 | 7207 | 64 |
2008636 | 2008636 | 2021-12-13 | Lake | Colorado | 8065 | 1210 | 1 |
2008637 | 2008637 | 2021-12-13 | Larimer | Colorado | 8069 | 46752 | 387 |
2008638 | 2008638 | 2021-12-13 | Las Animas | Colorado | 8071 | 2297 | 27 |
2008639 | 2008639 | 2021-12-13 | Lincoln | Colorado | 8073 | 1414 | 8 |
2008640 | 2008640 | 2021-12-13 | Logan | Colorado | 8075 | 5196 | 95 |
2008641 | 2008641 | 2021-12-13 | Mesa | Colorado | 8077 | 29048 | 427 |
2008642 | 2008642 | 2021-12-13 | Mineral | Colorado | 8079 | 150 | 1 |
2008643 | 2008643 | 2021-12-13 | Moffat | Colorado | 8081 | 2218 | 47 |
2008644 | 2008644 | 2021-12-13 | Montezuma | Colorado | 8083 | 4094 | 50 |
2008645 | 2008645 | 2021-12-13 | Montrose | Colorado | 8085 | 6876 | 125 |
2008646 | 2008646 | 2021-12-13 | Morgan | Colorado | 8087 | 4120 | 119 |
2008647 | 2008647 | 2021-12-13 | Otero | Colorado | 8089 | 3291 | 112 |
2008648 | 2008648 | 2021-12-13 | Ouray | Colorado | 8091 | 532 | 6 |
2008649 | 2008649 | 2021-12-13 | Park | Colorado | 8093 | 1792 | 13 |
2008650 | 2008650 | 2021-12-13 | Phillips | Colorado | 8095 | 596 | 15 |
2008651 | 2008651 | 2021-12-13 | Pitkin | Colorado | 8097 | 3336 | 6 |
2008652 | 2008652 | 2021-12-13 | Prowers | Colorado | 8099 | 2000 | 41 |
2008653 | 2008653 | 2021-12-13 | Pueblo | Colorado | 8101 | 30421 | 625 |
2008654 | 2008654 | 2021-12-13 | Rio Blanco | Colorado | 8103 | 1244 | 11 |
2008655 | 2008655 | 2021-12-13 | Rio Grande | Colorado | 8105 | 1905 | 34 |
2008656 | 2008656 | 2021-12-13 | Routt | Colorado | 8107 | 3897 | 24 |
2008657 | 2008657 | 2021-12-13 | Saguache | Colorado | 8109 | 827 | 9 |
2008658 | 2008658 | 2021-12-13 | San Juan | Colorado | 8111 | 108 | 0 |
2008659 | 2008659 | 2021-12-13 | San Miguel | Colorado | 8113 | 1302 | 5 |
2008660 | 2008660 | 2021-12-13 | Sedgwick | Colorado | 8115 | 360 | 6 |
2008661 | 2008661 | 2021-12-13 | Summit | Colorado | 8117 | 5521 | 12 |
2008662 | 2008662 | 2021-12-13 | Teller | Colorado | 8119 | 3435 | 46 |
2008663 | 2008663 | 2021-12-13 | Washington | Colorado | 8121 | 757 | 24 |
2008664 | 2008664 | 2021-12-13 | Weld | Colorado | 8123 | 54856 | 560 |
2008665 | 2008665 | 2021-12-13 | Yuma | Colorado | 8125 | 1422 | 20 |
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);