ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-03" 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 |
---|---|---|---|---|---|---|---|
1879592 | 1879592 | 2021-11-03 | Alcona | Michigan | 26001 | 1174 | 44 |
1879593 | 1879593 | 2021-11-03 | Alger | Michigan | 26003 | 1013 | 9 |
1879594 | 1879594 | 2021-11-03 | Allegan | Michigan | 26005 | 15252 | 197 |
1879595 | 1879595 | 2021-11-03 | Alpena | Michigan | 26007 | 3322 | 73 |
1879596 | 1879596 | 2021-11-03 | Antrim | Michigan | 26009 | 2477 | 38 |
1879597 | 1879597 | 2021-11-03 | Arenac | Michigan | 26011 | 1865 | 36 |
1879598 | 1879598 | 2021-11-03 | Baraga | Michigan | 26013 | 1374 | 47 |
1879599 | 1879599 | 2021-11-03 | Barry | Michigan | 26015 | 8110 | 90 |
1879600 | 1879600 | 2021-11-03 | Bay | Michigan | 26017 | 15340 | 393 |
1879601 | 1879601 | 2021-11-03 | Benzie | Michigan | 26019 | 1704 | 40 |
1879602 | 1879602 | 2021-11-03 | Berrien | Michigan | 26021 | 19680 | 332 |
1879603 | 1879603 | 2021-11-03 | Branch | Michigan | 26023 | 7528 | 137 |
1879604 | 1879604 | 2021-11-03 | Calhoun | Michigan | 26025 | 19266 | 357 |
1879605 | 1879605 | 2021-11-03 | Cass | Michigan | 26027 | 7257 | 93 |
1879606 | 1879606 | 2021-11-03 | Charlevoix | Michigan | 26029 | 2648 | 37 |
1879607 | 1879607 | 2021-11-03 | Cheboygan | Michigan | 26031 | 2962 | 68 |
1879608 | 1879608 | 2021-11-03 | Chippewa | Michigan | 26033 | 7021 | 68 |
1879609 | 1879609 | 2021-11-03 | Clare | Michigan | 26035 | 3985 | 105 |
1879610 | 1879610 | 2021-11-03 | Clinton | Michigan | 26037 | 10527 | 112 |
1879611 | 1879611 | 2021-11-03 | Crawford | Michigan | 26039 | 1431 | 17 |
1879612 | 1879612 | 2021-11-03 | Delta | Michigan | 26041 | 5963 | 110 |
1879613 | 1879613 | 2021-11-03 | Dickinson | Michigan | 26043 | 4097 | 84 |
1879614 | 1879614 | 2021-11-03 | Eaton | Michigan | 26045 | 13637 | 249 |
1879615 | 1879615 | 2021-11-03 | Emmet | Michigan | 26047 | 3542 | 51 |
1879616 | 1879616 | 2021-11-03 | Genesee | Michigan | 26049 | 53604 | 1103 |
1879617 | 1879617 | 2021-11-03 | Gladwin | Michigan | 26051 | 3391 | 77 |
1879618 | 1879618 | 2021-11-03 | Gogebic | Michigan | 26053 | 1856 | 54 |
1879619 | 1879619 | 2021-11-03 | Grand Traverse | Michigan | 26055 | 9217 | 121 |
1879620 | 1879620 | 2021-11-03 | Gratiot | Michigan | 26057 | 8969 | 134 |
1879621 | 1879621 | 2021-11-03 | Hillsdale | Michigan | 26059 | 6372 | 128 |
1879622 | 1879622 | 2021-11-03 | Houghton | Michigan | 26061 | 4341 | 56 |
1879623 | 1879623 | 2021-11-03 | Huron | Michigan | 26063 | 4965 | 97 |
1879624 | 1879624 | 2021-11-03 | Ingham | Michigan | 26065 | 31857 | 461 |
1879625 | 1879625 | 2021-11-03 | Ionia | Michigan | 26067 | 12074 | 105 |
1879626 | 1879626 | 2021-11-03 | Iosco | Michigan | 26069 | 3151 | 97 |
1879627 | 1879627 | 2021-11-03 | Iron | Michigan | 26071 | 1476 | 58 |
1879628 | 1879628 | 2021-11-03 | Isabella | Michigan | 26073 | 9353 | 130 |
1879629 | 1879629 | 2021-11-03 | Jackson | Michigan | 26075 | 26817 | 375 |
1879630 | 1879630 | 2021-11-03 | Kalamazoo | Michigan | 26077 | 30534 | 465 |
1879631 | 1879631 | 2021-11-03 | Kalkaska | Michigan | 26079 | 1844 | 40 |
1879632 | 1879632 | 2021-11-03 | Kent | Michigan | 26081 | 95904 | 1007 |
1879633 | 1879633 | 2021-11-03 | Keweenaw | Michigan | 26083 | 270 | 5 |
1879634 | 1879634 | 2021-11-03 | Lake | Michigan | 26085 | 1003 | 22 |
1879635 | 1879635 | 2021-11-03 | Lapeer | Michigan | 26087 | 12367 | 260 |
1879636 | 1879636 | 2021-11-03 | Leelanau | Michigan | 26089 | 1705 | 26 |
1879637 | 1879637 | 2021-11-03 | Lenawee | Michigan | 26091 | 15153 | 207 |
1879638 | 1879638 | 2021-11-03 | Livingston | Michigan | 26093 | 23976 | 247 |
1879639 | 1879639 | 2021-11-03 | Luce | Michigan | 26095 | 1609 | 6 |
1879640 | 1879640 | 2021-11-03 | Mackinac | Michigan | 26097 | 1326 | 12 |
1879641 | 1879641 | 2021-11-03 | Macomb | Michigan | 26099 | 124656 | 2724 |
1879642 | 1879642 | 2021-11-03 | Manistee | Michigan | 26101 | 2579 | 38 |
1879643 | 1879643 | 2021-11-03 | Marquette | Michigan | 26103 | 8260 | 82 |
1879644 | 1879644 | 2021-11-03 | Mason | Michigan | 26105 | 3295 | 47 |
1879645 | 1879645 | 2021-11-03 | Mecosta | Michigan | 26107 | 4886 | 48 |
1879646 | 1879646 | 2021-11-03 | Menominee | Michigan | 26109 | 3440 | 51 |
1879647 | 1879647 | 2021-11-03 | Midland | Michigan | 26111 | 10674 | 143 |
1879648 | 1879648 | 2021-11-03 | Missaukee | Michigan | 26113 | 1897 | 40 |
1879649 | 1879649 | 2021-11-03 | Monroe | Michigan | 26115 | 21076 | 308 |
1879650 | 1879650 | 2021-11-03 | Montcalm | Michigan | 26117 | 11104 | 137 |
1879651 | 1879651 | 2021-11-03 | Montmorency | Michigan | 26119 | 1011 | 28 |
1879652 | 1879652 | 2021-11-03 | Muskegon | Michigan | 26121 | 24165 | 428 |
1879653 | 1879653 | 2021-11-03 | Newaygo | Michigan | 26123 | 6799 | 84 |
1879654 | 1879654 | 2021-11-03 | Oakland | Michigan | 26125 | 149080 | 2703 |
1879655 | 1879655 | 2021-11-03 | Oceana | Michigan | 26127 | 3815 | 71 |
1879656 | 1879656 | 2021-11-03 | Ogemaw | Michigan | 26129 | 2791 | 62 |
1879657 | 1879657 | 2021-11-03 | Ontonagon | Michigan | 26131 | 628 | 22 |
1879658 | 1879658 | 2021-11-03 | Osceola | Michigan | 26133 | 3168 | 41 |
1879659 | 1879659 | 2021-11-03 | Oscoda | Michigan | 26135 | 995 | 39 |
1879660 | 1879660 | 2021-11-03 | Otsego | Michigan | 26137 | 3400 | 58 |
1879661 | 1879661 | 2021-11-03 | Ottawa | Michigan | 26139 | 42610 | 509 |
1879662 | 1879662 | 2021-11-03 | Presque Isle | Michigan | 26141 | 1410 | 39 |
1879663 | 1879663 | 2021-11-03 | Roscommon | Michigan | 26143 | 2704 | 67 |
1879664 | 1879664 | 2021-11-03 | Saginaw | Michigan | 26145 | 29231 | 682 |
1879665 | 1879665 | 2021-11-03 | Sanilac | Michigan | 26151 | 5120 | 137 |
1879666 | 1879666 | 2021-11-03 | Schoolcraft | Michigan | 26153 | 845 | 5 |
1879667 | 1879667 | 2021-11-03 | Shiawassee | Michigan | 26155 | 9033 | 132 |
1879668 | 1879668 | 2021-11-03 | St. Clair | Michigan | 26147 | 22907 | 525 |
1879669 | 1879669 | 2021-11-03 | St. Joseph | Michigan | 26149 | 8676 | 121 |
1879670 | 1879670 | 2021-11-03 | Tuscola | Michigan | 26157 | 7678 | 200 |
1879671 | 1879671 | 2021-11-03 | Unknown | Michigan | 1434 | 14 | |
1879672 | 1879672 | 2021-11-03 | Van Buren | Michigan | 26159 | 9545 | 167 |
1879673 | 1879673 | 2021-11-03 | Washtenaw | Michigan | 26161 | 34638 | 340 |
1879674 | 1879674 | 2021-11-03 | Wayne | Michigan | 26163 | 203373 | 5628 |
1879675 | 1879675 | 2021-11-03 | Wexford | Michigan | 26165 | 3817 | 55 |
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);