ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
860104 | 860104 | 2020-12-24 | Aitkin | Minnesota | 27001 | 1002 | 32 |
860105 | 860105 | 2020-12-24 | Anoka | Minnesota | 27003 | 28326 | 307 |
860106 | 860106 | 2020-12-24 | Becker | Minnesota | 27005 | 2627 | 32 |
860107 | 860107 | 2020-12-24 | Beltrami | Minnesota | 27007 | 2822 | 36 |
860108 | 860108 | 2020-12-24 | Benton | Minnesota | 27009 | 3792 | 72 |
860109 | 860109 | 2020-12-24 | Big Stone | Minnesota | 27011 | 422 | 3 |
860110 | 860110 | 2020-12-24 | Blue Earth | Minnesota | 27013 | 4910 | 27 |
860111 | 860111 | 2020-12-24 | Brown | Minnesota | 27015 | 1957 | 30 |
860112 | 860112 | 2020-12-24 | Carlton | Minnesota | 27017 | 2536 | 35 |
860113 | 860113 | 2020-12-24 | Carver | Minnesota | 27019 | 6289 | 32 |
860114 | 860114 | 2020-12-24 | Cass | Minnesota | 27021 | 1879 | 19 |
860115 | 860115 | 2020-12-24 | Chippewa | Minnesota | 27023 | 1238 | 23 |
860116 | 860116 | 2020-12-24 | Chisago | Minnesota | 27025 | 4018 | 26 |
860117 | 860117 | 2020-12-24 | Clay | Minnesota | 27027 | 6065 | 75 |
860118 | 860118 | 2020-12-24 | Clearwater | Minnesota | 27029 | 635 | 13 |
860119 | 860119 | 2020-12-24 | Cook | Minnesota | 27031 | 102 | 0 |
860120 | 860120 | 2020-12-24 | Cottonwood | Minnesota | 27033 | 1203 | 14 |
860121 | 860121 | 2020-12-24 | Crow Wing | Minnesota | 27035 | 4425 | 56 |
860122 | 860122 | 2020-12-24 | Dakota | Minnesota | 27037 | 29355 | 262 |
860123 | 860123 | 2020-12-24 | Dodge | Minnesota | 27039 | 1136 | 3 |
860124 | 860124 | 2020-12-24 | Douglas | Minnesota | 27041 | 3383 | 56 |
860125 | 860125 | 2020-12-24 | Faribault | Minnesota | 27043 | 867 | 9 |
860126 | 860126 | 2020-12-24 | Fillmore | Minnesota | 27045 | 1040 | 0 |
860127 | 860127 | 2020-12-24 | Freeborn | Minnesota | 27047 | 1905 | 17 |
860128 | 860128 | 2020-12-24 | Goodhue | Minnesota | 27049 | 2906 | 39 |
860129 | 860129 | 2020-12-24 | Grant | Minnesota | 27051 | 369 | 7 |
860130 | 860130 | 2020-12-24 | Hennepin | Minnesota | 27053 | 84116 | 1345 |
860131 | 860131 | 2020-12-24 | Houston | Minnesota | 27055 | 1132 | 11 |
860132 | 860132 | 2020-12-24 | Hubbard | Minnesota | 27057 | 1370 | 36 |
860133 | 860133 | 2020-12-24 | Isanti | Minnesota | 27059 | 2555 | 30 |
860134 | 860134 | 2020-12-24 | Itasca | Minnesota | 27061 | 2627 | 33 |
860135 | 860135 | 2020-12-24 | Jackson | Minnesota | 27063 | 767 | 6 |
860136 | 860136 | 2020-12-24 | Kanabec | Minnesota | 27065 | 901 | 18 |
860137 | 860137 | 2020-12-24 | Kandiyohi | Minnesota | 27067 | 5292 | 60 |
860138 | 860138 | 2020-12-24 | Kittson | Minnesota | 27069 | 338 | 18 |
860139 | 860139 | 2020-12-24 | Koochiching | Minnesota | 27071 | 536 | 8 |
860140 | 860140 | 2020-12-24 | Lac qui Parle | Minnesota | 27073 | 576 | 14 |
860141 | 860141 | 2020-12-24 | Lake | Minnesota | 27075 | 528 | 15 |
860142 | 860142 | 2020-12-24 | Lake of the Woods | Minnesota | 27077 | 149 | 1 |
860143 | 860143 | 2020-12-24 | Le Sueur | Minnesota | 27079 | 1886 | 15 |
860144 | 860144 | 2020-12-24 | Lincoln | Minnesota | 27081 | 444 | 1 |
860145 | 860145 | 2020-12-24 | Lyon | Minnesota | 27083 | 2761 | 28 |
860146 | 860146 | 2020-12-24 | Mahnomen | Minnesota | 27087 | 384 | 7 |
860147 | 860147 | 2020-12-24 | Marshall | Minnesota | 27089 | 667 | 12 |
860148 | 860148 | 2020-12-24 | Martin | Minnesota | 27091 | 1542 | 24 |
860149 | 860149 | 2020-12-24 | McLeod | Minnesota | 27085 | 3008 | 36 |
860150 | 860150 | 2020-12-24 | Meeker | Minnesota | 27093 | 1837 | 31 |
860151 | 860151 | 2020-12-24 | Mille Lacs | Minnesota | 27095 | 1993 | 43 |
860152 | 860152 | 2020-12-24 | Morrison | Minnesota | 27097 | 2853 | 40 |
860153 | 860153 | 2020-12-24 | Mower | Minnesota | 27099 | 3265 | 24 |
860154 | 860154 | 2020-12-24 | Murray | Minnesota | 27101 | 735 | 5 |
860155 | 860155 | 2020-12-24 | Nicollet | Minnesota | 27103 | 2008 | 30 |
860156 | 860156 | 2020-12-24 | Nobles | Minnesota | 27105 | 3487 | 44 |
860157 | 860157 | 2020-12-24 | Norman | Minnesota | 27107 | 405 | 8 |
860158 | 860158 | 2020-12-24 | Olmsted | Minnesota | 27109 | 8837 | 54 |
860159 | 860159 | 2020-12-24 | Otter Tail | Minnesota | 27111 | 4118 | 48 |
860160 | 860160 | 2020-12-24 | Pennington | Minnesota | 27113 | 875 | 14 |
860161 | 860161 | 2020-12-24 | Pine | Minnesota | 27115 | 2323 | 12 |
860162 | 860162 | 2020-12-24 | Pipestone | Minnesota | 27117 | 861 | 21 |
860163 | 860163 | 2020-12-24 | Polk | Minnesota | 27119 | 3151 | 47 |
860164 | 860164 | 2020-12-24 | Pope | Minnesota | 27121 | 676 | 3 |
860165 | 860165 | 2020-12-24 | Ramsey | Minnesota | 27123 | 36203 | 654 |
860166 | 860166 | 2020-12-24 | Red Lake | Minnesota | 27125 | 301 | 3 |
860167 | 860167 | 2020-12-24 | Redwood | Minnesota | 27127 | 1285 | 26 |
860168 | 860168 | 2020-12-24 | Renville | Minnesota | 27129 | 1265 | 38 |
860169 | 860169 | 2020-12-24 | Rice | Minnesota | 27131 | 5312 | 48 |
860170 | 860170 | 2020-12-24 | Rock | Minnesota | 27133 | 1008 | 10 |
860171 | 860171 | 2020-12-24 | Roseau | Minnesota | 27135 | 1582 | 14 |
860172 | 860172 | 2020-12-24 | Scott | Minnesota | 27139 | 10693 | 74 |
860173 | 860173 | 2020-12-24 | Sherburne | Minnesota | 27141 | 7465 | 55 |
860174 | 860174 | 2020-12-24 | Sibley | Minnesota | 27143 | 982 | 4 |
860175 | 860175 | 2020-12-24 | St. Louis | Minnesota | 27137 | 12066 | 186 |
860176 | 860176 | 2020-12-24 | Stearns | Minnesota | 27145 | 16630 | 165 |
860177 | 860177 | 2020-12-24 | Steele | Minnesota | 27147 | 2453 | 9 |
860178 | 860178 | 2020-12-24 | Stevens | Minnesota | 27149 | 657 | 6 |
860179 | 860179 | 2020-12-24 | Swift | Minnesota | 27151 | 781 | 14 |
860180 | 860180 | 2020-12-24 | Todd | Minnesota | 27153 | 2194 | 24 |
860181 | 860181 | 2020-12-24 | Traverse | Minnesota | 27155 | 201 | 2 |
860182 | 860182 | 2020-12-24 | Unknown | Minnesota | 500 | 60 | |
860183 | 860183 | 2020-12-24 | Wabasha | Minnesota | 27157 | 1441 | 2 |
860184 | 860184 | 2020-12-24 | Wadena | Minnesota | 27159 | 1094 | 11 |
860185 | 860185 | 2020-12-24 | Waseca | Minnesota | 27161 | 1680 | 12 |
860186 | 860186 | 2020-12-24 | Washington | Minnesota | 27163 | 17984 | 176 |
860187 | 860187 | 2020-12-24 | Watonwan | Minnesota | 27165 | 1019 | 5 |
860188 | 860188 | 2020-12-24 | Wilkin | Minnesota | 27167 | 574 | 7 |
860189 | 860189 | 2020-12-24 | Winona | Minnesota | 27169 | 3474 | 42 |
860190 | 860190 | 2020-12-24 | Wright | Minnesota | 27171 | 10562 | 81 |
860191 | 860191 | 2020-12-24 | Yellow Medicine | Minnesota | 27173 | 844 | 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);