ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where deaths = 99 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445544 | 2445544 | 2022-04-26 | Blue Earth | Minnesota | 27013 | 18111 | 99 |
2256869 | 2256869 | 2022-02-27 | Morrison | Minnesota | 27097 | 8955 | 99 |
2253618 | 2253618 | 2022-02-26 | Morrison | Minnesota | 27097 | 8955 | 99 |
2250367 | 2250367 | 2022-02-25 | Morrison | Minnesota | 27097 | 8955 | 99 |
2247116 | 2247116 | 2022-02-24 | Morrison | Minnesota | 27097 | 8952 | 99 |
2243865 | 2243865 | 2022-02-23 | Morrison | Minnesota | 27097 | 8952 | 99 |
2243876 | 2243876 | 2022-02-23 | Polk | Minnesota | 27119 | 8436 | 99 |
2240614 | 2240614 | 2022-02-22 | Morrison | Minnesota | 27097 | 8927 | 99 |
2237363 | 2237363 | 2022-02-21 | Morrison | Minnesota | 27097 | 8909 | 99 |
2234112 | 2234112 | 2022-02-20 | Morrison | Minnesota | 27097 | 8909 | 99 |
2230861 | 2230861 | 2022-02-19 | Morrison | Minnesota | 27097 | 8909 | 99 |
2227610 | 2227610 | 2022-02-18 | Morrison | Minnesota | 27097 | 8909 | 99 |
2224359 | 2224359 | 2022-02-17 | Morrison | Minnesota | 27097 | 8881 | 99 |
2221108 | 2221108 | 2022-02-16 | Morrison | Minnesota | 27097 | 8867 | 99 |
2217857 | 2217857 | 2022-02-15 | Morrison | Minnesota | 27097 | 8861 | 99 |
2214606 | 2214606 | 2022-02-14 | Morrison | Minnesota | 27097 | 8816 | 99 |
2211354 | 2211354 | 2022-02-13 | Morrison | Minnesota | 27097 | 8781 | 99 |
2208101 | 2208101 | 2022-02-12 | Morrison | Minnesota | 27097 | 8781 | 99 |
2204848 | 2204848 | 2022-02-11 | Morrison | Minnesota | 27097 | 8781 | 99 |
2201595 | 2201595 | 2022-02-10 | Morrison | Minnesota | 27097 | 8755 | 99 |
2198341 | 2198341 | 2022-02-09 | Morrison | Minnesota | 27097 | 8716 | 99 |
2195087 | 2195087 | 2022-02-08 | Morrison | Minnesota | 27097 | 8687 | 99 |
2191830 | 2191830 | 2022-02-07 | McLeod | Minnesota | 27085 | 9967 | 99 |
2188577 | 2188577 | 2022-02-06 | McLeod | Minnesota | 27085 | 9916 | 99 |
2185324 | 2185324 | 2022-02-05 | McLeod | Minnesota | 27085 | 9916 | 99 |
2182072 | 2182072 | 2022-02-04 | McLeod | Minnesota | 27085 | 9916 | 99 |
2172279 | 2172279 | 2022-02-01 | Carver | Minnesota | 27019 | 24773 | 99 |
2169026 | 2169026 | 2022-01-31 | Carver | Minnesota | 27019 | 24472 | 99 |
2165771 | 2165771 | 2022-01-30 | Carver | Minnesota | 27019 | 24131 | 99 |
2162516 | 2162516 | 2022-01-29 | Carver | Minnesota | 27019 | 24131 | 99 |
2159261 | 2159261 | 2022-01-28 | Carver | Minnesota | 27019 | 24131 | 99 |
2156007 | 2156007 | 2022-01-27 | Carver | Minnesota | 27019 | 23903 | 99 |
2110504 | 2110504 | 2022-01-13 | Mille Lacs | Minnesota | 27095 | 6077 | 99 |
2107253 | 2107253 | 2022-01-12 | Mille Lacs | Minnesota | 27095 | 6056 | 99 |
2104002 | 2104002 | 2022-01-11 | Mille Lacs | Minnesota | 27095 | 6031 | 99 |
2081223 | 2081223 | 2022-01-04 | Isanti | Minnesota | 27059 | 7931 | 99 |
1990204 | 1990204 | 2021-12-07 | Goodhue | Minnesota | 27049 | 8443 | 99 |
1986954 | 1986954 | 2021-12-06 | Goodhue | Minnesota | 27049 | 8295 | 99 |
1986960 | 1986960 | 2021-12-06 | Itasca | Minnesota | 27061 | 7854 | 99 |
1983704 | 1983704 | 2021-12-05 | Goodhue | Minnesota | 27049 | 8226 | 99 |
1983710 | 1983710 | 2021-12-05 | Itasca | Minnesota | 27061 | 7799 | 99 |
1980454 | 1980454 | 2021-12-04 | Goodhue | Minnesota | 27049 | 8226 | 99 |
1980460 | 1980460 | 2021-12-04 | Itasca | Minnesota | 27061 | 7799 | 99 |
1977204 | 1977204 | 2021-12-03 | Goodhue | Minnesota | 27049 | 8226 | 99 |
1977210 | 1977210 | 2021-12-03 | Itasca | Minnesota | 27061 | 7799 | 99 |
1973954 | 1973954 | 2021-12-02 | Goodhue | Minnesota | 27049 | 8168 | 99 |
1973960 | 1973960 | 2021-12-02 | Itasca | Minnesota | 27061 | 7772 | 99 |
1970711 | 1970711 | 2021-12-01 | Itasca | Minnesota | 27061 | 7722 | 99 |
1941442 | 1941442 | 2021-11-22 | Douglas | Minnesota | 27041 | 7481 | 99 |
1938192 | 1938192 | 2021-11-21 | Douglas | Minnesota | 27041 | 7430 | 99 |
1934942 | 1934942 | 2021-11-20 | Douglas | Minnesota | 27041 | 7430 | 99 |
1931692 | 1931692 | 2021-11-19 | Douglas | Minnesota | 27041 | 7430 | 99 |
1928441 | 1928441 | 2021-11-18 | Douglas | Minnesota | 27041 | 7365 | 99 |
1925191 | 1925191 | 2021-11-17 | Douglas | Minnesota | 27041 | 7309 | 99 |
1882938 | 1882938 | 2021-11-04 | Clay | Minnesota | 27027 | 10838 | 99 |
1879689 | 1879689 | 2021-11-03 | Clay | Minnesota | 27027 | 10761 | 99 |
1879709 | 1879709 | 2021-11-03 | Kandiyohi | Minnesota | 27067 | 8837 | 99 |
1876440 | 1876440 | 2021-11-02 | Clay | Minnesota | 27027 | 10717 | 99 |
1876460 | 1876460 | 2021-11-02 | Kandiyohi | Minnesota | 27067 | 8814 | 99 |
1873191 | 1873191 | 2021-11-01 | Clay | Minnesota | 27027 | 10630 | 99 |
1873211 | 1873211 | 2021-11-01 | Kandiyohi | Minnesota | 27067 | 8721 | 99 |
1869942 | 1869942 | 2021-10-31 | Clay | Minnesota | 27027 | 10507 | 99 |
1866693 | 1866693 | 2021-10-30 | Clay | Minnesota | 27027 | 10507 | 99 |
1863444 | 1863444 | 2021-10-29 | Clay | Minnesota | 27027 | 10507 | 99 |
1860195 | 1860195 | 2021-10-28 | Clay | Minnesota | 27027 | 10432 | 99 |
1856946 | 1856946 | 2021-10-27 | Clay | Minnesota | 27027 | 10394 | 99 |
1853697 | 1853697 | 2021-10-26 | Clay | Minnesota | 27027 | 10349 | 99 |
1850448 | 1850448 | 2021-10-25 | Clay | Minnesota | 27027 | 10275 | 99 |
1847198 | 1847198 | 2021-10-24 | Clay | Minnesota | 27027 | 10253 | 99 |
1843948 | 1843948 | 2021-10-23 | Clay | Minnesota | 27027 | 10253 | 99 |
1840698 | 1840698 | 2021-10-22 | Clay | Minnesota | 27027 | 10253 | 99 |
1837449 | 1837449 | 2021-10-21 | Clay | Minnesota | 27027 | 10235 | 99 |
1834200 | 1834200 | 2021-10-20 | Clay | Minnesota | 27027 | 10180 | 99 |
1782258 | 1782258 | 2021-10-04 | Otter Tail | Minnesota | 27111 | 7221 | 99 |
1779008 | 1779008 | 2021-10-03 | Otter Tail | Minnesota | 27111 | 7163 | 99 |
1775758 | 1775758 | 2021-10-02 | Otter Tail | Minnesota | 27111 | 7163 | 99 |
1772508 | 1772508 | 2021-10-01 | Otter Tail | Minnesota | 27111 | 7163 | 99 |
1720472 | 1720472 | 2021-09-15 | Benton | Minnesota | 27009 | 6387 | 99 |
1710795 | 1710795 | 2021-09-12 | Sherburne | Minnesota | 27141 | 13167 | 99 |
1707548 | 1707548 | 2021-09-11 | Sherburne | Minnesota | 27141 | 13167 | 99 |
1704301 | 1704301 | 2021-09-10 | Sherburne | Minnesota | 27141 | 13167 | 99 |
1701051 | 1701051 | 2021-09-09 | Sherburne | Minnesota | 27141 | 13126 | 99 |
1697802 | 1697802 | 2021-09-08 | Sherburne | Minnesota | 27141 | 13113 | 99 |
1694554 | 1694554 | 2021-09-07 | Sherburne | Minnesota | 27141 | 12993 | 99 |
1691305 | 1691305 | 2021-09-06 | Sherburne | Minnesota | 27141 | 12969 | 99 |
1688055 | 1688055 | 2021-09-05 | Sherburne | Minnesota | 27141 | 12969 | 99 |
1684805 | 1684805 | 2021-09-04 | Sherburne | Minnesota | 27141 | 12969 | 99 |
1681554 | 1681554 | 2021-09-03 | Sherburne | Minnesota | 27141 | 12969 | 99 |
1678306 | 1678306 | 2021-09-02 | Sherburne | Minnesota | 27141 | 12927 | 99 |
1629529 | 1629529 | 2021-08-18 | Crow Wing | Minnesota | 27035 | 7126 | 99 |
1626282 | 1626282 | 2021-08-17 | Crow Wing | Minnesota | 27035 | 7097 | 99 |
1623035 | 1623035 | 2021-08-16 | Crow Wing | Minnesota | 27035 | 7062 | 99 |
1619788 | 1619788 | 2021-08-15 | Crow Wing | Minnesota | 27035 | 7051 | 99 |
1616540 | 1616540 | 2021-08-14 | Crow Wing | Minnesota | 27035 | 7051 | 99 |
1613292 | 1613292 | 2021-08-13 | Crow Wing | Minnesota | 27035 | 7051 | 99 |
1610043 | 1610043 | 2021-08-12 | Crow Wing | Minnesota | 27035 | 7039 | 99 |
1606795 | 1606795 | 2021-08-11 | Crow Wing | Minnesota | 27035 | 7019 | 99 |
1603546 | 1603546 | 2021-08-10 | Crow Wing | Minnesota | 27035 | 7003 | 99 |
1600297 | 1600297 | 2021-08-09 | Crow Wing | Minnesota | 27035 | 6984 | 99 |
1597049 | 1597049 | 2021-08-08 | Crow Wing | Minnesota | 27035 | 6972 | 99 |
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);