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 2022-02-15 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217725 | 2217725 | 2022-02-15 | Alcona | Michigan | 26001 | 1675 | 67 |
2217726 | 2217726 | 2022-02-15 | Alger | Michigan | 26003 | 1822 | 13 |
2217727 | 2217727 | 2022-02-15 | Allegan | Michigan | 26005 | 26555 | 324 |
2217728 | 2217728 | 2022-02-15 | Alpena | Michigan | 26007 | 5402 | 127 |
2217729 | 2217729 | 2022-02-15 | Antrim | Michigan | 26009 | 4194 | 57 |
2217730 | 2217730 | 2022-02-15 | Arenac | Michigan | 26011 | 3128 | 62 |
2217731 | 2217731 | 2022-02-15 | Baraga | Michigan | 26013 | 2159 | 54 |
2217732 | 2217732 | 2022-02-15 | Barry | Michigan | 26015 | 14024 | 155 |
2217733 | 2217733 | 2022-02-15 | Bay | Michigan | 26017 | 26529 | 551 |
2217734 | 2217734 | 2022-02-15 | Benzie | Michigan | 26019 | 3352 | 63 |
2217735 | 2217735 | 2022-02-15 | Berrien | Michigan | 26021 | 34146 | 498 |
2217736 | 2217736 | 2022-02-15 | Branch | Michigan | 26023 | 11965 | 187 |
2217737 | 2217737 | 2022-02-15 | Calhoun | Michigan | 26025 | 33213 | 538 |
2217738 | 2217738 | 2022-02-15 | Cass | Michigan | 26027 | 10949 | 128 |
2217739 | 2217739 | 2022-02-15 | Charlevoix | Michigan | 26029 | 4827 | 56 |
2217740 | 2217740 | 2022-02-15 | Cheboygan | Michigan | 26031 | 4505 | 93 |
2217741 | 2217741 | 2022-02-15 | Chippewa | Michigan | 26033 | 11285 | 105 |
2217742 | 2217742 | 2022-02-15 | Clare | Michigan | 26035 | 6583 | 150 |
2217743 | 2217743 | 2022-02-15 | Clinton | Michigan | 26037 | 20414 | 192 |
2217744 | 2217744 | 2022-02-15 | Crawford | Michigan | 26039 | 2481 | 26 |
2217745 | 2217745 | 2022-02-15 | Delta | Michigan | 26041 | 9771 | 148 |
2217746 | 2217746 | 2022-02-15 | Dickinson | Michigan | 26043 | 7271 | 102 |
2217747 | 2217747 | 2022-02-15 | Eaton | Michigan | 26045 | 25947 | 370 |
2217748 | 2217748 | 2022-02-15 | Emmet | Michigan | 26047 | 6255 | 74 |
2217749 | 2217749 | 2022-02-15 | Genesee | Michigan | 26049 | 98829 | 1605 |
2217750 | 2217750 | 2022-02-15 | Gladwin | Michigan | 26051 | 5474 | 106 |
2217751 | 2217751 | 2022-02-15 | Gogebic | Michigan | 26053 | 3196 | 65 |
2217752 | 2217752 | 2022-02-15 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2217753 | 2217753 | 2022-02-15 | Gratiot | Michigan | 26057 | 13310 | 177 |
2217754 | 2217754 | 2022-02-15 | Hillsdale | Michigan | 26059 | 10156 | 184 |
2217755 | 2217755 | 2022-02-15 | Houghton | Michigan | 26061 | 7600 | 88 |
2217756 | 2217756 | 2022-02-15 | Huron | Michigan | 26063 | 7928 | 141 |
2217757 | 2217757 | 2022-02-15 | Ingham | Michigan | 26065 | 62181 | 693 |
2217758 | 2217758 | 2022-02-15 | Ionia | Michigan | 26067 | 19125 | 170 |
2217759 | 2217759 | 2022-02-15 | Iosco | Michigan | 26069 | 4665 | 129 |
2217760 | 2217760 | 2022-02-15 | Iron | Michigan | 26071 | 2593 | 81 |
2217761 | 2217761 | 2022-02-15 | Isabella | Michigan | 26073 | 15238 | 188 |
2217762 | 2217762 | 2022-02-15 | Jackson | Michigan | 26075 | 43894 | 538 |
2217763 | 2217763 | 2022-02-15 | Kalamazoo | Michigan | 26077 | 57079 | 625 |
2217764 | 2217764 | 2022-02-15 | Kalkaska | Michigan | 26079 | 3439 | 53 |
2217765 | 2217765 | 2022-02-15 | Kent | Michigan | 26081 | 162888 | 1430 |
2217766 | 2217766 | 2022-02-15 | Keweenaw | Michigan | 26083 | 496 | 12 |
2217767 | 2217767 | 2022-02-15 | Lake | Michigan | 26085 | 1788 | 34 |
2217768 | 2217768 | 2022-02-15 | Lapeer | Michigan | 26087 | 20440 | 402 |
2217769 | 2217769 | 2022-02-15 | Leelanau | Michigan | 26089 | 3473 | 47 |
2217770 | 2217770 | 2022-02-15 | Lenawee | Michigan | 26091 | 25440 | 304 |
2217771 | 2217771 | 2022-02-15 | Livingston | Michigan | 26093 | 44755 | 418 |
2217772 | 2217772 | 2022-02-15 | Luce | Michigan | 26095 | 2238 | 9 |
2217773 | 2217773 | 2022-02-15 | Mackinac | Michigan | 26097 | 2314 | 27 |
2217774 | 2217774 | 2022-02-15 | Macomb | Michigan | 26099 | 222512 | 3699 |
2217775 | 2217775 | 2022-02-15 | Manistee | Michigan | 26101 | 4323 | 79 |
2217776 | 2217776 | 2022-02-15 | Marquette | Michigan | 26103 | 15419 | 114 |
2217777 | 2217777 | 2022-02-15 | Mason | Michigan | 26105 | 6454 | 82 |
2217778 | 2217778 | 2022-02-15 | Mecosta | Michigan | 26107 | 8459 | 96 |
2217779 | 2217779 | 2022-02-15 | Menominee | Michigan | 26109 | 5448 | 68 |
2217780 | 2217780 | 2022-02-15 | Midland | Michigan | 26111 | 18638 | 211 |
2217781 | 2217781 | 2022-02-15 | Missaukee | Michigan | 26113 | 2842 | 57 |
2217782 | 2217782 | 2022-02-15 | Monroe | Michigan | 26115 | 37214 | 442 |
2217783 | 2217783 | 2022-02-15 | Montcalm | Michigan | 26117 | 16839 | 199 |
2217784 | 2217784 | 2022-02-15 | Montmorency | Michigan | 26119 | 1679 | 46 |
2217785 | 2217785 | 2022-02-15 | Muskegon | Michigan | 26121 | 40841 | 604 |
2217786 | 2217786 | 2022-02-15 | Newaygo | Michigan | 26123 | 11245 | 150 |
2217787 | 2217787 | 2022-02-15 | Oakland | Michigan | 26125 | 278626 | 3589 |
2217788 | 2217788 | 2022-02-15 | Oceana | Michigan | 26127 | 6154 | 87 |
2217789 | 2217789 | 2022-02-15 | Ogemaw | Michigan | 26129 | 4235 | 91 |
2217790 | 2217790 | 2022-02-15 | Ontonagon | Michigan | 26131 | 954 | 35 |
2217791 | 2217791 | 2022-02-15 | Osceola | Michigan | 26133 | 4877 | 71 |
2217792 | 2217792 | 2022-02-15 | Oscoda | Michigan | 26135 | 1415 | 53 |
2217793 | 2217793 | 2022-02-15 | Otsego | Michigan | 26137 | 5448 | 94 |
2217794 | 2217794 | 2022-02-15 | Ottawa | Michigan | 26139 | 73264 | 754 |
2217795 | 2217795 | 2022-02-15 | Presque Isle | Michigan | 26141 | 2041 | 55 |
2217796 | 2217796 | 2022-02-15 | Roscommon | Michigan | 26143 | 4509 | 109 |
2217797 | 2217797 | 2022-02-15 | Saginaw | Michigan | 26145 | 49321 | 888 |
2217798 | 2217798 | 2022-02-15 | Sanilac | Michigan | 26151 | 8515 | 177 |
2217799 | 2217799 | 2022-02-15 | Schoolcraft | Michigan | 26153 | 1706 | 13 |
2217800 | 2217800 | 2022-02-15 | Shiawassee | Michigan | 26155 | 17374 | 215 |
2217801 | 2217801 | 2022-02-15 | St. Clair | Michigan | 26147 | 39656 | 782 |
2217802 | 2217802 | 2022-02-15 | St. Joseph | Michigan | 26149 | 13453 | 189 |
2217803 | 2217803 | 2022-02-15 | Tuscola | Michigan | 26157 | 13005 | 267 |
2217804 | 2217804 | 2022-02-15 | Unknown | Michigan | 11162 | 28 | |
2217805 | 2217805 | 2022-02-15 | Van Buren | Michigan | 26159 | 16647 | 248 |
2217806 | 2217806 | 2022-02-15 | Washtenaw | Michigan | 26161 | 71877 | 496 |
2217807 | 2217807 | 2022-02-15 | Wayne | Michigan | 26163 | 388830 | 7422 |
2217808 | 2217808 | 2022-02-15 | Wexford | Michigan | 26165 | 6855 | 100 |
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);