ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 23 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
- Wilkin 12
- Rock 11
- Wadena 7
- Beltrami 6
- Kanabec 6
- Crow Wing 5
- Fillmore 5
- Blue Earth 4
- Brown 3
- Goodhue 3
- Chisago 2
- Clearwater 2
- Faribault 2
- Lake of the Woods 2
- Mahnomen 2
- Marshall 2
- Meeker 2
- Otter Tail 2
- Red Lake 2
- Scott 2
- Wright 2
- Anoka 1
- Clay 1
- Cottonwood 1
- Douglas 1
- Houston 1
- Kittson 1
- Lac qui Parle 1
- Le Sueur 1
- Martin 1
- …
state 1
- Minnesota · 105 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636245 | 636245 | 2020-10-16 | Kittson | Minnesota | 27069 | 23 | 0 |
577889 | 577889 | 2020-09-28 | Lake of the Woods | Minnesota | 27077 | 23 | 1 |
574648 | 574648 | 2020-09-27 | Lake of the Woods | Minnesota | 27077 | 23 | 1 |
526053 | 526053 | 2020-09-12 | Clearwater | Minnesota | 27029 | 23 | 0 |
522817 | 522817 | 2020-09-11 | Clearwater | Minnesota | 27029 | 23 | 0 |
506668 | 506668 | 2020-09-06 | Lac qui Parle | Minnesota | 27073 | 23 | 0 |
454994 | 454994 | 2020-08-21 | Stevens | Minnesota | 27149 | 23 | 0 |
409840 | 409840 | 2020-08-07 | Red Lake | Minnesota | 27125 | 23 | 0 |
406620 | 406620 | 2020-08-06 | Red Lake | Minnesota | 27125 | 23 | 0 |
400203 | 400203 | 2020-08-04 | Wadena | Minnesota | 27159 | 23 | 0 |
396951 | 396951 | 2020-08-03 | Mahnomen | Minnesota | 27087 | 23 | 1 |
396989 | 396989 | 2020-08-03 | Wadena | Minnesota | 27159 | 23 | 0 |
393735 | 393735 | 2020-08-02 | Mahnomen | Minnesota | 27087 | 23 | 1 |
393773 | 393773 | 2020-08-02 | Wadena | Minnesota | 27159 | 23 | 0 |
390556 | 390556 | 2020-08-01 | Wadena | Minnesota | 27159 | 23 | 0 |
387291 | 387291 | 2020-07-31 | Kanabec | Minnesota | 27065 | 23 | 1 |
387339 | 387339 | 2020-07-31 | Wadena | Minnesota | 27159 | 23 | 0 |
384073 | 384073 | 2020-07-30 | Kanabec | Minnesota | 27065 | 23 | 1 |
384121 | 384121 | 2020-07-30 | Wadena | Minnesota | 27159 | 23 | 0 |
380856 | 380856 | 2020-07-29 | Kanabec | Minnesota | 27065 | 23 | 1 |
380904 | 380904 | 2020-07-29 | Wadena | Minnesota | 27159 | 23 | 0 |
377639 | 377639 | 2020-07-28 | Kanabec | Minnesota | 27065 | 23 | 1 |
374424 | 374424 | 2020-07-27 | Kanabec | Minnesota | 27065 | 23 | 1 |
371212 | 371212 | 2020-07-26 | Kanabec | Minnesota | 27065 | 23 | 1 |
368054 | 368054 | 2020-07-25 | Wilkin | Minnesota | 27167 | 23 | 3 |
364846 | 364846 | 2020-07-24 | Wilkin | Minnesota | 27167 | 23 | 3 |
361639 | 361639 | 2020-07-23 | Wilkin | Minnesota | 27167 | 23 | 3 |
358393 | 358393 | 2020-07-22 | Marshall | Minnesota | 27089 | 23 | 0 |
358434 | 358434 | 2020-07-22 | Wilkin | Minnesota | 27167 | 23 | 3 |
355190 | 355190 | 2020-07-21 | Marshall | Minnesota | 27089 | 23 | 0 |
355200 | 355200 | 2020-07-21 | Norman | Minnesota | 27107 | 23 | 0 |
355231 | 355231 | 2020-07-21 | Wilkin | Minnesota | 27167 | 23 | 3 |
352029 | 352029 | 2020-07-20 | Wilkin | Minnesota | 27167 | 23 | 3 |
348829 | 348829 | 2020-07-19 | Wilkin | Minnesota | 27167 | 23 | 3 |
345628 | 345628 | 2020-07-18 | Wilkin | Minnesota | 27167 | 23 | 3 |
342428 | 342428 | 2020-07-17 | Wilkin | Minnesota | 27167 | 23 | 3 |
339232 | 339232 | 2020-07-16 | Wilkin | Minnesota | 27167 | 23 | 3 |
336036 | 336036 | 2020-07-15 | Wilkin | Minnesota | 27167 | 23 | 3 |
332843 | 332843 | 2020-07-14 | Wilkin | Minnesota | 27167 | 23 | 3 |
323266 | 323266 | 2020-07-11 | Redwood | Minnesota | 27127 | 23 | 0 |
313750 | 313750 | 2020-07-08 | Swift | Minnesota | 27151 | 23 | 1 |
285258 | 285258 | 2020-06-29 | Houston | Minnesota | 27055 | 23 | 0 |
278945 | 278945 | 2020-06-27 | Brown | Minnesota | 27015 | 23 | 2 |
275797 | 275797 | 2020-06-26 | Brown | Minnesota | 27015 | 23 | 2 |
272669 | 272669 | 2020-06-25 | Fillmore | Minnesota | 27045 | 23 | 0 |
269517 | 269517 | 2020-06-24 | Brown | Minnesota | 27015 | 23 | 2 |
269532 | 269532 | 2020-06-24 | Fillmore | Minnesota | 27045 | 23 | 0 |
266399 | 266399 | 2020-06-23 | Fillmore | Minnesota | 27045 | 23 | 0 |
266463 | 266463 | 2020-06-23 | Yellow Medicine | Minnesota | 27173 | 23 | 0 |
263273 | 263273 | 2020-06-22 | Fillmore | Minnesota | 27045 | 23 | 0 |
260144 | 260144 | 2020-06-21 | Fillmore | Minnesota | 27045 | 23 | 0 |
253879 | 253879 | 2020-06-19 | Beltrami | Minnesota | 27007 | 23 | 0 |
250764 | 250764 | 2020-06-18 | Beltrami | Minnesota | 27007 | 23 | 0 |
247652 | 247652 | 2020-06-17 | Beltrami | Minnesota | 27007 | 23 | 0 |
244539 | 244539 | 2020-06-16 | Beltrami | Minnesota | 27007 | 23 | 0 |
241428 | 241428 | 2020-06-15 | Beltrami | Minnesota | 27007 | 23 | 0 |
238319 | 238319 | 2020-06-14 | Beltrami | Minnesota | 27007 | 23 | 0 |
235274 | 235274 | 2020-06-13 | Rock | Minnesota | 27133 | 23 | 0 |
232168 | 232168 | 2020-06-12 | Rock | Minnesota | 27133 | 23 | 0 |
229064 | 229064 | 2020-06-11 | Rock | Minnesota | 27133 | 23 | 0 |
225962 | 225962 | 2020-06-10 | Rock | Minnesota | 27133 | 23 | 0 |
222864 | 222864 | 2020-06-09 | Rock | Minnesota | 27133 | 23 | 0 |
219769 | 219769 | 2020-06-08 | Rock | Minnesota | 27133 | 23 | 0 |
216633 | 216633 | 2020-06-07 | Faribault | Minnesota | 27043 | 23 | 0 |
216677 | 216677 | 2020-06-07 | Rock | Minnesota | 27133 | 23 | 0 |
213545 | 213545 | 2020-06-06 | Faribault | Minnesota | 27043 | 23 | 0 |
213589 | 213589 | 2020-06-06 | Rock | Minnesota | 27133 | 23 | 0 |
210505 | 210505 | 2020-06-05 | Rock | Minnesota | 27133 | 23 | 0 |
207405 | 207405 | 2020-06-04 | Mille Lacs | Minnesota | 27095 | 23 | 1 |
207414 | 207414 | 2020-06-04 | Pennington | Minnesota | 27113 | 23 | 0 |
207424 | 207424 | 2020-06-04 | Rock | Minnesota | 27133 | 23 | 0 |
204343 | 204343 | 2020-06-03 | Rock | Minnesota | 27133 | 23 | 0 |
167678 | 167678 | 2020-05-22 | Waseca | Minnesota | 27161 | 23 | 0 |
158529 | 158529 | 2020-05-19 | Douglas | Minnesota | 27041 | 23 | 0 |
146507 | 146507 | 2020-05-15 | Morrison | Minnesota | 27097 | 23 | 0 |
143510 | 143510 | 2020-05-14 | Nicollet | Minnesota | 27103 | 23 | 2 |
140479 | 140479 | 2020-05-13 | Chisago | Minnesota | 27025 | 23 | 1 |
140483 | 140483 | 2020-05-13 | Crow Wing | Minnesota | 27035 | 23 | 1 |
140510 | 140510 | 2020-05-13 | Meeker | Minnesota | 27093 | 23 | 0 |
137485 | 137485 | 2020-05-12 | Chisago | Minnesota | 27025 | 23 | 1 |
137489 | 137489 | 2020-05-12 | Crow Wing | Minnesota | 27035 | 23 | 1 |
137516 | 137516 | 2020-05-12 | Meeker | Minnesota | 27093 | 23 | 0 |
134499 | 134499 | 2020-05-11 | Crow Wing | Minnesota | 27035 | 23 | 1 |
131508 | 131508 | 2020-05-10 | Crow Wing | Minnesota | 27035 | 23 | 1 |
131544 | 131544 | 2020-05-10 | Otter Tail | Minnesota | 27111 | 23 | 0 |
128554 | 128554 | 2020-05-09 | Otter Tail | Minnesota | 27111 | 23 | 0 |
122549 | 122549 | 2020-05-07 | Crow Wing | Minnesota | 27035 | 23 | 1 |
119583 | 119583 | 2020-05-06 | Goodhue | Minnesota | 27049 | 23 | 0 |
116623 | 116623 | 2020-05-05 | Goodhue | Minnesota | 27049 | 23 | 0 |
113742 | 113742 | 2020-05-04 | Goodhue | Minnesota | 27049 | 23 | 0 |
105120 | 105120 | 2020-05-01 | Cottonwood | Minnesota | 27033 | 23 | 0 |
93745 | 93745 | 2020-04-27 | Le Sueur | Minnesota | 27079 | 23 | 0 |
90944 | 90944 | 2020-04-26 | Polk | Minnesota | 27119 | 23 | 0 |
71334 | 71334 | 2020-04-19 | Blue Earth | Minnesota | 27013 | 23 | 0 |
68570 | 68570 | 2020-04-18 | Blue Earth | Minnesota | 27013 | 23 | 0 |
68621 | 68621 | 2020-04-18 | Scott | Minnesota | 27139 | 23 | 1 |
68637 | 68637 | 2020-04-18 | Wright | Minnesota | 27171 | 23 | 1 |
65819 | 65819 | 2020-04-17 | Blue Earth | Minnesota | 27013 | 23 | 0 |
65869 | 65869 | 2020-04-17 | Scott | Minnesota | 27139 | 23 | 1 |
65885 | 65885 | 2020-04-17 | Wright | Minnesota | 27171 | 23 | 1 |
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);