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 2021-02-26 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1067814 | 1067814 | 2021-02-26 | Aitkin | Minnesota | 27001 | 1186 | 33 |
1067815 | 1067815 | 2021-02-26 | Anoka | Minnesota | 27003 | 33152 | 384 |
1067816 | 1067816 | 2021-02-26 | Becker | Minnesota | 27005 | 3095 | 41 |
1067817 | 1067817 | 2021-02-26 | Beltrami | Minnesota | 27007 | 3360 | 51 |
1067818 | 1067818 | 2021-02-26 | Benton | Minnesota | 27009 | 4424 | 90 |
1067819 | 1067819 | 2021-02-26 | Big Stone | Minnesota | 27011 | 513 | 3 |
1067820 | 1067820 | 2021-02-26 | Blue Earth | Minnesota | 27013 | 5896 | 35 |
1067821 | 1067821 | 2021-02-26 | Brown | Minnesota | 27015 | 2426 | 37 |
1067822 | 1067822 | 2021-02-26 | Carlton | Minnesota | 27017 | 2991 | 47 |
1067823 | 1067823 | 2021-02-26 | Carver | Minnesota | 27019 | 7623 | 40 |
1067824 | 1067824 | 2021-02-26 | Cass | Minnesota | 27021 | 2189 | 24 |
1067825 | 1067825 | 2021-02-26 | Chippewa | Minnesota | 27023 | 1358 | 35 |
1067826 | 1067826 | 2021-02-26 | Chisago | Minnesota | 27025 | 4961 | 44 |
1067827 | 1067827 | 2021-02-26 | Clay | Minnesota | 27027 | 6867 | 87 |
1067828 | 1067828 | 2021-02-26 | Clearwater | Minnesota | 27029 | 718 | 14 |
1067829 | 1067829 | 2021-02-26 | Cook | Minnesota | 27031 | 119 | 0 |
1067830 | 1067830 | 2021-02-26 | Cottonwood | Minnesota | 27033 | 1340 | 20 |
1067831 | 1067831 | 2021-02-26 | Crow Wing | Minnesota | 27035 | 5179 | 81 |
1067832 | 1067832 | 2021-02-26 | Dakota | Minnesota | 27037 | 36033 | 384 |
1067833 | 1067833 | 2021-02-26 | Dodge | Minnesota | 27039 | 1515 | 4 |
1067834 | 1067834 | 2021-02-26 | Douglas | Minnesota | 27041 | 3920 | 68 |
1067835 | 1067835 | 2021-02-26 | Faribault | Minnesota | 27043 | 1225 | 16 |
1067836 | 1067836 | 2021-02-26 | Fillmore | Minnesota | 27045 | 1368 | 8 |
1067837 | 1067837 | 2021-02-26 | Freeborn | Minnesota | 27047 | 2791 | 23 |
1067838 | 1067838 | 2021-02-26 | Goodhue | Minnesota | 27049 | 3842 | 68 |
1067839 | 1067839 | 2021-02-26 | Grant | Minnesota | 27051 | 489 | 8 |
1067840 | 1067840 | 2021-02-26 | Hennepin | Minnesota | 27053 | 100202 | 1580 |
1067841 | 1067841 | 2021-02-26 | Houston | Minnesota | 27055 | 1569 | 14 |
1067842 | 1067842 | 2021-02-26 | Hubbard | Minnesota | 27057 | 1604 | 40 |
1067843 | 1067843 | 2021-02-26 | Isanti | Minnesota | 27059 | 3051 | 53 |
1067844 | 1067844 | 2021-02-26 | Itasca | Minnesota | 27061 | 3114 | 46 |
1067845 | 1067845 | 2021-02-26 | Jackson | Minnesota | 27063 | 930 | 10 |
1067846 | 1067846 | 2021-02-26 | Kanabec | Minnesota | 27065 | 1071 | 19 |
1067847 | 1067847 | 2021-02-26 | Kandiyohi | Minnesota | 27067 | 5782 | 74 |
1067848 | 1067848 | 2021-02-26 | Kittson | Minnesota | 27069 | 408 | 21 |
1067849 | 1067849 | 2021-02-26 | Koochiching | Minnesota | 27071 | 617 | 11 |
1067850 | 1067850 | 2021-02-26 | Lac qui Parle | Minnesota | 27073 | 682 | 16 |
1067851 | 1067851 | 2021-02-26 | Lake | Minnesota | 27075 | 734 | 18 |
1067852 | 1067852 | 2021-02-26 | Lake of the Woods | Minnesota | 27077 | 214 | 1 |
1067853 | 1067853 | 2021-02-26 | Le Sueur | Minnesota | 27079 | 2332 | 20 |
1067854 | 1067854 | 2021-02-26 | Lincoln | Minnesota | 27081 | 504 | 2 |
1067855 | 1067855 | 2021-02-26 | Lyon | Minnesota | 27083 | 3119 | 43 |
1067856 | 1067856 | 2021-02-26 | Mahnomen | Minnesota | 27087 | 441 | 7 |
1067857 | 1067857 | 2021-02-26 | Marshall | Minnesota | 27089 | 774 | 15 |
1067858 | 1067858 | 2021-02-26 | Martin | Minnesota | 27091 | 1877 | 28 |
1067859 | 1067859 | 2021-02-26 | McLeod | Minnesota | 27085 | 3380 | 49 |
1067860 | 1067860 | 2021-02-26 | Meeker | Minnesota | 27093 | 2066 | 34 |
1067861 | 1067861 | 2021-02-26 | Mille Lacs | Minnesota | 27095 | 2266 | 47 |
1067862 | 1067862 | 2021-02-26 | Morrison | Minnesota | 27097 | 3228 | 47 |
1067863 | 1067863 | 2021-02-26 | Mower | Minnesota | 27099 | 4014 | 31 |
1067864 | 1067864 | 2021-02-26 | Murray | Minnesota | 27101 | 942 | 8 |
1067865 | 1067865 | 2021-02-26 | Nicollet | Minnesota | 27103 | 2546 | 41 |
1067866 | 1067866 | 2021-02-26 | Nobles | Minnesota | 27105 | 3863 | 47 |
1067867 | 1067867 | 2021-02-26 | Norman | Minnesota | 27107 | 473 | 8 |
1067868 | 1067868 | 2021-02-26 | Olmsted | Minnesota | 27109 | 11739 | 88 |
1067869 | 1067869 | 2021-02-26 | Otter Tail | Minnesota | 27111 | 4803 | 70 |
1067870 | 1067870 | 2021-02-26 | Pennington | Minnesota | 27113 | 1288 | 16 |
1067871 | 1067871 | 2021-02-26 | Pine | Minnesota | 27115 | 2815 | 16 |
1067872 | 1067872 | 2021-02-26 | Pipestone | Minnesota | 27117 | 1011 | 24 |
1067873 | 1067873 | 2021-02-26 | Polk | Minnesota | 27119 | 3418 | 62 |
1067874 | 1067874 | 2021-02-26 | Pope | Minnesota | 27121 | 799 | 5 |
1067875 | 1067875 | 2021-02-26 | Ramsey | Minnesota | 27123 | 42883 | 798 |
1067876 | 1067876 | 2021-02-26 | Red Lake | Minnesota | 27125 | 360 | 5 |
1067877 | 1067877 | 2021-02-26 | Redwood | Minnesota | 27127 | 1464 | 27 |
1067878 | 1067878 | 2021-02-26 | Renville | Minnesota | 27129 | 1487 | 40 |
1067879 | 1067879 | 2021-02-26 | Rice | Minnesota | 27131 | 6664 | 91 |
1067880 | 1067880 | 2021-02-26 | Rock | Minnesota | 27133 | 1156 | 14 |
1067881 | 1067881 | 2021-02-26 | Roseau | Minnesota | 27135 | 1795 | 17 |
1067882 | 1067882 | 2021-02-26 | Scott | Minnesota | 27139 | 13186 | 107 |
1067883 | 1067883 | 2021-02-26 | Sherburne | Minnesota | 27141 | 8681 | 72 |
1067884 | 1067884 | 2021-02-26 | Sibley | Minnesota | 27143 | 1170 | 10 |
1067885 | 1067885 | 2021-02-26 | St. Louis | Minnesota | 27137 | 14719 | 262 |
1067886 | 1067886 | 2021-02-26 | Stearns | Minnesota | 27145 | 18711 | 200 |
1067887 | 1067887 | 2021-02-26 | Steele | Minnesota | 27147 | 2987 | 11 |
1067888 | 1067888 | 2021-02-26 | Stevens | Minnesota | 27149 | 739 | 8 |
1067889 | 1067889 | 2021-02-26 | Swift | Minnesota | 27151 | 876 | 18 |
1067890 | 1067890 | 2021-02-26 | Todd | Minnesota | 27153 | 2459 | 30 |
1067891 | 1067891 | 2021-02-26 | Traverse | Minnesota | 27155 | 301 | 5 |
1067892 | 1067892 | 2021-02-26 | Unknown | Minnesota | 524 | 68 | |
1067893 | 1067893 | 2021-02-26 | Wabasha | Minnesota | 27157 | 1857 | 3 |
1067894 | 1067894 | 2021-02-26 | Wadena | Minnesota | 27159 | 1297 | 20 |
1067895 | 1067895 | 2021-02-26 | Waseca | Minnesota | 27161 | 2079 | 17 |
1067896 | 1067896 | 2021-02-26 | Washington | Minnesota | 27163 | 21952 | 253 |
1067897 | 1067897 | 2021-02-26 | Watonwan | Minnesota | 27165 | 1163 | 8 |
1067898 | 1067898 | 2021-02-26 | Wilkin | Minnesota | 27167 | 667 | 10 |
1067899 | 1067899 | 2021-02-26 | Winona | Minnesota | 27169 | 4158 | 49 |
1067900 | 1067900 | 2021-02-26 | Wright | Minnesota | 27171 | 12479 | 114 |
1067901 | 1067901 | 2021-02-26 | Yellow Medicine | Minnesota | 27173 | 976 | 17 |
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);