ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where deaths = 14 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clearwater 117
- Houston 91
- Wilkin 81
- Pope 34
- St. Louis 34
- Yellow Medicine 34
- Dodge 24
- Fillmore 22
- Murray 22
- Steele 22
- Mahnomen 16
- Pennington 16
- Crow Wing 15
- Jackson 14
- Roseau 13
- Swift 13
- Sherburne 12
- Rock 11
- Lac qui Parle 10
- Renville 10
- Cottonwood 8
- Sibley 8
- Wright 8
- Wabasha 7
- Watonwan 7
- Faribault 6
- Koochiching 6
- Todd 6
- Itasca 5
- Lake 5
- …
state 1
- Minnesota · 752 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500958 | 2500958 | 2022-05-13 | Norman | Minnesota | 27107 | 1535 | 14 |
2497700 | 2497700 | 2022-05-12 | Norman | Minnesota | 27107 | 1533 | 14 |
2175602 | 2175602 | 2022-02-02 | Wabasha | Minnesota | 27157 | 5130 | 14 |
2172349 | 2172349 | 2022-02-01 | Wabasha | Minnesota | 27157 | 5091 | 14 |
2169096 | 2169096 | 2022-01-31 | Wabasha | Minnesota | 27157 | 5016 | 14 |
2165841 | 2165841 | 2022-01-30 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2162586 | 2162586 | 2022-01-29 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2159331 | 2159331 | 2022-01-28 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2156017 | 2156017 | 2022-01-27 | Dodge | Minnesota | 27039 | 5069 | 14 |
2156077 | 2156077 | 2022-01-27 | Wabasha | Minnesota | 27157 | 4916 | 14 |
2152764 | 2152764 | 2022-01-26 | Dodge | Minnesota | 27039 | 4983 | 14 |
2149512 | 2149512 | 2022-01-25 | Dodge | Minnesota | 27039 | 4907 | 14 |
2149553 | 2149553 | 2022-01-25 | Pope | Minnesota | 27121 | 2518 | 14 |
2146260 | 2146260 | 2022-01-24 | Dodge | Minnesota | 27039 | 4745 | 14 |
2146301 | 2146301 | 2022-01-24 | Pope | Minnesota | 27121 | 2477 | 14 |
2143005 | 2143005 | 2022-01-23 | Dodge | Minnesota | 27039 | 4667 | 14 |
2143046 | 2143046 | 2022-01-23 | Pope | Minnesota | 27121 | 2457 | 14 |
2139750 | 2139750 | 2022-01-22 | Dodge | Minnesota | 27039 | 4667 | 14 |
2139791 | 2139791 | 2022-01-22 | Pope | Minnesota | 27121 | 2457 | 14 |
2136494 | 2136494 | 2022-01-21 | Dodge | Minnesota | 27039 | 4667 | 14 |
2136535 | 2136535 | 2022-01-21 | Pope | Minnesota | 27121 | 2457 | 14 |
2133242 | 2133242 | 2022-01-20 | Dodge | Minnesota | 27039 | 4592 | 14 |
2133283 | 2133283 | 2022-01-20 | Pope | Minnesota | 27121 | 2436 | 14 |
2129989 | 2129989 | 2022-01-19 | Dodge | Minnesota | 27039 | 4544 | 14 |
2130030 | 2130030 | 2022-01-19 | Pope | Minnesota | 27121 | 2417 | 14 |
2126735 | 2126735 | 2022-01-18 | Dodge | Minnesota | 27039 | 4372 | 14 |
2126776 | 2126776 | 2022-01-18 | Pope | Minnesota | 27121 | 2389 | 14 |
2123483 | 2123483 | 2022-01-17 | Dodge | Minnesota | 27039 | 4342 | 14 |
2123524 | 2123524 | 2022-01-17 | Pope | Minnesota | 27121 | 2382 | 14 |
2120231 | 2120231 | 2022-01-16 | Dodge | Minnesota | 27039 | 4342 | 14 |
2120272 | 2120272 | 2022-01-16 | Pope | Minnesota | 27121 | 2382 | 14 |
2116979 | 2116979 | 2022-01-15 | Dodge | Minnesota | 27039 | 4342 | 14 |
2117020 | 2117020 | 2022-01-15 | Pope | Minnesota | 27121 | 2382 | 14 |
2113728 | 2113728 | 2022-01-14 | Dodge | Minnesota | 27039 | 4342 | 14 |
2113769 | 2113769 | 2022-01-14 | Pope | Minnesota | 27121 | 2382 | 14 |
2110476 | 2110476 | 2022-01-13 | Dodge | Minnesota | 27039 | 4301 | 14 |
2110507 | 2110507 | 2022-01-13 | Murray | Minnesota | 27101 | 1713 | 14 |
2110517 | 2110517 | 2022-01-13 | Pope | Minnesota | 27121 | 2375 | 14 |
2107225 | 2107225 | 2022-01-12 | Dodge | Minnesota | 27039 | 4249 | 14 |
2107256 | 2107256 | 2022-01-12 | Murray | Minnesota | 27101 | 1695 | 14 |
2107266 | 2107266 | 2022-01-12 | Pope | Minnesota | 27121 | 2362 | 14 |
2103974 | 2103974 | 2022-01-11 | Dodge | Minnesota | 27039 | 4206 | 14 |
2104005 | 2104005 | 2022-01-11 | Murray | Minnesota | 27101 | 1688 | 14 |
2104015 | 2104015 | 2022-01-11 | Pope | Minnesota | 27121 | 2357 | 14 |
2100723 | 2100723 | 2022-01-10 | Dodge | Minnesota | 27039 | 4118 | 14 |
2100754 | 2100754 | 2022-01-10 | Murray | Minnesota | 27101 | 1667 | 14 |
2100764 | 2100764 | 2022-01-10 | Pope | Minnesota | 27121 | 2331 | 14 |
2097472 | 2097472 | 2022-01-09 | Dodge | Minnesota | 27039 | 4074 | 14 |
2097503 | 2097503 | 2022-01-09 | Murray | Minnesota | 27101 | 1656 | 14 |
2097513 | 2097513 | 2022-01-09 | Pope | Minnesota | 27121 | 2324 | 14 |
2094220 | 2094220 | 2022-01-08 | Dodge | Minnesota | 27039 | 4074 | 14 |
2094251 | 2094251 | 2022-01-08 | Murray | Minnesota | 27101 | 1656 | 14 |
2094261 | 2094261 | 2022-01-08 | Pope | Minnesota | 27121 | 2324 | 14 |
2090968 | 2090968 | 2022-01-07 | Dodge | Minnesota | 27039 | 4074 | 14 |
2090999 | 2090999 | 2022-01-07 | Murray | Minnesota | 27101 | 1656 | 14 |
2091009 | 2091009 | 2022-01-07 | Pope | Minnesota | 27121 | 2324 | 14 |
2087717 | 2087717 | 2022-01-06 | Dodge | Minnesota | 27039 | 4039 | 14 |
2087748 | 2087748 | 2022-01-06 | Murray | Minnesota | 27101 | 1653 | 14 |
2087758 | 2087758 | 2022-01-06 | Pope | Minnesota | 27121 | 2317 | 14 |
2084465 | 2084465 | 2022-01-05 | Dodge | Minnesota | 27039 | 4016 | 14 |
2084496 | 2084496 | 2022-01-05 | Murray | Minnesota | 27101 | 1640 | 14 |
2084506 | 2084506 | 2022-01-05 | Pope | Minnesota | 27121 | 2312 | 14 |
2081213 | 2081213 | 2022-01-04 | Dodge | Minnesota | 27039 | 4008 | 14 |
2081244 | 2081244 | 2022-01-04 | Murray | Minnesota | 27101 | 1628 | 14 |
2081254 | 2081254 | 2022-01-04 | Pope | Minnesota | 27121 | 2292 | 14 |
2077992 | 2077992 | 2022-01-03 | Murray | Minnesota | 27101 | 1621 | 14 |
2078002 | 2078002 | 2022-01-03 | Pope | Minnesota | 27121 | 2282 | 14 |
2074741 | 2074741 | 2022-01-02 | Murray | Minnesota | 27101 | 1616 | 14 |
2074751 | 2074751 | 2022-01-02 | Pope | Minnesota | 27121 | 2279 | 14 |
2071490 | 2071490 | 2022-01-01 | Murray | Minnesota | 27101 | 1616 | 14 |
2071500 | 2071500 | 2022-01-01 | Pope | Minnesota | 27121 | 2279 | 14 |
2068239 | 2068239 | 2021-12-31 | Murray | Minnesota | 27101 | 1616 | 14 |
2068249 | 2068249 | 2021-12-31 | Pope | Minnesota | 27121 | 2279 | 14 |
2064988 | 2064988 | 2021-12-30 | Murray | Minnesota | 27101 | 1616 | 14 |
2064998 | 2064998 | 2021-12-30 | Pope | Minnesota | 27121 | 2279 | 14 |
2061738 | 2061738 | 2021-12-29 | Murray | Minnesota | 27101 | 1611 | 14 |
2061748 | 2061748 | 2021-12-29 | Pope | Minnesota | 27121 | 2272 | 14 |
2058489 | 2058489 | 2021-12-28 | Murray | Minnesota | 27101 | 1604 | 14 |
2058499 | 2058499 | 2021-12-28 | Pope | Minnesota | 27121 | 2266 | 14 |
2055240 | 2055240 | 2021-12-27 | Murray | Minnesota | 27101 | 1597 | 14 |
2055250 | 2055250 | 2021-12-27 | Pope | Minnesota | 27121 | 2260 | 14 |
2051990 | 2051990 | 2021-12-26 | Murray | Minnesota | 27101 | 1596 | 14 |
2052000 | 2052000 | 2021-12-26 | Pope | Minnesota | 27121 | 2259 | 14 |
2048740 | 2048740 | 2021-12-25 | Murray | Minnesota | 27101 | 1596 | 14 |
2048750 | 2048750 | 2021-12-25 | Pope | Minnesota | 27121 | 2259 | 14 |
2045490 | 2045490 | 2021-12-24 | Murray | Minnesota | 27101 | 1596 | 14 |
2045500 | 2045500 | 2021-12-24 | Pope | Minnesota | 27121 | 2259 | 14 |
2042240 | 2042240 | 2021-12-23 | Murray | Minnesota | 27101 | 1596 | 14 |
2042250 | 2042250 | 2021-12-23 | Pope | Minnesota | 27121 | 2259 | 14 |
1990222 | 1990222 | 2021-12-07 | Mahnomen | Minnesota | 27087 | 1089 | 14 |
1986972 | 1986972 | 2021-12-06 | Mahnomen | Minnesota | 27087 | 1085 | 14 |
1983722 | 1983722 | 2021-12-05 | Mahnomen | Minnesota | 27087 | 1083 | 14 |
1980472 | 1980472 | 2021-12-04 | Mahnomen | Minnesota | 27087 | 1083 | 14 |
1977222 | 1977222 | 2021-12-03 | Mahnomen | Minnesota | 27087 | 1083 | 14 |
1973972 | 1973972 | 2021-12-02 | Mahnomen | Minnesota | 27087 | 1064 | 14 |
1970723 | 1970723 | 2021-12-01 | Mahnomen | Minnesota | 27087 | 1060 | 14 |
1967473 | 1967473 | 2021-11-30 | Mahnomen | Minnesota | 27087 | 1059 | 14 |
1964221 | 1964221 | 2021-11-29 | Mahnomen | Minnesota | 27087 | 1054 | 14 |
1960970 | 1960970 | 2021-11-28 | Mahnomen | Minnesota | 27087 | 1047 | 14 |
1957719 | 1957719 | 2021-11-27 | Mahnomen | Minnesota | 27087 | 1047 | 14 |
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);