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

25,555 rows where state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Minnesota · 25,555 ✖
Link rowid date ▲ county state fips cases deaths
938070 938070 2021-01-17 Aitkin Minnesota 27001 1076 33
938071 938071 2021-01-17 Anoka Minnesota 27003 30877 363
938072 938072 2021-01-17 Becker Minnesota 27005 2841 39
938073 938073 2021-01-17 Beltrami Minnesota 27007 3094 47
938074 938074 2021-01-17 Benton Minnesota 27009 4186 85
938075 938075 2021-01-17 Big Stone Minnesota 27011 455 3
938076 938076 2021-01-17 Blue Earth Minnesota 27013 5389 33
938077 938077 2021-01-17 Brown Minnesota 27015 2145 34
938078 938078 2021-01-17 Carlton Minnesota 27017 2785 43
938079 938079 2021-01-17 Carver Minnesota 27019 6924 36
938080 938080 2021-01-17 Cass Minnesota 27021 2073 23
938081 938081 2021-01-17 Chippewa Minnesota 27023 1309 32
938082 938082 2021-01-17 Chisago Minnesota 27025 4508 32
938083 938083 2021-01-17 Clay Minnesota 27027 6502 80
938084 938084 2021-01-17 Clearwater Minnesota 27029 685 14
938085 938085 2021-01-17 Cook Minnesota 27031 114 0
938086 938086 2021-01-17 Cottonwood Minnesota 27033 1268 18
938087 938087 2021-01-17 Crow Wing Minnesota 27035 4813 74
938088 938088 2021-01-17 Dakota Minnesota 27037 32876 338
938089 938089 2021-01-17 Dodge Minnesota 27039 1338 4
938090 938090 2021-01-17 Douglas Minnesota 27041 3734 66
938091 938091 2021-01-17 Faribault Minnesota 27043 1046 16
938092 938092 2021-01-17 Fillmore Minnesota 27045 1224 5
938093 938093 2021-01-17 Freeborn Minnesota 27047 2434 20
938094 938094 2021-01-17 Goodhue Minnesota 27049 3453 58
938095 938095 2021-01-17 Grant Minnesota 27051 429 8
938096 938096 2021-01-17 Hennepin Minnesota 27053 92747 1474
938097 938097 2021-01-17 Houston Minnesota 27055 1356 13
938098 938098 2021-01-17 Hubbard Minnesota 27057 1492 38
938099 938099 2021-01-17 Isanti Minnesota 27059 2816 41
938100 938100 2021-01-17 Itasca Minnesota 27061 2840 43
938101 938101 2021-01-17 Jackson Minnesota 27063 852 10
938102 938102 2021-01-17 Kanabec Minnesota 27065 974 18
938103 938103 2021-01-17 Kandiyohi Minnesota 27067 5534 71
938104 938104 2021-01-17 Kittson Minnesota 27069 372 19
938105 938105 2021-01-17 Koochiching Minnesota 27071 593 10
938106 938106 2021-01-17 Lac qui Parle Minnesota 27073 657 16
938107 938107 2021-01-17 Lake Minnesota 27075 632 15
938108 938108 2021-01-17 Lake of the Woods Minnesota 27077 190 1
938109 938109 2021-01-17 Le Sueur Minnesota 27079 2088 15
938110 938110 2021-01-17 Lincoln Minnesota 27081 482 1
938111 938111 2021-01-17 Lyon Minnesota 27083 3006 36
938112 938112 2021-01-17 Mahnomen Minnesota 27087 410 7
938113 938113 2021-01-17 Marshall Minnesota 27089 703 15
938114 938114 2021-01-17 Martin Minnesota 27091 1693 26
938115 938115 2021-01-17 McLeod Minnesota 27085 3242 45
938116 938116 2021-01-17 Meeker Minnesota 27093 1992 33
938117 938117 2021-01-17 Mille Lacs Minnesota 27095 2136 46
938118 938118 2021-01-17 Morrison Minnesota 27097 3111 44
938119 938119 2021-01-17 Mower Minnesota 27099 3633 29
938120 938120 2021-01-17 Murray Minnesota 27101 878 5
938121 938121 2021-01-17 Nicollet Minnesota 27103 2238 36
938122 938122 2021-01-17 Nobles Minnesota 27105 3687 46
938123 938123 2021-01-17 Norman Minnesota 27107 423 8
938124 938124 2021-01-17 Olmsted Minnesota 27109 10413 75
938125 938125 2021-01-17 Otter Tail Minnesota 27111 4544 66
938126 938126 2021-01-17 Pennington Minnesota 27113 988 15
938127 938127 2021-01-17 Pine Minnesota 27115 2660 13
938128 938128 2021-01-17 Pipestone Minnesota 27117 939 23
938129 938129 2021-01-17 Polk Minnesota 27119 3279 56
938130 938130 2021-01-17 Pope Minnesota 27121 737 5
938131 938131 2021-01-17 Ramsey Minnesota 27123 39820 736
938132 938132 2021-01-17 Red Lake Minnesota 27125 316 4
938133 938133 2021-01-17 Redwood Minnesota 27127 1395 27
938134 938134 2021-01-17 Renville Minnesota 27129 1371 39
938135 938135 2021-01-17 Rice Minnesota 27131 6041 68
938136 938136 2021-01-17 Rock Minnesota 27133 1097 12
938137 938137 2021-01-17 Roseau Minnesota 27135 1654 16
938138 938138 2021-01-17 Scott Minnesota 27139 11917 96
938139 938139 2021-01-17 Sherburne Minnesota 27141 8189 65
938140 938140 2021-01-17 Sibley Minnesota 27143 1083 7
938141 938141 2021-01-17 St. Louis Minnesota 27137 13609 241
938142 938142 2021-01-17 Stearns Minnesota 27145 17813 187
938143 938143 2021-01-17 Steele Minnesota 27147 2722 9
938144 938144 2021-01-17 Stevens Minnesota 27149 697 8
938145 938145 2021-01-17 Swift Minnesota 27151 831 18
938146 938146 2021-01-17 Todd Minnesota 27153 2316 30
938147 938147 2021-01-17 Traverse Minnesota 27155 250 3
938148 938148 2021-01-17 Unknown Minnesota   504 68
938149 938149 2021-01-17 Wabasha Minnesota 27157 1695 3
938150 938150 2021-01-17 Wadena Minnesota 27159 1196 16
938151 938151 2021-01-17 Waseca Minnesota 27161 1889 16
938152 938152 2021-01-17 Washington Minnesota 27163 20066 227
938153 938153 2021-01-17 Watonwan Minnesota 27165 1063 8
938154 938154 2021-01-17 Wilkin Minnesota 27167 622 9
938155 938155 2021-01-17 Winona Minnesota 27169 3872 46
938156 938156 2021-01-17 Wright Minnesota 27171 11570 104
938157 938157 2021-01-17 Yellow Medicine Minnesota 27173 935 14
934825 934825 2021-01-16 Aitkin Minnesota 27001 1071 33
934826 934826 2021-01-16 Anoka Minnesota 27003 30811 360
934827 934827 2021-01-16 Becker Minnesota 27005 2817 38
934828 934828 2021-01-16 Beltrami Minnesota 27007 3087 46
934829 934829 2021-01-16 Benton Minnesota 27009 4167 85
934830 934830 2021-01-16 Big Stone Minnesota 27011 454 3
934831 934831 2021-01-16 Blue Earth Minnesota 27013 5380 33
934832 934832 2021-01-16 Brown Minnesota 27015 2137 34
934833 934833 2021-01-16 Carlton Minnesota 27017 2781 43
934834 934834 2021-01-16 Carver Minnesota 27019 6914 36
934835 934835 2021-01-16 Cass Minnesota 27021 2061 23
934836 934836 2021-01-16 Chippewa Minnesota 27023 1308 32

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