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 2021-04-03 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1184607 | 1184607 | 2021-04-03 | Alcona | Michigan | 26001 | 499 | 25 |
1184608 | 1184608 | 2021-04-03 | Alger | Michigan | 26003 | 606 | 5 |
1184609 | 1184609 | 2021-04-03 | Allegan | Michigan | 26005 | 8478 | 118 |
1184610 | 1184610 | 2021-04-03 | Alpena | Michigan | 26007 | 1651 | 50 |
1184611 | 1184611 | 2021-04-03 | Antrim | Michigan | 26009 | 1234 | 20 |
1184612 | 1184612 | 2021-04-03 | Arenac | Michigan | 26011 | 820 | 27 |
1184613 | 1184613 | 2021-04-03 | Baraga | Michigan | 26013 | 798 | 34 |
1184614 | 1184614 | 2021-04-03 | Barry | Michigan | 26015 | 4344 | 52 |
1184615 | 1184615 | 2021-04-03 | Bay | Michigan | 26017 | 8527 | 308 |
1184616 | 1184616 | 2021-04-03 | Benzie | Michigan | 26019 | 1018 | 32 |
1184617 | 1184617 | 2021-04-03 | Berrien | Michigan | 26021 | 13043 | 252 |
1184618 | 1184618 | 2021-04-03 | Branch | Michigan | 26023 | 4898 | 112 |
1184619 | 1184619 | 2021-04-03 | Calhoun | Michigan | 26025 | 11443 | 247 |
1184620 | 1184620 | 2021-04-03 | Cass | Michigan | 26027 | 4669 | 68 |
1184621 | 1184621 | 2021-04-03 | Charlevoix | Michigan | 26029 | 1220 | 13 |
1184622 | 1184622 | 2021-04-03 | Cheboygan | Michigan | 26031 | 1334 | 38 |
1184623 | 1184623 | 2021-04-03 | Chippewa | Michigan | 26033 | 5204 | 46 |
1184624 | 1184624 | 2021-04-03 | Clare | Michigan | 26035 | 1782 | 69 |
1184625 | 1184625 | 2021-04-03 | Clinton | Michigan | 26037 | 6090 | 75 |
1184626 | 1184626 | 2021-04-03 | Crawford | Michigan | 26039 | 761 | 6 |
1184627 | 1184627 | 2021-04-03 | Delta | Michigan | 26041 | 3341 | 86 |
1184628 | 1184628 | 2021-04-03 | Dickinson | Michigan | 26043 | 2466 | 71 |
1184629 | 1184629 | 2021-04-03 | Eaton | Michigan | 26045 | 7895 | 162 |
1184630 | 1184630 | 2021-04-03 | Emmet | Michigan | 26047 | 1767 | 40 |
1184631 | 1184631 | 2021-04-03 | Genesee | Michigan | 26049 | 31410 | 787 |
1184632 | 1184632 | 2021-04-03 | Gladwin | Michigan | 26051 | 1675 | 43 |
1184633 | 1184633 | 2021-04-03 | Gogebic | Michigan | 26053 | 1331 | 50 |
1184634 | 1184634 | 2021-04-03 | Grand Traverse | Michigan | 26055 | 5085 | 77 |
1184635 | 1184635 | 2021-04-03 | Gratiot | Michigan | 26057 | 5932 | 110 |
1184636 | 1184636 | 2021-04-03 | Hillsdale | Michigan | 26059 | 3710 | 79 |
1184637 | 1184637 | 2021-04-03 | Houghton | Michigan | 26061 | 2854 | 40 |
1184638 | 1184638 | 2021-04-03 | Huron | Michigan | 26063 | 3093 | 62 |
1184639 | 1184639 | 2021-04-03 | Ingham | Michigan | 26065 | 20036 | 303 |
1184640 | 1184640 | 2021-04-03 | Ionia | Michigan | 26067 | 7704 | 79 |
1184641 | 1184641 | 2021-04-03 | Iosco | Michigan | 26069 | 1467 | 67 |
1184642 | 1184642 | 2021-04-03 | Iron | Michigan | 26071 | 946 | 51 |
1184643 | 1184643 | 2021-04-03 | Isabella | Michigan | 26073 | 4591 | 77 |
1184644 | 1184644 | 2021-04-03 | Jackson | Michigan | 26075 | 17180 | 266 |
1184645 | 1184645 | 2021-04-03 | Kalamazoo | Michigan | 26077 | 17915 | 329 |
1184646 | 1184646 | 2021-04-03 | Kalkaska | Michigan | 26079 | 806 | 16 |
1184647 | 1184647 | 2021-04-03 | Kent | Michigan | 26081 | 57747 | 749 |
1184648 | 1184648 | 2021-04-03 | Keweenaw | Michigan | 26083 | 155 | 2 |
1184649 | 1184649 | 2021-04-03 | Lake | Michigan | 26085 | 448 | 12 |
1184650 | 1184650 | 2021-04-03 | Lapeer | Michigan | 26087 | 7287 | 147 |
1184651 | 1184651 | 2021-04-03 | Leelanau | Michigan | 26089 | 1005 | 16 |
1184652 | 1184652 | 2021-04-03 | Lenawee | Michigan | 26091 | 8633 | 140 |
1184653 | 1184653 | 2021-04-03 | Livingston | Michigan | 26093 | 12682 | 157 |
1184654 | 1184654 | 2021-04-03 | Luce | Michigan | 26095 | 1133 | 2 |
1184655 | 1184655 | 2021-04-03 | Mackinac | Michigan | 26097 | 494 | 3 |
1184656 | 1184656 | 2021-04-03 | Macomb | Michigan | 26099 | 76232 | 2052 |
1184657 | 1184657 | 2021-04-03 | Manistee | Michigan | 26101 | 1661 | 23 |
1184658 | 1184658 | 2021-04-03 | Marquette | Michigan | 26103 | 5150 | 57 |
1184659 | 1184659 | 2021-04-03 | Mason | Michigan | 26105 | 1455 | 27 |
1184660 | 1184660 | 2021-04-03 | Mecosta | Michigan | 26107 | 2332 | 23 |
1184661 | 1184661 | 2021-04-03 | Menominee | Michigan | 26109 | 1940 | 41 |
1184662 | 1184662 | 2021-04-03 | Midland | Michigan | 26111 | 5738 | 70 |
1184663 | 1184663 | 2021-04-03 | Missaukee | Michigan | 26113 | 1133 | 20 |
1184664 | 1184664 | 2021-04-03 | Monroe | Michigan | 26115 | 12013 | 214 |
1184665 | 1184665 | 2021-04-03 | Montcalm | Michigan | 26117 | 6238 | 97 |
1184666 | 1184666 | 2021-04-03 | Montmorency | Michigan | 26119 | 408 | 18 |
1184667 | 1184667 | 2021-04-03 | Muskegon | Michigan | 26121 | 13617 | 318 |
1184668 | 1184668 | 2021-04-03 | Newaygo | Michigan | 26123 | 3446 | 54 |
1184669 | 1184669 | 2021-04-03 | Oakland | Michigan | 26125 | 90618 | 2070 |
1184670 | 1184670 | 2021-04-03 | Oceana | Michigan | 26127 | 2062 | 51 |
1184671 | 1184671 | 2021-04-03 | Ogemaw | Michigan | 26129 | 1210 | 34 |
1184672 | 1184672 | 2021-04-03 | Ontonagon | Michigan | 26131 | 432 | 21 |
1184673 | 1184673 | 2021-04-03 | Osceola | Michigan | 26133 | 1369 | 24 |
1184674 | 1184674 | 2021-04-03 | Oscoda | Michigan | 26135 | 476 | 20 |
1184675 | 1184675 | 2021-04-03 | Otsego | Michigan | 26137 | 1715 | 28 |
1184676 | 1184676 | 2021-04-03 | Ottawa | Michigan | 26139 | 25478 | 370 |
1184677 | 1184677 | 2021-04-03 | Presque Isle | Michigan | 26141 | 779 | 29 |
1184678 | 1184678 | 2021-04-03 | Roscommon | Michigan | 26143 | 1538 | 42 |
1184679 | 1184679 | 2021-04-03 | Saginaw | Michigan | 26145 | 17679 | 544 |
1184680 | 1184680 | 2021-04-03 | Sanilac | Michigan | 26151 | 3133 | 86 |
1184681 | 1184681 | 2021-04-03 | Schoolcraft | Michigan | 26153 | 314 | 5 |
1184682 | 1184682 | 2021-04-03 | Shiawassee | Michigan | 26155 | 4636 | 85 |
1184683 | 1184683 | 2021-04-03 | St. Clair | Michigan | 26147 | 12983 | 284 |
1184684 | 1184684 | 2021-04-03 | St. Joseph | Michigan | 26149 | 5239 | 91 |
1184685 | 1184685 | 2021-04-03 | Tuscola | Michigan | 26157 | 4217 | 142 |
1184686 | 1184686 | 2021-04-03 | Unknown | Michigan | 0 | 13 | |
1184687 | 1184687 | 2021-04-03 | Van Buren | Michigan | 26159 | 5730 | 100 |
1184688 | 1184688 | 2021-04-03 | Washtenaw | Michigan | 26161 | 21959 | 260 |
1184689 | 1184689 | 2021-04-03 | Wayne | Michigan | 26163 | 123028 | 4291 |
1184690 | 1184690 | 2021-04-03 | Wexford | Michigan | 26165 | 2108 | 25 |
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);