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-07-21 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
355064 | 355064 | 2020-07-21 | Alcona | Michigan | 26001 | 27 | 1 |
355065 | 355065 | 2020-07-21 | Alger | Michigan | 26003 | 4 | 0 |
355066 | 355066 | 2020-07-21 | Allegan | Michigan | 26005 | 440 | 7 |
355067 | 355067 | 2020-07-21 | Alpena | Michigan | 26007 | 125 | 13 |
355068 | 355068 | 2020-07-21 | Antrim | Michigan | 26009 | 30 | 0 |
355069 | 355069 | 2020-07-21 | Arenac | Michigan | 26011 | 39 | 2 |
355070 | 355070 | 2020-07-21 | Baraga | Michigan | 26013 | 5 | 0 |
355071 | 355071 | 2020-07-21 | Barry | Michigan | 26015 | 156 | 2 |
355072 | 355072 | 2020-07-21 | Bay | Michigan | 26017 | 484 | 31 |
355073 | 355073 | 2020-07-21 | Benzie | Michigan | 26019 | 24 | 1 |
355074 | 355074 | 2020-07-21 | Berrien | Michigan | 26021 | 1207 | 61 |
355075 | 355075 | 2020-07-21 | Branch | Michigan | 26023 | 1089 | 25 |
355076 | 355076 | 2020-07-21 | Calhoun | Michigan | 26025 | 670 | 39 |
355077 | 355077 | 2020-07-21 | Cass | Michigan | 26027 | 230 | 8 |
355078 | 355078 | 2020-07-21 | Charlevoix | Michigan | 26029 | 44 | 2 |
355079 | 355079 | 2020-07-21 | Cheboygan | Michigan | 26031 | 31 | 2 |
355080 | 355080 | 2020-07-21 | Chippewa | Michigan | 26033 | 26 | 0 |
355081 | 355081 | 2020-07-21 | Clare | Michigan | 26035 | 39 | 3 |
355082 | 355082 | 2020-07-21 | Clinton | Michigan | 26037 | 332 | 12 |
355083 | 355083 | 2020-07-21 | Crawford | Michigan | 26039 | 90 | 5 |
355084 | 355084 | 2020-07-21 | Delta | Michigan | 26041 | 52 | 3 |
355085 | 355085 | 2020-07-21 | Dickinson | Michigan | 26043 | 35 | 2 |
355086 | 355086 | 2020-07-21 | Eaton | Michigan | 26045 | 389 | 7 |
355087 | 355087 | 2020-07-21 | Emmet | Michigan | 26047 | 49 | 2 |
355088 | 355088 | 2020-07-21 | Genesee | Michigan | 26049 | 3154 | 293 |
355089 | 355089 | 2020-07-21 | Gladwin | Michigan | 26051 | 30 | 2 |
355090 | 355090 | 2020-07-21 | Gogebic | Michigan | 26053 | 45 | 1 |
355091 | 355091 | 2020-07-21 | Grand Traverse | Michigan | 26055 | 139 | 5 |
355092 | 355092 | 2020-07-21 | Gratiot | Michigan | 26057 | 126 | 15 |
355093 | 355093 | 2020-07-21 | Hillsdale | Michigan | 26059 | 218 | 25 |
355094 | 355094 | 2020-07-21 | Houghton | Michigan | 26061 | 37 | 0 |
355095 | 355095 | 2020-07-21 | Huron | Michigan | 26063 | 103 | 3 |
355096 | 355096 | 2020-07-21 | Ingham | Michigan | 26065 | 1301 | 29 |
355097 | 355097 | 2020-07-21 | Ionia | Michigan | 26067 | 244 | 5 |
355098 | 355098 | 2020-07-21 | Iosco | Michigan | 26069 | 123 | 11 |
355099 | 355099 | 2020-07-21 | Iron | Michigan | 26071 | 10 | 1 |
355100 | 355100 | 2020-07-21 | Isabella | Michigan | 26073 | 185 | 8 |
355101 | 355101 | 2020-07-21 | Jackson | Michigan | 26075 | 2204 | 54 |
355102 | 355102 | 2020-07-21 | Kalamazoo | Michigan | 26077 | 1351 | 74 |
355103 | 355103 | 2020-07-21 | Kalkaska | Michigan | 26079 | 46 | 4 |
355104 | 355104 | 2020-07-21 | Kent | Michigan | 26081 | 6430 | 149 |
355105 | 355105 | 2020-07-21 | Keweenaw | Michigan | 26083 | 2 | 0 |
355106 | 355106 | 2020-07-21 | Lake | Michigan | 26085 | 14 | 0 |
355107 | 355107 | 2020-07-21 | Lapeer | Michigan | 26087 | 648 | 39 |
355108 | 355108 | 2020-07-21 | Leelanau | Michigan | 26089 | 55 | 0 |
355109 | 355109 | 2020-07-21 | Lenawee | Michigan | 26091 | 1058 | 15 |
355110 | 355110 | 2020-07-21 | Livingston | Michigan | 26093 | 723 | 29 |
355111 | 355111 | 2020-07-21 | Luce | Michigan | 26095 | 4 | 0 |
355112 | 355112 | 2020-07-21 | Mackinac | Michigan | 26097 | 10 | 0 |
355113 | 355113 | 2020-07-21 | Macomb | Michigan | 26099 | 8744 | 941 |
355114 | 355114 | 2020-07-21 | Manistee | Michigan | 26101 | 43 | 0 |
355115 | 355115 | 2020-07-21 | Marquette | Michigan | 26103 | 107 | 11 |
355116 | 355116 | 2020-07-21 | Mason | Michigan | 26105 | 92 | 0 |
355117 | 355117 | 2020-07-21 | Mecosta | Michigan | 26107 | 46 | 2 |
355118 | 355118 | 2020-07-21 | Menominee | Michigan | 26109 | 58 | 0 |
355119 | 355119 | 2020-07-21 | Midland | Michigan | 26111 | 236 | 9 |
355120 | 355120 | 2020-07-21 | Missaukee | Michigan | 26113 | 40 | 1 |
355121 | 355121 | 2020-07-21 | Monroe | Michigan | 26115 | 747 | 21 |
355122 | 355122 | 2020-07-21 | Montcalm | Michigan | 26117 | 159 | 1 |
355123 | 355123 | 2020-07-21 | Montmorency | Michigan | 26119 | 7 | 0 |
355124 | 355124 | 2020-07-21 | Muskegon | Michigan | 26121 | 1046 | 55 |
355125 | 355125 | 2020-07-21 | Newaygo | Michigan | 26123 | 230 | 0 |
355126 | 355126 | 2020-07-21 | Oakland | Michigan | 26125 | 13492 | 1119 |
355127 | 355127 | 2020-07-21 | Oceana | Michigan | 26127 | 444 | 5 |
355128 | 355128 | 2020-07-21 | Ogemaw | Michigan | 26129 | 47 | 2 |
355129 | 355129 | 2020-07-21 | Ontonagon | Michigan | 26131 | 1 | 0 |
355130 | 355130 | 2020-07-21 | Osceola | Michigan | 26133 | 63 | 0 |
355131 | 355131 | 2020-07-21 | Oscoda | Michigan | 26135 | 23 | 1 |
355132 | 355132 | 2020-07-21 | Otsego | Michigan | 26137 | 139 | 10 |
355133 | 355133 | 2020-07-21 | Ottawa | Michigan | 26139 | 1531 | 53 |
355134 | 355134 | 2020-07-21 | Presque Isle | Michigan | 26141 | 14 | 0 |
355135 | 355135 | 2020-07-21 | Roscommon | Michigan | 26143 | 44 | 0 |
355136 | 355136 | 2020-07-21 | Saginaw | Michigan | 26145 | 1606 | 125 |
355137 | 355137 | 2020-07-21 | Sanilac | Michigan | 26151 | 81 | 6 |
355138 | 355138 | 2020-07-21 | Schoolcraft | Michigan | 26153 | 8 | 0 |
355139 | 355139 | 2020-07-21 | Shiawassee | Michigan | 26155 | 296 | 28 |
355140 | 355140 | 2020-07-21 | St. Clair | Michigan | 26147 | 662 | 53 |
355141 | 355141 | 2020-07-21 | St. Joseph | Michigan | 26149 | 453 | 6 |
355142 | 355142 | 2020-07-21 | Tuscola | Michigan | 26157 | 254 | 27 |
355143 | 355143 | 2020-07-21 | Unknown | Michigan | 145 | 2 | |
355144 | 355144 | 2020-07-21 | Van Buren | Michigan | 26159 | 313 | 9 |
355145 | 355145 | 2020-07-21 | Washtenaw | Michigan | 26161 | 2645 | 120 |
355146 | 355146 | 2020-07-21 | Wayne | Michigan | 26163 | 25434 | 2784 |
355147 | 355147 | 2020-07-21 | Wexford | Michigan | 26165 | 57 | 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);