ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-02-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 |
---|---|---|---|---|---|---|---|
999573 | 999573 | 2021-02-05 | Alcona | Michigan | 26001 | 417 | 23 |
999574 | 999574 | 2021-02-05 | Alger | Michigan | 26003 | 577 | 3 |
999575 | 999575 | 2021-02-05 | Allegan | Michigan | 26005 | 7044 | 108 |
999576 | 999576 | 2021-02-05 | Alpena | Michigan | 26007 | 1434 | 45 |
999577 | 999577 | 2021-02-05 | Antrim | Michigan | 26009 | 866 | 18 |
999578 | 999578 | 2021-02-05 | Arenac | Michigan | 26011 | 722 | 23 |
999579 | 999579 | 2021-02-05 | Baraga | Michigan | 26013 | 761 | 32 |
999580 | 999580 | 2021-02-05 | Barry | Michigan | 26015 | 3594 | 42 |
999581 | 999581 | 2021-02-05 | Bay | Michigan | 26017 | 7178 | 269 |
999582 | 999582 | 2021-02-05 | Benzie | Michigan | 26019 | 876 | 31 |
999583 | 999583 | 2021-02-05 | Berrien | Michigan | 26021 | 11074 | 225 |
999584 | 999584 | 2021-02-05 | Branch | Michigan | 26023 | 4509 | 105 |
999585 | 999585 | 2021-02-05 | Calhoun | Michigan | 26025 | 9092 | 222 |
999586 | 999586 | 2021-02-05 | Cass | Michigan | 26027 | 3811 | 57 |
999587 | 999587 | 2021-02-05 | Charlevoix | Michigan | 26029 | 1015 | 12 |
999588 | 999588 | 2021-02-05 | Cheboygan | Michigan | 26031 | 869 | 35 |
999589 | 999589 | 2021-02-05 | Chippewa | Michigan | 26033 | 4661 | 40 |
999590 | 999590 | 2021-02-05 | Clare | Michigan | 26035 | 1555 | 68 |
999591 | 999591 | 2021-02-05 | Clinton | Michigan | 26037 | 4821 | 67 |
999592 | 999592 | 2021-02-05 | Crawford | Michigan | 26039 | 565 | 5 |
999593 | 999593 | 2021-02-05 | Delta | Michigan | 26041 | 3081 | 82 |
999594 | 999594 | 2021-02-05 | Dickinson | Michigan | 26043 | 2344 | 69 |
999595 | 999595 | 2021-02-05 | Eaton | Michigan | 26045 | 5944 | 142 |
999596 | 999596 | 2021-02-05 | Emmet | Michigan | 26047 | 1422 | 36 |
999597 | 999597 | 2021-02-05 | Genesee | Michigan | 26049 | 24621 | 732 |
999598 | 999598 | 2021-02-05 | Gladwin | Michigan | 26051 | 1444 | 42 |
999599 | 999599 | 2021-02-05 | Gogebic | Michigan | 26053 | 1201 | 45 |
999600 | 999600 | 2021-02-05 | Grand Traverse | Michigan | 26055 | 4037 | 63 |
999601 | 999601 | 2021-02-05 | Gratiot | Michigan | 26057 | 5613 | 100 |
999602 | 999602 | 2021-02-05 | Hillsdale | Michigan | 26059 | 3192 | 70 |
999603 | 999603 | 2021-02-05 | Houghton | Michigan | 26061 | 2499 | 39 |
999604 | 999604 | 2021-02-05 | Huron | Michigan | 26063 | 2031 | 54 |
999605 | 999605 | 2021-02-05 | Ingham | Michigan | 26065 | 15435 | 263 |
999606 | 999606 | 2021-02-05 | Ionia | Michigan | 26067 | 6409 | 68 |
999607 | 999607 | 2021-02-05 | Iosco | Michigan | 26069 | 1257 | 62 |
999608 | 999608 | 2021-02-05 | Iron | Michigan | 26071 | 919 | 48 |
999609 | 999609 | 2021-02-05 | Isabella | Michigan | 26073 | 3878 | 70 |
999610 | 999610 | 2021-02-05 | Jackson | Michigan | 26075 | 13708 | 231 |
999611 | 999611 | 2021-02-05 | Kalamazoo | Michigan | 26077 | 14410 | 313 |
999612 | 999612 | 2021-02-05 | Kalkaska | Michigan | 26079 | 566 | 14 |
999613 | 999613 | 2021-02-05 | Kent | Michigan | 26081 | 49877 | 668 |
999614 | 999614 | 2021-02-05 | Keweenaw | Michigan | 26083 | 130 | 2 |
999615 | 999615 | 2021-02-05 | Lake | Michigan | 26085 | 350 | 11 |
999616 | 999616 | 2021-02-05 | Lapeer | Michigan | 26087 | 5197 | 124 |
999617 | 999617 | 2021-02-05 | Leelanau | Michigan | 26089 | 831 | 14 |
999618 | 999618 | 2021-02-05 | Lenawee | Michigan | 26091 | 7330 | 107 |
999619 | 999619 | 2021-02-05 | Livingston | Michigan | 26093 | 9882 | 121 |
999620 | 999620 | 2021-02-05 | Luce | Michigan | 26095 | 1063 | 2 |
999621 | 999621 | 2021-02-05 | Mackinac | Michigan | 26097 | 427 | 3 |
999622 | 999622 | 2021-02-05 | Macomb | Michigan | 26099 | 57048 | 1897 |
999623 | 999623 | 2021-02-05 | Manistee | Michigan | 26101 | 1360 | 20 |
999624 | 999624 | 2021-02-05 | Marquette | Michigan | 26103 | 4760 | 54 |
999625 | 999625 | 2021-02-05 | Mason | Michigan | 26105 | 1209 | 26 |
999626 | 999626 | 2021-02-05 | Mecosta | Michigan | 26107 | 1907 | 19 |
999627 | 999627 | 2021-02-05 | Menominee | Michigan | 26109 | 1854 | 36 |
999628 | 999628 | 2021-02-05 | Midland | Michigan | 26111 | 4819 | 59 |
999629 | 999629 | 2021-02-05 | Missaukee | Michigan | 26113 | 700 | 17 |
999630 | 999630 | 2021-02-05 | Monroe | Michigan | 26115 | 9328 | 185 |
999631 | 999631 | 2021-02-05 | Montcalm | Michigan | 26117 | 5481 | 90 |
999632 | 999632 | 2021-02-05 | Montmorency | Michigan | 26119 | 350 | 17 |
999633 | 999633 | 2021-02-05 | Muskegon | Michigan | 26121 | 12485 | 312 |
999634 | 999634 | 2021-02-05 | Newaygo | Michigan | 26123 | 2679 | 45 |
999635 | 999635 | 2021-02-05 | Oakland | Michigan | 26125 | 71677 | 1916 |
999636 | 999636 | 2021-02-05 | Oceana | Michigan | 26127 | 1827 | 49 |
999637 | 999637 | 2021-02-05 | Ogemaw | Michigan | 26129 | 1089 | 31 |
999638 | 999638 | 2021-02-05 | Ontonagon | Michigan | 26131 | 395 | 19 |
999639 | 999639 | 2021-02-05 | Osceola | Michigan | 26133 | 1006 | 22 |
999640 | 999640 | 2021-02-05 | Oscoda | Michigan | 26135 | 386 | 18 |
999641 | 999641 | 2021-02-05 | Otsego | Michigan | 26137 | 1123 | 25 |
999642 | 999642 | 2021-02-05 | Ottawa | Michigan | 26139 | 21535 | 337 |
999643 | 999643 | 2021-02-05 | Presque Isle | Michigan | 26141 | 631 | 24 |
999644 | 999644 | 2021-02-05 | Roscommon | Michigan | 26143 | 1102 | 31 |
999645 | 999645 | 2021-02-05 | Saginaw | Michigan | 26145 | 15458 | 484 |
999646 | 999646 | 2021-02-05 | Sanilac | Michigan | 26151 | 1898 | 73 |
999647 | 999647 | 2021-02-05 | Schoolcraft | Michigan | 26153 | 257 | 5 |
999648 | 999648 | 2021-02-05 | Shiawassee | Michigan | 26155 | 3623 | 74 |
999649 | 999649 | 2021-02-05 | St. Clair | Michigan | 26147 | 8340 | 238 |
999650 | 999650 | 2021-02-05 | St. Joseph | Michigan | 26149 | 4495 | 77 |
999651 | 999651 | 2021-02-05 | Tuscola | Michigan | 26157 | 3054 | 128 |
999652 | 999652 | 2021-02-05 | Unknown | Michigan | 0 | 14 | |
999653 | 999653 | 2021-02-05 | Van Buren | Michigan | 26159 | 4805 | 94 |
999654 | 999654 | 2021-02-05 | Washtenaw | Michigan | 26161 | 17890 | 237 |
999655 | 999655 | 2021-02-05 | Wayne | Michigan | 26163 | 97943 | 4021 |
999656 | 999656 | 2021-02-05 | Wexford | Michigan | 26165 | 1345 | 20 |
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);