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-06-11 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1408635 | 1408635 | 2021-06-11 | Alcona | Michigan | 26001 | 739 | 32 |
1408636 | 1408636 | 2021-06-11 | Alger | Michigan | 26003 | 667 | 7 |
1408637 | 1408637 | 2021-06-11 | Allegan | Michigan | 26005 | 11149 | 154 |
1408638 | 1408638 | 2021-06-11 | Alpena | Michigan | 26007 | 2266 | 62 |
1408639 | 1408639 | 2021-06-11 | Antrim | Michigan | 26009 | 1631 | 29 |
1408640 | 1408640 | 2021-06-11 | Arenac | Michigan | 26011 | 1207 | 29 |
1408641 | 1408641 | 2021-06-11 | Baraga | Michigan | 26013 | 987 | 38 |
1408642 | 1408642 | 2021-06-11 | Barry | Michigan | 26015 | 5948 | 68 |
1408643 | 1408643 | 2021-06-11 | Bay | Michigan | 26017 | 11235 | 351 |
1408644 | 1408644 | 2021-06-11 | Benzie | Michigan | 26019 | 1279 | 36 |
1408645 | 1408645 | 2021-06-11 | Berrien | Michigan | 26021 | 15550 | 288 |
1408646 | 1408646 | 2021-06-11 | Branch | Michigan | 26023 | 5701 | 120 |
1408647 | 1408647 | 2021-06-11 | Calhoun | Michigan | 26025 | 14501 | 314 |
1408648 | 1408648 | 2021-06-11 | Cass | Michigan | 26027 | 5480 | 76 |
1408649 | 1408649 | 2021-06-11 | Charlevoix | Michigan | 26029 | 1677 | 21 |
1408650 | 1408650 | 2021-06-11 | Cheboygan | Michigan | 26031 | 1930 | 45 |
1408651 | 1408651 | 2021-06-11 | Chippewa | Michigan | 26033 | 5615 | 49 |
1408652 | 1408652 | 2021-06-11 | Clare | Michigan | 26035 | 2464 | 83 |
1408653 | 1408653 | 2021-06-11 | Clinton | Michigan | 26037 | 7617 | 90 |
1408654 | 1408654 | 2021-06-11 | Crawford | Michigan | 26039 | 992 | 14 |
1408655 | 1408655 | 2021-06-11 | Delta | Michigan | 26041 | 4055 | 95 |
1408656 | 1408656 | 2021-06-11 | Dickinson | Michigan | 26043 | 2746 | 74 |
1408657 | 1408657 | 2021-06-11 | Eaton | Michigan | 26045 | 10136 | 207 |
1408658 | 1408658 | 2021-06-11 | Emmet | Michigan | 26047 | 2382 | 43 |
1408659 | 1408659 | 2021-06-11 | Genesee | Michigan | 26049 | 41678 | 959 |
1408660 | 1408660 | 2021-06-11 | Gladwin | Michigan | 26051 | 2301 | 58 |
1408661 | 1408661 | 2021-06-11 | Gogebic | Michigan | 26053 | 1405 | 51 |
1408662 | 1408662 | 2021-06-11 | Grand Traverse | Michigan | 26055 | 6469 | 97 |
1408663 | 1408663 | 2021-06-11 | Gratiot | Michigan | 26057 | 6965 | 124 |
1408664 | 1408664 | 2021-06-11 | Hillsdale | Michigan | 26059 | 4409 | 92 |
1408665 | 1408665 | 2021-06-11 | Houghton | Michigan | 26061 | 3135 | 43 |
1408666 | 1408666 | 2021-06-11 | Huron | Michigan | 26063 | 4086 | 82 |
1408667 | 1408667 | 2021-06-11 | Ingham | Michigan | 26065 | 24848 | 386 |
1408668 | 1408668 | 2021-06-11 | Ionia | Michigan | 26067 | 9309 | 85 |
1408669 | 1408669 | 2021-06-11 | Iosco | Michigan | 26069 | 2004 | 74 |
1408670 | 1408670 | 2021-06-11 | Iron | Michigan | 26071 | 1052 | 52 |
1408671 | 1408671 | 2021-06-11 | Isabella | Michigan | 26073 | 6325 | 99 |
1408672 | 1408672 | 2021-06-11 | Jackson | Michigan | 26075 | 20996 | 320 |
1408673 | 1408673 | 2021-06-11 | Kalamazoo | Michigan | 26077 | 23095 | 400 |
1408674 | 1408674 | 2021-06-11 | Kalkaska | Michigan | 26079 | 1130 | 25 |
1408675 | 1408675 | 2021-06-11 | Kent | Michigan | 26081 | 73146 | 850 |
1408676 | 1408676 | 2021-06-11 | Keweenaw | Michigan | 26083 | 174 | 2 |
1408677 | 1408677 | 2021-06-11 | Lake | Michigan | 26085 | 634 | 16 |
1408678 | 1408678 | 2021-06-11 | Lapeer | Michigan | 26087 | 9746 | 212 |
1408679 | 1408679 | 2021-06-11 | Leelanau | Michigan | 26089 | 1241 | 19 |
1408680 | 1408680 | 2021-06-11 | Lenawee | Michigan | 26091 | 10825 | 171 |
1408681 | 1408681 | 2021-06-11 | Livingston | Michigan | 26093 | 16752 | 193 |
1408682 | 1408682 | 2021-06-11 | Luce | Michigan | 26095 | 1337 | 6 |
1408683 | 1408683 | 2021-06-11 | Mackinac | Michigan | 26097 | 711 | 3 |
1408684 | 1408684 | 2021-06-11 | Macomb | Michigan | 26099 | 100409 | 2469 |
1408685 | 1408685 | 2021-06-11 | Manistee | Michigan | 26101 | 1972 | 24 |
1408686 | 1408686 | 2021-06-11 | Marquette | Michigan | 26103 | 5924 | 63 |
1408687 | 1408687 | 2021-06-11 | Mason | Michigan | 26105 | 2135 | 37 |
1408688 | 1408688 | 2021-06-11 | Mecosta | Michigan | 26107 | 3203 | 35 |
1408689 | 1408689 | 2021-06-11 | Menominee | Michigan | 26109 | 2122 | 43 |
1408690 | 1408690 | 2021-06-11 | Midland | Michigan | 26111 | 7554 | 92 |
1408691 | 1408691 | 2021-06-11 | Missaukee | Michigan | 26113 | 1508 | 27 |
1408692 | 1408692 | 2021-06-11 | Monroe | Michigan | 26115 | 15388 | 261 |
1408693 | 1408693 | 2021-06-11 | Montcalm | Michigan | 26117 | 8187 | 118 |
1408694 | 1408694 | 2021-06-11 | Montmorency | Michigan | 26119 | 614 | 20 |
1408695 | 1408695 | 2021-06-11 | Muskegon | Michigan | 26121 | 18338 | 376 |
1408696 | 1408696 | 2021-06-11 | Newaygo | Michigan | 26123 | 4879 | 69 |
1408697 | 1408697 | 2021-06-11 | Oakland | Michigan | 26125 | 118374 | 2411 |
1408698 | 1408698 | 2021-06-11 | Oceana | Michigan | 26127 | 2764 | 60 |
1408699 | 1408699 | 2021-06-11 | Ogemaw | Michigan | 26129 | 1741 | 43 |
1408700 | 1408700 | 2021-06-11 | Ontonagon | Michigan | 26131 | 482 | 21 |
1408701 | 1408701 | 2021-06-11 | Osceola | Michigan | 26133 | 1956 | 31 |
1408702 | 1408702 | 2021-06-11 | Oscoda | Michigan | 26135 | 690 | 31 |
1408703 | 1408703 | 2021-06-11 | Otsego | Michigan | 26137 | 2353 | 41 |
1408704 | 1408704 | 2021-06-11 | Ottawa | Michigan | 26139 | 32822 | 431 |
1408705 | 1408705 | 2021-06-11 | Presque Isle | Michigan | 26141 | 1054 | 34 |
1408706 | 1408706 | 2021-06-11 | Roscommon | Michigan | 26143 | 1897 | 53 |
1408707 | 1408707 | 2021-06-11 | Saginaw | Michigan | 26145 | 22473 | 622 |
1408708 | 1408708 | 2021-06-11 | Sanilac | Michigan | 26151 | 4256 | 125 |
1408709 | 1408709 | 2021-06-11 | Schoolcraft | Michigan | 26153 | 437 | 5 |
1408710 | 1408710 | 2021-06-11 | Shiawassee | Michigan | 26155 | 6414 | 105 |
1408711 | 1408711 | 2021-06-11 | St. Clair | Michigan | 26147 | 18465 | 444 |
1408712 | 1408712 | 2021-06-11 | St. Joseph | Michigan | 26149 | 6244 | 99 |
1408713 | 1408713 | 2021-06-11 | Tuscola | Michigan | 26157 | 5663 | 173 |
1408714 | 1408714 | 2021-06-11 | Unknown | Michigan | 665 | 15 | |
1408715 | 1408715 | 2021-06-11 | Van Buren | Michigan | 26159 | 7125 | 129 |
1408716 | 1408716 | 2021-06-11 | Washtenaw | Michigan | 26161 | 27074 | 307 |
1408717 | 1408717 | 2021-06-11 | Wayne | Michigan | 26163 | 165203 | 5101 |
1408718 | 1408718 | 2021-06-11 | Wexford | Michigan | 26165 | 2890 | 47 |
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);