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-12 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2207969 | 2207969 | 2022-02-12 | Alcona | Michigan | 26001 | 1665 | 67 |
2207970 | 2207970 | 2022-02-12 | Alger | Michigan | 26003 | 1815 | 13 |
2207971 | 2207971 | 2022-02-12 | Allegan | Michigan | 26005 | 26478 | 324 |
2207972 | 2207972 | 2022-02-12 | Alpena | Michigan | 26007 | 5384 | 127 |
2207973 | 2207973 | 2022-02-12 | Antrim | Michigan | 26009 | 4174 | 56 |
2207974 | 2207974 | 2022-02-12 | Arenac | Michigan | 26011 | 3112 | 62 |
2207975 | 2207975 | 2022-02-12 | Baraga | Michigan | 26013 | 2153 | 54 |
2207976 | 2207976 | 2022-02-12 | Barry | Michigan | 26015 | 13986 | 155 |
2207977 | 2207977 | 2022-02-12 | Bay | Michigan | 26017 | 26425 | 548 |
2207978 | 2207978 | 2022-02-12 | Benzie | Michigan | 26019 | 3338 | 63 |
2207979 | 2207979 | 2022-02-12 | Berrien | Michigan | 26021 | 34072 | 498 |
2207980 | 2207980 | 2022-02-12 | Branch | Michigan | 26023 | 11948 | 186 |
2207981 | 2207981 | 2022-02-12 | Calhoun | Michigan | 26025 | 33131 | 538 |
2207982 | 2207982 | 2022-02-12 | Cass | Michigan | 26027 | 10929 | 127 |
2207983 | 2207983 | 2022-02-12 | Charlevoix | Michigan | 26029 | 4825 | 56 |
2207984 | 2207984 | 2022-02-12 | Cheboygan | Michigan | 26031 | 4491 | 93 |
2207985 | 2207985 | 2022-02-12 | Chippewa | Michigan | 26033 | 11257 | 104 |
2207986 | 2207986 | 2022-02-12 | Clare | Michigan | 26035 | 6555 | 150 |
2207987 | 2207987 | 2022-02-12 | Clinton | Michigan | 26037 | 20271 | 193 |
2207988 | 2207988 | 2022-02-12 | Crawford | Michigan | 26039 | 2455 | 26 |
2207989 | 2207989 | 2022-02-12 | Delta | Michigan | 26041 | 9745 | 149 |
2207990 | 2207990 | 2022-02-12 | Dickinson | Michigan | 26043 | 7246 | 102 |
2207991 | 2207991 | 2022-02-12 | Eaton | Michigan | 26045 | 25867 | 371 |
2207992 | 2207992 | 2022-02-12 | Emmet | Michigan | 26047 | 6233 | 74 |
2207993 | 2207993 | 2022-02-12 | Genesee | Michigan | 26049 | 98664 | 1601 |
2207994 | 2207994 | 2022-02-12 | Gladwin | Michigan | 26051 | 5454 | 106 |
2207995 | 2207995 | 2022-02-12 | Gogebic | Michigan | 26053 | 3180 | 65 |
2207996 | 2207996 | 2022-02-12 | Grand Traverse | Michigan | 26055 | 16547 | 204 |
2207997 | 2207997 | 2022-02-12 | Gratiot | Michigan | 26057 | 13255 | 177 |
2207998 | 2207998 | 2022-02-12 | Hillsdale | Michigan | 26059 | 10121 | 185 |
2207999 | 2207999 | 2022-02-12 | Houghton | Michigan | 26061 | 7592 | 87 |
2208000 | 2208000 | 2022-02-12 | Huron | Michigan | 26063 | 7913 | 141 |
2208001 | 2208001 | 2022-02-12 | Ingham | Michigan | 26065 | 61993 | 690 |
2208002 | 2208002 | 2022-02-12 | Ionia | Michigan | 26067 | 19068 | 171 |
2208003 | 2208003 | 2022-02-12 | Iosco | Michigan | 26069 | 4644 | 129 |
2208004 | 2208004 | 2022-02-12 | Iron | Michigan | 26071 | 2583 | 79 |
2208005 | 2208005 | 2022-02-12 | Isabella | Michigan | 26073 | 15185 | 187 |
2208006 | 2208006 | 2022-02-12 | Jackson | Michigan | 26075 | 43796 | 537 |
2208007 | 2208007 | 2022-02-12 | Kalamazoo | Michigan | 26077 | 56899 | 624 |
2208008 | 2208008 | 2022-02-12 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2208009 | 2208009 | 2022-02-12 | Kent | Michigan | 26081 | 162438 | 1426 |
2208010 | 2208010 | 2022-02-12 | Keweenaw | Michigan | 26083 | 496 | 12 |
2208011 | 2208011 | 2022-02-12 | Lake | Michigan | 26085 | 1778 | 34 |
2208012 | 2208012 | 2022-02-12 | Lapeer | Michigan | 26087 | 20397 | 402 |
2208013 | 2208013 | 2022-02-12 | Leelanau | Michigan | 26089 | 3462 | 47 |
2208014 | 2208014 | 2022-02-12 | Lenawee | Michigan | 26091 | 25386 | 304 |
2208015 | 2208015 | 2022-02-12 | Livingston | Michigan | 26093 | 44666 | 420 |
2208016 | 2208016 | 2022-02-12 | Luce | Michigan | 26095 | 2234 | 9 |
2208017 | 2208017 | 2022-02-12 | Mackinac | Michigan | 26097 | 2312 | 27 |
2208018 | 2208018 | 2022-02-12 | Macomb | Michigan | 26099 | 222040 | 3698 |
2208019 | 2208019 | 2022-02-12 | Manistee | Michigan | 26101 | 4297 | 78 |
2208020 | 2208020 | 2022-02-12 | Marquette | Michigan | 26103 | 15370 | 113 |
2208021 | 2208021 | 2022-02-12 | Mason | Michigan | 26105 | 6404 | 82 |
2208022 | 2208022 | 2022-02-12 | Mecosta | Michigan | 26107 | 8418 | 96 |
2208023 | 2208023 | 2022-02-12 | Menominee | Michigan | 26109 | 5426 | 68 |
2208024 | 2208024 | 2022-02-12 | Midland | Michigan | 26111 | 18564 | 210 |
2208025 | 2208025 | 2022-02-12 | Missaukee | Michigan | 26113 | 2830 | 57 |
2208026 | 2208026 | 2022-02-12 | Monroe | Michigan | 26115 | 37117 | 442 |
2208027 | 2208027 | 2022-02-12 | Montcalm | Michigan | 26117 | 16791 | 199 |
2208028 | 2208028 | 2022-02-12 | Montmorency | Michigan | 26119 | 1673 | 45 |
2208029 | 2208029 | 2022-02-12 | Muskegon | Michigan | 26121 | 40683 | 601 |
2208030 | 2208030 | 2022-02-12 | Newaygo | Michigan | 26123 | 11202 | 150 |
2208031 | 2208031 | 2022-02-12 | Oakland | Michigan | 26125 | 277833 | 3588 |
2208032 | 2208032 | 2022-02-12 | Oceana | Michigan | 26127 | 6122 | 87 |
2208033 | 2208033 | 2022-02-12 | Ogemaw | Michigan | 26129 | 4215 | 91 |
2208034 | 2208034 | 2022-02-12 | Ontonagon | Michigan | 26131 | 953 | 35 |
2208035 | 2208035 | 2022-02-12 | Osceola | Michigan | 26133 | 4854 | 71 |
2208036 | 2208036 | 2022-02-12 | Oscoda | Michigan | 26135 | 1410 | 53 |
2208037 | 2208037 | 2022-02-12 | Otsego | Michigan | 26137 | 5429 | 93 |
2208038 | 2208038 | 2022-02-12 | Ottawa | Michigan | 26139 | 73028 | 752 |
2208039 | 2208039 | 2022-02-12 | Presque Isle | Michigan | 26141 | 2039 | 55 |
2208040 | 2208040 | 2022-02-12 | Roscommon | Michigan | 26143 | 4490 | 109 |
2208041 | 2208041 | 2022-02-12 | Saginaw | Michigan | 26145 | 49181 | 886 |
2208042 | 2208042 | 2022-02-12 | Sanilac | Michigan | 26151 | 8483 | 177 |
2208043 | 2208043 | 2022-02-12 | Schoolcraft | Michigan | 26153 | 1701 | 13 |
2208044 | 2208044 | 2022-02-12 | Shiawassee | Michigan | 26155 | 17312 | 216 |
2208045 | 2208045 | 2022-02-12 | St. Clair | Michigan | 26147 | 39527 | 778 |
2208046 | 2208046 | 2022-02-12 | St. Joseph | Michigan | 26149 | 13436 | 189 |
2208047 | 2208047 | 2022-02-12 | Tuscola | Michigan | 26157 | 12975 | 265 |
2208048 | 2208048 | 2022-02-12 | Unknown | Michigan | 11204 | 32 | |
2208049 | 2208049 | 2022-02-12 | Van Buren | Michigan | 26159 | 16606 | 248 |
2208050 | 2208050 | 2022-02-12 | Washtenaw | Michigan | 26161 | 71548 | 495 |
2208051 | 2208051 | 2022-02-12 | Wayne | Michigan | 26163 | 388109 | 7402 |
2208052 | 2208052 | 2022-02-12 | Wexford | Michigan | 26165 | 6825 | 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);