ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-09-12" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
524959 | 524959 | 2020-09-12 | Adams | Colorado | 8001 | 8063 | 211 |
524960 | 524960 | 2020-09-12 | Alamosa | Colorado | 8003 | 240 | 9 |
524961 | 524961 | 2020-09-12 | Arapahoe | Colorado | 8005 | 8624 | 370 |
524962 | 524962 | 2020-09-12 | Archuleta | Colorado | 8007 | 48 | 0 |
524963 | 524963 | 2020-09-12 | Baca | Colorado | 8009 | 17 | 0 |
524964 | 524964 | 2020-09-12 | Bent | Colorado | 8011 | 11 | 0 |
524965 | 524965 | 2020-09-12 | Boulder | Colorado | 8013 | 2759 | 79 |
524966 | 524966 | 2020-09-12 | Broomfield | Colorado | 8014 | 564 | 33 |
524967 | 524967 | 2020-09-12 | Chaffee | Colorado | 8015 | 318 | 19 |
524968 | 524968 | 2020-09-12 | Cheyenne | Colorado | 8017 | 9 | 0 |
524969 | 524969 | 2020-09-12 | Clear Creek | Colorado | 8019 | 36 | 1 |
524970 | 524970 | 2020-09-12 | Conejos | Colorado | 8021 | 31 | 0 |
524971 | 524971 | 2020-09-12 | Costilla | Colorado | 8023 | 32 | 1 |
524972 | 524972 | 2020-09-12 | Crowley | Colorado | 8025 | 73 | 1 |
524973 | 524973 | 2020-09-12 | Custer | Colorado | 8027 | 17 | 0 |
524974 | 524974 | 2020-09-12 | Delta | Colorado | 8029 | 174 | 2 |
524975 | 524975 | 2020-09-12 | Denver | Colorado | 8031 | 11760 | 434 |
524976 | 524976 | 2020-09-12 | Dolores | Colorado | 8033 | 3 | 0 |
524977 | 524977 | 2020-09-12 | Douglas | Colorado | 8035 | 2299 | 60 |
524978 | 524978 | 2020-09-12 | Eagle | Colorado | 8037 | 1207 | 9 |
524979 | 524979 | 2020-09-12 | El Paso | Colorado | 8041 | 6368 | 160 |
524980 | 524980 | 2020-09-12 | Elbert | Colorado | 8039 | 136 | 2 |
524981 | 524981 | 2020-09-12 | Fremont | Colorado | 8043 | 166 | 1 |
524982 | 524982 | 2020-09-12 | Garfield | Colorado | 8045 | 891 | 5 |
524983 | 524983 | 2020-09-12 | Gilpin | Colorado | 8047 | 18 | 0 |
524984 | 524984 | 2020-09-12 | Grand | Colorado | 8049 | 69 | 1 |
524985 | 524985 | 2020-09-12 | Gunnison | Colorado | 8051 | 296 | 7 |
524986 | 524986 | 2020-09-12 | Hinsdale | Colorado | 8053 | 3 | 0 |
524987 | 524987 | 2020-09-12 | Huerfano | Colorado | 8055 | 10 | 1 |
524988 | 524988 | 2020-09-12 | Jackson | Colorado | 8057 | 9 | 0 |
524989 | 524989 | 2020-09-12 | Jefferson | Colorado | 8059 | 5086 | 245 |
524990 | 524990 | 2020-09-12 | Kit Carson | Colorado | 8063 | 78 | 3 |
524991 | 524991 | 2020-09-12 | La Plata | Colorado | 8067 | 248 | 2 |
524992 | 524992 | 2020-09-12 | Lake | Colorado | 8065 | 86 | 0 |
524993 | 524993 | 2020-09-12 | Larimer | Colorado | 8069 | 2168 | 46 |
524994 | 524994 | 2020-09-12 | Las Animas | Colorado | 8071 | 21 | 0 |
524995 | 524995 | 2020-09-12 | Lincoln | Colorado | 8073 | 8 | 0 |
524996 | 524996 | 2020-09-12 | Logan | Colorado | 8075 | 743 | 5 |
524997 | 524997 | 2020-09-12 | Mesa | Colorado | 8077 | 488 | 6 |
524998 | 524998 | 2020-09-12 | Mineral | Colorado | 8079 | 20 | 0 |
524999 | 524999 | 2020-09-12 | Moffat | Colorado | 8081 | 35 | 1 |
525000 | 525000 | 2020-09-12 | Montezuma | Colorado | 8083 | 127 | 5 |
525001 | 525001 | 2020-09-12 | Montrose | Colorado | 8085 | 353 | 13 |
525002 | 525002 | 2020-09-12 | Morgan | Colorado | 8087 | 727 | 48 |
525003 | 525003 | 2020-09-12 | Otero | Colorado | 8089 | 83 | 6 |
525004 | 525004 | 2020-09-12 | Ouray | Colorado | 8091 | 25 | 1 |
525005 | 525005 | 2020-09-12 | Park | Colorado | 8093 | 46 | 1 |
525006 | 525006 | 2020-09-12 | Phillips | Colorado | 8095 | 30 | 0 |
525007 | 525007 | 2020-09-12 | Pitkin | Colorado | 8097 | 204 | 2 |
525008 | 525008 | 2020-09-12 | Prowers | Colorado | 8099 | 90 | 0 |
525009 | 525009 | 2020-09-12 | Pueblo | Colorado | 8101 | 969 | 34 |
525010 | 525010 | 2020-09-12 | Rio Blanco | Colorado | 8103 | 24 | 0 |
525011 | 525011 | 2020-09-12 | Rio Grande | Colorado | 8105 | 95 | 2 |
525012 | 525012 | 2020-09-12 | Routt | Colorado | 8107 | 138 | 8 |
525013 | 525013 | 2020-09-12 | Saguache | Colorado | 8109 | 111 | 2 |
525014 | 525014 | 2020-09-12 | San Juan | Colorado | 8111 | 6 | 0 |
525015 | 525015 | 2020-09-12 | San Miguel | Colorado | 8113 | 93 | 0 |
525016 | 525016 | 2020-09-12 | Sedgwick | Colorado | 8115 | 12 | 1 |
525017 | 525017 | 2020-09-12 | Summit | Colorado | 8117 | 370 | 4 |
525018 | 525018 | 2020-09-12 | Teller | Colorado | 8119 | 166 | 4 |
525019 | 525019 | 2020-09-12 | Washington | Colorado | 8121 | 55 | 0 |
525020 | 525020 | 2020-09-12 | Weld | Colorado | 8123 | 4285 | 149 |
525021 | 525021 | 2020-09-12 | Yuma | Colorado | 8125 | 70 | 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);