ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 77 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2289348 | 2289348 | 2022-03-09 | Brown | Minnesota | 27015 | 6486 | 77 |
2286097 | 2286097 | 2022-03-08 | Brown | Minnesota | 27015 | 6482 | 77 |
2282845 | 2282845 | 2022-03-07 | Brown | Minnesota | 27015 | 6481 | 77 |
2279592 | 2279592 | 2022-03-06 | Brown | Minnesota | 27015 | 6478 | 77 |
2276339 | 2276339 | 2022-03-05 | Brown | Minnesota | 27015 | 6478 | 77 |
2273086 | 2273086 | 2022-03-04 | Brown | Minnesota | 27015 | 6478 | 77 |
2269834 | 2269834 | 2022-03-03 | Brown | Minnesota | 27015 | 6475 | 77 |
2266581 | 2266581 | 2022-03-02 | Brown | Minnesota | 27015 | 6471 | 77 |
2260082 | 2260082 | 2022-02-28 | Cass | Minnesota | 27021 | 6761 | 77 |
2256831 | 2256831 | 2022-02-27 | Cass | Minnesota | 27021 | 6748 | 77 |
2253580 | 2253580 | 2022-02-26 | Cass | Minnesota | 27021 | 6748 | 77 |
2250329 | 2250329 | 2022-02-25 | Cass | Minnesota | 27021 | 6748 | 77 |
2247078 | 2247078 | 2022-02-24 | Cass | Minnesota | 27021 | 6742 | 77 |
2058445 | 2058445 | 2021-12-28 | Blue Earth | Minnesota | 27013 | 12628 | 77 |
2009687 | 2009687 | 2021-12-13 | Becker | Minnesota | 27005 | 6442 | 77 |
2009694 | 2009694 | 2021-12-13 | Carver | Minnesota | 27019 | 17605 | 77 |
2006443 | 2006443 | 2021-12-12 | Carver | Minnesota | 27019 | 17546 | 77 |
2003192 | 2003192 | 2021-12-11 | Carver | Minnesota | 27019 | 17546 | 77 |
1999942 | 1999942 | 2021-12-10 | Carver | Minnesota | 27019 | 17546 | 77 |
1983688 | 1983688 | 2021-12-05 | Carlton | Minnesota | 27017 | 5525 | 77 |
1980438 | 1980438 | 2021-12-04 | Carlton | Minnesota | 27017 | 5525 | 77 |
1977188 | 1977188 | 2021-12-03 | Carlton | Minnesota | 27017 | 5525 | 77 |
1938220 | 1938220 | 2021-11-21 | Morrison | Minnesota | 27097 | 6489 | 77 |
1934970 | 1934970 | 2021-11-20 | Morrison | Minnesota | 27097 | 6489 | 77 |
1931720 | 1931720 | 2021-11-19 | Morrison | Minnesota | 27097 | 6489 | 77 |
1928469 | 1928469 | 2021-11-18 | Morrison | Minnesota | 27097 | 6442 | 77 |
1925219 | 1925219 | 2021-11-17 | Morrison | Minnesota | 27097 | 6419 | 77 |
1921970 | 1921970 | 2021-11-16 | Morrison | Minnesota | 27097 | 6392 | 77 |
1902469 | 1902469 | 2021-11-10 | McLeod | Minnesota | 27085 | 6507 | 77 |
1899203 | 1899203 | 2021-11-09 | Isanti | Minnesota | 27059 | 6235 | 77 |
1895953 | 1895953 | 2021-11-08 | Isanti | Minnesota | 27059 | 6177 | 77 |
1834246 | 1834246 | 2021-10-20 | Polk | Minnesota | 27119 | 5086 | 77 |
1830997 | 1830997 | 2021-10-19 | Polk | Minnesota | 27119 | 5063 | 77 |
1827692 | 1827692 | 2021-10-18 | Beltrami | Minnesota | 27007 | 6371 | 77 |
1827748 | 1827748 | 2021-10-18 | Polk | Minnesota | 27119 | 5034 | 77 |
1824499 | 1824499 | 2021-10-17 | Polk | Minnesota | 27119 | 5025 | 77 |
1821250 | 1821250 | 2021-10-16 | Polk | Minnesota | 27119 | 5025 | 77 |
1818001 | 1818001 | 2021-10-15 | Polk | Minnesota | 27119 | 5025 | 77 |
1811475 | 1811475 | 2021-10-13 | Itasca | Minnesota | 27061 | 5901 | 77 |
1701006 | 1701006 | 2021-09-09 | Goodhue | Minnesota | 27049 | 5380 | 77 |
1337327 | 1337327 | 2021-05-20 | Douglas | Minnesota | 27041 | 4709 | 77 |
1285418 | 1285418 | 2021-05-04 | Otter Tail | Minnesota | 27111 | 5658 | 77 |
1155534 | 1155534 | 2021-03-25 | Sherburne | Minnesota | 27141 | 9323 | 77 |
1152287 | 1152287 | 2021-03-24 | Sherburne | Minnesota | 27141 | 9280 | 77 |
1149040 | 1149040 | 2021-03-23 | Sherburne | Minnesota | 27141 | 9248 | 77 |
1145793 | 1145793 | 2021-03-22 | Sherburne | Minnesota | 27141 | 9229 | 77 |
1142546 | 1142546 | 2021-03-21 | Sherburne | Minnesota | 27141 | 9205 | 77 |
1139299 | 1139299 | 2021-03-20 | Sherburne | Minnesota | 27141 | 9170 | 77 |
1136053 | 1136053 | 2021-03-19 | Sherburne | Minnesota | 27141 | 9134 | 77 |
1132807 | 1132807 | 2021-03-18 | Sherburne | Minnesota | 27141 | 9086 | 77 |
1129559 | 1129559 | 2021-03-17 | Sherburne | Minnesota | 27141 | 9053 | 77 |
1126312 | 1126312 | 2021-03-16 | Sherburne | Minnesota | 27141 | 9025 | 77 |
1123066 | 1123066 | 2021-03-15 | Sherburne | Minnesota | 27141 | 9013 | 77 |
1119819 | 1119819 | 2021-03-14 | Sherburne | Minnesota | 27141 | 8985 | 77 |
1116572 | 1116572 | 2021-03-13 | Sherburne | Minnesota | 27141 | 8958 | 77 |
1113326 | 1113326 | 2021-03-12 | Sherburne | Minnesota | 27141 | 8934 | 77 |
1110080 | 1110080 | 2021-03-11 | Sherburne | Minnesota | 27141 | 8906 | 77 |
1106834 | 1106834 | 2021-03-10 | Sherburne | Minnesota | 27141 | 8866 | 77 |
1103588 | 1103588 | 2021-03-09 | Sherburne | Minnesota | 27141 | 8844 | 77 |
976987 | 976987 | 2021-01-29 | Olmsted | Minnesota | 27109 | 10982 | 77 |
950990 | 950990 | 2021-01-21 | Crow Wing | Minnesota | 27035 | 4868 | 77 |
947744 | 947744 | 2021-01-20 | Crow Wing | Minnesota | 27035 | 4848 | 77 |
879578 | 879578 | 2020-12-30 | Benton | Minnesota | 27009 | 3874 | 77 |
876342 | 876342 | 2020-12-29 | Clay | Minnesota | 27027 | 6129 | 77 |
873097 | 873097 | 2020-12-28 | Clay | Minnesota | 27027 | 6123 | 77 |
869852 | 869852 | 2020-12-27 | Clay | Minnesota | 27027 | 6115 | 77 |
720626 | 720626 | 2020-11-11 | St. Louis | Minnesota | 27137 | 4717 | 77 |
717383 | 717383 | 2020-11-10 | St. Louis | Minnesota | 27137 | 4567 | 77 |
714139 | 714139 | 2020-11-09 | St. Louis | Minnesota | 27137 | 4457 | 77 |
710895 | 710895 | 2020-11-08 | St. Louis | Minnesota | 27137 | 4267 | 77 |
707651 | 707651 | 2020-11-07 | St. Louis | Minnesota | 27137 | 4120 | 77 |
704408 | 704408 | 2020-11-06 | St. Louis | Minnesota | 27137 | 4022 | 77 |
704419 | 704419 | 2020-11-06 | Washington | Minnesota | 27163 | 7930 | 77 |
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);