ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
443 rows where deaths = 7 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Butte 55
- Blaine 46
- Custer 43
- Benewah 38
- Jerome 37
- Valley 29
- Madison 22
- Teton 21
- Power 16
- Elmore 13
- Lemhi 13
- Minidoka 12
- Franklin 11
- Washington 11
- Lincoln 8
- Adams 7
- Bear Lake 7
- Boise 7
- Boundary 7
- Canyon 7
- Fremont 7
- Bonneville 5
- Latah 5
- Payette 4
- Cassia 3
- Bingham 1
- Bonner 1
- Caribou 1
- Gem 1
- Gooding 1
- …
state 1
- Idaho · 443 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217057 | 2217057 | 2022-02-15 | Custer | Idaho | 16037 | 516 | 7 |
2213806 | 2213806 | 2022-02-14 | Custer | Idaho | 16037 | 514 | 7 |
2210547 | 2210547 | 2022-02-13 | Butte | Idaho | 16023 | 471 | 7 |
2210554 | 2210554 | 2022-02-13 | Custer | Idaho | 16037 | 514 | 7 |
2207294 | 2207294 | 2022-02-12 | Butte | Idaho | 16023 | 471 | 7 |
2207301 | 2207301 | 2022-02-12 | Custer | Idaho | 16037 | 514 | 7 |
2204041 | 2204041 | 2022-02-11 | Butte | Idaho | 16023 | 471 | 7 |
2204048 | 2204048 | 2022-02-11 | Custer | Idaho | 16037 | 514 | 7 |
2200788 | 2200788 | 2022-02-10 | Butte | Idaho | 16023 | 470 | 7 |
2200795 | 2200795 | 2022-02-10 | Custer | Idaho | 16037 | 514 | 7 |
2197534 | 2197534 | 2022-02-09 | Butte | Idaho | 16023 | 469 | 7 |
2197541 | 2197541 | 2022-02-09 | Custer | Idaho | 16037 | 514 | 7 |
2194280 | 2194280 | 2022-02-08 | Butte | Idaho | 16023 | 469 | 7 |
2194287 | 2194287 | 2022-02-08 | Custer | Idaho | 16037 | 512 | 7 |
2191026 | 2191026 | 2022-02-07 | Butte | Idaho | 16023 | 467 | 7 |
2191033 | 2191033 | 2022-02-07 | Custer | Idaho | 16037 | 510 | 7 |
2187773 | 2187773 | 2022-02-06 | Butte | Idaho | 16023 | 465 | 7 |
2187780 | 2187780 | 2022-02-06 | Custer | Idaho | 16037 | 506 | 7 |
2184520 | 2184520 | 2022-02-05 | Butte | Idaho | 16023 | 465 | 7 |
2184527 | 2184527 | 2022-02-05 | Custer | Idaho | 16037 | 506 | 7 |
2181268 | 2181268 | 2022-02-04 | Butte | Idaho | 16023 | 465 | 7 |
2181275 | 2181275 | 2022-02-04 | Custer | Idaho | 16037 | 503 | 7 |
2178017 | 2178017 | 2022-02-03 | Butte | Idaho | 16023 | 465 | 7 |
2178024 | 2178024 | 2022-02-03 | Custer | Idaho | 16037 | 499 | 7 |
2174764 | 2174764 | 2022-02-02 | Butte | Idaho | 16023 | 461 | 7 |
2174771 | 2174771 | 2022-02-02 | Custer | Idaho | 16037 | 498 | 7 |
2171511 | 2171511 | 2022-02-01 | Butte | Idaho | 16023 | 457 | 7 |
2171518 | 2171518 | 2022-02-01 | Custer | Idaho | 16037 | 496 | 7 |
2168258 | 2168258 | 2022-01-31 | Butte | Idaho | 16023 | 455 | 7 |
2168265 | 2168265 | 2022-01-31 | Custer | Idaho | 16037 | 493 | 7 |
2165003 | 2165003 | 2022-01-30 | Butte | Idaho | 16023 | 452 | 7 |
2165010 | 2165010 | 2022-01-30 | Custer | Idaho | 16037 | 487 | 7 |
2161748 | 2161748 | 2022-01-29 | Butte | Idaho | 16023 | 452 | 7 |
2161755 | 2161755 | 2022-01-29 | Custer | Idaho | 16037 | 487 | 7 |
2158492 | 2158492 | 2022-01-28 | Butte | Idaho | 16023 | 443 | 7 |
2158499 | 2158499 | 2022-01-28 | Custer | Idaho | 16037 | 481 | 7 |
2155239 | 2155239 | 2022-01-27 | Butte | Idaho | 16023 | 442 | 7 |
2155246 | 2155246 | 2022-01-27 | Custer | Idaho | 16037 | 481 | 7 |
2151986 | 2151986 | 2022-01-26 | Butte | Idaho | 16023 | 441 | 7 |
2151993 | 2151993 | 2022-01-26 | Custer | Idaho | 16037 | 477 | 7 |
2148734 | 2148734 | 2022-01-25 | Butte | Idaho | 16023 | 436 | 7 |
2148741 | 2148741 | 2022-01-25 | Custer | Idaho | 16037 | 471 | 7 |
2145482 | 2145482 | 2022-01-24 | Butte | Idaho | 16023 | 431 | 7 |
2145489 | 2145489 | 2022-01-24 | Custer | Idaho | 16037 | 469 | 7 |
2142227 | 2142227 | 2022-01-23 | Butte | Idaho | 16023 | 431 | 7 |
2142234 | 2142234 | 2022-01-23 | Custer | Idaho | 16037 | 464 | 7 |
2138972 | 2138972 | 2022-01-22 | Butte | Idaho | 16023 | 431 | 7 |
2138979 | 2138979 | 2022-01-22 | Custer | Idaho | 16037 | 464 | 7 |
2135716 | 2135716 | 2022-01-21 | Butte | Idaho | 16023 | 431 | 7 |
2135723 | 2135723 | 2022-01-21 | Custer | Idaho | 16037 | 462 | 7 |
2132464 | 2132464 | 2022-01-20 | Butte | Idaho | 16023 | 431 | 7 |
2132471 | 2132471 | 2022-01-20 | Custer | Idaho | 16037 | 459 | 7 |
2129211 | 2129211 | 2022-01-19 | Butte | Idaho | 16023 | 424 | 7 |
2129218 | 2129218 | 2022-01-19 | Custer | Idaho | 16037 | 454 | 7 |
2125957 | 2125957 | 2022-01-18 | Butte | Idaho | 16023 | 418 | 7 |
2125964 | 2125964 | 2022-01-18 | Custer | Idaho | 16037 | 448 | 7 |
2122705 | 2122705 | 2022-01-17 | Butte | Idaho | 16023 | 410 | 7 |
2122712 | 2122712 | 2022-01-17 | Custer | Idaho | 16037 | 446 | 7 |
2119453 | 2119453 | 2022-01-16 | Butte | Idaho | 16023 | 410 | 7 |
2119460 | 2119460 | 2022-01-16 | Custer | Idaho | 16037 | 446 | 7 |
2116201 | 2116201 | 2022-01-15 | Butte | Idaho | 16023 | 410 | 7 |
2116208 | 2116208 | 2022-01-15 | Custer | Idaho | 16037 | 446 | 7 |
2112950 | 2112950 | 2022-01-14 | Butte | Idaho | 16023 | 410 | 7 |
2112957 | 2112957 | 2022-01-14 | Custer | Idaho | 16037 | 446 | 7 |
2109698 | 2109698 | 2022-01-13 | Butte | Idaho | 16023 | 409 | 7 |
2109705 | 2109705 | 2022-01-13 | Custer | Idaho | 16037 | 442 | 7 |
2106447 | 2106447 | 2022-01-12 | Butte | Idaho | 16023 | 403 | 7 |
2106454 | 2106454 | 2022-01-12 | Custer | Idaho | 16037 | 438 | 7 |
2103196 | 2103196 | 2022-01-11 | Butte | Idaho | 16023 | 400 | 7 |
2103203 | 2103203 | 2022-01-11 | Custer | Idaho | 16037 | 432 | 7 |
2099945 | 2099945 | 2022-01-10 | Butte | Idaho | 16023 | 400 | 7 |
2099952 | 2099952 | 2022-01-10 | Custer | Idaho | 16037 | 425 | 7 |
2096694 | 2096694 | 2022-01-09 | Butte | Idaho | 16023 | 398 | 7 |
2096701 | 2096701 | 2022-01-09 | Custer | Idaho | 16037 | 423 | 7 |
2093442 | 2093442 | 2022-01-08 | Butte | Idaho | 16023 | 398 | 7 |
2093449 | 2093449 | 2022-01-08 | Custer | Idaho | 16037 | 423 | 7 |
2090190 | 2090190 | 2022-01-07 | Butte | Idaho | 16023 | 398 | 7 |
2090197 | 2090197 | 2022-01-07 | Custer | Idaho | 16037 | 423 | 7 |
2086939 | 2086939 | 2022-01-06 | Butte | Idaho | 16023 | 398 | 7 |
2086946 | 2086946 | 2022-01-06 | Custer | Idaho | 16037 | 421 | 7 |
2083687 | 2083687 | 2022-01-05 | Butte | Idaho | 16023 | 393 | 7 |
2083694 | 2083694 | 2022-01-05 | Custer | Idaho | 16037 | 420 | 7 |
2080435 | 2080435 | 2022-01-04 | Butte | Idaho | 16023 | 391 | 7 |
2080442 | 2080442 | 2022-01-04 | Custer | Idaho | 16037 | 419 | 7 |
2077183 | 2077183 | 2022-01-03 | Butte | Idaho | 16023 | 389 | 7 |
2073932 | 2073932 | 2022-01-02 | Butte | Idaho | 16023 | 389 | 7 |
2070681 | 2070681 | 2022-01-01 | Butte | Idaho | 16023 | 389 | 7 |
2067430 | 2067430 | 2021-12-31 | Butte | Idaho | 16023 | 389 | 7 |
2064179 | 2064179 | 2021-12-30 | Butte | Idaho | 16023 | 389 | 7 |
2060929 | 2060929 | 2021-12-29 | Butte | Idaho | 16023 | 389 | 7 |
2057680 | 2057680 | 2021-12-28 | Butte | Idaho | 16023 | 389 | 7 |
2054431 | 2054431 | 2021-12-27 | Butte | Idaho | 16023 | 388 | 7 |
2051181 | 2051181 | 2021-12-26 | Butte | Idaho | 16023 | 388 | 7 |
2047931 | 2047931 | 2021-12-25 | Butte | Idaho | 16023 | 388 | 7 |
2044681 | 2044681 | 2021-12-24 | Butte | Idaho | 16023 | 388 | 7 |
2041432 | 2041432 | 2021-12-23 | Butte | Idaho | 16023 | 388 | 7 |
2038182 | 2038182 | 2021-12-22 | Butte | Idaho | 16023 | 388 | 7 |
2034932 | 2034932 | 2021-12-21 | Butte | Idaho | 16023 | 388 | 7 |
2031711 | 2031711 | 2021-12-20 | Teton | Idaho | 16081 | 1791 | 7 |
2028460 | 2028460 | 2021-12-19 | Teton | Idaho | 16081 | 1786 | 7 |
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);