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 2021-01-08 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908014 | 908014 | 2021-01-08 | Ada | Idaho | 16001 | 40370 | 368 |
908015 | 908015 | 2021-01-08 | Adams | Idaho | 16003 | 284 | 3 |
908016 | 908016 | 2021-01-08 | Bannock | Idaho | 16005 | 6748 | 69 |
908017 | 908017 | 2021-01-08 | Bear Lake | Idaho | 16007 | 291 | 2 |
908018 | 908018 | 2021-01-08 | Benewah | Idaho | 16009 | 482 | 5 |
908019 | 908019 | 2021-01-08 | Bingham | Idaho | 16011 | 3825 | 53 |
908020 | 908020 | 2021-01-08 | Blaine | Idaho | 16013 | 1606 | 13 |
908021 | 908021 | 2021-01-08 | Boise | Idaho | 16015 | 254 | 2 |
908022 | 908022 | 2021-01-08 | Bonner | Idaho | 16017 | 2163 | 18 |
908023 | 908023 | 2021-01-08 | Bonneville | Idaho | 16019 | 10737 | 118 |
908024 | 908024 | 2021-01-08 | Boundary | Idaho | 16021 | 613 | 10 |
908025 | 908025 | 2021-01-08 | Butte | Idaho | 16023 | 172 | 1 |
908026 | 908026 | 2021-01-08 | Camas | Idaho | 16025 | 57 | 0 |
908027 | 908027 | 2021-01-08 | Canyon | Idaho | 16027 | 21644 | 232 |
908028 | 908028 | 2021-01-08 | Caribou | Idaho | 16029 | 555 | 10 |
908029 | 908029 | 2021-01-08 | Cassia | Idaho | 16031 | 2643 | 22 |
908030 | 908030 | 2021-01-08 | Clark | Idaho | 16033 | 53 | 0 |
908031 | 908031 | 2021-01-08 | Clearwater | Idaho | 16035 | 848 | 8 |
908032 | 908032 | 2021-01-08 | Custer | Idaho | 16037 | 213 | 2 |
908033 | 908033 | 2021-01-08 | Elmore | Idaho | 16039 | 1412 | 10 |
908034 | 908034 | 2021-01-08 | Franklin | Idaho | 16041 | 979 | 11 |
908035 | 908035 | 2021-01-08 | Fremont | Idaho | 16043 | 892 | 14 |
908036 | 908036 | 2021-01-08 | Gem | Idaho | 16045 | 1493 | 22 |
908037 | 908037 | 2021-01-08 | Gooding | Idaho | 16047 | 1180 | 19 |
908038 | 908038 | 2021-01-08 | Idaho | Idaho | 16049 | 1108 | 15 |
908039 | 908039 | 2021-01-08 | Jefferson | Idaho | 16051 | 2137 | 15 |
908040 | 908040 | 2021-01-08 | Jerome | Idaho | 16053 | 2312 | 16 |
908041 | 908041 | 2021-01-08 | Kootenai | Idaho | 16055 | 13825 | 131 |
908042 | 908042 | 2021-01-08 | Latah | Idaho | 16057 | 2263 | 6 |
908043 | 908043 | 2021-01-08 | Lemhi | Idaho | 16059 | 469 | 9 |
908044 | 908044 | 2021-01-08 | Lewis | Idaho | 16061 | 353 | 5 |
908045 | 908045 | 2021-01-08 | Lincoln | Idaho | 16063 | 450 | 9 |
908046 | 908046 | 2021-01-08 | Madison | Idaho | 16065 | 5425 | 21 |
908047 | 908047 | 2021-01-08 | Minidoka | Idaho | 16067 | 2118 | 23 |
908048 | 908048 | 2021-01-08 | Nez Perce | Idaho | 16069 | 3123 | 45 |
908049 | 908049 | 2021-01-08 | Oneida | Idaho | 16071 | 268 | 2 |
908050 | 908050 | 2021-01-08 | Owyhee | Idaho | 16073 | 920 | 20 |
908051 | 908051 | 2021-01-08 | Payette | Idaho | 16075 | 2146 | 25 |
908052 | 908052 | 2021-01-08 | Power | Idaho | 16077 | 563 | 5 |
908053 | 908053 | 2021-01-08 | Shoshone | Idaho | 16079 | 883 | 29 |
908054 | 908054 | 2021-01-08 | Teton | Idaho | 16081 | 810 | 3 |
908055 | 908055 | 2021-01-08 | Twin Falls | Idaho | 16083 | 8282 | 115 |
908056 | 908056 | 2021-01-08 | Valley | Idaho | 16085 | 564 | 4 |
908057 | 908057 | 2021-01-08 | Washington | Idaho | 16087 | 1045 | 16 |
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);