ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 71 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
- Winona 4
- Carlton 3
- Grant 3
- Lincoln 3
- Mille Lacs 3
- Crow Wing 2
- Itasca 2
- St. Louis 2
- Waseca 2
- Wilkin 2
- Aitkin 1
- Becker 1
- Beltrami 1
- Big Stone 1
- Blue Earth 1
- Cass 1
- Clearwater 1
- Dakota 1
- Fillmore 1
- Goodhue 1
- Hubbard 1
- Jackson 1
- Kanabec 1
- Lake of the Woods 1
- Le Sueur 1
- Lyon 1
- McLeod 1
- Nicollet 1
- Norman 1
- Otter Tail 1
- …
state 1
- Minnesota · 57 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733567 | 733567 | 2020-11-15 | Lake of the Woods | Minnesota | 27077 | 71 | 1 |
704414 | 704414 | 2020-11-06 | Traverse | Minnesota | 27155 | 71 | 0 |
639471 | 639471 | 2020-10-17 | Clearwater | Minnesota | 27029 | 71 | 0 |
613533 | 613533 | 2020-10-09 | Grant | Minnesota | 27051 | 71 | 4 |
610291 | 610291 | 2020-10-08 | Grant | Minnesota | 27051 | 71 | 4 |
607049 | 607049 | 2020-10-07 | Grant | Minnesota | 27051 | 71 | 4 |
607077 | 607077 | 2020-10-07 | Norman | Minnesota | 27107 | 71 | 0 |
584417 | 584417 | 2020-09-30 | Wilkin | Minnesota | 27167 | 71 | 3 |
581176 | 581176 | 2020-09-29 | Wilkin | Minnesota | 27167 | 71 | 3 |
558413 | 558413 | 2020-09-22 | Big Stone | Minnesota | 27011 | 71 | 0 |
551933 | 551933 | 2020-09-20 | Aitkin | Minnesota | 27001 | 71 | 1 |
545484 | 545484 | 2020-09-18 | Hubbard | Minnesota | 27057 | 71 | 0 |
509940 | 509940 | 2020-09-07 | Swift | Minnesota | 27151 | 71 | 1 |
503439 | 503439 | 2020-09-05 | Lincoln | Minnesota | 27081 | 71 | 0 |
503473 | 503473 | 2020-09-05 | Stevens | Minnesota | 27149 | 71 | 1 |
500197 | 500197 | 2020-09-04 | Kanabec | Minnesota | 27065 | 71 | 6 |
500205 | 500205 | 2020-09-04 | Lincoln | Minnesota | 27081 | 71 | 0 |
496971 | 496971 | 2020-09-03 | Lincoln | Minnesota | 27081 | 71 | 0 |
493761 | 493761 | 2020-09-02 | Redwood | Minnesota | 27127 | 71 | 0 |
458212 | 458212 | 2020-08-22 | Renville | Minnesota | 27129 | 71 | 5 |
425905 | 425905 | 2020-08-12 | Fillmore | Minnesota | 27045 | 71 | 0 |
419486 | 419486 | 2020-08-10 | Mille Lacs | Minnesota | 27095 | 71 | 3 |
416265 | 416265 | 2020-08-09 | Mille Lacs | Minnesota | 27095 | 71 | 3 |
413045 | 413045 | 2020-08-08 | Mille Lacs | Minnesota | 27095 | 71 | 3 |
406568 | 406568 | 2020-08-06 | Cass | Minnesota | 27021 | 71 | 2 |
403371 | 403371 | 2020-08-05 | Jackson | Minnesota | 27063 | 71 | 0 |
368040 | 368040 | 2020-07-25 | Sibley | Minnesota | 27143 | 71 | 2 |
339151 | 339151 | 2020-07-16 | Becker | Minnesota | 27005 | 71 | 0 |
339152 | 339152 | 2020-07-16 | Beltrami | Minnesota | 27007 | 71 | 0 |
326417 | 326417 | 2020-07-12 | Itasca | Minnesota | 27061 | 71 | 12 |
323234 | 323234 | 2020-07-11 | Itasca | Minnesota | 27061 | 71 | 12 |
313756 | 313756 | 2020-07-08 | Waseca | Minnesota | 27161 | 71 | 0 |
310586 | 310586 | 2020-07-07 | Waseca | Minnesota | 27161 | 71 | 0 |
272685 | 272685 | 2020-06-25 | Le Sueur | Minnesota | 27079 | 71 | 1 |
269554 | 269554 | 2020-06-24 | McLeod | Minnesota | 27085 | 71 | 0 |
257054 | 257054 | 2020-06-20 | Polk | Minnesota | 27119 | 71 | 2 |
207383 | 207383 | 2020-06-04 | Goodhue | Minnesota | 27049 | 71 | 5 |
204318 | 204318 | 2020-06-03 | Lyon | Minnesota | 27083 | 71 | 1 |
204332 | 204332 | 2020-06-03 | Otter Tail | Minnesota | 27111 | 71 | 0 |
198145 | 198145 | 2020-06-01 | Crow Wing | Minnesota | 27035 | 71 | 2 |
195074 | 195074 | 2020-05-31 | Crow Wing | Minnesota | 27035 | 71 | 2 |
192071 | 192071 | 2020-05-30 | Watonwan | Minnesota | 27165 | 71 | 0 |
182888 | 182888 | 2020-05-27 | Unknown | Minnesota | 71 | 10 | |
179816 | 179816 | 2020-05-26 | Nicollet | Minnesota | 27103 | 71 | 6 |
170646 | 170646 | 2020-05-23 | Carlton | Minnesota | 27017 | 71 | 0 |
167609 | 167609 | 2020-05-22 | Carlton | Minnesota | 27017 | 71 | 0 |
164573 | 164573 | 2020-05-21 | Carlton | Minnesota | 27017 | 71 | 0 |
143468 | 143468 | 2020-05-14 | Blue Earth | Minnesota | 27013 | 71 | 0 |
140548 | 140548 | 2020-05-13 | Winona | Minnesota | 27169 | 71 | 15 |
137554 | 137554 | 2020-05-12 | Winona | Minnesota | 27169 | 71 | 15 |
134564 | 134564 | 2020-05-11 | Winona | Minnesota | 27169 | 71 | 15 |
131573 | 131573 | 2020-05-10 | Winona | Minnesota | 27169 | 71 | 15 |
116665 | 116665 | 2020-05-05 | Sherburne | Minnesota | 27141 | 71 | 1 |
102309 | 102309 | 2020-04-30 | St. Louis | Minnesota | 27137 | 71 | 11 |
99457 | 99457 | 2020-04-29 | St. Louis | Minnesota | 27137 | 71 | 11 |
39225 | 39225 | 2020-04-07 | Dakota | Minnesota | 27037 | 71 | 3 |
29477 | 29477 | 2020-04-03 | Ramsey | Minnesota | 27123 | 71 | 2 |
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);