ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-09-30" 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 |
---|---|---|---|---|---|---|---|
1769120 | 1769120 | 2021-09-30 | Alcona | Michigan | 26001 | 930 | 39 |
1769121 | 1769121 | 2021-09-30 | Alger | Michigan | 26003 | 866 | 7 |
1769122 | 1769122 | 2021-09-30 | Allegan | Michigan | 26005 | 13245 | 176 |
1769123 | 1769123 | 2021-09-30 | Alpena | Michigan | 26007 | 2769 | 69 |
1769124 | 1769124 | 2021-09-30 | Antrim | Michigan | 26009 | 2004 | 34 |
1769125 | 1769125 | 2021-09-30 | Arenac | Michigan | 26011 | 1469 | 31 |
1769126 | 1769126 | 2021-09-30 | Baraga | Michigan | 26013 | 1169 | 45 |
1769127 | 1769127 | 2021-09-30 | Barry | Michigan | 26015 | 7027 | 76 |
1769128 | 1769128 | 2021-09-30 | Bay | Michigan | 26017 | 12976 | 370 |
1769129 | 1769129 | 2021-09-30 | Benzie | Michigan | 26019 | 1483 | 38 |
1769130 | 1769130 | 2021-09-30 | Berrien | Michigan | 26021 | 18096 | 312 |
1769131 | 1769131 | 2021-09-30 | Branch | Michigan | 26023 | 6860 | 133 |
1769132 | 1769132 | 2021-09-30 | Calhoun | Michigan | 26025 | 16966 | 337 |
1769133 | 1769133 | 2021-09-30 | Cass | Michigan | 26027 | 6561 | 85 |
1769134 | 1769134 | 2021-09-30 | Charlevoix | Michigan | 26029 | 2163 | 29 |
1769135 | 1769135 | 2021-09-30 | Cheboygan | Michigan | 26031 | 2417 | 57 |
1769136 | 1769136 | 2021-09-30 | Chippewa | Michigan | 26033 | 6288 | 52 |
1769137 | 1769137 | 2021-09-30 | Clare | Michigan | 26035 | 3063 | 92 |
1769138 | 1769138 | 2021-09-30 | Clinton | Michigan | 26037 | 8837 | 102 |
1769139 | 1769139 | 2021-09-30 | Crawford | Michigan | 26039 | 1153 | 15 |
1769140 | 1769140 | 2021-09-30 | Delta | Michigan | 26041 | 5159 | 100 |
1769141 | 1769141 | 2021-09-30 | Dickinson | Michigan | 26043 | 3528 | 75 |
1769142 | 1769142 | 2021-09-30 | Eaton | Michigan | 26045 | 11870 | 228 |
1769143 | 1769143 | 2021-09-30 | Emmet | Michigan | 26047 | 2951 | 47 |
1769144 | 1769144 | 2021-09-30 | Genesee | Michigan | 26049 | 47361 | 1033 |
1769145 | 1769145 | 2021-09-30 | Gladwin | Michigan | 26051 | 2848 | 66 |
1769146 | 1769146 | 2021-09-30 | Gogebic | Michigan | 26053 | 1626 | 52 |
1769147 | 1769147 | 2021-09-30 | Grand Traverse | Michigan | 26055 | 7927 | 107 |
1769148 | 1769148 | 2021-09-30 | Gratiot | Michigan | 26057 | 7747 | 127 |
1769149 | 1769149 | 2021-09-30 | Hillsdale | Michigan | 26059 | 5485 | 109 |
1769150 | 1769150 | 2021-09-30 | Houghton | Michigan | 26061 | 3536 | 51 |
1769151 | 1769151 | 2021-09-30 | Huron | Michigan | 26063 | 4479 | 88 |
1769152 | 1769152 | 2021-09-30 | Ingham | Michigan | 26065 | 28537 | 432 |
1769153 | 1769153 | 2021-09-30 | Ionia | Michigan | 26067 | 10622 | 91 |
1769154 | 1769154 | 2021-09-30 | Iosco | Michigan | 26069 | 2551 | 85 |
1769155 | 1769155 | 2021-09-30 | Iron | Michigan | 26071 | 1264 | 53 |
1769156 | 1769156 | 2021-09-30 | Isabella | Michigan | 26073 | 7802 | 105 |
1769157 | 1769157 | 2021-09-30 | Jackson | Michigan | 26075 | 23831 | 347 |
1769158 | 1769158 | 2021-09-30 | Kalamazoo | Michigan | 26077 | 27187 | 434 |
1769159 | 1769159 | 2021-09-30 | Kalkaska | Michigan | 26079 | 1496 | 30 |
1769160 | 1769160 | 2021-09-30 | Kent | Michigan | 26081 | 84970 | 933 |
1769161 | 1769161 | 2021-09-30 | Keweenaw | Michigan | 26083 | 214 | 4 |
1769162 | 1769162 | 2021-09-30 | Lake | Michigan | 26085 | 814 | 18 |
1769163 | 1769163 | 2021-09-30 | Lapeer | Michigan | 26087 | 11001 | 236 |
1769164 | 1769164 | 2021-09-30 | Leelanau | Michigan | 26089 | 1495 | 22 |
1769165 | 1769165 | 2021-09-30 | Lenawee | Michigan | 26091 | 12857 | 192 |
1769166 | 1769166 | 2021-09-30 | Livingston | Michigan | 26093 | 20288 | 216 |
1769167 | 1769167 | 2021-09-30 | Luce | Michigan | 26095 | 1449 | 6 |
1769168 | 1769168 | 2021-09-30 | Mackinac | Michigan | 26097 | 1025 | 6 |
1769169 | 1769169 | 2021-09-30 | Macomb | Michigan | 26099 | 112792 | 2603 |
1769170 | 1769170 | 2021-09-30 | Manistee | Michigan | 26101 | 2290 | 33 |
1769171 | 1769171 | 2021-09-30 | Marquette | Michigan | 26103 | 7030 | 71 |
1769172 | 1769172 | 2021-09-30 | Mason | Michigan | 26105 | 2708 | 43 |
1769173 | 1769173 | 2021-09-30 | Mecosta | Michigan | 26107 | 3957 | 41 |
1769174 | 1769174 | 2021-09-30 | Menominee | Michigan | 26109 | 2874 | 48 |
1769175 | 1769175 | 2021-09-30 | Midland | Michigan | 26111 | 9052 | 115 |
1769176 | 1769176 | 2021-09-30 | Missaukee | Michigan | 26113 | 1695 | 30 |
1769177 | 1769177 | 2021-09-30 | Monroe | Michigan | 26115 | 18135 | 289 |
1769178 | 1769178 | 2021-09-30 | Montcalm | Michigan | 26117 | 9373 | 128 |
1769179 | 1769179 | 2021-09-30 | Montmorency | Michigan | 26119 | 782 | 23 |
1769180 | 1769180 | 2021-09-30 | Muskegon | Michigan | 26121 | 21239 | 410 |
1769181 | 1769181 | 2021-09-30 | Newaygo | Michigan | 26123 | 5789 | 71 |
1769182 | 1769182 | 2021-09-30 | Oakland | Michigan | 26125 | 135378 | 2585 |
1769183 | 1769183 | 2021-09-30 | Oceana | Michigan | 26127 | 3265 | 65 |
1769184 | 1769184 | 2021-09-30 | Ogemaw | Michigan | 26129 | 2213 | 46 |
1769185 | 1769185 | 2021-09-30 | Ontonagon | Michigan | 26131 | 569 | 22 |
1769186 | 1769186 | 2021-09-30 | Osceola | Michigan | 26133 | 2452 | 34 |
1769187 | 1769187 | 2021-09-30 | Oscoda | Michigan | 26135 | 818 | 32 |
1769188 | 1769188 | 2021-09-30 | Otsego | Michigan | 26137 | 2822 | 47 |
1769189 | 1769189 | 2021-09-30 | Ottawa | Michigan | 26139 | 37872 | 475 |
1769190 | 1769190 | 2021-09-30 | Presque Isle | Michigan | 26141 | 1228 | 35 |
1769191 | 1769191 | 2021-09-30 | Roscommon | Michigan | 26143 | 2149 | 59 |
1769192 | 1769192 | 2021-09-30 | Saginaw | Michigan | 26145 | 25841 | 659 |
1769193 | 1769193 | 2021-09-30 | Sanilac | Michigan | 26151 | 4571 | 128 |
1769194 | 1769194 | 2021-09-30 | Schoolcraft | Michigan | 26153 | 621 | 5 |
1769195 | 1769195 | 2021-09-30 | Shiawassee | Michigan | 26155 | 7721 | 120 |
1769196 | 1769196 | 2021-09-30 | St. Clair | Michigan | 26147 | 20618 | 486 |
1769197 | 1769197 | 2021-09-30 | St. Joseph | Michigan | 26149 | 7542 | 111 |
1769198 | 1769198 | 2021-09-30 | Tuscola | Michigan | 26157 | 6585 | 183 |
1769199 | 1769199 | 2021-09-30 | Unknown | Michigan | 898 | 18 | |
1769200 | 1769200 | 2021-09-30 | Van Buren | Michigan | 26159 | 8370 | 151 |
1769201 | 1769201 | 2021-09-30 | Washtenaw | Michigan | 26161 | 31354 | 325 |
1769202 | 1769202 | 2021-09-30 | Wayne | Michigan | 26163 | 186206 | 5404 |
1769203 | 1769203 | 2021-09-30 | Wexford | Michigan | 26165 | 3232 | 50 |
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);