ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 8 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Marshall 18
- Wabasha 14
- Brown 13
- Carver 6
- Cass 6
- Steele 6
- Norman 5
- Otter Tail 5
- Renville 5
- Cook 4
- Hubbard 4
- Lac qui Parle 4
- Pope 4
- Ramsey 4
- Redwood 4
- Sherburne 4
- Wadena 4
- Aitkin 3
- Big Stone 3
- Kittson 3
- Mahnomen 3
- Martin 3
- Nicollet 3
- Traverse 3
- Yellow Medicine 3
- Carlton 2
- Clay 2
- Dodge 2
- Fillmore 2
- McLeod 2
- …
state 1
- Minnesota · 172 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636226 | 636226 | 2020-10-16 | Cook | Minnesota | 27031 | 8 | 0 |
632980 | 632980 | 2020-10-15 | Cook | Minnesota | 27031 | 8 | 0 |
629735 | 629735 | 2020-10-14 | Cook | Minnesota | 27031 | 8 | 0 |
613523 | 613523 | 2020-10-09 | Cook | Minnesota | 27031 | 8 | 0 |
500199 | 500199 | 2020-09-04 | Kittson | Minnesota | 27069 | 8 | 0 |
496965 | 496965 | 2020-09-03 | Kittson | Minnesota | 27069 | 8 | 0 |
493732 | 493732 | 2020-09-02 | Kittson | Minnesota | 27069 | 8 | 0 |
429143 | 429143 | 2020-08-13 | Lac qui Parle | Minnesota | 27073 | 8 | 0 |
425919 | 425919 | 2020-08-12 | Lac qui Parle | Minnesota | 27073 | 8 | 0 |
422697 | 422697 | 2020-08-11 | Lac qui Parle | Minnesota | 27073 | 8 | 0 |
419475 | 419475 | 2020-08-10 | Lac qui Parle | Minnesota | 27073 | 8 | 0 |
368032 | 368032 | 2020-07-25 | Red Lake | Minnesota | 27125 | 8 | 0 |
339225 | 339225 | 2020-07-16 | Traverse | Minnesota | 27155 | 8 | 0 |
336029 | 336029 | 2020-07-15 | Traverse | Minnesota | 27155 | 8 | 0 |
332836 | 332836 | 2020-07-14 | Traverse | Minnesota | 27155 | 8 | 0 |
320053 | 320053 | 2020-07-10 | Hubbard | Minnesota | 27057 | 8 | 0 |
316878 | 316878 | 2020-07-09 | Hubbard | Minnesota | 27057 | 8 | 0 |
316923 | 316923 | 2020-07-09 | Stevens | Minnesota | 27149 | 8 | 0 |
313704 | 313704 | 2020-07-08 | Hubbard | Minnesota | 27057 | 8 | 0 |
310534 | 310534 | 2020-07-07 | Hubbard | Minnesota | 27057 | 8 | 0 |
307352 | 307352 | 2020-07-06 | Clearwater | Minnesota | 27029 | 8 | 0 |
304212 | 304212 | 2020-07-05 | Mahnomen | Minnesota | 27087 | 8 | 1 |
301048 | 301048 | 2020-07-04 | Mahnomen | Minnesota | 27087 | 8 | 1 |
297885 | 297885 | 2020-07-03 | Mahnomen | Minnesota | 27087 | 8 | 1 |
291557 | 291557 | 2020-07-01 | Grant | Minnesota | 27051 | 8 | 0 |
288420 | 288420 | 2020-06-30 | Lincoln | Minnesota | 27081 | 8 | 0 |
250788 | 250788 | 2020-06-18 | Houston | Minnesota | 27055 | 8 | 0 |
232189 | 232189 | 2020-06-12 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
229061 | 229061 | 2020-06-11 | Redwood | Minnesota | 27127 | 8 | 0 |
229062 | 229062 | 2020-06-11 | Renville | Minnesota | 27129 | 8 | 0 |
229085 | 229085 | 2020-06-11 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
225959 | 225959 | 2020-06-10 | Redwood | Minnesota | 27127 | 8 | 0 |
225960 | 225960 | 2020-06-10 | Renville | Minnesota | 27129 | 8 | 0 |
225983 | 225983 | 2020-06-10 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
222861 | 222861 | 2020-06-09 | Redwood | Minnesota | 27127 | 8 | 0 |
222862 | 222862 | 2020-06-09 | Renville | Minnesota | 27129 | 8 | 0 |
219766 | 219766 | 2020-06-08 | Redwood | Minnesota | 27127 | 8 | 0 |
219767 | 219767 | 2020-06-08 | Renville | Minnesota | 27129 | 8 | 0 |
216675 | 216675 | 2020-06-07 | Renville | Minnesota | 27129 | 8 | 0 |
207365 | 207365 | 2020-06-04 | Big Stone | Minnesota | 27011 | 8 | 0 |
204284 | 204284 | 2020-06-03 | Big Stone | Minnesota | 27011 | 8 | 0 |
201207 | 201207 | 2020-06-02 | Big Stone | Minnesota | 27011 | 8 | 0 |
198129 | 198129 | 2020-06-01 | Aitkin | Minnesota | 27001 | 8 | 0 |
195058 | 195058 | 2020-05-31 | Aitkin | Minnesota | 27001 | 8 | 0 |
195092 | 195092 | 2020-05-31 | Koochiching | Minnesota | 27071 | 8 | 0 |
191990 | 191990 | 2020-05-30 | Aitkin | Minnesota | 27001 | 8 | 0 |
189004 | 189004 | 2020-05-29 | Wadena | Minnesota | 27159 | 8 | 0 |
185926 | 185926 | 2020-05-28 | Pope | Minnesota | 27121 | 8 | 0 |
185946 | 185946 | 2020-05-28 | Wadena | Minnesota | 27159 | 8 | 0 |
182871 | 182871 | 2020-05-27 | Pope | Minnesota | 27121 | 8 | 0 |
182890 | 182890 | 2020-05-27 | Wadena | Minnesota | 27159 | 8 | 0 |
179825 | 179825 | 2020-05-26 | Pope | Minnesota | 27121 | 8 | 0 |
179844 | 179844 | 2020-05-26 | Wadena | Minnesota | 27159 | 8 | 0 |
176781 | 176781 | 2020-05-25 | Pope | Minnesota | 27121 | 8 | 0 |
173721 | 173721 | 2020-05-24 | Marshall | Minnesota | 27089 | 8 | 0 |
170679 | 170679 | 2020-05-23 | Marshall | Minnesota | 27089 | 8 | 0 |
167641 | 167641 | 2020-05-22 | Marshall | Minnesota | 27089 | 8 | 0 |
164605 | 164605 | 2020-05-21 | Marshall | Minnesota | 27089 | 8 | 0 |
161576 | 161576 | 2020-05-20 | Marshall | Minnesota | 27089 | 8 | 0 |
158550 | 158550 | 2020-05-19 | Marshall | Minnesota | 27089 | 8 | 0 |
155532 | 155532 | 2020-05-18 | Marshall | Minnesota | 27089 | 8 | 0 |
152518 | 152518 | 2020-05-17 | Marshall | Minnesota | 27089 | 8 | 0 |
149507 | 149507 | 2020-05-16 | Marshall | Minnesota | 27089 | 8 | 0 |
146472 | 146472 | 2020-05-15 | Cass | Minnesota | 27021 | 8 | 2 |
146502 | 146502 | 2020-05-15 | Marshall | Minnesota | 27089 | 8 | 0 |
146506 | 146506 | 2020-05-15 | Mille Lacs | Minnesota | 27095 | 8 | 1 |
143465 | 143465 | 2020-05-14 | Beltrami | Minnesota | 27007 | 8 | 0 |
143502 | 143502 | 2020-05-14 | Marshall | Minnesota | 27089 | 8 | 0 |
140477 | 140477 | 2020-05-13 | Cass | Minnesota | 27021 | 8 | 2 |
140507 | 140507 | 2020-05-13 | Marshall | Minnesota | 27089 | 8 | 0 |
137483 | 137483 | 2020-05-12 | Cass | Minnesota | 27021 | 8 | 2 |
137513 | 137513 | 2020-05-12 | Marshall | Minnesota | 27089 | 8 | 0 |
134493 | 134493 | 2020-05-11 | Cass | Minnesota | 27021 | 8 | 1 |
134510 | 134510 | 2020-05-11 | Isanti | Minnesota | 27059 | 8 | 0 |
134523 | 134523 | 2020-05-11 | Marshall | Minnesota | 27089 | 8 | 0 |
134554 | 134554 | 2020-05-11 | Swift | Minnesota | 27151 | 8 | 0 |
131502 | 131502 | 2020-05-10 | Cass | Minnesota | 27021 | 8 | 1 |
131532 | 131532 | 2020-05-10 | Marshall | Minnesota | 27089 | 8 | 0 |
128512 | 128512 | 2020-05-09 | Cass | Minnesota | 27021 | 8 | 0 |
128542 | 128542 | 2020-05-09 | Marshall | Minnesota | 27089 | 8 | 0 |
128544 | 128544 | 2020-05-09 | McLeod | Minnesota | 27085 | 8 | 0 |
125555 | 125555 | 2020-05-08 | Marshall | Minnesota | 27089 | 8 | 0 |
125557 | 125557 | 2020-05-08 | McLeod | Minnesota | 27085 | 8 | 0 |
122573 | 122573 | 2020-05-07 | Marshall | Minnesota | 27089 | 8 | 0 |
119580 | 119580 | 2020-05-06 | Faribault | Minnesota | 27043 | 8 | 0 |
110847 | 110847 | 2020-05-03 | Brown | Minnesota | 27015 | 8 | 1 |
110889 | 110889 | 2020-05-03 | Norman | Minnesota | 27107 | 8 | 0 |
110910 | 110910 | 2020-05-03 | Todd | Minnesota | 27153 | 8 | 0 |
107976 | 107976 | 2020-05-02 | Brown | Minnesota | 27015 | 8 | 1 |
108006 | 108006 | 2020-05-02 | Lyon | Minnesota | 27083 | 8 | 0 |
108018 | 108018 | 2020-05-02 | Norman | Minnesota | 27107 | 8 | 0 |
108039 | 108039 | 2020-05-02 | Todd | Minnesota | 27153 | 8 | 0 |
105112 | 105112 | 2020-05-01 | Brown | Minnesota | 27015 | 8 | 1 |
105153 | 105153 | 2020-05-01 | Norman | Minnesota | 27107 | 8 | 0 |
102252 | 102252 | 2020-04-30 | Brown | Minnesota | 27015 | 8 | 1 |
102292 | 102292 | 2020-04-30 | Norman | Minnesota | 27107 | 8 | 0 |
102316 | 102316 | 2020-04-30 | Wabasha | Minnesota | 27157 | 8 | 0 |
99400 | 99400 | 2020-04-29 | Brown | Minnesota | 27015 | 8 | 1 |
99440 | 99440 | 2020-04-29 | Norman | Minnesota | 27107 | 8 | 0 |
99442 | 99442 | 2020-04-29 | Otter Tail | Minnesota | 27111 | 8 | 0 |
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);