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 2020-08-16 and state = "Minnesota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
438785 | 438785 | 2020-08-16 | Aitkin | Minnesota | 27001 | 42 | 1 |
438786 | 438786 | 2020-08-16 | Anoka | Minnesota | 27003 | 4013 | 115 |
438787 | 438787 | 2020-08-16 | Becker | Minnesota | 27005 | 165 | 1 |
438788 | 438788 | 2020-08-16 | Beltrami | Minnesota | 27007 | 271 | 0 |
438789 | 438789 | 2020-08-16 | Benton | Minnesota | 27009 | 332 | 3 |
438790 | 438790 | 2020-08-16 | Big Stone | Minnesota | 27011 | 25 | 0 |
438791 | 438791 | 2020-08-16 | Blue Earth | Minnesota | 27013 | 982 | 6 |
438792 | 438792 | 2020-08-16 | Brown | Minnesota | 27015 | 99 | 2 |
438793 | 438793 | 2020-08-16 | Carlton | Minnesota | 27017 | 156 | 1 |
438794 | 438794 | 2020-08-16 | Carver | Minnesota | 27019 | 954 | 3 |
438795 | 438795 | 2020-08-16 | Cass | Minnesota | 27021 | 80 | 3 |
438796 | 438796 | 2020-08-16 | Chippewa | Minnesota | 27023 | 124 | 1 |
438797 | 438797 | 2020-08-16 | Chisago | Minnesota | 27025 | 214 | 1 |
438798 | 438798 | 2020-08-16 | Clay | Minnesota | 27027 | 797 | 40 |
438799 | 438799 | 2020-08-16 | Clearwater | Minnesota | 27029 | 14 | 0 |
438800 | 438800 | 2020-08-16 | Cook | Minnesota | 27031 | 6 | 0 |
438801 | 438801 | 2020-08-16 | Cottonwood | Minnesota | 27033 | 182 | 0 |
438802 | 438802 | 2020-08-16 | Crow Wing | Minnesota | 27035 | 268 | 14 |
438803 | 438803 | 2020-08-16 | Dakota | Minnesota | 27037 | 4810 | 106 |
438804 | 438804 | 2020-08-16 | Dodge | Minnesota | 27039 | 137 | 0 |
438805 | 438805 | 2020-08-16 | Douglas | Minnesota | 27041 | 147 | 1 |
438806 | 438806 | 2020-08-16 | Faribault | Minnesota | 27043 | 95 | 0 |
438807 | 438807 | 2020-08-16 | Fillmore | Minnesota | 27045 | 74 | 0 |
438808 | 438808 | 2020-08-16 | Freeborn | Minnesota | 27047 | 367 | 1 |
438809 | 438809 | 2020-08-16 | Goodhue | Minnesota | 27049 | 213 | 9 |
438810 | 438810 | 2020-08-16 | Grant | Minnesota | 27051 | 57 | 4 |
438811 | 438811 | 2020-08-16 | Hennepin | Minnesota | 27053 | 20469 | 848 |
438812 | 438812 | 2020-08-16 | Houston | Minnesota | 27055 | 57 | 0 |
438813 | 438813 | 2020-08-16 | Hubbard | Minnesota | 27057 | 37 | 0 |
438814 | 438814 | 2020-08-16 | Isanti | Minnesota | 27059 | 147 | 0 |
438815 | 438815 | 2020-08-16 | Itasca | Minnesota | 27061 | 147 | 12 |
438816 | 438816 | 2020-08-16 | Jackson | Minnesota | 27063 | 83 | 0 |
438817 | 438817 | 2020-08-16 | Kanabec | Minnesota | 27065 | 41 | 3 |
438818 | 438818 | 2020-08-16 | Kandiyohi | Minnesota | 27067 | 739 | 1 |
438819 | 438819 | 2020-08-16 | Kittson | Minnesota | 27069 | 3 | 0 |
438820 | 438820 | 2020-08-16 | Koochiching | Minnesota | 27071 | 84 | 3 |
438821 | 438821 | 2020-08-16 | Lac qui Parle | Minnesota | 27073 | 10 | 0 |
438822 | 438822 | 2020-08-16 | Lake | Minnesota | 27075 | 25 | 0 |
438823 | 438823 | 2020-08-16 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
438824 | 438824 | 2020-08-16 | Le Sueur | Minnesota | 27079 | 248 | 1 |
438825 | 438825 | 2020-08-16 | Lincoln | Minnesota | 27081 | 61 | 0 |
438826 | 438826 | 2020-08-16 | Lyon | Minnesota | 27083 | 430 | 3 |
438827 | 438827 | 2020-08-16 | Mahnomen | Minnesota | 27087 | 28 | 1 |
438828 | 438828 | 2020-08-16 | Marshall | Minnesota | 27089 | 30 | 0 |
438829 | 438829 | 2020-08-16 | Martin | Minnesota | 27091 | 211 | 6 |
438830 | 438830 | 2020-08-16 | McLeod | Minnesota | 27085 | 260 | 0 |
438831 | 438831 | 2020-08-16 | Meeker | Minnesota | 27093 | 90 | 2 |
438832 | 438832 | 2020-08-16 | Mille Lacs | Minnesota | 27095 | 78 | 3 |
438833 | 438833 | 2020-08-16 | Morrison | Minnesota | 27097 | 103 | 1 |
438834 | 438834 | 2020-08-16 | Mower | Minnesota | 27099 | 1126 | 2 |
438835 | 438835 | 2020-08-16 | Murray | Minnesota | 27101 | 129 | 1 |
438836 | 438836 | 2020-08-16 | Nicollet | Minnesota | 27103 | 375 | 13 |
438837 | 438837 | 2020-08-16 | Nobles | Minnesota | 27105 | 1792 | 9 |
438838 | 438838 | 2020-08-16 | Norman | Minnesota | 27107 | 40 | 0 |
438839 | 438839 | 2020-08-16 | Olmsted | Minnesota | 27109 | 1835 | 23 |
438840 | 438840 | 2020-08-16 | Otter Tail | Minnesota | 27111 | 217 | 4 |
438841 | 438841 | 2020-08-16 | Pennington | Minnesota | 27113 | 75 | 1 |
438842 | 438842 | 2020-08-16 | Pine | Minnesota | 27115 | 132 | 0 |
438843 | 438843 | 2020-08-16 | Pipestone | Minnesota | 27117 | 163 | 9 |
438844 | 438844 | 2020-08-16 | Polk | Minnesota | 27119 | 161 | 4 |
438845 | 438845 | 2020-08-16 | Pope | Minnesota | 27121 | 48 | 0 |
438846 | 438846 | 2020-08-16 | Ramsey | Minnesota | 27123 | 8054 | 274 |
438847 | 438847 | 2020-08-16 | Red Lake | Minnesota | 27125 | 26 | 0 |
438848 | 438848 | 2020-08-16 | Redwood | Minnesota | 27127 | 38 | 0 |
438849 | 438849 | 2020-08-16 | Renville | Minnesota | 27129 | 69 | 5 |
438850 | 438850 | 2020-08-16 | Rice | Minnesota | 27131 | 1065 | 8 |
438851 | 438851 | 2020-08-16 | Rock | Minnesota | 27133 | 90 | 0 |
438852 | 438852 | 2020-08-16 | Roseau | Minnesota | 27135 | 56 | 0 |
438853 | 438853 | 2020-08-16 | Scott | Minnesota | 27139 | 1717 | 23 |
438854 | 438854 | 2020-08-16 | Sherburne | Minnesota | 27141 | 780 | 10 |
438855 | 438855 | 2020-08-16 | Sibley | Minnesota | 27143 | 89 | 2 |
438856 | 438856 | 2020-08-16 | St. Louis | Minnesota | 27137 | 670 | 21 |
438857 | 438857 | 2020-08-16 | Stearns | Minnesota | 27145 | 2957 | 20 |
438858 | 438858 | 2020-08-16 | Steele | Minnesota | 27147 | 367 | 2 |
438859 | 438859 | 2020-08-16 | Stevens | Minnesota | 27149 | 22 | 0 |
438860 | 438860 | 2020-08-16 | Swift | Minnesota | 27151 | 58 | 1 |
438861 | 438861 | 2020-08-16 | Todd | Minnesota | 27153 | 435 | 2 |
438862 | 438862 | 2020-08-16 | Traverse | Minnesota | 27155 | 16 | 0 |
438863 | 438863 | 2020-08-16 | Unknown | Minnesota | 192 | 46 | |
438864 | 438864 | 2020-08-16 | Wabasha | Minnesota | 27157 | 101 | 0 |
438865 | 438865 | 2020-08-16 | Wadena | Minnesota | 27159 | 29 | 0 |
438866 | 438866 | 2020-08-16 | Waseca | Minnesota | 27161 | 169 | 1 |
438867 | 438867 | 2020-08-16 | Washington | Minnesota | 27163 | 2354 | 48 |
438868 | 438868 | 2020-08-16 | Watonwan | Minnesota | 27165 | 391 | 2 |
438869 | 438869 | 2020-08-16 | Wilkin | Minnesota | 27167 | 39 | 3 |
438870 | 438870 | 2020-08-16 | Winona | Minnesota | 27169 | 279 | 17 |
438871 | 438871 | 2020-08-16 | Wright | Minnesota | 27171 | 976 | 5 |
438872 | 438872 | 2020-08-16 | Yellow Medicine | Minnesota | 27173 | 54 | 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);