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-01-01 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
884982 | 884982 | 2021-01-01 | Adams | Colorado | 8001 | 40696 | 533 |
884983 | 884983 | 2021-01-01 | Alamosa | Colorado | 8003 | 948 | 24 |
884984 | 884984 | 2021-01-01 | Arapahoe | Colorado | 8005 | 38791 | 595 |
884985 | 884985 | 2021-01-01 | Archuleta | Colorado | 8007 | 487 | 0 |
884986 | 884986 | 2021-01-01 | Baca | Colorado | 8009 | 194 | 1 |
884987 | 884987 | 2021-01-01 | Bent | Colorado | 8011 | 1126 | 12 |
884988 | 884988 | 2021-01-01 | Boulder | Colorado | 8013 | 14729 | 182 |
884989 | 884989 | 2021-01-01 | Broomfield | Colorado | 8014 | 2837 | 67 |
884990 | 884990 | 2021-01-01 | Chaffee | Colorado | 8015 | 1072 | 21 |
884991 | 884991 | 2021-01-01 | Cheyenne | Colorado | 8017 | 89 | 5 |
884992 | 884992 | 2021-01-01 | Clear Creek | Colorado | 8019 | 282 | 2 |
884993 | 884993 | 2021-01-01 | Conejos | Colorado | 8021 | 318 | 3 |
884994 | 884994 | 2021-01-01 | Costilla | Colorado | 8023 | 163 | 2 |
884995 | 884995 | 2021-01-01 | Crowley | Colorado | 8025 | 1660 | 12 |
884996 | 884996 | 2021-01-01 | Custer | Colorado | 8027 | 148 | 0 |
884997 | 884997 | 2021-01-01 | Delta | Colorado | 8029 | 1610 | 25 |
884998 | 884998 | 2021-01-01 | Denver | Colorado | 8031 | 48023 | 674 |
884999 | 884999 | 2021-01-01 | Dolores | Colorado | 8033 | 52 | 0 |
885000 | 885000 | 2021-01-01 | Douglas | Colorado | 8035 | 16085 | 200 |
885001 | 885001 | 2021-01-01 | Eagle | Colorado | 8037 | 3392 | 16 |
885002 | 885002 | 2021-01-01 | El Paso | Colorado | 8041 | 41628 | 567 |
885003 | 885003 | 2021-01-01 | Elbert | Colorado | 8039 | 996 | 10 |
885004 | 885004 | 2021-01-01 | Fremont | Colorado | 8043 | 4681 | 20 |
885005 | 885005 | 2021-01-01 | Garfield | Colorado | 8045 | 3916 | 29 |
885006 | 885006 | 2021-01-01 | Gilpin | Colorado | 8047 | 125 | 1 |
885007 | 885007 | 2021-01-01 | Grand | Colorado | 8049 | 671 | 4 |
885008 | 885008 | 2021-01-01 | Gunnison | Colorado | 8051 | 714 | 6 |
885009 | 885009 | 2021-01-01 | Hinsdale | Colorado | 8053 | 14 | 0 |
885010 | 885010 | 2021-01-01 | Huerfano | Colorado | 8055 | 276 | 18 |
885011 | 885011 | 2021-01-01 | Jackson | Colorado | 8057 | 33 | 0 |
885012 | 885012 | 2021-01-01 | Jefferson | Colorado | 8059 | 29776 | 617 |
885013 | 885013 | 2021-01-01 | Kiowa | Colorado | 8061 | 75 | 2 |
885014 | 885014 | 2021-01-01 | Kit Carson | Colorado | 8063 | 438 | 9 |
885015 | 885015 | 2021-01-01 | La Plata | Colorado | 8067 | 2245 | 28 |
885016 | 885016 | 2021-01-01 | Lake | Colorado | 8065 | 433 | 0 |
885017 | 885017 | 2021-01-01 | Larimer | Colorado | 8069 | 15232 | 147 |
885018 | 885018 | 2021-01-01 | Las Animas | Colorado | 8071 | 512 | 6 |
885019 | 885019 | 2021-01-01 | Lincoln | Colorado | 8073 | 783 | 3 |
885020 | 885020 | 2021-01-01 | Logan | Colorado | 8075 | 3249 | 55 |
885021 | 885021 | 2021-01-01 | Mesa | Colorado | 8077 | 9239 | 139 |
885022 | 885022 | 2021-01-01 | Mineral | Colorado | 8079 | 44 | 1 |
885023 | 885023 | 2021-01-01 | Moffat | Colorado | 8081 | 543 | 20 |
885024 | 885024 | 2021-01-01 | Montezuma | Colorado | 8083 | 1242 | 16 |
885025 | 885025 | 2021-01-01 | Montrose | Colorado | 8085 | 2134 | 31 |
885026 | 885026 | 2021-01-01 | Morgan | Colorado | 8087 | 2136 | 82 |
885027 | 885027 | 2021-01-01 | Otero | Colorado | 8089 | 1648 | 39 |
885028 | 885028 | 2021-01-01 | Ouray | Colorado | 8091 | 155 | 3 |
885029 | 885029 | 2021-01-01 | Park | Colorado | 8093 | 384 | 5 |
885030 | 885030 | 2021-01-01 | Phillips | Colorado | 8095 | 286 | 8 |
885031 | 885031 | 2021-01-01 | Pitkin | Colorado | 8097 | 1045 | 4 |
885032 | 885032 | 2021-01-01 | Prowers | Colorado | 8099 | 1007 | 20 |
885033 | 885033 | 2021-01-01 | Pueblo | Colorado | 8101 | 13328 | 313 |
885034 | 885034 | 2021-01-01 | Rio Blanco | Colorado | 8103 | 269 | 3 |
885035 | 885035 | 2021-01-01 | Rio Grande | Colorado | 8105 | 393 | 7 |
885036 | 885036 | 2021-01-01 | Routt | Colorado | 8107 | 1058 | 18 |
885037 | 885037 | 2021-01-01 | Saguache | Colorado | 8109 | 256 | 4 |
885038 | 885038 | 2021-01-01 | San Juan | Colorado | 8111 | 27 | 0 |
885039 | 885039 | 2021-01-01 | San Miguel | Colorado | 8113 | 394 | 0 |
885040 | 885040 | 2021-01-01 | Sedgwick | Colorado | 8115 | 134 | 2 |
885041 | 885041 | 2021-01-01 | Summit | Colorado | 8117 | 2143 | 5 |
885042 | 885042 | 2021-01-01 | Teller | Colorado | 8119 | 994 | 9 |
885043 | 885043 | 2021-01-01 | Washington | Colorado | 8121 | 347 | 11 |
885044 | 885044 | 2021-01-01 | Weld | Colorado | 8123 | 20100 | 287 |
885045 | 885045 | 2021-01-01 | Yuma | Colorado | 8125 | 552 | 13 |
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);