ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-02-15 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1032113 | 1032113 | 2021-02-15 | Aitkin | Minnesota | 27001 | 1151 | 33 |
1032114 | 1032114 | 2021-02-15 | Anoka | Minnesota | 27003 | 32597 | 379 |
1032115 | 1032115 | 2021-02-15 | Becker | Minnesota | 27005 | 3011 | 41 |
1032116 | 1032116 | 2021-02-15 | Beltrami | Minnesota | 27007 | 3294 | 48 |
1032117 | 1032117 | 2021-02-15 | Benton | Minnesota | 27009 | 4383 | 90 |
1032118 | 1032118 | 2021-02-15 | Big Stone | Minnesota | 27011 | 497 | 3 |
1032119 | 1032119 | 2021-02-15 | Blue Earth | Minnesota | 27013 | 5736 | 34 |
1032120 | 1032120 | 2021-02-15 | Brown | Minnesota | 27015 | 2353 | 37 |
1032121 | 1032121 | 2021-02-15 | Carlton | Minnesota | 27017 | 2959 | 43 |
1032122 | 1032122 | 2021-02-15 | Carver | Minnesota | 27019 | 7406 | 40 |
1032123 | 1032123 | 2021-02-15 | Cass | Minnesota | 27021 | 2147 | 24 |
1032124 | 1032124 | 2021-02-15 | Chippewa | Minnesota | 27023 | 1350 | 35 |
1032125 | 1032125 | 2021-02-15 | Chisago | Minnesota | 27025 | 4838 | 44 |
1032126 | 1032126 | 2021-02-15 | Clay | Minnesota | 27027 | 6740 | 84 |
1032127 | 1032127 | 2021-02-15 | Clearwater | Minnesota | 27029 | 706 | 14 |
1032128 | 1032128 | 2021-02-15 | Cook | Minnesota | 27031 | 118 | 0 |
1032129 | 1032129 | 2021-02-15 | Cottonwood | Minnesota | 27033 | 1328 | 20 |
1032130 | 1032130 | 2021-02-15 | Crow Wing | Minnesota | 27035 | 5101 | 80 |
1032131 | 1032131 | 2021-02-15 | Dakota | Minnesota | 27037 | 35179 | 378 |
1032132 | 1032132 | 2021-02-15 | Dodge | Minnesota | 27039 | 1489 | 4 |
1032133 | 1032133 | 2021-02-15 | Douglas | Minnesota | 27041 | 3867 | 68 |
1032134 | 1032134 | 2021-02-15 | Faribault | Minnesota | 27043 | 1182 | 16 |
1032135 | 1032135 | 2021-02-15 | Fillmore | Minnesota | 27045 | 1351 | 8 |
1032136 | 1032136 | 2021-02-15 | Freeborn | Minnesota | 27047 | 2721 | 23 |
1032137 | 1032137 | 2021-02-15 | Goodhue | Minnesota | 27049 | 3785 | 65 |
1032138 | 1032138 | 2021-02-15 | Grant | Minnesota | 27051 | 468 | 8 |
1032139 | 1032139 | 2021-02-15 | Hennepin | Minnesota | 27053 | 98398 | 1569 |
1032140 | 1032140 | 2021-02-15 | Houston | Minnesota | 27055 | 1548 | 14 |
1032141 | 1032141 | 2021-02-15 | Hubbard | Minnesota | 27057 | 1585 | 39 |
1032142 | 1032142 | 2021-02-15 | Isanti | Minnesota | 27059 | 2997 | 49 |
1032143 | 1032143 | 2021-02-15 | Itasca | Minnesota | 27061 | 3014 | 45 |
1032144 | 1032144 | 2021-02-15 | Jackson | Minnesota | 27063 | 910 | 10 |
1032145 | 1032145 | 2021-02-15 | Kanabec | Minnesota | 27065 | 1054 | 19 |
1032146 | 1032146 | 2021-02-15 | Kandiyohi | Minnesota | 27067 | 5719 | 74 |
1032147 | 1032147 | 2021-02-15 | Kittson | Minnesota | 27069 | 395 | 21 |
1032148 | 1032148 | 2021-02-15 | Koochiching | Minnesota | 27071 | 615 | 11 |
1032149 | 1032149 | 2021-02-15 | Lac qui Parle | Minnesota | 27073 | 674 | 16 |
1032150 | 1032150 | 2021-02-15 | Lake | Minnesota | 27075 | 702 | 17 |
1032151 | 1032151 | 2021-02-15 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1032152 | 1032152 | 2021-02-15 | Le Sueur | Minnesota | 27079 | 2276 | 20 |
1032153 | 1032153 | 2021-02-15 | Lincoln | Minnesota | 27081 | 499 | 2 |
1032154 | 1032154 | 2021-02-15 | Lyon | Minnesota | 27083 | 3107 | 43 |
1032155 | 1032155 | 2021-02-15 | Mahnomen | Minnesota | 27087 | 429 | 7 |
1032156 | 1032156 | 2021-02-15 | Marshall | Minnesota | 27089 | 746 | 15 |
1032157 | 1032157 | 2021-02-15 | Martin | Minnesota | 27091 | 1825 | 27 |
1032158 | 1032158 | 2021-02-15 | McLeod | Minnesota | 27085 | 3345 | 49 |
1032159 | 1032159 | 2021-02-15 | Meeker | Minnesota | 27093 | 2042 | 33 |
1032160 | 1032160 | 2021-02-15 | Mille Lacs | Minnesota | 27095 | 2228 | 46 |
1032161 | 1032161 | 2021-02-15 | Morrison | Minnesota | 27097 | 3187 | 46 |
1032162 | 1032162 | 2021-02-15 | Mower | Minnesota | 27099 | 3943 | 30 |
1032163 | 1032163 | 2021-02-15 | Murray | Minnesota | 27101 | 935 | 8 |
1032164 | 1032164 | 2021-02-15 | Nicollet | Minnesota | 27103 | 2457 | 40 |
1032165 | 1032165 | 2021-02-15 | Nobles | Minnesota | 27105 | 3815 | 47 |
1032166 | 1032166 | 2021-02-15 | Norman | Minnesota | 27107 | 432 | 8 |
1032167 | 1032167 | 2021-02-15 | Olmsted | Minnesota | 27109 | 11517 | 84 |
1032168 | 1032168 | 2021-02-15 | Otter Tail | Minnesota | 27111 | 4735 | 70 |
1032169 | 1032169 | 2021-02-15 | Pennington | Minnesota | 27113 | 1163 | 16 |
1032170 | 1032170 | 2021-02-15 | Pine | Minnesota | 27115 | 2764 | 16 |
1032171 | 1032171 | 2021-02-15 | Pipestone | Minnesota | 27117 | 999 | 24 |
1032172 | 1032172 | 2021-02-15 | Polk | Minnesota | 27119 | 3379 | 62 |
1032173 | 1032173 | 2021-02-15 | Pope | Minnesota | 27121 | 777 | 5 |
1032174 | 1032174 | 2021-02-15 | Ramsey | Minnesota | 27123 | 42221 | 787 |
1032175 | 1032175 | 2021-02-15 | Red Lake | Minnesota | 27125 | 338 | 4 |
1032176 | 1032176 | 2021-02-15 | Redwood | Minnesota | 27127 | 1448 | 27 |
1032177 | 1032177 | 2021-02-15 | Renville | Minnesota | 27129 | 1452 | 40 |
1032178 | 1032178 | 2021-02-15 | Rice | Minnesota | 27131 | 6594 | 87 |
1032179 | 1032179 | 2021-02-15 | Rock | Minnesota | 27133 | 1148 | 12 |
1032180 | 1032180 | 2021-02-15 | Roseau | Minnesota | 27135 | 1724 | 17 |
1032181 | 1032181 | 2021-02-15 | Scott | Minnesota | 27139 | 12865 | 104 |
1032182 | 1032182 | 2021-02-15 | Sherburne | Minnesota | 27141 | 8581 | 73 |
1032183 | 1032183 | 2021-02-15 | Sibley | Minnesota | 27143 | 1139 | 9 |
1032184 | 1032184 | 2021-02-15 | St. Louis | Minnesota | 27137 | 14526 | 261 |
1032185 | 1032185 | 2021-02-15 | Stearns | Minnesota | 27145 | 18529 | 199 |
1032186 | 1032186 | 2021-02-15 | Steele | Minnesota | 27147 | 2946 | 11 |
1032187 | 1032187 | 2021-02-15 | Stevens | Minnesota | 27149 | 724 | 8 |
1032188 | 1032188 | 2021-02-15 | Swift | Minnesota | 27151 | 869 | 18 |
1032189 | 1032189 | 2021-02-15 | Todd | Minnesota | 27153 | 2389 | 30 |
1032190 | 1032190 | 2021-02-15 | Traverse | Minnesota | 27155 | 297 | 5 |
1032191 | 1032191 | 2021-02-15 | Unknown | Minnesota | 493 | 68 | |
1032192 | 1032192 | 2021-02-15 | Wabasha | Minnesota | 27157 | 1839 | 3 |
1032193 | 1032193 | 2021-02-15 | Wadena | Minnesota | 27159 | 1265 | 19 |
1032194 | 1032194 | 2021-02-15 | Waseca | Minnesota | 27161 | 2035 | 17 |
1032195 | 1032195 | 2021-02-15 | Washington | Minnesota | 27163 | 21542 | 249 |
1032196 | 1032196 | 2021-02-15 | Watonwan | Minnesota | 27165 | 1127 | 8 |
1032197 | 1032197 | 2021-02-15 | Wilkin | Minnesota | 27167 | 657 | 10 |
1032198 | 1032198 | 2021-02-15 | Winona | Minnesota | 27169 | 4104 | 48 |
1032199 | 1032199 | 2021-02-15 | Wright | Minnesota | 27171 | 12239 | 113 |
1032200 | 1032200 | 2021-02-15 | Yellow Medicine | Minnesota | 27173 | 966 | 17 |
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);