ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-15" 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 |
---|---|---|---|---|---|---|---|
1918588 | 1918588 | 2021-11-15 | Alcona | Michigan | 26001 | 1236 | 47 |
1918589 | 1918589 | 2021-11-15 | Alger | Michigan | 26003 | 1064 | 9 |
1918590 | 1918590 | 2021-11-15 | Allegan | Michigan | 26005 | 16489 | 203 |
1918591 | 1918591 | 2021-11-15 | Alpena | Michigan | 26007 | 3662 | 79 |
1918592 | 1918592 | 2021-11-15 | Antrim | Michigan | 26009 | 2635 | 40 |
1918593 | 1918593 | 2021-11-15 | Arenac | Michigan | 26011 | 1978 | 38 |
1918594 | 1918594 | 2021-11-15 | Baraga | Michigan | 26013 | 1483 | 47 |
1918595 | 1918595 | 2021-11-15 | Barry | Michigan | 26015 | 8756 | 94 |
1918596 | 1918596 | 2021-11-15 | Bay | Michigan | 26017 | 16138 | 411 |
1918597 | 1918597 | 2021-11-15 | Benzie | Michigan | 26019 | 1866 | 41 |
1918598 | 1918598 | 2021-11-15 | Berrien | Michigan | 26021 | 20437 | 337 |
1918599 | 1918599 | 2021-11-15 | Branch | Michigan | 26023 | 7907 | 138 |
1918600 | 1918600 | 2021-11-15 | Calhoun | Michigan | 26025 | 20192 | 369 |
1918601 | 1918601 | 2021-11-15 | Cass | Michigan | 26027 | 7567 | 95 |
1918602 | 1918602 | 2021-11-15 | Charlevoix | Michigan | 26029 | 2780 | 39 |
1918603 | 1918603 | 2021-11-15 | Cheboygan | Michigan | 26031 | 3098 | 71 |
1918604 | 1918604 | 2021-11-15 | Chippewa | Michigan | 26033 | 7291 | 69 |
1918605 | 1918605 | 2021-11-15 | Clare | Michigan | 26035 | 4251 | 112 |
1918606 | 1918606 | 2021-11-15 | Clinton | Michigan | 26037 | 11311 | 122 |
1918607 | 1918607 | 2021-11-15 | Crawford | Michigan | 26039 | 1547 | 17 |
1918608 | 1918608 | 2021-11-15 | Delta | Michigan | 26041 | 6240 | 112 |
1918609 | 1918609 | 2021-11-15 | Dickinson | Michigan | 26043 | 4308 | 84 |
1918610 | 1918610 | 2021-11-15 | Eaton | Michigan | 26045 | 14686 | 255 |
1918611 | 1918611 | 2021-11-15 | Emmet | Michigan | 26047 | 3720 | 53 |
1918612 | 1918612 | 2021-11-15 | Genesee | Michigan | 26049 | 56558 | 1118 |
1918613 | 1918613 | 2021-11-15 | Gladwin | Michigan | 26051 | 3556 | 79 |
1918614 | 1918614 | 2021-11-15 | Gogebic | Michigan | 26053 | 1934 | 54 |
1918615 | 1918615 | 2021-11-15 | Grand Traverse | Michigan | 26055 | 9908 | 122 |
1918616 | 1918616 | 2021-11-15 | Gratiot | Michigan | 26057 | 9443 | 139 |
1918617 | 1918617 | 2021-11-15 | Hillsdale | Michigan | 26059 | 6801 | 132 |
1918618 | 1918618 | 2021-11-15 | Houghton | Michigan | 26061 | 4735 | 57 |
1918619 | 1918619 | 2021-11-15 | Huron | Michigan | 26063 | 5306 | 97 |
1918620 | 1918620 | 2021-11-15 | Ingham | Michigan | 26065 | 33899 | 473 |
1918621 | 1918621 | 2021-11-15 | Ionia | Michigan | 26067 | 12794 | 113 |
1918622 | 1918622 | 2021-11-15 | Iosco | Michigan | 26069 | 3327 | 100 |
1918623 | 1918623 | 2021-11-15 | Iron | Michigan | 26071 | 1563 | 61 |
1918624 | 1918624 | 2021-11-15 | Isabella | Michigan | 26073 | 9828 | 137 |
1918625 | 1918625 | 2021-11-15 | Jackson | Michigan | 26075 | 28608 | 386 |
1918626 | 1918626 | 2021-11-15 | Kalamazoo | Michigan | 26077 | 32174 | 474 |
1918627 | 1918627 | 2021-11-15 | Kalkaska | Michigan | 26079 | 1948 | 40 |
1918628 | 1918628 | 2021-11-15 | Kent | Michigan | 26081 | 101346 | 1035 |
1918629 | 1918629 | 2021-11-15 | Keweenaw | Michigan | 26083 | 320 | 6 |
1918630 | 1918630 | 2021-11-15 | Lake | Michigan | 26085 | 1072 | 24 |
1918631 | 1918631 | 2021-11-15 | Lapeer | Michigan | 26087 | 13013 | 267 |
1918632 | 1918632 | 2021-11-15 | Leelanau | Michigan | 26089 | 1874 | 26 |
1918633 | 1918633 | 2021-11-15 | Lenawee | Michigan | 26091 | 16124 | 215 |
1918634 | 1918634 | 2021-11-15 | Livingston | Michigan | 26093 | 25930 | 258 |
1918635 | 1918635 | 2021-11-15 | Luce | Michigan | 26095 | 1664 | 6 |
1918636 | 1918636 | 2021-11-15 | Mackinac | Michigan | 26097 | 1396 | 14 |
1918637 | 1918637 | 2021-11-15 | Macomb | Michigan | 26099 | 130748 | 2774 |
1918638 | 1918638 | 2021-11-15 | Manistee | Michigan | 26101 | 2692 | 42 |
1918639 | 1918639 | 2021-11-15 | Marquette | Michigan | 26103 | 8628 | 86 |
1918640 | 1918640 | 2021-11-15 | Mason | Michigan | 26105 | 3658 | 50 |
1918641 | 1918641 | 2021-11-15 | Mecosta | Michigan | 26107 | 5237 | 54 |
1918642 | 1918642 | 2021-11-15 | Menominee | Michigan | 26109 | 3633 | 53 |
1918643 | 1918643 | 2021-11-15 | Midland | Michigan | 26111 | 11295 | 150 |
1918644 | 1918644 | 2021-11-15 | Missaukee | Michigan | 26113 | 1969 | 41 |
1918645 | 1918645 | 2021-11-15 | Monroe | Michigan | 26115 | 22373 | 314 |
1918646 | 1918646 | 2021-11-15 | Montcalm | Michigan | 26117 | 11727 | 140 |
1918647 | 1918647 | 2021-11-15 | Montmorency | Michigan | 26119 | 1150 | 32 |
1918648 | 1918648 | 2021-11-15 | Muskegon | Michigan | 26121 | 25840 | 436 |
1918649 | 1918649 | 2021-11-15 | Newaygo | Michigan | 26123 | 7237 | 85 |
1918650 | 1918650 | 2021-11-15 | Oakland | Michigan | 26125 | 156443 | 2734 |
1918651 | 1918651 | 2021-11-15 | Oceana | Michigan | 26127 | 4061 | 71 |
1918652 | 1918652 | 2021-11-15 | Ogemaw | Michigan | 26129 | 2898 | 68 |
1918653 | 1918653 | 2021-11-15 | Ontonagon | Michigan | 26131 | 673 | 23 |
1918654 | 1918654 | 2021-11-15 | Osceola | Michigan | 26133 | 3347 | 47 |
1918655 | 1918655 | 2021-11-15 | Oscoda | Michigan | 26135 | 1048 | 41 |
1918656 | 1918656 | 2021-11-15 | Otsego | Michigan | 26137 | 3669 | 63 |
1918657 | 1918657 | 2021-11-15 | Ottawa | Michigan | 26139 | 45474 | 530 |
1918658 | 1918658 | 2021-11-15 | Presque Isle | Michigan | 26141 | 1518 | 41 |
1918659 | 1918659 | 2021-11-15 | Roscommon | Michigan | 26143 | 2951 | 72 |
1918660 | 1918660 | 2021-11-15 | Saginaw | Michigan | 26145 | 30737 | 694 |
1918661 | 1918661 | 2021-11-15 | Sanilac | Michigan | 26151 | 5446 | 139 |
1918662 | 1918662 | 2021-11-15 | Schoolcraft | Michigan | 26153 | 926 | 6 |
1918663 | 1918663 | 2021-11-15 | Shiawassee | Michigan | 26155 | 9828 | 137 |
1918664 | 1918664 | 2021-11-15 | St. Clair | Michigan | 26147 | 24084 | 533 |
1918665 | 1918665 | 2021-11-15 | St. Joseph | Michigan | 26149 | 9148 | 123 |
1918666 | 1918666 | 2021-11-15 | Tuscola | Michigan | 26157 | 8151 | 205 |
1918667 | 1918667 | 2021-11-15 | Unknown | Michigan | 1724 | 18 | |
1918668 | 1918668 | 2021-11-15 | Van Buren | Michigan | 26159 | 10085 | 169 |
1918669 | 1918669 | 2021-11-15 | Washtenaw | Michigan | 26161 | 36500 | 343 |
1918670 | 1918670 | 2021-11-15 | Wayne | Michigan | 26163 | 212684 | 5696 |
1918671 | 1918671 | 2021-11-15 | Wexford | Michigan | 26165 | 4123 | 59 |
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);