ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-12-20" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
847124 | 847124 | 2020-12-20 | Aitkin | Minnesota | 27001 | 974 | 31 |
847125 | 847125 | 2020-12-20 | Anoka | Minnesota | 27003 | 27829 | 291 |
847126 | 847126 | 2020-12-20 | Becker | Minnesota | 27005 | 2602 | 31 |
847127 | 847127 | 2020-12-20 | Beltrami | Minnesota | 27007 | 2773 | 33 |
847128 | 847128 | 2020-12-20 | Benton | Minnesota | 27009 | 3726 | 72 |
847129 | 847129 | 2020-12-20 | Big Stone | Minnesota | 27011 | 420 | 3 |
847130 | 847130 | 2020-12-20 | Blue Earth | Minnesota | 27013 | 4831 | 24 |
847131 | 847131 | 2020-12-20 | Brown | Minnesota | 27015 | 1910 | 26 |
847132 | 847132 | 2020-12-20 | Carlton | Minnesota | 27017 | 2475 | 33 |
847133 | 847133 | 2020-12-20 | Carver | Minnesota | 27019 | 6182 | 29 |
847134 | 847134 | 2020-12-20 | Cass | Minnesota | 27021 | 1845 | 17 |
847135 | 847135 | 2020-12-20 | Chippewa | Minnesota | 27023 | 1214 | 19 |
847136 | 847136 | 2020-12-20 | Chisago | Minnesota | 27025 | 3962 | 25 |
847137 | 847137 | 2020-12-20 | Clay | Minnesota | 27027 | 5983 | 73 |
847138 | 847138 | 2020-12-20 | Clearwater | Minnesota | 27029 | 628 | 12 |
847139 | 847139 | 2020-12-20 | Cook | Minnesota | 27031 | 100 | 0 |
847140 | 847140 | 2020-12-20 | Cottonwood | Minnesota | 27033 | 1189 | 11 |
847141 | 847141 | 2020-12-20 | Crow Wing | Minnesota | 27035 | 4375 | 51 |
847142 | 847142 | 2020-12-20 | Dakota | Minnesota | 27037 | 28677 | 255 |
847143 | 847143 | 2020-12-20 | Dodge | Minnesota | 27039 | 1124 | 3 |
847144 | 847144 | 2020-12-20 | Douglas | Minnesota | 27041 | 3309 | 55 |
847145 | 847145 | 2020-12-20 | Faribault | Minnesota | 27043 | 836 | 8 |
847146 | 847146 | 2020-12-20 | Fillmore | Minnesota | 27045 | 1001 | 0 |
847147 | 847147 | 2020-12-20 | Freeborn | Minnesota | 27047 | 1860 | 17 |
847148 | 847148 | 2020-12-20 | Goodhue | Minnesota | 27049 | 2801 | 37 |
847149 | 847149 | 2020-12-20 | Grant | Minnesota | 27051 | 359 | 7 |
847150 | 847150 | 2020-12-20 | Hennepin | Minnesota | 27053 | 82734 | 1313 |
847151 | 847151 | 2020-12-20 | Houston | Minnesota | 27055 | 1074 | 9 |
847152 | 847152 | 2020-12-20 | Hubbard | Minnesota | 27057 | 1355 | 34 |
847153 | 847153 | 2020-12-20 | Isanti | Minnesota | 27059 | 2514 | 27 |
847154 | 847154 | 2020-12-20 | Itasca | Minnesota | 27061 | 2586 | 31 |
847155 | 847155 | 2020-12-20 | Jackson | Minnesota | 27063 | 740 | 5 |
847156 | 847156 | 2020-12-20 | Kanabec | Minnesota | 27065 | 893 | 18 |
847157 | 847157 | 2020-12-20 | Kandiyohi | Minnesota | 27067 | 5214 | 55 |
847158 | 847158 | 2020-12-20 | Kittson | Minnesota | 27069 | 337 | 17 |
847159 | 847159 | 2020-12-20 | Koochiching | Minnesota | 27071 | 525 | 8 |
847160 | 847160 | 2020-12-20 | Lac qui Parle | Minnesota | 27073 | 561 | 13 |
847161 | 847161 | 2020-12-20 | Lake | Minnesota | 27075 | 515 | 14 |
847162 | 847162 | 2020-12-20 | Lake of the Woods | Minnesota | 27077 | 144 | 1 |
847163 | 847163 | 2020-12-20 | Le Sueur | Minnesota | 27079 | 1861 | 14 |
847164 | 847164 | 2020-12-20 | Lincoln | Minnesota | 27081 | 436 | 1 |
847165 | 847165 | 2020-12-20 | Lyon | Minnesota | 27083 | 2708 | 26 |
847166 | 847166 | 2020-12-20 | Mahnomen | Minnesota | 27087 | 369 | 6 |
847167 | 847167 | 2020-12-20 | Marshall | Minnesota | 27089 | 659 | 11 |
847168 | 847168 | 2020-12-20 | Martin | Minnesota | 27091 | 1506 | 23 |
847169 | 847169 | 2020-12-20 | McLeod | Minnesota | 27085 | 2964 | 34 |
847170 | 847170 | 2020-12-20 | Meeker | Minnesota | 27093 | 1807 | 30 |
847171 | 847171 | 2020-12-20 | Mille Lacs | Minnesota | 27095 | 1961 | 42 |
847172 | 847172 | 2020-12-20 | Morrison | Minnesota | 27097 | 2833 | 38 |
847173 | 847173 | 2020-12-20 | Mower | Minnesota | 27099 | 3221 | 23 |
847174 | 847174 | 2020-12-20 | Murray | Minnesota | 27101 | 721 | 5 |
847175 | 847175 | 2020-12-20 | Nicollet | Minnesota | 27103 | 1970 | 30 |
847176 | 847176 | 2020-12-20 | Nobles | Minnesota | 27105 | 3463 | 43 |
847177 | 847177 | 2020-12-20 | Norman | Minnesota | 27107 | 404 | 8 |
847178 | 847178 | 2020-12-20 | Olmsted | Minnesota | 27109 | 8619 | 49 |
847179 | 847179 | 2020-12-20 | Otter Tail | Minnesota | 27111 | 4054 | 43 |
847180 | 847180 | 2020-12-20 | Pennington | Minnesota | 27113 | 865 | 12 |
847181 | 847181 | 2020-12-20 | Pine | Minnesota | 27115 | 2271 | 11 |
847182 | 847182 | 2020-12-20 | Pipestone | Minnesota | 27117 | 856 | 18 |
847183 | 847183 | 2020-12-20 | Polk | Minnesota | 27119 | 3123 | 46 |
847184 | 847184 | 2020-12-20 | Pope | Minnesota | 27121 | 671 | 3 |
847185 | 847185 | 2020-12-20 | Ramsey | Minnesota | 27123 | 35491 | 631 |
847186 | 847186 | 2020-12-20 | Red Lake | Minnesota | 27125 | 292 | 3 |
847187 | 847187 | 2020-12-20 | Redwood | Minnesota | 27127 | 1267 | 26 |
847188 | 847188 | 2020-12-20 | Renville | Minnesota | 27129 | 1234 | 37 |
847189 | 847189 | 2020-12-20 | Rice | Minnesota | 27131 | 5201 | 47 |
847190 | 847190 | 2020-12-20 | Rock | Minnesota | 27133 | 998 | 10 |
847191 | 847191 | 2020-12-20 | Roseau | Minnesota | 27135 | 1561 | 13 |
847192 | 847192 | 2020-12-20 | Scott | Minnesota | 27139 | 10546 | 73 |
847193 | 847193 | 2020-12-20 | Sherburne | Minnesota | 27141 | 7354 | 53 |
847194 | 847194 | 2020-12-20 | Sibley | Minnesota | 27143 | 964 | 4 |
847195 | 847195 | 2020-12-20 | St. Louis | Minnesota | 27137 | 11805 | 179 |
847196 | 847196 | 2020-12-20 | Stearns | Minnesota | 27145 | 16422 | 159 |
847197 | 847197 | 2020-12-20 | Steele | Minnesota | 27147 | 2421 | 9 |
847198 | 847198 | 2020-12-20 | Stevens | Minnesota | 27149 | 642 | 6 |
847199 | 847199 | 2020-12-20 | Swift | Minnesota | 27151 | 770 | 14 |
847200 | 847200 | 2020-12-20 | Todd | Minnesota | 27153 | 2180 | 23 |
847201 | 847201 | 2020-12-20 | Traverse | Minnesota | 27155 | 196 | 2 |
847202 | 847202 | 2020-12-20 | Unknown | Minnesota | 501 | 60 | |
847203 | 847203 | 2020-12-20 | Wabasha | Minnesota | 27157 | 1405 | 2 |
847204 | 847204 | 2020-12-20 | Wadena | Minnesota | 27159 | 1069 | 10 |
847205 | 847205 | 2020-12-20 | Waseca | Minnesota | 27161 | 1645 | 12 |
847206 | 847206 | 2020-12-20 | Washington | Minnesota | 27163 | 17691 | 170 |
847207 | 847207 | 2020-12-20 | Watonwan | Minnesota | 27165 | 1018 | 5 |
847208 | 847208 | 2020-12-20 | Wilkin | Minnesota | 27167 | 562 | 6 |
847209 | 847209 | 2020-12-20 | Winona | Minnesota | 27169 | 3425 | 42 |
847210 | 847210 | 2020-12-20 | Wright | Minnesota | 27171 | 10366 | 75 |
847211 | 847211 | 2020-12-20 | Yellow Medicine | Minnesota | 27173 | 833 | 14 |
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);