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 83
- 26125 111
- 26163 111
- 26065 109
- 26081 109
- 26117 109
- 26147 109
- 26161 109
- 26017 108
- 26029 108
- 26089 108
- 26099 108
- 26115 107
- 26139 106
- 26075 104
- 26137 104
- 26037 102
- 26045 102
- 26049 102
- 26093 102
- 26111 102
- 26005 100
- 26015 100
- 26021 100
- 26025 100
- 26035 100
- 26145 100
- 26157 100
- 26165 100
- 26047 99
- 26051 99
- 26055 99
- 26143 99
- 26033 98
- 26077 98
- 26121 98
- 26123 98
- 26059 97
- 26073 97
- 26079 97
- 26087 97
- 26101 97
- 26069 96
- 26091 96
- 26103 96
- 26151 96
- 26159 96
- 26053 95
- 26067 95
- 26107 95
- 26113 95
- 26127 95
- 26129 95
- 26155 95
- 26027 94
- 26039 94
- 26057 94
- 26063 94
- - 94
- 26133 93
- 26031 92
- 26009 91
- 26041 91
- 26061 91
- 26149 91
- 26011 90
- 26023 90
- 26135 90
- 26097 89
- 26043 88
- 26095 87
- 26141 84
- 26105 83
- 26153 82
- 26109 80
- 26007 79
- 26085 79
- 26119 77
- 26001 75
- 26013 74
- 26019 72
- 26071 27
- 26003 19
- 26083 19
county 83
- Oakland 111
- Wayne 111
- Ingham 109
- Kent 109
- Montcalm 109
- St. Clair 109
- Washtenaw 109
- Bay 108
- Charlevoix 108
- Leelanau 108
- Macomb 108
- Monroe 107
- Ottawa 106
- Jackson 104
- Otsego 104
- Clinton 102
- Eaton 102
- Genesee 102
- Livingston 102
- Midland 102
- Allegan 100
- Barry 100
- Berrien 100
- Calhoun 100
- Clare 100
- Saginaw 100
- Tuscola 100
- Wexford 100
- Emmet 99
- Gladwin 99
- Grand Traverse 99
- Roscommon 99
- Chippewa 98
- Kalamazoo 98
- Muskegon 98
- Newaygo 98
- Hillsdale 97
- Isabella 97
- Kalkaska 97
- Lapeer 97
- Manistee 97
- Iosco 96
- Lenawee 96
- Marquette 96
- Sanilac 96
- Van Buren 96
- Gogebic 95
- Ionia 95
- Mecosta 95
- Missaukee 95
- Oceana 95
- Ogemaw 95
- Shiawassee 95
- Cass 94
- Crawford 94
- Gratiot 94
- Huron 94
- Unknown 94
- Osceola 93
- Cheboygan 92
- Antrim 91
- Delta 91
- Houghton 91
- St. Joseph 91
- Arenac 90
- Branch 90
- Oscoda 90
- Mackinac 89
- Dickinson 88
- Luce 87
- Presque Isle 84
- Mason 83
- Schoolcraft 82
- Menominee 80
- Alpena 79
- Lake 79
- Montmorency 77
- Alcona 75
- Baraga 74
- Benzie 72
- Iron 27
- Alger 19
- Keweenaw 19
state 1
- Michigan · 7,751 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282003 | 282003 | 2020-06-28 | Alcona | Michigan | 26001 | 21 | 1 |
282004 | 282004 | 2020-06-28 | Alger | Michigan | 26003 | 3 | 0 |
282005 | 282005 | 2020-06-28 | Allegan | Michigan | 26005 | 306 | 6 |
282006 | 282006 | 2020-06-28 | Alpena | Michigan | 26007 | 118 | 12 |
282007 | 282007 | 2020-06-28 | Antrim | Michigan | 26009 | 18 | 0 |
282008 | 282008 | 2020-06-28 | Arenac | Michigan | 26011 | 39 | 2 |
282009 | 282009 | 2020-06-28 | Baraga | Michigan | 26013 | 4 | 0 |
282010 | 282010 | 2020-06-28 | Barry | Michigan | 26015 | 97 | 2 |
282011 | 282011 | 2020-06-28 | Bay | Michigan | 26017 | 386 | 30 |
282012 | 282012 | 2020-06-28 | Benzie | Michigan | 26019 | 7 | 0 |
282013 | 282013 | 2020-06-28 | Berrien | Michigan | 26021 | 933 | 60 |
282014 | 282014 | 2020-06-28 | Branch | Michigan | 26023 | 1050 | 25 |
282015 | 282015 | 2020-06-28 | Calhoun | Michigan | 26025 | 526 | 32 |
282016 | 282016 | 2020-06-28 | Cass | Michigan | 26027 | 136 | 4 |
282017 | 282017 | 2020-06-28 | Charlevoix | Michigan | 26029 | 29 | 2 |
282018 | 282018 | 2020-06-28 | Cheboygan | Michigan | 26031 | 27 | 2 |
282019 | 282019 | 2020-06-28 | Chippewa | Michigan | 26033 | 6 | 0 |
282020 | 282020 | 2020-06-28 | Clare | Michigan | 26035 | 27 | 3 |
282021 | 282021 | 2020-06-28 | Clinton | Michigan | 26037 | 217 | 12 |
282022 | 282022 | 2020-06-28 | Crawford | Michigan | 26039 | 68 | 5 |
282023 | 282023 | 2020-06-28 | Delta | Michigan | 26041 | 21 | 3 |
282024 | 282024 | 2020-06-28 | Dickinson | Michigan | 26043 | 7 | 2 |
282025 | 282025 | 2020-06-28 | Eaton | Michigan | 26045 | 314 | 7 |
282026 | 282026 | 2020-06-28 | Emmet | Michigan | 26047 | 27 | 2 |
282027 | 282027 | 2020-06-28 | Genesee | Michigan | 26049 | 2690 | 288 |
282028 | 282028 | 2020-06-28 | Gladwin | Michigan | 26051 | 26 | 1 |
282029 | 282029 | 2020-06-28 | Gogebic | Michigan | 26053 | 7 | 1 |
282030 | 282030 | 2020-06-28 | Grand Traverse | Michigan | 26055 | 46 | 5 |
282031 | 282031 | 2020-06-28 | Gratiot | Michigan | 26057 | 98 | 13 |
282032 | 282032 | 2020-06-28 | Hillsdale | Michigan | 26059 | 193 | 25 |
282033 | 282033 | 2020-06-28 | Houghton | Michigan | 26061 | 11 | 0 |
282034 | 282034 | 2020-06-28 | Huron | Michigan | 26063 | 65 | 3 |
282035 | 282035 | 2020-06-28 | Ingham | Michigan | 26065 | 992 | 29 |
282036 | 282036 | 2020-06-28 | Ionia | Michigan | 26067 | 197 | 4 |
282037 | 282037 | 2020-06-28 | Iosco | Michigan | 26069 | 112 | 10 |
282038 | 282038 | 2020-06-28 | Iron | Michigan | 26071 | 5 | 1 |
282039 | 282039 | 2020-06-28 | Isabella | Michigan | 26073 | 122 | 8 |
282040 | 282040 | 2020-06-28 | Jackson | Michigan | 26075 | 2082 | 52 |
282041 | 282041 | 2020-06-28 | Kalamazoo | Michigan | 26077 | 1063 | 67 |
282042 | 282042 | 2020-06-28 | Kalkaska | Michigan | 26079 | 32 | 2 |
282043 | 282043 | 2020-06-28 | Kent | Michigan | 26081 | 4855 | 132 |
282044 | 282044 | 2020-06-28 | Keweenaw | Michigan | 26083 | 1 | 0 |
282045 | 282045 | 2020-06-28 | Lake | Michigan | 26085 | 7 | 0 |
282046 | 282046 | 2020-06-28 | Lapeer | Michigan | 26087 | 595 | 38 |
282047 | 282047 | 2020-06-28 | Leelanau | Michigan | 26089 | 16 | 0 |
282048 | 282048 | 2020-06-28 | Lenawee | Michigan | 26091 | 939 | 10 |
282049 | 282049 | 2020-06-28 | Livingston | Michigan | 26093 | 602 | 29 |
282050 | 282050 | 2020-06-28 | Luce | Michigan | 26095 | 4 | 0 |
282051 | 282051 | 2020-06-28 | Mackinac | Michigan | 26097 | 8 | 0 |
282052 | 282052 | 2020-06-28 | Macomb | Michigan | 26099 | 7537 | 912 |
282053 | 282053 | 2020-06-28 | Manistee | Michigan | 26101 | 28 | 0 |
282054 | 282054 | 2020-06-28 | Marquette | Michigan | 26103 | 64 | 11 |
282055 | 282055 | 2020-06-28 | Mason | Michigan | 26105 | 45 | 0 |
282056 | 282056 | 2020-06-28 | Mecosta | Michigan | 26107 | 29 | 2 |
282057 | 282057 | 2020-06-28 | Menominee | Michigan | 26109 | 16 | 0 |
282058 | 282058 | 2020-06-28 | Midland | Michigan | 26111 | 164 | 9 |
282059 | 282059 | 2020-06-28 | Missaukee | Michigan | 26113 | 28 | 1 |
282060 | 282060 | 2020-06-28 | Monroe | Michigan | 26115 | 603 | 21 |
282061 | 282061 | 2020-06-28 | Montcalm | Michigan | 26117 | 88 | 1 |
282062 | 282062 | 2020-06-28 | Montmorency | Michigan | 26119 | 5 | 0 |
282063 | 282063 | 2020-06-28 | Muskegon | Michigan | 26121 | 807 | 50 |
282064 | 282064 | 2020-06-28 | Newaygo | Michigan | 26123 | 163 | 0 |
282065 | 282065 | 2020-06-28 | Oakland | Michigan | 26125 | 11916 | 1085 |
282066 | 282066 | 2020-06-28 | Oceana | Michigan | 26127 | 263 | 3 |
282067 | 282067 | 2020-06-28 | Ogemaw | Michigan | 26129 | 32 | 2 |
282068 | 282068 | 2020-06-28 | Osceola | Michigan | 26133 | 27 | 0 |
282069 | 282069 | 2020-06-28 | Oscoda | Michigan | 26135 | 16 | 1 |
282070 | 282070 | 2020-06-28 | Otsego | Michigan | 26137 | 133 | 10 |
282071 | 282071 | 2020-06-28 | Ottawa | Michigan | 26139 | 1023 | 51 |
282072 | 282072 | 2020-06-28 | Presque Isle | Michigan | 26141 | 12 | 0 |
282073 | 282073 | 2020-06-28 | Roscommon | Michigan | 26143 | 26 | 0 |
282074 | 282074 | 2020-06-28 | Saginaw | Michigan | 26145 | 1269 | 123 |
282075 | 282075 | 2020-06-28 | Sanilac | Michigan | 26151 | 44 | 6 |
282076 | 282076 | 2020-06-28 | Schoolcraft | Michigan | 26153 | 4 | 0 |
282077 | 282077 | 2020-06-28 | Shiawassee | Michigan | 26155 | 269 | 27 |
282078 | 282078 | 2020-06-28 | St. Clair | Michigan | 26147 | 549 | 49 |
282079 | 282079 | 2020-06-28 | St. Joseph | Michigan | 26149 | 289 | 3 |
282080 | 282080 | 2020-06-28 | Tuscola | Michigan | 26157 | 233 | 26 |
282081 | 282081 | 2020-06-28 | Unknown | Michigan | 159 | 2 | |
282082 | 282082 | 2020-06-28 | Van Buren | Michigan | 26159 | 225 | 7 |
282083 | 282083 | 2020-06-28 | Washtenaw | Michigan | 26161 | 2151 | 114 |
282084 | 282084 | 2020-06-28 | Wayne | Michigan | 26163 | 22645 | 2712 |
282085 | 282085 | 2020-06-28 | Wexford | Michigan | 26165 | 25 | 3 |
278855 | 278855 | 2020-06-27 | Alcona | Michigan | 26001 | 21 | 1 |
278856 | 278856 | 2020-06-27 | Alger | Michigan | 26003 | 3 | 0 |
278857 | 278857 | 2020-06-27 | Allegan | Michigan | 26005 | 303 | 6 |
278858 | 278858 | 2020-06-27 | Alpena | Michigan | 26007 | 117 | 12 |
278859 | 278859 | 2020-06-27 | Antrim | Michigan | 26009 | 18 | 0 |
278860 | 278860 | 2020-06-27 | Arenac | Michigan | 26011 | 38 | 2 |
278861 | 278861 | 2020-06-27 | Baraga | Michigan | 26013 | 4 | 0 |
278862 | 278862 | 2020-06-27 | Barry | Michigan | 26015 | 96 | 2 |
278863 | 278863 | 2020-06-27 | Bay | Michigan | 26017 | 386 | 30 |
278864 | 278864 | 2020-06-27 | Benzie | Michigan | 26019 | 7 | 0 |
278865 | 278865 | 2020-06-27 | Berrien | Michigan | 26021 | 928 | 60 |
278866 | 278866 | 2020-06-27 | Branch | Michigan | 26023 | 1048 | 25 |
278867 | 278867 | 2020-06-27 | Calhoun | Michigan | 26025 | 523 | 32 |
278868 | 278868 | 2020-06-27 | Cass | Michigan | 26027 | 134 | 4 |
278869 | 278869 | 2020-06-27 | Charlevoix | Michigan | 26029 | 29 | 2 |
278870 | 278870 | 2020-06-27 | Cheboygan | Michigan | 26031 | 28 | 2 |
278871 | 278871 | 2020-06-27 | Chippewa | Michigan | 26033 | 4 | 0 |
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);