ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,068 rows where deaths = 17 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Marshall 124
- Mahnomen 123
- Pope 95
- Houston 89
- Jackson 89
- Yellow Medicine 64
- Roseau 62
- Clearwater 42
- Winona 32
- Waseca 31
- Nicollet 30
- Pipestone 29
- Itasca 24
- Sibley 17
- Lac qui Parle 16
- Wilkin 16
- Koochiching 15
- Faribault 14
- Fillmore 14
- Lake 14
- Freeborn 11
- Swift 10
- Blue Earth 7
- Goodhue 6
- Isanti 6
- Rock 6
- Cass 5
- Polk 5
- Watonwan 5
- Clay 4
- …
state 1
- Minnesota · 1,068 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500936 | 2500936 | 2022-05-13 | Jackson | Minnesota | 27063 | 2167 | 17 |
2500965 | 2500965 | 2022-05-13 | Pope | Minnesota | 27121 | 3119 | 17 |
2497678 | 2497678 | 2022-05-12 | Jackson | Minnesota | 27063 | 2166 | 17 |
2497689 | 2497689 | 2022-05-12 | Mahnomen | Minnesota | 27087 | 1801 | 17 |
2497707 | 2497707 | 2022-05-12 | Pope | Minnesota | 27121 | 3110 | 17 |
2494420 | 2494420 | 2022-05-11 | Jackson | Minnesota | 27063 | 2166 | 17 |
2494431 | 2494431 | 2022-05-11 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2494449 | 2494449 | 2022-05-11 | Pope | Minnesota | 27121 | 3104 | 17 |
2491162 | 2491162 | 2022-05-10 | Jackson | Minnesota | 27063 | 2165 | 17 |
2491173 | 2491173 | 2022-05-10 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2491191 | 2491191 | 2022-05-10 | Pope | Minnesota | 27121 | 3081 | 17 |
2487905 | 2487905 | 2022-05-09 | Jackson | Minnesota | 27063 | 2165 | 17 |
2487916 | 2487916 | 2022-05-09 | Mahnomen | Minnesota | 27087 | 1798 | 17 |
2487934 | 2487934 | 2022-05-09 | Pope | Minnesota | 27121 | 3072 | 17 |
2484647 | 2484647 | 2022-05-08 | Jackson | Minnesota | 27063 | 2164 | 17 |
2484658 | 2484658 | 2022-05-08 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2484676 | 2484676 | 2022-05-08 | Pope | Minnesota | 27121 | 3067 | 17 |
2481389 | 2481389 | 2022-05-07 | Jackson | Minnesota | 27063 | 2164 | 17 |
2481400 | 2481400 | 2022-05-07 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2481418 | 2481418 | 2022-05-07 | Pope | Minnesota | 27121 | 3067 | 17 |
2478131 | 2478131 | 2022-05-06 | Jackson | Minnesota | 27063 | 2164 | 17 |
2478142 | 2478142 | 2022-05-06 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2478160 | 2478160 | 2022-05-06 | Pope | Minnesota | 27121 | 3067 | 17 |
2474873 | 2474873 | 2022-05-05 | Jackson | Minnesota | 27063 | 2162 | 17 |
2474884 | 2474884 | 2022-05-05 | Mahnomen | Minnesota | 27087 | 1791 | 17 |
2474902 | 2474902 | 2022-05-05 | Pope | Minnesota | 27121 | 3062 | 17 |
2471616 | 2471616 | 2022-05-04 | Jackson | Minnesota | 27063 | 2161 | 17 |
2471627 | 2471627 | 2022-05-04 | Mahnomen | Minnesota | 27087 | 1789 | 17 |
2471645 | 2471645 | 2022-05-04 | Pope | Minnesota | 27121 | 3059 | 17 |
2468360 | 2468360 | 2022-05-03 | Jackson | Minnesota | 27063 | 2159 | 17 |
2468371 | 2468371 | 2022-05-03 | Mahnomen | Minnesota | 27087 | 1787 | 17 |
2468389 | 2468389 | 2022-05-03 | Pope | Minnesota | 27121 | 3056 | 17 |
2465105 | 2465105 | 2022-05-02 | Jackson | Minnesota | 27063 | 2157 | 17 |
2465116 | 2465116 | 2022-05-02 | Mahnomen | Minnesota | 27087 | 1787 | 17 |
2465134 | 2465134 | 2022-05-02 | Pope | Minnesota | 27121 | 3053 | 17 |
2461849 | 2461849 | 2022-05-01 | Jackson | Minnesota | 27063 | 2157 | 17 |
2461860 | 2461860 | 2022-05-01 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2461878 | 2461878 | 2022-05-01 | Pope | Minnesota | 27121 | 3051 | 17 |
2458593 | 2458593 | 2022-04-30 | Jackson | Minnesota | 27063 | 2157 | 17 |
2458604 | 2458604 | 2022-04-30 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2458622 | 2458622 | 2022-04-30 | Pope | Minnesota | 27121 | 3051 | 17 |
2455337 | 2455337 | 2022-04-29 | Jackson | Minnesota | 27063 | 2157 | 17 |
2455348 | 2455348 | 2022-04-29 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2455366 | 2455366 | 2022-04-29 | Pope | Minnesota | 27121 | 3051 | 17 |
2452081 | 2452081 | 2022-04-28 | Jackson | Minnesota | 27063 | 2157 | 17 |
2452092 | 2452092 | 2022-04-28 | Mahnomen | Minnesota | 27087 | 1784 | 17 |
2452110 | 2452110 | 2022-04-28 | Pope | Minnesota | 27121 | 3051 | 17 |
2448825 | 2448825 | 2022-04-27 | Jackson | Minnesota | 27063 | 2156 | 17 |
2448836 | 2448836 | 2022-04-27 | Mahnomen | Minnesota | 27087 | 1784 | 17 |
2448854 | 2448854 | 2022-04-27 | Pope | Minnesota | 27121 | 3049 | 17 |
2445569 | 2445569 | 2022-04-26 | Jackson | Minnesota | 27063 | 2155 | 17 |
2445580 | 2445580 | 2022-04-26 | Mahnomen | Minnesota | 27087 | 1780 | 17 |
2445598 | 2445598 | 2022-04-26 | Pope | Minnesota | 27121 | 3047 | 17 |
2442313 | 2442313 | 2022-04-25 | Jackson | Minnesota | 27063 | 2155 | 17 |
2442324 | 2442324 | 2022-04-25 | Mahnomen | Minnesota | 27087 | 1780 | 17 |
2442342 | 2442342 | 2022-04-25 | Pope | Minnesota | 27121 | 3046 | 17 |
2439057 | 2439057 | 2022-04-24 | Jackson | Minnesota | 27063 | 2153 | 17 |
2439068 | 2439068 | 2022-04-24 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2439086 | 2439086 | 2022-04-24 | Pope | Minnesota | 27121 | 3045 | 17 |
2435801 | 2435801 | 2022-04-23 | Jackson | Minnesota | 27063 | 2153 | 17 |
2435812 | 2435812 | 2022-04-23 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2435830 | 2435830 | 2022-04-23 | Pope | Minnesota | 27121 | 3045 | 17 |
2432545 | 2432545 | 2022-04-22 | Jackson | Minnesota | 27063 | 2153 | 17 |
2432556 | 2432556 | 2022-04-22 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2432574 | 2432574 | 2022-04-22 | Pope | Minnesota | 27121 | 3045 | 17 |
2429289 | 2429289 | 2022-04-21 | Jackson | Minnesota | 27063 | 2151 | 17 |
2429300 | 2429300 | 2022-04-21 | Mahnomen | Minnesota | 27087 | 1776 | 17 |
2429318 | 2429318 | 2022-04-21 | Pope | Minnesota | 27121 | 3045 | 17 |
2426033 | 2426033 | 2022-04-20 | Jackson | Minnesota | 27063 | 2147 | 17 |
2426044 | 2426044 | 2022-04-20 | Mahnomen | Minnesota | 27087 | 1774 | 17 |
2426062 | 2426062 | 2022-04-20 | Pope | Minnesota | 27121 | 3043 | 17 |
2422777 | 2422777 | 2022-04-19 | Jackson | Minnesota | 27063 | 2146 | 17 |
2422788 | 2422788 | 2022-04-19 | Mahnomen | Minnesota | 27087 | 1766 | 17 |
2422806 | 2422806 | 2022-04-19 | Pope | Minnesota | 27121 | 3035 | 17 |
2419521 | 2419521 | 2022-04-18 | Jackson | Minnesota | 27063 | 2144 | 17 |
2419532 | 2419532 | 2022-04-18 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2419550 | 2419550 | 2022-04-18 | Pope | Minnesota | 27121 | 3033 | 17 |
2416265 | 2416265 | 2022-04-17 | Jackson | Minnesota | 27063 | 2142 | 17 |
2416276 | 2416276 | 2022-04-17 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2416294 | 2416294 | 2022-04-17 | Pope | Minnesota | 27121 | 3033 | 17 |
2413009 | 2413009 | 2022-04-16 | Jackson | Minnesota | 27063 | 2142 | 17 |
2413020 | 2413020 | 2022-04-16 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2413038 | 2413038 | 2022-04-16 | Pope | Minnesota | 27121 | 3033 | 17 |
2409753 | 2409753 | 2022-04-15 | Jackson | Minnesota | 27063 | 2142 | 17 |
2409764 | 2409764 | 2022-04-15 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2409782 | 2409782 | 2022-04-15 | Pope | Minnesota | 27121 | 3033 | 17 |
2406497 | 2406497 | 2022-04-14 | Jackson | Minnesota | 27063 | 2142 | 17 |
2406508 | 2406508 | 2022-04-14 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2406526 | 2406526 | 2022-04-14 | Pope | Minnesota | 27121 | 3032 | 17 |
2403241 | 2403241 | 2022-04-13 | Jackson | Minnesota | 27063 | 2142 | 17 |
2403252 | 2403252 | 2022-04-13 | Mahnomen | Minnesota | 27087 | 1761 | 17 |
2403270 | 2403270 | 2022-04-13 | Pope | Minnesota | 27121 | 3032 | 17 |
2399987 | 2399987 | 2022-04-12 | Jackson | Minnesota | 27063 | 2142 | 17 |
2399998 | 2399998 | 2022-04-12 | Mahnomen | Minnesota | 27087 | 1759 | 17 |
2400016 | 2400016 | 2022-04-12 | Pope | Minnesota | 27121 | 3031 | 17 |
2396731 | 2396731 | 2022-04-11 | Jackson | Minnesota | 27063 | 2141 | 17 |
2396742 | 2396742 | 2022-04-11 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2396760 | 2396760 | 2022-04-11 | Pope | Minnesota | 27121 | 3031 | 17 |
2393476 | 2393476 | 2022-04-10 | Jackson | Minnesota | 27063 | 2141 | 17 |
2393487 | 2393487 | 2022-04-10 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
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);