ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
470 rows where deaths = 32 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Rock 63
- Mower 55
- Cass 49
- Todd 42
- Martin 38
- Scott 18
- Aitkin 16
- Chippewa 16
- Cottonwood 16
- Koochiching 14
- Le Sueur 14
- Waseca 12
- Freeborn 9
- Pennington 8
- Pipestone 8
- Brown 7
- Roseau 7
- Becker 6
- Blue Earth 6
- Meeker 6
- Renville 6
- Unknown 6
- Chisago 5
- Faribault 5
- Carver 4
- Pine 4
- Swift 4
- Benton 3
- Nicollet 3
- Washington 3
- …
state 1
- Minnesota · 470 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2214624 | 2214624 | 2022-02-14 | Rock | Minnesota | 27133 | 2296 | 32 |
2214633 | 2214633 | 2022-02-14 | Swift | Minnesota | 27151 | 2229 | 32 |
2211372 | 2211372 | 2022-02-13 | Rock | Minnesota | 27133 | 2295 | 32 |
2211381 | 2211381 | 2022-02-13 | Swift | Minnesota | 27151 | 2215 | 32 |
2208119 | 2208119 | 2022-02-12 | Rock | Minnesota | 27133 | 2295 | 32 |
2208128 | 2208128 | 2022-02-12 | Swift | Minnesota | 27151 | 2215 | 32 |
2204866 | 2204866 | 2022-02-11 | Rock | Minnesota | 27133 | 2295 | 32 |
2204875 | 2204875 | 2022-02-11 | Swift | Minnesota | 27151 | 2215 | 32 |
2201613 | 2201613 | 2022-02-10 | Rock | Minnesota | 27133 | 2293 | 32 |
2198359 | 2198359 | 2022-02-09 | Rock | Minnesota | 27133 | 2285 | 32 |
2195105 | 2195105 | 2022-02-08 | Rock | Minnesota | 27133 | 2282 | 32 |
2191851 | 2191851 | 2022-02-07 | Rock | Minnesota | 27133 | 2271 | 32 |
2188598 | 2188598 | 2022-02-06 | Rock | Minnesota | 27133 | 2265 | 32 |
2185345 | 2185345 | 2022-02-05 | Rock | Minnesota | 27133 | 2265 | 32 |
2182093 | 2182093 | 2022-02-04 | Rock | Minnesota | 27133 | 2265 | 32 |
2178841 | 2178841 | 2022-02-03 | Rock | Minnesota | 27133 | 2257 | 32 |
2175581 | 2175581 | 2022-02-02 | Pipestone | Minnesota | 27117 | 1900 | 32 |
2175589 | 2175589 | 2022-02-02 | Rock | Minnesota | 27133 | 2245 | 32 |
2172328 | 2172328 | 2022-02-01 | Pipestone | Minnesota | 27117 | 1898 | 32 |
2172336 | 2172336 | 2022-02-01 | Rock | Minnesota | 27133 | 2237 | 32 |
2169075 | 2169075 | 2022-01-31 | Pipestone | Minnesota | 27117 | 1883 | 32 |
2169083 | 2169083 | 2022-01-31 | Rock | Minnesota | 27133 | 2222 | 32 |
2165820 | 2165820 | 2022-01-30 | Pipestone | Minnesota | 27117 | 1865 | 32 |
2165828 | 2165828 | 2022-01-30 | Rock | Minnesota | 27133 | 2205 | 32 |
2162565 | 2162565 | 2022-01-29 | Pipestone | Minnesota | 27117 | 1865 | 32 |
2162573 | 2162573 | 2022-01-29 | Rock | Minnesota | 27133 | 2205 | 32 |
2159310 | 2159310 | 2022-01-28 | Pipestone | Minnesota | 27117 | 1865 | 32 |
2159318 | 2159318 | 2022-01-28 | Rock | Minnesota | 27133 | 2205 | 32 |
2156056 | 2156056 | 2022-01-27 | Pipestone | Minnesota | 27117 | 1850 | 32 |
2156064 | 2156064 | 2022-01-27 | Rock | Minnesota | 27133 | 2194 | 32 |
2152803 | 2152803 | 2022-01-26 | Pipestone | Minnesota | 27117 | 1835 | 32 |
2152811 | 2152811 | 2022-01-26 | Rock | Minnesota | 27133 | 2173 | 32 |
2149559 | 2149559 | 2022-01-25 | Rock | Minnesota | 27133 | 2161 | 32 |
2146276 | 2146276 | 2022-01-24 | Koochiching | Minnesota | 27071 | 2225 | 32 |
2146307 | 2146307 | 2022-01-24 | Rock | Minnesota | 27133 | 2115 | 32 |
2143021 | 2143021 | 2022-01-23 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2143052 | 2143052 | 2022-01-23 | Rock | Minnesota | 27133 | 2084 | 32 |
2139766 | 2139766 | 2022-01-22 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2139797 | 2139797 | 2022-01-22 | Rock | Minnesota | 27133 | 2084 | 32 |
2136510 | 2136510 | 2022-01-21 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2136541 | 2136541 | 2022-01-21 | Rock | Minnesota | 27133 | 2084 | 32 |
2133258 | 2133258 | 2022-01-20 | Koochiching | Minnesota | 27071 | 2175 | 32 |
2133289 | 2133289 | 2022-01-20 | Rock | Minnesota | 27133 | 2052 | 32 |
2130005 | 2130005 | 2022-01-19 | Koochiching | Minnesota | 27071 | 2153 | 32 |
2130036 | 2130036 | 2022-01-19 | Rock | Minnesota | 27133 | 2034 | 32 |
2126751 | 2126751 | 2022-01-18 | Koochiching | Minnesota | 27071 | 2104 | 32 |
2126782 | 2126782 | 2022-01-18 | Rock | Minnesota | 27133 | 1989 | 32 |
2123499 | 2123499 | 2022-01-17 | Koochiching | Minnesota | 27071 | 2087 | 32 |
2123530 | 2123530 | 2022-01-17 | Rock | Minnesota | 27133 | 1977 | 32 |
2120247 | 2120247 | 2022-01-16 | Koochiching | Minnesota | 27071 | 2087 | 32 |
2120278 | 2120278 | 2022-01-16 | Rock | Minnesota | 27133 | 1977 | 32 |
2116995 | 2116995 | 2022-01-15 | Koochiching | Minnesota | 27071 | 2087 | 32 |
2117026 | 2117026 | 2022-01-15 | Rock | Minnesota | 27133 | 1977 | 32 |
2113744 | 2113744 | 2022-01-14 | Koochiching | Minnesota | 27071 | 2087 | 32 |
2113775 | 2113775 | 2022-01-14 | Rock | Minnesota | 27133 | 1977 | 32 |
2110492 | 2110492 | 2022-01-13 | Koochiching | Minnesota | 27071 | 2075 | 32 |
2110523 | 2110523 | 2022-01-13 | Rock | Minnesota | 27133 | 1969 | 32 |
2107241 | 2107241 | 2022-01-12 | Koochiching | Minnesota | 27071 | 2062 | 32 |
2107272 | 2107272 | 2022-01-12 | Rock | Minnesota | 27133 | 1956 | 32 |
2103990 | 2103990 | 2022-01-11 | Koochiching | Minnesota | 27071 | 2055 | 32 |
2104021 | 2104021 | 2022-01-11 | Rock | Minnesota | 27133 | 1948 | 32 |
2100770 | 2100770 | 2022-01-10 | Rock | Minnesota | 27133 | 1910 | 32 |
2097519 | 2097519 | 2022-01-09 | Rock | Minnesota | 27133 | 1906 | 32 |
2094267 | 2094267 | 2022-01-08 | Rock | Minnesota | 27133 | 1906 | 32 |
2091015 | 2091015 | 2022-01-07 | Rock | Minnesota | 27133 | 1906 | 32 |
2087754 | 2087754 | 2022-01-06 | Pennington | Minnesota | 27113 | 2722 | 32 |
2087764 | 2087764 | 2022-01-06 | Rock | Minnesota | 27133 | 1905 | 32 |
2084502 | 2084502 | 2022-01-05 | Pennington | Minnesota | 27113 | 2704 | 32 |
2084512 | 2084512 | 2022-01-05 | Rock | Minnesota | 27133 | 1891 | 32 |
2081250 | 2081250 | 2022-01-04 | Pennington | Minnesota | 27113 | 2702 | 32 |
2081260 | 2081260 | 2022-01-04 | Rock | Minnesota | 27133 | 1888 | 32 |
2077998 | 2077998 | 2022-01-03 | Pennington | Minnesota | 27113 | 2675 | 32 |
2078008 | 2078008 | 2022-01-03 | Rock | Minnesota | 27133 | 1868 | 32 |
2074747 | 2074747 | 2022-01-02 | Pennington | Minnesota | 27113 | 2669 | 32 |
2074757 | 2074757 | 2022-01-02 | Rock | Minnesota | 27133 | 1860 | 32 |
2071496 | 2071496 | 2022-01-01 | Pennington | Minnesota | 27113 | 2669 | 32 |
2071506 | 2071506 | 2022-01-01 | Rock | Minnesota | 27133 | 1860 | 32 |
2068245 | 2068245 | 2021-12-31 | Pennington | Minnesota | 27113 | 2669 | 32 |
2068255 | 2068255 | 2021-12-31 | Rock | Minnesota | 27133 | 1860 | 32 |
2064994 | 2064994 | 2021-12-30 | Pennington | Minnesota | 27113 | 2669 | 32 |
2065004 | 2065004 | 2021-12-30 | Rock | Minnesota | 27133 | 1860 | 32 |
2061754 | 2061754 | 2021-12-29 | Rock | Minnesota | 27133 | 1852 | 32 |
2058505 | 2058505 | 2021-12-28 | Rock | Minnesota | 27133 | 1849 | 32 |
2055256 | 2055256 | 2021-12-27 | Rock | Minnesota | 27133 | 1844 | 32 |
2052006 | 2052006 | 2021-12-26 | Rock | Minnesota | 27133 | 1841 | 32 |
2048756 | 2048756 | 2021-12-25 | Rock | Minnesota | 27133 | 1841 | 32 |
2045506 | 2045506 | 2021-12-24 | Rock | Minnesota | 27133 | 1841 | 32 |
2042256 | 2042256 | 2021-12-23 | Rock | Minnesota | 27133 | 1841 | 32 |
2039007 | 2039007 | 2021-12-22 | Rock | Minnesota | 27133 | 1831 | 32 |
2035757 | 2035757 | 2021-12-21 | Rock | Minnesota | 27133 | 1827 | 32 |
2032507 | 2032507 | 2021-12-20 | Rock | Minnesota | 27133 | 1822 | 32 |
2029256 | 2029256 | 2021-12-19 | Rock | Minnesota | 27133 | 1817 | 32 |
2026005 | 2026005 | 2021-12-18 | Rock | Minnesota | 27133 | 1817 | 32 |
2022754 | 2022754 | 2021-12-17 | Rock | Minnesota | 27133 | 1817 | 32 |
2019503 | 2019503 | 2021-12-16 | Rock | Minnesota | 27133 | 1815 | 32 |
2016253 | 2016253 | 2021-12-15 | Rock | Minnesota | 27133 | 1812 | 32 |
2013002 | 2013002 | 2021-12-14 | Rock | Minnesota | 27133 | 1811 | 32 |
1996749 | 1996749 | 2021-12-09 | Roseau | Minnesota | 27135 | 3275 | 32 |
1993498 | 1993498 | 2021-12-08 | Roseau | Minnesota | 27135 | 3260 | 32 |
1990247 | 1990247 | 2021-12-07 | Roseau | Minnesota | 27135 | 3255 | 32 |
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);