ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-02-23" 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 |
---|---|---|---|---|---|---|---|
2243733 | 2243733 | 2022-02-23 | Alcona | Michigan | 26001 | 1699 | 67 |
2243734 | 2243734 | 2022-02-23 | Alger | Michigan | 26003 | 1835 | 13 |
2243735 | 2243735 | 2022-02-23 | Allegan | Michigan | 26005 | 26753 | 329 |
2243736 | 2243736 | 2022-02-23 | Alpena | Michigan | 26007 | 5487 | 132 |
2243737 | 2243737 | 2022-02-23 | Antrim | Michigan | 26009 | 4242 | 58 |
2243738 | 2243738 | 2022-02-23 | Arenac | Michigan | 26011 | 3161 | 62 |
2243739 | 2243739 | 2022-02-23 | Baraga | Michigan | 26013 | 2182 | 54 |
2243740 | 2243740 | 2022-02-23 | Barry | Michigan | 26015 | 14116 | 158 |
2243741 | 2243741 | 2022-02-23 | Bay | Michigan | 26017 | 26744 | 561 |
2243742 | 2243742 | 2022-02-23 | Benzie | Michigan | 26019 | 3379 | 64 |
2243743 | 2243743 | 2022-02-23 | Berrien | Michigan | 26021 | 34314 | 517 |
2243744 | 2243744 | 2022-02-23 | Branch | Michigan | 26023 | 12035 | 193 |
2243745 | 2243745 | 2022-02-23 | Calhoun | Michigan | 26025 | 33484 | 547 |
2243746 | 2243746 | 2022-02-23 | Cass | Michigan | 26027 | 11012 | 134 |
2243747 | 2243747 | 2022-02-23 | Charlevoix | Michigan | 26029 | 4854 | 58 |
2243748 | 2243748 | 2022-02-23 | Cheboygan | Michigan | 26031 | 4533 | 99 |
2243749 | 2243749 | 2022-02-23 | Chippewa | Michigan | 26033 | 11408 | 110 |
2243750 | 2243750 | 2022-02-23 | Clare | Michigan | 26035 | 6655 | 153 |
2243751 | 2243751 | 2022-02-23 | Clinton | Michigan | 26037 | 20690 | 195 |
2243752 | 2243752 | 2022-02-23 | Crawford | Michigan | 26039 | 2511 | 29 |
2243753 | 2243753 | 2022-02-23 | Delta | Michigan | 26041 | 9850 | 153 |
2243754 | 2243754 | 2022-02-23 | Dickinson | Michigan | 26043 | 7329 | 106 |
2243755 | 2243755 | 2022-02-23 | Eaton | Michigan | 26045 | 26162 | 382 |
2243756 | 2243756 | 2022-02-23 | Emmet | Michigan | 26047 | 6293 | 80 |
2243757 | 2243757 | 2022-02-23 | Genesee | Michigan | 26049 | 99738 | 1646 |
2243758 | 2243758 | 2022-02-23 | Gladwin | Michigan | 26051 | 5525 | 107 |
2243759 | 2243759 | 2022-02-23 | Gogebic | Michigan | 26053 | 3225 | 67 |
2243760 | 2243760 | 2022-02-23 | Grand Traverse | Michigan | 26055 | 16869 | 212 |
2243761 | 2243761 | 2022-02-23 | Gratiot | Michigan | 26057 | 13444 | 180 |
2243762 | 2243762 | 2022-02-23 | Hillsdale | Michigan | 26059 | 10231 | 189 |
2243763 | 2243763 | 2022-02-23 | Houghton | Michigan | 26061 | 7670 | 88 |
2243764 | 2243764 | 2022-02-23 | Huron | Michigan | 26063 | 7976 | 143 |
2243765 | 2243765 | 2022-02-23 | Ingham | Michigan | 26065 | 62755 | 716 |
2243766 | 2243766 | 2022-02-23 | Ionia | Michigan | 26067 | 19289 | 172 |
2243767 | 2243767 | 2022-02-23 | Iosco | Michigan | 26069 | 4741 | 133 |
2243768 | 2243768 | 2022-02-23 | Iron | Michigan | 26071 | 2620 | 83 |
2243769 | 2243769 | 2022-02-23 | Isabella | Michigan | 26073 | 15393 | 194 |
2243770 | 2243770 | 2022-02-23 | Jackson | Michigan | 26075 | 44169 | 551 |
2243771 | 2243771 | 2022-02-23 | Kalamazoo | Michigan | 26077 | 57563 | 643 |
2243772 | 2243772 | 2022-02-23 | Kalkaska | Michigan | 26079 | 3473 | 53 |
2243773 | 2243773 | 2022-02-23 | Kent | Michigan | 26081 | 163945 | 1462 |
2243774 | 2243774 | 2022-02-23 | Keweenaw | Michigan | 26083 | 503 | 13 |
2243775 | 2243775 | 2022-02-23 | Lake | Michigan | 26085 | 1813 | 35 |
2243776 | 2243776 | 2022-02-23 | Lapeer | Michigan | 26087 | 20583 | 410 |
2243777 | 2243777 | 2022-02-23 | Leelanau | Michigan | 26089 | 3513 | 50 |
2243778 | 2243778 | 2022-02-23 | Lenawee | Michigan | 26091 | 25627 | 314 |
2243779 | 2243779 | 2022-02-23 | Livingston | Michigan | 26093 | 45174 | 430 |
2243780 | 2243780 | 2022-02-23 | Luce | Michigan | 26095 | 2258 | 10 |
2243781 | 2243781 | 2022-02-23 | Mackinac | Michigan | 26097 | 2349 | 28 |
2243782 | 2243782 | 2022-02-23 | Macomb | Michigan | 26099 | 224132 | 3796 |
2243783 | 2243783 | 2022-02-23 | Manistee | Michigan | 26101 | 4388 | 82 |
2243784 | 2243784 | 2022-02-23 | Marquette | Michigan | 26103 | 15608 | 119 |
2243785 | 2243785 | 2022-02-23 | Mason | Michigan | 26105 | 6566 | 86 |
2243786 | 2243786 | 2022-02-23 | Mecosta | Michigan | 26107 | 8540 | 102 |
2243787 | 2243787 | 2022-02-23 | Menominee | Michigan | 26109 | 5520 | 69 |
2243788 | 2243788 | 2022-02-23 | Midland | Michigan | 26111 | 18823 | 218 |
2243789 | 2243789 | 2022-02-23 | Missaukee | Michigan | 26113 | 2869 | 58 |
2243790 | 2243790 | 2022-02-23 | Monroe | Michigan | 26115 | 37466 | 449 |
2243791 | 2243791 | 2022-02-23 | Montcalm | Michigan | 26117 | 16991 | 204 |
2243792 | 2243792 | 2022-02-23 | Montmorency | Michigan | 26119 | 1691 | 46 |
2243793 | 2243793 | 2022-02-23 | Muskegon | Michigan | 26121 | 41219 | 620 |
2243794 | 2243794 | 2022-02-23 | Newaygo | Michigan | 26123 | 11327 | 153 |
2243795 | 2243795 | 2022-02-23 | Oakland | Michigan | 26125 | 281057 | 3672 |
2243796 | 2243796 | 2022-02-23 | Oceana | Michigan | 26127 | 6221 | 89 |
2243797 | 2243797 | 2022-02-23 | Ogemaw | Michigan | 26129 | 4275 | 98 |
2243798 | 2243798 | 2022-02-23 | Ontonagon | Michigan | 26131 | 966 | 36 |
2243799 | 2243799 | 2022-02-23 | Osceola | Michigan | 26133 | 4924 | 76 |
2243800 | 2243800 | 2022-02-23 | Oscoda | Michigan | 26135 | 1422 | 53 |
2243801 | 2243801 | 2022-02-23 | Otsego | Michigan | 26137 | 5524 | 96 |
2243802 | 2243802 | 2022-02-23 | Ottawa | Michigan | 26139 | 73808 | 768 |
2243803 | 2243803 | 2022-02-23 | Presque Isle | Michigan | 26141 | 2053 | 55 |
2243804 | 2243804 | 2022-02-23 | Roscommon | Michigan | 26143 | 4555 | 110 |
2243805 | 2243805 | 2022-02-23 | Saginaw | Michigan | 26145 | 49759 | 910 |
2243806 | 2243806 | 2022-02-23 | Sanilac | Michigan | 26151 | 8596 | 182 |
2243807 | 2243807 | 2022-02-23 | Schoolcraft | Michigan | 26153 | 1732 | 13 |
2243808 | 2243808 | 2022-02-23 | Shiawassee | Michigan | 26155 | 17557 | 221 |
2243809 | 2243809 | 2022-02-23 | St. Clair | Michigan | 26147 | 39954 | 795 |
2243810 | 2243810 | 2022-02-23 | St. Joseph | Michigan | 26149 | 13553 | 196 |
2243811 | 2243811 | 2022-02-23 | Tuscola | Michigan | 26157 | 13111 | 271 |
2243812 | 2243812 | 2022-02-23 | Unknown | Michigan | 11861 | 38 | |
2243813 | 2243813 | 2022-02-23 | Van Buren | Michigan | 26159 | 16757 | 257 |
2243814 | 2243814 | 2022-02-23 | Washtenaw | Michigan | 26161 | 72787 | 506 |
2243815 | 2243815 | 2022-02-23 | Wayne | Michigan | 26163 | 391092 | 7603 |
2243816 | 2243816 | 2022-02-23 | Wexford | Michigan | 26165 | 6948 | 102 |
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);