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-16 and state = "Michigan" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
339065 | 339065 | 2020-07-16 | Alcona | Michigan | 26001 | 24 | 1 |
339066 | 339066 | 2020-07-16 | Alger | Michigan | 26003 | 4 | 0 |
339067 | 339067 | 2020-07-16 | Allegan | Michigan | 26005 | 404 | 7 |
339068 | 339068 | 2020-07-16 | Alpena | Michigan | 26007 | 124 | 13 |
339069 | 339069 | 2020-07-16 | Antrim | Michigan | 26009 | 27 | 0 |
339070 | 339070 | 2020-07-16 | Arenac | Michigan | 26011 | 38 | 2 |
339071 | 339071 | 2020-07-16 | Baraga | Michigan | 26013 | 5 | 0 |
339072 | 339072 | 2020-07-16 | Barry | Michigan | 26015 | 145 | 2 |
339073 | 339073 | 2020-07-16 | Bay | Michigan | 26017 | 455 | 31 |
339074 | 339074 | 2020-07-16 | Benzie | Michigan | 26019 | 17 | 1 |
339075 | 339075 | 2020-07-16 | Berrien | Michigan | 26021 | 1117 | 61 |
339076 | 339076 | 2020-07-16 | Branch | Michigan | 26023 | 1082 | 25 |
339077 | 339077 | 2020-07-16 | Calhoun | Michigan | 26025 | 636 | 39 |
339078 | 339078 | 2020-07-16 | Cass | Michigan | 26027 | 210 | 7 |
339079 | 339079 | 2020-07-16 | Charlevoix | Michigan | 26029 | 43 | 2 |
339080 | 339080 | 2020-07-16 | Cheboygan | Michigan | 26031 | 29 | 2 |
339081 | 339081 | 2020-07-16 | Chippewa | Michigan | 26033 | 24 | 0 |
339082 | 339082 | 2020-07-16 | Clare | Michigan | 26035 | 35 | 3 |
339083 | 339083 | 2020-07-16 | Clinton | Michigan | 26037 | 314 | 12 |
339084 | 339084 | 2020-07-16 | Crawford | Michigan | 26039 | 84 | 5 |
339085 | 339085 | 2020-07-16 | Delta | Michigan | 26041 | 42 | 3 |
339086 | 339086 | 2020-07-16 | Dickinson | Michigan | 26043 | 27 | 2 |
339087 | 339087 | 2020-07-16 | Eaton | Michigan | 26045 | 363 | 7 |
339088 | 339088 | 2020-07-16 | Emmet | Michigan | 26047 | 46 | 2 |
339089 | 339089 | 2020-07-16 | Genesee | Michigan | 26049 | 3005 | 292 |
339090 | 339090 | 2020-07-16 | Gladwin | Michigan | 26051 | 29 | 1 |
339091 | 339091 | 2020-07-16 | Gogebic | Michigan | 26053 | 21 | 1 |
339092 | 339092 | 2020-07-16 | Grand Traverse | Michigan | 26055 | 114 | 5 |
339093 | 339093 | 2020-07-16 | Gratiot | Michigan | 26057 | 116 | 14 |
339094 | 339094 | 2020-07-16 | Hillsdale | Michigan | 26059 | 215 | 25 |
339095 | 339095 | 2020-07-16 | Houghton | Michigan | 26061 | 32 | 0 |
339096 | 339096 | 2020-07-16 | Huron | Michigan | 26063 | 93 | 3 |
339097 | 339097 | 2020-07-16 | Ingham | Michigan | 26065 | 1242 | 29 |
339098 | 339098 | 2020-07-16 | Ionia | Michigan | 26067 | 231 | 5 |
339099 | 339099 | 2020-07-16 | Iosco | Michigan | 26069 | 122 | 11 |
339100 | 339100 | 2020-07-16 | Iron | Michigan | 26071 | 8 | 1 |
339101 | 339101 | 2020-07-16 | Isabella | Michigan | 26073 | 180 | 8 |
339102 | 339102 | 2020-07-16 | Jackson | Michigan | 26075 | 2173 | 54 |
339103 | 339103 | 2020-07-16 | Kalamazoo | Michigan | 26077 | 1277 | 72 |
339104 | 339104 | 2020-07-16 | Kalkaska | Michigan | 26079 | 43 | 3 |
339105 | 339105 | 2020-07-16 | Kent | Michigan | 26081 | 6130 | 145 |
339106 | 339106 | 2020-07-16 | Keweenaw | Michigan | 26083 | 2 | 0 |
339107 | 339107 | 2020-07-16 | Lake | Michigan | 26085 | 13 | 0 |
339108 | 339108 | 2020-07-16 | Lapeer | Michigan | 26087 | 641 | 39 |
339109 | 339109 | 2020-07-16 | Leelanau | Michigan | 26089 | 49 | 0 |
339110 | 339110 | 2020-07-16 | Lenawee | Michigan | 26091 | 1021 | 15 |
339111 | 339111 | 2020-07-16 | Livingston | Michigan | 26093 | 691 | 29 |
339112 | 339112 | 2020-07-16 | Luce | Michigan | 26095 | 4 | 0 |
339113 | 339113 | 2020-07-16 | Mackinac | Michigan | 26097 | 9 | 0 |
339114 | 339114 | 2020-07-16 | Macomb | Michigan | 26099 | 8378 | 937 |
339115 | 339115 | 2020-07-16 | Manistee | Michigan | 26101 | 40 | 0 |
339116 | 339116 | 2020-07-16 | Marquette | Michigan | 26103 | 100 | 11 |
339117 | 339117 | 2020-07-16 | Mason | Michigan | 26105 | 79 | 0 |
339118 | 339118 | 2020-07-16 | Mecosta | Michigan | 26107 | 43 | 2 |
339119 | 339119 | 2020-07-16 | Menominee | Michigan | 26109 | 53 | 0 |
339120 | 339120 | 2020-07-16 | Midland | Michigan | 26111 | 217 | 9 |
339121 | 339121 | 2020-07-16 | Missaukee | Michigan | 26113 | 37 | 1 |
339122 | 339122 | 2020-07-16 | Monroe | Michigan | 26115 | 706 | 23 |
339123 | 339123 | 2020-07-16 | Montcalm | Michigan | 26117 | 137 | 1 |
339124 | 339124 | 2020-07-16 | Montmorency | Michigan | 26119 | 8 | 0 |
339125 | 339125 | 2020-07-16 | Muskegon | Michigan | 26121 | 979 | 54 |
339126 | 339126 | 2020-07-16 | Newaygo | Michigan | 26123 | 205 | 0 |
339127 | 339127 | 2020-07-16 | Oakland | Michigan | 26125 | 13171 | 1113 |
339128 | 339128 | 2020-07-16 | Oceana | Michigan | 26127 | 417 | 5 |
339129 | 339129 | 2020-07-16 | Ogemaw | Michigan | 26129 | 46 | 2 |
339130 | 339130 | 2020-07-16 | Ontonagon | Michigan | 26131 | 1 | 0 |
339131 | 339131 | 2020-07-16 | Osceola | Michigan | 26133 | 57 | 0 |
339132 | 339132 | 2020-07-16 | Oscoda | Michigan | 26135 | 23 | 1 |
339133 | 339133 | 2020-07-16 | Otsego | Michigan | 26137 | 138 | 10 |
339134 | 339134 | 2020-07-16 | Ottawa | Michigan | 26139 | 1400 | 53 |
339135 | 339135 | 2020-07-16 | Presque Isle | Michigan | 26141 | 14 | 0 |
339136 | 339136 | 2020-07-16 | Roscommon | Michigan | 26143 | 41 | 0 |
339137 | 339137 | 2020-07-16 | Saginaw | Michigan | 26145 | 1488 | 125 |
339138 | 339138 | 2020-07-16 | Sanilac | Michigan | 26151 | 60 | 6 |
339139 | 339139 | 2020-07-16 | Schoolcraft | Michigan | 26153 | 7 | 0 |
339140 | 339140 | 2020-07-16 | Shiawassee | Michigan | 26155 | 288 | 28 |
339141 | 339141 | 2020-07-16 | St. Clair | Michigan | 26147 | 628 | 53 |
339142 | 339142 | 2020-07-16 | St. Joseph | Michigan | 26149 | 417 | 5 |
339143 | 339143 | 2020-07-16 | Tuscola | Michigan | 26157 | 247 | 27 |
339144 | 339144 | 2020-07-16 | Unknown | Michigan | 157 | 2 | |
339145 | 339145 | 2020-07-16 | Van Buren | Michigan | 26159 | 287 | 9 |
339146 | 339146 | 2020-07-16 | Washtenaw | Michigan | 26161 | 2511 | 119 |
339147 | 339147 | 2020-07-16 | Wayne | Michigan | 26163 | 24784 | 2772 |
339148 | 339148 | 2020-07-16 | 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);