ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where deaths = 100 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 18
county 18
- Crow Wing 20
- Blue Earth 16
- Clay 12
- Douglas 8
- McLeod 7
- Sherburne 7
- Dakota 6
- Chisago 5
- Rice 5
- Beltrami 4
- Mille Lacs 4
- Polk 4
- Morrison 3
- Washington 2
- Benton 1
- Carver 1
- Isanti 1
- Otter Tail 1
state 1
- Minnesota · 107 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497653 | 2497653 | 2022-05-12 | Blue Earth | Minnesota | 27013 | 18315 | 100 |
2494395 | 2494395 | 2022-05-11 | Blue Earth | Minnesota | 27013 | 18299 | 100 |
2491137 | 2491137 | 2022-05-10 | Blue Earth | Minnesota | 27013 | 18288 | 100 |
2487880 | 2487880 | 2022-05-09 | Blue Earth | Minnesota | 27013 | 18256 | 100 |
2484622 | 2484622 | 2022-05-08 | Blue Earth | Minnesota | 27013 | 18233 | 100 |
2481364 | 2481364 | 2022-05-07 | Blue Earth | Minnesota | 27013 | 18233 | 100 |
2478106 | 2478106 | 2022-05-06 | Blue Earth | Minnesota | 27013 | 18233 | 100 |
2474848 | 2474848 | 2022-05-05 | Blue Earth | Minnesota | 27013 | 18221 | 100 |
2471591 | 2471591 | 2022-05-04 | Blue Earth | Minnesota | 27013 | 18208 | 100 |
2468335 | 2468335 | 2022-05-03 | Blue Earth | Minnesota | 27013 | 18194 | 100 |
2465080 | 2465080 | 2022-05-02 | Blue Earth | Minnesota | 27013 | 18177 | 100 |
2461824 | 2461824 | 2022-05-01 | Blue Earth | Minnesota | 27013 | 18170 | 100 |
2458568 | 2458568 | 2022-04-30 | Blue Earth | Minnesota | 27013 | 18170 | 100 |
2455312 | 2455312 | 2022-04-29 | Blue Earth | Minnesota | 27013 | 18170 | 100 |
2452056 | 2452056 | 2022-04-28 | Blue Earth | Minnesota | 27013 | 18151 | 100 |
2448800 | 2448800 | 2022-04-27 | Blue Earth | Minnesota | 27013 | 18123 | 100 |
2266622 | 2266622 | 2022-03-02 | Morrison | Minnesota | 27097 | 8978 | 100 |
2263371 | 2263371 | 2022-03-01 | Morrison | Minnesota | 27097 | 8976 | 100 |
2260120 | 2260120 | 2022-02-28 | Morrison | Minnesota | 27097 | 8962 | 100 |
2256880 | 2256880 | 2022-02-27 | Polk | Minnesota | 27119 | 8476 | 100 |
2253629 | 2253629 | 2022-02-26 | Polk | Minnesota | 27119 | 8476 | 100 |
2250378 | 2250378 | 2022-02-25 | Polk | Minnesota | 27119 | 8476 | 100 |
2247127 | 2247127 | 2022-02-24 | Polk | Minnesota | 27119 | 8474 | 100 |
2214603 | 2214603 | 2022-02-14 | McLeod | Minnesota | 27085 | 10196 | 100 |
2211351 | 2211351 | 2022-02-13 | McLeod | Minnesota | 27085 | 10161 | 100 |
2208098 | 2208098 | 2022-02-12 | McLeod | Minnesota | 27085 | 10161 | 100 |
2204845 | 2204845 | 2022-02-11 | McLeod | Minnesota | 27085 | 10161 | 100 |
2201592 | 2201592 | 2022-02-10 | McLeod | Minnesota | 27085 | 10133 | 100 |
2198338 | 2198338 | 2022-02-09 | McLeod | Minnesota | 27085 | 10104 | 100 |
2195084 | 2195084 | 2022-02-08 | McLeod | Minnesota | 27085 | 10034 | 100 |
2175532 | 2175532 | 2022-02-02 | Carver | Minnesota | 27019 | 25016 | 100 |
2123511 | 2123511 | 2022-01-17 | Mille Lacs | Minnesota | 27095 | 6107 | 100 |
2120259 | 2120259 | 2022-01-16 | Mille Lacs | Minnesota | 27095 | 6107 | 100 |
2117007 | 2117007 | 2022-01-15 | Mille Lacs | Minnesota | 27095 | 6107 | 100 |
2113756 | 2113756 | 2022-01-14 | Mille Lacs | Minnesota | 27095 | 6107 | 100 |
2084475 | 2084475 | 2022-01-05 | Isanti | Minnesota | 27059 | 7955 | 100 |
2074703 | 2074703 | 2022-01-02 | Chisago | Minnesota | 27025 | 11021 | 100 |
2071452 | 2071452 | 2022-01-01 | Chisago | Minnesota | 27025 | 11021 | 100 |
2068201 | 2068201 | 2021-12-31 | Chisago | Minnesota | 27025 | 11021 | 100 |
2064950 | 2064950 | 2021-12-30 | Chisago | Minnesota | 27025 | 11021 | 100 |
2061700 | 2061700 | 2021-12-29 | Chisago | Minnesota | 27025 | 10985 | 100 |
1986933 | 1986933 | 2021-12-06 | Beltrami | Minnesota | 27007 | 8283 | 100 |
1983683 | 1983683 | 2021-12-05 | Beltrami | Minnesota | 27007 | 8249 | 100 |
1980433 | 1980433 | 2021-12-04 | Beltrami | Minnesota | 27007 | 8249 | 100 |
1977183 | 1977183 | 2021-12-03 | Beltrami | Minnesota | 27007 | 8249 | 100 |
1967451 | 1967451 | 2021-11-30 | Douglas | Minnesota | 27041 | 7849 | 100 |
1964199 | 1964199 | 2021-11-29 | Douglas | Minnesota | 27041 | 7718 | 100 |
1960948 | 1960948 | 2021-11-28 | Douglas | Minnesota | 27041 | 7689 | 100 |
1957697 | 1957697 | 2021-11-27 | Douglas | Minnesota | 27041 | 7689 | 100 |
1954446 | 1954446 | 2021-11-26 | Douglas | Minnesota | 27041 | 7689 | 100 |
1951195 | 1951195 | 2021-11-25 | Douglas | Minnesota | 27041 | 7642 | 100 |
1947944 | 1947944 | 2021-11-24 | Douglas | Minnesota | 27041 | 7642 | 100 |
1944693 | 1944693 | 2021-11-23 | Douglas | Minnesota | 27041 | 7594 | 100 |
1921935 | 1921935 | 2021-11-16 | Clay | Minnesota | 27027 | 11449 | 100 |
1918685 | 1918685 | 2021-11-15 | Clay | Minnesota | 27027 | 11374 | 100 |
1915435 | 1915435 | 2021-11-14 | Clay | Minnesota | 27027 | 11303 | 100 |
1912185 | 1912185 | 2021-11-13 | Clay | Minnesota | 27027 | 11303 | 100 |
1908935 | 1908935 | 2021-11-12 | Clay | Minnesota | 27027 | 11303 | 100 |
1905686 | 1905686 | 2021-11-11 | Clay | Minnesota | 27027 | 11207 | 100 |
1902437 | 1902437 | 2021-11-10 | Clay | Minnesota | 27027 | 11153 | 100 |
1899187 | 1899187 | 2021-11-09 | Clay | Minnesota | 27027 | 11068 | 100 |
1895937 | 1895937 | 2021-11-08 | Clay | Minnesota | 27027 | 10966 | 100 |
1892687 | 1892687 | 2021-11-07 | Clay | Minnesota | 27027 | 10900 | 100 |
1889437 | 1889437 | 2021-11-06 | Clay | Minnesota | 27027 | 10900 | 100 |
1886187 | 1886187 | 2021-11-05 | Clay | Minnesota | 27027 | 10900 | 100 |
1785507 | 1785507 | 2021-10-05 | Otter Tail | Minnesota | 27111 | 7309 | 100 |
1733535 | 1733535 | 2021-09-19 | Sherburne | Minnesota | 27141 | 13522 | 100 |
1730285 | 1730285 | 2021-09-18 | Sherburne | Minnesota | 27141 | 13522 | 100 |
1727035 | 1727035 | 2021-09-17 | Sherburne | Minnesota | 27141 | 13522 | 100 |
1723721 | 1723721 | 2021-09-16 | Benton | Minnesota | 27009 | 6411 | 100 |
1723786 | 1723786 | 2021-09-16 | Sherburne | Minnesota | 27141 | 13465 | 100 |
1720537 | 1720537 | 2021-09-15 | Sherburne | Minnesota | 27141 | 13375 | 100 |
1717289 | 1717289 | 2021-09-14 | Sherburne | Minnesota | 27141 | 13324 | 100 |
1714041 | 1714041 | 2021-09-13 | Sherburne | Minnesota | 27141 | 13237 | 100 |
1694502 | 1694502 | 2021-09-07 | Crow Wing | Minnesota | 27035 | 7457 | 100 |
1691253 | 1691253 | 2021-09-06 | Crow Wing | Minnesota | 27035 | 7438 | 100 |
1688003 | 1688003 | 2021-09-05 | Crow Wing | Minnesota | 27035 | 7438 | 100 |
1684753 | 1684753 | 2021-09-04 | Crow Wing | Minnesota | 27035 | 7438 | 100 |
1681502 | 1681502 | 2021-09-03 | Crow Wing | Minnesota | 27035 | 7438 | 100 |
1678254 | 1678254 | 2021-09-02 | Crow Wing | Minnesota | 27035 | 7412 | 100 |
1675006 | 1675006 | 2021-09-01 | Crow Wing | Minnesota | 27035 | 7390 | 100 |
1671758 | 1671758 | 2021-08-31 | Crow Wing | Minnesota | 27035 | 7363 | 100 |
1668511 | 1668511 | 2021-08-30 | Crow Wing | Minnesota | 27035 | 7318 | 100 |
1665264 | 1665264 | 2021-08-29 | Crow Wing | Minnesota | 27035 | 7298 | 100 |
1662016 | 1662016 | 2021-08-28 | Crow Wing | Minnesota | 27035 | 7298 | 100 |
1658768 | 1658768 | 2021-08-27 | Crow Wing | Minnesota | 27035 | 7298 | 100 |
1655519 | 1655519 | 2021-08-26 | Crow Wing | Minnesota | 27035 | 7267 | 100 |
1652272 | 1652272 | 2021-08-25 | Crow Wing | Minnesota | 27035 | 7247 | 100 |
1649024 | 1649024 | 2021-08-24 | Crow Wing | Minnesota | 27035 | 7230 | 100 |
1645775 | 1645775 | 2021-08-23 | Crow Wing | Minnesota | 27035 | 7188 | 100 |
1642526 | 1642526 | 2021-08-22 | Crow Wing | Minnesota | 27035 | 7179 | 100 |
1639276 | 1639276 | 2021-08-21 | Crow Wing | Minnesota | 27035 | 7179 | 100 |
1636026 | 1636026 | 2021-08-20 | Crow Wing | Minnesota | 27035 | 7179 | 100 |
1632776 | 1632776 | 2021-08-19 | Crow Wing | Minnesota | 27035 | 7138 | 100 |
1207494 | 1207494 | 2021-04-10 | Rice | Minnesota | 27131 | 7408 | 100 |
1204246 | 1204246 | 2021-04-09 | Rice | Minnesota | 27131 | 7373 | 100 |
1200998 | 1200998 | 2021-04-08 | Rice | Minnesota | 27131 | 7329 | 100 |
1197749 | 1197749 | 2021-04-07 | Rice | Minnesota | 27131 | 7300 | 100 |
1194500 | 1194500 | 2021-04-06 | Rice | Minnesota | 27131 | 7281 | 100 |
746595 | 746595 | 2020-11-19 | Washington | Minnesota | 27163 | 11495 | 100 |
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);