ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,985 rows where deaths = 3 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wabasha 220
- Wilkin 171
- Dodge 167
- Lincoln 134
- Benton 132
- Mille Lacs 84
- Big Stone 82
- Lake of the Woods 80
- Sibley 80
- Koochiching 71
- Murray 61
- Lyon 57
- Red Lake 50
- Cass 44
- Lac qui Parle 42
- Polk 29
- Douglas 27
- Brown 25
- Mower 25
- Meeker 23
- Chippewa 22
- Pope 20
- Traverse 20
- McLeod 16
- Otter Tail 14
- Rice 14
- Mahnomen 13
- Morrison 13
- Kandiyohi 12
- Carver 11
- …
state 1
- Minnesota · 1,985 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2221075 | 2221075 | 2022-02-16 | Cook | Minnesota | 27031 | 531 | 3 |
2217824 | 2217824 | 2022-02-15 | Cook | Minnesota | 27031 | 531 | 3 |
2214573 | 2214573 | 2022-02-14 | Cook | Minnesota | 27031 | 527 | 3 |
2211321 | 2211321 | 2022-02-13 | Cook | Minnesota | 27031 | 521 | 3 |
2208068 | 2208068 | 2022-02-12 | Cook | Minnesota | 27031 | 521 | 3 |
2204815 | 2204815 | 2022-02-11 | Cook | Minnesota | 27031 | 521 | 3 |
2201562 | 2201562 | 2022-02-10 | Cook | Minnesota | 27031 | 519 | 3 |
1720487 | 1720487 | 2021-09-15 | Dodge | Minnesota | 27039 | 2383 | 3 |
1717239 | 1717239 | 2021-09-14 | Dodge | Minnesota | 27039 | 2369 | 3 |
1713991 | 1713991 | 2021-09-13 | Dodge | Minnesota | 27039 | 2343 | 3 |
1710745 | 1710745 | 2021-09-12 | Dodge | Minnesota | 27039 | 2338 | 3 |
1707498 | 1707498 | 2021-09-11 | Dodge | Minnesota | 27039 | 2338 | 3 |
1704251 | 1704251 | 2021-09-10 | Dodge | Minnesota | 27039 | 2338 | 3 |
1701001 | 1701001 | 2021-09-09 | Dodge | Minnesota | 27039 | 2316 | 3 |
1697752 | 1697752 | 2021-09-08 | Dodge | Minnesota | 27039 | 2311 | 3 |
1694504 | 1694504 | 2021-09-07 | Dodge | Minnesota | 27039 | 2273 | 3 |
1691255 | 1691255 | 2021-09-06 | Dodge | Minnesota | 27039 | 2265 | 3 |
1688005 | 1688005 | 2021-09-05 | Dodge | Minnesota | 27039 | 2265 | 3 |
1684755 | 1684755 | 2021-09-04 | Dodge | Minnesota | 27039 | 2265 | 3 |
1681504 | 1681504 | 2021-09-03 | Dodge | Minnesota | 27039 | 2265 | 3 |
1678256 | 1678256 | 2021-09-02 | Dodge | Minnesota | 27039 | 2245 | 3 |
1675008 | 1675008 | 2021-09-01 | Dodge | Minnesota | 27039 | 2213 | 3 |
1675029 | 1675029 | 2021-09-01 | Lincoln | Minnesota | 27081 | 609 | 3 |
1671760 | 1671760 | 2021-08-31 | Dodge | Minnesota | 27039 | 2204 | 3 |
1671781 | 1671781 | 2021-08-31 | Lincoln | Minnesota | 27081 | 606 | 3 |
1668513 | 1668513 | 2021-08-30 | Dodge | Minnesota | 27039 | 2172 | 3 |
1668534 | 1668534 | 2021-08-30 | Lincoln | Minnesota | 27081 | 606 | 3 |
1665266 | 1665266 | 2021-08-29 | Dodge | Minnesota | 27039 | 2153 | 3 |
1665287 | 1665287 | 2021-08-29 | Lincoln | Minnesota | 27081 | 605 | 3 |
1662018 | 1662018 | 2021-08-28 | Dodge | Minnesota | 27039 | 2153 | 3 |
1662039 | 1662039 | 2021-08-28 | Lincoln | Minnesota | 27081 | 605 | 3 |
1658770 | 1658770 | 2021-08-27 | Dodge | Minnesota | 27039 | 2153 | 3 |
1658791 | 1658791 | 2021-08-27 | Lincoln | Minnesota | 27081 | 605 | 3 |
1655521 | 1655521 | 2021-08-26 | Dodge | Minnesota | 27039 | 2137 | 3 |
1655542 | 1655542 | 2021-08-26 | Lincoln | Minnesota | 27081 | 604 | 3 |
1652274 | 1652274 | 2021-08-25 | Dodge | Minnesota | 27039 | 2122 | 3 |
1652295 | 1652295 | 2021-08-25 | Lincoln | Minnesota | 27081 | 601 | 3 |
1649026 | 1649026 | 2021-08-24 | Dodge | Minnesota | 27039 | 2120 | 3 |
1649047 | 1649047 | 2021-08-24 | Lincoln | Minnesota | 27081 | 601 | 3 |
1645777 | 1645777 | 2021-08-23 | Dodge | Minnesota | 27039 | 2079 | 3 |
1645798 | 1645798 | 2021-08-23 | Lincoln | Minnesota | 27081 | 599 | 3 |
1645837 | 1645837 | 2021-08-23 | Wabasha | Minnesota | 27157 | 2156 | 3 |
1642528 | 1642528 | 2021-08-22 | Dodge | Minnesota | 27039 | 2068 | 3 |
1642549 | 1642549 | 2021-08-22 | Lincoln | Minnesota | 27081 | 599 | 3 |
1642588 | 1642588 | 2021-08-22 | Wabasha | Minnesota | 27157 | 2154 | 3 |
1639278 | 1639278 | 2021-08-21 | Dodge | Minnesota | 27039 | 2068 | 3 |
1639299 | 1639299 | 2021-08-21 | Lincoln | Minnesota | 27081 | 599 | 3 |
1639338 | 1639338 | 2021-08-21 | Wabasha | Minnesota | 27157 | 2154 | 3 |
1636028 | 1636028 | 2021-08-20 | Dodge | Minnesota | 27039 | 2068 | 3 |
1636049 | 1636049 | 2021-08-20 | Lincoln | Minnesota | 27081 | 599 | 3 |
1636088 | 1636088 | 2021-08-20 | Wabasha | Minnesota | 27157 | 2154 | 3 |
1632778 | 1632778 | 2021-08-19 | Dodge | Minnesota | 27039 | 2051 | 3 |
1632799 | 1632799 | 2021-08-19 | Lincoln | Minnesota | 27081 | 599 | 3 |
1632838 | 1632838 | 2021-08-19 | Wabasha | Minnesota | 27157 | 2144 | 3 |
1629531 | 1629531 | 2021-08-18 | Dodge | Minnesota | 27039 | 2044 | 3 |
1629552 | 1629552 | 2021-08-18 | Lincoln | Minnesota | 27081 | 598 | 3 |
1629591 | 1629591 | 2021-08-18 | Wabasha | Minnesota | 27157 | 2142 | 3 |
1626284 | 1626284 | 2021-08-17 | Dodge | Minnesota | 27039 | 2042 | 3 |
1626305 | 1626305 | 2021-08-17 | Lincoln | Minnesota | 27081 | 598 | 3 |
1626344 | 1626344 | 2021-08-17 | Wabasha | Minnesota | 27157 | 2141 | 3 |
1623037 | 1623037 | 2021-08-16 | Dodge | Minnesota | 27039 | 2015 | 3 |
1623058 | 1623058 | 2021-08-16 | Lincoln | Minnesota | 27081 | 598 | 3 |
1623097 | 1623097 | 2021-08-16 | Wabasha | Minnesota | 27157 | 2131 | 3 |
1619790 | 1619790 | 2021-08-15 | Dodge | Minnesota | 27039 | 2003 | 3 |
1619811 | 1619811 | 2021-08-15 | Lincoln | Minnesota | 27081 | 598 | 3 |
1619850 | 1619850 | 2021-08-15 | Wabasha | Minnesota | 27157 | 2127 | 3 |
1616542 | 1616542 | 2021-08-14 | Dodge | Minnesota | 27039 | 2003 | 3 |
1616563 | 1616563 | 2021-08-14 | Lincoln | Minnesota | 27081 | 598 | 3 |
1616602 | 1616602 | 2021-08-14 | Wabasha | Minnesota | 27157 | 2127 | 3 |
1613294 | 1613294 | 2021-08-13 | Dodge | Minnesota | 27039 | 2003 | 3 |
1613315 | 1613315 | 2021-08-13 | Lincoln | Minnesota | 27081 | 598 | 3 |
1613354 | 1613354 | 2021-08-13 | Wabasha | Minnesota | 27157 | 2127 | 3 |
1610045 | 1610045 | 2021-08-12 | Dodge | Minnesota | 27039 | 1999 | 3 |
1610066 | 1610066 | 2021-08-12 | Lincoln | Minnesota | 27081 | 596 | 3 |
1610105 | 1610105 | 2021-08-12 | Wabasha | Minnesota | 27157 | 2119 | 3 |
1606797 | 1606797 | 2021-08-11 | Dodge | Minnesota | 27039 | 1996 | 3 |
1606818 | 1606818 | 2021-08-11 | Lincoln | Minnesota | 27081 | 595 | 3 |
1606857 | 1606857 | 2021-08-11 | Wabasha | Minnesota | 27157 | 2112 | 3 |
1603548 | 1603548 | 2021-08-10 | Dodge | Minnesota | 27039 | 1983 | 3 |
1603569 | 1603569 | 2021-08-10 | Lincoln | Minnesota | 27081 | 595 | 3 |
1603608 | 1603608 | 2021-08-10 | Wabasha | Minnesota | 27157 | 2110 | 3 |
1600299 | 1600299 | 2021-08-09 | Dodge | Minnesota | 27039 | 1964 | 3 |
1600320 | 1600320 | 2021-08-09 | Lincoln | Minnesota | 27081 | 594 | 3 |
1600359 | 1600359 | 2021-08-09 | Wabasha | Minnesota | 27157 | 2101 | 3 |
1597051 | 1597051 | 2021-08-08 | Dodge | Minnesota | 27039 | 1957 | 3 |
1597072 | 1597072 | 2021-08-08 | Lincoln | Minnesota | 27081 | 594 | 3 |
1597111 | 1597111 | 2021-08-08 | Wabasha | Minnesota | 27157 | 2099 | 3 |
1593802 | 1593802 | 2021-08-07 | Dodge | Minnesota | 27039 | 1957 | 3 |
1593823 | 1593823 | 2021-08-07 | Lincoln | Minnesota | 27081 | 594 | 3 |
1593862 | 1593862 | 2021-08-07 | Wabasha | Minnesota | 27157 | 2099 | 3 |
1590553 | 1590553 | 2021-08-06 | Dodge | Minnesota | 27039 | 1957 | 3 |
1590574 | 1590574 | 2021-08-06 | Lincoln | Minnesota | 27081 | 594 | 3 |
1590613 | 1590613 | 2021-08-06 | Wabasha | Minnesota | 27157 | 2099 | 3 |
1587304 | 1587304 | 2021-08-05 | Dodge | Minnesota | 27039 | 1949 | 3 |
1587325 | 1587325 | 2021-08-05 | Lincoln | Minnesota | 27081 | 591 | 3 |
1587364 | 1587364 | 2021-08-05 | Wabasha | Minnesota | 27157 | 2098 | 3 |
1584053 | 1584053 | 2021-08-04 | Dodge | Minnesota | 27039 | 1939 | 3 |
1584074 | 1584074 | 2021-08-04 | Lincoln | Minnesota | 27081 | 590 | 3 |
1584113 | 1584113 | 2021-08-04 | Wabasha | Minnesota | 27157 | 2096 | 3 |
1580804 | 1580804 | 2021-08-03 | Dodge | Minnesota | 27039 | 1938 | 3 |
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);