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 45
- 16001 459
- 16013 458
- 16081 458
- 16065 455
- 16083 454
- 16011 452
- 16027 452
- 16055 452
- 16085 450
- 16005 448
- 16031 448
- 16043 447
- 16049 447
- 16051 447
- 16069 447
- 16075 447
- 16037 446
- 16045 445
- 16019 444
- 16063 444
- 16073 443
- 16017 442
- 16039 442
- 16053 442
- 16067 442
- 16003 441
- 16025 441
- 16047 440
- 16057 440
- 16087 439
- 16029 437
- 16077 434
- 16059 416
- 16009 386
- 16041 382
- 16015 355
- 16021 354
- 16035 354
- 16007 350
- 16071 350
- 16079 347
- 16033 325
- 16061 310
- 16023 308
- - 10
county 45
- Ada 459
- Blaine 458
- Teton 458
- Madison 455
- Twin Falls 454
- Bingham 452
- Canyon 452
- Kootenai 452
- Valley 450
- Bannock 448
- Cassia 448
- Fremont 447
- Idaho 447
- Jefferson 447
- Nez Perce 447
- Payette 447
- Custer 446
- Gem 445
- Bonneville 444
- Lincoln 444
- Owyhee 443
- Bonner 442
- Elmore 442
- Jerome 442
- Minidoka 442
- Adams 441
- Camas 441
- Gooding 440
- Latah 440
- Washington 439
- Caribou 437
- Power 434
- Lemhi 416
- Benewah 386
- Franklin 382
- Boise 355
- Boundary 354
- Clearwater 354
- Bear Lake 350
- Oneida 350
- Shoshone 347
- Clark 325
- Lewis 310
- Butte 308
- Unknown 10
state 1
- Idaho · 18,530 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417686 | 1417686 | 2021-06-14 | Ada | Idaho | 16001 | 53267 | 478 |
1417687 | 1417687 | 2021-06-14 | Adams | Idaho | 16003 | 342 | 4 |
1417688 | 1417688 | 2021-06-14 | Bannock | Idaho | 16005 | 8867 | 110 |
1417689 | 1417689 | 2021-06-14 | Bear Lake | Idaho | 16007 | 398 | 2 |
1417690 | 1417690 | 2021-06-14 | Benewah | Idaho | 16009 | 707 | 10 |
1417691 | 1417691 | 2021-06-14 | Bingham | Idaho | 16011 | 4876 | 76 |
1417692 | 1417692 | 2021-06-14 | Blaine | Idaho | 16013 | 2389 | 18 |
1417693 | 1417693 | 2021-06-14 | Boise | Idaho | 16015 | 372 | 2 |
1417694 | 1417694 | 2021-06-14 | Bonner | Idaho | 16017 | 3346 | 43 |
1417695 | 1417695 | 2021-06-14 | Bonneville | Idaho | 16019 | 15016 | 174 |
1417696 | 1417696 | 2021-06-14 | Boundary | Idaho | 16021 | 882 | 11 |
1417697 | 1417697 | 2021-06-14 | Butte | Idaho | 16023 | 212 | 1 |
1417698 | 1417698 | 2021-06-14 | Camas | Idaho | 16025 | 72 | 0 |
1417699 | 1417699 | 2021-06-14 | Canyon | Idaho | 16027 | 27468 | 305 |
1417700 | 1417700 | 2021-06-14 | Caribou | Idaho | 16029 | 707 | 12 |
1417701 | 1417701 | 2021-06-14 | Cassia | Idaho | 16031 | 2961 | 27 |
1417702 | 1417702 | 2021-06-14 | Clark | Idaho | 16033 | 59 | 0 |
1417703 | 1417703 | 2021-06-14 | Clearwater | Idaho | 16035 | 1082 | 14 |
1417704 | 1417704 | 2021-06-14 | Custer | Idaho | 16037 | 257 | 3 |
1417705 | 1417705 | 2021-06-14 | Elmore | Idaho | 16039 | 2105 | 19 |
1417706 | 1417706 | 2021-06-14 | Franklin | Idaho | 16041 | 1219 | 16 |
1417707 | 1417707 | 2021-06-14 | Fremont | Idaho | 16043 | 1139 | 14 |
1417708 | 1417708 | 2021-06-14 | Gem | Idaho | 16045 | 1827 | 39 |
1417709 | 1417709 | 2021-06-14 | Gooding | Idaho | 16047 | 1319 | 23 |
1417710 | 1417710 | 2021-06-14 | Idaho | Idaho | 16049 | 1342 | 18 |
1417711 | 1417711 | 2021-06-14 | Jefferson | Idaho | 16051 | 3021 | 32 |
1417712 | 1417712 | 2021-06-14 | Jerome | Idaho | 16053 | 2637 | 23 |
1417713 | 1417713 | 2021-06-14 | Kootenai | Idaho | 16055 | 18886 | 210 |
1417714 | 1417714 | 2021-06-14 | Latah | Idaho | 16057 | 3211 | 11 |
1417715 | 1417715 | 2021-06-14 | Lemhi | Idaho | 16059 | 532 | 9 |
1417716 | 1417716 | 2021-06-14 | Lewis | Idaho | 16061 | 433 | 10 |
1417717 | 1417717 | 2021-06-14 | Lincoln | Idaho | 16063 | 512 | 11 |
1417718 | 1417718 | 2021-06-14 | Madison | Idaho | 16065 | 7319 | 28 |
1417719 | 1417719 | 2021-06-14 | Minidoka | Idaho | 16067 | 2350 | 33 |
1417720 | 1417720 | 2021-06-14 | Nez Perce | Idaho | 16069 | 3722 | 55 |
1417721 | 1417721 | 2021-06-14 | Oneida | Idaho | 16071 | 366 | 4 |
1417722 | 1417722 | 2021-06-14 | Owyhee | Idaho | 16073 | 1090 | 31 |
1417723 | 1417723 | 2021-06-14 | Payette | Idaho | 16075 | 2605 | 37 |
1417724 | 1417724 | 2021-06-14 | Power | Idaho | 16077 | 669 | 9 |
1417725 | 1417725 | 2021-06-14 | Shoshone | Idaho | 16079 | 1177 | 34 |
1417726 | 1417726 | 2021-06-14 | Teton | Idaho | 16081 | 1231 | 4 |
1417727 | 1417727 | 2021-06-14 | Twin Falls | Idaho | 16083 | 9741 | 132 |
1417728 | 1417728 | 2021-06-14 | Valley | Idaho | 16085 | 852 | 6 |
1417729 | 1417729 | 2021-06-14 | Washington | Idaho | 16087 | 1236 | 21 |
1414440 | 1414440 | 2021-06-13 | Ada | Idaho | 16001 | 53196 | 478 |
1414441 | 1414441 | 2021-06-13 | Adams | Idaho | 16003 | 342 | 4 |
1414442 | 1414442 | 2021-06-13 | Bannock | Idaho | 16005 | 8864 | 110 |
1414443 | 1414443 | 2021-06-13 | Bear Lake | Idaho | 16007 | 397 | 2 |
1414444 | 1414444 | 2021-06-13 | Benewah | Idaho | 16009 | 707 | 10 |
1414445 | 1414445 | 2021-06-13 | Bingham | Idaho | 16011 | 4877 | 76 |
1414446 | 1414446 | 2021-06-13 | Blaine | Idaho | 16013 | 2388 | 18 |
1414447 | 1414447 | 2021-06-13 | Boise | Idaho | 16015 | 369 | 2 |
1414448 | 1414448 | 2021-06-13 | Bonner | Idaho | 16017 | 3341 | 43 |
1414449 | 1414449 | 2021-06-13 | Bonneville | Idaho | 16019 | 15014 | 174 |
1414450 | 1414450 | 2021-06-13 | Boundary | Idaho | 16021 | 880 | 11 |
1414451 | 1414451 | 2021-06-13 | Butte | Idaho | 16023 | 212 | 1 |
1414452 | 1414452 | 2021-06-13 | Camas | Idaho | 16025 | 72 | 0 |
1414453 | 1414453 | 2021-06-13 | Canyon | Idaho | 16027 | 27413 | 305 |
1414454 | 1414454 | 2021-06-13 | Caribou | Idaho | 16029 | 703 | 12 |
1414455 | 1414455 | 2021-06-13 | Cassia | Idaho | 16031 | 2960 | 27 |
1414456 | 1414456 | 2021-06-13 | Clark | Idaho | 16033 | 59 | 0 |
1414457 | 1414457 | 2021-06-13 | Clearwater | Idaho | 16035 | 1082 | 14 |
1414458 | 1414458 | 2021-06-13 | Custer | Idaho | 16037 | 257 | 3 |
1414459 | 1414459 | 2021-06-13 | Elmore | Idaho | 16039 | 2101 | 19 |
1414460 | 1414460 | 2021-06-13 | Franklin | Idaho | 16041 | 1219 | 16 |
1414461 | 1414461 | 2021-06-13 | Fremont | Idaho | 16043 | 1139 | 14 |
1414462 | 1414462 | 2021-06-13 | Gem | Idaho | 16045 | 1824 | 39 |
1414463 | 1414463 | 2021-06-13 | Gooding | Idaho | 16047 | 1319 | 23 |
1414464 | 1414464 | 2021-06-13 | Idaho | Idaho | 16049 | 1335 | 18 |
1414465 | 1414465 | 2021-06-13 | Jefferson | Idaho | 16051 | 3020 | 32 |
1414466 | 1414466 | 2021-06-13 | Jerome | Idaho | 16053 | 2637 | 23 |
1414467 | 1414467 | 2021-06-13 | Kootenai | Idaho | 16055 | 18850 | 210 |
1414468 | 1414468 | 2021-06-13 | Latah | Idaho | 16057 | 3208 | 11 |
1414469 | 1414469 | 2021-06-13 | Lemhi | Idaho | 16059 | 532 | 9 |
1414470 | 1414470 | 2021-06-13 | Lewis | Idaho | 16061 | 433 | 10 |
1414471 | 1414471 | 2021-06-13 | Lincoln | Idaho | 16063 | 512 | 11 |
1414472 | 1414472 | 2021-06-13 | Madison | Idaho | 16065 | 7318 | 28 |
1414473 | 1414473 | 2021-06-13 | Minidoka | Idaho | 16067 | 2350 | 33 |
1414474 | 1414474 | 2021-06-13 | Nez Perce | Idaho | 16069 | 3715 | 55 |
1414475 | 1414475 | 2021-06-13 | Oneida | Idaho | 16071 | 366 | 4 |
1414476 | 1414476 | 2021-06-13 | Owyhee | Idaho | 16073 | 1089 | 31 |
1414477 | 1414477 | 2021-06-13 | Payette | Idaho | 16075 | 2604 | 37 |
1414478 | 1414478 | 2021-06-13 | Power | Idaho | 16077 | 669 | 9 |
1414479 | 1414479 | 2021-06-13 | Shoshone | Idaho | 16079 | 1173 | 34 |
1414480 | 1414480 | 2021-06-13 | Teton | Idaho | 16081 | 1229 | 4 |
1414481 | 1414481 | 2021-06-13 | Twin Falls | Idaho | 16083 | 9731 | 132 |
1414482 | 1414482 | 2021-06-13 | Valley | Idaho | 16085 | 851 | 6 |
1414483 | 1414483 | 2021-06-13 | Washington | Idaho | 16087 | 1236 | 21 |
1411195 | 1411195 | 2021-06-12 | Ada | Idaho | 16001 | 53196 | 478 |
1411196 | 1411196 | 2021-06-12 | Adams | Idaho | 16003 | 342 | 4 |
1411197 | 1411197 | 2021-06-12 | Bannock | Idaho | 16005 | 8864 | 110 |
1411198 | 1411198 | 2021-06-12 | Bear Lake | Idaho | 16007 | 397 | 2 |
1411199 | 1411199 | 2021-06-12 | Benewah | Idaho | 16009 | 707 | 10 |
1411200 | 1411200 | 2021-06-12 | Bingham | Idaho | 16011 | 4877 | 76 |
1411201 | 1411201 | 2021-06-12 | Blaine | Idaho | 16013 | 2388 | 18 |
1411202 | 1411202 | 2021-06-12 | Boise | Idaho | 16015 | 369 | 2 |
1411203 | 1411203 | 2021-06-12 | Bonner | Idaho | 16017 | 3341 | 43 |
1411204 | 1411204 | 2021-06-12 | Bonneville | Idaho | 16019 | 15014 | 174 |
1411205 | 1411205 | 2021-06-12 | Boundary | Idaho | 16021 | 880 | 11 |
1411206 | 1411206 | 2021-06-12 | Butte | Idaho | 16023 | 212 | 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);