ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where date = "2020-05-27" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Aitkin 1
- Anoka 1
- Becker 1
- Beltrami 1
- Benton 1
- Big Stone 1
- Blue Earth 1
- Brown 1
- Carlton 1
- Carver 1
- Cass 1
- Chippewa 1
- Chisago 1
- Clay 1
- Clearwater 1
- Cottonwood 1
- Crow Wing 1
- Dakota 1
- Dodge 1
- Douglas 1
- Faribault 1
- Fillmore 1
- Freeborn 1
- Goodhue 1
- Grant 1
- Hennepin 1
- Houston 1
- Hubbard 1
- Isanti 1
- Itasca 1
- …
state 1
- Minnesota · 85 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
182813 | 182813 | 2020-05-27 | Aitkin | Minnesota | 27001 | 7 | 0 |
182814 | 182814 | 2020-05-27 | Anoka | Minnesota | 27003 | 1262 | 59 |
182815 | 182815 | 2020-05-27 | Becker | Minnesota | 27005 | 37 | 0 |
182816 | 182816 | 2020-05-27 | Beltrami | Minnesota | 27007 | 13 | 0 |
182817 | 182817 | 2020-05-27 | Benton | Minnesota | 27009 | 169 | 2 |
182818 | 182818 | 2020-05-27 | Big Stone | Minnesota | 27011 | 3 | 0 |
182819 | 182819 | 2020-05-27 | Blue Earth | Minnesota | 27013 | 122 | 1 |
182820 | 182820 | 2020-05-27 | Brown | Minnesota | 27015 | 14 | 2 |
182821 | 182821 | 2020-05-27 | Carlton | Minnesota | 27017 | 73 | 0 |
182822 | 182822 | 2020-05-27 | Carver | Minnesota | 27019 | 185 | 2 |
182823 | 182823 | 2020-05-27 | Cass | Minnesota | 27021 | 12 | 2 |
182824 | 182824 | 2020-05-27 | Chippewa | Minnesota | 27023 | 44 | 1 |
182825 | 182825 | 2020-05-27 | Chisago | Minnesota | 27025 | 50 | 1 |
182826 | 182826 | 2020-05-27 | Clay | Minnesota | 27027 | 406 | 25 |
182827 | 182827 | 2020-05-27 | Clearwater | Minnesota | 27029 | 3 | 0 |
182828 | 182828 | 2020-05-27 | Cottonwood | Minnesota | 27033 | 65 | 0 |
182829 | 182829 | 2020-05-27 | Crow Wing | Minnesota | 27035 | 57 | 1 |
182830 | 182830 | 2020-05-27 | Dakota | Minnesota | 27037 | 1182 | 44 |
182831 | 182831 | 2020-05-27 | Dodge | Minnesota | 27039 | 46 | 0 |
182832 | 182832 | 2020-05-27 | Douglas | Minnesota | 27041 | 39 | 0 |
182833 | 182833 | 2020-05-27 | Faribault | Minnesota | 27043 | 13 | 0 |
182834 | 182834 | 2020-05-27 | Fillmore | Minnesota | 27045 | 17 | 1 |
182835 | 182835 | 2020-05-27 | Freeborn | Minnesota | 27047 | 97 | 0 |
182836 | 182836 | 2020-05-27 | Goodhue | Minnesota | 27049 | 60 | 3 |
182837 | 182837 | 2020-05-27 | Grant | Minnesota | 27051 | 3 | 0 |
182838 | 182838 | 2020-05-27 | Hennepin | Minnesota | 27053 | 7540 | 565 |
182839 | 182839 | 2020-05-27 | Houston | Minnesota | 27055 | 2 | 0 |
182840 | 182840 | 2020-05-27 | Hubbard | Minnesota | 27057 | 1 | 0 |
182841 | 182841 | 2020-05-27 | Isanti | Minnesota | 27059 | 33 | 0 |
182842 | 182842 | 2020-05-27 | Itasca | Minnesota | 27061 | 53 | 7 |
182843 | 182843 | 2020-05-27 | Jackson | Minnesota | 27063 | 39 | 0 |
182844 | 182844 | 2020-05-27 | Kanabec | Minnesota | 27065 | 11 | 1 |
182845 | 182845 | 2020-05-27 | Kandiyohi | Minnesota | 27067 | 475 | 1 |
182846 | 182846 | 2020-05-27 | Kittson | Minnesota | 27069 | 1 | 0 |
182847 | 182847 | 2020-05-27 | Koochiching | Minnesota | 27071 | 7 | 0 |
182848 | 182848 | 2020-05-27 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
182849 | 182849 | 2020-05-27 | Lake | Minnesota | 27075 | 1 | 0 |
182850 | 182850 | 2020-05-27 | Le Sueur | Minnesota | 27079 | 43 | 1 |
182851 | 182851 | 2020-05-27 | Lincoln | Minnesota | 27081 | 5 | 0 |
182852 | 182852 | 2020-05-27 | Lyon | Minnesota | 27083 | 36 | 0 |
182853 | 182853 | 2020-05-27 | Mahnomen | Minnesota | 27087 | 5 | 1 |
182854 | 182854 | 2020-05-27 | Marshall | Minnesota | 27089 | 9 | 0 |
182855 | 182855 | 2020-05-27 | Martin | Minnesota | 27091 | 126 | 5 |
182856 | 182856 | 2020-05-27 | McLeod | Minnesota | 27085 | 29 | 0 |
182857 | 182857 | 2020-05-27 | Meeker | Minnesota | 27093 | 44 | 0 |
182858 | 182858 | 2020-05-27 | Mille Lacs | Minnesota | 27095 | 17 | 1 |
182859 | 182859 | 2020-05-27 | Morrison | Minnesota | 27097 | 40 | 0 |
182860 | 182860 | 2020-05-27 | Mower | Minnesota | 27099 | 216 | 1 |
182861 | 182861 | 2020-05-27 | Murray | Minnesota | 27101 | 36 | 0 |
182862 | 182862 | 2020-05-27 | Nicollet | Minnesota | 27103 | 74 | 7 |
182863 | 182863 | 2020-05-27 | Nobles | Minnesota | 27105 | 1488 | 3 |
182864 | 182864 | 2020-05-27 | Norman | Minnesota | 27107 | 11 | 0 |
182865 | 182865 | 2020-05-27 | Olmsted | Minnesota | 27109 | 575 | 10 |
182866 | 182866 | 2020-05-27 | Otter Tail | Minnesota | 27111 | 62 | 0 |
182867 | 182867 | 2020-05-27 | Pennington | Minnesota | 27113 | 17 | 0 |
182868 | 182868 | 2020-05-27 | Pine | Minnesota | 27115 | 85 | 0 |
182869 | 182869 | 2020-05-27 | Pipestone | Minnesota | 27117 | 10 | 0 |
182870 | 182870 | 2020-05-27 | Polk | Minnesota | 27119 | 59 | 2 |
182871 | 182871 | 2020-05-27 | Pope | Minnesota | 27121 | 8 | 0 |
182872 | 182872 | 2020-05-27 | Ramsey | Minnesota | 27123 | 2610 | 103 |
182873 | 182873 | 2020-05-27 | Red Lake | Minnesota | 27125 | 4 | 0 |
182874 | 182874 | 2020-05-27 | Redwood | Minnesota | 27127 | 3 | 0 |
182875 | 182875 | 2020-05-27 | Renville | Minnesota | 27129 | 5 | 0 |
182876 | 182876 | 2020-05-27 | Rice | Minnesota | 27131 | 411 | 2 |
182877 | 182877 | 2020-05-27 | Rock | Minnesota | 27133 | 21 | 0 |
182878 | 182878 | 2020-05-27 | Roseau | Minnesota | 27135 | 1 | 0 |
182879 | 182879 | 2020-05-27 | Scott | Minnesota | 27139 | 379 | 2 |
182880 | 182880 | 2020-05-27 | Sherburne | Minnesota | 27141 | 219 | 2 |
182881 | 182881 | 2020-05-27 | Sibley | Minnesota | 27143 | 13 | 0 |
182882 | 182882 | 2020-05-27 | St. Louis | Minnesota | 27137 | 115 | 13 |
182883 | 182883 | 2020-05-27 | Stearns | Minnesota | 27145 | 1984 | 12 |
182884 | 182884 | 2020-05-27 | Steele | Minnesota | 27147 | 148 | 0 |
182885 | 182885 | 2020-05-27 | Swift | Minnesota | 27151 | 17 | 0 |
182886 | 182886 | 2020-05-27 | Todd | Minnesota | 27153 | 296 | 0 |
182887 | 182887 | 2020-05-27 | Traverse | Minnesota | 27155 | 3 | 0 |
182888 | 182888 | 2020-05-27 | Unknown | Minnesota | 71 | 10 | |
182889 | 182889 | 2020-05-27 | Wabasha | Minnesota | 27157 | 17 | 0 |
182890 | 182890 | 2020-05-27 | Wadena | Minnesota | 27159 | 8 | 0 |
182891 | 182891 | 2020-05-27 | Waseca | Minnesota | 27161 | 24 | 0 |
182892 | 182892 | 2020-05-27 | Washington | Minnesota | 27163 | 562 | 30 |
182893 | 182893 | 2020-05-27 | Watonwan | Minnesota | 27165 | 59 | 0 |
182894 | 182894 | 2020-05-27 | Wilkin | Minnesota | 27167 | 11 | 3 |
182895 | 182895 | 2020-05-27 | Winona | Minnesota | 27169 | 78 | 15 |
182896 | 182896 | 2020-05-27 | Wright | Minnesota | 27171 | 269 | 1 |
182897 | 182897 | 2020-05-27 | Yellow Medicine | Minnesota | 27173 | 6 | 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);