ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-11-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 |
---|---|---|---|---|---|---|---|
782131 | 782131 | 2020-11-30 | Alcona | Michigan | 26001 | 192 | 3 |
782132 | 782132 | 2020-11-30 | Alger | Michigan | 26003 | 246 | 2 |
782133 | 782133 | 2020-11-30 | Allegan | Michigan | 26005 | 4065 | 33 |
782134 | 782134 | 2020-11-30 | Alpena | Michigan | 26007 | 680 | 17 |
782135 | 782135 | 2020-11-30 | Antrim | Michigan | 26009 | 439 | 6 |
782136 | 782136 | 2020-11-30 | Arenac | Michigan | 26011 | 446 | 15 |
782137 | 782137 | 2020-11-30 | Baraga | Michigan | 26013 | 478 | 15 |
782138 | 782138 | 2020-11-30 | Barry | Michigan | 26015 | 2201 | 14 |
782139 | 782139 | 2020-11-30 | Bay | Michigan | 26017 | 4535 | 92 |
782140 | 782140 | 2020-11-30 | Benzie | Michigan | 26019 | 434 | 6 |
782141 | 782141 | 2020-11-30 | Berrien | Michigan | 26021 | 6897 | 115 |
782142 | 782142 | 2020-11-30 | Branch | Michigan | 26023 | 3116 | 55 |
782143 | 782143 | 2020-11-30 | Calhoun | Michigan | 26025 | 6035 | 121 |
782144 | 782144 | 2020-11-30 | Cass | Michigan | 26027 | 2239 | 29 |
782145 | 782145 | 2020-11-30 | Charlevoix | Michigan | 26029 | 595 | 8 |
782146 | 782146 | 2020-11-30 | Cheboygan | Michigan | 26031 | 497 | 20 |
782147 | 782147 | 2020-11-30 | Chippewa | Michigan | 26033 | 858 | 6 |
782148 | 782148 | 2020-11-30 | Clare | Michigan | 26035 | 771 | 25 |
782149 | 782149 | 2020-11-30 | Clinton | Michigan | 26037 | 2788 | 23 |
782150 | 782150 | 2020-11-30 | Crawford | Michigan | 26039 | 354 | 5 |
782151 | 782151 | 2020-11-30 | Delta | Michigan | 26041 | 2492 | 59 |
782152 | 782152 | 2020-11-30 | Dickinson | Michigan | 26043 | 1740 | 46 |
782153 | 782153 | 2020-11-30 | Eaton | Michigan | 26045 | 3178 | 42 |
782154 | 782154 | 2020-11-30 | Emmet | Michigan | 26047 | 976 | 28 |
782155 | 782155 | 2020-11-30 | Genesee | Michigan | 26049 | 15157 | 424 |
782156 | 782156 | 2020-11-30 | Gladwin | Michigan | 26051 | 835 | 12 |
782157 | 782157 | 2020-11-30 | Gogebic | Michigan | 26053 | 787 | 23 |
782158 | 782158 | 2020-11-30 | Grand Traverse | Michigan | 26055 | 1979 | 20 |
782159 | 782159 | 2020-11-30 | Gratiot | Michigan | 26057 | 1643 | 31 |
782160 | 782160 | 2020-11-30 | Hillsdale | Michigan | 26059 | 1694 | 39 |
782161 | 782161 | 2020-11-30 | Houghton | Michigan | 26061 | 1542 | 13 |
782162 | 782162 | 2020-11-30 | Huron | Michigan | 26063 | 801 | 15 |
782163 | 782163 | 2020-11-30 | Ingham | Michigan | 26065 | 9108 | 109 |
782164 | 782164 | 2020-11-30 | Ionia | Michigan | 26067 | 3177 | 16 |
782165 | 782165 | 2020-11-30 | Iosco | Michigan | 26069 | 758 | 26 |
782166 | 782166 | 2020-11-30 | Iron | Michigan | 26071 | 727 | 33 |
782167 | 782167 | 2020-11-30 | Isabella | Michigan | 26073 | 2484 | 21 |
782168 | 782168 | 2020-11-30 | Jackson | Michigan | 26075 | 6962 | 124 |
782169 | 782169 | 2020-11-30 | Kalamazoo | Michigan | 26077 | 9568 | 166 |
782170 | 782170 | 2020-11-30 | Kalkaska | Michigan | 26079 | 373 | 5 |
782171 | 782171 | 2020-11-30 | Kent | Michigan | 26081 | 33402 | 354 |
782172 | 782172 | 2020-11-30 | Keweenaw | Michigan | 26083 | 68 | 2 |
782173 | 782173 | 2020-11-30 | Lake | Michigan | 26085 | 206 | 5 |
782174 | 782174 | 2020-11-30 | Lapeer | Michigan | 26087 | 2884 | 60 |
782175 | 782175 | 2020-11-30 | Leelanau | Michigan | 26089 | 377 | 3 |
782176 | 782176 | 2020-11-30 | Lenawee | Michigan | 26091 | 3384 | 27 |
782177 | 782177 | 2020-11-30 | Livingston | Michigan | 26093 | 5746 | 48 |
782178 | 782178 | 2020-11-30 | Luce | Michigan | 26095 | 586 | 0 |
782179 | 782179 | 2020-11-30 | Mackinac | Michigan | 26097 | 291 | 0 |
782180 | 782180 | 2020-11-30 | Macomb | Michigan | 26099 | 37952 | 1283 |
782181 | 782181 | 2020-11-30 | Manistee | Michigan | 26101 | 393 | 5 |
782182 | 782182 | 2020-11-30 | Marquette | Michigan | 26103 | 3726 | 31 |
782183 | 782183 | 2020-11-30 | Mason | Michigan | 26105 | 611 | 11 |
782184 | 782184 | 2020-11-30 | Mecosta | Michigan | 26107 | 1261 | 9 |
782185 | 782185 | 2020-11-30 | Menominee | Michigan | 26109 | 1328 | 18 |
782186 | 782186 | 2020-11-30 | Midland | Michigan | 26111 | 3044 | 27 |
782187 | 782187 | 2020-11-30 | Missaukee | Michigan | 26113 | 293 | 5 |
782188 | 782188 | 2020-11-30 | Monroe | Michigan | 26115 | 5403 | 81 |
782189 | 782189 | 2020-11-30 | Montcalm | Michigan | 26117 | 2020 | 25 |
782190 | 782190 | 2020-11-30 | Montmorency | Michigan | 26119 | 184 | 2 |
782191 | 782191 | 2020-11-30 | Muskegon | Michigan | 26121 | 8507 | 175 |
782192 | 782192 | 2020-11-30 | Newaygo | Michigan | 26123 | 1632 | 17 |
782193 | 782193 | 2020-11-30 | Oakland | Michigan | 26125 | 46874 | 1364 |
782194 | 782194 | 2020-11-30 | Oceana | Michigan | 26127 | 1212 | 16 |
782195 | 782195 | 2020-11-30 | Ogemaw | Michigan | 26129 | 533 | 14 |
782196 | 782196 | 2020-11-30 | Ontonagon | Michigan | 26131 | 275 | 14 |
782197 | 782197 | 2020-11-30 | Osceola | Michigan | 26133 | 545 | 8 |
782198 | 782198 | 2020-11-30 | Oscoda | Michigan | 26135 | 178 | 4 |
782199 | 782199 | 2020-11-30 | Otsego | Michigan | 26137 | 769 | 18 |
782200 | 782200 | 2020-11-30 | Ottawa | Michigan | 26139 | 13912 | 158 |
782201 | 782201 | 2020-11-30 | Presque Isle | Michigan | 26141 | 284 | 4 |
782202 | 782202 | 2020-11-30 | Roscommon | Michigan | 26143 | 641 | 15 |
782203 | 782203 | 2020-11-30 | Saginaw | Michigan | 26145 | 8639 | 228 |
782204 | 782204 | 2020-11-30 | Sanilac | Michigan | 26151 | 816 | 16 |
782205 | 782205 | 2020-11-30 | Schoolcraft | Michigan | 26153 | 176 | 2 |
782206 | 782206 | 2020-11-30 | Shiawassee | Michigan | 26155 | 2008 | 42 |
782207 | 782207 | 2020-11-30 | St. Clair | Michigan | 26147 | 4535 | 83 |
782208 | 782208 | 2020-11-30 | St. Joseph | Michigan | 26149 | 2617 | 33 |
782209 | 782209 | 2020-11-30 | Tuscola | Michigan | 26157 | 1737 | 54 |
782210 | 782210 | 2020-11-30 | Unknown | Michigan | 5913 | 17 | |
782211 | 782211 | 2020-11-30 | Van Buren | Michigan | 26159 | 2884 | 44 |
782212 | 782212 | 2020-11-30 | Washtenaw | Michigan | 26161 | 10593 | 144 |
782213 | 782213 | 2020-11-30 | Wayne | Michigan | 26163 | 65146 | 3224 |
782214 | 782214 | 2020-11-30 | Wexford | Michigan | 26165 | 670 | 13 |
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);