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 2020-12-14 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
827649 | 827649 | 2020-12-14 | Aitkin | Minnesota | 27001 | 929 | 31 |
827650 | 827650 | 2020-12-14 | Anoka | Minnesota | 27003 | 26802 | 263 |
827651 | 827651 | 2020-12-14 | Becker | Minnesota | 27005 | 2505 | 29 |
827652 | 827652 | 2020-12-14 | Beltrami | Minnesota | 27007 | 2627 | 28 |
827653 | 827653 | 2020-12-14 | Benton | Minnesota | 27009 | 3589 | 65 |
827654 | 827654 | 2020-12-14 | Big Stone | Minnesota | 27011 | 407 | 2 |
827655 | 827655 | 2020-12-14 | Blue Earth | Minnesota | 27013 | 4710 | 22 |
827656 | 827656 | 2020-12-14 | Brown | Minnesota | 27015 | 1828 | 23 |
827657 | 827657 | 2020-12-14 | Carlton | Minnesota | 27017 | 2367 | 29 |
827658 | 827658 | 2020-12-14 | Carver | Minnesota | 27019 | 5928 | 22 |
827659 | 827659 | 2020-12-14 | Cass | Minnesota | 27021 | 1772 | 13 |
827660 | 827660 | 2020-12-14 | Chippewa | Minnesota | 27023 | 1144 | 18 |
827661 | 827661 | 2020-12-14 | Chisago | Minnesota | 27025 | 3794 | 24 |
827662 | 827662 | 2020-12-14 | Clay | Minnesota | 27027 | 5799 | 69 |
827663 | 827663 | 2020-12-14 | Clearwater | Minnesota | 27029 | 611 | 10 |
827664 | 827664 | 2020-12-14 | Cook | Minnesota | 27031 | 97 | 0 |
827665 | 827665 | 2020-12-14 | Cottonwood | Minnesota | 27033 | 1142 | 5 |
827666 | 827666 | 2020-12-14 | Crow Wing | Minnesota | 27035 | 4265 | 48 |
827667 | 827667 | 2020-12-14 | Dakota | Minnesota | 27037 | 27388 | 236 |
827668 | 827668 | 2020-12-14 | Dodge | Minnesota | 27039 | 1058 | 3 |
827669 | 827669 | 2020-12-14 | Douglas | Minnesota | 27041 | 3191 | 50 |
827670 | 827670 | 2020-12-14 | Faribault | Minnesota | 27043 | 778 | 5 |
827671 | 827671 | 2020-12-14 | Fillmore | Minnesota | 27045 | 928 | 0 |
827672 | 827672 | 2020-12-14 | Freeborn | Minnesota | 27047 | 1791 | 14 |
827673 | 827673 | 2020-12-14 | Goodhue | Minnesota | 27049 | 2649 | 35 |
827674 | 827674 | 2020-12-14 | Grant | Minnesota | 27051 | 346 | 7 |
827675 | 827675 | 2020-12-14 | Hennepin | Minnesota | 27053 | 79756 | 1246 |
827676 | 827676 | 2020-12-14 | Houston | Minnesota | 27055 | 996 | 5 |
827677 | 827677 | 2020-12-14 | Hubbard | Minnesota | 27057 | 1300 | 33 |
827678 | 827678 | 2020-12-14 | Isanti | Minnesota | 27059 | 2409 | 25 |
827679 | 827679 | 2020-12-14 | Itasca | Minnesota | 27061 | 2453 | 29 |
827680 | 827680 | 2020-12-14 | Jackson | Minnesota | 27063 | 691 | 3 |
827681 | 827681 | 2020-12-14 | Kanabec | Minnesota | 27065 | 855 | 18 |
827682 | 827682 | 2020-12-14 | Kandiyohi | Minnesota | 27067 | 5047 | 47 |
827683 | 827683 | 2020-12-14 | Kittson | Minnesota | 27069 | 325 | 14 |
827684 | 827684 | 2020-12-14 | Koochiching | Minnesota | 27071 | 497 | 7 |
827685 | 827685 | 2020-12-14 | Lac qui Parle | Minnesota | 27073 | 519 | 8 |
827686 | 827686 | 2020-12-14 | Lake | Minnesota | 27075 | 497 | 11 |
827687 | 827687 | 2020-12-14 | Lake of the Woods | Minnesota | 27077 | 137 | 1 |
827688 | 827688 | 2020-12-14 | Le Sueur | Minnesota | 27079 | 1786 | 13 |
827689 | 827689 | 2020-12-14 | Lincoln | Minnesota | 27081 | 427 | 1 |
827690 | 827690 | 2020-12-14 | Lyon | Minnesota | 27083 | 2612 | 23 |
827691 | 827691 | 2020-12-14 | Mahnomen | Minnesota | 27087 | 361 | 6 |
827692 | 827692 | 2020-12-14 | Marshall | Minnesota | 27089 | 630 | 11 |
827693 | 827693 | 2020-12-14 | Martin | Minnesota | 27091 | 1429 | 23 |
827694 | 827694 | 2020-12-14 | McLeod | Minnesota | 27085 | 2855 | 30 |
827695 | 827695 | 2020-12-14 | Meeker | Minnesota | 27093 | 1754 | 22 |
827696 | 827696 | 2020-12-14 | Mille Lacs | Minnesota | 27095 | 1884 | 38 |
827697 | 827697 | 2020-12-14 | Morrison | Minnesota | 27097 | 2756 | 36 |
827698 | 827698 | 2020-12-14 | Mower | Minnesota | 27099 | 3105 | 23 |
827699 | 827699 | 2020-12-14 | Murray | Minnesota | 27101 | 705 | 5 |
827700 | 827700 | 2020-12-14 | Nicollet | Minnesota | 27103 | 1906 | 30 |
827701 | 827701 | 2020-12-14 | Nobles | Minnesota | 27105 | 3395 | 41 |
827702 | 827702 | 2020-12-14 | Norman | Minnesota | 27107 | 399 | 7 |
827703 | 827703 | 2020-12-14 | Olmsted | Minnesota | 27109 | 8159 | 46 |
827704 | 827704 | 2020-12-14 | Otter Tail | Minnesota | 27111 | 3893 | 37 |
827705 | 827705 | 2020-12-14 | Pennington | Minnesota | 27113 | 832 | 10 |
827706 | 827706 | 2020-12-14 | Pine | Minnesota | 27115 | 1994 | 10 |
827707 | 827707 | 2020-12-14 | Pipestone | Minnesota | 27117 | 836 | 18 |
827708 | 827708 | 2020-12-14 | Polk | Minnesota | 27119 | 3061 | 40 |
827709 | 827709 | 2020-12-14 | Pope | Minnesota | 27121 | 650 | 3 |
827710 | 827710 | 2020-12-14 | Ramsey | Minnesota | 27123 | 34016 | 592 |
827711 | 827711 | 2020-12-14 | Red Lake | Minnesota | 27125 | 275 | 3 |
827712 | 827712 | 2020-12-14 | Redwood | Minnesota | 27127 | 1210 | 22 |
827713 | 827713 | 2020-12-14 | Renville | Minnesota | 27129 | 1184 | 34 |
827714 | 827714 | 2020-12-14 | Rice | Minnesota | 27131 | 4916 | 46 |
827715 | 827715 | 2020-12-14 | Rock | Minnesota | 27133 | 966 | 10 |
827716 | 827716 | 2020-12-14 | Roseau | Minnesota | 27135 | 1523 | 9 |
827717 | 827717 | 2020-12-14 | Scott | Minnesota | 27139 | 10160 | 71 |
827718 | 827718 | 2020-12-14 | Sherburne | Minnesota | 27141 | 7066 | 49 |
827719 | 827719 | 2020-12-14 | Sibley | Minnesota | 27143 | 936 | 4 |
827720 | 827720 | 2020-12-14 | St. Louis | Minnesota | 27137 | 11245 | 158 |
827721 | 827721 | 2020-12-14 | Stearns | Minnesota | 27145 | 16011 | 145 |
827722 | 827722 | 2020-12-14 | Steele | Minnesota | 27147 | 2346 | 9 |
827723 | 827723 | 2020-12-14 | Stevens | Minnesota | 27149 | 624 | 5 |
827724 | 827724 | 2020-12-14 | Swift | Minnesota | 27151 | 743 | 13 |
827725 | 827725 | 2020-12-14 | Todd | Minnesota | 27153 | 2114 | 19 |
827726 | 827726 | 2020-12-14 | Traverse | Minnesota | 27155 | 176 | 2 |
827727 | 827727 | 2020-12-14 | Unknown | Minnesota | 547 | 59 | |
827728 | 827728 | 2020-12-14 | Wabasha | Minnesota | 27157 | 1347 | 2 |
827729 | 827729 | 2020-12-14 | Wadena | Minnesota | 27159 | 1024 | 9 |
827730 | 827730 | 2020-12-14 | Waseca | Minnesota | 27161 | 1568 | 11 |
827731 | 827731 | 2020-12-14 | Washington | Minnesota | 27163 | 16968 | 150 |
827732 | 827732 | 2020-12-14 | Watonwan | Minnesota | 27165 | 995 | 5 |
827733 | 827733 | 2020-12-14 | Wilkin | Minnesota | 27167 | 535 | 5 |
827734 | 827734 | 2020-12-14 | Winona | Minnesota | 27169 | 3315 | 39 |
827735 | 827735 | 2020-12-14 | Wright | Minnesota | 27171 | 9939 | 66 |
827736 | 827736 | 2020-12-14 | Yellow Medicine | Minnesota | 27173 | 795 | 13 |
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);