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-07-04 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 |
---|---|---|---|---|---|---|---|
301007 | 301007 | 2020-07-04 | Aitkin | Minnesota | 27001 | 14 | 0 |
301008 | 301008 | 2020-07-04 | Anoka | Minnesota | 27003 | 2180 | 107 |
301009 | 301009 | 2020-07-04 | Becker | Minnesota | 27005 | 55 | 0 |
301010 | 301010 | 2020-07-04 | Beltrami | Minnesota | 27007 | 29 | 0 |
301011 | 301011 | 2020-07-04 | Benton | Minnesota | 27009 | 214 | 3 |
301012 | 301012 | 2020-07-04 | Big Stone | Minnesota | 27011 | 14 | 0 |
301013 | 301013 | 2020-07-04 | Blue Earth | Minnesota | 27013 | 453 | 2 |
301014 | 301014 | 2020-07-04 | Brown | Minnesota | 27015 | 30 | 2 |
301015 | 301015 | 2020-07-04 | Carlton | Minnesota | 27017 | 85 | 0 |
301016 | 301016 | 2020-07-04 | Carver | Minnesota | 27019 | 364 | 1 |
301017 | 301017 | 2020-07-04 | Cass | Minnesota | 27021 | 15 | 2 |
301018 | 301018 | 2020-07-04 | Chippewa | Minnesota | 27023 | 78 | 1 |
301019 | 301019 | 2020-07-04 | Chisago | Minnesota | 27025 | 97 | 1 |
301020 | 301020 | 2020-07-04 | Clay | Minnesota | 27027 | 585 | 38 |
301021 | 301021 | 2020-07-04 | Clearwater | Minnesota | 27029 | 7 | 0 |
301022 | 301022 | 2020-07-04 | Cook | Minnesota | 27031 | 1 | 0 |
301023 | 301023 | 2020-07-04 | Cottonwood | Minnesota | 27033 | 134 | 0 |
301024 | 301024 | 2020-07-04 | Crow Wing | Minnesota | 27035 | 106 | 12 |
301025 | 301025 | 2020-07-04 | Dakota | Minnesota | 27037 | 2286 | 90 |
301026 | 301026 | 2020-07-04 | Dodge | Minnesota | 27039 | 84 | 0 |
301027 | 301027 | 2020-07-04 | Douglas | Minnesota | 27041 | 62 | 0 |
301028 | 301028 | 2020-07-04 | Faribault | Minnesota | 27043 | 55 | 0 |
301029 | 301029 | 2020-07-04 | Fillmore | Minnesota | 27045 | 28 | 0 |
301030 | 301030 | 2020-07-04 | Freeborn | Minnesota | 27047 | 290 | 0 |
301031 | 301031 | 2020-07-04 | Goodhue | Minnesota | 27049 | 129 | 8 |
301032 | 301032 | 2020-07-04 | Grant | Minnesota | 27051 | 10 | 0 |
301033 | 301033 | 2020-07-04 | Hennepin | Minnesota | 27053 | 12150 | 785 |
301034 | 301034 | 2020-07-04 | Houston | Minnesota | 27055 | 25 | 0 |
301035 | 301035 | 2020-07-04 | Hubbard | Minnesota | 27057 | 6 | 0 |
301036 | 301036 | 2020-07-04 | Isanti | Minnesota | 27059 | 72 | 0 |
301037 | 301037 | 2020-07-04 | Itasca | Minnesota | 27061 | 64 | 12 |
301038 | 301038 | 2020-07-04 | Jackson | Minnesota | 27063 | 55 | 0 |
301039 | 301039 | 2020-07-04 | Kanabec | Minnesota | 27065 | 14 | 1 |
301040 | 301040 | 2020-07-04 | Kandiyohi | Minnesota | 27067 | 570 | 1 |
301041 | 301041 | 2020-07-04 | Kittson | Minnesota | 27069 | 2 | 0 |
301042 | 301042 | 2020-07-04 | Koochiching | Minnesota | 27071 | 14 | 1 |
301043 | 301043 | 2020-07-04 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
301044 | 301044 | 2020-07-04 | Lake | Minnesota | 27075 | 6 | 0 |
301045 | 301045 | 2020-07-04 | Le Sueur | Minnesota | 27079 | 98 | 1 |
301046 | 301046 | 2020-07-04 | Lincoln | Minnesota | 27081 | 10 | 0 |
301047 | 301047 | 2020-07-04 | Lyon | Minnesota | 27083 | 309 | 2 |
301048 | 301048 | 2020-07-04 | Mahnomen | Minnesota | 27087 | 8 | 1 |
301049 | 301049 | 2020-07-04 | Marshall | Minnesota | 27089 | 12 | 0 |
301050 | 301050 | 2020-07-04 | Martin | Minnesota | 27091 | 163 | 5 |
301051 | 301051 | 2020-07-04 | McLeod | Minnesota | 27085 | 88 | 0 |
301052 | 301052 | 2020-07-04 | Meeker | Minnesota | 27093 | 61 | 1 |
301053 | 301053 | 2020-07-04 | Mille Lacs | Minnesota | 27095 | 34 | 2 |
301054 | 301054 | 2020-07-04 | Morrison | Minnesota | 27097 | 59 | 1 |
301055 | 301055 | 2020-07-04 | Mower | Minnesota | 27099 | 945 | 2 |
301056 | 301056 | 2020-07-04 | Murray | Minnesota | 27101 | 58 | 0 |
301057 | 301057 | 2020-07-04 | Nicollet | Minnesota | 27103 | 159 | 12 |
301058 | 301058 | 2020-07-04 | Nobles | Minnesota | 27105 | 1662 | 6 |
301059 | 301059 | 2020-07-04 | Norman | Minnesota | 27107 | 20 | 0 |
301060 | 301060 | 2020-07-04 | Olmsted | Minnesota | 27109 | 1101 | 15 |
301061 | 301061 | 2020-07-04 | Otter Tail | Minnesota | 27111 | 93 | 1 |
301062 | 301062 | 2020-07-04 | Pennington | Minnesota | 27113 | 50 | 0 |
301063 | 301063 | 2020-07-04 | Pine | Minnesota | 27115 | 103 | 0 |
301064 | 301064 | 2020-07-04 | Pipestone | Minnesota | 27117 | 37 | 1 |
301065 | 301065 | 2020-07-04 | Polk | Minnesota | 27119 | 81 | 2 |
301066 | 301066 | 2020-07-04 | Pope | Minnesota | 27121 | 10 | 0 |
301067 | 301067 | 2020-07-04 | Ramsey | Minnesota | 27123 | 4805 | 226 |
301068 | 301068 | 2020-07-04 | Red Lake | Minnesota | 27125 | 3 | 0 |
301069 | 301069 | 2020-07-04 | Redwood | Minnesota | 27127 | 18 | 0 |
301070 | 301070 | 2020-07-04 | Renville | Minnesota | 27129 | 32 | 2 |
301071 | 301071 | 2020-07-04 | Rice | Minnesota | 27131 | 835 | 7 |
301072 | 301072 | 2020-07-04 | Rock | Minnesota | 27133 | 30 | 0 |
301073 | 301073 | 2020-07-04 | Roseau | Minnesota | 27135 | 13 | 0 |
301074 | 301074 | 2020-07-04 | Scott | Minnesota | 27139 | 700 | 4 |
301075 | 301075 | 2020-07-04 | Sherburne | Minnesota | 27141 | 307 | 5 |
301076 | 301076 | 2020-07-04 | Sibley | Minnesota | 27143 | 54 | 2 |
301077 | 301077 | 2020-07-04 | St. Louis | Minnesota | 27137 | 177 | 15 |
301078 | 301078 | 2020-07-04 | Stearns | Minnesota | 27145 | 2345 | 19 |
301079 | 301079 | 2020-07-04 | Steele | Minnesota | 27147 | 228 | 1 |
301080 | 301080 | 2020-07-04 | Stevens | Minnesota | 27149 | 4 | 0 |
301081 | 301081 | 2020-07-04 | Swift | Minnesota | 27151 | 21 | 1 |
301082 | 301082 | 2020-07-04 | Todd | Minnesota | 27153 | 400 | 2 |
301083 | 301083 | 2020-07-04 | Traverse | Minnesota | 27155 | 5 | 0 |
301084 | 301084 | 2020-07-04 | Unknown | Minnesota | 113 | 37 | |
301085 | 301085 | 2020-07-04 | Wabasha | Minnesota | 27157 | 31 | 0 |
301086 | 301086 | 2020-07-04 | Wadena | Minnesota | 27159 | 15 | 0 |
301087 | 301087 | 2020-07-04 | Waseca | Minnesota | 27161 | 64 | 0 |
301088 | 301088 | 2020-07-04 | Washington | Minnesota | 27163 | 1069 | 40 |
301089 | 301089 | 2020-07-04 | Watonwan | Minnesota | 27165 | 216 | 0 |
301090 | 301090 | 2020-07-04 | Wilkin | Minnesota | 27167 | 20 | 3 |
301091 | 301091 | 2020-07-04 | Winona | Minnesota | 27169 | 122 | 15 |
301092 | 301092 | 2020-07-04 | Wright | Minnesota | 27171 | 456 | 5 |
301093 | 301093 | 2020-07-04 | Yellow Medicine | Minnesota | 27173 | 30 | 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);