ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
681550 | 681550 | 2020-10-30 | Alcona | Michigan | 26001 | 55 | 3 |
681551 | 681551 | 2020-10-30 | Alger | Michigan | 26003 | 120 | 1 |
681552 | 681552 | 2020-10-30 | Allegan | Michigan | 26005 | 1434 | 7 |
681553 | 681553 | 2020-10-30 | Alpena | Michigan | 26007 | 175 | 14 |
681554 | 681554 | 2020-10-30 | Antrim | Michigan | 26009 | 142 | 0 |
681555 | 681555 | 2020-10-30 | Arenac | Michigan | 26011 | 109 | 3 |
681556 | 681556 | 2020-10-30 | Baraga | Michigan | 26013 | 115 | 4 |
681557 | 681557 | 2020-10-30 | Barry | Michigan | 26015 | 774 | 6 |
681558 | 681558 | 2020-10-30 | Bay | Michigan | 26017 | 1525 | 63 |
681559 | 681559 | 2020-10-30 | Benzie | Michigan | 26019 | 143 | 2 |
681560 | 681560 | 2020-10-30 | Berrien | Michigan | 26021 | 2978 | 86 |
681561 | 681561 | 2020-10-30 | Branch | Michigan | 26023 | 1763 | 34 |
681562 | 681562 | 2020-10-30 | Calhoun | Michigan | 26025 | 3157 | 69 |
681563 | 681563 | 2020-10-30 | Cass | Michigan | 26027 | 1073 | 24 |
681564 | 681564 | 2020-10-30 | Charlevoix | Michigan | 26029 | 220 | 4 |
681565 | 681565 | 2020-10-30 | Cheboygan | Michigan | 26031 | 183 | 2 |
681566 | 681566 | 2020-10-30 | Chippewa | Michigan | 26033 | 183 | 0 |
681567 | 681567 | 2020-10-30 | Clare | Michigan | 26035 | 309 | 13 |
681568 | 681568 | 2020-10-30 | Clinton | Michigan | 26037 | 1249 | 16 |
681569 | 681569 | 2020-10-30 | Crawford | Michigan | 26039 | 157 | 5 |
681570 | 681570 | 2020-10-30 | Delta | Michigan | 26041 | 1332 | 34 |
681571 | 681571 | 2020-10-30 | Dickinson | Michigan | 26043 | 722 | 21 |
681572 | 681572 | 2020-10-30 | Eaton | Michigan | 26045 | 1245 | 11 |
681573 | 681573 | 2020-10-30 | Emmet | Michigan | 26047 | 322 | 4 |
681574 | 681574 | 2020-10-30 | Genesee | Michigan | 26049 | 7213 | 341 |
681575 | 681575 | 2020-10-30 | Gladwin | Michigan | 26051 | 234 | 2 |
681576 | 681576 | 2020-10-30 | Gogebic | Michigan | 26053 | 443 | 11 |
681577 | 681577 | 2020-10-30 | Grand Traverse | Michigan | 26055 | 868 | 14 |
681578 | 681578 | 2020-10-30 | Gratiot | Michigan | 26057 | 591 | 17 |
681579 | 681579 | 2020-10-30 | Hillsdale | Michigan | 26059 | 564 | 29 |
681580 | 681580 | 2020-10-30 | Houghton | Michigan | 26061 | 977 | 9 |
681581 | 681581 | 2020-10-30 | Huron | Michigan | 26063 | 286 | 6 |
681582 | 681582 | 2020-10-30 | Ingham | Michigan | 26065 | 4834 | 68 |
681583 | 681583 | 2020-10-30 | Ionia | Michigan | 26067 | 989 | 9 |
681584 | 681584 | 2020-10-30 | Iosco | Michigan | 26069 | 309 | 16 |
681585 | 681585 | 2020-10-30 | Iron | Michigan | 26071 | 465 | 25 |
681586 | 681586 | 2020-10-30 | Isabella | Michigan | 26073 | 1120 | 15 |
681587 | 681587 | 2020-10-30 | Jackson | Michigan | 26075 | 3643 | 91 |
681588 | 681588 | 2020-10-30 | Kalamazoo | Michigan | 26077 | 5111 | 112 |
681589 | 681589 | 2020-10-30 | Kalkaska | Michigan | 26079 | 145 | 4 |
681590 | 681590 | 2020-10-30 | Kent | Michigan | 26081 | 15528 | 186 |
681591 | 681591 | 2020-10-30 | Keweenaw | Michigan | 26083 | 21 | 0 |
681592 | 681592 | 2020-10-30 | Lake | Michigan | 26085 | 67 | 1 |
681593 | 681593 | 2020-10-30 | Lapeer | Michigan | 26087 | 1288 | 45 |
681594 | 681594 | 2020-10-30 | Leelanau | Michigan | 26089 | 160 | 2 |
681595 | 681595 | 2020-10-30 | Lenawee | Michigan | 26091 | 1926 | 24 |
681596 | 681596 | 2020-10-30 | Livingston | Michigan | 26093 | 2324 | 36 |
681597 | 681597 | 2020-10-30 | Luce | Michigan | 26095 | 322 | 1 |
681598 | 681598 | 2020-10-30 | Mackinac | Michigan | 26097 | 167 | 0 |
681599 | 681599 | 2020-10-30 | Macomb | Michigan | 26099 | 19647 | 1098 |
681600 | 681600 | 2020-10-30 | Manistee | Michigan | 26101 | 163 | 3 |
681601 | 681601 | 2020-10-30 | Marquette | Michigan | 26103 | 1196 | 15 |
681602 | 681602 | 2020-10-30 | Mason | Michigan | 26105 | 273 | 2 |
681603 | 681603 | 2020-10-30 | Mecosta | Michigan | 26107 | 588 | 4 |
681604 | 681604 | 2020-10-30 | Menominee | Michigan | 26109 | 757 | 6 |
681605 | 681605 | 2020-10-30 | Midland | Michigan | 26111 | 1138 | 14 |
681606 | 681606 | 2020-10-30 | Missaukee | Michigan | 26113 | 94 | 1 |
681607 | 681607 | 2020-10-30 | Monroe | Michigan | 26115 | 2134 | 39 |
681608 | 681608 | 2020-10-30 | Montcalm | Michigan | 26117 | 755 | 13 |
681609 | 681609 | 2020-10-30 | Montmorency | Michigan | 26119 | 37 | 0 |
681610 | 681610 | 2020-10-30 | Muskegon | Michigan | 26121 | 3456 | 88 |
681611 | 681611 | 2020-10-30 | Newaygo | Michigan | 26123 | 689 | 4 |
681612 | 681612 | 2020-10-30 | Oakland | Michigan | 26125 | 26259 | 1239 |
681613 | 681613 | 2020-10-30 | Oceana | Michigan | 26127 | 666 | 6 |
681614 | 681614 | 2020-10-30 | Ogemaw | Michigan | 26129 | 125 | 5 |
681615 | 681615 | 2020-10-30 | Ontonagon | Michigan | 26131 | 116 | 0 |
681616 | 681616 | 2020-10-30 | Osceola | Michigan | 26133 | 195 | 1 |
681617 | 681617 | 2020-10-30 | Oscoda | Michigan | 26135 | 60 | 2 |
681618 | 681618 | 2020-10-30 | Otsego | Michigan | 26137 | 297 | 12 |
681619 | 681619 | 2020-10-30 | Ottawa | Michigan | 26139 | 5569 | 78 |
681620 | 681620 | 2020-10-30 | Presque Isle | Michigan | 26141 | 79 | 1 |
681621 | 681621 | 2020-10-30 | Roscommon | Michigan | 26143 | 213 | 6 |
681622 | 681622 | 2020-10-30 | Saginaw | Michigan | 26145 | 4138 | 157 |
681623 | 681623 | 2020-10-30 | Sanilac | Michigan | 26151 | 223 | 7 |
681624 | 681624 | 2020-10-30 | Schoolcraft | Michigan | 26153 | 93 | 1 |
681625 | 681625 | 2020-10-30 | Shiawassee | Michigan | 26155 | 786 | 34 |
681626 | 681626 | 2020-10-30 | St. Clair | Michigan | 26147 | 1686 | 65 |
681627 | 681627 | 2020-10-30 | St. Joseph | Michigan | 26149 | 1326 | 23 |
681628 | 681628 | 2020-10-30 | Tuscola | Michigan | 26157 | 709 | 36 |
681629 | 681629 | 2020-10-30 | Unknown | Michigan | 1442 | 4 | |
681630 | 681630 | 2020-10-30 | Van Buren | Michigan | 26159 | 1182 | 20 |
681631 | 681631 | 2020-10-30 | Washtenaw | Michigan | 26161 | 6240 | 129 |
681632 | 681632 | 2020-10-30 | Wayne | Michigan | 26163 | 41757 | 3057 |
681633 | 681633 | 2020-10-30 | Wexford | Michigan | 26165 | 192 | 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);