ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-09-02" 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 |
---|---|---|---|---|---|---|---|
1678153 | 1678153 | 2021-09-02 | Alcona | Michigan | 26001 | 831 | 36 |
1678154 | 1678154 | 2021-09-02 | Alger | Michigan | 26003 | 714 | 7 |
1678155 | 1678155 | 2021-09-02 | Allegan | Michigan | 26005 | 12088 | 166 |
1678156 | 1678156 | 2021-09-02 | Alpena | Michigan | 26007 | 2505 | 66 |
1678157 | 1678157 | 2021-09-02 | Antrim | Michigan | 26009 | 1779 | 33 |
1678158 | 1678158 | 2021-09-02 | Arenac | Michigan | 26011 | 1299 | 31 |
1678159 | 1678159 | 2021-09-02 | Baraga | Michigan | 26013 | 1057 | 41 |
1678160 | 1678160 | 2021-09-02 | Barry | Michigan | 26015 | 6381 | 74 |
1678161 | 1678161 | 2021-09-02 | Bay | Michigan | 26017 | 11828 | 364 |
1678162 | 1678162 | 2021-09-02 | Benzie | Michigan | 26019 | 1358 | 38 |
1678163 | 1678163 | 2021-09-02 | Berrien | Michigan | 26021 | 16631 | 305 |
1678164 | 1678164 | 2021-09-02 | Branch | Michigan | 26023 | 6400 | 126 |
1678165 | 1678165 | 2021-09-02 | Calhoun | Michigan | 26025 | 15578 | 327 |
1678166 | 1678166 | 2021-09-02 | Cass | Michigan | 26027 | 5899 | 80 |
1678167 | 1678167 | 2021-09-02 | Charlevoix | Michigan | 26029 | 1938 | 27 |
1678168 | 1678168 | 2021-09-02 | Cheboygan | Michigan | 26031 | 2085 | 52 |
1678169 | 1678169 | 2021-09-02 | Chippewa | Michigan | 26033 | 5826 | 50 |
1678170 | 1678170 | 2021-09-02 | Clare | Michigan | 26035 | 2691 | 88 |
1678171 | 1678171 | 2021-09-02 | Clinton | Michigan | 26037 | 8146 | 97 |
1678172 | 1678172 | 2021-09-02 | Crawford | Michigan | 26039 | 1056 | 14 |
1678173 | 1678173 | 2021-09-02 | Delta | Michigan | 26041 | 4496 | 95 |
1678174 | 1678174 | 2021-09-02 | Dickinson | Michigan | 26043 | 2937 | 74 |
1678175 | 1678175 | 2021-09-02 | Eaton | Michigan | 26045 | 10926 | 213 |
1678176 | 1678176 | 2021-09-02 | Emmet | Michigan | 26047 | 2622 | 45 |
1678177 | 1678177 | 2021-09-02 | Genesee | Michigan | 26049 | 44345 | 1001 |
1678178 | 1678178 | 2021-09-02 | Gladwin | Michigan | 26051 | 2451 | 62 |
1678179 | 1678179 | 2021-09-02 | Gogebic | Michigan | 26053 | 1530 | 53 |
1678180 | 1678180 | 2021-09-02 | Grand Traverse | Michigan | 26055 | 7050 | 103 |
1678181 | 1678181 | 2021-09-02 | Gratiot | Michigan | 26057 | 7194 | 126 |
1678182 | 1678182 | 2021-09-02 | Hillsdale | Michigan | 26059 | 4768 | 99 |
1678183 | 1678183 | 2021-09-02 | Houghton | Michigan | 26061 | 3315 | 45 |
1678184 | 1678184 | 2021-09-02 | Huron | Michigan | 26063 | 4297 | 86 |
1678185 | 1678185 | 2021-09-02 | Ingham | Michigan | 26065 | 26526 | 409 |
1678186 | 1678186 | 2021-09-02 | Ionia | Michigan | 26067 | 9766 | 87 |
1678187 | 1678187 | 2021-09-02 | Iosco | Michigan | 26069 | 2182 | 78 |
1678188 | 1678188 | 2021-09-02 | Iron | Michigan | 26071 | 1144 | 53 |
1678189 | 1678189 | 2021-09-02 | Isabella | Michigan | 26073 | 6669 | 102 |
1678190 | 1678190 | 2021-09-02 | Jackson | Michigan | 26075 | 22333 | 336 |
1678191 | 1678191 | 2021-09-02 | Kalamazoo | Michigan | 26077 | 25208 | 418 |
1678192 | 1678192 | 2021-09-02 | Kalkaska | Michigan | 26079 | 1249 | 30 |
1678193 | 1678193 | 2021-09-02 | Kent | Michigan | 26081 | 78266 | 889 |
1678194 | 1678194 | 2021-09-02 | Keweenaw | Michigan | 26083 | 184 | 2 |
1678195 | 1678195 | 2021-09-02 | Lake | Michigan | 26085 | 706 | 17 |
1678196 | 1678196 | 2021-09-02 | Lapeer | Michigan | 26087 | 10315 | 219 |
1678197 | 1678197 | 2021-09-02 | Leelanau | Michigan | 26089 | 1355 | 21 |
1678198 | 1678198 | 2021-09-02 | Lenawee | Michigan | 26091 | 11628 | 183 |
1678199 | 1678199 | 2021-09-02 | Livingston | Michigan | 26093 | 18445 | 204 |
1678200 | 1678200 | 2021-09-02 | Luce | Michigan | 26095 | 1359 | 6 |
1678201 | 1678201 | 2021-09-02 | Mackinac | Michigan | 26097 | 804 | 3 |
1678202 | 1678202 | 2021-09-02 | Macomb | Michigan | 26099 | 106248 | 2545 |
1678203 | 1678203 | 2021-09-02 | Manistee | Michigan | 26101 | 2133 | 28 |
1678204 | 1678204 | 2021-09-02 | Marquette | Michigan | 26103 | 6183 | 67 |
1678205 | 1678205 | 2021-09-02 | Mason | Michigan | 26105 | 2409 | 39 |
1678206 | 1678206 | 2021-09-02 | Mecosta | Michigan | 26107 | 3418 | 38 |
1678207 | 1678207 | 2021-09-02 | Menominee | Michigan | 26109 | 2405 | 44 |
1678208 | 1678208 | 2021-09-02 | Midland | Michigan | 26111 | 8089 | 102 |
1678209 | 1678209 | 2021-09-02 | Missaukee | Michigan | 26113 | 1558 | 29 |
1678210 | 1678210 | 2021-09-02 | Monroe | Michigan | 26115 | 16440 | 276 |
1678211 | 1678211 | 2021-09-02 | Montcalm | Michigan | 26117 | 8567 | 123 |
1678212 | 1678212 | 2021-09-02 | Montmorency | Michigan | 26119 | 695 | 20 |
1678213 | 1678213 | 2021-09-02 | Muskegon | Michigan | 26121 | 19511 | 390 |
1678214 | 1678214 | 2021-09-02 | Newaygo | Michigan | 26123 | 5136 | 70 |
1678215 | 1678215 | 2021-09-02 | Oakland | Michigan | 26125 | 127180 | 2516 |
1678216 | 1678216 | 2021-09-02 | Oceana | Michigan | 26127 | 2900 | 62 |
1678217 | 1678217 | 2021-09-02 | Ogemaw | Michigan | 26129 | 1915 | 45 |
1678218 | 1678218 | 2021-09-02 | Ontonagon | Michigan | 26131 | 530 | 22 |
1678219 | 1678219 | 2021-09-02 | Osceola | Michigan | 26133 | 2085 | 31 |
1678220 | 1678220 | 2021-09-02 | Oscoda | Michigan | 26135 | 728 | 31 |
1678221 | 1678221 | 2021-09-02 | Otsego | Michigan | 26137 | 2568 | 41 |
1678222 | 1678222 | 2021-09-02 | Ottawa | Michigan | 26139 | 35074 | 452 |
1678223 | 1678223 | 2021-09-02 | Presque Isle | Michigan | 26141 | 1114 | 34 |
1678224 | 1678224 | 2021-09-02 | Roscommon | Michigan | 26143 | 1982 | 55 |
1678225 | 1678225 | 2021-09-02 | Saginaw | Michigan | 26145 | 23960 | 646 |
1678226 | 1678226 | 2021-09-02 | Sanilac | Michigan | 26151 | 4390 | 128 |
1678227 | 1678227 | 2021-09-02 | Schoolcraft | Michigan | 26153 | 493 | 5 |
1678228 | 1678228 | 2021-09-02 | Shiawassee | Michigan | 26155 | 6962 | 112 |
1678229 | 1678229 | 2021-09-02 | St. Clair | Michigan | 26147 | 19352 | 462 |
1678230 | 1678230 | 2021-09-02 | St. Joseph | Michigan | 26149 | 6721 | 104 |
1678231 | 1678231 | 2021-09-02 | Tuscola | Michigan | 26157 | 6003 | 177 |
1678232 | 1678232 | 2021-09-02 | Unknown | Michigan | 812 | 18 | |
1678233 | 1678233 | 2021-09-02 | Van Buren | Michigan | 26159 | 7685 | 141 |
1678234 | 1678234 | 2021-09-02 | Washtenaw | Michigan | 26161 | 29199 | 316 |
1678235 | 1678235 | 2021-09-02 | Wayne | Michigan | 26163 | 176513 | 5304 |
1678236 | 1678236 | 2021-09-02 | Wexford | Michigan | 26165 | 2997 | 49 |
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);