ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-01-08" 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 |
---|---|---|---|---|---|---|---|
908700 | 908700 | 2021-01-08 | Alcona | Michigan | 26001 | 366 | 17 |
908701 | 908701 | 2021-01-08 | Alger | Michigan | 26003 | 465 | 3 |
908702 | 908702 | 2021-01-08 | Allegan | Michigan | 26005 | 6141 | 81 |
908703 | 908703 | 2021-01-08 | Alpena | Michigan | 26007 | 1278 | 33 |
908704 | 908704 | 2021-01-08 | Antrim | Michigan | 26009 | 733 | 12 |
908705 | 908705 | 2021-01-08 | Arenac | Michigan | 26011 | 632 | 25 |
908706 | 908706 | 2021-01-08 | Baraga | Michigan | 26013 | 629 | 29 |
908707 | 908707 | 2021-01-08 | Barry | Michigan | 26015 | 3153 | 38 |
908708 | 908708 | 2021-01-08 | Bay | Michigan | 26017 | 6619 | 208 |
908709 | 908709 | 2021-01-08 | Benzie | Michigan | 26019 | 742 | 28 |
908710 | 908710 | 2021-01-08 | Berrien | Michigan | 26021 | 9850 | 205 |
908711 | 908711 | 2021-01-08 | Branch | Michigan | 26023 | 4102 | 95 |
908712 | 908712 | 2021-01-08 | Calhoun | Michigan | 26025 | 8117 | 204 |
908713 | 908713 | 2021-01-08 | Cass | Michigan | 26027 | 3367 | 51 |
908714 | 908714 | 2021-01-08 | Charlevoix | Michigan | 26029 | 884 | 10 |
908715 | 908715 | 2021-01-08 | Cheboygan | Michigan | 26031 | 787 | 34 |
908716 | 908716 | 2021-01-08 | Chippewa | Michigan | 26033 | 2969 | 21 |
908717 | 908717 | 2021-01-08 | Clare | Michigan | 26035 | 1295 | 46 |
908718 | 908718 | 2021-01-08 | Clinton | Michigan | 26037 | 4270 | 44 |
908719 | 908719 | 2021-01-08 | Crawford | Michigan | 26039 | 501 | 5 |
908720 | 908720 | 2021-01-08 | Delta | Michigan | 26041 | 2967 | 78 |
908721 | 908721 | 2021-01-08 | Dickinson | Michigan | 26043 | 2246 | 70 |
908722 | 908722 | 2021-01-08 | Eaton | Michigan | 26045 | 5072 | 102 |
908723 | 908723 | 2021-01-08 | Emmet | Michigan | 26047 | 1279 | 34 |
908724 | 908724 | 2021-01-08 | Genesee | Michigan | 26049 | 22511 | 644 |
908725 | 908725 | 2021-01-08 | Gladwin | Michigan | 26051 | 1276 | 35 |
908726 | 908726 | 2021-01-08 | Gogebic | Michigan | 26053 | 1032 | 39 |
908727 | 908727 | 2021-01-08 | Grand Traverse | Michigan | 26055 | 3420 | 49 |
908728 | 908728 | 2021-01-08 | Gratiot | Michigan | 26057 | 4211 | 84 |
908729 | 908729 | 2021-01-08 | Hillsdale | Michigan | 26059 | 2793 | 61 |
908730 | 908730 | 2021-01-08 | Houghton | Michigan | 26061 | 2146 | 34 |
908731 | 908731 | 2021-01-08 | Huron | Michigan | 26063 | 1669 | 49 |
908732 | 908732 | 2021-01-08 | Ingham | Michigan | 26065 | 13324 | 209 |
908733 | 908733 | 2021-01-08 | Ionia | Michigan | 26067 | 5105 | 53 |
908734 | 908734 | 2021-01-08 | Iosco | Michigan | 26069 | 1164 | 55 |
908735 | 908735 | 2021-01-08 | Iron | Michigan | 26071 | 855 | 37 |
908736 | 908736 | 2021-01-08 | Isabella | Michigan | 26073 | 3603 | 51 |
908737 | 908737 | 2021-01-08 | Jackson | Michigan | 26075 | 10906 | 200 |
908738 | 908738 | 2021-01-08 | Kalamazoo | Michigan | 26077 | 13065 | 273 |
908739 | 908739 | 2021-01-08 | Kalkaska | Michigan | 26079 | 513 | 14 |
908740 | 908740 | 2021-01-08 | Kent | Michigan | 26081 | 45628 | 585 |
908741 | 908741 | 2021-01-08 | Keweenaw | Michigan | 26083 | 98 | 2 |
908742 | 908742 | 2021-01-08 | Lake | Michigan | 26085 | 312 | 10 |
908743 | 908743 | 2021-01-08 | Lapeer | Michigan | 26087 | 4535 | 110 |
908744 | 908744 | 2021-01-08 | Leelanau | Michigan | 26089 | 682 | 8 |
908745 | 908745 | 2021-01-08 | Lenawee | Michigan | 26091 | 5866 | 78 |
908746 | 908746 | 2021-01-08 | Livingston | Michigan | 26093 | 8533 | 88 |
908747 | 908747 | 2021-01-08 | Luce | Michigan | 26095 | 980 | 0 |
908748 | 908748 | 2021-01-08 | Mackinac | Michigan | 26097 | 396 | 3 |
908749 | 908749 | 2021-01-08 | Macomb | Michigan | 26099 | 52050 | 1683 |
908750 | 908750 | 2021-01-08 | Manistee | Michigan | 26101 | 671 | 19 |
908751 | 908751 | 2021-01-08 | Marquette | Michigan | 26103 | 4531 | 52 |
908752 | 908752 | 2021-01-08 | Mason | Michigan | 26105 | 1048 | 21 |
908753 | 908753 | 2021-01-08 | Mecosta | Michigan | 26107 | 1737 | 14 |
908754 | 908754 | 2021-01-08 | Menominee | Michigan | 26109 | 1763 | 29 |
908755 | 908755 | 2021-01-08 | Midland | Michigan | 26111 | 4303 | 49 |
908756 | 908756 | 2021-01-08 | Missaukee | Michigan | 26113 | 569 | 12 |
908757 | 908757 | 2021-01-08 | Monroe | Michigan | 26115 | 8195 | 165 |
908758 | 908758 | 2021-01-08 | Montcalm | Michigan | 26117 | 3389 | 71 |
908759 | 908759 | 2021-01-08 | Montmorency | Michigan | 26119 | 325 | 12 |
908760 | 908760 | 2021-01-08 | Muskegon | Michigan | 26121 | 11471 | 280 |
908761 | 908761 | 2021-01-08 | Newaygo | Michigan | 26123 | 2382 | 35 |
908762 | 908762 | 2021-01-08 | Oakland | Michigan | 26125 | 64666 | 1717 |
908763 | 908763 | 2021-01-08 | Oceana | Michigan | 26127 | 1690 | 44 |
908764 | 908764 | 2021-01-08 | Ogemaw | Michigan | 26129 | 980 | 29 |
908765 | 908765 | 2021-01-08 | Ontonagon | Michigan | 26131 | 312 | 16 |
908766 | 908766 | 2021-01-08 | Osceola | Michigan | 26133 | 898 | 19 |
908767 | 908767 | 2021-01-08 | Oscoda | Michigan | 26135 | 329 | 18 |
908768 | 908768 | 2021-01-08 | Otsego | Michigan | 26137 | 1056 | 25 |
908769 | 908769 | 2021-01-08 | Ottawa | Michigan | 26139 | 19437 | 291 |
908770 | 908770 | 2021-01-08 | Presque Isle | Michigan | 26141 | 570 | 18 |
908771 | 908771 | 2021-01-08 | Roscommon | Michigan | 26143 | 1015 | 26 |
908772 | 908772 | 2021-01-08 | Saginaw | Michigan | 26145 | 12981 | 429 |
908773 | 908773 | 2021-01-08 | Sanilac | Michigan | 26151 | 1617 | 67 |
908774 | 908774 | 2021-01-08 | Schoolcraft | Michigan | 26153 | 239 | 4 |
908775 | 908775 | 2021-01-08 | Shiawassee | Michigan | 26155 | 3150 | 59 |
908776 | 908776 | 2021-01-08 | St. Clair | Michigan | 26147 | 7521 | 184 |
908777 | 908777 | 2021-01-08 | St. Joseph | Michigan | 26149 | 3866 | 62 |
908778 | 908778 | 2021-01-08 | Tuscola | Michigan | 26157 | 2821 | 102 |
908779 | 908779 | 2021-01-08 | Unknown | Michigan | 8596 | 44 | |
908780 | 908780 | 2021-01-08 | Van Buren | Michigan | 26159 | 4337 | 83 |
908781 | 908781 | 2021-01-08 | Washtenaw | Michigan | 26161 | 15220 | 215 |
908782 | 908782 | 2021-01-08 | Wayne | Michigan | 26163 | 89162 | 3745 |
908783 | 908783 | 2021-01-08 | Wexford | Michigan | 26165 | 1095 | 20 |
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);