ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

49,403 rows where state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Minnesota · 49,403 ✖
Link rowid date ▲ county state fips cases deaths
1817942 1817942 2021-10-15 Aitkin Minnesota 27001 1784 42
1817943 1817943 2021-10-15 Anoka Minnesota 27003 53010 513
1817944 1817944 2021-10-15 Becker Minnesota 27005 5187 62
1817945 1817945 2021-10-15 Beltrami Minnesota 27007 6332 76
1817946 1817946 2021-10-15 Benton Minnesota 27009 7363 108
1817947 1817947 2021-10-15 Big Stone Minnesota 27011 787 4
1817948 1817948 2021-10-15 Blue Earth Minnesota 27013 9495 59
1817949 1817949 2021-10-15 Brown Minnesota 27015 3988 46
1817950 1817950 2021-10-15 Carlton Minnesota 27017 4386 66
1817951 1817951 2021-10-15 Carver Minnesota 27019 13369 54
1817952 1817952 2021-10-15 Cass Minnesota 27021 4131 42
1817953 1817953 2021-10-15 Chippewa Minnesota 27023 1858 39
1817954 1817954 2021-10-15 Chisago Minnesota 27025 8166 62
1817955 1817955 2021-10-15 Clay Minnesota 27027 10065 98
1817956 1817956 2021-10-15 Clearwater Minnesota 27029 1333 18
1817957 1817957 2021-10-15 Cook Minnesota 27031 242 0
1817958 1817958 2021-10-15 Cottonwood Minnesota 27033 1930 27
1817959 1817959 2021-10-15 Crow Wing Minnesota 27035 9254 105
1817960 1817960 2021-10-15 Dakota Minnesota 27037 56158 520
1817961 1817961 2021-10-15 Dodge Minnesota 27039 2681 9
1817962 1817962 2021-10-15 Douglas Minnesota 27041 6161 89
1817963 1817963 2021-10-15 Faribault Minnesota 27043 2146 30
1817964 1817964 2021-10-15 Fillmore Minnesota 27045 2363 12
1817965 1817965 2021-10-15 Freeborn Minnesota 27047 4808 42
1817966 1817966 2021-10-15 Goodhue Minnesota 27049 6036 83
1817967 1817967 2021-10-15 Grant Minnesota 27051 766 9
1817968 1817968 2021-10-15 Hennepin Minnesota 27053 151329 1905
1817969 1817969 2021-10-15 Houston Minnesota 27055 2290 17
1817970 1817970 2021-10-15 Hubbard Minnesota 27057 2836 44
1817971 1817971 2021-10-15 Isanti Minnesota 27059 5581 72
1817972 1817972 2021-10-15 Itasca Minnesota 27061 5969 78
1817973 1817973 2021-10-15 Jackson Minnesota 27063 1441 14
1817974 1817974 2021-10-15 Kanabec Minnesota 27065 1871 30
1817975 1817975 2021-10-15 Kandiyohi Minnesota 27067 8191 95
1817976 1817976 2021-10-15 Kittson Minnesota 27069 595 22
1817977 1817977 2021-10-15 Koochiching Minnesota 27071 1372 19
1817978 1817978 2021-10-15 Lac qui Parle Minnesota 27073 950 24
1817979 1817979 2021-10-15 Lake Minnesota 27075 1062 21
1817980 1817980 2021-10-15 Lake of the Woods Minnesota 27077 452 4
1817981 1817981 2021-10-15 Le Sueur Minnesota 27079 3783 31
1817982 1817982 2021-10-15 Lincoln Minnesota 27081 752 5
1817983 1817983 2021-10-15 Lyon Minnesota 27083 4444 56
1817984 1817984 2021-10-15 Mahnomen Minnesota 27087 863 12
1817985 1817985 2021-10-15 Marshall Minnesota 27089 1314 19
1817986 1817986 2021-10-15 Martin Minnesota 27091 3165 34
1817987 1817987 2021-10-15 McLeod Minnesota 27085 5808 68
1817988 1817988 2021-10-15 Meeker Minnesota 27093 3504 52
1817989 1817989 2021-10-15 Mille Lacs Minnesota 27095 4035 65
1817990 1817990 2021-10-15 Morrison Minnesota 27097 5415 65
1817991 1817991 2021-10-15 Mower Minnesota 27099 6317 40
1817992 1817992 2021-10-15 Murray Minnesota 27101 1313 10
1817993 1817993 2021-10-15 Nicollet Minnesota 27103 4230 51
1817994 1817994 2021-10-15 Nobles Minnesota 27105 4770 52
1817995 1817995 2021-10-15 Norman Minnesota 27107 845 9
1817996 1817996 2021-10-15 Olmsted Minnesota 27109 17821 118
1817997 1817997 2021-10-15 Otter Tail Minnesota 27111 7807 104
1817998 1817998 2021-10-15 Pennington Minnesota 27113 2132 27
1817999 1817999 2021-10-15 Pine Minnesota 27115 4199 30
1818000 1818000 2021-10-15 Pipestone Minnesota 27117 1316 27
1818001 1818001 2021-10-15 Polk Minnesota 27119 5025 77
1818002 1818002 2021-10-15 Pope Minnesota 27121 1532 8
1818003 1818003 2021-10-15 Ramsey Minnesota 27123 62614 972
1818004 1818004 2021-10-15 Red Lake Minnesota 27125 576 9
1818005 1818005 2021-10-15 Redwood Minnesota 27127 2341 43
1818006 1818006 2021-10-15 Renville Minnesota 27129 2242 49
1818007 1818007 2021-10-15 Rice Minnesota 27131 9855 131
1818008 1818008 2021-10-15 Rock Minnesota 27133 1532 19
1818009 1818009 2021-10-15 Roseau Minnesota 27135 2589 24
1818010 1818010 2021-10-15 Scott Minnesota 27139 21316 159
1818011 1818011 2021-10-15 Sherburne Minnesota 27141 15232 111
1818012 1818012 2021-10-15 Sibley Minnesota 27143 2045 12
1818013 1818013 2021-10-15 St. Louis Minnesota 27137 23178 352
1818014 1818014 2021-10-15 Stearns Minnesota 27145 27922 252
1818015 1818015 2021-10-15 Steele Minnesota 27147 5724 25
1818016 1818016 2021-10-15 Stevens Minnesota 27149 1223 11
1818017 1818017 2021-10-15 Swift Minnesota 27151 1326 19
1818018 1818018 2021-10-15 Todd Minnesota 27153 3893 36
1818019 1818019 2021-10-15 Traverse Minnesota 27155 500 5
1818020 1818020 2021-10-15 Unknown Minnesota   652 124
1818021 1818021 2021-10-15 Wabasha Minnesota 27157 2849 5
1818022 1818022 2021-10-15 Wadena Minnesota 27159 2302 29
1818023 1818023 2021-10-15 Waseca Minnesota 27161 3226 29
1818024 1818024 2021-10-15 Washington Minnesota 27163 33145 327
1818025 1818025 2021-10-15 Watonwan Minnesota 27165 1687 11
1818026 1818026 2021-10-15 Wilkin Minnesota 27167 1002 14
1818027 1818027 2021-10-15 Winona Minnesota 27169 6036 53
1818028 1818028 2021-10-15 Wright Minnesota 27171 20879 170
1818029 1818029 2021-10-15 Yellow Medicine Minnesota 27173 1511 20
1814693 1814693 2021-10-14 Aitkin Minnesota 27001 1766 42
1814694 1814694 2021-10-14 Anoka Minnesota 27003 52797 511
1814695 1814695 2021-10-14 Becker Minnesota 27005 5153 62
1814696 1814696 2021-10-14 Beltrami Minnesota 27007 6269 76
1814697 1814697 2021-10-14 Benton Minnesota 27009 7332 105
1814698 1814698 2021-10-14 Big Stone Minnesota 27011 783 4
1814699 1814699 2021-10-14 Blue Earth Minnesota 27013 9463 59
1814700 1814700 2021-10-14 Brown Minnesota 27015 3957 45
1814701 1814701 2021-10-14 Carlton Minnesota 27017 4356 65
1814702 1814702 2021-10-14 Carver Minnesota 27019 13318 54
1814703 1814703 2021-10-14 Cass Minnesota 27021 4082 42
1814704 1814704 2021-10-14 Chippewa Minnesota 27023 1837 39

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);