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 2021-04-29 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1269045 | 1269045 | 2021-04-29 | Alcona | Michigan | 26001 | 695 | 27 |
1269046 | 1269046 | 2021-04-29 | Alger | Michigan | 26003 | 645 | 6 |
1269047 | 1269047 | 2021-04-29 | Allegan | Michigan | 26005 | 10277 | 129 |
1269048 | 1269048 | 2021-04-29 | Alpena | Michigan | 26007 | 2065 | 58 |
1269049 | 1269049 | 2021-04-29 | Antrim | Michigan | 26009 | 1524 | 27 |
1269050 | 1269050 | 2021-04-29 | Arenac | Michigan | 26011 | 1067 | 28 |
1269051 | 1269051 | 2021-04-29 | Baraga | Michigan | 26013 | 849 | 35 |
1269052 | 1269052 | 2021-04-29 | Barry | Michigan | 26015 | 5457 | 61 |
1269053 | 1269053 | 2021-04-29 | Bay | Michigan | 26017 | 10497 | 322 |
1269054 | 1269054 | 2021-04-29 | Benzie | Michigan | 26019 | 1213 | 32 |
1269055 | 1269055 | 2021-04-29 | Berrien | Michigan | 26021 | 14640 | 268 |
1269056 | 1269056 | 2021-04-29 | Branch | Michigan | 26023 | 5401 | 118 |
1269057 | 1269057 | 2021-04-29 | Calhoun | Michigan | 26025 | 13369 | 269 |
1269058 | 1269058 | 2021-04-29 | Cass | Michigan | 26027 | 5187 | 74 |
1269059 | 1269059 | 2021-04-29 | Charlevoix | Michigan | 26029 | 1573 | 20 |
1269060 | 1269060 | 2021-04-29 | Cheboygan | Michigan | 26031 | 1800 | 41 |
1269061 | 1269061 | 2021-04-29 | Chippewa | Michigan | 26033 | 5485 | 48 |
1269062 | 1269062 | 2021-04-29 | Clare | Michigan | 26035 | 2248 | 74 |
1269063 | 1269063 | 2021-04-29 | Clinton | Michigan | 26037 | 7250 | 81 |
1269064 | 1269064 | 2021-04-29 | Crawford | Michigan | 26039 | 931 | 11 |
1269065 | 1269065 | 2021-04-29 | Delta | Michigan | 26041 | 3829 | 88 |
1269066 | 1269066 | 2021-04-29 | Dickinson | Michigan | 26043 | 2665 | 74 |
1269067 | 1269067 | 2021-04-29 | Eaton | Michigan | 26045 | 9625 | 182 |
1269068 | 1269068 | 2021-04-29 | Emmet | Michigan | 26047 | 2233 | 41 |
1269069 | 1269069 | 2021-04-29 | Genesee | Michigan | 26049 | 39394 | 867 |
1269070 | 1269070 | 2021-04-29 | Gladwin | Michigan | 26051 | 2179 | 50 |
1269071 | 1269071 | 2021-04-29 | Gogebic | Michigan | 26053 | 1361 | 50 |
1269072 | 1269072 | 2021-04-29 | Grand Traverse | Michigan | 26055 | 6182 | 88 |
1269073 | 1269073 | 2021-04-29 | Gratiot | Michigan | 26057 | 6611 | 114 |
1269074 | 1269074 | 2021-04-29 | Hillsdale | Michigan | 26059 | 4135 | 83 |
1269075 | 1269075 | 2021-04-29 | Houghton | Michigan | 26061 | 3032 | 40 |
1269076 | 1269076 | 2021-04-29 | Huron | Michigan | 26063 | 3950 | 72 |
1269077 | 1269077 | 2021-04-29 | Ingham | Michigan | 26065 | 23595 | 346 |
1269078 | 1269078 | 2021-04-29 | Ionia | Michigan | 26067 | 8710 | 82 |
1269079 | 1269079 | 2021-04-29 | Iosco | Michigan | 26069 | 1844 | 69 |
1269080 | 1269080 | 2021-04-29 | Iron | Michigan | 26071 | 1004 | 51 |
1269081 | 1269081 | 2021-04-29 | Isabella | Michigan | 26073 | 5798 | 84 |
1269082 | 1269082 | 2021-04-29 | Jackson | Michigan | 26075 | 19961 | 290 |
1269083 | 1269083 | 2021-04-29 | Kalamazoo | Michigan | 26077 | 21445 | 355 |
1269084 | 1269084 | 2021-04-29 | Kalkaska | Michigan | 26079 | 1038 | 21 |
1269085 | 1269085 | 2021-04-29 | Kent | Michigan | 26081 | 67863 | 785 |
1269086 | 1269086 | 2021-04-29 | Keweenaw | Michigan | 26083 | 173 | 2 |
1269087 | 1269087 | 2021-04-29 | Lake | Michigan | 26085 | 578 | 14 |
1269088 | 1269088 | 2021-04-29 | Lapeer | Michigan | 26087 | 9166 | 179 |
1269089 | 1269089 | 2021-04-29 | Leelanau | Michigan | 26089 | 1187 | 17 |
1269090 | 1269090 | 2021-04-29 | Lenawee | Michigan | 26091 | 10321 | 157 |
1269091 | 1269091 | 2021-04-29 | Livingston | Michigan | 26093 | 15789 | 171 |
1269092 | 1269092 | 2021-04-29 | Luce | Michigan | 26095 | 1209 | 3 |
1269093 | 1269093 | 2021-04-29 | Mackinac | Michigan | 26097 | 616 | 4 |
1269094 | 1269094 | 2021-04-29 | Macomb | Michigan | 26099 | 94657 | 2230 |
1269095 | 1269095 | 2021-04-29 | Manistee | Michigan | 26101 | 1899 | 23 |
1269096 | 1269096 | 2021-04-29 | Marquette | Michigan | 26103 | 5739 | 59 |
1269097 | 1269097 | 2021-04-29 | Mason | Michigan | 26105 | 1984 | 32 |
1269098 | 1269098 | 2021-04-29 | Mecosta | Michigan | 26107 | 2956 | 27 |
1269099 | 1269099 | 2021-04-29 | Menominee | Michigan | 26109 | 2045 | 41 |
1269100 | 1269100 | 2021-04-29 | Midland | Michigan | 26111 | 7010 | 77 |
1269101 | 1269101 | 2021-04-29 | Missaukee | Michigan | 26113 | 1402 | 23 |
1269102 | 1269102 | 2021-04-29 | Monroe | Michigan | 26115 | 14469 | 237 |
1269103 | 1269103 | 2021-04-29 | Montcalm | Michigan | 26117 | 7500 | 106 |
1269104 | 1269104 | 2021-04-29 | Montmorency | Michigan | 26119 | 542 | 18 |
1269105 | 1269105 | 2021-04-29 | Muskegon | Michigan | 26121 | 16428 | 336 |
1269106 | 1269106 | 2021-04-29 | Newaygo | Michigan | 26123 | 4394 | 57 |
1269107 | 1269107 | 2021-04-29 | Oakland | Michigan | 26125 | 110431 | 2189 |
1269108 | 1269108 | 2021-04-29 | Oceana | Michigan | 26127 | 2587 | 53 |
1269109 | 1269109 | 2021-04-29 | Ogemaw | Michigan | 26129 | 1550 | 36 |
1269110 | 1269110 | 2021-04-29 | Ontonagon | Michigan | 26131 | 453 | 21 |
1269111 | 1269111 | 2021-04-29 | Osceola | Michigan | 26133 | 1780 | 27 |
1269112 | 1269112 | 2021-04-29 | Oscoda | Michigan | 26135 | 585 | 24 |
1269113 | 1269113 | 2021-04-29 | Otsego | Michigan | 26137 | 2204 | 36 |
1269114 | 1269114 | 2021-04-29 | Ottawa | Michigan | 26139 | 30480 | 393 |
1269115 | 1269115 | 2021-04-29 | Presque Isle | Michigan | 26141 | 962 | 31 |
1269116 | 1269116 | 2021-04-29 | Roscommon | Michigan | 26143 | 1800 | 47 |
1269117 | 1269117 | 2021-04-29 | Saginaw | Michigan | 26145 | 20803 | 573 |
1269118 | 1269118 | 2021-04-29 | Sanilac | Michigan | 26151 | 4077 | 103 |
1269119 | 1269119 | 2021-04-29 | Schoolcraft | Michigan | 26153 | 354 | 5 |
1269120 | 1269120 | 2021-04-29 | Shiawassee | Michigan | 26155 | 5978 | 96 |
1269121 | 1269121 | 2021-04-29 | St. Clair | Michigan | 26147 | 17230 | 385 |
1269122 | 1269122 | 2021-04-29 | St. Joseph | Michigan | 26149 | 5810 | 94 |
1269123 | 1269123 | 2021-04-29 | Tuscola | Michigan | 26157 | 5355 | 159 |
1269124 | 1269124 | 2021-04-29 | Unknown | Michigan | 195 | 17 | |
1269125 | 1269125 | 2021-04-29 | Van Buren | Michigan | 26159 | 6677 | 113 |
1269126 | 1269126 | 2021-04-29 | Washtenaw | Michigan | 26161 | 25940 | 278 |
1269127 | 1269127 | 2021-04-29 | Wayne | Michigan | 26163 | 154097 | 4613 |
1269128 | 1269128 | 2021-04-29 | Wexford | Michigan | 26165 | 2678 | 38 |
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);