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-01-16 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2120128 | 2120128 | 2022-01-16 | Alcona | Michigan | 26001 | 1516 | 60 |
2120129 | 2120129 | 2022-01-16 | Alger | Michigan | 26003 | 1490 | 11 |
2120130 | 2120130 | 2022-01-16 | Allegan | Michigan | 26005 | 22475 | 293 |
2120131 | 2120131 | 2022-01-16 | Alpena | Michigan | 26007 | 4797 | 120 |
2120132 | 2120132 | 2022-01-16 | Antrim | Michigan | 26009 | 3583 | 52 |
2120133 | 2120133 | 2022-01-16 | Arenac | Michigan | 26011 | 2611 | 56 |
2120134 | 2120134 | 2022-01-16 | Baraga | Michigan | 26013 | 1861 | 50 |
2120135 | 2120135 | 2022-01-16 | Barry | Michigan | 26015 | 11798 | 138 |
2120136 | 2120136 | 2022-01-16 | Bay | Michigan | 26017 | 21690 | 510 |
2120137 | 2120137 | 2022-01-16 | Benzie | Michigan | 26019 | 2719 | 57 |
2120138 | 2120138 | 2022-01-16 | Berrien | Michigan | 26021 | 29149 | 432 |
2120139 | 2120139 | 2022-01-16 | Branch | Michigan | 26023 | 10063 | 174 |
2120140 | 2120140 | 2022-01-16 | Calhoun | Michigan | 26025 | 27744 | 496 |
2120141 | 2120141 | 2022-01-16 | Cass | Michigan | 26027 | 9779 | 117 |
2120142 | 2120142 | 2022-01-16 | Charlevoix | Michigan | 26029 | 4093 | 54 |
2120143 | 2120143 | 2022-01-16 | Cheboygan | Michigan | 26031 | 3994 | 85 |
2120144 | 2120144 | 2022-01-16 | Chippewa | Michigan | 26033 | 9385 | 90 |
2120145 | 2120145 | 2022-01-16 | Clare | Michigan | 26035 | 5535 | 143 |
2120146 | 2120146 | 2022-01-16 | Clinton | Michigan | 26037 | 16252 | 175 |
2120147 | 2120147 | 2022-01-16 | Crawford | Michigan | 26039 | 2090 | 23 |
2120148 | 2120148 | 2022-01-16 | Delta | Michigan | 26041 | 8014 | 139 |
2120149 | 2120149 | 2022-01-16 | Dickinson | Michigan | 26043 | 5843 | 95 |
2120150 | 2120150 | 2022-01-16 | Eaton | Michigan | 26045 | 21271 | 336 |
2120151 | 2120151 | 2022-01-16 | Emmet | Michigan | 26047 | 5229 | 65 |
2120152 | 2120152 | 2022-01-16 | Genesee | Michigan | 26049 | 84530 | 1446 |
2120153 | 2120153 | 2022-01-16 | Gladwin | Michigan | 26051 | 4619 | 102 |
2120154 | 2120154 | 2022-01-16 | Gogebic | Michigan | 26053 | 2640 | 63 |
2120155 | 2120155 | 2022-01-16 | Grand Traverse | Michigan | 26055 | 13847 | 190 |
2120156 | 2120156 | 2022-01-16 | Gratiot | Michigan | 26057 | 11485 | 169 |
2120157 | 2120157 | 2022-01-16 | Hillsdale | Michigan | 26059 | 8692 | 178 |
2120158 | 2120158 | 2022-01-16 | Houghton | Michigan | 26061 | 6392 | 77 |
2120159 | 2120159 | 2022-01-16 | Huron | Michigan | 26063 | 6779 | 130 |
2120160 | 2120160 | 2022-01-16 | Ingham | Michigan | 26065 | 50641 | 625 |
2120161 | 2120161 | 2022-01-16 | Ionia | Michigan | 26067 | 16366 | 153 |
2120162 | 2120162 | 2022-01-16 | Iosco | Michigan | 26069 | 4122 | 119 |
2120163 | 2120163 | 2022-01-16 | Iron | Michigan | 26071 | 2062 | 74 |
2120164 | 2120164 | 2022-01-16 | Isabella | Michigan | 26073 | 12795 | 174 |
2120165 | 2120165 | 2022-01-16 | Jackson | Michigan | 26075 | 37980 | 493 |
2120166 | 2120166 | 2022-01-16 | Kalamazoo | Michigan | 26077 | 47998 | 573 |
2120167 | 2120167 | 2022-01-16 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2120168 | 2120168 | 2022-01-16 | Kent | Michigan | 26081 | 140589 | 1331 |
2120169 | 2120169 | 2022-01-16 | Keweenaw | Michigan | 26083 | 419 | 11 |
2120170 | 2120170 | 2022-01-16 | Lake | Michigan | 26085 | 1492 | 32 |
2120171 | 2120171 | 2022-01-16 | Lapeer | Michigan | 26087 | 17830 | 365 |
2120172 | 2120172 | 2022-01-16 | Leelanau | Michigan | 26089 | 2890 | 43 |
2120173 | 2120173 | 2022-01-16 | Lenawee | Michigan | 26091 | 21593 | 272 |
2120174 | 2120174 | 2022-01-16 | Livingston | Michigan | 26093 | 38344 | 380 |
2120175 | 2120175 | 2022-01-16 | Luce | Michigan | 26095 | 2007 | 6 |
2120176 | 2120176 | 2022-01-16 | Mackinac | Michigan | 26097 | 1936 | 25 |
2120177 | 2120177 | 2022-01-16 | Macomb | Michigan | 26099 | 193931 | 3398 |
2120178 | 2120178 | 2022-01-16 | Manistee | Michigan | 26101 | 3580 | 68 |
2120179 | 2120179 | 2022-01-16 | Marquette | Michigan | 26103 | 12192 | 101 |
2120180 | 2120180 | 2022-01-16 | Mason | Michigan | 26105 | 5210 | 74 |
2120181 | 2120181 | 2022-01-16 | Mecosta | Michigan | 26107 | 6966 | 88 |
2120182 | 2120182 | 2022-01-16 | Menominee | Michigan | 26109 | 4613 | 64 |
2120183 | 2120183 | 2022-01-16 | Midland | Michigan | 26111 | 15334 | 195 |
2120184 | 2120184 | 2022-01-16 | Missaukee | Michigan | 26113 | 2376 | 54 |
2120185 | 2120185 | 2022-01-16 | Monroe | Michigan | 26115 | 32120 | 394 |
2120186 | 2120186 | 2022-01-16 | Montcalm | Michigan | 26117 | 14593 | 183 |
2120187 | 2120187 | 2022-01-16 | Montmorency | Michigan | 26119 | 1443 | 43 |
2120188 | 2120188 | 2022-01-16 | Muskegon | Michigan | 26121 | 35535 | 547 |
2120189 | 2120189 | 2022-01-16 | Newaygo | Michigan | 26123 | 9479 | 133 |
2120190 | 2120190 | 2022-01-16 | Oakland | Michigan | 26125 | 237946 | 3295 |
2120191 | 2120191 | 2022-01-16 | Oceana | Michigan | 26127 | 5267 | 84 |
2120192 | 2120192 | 2022-01-16 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2120193 | 2120193 | 2022-01-16 | Ontonagon | Michigan | 26131 | 852 | 30 |
2120194 | 2120194 | 2022-01-16 | Osceola | Michigan | 26133 | 4167 | 67 |
2120195 | 2120195 | 2022-01-16 | Oscoda | Michigan | 26135 | 1237 | 51 |
2120196 | 2120196 | 2022-01-16 | Otsego | Michigan | 26137 | 4671 | 87 |
2120197 | 2120197 | 2022-01-16 | Ottawa | Michigan | 26139 | 62279 | 689 |
2120198 | 2120198 | 2022-01-16 | Presque Isle | Michigan | 26141 | 1836 | 52 |
2120199 | 2120199 | 2022-01-16 | Roscommon | Michigan | 26143 | 3896 | 108 |
2120200 | 2120200 | 2022-01-16 | Saginaw | Michigan | 26145 | 41528 | 834 |
2120201 | 2120201 | 2022-01-16 | Sanilac | Michigan | 26151 | 7409 | 170 |
2120202 | 2120202 | 2022-01-16 | Schoolcraft | Michigan | 26153 | 1393 | 9 |
2120203 | 2120203 | 2022-01-16 | Shiawassee | Michigan | 26155 | 14447 | 199 |
2120204 | 2120204 | 2022-01-16 | St. Clair | Michigan | 26147 | 35385 | 716 |
2120205 | 2120205 | 2022-01-16 | St. Joseph | Michigan | 26149 | 11628 | 172 |
2120206 | 2120206 | 2022-01-16 | Tuscola | Michigan | 26157 | 10959 | 251 |
2120207 | 2120207 | 2022-01-16 | Unknown | Michigan | 3935 | 26 | |
2120208 | 2120208 | 2022-01-16 | Van Buren | Michigan | 26159 | 14258 | 230 |
2120209 | 2120209 | 2022-01-16 | Washtenaw | Michigan | 26161 | 59450 | 444 |
2120210 | 2120210 | 2022-01-16 | Wayne | Michigan | 26163 | 336018 | 6793 |
2120211 | 2120211 | 2022-01-16 | Wexford | Michigan | 26165 | 5413 | 90 |
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);