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-08-04 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1584034 | 1584034 | 2021-08-04 | Aitkin | Minnesota | 27001 | 1406 | 37 |
1584035 | 1584035 | 2021-08-04 | Anoka | Minnesota | 27003 | 43706 | 466 |
1584036 | 1584036 | 2021-08-04 | Becker | Minnesota | 27005 | 3912 | 57 |
1584037 | 1584037 | 2021-08-04 | Beltrami | Minnesota | 27007 | 4147 | 63 |
1584038 | 1584038 | 2021-08-04 | Benton | Minnesota | 27009 | 5909 | 98 |
1584039 | 1584039 | 2021-08-04 | Big Stone | Minnesota | 27011 | 614 | 4 |
1584040 | 1584040 | 2021-08-04 | Blue Earth | Minnesota | 27013 | 7755 | 44 |
1584041 | 1584041 | 2021-08-04 | Brown | Minnesota | 27015 | 3101 | 40 |
1584042 | 1584042 | 2021-08-04 | Carlton | Minnesota | 27017 | 3589 | 58 |
1584043 | 1584043 | 2021-08-04 | Carver | Minnesota | 27019 | 10857 | 49 |
1584044 | 1584044 | 2021-08-04 | Cass | Minnesota | 27021 | 2906 | 33 |
1584045 | 1584045 | 2021-08-04 | Chippewa | Minnesota | 27023 | 1548 | 38 |
1584046 | 1584046 | 2021-08-04 | Chisago | Minnesota | 27025 | 6332 | 55 |
1584047 | 1584047 | 2021-08-04 | Clay | Minnesota | 27027 | 8318 | 92 |
1584048 | 1584048 | 2021-08-04 | Clearwater | Minnesota | 27029 | 900 | 17 |
1584049 | 1584049 | 2021-08-04 | Cook | Minnesota | 27031 | 176 | 0 |
1584050 | 1584050 | 2021-08-04 | Cottonwood | Minnesota | 27033 | 1683 | 24 |
1584051 | 1584051 | 2021-08-04 | Crow Wing | Minnesota | 27035 | 6950 | 99 |
1584052 | 1584052 | 2021-08-04 | Dakota | Minnesota | 27037 | 47738 | 479 |
1584053 | 1584053 | 2021-08-04 | Dodge | Minnesota | 27039 | 1939 | 3 |
1584054 | 1584054 | 2021-08-04 | Douglas | Minnesota | 27041 | 4820 | 81 |
1584055 | 1584055 | 2021-08-04 | Faribault | Minnesota | 27043 | 1584 | 20 |
1584056 | 1584056 | 2021-08-04 | Fillmore | Minnesota | 27045 | 1629 | 10 |
1584057 | 1584057 | 2021-08-04 | Freeborn | Minnesota | 27047 | 3568 | 35 |
1584058 | 1584058 | 2021-08-04 | Goodhue | Minnesota | 27049 | 4897 | 74 |
1584059 | 1584059 | 2021-08-04 | Grant | Minnesota | 27051 | 595 | 8 |
1584060 | 1584060 | 2021-08-04 | Hennepin | Minnesota | 27053 | 127906 | 1807 |
1584061 | 1584061 | 2021-08-04 | Houston | Minnesota | 27055 | 1781 | 16 |
1584062 | 1584062 | 2021-08-04 | Hubbard | Minnesota | 27057 | 2000 | 41 |
1584063 | 1584063 | 2021-08-04 | Isanti | Minnesota | 27059 | 4489 | 67 |
1584064 | 1584064 | 2021-08-04 | Itasca | Minnesota | 27061 | 4660 | 68 |
1584065 | 1584065 | 2021-08-04 | Jackson | Minnesota | 27063 | 1239 | 12 |
1584066 | 1584066 | 2021-08-04 | Kanabec | Minnesota | 27065 | 1486 | 29 |
1584067 | 1584067 | 2021-08-04 | Kandiyohi | Minnesota | 27067 | 6764 | 85 |
1584068 | 1584068 | 2021-08-04 | Kittson | Minnesota | 27069 | 495 | 22 |
1584069 | 1584069 | 2021-08-04 | Koochiching | Minnesota | 27071 | 969 | 19 |
1584070 | 1584070 | 2021-08-04 | Lac qui Parle | Minnesota | 27073 | 762 | 22 |
1584071 | 1584071 | 2021-08-04 | Lake | Minnesota | 27075 | 854 | 21 |
1584072 | 1584072 | 2021-08-04 | Lake of the Woods | Minnesota | 27077 | 351 | 4 |
1584073 | 1584073 | 2021-08-04 | Le Sueur | Minnesota | 27079 | 3029 | 28 |
1584074 | 1584074 | 2021-08-04 | Lincoln | Minnesota | 27081 | 590 | 3 |
1584075 | 1584075 | 2021-08-04 | Lyon | Minnesota | 27083 | 3677 | 54 |
1584076 | 1584076 | 2021-08-04 | Mahnomen | Minnesota | 27087 | 567 | 9 |
1584077 | 1584077 | 2021-08-04 | Marshall | Minnesota | 27089 | 896 | 18 |
1584078 | 1584078 | 2021-08-04 | Martin | Minnesota | 27091 | 2388 | 33 |
1584079 | 1584079 | 2021-08-04 | McLeod | Minnesota | 27085 | 4387 | 61 |
1584080 | 1584080 | 2021-08-04 | Meeker | Minnesota | 27093 | 2693 | 44 |
1584081 | 1584081 | 2021-08-04 | Mille Lacs | Minnesota | 27095 | 3174 | 56 |
1584082 | 1584082 | 2021-08-04 | Morrison | Minnesota | 27097 | 4313 | 62 |
1584083 | 1584083 | 2021-08-04 | Mower | Minnesota | 27099 | 4811 | 34 |
1584084 | 1584084 | 2021-08-04 | Murray | Minnesota | 27101 | 1080 | 10 |
1584085 | 1584085 | 2021-08-04 | Nicollet | Minnesota | 27103 | 3361 | 45 |
1584086 | 1584086 | 2021-08-04 | Nobles | Minnesota | 27105 | 4128 | 50 |
1584087 | 1584087 | 2021-08-04 | Norman | Minnesota | 27107 | 553 | 9 |
1584088 | 1584088 | 2021-08-04 | Olmsted | Minnesota | 27109 | 13691 | 104 |
1584089 | 1584089 | 2021-08-04 | Otter Tail | Minnesota | 27111 | 5946 | 87 |
1584090 | 1584090 | 2021-08-04 | Pennington | Minnesota | 27113 | 1543 | 20 |
1584091 | 1584091 | 2021-08-04 | Pine | Minnesota | 27115 | 3397 | 23 |
1584092 | 1584092 | 2021-08-04 | Pipestone | Minnesota | 27117 | 1173 | 26 |
1584093 | 1584093 | 2021-08-04 | Polk | Minnesota | 27119 | 3922 | 73 |
1584094 | 1584094 | 2021-08-04 | Pope | Minnesota | 27121 | 1147 | 7 |
1584095 | 1584095 | 2021-08-04 | Ramsey | Minnesota | 27123 | 53670 | 911 |
1584096 | 1584096 | 2021-08-04 | Red Lake | Minnesota | 27125 | 403 | 7 |
1584097 | 1584097 | 2021-08-04 | Redwood | Minnesota | 27127 | 1797 | 41 |
1584098 | 1584098 | 2021-08-04 | Renville | Minnesota | 27129 | 1847 | 46 |
1584099 | 1584099 | 2021-08-04 | Rice | Minnesota | 27131 | 8349 | 112 |
1584100 | 1584100 | 2021-08-04 | Rock | Minnesota | 27133 | 1305 | 19 |
1584101 | 1584101 | 2021-08-04 | Roseau | Minnesota | 27135 | 2130 | 21 |
1584102 | 1584102 | 2021-08-04 | Scott | Minnesota | 27139 | 17835 | 139 |
1584103 | 1584103 | 2021-08-04 | Sherburne | Minnesota | 27141 | 12225 | 96 |
1584104 | 1584104 | 2021-08-04 | Sibley | Minnesota | 27143 | 1483 | 10 |
1584105 | 1584105 | 2021-08-04 | St. Louis | Minnesota | 27137 | 18436 | 321 |
1584106 | 1584106 | 2021-08-04 | Stearns | Minnesota | 27145 | 22889 | 227 |
1584107 | 1584107 | 2021-08-04 | Steele | Minnesota | 27147 | 4042 | 19 |
1584108 | 1584108 | 2021-08-04 | Stevens | Minnesota | 27149 | 930 | 11 |
1584109 | 1584109 | 2021-08-04 | Swift | Minnesota | 27151 | 1078 | 18 |
1584110 | 1584110 | 2021-08-04 | Todd | Minnesota | 27153 | 2912 | 33 |
1584111 | 1584111 | 2021-08-04 | Traverse | Minnesota | 27155 | 386 | 5 |
1584112 | 1584112 | 2021-08-04 | Unknown | Minnesota | 606 | 93 | |
1584113 | 1584113 | 2021-08-04 | Wabasha | Minnesota | 27157 | 2096 | 3 |
1584114 | 1584114 | 2021-08-04 | Wadena | Minnesota | 27159 | 1660 | 23 |
1584115 | 1584115 | 2021-08-04 | Waseca | Minnesota | 27161 | 2442 | 23 |
1584116 | 1584116 | 2021-08-04 | Washington | Minnesota | 27163 | 27959 | 298 |
1584117 | 1584117 | 2021-08-04 | Watonwan | Minnesota | 27165 | 1370 | 9 |
1584118 | 1584118 | 2021-08-04 | Wilkin | Minnesota | 27167 | 848 | 13 |
1584119 | 1584119 | 2021-08-04 | Winona | Minnesota | 27169 | 4685 | 52 |
1584120 | 1584120 | 2021-08-04 | Wright | Minnesota | 27171 | 16676 | 153 |
1584121 | 1584121 | 2021-08-04 | Yellow Medicine | Minnesota | 27173 | 1156 | 20 |
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);