ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 28 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Mower 10
- Red Lake 8
- Mille Lacs 6
- Rock 5
- Wabasha 4
- Le Sueur 3
- Mahnomen 3
- Marshall 3
- Unknown 3
- Wilkin 3
- Aitkin 2
- Clearwater 2
- Fillmore 2
- Hubbard 2
- Kanabec 2
- Lake 2
- Redwood 2
- Renville 2
- Roseau 2
- Sibley 2
- Traverse 2
- Wadena 2
- Watonwan 2
- Beltrami 1
- Big Stone 1
- Cass 1
- Chippewa 1
- Cottonwood 1
- Dakota 1
- Dodge 1
- …
state 1
- Minnesota · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
577865 | 577865 | 2020-09-28 | Clearwater | Minnesota | 27029 | 28 | 0 |
574624 | 574624 | 2020-09-27 | Clearwater | Minnesota | 27029 | 28 | 0 |
526116 | 526116 | 2020-09-12 | Traverse | Minnesota | 27155 | 28 | 0 |
522880 | 522880 | 2020-09-11 | Traverse | Minnesota | 27155 | 28 | 0 |
480824 | 480824 | 2020-08-29 | Red Lake | Minnesota | 27125 | 28 | 0 |
477567 | 477567 | 2020-08-28 | Lake | Minnesota | 27075 | 28 | 0 |
477592 | 477592 | 2020-08-28 | Red Lake | Minnesota | 27125 | 28 | 0 |
474334 | 474334 | 2020-08-27 | Lake | Minnesota | 27075 | 28 | 0 |
474359 | 474359 | 2020-08-27 | Red Lake | Minnesota | 27125 | 28 | 0 |
471127 | 471127 | 2020-08-26 | Red Lake | Minnesota | 27125 | 28 | 0 |
467897 | 467897 | 2020-08-25 | Red Lake | Minnesota | 27125 | 28 | 0 |
464668 | 464668 | 2020-08-24 | Red Lake | Minnesota | 27125 | 28 | 0 |
464680 | 464680 | 2020-08-24 | Stevens | Minnesota | 27149 | 28 | 0 |
461437 | 461437 | 2020-08-23 | Red Lake | Minnesota | 27125 | 28 | 0 |
458210 | 458210 | 2020-08-22 | Red Lake | Minnesota | 27125 | 28 | 0 |
448469 | 448469 | 2020-08-19 | Big Stone | Minnesota | 27011 | 28 | 0 |
442054 | 442054 | 2020-08-17 | Mahnomen | Minnesota | 27087 | 28 | 1 |
438827 | 438827 | 2020-08-16 | Mahnomen | Minnesota | 27087 | 28 | 1 |
435602 | 435602 | 2020-08-15 | Mahnomen | Minnesota | 27087 | 28 | 1 |
432414 | 432414 | 2020-08-14 | Wadena | Minnesota | 27159 | 28 | 0 |
429187 | 429187 | 2020-08-13 | Wadena | Minnesota | 27159 | 28 | 0 |
400155 | 400155 | 2020-08-04 | Kanabec | Minnesota | 27065 | 28 | 1 |
400207 | 400207 | 2020-08-04 | Wilkin | Minnesota | 27167 | 28 | 3 |
396937 | 396937 | 2020-08-03 | Hubbard | Minnesota | 27057 | 28 | 0 |
396952 | 396952 | 2020-08-03 | Marshall | Minnesota | 27089 | 28 | 0 |
396993 | 396993 | 2020-08-03 | Wilkin | Minnesota | 27167 | 28 | 3 |
393693 | 393693 | 2020-08-02 | Aitkin | Minnesota | 27001 | 28 | 0 |
393721 | 393721 | 2020-08-02 | Hubbard | Minnesota | 27057 | 28 | 0 |
393725 | 393725 | 2020-08-02 | Kanabec | Minnesota | 27065 | 28 | 1 |
393736 | 393736 | 2020-08-02 | Marshall | Minnesota | 27089 | 28 | 0 |
393777 | 393777 | 2020-08-02 | Wilkin | Minnesota | 27167 | 28 | 3 |
390476 | 390476 | 2020-08-01 | Aitkin | Minnesota | 27001 | 28 | 0 |
390519 | 390519 | 2020-08-01 | Marshall | Minnesota | 27089 | 28 | 0 |
368033 | 368033 | 2020-07-25 | Redwood | Minnesota | 27127 | 28 | 0 |
364815 | 364815 | 2020-07-24 | Norman | Minnesota | 27107 | 28 | 0 |
364825 | 364825 | 2020-07-24 | Redwood | Minnesota | 27127 | 28 | 0 |
358410 | 358410 | 2020-07-22 | Pope | Minnesota | 27121 | 28 | 0 |
342355 | 342355 | 2020-07-17 | Cass | Minnesota | 27021 | 28 | 2 |
329639 | 329639 | 2020-07-13 | Roseau | Minnesota | 27135 | 28 | 0 |
326453 | 326453 | 2020-07-12 | Roseau | Minnesota | 27135 | 28 | 0 |
313703 | 313703 | 2020-07-08 | Houston | Minnesota | 27055 | 28 | 0 |
301029 | 301029 | 2020-07-04 | Fillmore | Minnesota | 27045 | 28 | 0 |
297866 | 297866 | 2020-07-03 | Fillmore | Minnesota | 27045 | 28 | 0 |
294749 | 294749 | 2020-07-02 | Renville | Minnesota | 27129 | 28 | 2 |
291535 | 291535 | 2020-07-01 | Beltrami | Minnesota | 27007 | 28 | 0 |
291595 | 291595 | 2020-07-01 | Renville | Minnesota | 27129 | 28 | 2 |
275868 | 275868 | 2020-06-26 | Wabasha | Minnesota | 27157 | 28 | 0 |
272712 | 272712 | 2020-06-25 | Rock | Minnesota | 27133 | 28 | 0 |
269575 | 269575 | 2020-06-24 | Rock | Minnesota | 27133 | 28 | 0 |
269588 | 269588 | 2020-06-24 | Wabasha | Minnesota | 27157 | 28 | 0 |
266442 | 266442 | 2020-06-23 | Rock | Minnesota | 27133 | 28 | 0 |
266455 | 266455 | 2020-06-23 | Wabasha | Minnesota | 27157 | 28 | 0 |
263316 | 263316 | 2020-06-22 | Rock | Minnesota | 27133 | 28 | 0 |
263329 | 263329 | 2020-06-22 | Wabasha | Minnesota | 27157 | 28 | 0 |
260187 | 260187 | 2020-06-21 | Rock | Minnesota | 27133 | 28 | 0 |
257065 | 257065 | 2020-06-20 | Sibley | Minnesota | 27143 | 28 | 2 |
253945 | 253945 | 2020-06-19 | Sibley | Minnesota | 27143 | 28 | 2 |
250807 | 250807 | 2020-06-18 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
247695 | 247695 | 2020-06-17 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
244557 | 244557 | 2020-06-16 | Faribault | Minnesota | 27043 | 28 | 0 |
244582 | 244582 | 2020-06-16 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
241471 | 241471 | 2020-06-15 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
238362 | 238362 | 2020-06-14 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
235255 | 235255 | 2020-06-13 | Mille Lacs | Minnesota | 27095 | 28 | 1 |
179810 | 179810 | 2020-05-26 | McLeod | Minnesota | 27085 | 28 | 0 |
176751 | 176751 | 2020-05-25 | Isanti | Minnesota | 27059 | 28 | 0 |
173755 | 173755 | 2020-05-24 | Unknown | Minnesota | 28 | 9 | |
164603 | 164603 | 2020-05-21 | Lyon | Minnesota | 27083 | 28 | 0 |
155566 | 155566 | 2020-05-18 | Unknown | Minnesota | 28 | 9 | |
149478 | 149478 | 2020-05-16 | Chippewa | Minnesota | 27023 | 28 | 0 |
149541 | 149541 | 2020-05-16 | Unknown | Minnesota | 28 | 9 | |
146510 | 146510 | 2020-05-15 | Nicollet | Minnesota | 27103 | 28 | 2 |
143480 | 143480 | 2020-05-14 | Dodge | Minnesota | 27039 | 28 | 0 |
140546 | 140546 | 2020-05-13 | Watonwan | Minnesota | 27165 | 28 | 0 |
137552 | 137552 | 2020-05-12 | Watonwan | Minnesota | 27165 | 28 | 0 |
131520 | 131520 | 2020-05-10 | Itasca | Minnesota | 27061 | 28 | 0 |
128538 | 128538 | 2020-05-09 | Le Sueur | Minnesota | 27079 | 28 | 0 |
125551 | 125551 | 2020-05-08 | Le Sueur | Minnesota | 27079 | 28 | 0 |
122569 | 122569 | 2020-05-07 | Le Sueur | Minnesota | 27079 | 28 | 0 |
110855 | 110855 | 2020-05-03 | Cottonwood | Minnesota | 27033 | 28 | 0 |
110885 | 110885 | 2020-05-03 | Mower | Minnesota | 27099 | 28 | 0 |
108014 | 108014 | 2020-05-02 | Mower | Minnesota | 27099 | 28 | 0 |
105149 | 105149 | 2020-05-01 | Mower | Minnesota | 27099 | 28 | 0 |
102288 | 102288 | 2020-04-30 | Mower | Minnesota | 27099 | 28 | 0 |
102307 | 102307 | 2020-04-30 | Sherburne | Minnesota | 27141 | 28 | 0 |
99436 | 99436 | 2020-04-29 | Mower | Minnesota | 27099 | 28 | 0 |
96590 | 96590 | 2020-04-28 | Mower | Minnesota | 27099 | 28 | 0 |
93755 | 93755 | 2020-04-27 | Mower | Minnesota | 27099 | 28 | 0 |
90934 | 90934 | 2020-04-26 | Mower | Minnesota | 27099 | 28 | 0 |
88104 | 88104 | 2020-04-25 | Kandiyohi | Minnesota | 27067 | 28 | 0 |
88118 | 88118 | 2020-04-25 | Mower | Minnesota | 27099 | 28 | 0 |
85308 | 85308 | 2020-04-24 | Mower | Minnesota | 27099 | 28 | 0 |
79726 | 79726 | 2020-04-22 | Scott | Minnesota | 27139 | 28 | 1 |
65834 | 65834 | 2020-04-17 | Freeborn | Minnesota | 27047 | 28 | 0 |
41816 | 41816 | 2020-04-08 | St. Louis | Minnesota | 27137 | 28 | 0 |
14827 | 14827 | 2020-03-27 | Dakota | Minnesota | 27037 | 28 | 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);