ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where "date" is on date 2020-08-11 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 |
---|---|---|---|---|---|---|---|
421895 | 421895 | 2020-08-11 | Ada | Idaho | 16001 | 9315 | 85 |
421896 | 421896 | 2020-08-11 | Adams | Idaho | 16003 | 20 | 0 |
421897 | 421897 | 2020-08-11 | Bannock | Idaho | 16005 | 462 | 2 |
421898 | 421898 | 2020-08-11 | Bear Lake | Idaho | 16007 | 23 | 0 |
421899 | 421899 | 2020-08-11 | Benewah | Idaho | 16009 | 72 | 1 |
421900 | 421900 | 2020-08-11 | Bingham | Idaho | 16011 | 312 | 2 |
421901 | 421901 | 2020-08-11 | Blaine | Idaho | 16013 | 578 | 6 |
421902 | 421902 | 2020-08-11 | Boise | Idaho | 16015 | 51 | 1 |
421903 | 421903 | 2020-08-11 | Bonner | Idaho | 16017 | 184 | 0 |
421904 | 421904 | 2020-08-11 | Bonneville | Idaho | 16019 | 1160 | 4 |
421905 | 421905 | 2020-08-11 | Boundary | Idaho | 16021 | 38 | 0 |
421906 | 421906 | 2020-08-11 | Butte | Idaho | 16023 | 1 | 0 |
421907 | 421907 | 2020-08-11 | Camas | Idaho | 16025 | 1 | 0 |
421908 | 421908 | 2020-08-11 | Canyon | Idaho | 16027 | 5951 | 51 |
421909 | 421909 | 2020-08-11 | Caribou | Idaho | 16029 | 32 | 0 |
421910 | 421910 | 2020-08-11 | Cassia | Idaho | 16031 | 533 | 1 |
421911 | 421911 | 2020-08-11 | Clark | Idaho | 16033 | 10 | 0 |
421912 | 421912 | 2020-08-11 | Clearwater | Idaho | 16035 | 17 | 0 |
421913 | 421913 | 2020-08-11 | Custer | Idaho | 16037 | 11 | 0 |
421914 | 421914 | 2020-08-11 | Elmore | Idaho | 16039 | 215 | 3 |
421915 | 421915 | 2020-08-11 | Franklin | Idaho | 16041 | 54 | 0 |
421916 | 421916 | 2020-08-11 | Fremont | Idaho | 16043 | 87 | 0 |
421917 | 421917 | 2020-08-11 | Gem | Idaho | 16045 | 180 | 1 |
421918 | 421918 | 2020-08-11 | Gooding | Idaho | 16047 | 170 | 0 |
421919 | 421919 | 2020-08-11 | Idaho | Idaho | 16049 | 32 | 0 |
421920 | 421920 | 2020-08-11 | Jefferson | Idaho | 16051 | 214 | 1 |
421921 | 421921 | 2020-08-11 | Jerome | Idaho | 16053 | 489 | 6 |
421922 | 421922 | 2020-08-11 | Kootenai | Idaho | 16055 | 1856 | 18 |
421923 | 421923 | 2020-08-11 | Latah | Idaho | 16057 | 110 | 0 |
421924 | 421924 | 2020-08-11 | Lemhi | Idaho | 16059 | 29 | 0 |
421925 | 421925 | 2020-08-11 | Lincoln | Idaho | 16063 | 60 | 0 |
421926 | 421926 | 2020-08-11 | Madison | Idaho | 16065 | 172 | 0 |
421927 | 421927 | 2020-08-11 | Minidoka | Idaho | 16067 | 484 | 2 |
421928 | 421928 | 2020-08-11 | Nez Perce | Idaho | 16069 | 161 | 19 |
421929 | 421929 | 2020-08-11 | Oneida | Idaho | 16071 | 15 | 0 |
421930 | 421930 | 2020-08-11 | Owyhee | Idaho | 16073 | 266 | 3 |
421931 | 421931 | 2020-08-11 | Payette | Idaho | 16075 | 405 | 3 |
421932 | 421932 | 2020-08-11 | Power | Idaho | 16077 | 67 | 0 |
421933 | 421933 | 2020-08-11 | Shoshone | Idaho | 16079 | 121 | 2 |
421934 | 421934 | 2020-08-11 | Teton | Idaho | 16081 | 92 | 0 |
421935 | 421935 | 2020-08-11 | Twin Falls | Idaho | 16083 | 1436 | 33 |
421936 | 421936 | 2020-08-11 | Valley | Idaho | 16085 | 65 | 1 |
421937 | 421937 | 2020-08-11 | Washington | Idaho | 16087 | 216 | 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);