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-12 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2107122 | 2107122 | 2022-01-12 | Alcona | Michigan | 26001 | 1500 | 60 |
2107123 | 2107123 | 2022-01-12 | Alger | Michigan | 26003 | 1414 | 11 |
2107124 | 2107124 | 2022-01-12 | Allegan | Michigan | 26005 | 22184 | 290 |
2107125 | 2107125 | 2022-01-12 | Alpena | Michigan | 26007 | 4751 | 119 |
2107126 | 2107126 | 2022-01-12 | Antrim | Michigan | 26009 | 3517 | 52 |
2107127 | 2107127 | 2022-01-12 | Arenac | Michigan | 26011 | 2557 | 56 |
2107128 | 2107128 | 2022-01-12 | Baraga | Michigan | 26013 | 1823 | 49 |
2107129 | 2107129 | 2022-01-12 | Barry | Michigan | 26015 | 11645 | 137 |
2107130 | 2107130 | 2022-01-12 | Bay | Michigan | 26017 | 21196 | 500 |
2107131 | 2107131 | 2022-01-12 | Benzie | Michigan | 26019 | 2658 | 56 |
2107132 | 2107132 | 2022-01-12 | Berrien | Michigan | 26021 | 28681 | 428 |
2107133 | 2107133 | 2022-01-12 | Branch | Michigan | 26023 | 9974 | 171 |
2107134 | 2107134 | 2022-01-12 | Calhoun | Michigan | 26025 | 27223 | 491 |
2107135 | 2107135 | 2022-01-12 | Cass | Michigan | 26027 | 9644 | 116 |
2107136 | 2107136 | 2022-01-12 | Charlevoix | Michigan | 26029 | 3977 | 54 |
2107137 | 2107137 | 2022-01-12 | Cheboygan | Michigan | 26031 | 3952 | 84 |
2107138 | 2107138 | 2022-01-12 | Chippewa | Michigan | 26033 | 9119 | 88 |
2107139 | 2107139 | 2022-01-12 | Clare | Michigan | 26035 | 5478 | 142 |
2107140 | 2107140 | 2022-01-12 | Clinton | Michigan | 26037 | 15953 | 170 |
2107141 | 2107141 | 2022-01-12 | Crawford | Michigan | 26039 | 2073 | 23 |
2107142 | 2107142 | 2022-01-12 | Delta | Michigan | 26041 | 7862 | 139 |
2107143 | 2107143 | 2022-01-12 | Dickinson | Michigan | 26043 | 5712 | 95 |
2107144 | 2107144 | 2022-01-12 | Eaton | Michigan | 26045 | 20884 | 333 |
2107145 | 2107145 | 2022-01-12 | Emmet | Michigan | 26047 | 5124 | 65 |
2107146 | 2107146 | 2022-01-12 | Genesee | Michigan | 26049 | 82639 | 1425 |
2107147 | 2107147 | 2022-01-12 | Gladwin | Michigan | 26051 | 4538 | 101 |
2107148 | 2107148 | 2022-01-12 | Gogebic | Michigan | 26053 | 2572 | 63 |
2107149 | 2107149 | 2022-01-12 | Grand Traverse | Michigan | 26055 | 13554 | 188 |
2107150 | 2107150 | 2022-01-12 | Gratiot | Michigan | 26057 | 11382 | 169 |
2107151 | 2107151 | 2022-01-12 | Hillsdale | Michigan | 26059 | 8619 | 176 |
2107152 | 2107152 | 2022-01-12 | Houghton | Michigan | 26061 | 6132 | 77 |
2107153 | 2107153 | 2022-01-12 | Huron | Michigan | 26063 | 6679 | 129 |
2107154 | 2107154 | 2022-01-12 | Ingham | Michigan | 26065 | 49440 | 612 |
2107155 | 2107155 | 2022-01-12 | Ionia | Michigan | 26067 | 16146 | 152 |
2107156 | 2107156 | 2022-01-12 | Iosco | Michigan | 26069 | 4090 | 119 |
2107157 | 2107157 | 2022-01-12 | Iron | Michigan | 26071 | 2041 | 74 |
2107158 | 2107158 | 2022-01-12 | Isabella | Michigan | 26073 | 12554 | 171 |
2107159 | 2107159 | 2022-01-12 | Jackson | Michigan | 26075 | 37305 | 489 |
2107160 | 2107160 | 2022-01-12 | Kalamazoo | Michigan | 26077 | 46870 | 569 |
2107161 | 2107161 | 2022-01-12 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2107162 | 2107162 | 2022-01-12 | Kent | Michigan | 26081 | 138186 | 1326 |
2107163 | 2107163 | 2022-01-12 | Keweenaw | Michigan | 26083 | 409 | 11 |
2107164 | 2107164 | 2022-01-12 | Lake | Michigan | 26085 | 1477 | 32 |
2107165 | 2107165 | 2022-01-12 | Lapeer | Michigan | 26087 | 17555 | 363 |
2107166 | 2107166 | 2022-01-12 | Leelanau | Michigan | 26089 | 2834 | 42 |
2107167 | 2107167 | 2022-01-12 | Lenawee | Michigan | 26091 | 21216 | 272 |
2107168 | 2107168 | 2022-01-12 | Livingston | Michigan | 26093 | 37370 | 377 |
2107169 | 2107169 | 2022-01-12 | Luce | Michigan | 26095 | 1990 | 6 |
2107170 | 2107170 | 2022-01-12 | Mackinac | Michigan | 26097 | 1900 | 24 |
2107171 | 2107171 | 2022-01-12 | Macomb | Michigan | 26099 | 190201 | 3367 |
2107172 | 2107172 | 2022-01-12 | Manistee | Michigan | 26101 | 3516 | 65 |
2107173 | 2107173 | 2022-01-12 | Marquette | Michigan | 26103 | 11875 | 100 |
2107174 | 2107174 | 2022-01-12 | Mason | Michigan | 26105 | 5120 | 74 |
2107175 | 2107175 | 2022-01-12 | Mecosta | Michigan | 26107 | 6885 | 89 |
2107176 | 2107176 | 2022-01-12 | Menominee | Michigan | 26109 | 4550 | 64 |
2107177 | 2107177 | 2022-01-12 | Midland | Michigan | 26111 | 15049 | 193 |
2107178 | 2107178 | 2022-01-12 | Missaukee | Michigan | 26113 | 2348 | 54 |
2107179 | 2107179 | 2022-01-12 | Monroe | Michigan | 26115 | 31462 | 391 |
2107180 | 2107180 | 2022-01-12 | Montcalm | Michigan | 26117 | 14428 | 182 |
2107181 | 2107181 | 2022-01-12 | Montmorency | Michigan | 26119 | 1428 | 43 |
2107182 | 2107182 | 2022-01-12 | Muskegon | Michigan | 26121 | 34864 | 545 |
2107183 | 2107183 | 2022-01-12 | Newaygo | Michigan | 26123 | 9387 | 133 |
2107184 | 2107184 | 2022-01-12 | Oakland | Michigan | 26125 | 232417 | 3244 |
2107185 | 2107185 | 2022-01-12 | Oceana | Michigan | 26127 | 5191 | 84 |
2107186 | 2107186 | 2022-01-12 | Ogemaw | Michigan | 26129 | 3557 | 84 |
2107187 | 2107187 | 2022-01-12 | Ontonagon | Michigan | 26131 | 832 | 28 |
2107188 | 2107188 | 2022-01-12 | Osceola | Michigan | 26133 | 4113 | 66 |
2107189 | 2107189 | 2022-01-12 | Oscoda | Michigan | 26135 | 1227 | 51 |
2107190 | 2107190 | 2022-01-12 | Otsego | Michigan | 26137 | 4593 | 86 |
2107191 | 2107191 | 2022-01-12 | Ottawa | Michigan | 26139 | 61146 | 684 |
2107192 | 2107192 | 2022-01-12 | Presque Isle | Michigan | 26141 | 1826 | 52 |
2107193 | 2107193 | 2022-01-12 | Roscommon | Michigan | 26143 | 3861 | 107 |
2107194 | 2107194 | 2022-01-12 | Saginaw | Michigan | 26145 | 40757 | 833 |
2107195 | 2107195 | 2022-01-12 | Sanilac | Michigan | 26151 | 7309 | 168 |
2107196 | 2107196 | 2022-01-12 | Schoolcraft | Michigan | 26153 | 1365 | 9 |
2107197 | 2107197 | 2022-01-12 | Shiawassee | Michigan | 26155 | 14120 | 196 |
2107198 | 2107198 | 2022-01-12 | St. Clair | Michigan | 26147 | 34077 | 707 |
2107199 | 2107199 | 2022-01-12 | St. Joseph | Michigan | 26149 | 11489 | 171 |
2107200 | 2107200 | 2022-01-12 | Tuscola | Michigan | 26157 | 10762 | 247 |
2107201 | 2107201 | 2022-01-12 | Unknown | Michigan | 4158 | 27 | |
2107202 | 2107202 | 2022-01-12 | Van Buren | Michigan | 26159 | 14067 | 225 |
2107203 | 2107203 | 2022-01-12 | Washtenaw | Michigan | 26161 | 57534 | 440 |
2107204 | 2107204 | 2022-01-12 | Wayne | Michigan | 26163 | 325483 | 6734 |
2107205 | 2107205 | 2022-01-12 | Wexford | Michigan | 26165 | 5362 | 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);