ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
293 rows where deaths = 36 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2312140 | 2312140 | 2022-03-16 | Koochiching | Minnesota | 27071 | 2691 | 36 |
2195095 | 2195095 | 2022-02-08 | Pennington | Minnesota | 27113 | 3322 | 36 |
2191841 | 2191841 | 2022-02-07 | Pennington | Minnesota | 27113 | 3295 | 36 |
2188588 | 2188588 | 2022-02-06 | Pennington | Minnesota | 27113 | 3281 | 36 |
2185335 | 2185335 | 2022-02-05 | Pennington | Minnesota | 27113 | 3281 | 36 |
2182083 | 2182083 | 2022-02-04 | Pennington | Minnesota | 27113 | 3281 | 36 |
2178831 | 2178831 | 2022-02-03 | Pennington | Minnesota | 27113 | 3263 | 36 |
2175579 | 2175579 | 2022-02-02 | Pennington | Minnesota | 27113 | 3246 | 36 |
2172326 | 2172326 | 2022-02-01 | Pennington | Minnesota | 27113 | 3235 | 36 |
2152826 | 2152826 | 2022-01-26 | Waseca | Minnesota | 27161 | 4869 | 36 |
2149574 | 2149574 | 2022-01-25 | Waseca | Minnesota | 27161 | 4817 | 36 |
2146322 | 2146322 | 2022-01-24 | Waseca | Minnesota | 27161 | 4709 | 36 |
2143067 | 2143067 | 2022-01-23 | Waseca | Minnesota | 27161 | 4678 | 36 |
2139812 | 2139812 | 2022-01-22 | Waseca | Minnesota | 27161 | 4678 | 36 |
2136556 | 2136556 | 2022-01-21 | Waseca | Minnesota | 27161 | 4678 | 36 |
2133304 | 2133304 | 2022-01-20 | Waseca | Minnesota | 27161 | 4643 | 36 |
2130051 | 2130051 | 2022-01-19 | Waseca | Minnesota | 27161 | 4613 | 36 |
2126797 | 2126797 | 2022-01-18 | Waseca | Minnesota | 27161 | 4522 | 36 |
2123545 | 2123545 | 2022-01-17 | Waseca | Minnesota | 27161 | 4506 | 36 |
2120293 | 2120293 | 2022-01-16 | Waseca | Minnesota | 27161 | 4506 | 36 |
2117041 | 2117041 | 2022-01-15 | Waseca | Minnesota | 27161 | 4506 | 36 |
2113790 | 2113790 | 2022-01-14 | Waseca | Minnesota | 27161 | 4506 | 36 |
2110473 | 2110473 | 2022-01-13 | Cottonwood | Minnesota | 27033 | 2622 | 36 |
2110538 | 2110538 | 2022-01-13 | Waseca | Minnesota | 27161 | 4470 | 36 |
2058506 | 2058506 | 2021-12-28 | Roseau | Minnesota | 27135 | 3393 | 36 |
2055257 | 2055257 | 2021-12-27 | Roseau | Minnesota | 27135 | 3382 | 36 |
2019458 | 2019458 | 2021-12-16 | Faribault | Minnesota | 27043 | 2737 | 36 |
2016208 | 2016208 | 2021-12-15 | Faribault | Minnesota | 27043 | 2723 | 36 |
2012957 | 2012957 | 2021-12-14 | Faribault | Minnesota | 27043 | 2720 | 36 |
2009706 | 2009706 | 2021-12-13 | Faribault | Minnesota | 27043 | 2703 | 36 |
2009724 | 2009724 | 2021-12-13 | Le Sueur | Minnesota | 27079 | 4846 | 36 |
2006455 | 2006455 | 2021-12-12 | Faribault | Minnesota | 27043 | 2693 | 36 |
2006473 | 2006473 | 2021-12-12 | Le Sueur | Minnesota | 27079 | 4827 | 36 |
2003204 | 2003204 | 2021-12-11 | Faribault | Minnesota | 27043 | 2693 | 36 |
2003222 | 2003222 | 2021-12-11 | Le Sueur | Minnesota | 27079 | 4827 | 36 |
1999954 | 1999954 | 2021-12-10 | Faribault | Minnesota | 27043 | 2693 | 36 |
1999972 | 1999972 | 2021-12-10 | Le Sueur | Minnesota | 27079 | 4827 | 36 |
1996703 | 1996703 | 2021-12-09 | Faribault | Minnesota | 27043 | 2677 | 36 |
1996721 | 1996721 | 2021-12-09 | Le Sueur | Minnesota | 27079 | 4806 | 36 |
1993452 | 1993452 | 2021-12-08 | Faribault | Minnesota | 27043 | 2675 | 36 |
1993470 | 1993470 | 2021-12-08 | Le Sueur | Minnesota | 27079 | 4780 | 36 |
1990219 | 1990219 | 2021-12-07 | Le Sueur | Minnesota | 27079 | 4765 | 36 |
1986969 | 1986969 | 2021-12-06 | Le Sueur | Minnesota | 27079 | 4683 | 36 |
1983719 | 1983719 | 2021-12-05 | Le Sueur | Minnesota | 27079 | 4647 | 36 |
1980469 | 1980469 | 2021-12-04 | Le Sueur | Minnesota | 27079 | 4647 | 36 |
1977219 | 1977219 | 2021-12-03 | Le Sueur | Minnesota | 27079 | 4647 | 36 |
1970713 | 1970713 | 2021-12-01 | Kanabec | Minnesota | 27065 | 2501 | 36 |
1967463 | 1967463 | 2021-11-30 | Kanabec | Minnesota | 27065 | 2481 | 36 |
1964211 | 1964211 | 2021-11-29 | Kanabec | Minnesota | 27065 | 2444 | 36 |
1960960 | 1960960 | 2021-11-28 | Kanabec | Minnesota | 27065 | 2415 | 36 |
1957709 | 1957709 | 2021-11-27 | Kanabec | Minnesota | 27065 | 2415 | 36 |
1954458 | 1954458 | 2021-11-26 | Kanabec | Minnesota | 27065 | 2415 | 36 |
1928501 | 1928501 | 2021-11-18 | Wadena | Minnesota | 27159 | 2903 | 36 |
1895981 | 1895981 | 2021-11-08 | Pine | Minnesota | 27115 | 4549 | 36 |
1892731 | 1892731 | 2021-11-07 | Pine | Minnesota | 27115 | 4523 | 36 |
1889481 | 1889481 | 2021-11-06 | Pine | Minnesota | 27115 | 4523 | 36 |
1886231 | 1886231 | 2021-11-05 | Pine | Minnesota | 27115 | 4523 | 36 |
1853760 | 1853760 | 2021-10-26 | Todd | Minnesota | 27153 | 4097 | 36 |
1850479 | 1850479 | 2021-10-25 | Martin | Minnesota | 27091 | 3272 | 36 |
1850511 | 1850511 | 2021-10-25 | Todd | Minnesota | 27153 | 4053 | 36 |
1847229 | 1847229 | 2021-10-24 | Martin | Minnesota | 27091 | 3263 | 36 |
1847261 | 1847261 | 2021-10-24 | Todd | Minnesota | 27153 | 4000 | 36 |
1843979 | 1843979 | 2021-10-23 | Martin | Minnesota | 27091 | 3263 | 36 |
1844011 | 1844011 | 2021-10-23 | Todd | Minnesota | 27153 | 4000 | 36 |
1840729 | 1840729 | 2021-10-22 | Martin | Minnesota | 27091 | 3263 | 36 |
1840761 | 1840761 | 2021-10-22 | Todd | Minnesota | 27153 | 4000 | 36 |
1837480 | 1837480 | 2021-10-21 | Martin | Minnesota | 27091 | 3262 | 36 |
1837512 | 1837512 | 2021-10-21 | Todd | Minnesota | 27153 | 3988 | 36 |
1834231 | 1834231 | 2021-10-20 | Martin | Minnesota | 27091 | 3239 | 36 |
1834263 | 1834263 | 2021-10-20 | Todd | Minnesota | 27153 | 3981 | 36 |
1831014 | 1831014 | 2021-10-19 | Todd | Minnesota | 27153 | 3973 | 36 |
1827765 | 1827765 | 2021-10-18 | Todd | Minnesota | 27153 | 3918 | 36 |
1824516 | 1824516 | 2021-10-17 | Todd | Minnesota | 27153 | 3893 | 36 |
1821267 | 1821267 | 2021-10-16 | Todd | Minnesota | 27153 | 3893 | 36 |
1818018 | 1818018 | 2021-10-15 | Todd | Minnesota | 27153 | 3893 | 36 |
1814769 | 1814769 | 2021-10-14 | Todd | Minnesota | 27153 | 3842 | 36 |
1811521 | 1811521 | 2021-10-13 | Todd | Minnesota | 27153 | 3807 | 36 |
1808272 | 1808272 | 2021-10-12 | Todd | Minnesota | 27153 | 3778 | 36 |
1805021 | 1805021 | 2021-10-11 | Todd | Minnesota | 27153 | 3696 | 36 |
1801772 | 1801772 | 2021-10-10 | Todd | Minnesota | 27153 | 3656 | 36 |
1798523 | 1798523 | 2021-10-09 | Todd | Minnesota | 27153 | 3656 | 36 |
1795274 | 1795274 | 2021-10-08 | Todd | Minnesota | 27153 | 3656 | 36 |
1792025 | 1792025 | 2021-10-07 | Todd | Minnesota | 27153 | 3613 | 36 |
1756219 | 1756219 | 2021-09-26 | Cass | Minnesota | 27021 | 3555 | 36 |
1752971 | 1752971 | 2021-09-25 | Cass | Minnesota | 27021 | 3555 | 36 |
1749723 | 1749723 | 2021-09-24 | Cass | Minnesota | 27021 | 3555 | 36 |
1746473 | 1746473 | 2021-09-23 | Cass | Minnesota | 27021 | 3526 | 36 |
1717269 | 1717269 | 2021-09-14 | Mower | Minnesota | 27099 | 5482 | 36 |
1610049 | 1610049 | 2021-08-12 | Freeborn | Minnesota | 27047 | 3635 | 36 |
1606801 | 1606801 | 2021-08-11 | Freeborn | Minnesota | 27047 | 3625 | 36 |
1603552 | 1603552 | 2021-08-10 | Freeborn | Minnesota | 27047 | 3614 | 36 |
1600303 | 1600303 | 2021-08-09 | Freeborn | Minnesota | 27047 | 3596 | 36 |
1402228 | 1402228 | 2021-06-09 | Aitkin | Minnesota | 27001 | 1380 | 36 |
1398983 | 1398983 | 2021-06-08 | Aitkin | Minnesota | 27001 | 1380 | 36 |
1395737 | 1395737 | 2021-06-07 | Aitkin | Minnesota | 27001 | 1380 | 36 |
1392491 | 1392491 | 2021-06-06 | Aitkin | Minnesota | 27001 | 1379 | 36 |
1389246 | 1389246 | 2021-06-05 | Aitkin | Minnesota | 27001 | 1378 | 36 |
1386001 | 1386001 | 2021-06-04 | Aitkin | Minnesota | 27001 | 1378 | 36 |
1382756 | 1382756 | 2021-06-03 | Aitkin | Minnesota | 27001 | 1371 | 36 |
1379510 | 1379510 | 2021-06-02 | Aitkin | Minnesota | 27001 | 1370 | 36 |
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);