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-12-01 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
784690 | 784690 | 2020-12-01 | Ada | Idaho | 16001 | 26209 | 245 |
784691 | 784691 | 2020-12-01 | Adams | Idaho | 16003 | 113 | 2 |
784692 | 784692 | 2020-12-01 | Bannock | Idaho | 16005 | 4562 | 33 |
784693 | 784693 | 2020-12-01 | Bear Lake | Idaho | 16007 | 194 | 1 |
784694 | 784694 | 2020-12-01 | Benewah | Idaho | 16009 | 287 | 3 |
784695 | 784695 | 2020-12-01 | Bingham | Idaho | 16011 | 2835 | 29 |
784696 | 784696 | 2020-12-01 | Blaine | Idaho | 16013 | 1297 | 7 |
784697 | 784697 | 2020-12-01 | Boise | Idaho | 16015 | 146 | 2 |
784698 | 784698 | 2020-12-01 | Bonner | Idaho | 16017 | 1009 | 5 |
784699 | 784699 | 2020-12-01 | Bonneville | Idaho | 16019 | 7822 | 69 |
784700 | 784700 | 2020-12-01 | Boundary | Idaho | 16021 | 363 | 4 |
784701 | 784701 | 2020-12-01 | Butte | Idaho | 16023 | 125 | 0 |
784702 | 784702 | 2020-12-01 | Camas | Idaho | 16025 | 54 | 0 |
784703 | 784703 | 2020-12-01 | Canyon | Idaho | 16027 | 15754 | 142 |
784704 | 784704 | 2020-12-01 | Caribou | Idaho | 16029 | 446 | 10 |
784705 | 784705 | 2020-12-01 | Cassia | Idaho | 16031 | 2170 | 18 |
784706 | 784706 | 2020-12-01 | Clark | Idaho | 16033 | 49 | 0 |
784707 | 784707 | 2020-12-01 | Clearwater | Idaho | 16035 | 560 | 0 |
784708 | 784708 | 2020-12-01 | Custer | Idaho | 16037 | 150 | 1 |
784709 | 784709 | 2020-12-01 | Elmore | Idaho | 16039 | 931 | 7 |
784710 | 784710 | 2020-12-01 | Franklin | Idaho | 16041 | 723 | 6 |
784711 | 784711 | 2020-12-01 | Fremont | Idaho | 16043 | 732 | 10 |
784712 | 784712 | 2020-12-01 | Gem | Idaho | 16045 | 1012 | 5 |
784713 | 784713 | 2020-12-01 | Gooding | Idaho | 16047 | 961 | 9 |
784714 | 784714 | 2020-12-01 | Idaho | Idaho | 16049 | 797 | 9 |
784715 | 784715 | 2020-12-01 | Jefferson | Idaho | 16051 | 1584 | 11 |
784716 | 784716 | 2020-12-01 | Jerome | Idaho | 16053 | 1905 | 14 |
784717 | 784717 | 2020-12-01 | Kootenai | Idaho | 16055 | 7709 | 83 |
784718 | 784718 | 2020-12-01 | Latah | Idaho | 16057 | 1730 | 3 |
784719 | 784719 | 2020-12-01 | Lemhi | Idaho | 16059 | 433 | 8 |
784720 | 784720 | 2020-12-01 | Lewis | Idaho | 16061 | 210 | 4 |
784721 | 784721 | 2020-12-01 | Lincoln | Idaho | 16063 | 357 | 8 |
784722 | 784722 | 2020-12-01 | Madison | Idaho | 16065 | 4276 | 8 |
784723 | 784723 | 2020-12-01 | Minidoka | Idaho | 16067 | 1766 | 18 |
784724 | 784724 | 2020-12-01 | Nez Perce | Idaho | 16069 | 2342 | 36 |
784725 | 784725 | 2020-12-01 | Oneida | Idaho | 16071 | 147 | 0 |
784726 | 784726 | 2020-12-01 | Owyhee | Idaho | 16073 | 706 | 5 |
784727 | 784727 | 2020-12-01 | Payette | Idaho | 16075 | 1667 | 15 |
784728 | 784728 | 2020-12-01 | Power | Idaho | 16077 | 486 | 4 |
784729 | 784729 | 2020-12-01 | Shoshone | Idaho | 16079 | 526 | 22 |
784730 | 784730 | 2020-12-01 | Teton | Idaho | 16081 | 565 | 2 |
784731 | 784731 | 2020-12-01 | Twin Falls | Idaho | 16083 | 6891 | 95 |
784732 | 784732 | 2020-12-01 | Valley | Idaho | 16085 | 257 | 1 |
784733 | 784733 | 2020-12-01 | Washington | Idaho | 16087 | 784 | 12 |
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);