ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,072 rows where deaths = 1 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lake of the Woods 203
- Chisago 184
- Mahnomen 170
- Swift 145
- Kandiyohi 136
- Chippewa 130
- Morrison 107
- Jackson 101
- Pennington 101
- Le Sueur 97
- Kanabec 85
- Stevens 82
- Lincoln 77
- Aitkin 75
- Carlton 72
- Mille Lacs 72
- Fillmore 63
- Marshall 63
- Freeborn 59
- Cook 56
- Otter Tail 51
- Wright 50
- Scott 47
- Meeker 45
- Douglas 42
- Wabasha 40
- Murray 39
- Steele 38
- Brown 34
- Crow Wing 32
- …
state 1
- Minnesota · 3,072 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2149508 | 2149508 | 2022-01-25 | Cook | Minnesota | 27031 | 469 | 1 |
2146256 | 2146256 | 2022-01-24 | Cook | Minnesota | 27031 | 456 | 1 |
2143001 | 2143001 | 2022-01-23 | Cook | Minnesota | 27031 | 454 | 1 |
2139746 | 2139746 | 2022-01-22 | Cook | Minnesota | 27031 | 454 | 1 |
2136490 | 2136490 | 2022-01-21 | Cook | Minnesota | 27031 | 454 | 1 |
2133238 | 2133238 | 2022-01-20 | Cook | Minnesota | 27031 | 451 | 1 |
2129985 | 2129985 | 2022-01-19 | Cook | Minnesota | 27031 | 447 | 1 |
2126731 | 2126731 | 2022-01-18 | Cook | Minnesota | 27031 | 425 | 1 |
2123479 | 2123479 | 2022-01-17 | Cook | Minnesota | 27031 | 421 | 1 |
2120227 | 2120227 | 2022-01-16 | Cook | Minnesota | 27031 | 421 | 1 |
2116975 | 2116975 | 2022-01-15 | Cook | Minnesota | 27031 | 421 | 1 |
2113724 | 2113724 | 2022-01-14 | Cook | Minnesota | 27031 | 421 | 1 |
2110472 | 2110472 | 2022-01-13 | Cook | Minnesota | 27031 | 414 | 1 |
2107221 | 2107221 | 2022-01-12 | Cook | Minnesota | 27031 | 410 | 1 |
2103970 | 2103970 | 2022-01-11 | Cook | Minnesota | 27031 | 407 | 1 |
2100719 | 2100719 | 2022-01-10 | Cook | Minnesota | 27031 | 385 | 1 |
2097468 | 2097468 | 2022-01-09 | Cook | Minnesota | 27031 | 378 | 1 |
2094216 | 2094216 | 2022-01-08 | Cook | Minnesota | 27031 | 378 | 1 |
2090964 | 2090964 | 2022-01-07 | Cook | Minnesota | 27031 | 378 | 1 |
2087713 | 2087713 | 2022-01-06 | Cook | Minnesota | 27031 | 374 | 1 |
2084461 | 2084461 | 2022-01-05 | Cook | Minnesota | 27031 | 373 | 1 |
2081209 | 2081209 | 2022-01-04 | Cook | Minnesota | 27031 | 369 | 1 |
2077957 | 2077957 | 2022-01-03 | Cook | Minnesota | 27031 | 364 | 1 |
2074706 | 2074706 | 2022-01-02 | Cook | Minnesota | 27031 | 356 | 1 |
2071455 | 2071455 | 2022-01-01 | Cook | Minnesota | 27031 | 356 | 1 |
2068204 | 2068204 | 2021-12-31 | Cook | Minnesota | 27031 | 356 | 1 |
2064953 | 2064953 | 2021-12-30 | Cook | Minnesota | 27031 | 356 | 1 |
2061703 | 2061703 | 2021-12-29 | Cook | Minnesota | 27031 | 353 | 1 |
2058454 | 2058454 | 2021-12-28 | Cook | Minnesota | 27031 | 350 | 1 |
2055205 | 2055205 | 2021-12-27 | Cook | Minnesota | 27031 | 345 | 1 |
2051955 | 2051955 | 2021-12-26 | Cook | Minnesota | 27031 | 343 | 1 |
2048705 | 2048705 | 2021-12-25 | Cook | Minnesota | 27031 | 343 | 1 |
2045455 | 2045455 | 2021-12-24 | Cook | Minnesota | 27031 | 343 | 1 |
2042205 | 2042205 | 2021-12-23 | Cook | Minnesota | 27031 | 343 | 1 |
2038956 | 2038956 | 2021-12-22 | Cook | Minnesota | 27031 | 339 | 1 |
2035706 | 2035706 | 2021-12-21 | Cook | Minnesota | 27031 | 338 | 1 |
2032456 | 2032456 | 2021-12-20 | Cook | Minnesota | 27031 | 335 | 1 |
2029205 | 2029205 | 2021-12-19 | Cook | Minnesota | 27031 | 333 | 1 |
2025954 | 2025954 | 2021-12-18 | Cook | Minnesota | 27031 | 333 | 1 |
2022703 | 2022703 | 2021-12-17 | Cook | Minnesota | 27031 | 333 | 1 |
2019452 | 2019452 | 2021-12-16 | Cook | Minnesota | 27031 | 332 | 1 |
2016202 | 2016202 | 2021-12-15 | Cook | Minnesota | 27031 | 329 | 1 |
2012951 | 2012951 | 2021-12-14 | Cook | Minnesota | 27031 | 328 | 1 |
2009700 | 2009700 | 2021-12-13 | Cook | Minnesota | 27031 | 325 | 1 |
2006449 | 2006449 | 2021-12-12 | Cook | Minnesota | 27031 | 324 | 1 |
2003198 | 2003198 | 2021-12-11 | Cook | Minnesota | 27031 | 324 | 1 |
1999948 | 1999948 | 2021-12-10 | Cook | Minnesota | 27031 | 324 | 1 |
1996697 | 1996697 | 2021-12-09 | Cook | Minnesota | 27031 | 322 | 1 |
1993446 | 1993446 | 2021-12-08 | Cook | Minnesota | 27031 | 321 | 1 |
1990195 | 1990195 | 2021-12-07 | Cook | Minnesota | 27031 | 319 | 1 |
1986945 | 1986945 | 2021-12-06 | Cook | Minnesota | 27031 | 315 | 1 |
1983695 | 1983695 | 2021-12-05 | Cook | Minnesota | 27031 | 314 | 1 |
1980445 | 1980445 | 2021-12-04 | Cook | Minnesota | 27031 | 314 | 1 |
1977195 | 1977195 | 2021-12-03 | Cook | Minnesota | 27031 | 314 | 1 |
1973945 | 1973945 | 2021-12-02 | Cook | Minnesota | 27031 | 313 | 1 |
1970696 | 1970696 | 2021-12-01 | Cook | Minnesota | 27031 | 307 | 1 |
1152256 | 1152256 | 2021-03-24 | Lake of the Woods | Minnesota | 27077 | 245 | 1 |
1149009 | 1149009 | 2021-03-23 | Lake of the Woods | Minnesota | 27077 | 245 | 1 |
1145762 | 1145762 | 2021-03-22 | Lake of the Woods | Minnesota | 27077 | 245 | 1 |
1142515 | 1142515 | 2021-03-21 | Lake of the Woods | Minnesota | 27077 | 244 | 1 |
1139268 | 1139268 | 2021-03-20 | Lake of the Woods | Minnesota | 27077 | 243 | 1 |
1136022 | 1136022 | 2021-03-19 | Lake of the Woods | Minnesota | 27077 | 243 | 1 |
1132776 | 1132776 | 2021-03-18 | Lake of the Woods | Minnesota | 27077 | 241 | 1 |
1129528 | 1129528 | 2021-03-17 | Lake of the Woods | Minnesota | 27077 | 237 | 1 |
1126281 | 1126281 | 2021-03-16 | Lake of the Woods | Minnesota | 27077 | 233 | 1 |
1123035 | 1123035 | 2021-03-15 | Lake of the Woods | Minnesota | 27077 | 229 | 1 |
1119788 | 1119788 | 2021-03-14 | Lake of the Woods | Minnesota | 27077 | 227 | 1 |
1116541 | 1116541 | 2021-03-13 | Lake of the Woods | Minnesota | 27077 | 227 | 1 |
1113295 | 1113295 | 2021-03-12 | Lake of the Woods | Minnesota | 27077 | 227 | 1 |
1110049 | 1110049 | 2021-03-11 | Lake of the Woods | Minnesota | 27077 | 227 | 1 |
1106803 | 1106803 | 2021-03-10 | Lake of the Woods | Minnesota | 27077 | 226 | 1 |
1103557 | 1103557 | 2021-03-09 | Lake of the Woods | Minnesota | 27077 | 226 | 1 |
1100311 | 1100311 | 2021-03-08 | Lake of the Woods | Minnesota | 27077 | 225 | 1 |
1097064 | 1097064 | 2021-03-07 | Lake of the Woods | Minnesota | 27077 | 223 | 1 |
1093817 | 1093817 | 2021-03-06 | Lake of the Woods | Minnesota | 27077 | 222 | 1 |
1090571 | 1090571 | 2021-03-05 | Lake of the Woods | Minnesota | 27077 | 222 | 1 |
1087326 | 1087326 | 2021-03-04 | Lake of the Woods | Minnesota | 27077 | 220 | 1 |
1084081 | 1084081 | 2021-03-03 | Lake of the Woods | Minnesota | 27077 | 219 | 1 |
1080835 | 1080835 | 2021-03-02 | Lake of the Woods | Minnesota | 27077 | 219 | 1 |
1077589 | 1077589 | 2021-03-01 | Lake of the Woods | Minnesota | 27077 | 219 | 1 |
1074343 | 1074343 | 2021-02-28 | Lake of the Woods | Minnesota | 27077 | 219 | 1 |
1071097 | 1071097 | 2021-02-27 | Lake of the Woods | Minnesota | 27077 | 216 | 1 |
1067852 | 1067852 | 2021-02-26 | Lake of the Woods | Minnesota | 27077 | 214 | 1 |
1064607 | 1064607 | 2021-02-25 | Lake of the Woods | Minnesota | 27077 | 213 | 1 |
1061363 | 1061363 | 2021-02-24 | Lake of the Woods | Minnesota | 27077 | 213 | 1 |
1058117 | 1058117 | 2021-02-23 | Lake of the Woods | Minnesota | 27077 | 213 | 1 |
1054871 | 1054871 | 2021-02-22 | Lake of the Woods | Minnesota | 27077 | 213 | 1 |
1051624 | 1051624 | 2021-02-21 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1048377 | 1048377 | 2021-02-20 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1045131 | 1045131 | 2021-02-19 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1041886 | 1041886 | 2021-02-18 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1038641 | 1038641 | 2021-02-17 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1035396 | 1035396 | 2021-02-16 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1032151 | 1032151 | 2021-02-15 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1028904 | 1028904 | 2021-02-14 | Lake of the Woods | Minnesota | 27077 | 210 | 1 |
1025658 | 1025658 | 2021-02-13 | Lake of the Woods | Minnesota | 27077 | 210 | 1 |
1022413 | 1022413 | 2021-02-12 | Lake of the Woods | Minnesota | 27077 | 209 | 1 |
1019168 | 1019168 | 2021-02-11 | Lake of the Woods | Minnesota | 27077 | 209 | 1 |
1015923 | 1015923 | 2021-02-10 | Lake of the Woods | Minnesota | 27077 | 209 | 1 |
1012678 | 1012678 | 2021-02-09 | Lake of the Woods | Minnesota | 27077 | 209 | 1 |
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);