ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-08-25 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
467751 | 467751 | 2020-08-25 | Alcona | Michigan | 26001 | 31 | 2 |
467752 | 467752 | 2020-08-25 | Alger | Michigan | 26003 | 17 | 0 |
467753 | 467753 | 2020-08-25 | Allegan | Michigan | 26005 | 606 | 6 |
467754 | 467754 | 2020-08-25 | Alpena | Michigan | 26007 | 132 | 14 |
467755 | 467755 | 2020-08-25 | Antrim | Michigan | 26009 | 53 | 0 |
467756 | 467756 | 2020-08-25 | Arenac | Michigan | 26011 | 51 | 3 |
467757 | 467757 | 2020-08-25 | Baraga | Michigan | 26013 | 8 | 0 |
467758 | 467758 | 2020-08-25 | Barry | Michigan | 26015 | 208 | 2 |
467759 | 467759 | 2020-08-25 | Bay | Michigan | 26017 | 786 | 40 |
467760 | 467760 | 2020-08-25 | Benzie | Michigan | 26019 | 41 | 2 |
467761 | 467761 | 2020-08-25 | Berrien | Michigan | 26021 | 1622 | 69 |
467762 | 467762 | 2020-08-25 | Branch | Michigan | 26023 | 1223 | 26 |
467763 | 467763 | 2020-08-25 | Calhoun | Michigan | 26025 | 897 | 44 |
467764 | 467764 | 2020-08-25 | Cass | Michigan | 26027 | 393 | 15 |
467765 | 467765 | 2020-08-25 | Charlevoix | Michigan | 26029 | 71 | 2 |
467766 | 467766 | 2020-08-25 | Cheboygan | Michigan | 26031 | 65 | 2 |
467767 | 467767 | 2020-08-25 | Chippewa | Michigan | 26033 | 52 | 0 |
467768 | 467768 | 2020-08-25 | Clare | Michigan | 26035 | 97 | 3 |
467769 | 467769 | 2020-08-25 | Clinton | Michigan | 26037 | 461 | 13 |
467770 | 467770 | 2020-08-25 | Crawford | Michigan | 26039 | 113 | 5 |
467771 | 467771 | 2020-08-25 | Delta | Michigan | 26041 | 134 | 3 |
467772 | 467772 | 2020-08-25 | Dickinson | Michigan | 26043 | 61 | 2 |
467773 | 467773 | 2020-08-25 | Eaton | Michigan | 26045 | 497 | 8 |
467774 | 467774 | 2020-08-25 | Emmet | Michigan | 26047 | 108 | 2 |
467775 | 467775 | 2020-08-25 | Genesee | Michigan | 26049 | 3888 | 303 |
467776 | 467776 | 2020-08-25 | Gladwin | Michigan | 26051 | 75 | 2 |
467777 | 467777 | 2020-08-25 | Gogebic | Michigan | 26053 | 142 | 1 |
467778 | 467778 | 2020-08-25 | Grand Traverse | Michigan | 26055 | 298 | 6 |
467779 | 467779 | 2020-08-25 | Gratiot | Michigan | 26057 | 187 | 15 |
467780 | 467780 | 2020-08-25 | Hillsdale | Michigan | 26059 | 297 | 26 |
467781 | 467781 | 2020-08-25 | Houghton | Michigan | 26061 | 61 | 0 |
467782 | 467782 | 2020-08-25 | Huron | Michigan | 26063 | 194 | 4 |
467783 | 467783 | 2020-08-25 | Ingham | Michigan | 26065 | 1714 | 37 |
467784 | 467784 | 2020-08-25 | Ionia | Michigan | 26067 | 292 | 7 |
467785 | 467785 | 2020-08-25 | Iosco | Michigan | 26069 | 141 | 12 |
467786 | 467786 | 2020-08-25 | Iron | Michigan | 26071 | 26 | 1 |
467787 | 467787 | 2020-08-25 | Isabella | Michigan | 26073 | 354 | 9 |
467788 | 467788 | 2020-08-25 | Jackson | Michigan | 26075 | 2509 | 60 |
467789 | 467789 | 2020-08-25 | Kalamazoo | Michigan | 26077 | 1857 | 86 |
467790 | 467790 | 2020-08-25 | Kalkaska | Michigan | 26079 | 62 | 4 |
467791 | 467791 | 2020-08-25 | Kent | Michigan | 26081 | 8171 | 162 |
467792 | 467792 | 2020-08-25 | Keweenaw | Michigan | 26083 | 2 | 0 |
467793 | 467793 | 2020-08-25 | Lake | Michigan | 26085 | 29 | 0 |
467794 | 467794 | 2020-08-25 | Lapeer | Michigan | 26087 | 828 | 42 |
467795 | 467795 | 2020-08-25 | Leelanau | Michigan | 26089 | 84 | 1 |
467796 | 467796 | 2020-08-25 | Lenawee | Michigan | 26091 | 1243 | 17 |
467797 | 467797 | 2020-08-25 | Livingston | Michigan | 26093 | 1078 | 30 |
467798 | 467798 | 2020-08-25 | Luce | Michigan | 26095 | 120 | 0 |
467799 | 467799 | 2020-08-25 | Mackinac | Michigan | 26097 | 32 | 0 |
467800 | 467800 | 2020-08-25 | Macomb | Michigan | 26099 | 12498 | 966 |
467801 | 467801 | 2020-08-25 | Manistee | Michigan | 26101 | 60 | 1 |
467802 | 467802 | 2020-08-25 | Marquette | Michigan | 26103 | 233 | 11 |
467803 | 467803 | 2020-08-25 | Mason | Michigan | 26105 | 115 | 0 |
467804 | 467804 | 2020-08-25 | Mecosta | Michigan | 26107 | 82 | 2 |
467805 | 467805 | 2020-08-25 | Menominee | Michigan | 26109 | 233 | 0 |
467806 | 467806 | 2020-08-25 | Midland | Michigan | 26111 | 389 | 11 |
467807 | 467807 | 2020-08-25 | Missaukee | Michigan | 26113 | 43 | 1 |
467808 | 467808 | 2020-08-25 | Monroe | Michigan | 26115 | 1230 | 26 |
467809 | 467809 | 2020-08-25 | Montcalm | Michigan | 26117 | 216 | 3 |
467810 | 467810 | 2020-08-25 | Montmorency | Michigan | 26119 | 12 | 0 |
467811 | 467811 | 2020-08-25 | Muskegon | Michigan | 26121 | 1907 | 64 |
467812 | 467812 | 2020-08-25 | Newaygo | Michigan | 26123 | 287 | 0 |
467813 | 467813 | 2020-08-25 | Oakland | Michigan | 26125 | 17459 | 1155 |
467814 | 467814 | 2020-08-25 | Oceana | Michigan | 26127 | 498 | 6 |
467815 | 467815 | 2020-08-25 | Ogemaw | Michigan | 26129 | 55 | 3 |
467816 | 467816 | 2020-08-25 | Ontonagon | Michigan | 26131 | 33 | 0 |
467817 | 467817 | 2020-08-25 | Osceola | Michigan | 26133 | 74 | 0 |
467818 | 467818 | 2020-08-25 | Oscoda | Michigan | 26135 | 29 | 1 |
467819 | 467819 | 2020-08-25 | Otsego | Michigan | 26137 | 152 | 11 |
467820 | 467820 | 2020-08-25 | Ottawa | Michigan | 26139 | 2021 | 63 |
467821 | 467821 | 2020-08-25 | Presque Isle | Michigan | 26141 | 21 | 1 |
467822 | 467822 | 2020-08-25 | Roscommon | Michigan | 26143 | 72 | 4 |
467823 | 467823 | 2020-08-25 | Saginaw | Michigan | 26145 | 2411 | 130 |
467824 | 467824 | 2020-08-25 | Sanilac | Michigan | 26151 | 118 | 7 |
467825 | 467825 | 2020-08-25 | Schoolcraft | Michigan | 26153 | 15 | 0 |
467826 | 467826 | 2020-08-25 | Shiawassee | Michigan | 26155 | 400 | 29 |
467827 | 467827 | 2020-08-25 | St. Clair | Michigan | 26147 | 889 | 53 |
467828 | 467828 | 2020-08-25 | St. Joseph | Michigan | 26149 | 670 | 11 |
467829 | 467829 | 2020-08-25 | Tuscola | Michigan | 26157 | 427 | 29 |
467830 | 467830 | 2020-08-25 | Unknown | Michigan | 319 | 4 | |
467831 | 467831 | 2020-08-25 | Van Buren | Michigan | 26159 | 582 | 14 |
467832 | 467832 | 2020-08-25 | Washtenaw | Michigan | 26161 | 3328 | 124 |
467833 | 467833 | 2020-08-25 | Wayne | Michigan | 26163 | 30358 | 2865 |
467834 | 467834 | 2020-08-25 | Wexford | Michigan | 26165 | 95 | 4 |
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);