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 2022-02-26 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2252800 | 2252800 | 2022-02-26 | Ada | Idaho | 16001 | 125657 | 985 |
2252801 | 2252801 | 2022-02-26 | Adams | Idaho | 16003 | 684 | 14 |
2252802 | 2252802 | 2022-02-26 | Bannock | Idaho | 16005 | 20639 | 238 |
2252803 | 2252803 | 2022-02-26 | Bear Lake | Idaho | 16007 | 920 | 15 |
2252804 | 2252804 | 2022-02-26 | Benewah | Idaho | 16009 | 1990 | 40 |
2252805 | 2252805 | 2022-02-26 | Bingham | Idaho | 16011 | 9697 | 150 |
2252806 | 2252806 | 2022-02-26 | Blaine | Idaho | 16013 | 5378 | 30 |
2252807 | 2252807 | 2022-02-26 | Boise | Idaho | 16015 | 1029 | 13 |
2252808 | 2252808 | 2022-02-26 | Bonner | Idaho | 16017 | 8383 | 175 |
2252809 | 2252809 | 2022-02-26 | Bonneville | Idaho | 16019 | 30691 | 276 |
2252810 | 2252810 | 2022-02-26 | Boundary | Idaho | 16021 | 2013 | 57 |
2252811 | 2252811 | 2022-02-26 | Butte | Idaho | 16023 | 475 | 9 |
2252812 | 2252812 | 2022-02-26 | Camas | Idaho | 16025 | 139 | 2 |
2252813 | 2252813 | 2022-02-26 | Canyon | Idaho | 16027 | 60063 | 665 |
2252814 | 2252814 | 2022-02-26 | Caribou | Idaho | 16029 | 1479 | 26 |
2252815 | 2252815 | 2022-02-26 | Cassia | Idaho | 16031 | 4702 | 52 |
2252816 | 2252816 | 2022-02-26 | Clark | Idaho | 16033 | 108 | 0 |
2252817 | 2252817 | 2022-02-26 | Clearwater | Idaho | 16035 | 2189 | 31 |
2252818 | 2252818 | 2022-02-26 | Custer | Idaho | 16037 | 521 | 8 |
2252819 | 2252819 | 2022-02-26 | Elmore | Idaho | 16039 | 6660 | 64 |
2252820 | 2252820 | 2022-02-26 | Franklin | Idaho | 16041 | 2329 | 29 |
2252821 | 2252821 | 2022-02-26 | Fremont | Idaho | 16043 | 2145 | 25 |
2252822 | 2252822 | 2022-02-26 | Gem | Idaho | 16045 | 3597 | 77 |
2252823 | 2252823 | 2022-02-26 | Gooding | Idaho | 16047 | 2977 | 52 |
2252824 | 2252824 | 2022-02-26 | Idaho | Idaho | 16049 | 2920 | 48 |
2252825 | 2252825 | 2022-02-26 | Jefferson | Idaho | 16051 | 6019 | 62 |
2252826 | 2252826 | 2022-02-26 | Jerome | Idaho | 16053 | 5340 | 63 |
2252827 | 2252827 | 2022-02-26 | Kootenai | Idaho | 16055 | 38780 | 571 |
2252828 | 2252828 | 2022-02-26 | Latah | Idaho | 16057 | 6638 | 48 |
2252829 | 2252829 | 2022-02-26 | Lemhi | Idaho | 16059 | 1246 | 25 |
2252830 | 2252830 | 2022-02-26 | Lewis | Idaho | 16061 | 1124 | 26 |
2252831 | 2252831 | 2022-02-26 | Lincoln | Idaho | 16063 | 978 | 15 |
2252832 | 2252832 | 2022-02-26 | Madison | Idaho | 16065 | 12622 | 47 |
2252833 | 2252833 | 2022-02-26 | Minidoka | Idaho | 16067 | 3847 | 58 |
2252834 | 2252834 | 2022-02-26 | Nez Perce | Idaho | 16069 | 8858 | 138 |
2252835 | 2252835 | 2022-02-26 | Oneida | Idaho | 16071 | 794 | 11 |
2252836 | 2252836 | 2022-02-26 | Owyhee | Idaho | 16073 | 2219 | 49 |
2252837 | 2252837 | 2022-02-26 | Payette | Idaho | 16075 | 5443 | 83 |
2252838 | 2252838 | 2022-02-26 | Power | Idaho | 16077 | 1480 | 20 |
2252839 | 2252839 | 2022-02-26 | Shoshone | Idaho | 16079 | 2575 | 74 |
2252840 | 2252840 | 2022-02-26 | Teton | Idaho | 16081 | 2676 | 8 |
2252841 | 2252841 | 2022-02-26 | Twin Falls | Idaho | 16083 | 20915 | 281 |
2252842 | 2252842 | 2022-02-26 | Valley | Idaho | 16085 | 2470 | 16 |
2252843 | 2252843 | 2022-02-26 | Washington | Idaho | 16087 | 2322 | 56 |
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);