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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 16001 314
- 16013 313
- 16081 313
- 16065 310
- 16083 309
- 16011 307
- 16027 307
- 16055 307
- 16085 305
- 16005 303
- 16031 303
- 16043 302
- 16049 302
- 16051 302
- 16069 302
- 16075 302
- 16037 301
- 16045 300
- 16019 299
- 16063 299
- 16073 298
- 16017 297
- 16039 297
- 16053 297
- 16067 297
- 16003 296
- 16025 296
- 16047 295
- 16057 295
- 16087 294
- …
county >30
- Ada 314
- Blaine 313
- Teton 313
- Madison 310
- Twin Falls 309
- Bingham 307
- Canyon 307
- Kootenai 307
- Valley 305
- Bannock 303
- Cassia 303
- Fremont 302
- Idaho 302
- Jefferson 302
- Nez Perce 302
- Payette 302
- Custer 301
- Gem 300
- Bonneville 299
- Lincoln 299
- Owyhee 298
- Bonner 297
- Elmore 297
- Jerome 297
- Minidoka 297
- Adams 296
- Camas 296
- Gooding 295
- Latah 295
- Washington 294
- …
state 1
- Idaho · 12,150 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946957 | 946957 | 2021-01-20 | Ada | Idaho | 16001 | 43032 | 391 |
946958 | 946958 | 2021-01-20 | Adams | Idaho | 16003 | 304 | 3 |
946959 | 946959 | 2021-01-20 | Bannock | Idaho | 16005 | 7159 | 79 |
946960 | 946960 | 2021-01-20 | Bear Lake | Idaho | 16007 | 314 | 2 |
946961 | 946961 | 2021-01-20 | Benewah | Idaho | 16009 | 518 | 6 |
946962 | 946962 | 2021-01-20 | Bingham | Idaho | 16011 | 3961 | 55 |
946963 | 946963 | 2021-01-20 | Blaine | Idaho | 16013 | 1788 | 14 |
946964 | 946964 | 2021-01-20 | Boise | Idaho | 16015 | 286 | 2 |
946965 | 946965 | 2021-01-20 | Bonner | Idaho | 16017 | 2484 | 24 |
946966 | 946966 | 2021-01-20 | Bonneville | Idaho | 16019 | 11225 | 125 |
946967 | 946967 | 2021-01-20 | Boundary | Idaho | 16021 | 695 | 10 |
946968 | 946968 | 2021-01-20 | Butte | Idaho | 16023 | 182 | 1 |
946969 | 946969 | 2021-01-20 | Camas | Idaho | 16025 | 58 | 0 |
946970 | 946970 | 2021-01-20 | Canyon | Idaho | 16027 | 23065 | 245 |
946971 | 946971 | 2021-01-20 | Caribou | Idaho | 16029 | 601 | 11 |
946972 | 946972 | 2021-01-20 | Cassia | Idaho | 16031 | 2717 | 22 |
946973 | 946973 | 2021-01-20 | Clark | Idaho | 16033 | 53 | 0 |
946974 | 946974 | 2021-01-20 | Clearwater | Idaho | 16035 | 936 | 10 |
946975 | 946975 | 2021-01-20 | Custer | Idaho | 16037 | 226 | 2 |
946976 | 946976 | 2021-01-20 | Elmore | Idaho | 16039 | 1493 | 10 |
946977 | 946977 | 2021-01-20 | Franklin | Idaho | 16041 | 1006 | 12 |
946978 | 946978 | 2021-01-20 | Fremont | Idaho | 16043 | 926 | 14 |
946979 | 946979 | 2021-01-20 | Gem | Idaho | 16045 | 1582 | 26 |
946980 | 946980 | 2021-01-20 | Gooding | Idaho | 16047 | 1216 | 21 |
946981 | 946981 | 2021-01-20 | Idaho | Idaho | 16049 | 1145 | 16 |
946982 | 946982 | 2021-01-20 | Jefferson | Idaho | 16051 | 2212 | 15 |
946983 | 946983 | 2021-01-20 | Jerome | Idaho | 16053 | 2384 | 18 |
946984 | 946984 | 2021-01-20 | Kootenai | Idaho | 16055 | 15049 | 146 |
946985 | 946985 | 2021-01-20 | Latah | Idaho | 16057 | 2404 | 6 |
946986 | 946986 | 2021-01-20 | Lemhi | Idaho | 16059 | 474 | 9 |
946987 | 946987 | 2021-01-20 | Lewis | Idaho | 16061 | 361 | 6 |
946988 | 946988 | 2021-01-20 | Lincoln | Idaho | 16063 | 462 | 10 |
946989 | 946989 | 2021-01-20 | Madison | Idaho | 16065 | 5712 | 21 |
946990 | 946990 | 2021-01-20 | Minidoka | Idaho | 16067 | 2189 | 26 |
946991 | 946991 | 2021-01-20 | Nez Perce | Idaho | 16069 | 3224 | 46 |
946992 | 946992 | 2021-01-20 | Oneida | Idaho | 16071 | 291 | 3 |
946993 | 946993 | 2021-01-20 | Owyhee | Idaho | 16073 | 957 | 23 |
946994 | 946994 | 2021-01-20 | Payette | Idaho | 16075 | 2263 | 26 |
946995 | 946995 | 2021-01-20 | Power | Idaho | 16077 | 586 | 6 |
946996 | 946996 | 2021-01-20 | Shoshone | Idaho | 16079 | 936 | 30 |
946997 | 946997 | 2021-01-20 | Teton | Idaho | 16081 | 904 | 4 |
946998 | 946998 | 2021-01-20 | Twin Falls | Idaho | 16083 | 8586 | 119 |
946999 | 946999 | 2021-01-20 | Valley | Idaho | 16085 | 669 | 4 |
947000 | 947000 | 2021-01-20 | Washington | Idaho | 16087 | 1110 | 18 |
943710 | 943710 | 2021-01-19 | Ada | Idaho | 16001 | 42901 | 391 |
943711 | 943711 | 2021-01-19 | Adams | Idaho | 16003 | 304 | 3 |
943712 | 943712 | 2021-01-19 | Bannock | Idaho | 16005 | 7116 | 79 |
943713 | 943713 | 2021-01-19 | Bear Lake | Idaho | 16007 | 313 | 2 |
943714 | 943714 | 2021-01-19 | Benewah | Idaho | 16009 | 517 | 6 |
943715 | 943715 | 2021-01-19 | Bingham | Idaho | 16011 | 3954 | 55 |
943716 | 943716 | 2021-01-19 | Blaine | Idaho | 16013 | 1757 | 14 |
943717 | 943717 | 2021-01-19 | Boise | Idaho | 16015 | 284 | 2 |
943718 | 943718 | 2021-01-19 | Bonner | Idaho | 16017 | 2452 | 24 |
943719 | 943719 | 2021-01-19 | Bonneville | Idaho | 16019 | 11174 | 125 |
943720 | 943720 | 2021-01-19 | Boundary | Idaho | 16021 | 686 | 10 |
943721 | 943721 | 2021-01-19 | Butte | Idaho | 16023 | 180 | 1 |
943722 | 943722 | 2021-01-19 | Camas | Idaho | 16025 | 58 | 0 |
943723 | 943723 | 2021-01-19 | Canyon | Idaho | 16027 | 22971 | 245 |
943724 | 943724 | 2021-01-19 | Caribou | Idaho | 16029 | 597 | 11 |
943725 | 943725 | 2021-01-19 | Cassia | Idaho | 16031 | 2710 | 22 |
943726 | 943726 | 2021-01-19 | Clark | Idaho | 16033 | 53 | 0 |
943727 | 943727 | 2021-01-19 | Clearwater | Idaho | 16035 | 936 | 10 |
943728 | 943728 | 2021-01-19 | Custer | Idaho | 16037 | 225 | 2 |
943729 | 943729 | 2021-01-19 | Elmore | Idaho | 16039 | 1485 | 10 |
943730 | 943730 | 2021-01-19 | Franklin | Idaho | 16041 | 1006 | 12 |
943731 | 943731 | 2021-01-19 | Fremont | Idaho | 16043 | 923 | 14 |
943732 | 943732 | 2021-01-19 | Gem | Idaho | 16045 | 1580 | 28 |
943733 | 943733 | 2021-01-19 | Gooding | Idaho | 16047 | 1214 | 21 |
943734 | 943734 | 2021-01-19 | Idaho | Idaho | 16049 | 1143 | 16 |
943735 | 943735 | 2021-01-19 | Jefferson | Idaho | 16051 | 2207 | 15 |
943736 | 943736 | 2021-01-19 | Jerome | Idaho | 16053 | 2373 | 18 |
943737 | 943737 | 2021-01-19 | Kootenai | Idaho | 16055 | 14958 | 146 |
943738 | 943738 | 2021-01-19 | Latah | Idaho | 16057 | 2397 | 6 |
943739 | 943739 | 2021-01-19 | Lemhi | Idaho | 16059 | 473 | 9 |
943740 | 943740 | 2021-01-19 | Lewis | Idaho | 16061 | 361 | 6 |
943741 | 943741 | 2021-01-19 | Lincoln | Idaho | 16063 | 462 | 10 |
943742 | 943742 | 2021-01-19 | Madison | Idaho | 16065 | 5690 | 21 |
943743 | 943743 | 2021-01-19 | Minidoka | Idaho | 16067 | 2183 | 26 |
943744 | 943744 | 2021-01-19 | Nez Perce | Idaho | 16069 | 3215 | 46 |
943745 | 943745 | 2021-01-19 | Oneida | Idaho | 16071 | 287 | 3 |
943746 | 943746 | 2021-01-19 | Owyhee | Idaho | 16073 | 956 | 23 |
943747 | 943747 | 2021-01-19 | Payette | Idaho | 16075 | 2252 | 26 |
943748 | 943748 | 2021-01-19 | Power | Idaho | 16077 | 579 | 6 |
943749 | 943749 | 2021-01-19 | Shoshone | Idaho | 16079 | 926 | 30 |
943750 | 943750 | 2021-01-19 | Teton | Idaho | 16081 | 896 | 4 |
943751 | 943751 | 2021-01-19 | Twin Falls | Idaho | 16083 | 8554 | 119 |
943752 | 943752 | 2021-01-19 | Valley | Idaho | 16085 | 661 | 4 |
943753 | 943753 | 2021-01-19 | Washington | Idaho | 16087 | 1100 | 18 |
940465 | 940465 | 2021-01-18 | Ada | Idaho | 16001 | 42506 | 387 |
940466 | 940466 | 2021-01-18 | Adams | Idaho | 16003 | 303 | 3 |
940467 | 940467 | 2021-01-18 | Bannock | Idaho | 16005 | 7058 | 78 |
940468 | 940468 | 2021-01-18 | Bear Lake | Idaho | 16007 | 312 | 2 |
940469 | 940469 | 2021-01-18 | Benewah | Idaho | 16009 | 510 | 6 |
940470 | 940470 | 2021-01-18 | Bingham | Idaho | 16011 | 3931 | 55 |
940471 | 940471 | 2021-01-18 | Blaine | Idaho | 16013 | 1725 | 14 |
940472 | 940472 | 2021-01-18 | Boise | Idaho | 16015 | 271 | 2 |
940473 | 940473 | 2021-01-18 | Bonner | Idaho | 16017 | 2390 | 23 |
940474 | 940474 | 2021-01-18 | Bonneville | Idaho | 16019 | 11110 | 124 |
940475 | 940475 | 2021-01-18 | Boundary | Idaho | 16021 | 680 | 10 |
940476 | 940476 | 2021-01-18 | Butte | Idaho | 16023 | 180 | 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);