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-02-09 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1012556 | 1012556 | 2021-02-09 | Alcona | Michigan | 26001 | 419 | 24 |
1012557 | 1012557 | 2021-02-09 | Alger | Michigan | 26003 | 578 | 3 |
1012558 | 1012558 | 2021-02-09 | Allegan | Michigan | 26005 | 7076 | 112 |
1012559 | 1012559 | 2021-02-09 | Alpena | Michigan | 26007 | 1439 | 46 |
1012560 | 1012560 | 2021-02-09 | Antrim | Michigan | 26009 | 882 | 19 |
1012561 | 1012561 | 2021-02-09 | Arenac | Michigan | 26011 | 730 | 24 |
1012562 | 1012562 | 2021-02-09 | Baraga | Michigan | 26013 | 764 | 32 |
1012563 | 1012563 | 2021-02-09 | Barry | Michigan | 26015 | 3616 | 41 |
1012564 | 1012564 | 2021-02-09 | Bay | Michigan | 26017 | 7211 | 275 |
1012565 | 1012565 | 2021-02-09 | Benzie | Michigan | 26019 | 880 | 31 |
1012566 | 1012566 | 2021-02-09 | Berrien | Michigan | 26021 | 11172 | 228 |
1012567 | 1012567 | 2021-02-09 | Branch | Michigan | 26023 | 4527 | 107 |
1012568 | 1012568 | 2021-02-09 | Calhoun | Michigan | 26025 | 9172 | 225 |
1012569 | 1012569 | 2021-02-09 | Cass | Michigan | 26027 | 3842 | 58 |
1012570 | 1012570 | 2021-02-09 | Charlevoix | Michigan | 26029 | 1017 | 12 |
1012571 | 1012571 | 2021-02-09 | Cheboygan | Michigan | 26031 | 874 | 35 |
1012572 | 1012572 | 2021-02-09 | Chippewa | Michigan | 26033 | 4667 | 40 |
1012573 | 1012573 | 2021-02-09 | Clare | Michigan | 26035 | 1569 | 69 |
1012574 | 1012574 | 2021-02-09 | Clinton | Michigan | 26037 | 4872 | 68 |
1012575 | 1012575 | 2021-02-09 | Crawford | Michigan | 26039 | 569 | 5 |
1012576 | 1012576 | 2021-02-09 | Delta | Michigan | 26041 | 3087 | 84 |
1012577 | 1012577 | 2021-02-09 | Dickinson | Michigan | 26043 | 2350 | 69 |
1012578 | 1012578 | 2021-02-09 | Eaton | Michigan | 26045 | 5983 | 144 |
1012579 | 1012579 | 2021-02-09 | Emmet | Michigan | 26047 | 1447 | 36 |
1012580 | 1012580 | 2021-02-09 | Genesee | Michigan | 26049 | 24732 | 736 |
1012581 | 1012581 | 2021-02-09 | Gladwin | Michigan | 26051 | 1450 | 42 |
1012582 | 1012582 | 2021-02-09 | Gogebic | Michigan | 26053 | 1208 | 45 |
1012583 | 1012583 | 2021-02-09 | Grand Traverse | Michigan | 26055 | 4073 | 64 |
1012584 | 1012584 | 2021-02-09 | Gratiot | Michigan | 26057 | 5617 | 101 |
1012585 | 1012585 | 2021-02-09 | Hillsdale | Michigan | 26059 | 3220 | 71 |
1012586 | 1012586 | 2021-02-09 | Houghton | Michigan | 26061 | 2517 | 39 |
1012587 | 1012587 | 2021-02-09 | Huron | Michigan | 26063 | 2044 | 55 |
1012588 | 1012588 | 2021-02-09 | Ingham | Michigan | 26065 | 15616 | 266 |
1012589 | 1012589 | 2021-02-09 | Ionia | Michigan | 26067 | 6438 | 70 |
1012590 | 1012590 | 2021-02-09 | Iosco | Michigan | 26069 | 1262 | 65 |
1012591 | 1012591 | 2021-02-09 | Iron | Michigan | 26071 | 922 | 48 |
1012592 | 1012592 | 2021-02-09 | Isabella | Michigan | 26073 | 3900 | 71 |
1012593 | 1012593 | 2021-02-09 | Jackson | Michigan | 26075 | 13758 | 233 |
1012594 | 1012594 | 2021-02-09 | Kalamazoo | Michigan | 26077 | 14486 | 315 |
1012595 | 1012595 | 2021-02-09 | Kalkaska | Michigan | 26079 | 570 | 14 |
1012596 | 1012596 | 2021-02-09 | Kent | Michigan | 26081 | 50164 | 680 |
1012597 | 1012597 | 2021-02-09 | Keweenaw | Michigan | 26083 | 130 | 2 |
1012598 | 1012598 | 2021-02-09 | Lake | Michigan | 26085 | 355 | 11 |
1012599 | 1012599 | 2021-02-09 | Lapeer | Michigan | 26087 | 5261 | 125 |
1012600 | 1012600 | 2021-02-09 | Leelanau | Michigan | 26089 | 834 | 14 |
1012601 | 1012601 | 2021-02-09 | Lenawee | Michigan | 26091 | 7378 | 114 |
1012602 | 1012602 | 2021-02-09 | Livingston | Michigan | 26093 | 9958 | 129 |
1012603 | 1012603 | 2021-02-09 | Luce | Michigan | 26095 | 1069 | 2 |
1012604 | 1012604 | 2021-02-09 | Mackinac | Michigan | 26097 | 428 | 3 |
1012605 | 1012605 | 2021-02-09 | Macomb | Michigan | 26099 | 57397 | 1913 |
1012606 | 1012606 | 2021-02-09 | Manistee | Michigan | 26101 | 1375 | 20 |
1012607 | 1012607 | 2021-02-09 | Marquette | Michigan | 26103 | 4765 | 54 |
1012608 | 1012608 | 2021-02-09 | Mason | Michigan | 26105 | 1211 | 26 |
1012609 | 1012609 | 2021-02-09 | Mecosta | Michigan | 26107 | 1932 | 19 |
1012610 | 1012610 | 2021-02-09 | Menominee | Michigan | 26109 | 1857 | 36 |
1012611 | 1012611 | 2021-02-09 | Midland | Michigan | 26111 | 4858 | 61 |
1012612 | 1012612 | 2021-02-09 | Missaukee | Michigan | 26113 | 712 | 17 |
1012613 | 1012613 | 2021-02-09 | Monroe | Michigan | 26115 | 9405 | 187 |
1012614 | 1012614 | 2021-02-09 | Montcalm | Michigan | 26117 | 5502 | 90 |
1012615 | 1012615 | 2021-02-09 | Montmorency | Michigan | 26119 | 351 | 17 |
1012616 | 1012616 | 2021-02-09 | Muskegon | Michigan | 26121 | 12521 | 314 |
1012617 | 1012617 | 2021-02-09 | Newaygo | Michigan | 26123 | 2696 | 46 |
1012618 | 1012618 | 2021-02-09 | Oakland | Michigan | 26125 | 72246 | 1933 |
1012619 | 1012619 | 2021-02-09 | Oceana | Michigan | 26127 | 1833 | 49 |
1012620 | 1012620 | 2021-02-09 | Ogemaw | Michigan | 26129 | 1093 | 32 |
1012621 | 1012621 | 2021-02-09 | Ontonagon | Michigan | 26131 | 398 | 19 |
1012622 | 1012622 | 2021-02-09 | Osceola | Michigan | 26133 | 1018 | 22 |
1012623 | 1012623 | 2021-02-09 | Oscoda | Michigan | 26135 | 388 | 18 |
1012624 | 1012624 | 2021-02-09 | Otsego | Michigan | 26137 | 1126 | 25 |
1012625 | 1012625 | 2021-02-09 | Ottawa | Michigan | 26139 | 21673 | 340 |
1012626 | 1012626 | 2021-02-09 | Presque Isle | Michigan | 26141 | 638 | 26 |
1012627 | 1012627 | 2021-02-09 | Roscommon | Michigan | 26143 | 1112 | 31 |
1012628 | 1012628 | 2021-02-09 | Saginaw | Michigan | 26145 | 15570 | 487 |
1012629 | 1012629 | 2021-02-09 | Sanilac | Michigan | 26151 | 1920 | 73 |
1012630 | 1012630 | 2021-02-09 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1012631 | 1012631 | 2021-02-09 | Shiawassee | Michigan | 26155 | 3650 | 74 |
1012632 | 1012632 | 2021-02-09 | St. Clair | Michigan | 26147 | 8393 | 243 |
1012633 | 1012633 | 2021-02-09 | St. Joseph | Michigan | 26149 | 4517 | 80 |
1012634 | 1012634 | 2021-02-09 | Tuscola | Michigan | 26157 | 3068 | 131 |
1012635 | 1012635 | 2021-02-09 | Unknown | Michigan | 0 | 15 | |
1012636 | 1012636 | 2021-02-09 | Van Buren | Michigan | 26159 | 4839 | 95 |
1012637 | 1012637 | 2021-02-09 | Washtenaw | Michigan | 26161 | 18116 | 241 |
1012638 | 1012638 | 2021-02-09 | Wayne | Michigan | 26163 | 98659 | 4053 |
1012639 | 1012639 | 2021-02-09 | Wexford | Michigan | 26165 | 1357 | 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);