ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where "date" is on date 2020-04-06 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Anoka 1
- Beltrami 1
- Benton 1
- Big Stone 1
- Blue Earth 1
- Brown 1
- Carlton 1
- Carver 1
- Cass 1
- Chisago 1
- Clay 1
- Clearwater 1
- Cottonwood 1
- Crow Wing 1
- Dakota 1
- Dodge 1
- Douglas 1
- Faribault 1
- Fillmore 1
- Freeborn 1
- Goodhue 1
- Hennepin 1
- Houston 1
- Isanti 1
- Itasca 1
- Jackson 1
- Kandiyohi 1
- Koochiching 1
- Lac qui Parle 1
- Le Sueur 1
- …
state 1
- Minnesota · 63 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
36702 | 36702 | 2020-04-06 | Anoka | Minnesota | 27003 | 40 | 0 |
36703 | 36703 | 2020-04-06 | Beltrami | Minnesota | 27007 | 6 | 0 |
36704 | 36704 | 2020-04-06 | Benton | Minnesota | 27009 | 1 | 0 |
36705 | 36705 | 2020-04-06 | Big Stone | Minnesota | 27011 | 1 | 0 |
36706 | 36706 | 2020-04-06 | Blue Earth | Minnesota | 27013 | 16 | 0 |
36707 | 36707 | 2020-04-06 | Brown | Minnesota | 27015 | 5 | 0 |
36708 | 36708 | 2020-04-06 | Carlton | Minnesota | 27017 | 10 | 0 |
36709 | 36709 | 2020-04-06 | Carver | Minnesota | 27019 | 10 | 0 |
36710 | 36710 | 2020-04-06 | Cass | Minnesota | 27021 | 1 | 0 |
36711 | 36711 | 2020-04-06 | Chisago | Minnesota | 27025 | 5 | 1 |
36712 | 36712 | 2020-04-06 | Clay | Minnesota | 27027 | 19 | 0 |
36713 | 36713 | 2020-04-06 | Clearwater | Minnesota | 27029 | 2 | 0 |
36714 | 36714 | 2020-04-06 | Cottonwood | Minnesota | 27033 | 5 | 0 |
36715 | 36715 | 2020-04-06 | Crow Wing | Minnesota | 27035 | 6 | 0 |
36716 | 36716 | 2020-04-06 | Dakota | Minnesota | 27037 | 67 | 2 |
36717 | 36717 | 2020-04-06 | Dodge | Minnesota | 27039 | 10 | 0 |
36718 | 36718 | 2020-04-06 | Douglas | Minnesota | 27041 | 1 | 0 |
36719 | 36719 | 2020-04-06 | Faribault | Minnesota | 27043 | 3 | 0 |
36720 | 36720 | 2020-04-06 | Fillmore | Minnesota | 27045 | 10 | 0 |
36721 | 36721 | 2020-04-06 | Freeborn | Minnesota | 27047 | 11 | 0 |
36722 | 36722 | 2020-04-06 | Goodhue | Minnesota | 27049 | 10 | 0 |
36723 | 36723 | 2020-04-06 | Hennepin | Minnesota | 27053 | 280 | 14 |
36724 | 36724 | 2020-04-06 | Houston | Minnesota | 27055 | 1 | 0 |
36725 | 36725 | 2020-04-06 | Isanti | Minnesota | 27059 | 4 | 0 |
36726 | 36726 | 2020-04-06 | Itasca | Minnesota | 27061 | 2 | 0 |
36727 | 36727 | 2020-04-06 | Jackson | Minnesota | 27063 | 1 | 0 |
36728 | 36728 | 2020-04-06 | Kandiyohi | Minnesota | 27067 | 2 | 0 |
36729 | 36729 | 2020-04-06 | Koochiching | Minnesota | 27071 | 1 | 0 |
36730 | 36730 | 2020-04-06 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
36731 | 36731 | 2020-04-06 | Le Sueur | Minnesota | 27079 | 20 | 0 |
36732 | 36732 | 2020-04-06 | Lincoln | Minnesota | 27081 | 2 | 0 |
36733 | 36733 | 2020-04-06 | Lyon | Minnesota | 27083 | 4 | 0 |
36734 | 36734 | 2020-04-06 | Mahnomen | Minnesota | 27087 | 1 | 0 |
36735 | 36735 | 2020-04-06 | Martin | Minnesota | 27091 | 33 | 4 |
36736 | 36736 | 2020-04-06 | McLeod | Minnesota | 27085 | 1 | 0 |
36737 | 36737 | 2020-04-06 | Meeker | Minnesota | 27093 | 1 | 0 |
36738 | 36738 | 2020-04-06 | Mower | Minnesota | 27099 | 17 | 0 |
36739 | 36739 | 2020-04-06 | Murray | Minnesota | 27101 | 1 | 0 |
36740 | 36740 | 2020-04-06 | Nicollet | Minnesota | 27103 | 4 | 0 |
36741 | 36741 | 2020-04-06 | Olmsted | Minnesota | 27109 | 96 | 2 |
36742 | 36742 | 2020-04-06 | Otter Tail | Minnesota | 27111 | 2 | 0 |
36743 | 36743 | 2020-04-06 | Pipestone | Minnesota | 27117 | 1 | 0 |
36744 | 36744 | 2020-04-06 | Polk | Minnesota | 27119 | 1 | 0 |
36745 | 36745 | 2020-04-06 | Ramsey | Minnesota | 27123 | 96 | 3 |
36746 | 36746 | 2020-04-06 | Redwood | Minnesota | 27127 | 1 | 0 |
36747 | 36747 | 2020-04-06 | Renville | Minnesota | 27129 | 2 | 0 |
36748 | 36748 | 2020-04-06 | Rice | Minnesota | 27131 | 4 | 0 |
36749 | 36749 | 2020-04-06 | Scott | Minnesota | 27139 | 15 | 1 |
36750 | 36750 | 2020-04-06 | Sherburne | Minnesota | 27141 | 10 | 0 |
36751 | 36751 | 2020-04-06 | Sibley | Minnesota | 27143 | 1 | 0 |
36752 | 36752 | 2020-04-06 | St. Louis | Minnesota | 27137 | 16 | 0 |
36753 | 36753 | 2020-04-06 | Stearns | Minnesota | 27145 | 6 | 0 |
36754 | 36754 | 2020-04-06 | Steele | Minnesota | 27147 | 8 | 0 |
36755 | 36755 | 2020-04-06 | Traverse | Minnesota | 27155 | 2 | 0 |
36756 | 36756 | 2020-04-06 | Unknown | Minnesota | 6 | 0 | |
36757 | 36757 | 2020-04-06 | Wabasha | Minnesota | 27157 | 6 | 0 |
36758 | 36758 | 2020-04-06 | Waseca | Minnesota | 27161 | 3 | 0 |
36759 | 36759 | 2020-04-06 | Washington | Minnesota | 27163 | 65 | 1 |
36760 | 36760 | 2020-04-06 | Watonwan | Minnesota | 27165 | 4 | 0 |
36761 | 36761 | 2020-04-06 | Wilkin | Minnesota | 27167 | 2 | 0 |
36762 | 36762 | 2020-04-06 | Winona | Minnesota | 27169 | 14 | 2 |
36763 | 36763 | 2020-04-06 | Wright | Minnesota | 27171 | 9 | 0 |
36764 | 36764 | 2020-04-06 | Yellow Medicine | Minnesota | 27173 | 1 | 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);