ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-04-16 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
62996 | 62996 | 2020-04-16 | Alcona | Michigan | 26001 | 1 | 0 |
62997 | 62997 | 2020-04-16 | Allegan | Michigan | 26005 | 25 | 0 |
62998 | 62998 | 2020-04-16 | Alpena | Michigan | 26007 | 2 | 0 |
62999 | 62999 | 2020-04-16 | Antrim | Michigan | 26009 | 9 | 0 |
63000 | 63000 | 2020-04-16 | Arenac | Michigan | 26011 | 7 | 0 |
63001 | 63001 | 2020-04-16 | Baraga | Michigan | 26013 | 1 | 0 |
63002 | 63002 | 2020-04-16 | Barry | Michigan | 26015 | 20 | 1 |
63003 | 63003 | 2020-04-16 | Bay | Michigan | 26017 | 67 | 2 |
63004 | 63004 | 2020-04-16 | Berrien | Michigan | 26021 | 133 | 7 |
63005 | 63005 | 2020-04-16 | Branch | Michigan | 26023 | 116 | 4 |
63006 | 63006 | 2020-04-16 | Calhoun | Michigan | 26025 | 119 | 4 |
63007 | 63007 | 2020-04-16 | Cass | Michigan | 26027 | 19 | 1 |
63008 | 63008 | 2020-04-16 | Charlevoix | Michigan | 26029 | 11 | 1 |
63009 | 63009 | 2020-04-16 | Cheboygan | Michigan | 26031 | 12 | 1 |
63010 | 63010 | 2020-04-16 | Chippewa | Michigan | 26033 | 1 | 1 |
63011 | 63011 | 2020-04-16 | Clare | Michigan | 26035 | 7 | 1 |
63012 | 63012 | 2020-04-16 | Clinton | Michigan | 26037 | 102 | 6 |
63013 | 63013 | 2020-04-16 | Crawford | Michigan | 26039 | 18 | 1 |
63014 | 63014 | 2020-04-16 | Delta | Michigan | 26041 | 10 | 1 |
63015 | 63015 | 2020-04-16 | Dickinson | Michigan | 26043 | 3 | 2 |
63016 | 63016 | 2020-04-16 | Eaton | Michigan | 26045 | 84 | 5 |
63017 | 63017 | 2020-04-16 | Emmet | Michigan | 26047 | 21 | 2 |
63018 | 63018 | 2020-04-16 | Genesee | Michigan | 26049 | 1147 | 99 |
63019 | 63019 | 2020-04-16 | Gladwin | Michigan | 26051 | 8 | 0 |
63020 | 63020 | 2020-04-16 | Gogebic | Michigan | 26053 | 4 | 1 |
63021 | 63021 | 2020-04-16 | Grand Traverse | Michigan | 26055 | 17 | 3 |
63022 | 63022 | 2020-04-16 | Gratiot | Michigan | 26057 | 7 | 0 |
63023 | 63023 | 2020-04-16 | Hillsdale | Michigan | 26059 | 84 | 9 |
63024 | 63024 | 2020-04-16 | Houghton | Michigan | 26061 | 2 | 0 |
63025 | 63025 | 2020-04-16 | Huron | Michigan | 26063 | 8 | 0 |
63026 | 63026 | 2020-04-16 | Ingham | Michigan | 26065 | 278 | 6 |
63027 | 63027 | 2020-04-16 | Ionia | Michigan | 26067 | 20 | 2 |
63028 | 63028 | 2020-04-16 | Iosco | Michigan | 26069 | 6 | 1 |
63029 | 63029 | 2020-04-16 | Isabella | Michigan | 26073 | 45 | 5 |
63030 | 63030 | 2020-04-16 | Jackson | Michigan | 26075 | 430 | 14 |
63031 | 63031 | 2020-04-16 | Kalamazoo | Michigan | 26077 | 118 | 8 |
63032 | 63032 | 2020-04-16 | Kalkaska | Michigan | 26079 | 17 | 2 |
63033 | 63033 | 2020-04-16 | Kent | Michigan | 26081 | 386 | 17 |
63034 | 63034 | 2020-04-16 | Lake | Michigan | 26085 | 2 | 0 |
63035 | 63035 | 2020-04-16 | Lapeer | Michigan | 26087 | 137 | 13 |
63036 | 63036 | 2020-04-16 | Leelanau | Michigan | 26089 | 6 | 0 |
63037 | 63037 | 2020-04-16 | Lenawee | Michigan | 26091 | 67 | 0 |
63038 | 63038 | 2020-04-16 | Livingston | Michigan | 26093 | 269 | 9 |
63039 | 63039 | 2020-04-16 | Luce | Michigan | 26095 | 1 | 0 |
63040 | 63040 | 2020-04-16 | Mackinac | Michigan | 26097 | 4 | 0 |
63041 | 63041 | 2020-04-16 | Macomb | Michigan | 26099 | 4069 | 354 |
63042 | 63042 | 2020-04-16 | Manistee | Michigan | 26101 | 11 | 0 |
63043 | 63043 | 2020-04-16 | Marquette | Michigan | 26103 | 27 | 5 |
63044 | 63044 | 2020-04-16 | Mason | Michigan | 26105 | 4 | 0 |
63045 | 63045 | 2020-04-16 | Mecosta | Michigan | 26107 | 11 | 1 |
63046 | 63046 | 2020-04-16 | Menominee | Michigan | 26109 | 1 | 0 |
63047 | 63047 | 2020-04-16 | Midland | Michigan | 26111 | 41 | 1 |
63048 | 63048 | 2020-04-16 | Missaukee | Michigan | 26113 | 3 | 1 |
63049 | 63049 | 2020-04-16 | Monroe | Michigan | 26115 | 217 | 10 |
63050 | 63050 | 2020-04-16 | Montcalm | Michigan | 26117 | 23 | 1 |
63051 | 63051 | 2020-04-16 | Montmorency | Michigan | 26119 | 2 | 0 |
63052 | 63052 | 2020-04-16 | Muskegon | Michigan | 26121 | 110 | 5 |
63053 | 63053 | 2020-04-16 | Newaygo | Michigan | 26123 | 7 | 0 |
63054 | 63054 | 2020-04-16 | Oakland | Michigan | 26125 | 5778 | 420 |
63055 | 63055 | 2020-04-16 | Oceana | Michigan | 26127 | 3 | 1 |
63056 | 63056 | 2020-04-16 | Ogemaw | Michigan | 26129 | 5 | 0 |
63057 | 63057 | 2020-04-16 | Osceola | Michigan | 26133 | 6 | 0 |
63058 | 63058 | 2020-04-16 | Oscoda | Michigan | 26135 | 4 | 0 |
63059 | 63059 | 2020-04-16 | Otsego | Michigan | 26137 | 44 | 2 |
63060 | 63060 | 2020-04-16 | Ottawa | Michigan | 26139 | 82 | 2 |
63061 | 63061 | 2020-04-16 | Presque Isle | Michigan | 26141 | 2 | 0 |
63062 | 63062 | 2020-04-16 | Roscommon | Michigan | 26143 | 9 | 0 |
63063 | 63063 | 2020-04-16 | Saginaw | Michigan | 26145 | 350 | 20 |
63064 | 63064 | 2020-04-16 | Sanilac | Michigan | 26151 | 25 | 2 |
63065 | 63065 | 2020-04-16 | Schoolcraft | Michigan | 26153 | 3 | 0 |
63066 | 63066 | 2020-04-16 | Shiawassee | Michigan | 26155 | 70 | 2 |
63067 | 63067 | 2020-04-16 | St. Clair | Michigan | 26147 | 232 | 8 |
63068 | 63068 | 2020-04-16 | St. Joseph | Michigan | 26149 | 23 | 1 |
63069 | 63069 | 2020-04-16 | Tuscola | Michigan | 26157 | 50 | 10 |
63070 | 63070 | 2020-04-16 | Unknown | Michigan | 88 | 7 | |
63071 | 63071 | 2020-04-16 | Van Buren | Michigan | 26159 | 26 | 2 |
63072 | 63072 | 2020-04-16 | Washtenaw | Michigan | 26161 | 918 | 25 |
63073 | 63073 | 2020-04-16 | Wayne | Michigan | 26163 | 13018 | 982 |
63074 | 63074 | 2020-04-16 | Wexford | Michigan | 26165 | 7 | 1 |
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);