ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where deaths = 70 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2325168 | 2325168 | 2022-03-20 | Mower | Minnesota | 27099 | 11788 | 70 |
2321914 | 2321914 | 2022-03-19 | Mower | Minnesota | 27099 | 11788 | 70 |
2318660 | 2318660 | 2022-03-18 | Mower | Minnesota | 27099 | 11788 | 70 |
2315407 | 2315407 | 2022-03-17 | Mower | Minnesota | 27099 | 11783 | 70 |
2312154 | 2312154 | 2022-03-16 | Mower | Minnesota | 27099 | 11781 | 70 |
2308901 | 2308901 | 2022-03-15 | Mower | Minnesota | 27099 | 11773 | 70 |
2305650 | 2305650 | 2022-03-14 | Mower | Minnesota | 27099 | 11770 | 70 |
2302398 | 2302398 | 2022-03-13 | Mower | Minnesota | 27099 | 11768 | 70 |
2299146 | 2299146 | 2022-03-12 | Mower | Minnesota | 27099 | 11768 | 70 |
2295894 | 2295894 | 2022-03-11 | Mower | Minnesota | 27099 | 11768 | 70 |
2292642 | 2292642 | 2022-03-10 | Mower | Minnesota | 27099 | 11760 | 70 |
2289390 | 2289390 | 2022-03-09 | Mower | Minnesota | 27099 | 11759 | 70 |
2286139 | 2286139 | 2022-03-08 | Mower | Minnesota | 27099 | 11754 | 70 |
2260095 | 2260095 | 2022-02-28 | Freeborn | Minnesota | 27047 | 8887 | 70 |
2256844 | 2256844 | 2022-02-27 | Freeborn | Minnesota | 27047 | 8881 | 70 |
2253593 | 2253593 | 2022-02-26 | Freeborn | Minnesota | 27047 | 8881 | 70 |
2250342 | 2250342 | 2022-02-25 | Freeborn | Minnesota | 27047 | 8881 | 70 |
2247091 | 2247091 | 2022-02-24 | Freeborn | Minnesota | 27047 | 8872 | 70 |
2243840 | 2243840 | 2022-02-23 | Freeborn | Minnesota | 27047 | 8865 | 70 |
2243902 | 2243902 | 2022-02-23 | Winona | Minnesota | 27169 | 12309 | 70 |
2240589 | 2240589 | 2022-02-22 | Freeborn | Minnesota | 27047 | 8829 | 70 |
2240651 | 2240651 | 2022-02-22 | Winona | Minnesota | 27169 | 12233 | 70 |
2237400 | 2237400 | 2022-02-21 | Winona | Minnesota | 27169 | 12202 | 70 |
2234149 | 2234149 | 2022-02-20 | Winona | Minnesota | 27169 | 12202 | 70 |
2230898 | 2230898 | 2022-02-19 | Winona | Minnesota | 27169 | 12202 | 70 |
2227647 | 2227647 | 2022-02-18 | Winona | Minnesota | 27169 | 12202 | 70 |
2224352 | 2224352 | 2022-02-17 | Lyon | Minnesota | 27083 | 6959 | 70 |
2221101 | 2221101 | 2022-02-16 | Lyon | Minnesota | 27083 | 6952 | 70 |
2217850 | 2217850 | 2022-02-15 | Lyon | Minnesota | 27083 | 6949 | 70 |
2214599 | 2214599 | 2022-02-14 | Lyon | Minnesota | 27083 | 6944 | 70 |
2211347 | 2211347 | 2022-02-13 | Lyon | Minnesota | 27083 | 6925 | 70 |
2208094 | 2208094 | 2022-02-12 | Lyon | Minnesota | 27083 | 6925 | 70 |
2204841 | 2204841 | 2022-02-11 | Lyon | Minnesota | 27083 | 6925 | 70 |
2201588 | 2201588 | 2022-02-10 | Lyon | Minnesota | 27083 | 6913 | 70 |
2198334 | 2198334 | 2022-02-09 | Lyon | Minnesota | 27083 | 6889 | 70 |
2195080 | 2195080 | 2022-02-08 | Lyon | Minnesota | 27083 | 6876 | 70 |
2191826 | 2191826 | 2022-02-07 | Lyon | Minnesota | 27083 | 6844 | 70 |
2188542 | 2188542 | 2022-02-06 | Cass | Minnesota | 27021 | 6418 | 70 |
2188573 | 2188573 | 2022-02-06 | Lyon | Minnesota | 27083 | 6821 | 70 |
2185289 | 2185289 | 2022-02-05 | Cass | Minnesota | 27021 | 6418 | 70 |
2185320 | 2185320 | 2022-02-05 | Lyon | Minnesota | 27083 | 6821 | 70 |
2182037 | 2182037 | 2022-02-04 | Cass | Minnesota | 27021 | 6418 | 70 |
2182068 | 2182068 | 2022-02-04 | Lyon | Minnesota | 27083 | 6821 | 70 |
2178785 | 2178785 | 2022-02-03 | Cass | Minnesota | 27021 | 6385 | 70 |
2178816 | 2178816 | 2022-02-03 | Lyon | Minnesota | 27083 | 6805 | 70 |
2175533 | 2175533 | 2022-02-02 | Cass | Minnesota | 27021 | 6351 | 70 |
2175564 | 2175564 | 2022-02-02 | Lyon | Minnesota | 27083 | 6785 | 70 |
2172277 | 2172277 | 2022-02-01 | Brown | Minnesota | 27015 | 6168 | 70 |
2172280 | 2172280 | 2022-02-01 | Cass | Minnesota | 27021 | 6336 | 70 |
2172311 | 2172311 | 2022-02-01 | Lyon | Minnesota | 27083 | 6765 | 70 |
2169024 | 2169024 | 2022-01-31 | Brown | Minnesota | 27015 | 6069 | 70 |
2169027 | 2169027 | 2022-01-31 | Cass | Minnesota | 27021 | 6236 | 70 |
2169058 | 2169058 | 2022-01-31 | Lyon | Minnesota | 27083 | 6686 | 70 |
2165769 | 2165769 | 2022-01-30 | Brown | Minnesota | 27015 | 5996 | 70 |
2165772 | 2165772 | 2022-01-30 | Cass | Minnesota | 27021 | 6172 | 70 |
2165803 | 2165803 | 2022-01-30 | Lyon | Minnesota | 27083 | 6625 | 70 |
2162514 | 2162514 | 2022-01-29 | Brown | Minnesota | 27015 | 5996 | 70 |
2162517 | 2162517 | 2022-01-29 | Cass | Minnesota | 27021 | 6172 | 70 |
2162548 | 2162548 | 2022-01-29 | Lyon | Minnesota | 27083 | 6625 | 70 |
2159259 | 2159259 | 2022-01-28 | Brown | Minnesota | 27015 | 5996 | 70 |
2159262 | 2159262 | 2022-01-28 | Cass | Minnesota | 27021 | 6172 | 70 |
2159293 | 2159293 | 2022-01-28 | Lyon | Minnesota | 27083 | 6625 | 70 |
2156005 | 2156005 | 2022-01-27 | Brown | Minnesota | 27015 | 5930 | 70 |
2156008 | 2156008 | 2022-01-27 | Cass | Minnesota | 27021 | 6110 | 70 |
2156039 | 2156039 | 2022-01-27 | Lyon | Minnesota | 27083 | 6562 | 70 |
2152755 | 2152755 | 2022-01-26 | Cass | Minnesota | 27021 | 6020 | 70 |
2152786 | 2152786 | 2022-01-26 | Lyon | Minnesota | 27083 | 6497 | 70 |
2149503 | 2149503 | 2022-01-25 | Cass | Minnesota | 27021 | 5966 | 70 |
2149534 | 2149534 | 2022-01-25 | Lyon | Minnesota | 27083 | 6440 | 70 |
2149539 | 2149539 | 2022-01-25 | Meeker | Minnesota | 27093 | 5244 | 70 |
2146251 | 2146251 | 2022-01-24 | Cass | Minnesota | 27021 | 5859 | 70 |
2146282 | 2146282 | 2022-01-24 | Lyon | Minnesota | 27083 | 6325 | 70 |
2146287 | 2146287 | 2022-01-24 | Meeker | Minnesota | 27093 | 5153 | 70 |
2142996 | 2142996 | 2022-01-23 | Cass | Minnesota | 27021 | 5826 | 70 |
2143032 | 2143032 | 2022-01-23 | Meeker | Minnesota | 27093 | 5123 | 70 |
2139741 | 2139741 | 2022-01-22 | Cass | Minnesota | 27021 | 5826 | 70 |
2139777 | 2139777 | 2022-01-22 | Meeker | Minnesota | 27093 | 5123 | 70 |
2136485 | 2136485 | 2022-01-21 | Cass | Minnesota | 27021 | 5826 | 70 |
2136521 | 2136521 | 2022-01-21 | Meeker | Minnesota | 27093 | 5123 | 70 |
2133233 | 2133233 | 2022-01-20 | Cass | Minnesota | 27021 | 5772 | 70 |
2133269 | 2133269 | 2022-01-20 | Meeker | Minnesota | 27093 | 5087 | 70 |
2130016 | 2130016 | 2022-01-19 | Meeker | Minnesota | 27093 | 5041 | 70 |
2126762 | 2126762 | 2022-01-18 | Meeker | Minnesota | 27093 | 4977 | 70 |
2123510 | 2123510 | 2022-01-17 | Meeker | Minnesota | 27093 | 4953 | 70 |
2120258 | 2120258 | 2022-01-16 | Meeker | Minnesota | 27093 | 4953 | 70 |
2117006 | 2117006 | 2022-01-15 | Meeker | Minnesota | 27093 | 4953 | 70 |
2113755 | 2113755 | 2022-01-14 | Meeker | Minnesota | 27093 | 4953 | 70 |
2110503 | 2110503 | 2022-01-13 | Meeker | Minnesota | 27093 | 4925 | 70 |
1973936 | 1973936 | 2021-12-02 | Blue Earth | Minnesota | 27013 | 11542 | 70 |
1970687 | 1970687 | 2021-12-01 | Blue Earth | Minnesota | 27013 | 11479 | 70 |
1941434 | 1941434 | 2021-11-22 | Chisago | Minnesota | 27025 | 9558 | 70 |
1938174 | 1938174 | 2021-11-21 | Becker | Minnesota | 27005 | 6056 | 70 |
1938184 | 1938184 | 2021-11-21 | Chisago | Minnesota | 27025 | 9511 | 70 |
1934924 | 1934924 | 2021-11-20 | Becker | Minnesota | 27005 | 6056 | 70 |
1934934 | 1934934 | 2021-11-20 | Chisago | Minnesota | 27025 | 9511 | 70 |
1931674 | 1931674 | 2021-11-19 | Becker | Minnesota | 27005 | 6056 | 70 |
1931684 | 1931684 | 2021-11-19 | Chisago | Minnesota | 27025 | 9511 | 70 |
1928423 | 1928423 | 2021-11-18 | Becker | Minnesota | 27005 | 6035 | 70 |
1925173 | 1925173 | 2021-11-17 | Becker | Minnesota | 27005 | 5990 | 70 |
1925179 | 1925179 | 2021-11-17 | Carlton | Minnesota | 27017 | 5052 | 70 |
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);