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-07-15 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
335869 | 335869 | 2020-07-15 | Alcona | Michigan | 26001 | 25 | 1 |
335870 | 335870 | 2020-07-15 | Alger | Michigan | 26003 | 5 | 0 |
335871 | 335871 | 2020-07-15 | Allegan | Michigan | 26005 | 400 | 7 |
335872 | 335872 | 2020-07-15 | Alpena | Michigan | 26007 | 123 | 12 |
335873 | 335873 | 2020-07-15 | Antrim | Michigan | 26009 | 27 | 0 |
335874 | 335874 | 2020-07-15 | Arenac | Michigan | 26011 | 38 | 2 |
335875 | 335875 | 2020-07-15 | Baraga | Michigan | 26013 | 5 | 0 |
335876 | 335876 | 2020-07-15 | Barry | Michigan | 26015 | 140 | 2 |
335877 | 335877 | 2020-07-15 | Bay | Michigan | 26017 | 442 | 31 |
335878 | 335878 | 2020-07-15 | Benzie | Michigan | 26019 | 16 | 1 |
335879 | 335879 | 2020-07-15 | Berrien | Michigan | 26021 | 1106 | 61 |
335880 | 335880 | 2020-07-15 | Branch | Michigan | 26023 | 1079 | 25 |
335881 | 335881 | 2020-07-15 | Calhoun | Michigan | 26025 | 630 | 39 |
335882 | 335882 | 2020-07-15 | Cass | Michigan | 26027 | 208 | 6 |
335883 | 335883 | 2020-07-15 | Charlevoix | Michigan | 26029 | 44 | 2 |
335884 | 335884 | 2020-07-15 | Cheboygan | Michigan | 26031 | 29 | 2 |
335885 | 335885 | 2020-07-15 | Chippewa | Michigan | 26033 | 24 | 0 |
335886 | 335886 | 2020-07-15 | Clare | Michigan | 26035 | 35 | 3 |
335887 | 335887 | 2020-07-15 | Clinton | Michigan | 26037 | 305 | 12 |
335888 | 335888 | 2020-07-15 | Crawford | Michigan | 26039 | 84 | 5 |
335889 | 335889 | 2020-07-15 | Delta | Michigan | 26041 | 37 | 3 |
335890 | 335890 | 2020-07-15 | Dickinson | Michigan | 26043 | 21 | 2 |
335891 | 335891 | 2020-07-15 | Eaton | Michigan | 26045 | 360 | 7 |
335892 | 335892 | 2020-07-15 | Emmet | Michigan | 26047 | 44 | 2 |
335893 | 335893 | 2020-07-15 | Genesee | Michigan | 26049 | 2986 | 291 |
335894 | 335894 | 2020-07-15 | Gladwin | Michigan | 26051 | 29 | 1 |
335895 | 335895 | 2020-07-15 | Gogebic | Michigan | 26053 | 18 | 1 |
335896 | 335896 | 2020-07-15 | Grand Traverse | Michigan | 26055 | 108 | 5 |
335897 | 335897 | 2020-07-15 | Gratiot | Michigan | 26057 | 113 | 14 |
335898 | 335898 | 2020-07-15 | Hillsdale | Michigan | 26059 | 212 | 25 |
335899 | 335899 | 2020-07-15 | Houghton | Michigan | 26061 | 31 | 0 |
335900 | 335900 | 2020-07-15 | Huron | Michigan | 26063 | 86 | 3 |
335901 | 335901 | 2020-07-15 | Ingham | Michigan | 26065 | 1210 | 29 |
335902 | 335902 | 2020-07-15 | Ionia | Michigan | 26067 | 225 | 5 |
335903 | 335903 | 2020-07-15 | Iosco | Michigan | 26069 | 122 | 11 |
335904 | 335904 | 2020-07-15 | Iron | Michigan | 26071 | 8 | 1 |
335905 | 335905 | 2020-07-15 | Isabella | Michigan | 26073 | 174 | 8 |
335906 | 335906 | 2020-07-15 | Jackson | Michigan | 26075 | 2168 | 54 |
335907 | 335907 | 2020-07-15 | Kalamazoo | Michigan | 26077 | 1268 | 71 |
335908 | 335908 | 2020-07-15 | Kalkaska | Michigan | 26079 | 44 | 3 |
335909 | 335909 | 2020-07-15 | Kent | Michigan | 26081 | 6067 | 145 |
335910 | 335910 | 2020-07-15 | Keweenaw | Michigan | 26083 | 2 | 0 |
335911 | 335911 | 2020-07-15 | Lake | Michigan | 26085 | 13 | 0 |
335912 | 335912 | 2020-07-15 | Lapeer | Michigan | 26087 | 640 | 39 |
335913 | 335913 | 2020-07-15 | Leelanau | Michigan | 26089 | 47 | 0 |
335914 | 335914 | 2020-07-15 | Lenawee | Michigan | 26091 | 1021 | 15 |
335915 | 335915 | 2020-07-15 | Livingston | Michigan | 26093 | 675 | 29 |
335916 | 335916 | 2020-07-15 | Luce | Michigan | 26095 | 4 | 0 |
335917 | 335917 | 2020-07-15 | Mackinac | Michigan | 26097 | 9 | 0 |
335918 | 335918 | 2020-07-15 | Macomb | Michigan | 26099 | 8277 | 934 |
335919 | 335919 | 2020-07-15 | Manistee | Michigan | 26101 | 40 | 0 |
335920 | 335920 | 2020-07-15 | Marquette | Michigan | 26103 | 98 | 11 |
335921 | 335921 | 2020-07-15 | Mason | Michigan | 26105 | 80 | 0 |
335922 | 335922 | 2020-07-15 | Mecosta | Michigan | 26107 | 43 | 2 |
335923 | 335923 | 2020-07-15 | Menominee | Michigan | 26109 | 51 | 0 |
335924 | 335924 | 2020-07-15 | Midland | Michigan | 26111 | 202 | 9 |
335925 | 335925 | 2020-07-15 | Missaukee | Michigan | 26113 | 37 | 1 |
335926 | 335926 | 2020-07-15 | Monroe | Michigan | 26115 | 693 | 23 |
335927 | 335927 | 2020-07-15 | Montcalm | Michigan | 26117 | 131 | 1 |
335928 | 335928 | 2020-07-15 | Montmorency | Michigan | 26119 | 7 | 0 |
335929 | 335929 | 2020-07-15 | Muskegon | Michigan | 26121 | 958 | 54 |
335930 | 335930 | 2020-07-15 | Newaygo | Michigan | 26123 | 204 | 0 |
335931 | 335931 | 2020-07-15 | Oakland | Michigan | 26125 | 13022 | 1110 |
335932 | 335932 | 2020-07-15 | Oceana | Michigan | 26127 | 414 | 5 |
335933 | 335933 | 2020-07-15 | Ogemaw | Michigan | 26129 | 46 | 2 |
335934 | 335934 | 2020-07-15 | Ontonagon | Michigan | 26131 | 1 | 0 |
335935 | 335935 | 2020-07-15 | Osceola | Michigan | 26133 | 52 | 0 |
335936 | 335936 | 2020-07-15 | Oscoda | Michigan | 26135 | 23 | 1 |
335937 | 335937 | 2020-07-15 | Otsego | Michigan | 26137 | 137 | 10 |
335938 | 335938 | 2020-07-15 | Ottawa | Michigan | 26139 | 1381 | 53 |
335939 | 335939 | 2020-07-15 | Presque Isle | Michigan | 26141 | 14 | 0 |
335940 | 335940 | 2020-07-15 | Roscommon | Michigan | 26143 | 38 | 0 |
335941 | 335941 | 2020-07-15 | Saginaw | Michigan | 26145 | 1460 | 125 |
335942 | 335942 | 2020-07-15 | Sanilac | Michigan | 26151 | 59 | 6 |
335943 | 335943 | 2020-07-15 | Schoolcraft | Michigan | 26153 | 7 | 0 |
335944 | 335944 | 2020-07-15 | Shiawassee | Michigan | 26155 | 285 | 28 |
335945 | 335945 | 2020-07-15 | St. Clair | Michigan | 26147 | 626 | 53 |
335946 | 335946 | 2020-07-15 | St. Joseph | Michigan | 26149 | 414 | 5 |
335947 | 335947 | 2020-07-15 | Tuscola | Michigan | 26157 | 244 | 27 |
335948 | 335948 | 2020-07-15 | Unknown | Michigan | 153 | 2 | |
335949 | 335949 | 2020-07-15 | Van Buren | Michigan | 26159 | 286 | 9 |
335950 | 335950 | 2020-07-15 | Washtenaw | Michigan | 26161 | 2483 | 119 |
335951 | 335951 | 2020-07-15 | Wayne | Michigan | 26163 | 24549 | 2764 |
335952 | 335952 | 2020-07-15 | Wexford | Michigan | 26165 | 59 | 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);