ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where "date" is on date 2020-04-09 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
43713 | 43713 | 2020-04-09 | Ada | Idaho | 16001 | 496 | 6 |
43714 | 43714 | 2020-04-09 | Adams | Idaho | 16003 | 1 | 0 |
43715 | 43715 | 2020-04-09 | Bannock | Idaho | 16005 | 5 | 0 |
43716 | 43716 | 2020-04-09 | Bingham | Idaho | 16011 | 2 | 0 |
43717 | 43717 | 2020-04-09 | Blaine | Idaho | 16013 | 446 | 5 |
43718 | 43718 | 2020-04-09 | Bonner | Idaho | 16017 | 3 | 0 |
43719 | 43719 | 2020-04-09 | Bonneville | Idaho | 16019 | 11 | 0 |
43720 | 43720 | 2020-04-09 | Camas | Idaho | 16025 | 1 | 0 |
43721 | 43721 | 2020-04-09 | Canyon | Idaho | 16027 | 139 | 4 |
43722 | 43722 | 2020-04-09 | Caribou | Idaho | 16029 | 1 | 0 |
43723 | 43723 | 2020-04-09 | Cassia | Idaho | 16031 | 6 | 1 |
43724 | 43724 | 2020-04-09 | Custer | Idaho | 16037 | 2 | 0 |
43725 | 43725 | 2020-04-09 | Elmore | Idaho | 16039 | 16 | 0 |
43726 | 43726 | 2020-04-09 | Fremont | Idaho | 16043 | 2 | 0 |
43727 | 43727 | 2020-04-09 | Gem | Idaho | 16045 | 8 | 0 |
43728 | 43728 | 2020-04-09 | Gooding | Idaho | 16047 | 5 | 0 |
43729 | 43729 | 2020-04-09 | Idaho | Idaho | 16049 | 3 | 0 |
43730 | 43730 | 2020-04-09 | Jefferson | Idaho | 16051 | 5 | 0 |
43731 | 43731 | 2020-04-09 | Jerome | Idaho | 16053 | 24 | 2 |
43732 | 43732 | 2020-04-09 | Kootenai | Idaho | 16055 | 42 | 0 |
43733 | 43733 | 2020-04-09 | Latah | Idaho | 16057 | 3 | 0 |
43734 | 43734 | 2020-04-09 | Lincoln | Idaho | 16063 | 14 | 0 |
43735 | 43735 | 2020-04-09 | Madison | Idaho | 16065 | 7 | 0 |
43736 | 43736 | 2020-04-09 | Minidoka | Idaho | 16067 | 7 | 0 |
43737 | 43737 | 2020-04-09 | Nez Perce | Idaho | 16069 | 21 | 5 |
43738 | 43738 | 2020-04-09 | Owyhee | Idaho | 16073 | 4 | 0 |
43739 | 43739 | 2020-04-09 | Payette | Idaho | 16075 | 8 | 0 |
43740 | 43740 | 2020-04-09 | Power | Idaho | 16077 | 2 | 0 |
43741 | 43741 | 2020-04-09 | Teton | Idaho | 16081 | 6 | 0 |
43742 | 43742 | 2020-04-09 | Twin Falls | Idaho | 16083 | 73 | 1 |
43743 | 43743 | 2020-04-09 | Valley | Idaho | 16085 | 2 | 0 |
43744 | 43744 | 2020-04-09 | Washington | Idaho | 16087 | 1 | 0 |
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);