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-12-27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2055106 | 2055106 | 2021-12-27 | Alcona | Michigan | 26001 | 1409 | 55 |
2055107 | 2055107 | 2021-12-27 | Alger | Michigan | 26003 | 1231 | 11 |
2055108 | 2055108 | 2021-12-27 | Allegan | Michigan | 26005 | 20135 | 272 |
2055109 | 2055109 | 2021-12-27 | Alpena | Michigan | 26007 | 4526 | 113 |
2055110 | 2055110 | 2021-12-27 | Antrim | Michigan | 26009 | 3129 | 50 |
2055111 | 2055111 | 2021-12-27 | Arenac | Michigan | 26011 | 2353 | 51 |
2055112 | 2055112 | 2021-12-27 | Baraga | Michigan | 26013 | 1660 | 49 |
2055113 | 2055113 | 2021-12-27 | Barry | Michigan | 26015 | 10662 | 131 |
2055114 | 2055114 | 2021-12-27 | Bay | Michigan | 26017 | 19046 | 467 |
2055115 | 2055115 | 2021-12-27 | Benzie | Michigan | 26019 | 2389 | 53 |
2055116 | 2055116 | 2021-12-27 | Berrien | Michigan | 26021 | 25082 | 389 |
2055117 | 2055117 | 2021-12-27 | Branch | Michigan | 26023 | 9325 | 163 |
2055118 | 2055118 | 2021-12-27 | Calhoun | Michigan | 26025 | 24614 | 459 |
2055119 | 2055119 | 2021-12-27 | Cass | Michigan | 26027 | 8963 | 110 |
2055120 | 2055120 | 2021-12-27 | Charlevoix | Michigan | 26029 | 3393 | 52 |
2055121 | 2055121 | 2021-12-27 | Cheboygan | Michigan | 26031 | 3646 | 80 |
2055122 | 2055122 | 2021-12-27 | Chippewa | Michigan | 26033 | 8191 | 80 |
2055123 | 2055123 | 2021-12-27 | Clare | Michigan | 26035 | 5102 | 131 |
2055124 | 2055124 | 2021-12-27 | Clinton | Michigan | 26037 | 14055 | 162 |
2055125 | 2055125 | 2021-12-27 | Crawford | Michigan | 26039 | 1924 | 20 |
2055126 | 2055126 | 2021-12-27 | Delta | Michigan | 26041 | 7104 | 132 |
2055127 | 2055127 | 2021-12-27 | Dickinson | Michigan | 26043 | 5076 | 92 |
2055128 | 2055128 | 2021-12-27 | Eaton | Michigan | 26045 | 18115 | 318 |
2055129 | 2055129 | 2021-12-27 | Emmet | Michigan | 26047 | 4519 | 59 |
2055130 | 2055130 | 2021-12-27 | Genesee | Michigan | 26049 | 71178 | 1324 |
2055131 | 2055131 | 2021-12-27 | Gladwin | Michigan | 26051 | 4110 | 94 |
2055132 | 2055132 | 2021-12-27 | Gogebic | Michigan | 26053 | 2318 | 62 |
2055133 | 2055133 | 2021-12-27 | Grand Traverse | Michigan | 26055 | 12167 | 173 |
2055134 | 2055134 | 2021-12-27 | Gratiot | Michigan | 26057 | 10799 | 162 |
2055135 | 2055135 | 2021-12-27 | Hillsdale | Michigan | 26059 | 8191 | 170 |
2055136 | 2055136 | 2021-12-27 | Houghton | Michigan | 26061 | 5645 | 72 |
2055137 | 2055137 | 2021-12-27 | Huron | Michigan | 26063 | 6264 | 121 |
2055138 | 2055138 | 2021-12-27 | Ingham | Michigan | 26065 | 41392 | 577 |
2055139 | 2055139 | 2021-12-27 | Ionia | Michigan | 26067 | 15078 | 144 |
2055140 | 2055140 | 2021-12-27 | Iosco | Michigan | 26069 | 3779 | 112 |
2055141 | 2055141 | 2021-12-27 | Iron | Michigan | 26071 | 1863 | 70 |
2055142 | 2055142 | 2021-12-27 | Isabella | Michigan | 26073 | 11315 | 160 |
2055143 | 2055143 | 2021-12-27 | Jackson | Michigan | 26075 | 33766 | 457 |
2055144 | 2055144 | 2021-12-27 | Kalamazoo | Michigan | 26077 | 39376 | 540 |
2055145 | 2055145 | 2021-12-27 | Kalkaska | Michigan | 26079 | 2498 | 47 |
2055146 | 2055146 | 2021-12-27 | Kent | Michigan | 26081 | 121287 | 1231 |
2055147 | 2055147 | 2021-12-27 | Keweenaw | Michigan | 26083 | 389 | 11 |
2055148 | 2055148 | 2021-12-27 | Lake | Michigan | 26085 | 1391 | 31 |
2055149 | 2055149 | 2021-12-27 | Lapeer | Michigan | 26087 | 15960 | 328 |
2055150 | 2055150 | 2021-12-27 | Leelanau | Michigan | 26089 | 2461 | 41 |
2055151 | 2055151 | 2021-12-27 | Lenawee | Michigan | 26091 | 19021 | 254 |
2055152 | 2055152 | 2021-12-27 | Livingston | Michigan | 26093 | 32736 | 354 |
2055153 | 2055153 | 2021-12-27 | Luce | Michigan | 26095 | 1881 | 6 |
2055154 | 2055154 | 2021-12-27 | Mackinac | Michigan | 26097 | 1682 | 19 |
2055155 | 2055155 | 2021-12-27 | Macomb | Michigan | 26099 | 162666 | 3181 |
2055156 | 2055156 | 2021-12-27 | Manistee | Michigan | 26101 | 3286 | 63 |
2055157 | 2055157 | 2021-12-27 | Marquette | Michigan | 26103 | 9950 | 96 |
2055158 | 2055158 | 2021-12-27 | Mason | Michigan | 26105 | 4739 | 66 |
2055159 | 2055159 | 2021-12-27 | Mecosta | Michigan | 26107 | 6349 | 85 |
2055160 | 2055160 | 2021-12-27 | Menominee | Michigan | 26109 | 4189 | 60 |
2055161 | 2055161 | 2021-12-27 | Midland | Michigan | 26111 | 13425 | 181 |
2055162 | 2055162 | 2021-12-27 | Missaukee | Michigan | 26113 | 2233 | 46 |
2055163 | 2055163 | 2021-12-27 | Monroe | Michigan | 26115 | 26834 | 369 |
2055164 | 2055164 | 2021-12-27 | Montcalm | Michigan | 26117 | 13673 | 168 |
2055165 | 2055165 | 2021-12-27 | Montmorency | Michigan | 26119 | 1339 | 41 |
2055166 | 2055166 | 2021-12-27 | Muskegon | Michigan | 26121 | 31219 | 519 |
2055167 | 2055167 | 2021-12-27 | Newaygo | Michigan | 26123 | 8778 | 129 |
2055168 | 2055168 | 2021-12-27 | Oakland | Michigan | 26125 | 194971 | 3071 |
2055169 | 2055169 | 2021-12-27 | Oceana | Michigan | 26127 | 4896 | 84 |
2055170 | 2055170 | 2021-12-27 | Ogemaw | Michigan | 26129 | 3314 | 80 |
2055171 | 2055171 | 2021-12-27 | Ontonagon | Michigan | 26131 | 747 | 27 |
2055172 | 2055172 | 2021-12-27 | Osceola | Michigan | 26133 | 3872 | 61 |
2055173 | 2055173 | 2021-12-27 | Oscoda | Michigan | 26135 | 1168 | 50 |
2055174 | 2055174 | 2021-12-27 | Otsego | Michigan | 26137 | 4293 | 78 |
2055175 | 2055175 | 2021-12-27 | Ottawa | Michigan | 26139 | 54992 | 641 |
2055176 | 2055176 | 2021-12-27 | Presque Isle | Michigan | 26141 | 1732 | 50 |
2055177 | 2055177 | 2021-12-27 | Roscommon | Michigan | 26143 | 3632 | 99 |
2055178 | 2055178 | 2021-12-27 | Saginaw | Michigan | 26145 | 36748 | 788 |
2055179 | 2055179 | 2021-12-27 | Sanilac | Michigan | 26151 | 6759 | 164 |
2055180 | 2055180 | 2021-12-27 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2055181 | 2055181 | 2021-12-27 | Shiawassee | Michigan | 26155 | 12590 | 182 |
2055182 | 2055182 | 2021-12-27 | St. Clair | Michigan | 26147 | 30293 | 642 |
2055183 | 2055183 | 2021-12-27 | St. Joseph | Michigan | 26149 | 10794 | 157 |
2055184 | 2055184 | 2021-12-27 | Tuscola | Michigan | 26157 | 9919 | 235 |
2055185 | 2055185 | 2021-12-27 | Unknown | Michigan | 2577 | 26 | |
2055186 | 2055186 | 2021-12-27 | Van Buren | Michigan | 26159 | 12600 | 207 |
2055187 | 2055187 | 2021-12-27 | Washtenaw | Michigan | 26161 | 45441 | 401 |
2055188 | 2055188 | 2021-12-27 | Wayne | Michigan | 26163 | 268864 | 6411 |
2055189 | 2055189 | 2021-12-27 | Wexford | Michigan | 26165 | 5037 | 84 |
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);