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-08-19 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
447697 | 447697 | 2020-08-19 | Ada | Idaho | 16001 | 10228 | 102 |
447698 | 447698 | 2020-08-19 | Adams | Idaho | 16003 | 23 | 0 |
447699 | 447699 | 2020-08-19 | Bannock | Idaho | 16005 | 573 | 2 |
447700 | 447700 | 2020-08-19 | Bear Lake | Idaho | 16007 | 31 | 0 |
447701 | 447701 | 2020-08-19 | Benewah | Idaho | 16009 | 90 | 1 |
447702 | 447702 | 2020-08-19 | Bingham | Idaho | 16011 | 394 | 4 |
447703 | 447703 | 2020-08-19 | Blaine | Idaho | 16013 | 592 | 6 |
447704 | 447704 | 2020-08-19 | Boise | Idaho | 16015 | 56 | 1 |
447705 | 447705 | 2020-08-19 | Bonner | Idaho | 16017 | 192 | 0 |
447706 | 447706 | 2020-08-19 | Bonneville | Idaho | 16019 | 1434 | 6 |
447707 | 447707 | 2020-08-19 | Boundary | Idaho | 16021 | 42 | 0 |
447708 | 447708 | 2020-08-19 | Butte | Idaho | 16023 | 4 | 0 |
447709 | 447709 | 2020-08-19 | Camas | Idaho | 16025 | 2 | 0 |
447710 | 447710 | 2020-08-19 | Canyon | Idaho | 16027 | 6589 | 61 |
447711 | 447711 | 2020-08-19 | Caribou | Idaho | 16029 | 34 | 0 |
447712 | 447712 | 2020-08-19 | Cassia | Idaho | 16031 | 565 | 1 |
447713 | 447713 | 2020-08-19 | Clark | Idaho | 16033 | 16 | 0 |
447714 | 447714 | 2020-08-19 | Clearwater | Idaho | 16035 | 18 | 0 |
447715 | 447715 | 2020-08-19 | Custer | Idaho | 16037 | 16 | 0 |
447716 | 447716 | 2020-08-19 | Elmore | Idaho | 16039 | 245 | 3 |
447717 | 447717 | 2020-08-19 | Franklin | Idaho | 16041 | 56 | 0 |
447718 | 447718 | 2020-08-19 | Fremont | Idaho | 16043 | 98 | 1 |
447719 | 447719 | 2020-08-19 | Gem | Idaho | 16045 | 198 | 1 |
447720 | 447720 | 2020-08-19 | Gooding | Idaho | 16047 | 189 | 0 |
447721 | 447721 | 2020-08-19 | Idaho | Idaho | 16049 | 38 | 0 |
447722 | 447722 | 2020-08-19 | Jefferson | Idaho | 16051 | 281 | 1 |
447723 | 447723 | 2020-08-19 | Jerome | Idaho | 16053 | 541 | 6 |
447724 | 447724 | 2020-08-19 | Kootenai | Idaho | 16055 | 2033 | 22 |
447725 | 447725 | 2020-08-19 | Latah | Idaho | 16057 | 157 | 0 |
447726 | 447726 | 2020-08-19 | Lemhi | Idaho | 16059 | 62 | 0 |
447727 | 447727 | 2020-08-19 | Lewis | Idaho | 16061 | 6 | 0 |
447728 | 447728 | 2020-08-19 | Lincoln | Idaho | 16063 | 63 | 0 |
447729 | 447729 | 2020-08-19 | Madison | Idaho | 16065 | 204 | 0 |
447730 | 447730 | 2020-08-19 | Minidoka | Idaho | 16067 | 518 | 2 |
447731 | 447731 | 2020-08-19 | Nez Perce | Idaho | 16069 | 201 | 19 |
447732 | 447732 | 2020-08-19 | Oneida | Idaho | 16071 | 18 | 0 |
447733 | 447733 | 2020-08-19 | Owyhee | Idaho | 16073 | 283 | 4 |
447734 | 447734 | 2020-08-19 | Payette | Idaho | 16075 | 495 | 4 |
447735 | 447735 | 2020-08-19 | Power | Idaho | 16077 | 84 | 0 |
447736 | 447736 | 2020-08-19 | Shoshone | Idaho | 16079 | 176 | 7 |
447737 | 447737 | 2020-08-19 | Teton | Idaho | 16081 | 111 | 0 |
447738 | 447738 | 2020-08-19 | Twin Falls | Idaho | 16083 | 1550 | 34 |
447739 | 447739 | 2020-08-19 | Valley | Idaho | 16085 | 77 | 1 |
447740 | 447740 | 2020-08-19 | Washington | Idaho | 16087 | 246 | 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);