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-05-15 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1320990 | 1320990 | 2021-05-15 | Alcona | Michigan | 26001 | 726 | 29 |
1320991 | 1320991 | 2021-05-15 | Alger | Michigan | 26003 | 663 | 6 |
1320992 | 1320992 | 2021-05-15 | Allegan | Michigan | 26005 | 10827 | 139 |
1320993 | 1320993 | 2021-05-15 | Alpena | Michigan | 26007 | 2200 | 61 |
1320994 | 1320994 | 2021-05-15 | Antrim | Michigan | 26009 | 1598 | 28 |
1320995 | 1320995 | 2021-05-15 | Arenac | Michigan | 26011 | 1178 | 29 |
1320996 | 1320996 | 2021-05-15 | Baraga | Michigan | 26013 | 943 | 38 |
1320997 | 1320997 | 2021-05-15 | Barry | Michigan | 26015 | 5808 | 65 |
1320998 | 1320998 | 2021-05-15 | Bay | Michigan | 26017 | 11039 | 341 |
1320999 | 1320999 | 2021-05-15 | Benzie | Michigan | 26019 | 1263 | 34 |
1321000 | 1321000 | 2021-05-15 | Berrien | Michigan | 26021 | 15216 | 278 |
1321001 | 1321001 | 2021-05-15 | Branch | Michigan | 26023 | 5573 | 120 |
1321002 | 1321002 | 2021-05-15 | Calhoun | Michigan | 26025 | 14108 | 286 |
1321003 | 1321003 | 2021-05-15 | Cass | Michigan | 26027 | 5340 | 76 |
1321004 | 1321004 | 2021-05-15 | Charlevoix | Michigan | 26029 | 1630 | 20 |
1321005 | 1321005 | 2021-05-15 | Cheboygan | Michigan | 26031 | 1898 | 45 |
1321006 | 1321006 | 2021-05-15 | Chippewa | Michigan | 26033 | 5566 | 49 |
1321007 | 1321007 | 2021-05-15 | Clare | Michigan | 26035 | 2414 | 79 |
1321008 | 1321008 | 2021-05-15 | Clinton | Michigan | 26037 | 7464 | 85 |
1321009 | 1321009 | 2021-05-15 | Crawford | Michigan | 26039 | 974 | 14 |
1321010 | 1321010 | 2021-05-15 | Delta | Michigan | 26041 | 3984 | 91 |
1321011 | 1321011 | 2021-05-15 | Dickinson | Michigan | 26043 | 2711 | 74 |
1321012 | 1321012 | 2021-05-15 | Eaton | Michigan | 26045 | 9952 | 202 |
1321013 | 1321013 | 2021-05-15 | Emmet | Michigan | 26047 | 2340 | 41 |
1321014 | 1321014 | 2021-05-15 | Genesee | Michigan | 26049 | 41098 | 917 |
1321015 | 1321015 | 2021-05-15 | Gladwin | Michigan | 26051 | 2264 | 56 |
1321016 | 1321016 | 2021-05-15 | Gogebic | Michigan | 26053 | 1391 | 50 |
1321017 | 1321017 | 2021-05-15 | Grand Traverse | Michigan | 26055 | 6346 | 95 |
1321018 | 1321018 | 2021-05-15 | Gratiot | Michigan | 26057 | 6875 | 118 |
1321019 | 1321019 | 2021-05-15 | Hillsdale | Michigan | 26059 | 4314 | 90 |
1321020 | 1321020 | 2021-05-15 | Houghton | Michigan | 26061 | 3101 | 40 |
1321021 | 1321021 | 2021-05-15 | Huron | Michigan | 26063 | 4051 | 75 |
1321022 | 1321022 | 2021-05-15 | Ingham | Michigan | 26065 | 24388 | 369 |
1321023 | 1321023 | 2021-05-15 | Ionia | Michigan | 26067 | 9105 | 84 |
1321024 | 1321024 | 2021-05-15 | Iosco | Michigan | 26069 | 1949 | 71 |
1321025 | 1321025 | 2021-05-15 | Iron | Michigan | 26071 | 1040 | 51 |
1321026 | 1321026 | 2021-05-15 | Isabella | Michigan | 26073 | 6165 | 92 |
1321027 | 1321027 | 2021-05-15 | Jackson | Michigan | 26075 | 20658 | 302 |
1321028 | 1321028 | 2021-05-15 | Kalamazoo | Michigan | 26077 | 22589 | 385 |
1321029 | 1321029 | 2021-05-15 | Kalkaska | Michigan | 26079 | 1100 | 23 |
1321030 | 1321030 | 2021-05-15 | Kent | Michigan | 26081 | 71197 | 813 |
1321031 | 1321031 | 2021-05-15 | Keweenaw | Michigan | 26083 | 175 | 2 |
1321032 | 1321032 | 2021-05-15 | Lake | Michigan | 26085 | 608 | 15 |
1321033 | 1321033 | 2021-05-15 | Lapeer | Michigan | 26087 | 9570 | 198 |
1321034 | 1321034 | 2021-05-15 | Leelanau | Michigan | 26089 | 1227 | 18 |
1321035 | 1321035 | 2021-05-15 | Lenawee | Michigan | 26091 | 10676 | 166 |
1321036 | 1321036 | 2021-05-15 | Livingston | Michigan | 26093 | 16462 | 180 |
1321037 | 1321037 | 2021-05-15 | Luce | Michigan | 26095 | 1283 | 4 |
1321038 | 1321038 | 2021-05-15 | Mackinac | Michigan | 26097 | 674 | 3 |
1321039 | 1321039 | 2021-05-15 | Macomb | Michigan | 26099 | 98634 | 2370 |
1321040 | 1321040 | 2021-05-15 | Manistee | Michigan | 26101 | 1947 | 24 |
1321041 | 1321041 | 2021-05-15 | Marquette | Michigan | 26103 | 5873 | 62 |
1321042 | 1321042 | 2021-05-15 | Mason | Michigan | 26105 | 2100 | 36 |
1321043 | 1321043 | 2021-05-15 | Mecosta | Michigan | 26107 | 3120 | 30 |
1321044 | 1321044 | 2021-05-15 | Menominee | Michigan | 26109 | 2101 | 41 |
1321045 | 1321045 | 2021-05-15 | Midland | Michigan | 26111 | 7369 | 84 |
1321046 | 1321046 | 2021-05-15 | Missaukee | Michigan | 26113 | 1475 | 24 |
1321047 | 1321047 | 2021-05-15 | Monroe | Michigan | 26115 | 15096 | 253 |
1321048 | 1321048 | 2021-05-15 | Montcalm | Michigan | 26117 | 7925 | 113 |
1321049 | 1321049 | 2021-05-15 | Montmorency | Michigan | 26119 | 592 | 19 |
1321050 | 1321050 | 2021-05-15 | Muskegon | Michigan | 26121 | 17686 | 356 |
1321051 | 1321051 | 2021-05-15 | Newaygo | Michigan | 26123 | 4724 | 62 |
1321052 | 1321052 | 2021-05-15 | Oakland | Michigan | 26125 | 116183 | 2305 |
1321053 | 1321053 | 2021-05-15 | Oceana | Michigan | 26127 | 2710 | 59 |
1321054 | 1321054 | 2021-05-15 | Ogemaw | Michigan | 26129 | 1665 | 40 |
1321055 | 1321055 | 2021-05-15 | Ontonagon | Michigan | 26131 | 463 | 21 |
1321056 | 1321056 | 2021-05-15 | Osceola | Michigan | 26133 | 1894 | 28 |
1321057 | 1321057 | 2021-05-15 | Oscoda | Michigan | 26135 | 637 | 29 |
1321058 | 1321058 | 2021-05-15 | Otsego | Michigan | 26137 | 2306 | 40 |
1321059 | 1321059 | 2021-05-15 | Ottawa | Michigan | 26139 | 32106 | 408 |
1321060 | 1321060 | 2021-05-15 | Presque Isle | Michigan | 26141 | 1031 | 32 |
1321061 | 1321061 | 2021-05-15 | Roscommon | Michigan | 26143 | 1861 | 48 |
1321062 | 1321062 | 2021-05-15 | Saginaw | Michigan | 26145 | 21936 | 591 |
1321063 | 1321063 | 2021-05-15 | Sanilac | Michigan | 26151 | 4200 | 112 |
1321064 | 1321064 | 2021-05-15 | Schoolcraft | Michigan | 26153 | 407 | 5 |
1321065 | 1321065 | 2021-05-15 | Shiawassee | Michigan | 26155 | 6271 | 102 |
1321066 | 1321066 | 2021-05-15 | St. Clair | Michigan | 26147 | 18016 | 425 |
1321067 | 1321067 | 2021-05-15 | St. Joseph | Michigan | 26149 | 6075 | 96 |
1321068 | 1321068 | 2021-05-15 | Tuscola | Michigan | 26157 | 5585 | 168 |
1321069 | 1321069 | 2021-05-15 | Unknown | Michigan | 609 | 13 | |
1321070 | 1321070 | 2021-05-15 | Van Buren | Michigan | 26159 | 6973 | 123 |
1321071 | 1321071 | 2021-05-15 | Washtenaw | Michigan | 26161 | 26716 | 291 |
1321072 | 1321072 | 2021-05-15 | Wayne | Michigan | 26163 | 161588 | 4873 |
1321073 | 1321073 | 2021-05-15 | Wexford | Michigan | 26165 | 2841 | 45 |
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);