ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where "date" is on date 2020-08-08 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
412232 | 412232 | 2020-08-08 | Ada | Idaho | 16001 | 8932 | 81 |
412233 | 412233 | 2020-08-08 | Adams | Idaho | 16003 | 19 | 0 |
412234 | 412234 | 2020-08-08 | Bannock | Idaho | 16005 | 424 | 2 |
412235 | 412235 | 2020-08-08 | Bear Lake | Idaho | 16007 | 22 | 0 |
412236 | 412236 | 2020-08-08 | Benewah | Idaho | 16009 | 64 | 0 |
412237 | 412237 | 2020-08-08 | Bingham | Idaho | 16011 | 278 | 2 |
412238 | 412238 | 2020-08-08 | Blaine | Idaho | 16013 | 575 | 6 |
412239 | 412239 | 2020-08-08 | Boise | Idaho | 16015 | 48 | 1 |
412240 | 412240 | 2020-08-08 | Bonner | Idaho | 16017 | 183 | 0 |
412241 | 412241 | 2020-08-08 | Bonneville | Idaho | 16019 | 1011 | 4 |
412242 | 412242 | 2020-08-08 | Boundary | Idaho | 16021 | 37 | 0 |
412243 | 412243 | 2020-08-08 | Camas | Idaho | 16025 | 1 | 0 |
412244 | 412244 | 2020-08-08 | Canyon | Idaho | 16027 | 5726 | 48 |
412245 | 412245 | 2020-08-08 | Caribou | Idaho | 16029 | 31 | 0 |
412246 | 412246 | 2020-08-08 | Cassia | Idaho | 16031 | 519 | 1 |
412247 | 412247 | 2020-08-08 | Clark | Idaho | 16033 | 9 | 0 |
412248 | 412248 | 2020-08-08 | Clearwater | Idaho | 16035 | 16 | 0 |
412249 | 412249 | 2020-08-08 | Custer | Idaho | 16037 | 10 | 0 |
412250 | 412250 | 2020-08-08 | Elmore | Idaho | 16039 | 212 | 3 |
412251 | 412251 | 2020-08-08 | Franklin | Idaho | 16041 | 52 | 0 |
412252 | 412252 | 2020-08-08 | Fremont | Idaho | 16043 | 79 | 0 |
412253 | 412253 | 2020-08-08 | Gem | Idaho | 16045 | 179 | 1 |
412254 | 412254 | 2020-08-08 | Gooding | Idaho | 16047 | 162 | 0 |
412255 | 412255 | 2020-08-08 | Idaho | Idaho | 16049 | 31 | 0 |
412256 | 412256 | 2020-08-08 | Jefferson | Idaho | 16051 | 190 | 1 |
412257 | 412257 | 2020-08-08 | Jerome | Idaho | 16053 | 471 | 6 |
412258 | 412258 | 2020-08-08 | Kootenai | Idaho | 16055 | 1790 | 16 |
412259 | 412259 | 2020-08-08 | Latah | Idaho | 16057 | 101 | 0 |
412260 | 412260 | 2020-08-08 | Lemhi | Idaho | 16059 | 23 | 0 |
412261 | 412261 | 2020-08-08 | Lincoln | Idaho | 16063 | 57 | 0 |
412262 | 412262 | 2020-08-08 | Madison | Idaho | 16065 | 162 | 0 |
412263 | 412263 | 2020-08-08 | Minidoka | Idaho | 16067 | 475 | 2 |
412264 | 412264 | 2020-08-08 | Nez Perce | Idaho | 16069 | 158 | 19 |
412265 | 412265 | 2020-08-08 | Oneida | Idaho | 16071 | 13 | 0 |
412266 | 412266 | 2020-08-08 | Owyhee | Idaho | 16073 | 262 | 2 |
412267 | 412267 | 2020-08-08 | Payette | Idaho | 16075 | 384 | 2 |
412268 | 412268 | 2020-08-08 | Power | Idaho | 16077 | 59 | 0 |
412269 | 412269 | 2020-08-08 | Shoshone | Idaho | 16079 | 96 | 2 |
412270 | 412270 | 2020-08-08 | Teton | Idaho | 16081 | 86 | 0 |
412271 | 412271 | 2020-08-08 | Twin Falls | Idaho | 16083 | 1384 | 33 |
412272 | 412272 | 2020-08-08 | Valley | Idaho | 16085 | 59 | 1 |
412273 | 412273 | 2020-08-08 | Washington | Idaho | 16087 | 203 | 3 |
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);