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-11-04 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
697851 | 697851 | 2020-11-04 | Aitkin | Minnesota | 27001 | 266 | 5 |
697852 | 697852 | 2020-11-04 | Anoka | Minnesota | 27003 | 10778 | 161 |
697853 | 697853 | 2020-11-04 | Becker | Minnesota | 27005 | 778 | 4 |
697854 | 697854 | 2020-11-04 | Beltrami | Minnesota | 27007 | 1068 | 12 |
697855 | 697855 | 2020-11-04 | Benton | Minnesota | 27009 | 1274 | 16 |
697856 | 697856 | 2020-11-04 | Big Stone | Minnesota | 27011 | 194 | 1 |
697857 | 697857 | 2020-11-04 | Blue Earth | Minnesota | 27013 | 2310 | 7 |
697858 | 697858 | 2020-11-04 | Brown | Minnesota | 27015 | 434 | 3 |
697859 | 697859 | 2020-11-04 | Carlton | Minnesota | 27017 | 679 | 3 |
697860 | 697860 | 2020-11-04 | Carver | Minnesota | 27019 | 2105 | 9 |
697861 | 697861 | 2020-11-04 | Cass | Minnesota | 27021 | 536 | 5 |
697862 | 697862 | 2020-11-04 | Chippewa | Minnesota | 27023 | 510 | 3 |
697863 | 697863 | 2020-11-04 | Chisago | Minnesota | 27025 | 1453 | 2 |
697864 | 697864 | 2020-11-04 | Clay | Minnesota | 27027 | 2888 | 46 |
697865 | 697865 | 2020-11-04 | Clearwater | Minnesota | 27029 | 173 | 1 |
697866 | 697866 | 2020-11-04 | Cook | Minnesota | 27031 | 30 | 0 |
697867 | 697867 | 2020-11-04 | Cottonwood | Minnesota | 27033 | 332 | 0 |
697868 | 697868 | 2020-11-04 | Crow Wing | Minnesota | 27035 | 1453 | 22 |
697869 | 697869 | 2020-11-04 | Dakota | Minnesota | 27037 | 11435 | 141 |
697870 | 697870 | 2020-11-04 | Dodge | Minnesota | 27039 | 463 | 0 |
697871 | 697871 | 2020-11-04 | Douglas | Minnesota | 27041 | 951 | 8 |
697872 | 697872 | 2020-11-04 | Faribault | Minnesota | 27043 | 286 | 0 |
697873 | 697873 | 2020-11-04 | Fillmore | Minnesota | 27045 | 318 | 0 |
697874 | 697874 | 2020-11-04 | Freeborn | Minnesota | 27047 | 798 | 5 |
697875 | 697875 | 2020-11-04 | Goodhue | Minnesota | 27049 | 838 | 14 |
697876 | 697876 | 2020-11-04 | Grant | Minnesota | 27051 | 123 | 5 |
697877 | 697877 | 2020-11-04 | Hennepin | Minnesota | 27053 | 38911 | 1009 |
697878 | 697878 | 2020-11-04 | Houston | Minnesota | 27055 | 290 | 2 |
697879 | 697879 | 2020-11-04 | Hubbard | Minnesota | 27057 | 546 | 6 |
697880 | 697880 | 2020-11-04 | Isanti | Minnesota | 27059 | 715 | 8 |
697881 | 697881 | 2020-11-04 | Itasca | Minnesota | 27061 | 921 | 17 |
697882 | 697882 | 2020-11-04 | Jackson | Minnesota | 27063 | 251 | 1 |
697883 | 697883 | 2020-11-04 | Kanabec | Minnesota | 27065 | 265 | 10 |
697884 | 697884 | 2020-11-04 | Kandiyohi | Minnesota | 27067 | 2003 | 5 |
697885 | 697885 | 2020-11-04 | Kittson | Minnesota | 27069 | 86 | 0 |
697886 | 697886 | 2020-11-04 | Koochiching | Minnesota | 27071 | 192 | 5 |
697887 | 697887 | 2020-11-04 | Lac qui Parle | Minnesota | 27073 | 165 | 3 |
697888 | 697888 | 2020-11-04 | Lake | Minnesota | 27075 | 158 | 0 |
697889 | 697889 | 2020-11-04 | Lake of the Woods | Minnesota | 27077 | 56 | 1 |
697890 | 697890 | 2020-11-04 | Le Sueur | Minnesota | 27079 | 740 | 6 |
697891 | 697891 | 2020-11-04 | Lincoln | Minnesota | 27081 | 214 | 0 |
697892 | 697892 | 2020-11-04 | Lyon | Minnesota | 27083 | 1111 | 6 |
697893 | 697893 | 2020-11-04 | Mahnomen | Minnesota | 27087 | 142 | 2 |
697894 | 697894 | 2020-11-04 | Marshall | Minnesota | 27089 | 213 | 1 |
697895 | 697895 | 2020-11-04 | Martin | Minnesota | 27091 | 670 | 18 |
697896 | 697896 | 2020-11-04 | McLeod | Minnesota | 27085 | 705 | 4 |
697897 | 697897 | 2020-11-04 | Meeker | Minnesota | 27093 | 405 | 4 |
697898 | 697898 | 2020-11-04 | Mille Lacs | Minnesota | 27095 | 573 | 21 |
697899 | 697899 | 2020-11-04 | Morrison | Minnesota | 27097 | 1020 | 9 |
697900 | 697900 | 2020-11-04 | Mower | Minnesota | 27099 | 1614 | 20 |
697901 | 697901 | 2020-11-04 | Murray | Minnesota | 27101 | 324 | 3 |
697902 | 697902 | 2020-11-04 | Nicollet | Minnesota | 27103 | 848 | 18 |
697903 | 697903 | 2020-11-04 | Nobles | Minnesota | 27105 | 2487 | 20 |
697904 | 697904 | 2020-11-04 | Norman | Minnesota | 27107 | 167 | 1 |
697905 | 697905 | 2020-11-04 | Olmsted | Minnesota | 27109 | 3823 | 30 |
697906 | 697906 | 2020-11-04 | Otter Tail | Minnesota | 27111 | 1121 | 8 |
697907 | 697907 | 2020-11-04 | Pennington | Minnesota | 27113 | 246 | 2 |
697908 | 697908 | 2020-11-04 | Pine | Minnesota | 27115 | 658 | 1 |
697909 | 697909 | 2020-11-04 | Pipestone | Minnesota | 27117 | 398 | 17 |
697910 | 697910 | 2020-11-04 | Polk | Minnesota | 27119 | 1117 | 7 |
697911 | 697911 | 2020-11-04 | Pope | Minnesota | 27121 | 193 | 0 |
697912 | 697912 | 2020-11-04 | Ramsey | Minnesota | 27123 | 16189 | 388 |
697913 | 697913 | 2020-11-04 | Red Lake | Minnesota | 27125 | 101 | 2 |
697914 | 697914 | 2020-11-04 | Redwood | Minnesota | 27127 | 346 | 12 |
697915 | 697915 | 2020-11-04 | Renville | Minnesota | 27129 | 323 | 13 |
697916 | 697916 | 2020-11-04 | Rice | Minnesota | 27131 | 1865 | 13 |
697917 | 697917 | 2020-11-04 | Rock | Minnesota | 27133 | 407 | 9 |
697918 | 697918 | 2020-11-04 | Roseau | Minnesota | 27135 | 436 | 0 |
697919 | 697919 | 2020-11-04 | Scott | Minnesota | 27139 | 4098 | 38 |
697920 | 697920 | 2020-11-04 | Sherburne | Minnesota | 27141 | 2216 | 26 |
697921 | 697921 | 2020-11-04 | Sibley | Minnesota | 27143 | 302 | 3 |
697922 | 697922 | 2020-11-04 | St. Louis | Minnesota | 27137 | 3785 | 76 |
697923 | 697923 | 2020-11-04 | Stearns | Minnesota | 27145 | 7141 | 54 |
697924 | 697924 | 2020-11-04 | Steele | Minnesota | 27147 | 897 | 4 |
697925 | 697925 | 2020-11-04 | Stevens | Minnesota | 27149 | 215 | 1 |
697926 | 697926 | 2020-11-04 | Swift | Minnesota | 27151 | 263 | 2 |
697927 | 697927 | 2020-11-04 | Todd | Minnesota | 27153 | 1052 | 9 |
697928 | 697928 | 2020-11-04 | Traverse | Minnesota | 27155 | 66 | 0 |
697929 | 697929 | 2020-11-04 | Unknown | Minnesota | 285 | 54 | |
697930 | 697930 | 2020-11-04 | Wabasha | Minnesota | 27157 | 472 | 1 |
697931 | 697931 | 2020-11-04 | Wadena | Minnesota | 27159 | 329 | 5 |
697932 | 697932 | 2020-11-04 | Waseca | Minnesota | 27161 | 981 | 10 |
697933 | 697933 | 2020-11-04 | Washington | Minnesota | 27163 | 7519 | 75 |
697934 | 697934 | 2020-11-04 | Watonwan | Minnesota | 27165 | 611 | 4 |
697935 | 697935 | 2020-11-04 | Wilkin | Minnesota | 27167 | 163 | 4 |
697936 | 697936 | 2020-11-04 | Winona | Minnesota | 27169 | 1503 | 20 |
697937 | 697937 | 2020-11-04 | Wright | Minnesota | 27171 | 3238 | 16 |
697938 | 697938 | 2020-11-04 | Yellow Medicine | Minnesota | 27173 | 353 | 7 |
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);