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-11-20 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1934922 | 1934922 | 2021-11-20 | Aitkin | Minnesota | 27001 | 2107 | 47 |
1934923 | 1934923 | 2021-11-20 | Anoka | Minnesota | 27003 | 60691 | 557 |
1934924 | 1934924 | 2021-11-20 | Becker | Minnesota | 27005 | 6056 | 70 |
1934925 | 1934925 | 2021-11-20 | Beltrami | Minnesota | 27007 | 7824 | 92 |
1934926 | 1934926 | 2021-11-20 | Benton | Minnesota | 27009 | 8560 | 122 |
1934927 | 1934927 | 2021-11-20 | Big Stone | Minnesota | 27011 | 918 | 5 |
1934928 | 1934928 | 2021-11-20 | Blue Earth | Minnesota | 27013 | 10943 | 65 |
1934929 | 1934929 | 2021-11-20 | Brown | Minnesota | 27015 | 4549 | 57 |
1934930 | 1934930 | 2021-11-20 | Carlton | Minnesota | 27017 | 5105 | 72 |
1934931 | 1934931 | 2021-11-20 | Carver | Minnesota | 27019 | 15768 | 65 |
1934932 | 1934932 | 2021-11-20 | Cass | Minnesota | 27021 | 4811 | 50 |
1934933 | 1934933 | 2021-11-20 | Chippewa | Minnesota | 27023 | 2116 | 41 |
1934934 | 1934934 | 2021-11-20 | Chisago | Minnesota | 27025 | 9511 | 70 |
1934935 | 1934935 | 2021-11-20 | Clay | Minnesota | 27027 | 11602 | 101 |
1934936 | 1934936 | 2021-11-20 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1934937 | 1934937 | 2021-11-20 | Cook | Minnesota | 27031 | 292 | 0 |
1934938 | 1934938 | 2021-11-20 | Cottonwood | Minnesota | 27033 | 2188 | 32 |
1934939 | 1934939 | 2021-11-20 | Crow Wing | Minnesota | 27035 | 10727 | 121 |
1934940 | 1934940 | 2021-11-20 | Dakota | Minnesota | 27037 | 64054 | 561 |
1934941 | 1934941 | 2021-11-20 | Dodge | Minnesota | 27039 | 3356 | 11 |
1934942 | 1934942 | 2021-11-20 | Douglas | Minnesota | 27041 | 7430 | 99 |
1934943 | 1934943 | 2021-11-20 | Faribault | Minnesota | 27043 | 2467 | 31 |
1934944 | 1934944 | 2021-11-20 | Fillmore | Minnesota | 27045 | 2897 | 15 |
1934945 | 1934945 | 2021-11-20 | Freeborn | Minnesota | 27047 | 5388 | 43 |
1934946 | 1934946 | 2021-11-20 | Goodhue | Minnesota | 27049 | 7535 | 93 |
1934947 | 1934947 | 2021-11-20 | Grant | Minnesota | 27051 | 940 | 9 |
1934948 | 1934948 | 2021-11-20 | Hennepin | Minnesota | 27053 | 170874 | 2000 |
1934949 | 1934949 | 2021-11-20 | Houston | Minnesota | 27055 | 2599 | 17 |
1934950 | 1934950 | 2021-11-20 | Hubbard | Minnesota | 27057 | 3392 | 48 |
1934951 | 1934951 | 2021-11-20 | Isanti | Minnesota | 27059 | 6601 | 81 |
1934952 | 1934952 | 2021-11-20 | Itasca | Minnesota | 27061 | 7315 | 93 |
1934953 | 1934953 | 2021-11-20 | Jackson | Minnesota | 27063 | 1575 | 16 |
1934954 | 1934954 | 2021-11-20 | Kanabec | Minnesota | 27065 | 2326 | 34 |
1934955 | 1934955 | 2021-11-20 | Kandiyohi | Minnesota | 27067 | 9482 | 104 |
1934956 | 1934956 | 2021-11-20 | Kittson | Minnesota | 27069 | 692 | 22 |
1934957 | 1934957 | 2021-11-20 | Koochiching | Minnesota | 27071 | 1597 | 22 |
1934958 | 1934958 | 2021-11-20 | Lac qui Parle | Minnesota | 27073 | 1167 | 25 |
1934959 | 1934959 | 2021-11-20 | Lake | Minnesota | 27075 | 1259 | 24 |
1934960 | 1934960 | 2021-11-20 | Lake of the Woods | Minnesota | 27077 | 519 | 5 |
1934961 | 1934961 | 2021-11-20 | Le Sueur | Minnesota | 27079 | 4340 | 33 |
1934962 | 1934962 | 2021-11-20 | Lincoln | Minnesota | 27081 | 857 | 5 |
1934963 | 1934963 | 2021-11-20 | Lyon | Minnesota | 27083 | 5083 | 61 |
1934964 | 1934964 | 2021-11-20 | Mahnomen | Minnesota | 27087 | 1035 | 13 |
1934965 | 1934965 | 2021-11-20 | Marshall | Minnesota | 27089 | 1483 | 21 |
1934966 | 1934966 | 2021-11-20 | Martin | Minnesota | 27091 | 3705 | 43 |
1934967 | 1934967 | 2021-11-20 | McLeod | Minnesota | 27085 | 6794 | 82 |
1934968 | 1934968 | 2021-11-20 | Meeker | Minnesota | 27093 | 4131 | 57 |
1934969 | 1934969 | 2021-11-20 | Mille Lacs | Minnesota | 27095 | 4977 | 69 |
1934970 | 1934970 | 2021-11-20 | Morrison | Minnesota | 27097 | 6489 | 77 |
1934971 | 1934971 | 2021-11-20 | Mower | Minnesota | 27099 | 7110 | 46 |
1934972 | 1934972 | 2021-11-20 | Murray | Minnesota | 27101 | 1490 | 11 |
1934973 | 1934973 | 2021-11-20 | Nicollet | Minnesota | 27103 | 4948 | 57 |
1934974 | 1934974 | 2021-11-20 | Nobles | Minnesota | 27105 | 5179 | 54 |
1934975 | 1934975 | 2021-11-20 | Norman | Minnesota | 27107 | 1015 | 9 |
1934976 | 1934976 | 2021-11-20 | Olmsted | Minnesota | 27109 | 21013 | 126 |
1934977 | 1934977 | 2021-11-20 | Otter Tail | Minnesota | 27111 | 9403 | 119 |
1934978 | 1934978 | 2021-11-20 | Pennington | Minnesota | 27113 | 2394 | 29 |
1934979 | 1934979 | 2021-11-20 | Pine | Minnesota | 27115 | 4880 | 40 |
1934980 | 1934980 | 2021-11-20 | Pipestone | Minnesota | 27117 | 1465 | 29 |
1934981 | 1934981 | 2021-11-20 | Polk | Minnesota | 27119 | 5775 | 84 |
1934982 | 1934982 | 2021-11-20 | Pope | Minnesota | 27121 | 1962 | 10 |
1934983 | 1934983 | 2021-11-20 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1934984 | 1934984 | 2021-11-20 | Red Lake | Minnesota | 27125 | 689 | 10 |
1934985 | 1934985 | 2021-11-20 | Redwood | Minnesota | 27127 | 2715 | 45 |
1934986 | 1934986 | 2021-11-20 | Renville | Minnesota | 27129 | 2595 | 51 |
1934987 | 1934987 | 2021-11-20 | Rice | Minnesota | 27131 | 10943 | 137 |
1934988 | 1934988 | 2021-11-20 | Rock | Minnesota | 27133 | 1724 | 28 |
1934989 | 1934989 | 2021-11-20 | Roseau | Minnesota | 27135 | 3035 | 31 |
1934990 | 1934990 | 2021-11-20 | Scott | Minnesota | 27139 | 24533 | 175 |
1934991 | 1934991 | 2021-11-20 | Sherburne | Minnesota | 27141 | 17869 | 120 |
1934992 | 1934992 | 2021-11-20 | Sibley | Minnesota | 27143 | 2395 | 17 |
1934993 | 1934993 | 2021-11-20 | St. Louis | Minnesota | 27137 | 27673 | 384 |
1934994 | 1934994 | 2021-11-20 | Stearns | Minnesota | 27145 | 31982 | 270 |
1934995 | 1934995 | 2021-11-20 | Steele | Minnesota | 27147 | 6524 | 30 |
1934996 | 1934996 | 2021-11-20 | Stevens | Minnesota | 27149 | 1603 | 11 |
1934997 | 1934997 | 2021-11-20 | Swift | Minnesota | 27151 | 1635 | 21 |
1934998 | 1934998 | 2021-11-20 | Todd | Minnesota | 27153 | 4723 | 40 |
1934999 | 1934999 | 2021-11-20 | Traverse | Minnesota | 27155 | 593 | 6 |
1935000 | 1935000 | 2021-11-20 | Unknown | Minnesota | 670 | 124 | |
1935001 | 1935001 | 2021-11-20 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1935002 | 1935002 | 2021-11-20 | Wadena | Minnesota | 27159 | 2923 | 37 |
1935003 | 1935003 | 2021-11-20 | Waseca | Minnesota | 27161 | 3575 | 32 |
1935004 | 1935004 | 2021-11-20 | Washington | Minnesota | 27163 | 38160 | 348 |
1935005 | 1935005 | 2021-11-20 | Watonwan | Minnesota | 27165 | 1916 | 20 |
1935006 | 1935006 | 2021-11-20 | Wilkin | Minnesota | 27167 | 1167 | 15 |
1935007 | 1935007 | 2021-11-20 | Winona | Minnesota | 27169 | 6878 | 56 |
1935008 | 1935008 | 2021-11-20 | Wright | Minnesota | 27171 | 24642 | 197 |
1935009 | 1935009 | 2021-11-20 | Yellow Medicine | Minnesota | 27173 | 1804 | 21 |
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);