ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-03-31" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22620 | 22620 | 2020-03-31 | Allegan | Michigan | 26005 | 3 | 0 |
22621 | 22621 | 2020-03-31 | Antrim | Michigan | 26009 | 3 | 0 |
22622 | 22622 | 2020-03-31 | Arenac | Michigan | 26011 | 1 | 0 |
22623 | 22623 | 2020-03-31 | Barry | Michigan | 26015 | 2 | 0 |
22624 | 22624 | 2020-03-31 | Bay | Michigan | 26017 | 9 | 0 |
22625 | 22625 | 2020-03-31 | Berrien | Michigan | 26021 | 35 | 1 |
22626 | 22626 | 2020-03-31 | Branch | Michigan | 26023 | 2 | 0 |
22627 | 22627 | 2020-03-31 | Calhoun | Michigan | 26025 | 17 | 0 |
22628 | 22628 | 2020-03-31 | Cass | Michigan | 26027 | 4 | 1 |
22629 | 22629 | 2020-03-31 | Charlevoix | Michigan | 26029 | 4 | 0 |
22630 | 22630 | 2020-03-31 | Cheboygan | Michigan | 26031 | 1 | 0 |
22631 | 22631 | 2020-03-31 | Chippewa | Michigan | 26033 | 1 | 0 |
22632 | 22632 | 2020-03-31 | Clare | Michigan | 26035 | 1 | 0 |
22633 | 22633 | 2020-03-31 | Clinton | Michigan | 26037 | 24 | 0 |
22634 | 22634 | 2020-03-31 | Crawford | Michigan | 26039 | 1 | 0 |
22635 | 22635 | 2020-03-31 | Delta | Michigan | 26041 | 1 | 0 |
22636 | 22636 | 2020-03-31 | Eaton | Michigan | 26045 | 21 | 0 |
22637 | 22637 | 2020-03-31 | Emmet | Michigan | 26047 | 5 | 0 |
22638 | 22638 | 2020-03-31 | Genesee | Michigan | 26049 | 185 | 7 |
22639 | 22639 | 2020-03-31 | Gladwin | Michigan | 26051 | 2 | 0 |
22640 | 22640 | 2020-03-31 | Gogebic | Michigan | 26053 | 2 | 1 |
22641 | 22641 | 2020-03-31 | Grand Traverse | Michigan | 26055 | 7 | 0 |
22642 | 22642 | 2020-03-31 | Gratiot | Michigan | 26057 | 3 | 0 |
22643 | 22643 | 2020-03-31 | Hillsdale | Michigan | 26059 | 14 | 1 |
22644 | 22644 | 2020-03-31 | Houghton | Michigan | 26061 | 1 | 0 |
22645 | 22645 | 2020-03-31 | Huron | Michigan | 26063 | 3 | 0 |
22646 | 22646 | 2020-03-31 | Ingham | Michigan | 26065 | 91 | 0 |
22647 | 22647 | 2020-03-31 | Ionia | Michigan | 26067 | 4 | 0 |
22648 | 22648 | 2020-03-31 | Iosco | Michigan | 26069 | 1 | 0 |
22649 | 22649 | 2020-03-31 | Isabella | Michigan | 26073 | 6 | 1 |
22650 | 22650 | 2020-03-31 | Jackson | Michigan | 26075 | 47 | 1 |
22651 | 22651 | 2020-03-31 | Kalamazoo | Michigan | 26077 | 24 | 1 |
22652 | 22652 | 2020-03-31 | Kalkaska | Michigan | 26079 | 7 | 1 |
22653 | 22653 | 2020-03-31 | Kent | Michigan | 26081 | 108 | 1 |
22654 | 22654 | 2020-03-31 | Lapeer | Michigan | 26087 | 8 | 0 |
22655 | 22655 | 2020-03-31 | Leelanau | Michigan | 26089 | 1 | 0 |
22656 | 22656 | 2020-03-31 | Lenawee | Michigan | 26091 | 18 | 0 |
22657 | 22657 | 2020-03-31 | Livingston | Michigan | 26093 | 80 | 2 |
22658 | 22658 | 2020-03-31 | Macomb | Michigan | 26099 | 853 | 38 |
22659 | 22659 | 2020-03-31 | Manistee | Michigan | 26101 | 1 | 0 |
22660 | 22660 | 2020-03-31 | Marquette | Michigan | 26103 | 4 | 0 |
22661 | 22661 | 2020-03-31 | Mecosta | Michigan | 26107 | 3 | 1 |
22662 | 22662 | 2020-03-31 | Midland | Michigan | 26111 | 10 | 0 |
22663 | 22663 | 2020-03-31 | Missaukee | Michigan | 26113 | 1 | 1 |
22664 | 22664 | 2020-03-31 | Monroe | Michigan | 26115 | 49 | 0 |
22665 | 22665 | 2020-03-31 | Montcalm | Michigan | 26117 | 5 | 0 |
22666 | 22666 | 2020-03-31 | Muskegon | Michigan | 26121 | 18 | 2 |
22667 | 22667 | 2020-03-31 | Newaygo | Michigan | 26123 | 1 | 0 |
22668 | 22668 | 2020-03-31 | Oakland | Michigan | 26125 | 1620 | 75 |
22669 | 22669 | 2020-03-31 | Oceana | Michigan | 26127 | 2 | 0 |
22670 | 22670 | 2020-03-31 | Ogemaw | Michigan | 26129 | 1 | 0 |
22671 | 22671 | 2020-03-31 | Osceola | Michigan | 26133 | 2 | 0 |
22672 | 22672 | 2020-03-31 | Oscoda | Michigan | 26135 | 2 | 0 |
22673 | 22673 | 2020-03-31 | Otsego | Michigan | 26137 | 19 | 0 |
22674 | 22674 | 2020-03-31 | Ottawa | Michigan | 26139 | 31 | 0 |
22675 | 22675 | 2020-03-31 | Roscommon | Michigan | 26143 | 1 | 0 |
22676 | 22676 | 2020-03-31 | Saginaw | Michigan | 26145 | 51 | 0 |
22677 | 22677 | 2020-03-31 | Sanilac | Michigan | 26151 | 7 | 0 |
22678 | 22678 | 2020-03-31 | Shiawassee | Michigan | 26155 | 8 | 0 |
22679 | 22679 | 2020-03-31 | St. Clair | Michigan | 26147 | 32 | 0 |
22680 | 22680 | 2020-03-31 | St. Joseph | Michigan | 26149 | 4 | 0 |
22681 | 22681 | 2020-03-31 | Tuscola | Michigan | 26157 | 9 | 2 |
22682 | 22682 | 2020-03-31 | Unknown | Michigan | 93 | 0 | |
22683 | 22683 | 2020-03-31 | Van Buren | Michigan | 26159 | 7 | 0 |
22684 | 22684 | 2020-03-31 | Washtenaw | Michigan | 26161 | 311 | 7 |
22685 | 22685 | 2020-03-31 | Wayne | Michigan | 26163 | 3735 | 120 |
22686 | 22686 | 2020-03-31 | Wexford | Michigan | 26165 | 2 | 0 |
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);