ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 101 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500911 | 2500911 | 2022-05-13 | Blue Earth | Minnesota | 27013 | 18332 | 101 |
2286138 | 2286138 | 2022-03-08 | Morrison | Minnesota | 27097 | 9009 | 101 |
2282886 | 2282886 | 2022-03-07 | Morrison | Minnesota | 27097 | 8992 | 101 |
2279633 | 2279633 | 2022-03-06 | Morrison | Minnesota | 27097 | 8987 | 101 |
2279644 | 2279644 | 2022-03-06 | Polk | Minnesota | 27119 | 8521 | 101 |
2276380 | 2276380 | 2022-03-05 | Morrison | Minnesota | 27097 | 8987 | 101 |
2276391 | 2276391 | 2022-03-05 | Polk | Minnesota | 27119 | 8521 | 101 |
2273127 | 2273127 | 2022-03-04 | Morrison | Minnesota | 27097 | 8987 | 101 |
2273138 | 2273138 | 2022-03-04 | Polk | Minnesota | 27119 | 8521 | 101 |
2269875 | 2269875 | 2022-03-03 | Morrison | Minnesota | 27097 | 8984 | 101 |
2269886 | 2269886 | 2022-03-03 | Polk | Minnesota | 27119 | 8513 | 101 |
2266633 | 2266633 | 2022-03-02 | Polk | Minnesota | 27119 | 8505 | 101 |
2263382 | 2263382 | 2022-03-01 | Polk | Minnesota | 27119 | 8501 | 101 |
2260131 | 2260131 | 2022-02-28 | Polk | Minnesota | 27119 | 8495 | 101 |
2237360 | 2237360 | 2022-02-21 | McLeod | Minnesota | 27085 | 10314 | 101 |
2234109 | 2234109 | 2022-02-20 | McLeod | Minnesota | 27085 | 10314 | 101 |
2230858 | 2230858 | 2022-02-19 | McLeod | Minnesota | 27085 | 10314 | 101 |
2227607 | 2227607 | 2022-02-18 | McLeod | Minnesota | 27085 | 10314 | 101 |
2224356 | 2224356 | 2022-02-17 | McLeod | Minnesota | 27085 | 10265 | 101 |
2221105 | 2221105 | 2022-02-16 | McLeod | Minnesota | 27085 | 10254 | 101 |
2217854 | 2217854 | 2022-02-15 | McLeod | Minnesota | 27085 | 10244 | 101 |
2129999 | 2129999 | 2022-01-19 | Isanti | Minnesota | 27059 | 8561 | 101 |
2130017 | 2130017 | 2022-01-19 | Mille Lacs | Minnesota | 27095 | 6235 | 101 |
2126745 | 2126745 | 2022-01-18 | Isanti | Minnesota | 27059 | 8415 | 101 |
2126763 | 2126763 | 2022-01-18 | Mille Lacs | Minnesota | 27095 | 6134 | 101 |
2123493 | 2123493 | 2022-01-17 | Isanti | Minnesota | 27059 | 8375 | 101 |
2120241 | 2120241 | 2022-01-16 | Isanti | Minnesota | 27059 | 8375 | 101 |
2116989 | 2116989 | 2022-01-15 | Isanti | Minnesota | 27059 | 8375 | 101 |
2113738 | 2113738 | 2022-01-14 | Isanti | Minnesota | 27059 | 8375 | 101 |
2110486 | 2110486 | 2022-01-13 | Isanti | Minnesota | 27059 | 8328 | 101 |
2107235 | 2107235 | 2022-01-12 | Isanti | Minnesota | 27059 | 8275 | 101 |
2103984 | 2103984 | 2022-01-11 | Isanti | Minnesota | 27059 | 8218 | 101 |
2100733 | 2100733 | 2022-01-10 | Isanti | Minnesota | 27059 | 8078 | 101 |
2097482 | 2097482 | 2022-01-09 | Isanti | Minnesota | 27059 | 8023 | 101 |
2094230 | 2094230 | 2022-01-08 | Isanti | Minnesota | 27059 | 8023 | 101 |
2090978 | 2090978 | 2022-01-07 | Isanti | Minnesota | 27059 | 8023 | 101 |
2077954 | 2077954 | 2022-01-03 | Chisago | Minnesota | 27025 | 11064 | 101 |
2012956 | 2012956 | 2021-12-14 | Douglas | Minnesota | 27041 | 8267 | 101 |
2009705 | 2009705 | 2021-12-13 | Douglas | Minnesota | 27041 | 8216 | 101 |
2009709 | 2009709 | 2021-12-13 | Goodhue | Minnesota | 27049 | 8633 | 101 |
2006454 | 2006454 | 2021-12-12 | Douglas | Minnesota | 27041 | 8184 | 101 |
2006458 | 2006458 | 2021-12-12 | Goodhue | Minnesota | 27049 | 8571 | 101 |
2003203 | 2003203 | 2021-12-11 | Douglas | Minnesota | 27041 | 8184 | 101 |
2003207 | 2003207 | 2021-12-11 | Goodhue | Minnesota | 27049 | 8571 | 101 |
1999953 | 1999953 | 2021-12-10 | Douglas | Minnesota | 27041 | 8184 | 101 |
1999957 | 1999957 | 2021-12-10 | Goodhue | Minnesota | 27049 | 8571 | 101 |
1996702 | 1996702 | 2021-12-09 | Douglas | Minnesota | 27041 | 8152 | 101 |
1996706 | 1996706 | 2021-12-09 | Goodhue | Minnesota | 27049 | 8519 | 101 |
1993451 | 1993451 | 2021-12-08 | Douglas | Minnesota | 27041 | 8116 | 101 |
1993455 | 1993455 | 2021-12-08 | Goodhue | Minnesota | 27049 | 8477 | 101 |
1990183 | 1990183 | 2021-12-07 | Beltrami | Minnesota | 27007 | 8365 | 101 |
1990200 | 1990200 | 2021-12-07 | Douglas | Minnesota | 27041 | 8084 | 101 |
1986950 | 1986950 | 2021-12-06 | Douglas | Minnesota | 27041 | 8015 | 101 |
1983700 | 1983700 | 2021-12-05 | Douglas | Minnesota | 27041 | 7967 | 101 |
1980450 | 1980450 | 2021-12-04 | Douglas | Minnesota | 27041 | 7967 | 101 |
1977200 | 1977200 | 2021-12-03 | Douglas | Minnesota | 27041 | 7967 | 101 |
1973950 | 1973950 | 2021-12-02 | Douglas | Minnesota | 27041 | 7929 | 101 |
1970701 | 1970701 | 2021-12-01 | Douglas | Minnesota | 27041 | 7875 | 101 |
1938185 | 1938185 | 2021-11-21 | Clay | Minnesota | 27027 | 11602 | 101 |
1934935 | 1934935 | 2021-11-20 | Clay | Minnesota | 27027 | 11602 | 101 |
1931685 | 1931685 | 2021-11-19 | Clay | Minnesota | 27027 | 11602 | 101 |
1928434 | 1928434 | 2021-11-18 | Clay | Minnesota | 27027 | 11573 | 101 |
1925184 | 1925184 | 2021-11-17 | Clay | Minnesota | 27027 | 11527 | 101 |
1882958 | 1882958 | 2021-11-04 | Kandiyohi | Minnesota | 27067 | 8883 | 101 |
1788755 | 1788755 | 2021-10-06 | Otter Tail | Minnesota | 27111 | 7368 | 101 |
1743218 | 1743218 | 2021-09-22 | Benton | Minnesota | 27009 | 6577 | 101 |
1739969 | 1739969 | 2021-09-21 | Benton | Minnesota | 27009 | 6567 | 101 |
1736720 | 1736720 | 2021-09-20 | Benton | Minnesota | 27009 | 6472 | 101 |
1736785 | 1736785 | 2021-09-20 | Sherburne | Minnesota | 27141 | 13539 | 101 |
1733470 | 1733470 | 2021-09-19 | Benton | Minnesota | 27009 | 6439 | 101 |
1730220 | 1730220 | 2021-09-18 | Benton | Minnesota | 27009 | 6439 | 101 |
1726970 | 1726970 | 2021-09-17 | Benton | Minnesota | 27009 | 6439 | 101 |
1720485 | 1720485 | 2021-09-15 | Crow Wing | Minnesota | 27035 | 7723 | 101 |
1717237 | 1717237 | 2021-09-14 | Crow Wing | Minnesota | 27035 | 7684 | 101 |
1713989 | 1713989 | 2021-09-13 | Crow Wing | Minnesota | 27035 | 7630 | 101 |
1710743 | 1710743 | 2021-09-12 | Crow Wing | Minnesota | 27035 | 7592 | 101 |
1707496 | 1707496 | 2021-09-11 | Crow Wing | Minnesota | 27035 | 7592 | 101 |
1704249 | 1704249 | 2021-09-10 | Crow Wing | Minnesota | 27035 | 7592 | 101 |
1700999 | 1700999 | 2021-09-09 | Crow Wing | Minnesota | 27035 | 7562 | 101 |
1697750 | 1697750 | 2021-09-08 | Crow Wing | Minnesota | 27035 | 7545 | 101 |
1350351 | 1350351 | 2021-05-24 | Olmsted | Minnesota | 27109 | 13328 | 101 |
1347105 | 1347105 | 2021-05-23 | Olmsted | Minnesota | 27109 | 13324 | 101 |
1343857 | 1343857 | 2021-05-22 | Olmsted | Minnesota | 27109 | 13319 | 101 |
1233477 | 1233477 | 2021-04-18 | Rice | Minnesota | 27131 | 7649 | 101 |
1230229 | 1230229 | 2021-04-17 | Rice | Minnesota | 27131 | 7632 | 101 |
1226981 | 1226981 | 2021-04-16 | Rice | Minnesota | 27131 | 7588 | 101 |
1223733 | 1223733 | 2021-04-15 | Rice | Minnesota | 27131 | 7554 | 101 |
1220486 | 1220486 | 2021-04-14 | Rice | Minnesota | 27131 | 7506 | 101 |
1217238 | 1217238 | 2021-04-13 | Rice | Minnesota | 27131 | 7481 | 101 |
1213991 | 1213991 | 2021-04-12 | Rice | Minnesota | 27131 | 7454 | 101 |
1210743 | 1210743 | 2021-04-11 | Rice | Minnesota | 27131 | 7432 | 101 |
977001 | 977001 | 2021-01-29 | Scott | Minnesota | 27139 | 12368 | 101 |
928341 | 928341 | 2021-01-14 | Wright | Minnesota | 27171 | 11485 | 101 |
769305 | 769305 | 2020-11-26 | St. Louis | Minnesota | 27137 | 7935 | 101 |
766059 | 766059 | 2020-11-25 | St. Louis | Minnesota | 27137 | 7935 | 101 |
361574 | 361574 | 2020-07-23 | Dakota | Minnesota | 27037 | 3263 | 101 |
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);