ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where "date" is on date 2020-09-22 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
557639 | 557639 | 2020-09-22 | Ada | Idaho | 16001 | 12471 | 147 |
557640 | 557640 | 2020-09-22 | Adams | Idaho | 16003 | 28 | 1 |
557641 | 557641 | 2020-09-22 | Bannock | Idaho | 16005 | 995 | 4 |
557642 | 557642 | 2020-09-22 | Bear Lake | Idaho | 16007 | 46 | 1 |
557643 | 557643 | 2020-09-22 | Benewah | Idaho | 16009 | 137 | 3 |
557644 | 557644 | 2020-09-22 | Bingham | Idaho | 16011 | 900 | 10 |
557645 | 557645 | 2020-09-22 | Blaine | Idaho | 16013 | 641 | 6 |
557646 | 557646 | 2020-09-22 | Boise | Idaho | 16015 | 67 | 1 |
557647 | 557647 | 2020-09-22 | Bonner | Idaho | 16017 | 302 | 0 |
557648 | 557648 | 2020-09-22 | Bonneville | Idaho | 16019 | 2534 | 16 |
557649 | 557649 | 2020-09-22 | Boundary | Idaho | 16021 | 56 | 1 |
557650 | 557650 | 2020-09-22 | Butte | Idaho | 16023 | 27 | 0 |
557651 | 557651 | 2020-09-22 | Camas | Idaho | 16025 | 21 | 0 |
557652 | 557652 | 2020-09-22 | Canyon | Idaho | 16027 | 7973 | 100 |
557653 | 557653 | 2020-09-22 | Caribou | Idaho | 16029 | 105 | 0 |
557654 | 557654 | 2020-09-22 | Cassia | Idaho | 16031 | 653 | 5 |
557655 | 557655 | 2020-09-22 | Clark | Idaho | 16033 | 32 | 0 |
557656 | 557656 | 2020-09-22 | Clearwater | Idaho | 16035 | 38 | 0 |
557657 | 557657 | 2020-09-22 | Custer | Idaho | 16037 | 59 | 1 |
557658 | 557658 | 2020-09-22 | Elmore | Idaho | 16039 | 331 | 3 |
557659 | 557659 | 2020-09-22 | Franklin | Idaho | 16041 | 118 | 0 |
557660 | 557660 | 2020-09-22 | Fremont | Idaho | 16043 | 176 | 3 |
557661 | 557661 | 2020-09-22 | Gem | Idaho | 16045 | 291 | 2 |
557662 | 557662 | 2020-09-22 | Gooding | Idaho | 16047 | 265 | 0 |
557663 | 557663 | 2020-09-22 | Idaho | Idaho | 16049 | 184 | 0 |
557664 | 557664 | 2020-09-22 | Jefferson | Idaho | 16051 | 505 | 1 |
557665 | 557665 | 2020-09-22 | Jerome | Idaho | 16053 | 733 | 7 |
557666 | 557666 | 2020-09-22 | Kootenai | Idaho | 16055 | 2517 | 35 |
557667 | 557667 | 2020-09-22 | Latah | Idaho | 16057 | 337 | 0 |
557668 | 557668 | 2020-09-22 | Lemhi | Idaho | 16059 | 84 | 0 |
557669 | 557669 | 2020-09-22 | Lewis | Idaho | 16061 | 14 | 0 |
557670 | 557670 | 2020-09-22 | Lincoln | Idaho | 16063 | 87 | 0 |
557671 | 557671 | 2020-09-22 | Madison | Idaho | 16065 | 575 | 1 |
557672 | 557672 | 2020-09-22 | Minidoka | Idaho | 16067 | 646 | 7 |
557673 | 557673 | 2020-09-22 | Nez Perce | Idaho | 16069 | 413 | 24 |
557674 | 557674 | 2020-09-22 | Oneida | Idaho | 16071 | 23 | 0 |
557675 | 557675 | 2020-09-22 | Owyhee | Idaho | 16073 | 324 | 5 |
557676 | 557676 | 2020-09-22 | Payette | Idaho | 16075 | 839 | 7 |
557677 | 557677 | 2020-09-22 | Power | Idaho | 16077 | 242 | 1 |
557678 | 557678 | 2020-09-22 | Shoshone | Idaho | 16079 | 214 | 18 |
557679 | 557679 | 2020-09-22 | Teton | Idaho | 16081 | 148 | 0 |
557680 | 557680 | 2020-09-22 | Twin Falls | Idaho | 16083 | 2096 | 36 |
557681 | 557681 | 2020-09-22 | Valley | Idaho | 16085 | 87 | 1 |
557682 | 557682 | 2020-09-22 | Washington | Idaho | 16087 | 342 | 5 |
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);