ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where "date" is on date 2020-04-14 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Anoka 1
- Becker 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
- …
state 1
- Minnesota · 71 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57643 | 57643 | 2020-04-14 | Anoka | Minnesota | 27003 | 72 | 0 |
57644 | 57644 | 2020-04-14 | Becker | Minnesota | 27005 | 2 | 0 |
57645 | 57645 | 2020-04-14 | Beltrami | Minnesota | 27007 | 5 | 0 |
57646 | 57646 | 2020-04-14 | Benton | Minnesota | 27009 | 1 | 0 |
57647 | 57647 | 2020-04-14 | Big Stone | Minnesota | 27011 | 1 | 0 |
57648 | 57648 | 2020-04-14 | Blue Earth | Minnesota | 27013 | 22 | 0 |
57649 | 57649 | 2020-04-14 | Brown | Minnesota | 27015 | 7 | 1 |
57650 | 57650 | 2020-04-14 | Carlton | Minnesota | 27017 | 26 | 0 |
57651 | 57651 | 2020-04-14 | Carver | Minnesota | 27019 | 13 | 0 |
57652 | 57652 | 2020-04-14 | Cass | Minnesota | 27021 | 4 | 0 |
57653 | 57653 | 2020-04-14 | Chisago | Minnesota | 27025 | 7 | 1 |
57654 | 57654 | 2020-04-14 | Clay | Minnesota | 27027 | 42 | 0 |
57655 | 57655 | 2020-04-14 | Clearwater | Minnesota | 27029 | 3 | 0 |
57656 | 57656 | 2020-04-14 | Cottonwood | Minnesota | 27033 | 6 | 0 |
57657 | 57657 | 2020-04-14 | Crow Wing | Minnesota | 27035 | 17 | 0 |
57658 | 57658 | 2020-04-14 | Dakota | Minnesota | 27037 | 103 | 5 |
57659 | 57659 | 2020-04-14 | Dodge | Minnesota | 27039 | 16 | 0 |
57660 | 57660 | 2020-04-14 | Douglas | Minnesota | 27041 | 1 | 0 |
57661 | 57661 | 2020-04-14 | Faribault | Minnesota | 27043 | 4 | 0 |
57662 | 57662 | 2020-04-14 | Fillmore | Minnesota | 27045 | 10 | 0 |
57663 | 57663 | 2020-04-14 | Freeborn | Minnesota | 27047 | 27 | 0 |
57664 | 57664 | 2020-04-14 | Goodhue | Minnesota | 27049 | 17 | 0 |
57665 | 57665 | 2020-04-14 | Hennepin | Minnesota | 27053 | 588 | 40 |
57666 | 57666 | 2020-04-14 | Houston | Minnesota | 27055 | 1 | 0 |
57667 | 57667 | 2020-04-14 | Isanti | Minnesota | 27059 | 4 | 0 |
57668 | 57668 | 2020-04-14 | Itasca | Minnesota | 27061 | 2 | 0 |
57669 | 57669 | 2020-04-14 | Jackson | Minnesota | 27063 | 1 | 0 |
57670 | 57670 | 2020-04-14 | Kandiyohi | Minnesota | 27067 | 2 | 0 |
57671 | 57671 | 2020-04-14 | Koochiching | Minnesota | 27071 | 1 | 0 |
57672 | 57672 | 2020-04-14 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
57673 | 57673 | 2020-04-14 | Le Sueur | Minnesota | 27079 | 21 | 0 |
57674 | 57674 | 2020-04-14 | Lincoln | Minnesota | 27081 | 2 | 0 |
57675 | 57675 | 2020-04-14 | Lyon | Minnesota | 27083 | 5 | 0 |
57676 | 57676 | 2020-04-14 | Mahnomen | Minnesota | 27087 | 1 | 0 |
57677 | 57677 | 2020-04-14 | Martin | Minnesota | 27091 | 39 | 4 |
57678 | 57678 | 2020-04-14 | McLeod | Minnesota | 27085 | 2 | 0 |
57679 | 57679 | 2020-04-14 | Meeker | Minnesota | 27093 | 2 | 0 |
57680 | 57680 | 2020-04-14 | Mower | Minnesota | 27099 | 24 | 0 |
57681 | 57681 | 2020-04-14 | Murray | Minnesota | 27101 | 1 | 0 |
57682 | 57682 | 2020-04-14 | Nicollet | Minnesota | 27103 | 7 | 1 |
57683 | 57683 | 2020-04-14 | Nobles | Minnesota | 27105 | 3 | 0 |
57684 | 57684 | 2020-04-14 | Olmsted | Minnesota | 27109 | 147 | 2 |
57685 | 57685 | 2020-04-14 | Otter Tail | Minnesota | 27111 | 4 | 0 |
57686 | 57686 | 2020-04-14 | Pine | Minnesota | 27115 | 6 | 0 |
57687 | 57687 | 2020-04-14 | Pipestone | Minnesota | 27117 | 1 | 0 |
57688 | 57688 | 2020-04-14 | Polk | Minnesota | 27119 | 1 | 0 |
57689 | 57689 | 2020-04-14 | Ramsey | Minnesota | 27123 | 153 | 7 |
57690 | 57690 | 2020-04-14 | Red Lake | Minnesota | 27125 | 1 | 0 |
57691 | 57691 | 2020-04-14 | Redwood | Minnesota | 27127 | 1 | 0 |
57692 | 57692 | 2020-04-14 | Renville | Minnesota | 27129 | 3 | 0 |
57693 | 57693 | 2020-04-14 | Rice | Minnesota | 27131 | 5 | 0 |
57694 | 57694 | 2020-04-14 | Rock | Minnesota | 27133 | 2 | 0 |
57695 | 57695 | 2020-04-14 | Roseau | Minnesota | 27135 | 1 | 0 |
57696 | 57696 | 2020-04-14 | Scott | Minnesota | 27139 | 20 | 1 |
57697 | 57697 | 2020-04-14 | Sherburne | Minnesota | 27141 | 10 | 0 |
57698 | 57698 | 2020-04-14 | Sibley | Minnesota | 27143 | 1 | 0 |
57699 | 57699 | 2020-04-14 | St. Louis | Minnesota | 27137 | 42 | 5 |
57700 | 57700 | 2020-04-14 | Stearns | Minnesota | 27145 | 7 | 0 |
57701 | 57701 | 2020-04-14 | Steele | Minnesota | 27147 | 9 | 0 |
57702 | 57702 | 2020-04-14 | Swift | Minnesota | 27151 | 1 | 0 |
57703 | 57703 | 2020-04-14 | Todd | Minnesota | 27153 | 2 | 0 |
57704 | 57704 | 2020-04-14 | Traverse | Minnesota | 27155 | 2 | 0 |
57705 | 57705 | 2020-04-14 | Unknown | Minnesota | 6 | 0 | |
57706 | 57706 | 2020-04-14 | Wabasha | Minnesota | 27157 | 7 | 0 |
57707 | 57707 | 2020-04-14 | Waseca | Minnesota | 27161 | 3 | 0 |
57708 | 57708 | 2020-04-14 | Washington | Minnesota | 27163 | 84 | 3 |
57709 | 57709 | 2020-04-14 | Watonwan | Minnesota | 27165 | 4 | 0 |
57710 | 57710 | 2020-04-14 | Wilkin | Minnesota | 27167 | 7 | 2 |
57711 | 57711 | 2020-04-14 | Winona | Minnesota | 27169 | 30 | 6 |
57712 | 57712 | 2020-04-14 | Wright | Minnesota | 27171 | 19 | 1 |
57713 | 57713 | 2020-04-14 | Yellow Medicine | Minnesota | 27173 | 3 | 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);