ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2020-08-13 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
429023 | 429023 | 2020-08-13 | Alcona | Michigan | 26001 | 29 | 1 |
429024 | 429024 | 2020-08-13 | Alger | Michigan | 26003 | 15 | 0 |
429025 | 429025 | 2020-08-13 | Allegan | Michigan | 26005 | 548 | 6 |
429026 | 429026 | 2020-08-13 | Alpena | Michigan | 26007 | 130 | 13 |
429027 | 429027 | 2020-08-13 | Antrim | Michigan | 26009 | 41 | 0 |
429028 | 429028 | 2020-08-13 | Arenac | Michigan | 26011 | 44 | 3 |
429029 | 429029 | 2020-08-13 | Baraga | Michigan | 26013 | 5 | 0 |
429030 | 429030 | 2020-08-13 | Barry | Michigan | 26015 | 192 | 2 |
429031 | 429031 | 2020-08-13 | Bay | Michigan | 26017 | 686 | 31 |
429032 | 429032 | 2020-08-13 | Benzie | Michigan | 26019 | 30 | 1 |
429033 | 429033 | 2020-08-13 | Berrien | Michigan | 26021 | 1472 | 67 |
429034 | 429034 | 2020-08-13 | Branch | Michigan | 26023 | 1184 | 25 |
429035 | 429035 | 2020-08-13 | Calhoun | Michigan | 26025 | 819 | 42 |
429036 | 429036 | 2020-08-13 | Cass | Michigan | 26027 | 345 | 14 |
429037 | 429037 | 2020-08-13 | Charlevoix | Michigan | 26029 | 55 | 2 |
429038 | 429038 | 2020-08-13 | Cheboygan | Michigan | 26031 | 53 | 2 |
429039 | 429039 | 2020-08-13 | Chippewa | Michigan | 26033 | 45 | 0 |
429040 | 429040 | 2020-08-13 | Clare | Michigan | 26035 | 80 | 3 |
429041 | 429041 | 2020-08-13 | Clinton | Michigan | 26037 | 430 | 13 |
429042 | 429042 | 2020-08-13 | Crawford | Michigan | 26039 | 107 | 5 |
429043 | 429043 | 2020-08-13 | Delta | Michigan | 26041 | 106 | 3 |
429044 | 429044 | 2020-08-13 | Dickinson | Michigan | 26043 | 62 | 2 |
429045 | 429045 | 2020-08-13 | Eaton | Michigan | 26045 | 465 | 8 |
429046 | 429046 | 2020-08-13 | Emmet | Michigan | 26047 | 69 | 2 |
429047 | 429047 | 2020-08-13 | Genesee | Michigan | 26049 | 3699 | 299 |
429048 | 429048 | 2020-08-13 | Gladwin | Michigan | 26051 | 62 | 2 |
429049 | 429049 | 2020-08-13 | Gogebic | Michigan | 26053 | 130 | 1 |
429050 | 429050 | 2020-08-13 | Grand Traverse | Michigan | 26055 | 237 | 5 |
429051 | 429051 | 2020-08-13 | Gratiot | Michigan | 26057 | 167 | 15 |
429052 | 429052 | 2020-08-13 | Hillsdale | Michigan | 26059 | 281 | 25 |
429053 | 429053 | 2020-08-13 | Houghton | Michigan | 26061 | 51 | 0 |
429054 | 429054 | 2020-08-13 | Huron | Michigan | 26063 | 165 | 4 |
429055 | 429055 | 2020-08-13 | Ingham | Michigan | 26065 | 1588 | 32 |
429056 | 429056 | 2020-08-13 | Ionia | Michigan | 26067 | 279 | 7 |
429057 | 429057 | 2020-08-13 | Iosco | Michigan | 26069 | 135 | 12 |
429058 | 429058 | 2020-08-13 | Iron | Michigan | 26071 | 20 | 1 |
429059 | 429059 | 2020-08-13 | Isabella | Michigan | 26073 | 222 | 9 |
429060 | 429060 | 2020-08-13 | Jackson | Michigan | 26075 | 2449 | 56 |
429061 | 429061 | 2020-08-13 | Kalamazoo | Michigan | 26077 | 1700 | 83 |
429062 | 429062 | 2020-08-13 | Kalkaska | Michigan | 26079 | 55 | 4 |
429063 | 429063 | 2020-08-13 | Kent | Michigan | 26081 | 7677 | 157 |
429064 | 429064 | 2020-08-13 | Keweenaw | Michigan | 26083 | 3 | 0 |
429065 | 429065 | 2020-08-13 | Lake | Michigan | 26085 | 27 | 0 |
429066 | 429066 | 2020-08-13 | Lapeer | Michigan | 26087 | 789 | 40 |
429067 | 429067 | 2020-08-13 | Leelanau | Michigan | 26089 | 74 | 0 |
429068 | 429068 | 2020-08-13 | Lenawee | Michigan | 26091 | 1188 | 16 |
429069 | 429069 | 2020-08-13 | Livingston | Michigan | 26093 | 914 | 29 |
429070 | 429070 | 2020-08-13 | Luce | Michigan | 26095 | 33 | 0 |
429071 | 429071 | 2020-08-13 | Mackinac | Michigan | 26097 | 26 | 0 |
429072 | 429072 | 2020-08-13 | Macomb | Michigan | 26099 | 11195 | 954 |
429073 | 429073 | 2020-08-13 | Manistee | Michigan | 26101 | 54 | 0 |
429074 | 429074 | 2020-08-13 | Marquette | Michigan | 26103 | 179 | 11 |
429075 | 429075 | 2020-08-13 | Mason | Michigan | 26105 | 104 | 0 |
429076 | 429076 | 2020-08-13 | Mecosta | Michigan | 26107 | 70 | 2 |
429077 | 429077 | 2020-08-13 | Menominee | Michigan | 26109 | 153 | 0 |
429078 | 429078 | 2020-08-13 | Midland | Michigan | 26111 | 348 | 10 |
429079 | 429079 | 2020-08-13 | Missaukee | Michigan | 26113 | 42 | 1 |
429080 | 429080 | 2020-08-13 | Monroe | Michigan | 26115 | 1032 | 25 |
429081 | 429081 | 2020-08-13 | Montcalm | Michigan | 26117 | 201 | 2 |
429082 | 429082 | 2020-08-13 | Montmorency | Michigan | 26119 | 8 | 0 |
429083 | 429083 | 2020-08-13 | Muskegon | Michigan | 26121 | 1419 | 61 |
429084 | 429084 | 2020-08-13 | Newaygo | Michigan | 26123 | 259 | 0 |
429085 | 429085 | 2020-08-13 | Oakland | Michigan | 26125 | 16083 | 1136 |
429086 | 429086 | 2020-08-13 | Oceana | Michigan | 26127 | 482 | 6 |
429087 | 429087 | 2020-08-13 | Ogemaw | Michigan | 26129 | 54 | 3 |
429088 | 429088 | 2020-08-13 | Ontonagon | Michigan | 26131 | 20 | 0 |
429089 | 429089 | 2020-08-13 | Osceola | Michigan | 26133 | 71 | 0 |
429090 | 429090 | 2020-08-13 | Oscoda | Michigan | 26135 | 24 | 1 |
429091 | 429091 | 2020-08-13 | Otsego | Michigan | 26137 | 146 | 11 |
429092 | 429092 | 2020-08-13 | Ottawa | Michigan | 26139 | 1884 | 59 |
429093 | 429093 | 2020-08-13 | Presque Isle | Michigan | 26141 | 21 | 1 |
429094 | 429094 | 2020-08-13 | Roscommon | Michigan | 26143 | 57 | 2 |
429095 | 429095 | 2020-08-13 | Saginaw | Michigan | 26145 | 2119 | 128 |
429096 | 429096 | 2020-08-13 | Sanilac | Michigan | 26151 | 111 | 6 |
429097 | 429097 | 2020-08-13 | Schoolcraft | Michigan | 26153 | 13 | 0 |
429098 | 429098 | 2020-08-13 | Shiawassee | Michigan | 26155 | 350 | 28 |
429099 | 429099 | 2020-08-13 | St. Clair | Michigan | 26147 | 838 | 53 |
429100 | 429100 | 2020-08-13 | St. Joseph | Michigan | 26149 | 608 | 10 |
429101 | 429101 | 2020-08-13 | Tuscola | Michigan | 26157 | 367 | 29 |
429102 | 429102 | 2020-08-13 | Unknown | Michigan | 263 | 4 | |
429103 | 429103 | 2020-08-13 | Van Buren | Michigan | 26159 | 478 | 10 |
429104 | 429104 | 2020-08-13 | Washtenaw | Michigan | 26161 | 3138 | 122 |
429105 | 429105 | 2020-08-13 | Wayne | Michigan | 26163 | 28715 | 2835 |
429106 | 429106 | 2020-08-13 | Wexford | Michigan | 26165 | 74 | 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);