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-12-03 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1977096 | 1977096 | 2021-12-03 | Alcona | Michigan | 26001 | 1346 | 51 |
1977097 | 1977097 | 2021-12-03 | Alger | Michigan | 26003 | 1159 | 9 |
1977098 | 1977098 | 2021-12-03 | Allegan | Michigan | 26005 | 18568 | 223 |
1977099 | 1977099 | 2021-12-03 | Alpena | Michigan | 26007 | 4134 | 88 |
1977100 | 1977100 | 2021-12-03 | Antrim | Michigan | 26009 | 2914 | 43 |
1977101 | 1977101 | 2021-12-03 | Arenac | Michigan | 26011 | 2146 | 45 |
1977102 | 1977102 | 2021-12-03 | Baraga | Michigan | 26013 | 1579 | 47 |
1977103 | 1977103 | 2021-12-03 | Barry | Michigan | 26015 | 9885 | 109 |
1977104 | 1977104 | 2021-12-03 | Bay | Michigan | 26017 | 17637 | 435 |
1977105 | 1977105 | 2021-12-03 | Benzie | Michigan | 26019 | 2170 | 44 |
1977106 | 1977106 | 2021-12-03 | Berrien | Michigan | 26021 | 22413 | 351 |
1977107 | 1977107 | 2021-12-03 | Branch | Michigan | 26023 | 8695 | 151 |
1977108 | 1977108 | 2021-12-03 | Calhoun | Michigan | 26025 | 22567 | 407 |
1977109 | 1977109 | 2021-12-03 | Cass | Michigan | 26027 | 8192 | 105 |
1977110 | 1977110 | 2021-12-03 | Charlevoix | Michigan | 26029 | 3112 | 44 |
1977111 | 1977111 | 2021-12-03 | Cheboygan | Michigan | 26031 | 3333 | 78 |
1977112 | 1977112 | 2021-12-03 | Chippewa | Michigan | 26033 | 7771 | 74 |
1977113 | 1977113 | 2021-12-03 | Clare | Michigan | 26035 | 4678 | 121 |
1977114 | 1977114 | 2021-12-03 | Clinton | Michigan | 26037 | 12755 | 135 |
1977115 | 1977115 | 2021-12-03 | Crawford | Michigan | 26039 | 1799 | 19 |
1977116 | 1977116 | 2021-12-03 | Delta | Michigan | 26041 | 6703 | 125 |
1977117 | 1977117 | 2021-12-03 | Dickinson | Michigan | 26043 | 4746 | 88 |
1977118 | 1977118 | 2021-12-03 | Eaton | Michigan | 26045 | 16523 | 285 |
1977119 | 1977119 | 2021-12-03 | Emmet | Michigan | 26047 | 4080 | 55 |
1977120 | 1977120 | 2021-12-03 | Genesee | Michigan | 26049 | 63328 | 1198 |
1977121 | 1977121 | 2021-12-03 | Gladwin | Michigan | 26051 | 3786 | 85 |
1977122 | 1977122 | 2021-12-03 | Gogebic | Michigan | 26053 | 2169 | 55 |
1977123 | 1977123 | 2021-12-03 | Grand Traverse | Michigan | 26055 | 11194 | 148 |
1977124 | 1977124 | 2021-12-03 | Gratiot | Michigan | 26057 | 10048 | 148 |
1977125 | 1977125 | 2021-12-03 | Hillsdale | Michigan | 26059 | 7575 | 151 |
1977126 | 1977126 | 2021-12-03 | Houghton | Michigan | 26061 | 5342 | 61 |
1977127 | 1977127 | 2021-12-03 | Huron | Michigan | 26063 | 5832 | 105 |
1977128 | 1977128 | 2021-12-03 | Ingham | Michigan | 26065 | 37505 | 514 |
1977129 | 1977129 | 2021-12-03 | Ionia | Michigan | 26067 | 14099 | 124 |
1977130 | 1977130 | 2021-12-03 | Iosco | Michigan | 26069 | 3574 | 105 |
1977131 | 1977131 | 2021-12-03 | Iron | Michigan | 26071 | 1749 | 68 |
1977132 | 1977132 | 2021-12-03 | Isabella | Michigan | 26073 | 10559 | 143 |
1977133 | 1977133 | 2021-12-03 | Jackson | Michigan | 26075 | 31620 | 417 |
1977134 | 1977134 | 2021-12-03 | Kalamazoo | Michigan | 26077 | 35615 | 496 |
1977135 | 1977135 | 2021-12-03 | Kalkaska | Michigan | 26079 | 2224 | 41 |
1977136 | 1977136 | 2021-12-03 | Kent | Michigan | 26081 | 112158 | 1130 |
1977137 | 1977137 | 2021-12-03 | Keweenaw | Michigan | 26083 | 375 | 9 |
1977138 | 1977138 | 2021-12-03 | Lake | Michigan | 26085 | 1225 | 27 |
1977139 | 1977139 | 2021-12-03 | Lapeer | Michigan | 26087 | 14570 | 292 |
1977140 | 1977140 | 2021-12-03 | Leelanau | Michigan | 26089 | 2223 | 35 |
1977141 | 1977141 | 2021-12-03 | Lenawee | Michigan | 26091 | 17744 | 227 |
1977142 | 1977142 | 2021-12-03 | Livingston | Michigan | 26093 | 29554 | 303 |
1977143 | 1977143 | 2021-12-03 | Luce | Michigan | 26095 | 1750 | 6 |
1977144 | 1977144 | 2021-12-03 | Mackinac | Michigan | 26097 | 1554 | 16 |
1977145 | 1977145 | 2021-12-03 | Macomb | Michigan | 26099 | 144365 | 2912 |
1977146 | 1977146 | 2021-12-03 | Manistee | Michigan | 26101 | 2993 | 49 |
1977147 | 1977147 | 2021-12-03 | Marquette | Michigan | 26103 | 9273 | 90 |
1977148 | 1977148 | 2021-12-03 | Mason | Michigan | 26105 | 4229 | 58 |
1977149 | 1977149 | 2021-12-03 | Mecosta | Michigan | 26107 | 5862 | 71 |
1977150 | 1977150 | 2021-12-03 | Menominee | Michigan | 26109 | 3922 | 57 |
1977151 | 1977151 | 2021-12-03 | Midland | Michigan | 26111 | 12326 | 164 |
1977152 | 1977152 | 2021-12-03 | Missaukee | Michigan | 26113 | 2110 | 42 |
1977153 | 1977153 | 2021-12-03 | Monroe | Michigan | 26115 | 24406 | 337 |
1977154 | 1977154 | 2021-12-03 | Montcalm | Michigan | 26117 | 12769 | 154 |
1977155 | 1977155 | 2021-12-03 | Montmorency | Michigan | 26119 | 1271 | 37 |
1977156 | 1977156 | 2021-12-03 | Muskegon | Michigan | 26121 | 29010 | 475 |
1977157 | 1977157 | 2021-12-03 | Newaygo | Michigan | 26123 | 8080 | 107 |
1977158 | 1977158 | 2021-12-03 | Oakland | Michigan | 26125 | 173149 | 2857 |
1977159 | 1977159 | 2021-12-03 | Oceana | Michigan | 26127 | 4577 | 75 |
1977160 | 1977160 | 2021-12-03 | Ogemaw | Michigan | 26129 | 3129 | 74 |
1977161 | 1977161 | 2021-12-03 | Ontonagon | Michigan | 26131 | 697 | 24 |
1977162 | 1977162 | 2021-12-03 | Osceola | Michigan | 26133 | 3619 | 50 |
1977163 | 1977163 | 2021-12-03 | Oscoda | Michigan | 26135 | 1112 | 47 |
1977164 | 1977164 | 2021-12-03 | Otsego | Michigan | 26137 | 4017 | 69 |
1977165 | 1977165 | 2021-12-03 | Ottawa | Michigan | 26139 | 50897 | 573 |
1977166 | 1977166 | 2021-12-03 | Presque Isle | Michigan | 26141 | 1634 | 48 |
1977167 | 1977167 | 2021-12-03 | Roscommon | Michigan | 26143 | 3368 | 88 |
1977168 | 1977168 | 2021-12-03 | Saginaw | Michigan | 26145 | 33727 | 729 |
1977169 | 1977169 | 2021-12-03 | Sanilac | Michigan | 26151 | 6182 | 153 |
1977170 | 1977170 | 2021-12-03 | Schoolcraft | Michigan | 26153 | 1074 | 7 |
1977171 | 1977171 | 2021-12-03 | Shiawassee | Michigan | 26155 | 11435 | 154 |
1977172 | 1977172 | 2021-12-03 | St. Clair | Michigan | 26147 | 27089 | 562 |
1977173 | 1977173 | 2021-12-03 | St. Joseph | Michigan | 26149 | 10047 | 136 |
1977174 | 1977174 | 2021-12-03 | Tuscola | Michigan | 26157 | 9106 | 222 |
1977175 | 1977175 | 2021-12-03 | Unknown | Michigan | 2091 | 18 | |
1977176 | 1977176 | 2021-12-03 | Van Buren | Michigan | 26159 | 11333 | 188 |
1977177 | 1977177 | 2021-12-03 | Washtenaw | Michigan | 26161 | 40288 | 361 |
1977178 | 1977178 | 2021-12-03 | Wayne | Michigan | 26163 | 234369 | 5977 |
1977179 | 1977179 | 2021-12-03 | Wexford | Michigan | 26165 | 4634 | 76 |
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);