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 2021-12-29 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2061688 | 2061688 | 2021-12-29 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2061689 | 2061689 | 2021-12-29 | Anoka | Minnesota | 27003 | 71207 | 670 |
2061690 | 2061690 | 2021-12-29 | Becker | Minnesota | 27005 | 6614 | 81 |
2061691 | 2061691 | 2021-12-29 | Beltrami | Minnesota | 27007 | 8757 | 111 |
2061692 | 2061692 | 2021-12-29 | Benton | Minnesota | 27009 | 10018 | 139 |
2061693 | 2061693 | 2021-12-29 | Big Stone | Minnesota | 27011 | 1008 | 7 |
2061694 | 2061694 | 2021-12-29 | Blue Earth | Minnesota | 27013 | 12677 | 79 |
2061695 | 2061695 | 2021-12-29 | Brown | Minnesota | 27015 | 5014 | 66 |
2061696 | 2061696 | 2021-12-29 | Carlton | Minnesota | 27017 | 6101 | 80 |
2061697 | 2061697 | 2021-12-29 | Carver | Minnesota | 27019 | 18662 | 90 |
2061698 | 2061698 | 2021-12-29 | Cass | Minnesota | 27021 | 5380 | 64 |
2061699 | 2061699 | 2021-12-29 | Chippewa | Minnesota | 27023 | 2347 | 43 |
2061700 | 2061700 | 2021-12-29 | Chisago | Minnesota | 27025 | 10985 | 100 |
2061701 | 2061701 | 2021-12-29 | Clay | Minnesota | 27027 | 13125 | 113 |
2061702 | 2061702 | 2021-12-29 | Clearwater | Minnesota | 27029 | 1690 | 25 |
2061703 | 2061703 | 2021-12-29 | Cook | Minnesota | 27031 | 353 | 1 |
2061704 | 2061704 | 2021-12-29 | Cottonwood | Minnesota | 27033 | 2479 | 34 |
2061705 | 2061705 | 2021-12-29 | Crow Wing | Minnesota | 27035 | 12180 | 137 |
2061706 | 2061706 | 2021-12-29 | Dakota | Minnesota | 27037 | 75737 | 653 |
2061707 | 2061707 | 2021-12-29 | Dodge | Minnesota | 27039 | 3964 | 13 |
2061708 | 2061708 | 2021-12-29 | Douglas | Minnesota | 27041 | 8511 | 103 |
2061709 | 2061709 | 2021-12-29 | Faribault | Minnesota | 27043 | 2832 | 40 |
2061710 | 2061710 | 2021-12-29 | Fillmore | Minnesota | 27045 | 3435 | 16 |
2061711 | 2061711 | 2021-12-29 | Freeborn | Minnesota | 27047 | 6317 | 51 |
2061712 | 2061712 | 2021-12-29 | Goodhue | Minnesota | 27049 | 9194 | 107 |
2061713 | 2061713 | 2021-12-29 | Grant | Minnesota | 27051 | 1116 | 12 |
2061714 | 2061714 | 2021-12-29 | Hennepin | Minnesota | 27053 | 201420 | 2173 |
2061715 | 2061715 | 2021-12-29 | Houston | Minnesota | 27055 | 3128 | 18 |
2061716 | 2061716 | 2021-12-29 | Hubbard | Minnesota | 27057 | 3793 | 51 |
2061717 | 2061717 | 2021-12-29 | Isanti | Minnesota | 27059 | 7830 | 95 |
2061718 | 2061718 | 2021-12-29 | Itasca | Minnesota | 27061 | 8478 | 114 |
2061719 | 2061719 | 2021-12-29 | Jackson | Minnesota | 27063 | 1721 | 16 |
2061720 | 2061720 | 2021-12-29 | Kanabec | Minnesota | 27065 | 2824 | 44 |
2061721 | 2061721 | 2021-12-29 | Kandiyohi | Minnesota | 27067 | 10514 | 117 |
2061722 | 2061722 | 2021-12-29 | Kittson | Minnesota | 27069 | 852 | 24 |
2061723 | 2061723 | 2021-12-29 | Koochiching | Minnesota | 27071 | 1987 | 29 |
2061724 | 2061724 | 2021-12-29 | Lac qui Parle | Minnesota | 27073 | 1335 | 26 |
2061725 | 2061725 | 2021-12-29 | Lake | Minnesota | 27075 | 1474 | 26 |
2061726 | 2061726 | 2021-12-29 | Lake of the Woods | Minnesota | 27077 | 565 | 5 |
2061727 | 2061727 | 2021-12-29 | Le Sueur | Minnesota | 27079 | 5056 | 41 |
2061728 | 2061728 | 2021-12-29 | Lincoln | Minnesota | 27081 | 942 | 5 |
2061729 | 2061729 | 2021-12-29 | Lyon | Minnesota | 27083 | 5593 | 66 |
2061730 | 2061730 | 2021-12-29 | Mahnomen | Minnesota | 27087 | 1158 | 16 |
2061731 | 2061731 | 2021-12-29 | Marshall | Minnesota | 27089 | 1651 | 23 |
2061732 | 2061732 | 2021-12-29 | Martin | Minnesota | 27091 | 4214 | 52 |
2061733 | 2061733 | 2021-12-29 | McLeod | Minnesota | 27085 | 7880 | 92 |
2061734 | 2061734 | 2021-12-29 | Meeker | Minnesota | 27093 | 4730 | 67 |
2061735 | 2061735 | 2021-12-29 | Mille Lacs | Minnesota | 27095 | 5813 | 93 |
2061736 | 2061736 | 2021-12-29 | Morrison | Minnesota | 27097 | 7157 | 86 |
2061737 | 2061737 | 2021-12-29 | Mower | Minnesota | 27099 | 7898 | 54 |
2061738 | 2061738 | 2021-12-29 | Murray | Minnesota | 27101 | 1611 | 14 |
2061739 | 2061739 | 2021-12-29 | Nicollet | Minnesota | 27103 | 5700 | 62 |
2061740 | 2061740 | 2021-12-29 | Nobles | Minnesota | 27105 | 5446 | 56 |
2061741 | 2061741 | 2021-12-29 | Norman | Minnesota | 27107 | 1094 | 10 |
2061742 | 2061742 | 2021-12-29 | Olmsted | Minnesota | 27109 | 24873 | 139 |
2061743 | 2061743 | 2021-12-29 | Otter Tail | Minnesota | 27111 | 10534 | 144 |
2061744 | 2061744 | 2021-12-29 | Pennington | Minnesota | 27113 | 2664 | 31 |
2061745 | 2061745 | 2021-12-29 | Pine | Minnesota | 27115 | 5664 | 48 |
2061746 | 2061746 | 2021-12-29 | Pipestone | Minnesota | 27117 | 1613 | 30 |
2061747 | 2061747 | 2021-12-29 | Polk | Minnesota | 27119 | 6353 | 91 |
2061748 | 2061748 | 2021-12-29 | Pope | Minnesota | 27121 | 2272 | 14 |
2061749 | 2061749 | 2021-12-29 | Ramsey | Minnesota | 27123 | 83285 | 1123 |
2061750 | 2061750 | 2021-12-29 | Red Lake | Minnesota | 27125 | 736 | 11 |
2061751 | 2061751 | 2021-12-29 | Redwood | Minnesota | 27127 | 3025 | 49 |
2061752 | 2061752 | 2021-12-29 | Renville | Minnesota | 27129 | 2869 | 52 |
2061753 | 2061753 | 2021-12-29 | Rice | Minnesota | 27131 | 12478 | 147 |
2061754 | 2061754 | 2021-12-29 | Rock | Minnesota | 27133 | 1852 | 32 |
2061755 | 2061755 | 2021-12-29 | Roseau | Minnesota | 27135 | 3405 | 37 |
2061756 | 2061756 | 2021-12-29 | Scott | Minnesota | 27139 | 28966 | 209 |
2061757 | 2061757 | 2021-12-29 | Sherburne | Minnesota | 27141 | 20881 | 151 |
2061758 | 2061758 | 2021-12-29 | Sibley | Minnesota | 27143 | 2794 | 20 |
2061759 | 2061759 | 2021-12-29 | St. Louis | Minnesota | 27137 | 32809 | 447 |
2061760 | 2061760 | 2021-12-29 | Stearns | Minnesota | 27145 | 37020 | 311 |
2061761 | 2061761 | 2021-12-29 | Steele | Minnesota | 27147 | 7518 | 41 |
2061762 | 2061762 | 2021-12-29 | Stevens | Minnesota | 27149 | 1880 | 11 |
2061763 | 2061763 | 2021-12-29 | Swift | Minnesota | 27151 | 1828 | 29 |
2061764 | 2061764 | 2021-12-29 | Todd | Minnesota | 27153 | 5283 | 51 |
2061765 | 2061765 | 2021-12-29 | Traverse | Minnesota | 27155 | 629 | 8 |
2061766 | 2061766 | 2021-12-29 | Unknown | Minnesota | 734 | 134 | |
2061767 | 2061767 | 2021-12-29 | Wabasha | Minnesota | 27157 | 4106 | 12 |
2061768 | 2061768 | 2021-12-29 | Wadena | Minnesota | 27159 | 3239 | 44 |
2061769 | 2061769 | 2021-12-29 | Waseca | Minnesota | 27161 | 4262 | 35 |
2061770 | 2061770 | 2021-12-29 | Washington | Minnesota | 27163 | 45573 | 405 |
2061771 | 2061771 | 2021-12-29 | Watonwan | Minnesota | 27165 | 2166 | 21 |
2061772 | 2061772 | 2021-12-29 | Wilkin | Minnesota | 27167 | 1289 | 17 |
2061773 | 2061773 | 2021-12-29 | Winona | Minnesota | 27169 | 8416 | 62 |
2061774 | 2061774 | 2021-12-29 | Wright | Minnesota | 27171 | 28553 | 257 |
2061775 | 2061775 | 2021-12-29 | Yellow Medicine | Minnesota | 27173 | 2009 | 25 |
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);