ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-08-17" 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 |
---|---|---|---|---|---|---|---|
441928 | 441928 | 2020-08-17 | Alcona | Michigan | 26001 | 29 | 1 |
441929 | 441929 | 2020-08-17 | Alger | Michigan | 26003 | 17 | 0 |
441930 | 441930 | 2020-08-17 | Allegan | Michigan | 26005 | 572 | 6 |
441931 | 441931 | 2020-08-17 | Alpena | Michigan | 26007 | 130 | 13 |
441932 | 441932 | 2020-08-17 | Antrim | Michigan | 26009 | 43 | 0 |
441933 | 441933 | 2020-08-17 | Arenac | Michigan | 26011 | 49 | 3 |
441934 | 441934 | 2020-08-17 | Baraga | Michigan | 26013 | 5 | 0 |
441935 | 441935 | 2020-08-17 | Barry | Michigan | 26015 | 200 | 2 |
441936 | 441936 | 2020-08-17 | Bay | Michigan | 26017 | 712 | 35 |
441937 | 441937 | 2020-08-17 | Benzie | Michigan | 26019 | 35 | 1 |
441938 | 441938 | 2020-08-17 | Berrien | Michigan | 26021 | 1530 | 68 |
441939 | 441939 | 2020-08-17 | Branch | Michigan | 26023 | 1198 | 25 |
441940 | 441940 | 2020-08-17 | Calhoun | Michigan | 26025 | 849 | 43 |
441941 | 441941 | 2020-08-17 | Cass | Michigan | 26027 | 363 | 15 |
441942 | 441942 | 2020-08-17 | Charlevoix | Michigan | 26029 | 62 | 2 |
441943 | 441943 | 2020-08-17 | Cheboygan | Michigan | 26031 | 57 | 2 |
441944 | 441944 | 2020-08-17 | Chippewa | Michigan | 26033 | 45 | 0 |
441945 | 441945 | 2020-08-17 | Clare | Michigan | 26035 | 84 | 3 |
441946 | 441946 | 2020-08-17 | Clinton | Michigan | 26037 | 440 | 13 |
441947 | 441947 | 2020-08-17 | Crawford | Michigan | 26039 | 110 | 5 |
441948 | 441948 | 2020-08-17 | Delta | Michigan | 26041 | 116 | 3 |
441949 | 441949 | 2020-08-17 | Dickinson | Michigan | 26043 | 59 | 2 |
441950 | 441950 | 2020-08-17 | Eaton | Michigan | 26045 | 474 | 8 |
441951 | 441951 | 2020-08-17 | Emmet | Michigan | 26047 | 84 | 2 |
441952 | 441952 | 2020-08-17 | Genesee | Michigan | 26049 | 3758 | 298 |
441953 | 441953 | 2020-08-17 | Gladwin | Michigan | 26051 | 68 | 2 |
441954 | 441954 | 2020-08-17 | Gogebic | Michigan | 26053 | 135 | 1 |
441955 | 441955 | 2020-08-17 | Grand Traverse | Michigan | 26055 | 252 | 5 |
441956 | 441956 | 2020-08-17 | Gratiot | Michigan | 26057 | 172 | 15 |
441957 | 441957 | 2020-08-17 | Hillsdale | Michigan | 26059 | 283 | 25 |
441958 | 441958 | 2020-08-17 | Houghton | Michigan | 26061 | 55 | 0 |
441959 | 441959 | 2020-08-17 | Huron | Michigan | 26063 | 176 | 4 |
441960 | 441960 | 2020-08-17 | Ingham | Michigan | 26065 | 1641 | 33 |
441961 | 441961 | 2020-08-17 | Ionia | Michigan | 26067 | 281 | 7 |
441962 | 441962 | 2020-08-17 | Iosco | Michigan | 26069 | 136 | 12 |
441963 | 441963 | 2020-08-17 | Iron | Michigan | 26071 | 24 | 1 |
441964 | 441964 | 2020-08-17 | Isabella | Michigan | 26073 | 227 | 9 |
441965 | 441965 | 2020-08-17 | Jackson | Michigan | 26075 | 2470 | 57 |
441966 | 441966 | 2020-08-17 | Kalamazoo | Michigan | 26077 | 1754 | 86 |
441967 | 441967 | 2020-08-17 | Kalkaska | Michigan | 26079 | 57 | 4 |
441968 | 441968 | 2020-08-17 | Kent | Michigan | 26081 | 7808 | 158 |
441969 | 441969 | 2020-08-17 | Keweenaw | Michigan | 26083 | 3 | 0 |
441970 | 441970 | 2020-08-17 | Lake | Michigan | 26085 | 29 | 0 |
441971 | 441971 | 2020-08-17 | Lapeer | Michigan | 26087 | 813 | 40 |
441972 | 441972 | 2020-08-17 | Leelanau | Michigan | 26089 | 76 | 0 |
441973 | 441973 | 2020-08-17 | Lenawee | Michigan | 26091 | 1206 | 17 |
441974 | 441974 | 2020-08-17 | Livingston | Michigan | 26093 | 971 | 29 |
441975 | 441975 | 2020-08-17 | Luce | Michigan | 26095 | 33 | 0 |
441976 | 441976 | 2020-08-17 | Mackinac | Michigan | 26097 | 27 | 0 |
441977 | 441977 | 2020-08-17 | Macomb | Michigan | 26099 | 11647 | 960 |
441978 | 441978 | 2020-08-17 | Manistee | Michigan | 26101 | 55 | 1 |
441979 | 441979 | 2020-08-17 | Marquette | Michigan | 26103 | 196 | 11 |
441980 | 441980 | 2020-08-17 | Mason | Michigan | 26105 | 108 | 0 |
441981 | 441981 | 2020-08-17 | Mecosta | Michigan | 26107 | 74 | 2 |
441982 | 441982 | 2020-08-17 | Menominee | Michigan | 26109 | 182 | 0 |
441983 | 441983 | 2020-08-17 | Midland | Michigan | 26111 | 360 | 10 |
441984 | 441984 | 2020-08-17 | Missaukee | Michigan | 26113 | 42 | 1 |
441985 | 441985 | 2020-08-17 | Monroe | Michigan | 26115 | 1074 | 23 |
441986 | 441986 | 2020-08-17 | Montcalm | Michigan | 26117 | 206 | 3 |
441987 | 441987 | 2020-08-17 | Montmorency | Michigan | 26119 | 8 | 0 |
441988 | 441988 | 2020-08-17 | Muskegon | Michigan | 26121 | 1444 | 63 |
441989 | 441989 | 2020-08-17 | Newaygo | Michigan | 26123 | 275 | 0 |
441990 | 441990 | 2020-08-17 | Oakland | Michigan | 26125 | 16547 | 1142 |
441991 | 441991 | 2020-08-17 | Oceana | Michigan | 26127 | 489 | 6 |
441992 | 441992 | 2020-08-17 | Ogemaw | Michigan | 26129 | 55 | 3 |
441993 | 441993 | 2020-08-17 | Ontonagon | Michigan | 26131 | 29 | 0 |
441994 | 441994 | 2020-08-17 | Osceola | Michigan | 26133 | 71 | 0 |
441995 | 441995 | 2020-08-17 | Oscoda | Michigan | 26135 | 27 | 1 |
441996 | 441996 | 2020-08-17 | Otsego | Michigan | 26137 | 147 | 11 |
441997 | 441997 | 2020-08-17 | Ottawa | Michigan | 26139 | 1942 | 59 |
441998 | 441998 | 2020-08-17 | Presque Isle | Michigan | 26141 | 21 | 1 |
441999 | 441999 | 2020-08-17 | Roscommon | Michigan | 26143 | 58 | 2 |
442000 | 442000 | 2020-08-17 | Saginaw | Michigan | 26145 | 2192 | 128 |
442001 | 442001 | 2020-08-17 | Sanilac | Michigan | 26151 | 117 | 6 |
442002 | 442002 | 2020-08-17 | Schoolcraft | Michigan | 26153 | 13 | 0 |
442003 | 442003 | 2020-08-17 | Shiawassee | Michigan | 26155 | 354 | 28 |
442004 | 442004 | 2020-08-17 | St. Clair | Michigan | 26147 | 845 | 53 |
442005 | 442005 | 2020-08-17 | St. Joseph | Michigan | 26149 | 637 | 10 |
442006 | 442006 | 2020-08-17 | Tuscola | Michigan | 26157 | 386 | 29 |
442007 | 442007 | 2020-08-17 | Unknown | Michigan | 543 | 3 | |
442008 | 442008 | 2020-08-17 | Van Buren | Michigan | 26159 | 509 | 13 |
442009 | 442009 | 2020-08-17 | Washtenaw | Michigan | 26161 | 3181 | 123 |
442010 | 442010 | 2020-08-17 | Wayne | Michigan | 26163 | 29242 | 2841 |
442011 | 442011 | 2020-08-17 | Wexford | Michigan | 26165 | 78 | 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);