ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33,184 rows where state = "Idaho" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 45
- 16001 792
- 16013 791
- 16081 791
- 16065 788
- 16083 787
- 16011 785
- 16027 785
- 16055 785
- 16085 783
- 16005 781
- 16031 781
- 16043 780
- 16049 780
- 16051 780
- 16069 780
- 16075 780
- 16037 779
- 16045 778
- 16019 777
- 16063 777
- 16073 776
- 16017 775
- 16039 775
- 16053 775
- 16067 775
- 16003 774
- 16025 774
- 16047 773
- 16057 773
- 16087 772
- 16029 770
- 16077 767
- 16059 749
- 16009 719
- 16041 715
- 16015 688
- 16021 687
- 16035 687
- 16007 683
- 16071 683
- 16079 680
- 16033 658
- 16061 643
- 16023 641
- - 12
county 45
- Ada 792
- Blaine 791
- Teton 791
- Madison 788
- Twin Falls 787
- Bingham 785
- Canyon 785
- Kootenai 785
- Valley 783
- Bannock 781
- Cassia 781
- Fremont 780
- Idaho 780
- Jefferson 780
- Nez Perce 780
- Payette 780
- Custer 779
- Gem 778
- Bonneville 777
- Lincoln 777
- Owyhee 776
- Bonner 775
- Elmore 775
- Jerome 775
- Minidoka 775
- Adams 774
- Camas 774
- Gooding 773
- Latah 773
- Washington 772
- Caribou 770
- Power 767
- Lemhi 749
- Benewah 719
- Franklin 715
- Boise 688
- Boundary 687
- Clearwater 687
- Bear Lake 683
- Oneida 683
- Shoshone 680
- Clark 658
- Lewis 643
- Butte 641
- Unknown 12
state 1
- Idaho · 33,184 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1713 | 1713 | 2020-03-13 | Ada | Idaho | 16001 | 1 | 0 |
2039 | 2039 | 2020-03-14 | Teton | Idaho | 16081 | 1 | 0 |
2429 | 2429 | 2020-03-15 | Teton | Idaho | 16081 | 1 | 0 |
2870 | 2870 | 2020-03-16 | Teton | Idaho | 16081 | 1 | 0 |
3358 | 3358 | 2020-03-17 | Madison | Idaho | 16065 | 1 | 0 |
3359 | 3359 | 2020-03-17 | Teton | Idaho | 16081 | 1 | 0 |
3920 | 3920 | 2020-03-18 | Madison | Idaho | 16065 | 1 | 0 |
3921 | 3921 | 2020-03-18 | Teton | Idaho | 16081 | 1 | 0 |
3922 | 3922 | 2020-03-18 | Twin Falls | Idaho | 16083 | 1 | 0 |
4596 | 4596 | 2020-03-19 | Madison | Idaho | 16065 | 1 | 0 |
4597 | 4597 | 2020-03-19 | Teton | Idaho | 16081 | 1 | 0 |
4598 | 4598 | 2020-03-19 | Twin Falls | Idaho | 16083 | 1 | 0 |
5395 | 5395 | 2020-03-20 | Bingham | Idaho | 16011 | 1 | 0 |
5397 | 5397 | 2020-03-20 | Canyon | Idaho | 16027 | 1 | 0 |
5399 | 5399 | 2020-03-20 | Madison | Idaho | 16065 | 1 | 0 |
5400 | 5400 | 2020-03-20 | Teton | Idaho | 16081 | 1 | 0 |
5401 | 5401 | 2020-03-20 | Twin Falls | Idaho | 16083 | 1 | 0 |
6329 | 6329 | 2020-03-21 | Bingham | Idaho | 16011 | 1 | 0 |
6331 | 6331 | 2020-03-21 | Canyon | Idaho | 16027 | 1 | 0 |
6335 | 6335 | 2020-03-21 | Twin Falls | Idaho | 16083 | 1 | 0 |
7377 | 7377 | 2020-03-22 | Bingham | Idaho | 16011 | 1 | 0 |
7383 | 7383 | 2020-03-22 | Twin Falls | Idaho | 16083 | 1 | 0 |
7384 | 7384 | 2020-03-22 | Valley | Idaho | 16085 | 1 | 0 |
8532 | 8532 | 2020-03-23 | Bingham | Idaho | 16011 | 1 | 0 |
8538 | 8538 | 2020-03-23 | Twin Falls | Idaho | 16083 | 1 | 0 |
8539 | 8539 | 2020-03-23 | Valley | Idaho | 16085 | 1 | 0 |
9794 | 9794 | 2020-03-24 | Bingham | Idaho | 16011 | 1 | 0 |
9797 | 9797 | 2020-03-24 | Cassia | Idaho | 16031 | 1 | 0 |
9801 | 9801 | 2020-03-24 | Twin Falls | Idaho | 16083 | 1 | 0 |
9802 | 9802 | 2020-03-24 | Valley | Idaho | 16085 | 1 | 0 |
11179 | 11179 | 2020-03-25 | Bingham | Idaho | 16011 | 1 | 0 |
11182 | 11182 | 2020-03-25 | Cassia | Idaho | 16031 | 1 | 0 |
11183 | 11183 | 2020-03-25 | Fremont | Idaho | 16043 | 1 | 0 |
11184 | 11184 | 2020-03-25 | Idaho | Idaho | 16049 | 1 | 0 |
11188 | 11188 | 2020-03-25 | Nez Perce | Idaho | 16069 | 1 | 0 |
11189 | 11189 | 2020-03-25 | Payette | Idaho | 16075 | 1 | 0 |
11191 | 11191 | 2020-03-25 | Twin Falls | Idaho | 16083 | 1 | 0 |
11192 | 11192 | 2020-03-25 | Valley | Idaho | 16085 | 1 | 0 |
12732 | 12732 | 2020-03-26 | Bingham | Idaho | 16011 | 1 | 0 |
12735 | 12735 | 2020-03-26 | Cassia | Idaho | 16031 | 1 | 0 |
12736 | 12736 | 2020-03-26 | Custer | Idaho | 16037 | 1 | 0 |
12737 | 12737 | 2020-03-26 | Fremont | Idaho | 16043 | 1 | 0 |
12738 | 12738 | 2020-03-26 | Idaho | Idaho | 16049 | 1 | 0 |
12743 | 12743 | 2020-03-26 | Payette | Idaho | 16075 | 1 | 0 |
12745 | 12745 | 2020-03-26 | Twin Falls | Idaho | 16083 | 1 | 0 |
12746 | 12746 | 2020-03-26 | Unknown | Idaho | 1 | 0 | |
12747 | 12747 | 2020-03-26 | Valley | Idaho | 16085 | 1 | 0 |
14407 | 14407 | 2020-03-27 | Bingham | Idaho | 16011 | 1 | 0 |
14410 | 14410 | 2020-03-27 | Cassia | Idaho | 16031 | 1 | 0 |
14411 | 14411 | 2020-03-27 | Custer | Idaho | 16037 | 1 | 0 |
14412 | 14412 | 2020-03-27 | Fremont | Idaho | 16043 | 1 | 0 |
14413 | 14413 | 2020-03-27 | Gem | Idaho | 16045 | 1 | 0 |
14414 | 14414 | 2020-03-27 | Idaho | Idaho | 16049 | 1 | 0 |
14419 | 14419 | 2020-03-27 | Payette | Idaho | 16075 | 1 | 0 |
14422 | 14422 | 2020-03-27 | Valley | Idaho | 16085 | 1 | 0 |
16198 | 16198 | 2020-03-28 | Bingham | Idaho | 16011 | 1 | 0 |
16200 | 16200 | 2020-03-28 | Bonneville | Idaho | 16019 | 1 | 0 |
16202 | 16202 | 2020-03-28 | Cassia | Idaho | 16031 | 1 | 0 |
16203 | 16203 | 2020-03-28 | Custer | Idaho | 16037 | 1 | 0 |
16204 | 16204 | 2020-03-28 | Fremont | Idaho | 16043 | 1 | 0 |
16205 | 16205 | 2020-03-28 | Gem | Idaho | 16045 | 1 | 0 |
16206 | 16206 | 2020-03-28 | Idaho | Idaho | 16049 | 1 | 0 |
16209 | 16209 | 2020-03-28 | Lincoln | Idaho | 16063 | 1 | 0 |
16212 | 16212 | 2020-03-28 | Payette | Idaho | 16075 | 1 | 0 |
16215 | 16215 | 2020-03-28 | Valley | Idaho | 16085 | 1 | 0 |
18095 | 18095 | 2020-03-29 | Bingham | Idaho | 16011 | 1 | 0 |
18097 | 18097 | 2020-03-29 | Bonneville | Idaho | 16019 | 1 | 0 |
18099 | 18099 | 2020-03-29 | Cassia | Idaho | 16031 | 1 | 0 |
18100 | 18100 | 2020-03-29 | Custer | Idaho | 16037 | 1 | 0 |
18101 | 18101 | 2020-03-29 | Fremont | Idaho | 16043 | 1 | 0 |
18103 | 18103 | 2020-03-29 | Idaho | Idaho | 16049 | 1 | 0 |
18106 | 18106 | 2020-03-29 | Lincoln | Idaho | 16063 | 1 | 0 |
18109 | 18109 | 2020-03-29 | Owyhee | Idaho | 16073 | 1 | 0 |
18110 | 18110 | 2020-03-29 | Payette | Idaho | 16075 | 1 | 0 |
18113 | 18113 | 2020-03-29 | Valley | Idaho | 16085 | 1 | 0 |
20091 | 20091 | 2020-03-30 | Bingham | Idaho | 16011 | 1 | 0 |
20093 | 20093 | 2020-03-30 | Bonner | Idaho | 16017 | 1 | 0 |
20096 | 20096 | 2020-03-30 | Cassia | Idaho | 16031 | 1 | 0 |
20097 | 20097 | 2020-03-30 | Custer | Idaho | 16037 | 1 | 0 |
20098 | 20098 | 2020-03-30 | Elmore | Idaho | 16039 | 1 | 0 |
20099 | 20099 | 2020-03-30 | Fremont | Idaho | 16043 | 1 | 0 |
20101 | 20101 | 2020-03-30 | Idaho | Idaho | 16049 | 1 | 0 |
20103 | 20103 | 2020-03-30 | Jerome | Idaho | 16053 | 1 | 0 |
20105 | 20105 | 2020-03-30 | Lincoln | Idaho | 16063 | 1 | 0 |
20107 | 20107 | 2020-03-30 | Minidoka | Idaho | 16067 | 1 | 0 |
20109 | 20109 | 2020-03-30 | Owyhee | Idaho | 16073 | 1 | 0 |
20110 | 20110 | 2020-03-30 | Payette | Idaho | 16075 | 1 | 0 |
22179 | 22179 | 2020-03-31 | Adams | Idaho | 16003 | 1 | 0 |
22183 | 22183 | 2020-03-31 | Bonner | Idaho | 16017 | 1 | 0 |
22185 | 22185 | 2020-03-31 | Camas | Idaho | 16025 | 1 | 0 |
22187 | 22187 | 2020-03-31 | Cassia | Idaho | 16031 | 1 | 1 |
22190 | 22190 | 2020-03-31 | Fremont | Idaho | 16043 | 1 | 0 |
22192 | 22192 | 2020-03-31 | Idaho | Idaho | 16049 | 1 | 0 |
22198 | 22198 | 2020-03-31 | Minidoka | Idaho | 16067 | 1 | 0 |
22200 | 22200 | 2020-03-31 | Owyhee | Idaho | 16073 | 1 | 0 |
22201 | 22201 | 2020-03-31 | Payette | Idaho | 16075 | 1 | 0 |
24345 | 24345 | 2020-04-01 | Adams | Idaho | 16003 | 1 | 0 |
24349 | 24349 | 2020-04-01 | Bonner | Idaho | 16017 | 1 | 0 |
24351 | 24351 | 2020-04-01 | Camas | Idaho | 16025 | 1 | 0 |
24353 | 24353 | 2020-04-01 | Cassia | Idaho | 16031 | 1 | 1 |
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);