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-08-07 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1592700 | 1592700 | 2021-08-07 | Adams | Colorado | 8001 | 64312 | 773 |
1592701 | 1592701 | 2021-08-07 | Alamosa | Colorado | 8003 | 1820 | 38 |
1592702 | 1592702 | 2021-08-07 | Arapahoe | Colorado | 8005 | 66561 | 846 |
1592703 | 1592703 | 2021-08-07 | Archuleta | Colorado | 8007 | 1161 | 2 |
1592704 | 1592704 | 2021-08-07 | Baca | Colorado | 8009 | 333 | 4 |
1592705 | 1592705 | 2021-08-07 | Bent | Colorado | 8011 | 1550 | 22 |
1592706 | 1592706 | 2021-08-07 | Boulder | Colorado | 8013 | 25086 | 263 |
1592707 | 1592707 | 2021-08-07 | Broomfield | Colorado | 8014 | 5259 | 77 |
1592708 | 1592708 | 2021-08-07 | Chaffee | Colorado | 8015 | 1857 | 25 |
1592709 | 1592709 | 2021-08-07 | Cheyenne | Colorado | 8017 | 134 | 6 |
1592710 | 1592710 | 2021-08-07 | Clear Creek | Colorado | 8019 | 516 | 3 |
1592711 | 1592711 | 2021-08-07 | Conejos | Colorado | 8021 | 767 | 26 |
1592712 | 1592712 | 2021-08-07 | Costilla | Colorado | 8023 | 259 | 5 |
1592713 | 1592713 | 2021-08-07 | Crowley | Colorado | 8025 | 2219 | 17 |
1592714 | 1592714 | 2021-08-07 | Custer | Colorado | 8027 | 239 | 3 |
1592715 | 1592715 | 2021-08-07 | Delta | Colorado | 8029 | 3148 | 73 |
1592716 | 1592716 | 2021-08-07 | Denver | Colorado | 8031 | 76952 | 855 |
1592717 | 1592717 | 2021-08-07 | Dolores | Colorado | 8033 | 132 | 1 |
1592718 | 1592718 | 2021-08-07 | Douglas | Colorado | 8035 | 32496 | 275 |
1592719 | 1592719 | 2021-08-07 | Eagle | Colorado | 8037 | 6622 | 23 |
1592720 | 1592720 | 2021-08-07 | El Paso | Colorado | 8041 | 77490 | 910 |
1592721 | 1592721 | 2021-08-07 | Elbert | Colorado | 8039 | 1968 | 15 |
1592722 | 1592722 | 2021-08-07 | Fremont | Colorado | 8043 | 6688 | 65 |
1592723 | 1592723 | 2021-08-07 | Garfield | Colorado | 8045 | 6520 | 55 |
1592724 | 1592724 | 2021-08-07 | Gilpin | Colorado | 8047 | 296 | 3 |
1592725 | 1592725 | 2021-08-07 | Grand | Colorado | 8049 | 1546 | 7 |
1592726 | 1592726 | 2021-08-07 | Gunnison | Colorado | 8051 | 1441 | 7 |
1592727 | 1592727 | 2021-08-07 | Hinsdale | Colorado | 8053 | 34 | 0 |
1592728 | 1592728 | 2021-08-07 | Huerfano | Colorado | 8055 | 459 | 18 |
1592729 | 1592729 | 2021-08-07 | Jackson | Colorado | 8057 | 68 | 0 |
1592730 | 1592730 | 2021-08-07 | Jefferson | Colorado | 8059 | 50763 | 816 |
1592731 | 1592731 | 2021-08-07 | Kiowa | Colorado | 8061 | 97 | 3 |
1592732 | 1592732 | 2021-08-07 | Kit Carson | Colorado | 8063 | 677 | 13 |
1592733 | 1592733 | 2021-08-07 | La Plata | Colorado | 8067 | 4371 | 45 |
1592734 | 1592734 | 2021-08-07 | Lake | Colorado | 8065 | 850 | 1 |
1592735 | 1592735 | 2021-08-07 | Larimer | Colorado | 8069 | 29198 | 248 |
1592736 | 1592736 | 2021-08-07 | Las Animas | Colorado | 8071 | 1293 | 14 |
1592737 | 1592737 | 2021-08-07 | Lincoln | Colorado | 8073 | 1051 | 4 |
1592738 | 1592738 | 2021-08-07 | Logan | Colorado | 8075 | 4088 | 69 |
1592739 | 1592739 | 2021-08-07 | Mesa | Colorado | 8077 | 18434 | 270 |
1592740 | 1592740 | 2021-08-07 | Mineral | Colorado | 8079 | 100 | 1 |
1592741 | 1592741 | 2021-08-07 | Moffat | Colorado | 8081 | 1234 | 28 |
1592742 | 1592742 | 2021-08-07 | Montezuma | Colorado | 8083 | 2188 | 28 |
1592743 | 1592743 | 2021-08-07 | Montrose | Colorado | 8085 | 4078 | 71 |
1592744 | 1592744 | 2021-08-07 | Morgan | Colorado | 8087 | 2789 | 96 |
1592745 | 1592745 | 2021-08-07 | Otero | Colorado | 8089 | 2109 | 67 |
1592746 | 1592746 | 2021-08-07 | Ouray | Colorado | 8091 | 319 | 4 |
1592747 | 1592747 | 2021-08-07 | Park | Colorado | 8093 | 902 | 5 |
1592748 | 1592748 | 2021-08-07 | Phillips | Colorado | 8095 | 404 | 13 |
1592749 | 1592749 | 2021-08-07 | Pitkin | Colorado | 8097 | 2707 | 4 |
1592750 | 1592750 | 2021-08-07 | Prowers | Colorado | 8099 | 1308 | 23 |
1592751 | 1592751 | 2021-08-07 | Pueblo | Colorado | 8101 | 20064 | 427 |
1592752 | 1592752 | 2021-08-07 | Rio Blanco | Colorado | 8103 | 706 | 5 |
1592753 | 1592753 | 2021-08-07 | Rio Grande | Colorado | 8105 | 964 | 19 |
1592754 | 1592754 | 2021-08-07 | Routt | Colorado | 8107 | 2464 | 21 |
1592755 | 1592755 | 2021-08-07 | Saguache | Colorado | 8109 | 478 | 8 |
1592756 | 1592756 | 2021-08-07 | San Juan | Colorado | 8111 | 55 | 0 |
1592757 | 1592757 | 2021-08-07 | San Miguel | Colorado | 8113 | 960 | 1 |
1592758 | 1592758 | 2021-08-07 | Sedgwick | Colorado | 8115 | 239 | 3 |
1592759 | 1592759 | 2021-08-07 | Summit | Colorado | 8117 | 4019 | 8 |
1592760 | 1592760 | 2021-08-07 | Teller | Colorado | 8119 | 2012 | 18 |
1592761 | 1592761 | 2021-08-07 | Washington | Colorado | 8121 | 478 | 13 |
1592762 | 1592762 | 2021-08-07 | Weld | Colorado | 8123 | 34883 | 359 |
1592763 | 1592763 | 2021-08-07 | Yuma | Colorado | 8125 | 984 | 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);