ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2022-03-02 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2266574 | 2266574 | 2022-03-02 | Aitkin | Minnesota | 27001 | 2917 | 60 |
2266575 | 2266575 | 2022-03-02 | Anoka | Minnesota | 27003 | 97468 | 778 |
2266576 | 2266576 | 2022-03-02 | Becker | Minnesota | 27005 | 8631 | 89 |
2266577 | 2266577 | 2022-03-02 | Beltrami | Minnesota | 27007 | 11337 | 122 |
2266578 | 2266578 | 2022-03-02 | Benton | Minnesota | 27009 | 13782 | 168 |
2266579 | 2266579 | 2022-03-02 | Big Stone | Minnesota | 27011 | 1365 | 8 |
2266580 | 2266580 | 2022-03-02 | Blue Earth | Minnesota | 27013 | 17476 | 94 |
2266581 | 2266581 | 2022-03-02 | Brown | Minnesota | 27015 | 6471 | 77 |
2266582 | 2266582 | 2022-03-02 | Carlton | Minnesota | 27017 | 8760 | 92 |
2266583 | 2266583 | 2022-03-02 | Carver | Minnesota | 27019 | 26248 | 113 |
2266584 | 2266584 | 2022-03-02 | Cass | Minnesota | 27021 | 6780 | 79 |
2266585 | 2266585 | 2022-03-02 | Chippewa | Minnesota | 27023 | 3037 | 47 |
2266586 | 2266586 | 2022-03-02 | Chisago | Minnesota | 27025 | 14388 | 117 |
2266587 | 2266587 | 2022-03-02 | Clay | Minnesota | 27027 | 19475 | 120 |
2266588 | 2266588 | 2022-03-02 | Clearwater | Minnesota | 27029 | 2109 | 30 |
2266589 | 2266589 | 2022-03-02 | Cook | Minnesota | 27031 | 541 | 4 |
2266590 | 2266590 | 2022-03-02 | Cottonwood | Minnesota | 27033 | 3179 | 40 |
2266591 | 2266591 | 2022-03-02 | Crow Wing | Minnesota | 27035 | 15757 | 163 |
2266592 | 2266592 | 2022-03-02 | Dakota | Minnesota | 27037 | 108236 | 755 |
2266593 | 2266593 | 2022-03-02 | Dodge | Minnesota | 27039 | 5581 | 21 |
2266594 | 2266594 | 2022-03-02 | Douglas | Minnesota | 27041 | 10769 | 115 |
2266595 | 2266595 | 2022-03-02 | Faribault | Minnesota | 27043 | 3719 | 50 |
2266596 | 2266596 | 2022-03-02 | Fillmore | Minnesota | 27045 | 4652 | 24 |
2266597 | 2266597 | 2022-03-02 | Freeborn | Minnesota | 27047 | 8911 | 71 |
2266598 | 2266598 | 2022-03-02 | Goodhue | Minnesota | 27049 | 12820 | 126 |
2266599 | 2266599 | 2022-03-02 | Grant | Minnesota | 27051 | 1441 | 12 |
2266600 | 2266600 | 2022-03-02 | Hennepin | Minnesota | 27053 | 294111 | 2510 |
2266601 | 2266601 | 2022-03-02 | Houston | Minnesota | 27055 | 4435 | 18 |
2266602 | 2266602 | 2022-03-02 | Hubbard | Minnesota | 27057 | 4861 | 56 |
2266603 | 2266603 | 2022-03-02 | Isanti | Minnesota | 27059 | 10013 | 116 |
2266604 | 2266604 | 2022-03-02 | Itasca | Minnesota | 27061 | 10871 | 140 |
2266605 | 2266605 | 2022-03-02 | Jackson | Minnesota | 27063 | 2128 | 17 |
2266606 | 2266606 | 2022-03-02 | Kanabec | Minnesota | 27065 | 3457 | 54 |
2266607 | 2266607 | 2022-03-02 | Kandiyohi | Minnesota | 27067 | 13228 | 135 |
2266608 | 2266608 | 2022-03-02 | Kittson | Minnesota | 27069 | 1022 | 26 |
2266609 | 2266609 | 2022-03-02 | Koochiching | Minnesota | 27071 | 2669 | 34 |
2266610 | 2266610 | 2022-03-02 | Lac qui Parle | Minnesota | 27073 | 1722 | 28 |
2266611 | 2266611 | 2022-03-02 | Lake | Minnesota | 27075 | 2019 | 28 |
2266612 | 2266612 | 2022-03-02 | Lake of the Woods | Minnesota | 27077 | 753 | 6 |
2266613 | 2266613 | 2022-03-02 | Le Sueur | Minnesota | 27079 | 6391 | 49 |
2266614 | 2266614 | 2022-03-02 | Lincoln | Minnesota | 27081 | 1203 | 6 |
2266615 | 2266615 | 2022-03-02 | Lyon | Minnesota | 27083 | 7013 | 72 |
2266616 | 2266616 | 2022-03-02 | Mahnomen | Minnesota | 27087 | 1696 | 17 |
2266617 | 2266617 | 2022-03-02 | Marshall | Minnesota | 27089 | 2041 | 23 |
2266618 | 2266618 | 2022-03-02 | Martin | Minnesota | 27091 | 5512 | 60 |
2266619 | 2266619 | 2022-03-02 | McLeod | Minnesota | 27085 | 10394 | 105 |
2266620 | 2266620 | 2022-03-02 | Meeker | Minnesota | 27093 | 5797 | 74 |
2266621 | 2266621 | 2022-03-02 | Mille Lacs | Minnesota | 27095 | 7133 | 110 |
2266622 | 2266622 | 2022-03-02 | Morrison | Minnesota | 27097 | 8978 | 100 |
2266623 | 2266623 | 2022-03-02 | Mower | Minnesota | 27099 | 11723 | 69 |
2266624 | 2266624 | 2022-03-02 | Murray | Minnesota | 27101 | 2011 | 15 |
2266625 | 2266625 | 2022-03-02 | Nicollet | Minnesota | 27103 | 7849 | 66 |
2266626 | 2266626 | 2022-03-02 | Nobles | Minnesota | 27105 | 6889 | 59 |
2266627 | 2266627 | 2022-03-02 | Norman | Minnesota | 27107 | 1469 | 13 |
2266628 | 2266628 | 2022-03-02 | Olmsted | Minnesota | 27109 | 39779 | 170 |
2266629 | 2266629 | 2022-03-02 | Otter Tail | Minnesota | 27111 | 13322 | 162 |
2266630 | 2266630 | 2022-03-02 | Pennington | Minnesota | 27113 | 3495 | 40 |
2266631 | 2266631 | 2022-03-02 | Pine | Minnesota | 27115 | 6934 | 64 |
2266632 | 2266632 | 2022-03-02 | Pipestone | Minnesota | 27117 | 1975 | 34 |
2266633 | 2266633 | 2022-03-02 | Polk | Minnesota | 27119 | 8505 | 101 |
2266634 | 2266634 | 2022-03-02 | Pope | Minnesota | 27121 | 2926 | 17 |
2266635 | 2266635 | 2022-03-02 | Ramsey | Minnesota | 27123 | 122174 | 1305 |
2266636 | 2266636 | 2022-03-02 | Red Lake | Minnesota | 27125 | 928 | 13 |
2266637 | 2266637 | 2022-03-02 | Redwood | Minnesota | 27127 | 3856 | 53 |
2266638 | 2266638 | 2022-03-02 | Renville | Minnesota | 27129 | 3626 | 56 |
2266639 | 2266639 | 2022-03-02 | Rice | Minnesota | 27131 | 17436 | 168 |
2266640 | 2266640 | 2022-03-02 | Rock | Minnesota | 27133 | 2310 | 33 |
2266641 | 2266641 | 2022-03-02 | Roseau | Minnesota | 27135 | 4370 | 44 |
2266642 | 2266642 | 2022-03-02 | Scott | Minnesota | 27139 | 39658 | 249 |
2266643 | 2266643 | 2022-03-02 | Sherburne | Minnesota | 27141 | 27063 | 176 |
2266644 | 2266644 | 2022-03-02 | Sibley | Minnesota | 27143 | 3446 | 23 |
2266645 | 2266645 | 2022-03-02 | St. Louis | Minnesota | 27137 | 45953 | 516 |
2266646 | 2266646 | 2022-03-02 | Stearns | Minnesota | 27145 | 50041 | 360 |
2266647 | 2266647 | 2022-03-02 | Steele | Minnesota | 27147 | 10229 | 58 |
2266648 | 2266648 | 2022-03-02 | Stevens | Minnesota | 27149 | 2595 | 13 |
2266649 | 2266649 | 2022-03-02 | Swift | Minnesota | 27151 | 2265 | 33 |
2266650 | 2266650 | 2022-03-02 | Todd | Minnesota | 27153 | 6636 | 55 |
2266651 | 2266651 | 2022-03-02 | Traverse | Minnesota | 27155 | 825 | 10 |
2266652 | 2266652 | 2022-03-02 | Unknown | Minnesota | 6394 | 180 | |
2266653 | 2266653 | 2022-03-02 | Wabasha | Minnesota | 27157 | 5479 | 16 |
2266654 | 2266654 | 2022-03-02 | Wadena | Minnesota | 27159 | 4112 | 52 |
2266655 | 2266655 | 2022-03-02 | Waseca | Minnesota | 27161 | 5411 | 39 |
2266656 | 2266656 | 2022-03-02 | Washington | Minnesota | 27163 | 65821 | 467 |
2266657 | 2266657 | 2022-03-02 | Watonwan | Minnesota | 27165 | 2922 | 23 |
2266658 | 2266658 | 2022-03-02 | Wilkin | Minnesota | 27167 | 1620 | 22 |
2266659 | 2266659 | 2022-03-02 | Winona | Minnesota | 27169 | 12392 | 71 |
2266660 | 2266660 | 2022-03-02 | Wright | Minnesota | 27171 | 36145 | 300 |
2266661 | 2266661 | 2022-03-02 | Yellow Medicine | Minnesota | 27173 | 2490 | 28 |
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);