ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where date = "2020-06-05" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
209702 | 209702 | 2020-06-05 | Ada | Idaho | 16001 | 833 | 22 |
209703 | 209703 | 2020-06-05 | Adams | Idaho | 16003 | 3 | 0 |
209704 | 209704 | 2020-06-05 | Bannock | Idaho | 16005 | 45 | 1 |
209705 | 209705 | 2020-06-05 | Benewah | Idaho | 16009 | 17 | 0 |
209706 | 209706 | 2020-06-05 | Bingham | Idaho | 16011 | 20 | 0 |
209707 | 209707 | 2020-06-05 | Blaine | Idaho | 16013 | 514 | 5 |
209708 | 209708 | 2020-06-05 | Bonner | Idaho | 16017 | 6 | 0 |
209709 | 209709 | 2020-06-05 | Bonneville | Idaho | 16019 | 60 | 0 |
209710 | 209710 | 2020-06-05 | Camas | Idaho | 16025 | 1 | 0 |
209711 | 209711 | 2020-06-05 | Canyon | Idaho | 16027 | 336 | 6 |
209712 | 209712 | 2020-06-05 | Caribou | Idaho | 16029 | 3 | 0 |
209713 | 209713 | 2020-06-05 | Cassia | Idaho | 16031 | 109 | 1 |
209714 | 209714 | 2020-06-05 | Custer | Idaho | 16037 | 2 | 0 |
209715 | 209715 | 2020-06-05 | Elmore | Idaho | 16039 | 32 | 2 |
209716 | 209716 | 2020-06-05 | Franklin | Idaho | 16041 | 8 | 0 |
209717 | 209717 | 2020-06-05 | Fremont | Idaho | 16043 | 4 | 0 |
209718 | 209718 | 2020-06-05 | Gem | Idaho | 16045 | 17 | 0 |
209719 | 209719 | 2020-06-05 | Gooding | Idaho | 16047 | 55 | 0 |
209720 | 209720 | 2020-06-05 | Idaho | Idaho | 16049 | 3 | 0 |
209721 | 209721 | 2020-06-05 | Jefferson | Idaho | 16051 | 9 | 0 |
209722 | 209722 | 2020-06-05 | Jerome | Idaho | 16053 | 194 | 2 |
209723 | 209723 | 2020-06-05 | Kootenai | Idaho | 16055 | 81 | 0 |
209724 | 209724 | 2020-06-05 | Latah | Idaho | 16057 | 7 | 0 |
209725 | 209725 | 2020-06-05 | Lemhi | Idaho | 16059 | 1 | 0 |
209726 | 209726 | 2020-06-05 | Lincoln | Idaho | 16063 | 33 | 0 |
209727 | 209727 | 2020-06-05 | Madison | Idaho | 16065 | 27 | 0 |
209728 | 209728 | 2020-06-05 | Minidoka | Idaho | 16067 | 71 | 0 |
209729 | 209729 | 2020-06-05 | Nez Perce | Idaho | 16069 | 83 | 19 |
209730 | 209730 | 2020-06-05 | Owyhee | Idaho | 16073 | 8 | 0 |
209731 | 209731 | 2020-06-05 | Payette | Idaho | 16075 | 26 | 2 |
209732 | 209732 | 2020-06-05 | Power | Idaho | 16077 | 7 | 0 |
209733 | 209733 | 2020-06-05 | Teton | Idaho | 16081 | 11 | 0 |
209734 | 209734 | 2020-06-05 | Twin Falls | Idaho | 16083 | 437 | 23 |
209735 | 209735 | 2020-06-05 | Valley | Idaho | 16085 | 2 | 0 |
209736 | 209736 | 2020-06-05 | Washington | Idaho | 16087 | 46 | 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);