ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-01-12" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921764 | 921764 | 2021-01-12 | Aitkin | Minnesota | 27001 | 1057 | 33 |
921765 | 921765 | 2021-01-12 | Anoka | Minnesota | 27003 | 30475 | 352 |
921766 | 921766 | 2021-01-12 | Becker | Minnesota | 27005 | 2783 | 38 |
921767 | 921767 | 2021-01-12 | Beltrami | Minnesota | 27007 | 3026 | 46 |
921768 | 921768 | 2021-01-12 | Benton | Minnesota | 27009 | 4108 | 84 |
921769 | 921769 | 2021-01-12 | Big Stone | Minnesota | 27011 | 450 | 3 |
921770 | 921770 | 2021-01-12 | Blue Earth | Minnesota | 27013 | 5306 | 32 |
921771 | 921771 | 2021-01-12 | Brown | Minnesota | 27015 | 2113 | 34 |
921772 | 921772 | 2021-01-12 | Carlton | Minnesota | 27017 | 2754 | 41 |
921773 | 921773 | 2021-01-12 | Carver | Minnesota | 27019 | 6827 | 35 |
921774 | 921774 | 2021-01-12 | Cass | Minnesota | 27021 | 2012 | 22 |
921775 | 921775 | 2021-01-12 | Chippewa | Minnesota | 27023 | 1303 | 31 |
921776 | 921776 | 2021-01-12 | Chisago | Minnesota | 27025 | 4442 | 29 |
921777 | 921777 | 2021-01-12 | Clay | Minnesota | 27027 | 6392 | 78 |
921778 | 921778 | 2021-01-12 | Clearwater | Minnesota | 27029 | 679 | 14 |
921779 | 921779 | 2021-01-12 | Cook | Minnesota | 27031 | 111 | 0 |
921780 | 921780 | 2021-01-12 | Cottonwood | Minnesota | 27033 | 1242 | 17 |
921781 | 921781 | 2021-01-12 | Crow Wing | Minnesota | 27035 | 4722 | 71 |
921782 | 921782 | 2021-01-12 | Dakota | Minnesota | 27037 | 32330 | 310 |
921783 | 921783 | 2021-01-12 | Dodge | Minnesota | 27039 | 1285 | 4 |
921784 | 921784 | 2021-01-12 | Douglas | Minnesota | 27041 | 3683 | 65 |
921785 | 921785 | 2021-01-12 | Faribault | Minnesota | 27043 | 1022 | 14 |
921786 | 921786 | 2021-01-12 | Fillmore | Minnesota | 27045 | 1191 | 3 |
921787 | 921787 | 2021-01-12 | Freeborn | Minnesota | 27047 | 2290 | 19 |
921788 | 921788 | 2021-01-12 | Goodhue | Minnesota | 27049 | 3367 | 53 |
921789 | 921789 | 2021-01-12 | Grant | Minnesota | 27051 | 423 | 7 |
921790 | 921790 | 2021-01-12 | Hennepin | Minnesota | 27053 | 91292 | 1448 |
921791 | 921791 | 2021-01-12 | Houston | Minnesota | 27055 | 1305 | 13 |
921792 | 921792 | 2021-01-12 | Hubbard | Minnesota | 27057 | 1453 | 37 |
921793 | 921793 | 2021-01-12 | Isanti | Minnesota | 27059 | 2781 | 39 |
921794 | 921794 | 2021-01-12 | Itasca | Minnesota | 27061 | 2788 | 41 |
921795 | 921795 | 2021-01-12 | Jackson | Minnesota | 27063 | 830 | 10 |
921796 | 921796 | 2021-01-12 | Kanabec | Minnesota | 27065 | 961 | 18 |
921797 | 921797 | 2021-01-12 | Kandiyohi | Minnesota | 27067 | 5488 | 69 |
921798 | 921798 | 2021-01-12 | Kittson | Minnesota | 27069 | 358 | 19 |
921799 | 921799 | 2021-01-12 | Koochiching | Minnesota | 27071 | 572 | 10 |
921800 | 921800 | 2021-01-12 | Lac qui Parle | Minnesota | 27073 | 648 | 16 |
921801 | 921801 | 2021-01-12 | Lake | Minnesota | 27075 | 604 | 15 |
921802 | 921802 | 2021-01-12 | Lake of the Woods | Minnesota | 27077 | 172 | 1 |
921803 | 921803 | 2021-01-12 | Le Sueur | Minnesota | 27079 | 2058 | 15 |
921804 | 921804 | 2021-01-12 | Lincoln | Minnesota | 27081 | 477 | 1 |
921805 | 921805 | 2021-01-12 | Lyon | Minnesota | 27083 | 2976 | 34 |
921806 | 921806 | 2021-01-12 | Mahnomen | Minnesota | 27087 | 406 | 7 |
921807 | 921807 | 2021-01-12 | Marshall | Minnesota | 27089 | 696 | 15 |
921808 | 921808 | 2021-01-12 | Martin | Minnesota | 27091 | 1664 | 26 |
921809 | 921809 | 2021-01-12 | McLeod | Minnesota | 27085 | 3208 | 41 |
921810 | 921810 | 2021-01-12 | Meeker | Minnesota | 27093 | 1967 | 33 |
921811 | 921811 | 2021-01-12 | Mille Lacs | Minnesota | 27095 | 2110 | 45 |
921812 | 921812 | 2021-01-12 | Morrison | Minnesota | 27097 | 3068 | 43 |
921813 | 921813 | 2021-01-12 | Mower | Minnesota | 27099 | 3537 | 26 |
921814 | 921814 | 2021-01-12 | Murray | Minnesota | 27101 | 849 | 5 |
921815 | 921815 | 2021-01-12 | Nicollet | Minnesota | 27103 | 2200 | 36 |
921816 | 921816 | 2021-01-12 | Nobles | Minnesota | 27105 | 3627 | 46 |
921817 | 921817 | 2021-01-12 | Norman | Minnesota | 27107 | 420 | 8 |
921818 | 921818 | 2021-01-12 | Olmsted | Minnesota | 27109 | 10089 | 68 |
921819 | 921819 | 2021-01-12 | Otter Tail | Minnesota | 27111 | 4464 | 57 |
921820 | 921820 | 2021-01-12 | Pennington | Minnesota | 27113 | 939 | 15 |
921821 | 921821 | 2021-01-12 | Pine | Minnesota | 27115 | 2616 | 13 |
921822 | 921822 | 2021-01-12 | Pipestone | Minnesota | 27117 | 913 | 22 |
921823 | 921823 | 2021-01-12 | Polk | Minnesota | 27119 | 3255 | 53 |
921824 | 921824 | 2021-01-12 | Pope | Minnesota | 27121 | 732 | 5 |
921825 | 921825 | 2021-01-12 | Ramsey | Minnesota | 27123 | 39186 | 723 |
921826 | 921826 | 2021-01-12 | Red Lake | Minnesota | 27125 | 314 | 4 |
921827 | 921827 | 2021-01-12 | Redwood | Minnesota | 27127 | 1366 | 27 |
921828 | 921828 | 2021-01-12 | Renville | Minnesota | 27129 | 1354 | 39 |
921829 | 921829 | 2021-01-12 | Rice | Minnesota | 27131 | 5891 | 64 |
921830 | 921830 | 2021-01-12 | Rock | Minnesota | 27133 | 1074 | 11 |
921831 | 921831 | 2021-01-12 | Roseau | Minnesota | 27135 | 1641 | 16 |
921832 | 921832 | 2021-01-12 | Scott | Minnesota | 27139 | 11703 | 93 |
921833 | 921833 | 2021-01-12 | Sherburne | Minnesota | 27141 | 8082 | 62 |
921834 | 921834 | 2021-01-12 | Sibley | Minnesota | 27143 | 1069 | 7 |
921835 | 921835 | 2021-01-12 | St. Louis | Minnesota | 27137 | 13358 | 231 |
921836 | 921836 | 2021-01-12 | Stearns | Minnesota | 27145 | 17600 | 179 |
921837 | 921837 | 2021-01-12 | Steele | Minnesota | 27147 | 2646 | 9 |
921838 | 921838 | 2021-01-12 | Stevens | Minnesota | 27149 | 690 | 8 |
921839 | 921839 | 2021-01-12 | Swift | Minnesota | 27151 | 821 | 17 |
921840 | 921840 | 2021-01-12 | Todd | Minnesota | 27153 | 2296 | 29 |
921841 | 921841 | 2021-01-12 | Traverse | Minnesota | 27155 | 238 | 3 |
921842 | 921842 | 2021-01-12 | Unknown | Minnesota | 546 | 68 | |
921843 | 921843 | 2021-01-12 | Wabasha | Minnesota | 27157 | 1644 | 2 |
921844 | 921844 | 2021-01-12 | Wadena | Minnesota | 27159 | 1177 | 13 |
921845 | 921845 | 2021-01-12 | Waseca | Minnesota | 27161 | 1868 | 15 |
921846 | 921846 | 2021-01-12 | Washington | Minnesota | 27163 | 19687 | 213 |
921847 | 921847 | 2021-01-12 | Watonwan | Minnesota | 27165 | 1049 | 7 |
921848 | 921848 | 2021-01-12 | Wilkin | Minnesota | 27167 | 608 | 9 |
921849 | 921849 | 2021-01-12 | Winona | Minnesota | 27169 | 3789 | 45 |
921850 | 921850 | 2021-01-12 | Wright | Minnesota | 27171 | 11401 | 99 |
921851 | 921851 | 2021-01-12 | Yellow Medicine | Minnesota | 27173 | 921 | 14 |
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);