ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,385 rows where deaths = 5 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Traverse 270
- Lincoln 125
- Lake of the Woods 98
- Martin 91
- Pope 63
- Murray 49
- Big Stone 42
- Wright 41
- Blue Earth 37
- Red Lake 34
- Koochiching 33
- Freeborn 31
- Wilkin 30
- Sherburne 27
- Wabasha 27
- Renville 24
- Cass 22
- Beltrami 21
- Le Sueur 20
- Grant 18
- Kandiyohi 16
- Dodge 13
- Sibley 13
- Stevens 13
- Watonwan 13
- Nobles 11
- Cottonwood 10
- Brown 9
- Yellow Medicine 9
- Isanti 8
- …
state 1
- Minnesota · 1,385 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2240604 | 2240604 | 2022-02-22 | Lake of the Woods | Minnesota | 27077 | 740 | 5 |
2237353 | 2237353 | 2022-02-21 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2234102 | 2234102 | 2022-02-20 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2230851 | 2230851 | 2022-02-19 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2227600 | 2227600 | 2022-02-18 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2224349 | 2224349 | 2022-02-17 | Lake of the Woods | Minnesota | 27077 | 738 | 5 |
2221098 | 2221098 | 2022-02-16 | Lake of the Woods | Minnesota | 27077 | 737 | 5 |
2217847 | 2217847 | 2022-02-15 | Lake of the Woods | Minnesota | 27077 | 735 | 5 |
2214596 | 2214596 | 2022-02-14 | Lake of the Woods | Minnesota | 27077 | 733 | 5 |
2211344 | 2211344 | 2022-02-13 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2208091 | 2208091 | 2022-02-12 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2204838 | 2204838 | 2022-02-11 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2201585 | 2201585 | 2022-02-10 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2198331 | 2198331 | 2022-02-09 | Lake of the Woods | Minnesota | 27077 | 723 | 5 |
2198333 | 2198333 | 2022-02-09 | Lincoln | Minnesota | 27081 | 1184 | 5 |
2195077 | 2195077 | 2022-02-08 | Lake of the Woods | Minnesota | 27077 | 719 | 5 |
2195079 | 2195079 | 2022-02-08 | Lincoln | Minnesota | 27081 | 1180 | 5 |
2191823 | 2191823 | 2022-02-07 | Lake of the Woods | Minnesota | 27077 | 716 | 5 |
2191825 | 2191825 | 2022-02-07 | Lincoln | Minnesota | 27081 | 1173 | 5 |
2188570 | 2188570 | 2022-02-06 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2188572 | 2188572 | 2022-02-06 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2185317 | 2185317 | 2022-02-05 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2185319 | 2185319 | 2022-02-05 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2182065 | 2182065 | 2022-02-04 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2182067 | 2182067 | 2022-02-04 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2178813 | 2178813 | 2022-02-03 | Lake of the Woods | Minnesota | 27077 | 708 | 5 |
2178815 | 2178815 | 2022-02-03 | Lincoln | Minnesota | 27081 | 1167 | 5 |
2175561 | 2175561 | 2022-02-02 | Lake of the Woods | Minnesota | 27077 | 700 | 5 |
2175563 | 2175563 | 2022-02-02 | Lincoln | Minnesota | 27081 | 1165 | 5 |
2172308 | 2172308 | 2022-02-01 | Lake of the Woods | Minnesota | 27077 | 700 | 5 |
2172310 | 2172310 | 2022-02-01 | Lincoln | Minnesota | 27081 | 1163 | 5 |
2169055 | 2169055 | 2022-01-31 | Lake of the Woods | Minnesota | 27077 | 685 | 5 |
2169057 | 2169057 | 2022-01-31 | Lincoln | Minnesota | 27081 | 1145 | 5 |
2165800 | 2165800 | 2022-01-30 | Lake of the Woods | Minnesota | 27077 | 678 | 5 |
2165802 | 2165802 | 2022-01-30 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2162545 | 2162545 | 2022-01-29 | Lake of the Woods | Minnesota | 27077 | 678 | 5 |
2162547 | 2162547 | 2022-01-29 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2159290 | 2159290 | 2022-01-28 | Lake of the Woods | Minnesota | 27077 | 678 | 5 |
2159292 | 2159292 | 2022-01-28 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2156036 | 2156036 | 2022-01-27 | Lake of the Woods | Minnesota | 27077 | 674 | 5 |
2156038 | 2156038 | 2022-01-27 | Lincoln | Minnesota | 27081 | 1129 | 5 |
2152783 | 2152783 | 2022-01-26 | Lake of the Woods | Minnesota | 27077 | 663 | 5 |
2152785 | 2152785 | 2022-01-26 | Lincoln | Minnesota | 27081 | 1111 | 5 |
2149531 | 2149531 | 2022-01-25 | Lake of the Woods | Minnesota | 27077 | 661 | 5 |
2149533 | 2149533 | 2022-01-25 | Lincoln | Minnesota | 27081 | 1102 | 5 |
2146279 | 2146279 | 2022-01-24 | Lake of the Woods | Minnesota | 27077 | 648 | 5 |
2146281 | 2146281 | 2022-01-24 | Lincoln | Minnesota | 27081 | 1075 | 5 |
2143024 | 2143024 | 2022-01-23 | Lake of the Woods | Minnesota | 27077 | 646 | 5 |
2143026 | 2143026 | 2022-01-23 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2139769 | 2139769 | 2022-01-22 | Lake of the Woods | Minnesota | 27077 | 646 | 5 |
2139771 | 2139771 | 2022-01-22 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2136513 | 2136513 | 2022-01-21 | Lake of the Woods | Minnesota | 27077 | 646 | 5 |
2136515 | 2136515 | 2022-01-21 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2133261 | 2133261 | 2022-01-20 | Lake of the Woods | Minnesota | 27077 | 629 | 5 |
2133263 | 2133263 | 2022-01-20 | Lincoln | Minnesota | 27081 | 1050 | 5 |
2130008 | 2130008 | 2022-01-19 | Lake of the Woods | Minnesota | 27077 | 621 | 5 |
2130010 | 2130010 | 2022-01-19 | Lincoln | Minnesota | 27081 | 1037 | 5 |
2126754 | 2126754 | 2022-01-18 | Lake of the Woods | Minnesota | 27077 | 604 | 5 |
2126756 | 2126756 | 2022-01-18 | Lincoln | Minnesota | 27081 | 1015 | 5 |
2123502 | 2123502 | 2022-01-17 | Lake of the Woods | Minnesota | 27077 | 600 | 5 |
2123504 | 2123504 | 2022-01-17 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2120250 | 2120250 | 2022-01-16 | Lake of the Woods | Minnesota | 27077 | 600 | 5 |
2120252 | 2120252 | 2022-01-16 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2116998 | 2116998 | 2022-01-15 | Lake of the Woods | Minnesota | 27077 | 600 | 5 |
2117000 | 2117000 | 2022-01-15 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2113747 | 2113747 | 2022-01-14 | Lake of the Woods | Minnesota | 27077 | 600 | 5 |
2113749 | 2113749 | 2022-01-14 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2110495 | 2110495 | 2022-01-13 | Lake of the Woods | Minnesota | 27077 | 597 | 5 |
2110497 | 2110497 | 2022-01-13 | Lincoln | Minnesota | 27081 | 1002 | 5 |
2107244 | 2107244 | 2022-01-12 | Lake of the Woods | Minnesota | 27077 | 592 | 5 |
2107246 | 2107246 | 2022-01-12 | Lincoln | Minnesota | 27081 | 994 | 5 |
2103993 | 2103993 | 2022-01-11 | Lake of the Woods | Minnesota | 27077 | 589 | 5 |
2103995 | 2103995 | 2022-01-11 | Lincoln | Minnesota | 27081 | 986 | 5 |
2100742 | 2100742 | 2022-01-10 | Lake of the Woods | Minnesota | 27077 | 585 | 5 |
2100744 | 2100744 | 2022-01-10 | Lincoln | Minnesota | 27081 | 973 | 5 |
2097491 | 2097491 | 2022-01-09 | Lake of the Woods | Minnesota | 27077 | 580 | 5 |
2097493 | 2097493 | 2022-01-09 | Lincoln | Minnesota | 27081 | 967 | 5 |
2094239 | 2094239 | 2022-01-08 | Lake of the Woods | Minnesota | 27077 | 580 | 5 |
2094241 | 2094241 | 2022-01-08 | Lincoln | Minnesota | 27081 | 967 | 5 |
2090987 | 2090987 | 2022-01-07 | Lake of the Woods | Minnesota | 27077 | 580 | 5 |
2090989 | 2090989 | 2022-01-07 | Lincoln | Minnesota | 27081 | 967 | 5 |
2087736 | 2087736 | 2022-01-06 | Lake of the Woods | Minnesota | 27077 | 576 | 5 |
2087738 | 2087738 | 2022-01-06 | Lincoln | Minnesota | 27081 | 964 | 5 |
2084484 | 2084484 | 2022-01-05 | Lake of the Woods | Minnesota | 27077 | 568 | 5 |
2084486 | 2084486 | 2022-01-05 | Lincoln | Minnesota | 27081 | 963 | 5 |
2081232 | 2081232 | 2022-01-04 | Lake of the Woods | Minnesota | 27077 | 567 | 5 |
2081234 | 2081234 | 2022-01-04 | Lincoln | Minnesota | 27081 | 960 | 5 |
2077980 | 2077980 | 2022-01-03 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2077982 | 2077982 | 2022-01-03 | Lincoln | Minnesota | 27081 | 953 | 5 |
2074729 | 2074729 | 2022-01-02 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2074731 | 2074731 | 2022-01-02 | Lincoln | Minnesota | 27081 | 947 | 5 |
2071478 | 2071478 | 2022-01-01 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2071480 | 2071480 | 2022-01-01 | Lincoln | Minnesota | 27081 | 947 | 5 |
2068227 | 2068227 | 2021-12-31 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2068229 | 2068229 | 2021-12-31 | Lincoln | Minnesota | 27081 | 947 | 5 |
2064976 | 2064976 | 2021-12-30 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2064978 | 2064978 | 2021-12-30 | Lincoln | Minnesota | 27081 | 947 | 5 |
2061726 | 2061726 | 2021-12-29 | Lake of the Woods | Minnesota | 27077 | 565 | 5 |
2061728 | 2061728 | 2021-12-29 | Lincoln | Minnesota | 27081 | 942 | 5 |
2058477 | 2058477 | 2021-12-28 | Lake of the Woods | Minnesota | 27077 | 564 | 5 |
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);