ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-07-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 |
---|---|---|---|---|---|---|---|
383957 | 383957 | 2020-07-30 | Alcona | Michigan | 26001 | 28 | 1 |
383958 | 383958 | 2020-07-30 | Alger | Michigan | 26003 | 6 | 0 |
383959 | 383959 | 2020-07-30 | Allegan | Michigan | 26005 | 485 | 7 |
383960 | 383960 | 2020-07-30 | Alpena | Michigan | 26007 | 125 | 13 |
383961 | 383961 | 2020-07-30 | Antrim | Michigan | 26009 | 35 | 0 |
383962 | 383962 | 2020-07-30 | Arenac | Michigan | 26011 | 40 | 3 |
383963 | 383963 | 2020-07-30 | Baraga | Michigan | 26013 | 5 | 0 |
383964 | 383964 | 2020-07-30 | Barry | Michigan | 26015 | 169 | 2 |
383965 | 383965 | 2020-07-30 | Bay | Michigan | 26017 | 536 | 31 |
383966 | 383966 | 2020-07-30 | Benzie | Michigan | 26019 | 28 | 1 |
383967 | 383967 | 2020-07-30 | Berrien | Michigan | 26021 | 1326 | 64 |
383968 | 383968 | 2020-07-30 | Branch | Michigan | 26023 | 1127 | 25 |
383969 | 383969 | 2020-07-30 | Calhoun | Michigan | 26025 | 717 | 41 |
383970 | 383970 | 2020-07-30 | Cass | Michigan | 26027 | 272 | 9 |
383971 | 383971 | 2020-07-30 | Charlevoix | Michigan | 26029 | 45 | 2 |
383972 | 383972 | 2020-07-30 | Cheboygan | Michigan | 26031 | 37 | 2 |
383973 | 383973 | 2020-07-30 | Chippewa | Michigan | 26033 | 28 | 0 |
383974 | 383974 | 2020-07-30 | Clare | Michigan | 26035 | 56 | 3 |
383975 | 383975 | 2020-07-30 | Clinton | Michigan | 26037 | 397 | 13 |
383976 | 383976 | 2020-07-30 | Crawford | Michigan | 26039 | 93 | 5 |
383977 | 383977 | 2020-07-30 | Delta | Michigan | 26041 | 65 | 3 |
383978 | 383978 | 2020-07-30 | Dickinson | Michigan | 26043 | 44 | 2 |
383979 | 383979 | 2020-07-30 | Eaton | Michigan | 26045 | 442 | 7 |
383980 | 383980 | 2020-07-30 | Emmet | Michigan | 26047 | 57 | 2 |
383981 | 383981 | 2020-07-30 | Genesee | Michigan | 26049 | 3415 | 294 |
383982 | 383982 | 2020-07-30 | Gladwin | Michigan | 26051 | 49 | 2 |
383983 | 383983 | 2020-07-30 | Gogebic | Michigan | 26053 | 78 | 1 |
383984 | 383984 | 2020-07-30 | Grand Traverse | Michigan | 26055 | 190 | 5 |
383985 | 383985 | 2020-07-30 | Gratiot | Michigan | 26057 | 148 | 15 |
383986 | 383986 | 2020-07-30 | Hillsdale | Michigan | 26059 | 244 | 25 |
383987 | 383987 | 2020-07-30 | Houghton | Michigan | 26061 | 47 | 0 |
383988 | 383988 | 2020-07-30 | Huron | Michigan | 26063 | 143 | 3 |
383989 | 383989 | 2020-07-30 | Ingham | Michigan | 26065 | 1438 | 31 |
383990 | 383990 | 2020-07-30 | Ionia | Michigan | 26067 | 268 | 5 |
383991 | 383991 | 2020-07-30 | Iosco | Michigan | 26069 | 128 | 12 |
383992 | 383992 | 2020-07-30 | Iron | Michigan | 26071 | 16 | 1 |
383993 | 383993 | 2020-07-30 | Isabella | Michigan | 26073 | 200 | 8 |
383994 | 383994 | 2020-07-30 | Jackson | Michigan | 26075 | 2387 | 55 |
383995 | 383995 | 2020-07-30 | Kalamazoo | Michigan | 26077 | 1489 | 78 |
383996 | 383996 | 2020-07-30 | Kalkaska | Michigan | 26079 | 49 | 4 |
383997 | 383997 | 2020-07-30 | Kent | Michigan | 26081 | 6997 | 154 |
383998 | 383998 | 2020-07-30 | Keweenaw | Michigan | 26083 | 3 | 0 |
383999 | 383999 | 2020-07-30 | Lake | Michigan | 26085 | 16 | 0 |
384000 | 384000 | 2020-07-30 | Lapeer | Michigan | 26087 | 706 | 39 |
384001 | 384001 | 2020-07-30 | Leelanau | Michigan | 26089 | 62 | 0 |
384002 | 384002 | 2020-07-30 | Lenawee | Michigan | 26091 | 1117 | 16 |
384003 | 384003 | 2020-07-30 | Livingston | Michigan | 26093 | 797 | 29 |
384004 | 384004 | 2020-07-30 | Luce | Michigan | 26095 | 4 | 0 |
384005 | 384005 | 2020-07-30 | Mackinac | Michigan | 26097 | 20 | 0 |
384006 | 384006 | 2020-07-30 | Macomb | Michigan | 26099 | 9555 | 941 |
384007 | 384007 | 2020-07-30 | Manistee | Michigan | 26101 | 43 | 0 |
384008 | 384008 | 2020-07-30 | Marquette | Michigan | 26103 | 122 | 11 |
384009 | 384009 | 2020-07-30 | Mason | Michigan | 26105 | 95 | 0 |
384010 | 384010 | 2020-07-30 | Mecosta | Michigan | 26107 | 55 | 2 |
384011 | 384011 | 2020-07-30 | Menominee | Michigan | 26109 | 86 | 0 |
384012 | 384012 | 2020-07-30 | Midland | Michigan | 26111 | 289 | 9 |
384013 | 384013 | 2020-07-30 | Missaukee | Michigan | 26113 | 40 | 1 |
384014 | 384014 | 2020-07-30 | Monroe | Michigan | 26115 | 854 | 21 |
384015 | 384015 | 2020-07-30 | Montcalm | Michigan | 26117 | 177 | 1 |
384016 | 384016 | 2020-07-30 | Montmorency | Michigan | 26119 | 7 | 0 |
384017 | 384017 | 2020-07-30 | Muskegon | Michigan | 26121 | 1107 | 57 |
384018 | 384018 | 2020-07-30 | Newaygo | Michigan | 26123 | 247 | 0 |
384019 | 384019 | 2020-07-30 | Oakland | Michigan | 26125 | 14494 | 1126 |
384020 | 384020 | 2020-07-30 | Oceana | Michigan | 26127 | 462 | 6 |
384021 | 384021 | 2020-07-30 | Ogemaw | Michigan | 26129 | 50 | 2 |
384022 | 384022 | 2020-07-30 | Ontonagon | Michigan | 26131 | 4 | 0 |
384023 | 384023 | 2020-07-30 | Osceola | Michigan | 26133 | 65 | 0 |
384024 | 384024 | 2020-07-30 | Oscoda | Michigan | 26135 | 24 | 1 |
384025 | 384025 | 2020-07-30 | Otsego | Michigan | 26137 | 142 | 10 |
384026 | 384026 | 2020-07-30 | Ottawa | Michigan | 26139 | 1669 | 54 |
384027 | 384027 | 2020-07-30 | Presque Isle | Michigan | 26141 | 14 | 1 |
384028 | 384028 | 2020-07-30 | Roscommon | Michigan | 26143 | 47 | 0 |
384029 | 384029 | 2020-07-30 | Saginaw | Michigan | 26145 | 1811 | 129 |
384030 | 384030 | 2020-07-30 | Sanilac | Michigan | 26151 | 90 | 6 |
384031 | 384031 | 2020-07-30 | Schoolcraft | Michigan | 26153 | 8 | 0 |
384032 | 384032 | 2020-07-30 | Shiawassee | Michigan | 26155 | 315 | 28 |
384033 | 384033 | 2020-07-30 | St. Clair | Michigan | 26147 | 749 | 53 |
384034 | 384034 | 2020-07-30 | St. Joseph | Michigan | 26149 | 551 | 7 |
384035 | 384035 | 2020-07-30 | Tuscola | Michigan | 26157 | 297 | 27 |
384036 | 384036 | 2020-07-30 | Unknown | Michigan | 22 | 3 | |
384037 | 384037 | 2020-07-30 | Van Buren | Michigan | 26159 | 385 | 11 |
384038 | 384038 | 2020-07-30 | Washtenaw | Michigan | 26161 | 2860 | 122 |
384039 | 384039 | 2020-07-30 | Wayne | Michigan | 26163 | 26949 | 2800 |
384040 | 384040 | 2020-07-30 | Wexford | Michigan | 26165 | 67 | 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);