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-10-10 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1801696 | 1801696 | 2021-10-10 | Aitkin | Minnesota | 27001 | 1700 | 42 |
1801697 | 1801697 | 2021-10-10 | Anoka | Minnesota | 27003 | 51677 | 506 |
1801698 | 1801698 | 2021-10-10 | Becker | Minnesota | 27005 | 5028 | 62 |
1801699 | 1801699 | 2021-10-10 | Beltrami | Minnesota | 27007 | 6039 | 76 |
1801700 | 1801700 | 2021-10-10 | Benton | Minnesota | 27009 | 7152 | 102 |
1801701 | 1801701 | 2021-10-10 | Big Stone | Minnesota | 27011 | 754 | 4 |
1801702 | 1801702 | 2021-10-10 | Blue Earth | Minnesota | 27013 | 9301 | 56 |
1801703 | 1801703 | 2021-10-10 | Brown | Minnesota | 27015 | 3851 | 45 |
1801704 | 1801704 | 2021-10-10 | Carlton | Minnesota | 27017 | 4254 | 63 |
1801705 | 1801705 | 2021-10-10 | Carver | Minnesota | 27019 | 12997 | 53 |
1801706 | 1801706 | 2021-10-10 | Cass | Minnesota | 27021 | 3920 | 41 |
1801707 | 1801707 | 2021-10-10 | Chippewa | Minnesota | 27023 | 1799 | 39 |
1801708 | 1801708 | 2021-10-10 | Chisago | Minnesota | 27025 | 7851 | 61 |
1801709 | 1801709 | 2021-10-10 | Clay | Minnesota | 27027 | 9798 | 98 |
1801710 | 1801710 | 2021-10-10 | Clearwater | Minnesota | 27029 | 1281 | 18 |
1801711 | 1801711 | 2021-10-10 | Cook | Minnesota | 27031 | 229 | 0 |
1801712 | 1801712 | 2021-10-10 | Cottonwood | Minnesota | 27033 | 1882 | 26 |
1801713 | 1801713 | 2021-10-10 | Crow Wing | Minnesota | 27035 | 8891 | 104 |
1801714 | 1801714 | 2021-10-10 | Dakota | Minnesota | 27037 | 55074 | 512 |
1801715 | 1801715 | 2021-10-10 | Dodge | Minnesota | 27039 | 2604 | 8 |
1801716 | 1801716 | 2021-10-10 | Douglas | Minnesota | 27041 | 5936 | 86 |
1801717 | 1801717 | 2021-10-10 | Faribault | Minnesota | 27043 | 2064 | 26 |
1801718 | 1801718 | 2021-10-10 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1801719 | 1801719 | 2021-10-10 | Freeborn | Minnesota | 27047 | 4672 | 42 |
1801720 | 1801720 | 2021-10-10 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1801721 | 1801721 | 2021-10-10 | Grant | Minnesota | 27051 | 741 | 9 |
1801722 | 1801722 | 2021-10-10 | Hennepin | Minnesota | 27053 | 148439 | 1892 |
1801723 | 1801723 | 2021-10-10 | Houston | Minnesota | 27055 | 2227 | 17 |
1801724 | 1801724 | 2021-10-10 | Hubbard | Minnesota | 27057 | 2722 | 43 |
1801725 | 1801725 | 2021-10-10 | Isanti | Minnesota | 27059 | 5384 | 72 |
1801726 | 1801726 | 2021-10-10 | Itasca | Minnesota | 27061 | 5761 | 76 |
1801727 | 1801727 | 2021-10-10 | Jackson | Minnesota | 27063 | 1412 | 14 |
1801728 | 1801728 | 2021-10-10 | Kanabec | Minnesota | 27065 | 1794 | 29 |
1801729 | 1801729 | 2021-10-10 | Kandiyohi | Minnesota | 27067 | 7958 | 95 |
1801730 | 1801730 | 2021-10-10 | Kittson | Minnesota | 27069 | 580 | 22 |
1801731 | 1801731 | 2021-10-10 | Koochiching | Minnesota | 27071 | 1359 | 19 |
1801732 | 1801732 | 2021-10-10 | Lac qui Parle | Minnesota | 27073 | 928 | 24 |
1801733 | 1801733 | 2021-10-10 | Lake | Minnesota | 27075 | 1030 | 21 |
1801734 | 1801734 | 2021-10-10 | Lake of the Woods | Minnesota | 27077 | 438 | 4 |
1801735 | 1801735 | 2021-10-10 | Le Sueur | Minnesota | 27079 | 3683 | 30 |
1801736 | 1801736 | 2021-10-10 | Lincoln | Minnesota | 27081 | 719 | 5 |
1801737 | 1801737 | 2021-10-10 | Lyon | Minnesota | 27083 | 4276 | 56 |
1801738 | 1801738 | 2021-10-10 | Mahnomen | Minnesota | 27087 | 814 | 11 |
1801739 | 1801739 | 2021-10-10 | Marshall | Minnesota | 27089 | 1236 | 19 |
1801740 | 1801740 | 2021-10-10 | Martin | Minnesota | 27091 | 3018 | 33 |
1801741 | 1801741 | 2021-10-10 | McLeod | Minnesota | 27085 | 5595 | 66 |
1801742 | 1801742 | 2021-10-10 | Meeker | Minnesota | 27093 | 3400 | 51 |
1801743 | 1801743 | 2021-10-10 | Mille Lacs | Minnesota | 27095 | 3893 | 64 |
1801744 | 1801744 | 2021-10-10 | Morrison | Minnesota | 27097 | 5175 | 63 |
1801745 | 1801745 | 2021-10-10 | Mower | Minnesota | 27099 | 6137 | 39 |
1801746 | 1801746 | 2021-10-10 | Murray | Minnesota | 27101 | 1262 | 10 |
1801747 | 1801747 | 2021-10-10 | Nicollet | Minnesota | 27103 | 4088 | 49 |
1801748 | 1801748 | 2021-10-10 | Nobles | Minnesota | 27105 | 4691 | 51 |
1801749 | 1801749 | 2021-10-10 | Norman | Minnesota | 27107 | 797 | 9 |
1801750 | 1801750 | 2021-10-10 | Olmsted | Minnesota | 27109 | 17275 | 117 |
1801751 | 1801751 | 2021-10-10 | Otter Tail | Minnesota | 27111 | 7490 | 102 |
1801752 | 1801752 | 2021-10-10 | Pennington | Minnesota | 27113 | 2076 | 24 |
1801753 | 1801753 | 2021-10-10 | Pine | Minnesota | 27115 | 4072 | 30 |
1801754 | 1801754 | 2021-10-10 | Pipestone | Minnesota | 27117 | 1293 | 27 |
1801755 | 1801755 | 2021-10-10 | Polk | Minnesota | 27119 | 4851 | 75 |
1801756 | 1801756 | 2021-10-10 | Pope | Minnesota | 27121 | 1450 | 8 |
1801757 | 1801757 | 2021-10-10 | Ramsey | Minnesota | 27123 | 61496 | 964 |
1801758 | 1801758 | 2021-10-10 | Red Lake | Minnesota | 27125 | 564 | 8 |
1801759 | 1801759 | 2021-10-10 | Redwood | Minnesota | 27127 | 2246 | 43 |
1801760 | 1801760 | 2021-10-10 | Renville | Minnesota | 27129 | 2182 | 48 |
1801761 | 1801761 | 2021-10-10 | Rice | Minnesota | 27131 | 9659 | 128 |
1801762 | 1801762 | 2021-10-10 | Rock | Minnesota | 27133 | 1513 | 19 |
1801763 | 1801763 | 2021-10-10 | Roseau | Minnesota | 27135 | 2514 | 24 |
1801764 | 1801764 | 2021-10-10 | Scott | Minnesota | 27139 | 20877 | 157 |
1801765 | 1801765 | 2021-10-10 | Sherburne | Minnesota | 27141 | 14783 | 111 |
1801766 | 1801766 | 2021-10-10 | Sibley | Minnesota | 27143 | 1946 | 12 |
1801767 | 1801767 | 2021-10-10 | St. Louis | Minnesota | 27137 | 22438 | 345 |
1801768 | 1801768 | 2021-10-10 | Stearns | Minnesota | 27145 | 27119 | 251 |
1801769 | 1801769 | 2021-10-10 | Steele | Minnesota | 27147 | 5555 | 25 |
1801770 | 1801770 | 2021-10-10 | Stevens | Minnesota | 27149 | 1164 | 11 |
1801771 | 1801771 | 2021-10-10 | Swift | Minnesota | 27151 | 1301 | 19 |
1801772 | 1801772 | 2021-10-10 | Todd | Minnesota | 27153 | 3656 | 36 |
1801773 | 1801773 | 2021-10-10 | Traverse | Minnesota | 27155 | 482 | 5 |
1801774 | 1801774 | 2021-10-10 | Unknown | Minnesota | 648 | 113 | |
1801775 | 1801775 | 2021-10-10 | Wabasha | Minnesota | 27157 | 2703 | 5 |
1801776 | 1801776 | 2021-10-10 | Wadena | Minnesota | 27159 | 2179 | 28 |
1801777 | 1801777 | 2021-10-10 | Waseca | Minnesota | 27161 | 3164 | 28 |
1801778 | 1801778 | 2021-10-10 | Washington | Minnesota | 27163 | 32495 | 323 |
1801779 | 1801779 | 2021-10-10 | Watonwan | Minnesota | 27165 | 1657 | 11 |
1801780 | 1801780 | 2021-10-10 | Wilkin | Minnesota | 27167 | 966 | 14 |
1801781 | 1801781 | 2021-10-10 | Winona | Minnesota | 27169 | 5925 | 52 |
1801782 | 1801782 | 2021-10-10 | Wright | Minnesota | 27171 | 20241 | 168 |
1801783 | 1801783 | 2021-10-10 | Yellow Medicine | Minnesota | 27173 | 1418 | 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);