ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where date = "2020-06-25" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272647 | 272647 | 2020-06-25 | Aitkin | Minnesota | 27001 | 13 | 0 |
272648 | 272648 | 2020-06-25 | Anoka | Minnesota | 27003 | 1961 | 103 |
272649 | 272649 | 2020-06-25 | Becker | Minnesota | 27005 | 53 | 0 |
272650 | 272650 | 2020-06-25 | Beltrami | Minnesota | 27007 | 27 | 0 |
272651 | 272651 | 2020-06-25 | Benton | Minnesota | 27009 | 203 | 3 |
272652 | 272652 | 2020-06-25 | Big Stone | Minnesota | 27011 | 14 | 0 |
272653 | 272653 | 2020-06-25 | Blue Earth | Minnesota | 27013 | 281 | 2 |
272654 | 272654 | 2020-06-25 | Brown | Minnesota | 27015 | 22 | 2 |
272655 | 272655 | 2020-06-25 | Carlton | Minnesota | 27017 | 81 | 0 |
272656 | 272656 | 2020-06-25 | Carver | Minnesota | 27019 | 308 | 1 |
272657 | 272657 | 2020-06-25 | Cass | Minnesota | 27021 | 11 | 2 |
272658 | 272658 | 2020-06-25 | Chippewa | Minnesota | 27023 | 69 | 1 |
272659 | 272659 | 2020-06-25 | Chisago | Minnesota | 27025 | 88 | 1 |
272660 | 272660 | 2020-06-25 | Clay | Minnesota | 27027 | 537 | 37 |
272661 | 272661 | 2020-06-25 | Clearwater | Minnesota | 27029 | 7 | 0 |
272662 | 272662 | 2020-06-25 | Cook | Minnesota | 27031 | 1 | 0 |
272663 | 272663 | 2020-06-25 | Cottonwood | Minnesota | 27033 | 127 | 0 |
272664 | 272664 | 2020-06-25 | Crow Wing | Minnesota | 27035 | 97 | 11 |
272665 | 272665 | 2020-06-25 | Dakota | Minnesota | 27037 | 2012 | 85 |
272666 | 272666 | 2020-06-25 | Dodge | Minnesota | 27039 | 67 | 0 |
272667 | 272667 | 2020-06-25 | Douglas | Minnesota | 27041 | 55 | 0 |
272668 | 272668 | 2020-06-25 | Faribault | Minnesota | 27043 | 41 | 0 |
272669 | 272669 | 2020-06-25 | Fillmore | Minnesota | 27045 | 23 | 0 |
272670 | 272670 | 2020-06-25 | Freeborn | Minnesota | 27047 | 262 | 0 |
272671 | 272671 | 2020-06-25 | Goodhue | Minnesota | 27049 | 109 | 8 |
272672 | 272672 | 2020-06-25 | Grant | Minnesota | 27051 | 6 | 0 |
272673 | 272673 | 2020-06-25 | Hennepin | Minnesota | 27053 | 11178 | 758 |
272674 | 272674 | 2020-06-25 | Houston | Minnesota | 27055 | 16 | 0 |
272675 | 272675 | 2020-06-25 | Hubbard | Minnesota | 27057 | 5 | 0 |
272676 | 272676 | 2020-06-25 | Isanti | Minnesota | 27059 | 56 | 0 |
272677 | 272677 | 2020-06-25 | Itasca | Minnesota | 27061 | 63 | 12 |
272678 | 272678 | 2020-06-25 | Jackson | Minnesota | 27063 | 53 | 0 |
272679 | 272679 | 2020-06-25 | Kanabec | Minnesota | 27065 | 13 | 1 |
272680 | 272680 | 2020-06-25 | Kandiyohi | Minnesota | 27067 | 564 | 1 |
272681 | 272681 | 2020-06-25 | Kittson | Minnesota | 27069 | 1 | 0 |
272682 | 272682 | 2020-06-25 | Koochiching | Minnesota | 27071 | 9 | 0 |
272683 | 272683 | 2020-06-25 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
272684 | 272684 | 2020-06-25 | Lake | Minnesota | 27075 | 5 | 0 |
272685 | 272685 | 2020-06-25 | Le Sueur | Minnesota | 27079 | 71 | 1 |
272686 | 272686 | 2020-06-25 | Lincoln | Minnesota | 27081 | 7 | 0 |
272687 | 272687 | 2020-06-25 | Lyon | Minnesota | 27083 | 284 | 2 |
272688 | 272688 | 2020-06-25 | Mahnomen | Minnesota | 27087 | 6 | 1 |
272689 | 272689 | 2020-06-25 | Marshall | Minnesota | 27089 | 12 | 0 |
272690 | 272690 | 2020-06-25 | Martin | Minnesota | 27091 | 148 | 5 |
272691 | 272691 | 2020-06-25 | McLeod | Minnesota | 27085 | 75 | 0 |
272692 | 272692 | 2020-06-25 | Meeker | Minnesota | 27093 | 57 | 1 |
272693 | 272693 | 2020-06-25 | Mille Lacs | Minnesota | 27095 | 31 | 1 |
272694 | 272694 | 2020-06-25 | Morrison | Minnesota | 27097 | 56 | 1 |
272695 | 272695 | 2020-06-25 | Mower | Minnesota | 27099 | 847 | 2 |
272696 | 272696 | 2020-06-25 | Murray | Minnesota | 27101 | 47 | 0 |
272697 | 272697 | 2020-06-25 | Nicollet | Minnesota | 27103 | 115 | 12 |
272698 | 272698 | 2020-06-25 | Nobles | Minnesota | 27105 | 1637 | 6 |
272699 | 272699 | 2020-06-25 | Norman | Minnesota | 27107 | 19 | 0 |
272700 | 272700 | 2020-06-25 | Olmsted | Minnesota | 27109 | 948 | 15 |
272701 | 272701 | 2020-06-25 | Otter Tail | Minnesota | 27111 | 85 | 1 |
272702 | 272702 | 2020-06-25 | Pennington | Minnesota | 27113 | 50 | 0 |
272703 | 272703 | 2020-06-25 | Pine | Minnesota | 27115 | 98 | 0 |
272704 | 272704 | 2020-06-25 | Pipestone | Minnesota | 27117 | 15 | 0 |
272705 | 272705 | 2020-06-25 | Polk | Minnesota | 27119 | 75 | 2 |
272706 | 272706 | 2020-06-25 | Pope | Minnesota | 27121 | 10 | 0 |
272707 | 272707 | 2020-06-25 | Ramsey | Minnesota | 27123 | 4474 | 217 |
272708 | 272708 | 2020-06-25 | Red Lake | Minnesota | 27125 | 3 | 0 |
272709 | 272709 | 2020-06-25 | Redwood | Minnesota | 27127 | 12 | 0 |
272710 | 272710 | 2020-06-25 | Renville | Minnesota | 27129 | 19 | 1 |
272711 | 272711 | 2020-06-25 | Rice | Minnesota | 27131 | 771 | 4 |
272712 | 272712 | 2020-06-25 | Rock | Minnesota | 27133 | 28 | 0 |
272713 | 272713 | 2020-06-25 | Roseau | Minnesota | 27135 | 6 | 0 |
272714 | 272714 | 2020-06-25 | Scott | Minnesota | 27139 | 609 | 4 |
272715 | 272715 | 2020-06-25 | Sherburne | Minnesota | 27141 | 278 | 4 |
272716 | 272716 | 2020-06-25 | Sibley | Minnesota | 27143 | 35 | 2 |
272717 | 272717 | 2020-06-25 | St. Louis | Minnesota | 27137 | 151 | 14 |
272718 | 272718 | 2020-06-25 | Stearns | Minnesota | 27145 | 2141 | 19 |
272719 | 272719 | 2020-06-25 | Steele | Minnesota | 27147 | 206 | 0 |
272720 | 272720 | 2020-06-25 | Stevens | Minnesota | 27149 | 3 | 0 |
272721 | 272721 | 2020-06-25 | Swift | Minnesota | 27151 | 20 | 1 |
272722 | 272722 | 2020-06-25 | Todd | Minnesota | 27153 | 395 | 2 |
272723 | 272723 | 2020-06-25 | Traverse | Minnesota | 27155 | 5 | 0 |
272724 | 272724 | 2020-06-25 | Unknown | Minnesota | 114 | 35 | |
272725 | 272725 | 2020-06-25 | Wabasha | Minnesota | 27157 | 29 | 0 |
272726 | 272726 | 2020-06-25 | Wadena | Minnesota | 27159 | 15 | 0 |
272727 | 272727 | 2020-06-25 | Waseca | Minnesota | 27161 | 46 | 0 |
272728 | 272728 | 2020-06-25 | Washington | Minnesota | 27163 | 926 | 39 |
272729 | 272729 | 2020-06-25 | Watonwan | Minnesota | 27165 | 175 | 0 |
272730 | 272730 | 2020-06-25 | Wilkin | Minnesota | 27167 | 20 | 3 |
272731 | 272731 | 2020-06-25 | Winona | Minnesota | 27169 | 107 | 15 |
272732 | 272732 | 2020-06-25 | Wright | Minnesota | 27171 | 411 | 3 |
272733 | 272733 | 2020-06-25 | Yellow Medicine | Minnesota | 27173 | 24 | 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);