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-11-07 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1891904 | 1891904 | 2021-11-07 | Ada | Idaho | 16001 | 82677 | 792 |
1891905 | 1891905 | 2021-11-07 | Adams | Idaho | 16003 | 533 | 12 |
1891906 | 1891906 | 2021-11-07 | Bannock | Idaho | 16005 | 13677 | 190 |
1891907 | 1891907 | 2021-11-07 | Bear Lake | Idaho | 16007 | 716 | 13 |
1891908 | 1891908 | 2021-11-07 | Benewah | Idaho | 16009 | 1249 | 26 |
1891909 | 1891909 | 2021-11-07 | Bingham | Idaho | 16011 | 6950 | 124 |
1891910 | 1891910 | 2021-11-07 | Blaine | Idaho | 16013 | 3082 | 27 |
1891911 | 1891911 | 2021-11-07 | Boise | Idaho | 16015 | 791 | 10 |
1891912 | 1891912 | 2021-11-07 | Bonner | Idaho | 16017 | 5897 | 103 |
1891913 | 1891913 | 2021-11-07 | Bonneville | Idaho | 16019 | 20464 | 215 |
1891914 | 1891914 | 2021-11-07 | Boundary | Idaho | 16021 | 1596 | 33 |
1891915 | 1891915 | 2021-11-07 | Butte | Idaho | 16023 | 366 | 4 |
1891916 | 1891916 | 2021-11-07 | Camas | Idaho | 16025 | 107 | 1 |
1891917 | 1891917 | 2021-11-07 | Canyon | Idaho | 16027 | 42499 | 531 |
1891918 | 1891918 | 2021-11-07 | Caribou | Idaho | 16029 | 1018 | 19 |
1891919 | 1891919 | 2021-11-07 | Cassia | Idaho | 16031 | 3914 | 38 |
1891920 | 1891920 | 2021-11-07 | Clark | Idaho | 16033 | 85 | 0 |
1891921 | 1891921 | 2021-11-07 | Clearwater | Idaho | 16035 | 1626 | 26 |
1891922 | 1891922 | 2021-11-07 | Custer | Idaho | 16037 | 385 | 6 |
1891923 | 1891923 | 2021-11-07 | Elmore | Idaho | 16039 | 4212 | 47 |
1891924 | 1891924 | 2021-11-07 | Franklin | Idaho | 16041 | 1657 | 23 |
1891925 | 1891925 | 2021-11-07 | Fremont | Idaho | 16043 | 1542 | 16 |
1891926 | 1891926 | 2021-11-07 | Gem | Idaho | 16045 | 2830 | 62 |
1891927 | 1891927 | 2021-11-07 | Gooding | Idaho | 16047 | 2302 | 41 |
1891928 | 1891928 | 2021-11-07 | Idaho | Idaho | 16049 | 2189 | 36 |
1891929 | 1891929 | 2021-11-07 | Jefferson | Idaho | 16051 | 4207 | 45 |
1891930 | 1891930 | 2021-11-07 | Jerome | Idaho | 16053 | 4296 | 52 |
1891931 | 1891931 | 2021-11-07 | Kootenai | Idaho | 16055 | 29690 | 408 |
1891932 | 1891932 | 2021-11-07 | Latah | Idaho | 16057 | 4597 | 37 |
1891933 | 1891933 | 2021-11-07 | Lemhi | Idaho | 16059 | 865 | 19 |
1891934 | 1891934 | 2021-11-07 | Lewis | Idaho | 16061 | 787 | 21 |
1891935 | 1891935 | 2021-11-07 | Lincoln | Idaho | 16063 | 697 | 12 |
1891936 | 1891936 | 2021-11-07 | Madison | Idaho | 16065 | 8772 | 39 |
1891937 | 1891937 | 2021-11-07 | Minidoka | Idaho | 16067 | 3196 | 48 |
1891938 | 1891938 | 2021-11-07 | Nez Perce | Idaho | 16069 | 6204 | 99 |
1891939 | 1891939 | 2021-11-07 | Oneida | Idaho | 16071 | 558 | 9 |
1891940 | 1891940 | 2021-11-07 | Owyhee | Idaho | 16073 | 1663 | 39 |
1891941 | 1891941 | 2021-11-07 | Payette | Idaho | 16075 | 4178 | 65 |
1891942 | 1891942 | 2021-11-07 | Power | Idaho | 16077 | 1083 | 15 |
1891943 | 1891943 | 2021-11-07 | Shoshone | Idaho | 16079 | 2024 | 61 |
1891944 | 1891944 | 2021-11-07 | Teton | Idaho | 16081 | 1669 | 5 |
1891945 | 1891945 | 2021-11-07 | Twin Falls | Idaho | 16083 | 16097 | 219 |
1891946 | 1891946 | 2021-11-07 | Valley | Idaho | 16085 | 1509 | 12 |
1891947 | 1891947 | 2021-11-07 | Washington | Idaho | 16087 | 1892 | 47 |
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);