ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-06-20" 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 |
---|---|---|---|---|---|---|---|
1437848 | 1437848 | 2021-06-20 | Alcona | Michigan | 26001 | 739 | 33 |
1437849 | 1437849 | 2021-06-20 | Alger | Michigan | 26003 | 668 | 7 |
1437850 | 1437850 | 2021-06-20 | Allegan | Michigan | 26005 | 11165 | 158 |
1437851 | 1437851 | 2021-06-20 | Alpena | Michigan | 26007 | 2269 | 62 |
1437852 | 1437852 | 2021-06-20 | Antrim | Michigan | 26009 | 1633 | 29 |
1437853 | 1437853 | 2021-06-20 | Arenac | Michigan | 26011 | 1208 | 29 |
1437854 | 1437854 | 2021-06-20 | Baraga | Michigan | 26013 | 990 | 39 |
1437855 | 1437855 | 2021-06-20 | Barry | Michigan | 26015 | 5952 | 69 |
1437856 | 1437856 | 2021-06-20 | Bay | Michigan | 26017 | 11248 | 353 |
1437857 | 1437857 | 2021-06-20 | Benzie | Michigan | 26019 | 1281 | 36 |
1437858 | 1437858 | 2021-06-20 | Berrien | Michigan | 26021 | 15565 | 290 |
1437859 | 1437859 | 2021-06-20 | Branch | Michigan | 26023 | 5726 | 120 |
1437860 | 1437860 | 2021-06-20 | Calhoun | Michigan | 26025 | 14527 | 314 |
1437861 | 1437861 | 2021-06-20 | Cass | Michigan | 26027 | 5489 | 77 |
1437862 | 1437862 | 2021-06-20 | Charlevoix | Michigan | 26029 | 1681 | 22 |
1437863 | 1437863 | 2021-06-20 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1437864 | 1437864 | 2021-06-20 | Chippewa | Michigan | 26033 | 5620 | 50 |
1437865 | 1437865 | 2021-06-20 | Clare | Michigan | 26035 | 2468 | 83 |
1437866 | 1437866 | 2021-06-20 | Clinton | Michigan | 26037 | 7634 | 91 |
1437867 | 1437867 | 2021-06-20 | Crawford | Michigan | 26039 | 994 | 14 |
1437868 | 1437868 | 2021-06-20 | Delta | Michigan | 26041 | 4056 | 95 |
1437869 | 1437869 | 2021-06-20 | Dickinson | Michigan | 26043 | 2754 | 74 |
1437870 | 1437870 | 2021-06-20 | Eaton | Michigan | 26045 | 10143 | 209 |
1437871 | 1437871 | 2021-06-20 | Emmet | Michigan | 26047 | 2383 | 43 |
1437872 | 1437872 | 2021-06-20 | Genesee | Michigan | 26049 | 41720 | 963 |
1437873 | 1437873 | 2021-06-20 | Gladwin | Michigan | 26051 | 2305 | 59 |
1437874 | 1437874 | 2021-06-20 | Gogebic | Michigan | 26053 | 1405 | 52 |
1437875 | 1437875 | 2021-06-20 | Grand Traverse | Michigan | 26055 | 6472 | 99 |
1437876 | 1437876 | 2021-06-20 | Gratiot | Michigan | 26057 | 6968 | 125 |
1437877 | 1437877 | 2021-06-20 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1437878 | 1437878 | 2021-06-20 | Houghton | Michigan | 26061 | 3139 | 43 |
1437879 | 1437879 | 2021-06-20 | Huron | Michigan | 26063 | 4089 | 82 |
1437880 | 1437880 | 2021-06-20 | Ingham | Michigan | 26065 | 24868 | 386 |
1437881 | 1437881 | 2021-06-20 | Ionia | Michigan | 26067 | 9319 | 85 |
1437882 | 1437882 | 2021-06-20 | Iosco | Michigan | 26069 | 2004 | 74 |
1437883 | 1437883 | 2021-06-20 | Iron | Michigan | 26071 | 1052 | 53 |
1437884 | 1437884 | 2021-06-20 | Isabella | Michigan | 26073 | 6332 | 99 |
1437885 | 1437885 | 2021-06-20 | Jackson | Michigan | 26075 | 21029 | 321 |
1437886 | 1437886 | 2021-06-20 | Kalamazoo | Michigan | 26077 | 23131 | 401 |
1437887 | 1437887 | 2021-06-20 | Kalkaska | Michigan | 26079 | 1138 | 25 |
1437888 | 1437888 | 2021-06-20 | Kent | Michigan | 26081 | 73244 | 855 |
1437889 | 1437889 | 2021-06-20 | Keweenaw | Michigan | 26083 | 174 | 2 |
1437890 | 1437890 | 2021-06-20 | Lake | Michigan | 26085 | 635 | 16 |
1437891 | 1437891 | 2021-06-20 | Lapeer | Michigan | 26087 | 9752 | 214 |
1437892 | 1437892 | 2021-06-20 | Leelanau | Michigan | 26089 | 1242 | 19 |
1437893 | 1437893 | 2021-06-20 | Lenawee | Michigan | 26091 | 10835 | 175 |
1437894 | 1437894 | 2021-06-20 | Livingston | Michigan | 26093 | 16772 | 195 |
1437895 | 1437895 | 2021-06-20 | Luce | Michigan | 26095 | 1338 | 6 |
1437896 | 1437896 | 2021-06-20 | Mackinac | Michigan | 26097 | 713 | 3 |
1437897 | 1437897 | 2021-06-20 | Macomb | Michigan | 26099 | 100533 | 2482 |
1437898 | 1437898 | 2021-06-20 | Manistee | Michigan | 26101 | 1975 | 24 |
1437899 | 1437899 | 2021-06-20 | Marquette | Michigan | 26103 | 5924 | 63 |
1437900 | 1437900 | 2021-06-20 | Mason | Michigan | 26105 | 2136 | 37 |
1437901 | 1437901 | 2021-06-20 | Mecosta | Michigan | 26107 | 3209 | 36 |
1437902 | 1437902 | 2021-06-20 | Menominee | Michigan | 26109 | 2125 | 43 |
1437903 | 1437903 | 2021-06-20 | Midland | Michigan | 26111 | 7564 | 93 |
1437904 | 1437904 | 2021-06-20 | Missaukee | Michigan | 26113 | 1511 | 27 |
1437905 | 1437905 | 2021-06-20 | Monroe | Michigan | 26115 | 15408 | 262 |
1437906 | 1437906 | 2021-06-20 | Montcalm | Michigan | 26117 | 8197 | 119 |
1437907 | 1437907 | 2021-06-20 | Montmorency | Michigan | 26119 | 615 | 20 |
1437908 | 1437908 | 2021-06-20 | Muskegon | Michigan | 26121 | 18370 | 379 |
1437909 | 1437909 | 2021-06-20 | Newaygo | Michigan | 26123 | 4884 | 69 |
1437910 | 1437910 | 2021-06-20 | Oakland | Michigan | 26125 | 118538 | 2426 |
1437911 | 1437911 | 2021-06-20 | Oceana | Michigan | 26127 | 2767 | 60 |
1437912 | 1437912 | 2021-06-20 | Ogemaw | Michigan | 26129 | 1742 | 44 |
1437913 | 1437913 | 2021-06-20 | Ontonagon | Michigan | 26131 | 482 | 21 |
1437914 | 1437914 | 2021-06-20 | Osceola | Michigan | 26133 | 1959 | 31 |
1437915 | 1437915 | 2021-06-20 | Oscoda | Michigan | 26135 | 691 | 31 |
1437916 | 1437916 | 2021-06-20 | Otsego | Michigan | 26137 | 2354 | 41 |
1437917 | 1437917 | 2021-06-20 | Ottawa | Michigan | 26139 | 32874 | 435 |
1437918 | 1437918 | 2021-06-20 | Presque Isle | Michigan | 26141 | 1056 | 34 |
1437919 | 1437919 | 2021-06-20 | Roscommon | Michigan | 26143 | 1898 | 53 |
1437920 | 1437920 | 2021-06-20 | Saginaw | Michigan | 26145 | 22497 | 630 |
1437921 | 1437921 | 2021-06-20 | Sanilac | Michigan | 26151 | 4257 | 125 |
1437922 | 1437922 | 2021-06-20 | Schoolcraft | Michigan | 26153 | 439 | 5 |
1437923 | 1437923 | 2021-06-20 | Shiawassee | Michigan | 26155 | 6427 | 106 |
1437924 | 1437924 | 2021-06-20 | St. Clair | Michigan | 26147 | 18490 | 448 |
1437925 | 1437925 | 2021-06-20 | St. Joseph | Michigan | 26149 | 6260 | 100 |
1437926 | 1437926 | 2021-06-20 | Tuscola | Michigan | 26157 | 5665 | 173 |
1437927 | 1437927 | 2021-06-20 | Unknown | Michigan | 906 | 16 | |
1437928 | 1437928 | 2021-06-20 | Van Buren | Michigan | 26159 | 7133 | 130 |
1437929 | 1437929 | 2021-06-20 | Washtenaw | Michigan | 26161 | 27100 | 308 |
1437930 | 1437930 | 2021-06-20 | Wayne | Michigan | 26163 | 165535 | 5142 |
1437931 | 1437931 | 2021-06-20 | Wexford | Michigan | 26165 | 2895 | 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);