ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-06-14 and state = "Idaho" 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 |
---|---|---|---|---|---|---|---|
237573 | 237573 | 2020-06-14 | Ada | Idaho | 16001 | 892 | 22 |
237574 | 237574 | 2020-06-14 | Adams | Idaho | 16003 | 4 | 0 |
237575 | 237575 | 2020-06-14 | Bannock | Idaho | 16005 | 67 | 1 |
237576 | 237576 | 2020-06-14 | Benewah | Idaho | 16009 | 19 | 0 |
237577 | 237577 | 2020-06-14 | Bingham | Idaho | 16011 | 26 | 0 |
237578 | 237578 | 2020-06-14 | Blaine | Idaho | 16013 | 515 | 5 |
237579 | 237579 | 2020-06-14 | Bonner | Idaho | 16017 | 7 | 0 |
237580 | 237580 | 2020-06-14 | Bonneville | Idaho | 16019 | 79 | 1 |
237581 | 237581 | 2020-06-14 | Camas | Idaho | 16025 | 1 | 0 |
237582 | 237582 | 2020-06-14 | Canyon | Idaho | 16027 | 356 | 6 |
237583 | 237583 | 2020-06-14 | Caribou | Idaho | 16029 | 6 | 0 |
237584 | 237584 | 2020-06-14 | Cassia | Idaho | 16031 | 136 | 1 |
237585 | 237585 | 2020-06-14 | Custer | Idaho | 16037 | 2 | 0 |
237586 | 237586 | 2020-06-14 | Elmore | Idaho | 16039 | 34 | 2 |
237587 | 237587 | 2020-06-14 | Franklin | Idaho | 16041 | 18 | 0 |
237588 | 237588 | 2020-06-14 | Fremont | Idaho | 16043 | 4 | 0 |
237589 | 237589 | 2020-06-14 | Gem | Idaho | 16045 | 17 | 0 |
237590 | 237590 | 2020-06-14 | Gooding | Idaho | 16047 | 59 | 0 |
237591 | 237591 | 2020-06-14 | Idaho | Idaho | 16049 | 3 | 0 |
237592 | 237592 | 2020-06-14 | Jefferson | Idaho | 16051 | 12 | 0 |
237593 | 237593 | 2020-06-14 | Jerome | Idaho | 16053 | 206 | 3 |
237594 | 237594 | 2020-06-14 | Kootenai | Idaho | 16055 | 98 | 0 |
237595 | 237595 | 2020-06-14 | Latah | Idaho | 16057 | 7 | 0 |
237596 | 237596 | 2020-06-14 | Lemhi | Idaho | 16059 | 1 | 0 |
237597 | 237597 | 2020-06-14 | Lincoln | Idaho | 16063 | 35 | 0 |
237598 | 237598 | 2020-06-14 | Madison | Idaho | 16065 | 30 | 0 |
237599 | 237599 | 2020-06-14 | Minidoka | Idaho | 16067 | 101 | 0 |
237600 | 237600 | 2020-06-14 | Nez Perce | Idaho | 16069 | 84 | 19 |
237601 | 237601 | 2020-06-14 | Owyhee | Idaho | 16073 | 8 | 0 |
237602 | 237602 | 2020-06-14 | Payette | Idaho | 16075 | 27 | 2 |
237603 | 237603 | 2020-06-14 | Power | Idaho | 16077 | 10 | 0 |
237604 | 237604 | 2020-06-14 | Teton | Idaho | 16081 | 11 | 0 |
237605 | 237605 | 2020-06-14 | Twin Falls | Idaho | 16083 | 480 | 26 |
237606 | 237606 | 2020-06-14 | Valley | Idaho | 16085 | 3 | 0 |
237607 | 237607 | 2020-06-14 | Washington | Idaho | 16087 | 55 | 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);