ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65,202 rows where state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 84
- 26125 795
- 26163 795
- 26065 793
- 26081 793
- 26117 793
- 26147 793
- 26161 793
- 26017 792
- 26029 792
- 26089 792
- 26099 792
- 26115 791
- 26139 790
- 26075 788
- 26137 788
- 26037 786
- 26045 786
- 26049 786
- 26093 786
- 26111 786
- 26005 784
- 26015 784
- 26021 784
- 26025 784
- 26035 784
- 26145 784
- 26157 784
- 26165 784
- 26047 783
- 26051 783
- 26055 783
- 26143 783
- 26033 782
- 26077 782
- 26121 782
- 26123 782
- 26059 781
- 26073 781
- 26079 781
- 26087 781
- 26101 781
- 26069 780
- 26091 780
- 26103 780
- 26151 780
- 26159 780
- 26053 779
- 26067 779
- 26107 779
- 26113 779
- 26127 779
- 26129 779
- 26155 779
- 26027 778
- 26039 778
- 26057 778
- 26063 778
- - 778
- 26133 777
- 26031 776
- 26009 775
- 26041 775
- 26061 775
- 26149 775
- 26011 774
- 26023 774
- 26135 774
- 26097 773
- 26043 772
- 26095 771
- 26141 768
- 26105 767
- 26153 766
- 26109 764
- 26007 763
- 26085 763
- 26119 761
- 26001 759
- 26013 758
- 26019 756
- 26071 711
- 26003 703
- 26083 703
- 26131 679
county 84
- Oakland 795
- Wayne 795
- Ingham 793
- Kent 793
- Montcalm 793
- St. Clair 793
- Washtenaw 793
- Bay 792
- Charlevoix 792
- Leelanau 792
- Macomb 792
- Monroe 791
- Ottawa 790
- Jackson 788
- Otsego 788
- Clinton 786
- Eaton 786
- Genesee 786
- Livingston 786
- Midland 786
- Allegan 784
- Barry 784
- Berrien 784
- Calhoun 784
- Clare 784
- Saginaw 784
- Tuscola 784
- Wexford 784
- Emmet 783
- Gladwin 783
- Grand Traverse 783
- Roscommon 783
- Chippewa 782
- Kalamazoo 782
- Muskegon 782
- Newaygo 782
- Hillsdale 781
- Isabella 781
- Kalkaska 781
- Lapeer 781
- Manistee 781
- Iosco 780
- Lenawee 780
- Marquette 780
- Sanilac 780
- Van Buren 780
- Gogebic 779
- Ionia 779
- Mecosta 779
- Missaukee 779
- Oceana 779
- Ogemaw 779
- Shiawassee 779
- Cass 778
- Crawford 778
- Gratiot 778
- Huron 778
- Unknown 778
- Osceola 777
- Cheboygan 776
- Antrim 775
- Delta 775
- Houghton 775
- St. Joseph 775
- Arenac 774
- Branch 774
- Oscoda 774
- Mackinac 773
- Dickinson 772
- Luce 771
- Presque Isle 768
- Mason 767
- Schoolcraft 766
- Menominee 764
- Alpena 763
- Lake 763
- Montmorency 761
- Alcona 759
- Baraga 758
- Benzie 756
- Iron 711
- Alger 703
- Keweenaw 703
- Ontonagon 679
state 1
- Michigan · 65,202 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500821 | 2500821 | 2022-05-13 | Alcona | Michigan | 26001 | 1745 | 71 |
2500822 | 2500822 | 2022-05-13 | Alger | Michigan | 26003 | 1880 | 13 |
2500823 | 2500823 | 2022-05-13 | Allegan | Michigan | 26005 | 27448 | 348 |
2500824 | 2500824 | 2022-05-13 | Alpena | Michigan | 26007 | 5809 | 139 |
2500825 | 2500825 | 2022-05-13 | Antrim | Michigan | 26009 | 4470 | 66 |
2500826 | 2500826 | 2022-05-13 | Arenac | Michigan | 26011 | 3267 | 67 |
2500827 | 2500827 | 2022-05-13 | Baraga | Michigan | 26013 | 2222 | 54 |
2500828 | 2500828 | 2022-05-13 | Barry | Michigan | 26015 | 14514 | 169 |
2500829 | 2500829 | 2022-05-13 | Bay | Michigan | 26017 | 27496 | 588 |
2500830 | 2500830 | 2022-05-13 | Benzie | Michigan | 26019 | 3514 | 68 |
2500831 | 2500831 | 2022-05-13 | Berrien | Michigan | 26021 | 35344 | 561 |
2500832 | 2500832 | 2022-05-13 | Branch | Michigan | 26023 | 12253 | 206 |
2500833 | 2500833 | 2022-05-13 | Calhoun | Michigan | 26025 | 35011 | 575 |
2500834 | 2500834 | 2022-05-13 | Cass | Michigan | 26027 | 11215 | 145 |
2500835 | 2500835 | 2022-05-13 | Charlevoix | Michigan | 26029 | 5014 | 60 |
2500836 | 2500836 | 2022-05-13 | Cheboygan | Michigan | 26031 | 4760 | 104 |
2500837 | 2500837 | 2022-05-13 | Chippewa | Michigan | 26033 | 11841 | 120 |
2500838 | 2500838 | 2022-05-13 | Clare | Michigan | 26035 | 6834 | 157 |
2500839 | 2500839 | 2022-05-13 | Clinton | Michigan | 26037 | 22007 | 208 |
2500840 | 2500840 | 2022-05-13 | Crawford | Michigan | 26039 | 2629 | 31 |
2500841 | 2500841 | 2022-05-13 | Delta | Michigan | 26041 | 10050 | 157 |
2500842 | 2500842 | 2022-05-13 | Dickinson | Michigan | 26043 | 7490 | 110 |
2500843 | 2500843 | 2022-05-13 | Eaton | Michigan | 26045 | 27518 | 402 |
2500844 | 2500844 | 2022-05-13 | Emmet | Michigan | 26047 | 6608 | 87 |
2500845 | 2500845 | 2022-05-13 | Genesee | Michigan | 26049 | 103601 | 1720 |
2500846 | 2500846 | 2022-05-13 | Gladwin | Michigan | 26051 | 5632 | 114 |
2500847 | 2500847 | 2022-05-13 | Gogebic | Michigan | 26053 | 3296 | 69 |
2500848 | 2500848 | 2022-05-13 | Grand Traverse | Michigan | 26055 | 17858 | 236 |
2500849 | 2500849 | 2022-05-13 | Gratiot | Michigan | 26057 | 13864 | 191 |
2500850 | 2500850 | 2022-05-13 | Hillsdale | Michigan | 26059 | 10453 | 203 |
2500851 | 2500851 | 2022-05-13 | Houghton | Michigan | 26061 | 7982 | 92 |
2500852 | 2500852 | 2022-05-13 | Huron | Michigan | 26063 | 8138 | 145 |
2500853 | 2500853 | 2022-05-13 | Ingham | Michigan | 26065 | 66384 | 769 |
2500854 | 2500854 | 2022-05-13 | Ionia | Michigan | 26067 | 19843 | 181 |
2500855 | 2500855 | 2022-05-13 | Iosco | Michigan | 26069 | 4860 | 145 |
2500856 | 2500856 | 2022-05-13 | Iron | Michigan | 26071 | 2673 | 86 |
2500857 | 2500857 | 2022-05-13 | Isabella | Michigan | 26073 | 15890 | 211 |
2500858 | 2500858 | 2022-05-13 | Jackson | Michigan | 26075 | 45532 | 590 |
2500859 | 2500859 | 2022-05-13 | Kalamazoo | Michigan | 26077 | 60792 | 675 |
2500860 | 2500860 | 2022-05-13 | Kalkaska | Michigan | 26079 | 3623 | 61 |
2500861 | 2500861 | 2022-05-13 | Kent | Michigan | 26081 | 170251 | 1533 |
2500862 | 2500862 | 2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 |
2500863 | 2500863 | 2022-05-13 | Lake | Michigan | 26085 | 1893 | 37 |
2500864 | 2500864 | 2022-05-13 | Lapeer | Michigan | 26087 | 21122 | 427 |
2500865 | 2500865 | 2022-05-13 | Leelanau | Michigan | 26089 | 3697 | 55 |
2500866 | 2500866 | 2022-05-13 | Lenawee | Michigan | 26091 | 26611 | 331 |
2500867 | 2500867 | 2022-05-13 | Livingston | Michigan | 26093 | 47690 | 451 |
2500868 | 2500868 | 2022-05-13 | Luce | Michigan | 26095 | 2306 | 14 |
2500869 | 2500869 | 2022-05-13 | Mackinac | Michigan | 26097 | 2479 | 31 |
2500870 | 2500870 | 2022-05-13 | Macomb | Michigan | 26099 | 238947 | 3970 |
2500871 | 2500871 | 2022-05-13 | Manistee | Michigan | 26101 | 4550 | 91 |
2500872 | 2500872 | 2022-05-13 | Marquette | Michigan | 26103 | 16276 | 131 |
2500873 | 2500873 | 2022-05-13 | Mason | Michigan | 26105 | 6873 | 96 |
2500874 | 2500874 | 2022-05-13 | Mecosta | Michigan | 26107 | 8784 | 108 |
2500875 | 2500875 | 2022-05-13 | Menominee | Michigan | 26109 | 5693 | 70 |
2500876 | 2500876 | 2022-05-13 | Midland | Michigan | 26111 | 19428 | 226 |
2500877 | 2500877 | 2022-05-13 | Missaukee | Michigan | 26113 | 2946 | 60 |
2500878 | 2500878 | 2022-05-13 | Monroe | Michigan | 26115 | 39169 | 475 |
2500879 | 2500879 | 2022-05-13 | Montcalm | Michigan | 26117 | 17350 | 216 |
2500880 | 2500880 | 2022-05-13 | Montmorency | Michigan | 26119 | 1750 | 48 |
2500881 | 2500881 | 2022-05-13 | Muskegon | Michigan | 26121 | 42498 | 650 |
2500882 | 2500882 | 2022-05-13 | Newaygo | Michigan | 26123 | 11622 | 158 |
2500883 | 2500883 | 2022-05-13 | Oakland | Michigan | 26125 | 300744 | 3851 |
2500884 | 2500884 | 2022-05-13 | Oceana | Michigan | 26127 | 6422 | 90 |
2500885 | 2500885 | 2022-05-13 | Ogemaw | Michigan | 26129 | 4372 | 106 |
2500886 | 2500886 | 2022-05-13 | Ontonagon | Michigan | 26131 | 1008 | 38 |
2500887 | 2500887 | 2022-05-13 | Osceola | Michigan | 26133 | 5067 | 80 |
2500888 | 2500888 | 2022-05-13 | Oscoda | Michigan | 26135 | 1450 | 56 |
2500889 | 2500889 | 2022-05-13 | Otsego | Michigan | 26137 | 5779 | 101 |
2500890 | 2500890 | 2022-05-13 | Ottawa | Michigan | 26139 | 76277 | 785 |
2500891 | 2500891 | 2022-05-13 | Presque Isle | Michigan | 26141 | 2085 | 58 |
2500892 | 2500892 | 2022-05-13 | Roscommon | Michigan | 26143 | 4690 | 115 |
2500893 | 2500893 | 2022-05-13 | Saginaw | Michigan | 26145 | 51303 | 956 |
2500894 | 2500894 | 2022-05-13 | Sanilac | Michigan | 26151 | 8827 | 193 |
2500895 | 2500895 | 2022-05-13 | Schoolcraft | Michigan | 26153 | 1763 | 16 |
2500896 | 2500896 | 2022-05-13 | Shiawassee | Michigan | 26155 | 18142 | 232 |
2500897 | 2500897 | 2022-05-13 | St. Clair | Michigan | 26147 | 41609 | 835 |
2500898 | 2500898 | 2022-05-13 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2500899 | 2500899 | 2022-05-13 | Tuscola | Michigan | 26157 | 13350 | 277 |
2500900 | 2500900 | 2022-05-13 | Unknown | Michigan | 17641 | 80 | |
2500901 | 2500901 | 2022-05-13 | Van Buren | Michigan | 26159 | 17347 | 273 |
2500902 | 2500902 | 2022-05-13 | Washtenaw | Michigan | 26161 | 83317 | 522 |
2500903 | 2500903 | 2022-05-13 | Wayne | Michigan | 26163 | 416604 | 7975 |
2500904 | 2500904 | 2022-05-13 | Wexford | Michigan | 26165 | 7169 | 107 |
2497563 | 2497563 | 2022-05-12 | Alcona | Michigan | 26001 | 1745 | 71 |
2497564 | 2497564 | 2022-05-12 | Alger | Michigan | 26003 | 1880 | 13 |
2497565 | 2497565 | 2022-05-12 | Allegan | Michigan | 26005 | 27448 | 348 |
2497566 | 2497566 | 2022-05-12 | Alpena | Michigan | 26007 | 5809 | 139 |
2497567 | 2497567 | 2022-05-12 | Antrim | Michigan | 26009 | 4470 | 66 |
2497568 | 2497568 | 2022-05-12 | Arenac | Michigan | 26011 | 3267 | 67 |
2497569 | 2497569 | 2022-05-12 | Baraga | Michigan | 26013 | 2222 | 54 |
2497570 | 2497570 | 2022-05-12 | Barry | Michigan | 26015 | 14514 | 169 |
2497571 | 2497571 | 2022-05-12 | Bay | Michigan | 26017 | 27496 | 588 |
2497572 | 2497572 | 2022-05-12 | Benzie | Michigan | 26019 | 3514 | 68 |
2497573 | 2497573 | 2022-05-12 | Berrien | Michigan | 26021 | 35344 | 561 |
2497574 | 2497574 | 2022-05-12 | Branch | Michigan | 26023 | 12253 | 206 |
2497575 | 2497575 | 2022-05-12 | Calhoun | Michigan | 26025 | 35011 | 575 |
2497576 | 2497576 | 2022-05-12 | Cass | Michigan | 26027 | 11215 | 145 |
2497577 | 2497577 | 2022-05-12 | Charlevoix | Michigan | 26029 | 5014 | 60 |
2497578 | 2497578 | 2022-05-12 | Cheboygan | Michigan | 26031 | 4760 | 104 |
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);