ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-08-16" 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 |
---|---|---|---|---|---|---|---|
1622934 | 1622934 | 2021-08-16 | Alcona | Michigan | 26001 | 779 | 33 |
1622935 | 1622935 | 2021-08-16 | Alger | Michigan | 26003 | 677 | 7 |
1622936 | 1622936 | 2021-08-16 | Allegan | Michigan | 26005 | 11662 | 163 |
1622937 | 1622937 | 2021-08-16 | Alpena | Michigan | 26007 | 2420 | 66 |
1622938 | 1622938 | 2021-08-16 | Antrim | Michigan | 26009 | 1696 | 31 |
1622939 | 1622939 | 2021-08-16 | Arenac | Michigan | 26011 | 1249 | 29 |
1622940 | 1622940 | 2021-08-16 | Baraga | Michigan | 26013 | 1009 | 41 |
1622941 | 1622941 | 2021-08-16 | Barry | Michigan | 26015 | 6150 | 72 |
1622942 | 1622942 | 2021-08-16 | Bay | Michigan | 26017 | 11537 | 357 |
1622943 | 1622943 | 2021-08-16 | Benzie | Michigan | 26019 | 1315 | 38 |
1622944 | 1622944 | 2021-08-16 | Berrien | Michigan | 26021 | 16059 | 302 |
1622945 | 1622945 | 2021-08-16 | Branch | Michigan | 26023 | 6159 | 122 |
1622946 | 1622946 | 2021-08-16 | Calhoun | Michigan | 26025 | 15084 | 322 |
1622947 | 1622947 | 2021-08-16 | Cass | Michigan | 26027 | 5697 | 78 |
1622948 | 1622948 | 2021-08-16 | Charlevoix | Michigan | 26029 | 1828 | 25 |
1622949 | 1622949 | 2021-08-16 | Cheboygan | Michigan | 26031 | 1982 | 49 |
1622950 | 1622950 | 2021-08-16 | Chippewa | Michigan | 26033 | 5714 | 50 |
1622951 | 1622951 | 2021-08-16 | Clare | Michigan | 26035 | 2562 | 87 |
1622952 | 1622952 | 2021-08-16 | Clinton | Michigan | 26037 | 7904 | 94 |
1622953 | 1622953 | 2021-08-16 | Crawford | Michigan | 26039 | 1023 | 14 |
1622954 | 1622954 | 2021-08-16 | Delta | Michigan | 26041 | 4255 | 95 |
1622955 | 1622955 | 2021-08-16 | Dickinson | Michigan | 26043 | 2834 | 74 |
1622956 | 1622956 | 2021-08-16 | Eaton | Michigan | 26045 | 10497 | 211 |
1622957 | 1622957 | 2021-08-16 | Emmet | Michigan | 26047 | 2476 | 43 |
1622958 | 1622958 | 2021-08-16 | Genesee | Michigan | 26049 | 42900 | 990 |
1622959 | 1622959 | 2021-08-16 | Gladwin | Michigan | 26051 | 2352 | 61 |
1622960 | 1622960 | 2021-08-16 | Gogebic | Michigan | 26053 | 1492 | 53 |
1622961 | 1622961 | 2021-08-16 | Grand Traverse | Michigan | 26055 | 6760 | 101 |
1622962 | 1622962 | 2021-08-16 | Gratiot | Michigan | 26057 | 7060 | 125 |
1622963 | 1622963 | 2021-08-16 | Hillsdale | Michigan | 26059 | 4562 | 96 |
1622964 | 1622964 | 2021-08-16 | Houghton | Michigan | 26061 | 3221 | 43 |
1622965 | 1622965 | 2021-08-16 | Huron | Michigan | 26063 | 4192 | 84 |
1622966 | 1622966 | 2021-08-16 | Ingham | Michigan | 26065 | 25812 | 397 |
1622967 | 1622967 | 2021-08-16 | Ionia | Michigan | 26067 | 9555 | 86 |
1622968 | 1622968 | 2021-08-16 | Iosco | Michigan | 26069 | 2103 | 75 |
1622969 | 1622969 | 2021-08-16 | Iron | Michigan | 26071 | 1086 | 53 |
1622970 | 1622970 | 2021-08-16 | Isabella | Michigan | 26073 | 6480 | 101 |
1622971 | 1622971 | 2021-08-16 | Jackson | Michigan | 26075 | 21728 | 328 |
1622972 | 1622972 | 2021-08-16 | Kalamazoo | Michigan | 26077 | 24206 | 407 |
1622973 | 1622973 | 2021-08-16 | Kalkaska | Michigan | 26079 | 1210 | 29 |
1622974 | 1622974 | 2021-08-16 | Kent | Michigan | 26081 | 75717 | 875 |
1622975 | 1622975 | 2021-08-16 | Keweenaw | Michigan | 26083 | 174 | 2 |
1622976 | 1622976 | 2021-08-16 | Lake | Michigan | 26085 | 660 | 17 |
1622977 | 1622977 | 2021-08-16 | Lapeer | Michigan | 26087 | 10026 | 216 |
1622978 | 1622978 | 2021-08-16 | Leelanau | Michigan | 26089 | 1290 | 20 |
1622979 | 1622979 | 2021-08-16 | Lenawee | Michigan | 26091 | 11173 | 179 |
1622980 | 1622980 | 2021-08-16 | Livingston | Michigan | 26093 | 17507 | 197 |
1622981 | 1622981 | 2021-08-16 | Luce | Michigan | 26095 | 1349 | 6 |
1622982 | 1622982 | 2021-08-16 | Mackinac | Michigan | 26097 | 731 | 3 |
1622983 | 1622983 | 2021-08-16 | Macomb | Michigan | 26099 | 103518 | 2521 |
1622984 | 1622984 | 2021-08-16 | Manistee | Michigan | 26101 | 2047 | 26 |
1622985 | 1622985 | 2021-08-16 | Marquette | Michigan | 26103 | 5990 | 66 |
1622986 | 1622986 | 2021-08-16 | Mason | Michigan | 26105 | 2249 | 39 |
1622987 | 1622987 | 2021-08-16 | Mecosta | Michigan | 26107 | 3293 | 38 |
1622988 | 1622988 | 2021-08-16 | Menominee | Michigan | 26109 | 2238 | 43 |
1622989 | 1622989 | 2021-08-16 | Midland | Michigan | 26111 | 7806 | 97 |
1622990 | 1622990 | 2021-08-16 | Missaukee | Michigan | 26113 | 1539 | 29 |
1622991 | 1622991 | 2021-08-16 | Monroe | Michigan | 26115 | 15933 | 268 |
1622992 | 1622992 | 2021-08-16 | Montcalm | Michigan | 26117 | 8311 | 122 |
1622993 | 1622993 | 2021-08-16 | Montmorency | Michigan | 26119 | 660 | 20 |
1622994 | 1622994 | 2021-08-16 | Muskegon | Michigan | 26121 | 18958 | 386 |
1622995 | 1622995 | 2021-08-16 | Newaygo | Michigan | 26123 | 5003 | 70 |
1622996 | 1622996 | 2021-08-16 | Oakland | Michigan | 26125 | 123304 | 2488 |
1622997 | 1622997 | 2021-08-16 | Oceana | Michigan | 26127 | 2829 | 60 |
1622998 | 1622998 | 2021-08-16 | Ogemaw | Michigan | 26129 | 1842 | 43 |
1622999 | 1622999 | 2021-08-16 | Ontonagon | Michigan | 26131 | 497 | 22 |
1623000 | 1623000 | 2021-08-16 | Osceola | Michigan | 26133 | 1995 | 31 |
1623001 | 1623001 | 2021-08-16 | Oscoda | Michigan | 26135 | 704 | 31 |
1623002 | 1623002 | 2021-08-16 | Otsego | Michigan | 26137 | 2396 | 41 |
1623003 | 1623003 | 2021-08-16 | Ottawa | Michigan | 26139 | 33829 | 447 |
1623004 | 1623004 | 2021-08-16 | Presque Isle | Michigan | 26141 | 1080 | 34 |
1623005 | 1623005 | 2021-08-16 | Roscommon | Michigan | 26143 | 1931 | 55 |
1623006 | 1623006 | 2021-08-16 | Saginaw | Michigan | 26145 | 23282 | 645 |
1623007 | 1623007 | 2021-08-16 | Sanilac | Michigan | 26151 | 4321 | 126 |
1623008 | 1623008 | 2021-08-16 | Schoolcraft | Michigan | 26153 | 458 | 5 |
1623009 | 1623009 | 2021-08-16 | Shiawassee | Michigan | 26155 | 6678 | 110 |
1623010 | 1623010 | 2021-08-16 | St. Clair | Michigan | 26147 | 18863 | 456 |
1623011 | 1623011 | 2021-08-16 | St. Joseph | Michigan | 26149 | 6472 | 104 |
1623012 | 1623012 | 2021-08-16 | Tuscola | Michigan | 26157 | 5822 | 176 |
1623013 | 1623013 | 2021-08-16 | Unknown | Michigan | 782 | 18 | |
1623014 | 1623014 | 2021-08-16 | Van Buren | Michigan | 26159 | 7464 | 138 |
1623015 | 1623015 | 2021-08-16 | Washtenaw | Michigan | 26161 | 28143 | 315 |
1623016 | 1623016 | 2021-08-16 | Wayne | Michigan | 26163 | 171788 | 5231 |
1623017 | 1623017 | 2021-08-16 | Wexford | Michigan | 26165 | 2945 | 48 |
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);