ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Madison" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174785 | 2174785 | 2022-02-02 | Madison | Idaho | 16065 | 12273 | 43 |
2171532 | 2171532 | 2022-02-01 | Madison | Idaho | 16065 | 12221 | 43 |
2168279 | 2168279 | 2022-01-31 | Madison | Idaho | 16065 | 12185 | 43 |
2165024 | 2165024 | 2022-01-30 | Madison | Idaho | 16065 | 12094 | 43 |
2161769 | 2161769 | 2022-01-29 | Madison | Idaho | 16065 | 12094 | 43 |
2158513 | 2158513 | 2022-01-28 | Madison | Idaho | 16065 | 11803 | 43 |
2155260 | 2155260 | 2022-01-27 | Madison | Idaho | 16065 | 11803 | 43 |
2152007 | 2152007 | 2022-01-26 | Madison | Idaho | 16065 | 11540 | 43 |
2148755 | 2148755 | 2022-01-25 | Madison | Idaho | 16065 | 11201 | 43 |
2145503 | 2145503 | 2022-01-24 | Madison | Idaho | 16065 | 10986 | 43 |
2142248 | 2142248 | 2022-01-23 | Madison | Idaho | 16065 | 10915 | 43 |
2138993 | 2138993 | 2022-01-22 | Madison | Idaho | 16065 | 10915 | 43 |
2135737 | 2135737 | 2022-01-21 | Madison | Idaho | 16065 | 10781 | 43 |
2132485 | 2132485 | 2022-01-20 | Madison | Idaho | 16065 | 10626 | 43 |
2129232 | 2129232 | 2022-01-19 | Madison | Idaho | 16065 | 10526 | 43 |
2125978 | 2125978 | 2022-01-18 | Madison | Idaho | 16065 | 10444 | 43 |
2122726 | 2122726 | 2022-01-17 | Madison | Idaho | 16065 | 10428 | 43 |
2119474 | 2119474 | 2022-01-16 | Madison | Idaho | 16065 | 10428 | 43 |
2116222 | 2116222 | 2022-01-15 | Madison | Idaho | 16065 | 10428 | 43 |
2112971 | 2112971 | 2022-01-14 | Madison | Idaho | 16065 | 10400 | 43 |
2109719 | 2109719 | 2022-01-13 | Madison | Idaho | 16065 | 10198 | 43 |
2106468 | 2106468 | 2022-01-12 | Madison | Idaho | 16065 | 10081 | 43 |
2103217 | 2103217 | 2022-01-11 | Madison | Idaho | 16065 | 9888 | 43 |
2099966 | 2099966 | 2022-01-10 | Madison | Idaho | 16065 | 9732 | 43 |
2096715 | 2096715 | 2022-01-09 | Madison | Idaho | 16065 | 9679 | 43 |
2093463 | 2093463 | 2022-01-08 | Madison | Idaho | 16065 | 9679 | 43 |
2090211 | 2090211 | 2022-01-07 | Madison | Idaho | 16065 | 9673 | 43 |
2086960 | 2086960 | 2022-01-06 | Madison | Idaho | 16065 | 9591 | 43 |
2083708 | 2083708 | 2022-01-05 | Madison | Idaho | 16065 | 9503 | 43 |
2080456 | 2080456 | 2022-01-04 | Madison | Idaho | 16065 | 9452 | 43 |
2077204 | 2077204 | 2022-01-03 | Madison | Idaho | 16065 | 9388 | 42 |
2073953 | 2073953 | 2022-01-02 | Madison | Idaho | 16065 | 9362 | 42 |
2070702 | 2070702 | 2022-01-01 | Madison | Idaho | 16065 | 9362 | 42 |
2067451 | 2067451 | 2021-12-31 | Madison | Idaho | 16065 | 9362 | 42 |
2064200 | 2064200 | 2021-12-30 | Madison | Idaho | 16065 | 9362 | 42 |
2060950 | 2060950 | 2021-12-29 | Madison | Idaho | 16065 | 9344 | 42 |
2057701 | 2057701 | 2021-12-28 | Madison | Idaho | 16065 | 9324 | 42 |
2054452 | 2054452 | 2021-12-27 | Madison | Idaho | 16065 | 9294 | 42 |
2051202 | 2051202 | 2021-12-26 | Madison | Idaho | 16065 | 9278 | 42 |
2047952 | 2047952 | 2021-12-25 | Madison | Idaho | 16065 | 9278 | 42 |
2044702 | 2044702 | 2021-12-24 | Madison | Idaho | 16065 | 9278 | 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 |
1989442 | 1989442 | 2021-12-07 | Madison | Idaho | 16065 | 9159 | 42 |
1986192 | 1986192 | 2021-12-06 | Madison | Idaho | 16065 | 9148 | 42 |
1982942 | 1982942 | 2021-12-05 | Madison | Idaho | 16065 | 9132 | 42 |
1979692 | 1979692 | 2021-12-04 | Madison | Idaho | 16065 | 9132 | 42 |
1976442 | 1976442 | 2021-12-03 | Madison | Idaho | 16065 | 9118 | 40 |
1973193 | 1973193 | 2021-12-02 | Madison | Idaho | 16065 | 9118 | 40 |
1969943 | 1969943 | 2021-12-01 | Madison | Idaho | 16065 | 9101 | 40 |
1966693 | 1966693 | 2021-11-30 | Madison | Idaho | 16065 | 9077 | 40 |
1963441 | 1963441 | 2021-11-29 | Madison | Idaho | 16065 | 9068 | 40 |
1960190 | 1960190 | 2021-11-28 | Madison | Idaho | 16065 | 9051 | 40 |
1956939 | 1956939 | 2021-11-27 | Madison | Idaho | 16065 | 9051 | 40 |
1953688 | 1953688 | 2021-11-26 | Madison | Idaho | 16065 | 9049 | 40 |
1950437 | 1950437 | 2021-11-25 | Madison | Idaho | 16065 | 9036 | 40 |
1947186 | 1947186 | 2021-11-24 | Madison | Idaho | 16065 | 9036 | 40 |
1943935 | 1943935 | 2021-11-23 | Madison | Idaho | 16065 | 9021 | 40 |
1940685 | 1940685 | 2021-11-22 | Madison | Idaho | 16065 | 9006 | 40 |
1937435 | 1937435 | 2021-11-21 | Madison | Idaho | 16065 | 8987 | 40 |
1934185 | 1934185 | 2021-11-20 | Madison | Idaho | 16065 | 8987 | 40 |
1930933 | 1930933 | 2021-11-19 | Madison | Idaho | 16065 | 8963 | 40 |
1927683 | 1927683 | 2021-11-18 | Madison | Idaho | 16065 | 8963 | 40 |
1924433 | 1924433 | 2021-11-17 | Madison | Idaho | 16065 | 8954 | 40 |
1921184 | 1921184 | 2021-11-16 | Madison | Idaho | 16065 | 8944 | 40 |
1917934 | 1917934 | 2021-11-15 | Madison | Idaho | 16065 | 8930 | 40 |
1914684 | 1914684 | 2021-11-14 | Madison | Idaho | 16065 | 8909 | 40 |
1911434 | 1911434 | 2021-11-13 | Madison | Idaho | 16065 | 8908 | 40 |
1908185 | 1908185 | 2021-11-12 | Madison | Idaho | 16065 | 8872 | 40 |
1904936 | 1904936 | 2021-11-11 | Madison | Idaho | 16065 | 8872 | 40 |
1901686 | 1901686 | 2021-11-10 | Madison | Idaho | 16065 | 8872 | 40 |
1898436 | 1898436 | 2021-11-09 | Madison | Idaho | 16065 | 8855 | 39 |
1895186 | 1895186 | 2021-11-08 | Madison | Idaho | 16065 | 8835 | 39 |
1891936 | 1891936 | 2021-11-07 | Madison | Idaho | 16065 | 8772 | 39 |
1888686 | 1888686 | 2021-11-06 | Madison | Idaho | 16065 | 8772 | 39 |
1885436 | 1885436 | 2021-11-05 | Madison | Idaho | 16065 | 8764 | 39 |
1882187 | 1882187 | 2021-11-04 | Madison | Idaho | 16065 | 8750 | 38 |
1878938 | 1878938 | 2021-11-03 | Madison | Idaho | 16065 | 8725 | 38 |
1875689 | 1875689 | 2021-11-02 | Madison | Idaho | 16065 | 8705 | 38 |
1872440 | 1872440 | 2021-11-01 | Madison | Idaho | 16065 | 8692 | 38 |
1869191 | 1869191 | 2021-10-31 | Madison | Idaho | 16065 | 8656 | 38 |
1865942 | 1865942 | 2021-10-30 | Madison | Idaho | 16065 | 8656 | 38 |
1862693 | 1862693 | 2021-10-29 | Madison | Idaho | 16065 | 8656 | 38 |
1859444 | 1859444 | 2021-10-28 | Madison | Idaho | 16065 | 8643 | 38 |
1856195 | 1856195 | 2021-10-27 | Madison | Idaho | 16065 | 8624 | 38 |
1852946 | 1852946 | 2021-10-26 | Madison | Idaho | 16065 | 8589 | 38 |
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);