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-06-25 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1454075 | 1454075 | 2021-06-25 | Alcona | Michigan | 26001 | 739 | 33 |
1454076 | 1454076 | 2021-06-25 | Alger | Michigan | 26003 | 669 | 7 |
1454077 | 1454077 | 2021-06-25 | Allegan | Michigan | 26005 | 11183 | 159 |
1454078 | 1454078 | 2021-06-25 | Alpena | Michigan | 26007 | 2269 | 63 |
1454079 | 1454079 | 2021-06-25 | Antrim | Michigan | 26009 | 1636 | 29 |
1454080 | 1454080 | 2021-06-25 | Arenac | Michigan | 26011 | 1209 | 29 |
1454081 | 1454081 | 2021-06-25 | Baraga | Michigan | 26013 | 991 | 39 |
1454082 | 1454082 | 2021-06-25 | Barry | Michigan | 26015 | 5962 | 69 |
1454083 | 1454083 | 2021-06-25 | Bay | Michigan | 26017 | 11259 | 353 |
1454084 | 1454084 | 2021-06-25 | Benzie | Michigan | 26019 | 1280 | 36 |
1454085 | 1454085 | 2021-06-25 | Berrien | Michigan | 26021 | 15585 | 290 |
1454086 | 1454086 | 2021-06-25 | Branch | Michigan | 26023 | 5751 | 120 |
1454087 | 1454087 | 2021-06-25 | Calhoun | Michigan | 26025 | 14546 | 317 |
1454088 | 1454088 | 2021-06-25 | Cass | Michigan | 26027 | 5495 | 77 |
1454089 | 1454089 | 2021-06-25 | Charlevoix | Michigan | 26029 | 1681 | 22 |
1454090 | 1454090 | 2021-06-25 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1454091 | 1454091 | 2021-06-25 | Chippewa | Michigan | 26033 | 5627 | 50 |
1454092 | 1454092 | 2021-06-25 | Clare | Michigan | 26035 | 2477 | 84 |
1454093 | 1454093 | 2021-06-25 | Clinton | Michigan | 26037 | 7655 | 92 |
1454094 | 1454094 | 2021-06-25 | Crawford | Michigan | 26039 | 995 | 14 |
1454095 | 1454095 | 2021-06-25 | Delta | Michigan | 26041 | 4057 | 95 |
1454096 | 1454096 | 2021-06-25 | Dickinson | Michigan | 26043 | 2753 | 74 |
1454097 | 1454097 | 2021-06-25 | Eaton | Michigan | 26045 | 10151 | 211 |
1454098 | 1454098 | 2021-06-25 | Emmet | Michigan | 26047 | 2384 | 43 |
1454099 | 1454099 | 2021-06-25 | Genesee | Michigan | 26049 | 41739 | 970 |
1454100 | 1454100 | 2021-06-25 | Gladwin | Michigan | 26051 | 2305 | 61 |
1454101 | 1454101 | 2021-06-25 | Gogebic | Michigan | 26053 | 1405 | 52 |
1454102 | 1454102 | 2021-06-25 | Grand Traverse | Michigan | 26055 | 6476 | 99 |
1454103 | 1454103 | 2021-06-25 | Gratiot | Michigan | 26057 | 6985 | 125 |
1454104 | 1454104 | 2021-06-25 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1454105 | 1454105 | 2021-06-25 | Houghton | Michigan | 26061 | 3139 | 43 |
1454106 | 1454106 | 2021-06-25 | Huron | Michigan | 26063 | 4092 | 82 |
1454107 | 1454107 | 2021-06-25 | Ingham | Michigan | 26065 | 24889 | 390 |
1454108 | 1454108 | 2021-06-25 | Ionia | Michigan | 26067 | 9339 | 85 |
1454109 | 1454109 | 2021-06-25 | Iosco | Michigan | 26069 | 2006 | 74 |
1454110 | 1454110 | 2021-06-25 | Iron | Michigan | 26071 | 1053 | 53 |
1454111 | 1454111 | 2021-06-25 | Isabella | Michigan | 26073 | 6338 | 100 |
1454112 | 1454112 | 2021-06-25 | Jackson | Michigan | 26075 | 21039 | 323 |
1454113 | 1454113 | 2021-06-25 | Kalamazoo | Michigan | 26077 | 23170 | 401 |
1454114 | 1454114 | 2021-06-25 | Kalkaska | Michigan | 26079 | 1139 | 26 |
1454115 | 1454115 | 2021-06-25 | Kent | Michigan | 26081 | 73490 | 859 |
1454116 | 1454116 | 2021-06-25 | Keweenaw | Michigan | 26083 | 174 | 2 |
1454117 | 1454117 | 2021-06-25 | Lake | Michigan | 26085 | 637 | 16 |
1454118 | 1454118 | 2021-06-25 | Lapeer | Michigan | 26087 | 9766 | 214 |
1454119 | 1454119 | 2021-06-25 | Leelanau | Michigan | 26089 | 1243 | 19 |
1454120 | 1454120 | 2021-06-25 | Lenawee | Michigan | 26091 | 10850 | 177 |
1454121 | 1454121 | 2021-06-25 | Livingston | Michigan | 26093 | 16788 | 196 |
1454122 | 1454122 | 2021-06-25 | Luce | Michigan | 26095 | 1338 | 6 |
1454123 | 1454123 | 2021-06-25 | Mackinac | Michigan | 26097 | 716 | 3 |
1454124 | 1454124 | 2021-06-25 | Macomb | Michigan | 26099 | 100600 | 2495 |
1454125 | 1454125 | 2021-06-25 | Manistee | Michigan | 26101 | 1981 | 24 |
1454126 | 1454126 | 2021-06-25 | Marquette | Michigan | 26103 | 5929 | 64 |
1454127 | 1454127 | 2021-06-25 | Mason | Michigan | 26105 | 2140 | 37 |
1454128 | 1454128 | 2021-06-25 | Mecosta | Michigan | 26107 | 3212 | 36 |
1454129 | 1454129 | 2021-06-25 | Menominee | Michigan | 26109 | 2126 | 43 |
1454130 | 1454130 | 2021-06-25 | Midland | Michigan | 26111 | 7575 | 94 |
1454131 | 1454131 | 2021-06-25 | Missaukee | Michigan | 26113 | 1512 | 27 |
1454132 | 1454132 | 2021-06-25 | Monroe | Michigan | 26115 | 15408 | 263 |
1454133 | 1454133 | 2021-06-25 | Montcalm | Michigan | 26117 | 8211 | 119 |
1454134 | 1454134 | 2021-06-25 | Montmorency | Michigan | 26119 | 618 | 20 |
1454135 | 1454135 | 2021-06-25 | Muskegon | Michigan | 26121 | 18411 | 384 |
1454136 | 1454136 | 2021-06-25 | Newaygo | Michigan | 26123 | 4892 | 69 |
1454137 | 1454137 | 2021-06-25 | Oakland | Michigan | 26125 | 118669 | 2442 |
1454138 | 1454138 | 2021-06-25 | Oceana | Michigan | 26127 | 2769 | 60 |
1454139 | 1454139 | 2021-06-25 | Ogemaw | Michigan | 26129 | 1743 | 43 |
1454140 | 1454140 | 2021-06-25 | Ontonagon | Michigan | 26131 | 482 | 21 |
1454141 | 1454141 | 2021-06-25 | Osceola | Michigan | 26133 | 1962 | 31 |
1454142 | 1454142 | 2021-06-25 | Oscoda | Michigan | 26135 | 691 | 31 |
1454143 | 1454143 | 2021-06-25 | Otsego | Michigan | 26137 | 2360 | 41 |
1454144 | 1454144 | 2021-06-25 | Ottawa | Michigan | 26139 | 32903 | 439 |
1454145 | 1454145 | 2021-06-25 | Presque Isle | Michigan | 26141 | 1056 | 34 |
1454146 | 1454146 | 2021-06-25 | Roscommon | Michigan | 26143 | 1899 | 54 |
1454147 | 1454147 | 2021-06-25 | Saginaw | Michigan | 26145 | 22517 | 633 |
1454148 | 1454148 | 2021-06-25 | Sanilac | Michigan | 26151 | 4259 | 125 |
1454149 | 1454149 | 2021-06-25 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1454150 | 1454150 | 2021-06-25 | Shiawassee | Michigan | 26155 | 6434 | 107 |
1454151 | 1454151 | 2021-06-25 | St. Clair | Michigan | 26147 | 18498 | 447 |
1454152 | 1454152 | 2021-06-25 | St. Joseph | Michigan | 26149 | 6254 | 100 |
1454153 | 1454153 | 2021-06-25 | Tuscola | Michigan | 26157 | 5668 | 174 |
1454154 | 1454154 | 2021-06-25 | Unknown | Michigan | 741 | 15 | |
1454155 | 1454155 | 2021-06-25 | Van Buren | Michigan | 26159 | 7141 | 130 |
1454156 | 1454156 | 2021-06-25 | Washtenaw | Michigan | 26161 | 27128 | 308 |
1454157 | 1454157 | 2021-06-25 | Wayne | Michigan | 26163 | 165755 | 5161 |
1454158 | 1454158 | 2021-06-25 | Wexford | Michigan | 26165 | 2901 | 48 |
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);