ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 27053 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110483 | 2110483 | 2022-01-13 | Hennepin | Minnesota | 27053 | 233623 | 2258 |
2107232 | 2107232 | 2022-01-12 | Hennepin | Minnesota | 27053 | 229701 | 2250 |
2103981 | 2103981 | 2022-01-11 | Hennepin | Minnesota | 27053 | 227504 | 2241 |
2100730 | 2100730 | 2022-01-10 | Hennepin | Minnesota | 27053 | 220433 | 2239 |
2097479 | 2097479 | 2022-01-09 | Hennepin | Minnesota | 27053 | 217270 | 2231 |
2094227 | 2094227 | 2022-01-08 | Hennepin | Minnesota | 27053 | 217270 | 2231 |
2090975 | 2090975 | 2022-01-07 | Hennepin | Minnesota | 27053 | 217270 | 2231 |
2087724 | 2087724 | 2022-01-06 | Hennepin | Minnesota | 27053 | 215242 | 2223 |
2084472 | 2084472 | 2022-01-05 | Hennepin | Minnesota | 27053 | 213184 | 2207 |
2081220 | 2081220 | 2022-01-04 | Hennepin | Minnesota | 27053 | 211920 | 2195 |
2077968 | 2077968 | 2022-01-03 | Hennepin | Minnesota | 27053 | 206084 | 2189 |
2074717 | 2074717 | 2022-01-02 | Hennepin | Minnesota | 27053 | 203703 | 2179 |
2071466 | 2071466 | 2022-01-01 | Hennepin | Minnesota | 27053 | 203703 | 2179 |
2068215 | 2068215 | 2021-12-31 | Hennepin | Minnesota | 27053 | 203703 | 2179 |
2064964 | 2064964 | 2021-12-30 | Hennepin | Minnesota | 27053 | 203703 | 2179 |
2061714 | 2061714 | 2021-12-29 | Hennepin | Minnesota | 27053 | 201420 | 2173 |
2058465 | 2058465 | 2021-12-28 | Hennepin | Minnesota | 27053 | 199170 | 2162 |
2055216 | 2055216 | 2021-12-27 | Hennepin | Minnesota | 27053 | 196397 | 2152 |
2051966 | 2051966 | 2021-12-26 | Hennepin | Minnesota | 27053 | 195164 | 2145 |
2048716 | 2048716 | 2021-12-25 | Hennepin | Minnesota | 27053 | 195164 | 2145 |
2045466 | 2045466 | 2021-12-24 | Hennepin | Minnesota | 27053 | 195164 | 2145 |
2042216 | 2042216 | 2021-12-23 | Hennepin | Minnesota | 27053 | 195164 | 2145 |
2038967 | 2038967 | 2021-12-22 | Hennepin | Minnesota | 27053 | 194286 | 2136 |
2035717 | 2035717 | 2021-12-21 | Hennepin | Minnesota | 27053 | 193486 | 2126 |
2032467 | 2032467 | 2021-12-20 | Hennepin | Minnesota | 27053 | 191712 | 2123 |
2029216 | 2029216 | 2021-12-19 | Hennepin | Minnesota | 27053 | 191052 | 2117 |
2025965 | 2025965 | 2021-12-18 | Hennepin | Minnesota | 27053 | 191052 | 2117 |
2022714 | 2022714 | 2021-12-17 | Hennepin | Minnesota | 27053 | 191052 | 2117 |
2019463 | 2019463 | 2021-12-16 | Hennepin | Minnesota | 27053 | 190309 | 2113 |
2016213 | 2016213 | 2021-12-15 | Hennepin | Minnesota | 27053 | 189549 | 2105 |
2012962 | 2012962 | 2021-12-14 | Hennepin | Minnesota | 27053 | 189196 | 2094 |
2009711 | 2009711 | 2021-12-13 | Hennepin | Minnesota | 27053 | 187296 | 2086 |
2006460 | 2006460 | 2021-12-12 | Hennepin | Minnesota | 27053 | 186697 | 2081 |
2003209 | 2003209 | 2021-12-11 | Hennepin | Minnesota | 27053 | 186697 | 2081 |
1999959 | 1999959 | 2021-12-10 | Hennepin | Minnesota | 27053 | 186697 | 2081 |
1996708 | 1996708 | 2021-12-09 | Hennepin | Minnesota | 27053 | 185762 | 2077 |
1993457 | 1993457 | 2021-12-08 | Hennepin | Minnesota | 27053 | 185057 | 2073 |
1990206 | 1990206 | 2021-12-07 | Hennepin | Minnesota | 27053 | 184376 | 2065 |
1986956 | 1986956 | 2021-12-06 | Hennepin | Minnesota | 27053 | 181940 | 2058 |
1983706 | 1983706 | 2021-12-05 | Hennepin | Minnesota | 27053 | 180913 | 2056 |
1980456 | 1980456 | 2021-12-04 | Hennepin | Minnesota | 27053 | 180913 | 2056 |
1977206 | 1977206 | 2021-12-03 | Hennepin | Minnesota | 27053 | 180913 | 2056 |
1973956 | 1973956 | 2021-12-02 | Hennepin | Minnesota | 27053 | 179781 | 2046 |
1970707 | 1970707 | 2021-12-01 | Hennepin | Minnesota | 27053 | 178683 | 2038 |
1967457 | 1967457 | 2021-11-30 | Hennepin | Minnesota | 27053 | 178049 | 2023 |
1964205 | 1964205 | 2021-11-29 | Hennepin | Minnesota | 27053 | 175783 | 2023 |
1960954 | 1960954 | 2021-11-28 | Hennepin | Minnesota | 27053 | 174977 | 2017 |
1957703 | 1957703 | 2021-11-27 | Hennepin | Minnesota | 27053 | 174977 | 2017 |
1954452 | 1954452 | 2021-11-26 | Hennepin | Minnesota | 27053 | 174977 | 2017 |
1951201 | 1951201 | 2021-11-25 | Hennepin | Minnesota | 27053 | 174365 | 2015 |
1947950 | 1947950 | 2021-11-24 | Hennepin | Minnesota | 27053 | 174365 | 2015 |
1944699 | 1944699 | 2021-11-23 | Hennepin | Minnesota | 27053 | 173631 | 2008 |
1941448 | 1941448 | 2021-11-22 | Hennepin | Minnesota | 27053 | 171633 | 2004 |
1938198 | 1938198 | 2021-11-21 | Hennepin | Minnesota | 27053 | 170874 | 2000 |
1934948 | 1934948 | 2021-11-20 | Hennepin | Minnesota | 27053 | 170874 | 2000 |
1931698 | 1931698 | 2021-11-19 | Hennepin | Minnesota | 27053 | 170874 | 2000 |
1928447 | 1928447 | 2021-11-18 | Hennepin | Minnesota | 27053 | 170048 | 1995 |
1925197 | 1925197 | 2021-11-17 | Hennepin | Minnesota | 27053 | 169233 | 1989 |
1921948 | 1921948 | 2021-11-16 | Hennepin | Minnesota | 27053 | 168542 | 1984 |
1918698 | 1918698 | 2021-11-15 | Hennepin | Minnesota | 27053 | 166609 | 1980 |
1915448 | 1915448 | 2021-11-14 | Hennepin | Minnesota | 27053 | 165628 | 1980 |
1912198 | 1912198 | 2021-11-13 | Hennepin | Minnesota | 27053 | 165628 | 1980 |
1908948 | 1908948 | 2021-11-12 | Hennepin | Minnesota | 27053 | 165628 | 1980 |
1905699 | 1905699 | 2021-11-11 | Hennepin | Minnesota | 27053 | 164792 | 1977 |
1902450 | 1902450 | 2021-11-10 | Hennepin | Minnesota | 27053 | 163976 | 1974 |
1899200 | 1899200 | 2021-11-09 | Hennepin | Minnesota | 27053 | 163032 | 1971 |
1895950 | 1895950 | 2021-11-08 | Hennepin | Minnesota | 27053 | 161774 | 1968 |
1892700 | 1892700 | 2021-11-07 | Hennepin | Minnesota | 27053 | 161064 | 1964 |
1889450 | 1889450 | 2021-11-06 | Hennepin | Minnesota | 27053 | 161064 | 1964 |
1886200 | 1886200 | 2021-11-05 | Hennepin | Minnesota | 27053 | 161064 | 1964 |
1882951 | 1882951 | 2021-11-04 | Hennepin | Minnesota | 27053 | 160547 | 1958 |
1879702 | 1879702 | 2021-11-03 | Hennepin | Minnesota | 27053 | 160028 | 1954 |
1876453 | 1876453 | 2021-11-02 | Hennepin | Minnesota | 27053 | 159574 | 1948 |
1873204 | 1873204 | 2021-11-01 | Hennepin | Minnesota | 27053 | 158408 | 1944 |
1869955 | 1869955 | 2021-10-31 | Hennepin | Minnesota | 27053 | 156327 | 1941 |
1866706 | 1866706 | 2021-10-30 | Hennepin | Minnesota | 27053 | 156327 | 1941 |
1863457 | 1863457 | 2021-10-29 | Hennepin | Minnesota | 27053 | 156327 | 1941 |
1860208 | 1860208 | 2021-10-28 | Hennepin | Minnesota | 27053 | 155861 | 1940 |
1856959 | 1856959 | 2021-10-27 | Hennepin | Minnesota | 27053 | 155507 | 1935 |
1853710 | 1853710 | 2021-10-26 | Hennepin | Minnesota | 27053 | 155199 | 1932 |
1850461 | 1850461 | 2021-10-25 | Hennepin | Minnesota | 27053 | 154134 | 1929 |
1847211 | 1847211 | 2021-10-24 | Hennepin | Minnesota | 27053 | 153749 | 1923 |
1843961 | 1843961 | 2021-10-23 | Hennepin | Minnesota | 27053 | 153749 | 1923 |
1840711 | 1840711 | 2021-10-22 | Hennepin | Minnesota | 27053 | 153749 | 1923 |
1837462 | 1837462 | 2021-10-21 | Hennepin | Minnesota | 27053 | 153348 | 1923 |
1834213 | 1834213 | 2021-10-20 | Hennepin | Minnesota | 27053 | 152926 | 1919 |
1830964 | 1830964 | 2021-10-19 | Hennepin | Minnesota | 27053 | 152688 | 1914 |
1827715 | 1827715 | 2021-10-18 | Hennepin | Minnesota | 27053 | 151755 | 1909 |
1824466 | 1824466 | 2021-10-17 | Hennepin | Minnesota | 27053 | 151329 | 1905 |
1821217 | 1821217 | 2021-10-16 | Hennepin | Minnesota | 27053 | 151329 | 1905 |
1817968 | 1817968 | 2021-10-15 | Hennepin | Minnesota | 27053 | 151329 | 1905 |
1814719 | 1814719 | 2021-10-14 | Hennepin | Minnesota | 27053 | 150856 | 1900 |
1811471 | 1811471 | 2021-10-13 | Hennepin | Minnesota | 27053 | 150445 | 1896 |
1808222 | 1808222 | 2021-10-12 | Hennepin | Minnesota | 27053 | 150041 | 1893 |
1804971 | 1804971 | 2021-10-11 | Hennepin | Minnesota | 27053 | 148887 | 1892 |
1801722 | 1801722 | 2021-10-10 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1798473 | 1798473 | 2021-10-09 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1795224 | 1795224 | 2021-10-08 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1791975 | 1791975 | 2021-10-07 | Hennepin | Minnesota | 27053 | 147851 | 1891 |
1788726 | 1788726 | 2021-10-06 | Hennepin | Minnesota | 27053 | 147494 | 1889 |
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);