ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-04-04 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Alamosa 1
- Arapahoe 1
- Archuleta 1
- Baca 1
- Boulder 1
- Broomfield 1
- Chaffee 1
- Clear Creek 1
- Costilla 1
- Crowley 1
- Custer 1
- Delta 1
- Denver 1
- Douglas 1
- Eagle 1
- El Paso 1
- Elbert 1
- Fremont 1
- Garfield 1
- Grand 1
- Gunnison 1
- Hinsdale 1
- Huerfano 1
- Jefferson 1
- Kit Carson 1
- La Plata 1
- Lake 1
- Larimer 1
- Las Animas 1
- …
state 1
- Colorado · 55 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30958 | 30958 | 2020-04-04 | Adams | Colorado | 8001 | 320 | 9 |
30959 | 30959 | 2020-04-04 | Alamosa | Colorado | 8003 | 4 | 0 |
30960 | 30960 | 2020-04-04 | Arapahoe | Colorado | 8005 | 552 | 10 |
30961 | 30961 | 2020-04-04 | Archuleta | Colorado | 8007 | 1 | 0 |
30962 | 30962 | 2020-04-04 | Baca | Colorado | 8009 | 9 | 0 |
30963 | 30963 | 2020-04-04 | Boulder | Colorado | 8013 | 159 | 3 |
30964 | 30964 | 2020-04-04 | Broomfield | Colorado | 8014 | 44 | 2 |
30965 | 30965 | 2020-04-04 | Chaffee | Colorado | 8015 | 21 | 2 |
30966 | 30966 | 2020-04-04 | Clear Creek | Colorado | 8019 | 6 | 0 |
30967 | 30967 | 2020-04-04 | Costilla | Colorado | 8023 | 3 | 0 |
30968 | 30968 | 2020-04-04 | Crowley | Colorado | 8025 | 1 | 1 |
30969 | 30969 | 2020-04-04 | Custer | Colorado | 8027 | 2 | 0 |
30970 | 30970 | 2020-04-04 | Delta | Colorado | 8029 | 4 | 0 |
30971 | 30971 | 2020-04-04 | Denver | Colorado | 8031 | 769 | 14 |
30972 | 30972 | 2020-04-04 | Douglas | Colorado | 8035 | 209 | 3 |
30973 | 30973 | 2020-04-04 | Eagle | Colorado | 8037 | 333 | 5 |
30974 | 30974 | 2020-04-04 | El Paso | Colorado | 8041 | 406 | 22 |
30975 | 30975 | 2020-04-04 | Elbert | Colorado | 8039 | 9 | 1 |
30976 | 30976 | 2020-04-04 | Fremont | Colorado | 8043 | 3 | 0 |
30977 | 30977 | 2020-04-04 | Garfield | Colorado | 8045 | 45 | 1 |
30978 | 30978 | 2020-04-04 | Grand | Colorado | 8049 | 4 | 0 |
30979 | 30979 | 2020-04-04 | Gunnison | Colorado | 8051 | 90 | 1 |
30980 | 30980 | 2020-04-04 | Hinsdale | Colorado | 8053 | 1 | 0 |
30981 | 30981 | 2020-04-04 | Huerfano | Colorado | 8055 | 1 | 0 |
30982 | 30982 | 2020-04-04 | Jefferson | Colorado | 8059 | 483 | 15 |
30983 | 30983 | 2020-04-04 | Kit Carson | Colorado | 8063 | 5 | 0 |
30984 | 30984 | 2020-04-04 | La Plata | Colorado | 8067 | 25 | 0 |
30985 | 30985 | 2020-04-04 | Lake | Colorado | 8065 | 3 | 0 |
30986 | 30986 | 2020-04-04 | Larimer | Colorado | 8069 | 144 | 8 |
30987 | 30987 | 2020-04-04 | Las Animas | Colorado | 8071 | 1 | 0 |
30988 | 30988 | 2020-04-04 | Lincoln | Colorado | 8073 | 1 | 0 |
30989 | 30989 | 2020-04-04 | Logan | Colorado | 8075 | 8 | 0 |
30990 | 30990 | 2020-04-04 | Mesa | Colorado | 8077 | 20 | 0 |
30991 | 30991 | 2020-04-04 | Mineral | Colorado | 8079 | 2 | 0 |
30992 | 30992 | 2020-04-04 | Moffat | Colorado | 8081 | 4 | 0 |
30993 | 30993 | 2020-04-04 | Montezuma | Colorado | 8083 | 6 | 1 |
30994 | 30994 | 2020-04-04 | Montrose | Colorado | 8085 | 31 | 1 |
30995 | 30995 | 2020-04-04 | Morgan | Colorado | 8087 | 16 | 0 |
30996 | 30996 | 2020-04-04 | Otero | Colorado | 8089 | 3 | 0 |
30997 | 30997 | 2020-04-04 | Ouray | Colorado | 8091 | 2 | 0 |
30998 | 30998 | 2020-04-04 | Park | Colorado | 8093 | 5 | 0 |
30999 | 30999 | 2020-04-04 | Phillips | Colorado | 8095 | 3 | 0 |
31000 | 31000 | 2020-04-04 | Pitkin | Colorado | 8097 | 38 | 2 |
31001 | 31001 | 2020-04-04 | Pueblo | Colorado | 8101 | 39 | 2 |
31002 | 31002 | 2020-04-04 | Rio Blanco | Colorado | 8103 | 1 | 0 |
31003 | 31003 | 2020-04-04 | Rio Grande | Colorado | 8105 | 5 | 0 |
31004 | 31004 | 2020-04-04 | Routt | Colorado | 8107 | 29 | 0 |
31005 | 31005 | 2020-04-04 | Saguache | Colorado | 8109 | 3 | 0 |
31006 | 31006 | 2020-04-04 | San Miguel | Colorado | 8113 | 9 | 0 |
31007 | 31007 | 2020-04-04 | Summit | Colorado | 8117 | 43 | 0 |
31008 | 31008 | 2020-04-04 | Teller | Colorado | 8119 | 11 | 1 |
31009 | 31009 | 2020-04-04 | Unknown | Colorado | 211 | 0 | |
31010 | 31010 | 2020-04-04 | Washington | Colorado | 8121 | 1 | 0 |
31011 | 31011 | 2020-04-04 | Weld | Colorado | 8123 | 424 | 22 |
31012 | 31012 | 2020-04-04 | Yuma | Colorado | 8125 | 2 | 0 |
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);