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 2020-11-17 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
738938 | 738938 | 2020-11-17 | Adams | Colorado | 8001 | 23339 | 289 |
738939 | 738939 | 2020-11-17 | Alamosa | Colorado | 8003 | 465 | 11 |
738940 | 738940 | 2020-11-17 | Arapahoe | Colorado | 8005 | 20970 | 417 |
738941 | 738941 | 2020-11-17 | Archuleta | Colorado | 8007 | 106 | 0 |
738942 | 738942 | 2020-11-17 | Baca | Colorado | 8009 | 45 | 0 |
738943 | 738943 | 2020-11-17 | Bent | Colorado | 8011 | 37 | 0 |
738944 | 738944 | 2020-11-17 | Boulder | Colorado | 8013 | 8910 | 108 |
738945 | 738945 | 2020-11-17 | Broomfield | Colorado | 8014 | 1581 | 46 |
738946 | 738946 | 2020-11-17 | Chaffee | Colorado | 8015 | 508 | 20 |
738947 | 738947 | 2020-11-17 | Cheyenne | Colorado | 8017 | 29 | 0 |
738948 | 738948 | 2020-11-17 | Clear Creek | Colorado | 8019 | 145 | 1 |
738949 | 738949 | 2020-11-17 | Conejos | Colorado | 8021 | 130 | 2 |
738950 | 738950 | 2020-11-17 | Costilla | Colorado | 8023 | 61 | 1 |
738951 | 738951 | 2020-11-17 | Crowley | Colorado | 8025 | 697 | 1 |
738952 | 738952 | 2020-11-17 | Custer | Colorado | 8027 | 50 | 0 |
738953 | 738953 | 2020-11-17 | Delta | Colorado | 8029 | 375 | 7 |
738954 | 738954 | 2020-11-17 | Denver | Colorado | 8031 | 29229 | 491 |
738955 | 738955 | 2020-11-17 | Dolores | Colorado | 8033 | 4 | 0 |
738956 | 738956 | 2020-11-17 | Douglas | Colorado | 8035 | 7670 | 84 |
738957 | 738957 | 2020-11-17 | Eagle | Colorado | 8037 | 1930 | 11 |
738958 | 738958 | 2020-11-17 | El Paso | Colorado | 8041 | 19751 | 232 |
738959 | 738959 | 2020-11-17 | Elbert | Colorado | 8039 | 419 | 4 |
738960 | 738960 | 2020-11-17 | Fremont | Colorado | 8043 | 1619 | 2 |
738961 | 738961 | 2020-11-17 | Garfield | Colorado | 8045 | 1666 | 6 |
738962 | 738962 | 2020-11-17 | Gilpin | Colorado | 8047 | 63 | 0 |
738963 | 738963 | 2020-11-17 | Grand | Colorado | 8049 | 229 | 1 |
738964 | 738964 | 2020-11-17 | Gunnison | Colorado | 8051 | 426 | 7 |
738965 | 738965 | 2020-11-17 | Hinsdale | Colorado | 8053 | 6 | 0 |
738966 | 738966 | 2020-11-17 | Huerfano | Colorado | 8055 | 94 | 4 |
738967 | 738967 | 2020-11-17 | Jackson | Colorado | 8057 | 14 | 0 |
738968 | 738968 | 2020-11-17 | Jefferson | Colorado | 8059 | 15287 | 388 |
738969 | 738969 | 2020-11-17 | Kiowa | Colorado | 8061 | 16 | 0 |
738970 | 738970 | 2020-11-17 | Kit Carson | Colorado | 8063 | 236 | 3 |
738971 | 738971 | 2020-11-17 | La Plata | Colorado | 8067 | 660 | 3 |
738972 | 738972 | 2020-11-17 | Lake | Colorado | 8065 | 202 | 0 |
738973 | 738973 | 2020-11-17 | Larimer | Colorado | 8069 | 7415 | 64 |
738974 | 738974 | 2020-11-17 | Las Animas | Colorado | 8071 | 123 | 0 |
738975 | 738975 | 2020-11-17 | Lincoln | Colorado | 8073 | 88 | 0 |
738976 | 738976 | 2020-11-17 | Logan | Colorado | 8075 | 1771 | 18 |
738977 | 738977 | 2020-11-17 | Mesa | Colorado | 8077 | 3859 | 39 |
738978 | 738978 | 2020-11-17 | Mineral | Colorado | 8079 | 21 | 0 |
738979 | 738979 | 2020-11-17 | Moffat | Colorado | 8081 | 151 | 1 |
738980 | 738980 | 2020-11-17 | Montezuma | Colorado | 8083 | 437 | 5 |
738981 | 738981 | 2020-11-17 | Montrose | Colorado | 8085 | 670 | 14 |
738982 | 738982 | 2020-11-17 | Morgan | Colorado | 8087 | 1301 | 51 |
738983 | 738983 | 2020-11-17 | Otero | Colorado | 8089 | 326 | 6 |
738984 | 738984 | 2020-11-17 | Ouray | Colorado | 8091 | 104 | 2 |
738985 | 738985 | 2020-11-17 | Park | Colorado | 8093 | 175 | 3 |
738986 | 738986 | 2020-11-17 | Phillips | Colorado | 8095 | 131 | 1 |
738987 | 738987 | 2020-11-17 | Pitkin | Colorado | 8097 | 395 | 2 |
738988 | 738988 | 2020-11-17 | Prowers | Colorado | 8099 | 381 | 11 |
738989 | 738989 | 2020-11-17 | Pueblo | Colorado | 8101 | 5275 | 69 |
738990 | 738990 | 2020-11-17 | Rio Blanco | Colorado | 8103 | 67 | 0 |
738991 | 738991 | 2020-11-17 | Rio Grande | Colorado | 8105 | 179 | 4 |
738992 | 738992 | 2020-11-17 | Routt | Colorado | 8107 | 418 | 9 |
738993 | 738993 | 2020-11-17 | Saguache | Colorado | 8109 | 194 | 2 |
738994 | 738994 | 2020-11-17 | San Juan | Colorado | 8111 | 16 | 0 |
738995 | 738995 | 2020-11-17 | San Miguel | Colorado | 8113 | 166 | 0 |
738996 | 738996 | 2020-11-17 | Sedgwick | Colorado | 8115 | 77 | 1 |
738997 | 738997 | 2020-11-17 | Summit | Colorado | 8117 | 1174 | 4 |
738998 | 738998 | 2020-11-17 | Teller | Colorado | 8119 | 419 | 4 |
738999 | 738999 | 2020-11-17 | Washington | Colorado | 8121 | 165 | 3 |
739000 | 739000 | 2020-11-17 | Weld | Colorado | 8123 | 10486 | 173 |
739001 | 739001 | 2020-11-17 | Yuma | Colorado | 8125 | 267 | 1 |
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);