ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-01-24" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
960709 | 960709 | 2021-01-24 | Aitkin | Minnesota | 27001 | 1114 | 33 |
960710 | 960710 | 2021-01-24 | Anoka | Minnesota | 27003 | 31357 | 368 |
960711 | 960711 | 2021-01-24 | Becker | Minnesota | 27005 | 2889 | 39 |
960712 | 960712 | 2021-01-24 | Beltrami | Minnesota | 27007 | 3157 | 48 |
960713 | 960713 | 2021-01-24 | Benton | Minnesota | 27009 | 4236 | 88 |
960714 | 960714 | 2021-01-24 | Big Stone | Minnesota | 27011 | 469 | 3 |
960715 | 960715 | 2021-01-24 | Blue Earth | Minnesota | 27013 | 5480 | 33 |
960716 | 960716 | 2021-01-24 | Brown | Minnesota | 27015 | 2180 | 34 |
960717 | 960717 | 2021-01-24 | Carlton | Minnesota | 27017 | 2840 | 43 |
960718 | 960718 | 2021-01-24 | Carver | Minnesota | 27019 | 7044 | 39 |
960719 | 960719 | 2021-01-24 | Cass | Minnesota | 27021 | 2107 | 24 |
960720 | 960720 | 2021-01-24 | Chippewa | Minnesota | 27023 | 1330 | 32 |
960721 | 960721 | 2021-01-24 | Chisago | Minnesota | 27025 | 4595 | 38 |
960722 | 960722 | 2021-01-24 | Clay | Minnesota | 27027 | 6588 | 84 |
960723 | 960723 | 2021-01-24 | Clearwater | Minnesota | 27029 | 688 | 14 |
960724 | 960724 | 2021-01-24 | Cook | Minnesota | 27031 | 116 | 0 |
960725 | 960725 | 2021-01-24 | Cottonwood | Minnesota | 27033 | 1290 | 18 |
960726 | 960726 | 2021-01-24 | Crow Wing | Minnesota | 27035 | 4904 | 78 |
960727 | 960727 | 2021-01-24 | Dakota | Minnesota | 27037 | 33540 | 354 |
960728 | 960728 | 2021-01-24 | Dodge | Minnesota | 27039 | 1393 | 4 |
960729 | 960729 | 2021-01-24 | Douglas | Minnesota | 27041 | 3793 | 66 |
960730 | 960730 | 2021-01-24 | Faribault | Minnesota | 27043 | 1094 | 16 |
960731 | 960731 | 2021-01-24 | Fillmore | Minnesota | 27045 | 1269 | 8 |
960732 | 960732 | 2021-01-24 | Freeborn | Minnesota | 27047 | 2541 | 23 |
960733 | 960733 | 2021-01-24 | Goodhue | Minnesota | 27049 | 3568 | 63 |
960734 | 960734 | 2021-01-24 | Grant | Minnesota | 27051 | 438 | 8 |
960735 | 960735 | 2021-01-24 | Hennepin | Minnesota | 27053 | 94378 | 1502 |
960736 | 960736 | 2021-01-24 | Houston | Minnesota | 27055 | 1400 | 14 |
960737 | 960737 | 2021-01-24 | Hubbard | Minnesota | 27057 | 1507 | 38 |
960738 | 960738 | 2021-01-24 | Isanti | Minnesota | 27059 | 2856 | 43 |
960739 | 960739 | 2021-01-24 | Itasca | Minnesota | 27061 | 2873 | 43 |
960740 | 960740 | 2021-01-24 | Jackson | Minnesota | 27063 | 873 | 10 |
960741 | 960741 | 2021-01-24 | Kanabec | Minnesota | 27065 | 996 | 18 |
960742 | 960742 | 2021-01-24 | Kandiyohi | Minnesota | 27067 | 5580 | 72 |
960743 | 960743 | 2021-01-24 | Kittson | Minnesota | 27069 | 374 | 20 |
960744 | 960744 | 2021-01-24 | Koochiching | Minnesota | 27071 | 606 | 10 |
960745 | 960745 | 2021-01-24 | Lac qui Parle | Minnesota | 27073 | 661 | 16 |
960746 | 960746 | 2021-01-24 | Lake | Minnesota | 27075 | 663 | 15 |
960747 | 960747 | 2021-01-24 | Lake of the Woods | Minnesota | 27077 | 196 | 1 |
960748 | 960748 | 2021-01-24 | Le Sueur | Minnesota | 27079 | 2142 | 16 |
960749 | 960749 | 2021-01-24 | Lincoln | Minnesota | 27081 | 491 | 2 |
960750 | 960750 | 2021-01-24 | Lyon | Minnesota | 27083 | 3055 | 39 |
960751 | 960751 | 2021-01-24 | Mahnomen | Minnesota | 27087 | 416 | 7 |
960752 | 960752 | 2021-01-24 | Marshall | Minnesota | 27089 | 703 | 15 |
960753 | 960753 | 2021-01-24 | Martin | Minnesota | 27091 | 1719 | 26 |
960754 | 960754 | 2021-01-24 | McLeod | Minnesota | 27085 | 3281 | 47 |
960755 | 960755 | 2021-01-24 | Meeker | Minnesota | 27093 | 2013 | 33 |
960756 | 960756 | 2021-01-24 | Mille Lacs | Minnesota | 27095 | 2156 | 45 |
960757 | 960757 | 2021-01-24 | Morrison | Minnesota | 27097 | 3145 | 45 |
960758 | 960758 | 2021-01-24 | Mower | Minnesota | 27099 | 3737 | 29 |
960759 | 960759 | 2021-01-24 | Murray | Minnesota | 27101 | 911 | 7 |
960760 | 960760 | 2021-01-24 | Nicollet | Minnesota | 27103 | 2294 | 38 |
960761 | 960761 | 2021-01-24 | Nobles | Minnesota | 27105 | 3746 | 47 |
960762 | 960762 | 2021-01-24 | Norman | Minnesota | 27107 | 425 | 8 |
960763 | 960763 | 2021-01-24 | Olmsted | Minnesota | 27109 | 10780 | 75 |
960764 | 960764 | 2021-01-24 | Otter Tail | Minnesota | 27111 | 4642 | 68 |
960765 | 960765 | 2021-01-24 | Pennington | Minnesota | 27113 | 1010 | 16 |
960766 | 960766 | 2021-01-24 | Pine | Minnesota | 27115 | 2703 | 15 |
960767 | 960767 | 2021-01-24 | Pipestone | Minnesota | 27117 | 968 | 23 |
960768 | 960768 | 2021-01-24 | Polk | Minnesota | 27119 | 3307 | 60 |
960769 | 960769 | 2021-01-24 | Pope | Minnesota | 27121 | 747 | 5 |
960770 | 960770 | 2021-01-24 | Ramsey | Minnesota | 27123 | 40624 | 748 |
960771 | 960771 | 2021-01-24 | Red Lake | Minnesota | 27125 | 320 | 4 |
960772 | 960772 | 2021-01-24 | Redwood | Minnesota | 27127 | 1411 | 27 |
960773 | 960773 | 2021-01-24 | Renville | Minnesota | 27129 | 1384 | 40 |
960774 | 960774 | 2021-01-24 | Rice | Minnesota | 27131 | 6242 | 74 |
960775 | 960775 | 2021-01-24 | Rock | Minnesota | 27133 | 1120 | 12 |
960776 | 960776 | 2021-01-24 | Roseau | Minnesota | 27135 | 1664 | 17 |
960777 | 960777 | 2021-01-24 | Scott | Minnesota | 27139 | 12177 | 99 |
960778 | 960778 | 2021-01-24 | Sherburne | Minnesota | 27141 | 8296 | 69 |
960779 | 960779 | 2021-01-24 | Sibley | Minnesota | 27143 | 1099 | 7 |
960780 | 960780 | 2021-01-24 | St. Louis | Minnesota | 27137 | 13970 | 250 |
960781 | 960781 | 2021-01-24 | Stearns | Minnesota | 27145 | 18091 | 190 |
960782 | 960782 | 2021-01-24 | Steele | Minnesota | 27147 | 2789 | 10 |
960783 | 960783 | 2021-01-24 | Stevens | Minnesota | 27149 | 707 | 8 |
960784 | 960784 | 2021-01-24 | Swift | Minnesota | 27151 | 845 | 18 |
960785 | 960785 | 2021-01-24 | Todd | Minnesota | 27153 | 2337 | 30 |
960786 | 960786 | 2021-01-24 | Traverse | Minnesota | 27155 | 261 | 3 |
960787 | 960787 | 2021-01-24 | Unknown | Minnesota | 541 | 69 | |
960788 | 960788 | 2021-01-24 | Wabasha | Minnesota | 27157 | 1746 | 3 |
960789 | 960789 | 2021-01-24 | Wadena | Minnesota | 27159 | 1208 | 18 |
960790 | 960790 | 2021-01-24 | Waseca | Minnesota | 27161 | 1932 | 16 |
960791 | 960791 | 2021-01-24 | Washington | Minnesota | 27163 | 20533 | 237 |
960792 | 960792 | 2021-01-24 | Watonwan | Minnesota | 27165 | 1068 | 8 |
960793 | 960793 | 2021-01-24 | Wilkin | Minnesota | 27167 | 633 | 9 |
960794 | 960794 | 2021-01-24 | Winona | Minnesota | 27169 | 3945 | 48 |
960795 | 960795 | 2021-01-24 | Wright | Minnesota | 27171 | 11791 | 107 |
960796 | 960796 | 2021-01-24 | Yellow Medicine | Minnesota | 27173 | 949 | 16 |
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);