ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where date = "2020-06-21" 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 |
---|---|---|---|---|---|---|---|
260039 | 260039 | 2020-06-21 | Alcona | Michigan | 26001 | 21 | 1 |
260040 | 260040 | 2020-06-21 | Alger | Michigan | 26003 | 2 | 0 |
260041 | 260041 | 2020-06-21 | Allegan | Michigan | 26005 | 299 | 6 |
260042 | 260042 | 2020-06-21 | Alpena | Michigan | 26007 | 115 | 12 |
260043 | 260043 | 2020-06-21 | Antrim | Michigan | 26009 | 16 | 0 |
260044 | 260044 | 2020-06-21 | Arenac | Michigan | 26011 | 38 | 2 |
260045 | 260045 | 2020-06-21 | Baraga | Michigan | 26013 | 1 | 0 |
260046 | 260046 | 2020-06-21 | Barry | Michigan | 26015 | 94 | 2 |
260047 | 260047 | 2020-06-21 | Bay | Michigan | 26017 | 378 | 29 |
260048 | 260048 | 2020-06-21 | Benzie | Michigan | 26019 | 5 | 0 |
260049 | 260049 | 2020-06-21 | Berrien | Michigan | 26021 | 915 | 60 |
260050 | 260050 | 2020-06-21 | Branch | Michigan | 26023 | 1043 | 25 |
260051 | 260051 | 2020-06-21 | Calhoun | Michigan | 26025 | 504 | 31 |
260052 | 260052 | 2020-06-21 | Cass | Michigan | 26027 | 122 | 4 |
260053 | 260053 | 2020-06-21 | Charlevoix | Michigan | 26029 | 25 | 2 |
260054 | 260054 | 2020-06-21 | Cheboygan | Michigan | 26031 | 26 | 2 |
260055 | 260055 | 2020-06-21 | Chippewa | Michigan | 26033 | 4 | 0 |
260056 | 260056 | 2020-06-21 | Clare | Michigan | 26035 | 27 | 2 |
260057 | 260057 | 2020-06-21 | Clinton | Michigan | 26037 | 201 | 11 |
260058 | 260058 | 2020-06-21 | Crawford | Michigan | 26039 | 66 | 5 |
260059 | 260059 | 2020-06-21 | Delta | Michigan | 26041 | 21 | 2 |
260060 | 260060 | 2020-06-21 | Dickinson | Michigan | 26043 | 7 | 2 |
260061 | 260061 | 2020-06-21 | Eaton | Michigan | 26045 | 269 | 7 |
260062 | 260062 | 2020-06-21 | Emmet | Michigan | 26047 | 27 | 2 |
260063 | 260063 | 2020-06-21 | Genesee | Michigan | 26049 | 2631 | 284 |
260064 | 260064 | 2020-06-21 | Gladwin | Michigan | 26051 | 23 | 1 |
260065 | 260065 | 2020-06-21 | Gogebic | Michigan | 26053 | 6 | 1 |
260066 | 260066 | 2020-06-21 | Grand Traverse | Michigan | 26055 | 43 | 5 |
260067 | 260067 | 2020-06-21 | Gratiot | Michigan | 26057 | 99 | 13 |
260068 | 260068 | 2020-06-21 | Hillsdale | Michigan | 26059 | 183 | 25 |
260069 | 260069 | 2020-06-21 | Houghton | Michigan | 26061 | 9 | 0 |
260070 | 260070 | 2020-06-21 | Huron | Michigan | 26063 | 63 | 1 |
260071 | 260071 | 2020-06-21 | Ingham | Michigan | 26065 | 845 | 29 |
260072 | 260072 | 2020-06-21 | Ionia | Michigan | 26067 | 194 | 4 |
260073 | 260073 | 2020-06-21 | Iosco | Michigan | 26069 | 112 | 10 |
260074 | 260074 | 2020-06-21 | Iron | Michigan | 26071 | 4 | 0 |
260075 | 260075 | 2020-06-21 | Isabella | Michigan | 26073 | 112 | 8 |
260076 | 260076 | 2020-06-21 | Jackson | Michigan | 26075 | 2056 | 52 |
260077 | 260077 | 2020-06-21 | Kalamazoo | Michigan | 26077 | 996 | 65 |
260078 | 260078 | 2020-06-21 | Kalkaska | Michigan | 26079 | 31 | 2 |
260079 | 260079 | 2020-06-21 | Kent | Michigan | 26081 | 4596 | 124 |
260080 | 260080 | 2020-06-21 | Keweenaw | Michigan | 26083 | 1 | 0 |
260081 | 260081 | 2020-06-21 | Lake | Michigan | 26085 | 7 | 0 |
260082 | 260082 | 2020-06-21 | Lapeer | Michigan | 26087 | 535 | 38 |
260083 | 260083 | 2020-06-21 | Leelanau | Michigan | 26089 | 12 | 0 |
260084 | 260084 | 2020-06-21 | Lenawee | Michigan | 26091 | 927 | 10 |
260085 | 260085 | 2020-06-21 | Livingston | Michigan | 26093 | 582 | 29 |
260086 | 260086 | 2020-06-21 | Luce | Michigan | 26095 | 4 | 0 |
260087 | 260087 | 2020-06-21 | Mackinac | Michigan | 26097 | 8 | 0 |
260088 | 260088 | 2020-06-21 | Macomb | Michigan | 26099 | 7391 | 904 |
260089 | 260089 | 2020-06-21 | Manistee | Michigan | 26101 | 27 | 0 |
260090 | 260090 | 2020-06-21 | Marquette | Michigan | 26103 | 62 | 11 |
260091 | 260091 | 2020-06-21 | Mason | Michigan | 26105 | 41 | 0 |
260092 | 260092 | 2020-06-21 | Mecosta | Michigan | 26107 | 29 | 2 |
260093 | 260093 | 2020-06-21 | Menominee | Michigan | 26109 | 9 | 0 |
260094 | 260094 | 2020-06-21 | Midland | Michigan | 26111 | 159 | 9 |
260095 | 260095 | 2020-06-21 | Missaukee | Michigan | 26113 | 24 | 1 |
260096 | 260096 | 2020-06-21 | Monroe | Michigan | 26115 | 576 | 21 |
260097 | 260097 | 2020-06-21 | Montcalm | Michigan | 26117 | 85 | 1 |
260098 | 260098 | 2020-06-21 | Montmorency | Michigan | 26119 | 5 | 0 |
260099 | 260099 | 2020-06-21 | Muskegon | Michigan | 26121 | 784 | 49 |
260100 | 260100 | 2020-06-21 | Newaygo | Michigan | 26123 | 139 | 0 |
260101 | 260101 | 2020-06-21 | Oakland | Michigan | 26125 | 11685 | 1077 |
260102 | 260102 | 2020-06-21 | Oceana | Michigan | 26127 | 176 | 3 |
260103 | 260103 | 2020-06-21 | Ogemaw | Michigan | 26129 | 32 | 2 |
260104 | 260104 | 2020-06-21 | Osceola | Michigan | 26133 | 27 | 0 |
260105 | 260105 | 2020-06-21 | Oscoda | Michigan | 26135 | 9 | 1 |
260106 | 260106 | 2020-06-21 | Otsego | Michigan | 26137 | 131 | 10 |
260107 | 260107 | 2020-06-21 | Ottawa | Michigan | 26139 | 966 | 51 |
260108 | 260108 | 2020-06-21 | Presque Isle | Michigan | 26141 | 12 | 0 |
260109 | 260109 | 2020-06-21 | Roscommon | Michigan | 26143 | 26 | 0 |
260110 | 260110 | 2020-06-21 | Saginaw | Michigan | 26145 | 1194 | 120 |
260111 | 260111 | 2020-06-21 | Sanilac | Michigan | 26151 | 44 | 6 |
260112 | 260112 | 2020-06-21 | Schoolcraft | Michigan | 26153 | 4 | 0 |
260113 | 260113 | 2020-06-21 | Shiawassee | Michigan | 26155 | 265 | 27 |
260114 | 260114 | 2020-06-21 | St. Clair | Michigan | 26147 | 525 | 48 |
260115 | 260115 | 2020-06-21 | St. Joseph | Michigan | 26149 | 219 | 3 |
260116 | 260116 | 2020-06-21 | Tuscola | Michigan | 26157 | 246 | 26 |
260117 | 260117 | 2020-06-21 | Unknown | Michigan | 166 | 2 | |
260118 | 260118 | 2020-06-21 | Van Buren | Michigan | 26159 | 216 | 7 |
260119 | 260119 | 2020-06-21 | Washtenaw | Michigan | 26161 | 2110 | 113 |
260120 | 260120 | 2020-06-21 | Wayne | Michigan | 26163 | 22162 | 2689 |
260121 | 260121 | 2020-06-21 | Wexford | Michigan | 26165 | 22 | 3 |
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);