ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-23" 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 |
---|---|---|---|---|---|---|---|
1944589 | 1944589 | 2021-11-23 | Alcona | Michigan | 26001 | 1276 | 47 |
1944590 | 1944590 | 2021-11-23 | Alger | Michigan | 26003 | 1104 | 9 |
1944591 | 1944591 | 2021-11-23 | Allegan | Michigan | 26005 | 17299 | 213 |
1944592 | 1944592 | 2021-11-23 | Alpena | Michigan | 26007 | 3887 | 81 |
1944593 | 1944593 | 2021-11-23 | Antrim | Michigan | 26009 | 2758 | 42 |
1944594 | 1944594 | 2021-11-23 | Arenac | Michigan | 26011 | 2040 | 42 |
1944595 | 1944595 | 2021-11-23 | Baraga | Michigan | 26013 | 1528 | 47 |
1944596 | 1944596 | 2021-11-23 | Barry | Michigan | 26015 | 9206 | 99 |
1944597 | 1944597 | 2021-11-23 | Bay | Michigan | 26017 | 16724 | 418 |
1944598 | 1944598 | 2021-11-23 | Benzie | Michigan | 26019 | 2002 | 44 |
1944599 | 1944599 | 2021-11-23 | Berrien | Michigan | 26021 | 21087 | 342 |
1944600 | 1944600 | 2021-11-23 | Branch | Michigan | 26023 | 8248 | 142 |
1944601 | 1944601 | 2021-11-23 | Calhoun | Michigan | 26025 | 21076 | 377 |
1944602 | 1944602 | 2021-11-23 | Cass | Michigan | 26027 | 7806 | 97 |
1944603 | 1944603 | 2021-11-23 | Charlevoix | Michigan | 26029 | 2953 | 42 |
1944604 | 1944604 | 2021-11-23 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1944605 | 1944605 | 2021-11-23 | Chippewa | Michigan | 26033 | 7474 | 70 |
1944606 | 1944606 | 2021-11-23 | Clare | Michigan | 26035 | 4421 | 113 |
1944607 | 1944607 | 2021-11-23 | Clinton | Michigan | 26037 | 11871 | 128 |
1944608 | 1944608 | 2021-11-23 | Crawford | Michigan | 26039 | 1636 | 17 |
1944609 | 1944609 | 2021-11-23 | Delta | Michigan | 26041 | 6435 | 117 |
1944610 | 1944610 | 2021-11-23 | Dickinson | Michigan | 26043 | 4463 | 85 |
1944611 | 1944611 | 2021-11-23 | Eaton | Michigan | 26045 | 15491 | 268 |
1944612 | 1944612 | 2021-11-23 | Emmet | Michigan | 26047 | 3843 | 55 |
1944613 | 1944613 | 2021-11-23 | Genesee | Michigan | 26049 | 59051 | 1154 |
1944614 | 1944614 | 2021-11-23 | Gladwin | Michigan | 26051 | 3643 | 81 |
1944615 | 1944615 | 2021-11-23 | Gogebic | Michigan | 26053 | 2016 | 56 |
1944616 | 1944616 | 2021-11-23 | Grand Traverse | Michigan | 26055 | 10498 | 124 |
1944617 | 1944617 | 2021-11-23 | Gratiot | Michigan | 26057 | 9690 | 143 |
1944618 | 1944618 | 2021-11-23 | Hillsdale | Michigan | 26059 | 7120 | 140 |
1944619 | 1944619 | 2021-11-23 | Houghton | Michigan | 26061 | 5027 | 59 |
1944620 | 1944620 | 2021-11-23 | Huron | Michigan | 26063 | 5493 | 100 |
1944621 | 1944621 | 2021-11-23 | Ingham | Michigan | 26065 | 35366 | 489 |
1944622 | 1944622 | 2021-11-23 | Ionia | Michigan | 26067 | 13323 | 114 |
1944623 | 1944623 | 2021-11-23 | Iosco | Michigan | 26069 | 3434 | 103 |
1944624 | 1944624 | 2021-11-23 | Iron | Michigan | 26071 | 1649 | 62 |
1944625 | 1944625 | 2021-11-23 | Isabella | Michigan | 26073 | 10121 | 138 |
1944626 | 1944626 | 2021-11-23 | Jackson | Michigan | 26075 | 29990 | 393 |
1944627 | 1944627 | 2021-11-23 | Kalamazoo | Michigan | 26077 | 33522 | 480 |
1944628 | 1944628 | 2021-11-23 | Kalkaska | Michigan | 26079 | 2053 | 40 |
1944629 | 1944629 | 2021-11-23 | Kent | Michigan | 26081 | 105981 | 1052 |
1944630 | 1944630 | 2021-11-23 | Keweenaw | Michigan | 26083 | 344 | 8 |
1944631 | 1944631 | 2021-11-23 | Lake | Michigan | 26085 | 1136 | 24 |
1944632 | 1944632 | 2021-11-23 | Lapeer | Michigan | 26087 | 13533 | 270 |
1944633 | 1944633 | 2021-11-23 | Leelanau | Michigan | 26089 | 1996 | 30 |
1944634 | 1944634 | 2021-11-23 | Lenawee | Michigan | 26091 | 16839 | 219 |
1944635 | 1944635 | 2021-11-23 | Livingston | Michigan | 26093 | 27313 | 273 |
1944636 | 1944636 | 2021-11-23 | Luce | Michigan | 26095 | 1688 | 6 |
1944637 | 1944637 | 2021-11-23 | Mackinac | Michigan | 26097 | 1440 | 14 |
1944638 | 1944638 | 2021-11-23 | Macomb | Michigan | 26099 | 135834 | 2817 |
1944639 | 1944639 | 2021-11-23 | Manistee | Michigan | 26101 | 2860 | 44 |
1944640 | 1944640 | 2021-11-23 | Marquette | Michigan | 26103 | 8844 | 89 |
1944641 | 1944641 | 2021-11-23 | Mason | Michigan | 26105 | 3933 | 54 |
1944642 | 1944642 | 2021-11-23 | Mecosta | Michigan | 26107 | 5519 | 56 |
1944643 | 1944643 | 2021-11-23 | Menominee | Michigan | 26109 | 3758 | 52 |
1944644 | 1944644 | 2021-11-23 | Midland | Michigan | 26111 | 11666 | 156 |
1944645 | 1944645 | 2021-11-23 | Missaukee | Michigan | 26113 | 2029 | 41 |
1944646 | 1944646 | 2021-11-23 | Monroe | Michigan | 26115 | 23111 | 321 |
1944647 | 1944647 | 2021-11-23 | Montcalm | Michigan | 26117 | 12203 | 144 |
1944648 | 1944648 | 2021-11-23 | Montmorency | Michigan | 26119 | 1211 | 33 |
1944649 | 1944649 | 2021-11-23 | Muskegon | Michigan | 26121 | 27061 | 444 |
1944650 | 1944650 | 2021-11-23 | Newaygo | Michigan | 26123 | 7571 | 92 |
1944651 | 1944651 | 2021-11-23 | Oakland | Michigan | 26125 | 162425 | 2765 |
1944652 | 1944652 | 2021-11-23 | Oceana | Michigan | 26127 | 4264 | 72 |
1944653 | 1944653 | 2021-11-23 | Ogemaw | Michigan | 26129 | 2969 | 68 |
1944654 | 1944654 | 2021-11-23 | Ontonagon | Michigan | 26131 | 681 | 23 |
1944655 | 1944655 | 2021-11-23 | Osceola | Michigan | 26133 | 3466 | 48 |
1944656 | 1944656 | 2021-11-23 | Oscoda | Michigan | 26135 | 1077 | 42 |
1944657 | 1944657 | 2021-11-23 | Otsego | Michigan | 26137 | 3848 | 66 |
1944658 | 1944658 | 2021-11-23 | Ottawa | Michigan | 26139 | 47685 | 544 |
1944659 | 1944659 | 2021-11-23 | Presque Isle | Michigan | 26141 | 1577 | 43 |
1944660 | 1944660 | 2021-11-23 | Roscommon | Michigan | 26143 | 3095 | 75 |
1944661 | 1944661 | 2021-11-23 | Saginaw | Michigan | 26145 | 31880 | 705 |
1944662 | 1944662 | 2021-11-23 | Sanilac | Michigan | 26151 | 5751 | 146 |
1944663 | 1944663 | 2021-11-23 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1944664 | 1944664 | 2021-11-23 | Shiawassee | Michigan | 26155 | 10475 | 145 |
1944665 | 1944665 | 2021-11-23 | St. Clair | Michigan | 26147 | 25385 | 545 |
1944666 | 1944666 | 2021-11-23 | St. Joseph | Michigan | 26149 | 9548 | 130 |
1944667 | 1944667 | 2021-11-23 | Tuscola | Michigan | 26157 | 8469 | 213 |
1944668 | 1944668 | 2021-11-23 | Unknown | Michigan | 1496 | 17 | |
1944669 | 1944669 | 2021-11-23 | Van Buren | Michigan | 26159 | 10564 | 177 |
1944670 | 1944670 | 2021-11-23 | Washtenaw | Michigan | 26161 | 38029 | 345 |
1944671 | 1944671 | 2021-11-23 | Wayne | Michigan | 26163 | 220832 | 5781 |
1944672 | 1944672 | 2021-11-23 | 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);