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-10-28 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1860098 | 1860098 | 2021-10-28 | Alcona | Michigan | 26001 | 1138 | 42 |
1860099 | 1860099 | 2021-10-28 | Alger | Michigan | 26003 | 1000 | 9 |
1860100 | 1860100 | 2021-10-28 | Allegan | Michigan | 26005 | 14751 | 191 |
1860101 | 1860101 | 2021-10-28 | Alpena | Michigan | 26007 | 3143 | 73 |
1860102 | 1860102 | 2021-10-28 | Antrim | Michigan | 26009 | 2401 | 38 |
1860103 | 1860103 | 2021-10-28 | Arenac | Michigan | 26011 | 1809 | 34 |
1860104 | 1860104 | 2021-10-28 | Baraga | Michigan | 26013 | 1326 | 47 |
1860105 | 1860105 | 2021-10-28 | Barry | Michigan | 26015 | 7812 | 84 |
1860106 | 1860106 | 2021-10-28 | Bay | Michigan | 26017 | 14910 | 389 |
1860107 | 1860107 | 2021-10-28 | Benzie | Michigan | 26019 | 1653 | 40 |
1860108 | 1860108 | 2021-10-28 | Berrien | Michigan | 26021 | 19273 | 329 |
1860109 | 1860109 | 2021-10-28 | Branch | Michigan | 26023 | 7316 | 137 |
1860110 | 1860110 | 2021-10-28 | Calhoun | Michigan | 26025 | 18818 | 353 |
1860111 | 1860111 | 2021-10-28 | Cass | Michigan | 26027 | 7135 | 91 |
1860112 | 1860112 | 2021-10-28 | Charlevoix | Michigan | 26029 | 2581 | 34 |
1860113 | 1860113 | 2021-10-28 | Cheboygan | Michigan | 26031 | 2866 | 65 |
1860114 | 1860114 | 2021-10-28 | Chippewa | Michigan | 26033 | 6919 | 68 |
1860115 | 1860115 | 2021-10-28 | Clare | Michigan | 26035 | 3844 | 103 |
1860116 | 1860116 | 2021-10-28 | Clinton | Michigan | 26037 | 10123 | 110 |
1860117 | 1860117 | 2021-10-28 | Crawford | Michigan | 26039 | 1356 | 16 |
1860118 | 1860118 | 2021-10-28 | Delta | Michigan | 26041 | 5802 | 106 |
1860119 | 1860119 | 2021-10-28 | Dickinson | Michigan | 26043 | 4004 | 82 |
1860120 | 1860120 | 2021-10-28 | Eaton | Michigan | 26045 | 13207 | 245 |
1860121 | 1860121 | 2021-10-28 | Emmet | Michigan | 26047 | 3455 | 51 |
1860122 | 1860122 | 2021-10-28 | Genesee | Michigan | 26049 | 52166 | 1086 |
1860123 | 1860123 | 2021-10-28 | Gladwin | Michigan | 26051 | 3290 | 71 |
1860124 | 1860124 | 2021-10-28 | Gogebic | Michigan | 26053 | 1816 | 53 |
1860125 | 1860125 | 2021-10-28 | Grand Traverse | Michigan | 26055 | 8950 | 117 |
1860126 | 1860126 | 2021-10-28 | Gratiot | Michigan | 26057 | 8716 | 132 |
1860127 | 1860127 | 2021-10-28 | Hillsdale | Michigan | 26059 | 6211 | 124 |
1860128 | 1860128 | 2021-10-28 | Houghton | Michigan | 26061 | 4114 | 55 |
1860129 | 1860129 | 2021-10-28 | Huron | Michigan | 26063 | 4828 | 94 |
1860130 | 1860130 | 2021-10-28 | Ingham | Michigan | 26065 | 31042 | 457 |
1860131 | 1860131 | 2021-10-28 | Ionia | Michigan | 26067 | 11790 | 100 |
1860132 | 1860132 | 2021-10-28 | Iosco | Michigan | 26069 | 3023 | 96 |
1860133 | 1860133 | 2021-10-28 | Iron | Michigan | 26071 | 1427 | 56 |
1860134 | 1860134 | 2021-10-28 | Isabella | Michigan | 26073 | 9062 | 120 |
1860135 | 1860135 | 2021-10-28 | Jackson | Michigan | 26075 | 26039 | 363 |
1860136 | 1860136 | 2021-10-28 | Kalamazoo | Michigan | 26077 | 29723 | 454 |
1860137 | 1860137 | 2021-10-28 | Kalkaska | Michigan | 26079 | 1782 | 37 |
1860138 | 1860138 | 2021-10-28 | Kent | Michigan | 26081 | 93566 | 997 |
1860139 | 1860139 | 2021-10-28 | Keweenaw | Michigan | 26083 | 260 | 4 |
1860140 | 1860140 | 2021-10-28 | Lake | Michigan | 26085 | 966 | 22 |
1860141 | 1860141 | 2021-10-28 | Lapeer | Michigan | 26087 | 12113 | 253 |
1860142 | 1860142 | 2021-10-28 | Leelanau | Michigan | 26089 | 1640 | 25 |
1860143 | 1860143 | 2021-10-28 | Lenawee | Michigan | 26091 | 14657 | 203 |
1860144 | 1860144 | 2021-10-28 | Livingston | Michigan | 26093 | 23228 | 241 |
1860145 | 1860145 | 2021-10-28 | Luce | Michigan | 26095 | 1588 | 6 |
1860146 | 1860146 | 2021-10-28 | Mackinac | Michigan | 26097 | 1294 | 11 |
1860147 | 1860147 | 2021-10-28 | Macomb | Michigan | 26099 | 121963 | 2687 |
1860148 | 1860148 | 2021-10-28 | Manistee | Michigan | 26101 | 2512 | 38 |
1860149 | 1860149 | 2021-10-28 | Marquette | Michigan | 26103 | 8030 | 80 |
1860150 | 1860150 | 2021-10-28 | Mason | Michigan | 26105 | 3141 | 47 |
1860151 | 1860151 | 2021-10-28 | Mecosta | Michigan | 26107 | 4707 | 45 |
1860152 | 1860152 | 2021-10-28 | Menominee | Michigan | 26109 | 3357 | 51 |
1860153 | 1860153 | 2021-10-28 | Midland | Michigan | 26111 | 10379 | 134 |
1860154 | 1860154 | 2021-10-28 | Missaukee | Michigan | 26113 | 1846 | 37 |
1860155 | 1860155 | 2021-10-28 | Monroe | Michigan | 26115 | 20521 | 302 |
1860156 | 1860156 | 2021-10-28 | Montcalm | Michigan | 26117 | 10856 | 133 |
1860157 | 1860157 | 2021-10-28 | Montmorency | Michigan | 26119 | 953 | 26 |
1860158 | 1860158 | 2021-10-28 | Muskegon | Michigan | 26121 | 23479 | 426 |
1860159 | 1860159 | 2021-10-28 | Newaygo | Michigan | 26123 | 6612 | 84 |
1860160 | 1860160 | 2021-10-28 | Oakland | Michigan | 26125 | 146046 | 2682 |
1860161 | 1860161 | 2021-10-28 | Oceana | Michigan | 26127 | 3703 | 70 |
1860162 | 1860162 | 2021-10-28 | Ogemaw | Michigan | 26129 | 2737 | 59 |
1860163 | 1860163 | 2021-10-28 | Ontonagon | Michigan | 26131 | 613 | 22 |
1860164 | 1860164 | 2021-10-28 | Osceola | Michigan | 26133 | 3076 | 41 |
1860165 | 1860165 | 2021-10-28 | Oscoda | Michigan | 26135 | 956 | 38 |
1860166 | 1860166 | 2021-10-28 | Otsego | Michigan | 26137 | 3287 | 57 |
1860167 | 1860167 | 2021-10-28 | Ottawa | Michigan | 26139 | 41440 | 505 |
1860168 | 1860168 | 2021-10-28 | Presque Isle | Michigan | 26141 | 1373 | 39 |
1860169 | 1860169 | 2021-10-28 | Roscommon | Michigan | 26143 | 2551 | 65 |
1860170 | 1860170 | 2021-10-28 | Saginaw | Michigan | 26145 | 28509 | 676 |
1860171 | 1860171 | 2021-10-28 | Sanilac | Michigan | 26151 | 4996 | 135 |
1860172 | 1860172 | 2021-10-28 | Schoolcraft | Michigan | 26153 | 804 | 5 |
1860173 | 1860173 | 2021-10-28 | Shiawassee | Michigan | 26155 | 8727 | 130 |
1860174 | 1860174 | 2021-10-28 | St. Clair | Michigan | 26147 | 22502 | 515 |
1860175 | 1860175 | 2021-10-28 | St. Joseph | Michigan | 26149 | 8464 | 121 |
1860176 | 1860176 | 2021-10-28 | Tuscola | Michigan | 26157 | 7436 | 195 |
1860177 | 1860177 | 2021-10-28 | Unknown | Michigan | 1011 | 11 | |
1860178 | 1860178 | 2021-10-28 | Van Buren | Michigan | 26159 | 9282 | 165 |
1860179 | 1860179 | 2021-10-28 | Washtenaw | Michigan | 26161 | 34064 | 339 |
1860180 | 1860180 | 2021-10-28 | Wayne | Michigan | 26163 | 199451 | 5575 |
1860181 | 1860181 | 2021-10-28 | Wexford | Michigan | 26165 | 3683 | 53 |
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);