ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
407 rows where deaths = 48 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Nobles 54
- Chippewa 51
- Winona 35
- Beltrami 32
- Becker 30
- Chisago 27
- Lyon 26
- Renville 24
- Carver 20
- Pine 15
- Kanabec 11
- Hubbard 10
- Sherburne 8
- McLeod 6
- Todd 6
- Washington 6
- Wadena 5
- Nicollet 4
- Polk 4
- Martin 3
- Mille Lacs 3
- Clay 2
- Crow Wing 2
- Kandiyohi 2
- Otter Tail 2
- Redwood 2
- Rice 2
- Wright 2
- Aitkin 1
- Benton 1
- …
state 1
- Minnesota · 407 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500916 | 2500916 | 2022-05-13 | Chippewa | Minnesota | 27023 | 3128 | 48 |
2497658 | 2497658 | 2022-05-12 | Chippewa | Minnesota | 27023 | 3119 | 48 |
2494400 | 2494400 | 2022-05-11 | Chippewa | Minnesota | 27023 | 3115 | 48 |
2491142 | 2491142 | 2022-05-10 | Chippewa | Minnesota | 27023 | 3112 | 48 |
2487885 | 2487885 | 2022-05-09 | Chippewa | Minnesota | 27023 | 3105 | 48 |
2484627 | 2484627 | 2022-05-08 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2481369 | 2481369 | 2022-05-07 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2478111 | 2478111 | 2022-05-06 | Chippewa | Minnesota | 27023 | 3102 | 48 |
2474853 | 2474853 | 2022-05-05 | Chippewa | Minnesota | 27023 | 3098 | 48 |
2471596 | 2471596 | 2022-05-04 | Chippewa | Minnesota | 27023 | 3097 | 48 |
2468340 | 2468340 | 2022-05-03 | Chippewa | Minnesota | 27023 | 3094 | 48 |
2465085 | 2465085 | 2022-05-02 | Chippewa | Minnesota | 27023 | 3093 | 48 |
2461829 | 2461829 | 2022-05-01 | Chippewa | Minnesota | 27023 | 3092 | 48 |
2458573 | 2458573 | 2022-04-30 | Chippewa | Minnesota | 27023 | 3092 | 48 |
2455317 | 2455317 | 2022-04-29 | Chippewa | Minnesota | 27023 | 3092 | 48 |
2452061 | 2452061 | 2022-04-28 | Chippewa | Minnesota | 27023 | 3091 | 48 |
2448805 | 2448805 | 2022-04-27 | Chippewa | Minnesota | 27023 | 3090 | 48 |
2445549 | 2445549 | 2022-04-26 | Chippewa | Minnesota | 27023 | 3085 | 48 |
2442293 | 2442293 | 2022-04-25 | Chippewa | Minnesota | 27023 | 3083 | 48 |
2439037 | 2439037 | 2022-04-24 | Chippewa | Minnesota | 27023 | 3083 | 48 |
2435781 | 2435781 | 2022-04-23 | Chippewa | Minnesota | 27023 | 3083 | 48 |
2432525 | 2432525 | 2022-04-22 | Chippewa | Minnesota | 27023 | 3083 | 48 |
2429269 | 2429269 | 2022-04-21 | Chippewa | Minnesota | 27023 | 3081 | 48 |
2426013 | 2426013 | 2022-04-20 | Chippewa | Minnesota | 27023 | 3080 | 48 |
2422757 | 2422757 | 2022-04-19 | Chippewa | Minnesota | 27023 | 3080 | 48 |
2419501 | 2419501 | 2022-04-18 | Chippewa | Minnesota | 27023 | 3077 | 48 |
2416245 | 2416245 | 2022-04-17 | Chippewa | Minnesota | 27023 | 3077 | 48 |
2412989 | 2412989 | 2022-04-16 | Chippewa | Minnesota | 27023 | 3077 | 48 |
2409733 | 2409733 | 2022-04-15 | Chippewa | Minnesota | 27023 | 3077 | 48 |
2406477 | 2406477 | 2022-04-14 | Chippewa | Minnesota | 27023 | 3077 | 48 |
2403221 | 2403221 | 2022-04-13 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2399967 | 2399967 | 2022-04-12 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2396711 | 2396711 | 2022-04-11 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2393456 | 2393456 | 2022-04-10 | Chippewa | Minnesota | 27023 | 3071 | 48 |
2390200 | 2390200 | 2022-04-09 | Chippewa | Minnesota | 27023 | 3071 | 48 |
2386944 | 2386944 | 2022-04-08 | Chippewa | Minnesota | 27023 | 3071 | 48 |
2383689 | 2383689 | 2022-04-07 | Chippewa | Minnesota | 27023 | 3071 | 48 |
2380434 | 2380434 | 2022-04-06 | Chippewa | Minnesota | 27023 | 3069 | 48 |
2377179 | 2377179 | 2022-04-05 | Chippewa | Minnesota | 27023 | 3068 | 48 |
2373927 | 2373927 | 2022-04-04 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2370674 | 2370674 | 2022-04-03 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2367421 | 2367421 | 2022-04-02 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2364168 | 2364168 | 2022-04-01 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2360914 | 2360914 | 2022-03-31 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2357660 | 2357660 | 2022-03-30 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2354407 | 2354407 | 2022-03-29 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2351155 | 2351155 | 2022-03-28 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2347902 | 2347902 | 2022-03-27 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2344649 | 2344649 | 2022-03-26 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2341396 | 2341396 | 2022-03-25 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2338143 | 2338143 | 2022-03-24 | Chippewa | Minnesota | 27023 | 3068 | 48 |
2221099 | 2221099 | 2022-02-16 | Le Sueur | Minnesota | 27079 | 6279 | 48 |
2195060 | 2195060 | 2022-02-08 | Faribault | Minnesota | 27043 | 3617 | 48 |
2188612 | 2188612 | 2022-02-06 | Wadena | Minnesota | 27159 | 3912 | 48 |
2185359 | 2185359 | 2022-02-05 | Wadena | Minnesota | 27159 | 3912 | 48 |
2182107 | 2182107 | 2022-02-04 | Wadena | Minnesota | 27159 | 3912 | 48 |
2178855 | 2178855 | 2022-02-03 | Wadena | Minnesota | 27159 | 3892 | 48 |
2175603 | 2175603 | 2022-02-02 | Wadena | Minnesota | 27159 | 3872 | 48 |
2130043 | 2130043 | 2022-01-19 | Steele | Minnesota | 27147 | 8489 | 48 |
2123496 | 2123496 | 2022-01-17 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2120244 | 2120244 | 2022-01-16 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2116992 | 2116992 | 2022-01-15 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2113741 | 2113741 | 2022-01-14 | Kanabec | Minnesota | 27065 | 2966 | 48 |
2110489 | 2110489 | 2022-01-13 | Kanabec | Minnesota | 27065 | 2936 | 48 |
2107238 | 2107238 | 2022-01-12 | Kanabec | Minnesota | 27065 | 2924 | 48 |
2103987 | 2103987 | 2022-01-11 | Kanabec | Minnesota | 27065 | 2904 | 48 |
2100736 | 2100736 | 2022-01-10 | Kanabec | Minnesota | 27065 | 2880 | 48 |
2097485 | 2097485 | 2022-01-09 | Kanabec | Minnesota | 27065 | 2878 | 48 |
2094233 | 2094233 | 2022-01-08 | Kanabec | Minnesota | 27065 | 2878 | 48 |
2090981 | 2090981 | 2022-01-07 | Kanabec | Minnesota | 27065 | 2878 | 48 |
2087755 | 2087755 | 2022-01-06 | Pine | Minnesota | 27115 | 5741 | 48 |
2084503 | 2084503 | 2022-01-05 | Pine | Minnesota | 27115 | 5721 | 48 |
2081251 | 2081251 | 2022-01-04 | Pine | Minnesota | 27115 | 5701 | 48 |
2077999 | 2077999 | 2022-01-03 | Pine | Minnesota | 27115 | 5688 | 48 |
2074748 | 2074748 | 2022-01-02 | Pine | Minnesota | 27115 | 5677 | 48 |
2071497 | 2071497 | 2022-01-01 | Pine | Minnesota | 27115 | 5677 | 48 |
2068246 | 2068246 | 2021-12-31 | Pine | Minnesota | 27115 | 5677 | 48 |
2064995 | 2064995 | 2021-12-30 | Pine | Minnesota | 27115 | 5677 | 48 |
2061745 | 2061745 | 2021-12-29 | Pine | Minnesota | 27115 | 5664 | 48 |
2058496 | 2058496 | 2021-12-28 | Pine | Minnesota | 27115 | 5657 | 48 |
2055247 | 2055247 | 2021-12-27 | Pine | Minnesota | 27115 | 5610 | 48 |
2051997 | 2051997 | 2021-12-26 | Pine | Minnesota | 27115 | 5599 | 48 |
2048747 | 2048747 | 2021-12-25 | Pine | Minnesota | 27115 | 5599 | 48 |
2045497 | 2045497 | 2021-12-24 | Pine | Minnesota | 27115 | 5599 | 48 |
2042247 | 2042247 | 2021-12-23 | Pine | Minnesota | 27115 | 5599 | 48 |
2035754 | 2035754 | 2021-12-21 | Redwood | Minnesota | 27127 | 2988 | 48 |
2032504 | 2032504 | 2021-12-20 | Redwood | Minnesota | 27127 | 2971 | 48 |
2029234 | 2029234 | 2021-12-19 | Martin | Minnesota | 27091 | 4098 | 48 |
2029266 | 2029266 | 2021-12-19 | Todd | Minnesota | 27153 | 5179 | 48 |
2025983 | 2025983 | 2021-12-18 | Martin | Minnesota | 27091 | 4098 | 48 |
2026015 | 2026015 | 2021-12-18 | Todd | Minnesota | 27153 | 5179 | 48 |
2022732 | 2022732 | 2021-12-17 | Martin | Minnesota | 27091 | 4098 | 48 |
2022764 | 2022764 | 2021-12-17 | Todd | Minnesota | 27153 | 5179 | 48 |
2019513 | 2019513 | 2021-12-16 | Todd | Minnesota | 27153 | 5167 | 48 |
2016263 | 2016263 | 2021-12-15 | Todd | Minnesota | 27153 | 5144 | 48 |
2013012 | 2013012 | 2021-12-14 | Todd | Minnesota | 27153 | 5121 | 48 |
1960956 | 1960956 | 2021-11-28 | Hubbard | Minnesota | 27057 | 3498 | 48 |
1957705 | 1957705 | 2021-11-27 | Hubbard | Minnesota | 27057 | 3498 | 48 |
1954454 | 1954454 | 2021-11-26 | Hubbard | Minnesota | 27057 | 3498 | 48 |
1951203 | 1951203 | 2021-11-25 | Hubbard | Minnesota | 27057 | 3482 | 48 |
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);