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 2020-12-08 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
808090 | 808090 | 2020-12-08 | Alcona | Michigan | 26001 | 288 | 8 |
808091 | 808091 | 2020-12-08 | Alger | Michigan | 26003 | 384 | 2 |
808092 | 808092 | 2020-12-08 | Allegan | Michigan | 26005 | 4686 | 41 |
808093 | 808093 | 2020-12-08 | Alpena | Michigan | 26007 | 893 | 18 |
808094 | 808094 | 2020-12-08 | Antrim | Michigan | 26009 | 516 | 7 |
808095 | 808095 | 2020-12-08 | Arenac | Michigan | 26011 | 521 | 22 |
808096 | 808096 | 2020-12-08 | Baraga | Michigan | 26013 | 590 | 24 |
808097 | 808097 | 2020-12-08 | Barry | Michigan | 26015 | 2531 | 17 |
808098 | 808098 | 2020-12-08 | Bay | Michigan | 26017 | 5175 | 127 |
808099 | 808099 | 2020-12-08 | Benzie | Michigan | 26019 | 535 | 11 |
808100 | 808100 | 2020-12-08 | Berrien | Michigan | 26021 | 7893 | 132 |
808101 | 808101 | 2020-12-08 | Branch | Michigan | 26023 | 3416 | 68 |
808102 | 808102 | 2020-12-08 | Calhoun | Michigan | 26025 | 6731 | 138 |
808103 | 808103 | 2020-12-08 | Cass | Michigan | 26027 | 2564 | 31 |
808104 | 808104 | 2020-12-08 | Charlevoix | Michigan | 26029 | 740 | 7 |
808105 | 808105 | 2020-12-08 | Cheboygan | Michigan | 26031 | 603 | 24 |
808106 | 808106 | 2020-12-08 | Chippewa | Michigan | 26033 | 2392 | 14 |
808107 | 808107 | 2020-12-08 | Clare | Michigan | 26035 | 924 | 27 |
808108 | 808108 | 2020-12-08 | Clinton | Michigan | 26037 | 3190 | 29 |
808109 | 808109 | 2020-12-08 | Crawford | Michigan | 26039 | 405 | 5 |
808110 | 808110 | 2020-12-08 | Delta | Michigan | 26041 | 2662 | 65 |
808111 | 808111 | 2020-12-08 | Dickinson | Michigan | 26043 | 1927 | 59 |
808112 | 808112 | 2020-12-08 | Eaton | Michigan | 26045 | 3743 | 59 |
808113 | 808113 | 2020-12-08 | Emmet | Michigan | 26047 | 1092 | 29 |
808114 | 808114 | 2020-12-08 | Genesee | Michigan | 26049 | 17420 | 475 |
808115 | 808115 | 2020-12-08 | Gladwin | Michigan | 26051 | 964 | 14 |
808116 | 808116 | 2020-12-08 | Gogebic | Michigan | 26053 | 892 | 25 |
808117 | 808117 | 2020-12-08 | Grand Traverse | Michigan | 26055 | 2366 | 25 |
808118 | 808118 | 2020-12-08 | Gratiot | Michigan | 26057 | 3630 | 44 |
808119 | 808119 | 2020-12-08 | Hillsdale | Michigan | 26059 | 1989 | 47 |
808120 | 808120 | 2020-12-08 | Houghton | Michigan | 26061 | 1750 | 16 |
808121 | 808121 | 2020-12-08 | Huron | Michigan | 26063 | 1082 | 19 |
808122 | 808122 | 2020-12-08 | Ingham | Michigan | 26065 | 10298 | 131 |
808123 | 808123 | 2020-12-08 | Ionia | Michigan | 26067 | 4292 | 33 |
808124 | 808124 | 2020-12-08 | Iosco | Michigan | 26069 | 916 | 31 |
808125 | 808125 | 2020-12-08 | Iron | Michigan | 26071 | 757 | 36 |
808126 | 808126 | 2020-12-08 | Isabella | Michigan | 26073 | 2816 | 28 |
808127 | 808127 | 2020-12-08 | Jackson | Michigan | 26075 | 8892 | 132 |
808128 | 808128 | 2020-12-08 | Kalamazoo | Michigan | 26077 | 10491 | 181 |
808129 | 808129 | 2020-12-08 | Kalkaska | Michigan | 26079 | 412 | 9 |
808130 | 808130 | 2020-12-08 | Kent | Michigan | 26081 | 37409 | 426 |
808131 | 808131 | 2020-12-08 | Keweenaw | Michigan | 26083 | 78 | 2 |
808132 | 808132 | 2020-12-08 | Lake | Michigan | 26085 | 236 | 6 |
808133 | 808133 | 2020-12-08 | Lapeer | Michigan | 26087 | 3418 | 71 |
808134 | 808134 | 2020-12-08 | Leelanau | Michigan | 26089 | 463 | 3 |
808135 | 808135 | 2020-12-08 | Lenawee | Michigan | 26091 | 4294 | 43 |
808136 | 808136 | 2020-12-08 | Livingston | Michigan | 26093 | 6616 | 54 |
808137 | 808137 | 2020-12-08 | Luce | Michigan | 26095 | 961 | 0 |
808138 | 808138 | 2020-12-08 | Mackinac | Michigan | 26097 | 333 | 1 |
808139 | 808139 | 2020-12-08 | Macomb | Michigan | 26099 | 43035 | 1361 |
808140 | 808140 | 2020-12-08 | Manistee | Michigan | 26101 | 478 | 9 |
808141 | 808141 | 2020-12-08 | Marquette | Michigan | 26103 | 4036 | 38 |
808142 | 808142 | 2020-12-08 | Mason | Michigan | 26105 | 734 | 13 |
808143 | 808143 | 2020-12-08 | Mecosta | Michigan | 26107 | 1407 | 12 |
808144 | 808144 | 2020-12-08 | Menominee | Michigan | 26109 | 1444 | 20 |
808145 | 808145 | 2020-12-08 | Midland | Michigan | 26111 | 3378 | 32 |
808146 | 808146 | 2020-12-08 | Missaukee | Michigan | 26113 | 343 | 7 |
808147 | 808147 | 2020-12-08 | Monroe | Michigan | 26115 | 6301 | 104 |
808148 | 808148 | 2020-12-08 | Montcalm | Michigan | 26117 | 2658 | 35 |
808149 | 808149 | 2020-12-08 | Montmorency | Michigan | 26119 | 234 | 2 |
808150 | 808150 | 2020-12-08 | Muskegon | Michigan | 26121 | 9969 | 213 |
808151 | 808151 | 2020-12-08 | Newaygo | Michigan | 26123 | 1899 | 23 |
808152 | 808152 | 2020-12-08 | Oakland | Michigan | 26125 | 52330 | 1437 |
808153 | 808153 | 2020-12-08 | Oceana | Michigan | 26127 | 1402 | 29 |
808154 | 808154 | 2020-12-08 | Ogemaw | Michigan | 26129 | 702 | 19 |
808155 | 808155 | 2020-12-08 | Ontonagon | Michigan | 26131 | 296 | 15 |
808156 | 808156 | 2020-12-08 | Osceola | Michigan | 26133 | 651 | 11 |
808157 | 808157 | 2020-12-08 | Oscoda | Michigan | 26135 | 251 | 10 |
808158 | 808158 | 2020-12-08 | Otsego | Michigan | 26137 | 867 | 19 |
808159 | 808159 | 2020-12-08 | Ottawa | Michigan | 26139 | 15824 | 197 |
808160 | 808160 | 2020-12-08 | Presque Isle | Michigan | 26141 | 368 | 4 |
808161 | 808161 | 2020-12-08 | Roscommon | Michigan | 26143 | 779 | 23 |
808162 | 808162 | 2020-12-08 | Saginaw | Michigan | 26145 | 10085 | 284 |
808163 | 808163 | 2020-12-08 | Sanilac | Michigan | 26151 | 1141 | 27 |
808164 | 808164 | 2020-12-08 | Schoolcraft | Michigan | 26153 | 198 | 3 |
808165 | 808165 | 2020-12-08 | Shiawassee | Michigan | 26155 | 2398 | 49 |
808166 | 808166 | 2020-12-08 | St. Clair | Michigan | 26147 | 5589 | 107 |
808167 | 808167 | 2020-12-08 | St. Joseph | Michigan | 26149 | 2935 | 39 |
808168 | 808168 | 2020-12-08 | Tuscola | Michigan | 26157 | 2018 | 66 |
808169 | 808169 | 2020-12-08 | Unknown | Michigan | 2529 | 11 | |
808170 | 808170 | 2020-12-08 | Van Buren | Michigan | 26159 | 3360 | 55 |
808171 | 808171 | 2020-12-08 | Washtenaw | Michigan | 26161 | 11809 | 156 |
808172 | 808172 | 2020-12-08 | Wayne | Michigan | 26163 | 72718 | 3356 |
808173 | 808173 | 2020-12-08 | Wexford | Michigan | 26165 | 784 | 18 |
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);