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-23 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 |
---|---|---|---|---|---|---|---|
265633 | 265633 | 2020-06-23 | Ada | Idaho | 16001 | 1383 | 22 |
265634 | 265634 | 2020-06-23 | Adams | Idaho | 16003 | 10 | 0 |
265635 | 265635 | 2020-06-23 | Bannock | Idaho | 16005 | 91 | 1 |
265636 | 265636 | 2020-06-23 | Benewah | Idaho | 16009 | 21 | 0 |
265637 | 265637 | 2020-06-23 | Bingham | Idaho | 16011 | 32 | 0 |
265638 | 265638 | 2020-06-23 | Blaine | Idaho | 16013 | 523 | 5 |
265639 | 265639 | 2020-06-23 | Bonner | Idaho | 16017 | 15 | 0 |
265640 | 265640 | 2020-06-23 | Bonneville | Idaho | 16019 | 96 | 1 |
265641 | 265641 | 2020-06-23 | Camas | Idaho | 16025 | 1 | 0 |
265642 | 265642 | 2020-06-23 | Canyon | Idaho | 16027 | 494 | 6 |
265643 | 265643 | 2020-06-23 | Caribou | Idaho | 16029 | 11 | 0 |
265644 | 265644 | 2020-06-23 | Cassia | Idaho | 16031 | 178 | 1 |
265645 | 265645 | 2020-06-23 | Custer | Idaho | 16037 | 2 | 0 |
265646 | 265646 | 2020-06-23 | Elmore | Idaho | 16039 | 43 | 2 |
265647 | 265647 | 2020-06-23 | Franklin | Idaho | 16041 | 21 | 0 |
265648 | 265648 | 2020-06-23 | Fremont | Idaho | 16043 | 4 | 0 |
265649 | 265649 | 2020-06-23 | Gem | Idaho | 16045 | 19 | 0 |
265650 | 265650 | 2020-06-23 | Gooding | Idaho | 16047 | 61 | 1 |
265651 | 265651 | 2020-06-23 | Idaho | Idaho | 16049 | 3 | 0 |
265652 | 265652 | 2020-06-23 | Jefferson | Idaho | 16051 | 16 | 0 |
265653 | 265653 | 2020-06-23 | Jerome | Idaho | 16053 | 227 | 3 |
265654 | 265654 | 2020-06-23 | Kootenai | Idaho | 16055 | 134 | 1 |
265655 | 265655 | 2020-06-23 | Latah | Idaho | 16057 | 9 | 0 |
265656 | 265656 | 2020-06-23 | Lemhi | Idaho | 16059 | 2 | 0 |
265657 | 265657 | 2020-06-23 | Lincoln | Idaho | 16063 | 36 | 0 |
265658 | 265658 | 2020-06-23 | Madison | Idaho | 16065 | 31 | 0 |
265659 | 265659 | 2020-06-23 | Minidoka | Idaho | 16067 | 130 | 0 |
265660 | 265660 | 2020-06-23 | Nez Perce | Idaho | 16069 | 90 | 19 |
265661 | 265661 | 2020-06-23 | Owyhee | Idaho | 16073 | 30 | 0 |
265662 | 265662 | 2020-06-23 | Payette | Idaho | 16075 | 48 | 2 |
265663 | 265663 | 2020-06-23 | Power | Idaho | 16077 | 16 | 0 |
265664 | 265664 | 2020-06-23 | Teton | Idaho | 16081 | 14 | 0 |
265665 | 265665 | 2020-06-23 | Twin Falls | Idaho | 16083 | 522 | 26 |
265666 | 265666 | 2020-06-23 | Valley | Idaho | 16085 | 3 | 0 |
265667 | 265667 | 2020-06-23 | Washington | Idaho | 16087 | 96 | 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);