ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-05-05" 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 |
---|---|---|---|---|---|---|---|
1288525 | 1288525 | 2021-05-05 | Alcona | Michigan | 26001 | 710 | 28 |
1288526 | 1288526 | 2021-05-05 | Alger | Michigan | 26003 | 656 | 6 |
1288527 | 1288527 | 2021-05-05 | Allegan | Michigan | 26005 | 10491 | 132 |
1288528 | 1288528 | 2021-05-05 | Alpena | Michigan | 26007 | 2124 | 59 |
1288529 | 1288529 | 2021-05-05 | Antrim | Michigan | 26009 | 1559 | 27 |
1288530 | 1288530 | 2021-05-05 | Arenac | Michigan | 26011 | 1111 | 29 |
1288531 | 1288531 | 2021-05-05 | Baraga | Michigan | 26013 | 891 | 36 |
1288532 | 1288532 | 2021-05-05 | Barry | Michigan | 26015 | 5618 | 64 |
1288533 | 1288533 | 2021-05-05 | Bay | Michigan | 26017 | 10742 | 327 |
1288534 | 1288534 | 2021-05-05 | Benzie | Michigan | 26019 | 1235 | 33 |
1288535 | 1288535 | 2021-05-05 | Berrien | Michigan | 26021 | 14915 | 270 |
1288536 | 1288536 | 2021-05-05 | Branch | Michigan | 26023 | 5474 | 118 |
1288537 | 1288537 | 2021-05-05 | Calhoun | Michigan | 26025 | 13657 | 274 |
1288538 | 1288538 | 2021-05-05 | Cass | Michigan | 26027 | 5258 | 74 |
1288539 | 1288539 | 2021-05-05 | Charlevoix | Michigan | 26029 | 1592 | 20 |
1288540 | 1288540 | 2021-05-05 | Cheboygan | Michigan | 26031 | 1842 | 42 |
1288541 | 1288541 | 2021-05-05 | Chippewa | Michigan | 26033 | 5520 | 48 |
1288542 | 1288542 | 2021-05-05 | Clare | Michigan | 26035 | 2311 | 74 |
1288543 | 1288543 | 2021-05-05 | Clinton | Michigan | 26037 | 7342 | 83 |
1288544 | 1288544 | 2021-05-05 | Crawford | Michigan | 26039 | 940 | 13 |
1288545 | 1288545 | 2021-05-05 | Delta | Michigan | 26041 | 3891 | 88 |
1288546 | 1288546 | 2021-05-05 | Dickinson | Michigan | 26043 | 2689 | 74 |
1288547 | 1288547 | 2021-05-05 | Eaton | Michigan | 26045 | 9770 | 189 |
1288548 | 1288548 | 2021-05-05 | Emmet | Michigan | 26047 | 2279 | 41 |
1288549 | 1288549 | 2021-05-05 | Genesee | Michigan | 26049 | 40220 | 879 |
1288550 | 1288550 | 2021-05-05 | Gladwin | Michigan | 26051 | 2209 | 50 |
1288551 | 1288551 | 2021-05-05 | Gogebic | Michigan | 26053 | 1368 | 50 |
1288552 | 1288552 | 2021-05-05 | Grand Traverse | Michigan | 26055 | 6238 | 90 |
1288553 | 1288553 | 2021-05-05 | Gratiot | Michigan | 26057 | 6733 | 118 |
1288554 | 1288554 | 2021-05-05 | Hillsdale | Michigan | 26059 | 4203 | 87 |
1288555 | 1288555 | 2021-05-05 | Houghton | Michigan | 26061 | 3061 | 40 |
1288556 | 1288556 | 2021-05-05 | Huron | Michigan | 26063 | 3996 | 73 |
1288557 | 1288557 | 2021-05-05 | Ingham | Michigan | 26065 | 23917 | 354 |
1288558 | 1288558 | 2021-05-05 | Ionia | Michigan | 26067 | 8874 | 83 |
1288559 | 1288559 | 2021-05-05 | Iosco | Michigan | 26069 | 1878 | 70 |
1288560 | 1288560 | 2021-05-05 | Iron | Michigan | 26071 | 1019 | 51 |
1288561 | 1288561 | 2021-05-05 | Isabella | Michigan | 26073 | 5963 | 85 |
1288562 | 1288562 | 2021-05-05 | Jackson | Michigan | 26075 | 20219 | 292 |
1288563 | 1288563 | 2021-05-05 | Kalamazoo | Michigan | 26077 | 21998 | 364 |
1288564 | 1288564 | 2021-05-05 | Kalkaska | Michigan | 26079 | 1067 | 21 |
1288565 | 1288565 | 2021-05-05 | Kent | Michigan | 26081 | 69371 | 799 |
1288566 | 1288566 | 2021-05-05 | Keweenaw | Michigan | 26083 | 173 | 2 |
1288567 | 1288567 | 2021-05-05 | Lake | Michigan | 26085 | 594 | 15 |
1288568 | 1288568 | 2021-05-05 | Lapeer | Michigan | 26087 | 9351 | 187 |
1288569 | 1288569 | 2021-05-05 | Leelanau | Michigan | 26089 | 1207 | 18 |
1288570 | 1288570 | 2021-05-05 | Lenawee | Michigan | 26091 | 10476 | 159 |
1288571 | 1288571 | 2021-05-05 | Livingston | Michigan | 26093 | 16108 | 175 |
1288572 | 1288572 | 2021-05-05 | Luce | Michigan | 26095 | 1235 | 3 |
1288573 | 1288573 | 2021-05-05 | Mackinac | Michigan | 26097 | 628 | 3 |
1288574 | 1288574 | 2021-05-05 | Macomb | Michigan | 26099 | 96606 | 2284 |
1288575 | 1288575 | 2021-05-05 | Manistee | Michigan | 26101 | 1921 | 24 |
1288576 | 1288576 | 2021-05-05 | Marquette | Michigan | 26103 | 5804 | 59 |
1288577 | 1288577 | 2021-05-05 | Mason | Michigan | 26105 | 2040 | 35 |
1288578 | 1288578 | 2021-05-05 | Mecosta | Michigan | 26107 | 3019 | 30 |
1288579 | 1288579 | 2021-05-05 | Menominee | Michigan | 26109 | 2068 | 41 |
1288580 | 1288580 | 2021-05-05 | Midland | Michigan | 26111 | 7161 | 78 |
1288581 | 1288581 | 2021-05-05 | Missaukee | Michigan | 26113 | 1432 | 24 |
1288582 | 1288582 | 2021-05-05 | Monroe | Michigan | 26115 | 14764 | 243 |
1288583 | 1288583 | 2021-05-05 | Montcalm | Michigan | 26117 | 7665 | 110 |
1288584 | 1288584 | 2021-05-05 | Montmorency | Michigan | 26119 | 561 | 19 |
1288585 | 1288585 | 2021-05-05 | Muskegon | Michigan | 26121 | 17003 | 345 |
1288586 | 1288586 | 2021-05-05 | Newaygo | Michigan | 26123 | 4534 | 60 |
1288587 | 1288587 | 2021-05-05 | Oakland | Michigan | 26125 | 112680 | 2222 |
1288588 | 1288588 | 2021-05-05 | Oceana | Michigan | 26127 | 2635 | 55 |
1288589 | 1288589 | 2021-05-05 | Ogemaw | Michigan | 26129 | 1592 | 36 |
1288590 | 1288590 | 2021-05-05 | Ontonagon | Michigan | 26131 | 453 | 21 |
1288591 | 1288591 | 2021-05-05 | Osceola | Michigan | 26133 | 1826 | 27 |
1288592 | 1288592 | 2021-05-05 | Oscoda | Michigan | 26135 | 603 | 24 |
1288593 | 1288593 | 2021-05-05 | Otsego | Michigan | 26137 | 2253 | 37 |
1288594 | 1288594 | 2021-05-05 | Ottawa | Michigan | 26139 | 31240 | 404 |
1288595 | 1288595 | 2021-05-05 | Presque Isle | Michigan | 26141 | 986 | 31 |
1288596 | 1288596 | 2021-05-05 | Roscommon | Michigan | 26143 | 1823 | 47 |
1288597 | 1288597 | 2021-05-05 | Saginaw | Michigan | 26145 | 21286 | 583 |
1288598 | 1288598 | 2021-05-05 | Sanilac | Michigan | 26151 | 4146 | 106 |
1288599 | 1288599 | 2021-05-05 | Schoolcraft | Michigan | 26153 | 363 | 5 |
1288600 | 1288600 | 2021-05-05 | Shiawassee | Michigan | 26155 | 6102 | 98 |
1288601 | 1288601 | 2021-05-05 | St. Clair | Michigan | 26147 | 17541 | 403 |
1288602 | 1288602 | 2021-05-05 | St. Joseph | Michigan | 26149 | 5925 | 94 |
1288603 | 1288603 | 2021-05-05 | Tuscola | Michigan | 26157 | 5462 | 163 |
1288604 | 1288604 | 2021-05-05 | Unknown | Michigan | 347 | 16 | |
1288605 | 1288605 | 2021-05-05 | Van Buren | Michigan | 26159 | 6822 | 117 |
1288606 | 1288606 | 2021-05-05 | Washtenaw | Michigan | 26161 | 26273 | 281 |
1288607 | 1288607 | 2021-05-05 | Wayne | Michigan | 26163 | 157610 | 4708 |
1288608 | 1288608 | 2021-05-05 | Wexford | Michigan | 26165 | 2754 | 40 |
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);