ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 33 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Houston 10
- Freeborn 8
- Grant 6
- Becker 5
- Murray 4
- Waseca 4
- Jackson 3
- Wabasha 3
- Cass 2
- Cook 2
- Faribault 2
- Hennepin 2
- Hubbard 2
- Mahnomen 2
- Marshall 2
- Red Lake 2
- Swift 2
- Wright 2
- Big Stone 1
- Blue Earth 1
- Dakota 1
- Goodhue 1
- Isanti 1
- Itasca 1
- Kittson 1
- Lac qui Parle 1
- Lake 1
- Le Sueur 1
- Lincoln 1
- Martin 1
- …
state 1
- Minnesota · 87 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
710839 | 710839 | 2020-11-08 | Cook | Minnesota | 27031 | 33 | 0 |
707595 | 707595 | 2020-11-07 | Cook | Minnesota | 27031 | 33 | 0 |
652474 | 652474 | 2020-10-21 | Kittson | Minnesota | 27069 | 33 | 0 |
539019 | 539019 | 2020-09-16 | Lac qui Parle | Minnesota | 27073 | 33 | 0 |
509927 | 509927 | 2020-09-07 | Red Lake | Minnesota | 27125 | 33 | 0 |
506694 | 506694 | 2020-09-06 | Red Lake | Minnesota | 27125 | 33 | 0 |
484034 | 484034 | 2020-08-30 | Lake | Minnesota | 27075 | 33 | 0 |
480767 | 480767 | 2020-08-29 | Big Stone | Minnesota | 27011 | 33 | 0 |
480805 | 480805 | 2020-08-29 | Marshall | Minnesota | 27089 | 33 | 0 |
477573 | 477573 | 2020-08-28 | Marshall | Minnesota | 27089 | 33 | 0 |
477604 | 477604 | 2020-08-28 | Stevens | Minnesota | 27149 | 33 | 0 |
471107 | 471107 | 2020-08-26 | Mahnomen | Minnesota | 27087 | 33 | 1 |
467877 | 467877 | 2020-08-25 | Mahnomen | Minnesota | 27087 | 33 | 1 |
416246 | 416246 | 2020-08-09 | Hubbard | Minnesota | 27057 | 33 | 0 |
413026 | 413026 | 2020-08-08 | Hubbard | Minnesota | 27057 | 33 | 0 |
409841 | 409841 | 2020-08-07 | Redwood | Minnesota | 27127 | 33 | 0 |
409862 | 409862 | 2020-08-07 | Wilkin | Minnesota | 27167 | 33 | 3 |
384094 | 384094 | 2020-07-30 | Norman | Minnesota | 27107 | 33 | 0 |
371207 | 371207 | 2020-07-26 | Houston | Minnesota | 27055 | 33 | 0 |
364790 | 364790 | 2020-07-24 | Houston | Minnesota | 27055 | 33 | 0 |
361581 | 361581 | 2020-07-23 | Grant | Minnesota | 27051 | 33 | 1 |
361583 | 361583 | 2020-07-23 | Houston | Minnesota | 27055 | 33 | 0 |
358361 | 358361 | 2020-07-22 | Cass | Minnesota | 27021 | 33 | 2 |
358376 | 358376 | 2020-07-22 | Grant | Minnesota | 27051 | 33 | 1 |
358378 | 358378 | 2020-07-22 | Houston | Minnesota | 27055 | 33 | 0 |
355173 | 355173 | 2020-07-21 | Grant | Minnesota | 27051 | 33 | 1 |
355175 | 355175 | 2020-07-21 | Houston | Minnesota | 27055 | 33 | 0 |
351971 | 351971 | 2020-07-20 | Grant | Minnesota | 27051 | 33 | 1 |
351973 | 351973 | 2020-07-20 | Houston | Minnesota | 27055 | 33 | 0 |
348756 | 348756 | 2020-07-19 | Cass | Minnesota | 27021 | 33 | 2 |
348771 | 348771 | 2020-07-19 | Grant | Minnesota | 27051 | 33 | 1 |
348773 | 348773 | 2020-07-19 | Houston | Minnesota | 27055 | 33 | 0 |
345570 | 345570 | 2020-07-18 | Grant | Minnesota | 27051 | 33 | 1 |
345572 | 345572 | 2020-07-18 | Houston | Minnesota | 27055 | 33 | 0 |
342372 | 342372 | 2020-07-17 | Houston | Minnesota | 27055 | 33 | 0 |
339176 | 339176 | 2020-07-16 | Houston | Minnesota | 27055 | 33 | 0 |
335992 | 335992 | 2020-07-15 | Lincoln | Minnesota | 27081 | 33 | 0 |
326461 | 326461 | 2020-07-12 | Swift | Minnesota | 27151 | 33 | 1 |
323278 | 323278 | 2020-07-11 | Swift | Minnesota | 27151 | 33 | 1 |
310584 | 310584 | 2020-07-07 | Wabasha | Minnesota | 27157 | 33 | 0 |
307416 | 307416 | 2020-07-06 | Wabasha | Minnesota | 27157 | 33 | 0 |
304249 | 304249 | 2020-07-05 | Wabasha | Minnesota | 27157 | 33 | 0 |
263272 | 263272 | 2020-06-22 | Faribault | Minnesota | 27043 | 33 | 0 |
260143 | 260143 | 2020-06-21 | Faribault | Minnesota | 27043 | 33 | 0 |
241505 | 241505 | 2020-06-15 | Waseca | Minnesota | 27161 | 33 | 0 |
238396 | 238396 | 2020-06-14 | Waseca | Minnesota | 27161 | 33 | 0 |
235289 | 235289 | 2020-06-13 | Waseca | Minnesota | 27161 | 33 | 0 |
232183 | 232183 | 2020-06-12 | Waseca | Minnesota | 27161 | 33 | 0 |
188969 | 188969 | 2020-05-29 | McLeod | Minnesota | 27085 | 33 | 0 |
182841 | 182841 | 2020-05-27 | Isanti | Minnesota | 27059 | 33 | 0 |
167603 | 167603 | 2020-05-22 | Becker | Minnesota | 27005 | 33 | 0 |
164567 | 164567 | 2020-05-21 | Becker | Minnesota | 27005 | 33 | 0 |
164612 | 164612 | 2020-05-21 | Murray | Minnesota | 27101 | 33 | 0 |
161583 | 161583 | 2020-05-20 | Murray | Minnesota | 27101 | 33 | 0 |
158557 | 158557 | 2020-05-19 | Murray | Minnesota | 27101 | 33 | 0 |
155494 | 155494 | 2020-05-18 | Becker | Minnesota | 27005 | 33 | 0 |
155539 | 155539 | 2020-05-18 | Murray | Minnesota | 27101 | 33 | 0 |
152480 | 152480 | 2020-05-17 | Becker | Minnesota | 27005 | 33 | 0 |
152501 | 152501 | 2020-05-17 | Goodhue | Minnesota | 27049 | 33 | 0 |
149469 | 149469 | 2020-05-16 | Becker | Minnesota | 27005 | 33 | 0 |
149515 | 149515 | 2020-05-16 | Nicollet | Minnesota | 27103 | 33 | 2 |
146498 | 146498 | 2020-05-15 | Le Sueur | Minnesota | 27079 | 33 | 1 |
146541 | 146541 | 2020-05-15 | Watonwan | Minnesota | 27165 | 33 | 0 |
143514 | 143514 | 2020-05-14 | Otter Tail | Minnesota | 27111 | 33 | 0 |
140496 | 140496 | 2020-05-13 | Jackson | Minnesota | 27063 | 33 | 0 |
137502 | 137502 | 2020-05-12 | Jackson | Minnesota | 27063 | 33 | 0 |
134511 | 134511 | 2020-05-11 | Itasca | Minnesota | 27061 | 33 | 0 |
134512 | 134512 | 2020-05-11 | Jackson | Minnesota | 27063 | 33 | 0 |
128574 | 128574 | 2020-05-09 | Todd | Minnesota | 27153 | 33 | 0 |
116645 | 116645 | 2020-05-05 | Mower | Minnesota | 27099 | 33 | 0 |
96553 | 96553 | 2020-04-28 | Blue Earth | Minnesota | 27013 | 33 | 0 |
93734 | 93734 | 2020-04-27 | Freeborn | Minnesota | 27047 | 33 | 0 |
90913 | 90913 | 2020-04-26 | Freeborn | Minnesota | 27047 | 33 | 0 |
90968 | 90968 | 2020-04-26 | Wright | Minnesota | 27171 | 33 | 1 |
88097 | 88097 | 2020-04-25 | Freeborn | Minnesota | 27047 | 33 | 0 |
88152 | 88152 | 2020-04-25 | Wright | Minnesota | 27171 | 33 | 1 |
85287 | 85287 | 2020-04-24 | Freeborn | Minnesota | 27047 | 33 | 0 |
85330 | 85330 | 2020-04-24 | Stearns | Minnesota | 27145 | 33 | 0 |
82483 | 82483 | 2020-04-23 | Freeborn | Minnesota | 27047 | 33 | 0 |
79687 | 79687 | 2020-04-22 | Freeborn | Minnesota | 27047 | 33 | 0 |
76902 | 76902 | 2020-04-21 | Freeborn | Minnesota | 27047 | 33 | 0 |
74122 | 74122 | 2020-04-20 | Freeborn | Minnesota | 27047 | 33 | 0 |
44392 | 44392 | 2020-04-09 | St. Louis | Minnesota | 27137 | 33 | 1 |
36735 | 36735 | 2020-04-06 | Martin | Minnesota | 27091 | 33 | 4 |
16649 | 16649 | 2020-03-28 | Dakota | Minnesota | 27037 | 33 | 0 |
4767 | 4767 | 2020-03-19 | Hennepin | Minnesota | 27053 | 33 | 0 |
4057 | 4057 | 2020-03-18 | Hennepin | Minnesota | 27053 | 33 | 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);