ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-19" 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 |
---|---|---|---|---|---|---|---|
1931588 | 1931588 | 2021-11-19 | Alcona | Michigan | 26001 | 1264 | 47 |
1931589 | 1931589 | 2021-11-19 | Alger | Michigan | 26003 | 1091 | 9 |
1931590 | 1931590 | 2021-11-19 | Allegan | Michigan | 26005 | 17036 | 212 |
1931591 | 1931591 | 2021-11-19 | Alpena | Michigan | 26007 | 3814 | 81 |
1931592 | 1931592 | 2021-11-19 | Antrim | Michigan | 26009 | 2725 | 41 |
1931593 | 1931593 | 2021-11-19 | Arenac | Michigan | 26011 | 2025 | 41 |
1931594 | 1931594 | 2021-11-19 | Baraga | Michigan | 26013 | 1521 | 47 |
1931595 | 1931595 | 2021-11-19 | Barry | Michigan | 26015 | 9113 | 99 |
1931596 | 1931596 | 2021-11-19 | Bay | Michigan | 26017 | 16543 | 415 |
1931597 | 1931597 | 2021-11-19 | Benzie | Michigan | 26019 | 1961 | 44 |
1931598 | 1931598 | 2021-11-19 | Berrien | Michigan | 26021 | 20896 | 341 |
1931599 | 1931599 | 2021-11-19 | Branch | Michigan | 26023 | 8140 | 141 |
1931600 | 1931600 | 2021-11-19 | Calhoun | Michigan | 26025 | 20812 | 372 |
1931601 | 1931601 | 2021-11-19 | Cass | Michigan | 26027 | 7737 | 97 |
1931602 | 1931602 | 2021-11-19 | Charlevoix | Michigan | 26029 | 2886 | 42 |
1931603 | 1931603 | 2021-11-19 | Cheboygan | Michigan | 26031 | 3183 | 71 |
1931604 | 1931604 | 2021-11-19 | Chippewa | Michigan | 26033 | 7436 | 69 |
1931605 | 1931605 | 2021-11-19 | Clare | Michigan | 26035 | 4341 | 113 |
1931606 | 1931606 | 2021-11-19 | Clinton | Michigan | 26037 | 11641 | 126 |
1931607 | 1931607 | 2021-11-19 | Crawford | Michigan | 26039 | 1620 | 17 |
1931608 | 1931608 | 2021-11-19 | Delta | Michigan | 26041 | 6386 | 115 |
1931609 | 1931609 | 2021-11-19 | Dickinson | Michigan | 26043 | 4414 | 85 |
1931610 | 1931610 | 2021-11-19 | Eaton | Michigan | 26045 | 15227 | 264 |
1931611 | 1931611 | 2021-11-19 | Emmet | Michigan | 26047 | 3793 | 55 |
1931612 | 1931612 | 2021-11-19 | Genesee | Michigan | 26049 | 58231 | 1148 |
1931613 | 1931613 | 2021-11-19 | Gladwin | Michigan | 26051 | 3612 | 80 |
1931614 | 1931614 | 2021-11-19 | Gogebic | Michigan | 26053 | 1988 | 55 |
1931615 | 1931615 | 2021-11-19 | Grand Traverse | Michigan | 26055 | 10301 | 124 |
1931616 | 1931616 | 2021-11-19 | Gratiot | Michigan | 26057 | 9596 | 141 |
1931617 | 1931617 | 2021-11-19 | Hillsdale | Michigan | 26059 | 6984 | 140 |
1931618 | 1931618 | 2021-11-19 | Houghton | Michigan | 26061 | 4940 | 59 |
1931619 | 1931619 | 2021-11-19 | Huron | Michigan | 26063 | 5450 | 100 |
1931620 | 1931620 | 2021-11-19 | Ingham | Michigan | 26065 | 34852 | 487 |
1931621 | 1931621 | 2021-11-19 | Ionia | Michigan | 26067 | 13147 | 114 |
1931622 | 1931622 | 2021-11-19 | Iosco | Michigan | 26069 | 3385 | 103 |
1931623 | 1931623 | 2021-11-19 | Iron | Michigan | 26071 | 1623 | 62 |
1931624 | 1931624 | 2021-11-19 | Isabella | Michigan | 26073 | 10032 | 138 |
1931625 | 1931625 | 2021-11-19 | Jackson | Michigan | 26075 | 29583 | 393 |
1931626 | 1931626 | 2021-11-19 | Kalamazoo | Michigan | 26077 | 33154 | 479 |
1931627 | 1931627 | 2021-11-19 | Kalkaska | Michigan | 26079 | 2021 | 40 |
1931628 | 1931628 | 2021-11-19 | Kent | Michigan | 26081 | 104456 | 1050 |
1931629 | 1931629 | 2021-11-19 | Keweenaw | Michigan | 26083 | 334 | 7 |
1931630 | 1931630 | 2021-11-19 | Lake | Michigan | 26085 | 1120 | 24 |
1931631 | 1931631 | 2021-11-19 | Lapeer | Michigan | 26087 | 13381 | 268 |
1931632 | 1931632 | 2021-11-19 | Leelanau | Michigan | 26089 | 1956 | 29 |
1931633 | 1931633 | 2021-11-19 | Lenawee | Michigan | 26091 | 16606 | 218 |
1931634 | 1931634 | 2021-11-19 | Livingston | Michigan | 26093 | 26875 | 268 |
1931635 | 1931635 | 2021-11-19 | Luce | Michigan | 26095 | 1677 | 6 |
1931636 | 1931636 | 2021-11-19 | Mackinac | Michigan | 26097 | 1426 | 14 |
1931637 | 1931637 | 2021-11-19 | Macomb | Michigan | 26099 | 133940 | 2814 |
1931638 | 1931638 | 2021-11-19 | Manistee | Michigan | 26101 | 2816 | 44 |
1931639 | 1931639 | 2021-11-19 | Marquette | Michigan | 26103 | 8777 | 88 |
1931640 | 1931640 | 2021-11-19 | Mason | Michigan | 26105 | 3850 | 54 |
1931641 | 1931641 | 2021-11-19 | Mecosta | Michigan | 26107 | 5443 | 56 |
1931642 | 1931642 | 2021-11-19 | Menominee | Michigan | 26109 | 3725 | 52 |
1931643 | 1931643 | 2021-11-19 | Midland | Michigan | 26111 | 11539 | 154 |
1931644 | 1931644 | 2021-11-19 | Missaukee | Michigan | 26113 | 2012 | 41 |
1931645 | 1931645 | 2021-11-19 | Monroe | Michigan | 26115 | 22881 | 321 |
1931646 | 1931646 | 2021-11-19 | Montcalm | Michigan | 26117 | 12026 | 144 |
1931647 | 1931647 | 2021-11-19 | Montmorency | Michigan | 26119 | 1192 | 33 |
1931648 | 1931648 | 2021-11-19 | Muskegon | Michigan | 26121 | 26649 | 442 |
1931649 | 1931649 | 2021-11-19 | Newaygo | Michigan | 26123 | 7438 | 90 |
1931650 | 1931650 | 2021-11-19 | Oakland | Michigan | 26125 | 160301 | 2761 |
1931651 | 1931651 | 2021-11-19 | Oceana | Michigan | 26127 | 4187 | 72 |
1931652 | 1931652 | 2021-11-19 | Ogemaw | Michigan | 26129 | 2930 | 68 |
1931653 | 1931653 | 2021-11-19 | Ontonagon | Michigan | 26131 | 680 | 23 |
1931654 | 1931654 | 2021-11-19 | Osceola | Michigan | 26133 | 3429 | 47 |
1931655 | 1931655 | 2021-11-19 | Oscoda | Michigan | 26135 | 1063 | 41 |
1931656 | 1931656 | 2021-11-19 | Otsego | Michigan | 26137 | 3784 | 65 |
1931657 | 1931657 | 2021-11-19 | Ottawa | Michigan | 26139 | 46980 | 544 |
1931658 | 1931658 | 2021-11-19 | Presque Isle | Michigan | 26141 | 1562 | 43 |
1931659 | 1931659 | 2021-11-19 | Roscommon | Michigan | 26143 | 3050 | 75 |
1931660 | 1931660 | 2021-11-19 | Saginaw | Michigan | 26145 | 31523 | 702 |
1931661 | 1931661 | 2021-11-19 | Sanilac | Michigan | 26151 | 5676 | 145 |
1931662 | 1931662 | 2021-11-19 | Schoolcraft | Michigan | 26153 | 960 | 6 |
1931663 | 1931663 | 2021-11-19 | Shiawassee | Michigan | 26155 | 10280 | 142 |
1931664 | 1931664 | 2021-11-19 | St. Clair | Michigan | 26147 | 24887 | 541 |
1931665 | 1931665 | 2021-11-19 | St. Joseph | Michigan | 26149 | 9422 | 128 |
1931666 | 1931666 | 2021-11-19 | Tuscola | Michigan | 26157 | 8352 | 213 |
1931667 | 1931667 | 2021-11-19 | Unknown | Michigan | 1822 | 17 | |
1931668 | 1931668 | 2021-11-19 | Van Buren | Michigan | 26159 | 10431 | 176 |
1931669 | 1931669 | 2021-11-19 | Washtenaw | Michigan | 26161 | 37467 | 345 |
1931670 | 1931670 | 2021-11-19 | Wayne | Michigan | 26163 | 218136 | 5774 |
1931671 | 1931671 | 2021-11-19 | Wexford | Michigan | 26165 | 4265 | 62 |
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);