ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where "date" is on date 2020-05-23 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
170558 | 170558 | 2020-05-23 | Alcona | Michigan | 26001 | 10 | 1 |
170559 | 170559 | 2020-05-23 | Allegan | Michigan | 26005 | 202 | 7 |
170560 | 170560 | 2020-05-23 | Alpena | Michigan | 26007 | 94 | 9 |
170561 | 170561 | 2020-05-23 | Antrim | Michigan | 26009 | 11 | 0 |
170562 | 170562 | 2020-05-23 | Arenac | Michigan | 26011 | 32 | 1 |
170563 | 170563 | 2020-05-23 | Baraga | Michigan | 26013 | 1 | 0 |
170564 | 170564 | 2020-05-23 | Barry | Michigan | 26015 | 59 | 2 |
170565 | 170565 | 2020-05-23 | Bay | Michigan | 26017 | 276 | 19 |
170566 | 170566 | 2020-05-23 | Benzie | Michigan | 26019 | 4 | 0 |
170567 | 170567 | 2020-05-23 | Berrien | Michigan | 26021 | 584 | 42 |
170568 | 170568 | 2020-05-23 | Branch | Michigan | 26023 | 893 | 24 |
170569 | 170569 | 2020-05-23 | Calhoun | Michigan | 26025 | 339 | 21 |
170570 | 170570 | 2020-05-23 | Cass | Michigan | 26027 | 76 | 2 |
170571 | 170571 | 2020-05-23 | Charlevoix | Michigan | 26029 | 14 | 1 |
170572 | 170572 | 2020-05-23 | Cheboygan | Michigan | 26031 | 21 | 1 |
170573 | 170573 | 2020-05-23 | Chippewa | Michigan | 26033 | 3 | 0 |
170574 | 170574 | 2020-05-23 | Clare | Michigan | 26035 | 17 | 2 |
170575 | 170575 | 2020-05-23 | Clinton | Michigan | 26037 | 137 | 10 |
170576 | 170576 | 2020-05-23 | Crawford | Michigan | 26039 | 58 | 5 |
170577 | 170577 | 2020-05-23 | Delta | Michigan | 26041 | 17 | 2 |
170578 | 170578 | 2020-05-23 | Dickinson | Michigan | 26043 | 5 | 2 |
170579 | 170579 | 2020-05-23 | Eaton | Michigan | 26045 | 175 | 6 |
170580 | 170580 | 2020-05-23 | Emmet | Michigan | 26047 | 21 | 2 |
170581 | 170581 | 2020-05-23 | Genesee | Michigan | 26049 | 1936 | 240 |
170582 | 170582 | 2020-05-23 | Gladwin | Michigan | 26051 | 17 | 1 |
170583 | 170583 | 2020-05-23 | Gogebic | Michigan | 26053 | 5 | 1 |
170584 | 170584 | 2020-05-23 | Grand Traverse | Michigan | 26055 | 23 | 5 |
170585 | 170585 | 2020-05-23 | Gratiot | Michigan | 26057 | 72 | 5 |
170586 | 170586 | 2020-05-23 | Hillsdale | Michigan | 26059 | 168 | 24 |
170587 | 170587 | 2020-05-23 | Houghton | Michigan | 26061 | 2 | 0 |
170588 | 170588 | 2020-05-23 | Huron | Michigan | 26063 | 42 | 1 |
170589 | 170589 | 2020-05-23 | Ingham | Michigan | 26065 | 695 | 25 |
170590 | 170590 | 2020-05-23 | Ionia | Michigan | 26067 | 144 | 3 |
170591 | 170591 | 2020-05-23 | Iosco | Michigan | 26069 | 77 | 9 |
170592 | 170592 | 2020-05-23 | Isabella | Michigan | 26073 | 70 | 7 |
170593 | 170593 | 2020-05-23 | Jackson | Michigan | 26075 | 1473 | 45 |
170594 | 170594 | 2020-05-23 | Kalamazoo | Michigan | 26077 | 793 | 47 |
170595 | 170595 | 2020-05-23 | Kalkaska | Michigan | 26079 | 19 | 2 |
170596 | 170596 | 2020-05-23 | Kent | Michigan | 26081 | 3312 | 67 |
170597 | 170597 | 2020-05-23 | Lake | Michigan | 26085 | 5 | 0 |
170598 | 170598 | 2020-05-23 | Lapeer | Michigan | 26087 | 470 | 33 |
170599 | 170599 | 2020-05-23 | Leelanau | Michigan | 26089 | 11 | 0 |
170600 | 170600 | 2020-05-23 | Lenawee | Michigan | 26091 | 861 | 6 |
170601 | 170601 | 2020-05-23 | Livingston | Michigan | 26093 | 398 | 27 |
170602 | 170602 | 2020-05-23 | Luce | Michigan | 26095 | 4 | 0 |
170603 | 170603 | 2020-05-23 | Mackinac | Michigan | 26097 | 6 | 0 |
170604 | 170604 | 2020-05-23 | Macomb | Michigan | 26099 | 6592 | 783 |
170605 | 170605 | 2020-05-23 | Manistee | Michigan | 26101 | 20 | 0 |
170606 | 170606 | 2020-05-23 | Marquette | Michigan | 26103 | 53 | 10 |
170607 | 170607 | 2020-05-23 | Mason | Michigan | 26105 | 31 | 0 |
170608 | 170608 | 2020-05-23 | Mecosta | Michigan | 26107 | 19 | 2 |
170609 | 170609 | 2020-05-23 | Menominee | Michigan | 26109 | 8 | 0 |
170610 | 170610 | 2020-05-23 | Midland | Michigan | 26111 | 79 | 8 |
170611 | 170611 | 2020-05-23 | Missaukee | Michigan | 26113 | 16 | 1 |
170612 | 170612 | 2020-05-23 | Monroe | Michigan | 26115 | 461 | 19 |
170613 | 170613 | 2020-05-23 | Montcalm | Michigan | 26117 | 68 | 1 |
170614 | 170614 | 2020-05-23 | Montmorency | Michigan | 26119 | 5 | 0 |
170615 | 170615 | 2020-05-23 | Muskegon | Michigan | 26121 | 583 | 28 |
170616 | 170616 | 2020-05-23 | Newaygo | Michigan | 26123 | 79 | 0 |
170617 | 170617 | 2020-05-23 | Oakland | Michigan | 26125 | 8192 | 954 |
170618 | 170618 | 2020-05-23 | Oceana | Michigan | 26127 | 74 | 2 |
170619 | 170619 | 2020-05-23 | Ogemaw | Michigan | 26129 | 20 | 0 |
170620 | 170620 | 2020-05-23 | Osceola | Michigan | 26133 | 10 | 0 |
170621 | 170621 | 2020-05-23 | Oscoda | Michigan | 26135 | 5 | 1 |
170622 | 170622 | 2020-05-23 | Otsego | Michigan | 26137 | 100 | 10 |
170623 | 170623 | 2020-05-23 | Ottawa | Michigan | 26139 | 673 | 26 |
170624 | 170624 | 2020-05-23 | Presque Isle | Michigan | 26141 | 11 | 0 |
170625 | 170625 | 2020-05-23 | Roscommon | Michigan | 26143 | 21 | 0 |
170626 | 170626 | 2020-05-23 | Saginaw | Michigan | 26145 | 983 | 105 |
170627 | 170627 | 2020-05-23 | Sanilac | Michigan | 26151 | 39 | 5 |
170628 | 170628 | 2020-05-23 | Schoolcraft | Michigan | 26153 | 4 | 0 |
170629 | 170629 | 2020-05-23 | Shiawassee | Michigan | 26155 | 238 | 24 |
170630 | 170630 | 2020-05-23 | St. Clair | Michigan | 26147 | 429 | 34 |
170631 | 170631 | 2020-05-23 | St. Joseph | Michigan | 26149 | 100 | 2 |
170632 | 170632 | 2020-05-23 | Tuscola | Michigan | 26157 | 183 | 23 |
170633 | 170633 | 2020-05-23 | Unknown | Michigan | 256 | 4 | |
170634 | 170634 | 2020-05-23 | Van Buren | Michigan | 26159 | 121 | 6 |
170635 | 170635 | 2020-05-23 | Washtenaw | Michigan | 26161 | 1451 | 103 |
170636 | 170636 | 2020-05-23 | Wayne | Michigan | 26163 | 19717 | 2363 |
170637 | 170637 | 2020-05-23 | Wexford | Michigan | 26165 | 11 | 2 |
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);