ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
157 rows where deaths = 42 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2145499 | 2145499 | 2022-01-24 | Latah | Idaho | 16057 | 5770 | 42 |
2142244 | 2142244 | 2022-01-23 | Latah | Idaho | 16057 | 5623 | 42 |
2138989 | 2138989 | 2022-01-22 | Latah | Idaho | 16057 | 5623 | 42 |
2135733 | 2135733 | 2022-01-21 | Latah | Idaho | 16057 | 5597 | 42 |
2132481 | 2132481 | 2022-01-20 | Latah | Idaho | 16057 | 5463 | 42 |
2129224 | 2129224 | 2022-01-19 | Idaho | Idaho | 16049 | 2609 | 42 |
2129228 | 2129228 | 2022-01-19 | Latah | Idaho | 16057 | 5371 | 42 |
2125970 | 2125970 | 2022-01-18 | Idaho | Idaho | 16049 | 2569 | 42 |
2125974 | 2125974 | 2022-01-18 | Latah | Idaho | 16057 | 5288 | 42 |
2122718 | 2122718 | 2022-01-17 | Idaho | Idaho | 16049 | 2540 | 42 |
2119466 | 2119466 | 2022-01-16 | Idaho | Idaho | 16049 | 2540 | 42 |
2116214 | 2116214 | 2022-01-15 | Idaho | Idaho | 16049 | 2540 | 42 |
2112963 | 2112963 | 2022-01-14 | Idaho | Idaho | 16049 | 2540 | 42 |
2109711 | 2109711 | 2022-01-13 | Idaho | Idaho | 16049 | 2519 | 42 |
2106460 | 2106460 | 2022-01-12 | Idaho | Idaho | 16049 | 2497 | 42 |
2103209 | 2103209 | 2022-01-11 | Idaho | Idaho | 16049 | 2485 | 42 |
2099958 | 2099958 | 2022-01-10 | Idaho | Idaho | 16049 | 2474 | 42 |
2096707 | 2096707 | 2022-01-09 | Idaho | Idaho | 16049 | 2443 | 42 |
2093455 | 2093455 | 2022-01-08 | Idaho | Idaho | 16049 | 2443 | 42 |
2090203 | 2090203 | 2022-01-07 | Idaho | Idaho | 16049 | 2443 | 42 |
2086952 | 2086952 | 2022-01-06 | Idaho | Idaho | 16049 | 2441 | 42 |
2083700 | 2083700 | 2022-01-05 | Idaho | Idaho | 16049 | 2436 | 42 |
2083712 | 2083712 | 2022-01-05 | Owyhee | Idaho | 16073 | 1770 | 42 |
2080448 | 2080448 | 2022-01-04 | Idaho | Idaho | 16049 | 2422 | 42 |
2080460 | 2080460 | 2022-01-04 | Owyhee | Idaho | 16073 | 1767 | 42 |
2077196 | 2077196 | 2022-01-03 | Idaho | Idaho | 16049 | 2408 | 42 |
2077204 | 2077204 | 2022-01-03 | Madison | Idaho | 16065 | 9388 | 42 |
2077208 | 2077208 | 2022-01-03 | Owyhee | Idaho | 16073 | 1760 | 42 |
2073945 | 2073945 | 2022-01-02 | Idaho | Idaho | 16049 | 2400 | 42 |
2073953 | 2073953 | 2022-01-02 | Madison | Idaho | 16065 | 9362 | 42 |
2073957 | 2073957 | 2022-01-02 | Owyhee | Idaho | 16073 | 1752 | 42 |
2070694 | 2070694 | 2022-01-01 | Idaho | Idaho | 16049 | 2400 | 42 |
2070702 | 2070702 | 2022-01-01 | Madison | Idaho | 16065 | 9362 | 42 |
2070706 | 2070706 | 2022-01-01 | Owyhee | Idaho | 16073 | 1752 | 42 |
2067443 | 2067443 | 2021-12-31 | Idaho | Idaho | 16049 | 2400 | 42 |
2067451 | 2067451 | 2021-12-31 | Madison | Idaho | 16065 | 9362 | 42 |
2067455 | 2067455 | 2021-12-31 | Owyhee | Idaho | 16073 | 1752 | 42 |
2064192 | 2064192 | 2021-12-30 | Idaho | Idaho | 16049 | 2400 | 42 |
2064200 | 2064200 | 2021-12-30 | Madison | Idaho | 16065 | 9362 | 42 |
2064204 | 2064204 | 2021-12-30 | Owyhee | Idaho | 16073 | 1752 | 42 |
2060942 | 2060942 | 2021-12-29 | Idaho | Idaho | 16049 | 2400 | 42 |
2060950 | 2060950 | 2021-12-29 | Madison | Idaho | 16065 | 9344 | 42 |
2057693 | 2057693 | 2021-12-28 | Idaho | Idaho | 16049 | 2398 | 42 |
2057701 | 2057701 | 2021-12-28 | Madison | Idaho | 16065 | 9324 | 42 |
2054444 | 2054444 | 2021-12-27 | Idaho | Idaho | 16049 | 2398 | 42 |
2054452 | 2054452 | 2021-12-27 | Madison | Idaho | 16065 | 9294 | 42 |
2051194 | 2051194 | 2021-12-26 | Idaho | Idaho | 16049 | 2384 | 42 |
2051202 | 2051202 | 2021-12-26 | Madison | Idaho | 16065 | 9278 | 42 |
2047944 | 2047944 | 2021-12-25 | Idaho | Idaho | 16049 | 2384 | 42 |
2047952 | 2047952 | 2021-12-25 | Madison | Idaho | 16065 | 9278 | 42 |
2044694 | 2044694 | 2021-12-24 | Idaho | Idaho | 16049 | 2384 | 42 |
2044702 | 2044702 | 2021-12-24 | Madison | Idaho | 16065 | 9278 | 42 |
2041445 | 2041445 | 2021-12-23 | Idaho | Idaho | 16049 | 2384 | 42 |
2041453 | 2041453 | 2021-12-23 | Madison | Idaho | 16065 | 9278 | 42 |
2038203 | 2038203 | 2021-12-22 | Madison | Idaho | 16065 | 9275 | 42 |
2034953 | 2034953 | 2021-12-21 | Madison | Idaho | 16065 | 9271 | 42 |
2031703 | 2031703 | 2021-12-20 | Madison | Idaho | 16065 | 9264 | 42 |
2028452 | 2028452 | 2021-12-19 | Madison | Idaho | 16065 | 9252 | 42 |
2025201 | 2025201 | 2021-12-18 | Madison | Idaho | 16065 | 9252 | 42 |
2021950 | 2021950 | 2021-12-17 | Madison | Idaho | 16065 | 9252 | 42 |
2018699 | 2018699 | 2021-12-16 | Madison | Idaho | 16065 | 9246 | 42 |
2015449 | 2015449 | 2021-12-15 | Madison | Idaho | 16065 | 9241 | 42 |
2012198 | 2012198 | 2021-12-14 | Madison | Idaho | 16065 | 9236 | 42 |
2008947 | 2008947 | 2021-12-13 | Madison | Idaho | 16065 | 9222 | 42 |
2005696 | 2005696 | 2021-12-12 | Madison | Idaho | 16065 | 9212 | 42 |
2002445 | 2002445 | 2021-12-11 | Madison | Idaho | 16065 | 9212 | 42 |
1999195 | 1999195 | 2021-12-10 | Madison | Idaho | 16065 | 9210 | 42 |
1995944 | 1995944 | 2021-12-09 | Madison | Idaho | 16065 | 9191 | 42 |
1992693 | 1992693 | 2021-12-08 | Madison | Idaho | 16065 | 9177 | 42 |
1989433 | 1989433 | 2021-12-07 | Gooding | Idaho | 16047 | 2374 | 42 |
1989442 | 1989442 | 2021-12-07 | Madison | Idaho | 16065 | 9159 | 42 |
1986183 | 1986183 | 2021-12-06 | Gooding | Idaho | 16047 | 2369 | 42 |
1986192 | 1986192 | 2021-12-06 | Madison | Idaho | 16065 | 9148 | 42 |
1982933 | 1982933 | 2021-12-05 | Gooding | Idaho | 16047 | 2367 | 42 |
1982942 | 1982942 | 2021-12-05 | Madison | Idaho | 16065 | 9132 | 42 |
1979683 | 1979683 | 2021-12-04 | Gooding | Idaho | 16047 | 2367 | 42 |
1979692 | 1979692 | 2021-12-04 | Madison | Idaho | 16065 | 9132 | 42 |
1976433 | 1976433 | 2021-12-03 | Gooding | Idaho | 16047 | 2364 | 42 |
1973184 | 1973184 | 2021-12-02 | Gooding | Idaho | 16047 | 2364 | 42 |
1969934 | 1969934 | 2021-12-01 | Gooding | Idaho | 16047 | 2357 | 42 |
1966684 | 1966684 | 2021-11-30 | Gooding | Idaho | 16047 | 2354 | 42 |
1963432 | 1963432 | 2021-11-29 | Gooding | Idaho | 16047 | 2350 | 42 |
1960181 | 1960181 | 2021-11-28 | Gooding | Idaho | 16047 | 2345 | 42 |
1956930 | 1956930 | 2021-11-27 | Gooding | Idaho | 16047 | 2345 | 42 |
1953679 | 1953679 | 2021-11-26 | Gooding | Idaho | 16047 | 2344 | 42 |
1950428 | 1950428 | 2021-11-25 | Gooding | Idaho | 16047 | 2344 | 42 |
1947177 | 1947177 | 2021-11-24 | Gooding | Idaho | 16047 | 2344 | 42 |
1943926 | 1943926 | 2021-11-23 | Gooding | Idaho | 16047 | 2342 | 42 |
1940668 | 1940668 | 2021-11-22 | Cassia | Idaho | 16031 | 3957 | 42 |
1940676 | 1940676 | 2021-11-22 | Gooding | Idaho | 16047 | 2337 | 42 |
1937413 | 1937413 | 2021-11-21 | Boundary | Idaho | 16021 | 1667 | 42 |
1937418 | 1937418 | 2021-11-21 | Cassia | Idaho | 16031 | 3956 | 42 |
1937426 | 1937426 | 2021-11-21 | Gooding | Idaho | 16047 | 2337 | 42 |
1934163 | 1934163 | 2021-11-20 | Boundary | Idaho | 16021 | 1667 | 42 |
1934168 | 1934168 | 2021-11-20 | Cassia | Idaho | 16031 | 3956 | 42 |
1934176 | 1934176 | 2021-11-20 | Gooding | Idaho | 16047 | 2337 | 42 |
1930911 | 1930911 | 2021-11-19 | Boundary | Idaho | 16021 | 1657 | 42 |
1930916 | 1930916 | 2021-11-19 | Cassia | Idaho | 16031 | 3952 | 42 |
1930924 | 1930924 | 2021-11-19 | Gooding | Idaho | 16047 | 2329 | 42 |
1927661 | 1927661 | 2021-11-18 | Boundary | Idaho | 16021 | 1657 | 42 |
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);