ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where date = "2020-06-09" 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 |
---|---|---|---|---|---|---|---|
222719 | 222719 | 2020-06-09 | Alcona | Michigan | 26001 | 21 | 1 |
222720 | 222720 | 2020-06-09 | Allegan | Michigan | 26005 | 273 | 6 |
222721 | 222721 | 2020-06-09 | Alpena | Michigan | 26007 | 108 | 9 |
222722 | 222722 | 2020-06-09 | Antrim | Michigan | 26009 | 13 | 0 |
222723 | 222723 | 2020-06-09 | Arenac | Michigan | 26011 | 38 | 1 |
222724 | 222724 | 2020-06-09 | Baraga | Michigan | 26013 | 1 | 0 |
222725 | 222725 | 2020-06-09 | Barry | Michigan | 26015 | 87 | 2 |
222726 | 222726 | 2020-06-09 | Bay | Michigan | 26017 | 385 | 27 |
222727 | 222727 | 2020-06-09 | Benzie | Michigan | 26019 | 5 | 0 |
222728 | 222728 | 2020-06-09 | Berrien | Michigan | 26021 | 869 | 57 |
222729 | 222729 | 2020-06-09 | Branch | Michigan | 26023 | 946 | 25 |
222730 | 222730 | 2020-06-09 | Calhoun | Michigan | 26025 | 470 | 26 |
222731 | 222731 | 2020-06-09 | Cass | Michigan | 26027 | 108 | 4 |
222732 | 222732 | 2020-06-09 | Charlevoix | Michigan | 26029 | 22 | 1 |
222733 | 222733 | 2020-06-09 | Cheboygan | Michigan | 26031 | 26 | 1 |
222734 | 222734 | 2020-06-09 | Chippewa | Michigan | 26033 | 4 | 0 |
222735 | 222735 | 2020-06-09 | Clare | Michigan | 26035 | 23 | 2 |
222736 | 222736 | 2020-06-09 | Clinton | Michigan | 26037 | 186 | 11 |
222737 | 222737 | 2020-06-09 | Crawford | Michigan | 26039 | 63 | 5 |
222738 | 222738 | 2020-06-09 | Delta | Michigan | 26041 | 20 | 2 |
222739 | 222739 | 2020-06-09 | Dickinson | Michigan | 26043 | 6 | 2 |
222740 | 222740 | 2020-06-09 | Eaton | Michigan | 26045 | 252 | 7 |
222741 | 222741 | 2020-06-09 | Emmet | Michigan | 26047 | 27 | 2 |
222742 | 222742 | 2020-06-09 | Genesee | Michigan | 26049 | 2552 | 281 |
222743 | 222743 | 2020-06-09 | Gladwin | Michigan | 26051 | 19 | 1 |
222744 | 222744 | 2020-06-09 | Gogebic | Michigan | 26053 | 6 | 1 |
222745 | 222745 | 2020-06-09 | Grand Traverse | Michigan | 26055 | 40 | 5 |
222746 | 222746 | 2020-06-09 | Gratiot | Michigan | 26057 | 94 | 11 |
222747 | 222747 | 2020-06-09 | Hillsdale | Michigan | 26059 | 179 | 25 |
222748 | 222748 | 2020-06-09 | Houghton | Michigan | 26061 | 8 | 0 |
222749 | 222749 | 2020-06-09 | Huron | Michigan | 26063 | 59 | 1 |
222750 | 222750 | 2020-06-09 | Ingham | Michigan | 26065 | 808 | 28 |
222751 | 222751 | 2020-06-09 | Ionia | Michigan | 26067 | 180 | 4 |
222752 | 222752 | 2020-06-09 | Iosco | Michigan | 26069 | 111 | 10 |
222753 | 222753 | 2020-06-09 | Iron | Michigan | 26071 | 2 | 0 |
222754 | 222754 | 2020-06-09 | Isabella | Michigan | 26073 | 94 | 7 |
222755 | 222755 | 2020-06-09 | Jackson | Michigan | 26075 | 2041 | 52 |
222756 | 222756 | 2020-06-09 | Kalamazoo | Michigan | 26077 | 935 | 61 |
222757 | 222757 | 2020-06-09 | Kalkaska | Michigan | 26079 | 31 | 2 |
222758 | 222758 | 2020-06-09 | Kent | Michigan | 26081 | 4231 | 107 |
222759 | 222759 | 2020-06-09 | Lake | Michigan | 26085 | 7 | 0 |
222760 | 222760 | 2020-06-09 | Lapeer | Michigan | 26087 | 517 | 38 |
222761 | 222761 | 2020-06-09 | Leelanau | Michigan | 26089 | 12 | 0 |
222762 | 222762 | 2020-06-09 | Lenawee | Michigan | 26091 | 919 | 10 |
222763 | 222763 | 2020-06-09 | Livingston | Michigan | 26093 | 566 | 29 |
222764 | 222764 | 2020-06-09 | Luce | Michigan | 26095 | 4 | 0 |
222765 | 222765 | 2020-06-09 | Mackinac | Michigan | 26097 | 8 | 0 |
222766 | 222766 | 2020-06-09 | Macomb | Michigan | 26099 | 7236 | 878 |
222767 | 222767 | 2020-06-09 | Manistee | Michigan | 26101 | 24 | 1 |
222768 | 222768 | 2020-06-09 | Marquette | Michigan | 26103 | 59 | 11 |
222769 | 222769 | 2020-06-09 | Mason | Michigan | 26105 | 38 | 0 |
222770 | 222770 | 2020-06-09 | Mecosta | Michigan | 26107 | 24 | 2 |
222771 | 222771 | 2020-06-09 | Menominee | Michigan | 26109 | 9 | 0 |
222772 | 222772 | 2020-06-09 | Midland | Michigan | 26111 | 128 | 9 |
222773 | 222773 | 2020-06-09 | Missaukee | Michigan | 26113 | 22 | 1 |
222774 | 222774 | 2020-06-09 | Monroe | Michigan | 26115 | 560 | 21 |
222775 | 222775 | 2020-06-09 | Montcalm | Michigan | 26117 | 81 | 1 |
222776 | 222776 | 2020-06-09 | Montmorency | Michigan | 26119 | 5 | 0 |
222777 | 222777 | 2020-06-09 | Muskegon | Michigan | 26121 | 714 | 40 |
222778 | 222778 | 2020-06-09 | Newaygo | Michigan | 26123 | 123 | 0 |
222779 | 222779 | 2020-06-09 | Oakland | Michigan | 26125 | 11255 | 1056 |
222780 | 222780 | 2020-06-09 | Oceana | Michigan | 26127 | 103 | 3 |
222781 | 222781 | 2020-06-09 | Ogemaw | Michigan | 26129 | 31 | 2 |
222782 | 222782 | 2020-06-09 | Osceola | Michigan | 26133 | 18 | 0 |
222783 | 222783 | 2020-06-09 | Oscoda | Michigan | 26135 | 8 | 1 |
222784 | 222784 | 2020-06-09 | Otsego | Michigan | 26137 | 131 | 10 |
222785 | 222785 | 2020-06-09 | Ottawa | Michigan | 26139 | 904 | 48 |
222786 | 222786 | 2020-06-09 | Presque Isle | Michigan | 26141 | 11 | 0 |
222787 | 222787 | 2020-06-09 | Roscommon | Michigan | 26143 | 24 | 0 |
222788 | 222788 | 2020-06-09 | Saginaw | Michigan | 26145 | 1138 | 115 |
222789 | 222789 | 2020-06-09 | Sanilac | Michigan | 26151 | 43 | 6 |
222790 | 222790 | 2020-06-09 | Schoolcraft | Michigan | 26153 | 4 | 0 |
222791 | 222791 | 2020-06-09 | Shiawassee | Michigan | 26155 | 261 | 27 |
222792 | 222792 | 2020-06-09 | St. Clair | Michigan | 26147 | 516 | 45 |
222793 | 222793 | 2020-06-09 | St. Joseph | Michigan | 26149 | 158 | 3 |
222794 | 222794 | 2020-06-09 | Tuscola | Michigan | 26157 | 205 | 25 |
222795 | 222795 | 2020-06-09 | Unknown | Michigan | 208 | 3 | |
222796 | 222796 | 2020-06-09 | Van Buren | Michigan | 26159 | 179 | 7 |
222797 | 222797 | 2020-06-09 | Washtenaw | Michigan | 26161 | 2020 | 111 |
222798 | 222798 | 2020-06-09 | Wayne | Michigan | 26163 | 21556 | 2653 |
222799 | 222799 | 2020-06-09 | Wexford | Michigan | 26165 | 18 | 3 |
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);