ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where date = "2020-05-27" 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 |
---|---|---|---|---|---|---|---|
182733 | 182733 | 2020-05-27 | Alcona | Michigan | 26001 | 12 | 1 |
182734 | 182734 | 2020-05-27 | Allegan | Michigan | 26005 | 211 | 6 |
182735 | 182735 | 2020-05-27 | Alpena | Michigan | 26007 | 95 | 9 |
182736 | 182736 | 2020-05-27 | Antrim | Michigan | 26009 | 12 | 0 |
182737 | 182737 | 2020-05-27 | Arenac | Michigan | 26011 | 33 | 1 |
182738 | 182738 | 2020-05-27 | Baraga | Michigan | 26013 | 1 | 0 |
182739 | 182739 | 2020-05-27 | Barry | Michigan | 26015 | 62 | 2 |
182740 | 182740 | 2020-05-27 | Bay | Michigan | 26017 | 294 | 22 |
182741 | 182741 | 2020-05-27 | Benzie | Michigan | 26019 | 4 | 0 |
182742 | 182742 | 2020-05-27 | Berrien | Michigan | 26021 | 600 | 48 |
182743 | 182743 | 2020-05-27 | Branch | Michigan | 26023 | 898 | 24 |
182744 | 182744 | 2020-05-27 | Calhoun | Michigan | 26025 | 351 | 22 |
182745 | 182745 | 2020-05-27 | Cass | Michigan | 26027 | 79 | 2 |
182746 | 182746 | 2020-05-27 | Charlevoix | Michigan | 26029 | 15 | 1 |
182747 | 182747 | 2020-05-27 | Cheboygan | Michigan | 26031 | 21 | 1 |
182748 | 182748 | 2020-05-27 | Chippewa | Michigan | 26033 | 3 | 0 |
182749 | 182749 | 2020-05-27 | Clare | Michigan | 26035 | 17 | 2 |
182750 | 182750 | 2020-05-27 | Clinton | Michigan | 26037 | 142 | 10 |
182751 | 182751 | 2020-05-27 | Crawford | Michigan | 26039 | 58 | 5 |
182752 | 182752 | 2020-05-27 | Delta | Michigan | 26041 | 17 | 2 |
182753 | 182753 | 2020-05-27 | Dickinson | Michigan | 26043 | 5 | 2 |
182754 | 182754 | 2020-05-27 | Eaton | Michigan | 26045 | 179 | 6 |
182755 | 182755 | 2020-05-27 | Emmet | Michigan | 26047 | 21 | 2 |
182756 | 182756 | 2020-05-27 | Genesee | Michigan | 26049 | 1971 | 247 |
182757 | 182757 | 2020-05-27 | Gladwin | Michigan | 26051 | 18 | 1 |
182758 | 182758 | 2020-05-27 | Gogebic | Michigan | 26053 | 5 | 1 |
182759 | 182759 | 2020-05-27 | Grand Traverse | Michigan | 26055 | 23 | 5 |
182760 | 182760 | 2020-05-27 | Gratiot | Michigan | 26057 | 80 | 8 |
182761 | 182761 | 2020-05-27 | Hillsdale | Michigan | 26059 | 169 | 24 |
182762 | 182762 | 2020-05-27 | Houghton | Michigan | 26061 | 4 | 0 |
182763 | 182763 | 2020-05-27 | Huron | Michigan | 26063 | 42 | 1 |
182764 | 182764 | 2020-05-27 | Ingham | Michigan | 26065 | 717 | 25 |
182765 | 182765 | 2020-05-27 | Ionia | Michigan | 26067 | 148 | 3 |
182766 | 182766 | 2020-05-27 | Iosco | Michigan | 26069 | 89 | 9 |
182767 | 182767 | 2020-05-27 | Isabella | Michigan | 26073 | 74 | 7 |
182768 | 182768 | 2020-05-27 | Jackson | Michigan | 26075 | 1495 | 45 |
182769 | 182769 | 2020-05-27 | Kalamazoo | Michigan | 26077 | 814 | 51 |
182770 | 182770 | 2020-05-27 | Kalkaska | Michigan | 26079 | 19 | 2 |
182771 | 182771 | 2020-05-27 | Kent | Michigan | 26081 | 3458 | 76 |
182772 | 182772 | 2020-05-27 | Lake | Michigan | 26085 | 5 | 0 |
182773 | 182773 | 2020-05-27 | Lapeer | Michigan | 26087 | 477 | 36 |
182774 | 182774 | 2020-05-27 | Leelanau | Michigan | 26089 | 11 | 0 |
182775 | 182775 | 2020-05-27 | Lenawee | Michigan | 26091 | 874 | 7 |
182776 | 182776 | 2020-05-27 | Livingston | Michigan | 26093 | 399 | 27 |
182777 | 182777 | 2020-05-27 | Luce | Michigan | 26095 | 4 | 0 |
182778 | 182778 | 2020-05-27 | Mackinac | Michigan | 26097 | 6 | 0 |
182779 | 182779 | 2020-05-27 | Macomb | Michigan | 26099 | 6670 | 789 |
182780 | 182780 | 2020-05-27 | Manistee | Michigan | 26101 | 20 | 0 |
182781 | 182781 | 2020-05-27 | Marquette | Michigan | 26103 | 54 | 10 |
182782 | 182782 | 2020-05-27 | Mason | Michigan | 26105 | 31 | 0 |
182783 | 182783 | 2020-05-27 | Mecosta | Michigan | 26107 | 20 | 2 |
182784 | 182784 | 2020-05-27 | Menominee | Michigan | 26109 | 8 | 0 |
182785 | 182785 | 2020-05-27 | Midland | Michigan | 26111 | 80 | 8 |
182786 | 182786 | 2020-05-27 | Missaukee | Michigan | 26113 | 16 | 1 |
182787 | 182787 | 2020-05-27 | Monroe | Michigan | 26115 | 464 | 19 |
182788 | 182788 | 2020-05-27 | Montcalm | Michigan | 26117 | 67 | 1 |
182789 | 182789 | 2020-05-27 | Montmorency | Michigan | 26119 | 5 | 0 |
182790 | 182790 | 2020-05-27 | Muskegon | Michigan | 26121 | 606 | 33 |
182791 | 182791 | 2020-05-27 | Newaygo | Michigan | 26123 | 96 | 0 |
182792 | 182792 | 2020-05-27 | Oakland | Michigan | 26125 | 8260 | 961 |
182793 | 182793 | 2020-05-27 | Oceana | Michigan | 26127 | 85 | 2 |
182794 | 182794 | 2020-05-27 | Ogemaw | Michigan | 26129 | 21 | 0 |
182795 | 182795 | 2020-05-27 | Osceola | Michigan | 26133 | 11 | 0 |
182796 | 182796 | 2020-05-27 | Oscoda | Michigan | 26135 | 5 | 1 |
182797 | 182797 | 2020-05-27 | Otsego | Michigan | 26137 | 100 | 10 |
182798 | 182798 | 2020-05-27 | Ottawa | Michigan | 26139 | 715 | 31 |
182799 | 182799 | 2020-05-27 | Presque Isle | Michigan | 26141 | 11 | 0 |
182800 | 182800 | 2020-05-27 | Roscommon | Michigan | 26143 | 21 | 0 |
182801 | 182801 | 2020-05-27 | Saginaw | Michigan | 26145 | 1003 | 107 |
182802 | 182802 | 2020-05-27 | Sanilac | Michigan | 26151 | 40 | 5 |
182803 | 182803 | 2020-05-27 | Schoolcraft | Michigan | 26153 | 4 | 0 |
182804 | 182804 | 2020-05-27 | Shiawassee | Michigan | 26155 | 237 | 26 |
182805 | 182805 | 2020-05-27 | St. Clair | Michigan | 26147 | 431 | 37 |
182806 | 182806 | 2020-05-27 | St. Joseph | Michigan | 26149 | 109 | 2 |
182807 | 182807 | 2020-05-27 | Tuscola | Michigan | 26157 | 186 | 23 |
182808 | 182808 | 2020-05-27 | Unknown | Michigan | 284 | 3 | |
182809 | 182809 | 2020-05-27 | Van Buren | Michigan | 26159 | 131 | 6 |
182810 | 182810 | 2020-05-27 | Washtenaw | Michigan | 26161 | 1688 | 104 |
182811 | 182811 | 2020-05-27 | Wayne | Michigan | 26163 | 20022 | 2408 |
182812 | 182812 | 2020-05-27 | Wexford | Michigan | 26165 | 11 | 2 |
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);