ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-09" 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 |
---|---|---|---|---|---|---|---|
1899090 | 1899090 | 2021-11-09 | Alcona | Michigan | 26001 | 1199 | 44 |
1899091 | 1899091 | 2021-11-09 | Alger | Michigan | 26003 | 1031 | 9 |
1899092 | 1899092 | 2021-11-09 | Allegan | Michigan | 26005 | 15630 | 201 |
1899093 | 1899093 | 2021-11-09 | Alpena | Michigan | 26007 | 3441 | 73 |
1899094 | 1899094 | 2021-11-09 | Antrim | Michigan | 26009 | 2541 | 38 |
1899095 | 1899095 | 2021-11-09 | Arenac | Michigan | 26011 | 1903 | 37 |
1899096 | 1899096 | 2021-11-09 | Baraga | Michigan | 26013 | 1422 | 47 |
1899097 | 1899097 | 2021-11-09 | Barry | Michigan | 26015 | 8325 | 92 |
1899098 | 1899098 | 2021-11-09 | Bay | Michigan | 26017 | 15601 | 399 |
1899099 | 1899099 | 2021-11-09 | Benzie | Michigan | 26019 | 1768 | 40 |
1899100 | 1899100 | 2021-11-09 | Berrien | Michigan | 26021 | 19904 | 333 |
1899101 | 1899101 | 2021-11-09 | Branch | Michigan | 26023 | 7645 | 137 |
1899102 | 1899102 | 2021-11-09 | Calhoun | Michigan | 26025 | 19554 | 360 |
1899103 | 1899103 | 2021-11-09 | Cass | Michigan | 26027 | 7361 | 93 |
1899104 | 1899104 | 2021-11-09 | Charlevoix | Michigan | 26029 | 2706 | 38 |
1899105 | 1899105 | 2021-11-09 | Cheboygan | Michigan | 26031 | 3012 | 68 |
1899106 | 1899106 | 2021-11-09 | Chippewa | Michigan | 26033 | 7109 | 68 |
1899107 | 1899107 | 2021-11-09 | Clare | Michigan | 26035 | 4073 | 107 |
1899108 | 1899108 | 2021-11-09 | Clinton | Michigan | 26037 | 10751 | 118 |
1899109 | 1899109 | 2021-11-09 | Crawford | Michigan | 26039 | 1468 | 17 |
1899110 | 1899110 | 2021-11-09 | Delta | Michigan | 26041 | 6042 | 111 |
1899111 | 1899111 | 2021-11-09 | Dickinson | Michigan | 26043 | 4144 | 84 |
1899112 | 1899112 | 2021-11-09 | Eaton | Michigan | 26045 | 13967 | 249 |
1899113 | 1899113 | 2021-11-09 | Emmet | Michigan | 26047 | 3622 | 51 |
1899114 | 1899114 | 2021-11-09 | Genesee | Michigan | 26049 | 54552 | 1107 |
1899115 | 1899115 | 2021-11-09 | Gladwin | Michigan | 26051 | 3462 | 77 |
1899116 | 1899116 | 2021-11-09 | Gogebic | Michigan | 26053 | 1874 | 54 |
1899117 | 1899117 | 2021-11-09 | Grand Traverse | Michigan | 26055 | 9463 | 121 |
1899118 | 1899118 | 2021-11-09 | Gratiot | Michigan | 26057 | 9146 | 134 |
1899119 | 1899119 | 2021-11-09 | Hillsdale | Michigan | 26059 | 6481 | 130 |
1899120 | 1899120 | 2021-11-09 | Houghton | Michigan | 26061 | 4459 | 56 |
1899121 | 1899121 | 2021-11-09 | Huron | Michigan | 26063 | 5100 | 96 |
1899122 | 1899122 | 2021-11-09 | Ingham | Michigan | 26065 | 32467 | 461 |
1899123 | 1899123 | 2021-11-09 | Ionia | Michigan | 26067 | 12307 | 111 |
1899124 | 1899124 | 2021-11-09 | Iosco | Michigan | 26069 | 3208 | 98 |
1899125 | 1899125 | 2021-11-09 | Iron | Michigan | 26071 | 1509 | 59 |
1899126 | 1899126 | 2021-11-09 | Isabella | Michigan | 26073 | 9506 | 135 |
1899127 | 1899127 | 2021-11-09 | Jackson | Michigan | 26075 | 27376 | 376 |
1899128 | 1899128 | 2021-11-09 | Kalamazoo | Michigan | 26077 | 31026 | 467 |
1899129 | 1899129 | 2021-11-09 | Kalkaska | Michigan | 26079 | 1879 | 40 |
1899130 | 1899130 | 2021-11-09 | Kent | Michigan | 26081 | 97462 | 1015 |
1899131 | 1899131 | 2021-11-09 | Keweenaw | Michigan | 26083 | 289 | 5 |
1899132 | 1899132 | 2021-11-09 | Lake | Michigan | 26085 | 1020 | 22 |
1899133 | 1899133 | 2021-11-09 | Lapeer | Michigan | 26087 | 12559 | 261 |
1899134 | 1899134 | 2021-11-09 | Leelanau | Michigan | 26089 | 1755 | 25 |
1899135 | 1899135 | 2021-11-09 | Lenawee | Michigan | 26091 | 15441 | 210 |
1899136 | 1899136 | 2021-11-09 | Livingston | Michigan | 26093 | 24591 | 249 |
1899137 | 1899137 | 2021-11-09 | Luce | Michigan | 26095 | 1625 | 6 |
1899138 | 1899138 | 2021-11-09 | Mackinac | Michigan | 26097 | 1349 | 12 |
1899139 | 1899139 | 2021-11-09 | Macomb | Michigan | 26099 | 126411 | 2741 |
1899140 | 1899140 | 2021-11-09 | Manistee | Michigan | 26101 | 2621 | 40 |
1899141 | 1899141 | 2021-11-09 | Marquette | Michigan | 26103 | 8393 | 82 |
1899142 | 1899142 | 2021-11-09 | Mason | Michigan | 26105 | 3396 | 48 |
1899143 | 1899143 | 2021-11-09 | Mecosta | Michigan | 26107 | 4982 | 53 |
1899144 | 1899144 | 2021-11-09 | Menominee | Michigan | 26109 | 3512 | 52 |
1899145 | 1899145 | 2021-11-09 | Midland | Michigan | 26111 | 10896 | 145 |
1899146 | 1899146 | 2021-11-09 | Missaukee | Michigan | 26113 | 1916 | 40 |
1899147 | 1899147 | 2021-11-09 | Monroe | Michigan | 26115 | 21490 | 310 |
1899148 | 1899148 | 2021-11-09 | Montcalm | Michigan | 26117 | 11294 | 138 |
1899149 | 1899149 | 2021-11-09 | Montmorency | Michigan | 26119 | 1059 | 29 |
1899150 | 1899150 | 2021-11-09 | Muskegon | Michigan | 26121 | 24657 | 432 |
1899151 | 1899151 | 2021-11-09 | Newaygo | Michigan | 26123 | 6927 | 85 |
1899152 | 1899152 | 2021-11-09 | Oakland | Michigan | 26125 | 151251 | 2711 |
1899153 | 1899153 | 2021-11-09 | Oceana | Michigan | 26127 | 3893 | 71 |
1899154 | 1899154 | 2021-11-09 | Ogemaw | Michigan | 26129 | 2826 | 62 |
1899155 | 1899155 | 2021-11-09 | Ontonagon | Michigan | 26131 | 651 | 22 |
1899156 | 1899156 | 2021-11-09 | Osceola | Michigan | 26133 | 3221 | 43 |
1899157 | 1899157 | 2021-11-09 | Oscoda | Michigan | 26135 | 1016 | 39 |
1899158 | 1899158 | 2021-11-09 | Otsego | Michigan | 26137 | 3511 | 61 |
1899159 | 1899159 | 2021-11-09 | Ottawa | Michigan | 26139 | 43452 | 514 |
1899160 | 1899160 | 2021-11-09 | Presque Isle | Michigan | 26141 | 1450 | 39 |
1899161 | 1899161 | 2021-11-09 | Roscommon | Michigan | 26143 | 2765 | 67 |
1899162 | 1899162 | 2021-11-09 | Saginaw | Michigan | 26145 | 29739 | 690 |
1899163 | 1899163 | 2021-11-09 | Sanilac | Michigan | 26151 | 5225 | 139 |
1899164 | 1899164 | 2021-11-09 | Schoolcraft | Michigan | 26153 | 882 | 5 |
1899165 | 1899165 | 2021-11-09 | Shiawassee | Michigan | 26155 | 9256 | 133 |
1899166 | 1899166 | 2021-11-09 | St. Clair | Michigan | 26147 | 23381 | 527 |
1899167 | 1899167 | 2021-11-09 | St. Joseph | Michigan | 26149 | 8833 | 121 |
1899168 | 1899168 | 2021-11-09 | Tuscola | Michigan | 26157 | 7798 | 202 |
1899169 | 1899169 | 2021-11-09 | Unknown | Michigan | 1229 | 14 | |
1899170 | 1899170 | 2021-11-09 | Van Buren | Michigan | 26159 | 9684 | 166 |
1899171 | 1899171 | 2021-11-09 | Washtenaw | Michigan | 26161 | 35345 | 340 |
1899172 | 1899172 | 2021-11-09 | Wayne | Michigan | 26163 | 206233 | 5644 |
1899173 | 1899173 | 2021-11-09 | Wexford | Michigan | 26165 | 3932 | 57 |
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);