ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-04-27" 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 |
---|---|---|---|---|---|---|---|
2448710 | 2448710 | 2022-04-27 | Alcona | Michigan | 26001 | 1733 | 71 |
2448711 | 2448711 | 2022-04-27 | Alger | Michigan | 26003 | 1867 | 13 |
2448712 | 2448712 | 2022-04-27 | Allegan | Michigan | 26005 | 27205 | 347 |
2448713 | 2448713 | 2022-04-27 | Alpena | Michigan | 26007 | 5728 | 139 |
2448714 | 2448714 | 2022-04-27 | Antrim | Michigan | 26009 | 4373 | 65 |
2448715 | 2448715 | 2022-04-27 | Arenac | Michigan | 26011 | 3210 | 67 |
2448716 | 2448716 | 2022-04-27 | Baraga | Michigan | 26013 | 2213 | 54 |
2448717 | 2448717 | 2022-04-27 | Barry | Michigan | 26015 | 14391 | 167 |
2448718 | 2448718 | 2022-04-27 | Bay | Michigan | 26017 | 27154 | 582 |
2448719 | 2448719 | 2022-04-27 | Benzie | Michigan | 26019 | 3458 | 67 |
2448720 | 2448720 | 2022-04-27 | Berrien | Michigan | 26021 | 34962 | 555 |
2448721 | 2448721 | 2022-04-27 | Branch | Michigan | 26023 | 12194 | 206 |
2448722 | 2448722 | 2022-04-27 | Calhoun | Michigan | 26025 | 34477 | 573 |
2448723 | 2448723 | 2022-04-27 | Cass | Michigan | 26027 | 11134 | 144 |
2448724 | 2448724 | 2022-04-27 | Charlevoix | Michigan | 26029 | 4932 | 60 |
2448725 | 2448725 | 2022-04-27 | Cheboygan | Michigan | 26031 | 4618 | 103 |
2448726 | 2448726 | 2022-04-27 | Chippewa | Michigan | 26033 | 11670 | 120 |
2448727 | 2448727 | 2022-04-27 | Clare | Michigan | 26035 | 6762 | 157 |
2448728 | 2448728 | 2022-04-27 | Clinton | Michigan | 26037 | 21463 | 207 |
2448729 | 2448729 | 2022-04-27 | Crawford | Michigan | 26039 | 2585 | 31 |
2448730 | 2448730 | 2022-04-27 | Delta | Michigan | 26041 | 9951 | 157 |
2448731 | 2448731 | 2022-04-27 | Dickinson | Michigan | 26043 | 7412 | 108 |
2448732 | 2448732 | 2022-04-27 | Eaton | Michigan | 26045 | 27063 | 401 |
2448733 | 2448733 | 2022-04-27 | Emmet | Michigan | 26047 | 6443 | 86 |
2448734 | 2448734 | 2022-04-27 | Genesee | Michigan | 26049 | 102026 | 1715 |
2448735 | 2448735 | 2022-04-27 | Gladwin | Michigan | 26051 | 5580 | 114 |
2448736 | 2448736 | 2022-04-27 | Gogebic | Michigan | 26053 | 3270 | 69 |
2448737 | 2448737 | 2022-04-27 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2448738 | 2448738 | 2022-04-27 | Gratiot | Michigan | 26057 | 13722 | 192 |
2448739 | 2448739 | 2022-04-27 | Hillsdale | Michigan | 26059 | 10371 | 204 |
2448740 | 2448740 | 2022-04-27 | Houghton | Michigan | 26061 | 7867 | 92 |
2448741 | 2448741 | 2022-04-27 | Huron | Michigan | 26063 | 8034 | 145 |
2448742 | 2448742 | 2022-04-27 | Ingham | Michigan | 26065 | 64895 | 765 |
2448743 | 2448743 | 2022-04-27 | Ionia | Michigan | 26067 | 19643 | 181 |
2448744 | 2448744 | 2022-04-27 | Iosco | Michigan | 26069 | 4814 | 143 |
2448745 | 2448745 | 2022-04-27 | Iron | Michigan | 26071 | 2653 | 87 |
2448746 | 2448746 | 2022-04-27 | Isabella | Michigan | 26073 | 15632 | 208 |
2448747 | 2448747 | 2022-04-27 | Jackson | Michigan | 26075 | 44948 | 588 |
2448748 | 2448748 | 2022-04-27 | Kalamazoo | Michigan | 26077 | 59847 | 673 |
2448749 | 2448749 | 2022-04-27 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2448750 | 2448750 | 2022-04-27 | Kent | Michigan | 26081 | 167891 | 1531 |
2448751 | 2448751 | 2022-04-27 | Keweenaw | Michigan | 26083 | 515 | 14 |
2448752 | 2448752 | 2022-04-27 | Lake | Michigan | 26085 | 1850 | 37 |
2448753 | 2448753 | 2022-04-27 | Lapeer | Michigan | 26087 | 20909 | 427 |
2448754 | 2448754 | 2022-04-27 | Leelanau | Michigan | 26089 | 3620 | 54 |
2448755 | 2448755 | 2022-04-27 | Lenawee | Michigan | 26091 | 26146 | 330 |
2448756 | 2448756 | 2022-04-27 | Livingston | Michigan | 26093 | 46705 | 450 |
2448757 | 2448757 | 2022-04-27 | Luce | Michigan | 26095 | 2292 | 14 |
2448758 | 2448758 | 2022-04-27 | Mackinac | Michigan | 26097 | 2421 | 31 |
2448759 | 2448759 | 2022-04-27 | Macomb | Michigan | 26099 | 233892 | 3961 |
2448760 | 2448760 | 2022-04-27 | Manistee | Michigan | 26101 | 4485 | 90 |
2448761 | 2448761 | 2022-04-27 | Marquette | Michigan | 26103 | 15951 | 130 |
2448762 | 2448762 | 2022-04-27 | Mason | Michigan | 26105 | 6793 | 95 |
2448763 | 2448763 | 2022-04-27 | Mecosta | Michigan | 26107 | 8699 | 106 |
2448764 | 2448764 | 2022-04-27 | Menominee | Michigan | 26109 | 5638 | 70 |
2448765 | 2448765 | 2022-04-27 | Midland | Michigan | 26111 | 19157 | 225 |
2448766 | 2448766 | 2022-04-27 | Missaukee | Michigan | 26113 | 2917 | 60 |
2448767 | 2448767 | 2022-04-27 | Monroe | Michigan | 26115 | 38305 | 473 |
2448768 | 2448768 | 2022-04-27 | Montcalm | Michigan | 26117 | 17219 | 216 |
2448769 | 2448769 | 2022-04-27 | Montmorency | Michigan | 26119 | 1732 | 48 |
2448770 | 2448770 | 2022-04-27 | Muskegon | Michigan | 26121 | 42067 | 649 |
2448771 | 2448771 | 2022-04-27 | Newaygo | Michigan | 26123 | 11514 | 158 |
2448772 | 2448772 | 2022-04-27 | Oakland | Michigan | 26125 | 292717 | 3837 |
2448773 | 2448773 | 2022-04-27 | Oceana | Michigan | 26127 | 6359 | 90 |
2448774 | 2448774 | 2022-04-27 | Ogemaw | Michigan | 26129 | 4321 | 106 |
2448775 | 2448775 | 2022-04-27 | Ontonagon | Michigan | 26131 | 996 | 38 |
2448776 | 2448776 | 2022-04-27 | Osceola | Michigan | 26133 | 5022 | 80 |
2448777 | 2448777 | 2022-04-27 | Oscoda | Michigan | 26135 | 1437 | 55 |
2448778 | 2448778 | 2022-04-27 | Otsego | Michigan | 26137 | 5666 | 100 |
2448779 | 2448779 | 2022-04-27 | Ottawa | Michigan | 26139 | 75339 | 782 |
2448780 | 2448780 | 2022-04-27 | Presque Isle | Michigan | 26141 | 2070 | 58 |
2448781 | 2448781 | 2022-04-27 | Roscommon | Michigan | 26143 | 4635 | 114 |
2448782 | 2448782 | 2022-04-27 | Saginaw | Michigan | 26145 | 50629 | 951 |
2448783 | 2448783 | 2022-04-27 | Sanilac | Michigan | 26151 | 8738 | 192 |
2448784 | 2448784 | 2022-04-27 | Schoolcraft | Michigan | 26153 | 1746 | 16 |
2448785 | 2448785 | 2022-04-27 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2448786 | 2448786 | 2022-04-27 | St. Clair | Michigan | 26147 | 40987 | 834 |
2448787 | 2448787 | 2022-04-27 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2448788 | 2448788 | 2022-04-27 | Tuscola | Michigan | 26157 | 13239 | 277 |
2448789 | 2448789 | 2022-04-27 | Unknown | Michigan | 12263 | 39 | |
2448790 | 2448790 | 2022-04-27 | Van Buren | Michigan | 26159 | 17155 | 270 |
2448791 | 2448791 | 2022-04-27 | Washtenaw | Michigan | 26161 | 79220 | 517 |
2448792 | 2448792 | 2022-04-27 | Wayne | Michigan | 26163 | 406822 | 7942 |
2448793 | 2448793 | 2022-04-27 | Wexford | Michigan | 26165 | 7106 | 106 |
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);