ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 58 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
759513 | 759513 | 2020-11-23 | Cook | Minnesota | 27031 | 58 | 0 |
704375 | 704375 | 2020-11-06 | Lake of the Woods | Minnesota | 27077 | 58 | 1 |
675225 | 675225 | 2020-10-28 | Traverse | Minnesota | 27155 | 58 | 0 |
671982 | 671982 | 2020-10-27 | Traverse | Minnesota | 27155 | 58 | 0 |
600582 | 600582 | 2020-10-05 | Marshall | Minnesota | 27089 | 58 | 1 |
597339 | 597339 | 2020-10-04 | Marshall | Minnesota | 27089 | 58 | 1 |
584386 | 584386 | 2020-09-30 | Norman | Minnesota | 27107 | 58 | 0 |
571403 | 571403 | 2020-09-26 | Lac qui Parle | Minnesota | 27073 | 58 | 1 |
568162 | 568162 | 2020-09-25 | Lake | Minnesota | 27075 | 58 | 0 |
564922 | 564922 | 2020-09-24 | Lake | Minnesota | 27075 | 58 | 0 |
561729 | 561729 | 2020-09-23 | Wilkin | Minnesota | 27167 | 58 | 3 |
551958 | 551958 | 2020-09-20 | Grant | Minnesota | 27051 | 58 | 4 |
529300 | 529300 | 2020-09-13 | Grant | Minnesota | 27051 | 58 | 4 |
526119 | 526119 | 2020-09-12 | Wadena | Minnesota | 27159 | 58 | 0 |
503399 | 503399 | 2020-09-05 | Aitkin | Minnesota | 27001 | 58 | 1 |
464666 | 464666 | 2020-08-24 | Pope | Minnesota | 27121 | 58 | 0 |
458223 | 458223 | 2020-08-22 | Swift | Minnesota | 27151 | 58 | 1 |
454987 | 454987 | 2020-08-21 | Roseau | Minnesota | 27135 | 58 | 0 |
454995 | 454995 | 2020-08-21 | Swift | Minnesota | 27151 | 58 | 1 |
451759 | 451759 | 2020-08-20 | Roseau | Minnesota | 27135 | 58 | 0 |
451767 | 451767 | 2020-08-20 | Swift | Minnesota | 27151 | 58 | 1 |
448539 | 448539 | 2020-08-19 | Swift | Minnesota | 27151 | 58 | 1 |
445313 | 445313 | 2020-08-18 | Swift | Minnesota | 27151 | 58 | 1 |
442087 | 442087 | 2020-08-17 | Swift | Minnesota | 27151 | 58 | 1 |
438860 | 438860 | 2020-08-16 | Swift | Minnesota | 27151 | 58 | 1 |
422701 | 422701 | 2020-08-11 | Lincoln | Minnesota | 27081 | 58 | 0 |
419479 | 419479 | 2020-08-10 | Lincoln | Minnesota | 27081 | 58 | 0 |
416258 | 416258 | 2020-08-09 | Lincoln | Minnesota | 27081 | 58 | 0 |
396919 | 396919 | 2020-08-03 | Cass | Minnesota | 27021 | 58 | 2 |
393703 | 393703 | 2020-08-02 | Cass | Minnesota | 27021 | 58 | 2 |
393757 | 393757 | 2020-08-02 | Renville | Minnesota | 27129 | 58 | 5 |
384063 | 384063 | 2020-07-30 | Fillmore | Minnesota | 27045 | 58 | 0 |
374427 | 374427 | 2020-07-27 | Koochiching | Minnesota | 27071 | 58 | 3 |
345600 | 345600 | 2020-07-18 | Pennington | Minnesota | 27113 | 58 | 0 |
342400 | 342400 | 2020-07-17 | Pennington | Minnesota | 27113 | 58 | 0 |
332763 | 332763 | 2020-07-14 | Beltrami | Minnesota | 27007 | 58 | 0 |
332791 | 332791 | 2020-07-14 | Jackson | Minnesota | 27063 | 58 | 0 |
332829 | 332829 | 2020-07-14 | Sibley | Minnesota | 27143 | 58 | 2 |
329604 | 329604 | 2020-07-13 | Jackson | Minnesota | 27063 | 58 | 0 |
326456 | 326456 | 2020-07-12 | Sibley | Minnesota | 27143 | 58 | 2 |
323273 | 323273 | 2020-07-11 | Sibley | Minnesota | 27143 | 58 | 2 |
301056 | 301056 | 2020-07-04 | Murray | Minnesota | 27101 | 58 | 0 |
297893 | 297893 | 2020-07-03 | Murray | Minnesota | 27101 | 58 | 0 |
291577 | 291577 | 2020-07-01 | Meeker | Minnesota | 27093 | 58 | 1 |
291612 | 291612 | 2020-07-01 | Waseca | Minnesota | 27161 | 58 | 0 |
288426 | 288426 | 2020-06-30 | Meeker | Minnesota | 27093 | 58 | 1 |
288428 | 288428 | 2020-06-30 | Morrison | Minnesota | 27097 | 58 | 1 |
285251 | 285251 | 2020-06-29 | Douglas | Minnesota | 27041 | 58 | 0 |
285278 | 285278 | 2020-06-29 | Morrison | Minnesota | 27097 | 58 | 1 |
282106 | 282106 | 2020-06-28 | Douglas | Minnesota | 27041 | 58 | 0 |
278958 | 278958 | 2020-06-27 | Douglas | Minnesota | 27041 | 58 | 0 |
278967 | 278967 | 2020-06-27 | Isanti | Minnesota | 27059 | 58 | 0 |
250805 | 250805 | 2020-06-18 | McLeod | Minnesota | 27085 | 58 | 0 |
247660 | 247660 | 2020-06-17 | Chippewa | Minnesota | 27023 | 58 | 1 |
235239 | 235239 | 2020-06-13 | Itasca | Minnesota | 27061 | 58 | 12 |
232122 | 232122 | 2020-06-12 | Dodge | Minnesota | 27039 | 58 | 0 |
232133 | 232133 | 2020-06-12 | Itasca | Minnesota | 27061 | 58 | 12 |
229029 | 229029 | 2020-06-11 | Itasca | Minnesota | 27061 | 58 | 12 |
225927 | 225927 | 2020-06-10 | Itasca | Minnesota | 27061 | 58 | 12 |
179790 | 179790 | 2020-05-26 | Goodhue | Minnesota | 27049 | 58 | 3 |
179847 | 179847 | 2020-05-26 | Watonwan | Minnesota | 27165 | 58 | 0 |
173737 | 173737 | 2020-05-24 | Polk | Minnesota | 27119 | 58 | 2 |
155507 | 155507 | 2020-05-18 | Cottonwood | Minnesota | 27033 | 58 | 0 |
152524 | 152524 | 2020-05-17 | Mower | Minnesota | 27099 | 58 | 0 |
128572 | 128572 | 2020-05-09 | Steele | Minnesota | 27147 | 58 | 0 |
122542 | 122542 | 2020-05-07 | Carver | Minnesota | 27019 | 58 | 0 |
110893 | 110893 | 2020-05-03 | Pine | Minnesota | 27115 | 58 | 0 |
110903 | 110903 | 2020-05-03 | Scott | Minnesota | 27139 | 58 | 1 |
108022 | 108022 | 2020-05-02 | Pine | Minnesota | 27115 | 58 | 0 |
105157 | 105157 | 2020-05-01 | Pine | Minnesota | 27115 | 58 | 0 |
82525 | 82525 | 2020-04-23 | St. Louis | Minnesota | 27137 | 58 | 10 |
49593 | 49593 | 2020-04-11 | Anoka | Minnesota | 27003 | 58 | 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);