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 2021-11-05 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1886090 | 1886090 | 2021-11-05 | Alcona | Michigan | 26001 | 1187 | 44 |
1886091 | 1886091 | 2021-11-05 | Alger | Michigan | 26003 | 1025 | 9 |
1886092 | 1886092 | 2021-11-05 | Allegan | Michigan | 26005 | 15467 | 199 |
1886093 | 1886093 | 2021-11-05 | Alpena | Michigan | 26007 | 3380 | 73 |
1886094 | 1886094 | 2021-11-05 | Antrim | Michigan | 26009 | 2496 | 38 |
1886095 | 1886095 | 2021-11-05 | Arenac | Michigan | 26011 | 1886 | 36 |
1886096 | 1886096 | 2021-11-05 | Baraga | Michigan | 26013 | 1411 | 47 |
1886097 | 1886097 | 2021-11-05 | Barry | Michigan | 26015 | 8250 | 91 |
1886098 | 1886098 | 2021-11-05 | Bay | Michigan | 26017 | 15489 | 397 |
1886099 | 1886099 | 2021-11-05 | Benzie | Michigan | 26019 | 1739 | 40 |
1886100 | 1886100 | 2021-11-05 | Berrien | Michigan | 26021 | 19813 | 333 |
1886101 | 1886101 | 2021-11-05 | Branch | Michigan | 26023 | 7596 | 137 |
1886102 | 1886102 | 2021-11-05 | Calhoun | Michigan | 26025 | 19429 | 359 |
1886103 | 1886103 | 2021-11-05 | Cass | Michigan | 26027 | 7320 | 93 |
1886104 | 1886104 | 2021-11-05 | Charlevoix | Michigan | 26029 | 2663 | 38 |
1886105 | 1886105 | 2021-11-05 | Cheboygan | Michigan | 26031 | 2991 | 68 |
1886106 | 1886106 | 2021-11-05 | Chippewa | Michigan | 26033 | 7062 | 68 |
1886107 | 1886107 | 2021-11-05 | Clare | Michigan | 26035 | 4023 | 106 |
1886108 | 1886108 | 2021-11-05 | Clinton | Michigan | 26037 | 10606 | 114 |
1886109 | 1886109 | 2021-11-05 | Crawford | Michigan | 26039 | 1457 | 17 |
1886110 | 1886110 | 2021-11-05 | Delta | Michigan | 26041 | 6003 | 110 |
1886111 | 1886111 | 2021-11-05 | Dickinson | Michigan | 26043 | 4121 | 84 |
1886112 | 1886112 | 2021-11-05 | Eaton | Michigan | 26045 | 13793 | 249 |
1886113 | 1886113 | 2021-11-05 | Emmet | Michigan | 26047 | 3564 | 51 |
1886114 | 1886114 | 2021-11-05 | Genesee | Michigan | 26049 | 54081 | 1107 |
1886115 | 1886115 | 2021-11-05 | Gladwin | Michigan | 26051 | 3426 | 77 |
1886116 | 1886116 | 2021-11-05 | Gogebic | Michigan | 26053 | 1865 | 54 |
1886117 | 1886117 | 2021-11-05 | Grand Traverse | Michigan | 26055 | 9338 | 121 |
1886118 | 1886118 | 2021-11-05 | Gratiot | Michigan | 26057 | 9061 | 134 |
1886119 | 1886119 | 2021-11-05 | Hillsdale | Michigan | 26059 | 6439 | 130 |
1886120 | 1886120 | 2021-11-05 | Houghton | Michigan | 26061 | 4408 | 56 |
1886121 | 1886121 | 2021-11-05 | Huron | Michigan | 26063 | 5036 | 96 |
1886122 | 1886122 | 2021-11-05 | Ingham | Michigan | 26065 | 32163 | 461 |
1886123 | 1886123 | 2021-11-05 | Ionia | Michigan | 26067 | 12196 | 109 |
1886124 | 1886124 | 2021-11-05 | Iosco | Michigan | 26069 | 3179 | 98 |
1886125 | 1886125 | 2021-11-05 | Iron | Michigan | 26071 | 1486 | 58 |
1886126 | 1886126 | 2021-11-05 | Isabella | Michigan | 26073 | 9438 | 133 |
1886127 | 1886127 | 2021-11-05 | Jackson | Michigan | 26075 | 27134 | 376 |
1886128 | 1886128 | 2021-11-05 | Kalamazoo | Michigan | 26077 | 30816 | 467 |
1886129 | 1886129 | 2021-11-05 | Kalkaska | Michigan | 26079 | 1860 | 40 |
1886130 | 1886130 | 2021-11-05 | Kent | Michigan | 26081 | 96768 | 1010 |
1886131 | 1886131 | 2021-11-05 | Keweenaw | Michigan | 26083 | 277 | 5 |
1886132 | 1886132 | 2021-11-05 | Lake | Michigan | 26085 | 1015 | 22 |
1886133 | 1886133 | 2021-11-05 | Lapeer | Michigan | 26087 | 12475 | 261 |
1886134 | 1886134 | 2021-11-05 | Leelanau | Michigan | 26089 | 1730 | 26 |
1886135 | 1886135 | 2021-11-05 | Lenawee | Michigan | 26091 | 15303 | 208 |
1886136 | 1886136 | 2021-11-05 | Livingston | Michigan | 26093 | 24308 | 248 |
1886137 | 1886137 | 2021-11-05 | Luce | Michigan | 26095 | 1615 | 6 |
1886138 | 1886138 | 2021-11-05 | Mackinac | Michigan | 26097 | 1335 | 12 |
1886139 | 1886139 | 2021-11-05 | Macomb | Michigan | 26099 | 125652 | 2738 |
1886140 | 1886140 | 2021-11-05 | Manistee | Michigan | 26101 | 2601 | 39 |
1886141 | 1886141 | 2021-11-05 | Marquette | Michigan | 26103 | 8330 | 82 |
1886142 | 1886142 | 2021-11-05 | Mason | Michigan | 26105 | 3341 | 47 |
1886143 | 1886143 | 2021-11-05 | Mecosta | Michigan | 26107 | 4940 | 49 |
1886144 | 1886144 | 2021-11-05 | Menominee | Michigan | 26109 | 3479 | 51 |
1886145 | 1886145 | 2021-11-05 | Midland | Michigan | 26111 | 10766 | 143 |
1886146 | 1886146 | 2021-11-05 | Missaukee | Michigan | 26113 | 1907 | 40 |
1886147 | 1886147 | 2021-11-05 | Monroe | Michigan | 26115 | 21297 | 309 |
1886148 | 1886148 | 2021-11-05 | Montcalm | Michigan | 26117 | 11195 | 137 |
1886149 | 1886149 | 2021-11-05 | Montmorency | Michigan | 26119 | 1040 | 29 |
1886150 | 1886150 | 2021-11-05 | Muskegon | Michigan | 26121 | 24447 | 432 |
1886151 | 1886151 | 2021-11-05 | Newaygo | Michigan | 26123 | 6857 | 84 |
1886152 | 1886152 | 2021-11-05 | Oakland | Michigan | 26125 | 150362 | 2710 |
1886153 | 1886153 | 2021-11-05 | Oceana | Michigan | 26127 | 3848 | 71 |
1886154 | 1886154 | 2021-11-05 | Ogemaw | Michigan | 26129 | 2816 | 62 |
1886155 | 1886155 | 2021-11-05 | Ontonagon | Michigan | 26131 | 649 | 22 |
1886156 | 1886156 | 2021-11-05 | Osceola | Michigan | 26133 | 3201 | 41 |
1886157 | 1886157 | 2021-11-05 | Oscoda | Michigan | 26135 | 1005 | 39 |
1886158 | 1886158 | 2021-11-05 | Otsego | Michigan | 26137 | 3447 | 60 |
1886159 | 1886159 | 2021-11-05 | Ottawa | Michigan | 26139 | 43084 | 513 |
1886160 | 1886160 | 2021-11-05 | Presque Isle | Michigan | 26141 | 1431 | 39 |
1886161 | 1886161 | 2021-11-05 | Roscommon | Michigan | 26143 | 2736 | 67 |
1886162 | 1886162 | 2021-11-05 | Saginaw | Michigan | 26145 | 29495 | 689 |
1886163 | 1886163 | 2021-11-05 | Sanilac | Michigan | 26151 | 5167 | 139 |
1886164 | 1886164 | 2021-11-05 | Schoolcraft | Michigan | 26153 | 862 | 5 |
1886165 | 1886165 | 2021-11-05 | Shiawassee | Michigan | 26155 | 9145 | 132 |
1886166 | 1886166 | 2021-11-05 | St. Clair | Michigan | 26147 | 23124 | 527 |
1886167 | 1886167 | 2021-11-05 | St. Joseph | Michigan | 26149 | 8766 | 121 |
1886168 | 1886168 | 2021-11-05 | Tuscola | Michigan | 26157 | 7741 | 201 |
1886169 | 1886169 | 2021-11-05 | Unknown | Michigan | 1488 | 14 | |
1886170 | 1886170 | 2021-11-05 | Van Buren | Michigan | 26159 | 9635 | 166 |
1886171 | 1886171 | 2021-11-05 | Washtenaw | Michigan | 26161 | 35006 | 340 |
1886172 | 1886172 | 2021-11-05 | Wayne | Michigan | 26163 | 204921 | 5642 |
1886173 | 1886173 | 2021-11-05 | Wexford | Michigan | 26165 | 3883 | 55 |
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);