ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where "date" is on date 2020-06-28 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282086 | 282086 | 2020-06-28 | Aitkin | Minnesota | 27001 | 13 | 0 |
282087 | 282087 | 2020-06-28 | Anoka | Minnesota | 27003 | 2053 | 106 |
282088 | 282088 | 2020-06-28 | Becker | Minnesota | 27005 | 54 | 0 |
282089 | 282089 | 2020-06-28 | Beltrami | Minnesota | 27007 | 27 | 0 |
282090 | 282090 | 2020-06-28 | Benton | Minnesota | 27009 | 208 | 3 |
282091 | 282091 | 2020-06-28 | Big Stone | Minnesota | 27011 | 14 | 0 |
282092 | 282092 | 2020-06-28 | Blue Earth | Minnesota | 27013 | 368 | 2 |
282093 | 282093 | 2020-06-28 | Brown | Minnesota | 27015 | 27 | 2 |
282094 | 282094 | 2020-06-28 | Carlton | Minnesota | 27017 | 81 | 0 |
282095 | 282095 | 2020-06-28 | Carver | Minnesota | 27019 | 333 | 1 |
282096 | 282096 | 2020-06-28 | Cass | Minnesota | 27021 | 12 | 2 |
282097 | 282097 | 2020-06-28 | Chippewa | Minnesota | 27023 | 74 | 1 |
282098 | 282098 | 2020-06-28 | Chisago | Minnesota | 27025 | 92 | 1 |
282099 | 282099 | 2020-06-28 | Clay | Minnesota | 27027 | 557 | 37 |
282100 | 282100 | 2020-06-28 | Clearwater | Minnesota | 27029 | 7 | 0 |
282101 | 282101 | 2020-06-28 | Cook | Minnesota | 27031 | 1 | 0 |
282102 | 282102 | 2020-06-28 | Cottonwood | Minnesota | 27033 | 131 | 0 |
282103 | 282103 | 2020-06-28 | Crow Wing | Minnesota | 27035 | 102 | 12 |
282104 | 282104 | 2020-06-28 | Dakota | Minnesota | 27037 | 2133 | 87 |
282105 | 282105 | 2020-06-28 | Dodge | Minnesota | 27039 | 79 | 0 |
282106 | 282106 | 2020-06-28 | Douglas | Minnesota | 27041 | 58 | 0 |
282107 | 282107 | 2020-06-28 | Faribault | Minnesota | 27043 | 48 | 0 |
282108 | 282108 | 2020-06-28 | Fillmore | Minnesota | 27045 | 25 | 0 |
282109 | 282109 | 2020-06-28 | Freeborn | Minnesota | 27047 | 280 | 0 |
282110 | 282110 | 2020-06-28 | Goodhue | Minnesota | 27049 | 117 | 8 |
282111 | 282111 | 2020-06-28 | Grant | Minnesota | 27051 | 6 | 0 |
282112 | 282112 | 2020-06-28 | Hennepin | Minnesota | 27053 | 11556 | 767 |
282113 | 282113 | 2020-06-28 | Houston | Minnesota | 27055 | 21 | 0 |
282114 | 282114 | 2020-06-28 | Hubbard | Minnesota | 27057 | 5 | 0 |
282115 | 282115 | 2020-06-28 | Isanti | Minnesota | 27059 | 60 | 0 |
282116 | 282116 | 2020-06-28 | Itasca | Minnesota | 27061 | 64 | 12 |
282117 | 282117 | 2020-06-28 | Jackson | Minnesota | 27063 | 54 | 0 |
282118 | 282118 | 2020-06-28 | Kanabec | Minnesota | 27065 | 13 | 1 |
282119 | 282119 | 2020-06-28 | Kandiyohi | Minnesota | 27067 | 565 | 1 |
282120 | 282120 | 2020-06-28 | Kittson | Minnesota | 27069 | 2 | 0 |
282121 | 282121 | 2020-06-28 | Koochiching | Minnesota | 27071 | 12 | 1 |
282122 | 282122 | 2020-06-28 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
282123 | 282123 | 2020-06-28 | Lake | Minnesota | 27075 | 6 | 0 |
282124 | 282124 | 2020-06-28 | Le Sueur | Minnesota | 27079 | 77 | 1 |
282125 | 282125 | 2020-06-28 | Lincoln | Minnesota | 27081 | 7 | 0 |
282126 | 282126 | 2020-06-28 | Lyon | Minnesota | 27083 | 294 | 2 |
282127 | 282127 | 2020-06-28 | Mahnomen | Minnesota | 27087 | 7 | 1 |
282128 | 282128 | 2020-06-28 | Marshall | Minnesota | 27089 | 12 | 0 |
282129 | 282129 | 2020-06-28 | Martin | Minnesota | 27091 | 154 | 5 |
282130 | 282130 | 2020-06-28 | McLeod | Minnesota | 27085 | 79 | 0 |
282131 | 282131 | 2020-06-28 | Meeker | Minnesota | 27093 | 57 | 1 |
282132 | 282132 | 2020-06-28 | Mille Lacs | Minnesota | 27095 | 32 | 1 |
282133 | 282133 | 2020-06-28 | Morrison | Minnesota | 27097 | 57 | 1 |
282134 | 282134 | 2020-06-28 | Mower | Minnesota | 27099 | 910 | 2 |
282135 | 282135 | 2020-06-28 | Murray | Minnesota | 27101 | 49 | 0 |
282136 | 282136 | 2020-06-28 | Nicollet | Minnesota | 27103 | 128 | 12 |
282137 | 282137 | 2020-06-28 | Nobles | Minnesota | 27105 | 1649 | 6 |
282138 | 282138 | 2020-06-28 | Norman | Minnesota | 27107 | 19 | 0 |
282139 | 282139 | 2020-06-28 | Olmsted | Minnesota | 27109 | 1020 | 15 |
282140 | 282140 | 2020-06-28 | Otter Tail | Minnesota | 27111 | 88 | 1 |
282141 | 282141 | 2020-06-28 | Pennington | Minnesota | 27113 | 50 | 0 |
282142 | 282142 | 2020-06-28 | Pine | Minnesota | 27115 | 99 | 0 |
282143 | 282143 | 2020-06-28 | Pipestone | Minnesota | 27117 | 20 | 1 |
282144 | 282144 | 2020-06-28 | Polk | Minnesota | 27119 | 79 | 2 |
282145 | 282145 | 2020-06-28 | Pope | Minnesota | 27121 | 10 | 0 |
282146 | 282146 | 2020-06-28 | Ramsey | Minnesota | 27123 | 4610 | 217 |
282147 | 282147 | 2020-06-28 | Red Lake | Minnesota | 27125 | 3 | 0 |
282148 | 282148 | 2020-06-28 | Redwood | Minnesota | 27127 | 14 | 0 |
282149 | 282149 | 2020-06-28 | Renville | Minnesota | 27129 | 24 | 1 |
282150 | 282150 | 2020-06-28 | Rice | Minnesota | 27131 | 793 | 4 |
282151 | 282151 | 2020-06-28 | Rock | Minnesota | 27133 | 29 | 0 |
282152 | 282152 | 2020-06-28 | Roseau | Minnesota | 27135 | 6 | 0 |
282153 | 282153 | 2020-06-28 | Scott | Minnesota | 27139 | 637 | 4 |
282154 | 282154 | 2020-06-28 | Sherburne | Minnesota | 27141 | 291 | 4 |
282155 | 282155 | 2020-06-28 | Sibley | Minnesota | 27143 | 43 | 2 |
282156 | 282156 | 2020-06-28 | St. Louis | Minnesota | 27137 | 156 | 14 |
282157 | 282157 | 2020-06-28 | Stearns | Minnesota | 27145 | 2200 | 19 |
282158 | 282158 | 2020-06-28 | Steele | Minnesota | 27147 | 212 | 0 |
282159 | 282159 | 2020-06-28 | Stevens | Minnesota | 27149 | 3 | 0 |
282160 | 282160 | 2020-06-28 | Swift | Minnesota | 27151 | 20 | 1 |
282161 | 282161 | 2020-06-28 | Todd | Minnesota | 27153 | 397 | 2 |
282162 | 282162 | 2020-06-28 | Traverse | Minnesota | 27155 | 5 | 0 |
282163 | 282163 | 2020-06-28 | Unknown | Minnesota | 117 | 35 | |
282164 | 282164 | 2020-06-28 | Wabasha | Minnesota | 27157 | 30 | 0 |
282165 | 282165 | 2020-06-28 | Wadena | Minnesota | 27159 | 15 | 0 |
282166 | 282166 | 2020-06-28 | Waseca | Minnesota | 27161 | 55 | 0 |
282167 | 282167 | 2020-06-28 | Washington | Minnesota | 27163 | 984 | 40 |
282168 | 282168 | 2020-06-28 | Watonwan | Minnesota | 27165 | 196 | 0 |
282169 | 282169 | 2020-06-28 | Wilkin | Minnesota | 27167 | 20 | 3 |
282170 | 282170 | 2020-06-28 | Winona | Minnesota | 27169 | 112 | 15 |
282171 | 282171 | 2020-06-28 | Wright | Minnesota | 27171 | 426 | 4 |
282172 | 282172 | 2020-06-28 | Yellow Medicine | Minnesota | 27173 | 27 | 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);