ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1704148 | 1704148 | 2021-09-10 | Alcona | Michigan | 26001 | 844 | 37 |
1704149 | 1704149 | 2021-09-10 | Alger | Michigan | 26003 | 751 | 7 |
1704150 | 1704150 | 2021-09-10 | Allegan | Michigan | 26005 | 12371 | 168 |
1704151 | 1704151 | 2021-09-10 | Alpena | Michigan | 26007 | 2545 | 67 |
1704152 | 1704152 | 2021-09-10 | Antrim | Michigan | 26009 | 1827 | 33 |
1704153 | 1704153 | 2021-09-10 | Arenac | Michigan | 26011 | 1321 | 31 |
1704154 | 1704154 | 2021-09-10 | Baraga | Michigan | 26013 | 1091 | 43 |
1704155 | 1704155 | 2021-09-10 | Barry | Michigan | 26015 | 6580 | 74 |
1704156 | 1704156 | 2021-09-10 | Bay | Michigan | 26017 | 12036 | 366 |
1704157 | 1704157 | 2021-09-10 | Benzie | Michigan | 26019 | 1391 | 38 |
1704158 | 1704158 | 2021-09-10 | Berrien | Michigan | 26021 | 16960 | 306 |
1704159 | 1704159 | 2021-09-10 | Branch | Michigan | 26023 | 6565 | 128 |
1704160 | 1704160 | 2021-09-10 | Calhoun | Michigan | 26025 | 15987 | 331 |
1704161 | 1704161 | 2021-09-10 | Cass | Michigan | 26027 | 6041 | 81 |
1704162 | 1704162 | 2021-09-10 | Charlevoix | Michigan | 26029 | 1979 | 27 |
1704163 | 1704163 | 2021-09-10 | Cheboygan | Michigan | 26031 | 2152 | 53 |
1704164 | 1704164 | 2021-09-10 | Chippewa | Michigan | 26033 | 5913 | 51 |
1704165 | 1704165 | 2021-09-10 | Clare | Michigan | 26035 | 2757 | 89 |
1704166 | 1704166 | 2021-09-10 | Clinton | Michigan | 26037 | 8329 | 98 |
1704167 | 1704167 | 2021-09-10 | Crawford | Michigan | 26039 | 1081 | 14 |
1704168 | 1704168 | 2021-09-10 | Delta | Michigan | 26041 | 4648 | 95 |
1704169 | 1704169 | 2021-09-10 | Dickinson | Michigan | 26043 | 3096 | 75 |
1704170 | 1704170 | 2021-09-10 | Eaton | Michigan | 26045 | 11181 | 218 |
1704171 | 1704171 | 2021-09-10 | Emmet | Michigan | 26047 | 2681 | 45 |
1704172 | 1704172 | 2021-09-10 | Genesee | Michigan | 26049 | 45277 | 1014 |
1704173 | 1704173 | 2021-09-10 | Gladwin | Michigan | 26051 | 2545 | 62 |
1704174 | 1704174 | 2021-09-10 | Gogebic | Michigan | 26053 | 1561 | 53 |
1704175 | 1704175 | 2021-09-10 | Grand Traverse | Michigan | 26055 | 7261 | 104 |
1704176 | 1704176 | 2021-09-10 | Gratiot | Michigan | 26057 | 7296 | 127 |
1704177 | 1704177 | 2021-09-10 | Hillsdale | Michigan | 26059 | 4978 | 101 |
1704178 | 1704178 | 2021-09-10 | Houghton | Michigan | 26061 | 3351 | 45 |
1704179 | 1704179 | 2021-09-10 | Huron | Michigan | 26063 | 4344 | 87 |
1704180 | 1704180 | 2021-09-10 | Ingham | Michigan | 26065 | 27032 | 417 |
1704181 | 1704181 | 2021-09-10 | Ionia | Michigan | 26067 | 9963 | 88 |
1704182 | 1704182 | 2021-09-10 | Iosco | Michigan | 26069 | 2258 | 80 |
1704183 | 1704183 | 2021-09-10 | Iron | Michigan | 26071 | 1199 | 53 |
1704184 | 1704184 | 2021-09-10 | Isabella | Michigan | 26073 | 6936 | 103 |
1704185 | 1704185 | 2021-09-10 | Jackson | Michigan | 26075 | 22791 | 337 |
1704186 | 1704186 | 2021-09-10 | Kalamazoo | Michigan | 26077 | 25797 | 426 |
1704187 | 1704187 | 2021-09-10 | Kalkaska | Michigan | 26079 | 1306 | 31 |
1704188 | 1704188 | 2021-09-10 | Kent | Michigan | 26081 | 80214 | 902 |
1704189 | 1704189 | 2021-09-10 | Keweenaw | Michigan | 26083 | 190 | 2 |
1704190 | 1704190 | 2021-09-10 | Lake | Michigan | 26085 | 747 | 17 |
1704191 | 1704191 | 2021-09-10 | Lapeer | Michigan | 26087 | 10491 | 225 |
1704192 | 1704192 | 2021-09-10 | Leelanau | Michigan | 26089 | 1392 | 21 |
1704193 | 1704193 | 2021-09-10 | Lenawee | Michigan | 26091 | 11919 | 185 |
1704194 | 1704194 | 2021-09-10 | Livingston | Michigan | 26093 | 18938 | 210 |
1704195 | 1704195 | 2021-09-10 | Luce | Michigan | 26095 | 1385 | 6 |
1704196 | 1704196 | 2021-09-10 | Mackinac | Michigan | 26097 | 865 | 4 |
1704197 | 1704197 | 2021-09-10 | Macomb | Michigan | 26099 | 108054 | 2558 |
1704198 | 1704198 | 2021-09-10 | Manistee | Michigan | 26101 | 2189 | 30 |
1704199 | 1704199 | 2021-09-10 | Marquette | Michigan | 26103 | 6385 | 68 |
1704200 | 1704200 | 2021-09-10 | Mason | Michigan | 26105 | 2489 | 41 |
1704201 | 1704201 | 2021-09-10 | Mecosta | Michigan | 26107 | 3532 | 39 |
1704202 | 1704202 | 2021-09-10 | Menominee | Michigan | 26109 | 2514 | 46 |
1704203 | 1704203 | 2021-09-10 | Midland | Michigan | 26111 | 8324 | 105 |
1704204 | 1704204 | 2021-09-10 | Missaukee | Michigan | 26113 | 1591 | 29 |
1704205 | 1704205 | 2021-09-10 | Monroe | Michigan | 26115 | 16843 | 278 |
1704206 | 1704206 | 2021-09-10 | Montcalm | Michigan | 26117 | 8744 | 126 |
1704207 | 1704207 | 2021-09-10 | Montmorency | Michigan | 26119 | 700 | 21 |
1704208 | 1704208 | 2021-09-10 | Muskegon | Michigan | 26121 | 19886 | 394 |
1704209 | 1704209 | 2021-09-10 | Newaygo | Michigan | 26123 | 5248 | 72 |
1704210 | 1704210 | 2021-09-10 | Oakland | Michigan | 26125 | 129543 | 2539 |
1704211 | 1704211 | 2021-09-10 | Oceana | Michigan | 26127 | 2945 | 62 |
1704212 | 1704212 | 2021-09-10 | Ogemaw | Michigan | 26129 | 1965 | 45 |
1704213 | 1704213 | 2021-09-10 | Ontonagon | Michigan | 26131 | 539 | 22 |
1704214 | 1704214 | 2021-09-10 | Osceola | Michigan | 26133 | 2153 | 31 |
1704215 | 1704215 | 2021-09-10 | Oscoda | Michigan | 26135 | 739 | 31 |
1704216 | 1704216 | 2021-09-10 | Otsego | Michigan | 26137 | 2603 | 43 |
1704217 | 1704217 | 2021-09-10 | Ottawa | Michigan | 26139 | 35924 | 456 |
1704218 | 1704218 | 2021-09-10 | Presque Isle | Michigan | 26141 | 1140 | 35 |
1704219 | 1704219 | 2021-09-10 | Roscommon | Michigan | 26143 | 2032 | 57 |
1704220 | 1704220 | 2021-09-10 | Saginaw | Michigan | 26145 | 24436 | 652 |
1704221 | 1704221 | 2021-09-10 | Sanilac | Michigan | 26151 | 4439 | 127 |
1704222 | 1704222 | 2021-09-10 | Schoolcraft | Michigan | 26153 | 519 | 5 |
1704223 | 1704223 | 2021-09-10 | Shiawassee | Michigan | 26155 | 7200 | 114 |
1704224 | 1704224 | 2021-09-10 | St. Clair | Michigan | 26147 | 19625 | 465 |
1704225 | 1704225 | 2021-09-10 | St. Joseph | Michigan | 26149 | 6946 | 104 |
1704226 | 1704226 | 2021-09-10 | Tuscola | Michigan | 26157 | 6113 | 180 |
1704227 | 1704227 | 2021-09-10 | Unknown | Michigan | 829 | 18 | |
1704228 | 1704228 | 2021-09-10 | Van Buren | Michigan | 26159 | 7815 | 147 |
1704229 | 1704229 | 2021-09-10 | Washtenaw | Michigan | 26161 | 29785 | 317 |
1704230 | 1704230 | 2021-09-10 | Wayne | Michigan | 26163 | 179400 | 5325 |
1704231 | 1704231 | 2021-09-10 | Wexford | Michigan | 26165 | 3029 | 50 |
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);