ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-09-04 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
500081 | 500081 | 2020-09-04 | Alcona | Michigan | 26001 | 37 | 2 |
500082 | 500082 | 2020-09-04 | Alger | Michigan | 26003 | 18 | 0 |
500083 | 500083 | 2020-09-04 | Allegan | Michigan | 26005 | 658 | 6 |
500084 | 500084 | 2020-09-04 | Alpena | Michigan | 26007 | 132 | 14 |
500085 | 500085 | 2020-09-04 | Antrim | Michigan | 26009 | 60 | 0 |
500086 | 500086 | 2020-09-04 | Arenac | Michigan | 26011 | 61 | 3 |
500087 | 500087 | 2020-09-04 | Baraga | Michigan | 26013 | 8 | 0 |
500088 | 500088 | 2020-09-04 | Barry | Michigan | 26015 | 224 | 2 |
500089 | 500089 | 2020-09-04 | Bay | Michigan | 26017 | 866 | 43 |
500090 | 500090 | 2020-09-04 | Benzie | Michigan | 26019 | 56 | 2 |
500091 | 500091 | 2020-09-04 | Berrien | Michigan | 26021 | 1724 | 70 |
500092 | 500092 | 2020-09-04 | Branch | Michigan | 26023 | 1320 | 27 |
500093 | 500093 | 2020-09-04 | Calhoun | Michigan | 26025 | 1054 | 44 |
500094 | 500094 | 2020-09-04 | Cass | Michigan | 26027 | 427 | 16 |
500095 | 500095 | 2020-09-04 | Charlevoix | Michigan | 26029 | 78 | 3 |
500096 | 500096 | 2020-09-04 | Cheboygan | Michigan | 26031 | 83 | 2 |
500097 | 500097 | 2020-09-04 | Chippewa | Michigan | 26033 | 65 | 0 |
500098 | 500098 | 2020-09-04 | Clare | Michigan | 26035 | 104 | 4 |
500099 | 500099 | 2020-09-04 | Clinton | Michigan | 26037 | 535 | 13 |
500100 | 500100 | 2020-09-04 | Crawford | Michigan | 26039 | 113 | 5 |
500101 | 500101 | 2020-09-04 | Delta | Michigan | 26041 | 176 | 3 |
500102 | 500102 | 2020-09-04 | Dickinson | Michigan | 26043 | 67 | 2 |
500103 | 500103 | 2020-09-04 | Eaton | Michigan | 26045 | 526 | 9 |
500104 | 500104 | 2020-09-04 | Emmet | Michigan | 26047 | 130 | 3 |
500105 | 500105 | 2020-09-04 | Genesee | Michigan | 26049 | 4021 | 305 |
500106 | 500106 | 2020-09-04 | Gladwin | Michigan | 26051 | 81 | 2 |
500107 | 500107 | 2020-09-04 | Gogebic | Michigan | 26053 | 146 | 1 |
500108 | 500108 | 2020-09-04 | Grand Traverse | Michigan | 26055 | 384 | 7 |
500109 | 500109 | 2020-09-04 | Gratiot | Michigan | 26057 | 199 | 15 |
500110 | 500110 | 2020-09-04 | Hillsdale | Michigan | 26059 | 305 | 26 |
500111 | 500111 | 2020-09-04 | Houghton | Michigan | 26061 | 110 | 2 |
500112 | 500112 | 2020-09-04 | Huron | Michigan | 26063 | 205 | 4 |
500113 | 500113 | 2020-09-04 | Ingham | Michigan | 26065 | 1889 | 40 |
500114 | 500114 | 2020-09-04 | Ionia | Michigan | 26067 | 389 | 7 |
500115 | 500115 | 2020-09-04 | Iosco | Michigan | 26069 | 149 | 12 |
500116 | 500116 | 2020-09-04 | Iron | Michigan | 26071 | 36 | 1 |
500117 | 500117 | 2020-09-04 | Isabella | Michigan | 26073 | 557 | 10 |
500118 | 500118 | 2020-09-04 | Jackson | Michigan | 26075 | 2586 | 62 |
500119 | 500119 | 2020-09-04 | Kalamazoo | Michigan | 26077 | 2037 | 88 |
500120 | 500120 | 2020-09-04 | Kalkaska | Michigan | 26079 | 71 | 4 |
500121 | 500121 | 2020-09-04 | Kent | Michigan | 26081 | 8646 | 169 |
500122 | 500122 | 2020-09-04 | Keweenaw | Michigan | 26083 | 4 | 0 |
500123 | 500123 | 2020-09-04 | Lake | Michigan | 26085 | 29 | 0 |
500124 | 500124 | 2020-09-04 | Lapeer | Michigan | 26087 | 859 | 43 |
500125 | 500125 | 2020-09-04 | Leelanau | Michigan | 26089 | 95 | 1 |
500126 | 500126 | 2020-09-04 | Lenawee | Michigan | 26091 | 1395 | 17 |
500127 | 500127 | 2020-09-04 | Livingston | Michigan | 26093 | 1213 | 30 |
500128 | 500128 | 2020-09-04 | Luce | Michigan | 26095 | 122 | 0 |
500129 | 500129 | 2020-09-04 | Mackinac | Michigan | 26097 | 42 | 0 |
500130 | 500130 | 2020-09-04 | Macomb | Michigan | 26099 | 13347 | 987 |
500131 | 500131 | 2020-09-04 | Manistee | Michigan | 26101 | 74 | 1 |
500132 | 500132 | 2020-09-04 | Marquette | Michigan | 26103 | 264 | 11 |
500133 | 500133 | 2020-09-04 | Mason | Michigan | 26105 | 123 | 0 |
500134 | 500134 | 2020-09-04 | Mecosta | Michigan | 26107 | 102 | 2 |
500135 | 500135 | 2020-09-04 | Menominee | Michigan | 26109 | 260 | 0 |
500136 | 500136 | 2020-09-04 | Midland | Michigan | 26111 | 449 | 11 |
500137 | 500137 | 2020-09-04 | Missaukee | Michigan | 26113 | 50 | 1 |
500138 | 500138 | 2020-09-04 | Monroe | Michigan | 26115 | 1367 | 28 |
500139 | 500139 | 2020-09-04 | Montcalm | Michigan | 26117 | 240 | 4 |
500140 | 500140 | 2020-09-04 | Montmorency | Michigan | 26119 | 12 | 0 |
500141 | 500141 | 2020-09-04 | Muskegon | Michigan | 26121 | 1975 | 68 |
500142 | 500142 | 2020-09-04 | Newaygo | Michigan | 26123 | 303 | 1 |
500143 | 500143 | 2020-09-04 | Oakland | Michigan | 26125 | 18455 | 1170 |
500144 | 500144 | 2020-09-04 | Oceana | Michigan | 26127 | 501 | 6 |
500145 | 500145 | 2020-09-04 | Ogemaw | Michigan | 26129 | 58 | 5 |
500146 | 500146 | 2020-09-04 | Ontonagon | Michigan | 26131 | 36 | 0 |
500147 | 500147 | 2020-09-04 | Osceola | Michigan | 26133 | 80 | 0 |
500148 | 500148 | 2020-09-04 | Oscoda | Michigan | 26135 | 29 | 1 |
500149 | 500149 | 2020-09-04 | Otsego | Michigan | 26137 | 162 | 11 |
500150 | 500150 | 2020-09-04 | Ottawa | Michigan | 26139 | 2440 | 64 |
500151 | 500151 | 2020-09-04 | Presque Isle | Michigan | 26141 | 22 | 1 |
500152 | 500152 | 2020-09-04 | Roscommon | Michigan | 26143 | 76 | 4 |
500153 | 500153 | 2020-09-04 | Saginaw | Michigan | 26145 | 2627 | 132 |
500154 | 500154 | 2020-09-04 | Sanilac | Michigan | 26151 | 128 | 7 |
500155 | 500155 | 2020-09-04 | Schoolcraft | Michigan | 26153 | 15 | 0 |
500156 | 500156 | 2020-09-04 | Shiawassee | Michigan | 26155 | 452 | 30 |
500157 | 500157 | 2020-09-04 | St. Clair | Michigan | 26147 | 941 | 53 |
500158 | 500158 | 2020-09-04 | St. Joseph | Michigan | 26149 | 691 | 11 |
500159 | 500159 | 2020-09-04 | Tuscola | Michigan | 26157 | 466 | 29 |
500160 | 500160 | 2020-09-04 | Unknown | Michigan | 501 | 4 | |
500161 | 500161 | 2020-09-04 | Van Buren | Michigan | 26159 | 658 | 16 |
500162 | 500162 | 2020-09-04 | Washtenaw | Michigan | 26161 | 3508 | 124 |
500163 | 500163 | 2020-09-04 | Wayne | Michigan | 26163 | 31850 | 2897 |
500164 | 500164 | 2020-09-04 | Wexford | Michigan | 26165 | 116 | 4 |
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);