ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2021-12-25 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2048606 | 2048606 | 2021-12-25 | Alcona | Michigan | 26001 | 1401 | 55 |
2048607 | 2048607 | 2021-12-25 | Alger | Michigan | 26003 | 1217 | 11 |
2048608 | 2048608 | 2021-12-25 | Allegan | Michigan | 26005 | 19899 | 267 |
2048609 | 2048609 | 2021-12-25 | Alpena | Michigan | 26007 | 4473 | 110 |
2048610 | 2048610 | 2021-12-25 | Antrim | Michigan | 26009 | 3101 | 50 |
2048611 | 2048611 | 2021-12-25 | Arenac | Michigan | 26011 | 2320 | 50 |
2048612 | 2048612 | 2021-12-25 | Baraga | Michigan | 26013 | 1643 | 48 |
2048613 | 2048613 | 2021-12-25 | Barry | Michigan | 26015 | 10518 | 125 |
2048614 | 2048614 | 2021-12-25 | Bay | Michigan | 26017 | 18849 | 467 |
2048615 | 2048615 | 2021-12-25 | Benzie | Michigan | 26019 | 2363 | 52 |
2048616 | 2048616 | 2021-12-25 | Berrien | Michigan | 26021 | 24685 | 385 |
2048617 | 2048617 | 2021-12-25 | Branch | Michigan | 26023 | 9269 | 161 |
2048618 | 2048618 | 2021-12-25 | Calhoun | Michigan | 26025 | 24376 | 456 |
2048619 | 2048619 | 2021-12-25 | Cass | Michigan | 26027 | 8878 | 110 |
2048620 | 2048620 | 2021-12-25 | Charlevoix | Michigan | 26029 | 3368 | 51 |
2048621 | 2048621 | 2021-12-25 | Cheboygan | Michigan | 26031 | 3593 | 80 |
2048622 | 2048622 | 2021-12-25 | Chippewa | Michigan | 26033 | 8119 | 80 |
2048623 | 2048623 | 2021-12-25 | Clare | Michigan | 26035 | 5054 | 130 |
2048624 | 2048624 | 2021-12-25 | Clinton | Michigan | 26037 | 13825 | 158 |
2048625 | 2048625 | 2021-12-25 | Crawford | Michigan | 26039 | 1910 | 20 |
2048626 | 2048626 | 2021-12-25 | Delta | Michigan | 26041 | 7035 | 132 |
2048627 | 2048627 | 2021-12-25 | Dickinson | Michigan | 26043 | 5022 | 92 |
2048628 | 2048628 | 2021-12-25 | Eaton | Michigan | 26045 | 17861 | 313 |
2048629 | 2048629 | 2021-12-25 | Emmet | Michigan | 26047 | 4454 | 59 |
2048630 | 2048630 | 2021-12-25 | Genesee | Michigan | 26049 | 70005 | 1309 |
2048631 | 2048631 | 2021-12-25 | Gladwin | Michigan | 26051 | 4036 | 93 |
2048632 | 2048632 | 2021-12-25 | Gogebic | Michigan | 26053 | 2295 | 62 |
2048633 | 2048633 | 2021-12-25 | Grand Traverse | Michigan | 26055 | 12008 | 172 |
2048634 | 2048634 | 2021-12-25 | Gratiot | Michigan | 26057 | 10739 | 162 |
2048635 | 2048635 | 2021-12-25 | Hillsdale | Michigan | 26059 | 8146 | 167 |
2048636 | 2048636 | 2021-12-25 | Houghton | Michigan | 26061 | 5610 | 71 |
2048637 | 2048637 | 2021-12-25 | Huron | Michigan | 26063 | 6225 | 120 |
2048638 | 2048638 | 2021-12-25 | Ingham | Michigan | 26065 | 40673 | 568 |
2048639 | 2048639 | 2021-12-25 | Ionia | Michigan | 26067 | 14952 | 142 |
2048640 | 2048640 | 2021-12-25 | Iosco | Michigan | 26069 | 3754 | 112 |
2048641 | 2048641 | 2021-12-25 | Iron | Michigan | 26071 | 1844 | 70 |
2048642 | 2048642 | 2021-12-25 | Isabella | Michigan | 26073 | 11175 | 159 |
2048643 | 2048643 | 2021-12-25 | Jackson | Michigan | 26075 | 33453 | 451 |
2048644 | 2048644 | 2021-12-25 | Kalamazoo | Michigan | 26077 | 38630 | 536 |
2048645 | 2048645 | 2021-12-25 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2048646 | 2048646 | 2021-12-25 | Kent | Michigan | 26081 | 119292 | 1213 |
2048647 | 2048647 | 2021-12-25 | Keweenaw | Michigan | 26083 | 387 | 11 |
2048648 | 2048648 | 2021-12-25 | Lake | Michigan | 26085 | 1372 | 31 |
2048649 | 2048649 | 2021-12-25 | Lapeer | Michigan | 26087 | 15755 | 325 |
2048650 | 2048650 | 2021-12-25 | Leelanau | Michigan | 26089 | 2431 | 41 |
2048651 | 2048651 | 2021-12-25 | Lenawee | Michigan | 26091 | 18795 | 250 |
2048652 | 2048652 | 2021-12-25 | Livingston | Michigan | 26093 | 32151 | 349 |
2048653 | 2048653 | 2021-12-25 | Luce | Michigan | 26095 | 1860 | 6 |
2048654 | 2048654 | 2021-12-25 | Mackinac | Michigan | 26097 | 1666 | 19 |
2048655 | 2048655 | 2021-12-25 | Macomb | Michigan | 26099 | 157970 | 3144 |
2048656 | 2048656 | 2021-12-25 | Manistee | Michigan | 26101 | 3247 | 58 |
2048657 | 2048657 | 2021-12-25 | Marquette | Michigan | 26103 | 9834 | 95 |
2048658 | 2048658 | 2021-12-25 | Mason | Michigan | 26105 | 4687 | 66 |
2048659 | 2048659 | 2021-12-25 | Mecosta | Michigan | 26107 | 6268 | 81 |
2048660 | 2048660 | 2021-12-25 | Menominee | Michigan | 26109 | 4152 | 60 |
2048661 | 2048661 | 2021-12-25 | Midland | Michigan | 26111 | 13237 | 181 |
2048662 | 2048662 | 2021-12-25 | Missaukee | Michigan | 26113 | 2213 | 45 |
2048663 | 2048663 | 2021-12-25 | Monroe | Michigan | 26115 | 26422 | 364 |
2048664 | 2048664 | 2021-12-25 | Montcalm | Michigan | 26117 | 13559 | 166 |
2048665 | 2048665 | 2021-12-25 | Montmorency | Michigan | 26119 | 1331 | 40 |
2048666 | 2048666 | 2021-12-25 | Muskegon | Michigan | 26121 | 30917 | 513 |
2048667 | 2048667 | 2021-12-25 | Newaygo | Michigan | 26123 | 8671 | 128 |
2048668 | 2048668 | 2021-12-25 | Oakland | Michigan | 26125 | 189146 | 3053 |
2048669 | 2048669 | 2021-12-25 | Oceana | Michigan | 26127 | 4873 | 84 |
2048670 | 2048670 | 2021-12-25 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2048671 | 2048671 | 2021-12-25 | Ontonagon | Michigan | 26131 | 737 | 26 |
2048672 | 2048672 | 2021-12-25 | Osceola | Michigan | 26133 | 3845 | 60 |
2048673 | 2048673 | 2021-12-25 | Oscoda | Michigan | 26135 | 1159 | 49 |
2048674 | 2048674 | 2021-12-25 | Otsego | Michigan | 26137 | 4265 | 78 |
2048675 | 2048675 | 2021-12-25 | Ottawa | Michigan | 26139 | 54422 | 629 |
2048676 | 2048676 | 2021-12-25 | Presque Isle | Michigan | 26141 | 1718 | 50 |
2048677 | 2048677 | 2021-12-25 | Roscommon | Michigan | 26143 | 3589 | 99 |
2048678 | 2048678 | 2021-12-25 | Saginaw | Michigan | 26145 | 36249 | 784 |
2048679 | 2048679 | 2021-12-25 | Sanilac | Michigan | 26151 | 6678 | 163 |
2048680 | 2048680 | 2021-12-25 | Schoolcraft | Michigan | 26153 | 1184 | 8 |
2048681 | 2048681 | 2021-12-25 | Shiawassee | Michigan | 26155 | 12452 | 176 |
2048682 | 2048682 | 2021-12-25 | St. Clair | Michigan | 26147 | 30096 | 633 |
2048683 | 2048683 | 2021-12-25 | St. Joseph | Michigan | 26149 | 10704 | 157 |
2048684 | 2048684 | 2021-12-25 | Tuscola | Michigan | 26157 | 9829 | 233 |
2048685 | 2048685 | 2021-12-25 | Unknown | Michigan | 2148 | 22 | |
2048686 | 2048686 | 2021-12-25 | Van Buren | Michigan | 26159 | 12457 | 204 |
2048687 | 2048687 | 2021-12-25 | Washtenaw | Michigan | 26161 | 44113 | 395 |
2048688 | 2048688 | 2021-12-25 | Wayne | Michigan | 26163 | 258996 | 6355 |
2048689 | 2048689 | 2021-12-25 | Wexford | Michigan | 26165 | 5000 | 84 |
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);