ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where deaths = 111 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328419 | 2328419 | 2022-03-21 | Mille Lacs | Minnesota | 27095 | 7199 | 111 |
2325166 | 2325166 | 2022-03-20 | Mille Lacs | Minnesota | 27095 | 7199 | 111 |
2321912 | 2321912 | 2022-03-19 | Mille Lacs | Minnesota | 27095 | 7199 | 111 |
2318658 | 2318658 | 2022-03-18 | Mille Lacs | Minnesota | 27095 | 7199 | 111 |
2315405 | 2315405 | 2022-03-17 | Mille Lacs | Minnesota | 27095 | 7197 | 111 |
2312152 | 2312152 | 2022-03-16 | Mille Lacs | Minnesota | 27095 | 7196 | 111 |
2308899 | 2308899 | 2022-03-15 | Mille Lacs | Minnesota | 27095 | 7193 | 111 |
2152757 | 2152757 | 2022-01-26 | Chisago | Minnesota | 27025 | 12704 | 111 |
2152765 | 2152765 | 2022-01-26 | Douglas | Minnesota | 27041 | 9674 | 111 |
2149505 | 2149505 | 2022-01-25 | Chisago | Minnesota | 27025 | 12631 | 111 |
2149513 | 2149513 | 2022-01-25 | Douglas | Minnesota | 27041 | 9605 | 111 |
2146261 | 2146261 | 2022-01-24 | Douglas | Minnesota | 27041 | 9427 | 111 |
2107209 | 2107209 | 2022-01-12 | Beltrami | Minnesota | 27007 | 9228 | 111 |
2103958 | 2103958 | 2022-01-11 | Beltrami | Minnesota | 27007 | 9188 | 111 |
2100707 | 2100707 | 2022-01-10 | Beltrami | Minnesota | 27007 | 9062 | 111 |
2097456 | 2097456 | 2022-01-09 | Beltrami | Minnesota | 27007 | 9000 | 111 |
2097477 | 2097477 | 2022-01-09 | Goodhue | Minnesota | 27049 | 9543 | 111 |
2094204 | 2094204 | 2022-01-08 | Beltrami | Minnesota | 27007 | 9000 | 111 |
2094225 | 2094225 | 2022-01-08 | Goodhue | Minnesota | 27049 | 9543 | 111 |
2090952 | 2090952 | 2022-01-07 | Beltrami | Minnesota | 27007 | 9000 | 111 |
2090973 | 2090973 | 2022-01-07 | Goodhue | Minnesota | 27049 | 9543 | 111 |
2087701 | 2087701 | 2022-01-06 | Beltrami | Minnesota | 27007 | 8968 | 111 |
2087722 | 2087722 | 2022-01-06 | Goodhue | Minnesota | 27049 | 9488 | 111 |
2084449 | 2084449 | 2022-01-05 | Beltrami | Minnesota | 27007 | 8936 | 111 |
2081197 | 2081197 | 2022-01-04 | Beltrami | Minnesota | 27007 | 8908 | 111 |
2077945 | 2077945 | 2022-01-03 | Beltrami | Minnesota | 27007 | 8822 | 111 |
2074694 | 2074694 | 2022-01-02 | Beltrami | Minnesota | 27007 | 8803 | 111 |
2071443 | 2071443 | 2022-01-01 | Beltrami | Minnesota | 27007 | 8803 | 111 |
2068192 | 2068192 | 2021-12-31 | Beltrami | Minnesota | 27007 | 8803 | 111 |
2064941 | 2064941 | 2021-12-30 | Beltrami | Minnesota | 27007 | 8803 | 111 |
2061691 | 2061691 | 2021-12-29 | Beltrami | Minnesota | 27007 | 8757 | 111 |
2051953 | 2051953 | 2021-12-26 | Clay | Minnesota | 27027 | 12977 | 111 |
2048703 | 2048703 | 2021-12-25 | Clay | Minnesota | 27027 | 12977 | 111 |
2045453 | 2045453 | 2021-12-24 | Clay | Minnesota | 27027 | 12977 | 111 |
2042203 | 2042203 | 2021-12-23 | Clay | Minnesota | 27027 | 12977 | 111 |
2038954 | 2038954 | 2021-12-22 | Clay | Minnesota | 27027 | 12955 | 111 |
2035704 | 2035704 | 2021-12-21 | Clay | Minnesota | 27027 | 12903 | 111 |
2032454 | 2032454 | 2021-12-20 | Clay | Minnesota | 27027 | 12818 | 111 |
2029203 | 2029203 | 2021-12-19 | Clay | Minnesota | 27027 | 12773 | 111 |
2025952 | 2025952 | 2021-12-18 | Clay | Minnesota | 27027 | 12773 | 111 |
2022701 | 2022701 | 2021-12-17 | Clay | Minnesota | 27027 | 12773 | 111 |
2019450 | 2019450 | 2021-12-16 | Clay | Minnesota | 27027 | 12731 | 111 |
2016200 | 2016200 | 2021-12-15 | Clay | Minnesota | 27027 | 12680 | 111 |
2012949 | 2012949 | 2021-12-14 | Clay | Minnesota | 27027 | 12606 | 111 |
2009698 | 2009698 | 2021-12-13 | Clay | Minnesota | 27027 | 12528 | 111 |
2006447 | 2006447 | 2021-12-12 | Clay | Minnesota | 27027 | 12489 | 111 |
2003196 | 2003196 | 2021-12-11 | Clay | Minnesota | 27027 | 12489 | 111 |
1999946 | 1999946 | 2021-12-10 | Clay | Minnesota | 27027 | 12489 | 111 |
1996695 | 1996695 | 2021-12-09 | Clay | Minnesota | 27027 | 12423 | 111 |
1847189 | 1847189 | 2021-10-24 | Benton | Minnesota | 27009 | 7477 | 111 |
1843939 | 1843939 | 2021-10-23 | Benton | Minnesota | 27009 | 7477 | 111 |
1840689 | 1840689 | 2021-10-22 | Benton | Minnesota | 27009 | 7477 | 111 |
1837440 | 1837440 | 2021-10-21 | Benton | Minnesota | 27009 | 7472 | 111 |
1824509 | 1824509 | 2021-10-17 | Sherburne | Minnesota | 27141 | 15232 | 111 |
1821260 | 1821260 | 2021-10-16 | Sherburne | Minnesota | 27141 | 15232 | 111 |
1818011 | 1818011 | 2021-10-15 | Sherburne | Minnesota | 27141 | 15232 | 111 |
1814762 | 1814762 | 2021-10-14 | Sherburne | Minnesota | 27141 | 15149 | 111 |
1811514 | 1811514 | 2021-10-13 | Sherburne | Minnesota | 27141 | 15089 | 111 |
1808265 | 1808265 | 2021-10-12 | Sherburne | Minnesota | 27141 | 15022 | 111 |
1805014 | 1805014 | 2021-10-11 | Sherburne | Minnesota | 27141 | 14843 | 111 |
1801765 | 1801765 | 2021-10-10 | Sherburne | Minnesota | 27141 | 14783 | 111 |
1798516 | 1798516 | 2021-10-09 | Sherburne | Minnesota | 27141 | 14783 | 111 |
1795267 | 1795267 | 2021-10-08 | Sherburne | Minnesota | 27141 | 14783 | 111 |
1792018 | 1792018 | 2021-10-07 | Sherburne | Minnesota | 27141 | 14691 | 111 |
1743268 | 1743268 | 2021-09-22 | Olmsted | Minnesota | 27109 | 16101 | 111 |
1740019 | 1740019 | 2021-09-21 | Olmsted | Minnesota | 27109 | 16057 | 111 |
1561361 | 1561361 | 2021-07-28 | Rice | Minnesota | 27131 | 8270 | 111 |
1558113 | 1558113 | 2021-07-27 | Rice | Minnesota | 27131 | 8261 | 111 |
1554866 | 1554866 | 2021-07-26 | Rice | Minnesota | 27131 | 8252 | 111 |
1551619 | 1551619 | 2021-07-25 | Rice | Minnesota | 27131 | 8249 | 111 |
1548372 | 1548372 | 2021-07-24 | Rice | Minnesota | 27131 | 8249 | 111 |
1545125 | 1545125 | 2021-07-23 | Rice | Minnesota | 27131 | 8249 | 111 |
1541877 | 1541877 | 2021-07-22 | Rice | Minnesota | 27131 | 8247 | 111 |
1538630 | 1538630 | 2021-07-21 | Rice | Minnesota | 27131 | 8242 | 111 |
1535383 | 1535383 | 2021-07-20 | Rice | Minnesota | 27131 | 8241 | 111 |
1532135 | 1532135 | 2021-07-19 | Rice | Minnesota | 27131 | 8239 | 111 |
1528888 | 1528888 | 2021-07-18 | Rice | Minnesota | 27131 | 8238 | 111 |
1525641 | 1525641 | 2021-07-17 | Rice | Minnesota | 27131 | 8238 | 111 |
1522394 | 1522394 | 2021-07-16 | Rice | Minnesota | 27131 | 8238 | 111 |
1519145 | 1519145 | 2021-07-15 | Rice | Minnesota | 27131 | 8233 | 111 |
1515898 | 1515898 | 2021-07-14 | Rice | Minnesota | 27131 | 8233 | 111 |
1512652 | 1512652 | 2021-07-13 | Rice | Minnesota | 27131 | 8232 | 111 |
1509405 | 1509405 | 2021-07-12 | Rice | Minnesota | 27131 | 8229 | 111 |
1506159 | 1506159 | 2021-07-11 | Rice | Minnesota | 27131 | 8224 | 111 |
1502913 | 1502913 | 2021-07-10 | Rice | Minnesota | 27131 | 8224 | 111 |
1499667 | 1499667 | 2021-07-09 | Rice | Minnesota | 27131 | 8224 | 111 |
1496421 | 1496421 | 2021-07-08 | Rice | Minnesota | 27131 | 8221 | 111 |
1493174 | 1493174 | 2021-07-07 | Rice | Minnesota | 27131 | 8221 | 111 |
1489927 | 1489927 | 2021-07-06 | Rice | Minnesota | 27131 | 8220 | 111 |
1486680 | 1486680 | 2021-07-05 | Rice | Minnesota | 27131 | 8220 | 111 |
1483434 | 1483434 | 2021-07-04 | Rice | Minnesota | 27131 | 8220 | 111 |
1480188 | 1480188 | 2021-07-03 | Rice | Minnesota | 27131 | 8220 | 111 |
1476941 | 1476941 | 2021-07-02 | Rice | Minnesota | 27131 | 8216 | 111 |
1473695 | 1473695 | 2021-07-01 | Rice | Minnesota | 27131 | 8216 | 111 |
1470449 | 1470449 | 2021-06-30 | Rice | Minnesota | 27131 | 8214 | 111 |
1467204 | 1467204 | 2021-06-29 | Rice | Minnesota | 27131 | 8213 | 111 |
1463959 | 1463959 | 2021-06-28 | Rice | Minnesota | 27131 | 8213 | 111 |
1171772 | 1171772 | 2021-03-30 | Scott | Minnesota | 27139 | 14614 | 111 |
1168524 | 1168524 | 2021-03-29 | Scott | Minnesota | 27139 | 14557 | 111 |
1165276 | 1165276 | 2021-03-28 | Scott | Minnesota | 27139 | 14490 | 111 |
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);