ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-06-01" 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 |
---|---|---|---|---|---|---|---|
1376181 | 1376181 | 2021-06-01 | Alcona | Michigan | 26001 | 738 | 32 |
1376182 | 1376182 | 2021-06-01 | Alger | Michigan | 26003 | 666 | 6 |
1376183 | 1376183 | 2021-06-01 | Allegan | Michigan | 26005 | 11092 | 150 |
1376184 | 1376184 | 2021-06-01 | Alpena | Michigan | 26007 | 2259 | 60 |
1376185 | 1376185 | 2021-06-01 | Antrim | Michigan | 26009 | 1630 | 29 |
1376186 | 1376186 | 2021-06-01 | Arenac | Michigan | 26011 | 1203 | 29 |
1376187 | 1376187 | 2021-06-01 | Baraga | Michigan | 26013 | 981 | 38 |
1376188 | 1376188 | 2021-06-01 | Barry | Michigan | 26015 | 5926 | 67 |
1376189 | 1376189 | 2021-06-01 | Bay | Michigan | 26017 | 11213 | 346 |
1376190 | 1376190 | 2021-06-01 | Benzie | Michigan | 26019 | 1274 | 35 |
1376191 | 1376191 | 2021-06-01 | Berrien | Michigan | 26021 | 15490 | 286 |
1376192 | 1376192 | 2021-06-01 | Branch | Michigan | 26023 | 5657 | 120 |
1376193 | 1376193 | 2021-06-01 | Calhoun | Michigan | 26025 | 14419 | 304 |
1376194 | 1376194 | 2021-06-01 | Cass | Michigan | 26027 | 5448 | 76 |
1376195 | 1376195 | 2021-06-01 | Charlevoix | Michigan | 26029 | 1668 | 21 |
1376196 | 1376196 | 2021-06-01 | Cheboygan | Michigan | 26031 | 1923 | 45 |
1376197 | 1376197 | 2021-06-01 | Chippewa | Michigan | 26033 | 5592 | 49 |
1376198 | 1376198 | 2021-06-01 | Clare | Michigan | 26035 | 2461 | 81 |
1376199 | 1376199 | 2021-06-01 | Clinton | Michigan | 26037 | 7588 | 89 |
1376200 | 1376200 | 2021-06-01 | Crawford | Michigan | 26039 | 991 | 14 |
1376201 | 1376201 | 2021-06-01 | Delta | Michigan | 26041 | 4029 | 94 |
1376202 | 1376202 | 2021-06-01 | Dickinson | Michigan | 26043 | 2733 | 74 |
1376203 | 1376203 | 2021-06-01 | Eaton | Michigan | 26045 | 10099 | 208 |
1376204 | 1376204 | 2021-06-01 | Emmet | Michigan | 26047 | 2371 | 42 |
1376205 | 1376205 | 2021-06-01 | Genesee | Michigan | 26049 | 41593 | 946 |
1376206 | 1376206 | 2021-06-01 | Gladwin | Michigan | 26051 | 2297 | 59 |
1376207 | 1376207 | 2021-06-01 | Gogebic | Michigan | 26053 | 1402 | 50 |
1376208 | 1376208 | 2021-06-01 | Grand Traverse | Michigan | 26055 | 6449 | 96 |
1376209 | 1376209 | 2021-06-01 | Gratiot | Michigan | 26057 | 6956 | 124 |
1376210 | 1376210 | 2021-06-01 | Hillsdale | Michigan | 26059 | 4389 | 93 |
1376211 | 1376211 | 2021-06-01 | Houghton | Michigan | 26061 | 3129 | 42 |
1376212 | 1376212 | 2021-06-01 | Huron | Michigan | 26063 | 4079 | 79 |
1376213 | 1376213 | 2021-06-01 | Ingham | Michigan | 26065 | 24761 | 382 |
1376214 | 1376214 | 2021-06-01 | Ionia | Michigan | 26067 | 9270 | 85 |
1376215 | 1376215 | 2021-06-01 | Iosco | Michigan | 26069 | 1993 | 74 |
1376216 | 1376216 | 2021-06-01 | Iron | Michigan | 26071 | 1052 | 51 |
1376217 | 1376217 | 2021-06-01 | Isabella | Michigan | 26073 | 6306 | 96 |
1376218 | 1376218 | 2021-06-01 | Jackson | Michigan | 26075 | 20973 | 309 |
1376219 | 1376219 | 2021-06-01 | Kalamazoo | Michigan | 26077 | 22992 | 396 |
1376220 | 1376220 | 2021-06-01 | Kalkaska | Michigan | 26079 | 1119 | 23 |
1376221 | 1376221 | 2021-06-01 | Kent | Michigan | 26081 | 72813 | 839 |
1376222 | 1376222 | 2021-06-01 | Keweenaw | Michigan | 26083 | 177 | 2 |
1376223 | 1376223 | 2021-06-01 | Lake | Michigan | 26085 | 630 | 15 |
1376224 | 1376224 | 2021-06-01 | Lapeer | Michigan | 26087 | 9714 | 208 |
1376225 | 1376225 | 2021-06-01 | Leelanau | Michigan | 26089 | 1239 | 18 |
1376226 | 1376226 | 2021-06-01 | Lenawee | Michigan | 26091 | 10794 | 170 |
1376227 | 1376227 | 2021-06-01 | Livingston | Michigan | 26093 | 16679 | 187 |
1376228 | 1376228 | 2021-06-01 | Luce | Michigan | 26095 | 1331 | 5 |
1376229 | 1376229 | 2021-06-01 | Mackinac | Michigan | 26097 | 705 | 3 |
1376230 | 1376230 | 2021-06-01 | Macomb | Michigan | 26099 | 100116 | 2431 |
1376231 | 1376231 | 2021-06-01 | Manistee | Michigan | 26101 | 1968 | 24 |
1376232 | 1376232 | 2021-06-01 | Marquette | Michigan | 26103 | 5921 | 62 |
1376233 | 1376233 | 2021-06-01 | Mason | Michigan | 26105 | 2127 | 36 |
1376234 | 1376234 | 2021-06-01 | Mecosta | Michigan | 26107 | 3189 | 32 |
1376235 | 1376235 | 2021-06-01 | Menominee | Michigan | 26109 | 2113 | 43 |
1376236 | 1376236 | 2021-06-01 | Midland | Michigan | 26111 | 7526 | 90 |
1376237 | 1376237 | 2021-06-01 | Missaukee | Michigan | 26113 | 1502 | 26 |
1376238 | 1376238 | 2021-06-01 | Monroe | Michigan | 26115 | 15336 | 261 |
1376239 | 1376239 | 2021-06-01 | Montcalm | Michigan | 26117 | 8137 | 118 |
1376240 | 1376240 | 2021-06-01 | Montmorency | Michigan | 26119 | 612 | 20 |
1376241 | 1376241 | 2021-06-01 | Muskegon | Michigan | 26121 | 18246 | 366 |
1376242 | 1376242 | 2021-06-01 | Newaygo | Michigan | 26123 | 4849 | 66 |
1376243 | 1376243 | 2021-06-01 | Oakland | Michigan | 26125 | 117919 | 2358 |
1376244 | 1376244 | 2021-06-01 | Oceana | Michigan | 26127 | 2753 | 60 |
1376245 | 1376245 | 2021-06-01 | Ogemaw | Michigan | 26129 | 1735 | 43 |
1376246 | 1376246 | 2021-06-01 | Ontonagon | Michigan | 26131 | 475 | 21 |
1376247 | 1376247 | 2021-06-01 | Osceola | Michigan | 26133 | 1951 | 30 |
1376248 | 1376248 | 2021-06-01 | Oscoda | Michigan | 26135 | 678 | 30 |
1376249 | 1376249 | 2021-06-01 | Otsego | Michigan | 26137 | 2347 | 41 |
1376250 | 1376250 | 2021-06-01 | Ottawa | Michigan | 26139 | 32685 | 424 |
1376251 | 1376251 | 2021-06-01 | Presque Isle | Michigan | 26141 | 1052 | 34 |
1376252 | 1376252 | 2021-06-01 | Roscommon | Michigan | 26143 | 1887 | 50 |
1376253 | 1376253 | 2021-06-01 | Saginaw | Michigan | 26145 | 22364 | 611 |
1376254 | 1376254 | 2021-06-01 | Sanilac | Michigan | 26151 | 4247 | 119 |
1376255 | 1376255 | 2021-06-01 | Schoolcraft | Michigan | 26153 | 434 | 5 |
1376256 | 1376256 | 2021-06-01 | Shiawassee | Michigan | 26155 | 6402 | 105 |
1376257 | 1376257 | 2021-06-01 | St. Clair | Michigan | 26147 | 18375 | 434 |
1376258 | 1376258 | 2021-06-01 | St. Joseph | Michigan | 26149 | 6198 | 100 |
1376259 | 1376259 | 2021-06-01 | Tuscola | Michigan | 26157 | 5653 | 175 |
1376260 | 1376260 | 2021-06-01 | Unknown | Michigan | 665 | 13 | |
1376261 | 1376261 | 2021-06-01 | Van Buren | Michigan | 26159 | 7091 | 128 |
1376262 | 1376262 | 2021-06-01 | Washtenaw | Michigan | 26161 | 27027 | 301 |
1376263 | 1376263 | 2021-06-01 | Wayne | Michigan | 26163 | 164417 | 5023 |
1376264 | 1376264 | 2021-06-01 | Wexford | Michigan | 26165 | 2884 | 47 |
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);