ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-22" 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 |
---|---|---|---|---|---|---|---|
1941338 | 1941338 | 2021-11-22 | Alcona | Michigan | 26001 | 1276 | 47 |
1941339 | 1941339 | 2021-11-22 | Alger | Michigan | 26003 | 1104 | 9 |
1941340 | 1941340 | 2021-11-22 | Allegan | Michigan | 26005 | 17299 | 213 |
1941341 | 1941341 | 2021-11-22 | Alpena | Michigan | 26007 | 3887 | 81 |
1941342 | 1941342 | 2021-11-22 | Antrim | Michigan | 26009 | 2745 | 42 |
1941343 | 1941343 | 2021-11-22 | Arenac | Michigan | 26011 | 2040 | 42 |
1941344 | 1941344 | 2021-11-22 | Baraga | Michigan | 26013 | 1528 | 47 |
1941345 | 1941345 | 2021-11-22 | Barry | Michigan | 26015 | 9206 | 99 |
1941346 | 1941346 | 2021-11-22 | Bay | Michigan | 26017 | 16724 | 418 |
1941347 | 1941347 | 2021-11-22 | Benzie | Michigan | 26019 | 2002 | 44 |
1941348 | 1941348 | 2021-11-22 | Berrien | Michigan | 26021 | 21087 | 342 |
1941349 | 1941349 | 2021-11-22 | Branch | Michigan | 26023 | 8248 | 142 |
1941350 | 1941350 | 2021-11-22 | Calhoun | Michigan | 26025 | 21076 | 377 |
1941351 | 1941351 | 2021-11-22 | Cass | Michigan | 26027 | 7806 | 97 |
1941352 | 1941352 | 2021-11-22 | Charlevoix | Michigan | 26029 | 2933 | 42 |
1941353 | 1941353 | 2021-11-22 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1941354 | 1941354 | 2021-11-22 | Chippewa | Michigan | 26033 | 7474 | 70 |
1941355 | 1941355 | 2021-11-22 | Clare | Michigan | 26035 | 4421 | 113 |
1941356 | 1941356 | 2021-11-22 | Clinton | Michigan | 26037 | 11871 | 128 |
1941357 | 1941357 | 2021-11-22 | Crawford | Michigan | 26039 | 1636 | 17 |
1941358 | 1941358 | 2021-11-22 | Delta | Michigan | 26041 | 6435 | 117 |
1941359 | 1941359 | 2021-11-22 | Dickinson | Michigan | 26043 | 4463 | 85 |
1941360 | 1941360 | 2021-11-22 | Eaton | Michigan | 26045 | 15491 | 268 |
1941361 | 1941361 | 2021-11-22 | Emmet | Michigan | 26047 | 3829 | 55 |
1941362 | 1941362 | 2021-11-22 | Genesee | Michigan | 26049 | 59051 | 1154 |
1941363 | 1941363 | 2021-11-22 | Gladwin | Michigan | 26051 | 3643 | 81 |
1941364 | 1941364 | 2021-11-22 | Gogebic | Michigan | 26053 | 2016 | 56 |
1941365 | 1941365 | 2021-11-22 | Grand Traverse | Michigan | 26055 | 10498 | 124 |
1941366 | 1941366 | 2021-11-22 | Gratiot | Michigan | 26057 | 9690 | 143 |
1941367 | 1941367 | 2021-11-22 | Hillsdale | Michigan | 26059 | 7120 | 140 |
1941368 | 1941368 | 2021-11-22 | Houghton | Michigan | 26061 | 5027 | 59 |
1941369 | 1941369 | 2021-11-22 | Huron | Michigan | 26063 | 5493 | 100 |
1941370 | 1941370 | 2021-11-22 | Ingham | Michigan | 26065 | 35366 | 489 |
1941371 | 1941371 | 2021-11-22 | Ionia | Michigan | 26067 | 13323 | 114 |
1941372 | 1941372 | 2021-11-22 | Iosco | Michigan | 26069 | 3434 | 103 |
1941373 | 1941373 | 2021-11-22 | Iron | Michigan | 26071 | 1649 | 62 |
1941374 | 1941374 | 2021-11-22 | Isabella | Michigan | 26073 | 10121 | 138 |
1941375 | 1941375 | 2021-11-22 | Jackson | Michigan | 26075 | 29990 | 393 |
1941376 | 1941376 | 2021-11-22 | Kalamazoo | Michigan | 26077 | 33522 | 480 |
1941377 | 1941377 | 2021-11-22 | Kalkaska | Michigan | 26079 | 2053 | 40 |
1941378 | 1941378 | 2021-11-22 | Kent | Michigan | 26081 | 105981 | 1052 |
1941379 | 1941379 | 2021-11-22 | Keweenaw | Michigan | 26083 | 344 | 8 |
1941380 | 1941380 | 2021-11-22 | Lake | Michigan | 26085 | 1136 | 24 |
1941381 | 1941381 | 2021-11-22 | Lapeer | Michigan | 26087 | 13533 | 270 |
1941382 | 1941382 | 2021-11-22 | Leelanau | Michigan | 26089 | 1996 | 30 |
1941383 | 1941383 | 2021-11-22 | Lenawee | Michigan | 26091 | 16839 | 219 |
1941384 | 1941384 | 2021-11-22 | Livingston | Michigan | 26093 | 27313 | 273 |
1941385 | 1941385 | 2021-11-22 | Luce | Michigan | 26095 | 1688 | 6 |
1941386 | 1941386 | 2021-11-22 | Mackinac | Michigan | 26097 | 1440 | 14 |
1941387 | 1941387 | 2021-11-22 | Macomb | Michigan | 26099 | 135834 | 2817 |
1941388 | 1941388 | 2021-11-22 | Manistee | Michigan | 26101 | 2860 | 44 |
1941389 | 1941389 | 2021-11-22 | Marquette | Michigan | 26103 | 8844 | 89 |
1941390 | 1941390 | 2021-11-22 | Mason | Michigan | 26105 | 3933 | 54 |
1941391 | 1941391 | 2021-11-22 | Mecosta | Michigan | 26107 | 5519 | 56 |
1941392 | 1941392 | 2021-11-22 | Menominee | Michigan | 26109 | 3758 | 52 |
1941393 | 1941393 | 2021-11-22 | Midland | Michigan | 26111 | 11666 | 156 |
1941394 | 1941394 | 2021-11-22 | Missaukee | Michigan | 26113 | 2029 | 41 |
1941395 | 1941395 | 2021-11-22 | Monroe | Michigan | 26115 | 23111 | 321 |
1941396 | 1941396 | 2021-11-22 | Montcalm | Michigan | 26117 | 12203 | 144 |
1941397 | 1941397 | 2021-11-22 | Montmorency | Michigan | 26119 | 1211 | 33 |
1941398 | 1941398 | 2021-11-22 | Muskegon | Michigan | 26121 | 27061 | 444 |
1941399 | 1941399 | 2021-11-22 | Newaygo | Michigan | 26123 | 7571 | 92 |
1941400 | 1941400 | 2021-11-22 | Oakland | Michigan | 26125 | 162425 | 2765 |
1941401 | 1941401 | 2021-11-22 | Oceana | Michigan | 26127 | 4264 | 72 |
1941402 | 1941402 | 2021-11-22 | Ogemaw | Michigan | 26129 | 2969 | 68 |
1941403 | 1941403 | 2021-11-22 | Ontonagon | Michigan | 26131 | 681 | 23 |
1941404 | 1941404 | 2021-11-22 | Osceola | Michigan | 26133 | 3466 | 48 |
1941405 | 1941405 | 2021-11-22 | Oscoda | Michigan | 26135 | 1077 | 42 |
1941406 | 1941406 | 2021-11-22 | Otsego | Michigan | 26137 | 3831 | 65 |
1941407 | 1941407 | 2021-11-22 | Ottawa | Michigan | 26139 | 47685 | 544 |
1941408 | 1941408 | 2021-11-22 | Presque Isle | Michigan | 26141 | 1577 | 43 |
1941409 | 1941409 | 2021-11-22 | Roscommon | Michigan | 26143 | 3095 | 75 |
1941410 | 1941410 | 2021-11-22 | Saginaw | Michigan | 26145 | 31880 | 705 |
1941411 | 1941411 | 2021-11-22 | Sanilac | Michigan | 26151 | 5751 | 146 |
1941412 | 1941412 | 2021-11-22 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1941413 | 1941413 | 2021-11-22 | Shiawassee | Michigan | 26155 | 10475 | 145 |
1941414 | 1941414 | 2021-11-22 | St. Clair | Michigan | 26147 | 25186 | 545 |
1941415 | 1941415 | 2021-11-22 | St. Joseph | Michigan | 26149 | 9548 | 130 |
1941416 | 1941416 | 2021-11-22 | Tuscola | Michigan | 26157 | 8469 | 213 |
1941417 | 1941417 | 2021-11-22 | Unknown | Michigan | 1901 | 18 | |
1941418 | 1941418 | 2021-11-22 | Van Buren | Michigan | 26159 | 10564 | 177 |
1941419 | 1941419 | 2021-11-22 | Washtenaw | Michigan | 26161 | 37887 | 345 |
1941420 | 1941420 | 2021-11-22 | Wayne | Michigan | 26163 | 220832 | 5781 |
1941421 | 1941421 | 2021-11-22 | Wexford | Michigan | 26165 | 4339 | 62 |
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);