ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-05-10" 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 |
---|---|---|---|---|---|---|---|
1304841 | 1304841 | 2021-05-10 | Aitkin | Minnesota | 27001 | 1342 | 36 |
1304842 | 1304842 | 2021-05-10 | Anoka | Minnesota | 27003 | 41373 | 436 |
1304843 | 1304843 | 2021-05-10 | Becker | Minnesota | 27005 | 3787 | 50 |
1304844 | 1304844 | 2021-05-10 | Beltrami | Minnesota | 27007 | 3912 | 58 |
1304845 | 1304845 | 2021-05-10 | Benton | Minnesota | 27009 | 5650 | 97 |
1304846 | 1304846 | 2021-05-10 | Big Stone | Minnesota | 27011 | 598 | 4 |
1304847 | 1304847 | 2021-05-10 | Blue Earth | Minnesota | 27013 | 7454 | 41 |
1304848 | 1304848 | 2021-05-10 | Brown | Minnesota | 27015 | 3043 | 40 |
1304849 | 1304849 | 2021-05-10 | Carlton | Minnesota | 27017 | 3438 | 53 |
1304850 | 1304850 | 2021-05-10 | Carver | Minnesota | 27019 | 10441 | 45 |
1304851 | 1304851 | 2021-05-10 | Cass | Minnesota | 27021 | 2694 | 28 |
1304852 | 1304852 | 2021-05-10 | Chippewa | Minnesota | 27023 | 1517 | 38 |
1304853 | 1304853 | 2021-05-10 | Chisago | Minnesota | 27025 | 5909 | 51 |
1304854 | 1304854 | 2021-05-10 | Clay | Minnesota | 27027 | 8124 | 92 |
1304855 | 1304855 | 2021-05-10 | Clearwater | Minnesota | 27029 | 863 | 16 |
1304856 | 1304856 | 2021-05-10 | Cook | Minnesota | 27031 | 161 | 0 |
1304857 | 1304857 | 2021-05-10 | Cottonwood | Minnesota | 27033 | 1642 | 21 |
1304858 | 1304858 | 2021-05-10 | Crow Wing | Minnesota | 27035 | 6599 | 88 |
1304859 | 1304859 | 2021-05-10 | Dakota | Minnesota | 27037 | 45622 | 446 |
1304860 | 1304860 | 2021-05-10 | Dodge | Minnesota | 27039 | 1834 | 3 |
1304861 | 1304861 | 2021-05-10 | Douglas | Minnesota | 27041 | 4642 | 74 |
1304862 | 1304862 | 2021-05-10 | Faribault | Minnesota | 27043 | 1512 | 19 |
1304863 | 1304863 | 2021-05-10 | Fillmore | Minnesota | 27045 | 1555 | 10 |
1304864 | 1304864 | 2021-05-10 | Freeborn | Minnesota | 27047 | 3411 | 29 |
1304865 | 1304865 | 2021-05-10 | Goodhue | Minnesota | 27049 | 4753 | 72 |
1304866 | 1304866 | 2021-05-10 | Grant | Minnesota | 27051 | 567 | 8 |
1304867 | 1304867 | 2021-05-10 | Hennepin | Minnesota | 27053 | 122024 | 1724 |
1304868 | 1304868 | 2021-05-10 | Houston | Minnesota | 27055 | 1714 | 15 |
1304869 | 1304869 | 2021-05-10 | Hubbard | Minnesota | 27057 | 1869 | 41 |
1304870 | 1304870 | 2021-05-10 | Isanti | Minnesota | 27059 | 4170 | 64 |
1304871 | 1304871 | 2021-05-10 | Itasca | Minnesota | 27061 | 4297 | 53 |
1304872 | 1304872 | 2021-05-10 | Jackson | Minnesota | 27063 | 1218 | 11 |
1304873 | 1304873 | 2021-05-10 | Kanabec | Minnesota | 27065 | 1435 | 24 |
1304874 | 1304874 | 2021-05-10 | Kandiyohi | Minnesota | 27067 | 6516 | 83 |
1304875 | 1304875 | 2021-05-10 | Kittson | Minnesota | 27069 | 485 | 22 |
1304876 | 1304876 | 2021-05-10 | Koochiching | Minnesota | 27071 | 817 | 15 |
1304877 | 1304877 | 2021-05-10 | Lac qui Parle | Minnesota | 27073 | 750 | 22 |
1304878 | 1304878 | 2021-05-10 | Lake | Minnesota | 27075 | 808 | 19 |
1304879 | 1304879 | 2021-05-10 | Lake of the Woods | Minnesota | 27077 | 322 | 3 |
1304880 | 1304880 | 2021-05-10 | Le Sueur | Minnesota | 27079 | 2890 | 22 |
1304881 | 1304881 | 2021-05-10 | Lincoln | Minnesota | 27081 | 577 | 3 |
1304882 | 1304882 | 2021-05-10 | Lyon | Minnesota | 27083 | 3598 | 50 |
1304883 | 1304883 | 2021-05-10 | Mahnomen | Minnesota | 27087 | 545 | 9 |
1304884 | 1304884 | 2021-05-10 | Marshall | Minnesota | 27089 | 879 | 17 |
1304885 | 1304885 | 2021-05-10 | Martin | Minnesota | 27091 | 2298 | 31 |
1304886 | 1304886 | 2021-05-10 | McLeod | Minnesota | 27085 | 4210 | 58 |
1304887 | 1304887 | 2021-05-10 | Meeker | Minnesota | 27093 | 2541 | 40 |
1304888 | 1304888 | 2021-05-10 | Mille Lacs | Minnesota | 27095 | 3013 | 52 |
1304889 | 1304889 | 2021-05-10 | Morrison | Minnesota | 27097 | 4166 | 60 |
1304890 | 1304890 | 2021-05-10 | Mower | Minnesota | 27099 | 4637 | 32 |
1304891 | 1304891 | 2021-05-10 | Murray | Minnesota | 27101 | 1060 | 9 |
1304892 | 1304892 | 2021-05-10 | Nicollet | Minnesota | 27103 | 3236 | 43 |
1304893 | 1304893 | 2021-05-10 | Nobles | Minnesota | 27105 | 4071 | 48 |
1304894 | 1304894 | 2021-05-10 | Norman | Minnesota | 27107 | 539 | 9 |
1304895 | 1304895 | 2021-05-10 | Olmsted | Minnesota | 27109 | 13184 | 98 |
1304896 | 1304896 | 2021-05-10 | Otter Tail | Minnesota | 27111 | 5726 | 78 |
1304897 | 1304897 | 2021-05-10 | Pennington | Minnesota | 27113 | 1536 | 19 |
1304898 | 1304898 | 2021-05-10 | Pine | Minnesota | 27115 | 3265 | 22 |
1304899 | 1304899 | 2021-05-10 | Pipestone | Minnesota | 27117 | 1149 | 26 |
1304900 | 1304900 | 2021-05-10 | Polk | Minnesota | 27119 | 3822 | 68 |
1304901 | 1304901 | 2021-05-10 | Pope | Minnesota | 27121 | 1094 | 6 |
1304902 | 1304902 | 2021-05-10 | Ramsey | Minnesota | 27123 | 50981 | 870 |
1304903 | 1304903 | 2021-05-10 | Red Lake | Minnesota | 27125 | 395 | 7 |
1304904 | 1304904 | 2021-05-10 | Redwood | Minnesota | 27127 | 1726 | 36 |
1304905 | 1304905 | 2021-05-10 | Renville | Minnesota | 27129 | 1789 | 43 |
1304906 | 1304906 | 2021-05-10 | Rice | Minnesota | 27131 | 8007 | 106 |
1304907 | 1304907 | 2021-05-10 | Rock | Minnesota | 27133 | 1278 | 19 |
1304908 | 1304908 | 2021-05-10 | Roseau | Minnesota | 27135 | 2079 | 19 |
1304909 | 1304909 | 2021-05-10 | Scott | Minnesota | 27139 | 17176 | 124 |
1304910 | 1304910 | 2021-05-10 | Sherburne | Minnesota | 27141 | 11609 | 85 |
1304911 | 1304911 | 2021-05-10 | Sibley | Minnesota | 27143 | 1425 | 10 |
1304912 | 1304912 | 2021-05-10 | St. Louis | Minnesota | 27137 | 17662 | 302 |
1304913 | 1304913 | 2021-05-10 | Stearns | Minnesota | 27145 | 22116 | 221 |
1304914 | 1304914 | 2021-05-10 | Steele | Minnesota | 27147 | 3843 | 15 |
1304915 | 1304915 | 2021-05-10 | Stevens | Minnesota | 27149 | 902 | 11 |
1304916 | 1304916 | 2021-05-10 | Swift | Minnesota | 27151 | 1049 | 18 |
1304917 | 1304917 | 2021-05-10 | Todd | Minnesota | 27153 | 2803 | 32 |
1304918 | 1304918 | 2021-05-10 | Traverse | Minnesota | 27155 | 368 | 5 |
1304919 | 1304919 | 2021-05-10 | Unknown | Minnesota | 585 | 93 | |
1304920 | 1304920 | 2021-05-10 | Wabasha | Minnesota | 27157 | 2048 | 3 |
1304921 | 1304921 | 2021-05-10 | Wadena | Minnesota | 27159 | 1549 | 22 |
1304922 | 1304922 | 2021-05-10 | Waseca | Minnesota | 27161 | 2364 | 22 |
1304923 | 1304923 | 2021-05-10 | Washington | Minnesota | 27163 | 26692 | 280 |
1304924 | 1304924 | 2021-05-10 | Watonwan | Minnesota | 27165 | 1321 | 9 |
1304925 | 1304925 | 2021-05-10 | Wilkin | Minnesota | 27167 | 806 | 12 |
1304926 | 1304926 | 2021-05-10 | Winona | Minnesota | 27169 | 4521 | 50 |
1304927 | 1304927 | 2021-05-10 | Wright | Minnesota | 27171 | 15909 | 139 |
1304928 | 1304928 | 2021-05-10 | Yellow Medicine | Minnesota | 27173 | 1138 | 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);