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 2020-07-30 and state = "Minnesota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384041 | 384041 | 2020-07-30 | Aitkin | Minnesota | 27001 | 25 | 0 |
384042 | 384042 | 2020-07-30 | Anoka | Minnesota | 27003 | 3190 | 112 |
384043 | 384043 | 2020-07-30 | Becker | Minnesota | 27005 | 129 | 1 |
384044 | 384044 | 2020-07-30 | Beltrami | Minnesota | 27007 | 180 | 0 |
384045 | 384045 | 2020-07-30 | Benton | Minnesota | 27009 | 294 | 3 |
384046 | 384046 | 2020-07-30 | Big Stone | Minnesota | 27011 | 22 | 0 |
384047 | 384047 | 2020-07-30 | Blue Earth | Minnesota | 27013 | 801 | 4 |
384048 | 384048 | 2020-07-30 | Brown | Minnesota | 27015 | 78 | 2 |
384049 | 384049 | 2020-07-30 | Carlton | Minnesota | 27017 | 120 | 0 |
384050 | 384050 | 2020-07-30 | Carver | Minnesota | 27019 | 723 | 2 |
384051 | 384051 | 2020-07-30 | Cass | Minnesota | 27021 | 50 | 2 |
384052 | 384052 | 2020-07-30 | Chippewa | Minnesota | 27023 | 92 | 1 |
384053 | 384053 | 2020-07-30 | Chisago | Minnesota | 27025 | 160 | 1 |
384054 | 384054 | 2020-07-30 | Clay | Minnesota | 27027 | 734 | 39 |
384055 | 384055 | 2020-07-30 | Clearwater | Minnesota | 27029 | 14 | 0 |
384056 | 384056 | 2020-07-30 | Cook | Minnesota | 27031 | 2 | 0 |
384057 | 384057 | 2020-07-30 | Cottonwood | Minnesota | 27033 | 165 | 0 |
384058 | 384058 | 2020-07-30 | Crow Wing | Minnesota | 27035 | 183 | 13 |
384059 | 384059 | 2020-07-30 | Dakota | Minnesota | 27037 | 3710 | 102 |
384060 | 384060 | 2020-07-30 | Dodge | Minnesota | 27039 | 121 | 0 |
384061 | 384061 | 2020-07-30 | Douglas | Minnesota | 27041 | 120 | 0 |
384062 | 384062 | 2020-07-30 | Faribault | Minnesota | 27043 | 78 | 0 |
384063 | 384063 | 2020-07-30 | Fillmore | Minnesota | 27045 | 58 | 0 |
384064 | 384064 | 2020-07-30 | Freeborn | Minnesota | 27047 | 352 | 1 |
384065 | 384065 | 2020-07-30 | Goodhue | Minnesota | 27049 | 163 | 8 |
384066 | 384066 | 2020-07-30 | Grant | Minnesota | 27051 | 44 | 1 |
384067 | 384067 | 2020-07-30 | Hennepin | Minnesota | 27053 | 17092 | 810 |
384068 | 384068 | 2020-07-30 | Houston | Minnesota | 27055 | 37 | 0 |
384069 | 384069 | 2020-07-30 | Hubbard | Minnesota | 27057 | 25 | 0 |
384070 | 384070 | 2020-07-30 | Isanti | Minnesota | 27059 | 102 | 0 |
384071 | 384071 | 2020-07-30 | Itasca | Minnesota | 27061 | 123 | 12 |
384072 | 384072 | 2020-07-30 | Jackson | Minnesota | 27063 | 69 | 0 |
384073 | 384073 | 2020-07-30 | Kanabec | Minnesota | 27065 | 23 | 1 |
384074 | 384074 | 2020-07-30 | Kandiyohi | Minnesota | 27067 | 653 | 1 |
384075 | 384075 | 2020-07-30 | Kittson | Minnesota | 27069 | 3 | 0 |
384076 | 384076 | 2020-07-30 | Koochiching | Minnesota | 27071 | 66 | 3 |
384077 | 384077 | 2020-07-30 | Lac qui Parle | Minnesota | 27073 | 6 | 0 |
384078 | 384078 | 2020-07-30 | Lake | Minnesota | 27075 | 14 | 0 |
384079 | 384079 | 2020-07-30 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
384080 | 384080 | 2020-07-30 | Le Sueur | Minnesota | 27079 | 196 | 1 |
384081 | 384081 | 2020-07-30 | Lincoln | Minnesota | 27081 | 53 | 0 |
384082 | 384082 | 2020-07-30 | Lyon | Minnesota | 27083 | 414 | 3 |
384083 | 384083 | 2020-07-30 | Mahnomen | Minnesota | 27087 | 20 | 1 |
384084 | 384084 | 2020-07-30 | Marshall | Minnesota | 27089 | 27 | 0 |
384085 | 384085 | 2020-07-30 | Martin | Minnesota | 27091 | 198 | 5 |
384086 | 384086 | 2020-07-30 | McLeod | Minnesota | 27085 | 121 | 0 |
384087 | 384087 | 2020-07-30 | Meeker | Minnesota | 27093 | 83 | 2 |
384088 | 384088 | 2020-07-30 | Mille Lacs | Minnesota | 27095 | 53 | 3 |
384089 | 384089 | 2020-07-30 | Morrison | Minnesota | 27097 | 80 | 1 |
384090 | 384090 | 2020-07-30 | Mower | Minnesota | 27099 | 1059 | 2 |
384091 | 384091 | 2020-07-30 | Murray | Minnesota | 27101 | 119 | 1 |
384092 | 384092 | 2020-07-30 | Nicollet | Minnesota | 27103 | 287 | 13 |
384093 | 384093 | 2020-07-30 | Nobles | Minnesota | 27105 | 1737 | 6 |
384094 | 384094 | 2020-07-30 | Norman | Minnesota | 27107 | 33 | 0 |
384095 | 384095 | 2020-07-30 | Olmsted | Minnesota | 27109 | 1567 | 22 |
384096 | 384096 | 2020-07-30 | Otter Tail | Minnesota | 27111 | 162 | 3 |
384097 | 384097 | 2020-07-30 | Pennington | Minnesota | 27113 | 69 | 1 |
384098 | 384098 | 2020-07-30 | Pine | Minnesota | 27115 | 123 | 0 |
384099 | 384099 | 2020-07-30 | Pipestone | Minnesota | 27117 | 140 | 9 |
384100 | 384100 | 2020-07-30 | Polk | Minnesota | 27119 | 124 | 3 |
384101 | 384101 | 2020-07-30 | Pope | Minnesota | 27121 | 35 | 0 |
384102 | 384102 | 2020-07-30 | Ramsey | Minnesota | 27123 | 6607 | 258 |
384103 | 384103 | 2020-07-30 | Red Lake | Minnesota | 27125 | 13 | 0 |
384104 | 384104 | 2020-07-30 | Redwood | Minnesota | 27127 | 30 | 0 |
384105 | 384105 | 2020-07-30 | Renville | Minnesota | 27129 | 54 | 5 |
384106 | 384106 | 2020-07-30 | Rice | Minnesota | 27131 | 970 | 8 |
384107 | 384107 | 2020-07-30 | Rock | Minnesota | 27133 | 70 | 0 |
384108 | 384108 | 2020-07-30 | Roseau | Minnesota | 27135 | 42 | 0 |
384109 | 384109 | 2020-07-30 | Scott | Minnesota | 27139 | 1272 | 11 |
384110 | 384110 | 2020-07-30 | Sherburne | Minnesota | 27141 | 602 | 6 |
384111 | 384111 | 2020-07-30 | Sibley | Minnesota | 27143 | 76 | 2 |
384112 | 384112 | 2020-07-30 | St. Louis | Minnesota | 27137 | 366 | 18 |
384113 | 384113 | 2020-07-30 | Stearns | Minnesota | 27145 | 2763 | 20 |
384114 | 384114 | 2020-07-30 | Steele | Minnesota | 27147 | 318 | 1 |
384115 | 384115 | 2020-07-30 | Stevens | Minnesota | 27149 | 15 | 0 |
384116 | 384116 | 2020-07-30 | Swift | Minnesota | 27151 | 51 | 1 |
384117 | 384117 | 2020-07-30 | Todd | Minnesota | 27153 | 413 | 2 |
384118 | 384118 | 2020-07-30 | Traverse | Minnesota | 27155 | 10 | 0 |
384119 | 384119 | 2020-07-30 | Unknown | Minnesota | 158 | 40 | |
384120 | 384120 | 2020-07-30 | Wabasha | Minnesota | 27157 | 74 | 0 |
384121 | 384121 | 2020-07-30 | Wadena | Minnesota | 27159 | 23 | 0 |
384122 | 384122 | 2020-07-30 | Waseca | Minnesota | 27161 | 123 | 0 |
384123 | 384123 | 2020-07-30 | Washington | Minnesota | 27163 | 1792 | 43 |
384124 | 384124 | 2020-07-30 | Watonwan | Minnesota | 27165 | 298 | 0 |
384125 | 384125 | 2020-07-30 | Wilkin | Minnesota | 27167 | 25 | 3 |
384126 | 384126 | 2020-07-30 | Winona | Minnesota | 27169 | 239 | 16 |
384127 | 384127 | 2020-07-30 | Wright | Minnesota | 27171 | 759 | 5 |
384128 | 384128 | 2020-07-30 | Yellow Medicine | Minnesota | 27173 | 47 | 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);