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 2022-01-18 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126716 | 2126716 | 2022-01-18 | Aitkin | Minnesota | 27001 | 2520 | 56 |
2126717 | 2126717 | 2022-01-18 | Anoka | Minnesota | 27003 | 80505 | 712 |
2126718 | 2126718 | 2022-01-18 | Becker | Minnesota | 27005 | 6999 | 83 |
2126719 | 2126719 | 2022-01-18 | Beltrami | Minnesota | 27007 | 9405 | 112 |
2126720 | 2126720 | 2022-01-18 | Benton | Minnesota | 27009 | 10993 | 146 |
2126721 | 2126721 | 2022-01-18 | Big Stone | Minnesota | 27011 | 1108 | 7 |
2126722 | 2126722 | 2022-01-18 | Blue Earth | Minnesota | 27013 | 13885 | 84 |
2126723 | 2126723 | 2022-01-18 | Brown | Minnesota | 27015 | 5345 | 69 |
2126724 | 2126724 | 2022-01-18 | Carlton | Minnesota | 27017 | 6475 | 82 |
2126725 | 2126725 | 2022-01-18 | Carver | Minnesota | 27019 | 21038 | 93 |
2126726 | 2126726 | 2022-01-18 | Cass | Minnesota | 27021 | 5654 | 67 |
2126727 | 2126727 | 2022-01-18 | Chippewa | Minnesota | 27023 | 2462 | 44 |
2126728 | 2126728 | 2022-01-18 | Chisago | Minnesota | 27025 | 11818 | 108 |
2126729 | 2126729 | 2022-01-18 | Clay | Minnesota | 27027 | 14624 | 114 |
2126730 | 2126730 | 2022-01-18 | Clearwater | Minnesota | 27029 | 1760 | 27 |
2126731 | 2126731 | 2022-01-18 | Cook | Minnesota | 27031 | 425 | 1 |
2126732 | 2126732 | 2022-01-18 | Cottonwood | Minnesota | 27033 | 2650 | 37 |
2126733 | 2126733 | 2022-01-18 | Crow Wing | Minnesota | 27035 | 12912 | 149 |
2126734 | 2126734 | 2022-01-18 | Dakota | Minnesota | 27037 | 87368 | 688 |
2126735 | 2126735 | 2022-01-18 | Dodge | Minnesota | 27039 | 4372 | 14 |
2126736 | 2126736 | 2022-01-18 | Douglas | Minnesota | 27041 | 9017 | 109 |
2126737 | 2126737 | 2022-01-18 | Faribault | Minnesota | 27043 | 3026 | 44 |
2126738 | 2126738 | 2022-01-18 | Fillmore | Minnesota | 27045 | 3751 | 18 |
2126739 | 2126739 | 2022-01-18 | Freeborn | Minnesota | 27047 | 7012 | 57 |
2126740 | 2126740 | 2022-01-18 | Goodhue | Minnesota | 27049 | 10201 | 112 |
2126741 | 2126741 | 2022-01-18 | Grant | Minnesota | 27051 | 1186 | 12 |
2126742 | 2126742 | 2022-01-18 | Hennepin | Minnesota | 27053 | 239529 | 2268 |
2126743 | 2126743 | 2022-01-18 | Houston | Minnesota | 27055 | 3497 | 18 |
2126744 | 2126744 | 2022-01-18 | Hubbard | Minnesota | 27057 | 4025 | 52 |
2126745 | 2126745 | 2022-01-18 | Isanti | Minnesota | 27059 | 8415 | 101 |
2126746 | 2126746 | 2022-01-18 | Itasca | Minnesota | 27061 | 9053 | 123 |
2126747 | 2126747 | 2022-01-18 | Jackson | Minnesota | 27063 | 1834 | 16 |
2126748 | 2126748 | 2022-01-18 | Kanabec | Minnesota | 27065 | 2980 | 49 |
2126749 | 2126749 | 2022-01-18 | Kandiyohi | Minnesota | 27067 | 11098 | 124 |
2126750 | 2126750 | 2022-01-18 | Kittson | Minnesota | 27069 | 898 | 25 |
2126751 | 2126751 | 2022-01-18 | Koochiching | Minnesota | 27071 | 2104 | 32 |
2126752 | 2126752 | 2022-01-18 | Lac qui Parle | Minnesota | 27073 | 1420 | 27 |
2126753 | 2126753 | 2022-01-18 | Lake | Minnesota | 27075 | 1580 | 26 |
2126754 | 2126754 | 2022-01-18 | Lake of the Woods | Minnesota | 27077 | 604 | 5 |
2126755 | 2126755 | 2022-01-18 | Le Sueur | Minnesota | 27079 | 5370 | 45 |
2126756 | 2126756 | 2022-01-18 | Lincoln | Minnesota | 27081 | 1015 | 5 |
2126757 | 2126757 | 2022-01-18 | Lyon | Minnesota | 27083 | 6006 | 68 |
2126758 | 2126758 | 2022-01-18 | Mahnomen | Minnesota | 27087 | 1231 | 17 |
2126759 | 2126759 | 2022-01-18 | Marshall | Minnesota | 27089 | 1732 | 23 |
2126760 | 2126760 | 2022-01-18 | Martin | Minnesota | 27091 | 4490 | 53 |
2126761 | 2126761 | 2022-01-18 | McLeod | Minnesota | 27085 | 8415 | 97 |
2126762 | 2126762 | 2022-01-18 | Meeker | Minnesota | 27093 | 4977 | 70 |
2126763 | 2126763 | 2022-01-18 | Mille Lacs | Minnesota | 27095 | 6134 | 101 |
2126764 | 2126764 | 2022-01-18 | Morrison | Minnesota | 27097 | 7497 | 92 |
2126765 | 2126765 | 2022-01-18 | Mower | Minnesota | 27099 | 9239 | 58 |
2126766 | 2126766 | 2022-01-18 | Murray | Minnesota | 27101 | 1742 | 15 |
2126767 | 2126767 | 2022-01-18 | Nicollet | Minnesota | 27103 | 6229 | 63 |
2126768 | 2126768 | 2022-01-18 | Nobles | Minnesota | 27105 | 5862 | 56 |
2126769 | 2126769 | 2022-01-18 | Norman | Minnesota | 27107 | 1147 | 11 |
2126770 | 2126770 | 2022-01-18 | Olmsted | Minnesota | 27109 | 29675 | 148 |
2126771 | 2126771 | 2022-01-18 | Otter Tail | Minnesota | 27111 | 10985 | 149 |
2126772 | 2126772 | 2022-01-18 | Pennington | Minnesota | 27113 | 2821 | 34 |
2126773 | 2126773 | 2022-01-18 | Pine | Minnesota | 27115 | 5930 | 57 |
2126774 | 2126774 | 2022-01-18 | Pipestone | Minnesota | 27117 | 1720 | 31 |
2126775 | 2126775 | 2022-01-18 | Polk | Minnesota | 27119 | 6740 | 92 |
2126776 | 2126776 | 2022-01-18 | Pope | Minnesota | 27121 | 2389 | 14 |
2126777 | 2126777 | 2022-01-18 | Ramsey | Minnesota | 27123 | 98579 | 1176 |
2126778 | 2126778 | 2022-01-18 | Red Lake | Minnesota | 27125 | 775 | 11 |
2126779 | 2126779 | 2022-01-18 | Redwood | Minnesota | 27127 | 3203 | 50 |
2126780 | 2126780 | 2022-01-18 | Renville | Minnesota | 27129 | 3028 | 52 |
2126781 | 2126781 | 2022-01-18 | Rice | Minnesota | 27131 | 13804 | 155 |
2126782 | 2126782 | 2022-01-18 | Rock | Minnesota | 27133 | 1989 | 32 |
2126783 | 2126783 | 2022-01-18 | Roseau | Minnesota | 27135 | 3627 | 38 |
2126784 | 2126784 | 2022-01-18 | Scott | Minnesota | 27139 | 32769 | 222 |
2126785 | 2126785 | 2022-01-18 | Sherburne | Minnesota | 27141 | 22597 | 161 |
2126786 | 2126786 | 2022-01-18 | Sibley | Minnesota | 27143 | 2920 | 23 |
2126787 | 2126787 | 2022-01-18 | St. Louis | Minnesota | 27137 | 35880 | 470 |
2126788 | 2126788 | 2022-01-18 | Stearns | Minnesota | 27145 | 41043 | 330 |
2126789 | 2126789 | 2022-01-18 | Steele | Minnesota | 27147 | 8160 | 47 |
2126790 | 2126790 | 2022-01-18 | Stevens | Minnesota | 27149 | 2080 | 11 |
2126791 | 2126791 | 2022-01-18 | Swift | Minnesota | 27151 | 1881 | 30 |
2126792 | 2126792 | 2022-01-18 | Todd | Minnesota | 27153 | 5629 | 54 |
2126793 | 2126793 | 2022-01-18 | Traverse | Minnesota | 27155 | 662 | 8 |
2126794 | 2126794 | 2022-01-18 | Unknown | Minnesota | 4275 | 140 | |
2126795 | 2126795 | 2022-01-18 | Wabasha | Minnesota | 27157 | 4417 | 13 |
2126796 | 2126796 | 2022-01-18 | Wadena | Minnesota | 27159 | 3409 | 46 |
2126797 | 2126797 | 2022-01-18 | Waseca | Minnesota | 27161 | 4522 | 36 |
2126798 | 2126798 | 2022-01-18 | Washington | Minnesota | 27163 | 52480 | 422 |
2126799 | 2126799 | 2022-01-18 | Watonwan | Minnesota | 27165 | 2294 | 22 |
2126800 | 2126800 | 2022-01-18 | Wilkin | Minnesota | 27167 | 1347 | 19 |
2126801 | 2126801 | 2022-01-18 | Winona | Minnesota | 27169 | 9719 | 64 |
2126802 | 2126802 | 2022-01-18 | Wright | Minnesota | 27171 | 30895 | 273 |
2126803 | 2126803 | 2022-01-18 | Yellow Medicine | Minnesota | 27173 | 2150 | 25 |
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);