ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
694608 | 694608 | 2020-11-03 | Aitkin | Minnesota | 27001 | 249 | 4 |
694609 | 694609 | 2020-11-03 | Anoka | Minnesota | 27003 | 10514 | 161 |
694610 | 694610 | 2020-11-03 | Becker | Minnesota | 27005 | 741 | 4 |
694611 | 694611 | 2020-11-03 | Beltrami | Minnesota | 27007 | 1034 | 11 |
694612 | 694612 | 2020-11-03 | Benton | Minnesota | 27009 | 1211 | 15 |
694613 | 694613 | 2020-11-03 | Big Stone | Minnesota | 27011 | 187 | 1 |
694614 | 694614 | 2020-11-03 | Blue Earth | Minnesota | 27013 | 2254 | 7 |
694615 | 694615 | 2020-11-03 | Brown | Minnesota | 27015 | 422 | 3 |
694616 | 694616 | 2020-11-03 | Carlton | Minnesota | 27017 | 629 | 3 |
694617 | 694617 | 2020-11-03 | Carver | Minnesota | 27019 | 2056 | 9 |
694618 | 694618 | 2020-11-03 | Cass | Minnesota | 27021 | 507 | 5 |
694619 | 694619 | 2020-11-03 | Chippewa | Minnesota | 27023 | 507 | 3 |
694620 | 694620 | 2020-11-03 | Chisago | Minnesota | 27025 | 1405 | 2 |
694621 | 694621 | 2020-11-03 | Clay | Minnesota | 27027 | 2762 | 46 |
694622 | 694622 | 2020-11-03 | Clearwater | Minnesota | 27029 | 167 | 1 |
694623 | 694623 | 2020-11-03 | Cook | Minnesota | 27031 | 27 | 0 |
694624 | 694624 | 2020-11-03 | Cottonwood | Minnesota | 27033 | 329 | 0 |
694625 | 694625 | 2020-11-03 | Crow Wing | Minnesota | 27035 | 1399 | 22 |
694626 | 694626 | 2020-11-03 | Dakota | Minnesota | 27037 | 11184 | 141 |
694627 | 694627 | 2020-11-03 | Dodge | Minnesota | 27039 | 450 | 0 |
694628 | 694628 | 2020-11-03 | Douglas | Minnesota | 27041 | 899 | 5 |
694629 | 694629 | 2020-11-03 | Faribault | Minnesota | 27043 | 277 | 0 |
694630 | 694630 | 2020-11-03 | Fillmore | Minnesota | 27045 | 311 | 0 |
694631 | 694631 | 2020-11-03 | Freeborn | Minnesota | 27047 | 780 | 5 |
694632 | 694632 | 2020-11-03 | Goodhue | Minnesota | 27049 | 797 | 13 |
694633 | 694633 | 2020-11-03 | Grant | Minnesota | 27051 | 118 | 5 |
694634 | 694634 | 2020-11-03 | Hennepin | Minnesota | 27053 | 38272 | 1006 |
694635 | 694635 | 2020-11-03 | Houston | Minnesota | 27055 | 269 | 2 |
694636 | 694636 | 2020-11-03 | Hubbard | Minnesota | 27057 | 535 | 5 |
694637 | 694637 | 2020-11-03 | Isanti | Minnesota | 27059 | 689 | 7 |
694638 | 694638 | 2020-11-03 | Itasca | Minnesota | 27061 | 896 | 17 |
694639 | 694639 | 2020-11-03 | Jackson | Minnesota | 27063 | 248 | 1 |
694640 | 694640 | 2020-11-03 | Kanabec | Minnesota | 27065 | 258 | 10 |
694641 | 694641 | 2020-11-03 | Kandiyohi | Minnesota | 27067 | 1988 | 5 |
694642 | 694642 | 2020-11-03 | Kittson | Minnesota | 27069 | 78 | 0 |
694643 | 694643 | 2020-11-03 | Koochiching | Minnesota | 27071 | 187 | 5 |
694644 | 694644 | 2020-11-03 | Lac qui Parle | Minnesota | 27073 | 158 | 3 |
694645 | 694645 | 2020-11-03 | Lake | Minnesota | 27075 | 151 | 0 |
694646 | 694646 | 2020-11-03 | Lake of the Woods | Minnesota | 27077 | 55 | 1 |
694647 | 694647 | 2020-11-03 | Le Sueur | Minnesota | 27079 | 722 | 6 |
694648 | 694648 | 2020-11-03 | Lincoln | Minnesota | 27081 | 212 | 0 |
694649 | 694649 | 2020-11-03 | Lyon | Minnesota | 27083 | 1100 | 6 |
694650 | 694650 | 2020-11-03 | Mahnomen | Minnesota | 27087 | 140 | 2 |
694651 | 694651 | 2020-11-03 | Marshall | Minnesota | 27089 | 204 | 1 |
694652 | 694652 | 2020-11-03 | Martin | Minnesota | 27091 | 659 | 18 |
694653 | 694653 | 2020-11-03 | McLeod | Minnesota | 27085 | 699 | 4 |
694654 | 694654 | 2020-11-03 | Meeker | Minnesota | 27093 | 398 | 4 |
694655 | 694655 | 2020-11-03 | Mille Lacs | Minnesota | 27095 | 538 | 21 |
694656 | 694656 | 2020-11-03 | Morrison | Minnesota | 27097 | 974 | 9 |
694657 | 694657 | 2020-11-03 | Mower | Minnesota | 27099 | 1597 | 20 |
694658 | 694658 | 2020-11-03 | Murray | Minnesota | 27101 | 321 | 3 |
694659 | 694659 | 2020-11-03 | Nicollet | Minnesota | 27103 | 829 | 18 |
694660 | 694660 | 2020-11-03 | Nobles | Minnesota | 27105 | 2475 | 20 |
694661 | 694661 | 2020-11-03 | Norman | Minnesota | 27107 | 155 | 0 |
694662 | 694662 | 2020-11-03 | Olmsted | Minnesota | 27109 | 3735 | 30 |
694663 | 694663 | 2020-11-03 | Otter Tail | Minnesota | 27111 | 1080 | 8 |
694664 | 694664 | 2020-11-03 | Pennington | Minnesota | 27113 | 240 | 2 |
694665 | 694665 | 2020-11-03 | Pine | Minnesota | 27115 | 643 | 1 |
694666 | 694666 | 2020-11-03 | Pipestone | Minnesota | 27117 | 397 | 17 |
694667 | 694667 | 2020-11-03 | Polk | Minnesota | 27119 | 1070 | 6 |
694668 | 694668 | 2020-11-03 | Pope | Minnesota | 27121 | 187 | 0 |
694669 | 694669 | 2020-11-03 | Ramsey | Minnesota | 27123 | 15853 | 384 |
694670 | 694670 | 2020-11-03 | Red Lake | Minnesota | 27125 | 95 | 2 |
694671 | 694671 | 2020-11-03 | Redwood | Minnesota | 27127 | 340 | 12 |
694672 | 694672 | 2020-11-03 | Renville | Minnesota | 27129 | 319 | 13 |
694673 | 694673 | 2020-11-03 | Rice | Minnesota | 27131 | 1823 | 12 |
694674 | 694674 | 2020-11-03 | Rock | Minnesota | 27133 | 402 | 6 |
694675 | 694675 | 2020-11-03 | Roseau | Minnesota | 27135 | 412 | 0 |
694676 | 694676 | 2020-11-03 | Scott | Minnesota | 27139 | 4013 | 37 |
694677 | 694677 | 2020-11-03 | Sherburne | Minnesota | 27141 | 2140 | 24 |
694678 | 694678 | 2020-11-03 | Sibley | Minnesota | 27143 | 295 | 3 |
694679 | 694679 | 2020-11-03 | St. Louis | Minnesota | 27137 | 3618 | 75 |
694680 | 694680 | 2020-11-03 | Stearns | Minnesota | 27145 | 6946 | 53 |
694681 | 694681 | 2020-11-03 | Steele | Minnesota | 27147 | 874 | 4 |
694682 | 694682 | 2020-11-03 | Stevens | Minnesota | 27149 | 211 | 1 |
694683 | 694683 | 2020-11-03 | Swift | Minnesota | 27151 | 256 | 2 |
694684 | 694684 | 2020-11-03 | Todd | Minnesota | 27153 | 1023 | 7 |
694685 | 694685 | 2020-11-03 | Traverse | Minnesota | 27155 | 63 | 0 |
694686 | 694686 | 2020-11-03 | Unknown | Minnesota | 298 | 54 | |
694687 | 694687 | 2020-11-03 | Wabasha | Minnesota | 27157 | 459 | 1 |
694688 | 694688 | 2020-11-03 | Wadena | Minnesota | 27159 | 318 | 4 |
694689 | 694689 | 2020-11-03 | Waseca | Minnesota | 27161 | 967 | 10 |
694690 | 694690 | 2020-11-03 | Washington | Minnesota | 27163 | 7340 | 75 |
694691 | 694691 | 2020-11-03 | Watonwan | Minnesota | 27165 | 602 | 4 |
694692 | 694692 | 2020-11-03 | Wilkin | Minnesota | 27167 | 155 | 4 |
694693 | 694693 | 2020-11-03 | Winona | Minnesota | 27169 | 1463 | 19 |
694694 | 694694 | 2020-11-03 | Wright | Minnesota | 27171 | 3145 | 16 |
694695 | 694695 | 2020-11-03 | Yellow Medicine | Minnesota | 27173 | 345 | 7 |
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);