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 2022-01-30 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2165678 | 2165678 | 2022-01-30 | Alcona | Michigan | 26001 | 1608 | 63 |
2165679 | 2165679 | 2022-01-30 | Alger | Michigan | 26003 | 1747 | 12 |
2165680 | 2165680 | 2022-01-30 | Allegan | Michigan | 26005 | 25344 | 305 |
2165681 | 2165681 | 2022-01-30 | Alpena | Michigan | 26007 | 5125 | 123 |
2165682 | 2165682 | 2022-01-30 | Antrim | Michigan | 26009 | 3957 | 53 |
2165683 | 2165683 | 2022-01-30 | Arenac | Michigan | 26011 | 2967 | 60 |
2165684 | 2165684 | 2022-01-30 | Baraga | Michigan | 26013 | 2068 | 51 |
2165685 | 2165685 | 2022-01-30 | Barry | Michigan | 26015 | 13375 | 147 |
2165686 | 2165686 | 2022-01-30 | Bay | Michigan | 26017 | 25283 | 531 |
2165687 | 2165687 | 2022-01-30 | Benzie | Michigan | 26019 | 3189 | 60 |
2165688 | 2165688 | 2022-01-30 | Berrien | Michigan | 26021 | 32698 | 464 |
2165689 | 2165689 | 2022-01-30 | Branch | Michigan | 26023 | 11366 | 181 |
2165690 | 2165690 | 2022-01-30 | Calhoun | Michigan | 26025 | 31807 | 523 |
2165691 | 2165691 | 2022-01-30 | Cass | Michigan | 26027 | 10616 | 124 |
2165692 | 2165692 | 2022-01-30 | Charlevoix | Michigan | 26029 | 4613 | 55 |
2165693 | 2165693 | 2022-01-30 | Cheboygan | Michigan | 26031 | 4337 | 88 |
2165694 | 2165694 | 2022-01-30 | Chippewa | Michigan | 26033 | 10784 | 97 |
2165695 | 2165695 | 2022-01-30 | Clare | Michigan | 26035 | 6206 | 147 |
2165696 | 2165696 | 2022-01-30 | Clinton | Michigan | 26037 | 18790 | 185 |
2165697 | 2165697 | 2022-01-30 | Crawford | Michigan | 26039 | 2333 | 23 |
2165698 | 2165698 | 2022-01-30 | Delta | Michigan | 26041 | 9309 | 144 |
2165699 | 2165699 | 2022-01-30 | Dickinson | Michigan | 26043 | 6900 | 98 |
2165700 | 2165700 | 2022-01-30 | Eaton | Michigan | 26045 | 24800 | 349 |
2165701 | 2165701 | 2022-01-30 | Emmet | Michigan | 26047 | 5963 | 65 |
2165702 | 2165702 | 2022-01-30 | Genesee | Michigan | 26049 | 95106 | 1524 |
2165703 | 2165703 | 2022-01-30 | Gladwin | Michigan | 26051 | 5210 | 103 |
2165704 | 2165704 | 2022-01-30 | Gogebic | Michigan | 26053 | 3061 | 64 |
2165705 | 2165705 | 2022-01-30 | Grand Traverse | Michigan | 26055 | 15824 | 195 |
2165706 | 2165706 | 2022-01-30 | Gratiot | Michigan | 26057 | 12550 | 175 |
2165707 | 2165707 | 2022-01-30 | Hillsdale | Michigan | 26059 | 9596 | 180 |
2165708 | 2165708 | 2022-01-30 | Houghton | Michigan | 26061 | 7367 | 82 |
2165709 | 2165709 | 2022-01-30 | Huron | Michigan | 26063 | 7594 | 136 |
2165710 | 2165710 | 2022-01-30 | Ingham | Michigan | 26065 | 59438 | 666 |
2165711 | 2165711 | 2022-01-30 | Ionia | Michigan | 26067 | 18253 | 166 |
2165712 | 2165712 | 2022-01-30 | Iosco | Michigan | 26069 | 4466 | 126 |
2165713 | 2165713 | 2022-01-30 | Iron | Michigan | 26071 | 2413 | 74 |
2165714 | 2165714 | 2022-01-30 | Isabella | Michigan | 26073 | 14517 | 182 |
2165715 | 2165715 | 2022-01-30 | Jackson | Michigan | 26075 | 42551 | 510 |
2165716 | 2165716 | 2022-01-30 | Kalamazoo | Michigan | 26077 | 54636 | 606 |
2165717 | 2165717 | 2022-01-30 | Kalkaska | Michigan | 26079 | 3207 | 48 |
2165718 | 2165718 | 2022-01-30 | Kent | Michigan | 26081 | 157169 | 1381 |
2165719 | 2165719 | 2022-01-30 | Keweenaw | Michigan | 26083 | 476 | 12 |
2165720 | 2165720 | 2022-01-30 | Lake | Michigan | 26085 | 1664 | 33 |
2165721 | 2165721 | 2022-01-30 | Lapeer | Michigan | 26087 | 19799 | 383 |
2165722 | 2165722 | 2022-01-30 | Leelanau | Michigan | 26089 | 3315 | 44 |
2165723 | 2165723 | 2022-01-30 | Lenawee | Michigan | 26091 | 24374 | 294 |
2165724 | 2165724 | 2022-01-30 | Livingston | Michigan | 26093 | 43640 | 403 |
2165725 | 2165725 | 2022-01-30 | Luce | Michigan | 26095 | 2179 | 8 |
2165726 | 2165726 | 2022-01-30 | Mackinac | Michigan | 26097 | 2224 | 26 |
2165727 | 2165727 | 2022-01-30 | Macomb | Michigan | 26099 | 214423 | 3557 |
2165728 | 2165728 | 2022-01-30 | Manistee | Michigan | 26101 | 4014 | 77 |
2165729 | 2165729 | 2022-01-30 | Marquette | Michigan | 26103 | 14657 | 107 |
2165730 | 2165730 | 2022-01-30 | Mason | Michigan | 26105 | 5979 | 78 |
2165731 | 2165731 | 2022-01-30 | Mecosta | Michigan | 26107 | 7932 | 91 |
2165732 | 2165732 | 2022-01-30 | Menominee | Michigan | 26109 | 5193 | 67 |
2165733 | 2165733 | 2022-01-30 | Midland | Michigan | 26111 | 17675 | 202 |
2165734 | 2165734 | 2022-01-30 | Missaukee | Michigan | 26113 | 2662 | 56 |
2165735 | 2165735 | 2022-01-30 | Monroe | Michigan | 26115 | 35968 | 419 |
2165736 | 2165736 | 2022-01-30 | Montcalm | Michigan | 26117 | 15944 | 192 |
2165737 | 2165737 | 2022-01-30 | Montmorency | Michigan | 26119 | 1594 | 45 |
2165738 | 2165738 | 2022-01-30 | Muskegon | Michigan | 26121 | 39337 | 577 |
2165739 | 2165739 | 2022-01-30 | Newaygo | Michigan | 26123 | 10583 | 141 |
2165740 | 2165740 | 2022-01-30 | Oakland | Michigan | 26125 | 267558 | 3460 |
2165741 | 2165741 | 2022-01-30 | Oceana | Michigan | 26127 | 5808 | 87 |
2165742 | 2165742 | 2022-01-30 | Ogemaw | Michigan | 26129 | 3994 | 88 |
2165743 | 2165743 | 2022-01-30 | Ontonagon | Michigan | 26131 | 921 | 34 |
2165744 | 2165744 | 2022-01-30 | Osceola | Michigan | 26133 | 4627 | 67 |
2165745 | 2165745 | 2022-01-30 | Oscoda | Michigan | 26135 | 1365 | 53 |
2165746 | 2165746 | 2022-01-30 | Otsego | Michigan | 26137 | 5172 | 90 |
2165747 | 2165747 | 2022-01-30 | Ottawa | Michigan | 26139 | 70237 | 722 |
2165748 | 2165748 | 2022-01-30 | Presque Isle | Michigan | 26141 | 1971 | 55 |
2165749 | 2165749 | 2022-01-30 | Roscommon | Michigan | 26143 | 4305 | 109 |
2165750 | 2165750 | 2022-01-30 | Saginaw | Michigan | 26145 | 47151 | 862 |
2165751 | 2165751 | 2022-01-30 | Sanilac | Michigan | 26151 | 8189 | 173 |
2165752 | 2165752 | 2022-01-30 | Schoolcraft | Michigan | 26153 | 1593 | 12 |
2165753 | 2165753 | 2022-01-30 | Shiawassee | Michigan | 26155 | 16609 | 211 |
2165754 | 2165754 | 2022-01-30 | St. Clair | Michigan | 26147 | 38608 | 754 |
2165755 | 2165755 | 2022-01-30 | St. Joseph | Michigan | 26149 | 12916 | 181 |
2165756 | 2165756 | 2022-01-30 | Tuscola | Michigan | 26157 | 12424 | 257 |
2165757 | 2165757 | 2022-01-30 | Unknown | Michigan | 8787 | 28 | |
2165758 | 2165758 | 2022-01-30 | Van Buren | Michigan | 26159 | 15999 | 242 |
2165759 | 2165759 | 2022-01-30 | Washtenaw | Michigan | 26161 | 68693 | 481 |
2165760 | 2165760 | 2022-01-30 | Wayne | Michigan | 26163 | 374385 | 7120 |
2165761 | 2165761 | 2022-01-30 | Wexford | Michigan | 26165 | 6318 | 95 |
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);