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-04-03 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370579 | 2370579 | 2022-04-03 | Alcona | Michigan | 26001 | 1725 | 71 |
2370580 | 2370580 | 2022-04-03 | Alger | Michigan | 26003 | 1866 | 13 |
2370581 | 2370581 | 2022-04-03 | Allegan | Michigan | 26005 | 27030 | 342 |
2370582 | 2370582 | 2022-04-03 | Alpena | Michigan | 26007 | 5585 | 136 |
2370583 | 2370583 | 2022-04-03 | Antrim | Michigan | 26009 | 4309 | 64 |
2370584 | 2370584 | 2022-04-03 | Arenac | Michigan | 26011 | 3195 | 67 |
2370585 | 2370585 | 2022-04-03 | Baraga | Michigan | 26013 | 2208 | 54 |
2370586 | 2370586 | 2022-04-03 | Barry | Michigan | 26015 | 14297 | 166 |
2370587 | 2370587 | 2022-04-03 | Bay | Michigan | 26017 | 26986 | 577 |
2370588 | 2370588 | 2022-04-03 | Benzie | Michigan | 26019 | 3422 | 65 |
2370589 | 2370589 | 2022-04-03 | Berrien | Michigan | 26021 | 34640 | 548 |
2370590 | 2370590 | 2022-04-03 | Branch | Michigan | 26023 | 12153 | 205 |
2370591 | 2370591 | 2022-04-03 | Calhoun | Michigan | 26025 | 34100 | 574 |
2370592 | 2370592 | 2022-04-03 | Cass | Michigan | 26027 | 11085 | 143 |
2370593 | 2370593 | 2022-04-03 | Charlevoix | Michigan | 26029 | 4909 | 60 |
2370594 | 2370594 | 2022-04-03 | Cheboygan | Michigan | 26031 | 4583 | 102 |
2370595 | 2370595 | 2022-04-03 | Chippewa | Michigan | 26033 | 11598 | 119 |
2370596 | 2370596 | 2022-04-03 | Clare | Michigan | 26035 | 6737 | 156 |
2370597 | 2370597 | 2022-04-03 | Clinton | Michigan | 26037 | 21202 | 209 |
2370598 | 2370598 | 2022-04-03 | Crawford | Michigan | 26039 | 2555 | 30 |
2370599 | 2370599 | 2022-04-03 | Delta | Michigan | 26041 | 9917 | 155 |
2370600 | 2370600 | 2022-04-03 | Dickinson | Michigan | 26043 | 7362 | 108 |
2370601 | 2370601 | 2022-04-03 | Eaton | Michigan | 26045 | 26735 | 394 |
2370602 | 2370602 | 2022-04-03 | Emmet | Michigan | 26047 | 6366 | 86 |
2370603 | 2370603 | 2022-04-03 | Genesee | Michigan | 26049 | 101110 | 1704 |
2370604 | 2370604 | 2022-04-03 | Gladwin | Michigan | 26051 | 5561 | 113 |
2370605 | 2370605 | 2022-04-03 | Gogebic | Michigan | 26053 | 3251 | 69 |
2370606 | 2370606 | 2022-04-03 | Grand Traverse | Michigan | 26055 | 17194 | 228 |
2370607 | 2370607 | 2022-04-03 | Gratiot | Michigan | 26057 | 13662 | 185 |
2370608 | 2370608 | 2022-04-03 | Hillsdale | Michigan | 26059 | 10328 | 204 |
2370609 | 2370609 | 2022-04-03 | Houghton | Michigan | 26061 | 7792 | 90 |
2370610 | 2370610 | 2022-04-03 | Huron | Michigan | 26063 | 8007 | 145 |
2370611 | 2370611 | 2022-04-03 | Ingham | Michigan | 26065 | 63884 | 757 |
2370612 | 2370612 | 2022-04-03 | Ionia | Michigan | 26067 | 19517 | 181 |
2370613 | 2370613 | 2022-04-03 | Iosco | Michigan | 26069 | 4798 | 140 |
2370614 | 2370614 | 2022-04-03 | Iron | Michigan | 26071 | 2644 | 87 |
2370615 | 2370615 | 2022-04-03 | Isabella | Michigan | 26073 | 15518 | 207 |
2370616 | 2370616 | 2022-04-03 | Jackson | Michigan | 26075 | 44521 | 580 |
2370617 | 2370617 | 2022-04-03 | Kalamazoo | Michigan | 26077 | 59010 | 669 |
2370618 | 2370618 | 2022-04-03 | Kalkaska | Michigan | 26079 | 3523 | 60 |
2370619 | 2370619 | 2022-04-03 | Kent | Michigan | 26081 | 166282 | 1513 |
2370620 | 2370620 | 2022-04-03 | Keweenaw | Michigan | 26083 | 512 | 13 |
2370621 | 2370621 | 2022-04-03 | Lake | Michigan | 26085 | 1839 | 37 |
2370622 | 2370622 | 2022-04-03 | Lapeer | Michigan | 26087 | 20768 | 426 |
2370623 | 2370623 | 2022-04-03 | Leelanau | Michigan | 26089 | 3577 | 53 |
2370624 | 2370624 | 2022-04-03 | Lenawee | Michigan | 26091 | 25900 | 328 |
2370625 | 2370625 | 2022-04-03 | Livingston | Michigan | 26093 | 46001 | 442 |
2370626 | 2370626 | 2022-04-03 | Luce | Michigan | 26095 | 2281 | 12 |
2370627 | 2370627 | 2022-04-03 | Mackinac | Michigan | 26097 | 2400 | 30 |
2370628 | 2370628 | 2022-04-03 | Macomb | Michigan | 26099 | 229451 | 3935 |
2370629 | 2370629 | 2022-04-03 | Manistee | Michigan | 26101 | 4458 | 89 |
2370630 | 2370630 | 2022-04-03 | Marquette | Michigan | 26103 | 15793 | 128 |
2370631 | 2370631 | 2022-04-03 | Mason | Michigan | 26105 | 6725 | 91 |
2370632 | 2370632 | 2022-04-03 | Mecosta | Michigan | 26107 | 8637 | 108 |
2370633 | 2370633 | 2022-04-03 | Menominee | Michigan | 26109 | 5622 | 70 |
2370634 | 2370634 | 2022-04-03 | Midland | Michigan | 26111 | 19016 | 223 |
2370635 | 2370635 | 2022-04-03 | Missaukee | Michigan | 26113 | 2903 | 59 |
2370636 | 2370636 | 2022-04-03 | Monroe | Michigan | 26115 | 37916 | 468 |
2370637 | 2370637 | 2022-04-03 | Montcalm | Michigan | 26117 | 17129 | 215 |
2370638 | 2370638 | 2022-04-03 | Montmorency | Michigan | 26119 | 1716 | 46 |
2370639 | 2370639 | 2022-04-03 | Muskegon | Michigan | 26121 | 41677 | 644 |
2370640 | 2370640 | 2022-04-03 | Newaygo | Michigan | 26123 | 11462 | 155 |
2370641 | 2370641 | 2022-04-03 | Oakland | Michigan | 26125 | 285720 | 3805 |
2370642 | 2370642 | 2022-04-03 | Oceana | Michigan | 26127 | 6327 | 89 |
2370643 | 2370643 | 2022-04-03 | Ogemaw | Michigan | 26129 | 4303 | 105 |
2370644 | 2370644 | 2022-04-03 | Ontonagon | Michigan | 26131 | 983 | 38 |
2370645 | 2370645 | 2022-04-03 | Osceola | Michigan | 26133 | 4989 | 80 |
2370646 | 2370646 | 2022-04-03 | Oscoda | Michigan | 26135 | 1433 | 55 |
2370647 | 2370647 | 2022-04-03 | Otsego | Michigan | 26137 | 5627 | 99 |
2370648 | 2370648 | 2022-04-03 | Ottawa | Michigan | 26139 | 74641 | 784 |
2370649 | 2370649 | 2022-04-03 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2370650 | 2370650 | 2022-04-03 | Roscommon | Michigan | 26143 | 4611 | 113 |
2370651 | 2370651 | 2022-04-03 | Saginaw | Michigan | 26145 | 50290 | 944 |
2370652 | 2370652 | 2022-04-03 | Sanilac | Michigan | 26151 | 8659 | 189 |
2370653 | 2370653 | 2022-04-03 | Schoolcraft | Michigan | 26153 | 1750 | 17 |
2370654 | 2370654 | 2022-04-03 | Shiawassee | Michigan | 26155 | 17753 | 230 |
2370655 | 2370655 | 2022-04-03 | St. Clair | Michigan | 26147 | 40545 | 825 |
2370656 | 2370656 | 2022-04-03 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2370657 | 2370657 | 2022-04-03 | Tuscola | Michigan | 26157 | 13190 | 275 |
2370658 | 2370658 | 2022-04-03 | Unknown | Michigan | 11517 | 37 | |
2370659 | 2370659 | 2022-04-03 | Van Buren | Michigan | 26159 | 16982 | 266 |
2370660 | 2370660 | 2022-04-03 | Washtenaw | Michigan | 26161 | 75375 | 513 |
2370661 | 2370661 | 2022-04-03 | Wayne | Michigan | 26163 | 398775 | 7887 |
2370662 | 2370662 | 2022-04-03 | Wexford | Michigan | 26165 | 7060 | 106 |
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);