ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-08-30" 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 |
---|---|---|---|---|---|---|---|
483913 | 483913 | 2020-08-30 | Alcona | Michigan | 26001 | 33 | 2 |
483914 | 483914 | 2020-08-30 | Alger | Michigan | 26003 | 17 | 0 |
483915 | 483915 | 2020-08-30 | Allegan | Michigan | 26005 | 637 | 6 |
483916 | 483916 | 2020-08-30 | Alpena | Michigan | 26007 | 132 | 14 |
483917 | 483917 | 2020-08-30 | Antrim | Michigan | 26009 | 58 | 0 |
483918 | 483918 | 2020-08-30 | Arenac | Michigan | 26011 | 55 | 3 |
483919 | 483919 | 2020-08-30 | Baraga | Michigan | 26013 | 8 | 0 |
483920 | 483920 | 2020-08-30 | Barry | Michigan | 26015 | 215 | 2 |
483921 | 483921 | 2020-08-30 | Bay | Michigan | 26017 | 814 | 41 |
483922 | 483922 | 2020-08-30 | Benzie | Michigan | 26019 | 46 | 2 |
483923 | 483923 | 2020-08-30 | Berrien | Michigan | 26021 | 1673 | 70 |
483924 | 483924 | 2020-08-30 | Branch | Michigan | 26023 | 1287 | 26 |
483925 | 483925 | 2020-08-30 | Calhoun | Michigan | 26025 | 983 | 44 |
483926 | 483926 | 2020-08-30 | Cass | Michigan | 26027 | 411 | 17 |
483927 | 483927 | 2020-08-30 | Charlevoix | Michigan | 26029 | 74 | 2 |
483928 | 483928 | 2020-08-30 | Cheboygan | Michigan | 26031 | 79 | 2 |
483929 | 483929 | 2020-08-30 | Chippewa | Michigan | 26033 | 58 | 0 |
483930 | 483930 | 2020-08-30 | Clare | Michigan | 26035 | 100 | 4 |
483931 | 483931 | 2020-08-30 | Clinton | Michigan | 26037 | 488 | 13 |
483932 | 483932 | 2020-08-30 | Crawford | Michigan | 26039 | 113 | 5 |
483933 | 483933 | 2020-08-30 | Delta | Michigan | 26041 | 151 | 3 |
483934 | 483934 | 2020-08-30 | Dickinson | Michigan | 26043 | 65 | 2 |
483935 | 483935 | 2020-08-30 | Eaton | Michigan | 26045 | 510 | 8 |
483936 | 483936 | 2020-08-30 | Emmet | Michigan | 26047 | 122 | 2 |
483937 | 483937 | 2020-08-30 | Genesee | Michigan | 26049 | 3960 | 305 |
483938 | 483938 | 2020-08-30 | Gladwin | Michigan | 26051 | 75 | 2 |
483939 | 483939 | 2020-08-30 | Gogebic | Michigan | 26053 | 144 | 1 |
483940 | 483940 | 2020-08-30 | Grand Traverse | Michigan | 26055 | 348 | 6 |
483941 | 483941 | 2020-08-30 | Gratiot | Michigan | 26057 | 191 | 15 |
483942 | 483942 | 2020-08-30 | Hillsdale | Michigan | 26059 | 302 | 26 |
483943 | 483943 | 2020-08-30 | Houghton | Michigan | 26061 | 72 | 1 |
483944 | 483944 | 2020-08-30 | Huron | Michigan | 26063 | 200 | 4 |
483945 | 483945 | 2020-08-30 | Ingham | Michigan | 26065 | 1772 | 39 |
483946 | 483946 | 2020-08-30 | Ionia | Michigan | 26067 | 301 | 7 |
483947 | 483947 | 2020-08-30 | Iosco | Michigan | 26069 | 143 | 12 |
483948 | 483948 | 2020-08-30 | Iron | Michigan | 26071 | 33 | 1 |
483949 | 483949 | 2020-08-30 | Isabella | Michigan | 26073 | 472 | 9 |
483950 | 483950 | 2020-08-30 | Jackson | Michigan | 26075 | 2547 | 62 |
483951 | 483951 | 2020-08-30 | Kalamazoo | Michigan | 26077 | 1935 | 88 |
483952 | 483952 | 2020-08-30 | Kalkaska | Michigan | 26079 | 66 | 4 |
483953 | 483953 | 2020-08-30 | Kent | Michigan | 26081 | 8449 | 167 |
483954 | 483954 | 2020-08-30 | Keweenaw | Michigan | 26083 | 2 | 0 |
483955 | 483955 | 2020-08-30 | Lake | Michigan | 26085 | 29 | 0 |
483956 | 483956 | 2020-08-30 | Lapeer | Michigan | 26087 | 840 | 42 |
483957 | 483957 | 2020-08-30 | Leelanau | Michigan | 26089 | 90 | 1 |
483958 | 483958 | 2020-08-30 | Lenawee | Michigan | 26091 | 1291 | 17 |
483959 | 483959 | 2020-08-30 | Livingston | Michigan | 26093 | 1121 | 30 |
483960 | 483960 | 2020-08-30 | Luce | Michigan | 26095 | 121 | 0 |
483961 | 483961 | 2020-08-30 | Mackinac | Michigan | 26097 | 36 | 0 |
483962 | 483962 | 2020-08-30 | Macomb | Michigan | 26099 | 12998 | 973 |
483963 | 483963 | 2020-08-30 | Manistee | Michigan | 26101 | 66 | 1 |
483964 | 483964 | 2020-08-30 | Marquette | Michigan | 26103 | 243 | 11 |
483965 | 483965 | 2020-08-30 | Mason | Michigan | 26105 | 120 | 0 |
483966 | 483966 | 2020-08-30 | Mecosta | Michigan | 26107 | 86 | 2 |
483967 | 483967 | 2020-08-30 | Menominee | Michigan | 26109 | 246 | 0 |
483968 | 483968 | 2020-08-30 | Midland | Michigan | 26111 | 413 | 11 |
483969 | 483969 | 2020-08-30 | Missaukee | Michigan | 26113 | 44 | 1 |
483970 | 483970 | 2020-08-30 | Monroe | Michigan | 26115 | 1310 | 27 |
483971 | 483971 | 2020-08-30 | Montcalm | Michigan | 26117 | 227 | 4 |
483972 | 483972 | 2020-08-30 | Montmorency | Michigan | 26119 | 12 | 0 |
483973 | 483973 | 2020-08-30 | Muskegon | Michigan | 26121 | 1947 | 67 |
483974 | 483974 | 2020-08-30 | Newaygo | Michigan | 26123 | 298 | 0 |
483975 | 483975 | 2020-08-30 | Oakland | Michigan | 26125 | 17996 | 1163 |
483976 | 483976 | 2020-08-30 | Oceana | Michigan | 26127 | 500 | 6 |
483977 | 483977 | 2020-08-30 | Ogemaw | Michigan | 26129 | 57 | 4 |
483978 | 483978 | 2020-08-30 | Ontonagon | Michigan | 26131 | 34 | 0 |
483979 | 483979 | 2020-08-30 | Osceola | Michigan | 26133 | 77 | 0 |
483980 | 483980 | 2020-08-30 | Oscoda | Michigan | 26135 | 29 | 1 |
483981 | 483981 | 2020-08-30 | Otsego | Michigan | 26137 | 154 | 11 |
483982 | 483982 | 2020-08-30 | Ottawa | Michigan | 26139 | 2133 | 63 |
483983 | 483983 | 2020-08-30 | Presque Isle | Michigan | 26141 | 21 | 1 |
483984 | 483984 | 2020-08-30 | Roscommon | Michigan | 26143 | 76 | 3 |
483985 | 483985 | 2020-08-30 | Saginaw | Michigan | 26145 | 2510 | 133 |
483986 | 483986 | 2020-08-30 | Sanilac | Michigan | 26151 | 125 | 7 |
483987 | 483987 | 2020-08-30 | Schoolcraft | Michigan | 26153 | 15 | 0 |
483988 | 483988 | 2020-08-30 | Shiawassee | Michigan | 26155 | 419 | 29 |
483989 | 483989 | 2020-08-30 | St. Clair | Michigan | 26147 | 922 | 53 |
483990 | 483990 | 2020-08-30 | St. Joseph | Michigan | 26149 | 680 | 11 |
483991 | 483991 | 2020-08-30 | Tuscola | Michigan | 26157 | 451 | 29 |
483992 | 483992 | 2020-08-30 | Unknown | Michigan | 433 | 5 | |
483993 | 483993 | 2020-08-30 | Van Buren | Michigan | 26159 | 624 | 16 |
483994 | 483994 | 2020-08-30 | Washtenaw | Michigan | 26161 | 3381 | 124 |
483995 | 483995 | 2020-08-30 | Wayne | Michigan | 26163 | 31178 | 2883 |
483996 | 483996 | 2020-08-30 | Wexford | Michigan | 26165 | 104 | 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);