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-18 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126632 | 2126632 | 2022-01-18 | Alcona | Michigan | 26001 | 1516 | 60 |
2126633 | 2126633 | 2022-01-18 | Alger | Michigan | 26003 | 1490 | 11 |
2126634 | 2126634 | 2022-01-18 | Allegan | Michigan | 26005 | 22475 | 293 |
2126635 | 2126635 | 2022-01-18 | Alpena | Michigan | 26007 | 4797 | 120 |
2126636 | 2126636 | 2022-01-18 | Antrim | Michigan | 26009 | 3677 | 52 |
2126637 | 2126637 | 2022-01-18 | Arenac | Michigan | 26011 | 2611 | 56 |
2126638 | 2126638 | 2022-01-18 | Baraga | Michigan | 26013 | 1861 | 50 |
2126639 | 2126639 | 2022-01-18 | Barry | Michigan | 26015 | 11798 | 138 |
2126640 | 2126640 | 2022-01-18 | Bay | Michigan | 26017 | 21690 | 510 |
2126641 | 2126641 | 2022-01-18 | Benzie | Michigan | 26019 | 2719 | 57 |
2126642 | 2126642 | 2022-01-18 | Berrien | Michigan | 26021 | 29149 | 432 |
2126643 | 2126643 | 2022-01-18 | Branch | Michigan | 26023 | 10063 | 174 |
2126644 | 2126644 | 2022-01-18 | Calhoun | Michigan | 26025 | 27744 | 496 |
2126645 | 2126645 | 2022-01-18 | Cass | Michigan | 26027 | 9779 | 117 |
2126646 | 2126646 | 2022-01-18 | Charlevoix | Michigan | 26029 | 4279 | 54 |
2126647 | 2126647 | 2022-01-18 | Cheboygan | Michigan | 26031 | 3994 | 85 |
2126648 | 2126648 | 2022-01-18 | Chippewa | Michigan | 26033 | 9385 | 90 |
2126649 | 2126649 | 2022-01-18 | Clare | Michigan | 26035 | 5535 | 143 |
2126650 | 2126650 | 2022-01-18 | Clinton | Michigan | 26037 | 16252 | 175 |
2126651 | 2126651 | 2022-01-18 | Crawford | Michigan | 26039 | 2090 | 23 |
2126652 | 2126652 | 2022-01-18 | Delta | Michigan | 26041 | 8014 | 139 |
2126653 | 2126653 | 2022-01-18 | Dickinson | Michigan | 26043 | 5843 | 95 |
2126654 | 2126654 | 2022-01-18 | Eaton | Michigan | 26045 | 21271 | 336 |
2126655 | 2126655 | 2022-01-18 | Emmet | Michigan | 26047 | 5499 | 65 |
2126656 | 2126656 | 2022-01-18 | Genesee | Michigan | 26049 | 84530 | 1446 |
2126657 | 2126657 | 2022-01-18 | Gladwin | Michigan | 26051 | 4619 | 102 |
2126658 | 2126658 | 2022-01-18 | Gogebic | Michigan | 26053 | 2640 | 63 |
2126659 | 2126659 | 2022-01-18 | Grand Traverse | Michigan | 26055 | 13847 | 190 |
2126660 | 2126660 | 2022-01-18 | Gratiot | Michigan | 26057 | 11485 | 169 |
2126661 | 2126661 | 2022-01-18 | Hillsdale | Michigan | 26059 | 8692 | 178 |
2126662 | 2126662 | 2022-01-18 | Houghton | Michigan | 26061 | 6392 | 77 |
2126663 | 2126663 | 2022-01-18 | Huron | Michigan | 26063 | 6779 | 130 |
2126664 | 2126664 | 2022-01-18 | Ingham | Michigan | 26065 | 50641 | 625 |
2126665 | 2126665 | 2022-01-18 | Ionia | Michigan | 26067 | 16366 | 153 |
2126666 | 2126666 | 2022-01-18 | Iosco | Michigan | 26069 | 4122 | 119 |
2126667 | 2126667 | 2022-01-18 | Iron | Michigan | 26071 | 2062 | 74 |
2126668 | 2126668 | 2022-01-18 | Isabella | Michigan | 26073 | 12795 | 174 |
2126669 | 2126669 | 2022-01-18 | Jackson | Michigan | 26075 | 37980 | 493 |
2126670 | 2126670 | 2022-01-18 | Kalamazoo | Michigan | 26077 | 47998 | 573 |
2126671 | 2126671 | 2022-01-18 | Kalkaska | Michigan | 26079 | 2793 | 48 |
2126672 | 2126672 | 2022-01-18 | Kent | Michigan | 26081 | 140589 | 1331 |
2126673 | 2126673 | 2022-01-18 | Keweenaw | Michigan | 26083 | 419 | 11 |
2126674 | 2126674 | 2022-01-18 | Lake | Michigan | 26085 | 1492 | 32 |
2126675 | 2126675 | 2022-01-18 | Lapeer | Michigan | 26087 | 17830 | 365 |
2126676 | 2126676 | 2022-01-18 | Leelanau | Michigan | 26089 | 2890 | 43 |
2126677 | 2126677 | 2022-01-18 | Lenawee | Michigan | 26091 | 21593 | 272 |
2126678 | 2126678 | 2022-01-18 | Livingston | Michigan | 26093 | 38344 | 380 |
2126679 | 2126679 | 2022-01-18 | Luce | Michigan | 26095 | 2007 | 6 |
2126680 | 2126680 | 2022-01-18 | Mackinac | Michigan | 26097 | 1936 | 25 |
2126681 | 2126681 | 2022-01-18 | Macomb | Michigan | 26099 | 193931 | 3398 |
2126682 | 2126682 | 2022-01-18 | Manistee | Michigan | 26101 | 3580 | 68 |
2126683 | 2126683 | 2022-01-18 | Marquette | Michigan | 26103 | 12192 | 101 |
2126684 | 2126684 | 2022-01-18 | Mason | Michigan | 26105 | 5210 | 74 |
2126685 | 2126685 | 2022-01-18 | Mecosta | Michigan | 26107 | 6966 | 88 |
2126686 | 2126686 | 2022-01-18 | Menominee | Michigan | 26109 | 4613 | 64 |
2126687 | 2126687 | 2022-01-18 | Midland | Michigan | 26111 | 15334 | 195 |
2126688 | 2126688 | 2022-01-18 | Missaukee | Michigan | 26113 | 2376 | 54 |
2126689 | 2126689 | 2022-01-18 | Monroe | Michigan | 26115 | 32120 | 394 |
2126690 | 2126690 | 2022-01-18 | Montcalm | Michigan | 26117 | 14593 | 183 |
2126691 | 2126691 | 2022-01-18 | Montmorency | Michigan | 26119 | 1443 | 43 |
2126692 | 2126692 | 2022-01-18 | Muskegon | Michigan | 26121 | 35535 | 547 |
2126693 | 2126693 | 2022-01-18 | Newaygo | Michigan | 26123 | 9479 | 133 |
2126694 | 2126694 | 2022-01-18 | Oakland | Michigan | 26125 | 237946 | 3295 |
2126695 | 2126695 | 2022-01-18 | Oceana | Michigan | 26127 | 5267 | 84 |
2126696 | 2126696 | 2022-01-18 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2126697 | 2126697 | 2022-01-18 | Ontonagon | Michigan | 26131 | 852 | 30 |
2126698 | 2126698 | 2022-01-18 | Osceola | Michigan | 26133 | 4167 | 67 |
2126699 | 2126699 | 2022-01-18 | Oscoda | Michigan | 26135 | 1237 | 51 |
2126700 | 2126700 | 2022-01-18 | Otsego | Michigan | 26137 | 4835 | 88 |
2126701 | 2126701 | 2022-01-18 | Ottawa | Michigan | 26139 | 62279 | 689 |
2126702 | 2126702 | 2022-01-18 | Presque Isle | Michigan | 26141 | 1836 | 52 |
2126703 | 2126703 | 2022-01-18 | Roscommon | Michigan | 26143 | 3896 | 108 |
2126704 | 2126704 | 2022-01-18 | Saginaw | Michigan | 26145 | 41528 | 834 |
2126705 | 2126705 | 2022-01-18 | Sanilac | Michigan | 26151 | 7409 | 170 |
2126706 | 2126706 | 2022-01-18 | Schoolcraft | Michigan | 26153 | 1393 | 9 |
2126707 | 2126707 | 2022-01-18 | Shiawassee | Michigan | 26155 | 14447 | 199 |
2126708 | 2126708 | 2022-01-18 | St. Clair | Michigan | 26147 | 35924 | 716 |
2126709 | 2126709 | 2022-01-18 | St. Joseph | Michigan | 26149 | 11628 | 172 |
2126710 | 2126710 | 2022-01-18 | Tuscola | Michigan | 26157 | 10959 | 251 |
2126711 | 2126711 | 2022-01-18 | Unknown | Michigan | 0 | 25 | |
2126712 | 2126712 | 2022-01-18 | Van Buren | Michigan | 26159 | 14258 | 230 |
2126713 | 2126713 | 2022-01-18 | Washtenaw | Michigan | 26161 | 62467 | 444 |
2126714 | 2126714 | 2022-01-18 | Wayne | Michigan | 26163 | 336018 | 6793 |
2126715 | 2126715 | 2022-01-18 | Wexford | Michigan | 26165 | 5413 | 90 |
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);