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-28 and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
377523 | 377523 | 2020-07-28 | Alcona | Michigan | 26001 | 27 | 1 |
377524 | 377524 | 2020-07-28 | Alger | Michigan | 26003 | 5 | 0 |
377525 | 377525 | 2020-07-28 | Allegan | Michigan | 26005 | 477 | 7 |
377526 | 377526 | 2020-07-28 | Alpena | Michigan | 26007 | 125 | 13 |
377527 | 377527 | 2020-07-28 | Antrim | Michigan | 26009 | 35 | 0 |
377528 | 377528 | 2020-07-28 | Arenac | Michigan | 26011 | 40 | 3 |
377529 | 377529 | 2020-07-28 | Baraga | Michigan | 26013 | 5 | 0 |
377530 | 377530 | 2020-07-28 | Barry | Michigan | 26015 | 168 | 2 |
377531 | 377531 | 2020-07-28 | Bay | Michigan | 26017 | 532 | 31 |
377532 | 377532 | 2020-07-28 | Benzie | Michigan | 26019 | 30 | 1 |
377533 | 377533 | 2020-07-28 | Berrien | Michigan | 26021 | 1304 | 64 |
377534 | 377534 | 2020-07-28 | Branch | Michigan | 26023 | 1122 | 25 |
377535 | 377535 | 2020-07-28 | Calhoun | Michigan | 26025 | 705 | 40 |
377536 | 377536 | 2020-07-28 | Cass | Michigan | 26027 | 265 | 9 |
377537 | 377537 | 2020-07-28 | Charlevoix | Michigan | 26029 | 45 | 2 |
377538 | 377538 | 2020-07-28 | Cheboygan | Michigan | 26031 | 34 | 2 |
377539 | 377539 | 2020-07-28 | Chippewa | Michigan | 26033 | 28 | 0 |
377540 | 377540 | 2020-07-28 | Clare | Michigan | 26035 | 53 | 3 |
377541 | 377541 | 2020-07-28 | Clinton | Michigan | 26037 | 380 | 12 |
377542 | 377542 | 2020-07-28 | Crawford | Michigan | 26039 | 93 | 5 |
377543 | 377543 | 2020-07-28 | Delta | Michigan | 26041 | 62 | 3 |
377544 | 377544 | 2020-07-28 | Dickinson | Michigan | 26043 | 43 | 2 |
377545 | 377545 | 2020-07-28 | Eaton | Michigan | 26045 | 432 | 7 |
377546 | 377546 | 2020-07-28 | Emmet | Michigan | 26047 | 55 | 2 |
377547 | 377547 | 2020-07-28 | Genesee | Michigan | 26049 | 3340 | 294 |
377548 | 377548 | 2020-07-28 | Gladwin | Michigan | 26051 | 45 | 2 |
377549 | 377549 | 2020-07-28 | Gogebic | Michigan | 26053 | 64 | 1 |
377550 | 377550 | 2020-07-28 | Grand Traverse | Michigan | 26055 | 175 | 5 |
377551 | 377551 | 2020-07-28 | Gratiot | Michigan | 26057 | 140 | 15 |
377552 | 377552 | 2020-07-28 | Hillsdale | Michigan | 26059 | 232 | 25 |
377553 | 377553 | 2020-07-28 | Houghton | Michigan | 26061 | 46 | 0 |
377554 | 377554 | 2020-07-28 | Huron | Michigan | 26063 | 140 | 3 |
377555 | 377555 | 2020-07-28 | Ingham | Michigan | 26065 | 1415 | 30 |
377556 | 377556 | 2020-07-28 | Ionia | Michigan | 26067 | 261 | 5 |
377557 | 377557 | 2020-07-28 | Iosco | Michigan | 26069 | 126 | 11 |
377558 | 377558 | 2020-07-28 | Iron | Michigan | 26071 | 15 | 1 |
377559 | 377559 | 2020-07-28 | Isabella | Michigan | 26073 | 197 | 8 |
377560 | 377560 | 2020-07-28 | Jackson | Michigan | 26075 | 2357 | 55 |
377561 | 377561 | 2020-07-28 | Kalamazoo | Michigan | 26077 | 1455 | 78 |
377562 | 377562 | 2020-07-28 | Kalkaska | Michigan | 26079 | 48 | 4 |
377563 | 377563 | 2020-07-28 | Kent | Michigan | 26081 | 6908 | 154 |
377564 | 377564 | 2020-07-28 | Keweenaw | Michigan | 26083 | 2 | 0 |
377565 | 377565 | 2020-07-28 | Lake | Michigan | 26085 | 16 | 0 |
377566 | 377566 | 2020-07-28 | Lapeer | Michigan | 26087 | 699 | 39 |
377567 | 377567 | 2020-07-28 | Leelanau | Michigan | 26089 | 63 | 0 |
377568 | 377568 | 2020-07-28 | Lenawee | Michigan | 26091 | 1102 | 15 |
377569 | 377569 | 2020-07-28 | Livingston | Michigan | 26093 | 770 | 29 |
377570 | 377570 | 2020-07-28 | Luce | Michigan | 26095 | 4 | 0 |
377571 | 377571 | 2020-07-28 | Mackinac | Michigan | 26097 | 19 | 0 |
377572 | 377572 | 2020-07-28 | Macomb | Michigan | 26099 | 9296 | 942 |
377573 | 377573 | 2020-07-28 | Manistee | Michigan | 26101 | 43 | 0 |
377574 | 377574 | 2020-07-28 | Marquette | Michigan | 26103 | 120 | 11 |
377575 | 377575 | 2020-07-28 | Mason | Michigan | 26105 | 94 | 0 |
377576 | 377576 | 2020-07-28 | Mecosta | Michigan | 26107 | 51 | 2 |
377577 | 377577 | 2020-07-28 | Menominee | Michigan | 26109 | 75 | 0 |
377578 | 377578 | 2020-07-28 | Midland | Michigan | 26111 | 278 | 9 |
377579 | 377579 | 2020-07-28 | Missaukee | Michigan | 26113 | 40 | 1 |
377580 | 377580 | 2020-07-28 | Monroe | Michigan | 26115 | 817 | 21 |
377581 | 377581 | 2020-07-28 | Montcalm | Michigan | 26117 | 175 | 1 |
377582 | 377582 | 2020-07-28 | Montmorency | Michigan | 26119 | 7 | 0 |
377583 | 377583 | 2020-07-28 | Muskegon | Michigan | 26121 | 1096 | 57 |
377584 | 377584 | 2020-07-28 | Newaygo | Michigan | 26123 | 246 | 0 |
377585 | 377585 | 2020-07-28 | Oakland | Michigan | 26125 | 14200 | 1126 |
377586 | 377586 | 2020-07-28 | Oceana | Michigan | 26127 | 460 | 6 |
377587 | 377587 | 2020-07-28 | Ogemaw | Michigan | 26129 | 49 | 2 |
377588 | 377588 | 2020-07-28 | Ontonagon | Michigan | 26131 | 3 | 0 |
377589 | 377589 | 2020-07-28 | Osceola | Michigan | 26133 | 65 | 0 |
377590 | 377590 | 2020-07-28 | Oscoda | Michigan | 26135 | 23 | 1 |
377591 | 377591 | 2020-07-28 | Otsego | Michigan | 26137 | 141 | 10 |
377592 | 377592 | 2020-07-28 | Ottawa | Michigan | 26139 | 1638 | 54 |
377593 | 377593 | 2020-07-28 | Presque Isle | Michigan | 26141 | 14 | 1 |
377594 | 377594 | 2020-07-28 | Roscommon | Michigan | 26143 | 45 | 0 |
377595 | 377595 | 2020-07-28 | Saginaw | Michigan | 26145 | 1782 | 125 |
377596 | 377596 | 2020-07-28 | Sanilac | Michigan | 26151 | 88 | 6 |
377597 | 377597 | 2020-07-28 | Schoolcraft | Michigan | 26153 | 8 | 0 |
377598 | 377598 | 2020-07-28 | Shiawassee | Michigan | 26155 | 302 | 28 |
377599 | 377599 | 2020-07-28 | St. Clair | Michigan | 26147 | 724 | 53 |
377600 | 377600 | 2020-07-28 | St. Joseph | Michigan | 26149 | 536 | 7 |
377601 | 377601 | 2020-07-28 | Tuscola | Michigan | 26157 | 286 | 27 |
377602 | 377602 | 2020-07-28 | Unknown | Michigan | 15 | 2 | |
377603 | 377603 | 2020-07-28 | Van Buren | Michigan | 26159 | 369 | 11 |
377604 | 377604 | 2020-07-28 | Washtenaw | Michigan | 26161 | 2814 | 120 |
377605 | 377605 | 2020-07-28 | Wayne | Michigan | 26163 | 26356 | 2791 |
377606 | 377606 | 2020-07-28 | Wexford | Michigan | 26165 | 65 | 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);