ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2021-03-18 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1132654 | 1132654 | 2021-03-18 | Alcona | Michigan | 26001 | 440 | 25 |
1132655 | 1132655 | 2021-03-18 | Alger | Michigan | 26003 | 587 | 5 |
1132656 | 1132656 | 2021-03-18 | Allegan | Michigan | 26005 | 7679 | 118 |
1132657 | 1132657 | 2021-03-18 | Alpena | Michigan | 26007 | 1524 | 48 |
1132658 | 1132658 | 2021-03-18 | Antrim | Michigan | 26009 | 1055 | 20 |
1132659 | 1132659 | 2021-03-18 | Arenac | Michigan | 26011 | 772 | 26 |
1132660 | 1132660 | 2021-03-18 | Baraga | Michigan | 26013 | 786 | 34 |
1132661 | 1132661 | 2021-03-18 | Barry | Michigan | 26015 | 3938 | 49 |
1132662 | 1132662 | 2021-03-18 | Bay | Michigan | 26017 | 7784 | 298 |
1132663 | 1132663 | 2021-03-18 | Benzie | Michigan | 26019 | 958 | 32 |
1132664 | 1132664 | 2021-03-18 | Berrien | Michigan | 26021 | 12113 | 247 |
1132665 | 1132665 | 2021-03-18 | Branch | Michigan | 26023 | 4722 | 111 |
1132666 | 1132666 | 2021-03-18 | Calhoun | Michigan | 26025 | 10373 | 240 |
1132667 | 1132667 | 2021-03-18 | Cass | Michigan | 26027 | 4288 | 67 |
1132668 | 1132668 | 2021-03-18 | Charlevoix | Michigan | 26029 | 1121 | 13 |
1132669 | 1132669 | 2021-03-18 | Cheboygan | Michigan | 26031 | 1131 | 38 |
1132670 | 1132670 | 2021-03-18 | Chippewa | Michigan | 26033 | 4936 | 44 |
1132671 | 1132671 | 2021-03-18 | Clare | Michigan | 26035 | 1642 | 69 |
1132672 | 1132672 | 2021-03-18 | Clinton | Michigan | 26037 | 5399 | 72 |
1132673 | 1132673 | 2021-03-18 | Crawford | Michigan | 26039 | 635 | 5 |
1132674 | 1132674 | 2021-03-18 | Delta | Michigan | 26041 | 3210 | 85 |
1132675 | 1132675 | 2021-03-18 | Dickinson | Michigan | 26043 | 2399 | 71 |
1132676 | 1132676 | 2021-03-18 | Eaton | Michigan | 26045 | 6728 | 159 |
1132677 | 1132677 | 2021-03-18 | Emmet | Michigan | 26047 | 1593 | 39 |
1132678 | 1132678 | 2021-03-18 | Genesee | Michigan | 26049 | 27421 | 766 |
1132679 | 1132679 | 2021-03-18 | Gladwin | Michigan | 26051 | 1522 | 43 |
1132680 | 1132680 | 2021-03-18 | Gogebic | Michigan | 26053 | 1303 | 49 |
1132681 | 1132681 | 2021-03-18 | Grand Traverse | Michigan | 26055 | 4634 | 74 |
1132682 | 1132682 | 2021-03-18 | Gratiot | Michigan | 26057 | 5720 | 108 |
1132683 | 1132683 | 2021-03-18 | Hillsdale | Michigan | 26059 | 3495 | 77 |
1132684 | 1132684 | 2021-03-18 | Houghton | Michigan | 26061 | 2736 | 39 |
1132685 | 1132685 | 2021-03-18 | Huron | Michigan | 26063 | 2491 | 61 |
1132686 | 1132686 | 2021-03-18 | Ingham | Michigan | 26065 | 17518 | 290 |
1132687 | 1132687 | 2021-03-18 | Ionia | Michigan | 26067 | 7281 | 79 |
1132688 | 1132688 | 2021-03-18 | Iosco | Michigan | 26069 | 1304 | 67 |
1132689 | 1132689 | 2021-03-18 | Iron | Michigan | 26071 | 928 | 50 |
1132690 | 1132690 | 2021-03-18 | Isabella | Michigan | 26073 | 4162 | 74 |
1132691 | 1132691 | 2021-03-18 | Jackson | Michigan | 26075 | 15124 | 258 |
1132692 | 1132692 | 2021-03-18 | Kalamazoo | Michigan | 26077 | 15943 | 325 |
1132693 | 1132693 | 2021-03-18 | Kalkaska | Michigan | 26079 | 685 | 15 |
1132694 | 1132694 | 2021-03-18 | Kent | Michigan | 26081 | 53591 | 724 |
1132695 | 1132695 | 2021-03-18 | Keweenaw | Michigan | 26083 | 151 | 2 |
1132696 | 1132696 | 2021-03-18 | Lake | Michigan | 26085 | 390 | 11 |
1132697 | 1132697 | 2021-03-18 | Lapeer | Michigan | 26087 | 6051 | 134 |
1132698 | 1132698 | 2021-03-18 | Leelanau | Michigan | 26089 | 933 | 15 |
1132699 | 1132699 | 2021-03-18 | Lenawee | Michigan | 26091 | 8064 | 131 |
1132700 | 1132700 | 2021-03-18 | Livingston | Michigan | 26093 | 11168 | 152 |
1132701 | 1132701 | 2021-03-18 | Luce | Michigan | 26095 | 1097 | 2 |
1132702 | 1132702 | 2021-03-18 | Mackinac | Michigan | 26097 | 453 | 3 |
1132703 | 1132703 | 2021-03-18 | Macomb | Michigan | 26099 | 63886 | 2006 |
1132704 | 1132704 | 2021-03-18 | Manistee | Michigan | 26101 | 1579 | 23 |
1132705 | 1132705 | 2021-03-18 | Marquette | Michigan | 26103 | 4903 | 57 |
1132706 | 1132706 | 2021-03-18 | Mason | Michigan | 26105 | 1281 | 27 |
1132707 | 1132707 | 2021-03-18 | Mecosta | Michigan | 26107 | 2090 | 21 |
1132708 | 1132708 | 2021-03-18 | Menominee | Michigan | 26109 | 1906 | 40 |
1132709 | 1132709 | 2021-03-18 | Midland | Michigan | 26111 | 5259 | 66 |
1132710 | 1132710 | 2021-03-18 | Missaukee | Michigan | 26113 | 936 | 18 |
1132711 | 1132711 | 2021-03-18 | Monroe | Michigan | 26115 | 10595 | 209 |
1132712 | 1132712 | 2021-03-18 | Montcalm | Michigan | 26117 | 5758 | 96 |
1132713 | 1132713 | 2021-03-18 | Montmorency | Michigan | 26119 | 374 | 18 |
1132714 | 1132714 | 2021-03-18 | Muskegon | Michigan | 26121 | 12907 | 318 |
1132715 | 1132715 | 2021-03-18 | Newaygo | Michigan | 26123 | 3114 | 53 |
1132716 | 1132716 | 2021-03-18 | Oakland | Michigan | 26125 | 79397 | 2036 |
1132717 | 1132717 | 2021-03-18 | Oceana | Michigan | 26127 | 1924 | 50 |
1132718 | 1132718 | 2021-03-18 | Ogemaw | Michigan | 26129 | 1140 | 34 |
1132719 | 1132719 | 2021-03-18 | Ontonagon | Michigan | 26131 | 423 | 21 |
1132720 | 1132720 | 2021-03-18 | Osceola | Michigan | 26133 | 1139 | 23 |
1132721 | 1132721 | 2021-03-18 | Oscoda | Michigan | 26135 | 409 | 20 |
1132722 | 1132722 | 2021-03-18 | Otsego | Michigan | 26137 | 1378 | 28 |
1132723 | 1132723 | 2021-03-18 | Ottawa | Michigan | 26139 | 23208 | 360 |
1132724 | 1132724 | 2021-03-18 | Presque Isle | Michigan | 26141 | 676 | 28 |
1132725 | 1132725 | 2021-03-18 | Roscommon | Michigan | 26143 | 1308 | 37 |
1132726 | 1132726 | 2021-03-18 | Saginaw | Michigan | 26145 | 16610 | 537 |
1132727 | 1132727 | 2021-03-18 | Sanilac | Michigan | 26151 | 2404 | 79 |
1132728 | 1132728 | 2021-03-18 | Schoolcraft | Michigan | 26153 | 271 | 5 |
1132729 | 1132729 | 2021-03-18 | Shiawassee | Michigan | 26155 | 4029 | 83 |
1132730 | 1132730 | 2021-03-18 | St. Clair | Michigan | 26147 | 9822 | 263 |
1132731 | 1132731 | 2021-03-18 | St. Joseph | Michigan | 26149 | 4964 | 87 |
1132732 | 1132732 | 2021-03-18 | Tuscola | Michigan | 26157 | 3500 | 139 |
1132733 | 1132733 | 2021-03-18 | Unknown | Michigan | 0 | 12 | |
1132734 | 1132734 | 2021-03-18 | Van Buren | Michigan | 26159 | 5214 | 98 |
1132735 | 1132735 | 2021-03-18 | Washtenaw | Michigan | 26161 | 20156 | 254 |
1132736 | 1132736 | 2021-03-18 | Wayne | Michigan | 26163 | 108045 | 4203 |
1132737 | 1132737 | 2021-03-18 | Wexford | Michigan | 26165 | 1739 | 22 |
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);