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 2020-10-19 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
645867 | 645867 | 2020-10-19 | Alcona | Michigan | 26001 | 51 | 2 |
645868 | 645868 | 2020-10-19 | Alger | Michigan | 26003 | 97 | 1 |
645869 | 645869 | 2020-10-19 | Allegan | Michigan | 26005 | 1061 | 7 |
645870 | 645870 | 2020-10-19 | Alpena | Michigan | 26007 | 153 | 14 |
645871 | 645871 | 2020-10-19 | Antrim | Michigan | 26009 | 99 | 0 |
645872 | 645872 | 2020-10-19 | Arenac | Michigan | 26011 | 88 | 3 |
645873 | 645873 | 2020-10-19 | Baraga | Michigan | 26013 | 72 | 4 |
645874 | 645874 | 2020-10-19 | Barry | Michigan | 26015 | 540 | 5 |
645875 | 645875 | 2020-10-19 | Bay | Michigan | 26017 | 1246 | 55 |
645876 | 645876 | 2020-10-19 | Benzie | Michigan | 26019 | 108 | 2 |
645877 | 645877 | 2020-10-19 | Berrien | Michigan | 26021 | 2415 | 77 |
645878 | 645878 | 2020-10-19 | Branch | Michigan | 26023 | 1601 | 33 |
645879 | 645879 | 2020-10-19 | Calhoun | Michigan | 26025 | 2267 | 53 |
645880 | 645880 | 2020-10-19 | Cass | Michigan | 26027 | 841 | 23 |
645881 | 645881 | 2020-10-19 | Charlevoix | Michigan | 26029 | 142 | 4 |
645882 | 645882 | 2020-10-19 | Cheboygan | Michigan | 26031 | 119 | 2 |
645883 | 645883 | 2020-10-19 | Chippewa | Michigan | 26033 | 108 | 0 |
645884 | 645884 | 2020-10-19 | Clare | Michigan | 26035 | 215 | 8 |
645885 | 645885 | 2020-10-19 | Clinton | Michigan | 26037 | 906 | 14 |
645886 | 645886 | 2020-10-19 | Crawford | Michigan | 26039 | 139 | 5 |
645887 | 645887 | 2020-10-19 | Delta | Michigan | 26041 | 1005 | 18 |
645888 | 645888 | 2020-10-19 | Dickinson | Michigan | 26043 | 454 | 8 |
645889 | 645889 | 2020-10-19 | Eaton | Michigan | 26045 | 970 | 10 |
645890 | 645890 | 2020-10-19 | Emmet | Michigan | 26047 | 192 | 4 |
645891 | 645891 | 2020-10-19 | Genesee | Michigan | 26049 | 6025 | 324 |
645892 | 645892 | 2020-10-19 | Gladwin | Michigan | 26051 | 167 | 2 |
645893 | 645893 | 2020-10-19 | Gogebic | Michigan | 26053 | 277 | 2 |
645894 | 645894 | 2020-10-19 | Grand Traverse | Michigan | 26055 | 654 | 13 |
645895 | 645895 | 2020-10-19 | Gratiot | Michigan | 26057 | 415 | 16 |
645896 | 645896 | 2020-10-19 | Hillsdale | Michigan | 26059 | 456 | 27 |
645897 | 645897 | 2020-10-19 | Houghton | Michigan | 26061 | 853 | 7 |
645898 | 645898 | 2020-10-19 | Huron | Michigan | 26063 | 258 | 5 |
645899 | 645899 | 2020-10-19 | Ingham | Michigan | 26065 | 4324 | 58 |
645900 | 645900 | 2020-10-19 | Ionia | Michigan | 26067 | 765 | 8 |
645901 | 645901 | 2020-10-19 | Iosco | Michigan | 26069 | 270 | 15 |
645902 | 645902 | 2020-10-19 | Iron | Michigan | 26071 | 364 | 18 |
645903 | 645903 | 2020-10-19 | Isabella | Michigan | 26073 | 933 | 15 |
645904 | 645904 | 2020-10-19 | Jackson | Michigan | 26075 | 3239 | 84 |
645905 | 645905 | 2020-10-19 | Kalamazoo | Michigan | 26077 | 4199 | 100 |
645906 | 645906 | 2020-10-19 | Kalkaska | Michigan | 26079 | 117 | 4 |
645907 | 645907 | 2020-10-19 | Kent | Michigan | 26081 | 12673 | 178 |
645908 | 645908 | 2020-10-19 | Keweenaw | Michigan | 26083 | 18 | 0 |
645909 | 645909 | 2020-10-19 | Lake | Michigan | 26085 | 52 | 0 |
645910 | 645910 | 2020-10-19 | Lapeer | Michigan | 26087 | 1114 | 45 |
645911 | 645911 | 2020-10-19 | Leelanau | Michigan | 26089 | 134 | 1 |
645912 | 645912 | 2020-10-19 | Lenawee | Michigan | 26091 | 1749 | 22 |
645913 | 645913 | 2020-10-19 | Livingston | Michigan | 26093 | 1836 | 33 |
645914 | 645914 | 2020-10-19 | Luce | Michigan | 26095 | 287 | 0 |
645915 | 645915 | 2020-10-19 | Mackinac | Michigan | 26097 | 140 | 0 |
645916 | 645916 | 2020-10-19 | Macomb | Michigan | 26099 | 17321 | 1070 |
645917 | 645917 | 2020-10-19 | Manistee | Michigan | 26101 | 125 | 3 |
645918 | 645918 | 2020-10-19 | Marquette | Michigan | 26103 | 803 | 12 |
645919 | 645919 | 2020-10-19 | Mason | Michigan | 26105 | 188 | 1 |
645920 | 645920 | 2020-10-19 | Mecosta | Michigan | 26107 | 397 | 4 |
645921 | 645921 | 2020-10-19 | Menominee | Michigan | 26109 | 607 | 3 |
645922 | 645922 | 2020-10-19 | Midland | Michigan | 26111 | 829 | 13 |
645923 | 645923 | 2020-10-19 | Missaukee | Michigan | 26113 | 82 | 1 |
645924 | 645924 | 2020-10-19 | Monroe | Michigan | 26115 | 1819 | 31 |
645925 | 645925 | 2020-10-19 | Montcalm | Michigan | 26117 | 519 | 8 |
645926 | 645926 | 2020-10-19 | Montmorency | Michigan | 26119 | 21 | 0 |
645927 | 645927 | 2020-10-19 | Muskegon | Michigan | 26121 | 2828 | 80 |
645928 | 645928 | 2020-10-19 | Newaygo | Michigan | 26123 | 538 | 3 |
645929 | 645929 | 2020-10-19 | Oakland | Michigan | 26125 | 23165 | 1227 |
645930 | 645930 | 2020-10-19 | Oceana | Michigan | 26127 | 575 | 6 |
645931 | 645931 | 2020-10-19 | Ogemaw | Michigan | 26129 | 90 | 5 |
645932 | 645932 | 2020-10-19 | Ontonagon | Michigan | 26131 | 72 | 0 |
645933 | 645933 | 2020-10-19 | Osceola | Michigan | 26133 | 124 | 0 |
645934 | 645934 | 2020-10-19 | Oscoda | Michigan | 26135 | 52 | 1 |
645935 | 645935 | 2020-10-19 | Otsego | Michigan | 26137 | 222 | 12 |
645936 | 645936 | 2020-10-19 | Ottawa | Michigan | 26139 | 4448 | 72 |
645937 | 645937 | 2020-10-19 | Presque Isle | Michigan | 26141 | 35 | 1 |
645938 | 645938 | 2020-10-19 | Roscommon | Michigan | 26143 | 138 | 5 |
645939 | 645939 | 2020-10-19 | Saginaw | Michigan | 26145 | 3454 | 149 |
645940 | 645940 | 2020-10-19 | Sanilac | Michigan | 26151 | 169 | 7 |
645941 | 645941 | 2020-10-19 | Schoolcraft | Michigan | 26153 | 54 | 0 |
645942 | 645942 | 2020-10-19 | Shiawassee | Michigan | 26155 | 635 | 33 |
645943 | 645943 | 2020-10-19 | St. Clair | Michigan | 26147 | 1311 | 63 |
645944 | 645944 | 2020-10-19 | St. Joseph | Michigan | 26149 | 1062 | 12 |
645945 | 645945 | 2020-10-19 | Tuscola | Michigan | 26157 | 590 | 34 |
645946 | 645946 | 2020-10-19 | Unknown | Michigan | 727 | 4 | |
645947 | 645947 | 2020-10-19 | Van Buren | Michigan | 26159 | 958 | 18 |
645948 | 645948 | 2020-10-19 | Washtenaw | Michigan | 26161 | 5273 | 126 |
645949 | 645949 | 2020-10-19 | Wayne | Michigan | 26163 | 38461 | 3027 |
645950 | 645950 | 2020-10-19 | Wexford | Michigan | 26165 | 155 | 4 |
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);