ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-10-06" and state = "Michigan" 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 |
---|---|---|---|---|---|---|---|
1788616 | 1788616 | 2021-10-06 | Alcona | Michigan | 26001 | 970 | 39 |
1788617 | 1788617 | 2021-10-06 | Alger | Michigan | 26003 | 921 | 8 |
1788618 | 1788618 | 2021-10-06 | Allegan | Michigan | 26005 | 13617 | 180 |
1788619 | 1788619 | 2021-10-06 | Alpena | Michigan | 26007 | 2831 | 69 |
1788620 | 1788620 | 2021-10-06 | Antrim | Michigan | 26009 | 2097 | 35 |
1788621 | 1788621 | 2021-10-06 | Arenac | Michigan | 26011 | 1518 | 32 |
1788622 | 1788622 | 2021-10-06 | Baraga | Michigan | 26013 | 1188 | 46 |
1788623 | 1788623 | 2021-10-06 | Barry | Michigan | 26015 | 7207 | 77 |
1788624 | 1788624 | 2021-10-06 | Bay | Michigan | 26017 | 13502 | 373 |
1788625 | 1788625 | 2021-10-06 | Benzie | Michigan | 26019 | 1532 | 38 |
1788626 | 1788626 | 2021-10-06 | Berrien | Michigan | 26021 | 18380 | 320 |
1788627 | 1788627 | 2021-10-06 | Branch | Michigan | 26023 | 6964 | 134 |
1788628 | 1788628 | 2021-10-06 | Calhoun | Michigan | 26025 | 17463 | 338 |
1788629 | 1788629 | 2021-10-06 | Cass | Michigan | 26027 | 6713 | 86 |
1788630 | 1788630 | 2021-10-06 | Charlevoix | Michigan | 26029 | 2255 | 29 |
1788631 | 1788631 | 2021-10-06 | Cheboygan | Michigan | 26031 | 2529 | 59 |
1788632 | 1788632 | 2021-10-06 | Chippewa | Michigan | 26033 | 6484 | 56 |
1788633 | 1788633 | 2021-10-06 | Clare | Michigan | 26035 | 3249 | 94 |
1788634 | 1788634 | 2021-10-06 | Clinton | Michigan | 26037 | 9195 | 103 |
1788635 | 1788635 | 2021-10-06 | Crawford | Michigan | 26039 | 1180 | 16 |
1788636 | 1788636 | 2021-10-06 | Delta | Michigan | 26041 | 5317 | 102 |
1788637 | 1788637 | 2021-10-06 | Dickinson | Michigan | 26043 | 3681 | 77 |
1788638 | 1788638 | 2021-10-06 | Eaton | Michigan | 26045 | 12224 | 232 |
1788639 | 1788639 | 2021-10-06 | Emmet | Michigan | 26047 | 3083 | 48 |
1788640 | 1788640 | 2021-10-06 | Genesee | Michigan | 26049 | 48353 | 1040 |
1788641 | 1788641 | 2021-10-06 | Gladwin | Michigan | 26051 | 2963 | 66 |
1788642 | 1788642 | 2021-10-06 | Gogebic | Michigan | 26053 | 1668 | 53 |
1788643 | 1788643 | 2021-10-06 | Grand Traverse | Michigan | 26055 | 8172 | 112 |
1788644 | 1788644 | 2021-10-06 | Gratiot | Michigan | 26057 | 7979 | 128 |
1788645 | 1788645 | 2021-10-06 | Hillsdale | Michigan | 26059 | 5676 | 113 |
1788646 | 1788646 | 2021-10-06 | Houghton | Michigan | 26061 | 3649 | 53 |
1788647 | 1788647 | 2021-10-06 | Huron | Michigan | 26063 | 4542 | 88 |
1788648 | 1788648 | 2021-10-06 | Ingham | Michigan | 26065 | 29166 | 435 |
1788649 | 1788649 | 2021-10-06 | Ionia | Michigan | 26067 | 10990 | 94 |
1788650 | 1788650 | 2021-10-06 | Iosco | Michigan | 26069 | 2653 | 87 |
1788651 | 1788651 | 2021-10-06 | Iron | Michigan | 26071 | 1303 | 54 |
1788652 | 1788652 | 2021-10-06 | Isabella | Michigan | 26073 | 8102 | 108 |
1788653 | 1788653 | 2021-10-06 | Jackson | Michigan | 26075 | 24249 | 348 |
1788654 | 1788654 | 2021-10-06 | Kalamazoo | Michigan | 26077 | 27837 | 439 |
1788655 | 1788655 | 2021-10-06 | Kalkaska | Michigan | 26079 | 1569 | 31 |
1788656 | 1788656 | 2021-10-06 | Kent | Michigan | 26081 | 87060 | 949 |
1788657 | 1788657 | 2021-10-06 | Keweenaw | Michigan | 26083 | 223 | 4 |
1788658 | 1788658 | 2021-10-06 | Lake | Michigan | 26085 | 847 | 19 |
1788659 | 1788659 | 2021-10-06 | Lapeer | Michigan | 26087 | 11304 | 238 |
1788660 | 1788660 | 2021-10-06 | Leelanau | Michigan | 26089 | 1536 | 24 |
1788661 | 1788661 | 2021-10-06 | Lenawee | Michigan | 26091 | 13303 | 195 |
1788662 | 1788662 | 2021-10-06 | Livingston | Michigan | 26093 | 21011 | 222 |
1788663 | 1788663 | 2021-10-06 | Luce | Michigan | 26095 | 1496 | 6 |
1788664 | 1788664 | 2021-10-06 | Mackinac | Michigan | 26097 | 1113 | 7 |
1788665 | 1788665 | 2021-10-06 | Macomb | Michigan | 26099 | 115080 | 2618 |
1788666 | 1788666 | 2021-10-06 | Manistee | Michigan | 26101 | 2338 | 33 |
1788667 | 1788667 | 2021-10-06 | Marquette | Michigan | 26103 | 7359 | 72 |
1788668 | 1788668 | 2021-10-06 | Mason | Michigan | 26105 | 2822 | 44 |
1788669 | 1788669 | 2021-10-06 | Mecosta | Michigan | 26107 | 4163 | 41 |
1788670 | 1788670 | 2021-10-06 | Menominee | Michigan | 26109 | 3037 | 48 |
1788671 | 1788671 | 2021-10-06 | Midland | Michigan | 26111 | 9369 | 120 |
1788672 | 1788672 | 2021-10-06 | Missaukee | Michigan | 26113 | 1743 | 30 |
1788673 | 1788673 | 2021-10-06 | Monroe | Michigan | 26115 | 18696 | 293 |
1788674 | 1788674 | 2021-10-06 | Montcalm | Michigan | 26117 | 9715 | 128 |
1788675 | 1788675 | 2021-10-06 | Montmorency | Michigan | 26119 | 809 | 24 |
1788676 | 1788676 | 2021-10-06 | Muskegon | Michigan | 26121 | 21872 | 414 |
1788677 | 1788677 | 2021-10-06 | Newaygo | Michigan | 26123 | 6026 | 75 |
1788678 | 1788678 | 2021-10-06 | Oakland | Michigan | 26125 | 138141 | 2608 |
1788679 | 1788679 | 2021-10-06 | Oceana | Michigan | 26127 | 3424 | 66 |
1788680 | 1788680 | 2021-10-06 | Ogemaw | Michigan | 26129 | 2390 | 48 |
1788681 | 1788681 | 2021-10-06 | Ontonagon | Michigan | 26131 | 578 | 22 |
1788682 | 1788682 | 2021-10-06 | Osceola | Michigan | 26133 | 2585 | 34 |
1788683 | 1788683 | 2021-10-06 | Oscoda | Michigan | 26135 | 852 | 32 |
1788684 | 1788684 | 2021-10-06 | Otsego | Michigan | 26137 | 2938 | 48 |
1788685 | 1788685 | 2021-10-06 | Ottawa | Michigan | 26139 | 38700 | 479 |
1788686 | 1788686 | 2021-10-06 | Presque Isle | Michigan | 26141 | 1266 | 35 |
1788687 | 1788687 | 2021-10-06 | Roscommon | Michigan | 26143 | 2210 | 61 |
1788688 | 1788688 | 2021-10-06 | Saginaw | Michigan | 26145 | 26470 | 664 |
1788689 | 1788689 | 2021-10-06 | Sanilac | Michigan | 26151 | 4683 | 131 |
1788690 | 1788690 | 2021-10-06 | Schoolcraft | Michigan | 26153 | 692 | 5 |
1788691 | 1788691 | 2021-10-06 | Shiawassee | Michigan | 26155 | 7929 | 121 |
1788692 | 1788692 | 2021-10-06 | St. Clair | Michigan | 26147 | 21038 | 495 |
1788693 | 1788693 | 2021-10-06 | St. Joseph | Michigan | 26149 | 7747 | 113 |
1788694 | 1788694 | 2021-10-06 | Tuscola | Michigan | 26157 | 6834 | 186 |
1788695 | 1788695 | 2021-10-06 | Unknown | Michigan | 1008 | 15 | |
1788696 | 1788696 | 2021-10-06 | Van Buren | Michigan | 26159 | 8633 | 154 |
1788697 | 1788697 | 2021-10-06 | Washtenaw | Michigan | 26161 | 31886 | 325 |
1788698 | 1788698 | 2021-10-06 | Wayne | Michigan | 26163 | 189458 | 5453 |
1788699 | 1788699 | 2021-10-06 | Wexford | Michigan | 26165 | 3334 | 51 |
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);