ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where "date" is on date 2020-05-26 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
179036 | 179036 | 2020-05-26 | Ada | Idaho | 16001 | 798 | 22 |
179037 | 179037 | 2020-05-26 | Adams | Idaho | 16003 | 3 | 0 |
179038 | 179038 | 2020-05-26 | Bannock | Idaho | 16005 | 20 | 0 |
179039 | 179039 | 2020-05-26 | Benewah | Idaho | 16009 | 3 | 0 |
179040 | 179040 | 2020-05-26 | Bingham | Idaho | 16011 | 6 | 0 |
179041 | 179041 | 2020-05-26 | Blaine | Idaho | 16013 | 510 | 5 |
179042 | 179042 | 2020-05-26 | Bonner | Idaho | 16017 | 4 | 0 |
179043 | 179043 | 2020-05-26 | Bonneville | Idaho | 16019 | 33 | 0 |
179044 | 179044 | 2020-05-26 | Camas | Idaho | 16025 | 1 | 0 |
179045 | 179045 | 2020-05-26 | Canyon | Idaho | 16027 | 287 | 6 |
179046 | 179046 | 2020-05-26 | Caribou | Idaho | 16029 | 1 | 0 |
179047 | 179047 | 2020-05-26 | Cassia | Idaho | 16031 | 49 | 1 |
179048 | 179048 | 2020-05-26 | Custer | Idaho | 16037 | 2 | 0 |
179049 | 179049 | 2020-05-26 | Elmore | Idaho | 16039 | 31 | 2 |
179050 | 179050 | 2020-05-26 | Fremont | Idaho | 16043 | 3 | 0 |
179051 | 179051 | 2020-05-26 | Gem | Idaho | 16045 | 17 | 0 |
179052 | 179052 | 2020-05-26 | Gooding | Idaho | 16047 | 40 | 0 |
179053 | 179053 | 2020-05-26 | Idaho | Idaho | 16049 | 3 | 0 |
179054 | 179054 | 2020-05-26 | Jefferson | Idaho | 16051 | 7 | 0 |
179055 | 179055 | 2020-05-26 | Jerome | Idaho | 16053 | 154 | 2 |
179056 | 179056 | 2020-05-26 | Kootenai | Idaho | 16055 | 66 | 0 |
179057 | 179057 | 2020-05-26 | Latah | Idaho | 16057 | 7 | 0 |
179058 | 179058 | 2020-05-26 | Lemhi | Idaho | 16059 | 1 | 0 |
179059 | 179059 | 2020-05-26 | Lincoln | Idaho | 16063 | 32 | 0 |
179060 | 179060 | 2020-05-26 | Madison | Idaho | 16065 | 21 | 0 |
179061 | 179061 | 2020-05-26 | Minidoka | Idaho | 16067 | 40 | 0 |
179062 | 179062 | 2020-05-26 | Nez Perce | Idaho | 16069 | 82 | 19 |
179063 | 179063 | 2020-05-26 | Owyhee | Idaho | 16073 | 9 | 0 |
179064 | 179064 | 2020-05-26 | Payette | Idaho | 16075 | 23 | 2 |
179065 | 179065 | 2020-05-26 | Power | Idaho | 16077 | 3 | 0 |
179066 | 179066 | 2020-05-26 | Teton | Idaho | 16081 | 11 | 0 |
179067 | 179067 | 2020-05-26 | Twin Falls | Idaho | 16083 | 396 | 22 |
179068 | 179068 | 2020-05-26 | Valley | Idaho | 16085 | 2 | 0 |
179069 | 179069 | 2020-05-26 | Washington | Idaho | 16087 | 34 | 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);