ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where deaths = 102 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2289389 | 2289389 | 2022-03-09 | Morrison | Minnesota | 27097 | 9014 | 102 |
2289400 | 2289400 | 2022-03-09 | Polk | Minnesota | 27119 | 8527 | 102 |
2286149 | 2286149 | 2022-03-08 | Polk | Minnesota | 27119 | 8524 | 102 |
2282897 | 2282897 | 2022-03-07 | Polk | Minnesota | 27119 | 8523 | 102 |
2243862 | 2243862 | 2022-02-23 | McLeod | Minnesota | 27085 | 10369 | 102 |
2240611 | 2240611 | 2022-02-22 | McLeod | Minnesota | 27085 | 10330 | 102 |
2195048 | 2195048 | 2022-02-08 | Carver | Minnesota | 27019 | 25445 | 102 |
2191794 | 2191794 | 2022-02-07 | Carver | Minnesota | 27019 | 25277 | 102 |
2188541 | 2188541 | 2022-02-06 | Carver | Minnesota | 27019 | 25164 | 102 |
2185288 | 2185288 | 2022-02-05 | Carver | Minnesota | 27019 | 25164 | 102 |
2182036 | 2182036 | 2022-02-04 | Carver | Minnesota | 27019 | 25164 | 102 |
2178784 | 2178784 | 2022-02-03 | Carver | Minnesota | 27019 | 25086 | 102 |
2146288 | 2146288 | 2022-01-24 | Mille Lacs | Minnesota | 27095 | 6359 | 102 |
2143033 | 2143033 | 2022-01-23 | Mille Lacs | Minnesota | 27095 | 6312 | 102 |
2139778 | 2139778 | 2022-01-22 | Mille Lacs | Minnesota | 27095 | 6312 | 102 |
2136522 | 2136522 | 2022-01-21 | Mille Lacs | Minnesota | 27095 | 6312 | 102 |
2133270 | 2133270 | 2022-01-20 | Mille Lacs | Minnesota | 27095 | 6268 | 102 |
2087727 | 2087727 | 2022-01-06 | Isanti | Minnesota | 27059 | 7981 | 102 |
2081206 | 2081206 | 2022-01-04 | Chisago | Minnesota | 27025 | 11138 | 102 |
2058459 | 2058459 | 2021-12-28 | Douglas | Minnesota | 27041 | 8502 | 102 |
2055210 | 2055210 | 2021-12-27 | Douglas | Minnesota | 27041 | 8461 | 102 |
2051960 | 2051960 | 2021-12-26 | Douglas | Minnesota | 27041 | 8446 | 102 |
2048710 | 2048710 | 2021-12-25 | Douglas | Minnesota | 27041 | 8446 | 102 |
2045460 | 2045460 | 2021-12-24 | Douglas | Minnesota | 27041 | 8446 | 102 |
2042210 | 2042210 | 2021-12-23 | Douglas | Minnesota | 27041 | 8446 | 102 |
2038961 | 2038961 | 2021-12-22 | Douglas | Minnesota | 27041 | 8425 | 102 |
2035711 | 2035711 | 2021-12-21 | Douglas | Minnesota | 27041 | 8400 | 102 |
2032461 | 2032461 | 2021-12-20 | Douglas | Minnesota | 27041 | 8366 | 102 |
2029210 | 2029210 | 2021-12-19 | Douglas | Minnesota | 27041 | 8353 | 102 |
2025959 | 2025959 | 2021-12-18 | Douglas | Minnesota | 27041 | 8353 | 102 |
2022708 | 2022708 | 2021-12-17 | Douglas | Minnesota | 27041 | 8353 | 102 |
2019457 | 2019457 | 2021-12-16 | Douglas | Minnesota | 27041 | 8337 | 102 |
2016207 | 2016207 | 2021-12-15 | Douglas | Minnesota | 27041 | 8295 | 102 |
2012960 | 2012960 | 2021-12-14 | Goodhue | Minnesota | 27049 | 8718 | 102 |
1996712 | 1996712 | 2021-12-09 | Itasca | Minnesota | 27061 | 7989 | 102 |
1993461 | 1993461 | 2021-12-08 | Itasca | Minnesota | 27061 | 7962 | 102 |
1990210 | 1990210 | 2021-12-07 | Itasca | Minnesota | 27061 | 7930 | 102 |
1951188 | 1951188 | 2021-11-25 | Clay | Minnesota | 27027 | 11865 | 102 |
1947937 | 1947937 | 2021-11-24 | Clay | Minnesota | 27027 | 11865 | 102 |
1944686 | 1944686 | 2021-11-23 | Clay | Minnesota | 27027 | 11817 | 102 |
1941435 | 1941435 | 2021-11-22 | Clay | Minnesota | 27027 | 11708 | 102 |
1899207 | 1899207 | 2021-11-09 | Kandiyohi | Minnesota | 27067 | 9048 | 102 |
1895957 | 1895957 | 2021-11-08 | Kandiyohi | Minnesota | 27067 | 8958 | 102 |
1892707 | 1892707 | 2021-11-07 | Kandiyohi | Minnesota | 27067 | 8918 | 102 |
1889457 | 1889457 | 2021-11-06 | Kandiyohi | Minnesota | 27067 | 8918 | 102 |
1886207 | 1886207 | 2021-11-05 | Kandiyohi | Minnesota | 27067 | 8918 | 102 |
1808251 | 1808251 | 2021-10-12 | Otter Tail | Minnesota | 27111 | 7677 | 102 |
1804949 | 1804949 | 2021-10-11 | Benton | Minnesota | 27009 | 7173 | 102 |
1805000 | 1805000 | 2021-10-11 | Otter Tail | Minnesota | 27111 | 7536 | 102 |
1801700 | 1801700 | 2021-10-10 | Benton | Minnesota | 27009 | 7152 | 102 |
1801751 | 1801751 | 2021-10-10 | Otter Tail | Minnesota | 27111 | 7490 | 102 |
1798451 | 1798451 | 2021-10-09 | Benton | Minnesota | 27009 | 7152 | 102 |
1798502 | 1798502 | 2021-10-09 | Otter Tail | Minnesota | 27111 | 7490 | 102 |
1795202 | 1795202 | 2021-10-08 | Benton | Minnesota | 27009 | 7152 | 102 |
1795253 | 1795253 | 2021-10-08 | Otter Tail | Minnesota | 27111 | 7490 | 102 |
1791953 | 1791953 | 2021-10-07 | Benton | Minnesota | 27009 | 7115 | 102 |
1792004 | 1792004 | 2021-10-07 | Otter Tail | Minnesota | 27111 | 7412 | 102 |
1788704 | 1788704 | 2021-10-06 | Benton | Minnesota | 27009 | 7076 | 102 |
1785456 | 1785456 | 2021-10-05 | Benton | Minnesota | 27009 | 7021 | 102 |
1782207 | 1782207 | 2021-10-04 | Benton | Minnesota | 27009 | 6928 | 102 |
1778957 | 1778957 | 2021-10-03 | Benton | Minnesota | 27009 | 6874 | 102 |
1775707 | 1775707 | 2021-10-02 | Benton | Minnesota | 27009 | 6874 | 102 |
1772457 | 1772457 | 2021-10-01 | Benton | Minnesota | 27009 | 6874 | 102 |
1769208 | 1769208 | 2021-09-30 | Benton | Minnesota | 27009 | 6817 | 102 |
1765959 | 1765959 | 2021-09-29 | Benton | Minnesota | 27009 | 6786 | 102 |
1762710 | 1762710 | 2021-09-28 | Benton | Minnesota | 27009 | 6758 | 102 |
1759461 | 1759461 | 2021-09-27 | Benton | Minnesota | 27009 | 6672 | 102 |
1756213 | 1756213 | 2021-09-26 | Benton | Minnesota | 27009 | 6653 | 102 |
1756226 | 1756226 | 2021-09-26 | Crow Wing | Minnesota | 27035 | 8070 | 102 |
1752965 | 1752965 | 2021-09-25 | Benton | Minnesota | 27009 | 6653 | 102 |
1752978 | 1752978 | 2021-09-25 | Crow Wing | Minnesota | 27035 | 8070 | 102 |
1749717 | 1749717 | 2021-09-24 | Benton | Minnesota | 27009 | 6653 | 102 |
1749730 | 1749730 | 2021-09-24 | Crow Wing | Minnesota | 27035 | 8070 | 102 |
1746467 | 1746467 | 2021-09-23 | Benton | Minnesota | 27009 | 6616 | 102 |
1746480 | 1746480 | 2021-09-23 | Crow Wing | Minnesota | 27035 | 8008 | 102 |
1743231 | 1743231 | 2021-09-22 | Crow Wing | Minnesota | 27035 | 7961 | 102 |
1739982 | 1739982 | 2021-09-21 | Crow Wing | Minnesota | 27035 | 7905 | 102 |
1736733 | 1736733 | 2021-09-20 | Crow Wing | Minnesota | 27035 | 7820 | 102 |
1733483 | 1733483 | 2021-09-19 | Crow Wing | Minnesota | 27035 | 7797 | 102 |
1730233 | 1730233 | 2021-09-18 | Crow Wing | Minnesota | 27035 | 7797 | 102 |
1726983 | 1726983 | 2021-09-17 | Crow Wing | Minnesota | 27035 | 7797 | 102 |
1723734 | 1723734 | 2021-09-16 | Crow Wing | Minnesota | 27035 | 7764 | 102 |
1538619 | 1538619 | 2021-07-21 | Olmsted | Minnesota | 27109 | 13488 | 102 |
1535372 | 1535372 | 2021-07-20 | Olmsted | Minnesota | 27109 | 13485 | 102 |
1532124 | 1532124 | 2021-07-19 | Olmsted | Minnesota | 27109 | 13474 | 102 |
1528877 | 1528877 | 2021-07-18 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1525630 | 1525630 | 2021-07-17 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1522383 | 1522383 | 2021-07-16 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1519134 | 1519134 | 2021-07-15 | Olmsted | Minnesota | 27109 | 13467 | 102 |
1515887 | 1515887 | 2021-07-14 | Olmsted | Minnesota | 27109 | 13467 | 102 |
1512641 | 1512641 | 2021-07-13 | Olmsted | Minnesota | 27109 | 13466 | 102 |
1509394 | 1509394 | 2021-07-12 | Olmsted | Minnesota | 27109 | 13449 | 102 |
1506148 | 1506148 | 2021-07-11 | Olmsted | Minnesota | 27109 | 13447 | 102 |
1502902 | 1502902 | 2021-07-10 | Olmsted | Minnesota | 27109 | 13447 | 102 |
1499656 | 1499656 | 2021-07-09 | Olmsted | Minnesota | 27109 | 13447 | 102 |
1496410 | 1496410 | 2021-07-08 | Olmsted | Minnesota | 27109 | 13443 | 102 |
1493163 | 1493163 | 2021-07-07 | Olmsted | Minnesota | 27109 | 13438 | 102 |
1489916 | 1489916 | 2021-07-06 | Olmsted | Minnesota | 27109 | 13433 | 102 |
1486669 | 1486669 | 2021-07-05 | Olmsted | Minnesota | 27109 | 13427 | 102 |
1483423 | 1483423 | 2021-07-04 | Olmsted | Minnesota | 27109 | 13427 | 102 |
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);