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-04 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1582952 | 1582952 | 2021-08-04 | Adams | Colorado | 8001 | 63937 | 769 |
1582953 | 1582953 | 2021-08-04 | Alamosa | Colorado | 8003 | 1815 | 38 |
1582954 | 1582954 | 2021-08-04 | Arapahoe | Colorado | 8005 | 66084 | 844 |
1582955 | 1582955 | 2021-08-04 | Archuleta | Colorado | 8007 | 1156 | 2 |
1582956 | 1582956 | 2021-08-04 | Baca | Colorado | 8009 | 331 | 4 |
1582957 | 1582957 | 2021-08-04 | Bent | Colorado | 8011 | 1550 | 22 |
1582958 | 1582958 | 2021-08-04 | Boulder | Colorado | 8013 | 24999 | 263 |
1582959 | 1582959 | 2021-08-04 | Broomfield | Colorado | 8014 | 5234 | 77 |
1582960 | 1582960 | 2021-08-04 | Chaffee | Colorado | 8015 | 1854 | 25 |
1582961 | 1582961 | 2021-08-04 | Cheyenne | Colorado | 8017 | 134 | 6 |
1582962 | 1582962 | 2021-08-04 | Clear Creek | Colorado | 8019 | 510 | 3 |
1582963 | 1582963 | 2021-08-04 | Conejos | Colorado | 8021 | 766 | 26 |
1582964 | 1582964 | 2021-08-04 | Costilla | Colorado | 8023 | 258 | 5 |
1582965 | 1582965 | 2021-08-04 | Crowley | Colorado | 8025 | 2219 | 17 |
1582966 | 1582966 | 2021-08-04 | Custer | Colorado | 8027 | 239 | 3 |
1582967 | 1582967 | 2021-08-04 | Delta | Colorado | 8029 | 3141 | 71 |
1582968 | 1582968 | 2021-08-04 | Denver | Colorado | 8031 | 76646 | 852 |
1582969 | 1582969 | 2021-08-04 | Dolores | Colorado | 8033 | 132 | 1 |
1582970 | 1582970 | 2021-08-04 | Douglas | Colorado | 8035 | 32227 | 273 |
1582971 | 1582971 | 2021-08-04 | Eagle | Colorado | 8037 | 6585 | 23 |
1582972 | 1582972 | 2021-08-04 | El Paso | Colorado | 8041 | 77024 | 909 |
1582973 | 1582973 | 2021-08-04 | Elbert | Colorado | 8039 | 1963 | 15 |
1582974 | 1582974 | 2021-08-04 | Fremont | Colorado | 8043 | 6675 | 65 |
1582975 | 1582975 | 2021-08-04 | Garfield | Colorado | 8045 | 6495 | 54 |
1582976 | 1582976 | 2021-08-04 | Gilpin | Colorado | 8047 | 295 | 3 |
1582977 | 1582977 | 2021-08-04 | Grand | Colorado | 8049 | 1542 | 7 |
1582978 | 1582978 | 2021-08-04 | Gunnison | Colorado | 8051 | 1437 | 7 |
1582979 | 1582979 | 2021-08-04 | Hinsdale | Colorado | 8053 | 34 | 0 |
1582980 | 1582980 | 2021-08-04 | Huerfano | Colorado | 8055 | 457 | 18 |
1582981 | 1582981 | 2021-08-04 | Jackson | Colorado | 8057 | 68 | 0 |
1582982 | 1582982 | 2021-08-04 | Jefferson | Colorado | 8059 | 50581 | 815 |
1582983 | 1582983 | 2021-08-04 | Kiowa | Colorado | 8061 | 95 | 3 |
1582984 | 1582984 | 2021-08-04 | Kit Carson | Colorado | 8063 | 675 | 12 |
1582985 | 1582985 | 2021-08-04 | La Plata | Colorado | 8067 | 4341 | 44 |
1582986 | 1582986 | 2021-08-04 | Lake | Colorado | 8065 | 850 | 1 |
1582987 | 1582987 | 2021-08-04 | Larimer | Colorado | 8069 | 29048 | 248 |
1582988 | 1582988 | 2021-08-04 | Las Animas | Colorado | 8071 | 1291 | 14 |
1582989 | 1582989 | 2021-08-04 | Lincoln | Colorado | 8073 | 1049 | 4 |
1582990 | 1582990 | 2021-08-04 | Logan | Colorado | 8075 | 4080 | 69 |
1582991 | 1582991 | 2021-08-04 | Mesa | Colorado | 8077 | 18373 | 270 |
1582992 | 1582992 | 2021-08-04 | Mineral | Colorado | 8079 | 100 | 1 |
1582993 | 1582993 | 2021-08-04 | Moffat | Colorado | 8081 | 1228 | 28 |
1582994 | 1582994 | 2021-08-04 | Montezuma | Colorado | 8083 | 2177 | 28 |
1582995 | 1582995 | 2021-08-04 | Montrose | Colorado | 8085 | 4058 | 71 |
1582996 | 1582996 | 2021-08-04 | Morgan | Colorado | 8087 | 2786 | 96 |
1582997 | 1582997 | 2021-08-04 | Otero | Colorado | 8089 | 2106 | 67 |
1582998 | 1582998 | 2021-08-04 | Ouray | Colorado | 8091 | 319 | 4 |
1582999 | 1582999 | 2021-08-04 | Park | Colorado | 8093 | 894 | 5 |
1583000 | 1583000 | 2021-08-04 | Phillips | Colorado | 8095 | 404 | 13 |
1583001 | 1583001 | 2021-08-04 | Pitkin | Colorado | 8097 | 2704 | 4 |
1583002 | 1583002 | 2021-08-04 | Prowers | Colorado | 8099 | 1305 | 22 |
1583003 | 1583003 | 2021-08-04 | Pueblo | Colorado | 8101 | 20010 | 427 |
1583004 | 1583004 | 2021-08-04 | Rio Blanco | Colorado | 8103 | 702 | 5 |
1583005 | 1583005 | 2021-08-04 | Rio Grande | Colorado | 8105 | 961 | 18 |
1583006 | 1583006 | 2021-08-04 | Routt | Colorado | 8107 | 2451 | 21 |
1583007 | 1583007 | 2021-08-04 | Saguache | Colorado | 8109 | 478 | 8 |
1583008 | 1583008 | 2021-08-04 | San Juan | Colorado | 8111 | 48 | 0 |
1583009 | 1583009 | 2021-08-04 | San Miguel | Colorado | 8113 | 954 | 1 |
1583010 | 1583010 | 2021-08-04 | Sedgwick | Colorado | 8115 | 238 | 3 |
1583011 | 1583011 | 2021-08-04 | Summit | Colorado | 8117 | 3995 | 8 |
1583012 | 1583012 | 2021-08-04 | Teller | Colorado | 8119 | 2004 | 18 |
1583013 | 1583013 | 2021-08-04 | Washington | Colorado | 8121 | 477 | 13 |
1583014 | 1583014 | 2021-08-04 | Weld | Colorado | 8123 | 34749 | 358 |
1583015 | 1583015 | 2021-08-04 | 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);