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 2022-03-08 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2286006 | 2286006 | 2022-03-08 | Alcona | Michigan | 26001 | 1716 | 68 |
2286007 | 2286007 | 2022-03-08 | Alger | Michigan | 26003 | 1850 | 13 |
2286008 | 2286008 | 2022-03-08 | Allegan | Michigan | 26005 | 26894 | 333 |
2286009 | 2286009 | 2022-03-08 | Alpena | Michigan | 26007 | 5556 | 133 |
2286010 | 2286010 | 2022-03-08 | Antrim | Michigan | 26009 | 4277 | 61 |
2286011 | 2286011 | 2022-03-08 | Arenac | Michigan | 26011 | 3185 | 63 |
2286012 | 2286012 | 2022-03-08 | Baraga | Michigan | 26013 | 2191 | 54 |
2286013 | 2286013 | 2022-03-08 | Barry | Michigan | 26015 | 14207 | 160 |
2286014 | 2286014 | 2022-03-08 | Bay | Michigan | 26017 | 26892 | 564 |
2286015 | 2286015 | 2022-03-08 | Benzie | Michigan | 26019 | 3394 | 64 |
2286016 | 2286016 | 2022-03-08 | Berrien | Michigan | 26021 | 34441 | 529 |
2286017 | 2286017 | 2022-03-08 | Branch | Michigan | 26023 | 12085 | 197 |
2286018 | 2286018 | 2022-03-08 | Calhoun | Michigan | 26025 | 33776 | 557 |
2286019 | 2286019 | 2022-03-08 | Cass | Michigan | 26027 | 11049 | 137 |
2286020 | 2286020 | 2022-03-08 | Charlevoix | Michigan | 26029 | 4887 | 59 |
2286021 | 2286021 | 2022-03-08 | Cheboygan | Michigan | 26031 | 4562 | 100 |
2286022 | 2286022 | 2022-03-08 | Chippewa | Michigan | 26033 | 11515 | 112 |
2286023 | 2286023 | 2022-03-08 | Clare | Michigan | 26035 | 6701 | 153 |
2286024 | 2286024 | 2022-03-08 | Clinton | Michigan | 26037 | 20969 | 201 |
2286025 | 2286025 | 2022-03-08 | Crawford | Michigan | 26039 | 2540 | 29 |
2286026 | 2286026 | 2022-03-08 | Delta | Michigan | 26041 | 9894 | 153 |
2286027 | 2286027 | 2022-03-08 | Dickinson | Michigan | 26043 | 7359 | 106 |
2286028 | 2286028 | 2022-03-08 | Eaton | Michigan | 26045 | 26496 | 387 |
2286029 | 2286029 | 2022-03-08 | Emmet | Michigan | 26047 | 6341 | 84 |
2286030 | 2286030 | 2022-03-08 | Genesee | Michigan | 26049 | 100332 | 1675 |
2286031 | 2286031 | 2022-03-08 | Gladwin | Michigan | 26051 | 5553 | 109 |
2286032 | 2286032 | 2022-03-08 | Gogebic | Michigan | 26053 | 3241 | 68 |
2286033 | 2286033 | 2022-03-08 | Grand Traverse | Michigan | 26055 | 17002 | 219 |
2286034 | 2286034 | 2022-03-08 | Gratiot | Michigan | 26057 | 13532 | 181 |
2286035 | 2286035 | 2022-03-08 | Hillsdale | Michigan | 26059 | 10272 | 194 |
2286036 | 2286036 | 2022-03-08 | Houghton | Michigan | 26061 | 7705 | 89 |
2286037 | 2286037 | 2022-03-08 | Huron | Michigan | 26063 | 7991 | 144 |
2286038 | 2286038 | 2022-03-08 | Ingham | Michigan | 26065 | 63288 | 734 |
2286039 | 2286039 | 2022-03-08 | Ionia | Michigan | 26067 | 19388 | 174 |
2286040 | 2286040 | 2022-03-08 | Iosco | Michigan | 26069 | 4772 | 135 |
2286041 | 2286041 | 2022-03-08 | Iron | Michigan | 26071 | 2637 | 85 |
2286042 | 2286042 | 2022-03-08 | Isabella | Michigan | 26073 | 15454 | 199 |
2286043 | 2286043 | 2022-03-08 | Jackson | Michigan | 26075 | 44318 | 559 |
2286044 | 2286044 | 2022-03-08 | Kalamazoo | Michigan | 26077 | 58492 | 656 |
2286045 | 2286045 | 2022-03-08 | Kalkaska | Michigan | 26079 | 3496 | 57 |
2286046 | 2286046 | 2022-03-08 | Kent | Michigan | 26081 | 165295 | 1480 |
2286047 | 2286047 | 2022-03-08 | Keweenaw | Michigan | 26083 | 504 | 13 |
2286048 | 2286048 | 2022-03-08 | Lake | Michigan | 26085 | 1831 | 35 |
2286049 | 2286049 | 2022-03-08 | Lapeer | Michigan | 26087 | 20666 | 416 |
2286050 | 2286050 | 2022-03-08 | Leelanau | Michigan | 26089 | 3541 | 50 |
2286051 | 2286051 | 2022-03-08 | Lenawee | Michigan | 26091 | 25753 | 316 |
2286052 | 2286052 | 2022-03-08 | Livingston | Michigan | 26093 | 45467 | 435 |
2286053 | 2286053 | 2022-03-08 | Luce | Michigan | 26095 | 2277 | 10 |
2286054 | 2286054 | 2022-03-08 | Mackinac | Michigan | 26097 | 2371 | 29 |
2286055 | 2286055 | 2022-03-08 | Macomb | Michigan | 26099 | 226074 | 3847 |
2286056 | 2286056 | 2022-03-08 | Manistee | Michigan | 26101 | 4431 | 84 |
2286057 | 2286057 | 2022-03-08 | Marquette | Michigan | 26103 | 15706 | 122 |
2286058 | 2286058 | 2022-03-08 | Mason | Michigan | 26105 | 6661 | 86 |
2286059 | 2286059 | 2022-03-08 | Mecosta | Michigan | 26107 | 8596 | 105 |
2286060 | 2286060 | 2022-03-08 | Menominee | Michigan | 26109 | 5551 | 69 |
2286061 | 2286061 | 2022-03-08 | Midland | Michigan | 26111 | 18931 | 219 |
2286062 | 2286062 | 2022-03-08 | Missaukee | Michigan | 26113 | 2886 | 59 |
2286063 | 2286063 | 2022-03-08 | Monroe | Michigan | 26115 | 37637 | 456 |
2286064 | 2286064 | 2022-03-08 | Montcalm | Michigan | 26117 | 17051 | 205 |
2286065 | 2286065 | 2022-03-08 | Montmorency | Michigan | 26119 | 1700 | 47 |
2286066 | 2286066 | 2022-03-08 | Muskegon | Michigan | 26121 | 41439 | 628 |
2286067 | 2286067 | 2022-03-08 | Newaygo | Michigan | 26123 | 11401 | 153 |
2286068 | 2286068 | 2022-03-08 | Oakland | Michigan | 26125 | 282960 | 3722 |
2286069 | 2286069 | 2022-03-08 | Oceana | Michigan | 26127 | 6271 | 89 |
2286070 | 2286070 | 2022-03-08 | Ogemaw | Michigan | 26129 | 4292 | 99 |
2286071 | 2286071 | 2022-03-08 | Ontonagon | Michigan | 26131 | 970 | 36 |
2286072 | 2286072 | 2022-03-08 | Osceola | Michigan | 26133 | 4953 | 77 |
2286073 | 2286073 | 2022-03-08 | Oscoda | Michigan | 26135 | 1425 | 54 |
2286074 | 2286074 | 2022-03-08 | Otsego | Michigan | 26137 | 5589 | 96 |
2286075 | 2286075 | 2022-03-08 | Ottawa | Michigan | 26139 | 74177 | 771 |
2286076 | 2286076 | 2022-03-08 | Presque Isle | Michigan | 26141 | 2056 | 55 |
2286077 | 2286077 | 2022-03-08 | Roscommon | Michigan | 26143 | 4583 | 110 |
2286078 | 2286078 | 2022-03-08 | Saginaw | Michigan | 26145 | 50135 | 924 |
2286079 | 2286079 | 2022-03-08 | Sanilac | Michigan | 26151 | 8633 | 184 |
2286080 | 2286080 | 2022-03-08 | Schoolcraft | Michigan | 26153 | 1745 | 15 |
2286081 | 2286081 | 2022-03-08 | Shiawassee | Michigan | 26155 | 17671 | 225 |
2286082 | 2286082 | 2022-03-08 | St. Clair | Michigan | 26147 | 40162 | 807 |
2286083 | 2286083 | 2022-03-08 | St. Joseph | Michigan | 26149 | 13596 | 199 |
2286084 | 2286084 | 2022-03-08 | Tuscola | Michigan | 26157 | 13162 | 271 |
2286085 | 2286085 | 2022-03-08 | Unknown | Michigan | 11957 | 33 | |
2286086 | 2286086 | 2022-03-08 | Van Buren | Michigan | 26159 | 16884 | 262 |
2286087 | 2286087 | 2022-03-08 | Washtenaw | Michigan | 26161 | 73947 | 512 |
2286088 | 2286088 | 2022-03-08 | Wayne | Michigan | 26163 | 393852 | 7715 |
2286089 | 2286089 | 2022-03-08 | Wexford | Michigan | 26165 | 6996 | 104 |
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);