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

67,883 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 >30

county >30

state 1

  • Minnesota · 67,883 ✖
Link rowid date ▲ county state fips cases deaths
2500905 2500905 2022-05-13 Aitkin Minnesota 27001 3049 62
2500906 2500906 2022-05-13 Anoka Minnesota 27003 100743 797
2500907 2500907 2022-05-13 Becker Minnesota 27005 8934 93
2500908 2500908 2022-05-13 Beltrami Minnesota 27007 12179 128
2500909 2500909 2022-05-13 Benton Minnesota 27009 14298 174
2500910 2500910 2022-05-13 Big Stone Minnesota 27011 1425 9
2500911 2500911 2022-05-13 Blue Earth Minnesota 27013 18332 101
2500912 2500912 2022-05-13 Brown Minnesota 27015 6624 81
2500913 2500913 2022-05-13 Carlton Minnesota 27017 9257 97
2500914 2500914 2022-05-13 Carver Minnesota 27019 27480 117
2500915 2500915 2022-05-13 Cass Minnesota 27021 7123 81
2500916 2500916 2022-05-13 Chippewa Minnesota 27023 3128 48
2500917 2500917 2022-05-13 Chisago Minnesota 27025 14845 120
2500918 2500918 2022-05-13 Clay Minnesota 27027 20161 124
2500919 2500919 2022-05-13 Clearwater Minnesota 27029 2175 30
2500920 2500920 2022-05-13 Cook Minnesota 27031 594 4
2500921 2500921 2022-05-13 Cottonwood Minnesota 27033 3253 41
2500922 2500922 2022-05-13 Crow Wing Minnesota 27035 16266 170
2500923 2500923 2022-05-13 Dakota Minnesota 27037 113641 775
2500924 2500924 2022-05-13 Dodge Minnesota 27039 5888 21
2500925 2500925 2022-05-13 Douglas Minnesota 27041 11106 117
2500926 2500926 2022-05-13 Faribault Minnesota 27043 3843 52
2500927 2500927 2022-05-13 Fillmore Minnesota 27045 4921 24
2500928 2500928 2022-05-13 Freeborn Minnesota 27047 9250 75
2500929 2500929 2022-05-13 Goodhue Minnesota 27049 13600 136
2500930 2500930 2022-05-13 Grant Minnesota 27051 1506 12
2500931 2500931 2022-05-13 Hennepin Minnesota 27053 312909 2593
2500932 2500932 2022-05-13 Houston Minnesota 27055 4660 19
2500933 2500933 2022-05-13 Hubbard Minnesota 27057 5010 59
2500934 2500934 2022-05-13 Isanti Minnesota 27059 10263 117
2500935 2500935 2022-05-13 Itasca Minnesota 27061 11229 146
2500936 2500936 2022-05-13 Jackson Minnesota 27063 2167 17
2500937 2500937 2022-05-13 Kanabec Minnesota 27065 3575 57
2500938 2500938 2022-05-13 Kandiyohi Minnesota 27067 13649 139
2500939 2500939 2022-05-13 Kittson Minnesota 27069 1051 27
2500940 2500940 2022-05-13 Koochiching Minnesota 27071 2796 37
2500941 2500941 2022-05-13 Lac qui Parle Minnesota 27073 1764 29
2500942 2500942 2022-05-13 Lake Minnesota 27075 2138 28
2500943 2500943 2022-05-13 Lake of the Woods Minnesota 27077 779 6
2500944 2500944 2022-05-13 Le Sueur Minnesota 27079 6586 51
2500945 2500945 2022-05-13 Lincoln Minnesota 27081 1220 6
2500946 2500946 2022-05-13 Lyon Minnesota 27083 7131 73
2500947 2500947 2022-05-13 Mahnomen Minnesota 27087 1803 18
2500948 2500948 2022-05-13 Marshall Minnesota 27089 2122 23
2500949 2500949 2022-05-13 Martin Minnesota 27091 5685 65
2500950 2500950 2022-05-13 McLeod Minnesota 27085 10753 108
2500951 2500951 2022-05-13 Meeker Minnesota 27093 5998 75
2500952 2500952 2022-05-13 Mille Lacs Minnesota 27095 7356 114
2500953 2500953 2022-05-13 Morrison Minnesota 27097 9262 105
2500954 2500954 2022-05-13 Mower Minnesota 27099 12083 74
2500955 2500955 2022-05-13 Murray Minnesota 27101 2043 16
2500956 2500956 2022-05-13 Nicollet Minnesota 27103 8305 66
2500957 2500957 2022-05-13 Nobles Minnesota 27105 6980 60
2500958 2500958 2022-05-13 Norman Minnesota 27107 1535 14
2500959 2500959 2022-05-13 Olmsted Minnesota 27109 43593 185
2500960 2500960 2022-05-13 Otter Tail Minnesota 27111 13763 167
2500961 2500961 2022-05-13 Pennington Minnesota 27113 3687 41
2500962 2500962 2022-05-13 Pine Minnesota 27115 7175 67
2500963 2500963 2022-05-13 Pipestone Minnesota 27117 2013 34
2500964 2500964 2022-05-13 Polk Minnesota 27119 8950 107
2500965 2500965 2022-05-13 Pope Minnesota 27121 3119 17
2500966 2500966 2022-05-13 Ramsey Minnesota 27123 129009 1348
2500967 2500967 2022-05-13 Red Lake Minnesota 27125 953 13
2500968 2500968 2022-05-13 Redwood Minnesota 27127 3985 54
2500969 2500969 2022-05-13 Renville Minnesota 27129 3783 56
2500970 2500970 2022-05-13 Rice Minnesota 27131 18357 176
2500971 2500971 2022-05-13 Rock Minnesota 27133 2348 34
2500972 2500972 2022-05-13 Roseau Minnesota 27135 4524 44
2500973 2500973 2022-05-13 Scott Minnesota 27139 41236 261
2500974 2500974 2022-05-13 Sherburne Minnesota 27141 27636 181
2500975 2500975 2022-05-13 Sibley Minnesota 27143 3596 24
2500976 2500976 2022-05-13 St. Louis Minnesota 27137 48555 533
2500977 2500977 2022-05-13 Stearns Minnesota 27145 51693 368
2500978 2500978 2022-05-13 Steele Minnesota 27147 10657 62
2500979 2500979 2022-05-13 Stevens Minnesota 27149 2675 13
2500980 2500980 2022-05-13 Swift Minnesota 27151 2313 33
2500981 2500981 2022-05-13 Todd Minnesota 27153 6898 58
2500982 2500982 2022-05-13 Traverse Minnesota 27155 871 10
2500983 2500983 2022-05-13 Unknown Minnesota   1129 290
2500984 2500984 2022-05-13 Wabasha Minnesota 27157 5795 16
2500985 2500985 2022-05-13 Wadena Minnesota 27159 4261 55
2500986 2500986 2022-05-13 Waseca Minnesota 27161 5587 39
2500987 2500987 2022-05-13 Washington Minnesota 27163 69180 481
2500988 2500988 2022-05-13 Watonwan Minnesota 27165 2990 23
2500989 2500989 2022-05-13 Wilkin Minnesota 27167 1662 22
2500990 2500990 2022-05-13 Winona Minnesota 27169 13109 72
2500991 2500991 2022-05-13 Wright Minnesota 27171 37182 305
2500992 2500992 2022-05-13 Yellow Medicine Minnesota 27173 2580 29
2497647 2497647 2022-05-12 Aitkin Minnesota 27001 3041 62
2497648 2497648 2022-05-12 Anoka Minnesota 27003 100598 796
2497649 2497649 2022-05-12 Becker Minnesota 27005 8927 93
2497650 2497650 2022-05-12 Beltrami Minnesota 27007 12175 128
2497651 2497651 2022-05-12 Benton Minnesota 27009 14284 174
2497652 2497652 2022-05-12 Big Stone Minnesota 27011 1423 9
2497653 2497653 2022-05-12 Blue Earth Minnesota 27013 18315 100
2497654 2497654 2022-05-12 Brown Minnesota 27015 6618 81
2497655 2497655 2022-05-12 Carlton Minnesota 27017 9236 97
2497656 2497656 2022-05-12 Carver Minnesota 27019 27427 117
2497657 2497657 2022-05-12 Cass Minnesota 27021 7116 81
2497658 2497658 2022-05-12 Chippewa Minnesota 27023 3119 48

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