ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-16" 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 |
---|---|---|---|---|---|---|---|
636127 | 636127 | 2020-10-16 | Alcona | Michigan | 26001 | 50 | 2 |
636128 | 636128 | 2020-10-16 | Alger | Michigan | 26003 | 78 | 0 |
636129 | 636129 | 2020-10-16 | Allegan | Michigan | 26005 | 1015 | 7 |
636130 | 636130 | 2020-10-16 | Alpena | Michigan | 26007 | 148 | 14 |
636131 | 636131 | 2020-10-16 | Antrim | Michigan | 26009 | 91 | 0 |
636132 | 636132 | 2020-10-16 | Arenac | Michigan | 26011 | 84 | 3 |
636133 | 636133 | 2020-10-16 | Baraga | Michigan | 26013 | 66 | 4 |
636134 | 636134 | 2020-10-16 | Barry | Michigan | 26015 | 504 | 5 |
636135 | 636135 | 2020-10-16 | Bay | Michigan | 26017 | 1199 | 55 |
636136 | 636136 | 2020-10-16 | Benzie | Michigan | 26019 | 101 | 2 |
636137 | 636137 | 2020-10-16 | Berrien | Michigan | 26021 | 2359 | 78 |
636138 | 636138 | 2020-10-16 | Branch | Michigan | 26023 | 1571 | 33 |
636139 | 636139 | 2020-10-16 | Calhoun | Michigan | 26025 | 2150 | 53 |
636140 | 636140 | 2020-10-16 | Cass | Michigan | 26027 | 788 | 23 |
636141 | 636141 | 2020-10-16 | Charlevoix | Michigan | 26029 | 135 | 4 |
636142 | 636142 | 2020-10-16 | Cheboygan | Michigan | 26031 | 112 | 2 |
636143 | 636143 | 2020-10-16 | Chippewa | Michigan | 26033 | 102 | 0 |
636144 | 636144 | 2020-10-16 | Clare | Michigan | 26035 | 198 | 6 |
636145 | 636145 | 2020-10-16 | Clinton | Michigan | 26037 | 857 | 14 |
636146 | 636146 | 2020-10-16 | Crawford | Michigan | 26039 | 136 | 5 |
636147 | 636147 | 2020-10-16 | Delta | Michigan | 26041 | 949 | 16 |
636148 | 636148 | 2020-10-16 | Dickinson | Michigan | 26043 | 414 | 5 |
636149 | 636149 | 2020-10-16 | Eaton | Michigan | 26045 | 894 | 10 |
636150 | 636150 | 2020-10-16 | Emmet | Michigan | 26047 | 182 | 4 |
636151 | 636151 | 2020-10-16 | Genesee | Michigan | 26049 | 5811 | 321 |
636152 | 636152 | 2020-10-16 | Gladwin | Michigan | 26051 | 156 | 2 |
636153 | 636153 | 2020-10-16 | Gogebic | Michigan | 26053 | 239 | 2 |
636154 | 636154 | 2020-10-16 | Grand Traverse | Michigan | 26055 | 628 | 13 |
636155 | 636155 | 2020-10-16 | Gratiot | Michigan | 26057 | 395 | 16 |
636156 | 636156 | 2020-10-16 | Hillsdale | Michigan | 26059 | 440 | 27 |
636157 | 636157 | 2020-10-16 | Houghton | Michigan | 26061 | 839 | 6 |
636158 | 636158 | 2020-10-16 | Huron | Michigan | 26063 | 253 | 5 |
636159 | 636159 | 2020-10-16 | Ingham | Michigan | 26065 | 4217 | 57 |
636160 | 636160 | 2020-10-16 | Ionia | Michigan | 26067 | 712 | 8 |
636161 | 636161 | 2020-10-16 | Iosco | Michigan | 26069 | 255 | 14 |
636162 | 636162 | 2020-10-16 | Iron | Michigan | 26071 | 326 | 17 |
636163 | 636163 | 2020-10-16 | Isabella | Michigan | 26073 | 897 | 15 |
636164 | 636164 | 2020-10-16 | Jackson | Michigan | 26075 | 3170 | 82 |
636165 | 636165 | 2020-10-16 | Kalamazoo | Michigan | 26077 | 4045 | 98 |
636166 | 636166 | 2020-10-16 | Kalkaska | Michigan | 26079 | 112 | 4 |
636167 | 636167 | 2020-10-16 | Kent | Michigan | 26081 | 12207 | 178 |
636168 | 636168 | 2020-10-16 | Keweenaw | Michigan | 26083 | 18 | 0 |
636169 | 636169 | 2020-10-16 | Lake | Michigan | 26085 | 42 | 0 |
636170 | 636170 | 2020-10-16 | Lapeer | Michigan | 26087 | 1079 | 45 |
636171 | 636171 | 2020-10-16 | Leelanau | Michigan | 26089 | 129 | 1 |
636172 | 636172 | 2020-10-16 | Lenawee | Michigan | 26091 | 1727 | 22 |
636173 | 636173 | 2020-10-16 | Livingston | Michigan | 26093 | 1764 | 33 |
636174 | 636174 | 2020-10-16 | Luce | Michigan | 26095 | 284 | 0 |
636175 | 636175 | 2020-10-16 | Mackinac | Michigan | 26097 | 134 | 0 |
636176 | 636176 | 2020-10-16 | Macomb | Michigan | 26099 | 16996 | 1064 |
636177 | 636177 | 2020-10-16 | Manistee | Michigan | 26101 | 119 | 3 |
636178 | 636178 | 2020-10-16 | Marquette | Michigan | 26103 | 703 | 12 |
636179 | 636179 | 2020-10-16 | Mason | Michigan | 26105 | 169 | 1 |
636180 | 636180 | 2020-10-16 | Mecosta | Michigan | 26107 | 344 | 4 |
636181 | 636181 | 2020-10-16 | Menominee | Michigan | 26109 | 609 | 3 |
636182 | 636182 | 2020-10-16 | Midland | Michigan | 26111 | 781 | 13 |
636183 | 636183 | 2020-10-16 | Missaukee | Michigan | 26113 | 75 | 1 |
636184 | 636184 | 2020-10-16 | Monroe | Michigan | 26115 | 1784 | 30 |
636185 | 636185 | 2020-10-16 | Montcalm | Michigan | 26117 | 464 | 8 |
636186 | 636186 | 2020-10-16 | Montmorency | Michigan | 26119 | 20 | 0 |
636187 | 636187 | 2020-10-16 | Muskegon | Michigan | 26121 | 2790 | 78 |
636188 | 636188 | 2020-10-16 | Newaygo | Michigan | 26123 | 509 | 2 |
636189 | 636189 | 2020-10-16 | Oakland | Michigan | 26125 | 22752 | 1224 |
636190 | 636190 | 2020-10-16 | Oceana | Michigan | 26127 | 566 | 6 |
636191 | 636191 | 2020-10-16 | Ogemaw | Michigan | 26129 | 83 | 5 |
636192 | 636192 | 2020-10-16 | Ontonagon | Michigan | 26131 | 64 | 0 |
636193 | 636193 | 2020-10-16 | Osceola | Michigan | 26133 | 119 | 0 |
636194 | 636194 | 2020-10-16 | Oscoda | Michigan | 26135 | 50 | 1 |
636195 | 636195 | 2020-10-16 | Otsego | Michigan | 26137 | 215 | 12 |
636196 | 636196 | 2020-10-16 | Ottawa | Michigan | 26139 | 4259 | 70 |
636197 | 636197 | 2020-10-16 | Presque Isle | Michigan | 26141 | 34 | 1 |
636198 | 636198 | 2020-10-16 | Roscommon | Michigan | 26143 | 128 | 4 |
636199 | 636199 | 2020-10-16 | Saginaw | Michigan | 26145 | 3342 | 148 |
636200 | 636200 | 2020-10-16 | Sanilac | Michigan | 26151 | 163 | 7 |
636201 | 636201 | 2020-10-16 | Schoolcraft | Michigan | 26153 | 53 | 0 |
636202 | 636202 | 2020-10-16 | Shiawassee | Michigan | 26155 | 605 | 33 |
636203 | 636203 | 2020-10-16 | St. Clair | Michigan | 26147 | 1256 | 62 |
636204 | 636204 | 2020-10-16 | St. Joseph | Michigan | 26149 | 1028 | 12 |
636205 | 636205 | 2020-10-16 | Tuscola | Michigan | 26157 | 573 | 34 |
636206 | 636206 | 2020-10-16 | Unknown | Michigan | 317 | 4 | |
636207 | 636207 | 2020-10-16 | Van Buren | Michigan | 26159 | 914 | 18 |
636208 | 636208 | 2020-10-16 | Washtenaw | Michigan | 26161 | 5072 | 126 |
636209 | 636209 | 2020-10-16 | Wayne | Michigan | 26163 | 37977 | 3019 |
636210 | 636210 | 2020-10-16 | Wexford | Michigan | 26165 | 149 | 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);