ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where "date" is on date 2020-05-04 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
113639 | 113639 | 2020-05-04 | Alcona | Michigan | 26001 | 4 | 1 |
113640 | 113640 | 2020-05-04 | Allegan | Michigan | 26005 | 116 | 2 |
113641 | 113641 | 2020-05-04 | Alpena | Michigan | 26007 | 83 | 7 |
113642 | 113642 | 2020-05-04 | Antrim | Michigan | 26009 | 10 | 0 |
113643 | 113643 | 2020-05-04 | Arenac | Michigan | 26011 | 28 | 1 |
113644 | 113644 | 2020-05-04 | Baraga | Michigan | 26013 | 1 | 0 |
113645 | 113645 | 2020-05-04 | Barry | Michigan | 26015 | 37 | 1 |
113646 | 113646 | 2020-05-04 | Bay | Michigan | 26017 | 161 | 8 |
113647 | 113647 | 2020-05-04 | Benzie | Michigan | 26019 | 4 | 0 |
113648 | 113648 | 2020-05-04 | Berrien | Michigan | 26021 | 304 | 20 |
113649 | 113649 | 2020-05-04 | Branch | Michigan | 26023 | 857 | 16 |
113650 | 113650 | 2020-05-04 | Calhoun | Michigan | 26025 | 244 | 16 |
113651 | 113651 | 2020-05-04 | Cass | Michigan | 26027 | 33 | 2 |
113652 | 113652 | 2020-05-04 | Charlevoix | Michigan | 26029 | 13 | 1 |
113653 | 113653 | 2020-05-04 | Cheboygan | Michigan | 26031 | 19 | 1 |
113654 | 113654 | 2020-05-04 | Chippewa | Michigan | 26033 | 3 | 0 |
113655 | 113655 | 2020-05-04 | Clare | Michigan | 26035 | 11 | 2 |
113656 | 113656 | 2020-05-04 | Clinton | Michigan | 26037 | 119 | 10 |
113657 | 113657 | 2020-05-04 | Crawford | Michigan | 26039 | 56 | 4 |
113658 | 113658 | 2020-05-04 | Delta | Michigan | 26041 | 13 | 2 |
113659 | 113659 | 2020-05-04 | Dickinson | Michigan | 26043 | 3 | 2 |
113660 | 113660 | 2020-05-04 | Eaton | Michigan | 26045 | 137 | 6 |
113661 | 113661 | 2020-05-04 | Emmet | Michigan | 26047 | 21 | 2 |
113662 | 113662 | 2020-05-04 | Genesee | Michigan | 26049 | 1647 | 199 |
113663 | 113663 | 2020-05-04 | Gladwin | Michigan | 26051 | 14 | 1 |
113664 | 113664 | 2020-05-04 | Gogebic | Michigan | 26053 | 5 | 1 |
113665 | 113665 | 2020-05-04 | Grand Traverse | Michigan | 26055 | 20 | 5 |
113666 | 113666 | 2020-05-04 | Gratiot | Michigan | 26057 | 25 | 2 |
113667 | 113667 | 2020-05-04 | Hillsdale | Michigan | 26059 | 131 | 21 |
113668 | 113668 | 2020-05-04 | Houghton | Michigan | 26061 | 2 | 0 |
113669 | 113669 | 2020-05-04 | Huron | Michigan | 26063 | 24 | 1 |
113670 | 113670 | 2020-05-04 | Ingham | Michigan | 26065 | 506 | 13 |
113671 | 113671 | 2020-05-04 | Ionia | Michigan | 26067 | 93 | 2 |
113672 | 113672 | 2020-05-04 | Iosco | Michigan | 26069 | 52 | 7 |
113673 | 113673 | 2020-05-04 | Isabella | Michigan | 26073 | 61 | 7 |
113674 | 113674 | 2020-05-04 | Jackson | Michigan | 26075 | 1278 | 42 |
113675 | 113675 | 2020-05-04 | Kalamazoo | Michigan | 26077 | 480 | 22 |
113676 | 113676 | 2020-05-04 | Kalkaska | Michigan | 26079 | 17 | 2 |
113677 | 113677 | 2020-05-04 | Kent | Michigan | 26081 | 1857 | 39 |
113678 | 113678 | 2020-05-04 | Lake | Michigan | 26085 | 2 | 0 |
113679 | 113679 | 2020-05-04 | Lapeer | Michigan | 26087 | 223 | 28 |
113680 | 113680 | 2020-05-04 | Leelanau | Michigan | 26089 | 9 | 0 |
113681 | 113681 | 2020-05-04 | Lenawee | Michigan | 26091 | 160 | 2 |
113682 | 113682 | 2020-05-04 | Livingston | Michigan | 26093 | 364 | 21 |
113683 | 113683 | 2020-05-04 | Luce | Michigan | 26095 | 2 | 0 |
113684 | 113684 | 2020-05-04 | Mackinac | Michigan | 26097 | 6 | 0 |
113685 | 113685 | 2020-05-04 | Macomb | Michigan | 26099 | 5835 | 648 |
113686 | 113686 | 2020-05-04 | Manistee | Michigan | 26101 | 11 | 0 |
113687 | 113687 | 2020-05-04 | Marquette | Michigan | 26103 | 50 | 8 |
113688 | 113688 | 2020-05-04 | Mason | Michigan | 26105 | 12 | 0 |
113689 | 113689 | 2020-05-04 | Mecosta | Michigan | 26107 | 14 | 2 |
113690 | 113690 | 2020-05-04 | Menominee | Michigan | 26109 | 6 | 0 |
113691 | 113691 | 2020-05-04 | Midland | Michigan | 26111 | 62 | 7 |
113692 | 113692 | 2020-05-04 | Missaukee | Michigan | 26113 | 16 | 1 |
113693 | 113693 | 2020-05-04 | Monroe | Michigan | 26115 | 320 | 13 |
113694 | 113694 | 2020-05-04 | Montcalm | Michigan | 26117 | 45 | 1 |
113695 | 113695 | 2020-05-04 | Montmorency | Michigan | 26119 | 5 | 0 |
113696 | 113696 | 2020-05-04 | Muskegon | Michigan | 26121 | 313 | 17 |
113697 | 113697 | 2020-05-04 | Newaygo | Michigan | 26123 | 28 | 0 |
113698 | 113698 | 2020-05-04 | Oakland | Michigan | 26125 | 7499 | 762 |
113699 | 113699 | 2020-05-04 | Oceana | Michigan | 26127 | 19 | 1 |
113700 | 113700 | 2020-05-04 | Ogemaw | Michigan | 26129 | 15 | 0 |
113701 | 113701 | 2020-05-04 | Osceola | Michigan | 26133 | 8 | 0 |
113702 | 113702 | 2020-05-04 | Oscoda | Michigan | 26135 | 5 | 0 |
113703 | 113703 | 2020-05-04 | Otsego | Michigan | 26137 | 93 | 8 |
113704 | 113704 | 2020-05-04 | Ottawa | Michigan | 26139 | 281 | 12 |
113705 | 113705 | 2020-05-04 | Presque Isle | Michigan | 26141 | 11 | 0 |
113706 | 113706 | 2020-05-04 | Roscommon | Michigan | 26143 | 18 | 0 |
113707 | 113707 | 2020-05-04 | Saginaw | Michigan | 26145 | 729 | 68 |
113708 | 113708 | 2020-05-04 | Sanilac | Michigan | 26151 | 36 | 5 |
113709 | 113709 | 2020-05-04 | Schoolcraft | Michigan | 26153 | 3 | 0 |
113710 | 113710 | 2020-05-04 | Shiawassee | Michigan | 26155 | 185 | 12 |
113711 | 113711 | 2020-05-04 | St. Clair | Michigan | 26147 | 339 | 21 |
113712 | 113712 | 2020-05-04 | St. Joseph | Michigan | 26149 | 42 | 1 |
113713 | 113713 | 2020-05-04 | Tuscola | Michigan | 26157 | 113 | 14 |
113714 | 113714 | 2020-05-04 | Unknown | Michigan | 0 | 3 | |
113715 | 113715 | 2020-05-04 | Van Buren | Michigan | 26159 | 67 | 2 |
113716 | 113716 | 2020-05-04 | Washtenaw | Michigan | 26161 | 1218 | 82 |
113717 | 113717 | 2020-05-04 | Wayne | Michigan | 26163 | 17334 | 1926 |
113718 | 113718 | 2020-05-04 | Wexford | Michigan | 26165 | 9 | 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);