ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-12-21" 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 |
---|---|---|---|---|---|---|---|
2035607 | 2035607 | 2021-12-21 | Alcona | Michigan | 26001 | 1396 | 55 |
2035608 | 2035608 | 2021-12-21 | Alger | Michigan | 26003 | 1208 | 11 |
2035609 | 2035609 | 2021-12-21 | Allegan | Michigan | 26005 | 19758 | 261 |
2035610 | 2035610 | 2021-12-21 | Alpena | Michigan | 26007 | 4422 | 107 |
2035611 | 2035611 | 2021-12-21 | Antrim | Michigan | 26009 | 3093 | 50 |
2035612 | 2035612 | 2021-12-21 | Arenac | Michigan | 26011 | 2311 | 49 |
2035613 | 2035613 | 2021-12-21 | Baraga | Michigan | 26013 | 1636 | 48 |
2035614 | 2035614 | 2021-12-21 | Barry | Michigan | 26015 | 10452 | 124 |
2035615 | 2035615 | 2021-12-21 | Bay | Michigan | 26017 | 18752 | 461 |
2035616 | 2035616 | 2021-12-21 | Benzie | Michigan | 26019 | 2342 | 52 |
2035617 | 2035617 | 2021-12-21 | Berrien | Michigan | 26021 | 24425 | 374 |
2035618 | 2035618 | 2021-12-21 | Branch | Michigan | 26023 | 9219 | 157 |
2035619 | 2035619 | 2021-12-21 | Calhoun | Michigan | 26025 | 24199 | 446 |
2035620 | 2035620 | 2021-12-21 | Cass | Michigan | 26027 | 8800 | 108 |
2035621 | 2035621 | 2021-12-21 | Charlevoix | Michigan | 26029 | 3358 | 50 |
2035622 | 2035622 | 2021-12-21 | Cheboygan | Michigan | 26031 | 3556 | 79 |
2035623 | 2035623 | 2021-12-21 | Chippewa | Michigan | 26033 | 8044 | 79 |
2035624 | 2035624 | 2021-12-21 | Clare | Michigan | 26035 | 5025 | 127 |
2035625 | 2035625 | 2021-12-21 | Clinton | Michigan | 26037 | 13706 | 155 |
2035626 | 2035626 | 2021-12-21 | Crawford | Michigan | 26039 | 1903 | 20 |
2035627 | 2035627 | 2021-12-21 | Delta | Michigan | 26041 | 7008 | 131 |
2035628 | 2035628 | 2021-12-21 | Dickinson | Michigan | 26043 | 4983 | 92 |
2035629 | 2035629 | 2021-12-21 | Eaton | Michigan | 26045 | 17729 | 311 |
2035630 | 2035630 | 2021-12-21 | Emmet | Michigan | 26047 | 4441 | 58 |
2035631 | 2035631 | 2021-12-21 | Genesee | Michigan | 26049 | 69169 | 1283 |
2035632 | 2035632 | 2021-12-21 | Gladwin | Michigan | 26051 | 4013 | 91 |
2035633 | 2035633 | 2021-12-21 | Gogebic | Michigan | 26053 | 2288 | 62 |
2035634 | 2035634 | 2021-12-21 | Grand Traverse | Michigan | 26055 | 11927 | 171 |
2035635 | 2035635 | 2021-12-21 | Gratiot | Michigan | 26057 | 10681 | 160 |
2035636 | 2035636 | 2021-12-21 | Hillsdale | Michigan | 26059 | 8101 | 166 |
2035637 | 2035637 | 2021-12-21 | Houghton | Michigan | 26061 | 5582 | 66 |
2035638 | 2035638 | 2021-12-21 | Huron | Michigan | 26063 | 6180 | 120 |
2035639 | 2035639 | 2021-12-21 | Ingham | Michigan | 26065 | 40252 | 559 |
2035640 | 2035640 | 2021-12-21 | Ionia | Michigan | 26067 | 14884 | 140 |
2035641 | 2035641 | 2021-12-21 | Iosco | Michigan | 26069 | 3747 | 112 |
2035642 | 2035642 | 2021-12-21 | Iron | Michigan | 26071 | 1836 | 70 |
2035643 | 2035643 | 2021-12-21 | Isabella | Michigan | 26073 | 11093 | 156 |
2035644 | 2035644 | 2021-12-21 | Jackson | Michigan | 26075 | 33262 | 444 |
2035645 | 2035645 | 2021-12-21 | Kalamazoo | Michigan | 26077 | 38182 | 525 |
2035646 | 2035646 | 2021-12-21 | Kalkaska | Michigan | 26079 | 2421 | 46 |
2035647 | 2035647 | 2021-12-21 | Kent | Michigan | 26081 | 118505 | 1203 |
2035648 | 2035648 | 2021-12-21 | Keweenaw | Michigan | 26083 | 387 | 11 |
2035649 | 2035649 | 2021-12-21 | Lake | Michigan | 26085 | 1360 | 30 |
2035650 | 2035650 | 2021-12-21 | Lapeer | Michigan | 26087 | 15641 | 318 |
2035651 | 2035651 | 2021-12-21 | Leelanau | Michigan | 26089 | 2417 | 41 |
2035652 | 2035652 | 2021-12-21 | Lenawee | Michigan | 26091 | 18674 | 247 |
2035653 | 2035653 | 2021-12-21 | Livingston | Michigan | 26093 | 31857 | 340 |
2035654 | 2035654 | 2021-12-21 | Luce | Michigan | 26095 | 1847 | 6 |
2035655 | 2035655 | 2021-12-21 | Mackinac | Michigan | 26097 | 1652 | 18 |
2035656 | 2035656 | 2021-12-21 | Macomb | Michigan | 26099 | 156275 | 3100 |
2035657 | 2035657 | 2021-12-21 | Manistee | Michigan | 26101 | 3210 | 57 |
2035658 | 2035658 | 2021-12-21 | Marquette | Michigan | 26103 | 9745 | 95 |
2035659 | 2035659 | 2021-12-21 | Mason | Michigan | 26105 | 4657 | 64 |
2035660 | 2035660 | 2021-12-21 | Mecosta | Michigan | 26107 | 6234 | 80 |
2035661 | 2035661 | 2021-12-21 | Menominee | Michigan | 26109 | 4131 | 60 |
2035662 | 2035662 | 2021-12-21 | Midland | Michigan | 26111 | 13156 | 176 |
2035663 | 2035663 | 2021-12-21 | Missaukee | Michigan | 26113 | 2202 | 45 |
2035664 | 2035664 | 2021-12-21 | Monroe | Michigan | 26115 | 26188 | 360 |
2035665 | 2035665 | 2021-12-21 | Montcalm | Michigan | 26117 | 13507 | 164 |
2035666 | 2035666 | 2021-12-21 | Montmorency | Michigan | 26119 | 1328 | 39 |
2035667 | 2035667 | 2021-12-21 | Muskegon | Michigan | 26121 | 30722 | 505 |
2035668 | 2035668 | 2021-12-21 | Newaygo | Michigan | 26123 | 8611 | 124 |
2035669 | 2035669 | 2021-12-21 | Oakland | Michigan | 26125 | 186800 | 3005 |
2035670 | 2035670 | 2021-12-21 | Oceana | Michigan | 26127 | 4854 | 82 |
2035671 | 2035671 | 2021-12-21 | Ogemaw | Michigan | 26129 | 3268 | 80 |
2035672 | 2035672 | 2021-12-21 | Ontonagon | Michigan | 26131 | 732 | 26 |
2035673 | 2035673 | 2021-12-21 | Osceola | Michigan | 26133 | 3828 | 55 |
2035674 | 2035674 | 2021-12-21 | Oscoda | Michigan | 26135 | 1157 | 49 |
2035675 | 2035675 | 2021-12-21 | Otsego | Michigan | 26137 | 4252 | 77 |
2035676 | 2035676 | 2021-12-21 | Ottawa | Michigan | 26139 | 54051 | 622 |
2035677 | 2035677 | 2021-12-21 | Presque Isle | Michigan | 26141 | 1716 | 50 |
2035678 | 2035678 | 2021-12-21 | Roscommon | Michigan | 26143 | 3567 | 98 |
2035679 | 2035679 | 2021-12-21 | Saginaw | Michigan | 26145 | 35998 | 766 |
2035680 | 2035680 | 2021-12-21 | Sanilac | Michigan | 26151 | 6625 | 160 |
2035681 | 2035681 | 2021-12-21 | Schoolcraft | Michigan | 26153 | 1172 | 7 |
2035682 | 2035682 | 2021-12-21 | Shiawassee | Michigan | 26155 | 12337 | 174 |
2035683 | 2035683 | 2021-12-21 | St. Clair | Michigan | 26147 | 29481 | 619 |
2035684 | 2035684 | 2021-12-21 | St. Joseph | Michigan | 26149 | 10650 | 152 |
2035685 | 2035685 | 2021-12-21 | Tuscola | Michigan | 26157 | 9771 | 231 |
2035686 | 2035686 | 2021-12-21 | Unknown | Michigan | 2279 | 24 | |
2035687 | 2035687 | 2021-12-21 | Van Buren | Michigan | 26159 | 12335 | 195 |
2035688 | 2035688 | 2021-12-21 | Washtenaw | Michigan | 26161 | 43561 | 389 |
2035689 | 2035689 | 2021-12-21 | Wayne | Michigan | 26163 | 255186 | 6264 |
2035690 | 2035690 | 2021-12-21 | Wexford | Michigan | 26165 | 4961 | 83 |
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);