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)
fips >30
- 26125 350
- 26163 350
- 26065 348
- 26081 348
- 26117 348
- 26147 348
- 26161 348
- 26017 347
- 26029 347
- 26089 347
- 26099 347
- 26115 346
- 26139 345
- 26075 343
- 26137 343
- 26037 341
- 26045 341
- 26049 341
- 26093 341
- 26111 341
- 26005 339
- 26015 339
- 26021 339
- 26025 339
- 26035 339
- 26145 339
- 26157 339
- 26165 339
- 26047 338
- 26051 338
- …
county >30
- Oakland 350
- Wayne 350
- Ingham 348
- Kent 348
- Montcalm 348
- St. Clair 348
- Washtenaw 348
- Bay 347
- Charlevoix 347
- Leelanau 347
- Macomb 347
- Monroe 346
- Ottawa 345
- Jackson 343
- Otsego 343
- Clinton 341
- Eaton 341
- Genesee 341
- Livingston 341
- Midland 341
- Allegan 339
- Barry 339
- Berrien 339
- Calhoun 339
- Clare 339
- Saginaw 339
- Tuscola 339
- Wexford 339
- Emmet 338
- Gladwin 338
- …
state 1
- Michigan · 27,822 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054749 | 1054749 | 2021-02-22 | Alcona | Michigan | 26001 | 427 | 24 |
1054750 | 1054750 | 2021-02-22 | Alger | Michigan | 26003 | 581 | 3 |
1054751 | 1054751 | 2021-02-22 | Allegan | Michigan | 26005 | 7235 | 118 |
1054752 | 1054752 | 2021-02-22 | Alpena | Michigan | 26007 | 1469 | 47 |
1054753 | 1054753 | 2021-02-22 | Antrim | Michigan | 26009 | 917 | 19 |
1054754 | 1054754 | 2021-02-22 | Arenac | Michigan | 26011 | 746 | 24 |
1054755 | 1054755 | 2021-02-22 | Baraga | Michigan | 26013 | 772 | 33 |
1054756 | 1054756 | 2021-02-22 | Barry | Michigan | 26015 | 3712 | 43 |
1054757 | 1054757 | 2021-02-22 | Bay | Michigan | 26017 | 7348 | 284 |
1054758 | 1054758 | 2021-02-22 | Benzie | Michigan | 26019 | 904 | 31 |
1054759 | 1054759 | 2021-02-22 | Berrien | Michigan | 26021 | 11421 | 237 |
1054760 | 1054760 | 2021-02-22 | Branch | Michigan | 26023 | 4566 | 110 |
1054761 | 1054761 | 2021-02-22 | Calhoun | Michigan | 26025 | 9451 | 232 |
1054762 | 1054762 | 2021-02-22 | Cass | Michigan | 26027 | 3934 | 63 |
1054763 | 1054763 | 2021-02-22 | Charlevoix | Michigan | 26029 | 1037 | 13 |
1054764 | 1054764 | 2021-02-22 | Cheboygan | Michigan | 26031 | 920 | 35 |
1054765 | 1054765 | 2021-02-22 | Chippewa | Michigan | 26033 | 4807 | 42 |
1054766 | 1054766 | 2021-02-22 | Clare | Michigan | 26035 | 1595 | 69 |
1054767 | 1054767 | 2021-02-22 | Clinton | Michigan | 26037 | 4991 | 69 |
1054768 | 1054768 | 2021-02-22 | Crawford | Michigan | 26039 | 580 | 5 |
1054769 | 1054769 | 2021-02-22 | Delta | Michigan | 26041 | 3110 | 84 |
1054770 | 1054770 | 2021-02-22 | Dickinson | Michigan | 26043 | 2362 | 69 |
1054771 | 1054771 | 2021-02-22 | Eaton | Michigan | 26045 | 6169 | 150 |
1054772 | 1054772 | 2021-02-22 | Emmet | Michigan | 26047 | 1500 | 38 |
1054773 | 1054773 | 2021-02-22 | Genesee | Michigan | 26049 | 25177 | 750 |
1054774 | 1054774 | 2021-02-22 | Gladwin | Michigan | 26051 | 1469 | 43 |
1054775 | 1054775 | 2021-02-22 | Gogebic | Michigan | 26053 | 1259 | 47 |
1054776 | 1054776 | 2021-02-22 | Grand Traverse | Michigan | 26055 | 4201 | 68 |
1054777 | 1054777 | 2021-02-22 | Gratiot | Michigan | 26057 | 5633 | 105 |
1054778 | 1054778 | 2021-02-22 | Hillsdale | Michigan | 26059 | 3311 | 72 |
1054779 | 1054779 | 2021-02-22 | Houghton | Michigan | 26061 | 2612 | 40 |
1054780 | 1054780 | 2021-02-22 | Huron | Michigan | 26063 | 2106 | 58 |
1054781 | 1054781 | 2021-02-22 | Ingham | Michigan | 26065 | 16138 | 278 |
1054782 | 1054782 | 2021-02-22 | Ionia | Michigan | 26067 | 6948 | 74 |
1054783 | 1054783 | 2021-02-22 | Iosco | Michigan | 26069 | 1275 | 67 |
1054784 | 1054784 | 2021-02-22 | Iron | Michigan | 26071 | 926 | 49 |
1054785 | 1054785 | 2021-02-22 | Isabella | Michigan | 26073 | 3991 | 73 |
1054786 | 1054786 | 2021-02-22 | Jackson | Michigan | 26075 | 13996 | 245 |
1054787 | 1054787 | 2021-02-22 | Kalamazoo | Michigan | 26077 | 14766 | 319 |
1054788 | 1054788 | 2021-02-22 | Kalkaska | Michigan | 26079 | 593 | 15 |
1054789 | 1054789 | 2021-02-22 | Kent | Michigan | 26081 | 51266 | 702 |
1054790 | 1054790 | 2021-02-22 | Keweenaw | Michigan | 26083 | 140 | 2 |
1054791 | 1054791 | 2021-02-22 | Lake | Michigan | 26085 | 359 | 11 |
1054792 | 1054792 | 2021-02-22 | Lapeer | Michigan | 26087 | 5458 | 128 |
1054793 | 1054793 | 2021-02-22 | Leelanau | Michigan | 26089 | 856 | 14 |
1054794 | 1054794 | 2021-02-22 | Lenawee | Michigan | 26091 | 7606 | 126 |
1054795 | 1054795 | 2021-02-22 | Livingston | Michigan | 26093 | 10223 | 139 |
1054796 | 1054796 | 2021-02-22 | Luce | Michigan | 26095 | 1072 | 2 |
1054797 | 1054797 | 2021-02-22 | Mackinac | Michigan | 26097 | 437 | 3 |
1054798 | 1054798 | 2021-02-22 | Macomb | Michigan | 26099 | 58609 | 1954 |
1054799 | 1054799 | 2021-02-22 | Manistee | Michigan | 26101 | 1483 | 23 |
1054800 | 1054800 | 2021-02-22 | Marquette | Michigan | 26103 | 4787 | 56 |
1054801 | 1054801 | 2021-02-22 | Mason | Michigan | 26105 | 1229 | 26 |
1054802 | 1054802 | 2021-02-22 | Mecosta | Michigan | 26107 | 2000 | 19 |
1054803 | 1054803 | 2021-02-22 | Menominee | Michigan | 26109 | 1875 | 37 |
1054804 | 1054804 | 2021-02-22 | Midland | Michigan | 26111 | 4910 | 64 |
1054805 | 1054805 | 2021-02-22 | Missaukee | Michigan | 26113 | 756 | 17 |
1054806 | 1054806 | 2021-02-22 | Monroe | Michigan | 26115 | 9639 | 198 |
1054807 | 1054807 | 2021-02-22 | Montcalm | Michigan | 26117 | 5583 | 92 |
1054808 | 1054808 | 2021-02-22 | Montmorency | Michigan | 26119 | 357 | 17 |
1054809 | 1054809 | 2021-02-22 | Muskegon | Michigan | 26121 | 12662 | 315 |
1054810 | 1054810 | 2021-02-22 | Newaygo | Michigan | 26123 | 2799 | 50 |
1054811 | 1054811 | 2021-02-22 | Oakland | Michigan | 26125 | 73922 | 1977 |
1054812 | 1054812 | 2021-02-22 | Oceana | Michigan | 26127 | 1860 | 50 |
1054813 | 1054813 | 2021-02-22 | Ogemaw | Michigan | 26129 | 1111 | 34 |
1054814 | 1054814 | 2021-02-22 | Ontonagon | Michigan | 26131 | 410 | 20 |
1054815 | 1054815 | 2021-02-22 | Osceola | Michigan | 26133 | 1041 | 23 |
1054816 | 1054816 | 2021-02-22 | Oscoda | Michigan | 26135 | 395 | 19 |
1054817 | 1054817 | 2021-02-22 | Otsego | Michigan | 26137 | 1160 | 25 |
1054818 | 1054818 | 2021-02-22 | Ottawa | Michigan | 26139 | 22166 | 347 |
1054819 | 1054819 | 2021-02-22 | Presque Isle | Michigan | 26141 | 651 | 28 |
1054820 | 1054820 | 2021-02-22 | Roscommon | Michigan | 26143 | 1140 | 32 |
1054821 | 1054821 | 2021-02-22 | Saginaw | Michigan | 26145 | 15808 | 508 |
1054822 | 1054822 | 2021-02-22 | Sanilac | Michigan | 26151 | 2009 | 76 |
1054823 | 1054823 | 2021-02-22 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1054824 | 1054824 | 2021-02-22 | Shiawassee | Michigan | 26155 | 3762 | 78 |
1054825 | 1054825 | 2021-02-22 | St. Clair | Michigan | 26147 | 8578 | 253 |
1054826 | 1054826 | 2021-02-22 | St. Joseph | Michigan | 26149 | 4609 | 84 |
1054827 | 1054827 | 2021-02-22 | Tuscola | Michigan | 26157 | 3150 | 137 |
1054828 | 1054828 | 2021-02-22 | Unknown | Michigan | 0 | 12 | |
1054829 | 1054829 | 2021-02-22 | Van Buren | Michigan | 26159 | 4945 | 95 |
1054830 | 1054830 | 2021-02-22 | Washtenaw | Michigan | 26161 | 18978 | 251 |
1054831 | 1054831 | 2021-02-22 | Wayne | Michigan | 26163 | 100669 | 4120 |
1054832 | 1054832 | 2021-02-22 | Wexford | Michigan | 26165 | 1418 | 20 |
1051502 | 1051502 | 2021-02-21 | Alcona | Michigan | 26001 | 427 | 24 |
1051503 | 1051503 | 2021-02-21 | Alger | Michigan | 26003 | 581 | 5 |
1051504 | 1051504 | 2021-02-21 | Allegan | Michigan | 26005 | 7211 | 118 |
1051505 | 1051505 | 2021-02-21 | Alpena | Michigan | 26007 | 1466 | 47 |
1051506 | 1051506 | 2021-02-21 | Antrim | Michigan | 26009 | 910 | 19 |
1051507 | 1051507 | 2021-02-21 | Arenac | Michigan | 26011 | 741 | 24 |
1051508 | 1051508 | 2021-02-21 | Baraga | Michigan | 26013 | 772 | 33 |
1051509 | 1051509 | 2021-02-21 | Barry | Michigan | 26015 | 3700 | 42 |
1051510 | 1051510 | 2021-02-21 | Bay | Michigan | 26017 | 7331 | 283 |
1051511 | 1051511 | 2021-02-21 | Benzie | Michigan | 26019 | 904 | 31 |
1051512 | 1051512 | 2021-02-21 | Berrien | Michigan | 26021 | 11383 | 236 |
1051513 | 1051513 | 2021-02-21 | Branch | Michigan | 26023 | 4561 | 110 |
1051514 | 1051514 | 2021-02-21 | Calhoun | Michigan | 26025 | 9423 | 232 |
1051515 | 1051515 | 2021-02-21 | Cass | Michigan | 26027 | 3917 | 63 |
1051516 | 1051516 | 2021-02-21 | Charlevoix | Michigan | 26029 | 1033 | 13 |
1051517 | 1051517 | 2021-02-21 | Cheboygan | Michigan | 26031 | 912 | 35 |
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);