ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where deaths = 113 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2347938 | 2347938 | 2022-03-27 | Mille Lacs | Minnesota | 27095 | 7205 | 113 |
2344685 | 2344685 | 2022-03-26 | Mille Lacs | Minnesota | 27095 | 7205 | 113 |
2341432 | 2341432 | 2022-03-25 | Mille Lacs | Minnesota | 27095 | 7205 | 113 |
2338179 | 2338179 | 2022-03-24 | Mille Lacs | Minnesota | 27095 | 7206 | 113 |
2334925 | 2334925 | 2022-03-23 | Mille Lacs | Minnesota | 27095 | 7205 | 113 |
2308861 | 2308861 | 2022-03-15 | Carver | Minnesota | 27019 | 26448 | 113 |
2305610 | 2305610 | 2022-03-14 | Carver | Minnesota | 27019 | 26441 | 113 |
2302358 | 2302358 | 2022-03-13 | Carver | Minnesota | 27019 | 26433 | 113 |
2299106 | 2299106 | 2022-03-12 | Carver | Minnesota | 27019 | 26433 | 113 |
2295854 | 2295854 | 2022-03-11 | Carver | Minnesota | 27019 | 26433 | 113 |
2292602 | 2292602 | 2022-03-10 | Carver | Minnesota | 27019 | 26362 | 113 |
2289350 | 2289350 | 2022-03-09 | Carver | Minnesota | 27019 | 26353 | 113 |
2286099 | 2286099 | 2022-03-08 | Carver | Minnesota | 27019 | 26338 | 113 |
2282847 | 2282847 | 2022-03-07 | Carver | Minnesota | 27019 | 26315 | 113 |
2279594 | 2279594 | 2022-03-06 | Carver | Minnesota | 27019 | 26268 | 113 |
2276341 | 2276341 | 2022-03-05 | Carver | Minnesota | 27019 | 26268 | 113 |
2273088 | 2273088 | 2022-03-04 | Carver | Minnesota | 27019 | 26268 | 113 |
2269836 | 2269836 | 2022-03-03 | Carver | Minnesota | 27019 | 26255 | 113 |
2266583 | 2266583 | 2022-03-02 | Carver | Minnesota | 27019 | 26248 | 113 |
2243837 | 2243837 | 2022-02-23 | Douglas | Minnesota | 27041 | 10717 | 113 |
2240586 | 2240586 | 2022-02-22 | Douglas | Minnesota | 27041 | 10686 | 113 |
2240595 | 2240595 | 2022-02-22 | Isanti | Minnesota | 27059 | 9969 | 113 |
2237335 | 2237335 | 2022-02-21 | Douglas | Minnesota | 27041 | 10670 | 113 |
2237344 | 2237344 | 2022-02-21 | Isanti | Minnesota | 27059 | 9955 | 113 |
2234084 | 2234084 | 2022-02-20 | Douglas | Minnesota | 27041 | 10670 | 113 |
2234093 | 2234093 | 2022-02-20 | Isanti | Minnesota | 27059 | 9955 | 113 |
2230833 | 2230833 | 2022-02-19 | Douglas | Minnesota | 27041 | 10670 | 113 |
2230842 | 2230842 | 2022-02-19 | Isanti | Minnesota | 27059 | 9955 | 113 |
2227582 | 2227582 | 2022-02-18 | Douglas | Minnesota | 27041 | 10670 | 113 |
2227591 | 2227591 | 2022-02-18 | Isanti | Minnesota | 27059 | 9955 | 113 |
2224331 | 2224331 | 2022-02-17 | Douglas | Minnesota | 27041 | 10640 | 113 |
2224340 | 2224340 | 2022-02-17 | Isanti | Minnesota | 27059 | 9934 | 113 |
2221080 | 2221080 | 2022-02-16 | Douglas | Minnesota | 27041 | 10629 | 113 |
2221089 | 2221089 | 2022-02-16 | Isanti | Minnesota | 27059 | 9925 | 113 |
2217829 | 2217829 | 2022-02-15 | Douglas | Minnesota | 27041 | 10618 | 113 |
2214578 | 2214578 | 2022-02-14 | Douglas | Minnesota | 27041 | 10562 | 113 |
2211326 | 2211326 | 2022-02-13 | Douglas | Minnesota | 27041 | 10505 | 113 |
2208073 | 2208073 | 2022-02-12 | Douglas | Minnesota | 27041 | 10505 | 113 |
2204820 | 2204820 | 2022-02-11 | Douglas | Minnesota | 27041 | 10505 | 113 |
2201567 | 2201567 | 2022-02-10 | Douglas | Minnesota | 27041 | 10474 | 113 |
2198313 | 2198313 | 2022-02-09 | Douglas | Minnesota | 27041 | 10436 | 113 |
2195059 | 2195059 | 2022-02-08 | Douglas | Minnesota | 27041 | 10401 | 113 |
2172282 | 2172282 | 2022-02-01 | Chisago | Minnesota | 27025 | 13376 | 113 |
2169029 | 2169029 | 2022-01-31 | Chisago | Minnesota | 27025 | 13203 | 113 |
2165774 | 2165774 | 2022-01-30 | Chisago | Minnesota | 27025 | 13052 | 113 |
2162519 | 2162519 | 2022-01-29 | Chisago | Minnesota | 27025 | 13052 | 113 |
2159264 | 2159264 | 2022-01-28 | Chisago | Minnesota | 27025 | 13052 | 113 |
2156001 | 2156001 | 2022-01-27 | Beltrami | Minnesota | 27007 | 10239 | 113 |
2152748 | 2152748 | 2022-01-26 | Beltrami | Minnesota | 27007 | 10028 | 113 |
2149496 | 2149496 | 2022-01-25 | Beltrami | Minnesota | 27007 | 9954 | 113 |
2129994 | 2129994 | 2022-01-19 | Goodhue | Minnesota | 27049 | 10589 | 113 |
2077955 | 2077955 | 2022-01-03 | Clay | Minnesota | 27027 | 13227 | 113 |
2074704 | 2074704 | 2022-01-02 | Clay | Minnesota | 27027 | 13171 | 113 |
2071453 | 2071453 | 2022-01-01 | Clay | Minnesota | 27027 | 13171 | 113 |
2068202 | 2068202 | 2021-12-31 | Clay | Minnesota | 27027 | 13171 | 113 |
2064951 | 2064951 | 2021-12-30 | Clay | Minnesota | 27027 | 13171 | 113 |
2061701 | 2061701 | 2021-12-29 | Clay | Minnesota | 27027 | 13125 | 113 |
2058452 | 2058452 | 2021-12-28 | Clay | Minnesota | 27027 | 13080 | 113 |
2058469 | 2058469 | 2021-12-28 | Itasca | Minnesota | 27061 | 8470 | 113 |
2055203 | 2055203 | 2021-12-27 | Clay | Minnesota | 27027 | 13014 | 113 |
2055220 | 2055220 | 2021-12-27 | Itasca | Minnesota | 27061 | 8389 | 113 |
1899229 | 1899229 | 2021-11-09 | Otter Tail | Minnesota | 27111 | 8869 | 113 |
1856937 | 1856937 | 2021-10-27 | Benton | Minnesota | 27009 | 7627 | 113 |
1805023 | 1805023 | 2021-10-11 | Unknown | Minnesota | 652 | 113 | |
1801774 | 1801774 | 2021-10-10 | Unknown | Minnesota | 648 | 113 | |
1798525 | 1798525 | 2021-10-09 | Unknown | Minnesota | 648 | 113 | |
1795276 | 1795276 | 2021-10-08 | Unknown | Minnesota | 648 | 113 | |
1792027 | 1792027 | 2021-10-07 | Unknown | Minnesota | 655 | 113 | |
1788778 | 1788778 | 2021-10-06 | Unknown | Minnesota | 648 | 113 | |
1785530 | 1785530 | 2021-10-05 | Unknown | Minnesota | 654 | 113 | |
1668559 | 1668559 | 2021-08-30 | Rice | Minnesota | 27131 | 8695 | 113 |
1665312 | 1665312 | 2021-08-29 | Rice | Minnesota | 27131 | 8681 | 113 |
1662064 | 1662064 | 2021-08-28 | Rice | Minnesota | 27131 | 8681 | 113 |
1658816 | 1658816 | 2021-08-27 | Rice | Minnesota | 27131 | 8681 | 113 |
1655567 | 1655567 | 2021-08-26 | Rice | Minnesota | 27131 | 8658 | 113 |
1652320 | 1652320 | 2021-08-25 | Rice | Minnesota | 27131 | 8651 | 113 |
1649072 | 1649072 | 2021-08-24 | Rice | Minnesota | 27131 | 8620 | 113 |
1645823 | 1645823 | 2021-08-23 | Rice | Minnesota | 27131 | 8586 | 113 |
1642574 | 1642574 | 2021-08-22 | Rice | Minnesota | 27131 | 8574 | 113 |
1639324 | 1639324 | 2021-08-21 | Rice | Minnesota | 27131 | 8574 | 113 |
1636074 | 1636074 | 2021-08-20 | Rice | Minnesota | 27131 | 8574 | 113 |
1632824 | 1632824 | 2021-08-19 | Rice | Minnesota | 27131 | 8559 | 113 |
1629577 | 1629577 | 2021-08-18 | Rice | Minnesota | 27131 | 8538 | 113 |
1626330 | 1626330 | 2021-08-17 | Rice | Minnesota | 27131 | 8522 | 113 |
1623083 | 1623083 | 2021-08-16 | Rice | Minnesota | 27131 | 8476 | 113 |
1619836 | 1619836 | 2021-08-15 | Rice | Minnesota | 27131 | 8457 | 113 |
1616588 | 1616588 | 2021-08-14 | Rice | Minnesota | 27131 | 8457 | 113 |
1613340 | 1613340 | 2021-08-13 | Rice | Minnesota | 27131 | 8457 | 113 |
1610091 | 1610091 | 2021-08-12 | Rice | Minnesota | 27131 | 8441 | 113 |
1606843 | 1606843 | 2021-08-11 | Rice | Minnesota | 27131 | 8425 | 113 |
1181513 | 1181513 | 2021-04-02 | Scott | Minnesota | 27139 | 14920 | 113 |
1038689 | 1038689 | 2021-02-17 | Wright | Minnesota | 27171 | 12270 | 113 |
1035444 | 1035444 | 2021-02-16 | Wright | Minnesota | 27171 | 12247 | 113 |
1032199 | 1032199 | 2021-02-15 | Wright | Minnesota | 27171 | 12239 | 113 |
1028952 | 1028952 | 2021-02-14 | Wright | Minnesota | 27171 | 12225 | 113 |
1025706 | 1025706 | 2021-02-13 | Wright | Minnesota | 27171 | 12215 | 113 |
1022461 | 1022461 | 2021-02-12 | Wright | Minnesota | 27171 | 12187 | 113 |
775806 | 775806 | 2020-11-28 | Washington | Minnesota | 27163 | 13529 | 113 |
500183 | 500183 | 2020-09-04 | Dakota | Minnesota | 27037 | 6303 | 113 |
496949 | 496949 | 2020-09-03 | Dakota | Minnesota | 27037 | 6219 | 113 |
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);