ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where deaths = 82 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2129978 | 2129978 | 2022-01-19 | Carlton | Minnesota | 27017 | 6613 | 82 |
2126724 | 2126724 | 2022-01-18 | Carlton | Minnesota | 27017 | 6475 | 82 |
2123466 | 2123466 | 2022-01-17 | Becker | Minnesota | 27005 | 6953 | 82 |
2123472 | 2123472 | 2022-01-17 | Carlton | Minnesota | 27017 | 6431 | 82 |
2120214 | 2120214 | 2022-01-16 | Becker | Minnesota | 27005 | 6953 | 82 |
2120220 | 2120220 | 2022-01-16 | Carlton | Minnesota | 27017 | 6431 | 82 |
2116962 | 2116962 | 2022-01-15 | Becker | Minnesota | 27005 | 6953 | 82 |
2116968 | 2116968 | 2022-01-15 | Carlton | Minnesota | 27017 | 6431 | 82 |
2113711 | 2113711 | 2022-01-14 | Becker | Minnesota | 27005 | 6953 | 82 |
2113717 | 2113717 | 2022-01-14 | Carlton | Minnesota | 27017 | 6431 | 82 |
2110459 | 2110459 | 2022-01-13 | Becker | Minnesota | 27005 | 6915 | 82 |
2110465 | 2110465 | 2022-01-13 | Carlton | Minnesota | 27017 | 6406 | 82 |
2107214 | 2107214 | 2022-01-12 | Carlton | Minnesota | 27017 | 6361 | 82 |
2081200 | 2081200 | 2022-01-04 | Blue Earth | Minnesota | 27013 | 12945 | 82 |
2077948 | 2077948 | 2022-01-03 | Blue Earth | Minnesota | 27013 | 12764 | 82 |
2074697 | 2074697 | 2022-01-02 | Blue Earth | Minnesota | 27013 | 12732 | 82 |
2071446 | 2071446 | 2022-01-01 | Blue Earth | Minnesota | 27013 | 12732 | 82 |
2068195 | 2068195 | 2021-12-31 | Blue Earth | Minnesota | 27013 | 12732 | 82 |
2064944 | 2064944 | 2021-12-30 | Blue Earth | Minnesota | 27013 | 12732 | 82 |
2006482 | 2006482 | 2021-12-12 | Morrison | Minnesota | 27097 | 6924 | 82 |
2003231 | 2003231 | 2021-12-11 | Morrison | Minnesota | 27097 | 6924 | 82 |
1999981 | 1999981 | 2021-12-10 | Morrison | Minnesota | 27097 | 6924 | 82 |
1996730 | 1996730 | 2021-12-09 | Morrison | Minnesota | 27097 | 6909 | 82 |
1993443 | 1993443 | 2021-12-08 | Chisago | Minnesota | 27025 | 10265 | 82 |
1993479 | 1993479 | 2021-12-08 | Morrison | Minnesota | 27097 | 6895 | 82 |
1990228 | 1990228 | 2021-12-07 | Morrison | Minnesota | 27097 | 6875 | 82 |
1986978 | 1986978 | 2021-12-06 | Morrison | Minnesota | 27097 | 6820 | 82 |
1938217 | 1938217 | 2021-11-21 | McLeod | Minnesota | 27085 | 6794 | 82 |
1934967 | 1934967 | 2021-11-20 | McLeod | Minnesota | 27085 | 6794 | 82 |
1931717 | 1931717 | 2021-11-19 | McLeod | Minnesota | 27085 | 6794 | 82 |
1928466 | 1928466 | 2021-11-18 | McLeod | Minnesota | 27085 | 6752 | 82 |
1925216 | 1925216 | 2021-11-17 | McLeod | Minnesota | 27085 | 6711 | 82 |
1921967 | 1921967 | 2021-11-16 | McLeod | Minnesota | 27085 | 6699 | 82 |
1918717 | 1918717 | 2021-11-15 | McLeod | Minnesota | 27085 | 6598 | 82 |
1915467 | 1915467 | 2021-11-14 | McLeod | Minnesota | 27085 | 6585 | 82 |
1912217 | 1912217 | 2021-11-13 | McLeod | Minnesota | 27085 | 6585 | 82 |
1908967 | 1908967 | 2021-11-12 | McLeod | Minnesota | 27085 | 6585 | 82 |
1905732 | 1905732 | 2021-11-11 | Polk | Minnesota | 27119 | 5611 | 82 |
1902483 | 1902483 | 2021-11-10 | Polk | Minnesota | 27119 | 5565 | 82 |
1899233 | 1899233 | 2021-11-09 | Polk | Minnesota | 27119 | 5539 | 82 |
1895983 | 1895983 | 2021-11-08 | Polk | Minnesota | 27119 | 5497 | 82 |
1892733 | 1892733 | 2021-11-07 | Polk | Minnesota | 27119 | 5478 | 82 |
1889483 | 1889483 | 2021-11-06 | Polk | Minnesota | 27119 | 5478 | 82 |
1886233 | 1886233 | 2021-11-05 | Polk | Minnesota | 27119 | 5478 | 82 |
1860185 | 1860185 | 2021-10-28 | Beltrami | Minnesota | 27007 | 6769 | 82 |
1856936 | 1856936 | 2021-10-27 | Beltrami | Minnesota | 27007 | 6727 | 82 |
1837466 | 1837466 | 2021-10-21 | Itasca | Minnesota | 27061 | 6153 | 82 |
1834217 | 1834217 | 2021-10-20 | Itasca | Minnesota | 27061 | 6129 | 82 |
1814717 | 1814717 | 2021-10-14 | Goodhue | Minnesota | 27049 | 5993 | 82 |
1811469 | 1811469 | 2021-10-13 | Goodhue | Minnesota | 27049 | 5955 | 82 |
1808220 | 1808220 | 2021-10-12 | Goodhue | Minnesota | 27049 | 5933 | 82 |
1804969 | 1804969 | 2021-10-11 | Goodhue | Minnesota | 27049 | 5879 | 82 |
1801720 | 1801720 | 2021-10-10 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1798471 | 1798471 | 2021-10-09 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1795222 | 1795222 | 2021-10-08 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1791973 | 1791973 | 2021-10-07 | Goodhue | Minnesota | 27049 | 5832 | 82 |
1788724 | 1788724 | 2021-10-06 | Goodhue | Minnesota | 27049 | 5817 | 82 |
1785476 | 1785476 | 2021-10-05 | Goodhue | Minnesota | 27049 | 5797 | 82 |
1632779 | 1632779 | 2021-08-19 | Douglas | Minnesota | 27041 | 4962 | 82 |
1399038 | 1399038 | 2021-06-08 | Otter Tail | Minnesota | 27111 | 5847 | 82 |
1395792 | 1395792 | 2021-06-07 | Otter Tail | Minnesota | 27111 | 5847 | 82 |
1392546 | 1392546 | 2021-06-06 | Otter Tail | Minnesota | 27111 | 5846 | 82 |
1389301 | 1389301 | 2021-06-05 | Otter Tail | Minnesota | 27111 | 5846 | 82 |
1295134 | 1295134 | 2021-05-07 | Kandiyohi | Minnesota | 27067 | 6491 | 82 |
1291888 | 1291888 | 2021-05-06 | Kandiyohi | Minnesota | 27067 | 6482 | 82 |
1288642 | 1288642 | 2021-05-05 | Kandiyohi | Minnesota | 27067 | 6472 | 82 |
1275692 | 1275692 | 2021-05-01 | Sherburne | Minnesota | 27141 | 11285 | 82 |
1103536 | 1103536 | 2021-03-09 | Crow Wing | Minnesota | 27035 | 5241 | 82 |
1100290 | 1100290 | 2021-03-08 | Crow Wing | Minnesota | 27035 | 5240 | 82 |
1097043 | 1097043 | 2021-03-07 | Crow Wing | Minnesota | 27035 | 5236 | 82 |
1093796 | 1093796 | 2021-03-06 | Crow Wing | Minnesota | 27035 | 5235 | 82 |
1090550 | 1090550 | 2021-03-05 | Crow Wing | Minnesota | 27035 | 5227 | 82 |
1087305 | 1087305 | 2021-03-04 | Crow Wing | Minnesota | 27035 | 5223 | 82 |
1084060 | 1084060 | 2021-03-03 | Crow Wing | Minnesota | 27035 | 5212 | 82 |
1009460 | 1009460 | 2021-02-08 | Rice | Minnesota | 27131 | 6510 | 82 |
1006213 | 1006213 | 2021-02-07 | Rice | Minnesota | 27131 | 6506 | 82 |
1002967 | 1002967 | 2021-02-06 | Rice | Minnesota | 27131 | 6487 | 82 |
999722 | 999722 | 2021-02-05 | Rice | Minnesota | 27131 | 6475 | 82 |
996476 | 996476 | 2021-02-04 | Rice | Minnesota | 27131 | 6452 | 82 |
993230 | 993230 | 2021-02-03 | Rice | Minnesota | 27131 | 6419 | 82 |
954231 | 954231 | 2021-01-22 | Clay | Minnesota | 27027 | 6555 | 82 |
899052 | 899052 | 2021-01-05 | Benton | Minnesota | 27009 | 4004 | 82 |
895807 | 895807 | 2021-01-04 | Benton | Minnesota | 27009 | 3991 | 82 |
892560 | 892560 | 2021-01-03 | Benton | Minnesota | 27009 | 3948 | 82 |
866680 | 866680 | 2020-12-26 | Wright | Minnesota | 27171 | 10614 | 82 |
727112 | 727112 | 2020-11-13 | St. Louis | Minnesota | 27137 | 5216 | 82 |
260140 | 260140 | 2020-06-21 | Dakota | Minnesota | 27037 | 1915 | 82 |
216614 | 216614 | 2020-06-07 | Anoka | Minnesota | 27003 | 1585 | 82 |
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);