ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-03-07" 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 |
---|---|---|---|---|---|---|---|
1096942 | 1096942 | 2021-03-07 | Alcona | Michigan | 26001 | 433 | 24 |
1096943 | 1096943 | 2021-03-07 | Alger | Michigan | 26003 | 584 | 5 |
1096944 | 1096944 | 2021-03-07 | Allegan | Michigan | 26005 | 7405 | 118 |
1096945 | 1096945 | 2021-03-07 | Alpena | Michigan | 26007 | 1502 | 48 |
1096946 | 1096946 | 2021-03-07 | Antrim | Michigan | 26009 | 979 | 20 |
1096947 | 1096947 | 2021-03-07 | Arenac | Michigan | 26011 | 767 | 25 |
1096948 | 1096948 | 2021-03-07 | Baraga | Michigan | 26013 | 777 | 33 |
1096949 | 1096949 | 2021-03-07 | Barry | Michigan | 26015 | 3821 | 47 |
1096950 | 1096950 | 2021-03-07 | Bay | Michigan | 26017 | 7549 | 294 |
1096951 | 1096951 | 2021-03-07 | Benzie | Michigan | 26019 | 931 | 31 |
1096952 | 1096952 | 2021-03-07 | Berrien | Michigan | 26021 | 11732 | 245 |
1096953 | 1096953 | 2021-03-07 | Branch | Michigan | 26023 | 4624 | 111 |
1096954 | 1096954 | 2021-03-07 | Calhoun | Michigan | 26025 | 9822 | 235 |
1096955 | 1096955 | 2021-03-07 | Cass | Michigan | 26027 | 4089 | 64 |
1096956 | 1096956 | 2021-03-07 | Charlevoix | Michigan | 26029 | 1065 | 13 |
1096957 | 1096957 | 2021-03-07 | Cheboygan | Michigan | 26031 | 1033 | 38 |
1096958 | 1096958 | 2021-03-07 | Chippewa | Michigan | 26033 | 4891 | 43 |
1096959 | 1096959 | 2021-03-07 | Clare | Michigan | 26035 | 1626 | 69 |
1096960 | 1096960 | 2021-03-07 | Clinton | Michigan | 26037 | 5098 | 71 |
1096961 | 1096961 | 2021-03-07 | Crawford | Michigan | 26039 | 607 | 5 |
1096962 | 1096962 | 2021-03-07 | Delta | Michigan | 26041 | 3157 | 85 |
1096963 | 1096963 | 2021-03-07 | Dickinson | Michigan | 26043 | 2373 | 70 |
1096964 | 1096964 | 2021-03-07 | Eaton | Michigan | 26045 | 6407 | 156 |
1096965 | 1096965 | 2021-03-07 | Emmet | Michigan | 26047 | 1557 | 39 |
1096966 | 1096966 | 2021-03-07 | Genesee | Michigan | 26049 | 26111 | 757 |
1096967 | 1096967 | 2021-03-07 | Gladwin | Michigan | 26051 | 1500 | 43 |
1096968 | 1096968 | 2021-03-07 | Gogebic | Michigan | 26053 | 1289 | 48 |
1096969 | 1096969 | 2021-03-07 | Grand Traverse | Michigan | 26055 | 4368 | 71 |
1096970 | 1096970 | 2021-03-07 | Gratiot | Michigan | 26057 | 5684 | 108 |
1096971 | 1096971 | 2021-03-07 | Hillsdale | Michigan | 26059 | 3392 | 76 |
1096972 | 1096972 | 2021-03-07 | Houghton | Michigan | 26061 | 2686 | 40 |
1096973 | 1096973 | 2021-03-07 | Huron | Michigan | 26063 | 2203 | 59 |
1096974 | 1096974 | 2021-03-07 | Ingham | Michigan | 26065 | 16689 | 282 |
1096975 | 1096975 | 2021-03-07 | Ionia | Michigan | 26067 | 7106 | 76 |
1096976 | 1096976 | 2021-03-07 | Iosco | Michigan | 26069 | 1281 | 67 |
1096977 | 1096977 | 2021-03-07 | Iron | Michigan | 26071 | 929 | 49 |
1096978 | 1096978 | 2021-03-07 | Isabella | Michigan | 26073 | 4062 | 73 |
1096979 | 1096979 | 2021-03-07 | Jackson | Michigan | 26075 | 14361 | 255 |
1096980 | 1096980 | 2021-03-07 | Kalamazoo | Michigan | 26077 | 15274 | 324 |
1096981 | 1096981 | 2021-03-07 | Kalkaska | Michigan | 26079 | 634 | 15 |
1096982 | 1096982 | 2021-03-07 | Kent | Michigan | 26081 | 52310 | 717 |
1096983 | 1096983 | 2021-03-07 | Keweenaw | Michigan | 26083 | 145 | 2 |
1096984 | 1096984 | 2021-03-07 | Lake | Michigan | 26085 | 368 | 11 |
1096985 | 1096985 | 2021-03-07 | Lapeer | Michigan | 26087 | 5704 | 131 |
1096986 | 1096986 | 2021-03-07 | Leelanau | Michigan | 26089 | 890 | 15 |
1096987 | 1096987 | 2021-03-07 | Lenawee | Michigan | 26091 | 7878 | 129 |
1096988 | 1096988 | 2021-03-07 | Livingston | Michigan | 26093 | 10586 | 149 |
1096989 | 1096989 | 2021-03-07 | Luce | Michigan | 26095 | 1087 | 2 |
1096990 | 1096990 | 2021-03-07 | Mackinac | Michigan | 26097 | 448 | 3 |
1096991 | 1096991 | 2021-03-07 | Macomb | Michigan | 26099 | 60588 | 1984 |
1096992 | 1096992 | 2021-03-07 | Manistee | Michigan | 26101 | 1535 | 23 |
1096993 | 1096993 | 2021-03-07 | Marquette | Michigan | 26103 | 4830 | 57 |
1096994 | 1096994 | 2021-03-07 | Mason | Michigan | 26105 | 1250 | 26 |
1096995 | 1096995 | 2021-03-07 | Mecosta | Michigan | 26107 | 2043 | 20 |
1096996 | 1096996 | 2021-03-07 | Menominee | Michigan | 26109 | 1882 | 38 |
1096997 | 1096997 | 2021-03-07 | Midland | Michigan | 26111 | 5088 | 66 |
1096998 | 1096998 | 2021-03-07 | Missaukee | Michigan | 26113 | 813 | 18 |
1096999 | 1096999 | 2021-03-07 | Monroe | Michigan | 26115 | 10008 | 204 |
1097000 | 1097000 | 2021-03-07 | Montcalm | Michigan | 26117 | 5671 | 94 |
1097001 | 1097001 | 2021-03-07 | Montmorency | Michigan | 26119 | 370 | 17 |
1097002 | 1097002 | 2021-03-07 | Muskegon | Michigan | 26121 | 12730 | 317 |
1097003 | 1097003 | 2021-03-07 | Newaygo | Michigan | 26123 | 2929 | 52 |
1097004 | 1097004 | 2021-03-07 | Oakland | Michigan | 26125 | 75863 | 2019 |
1097005 | 1097005 | 2021-03-07 | Oceana | Michigan | 26127 | 1889 | 50 |
1097006 | 1097006 | 2021-03-07 | Ogemaw | Michigan | 26129 | 1116 | 34 |
1097007 | 1097007 | 2021-03-07 | Ontonagon | Michigan | 26131 | 413 | 20 |
1097008 | 1097008 | 2021-03-07 | Osceola | Michigan | 26133 | 1070 | 23 |
1097009 | 1097009 | 2021-03-07 | Oscoda | Michigan | 26135 | 401 | 19 |
1097010 | 1097010 | 2021-03-07 | Otsego | Michigan | 26137 | 1196 | 27 |
1097011 | 1097011 | 2021-03-07 | Ottawa | Michigan | 26139 | 22619 | 357 |
1097012 | 1097012 | 2021-03-07 | Presque Isle | Michigan | 26141 | 667 | 28 |
1097013 | 1097013 | 2021-03-07 | Roscommon | Michigan | 26143 | 1188 | 33 |
1097014 | 1097014 | 2021-03-07 | Saginaw | Michigan | 26145 | 16159 | 527 |
1097015 | 1097015 | 2021-03-07 | Sanilac | Michigan | 26151 | 2155 | 77 |
1097016 | 1097016 | 2021-03-07 | Schoolcraft | Michigan | 26153 | 260 | 5 |
1097017 | 1097017 | 2021-03-07 | Shiawassee | Michigan | 26155 | 3894 | 81 |
1097018 | 1097018 | 2021-03-07 | St. Clair | Michigan | 26147 | 8904 | 261 |
1097019 | 1097019 | 2021-03-07 | St. Joseph | Michigan | 26149 | 4788 | 85 |
1097020 | 1097020 | 2021-03-07 | Tuscola | Michigan | 26157 | 3293 | 138 |
1097021 | 1097021 | 2021-03-07 | Unknown | Michigan | 0 | 12 | |
1097022 | 1097022 | 2021-03-07 | Van Buren | Michigan | 26159 | 5033 | 97 |
1097023 | 1097023 | 2021-03-07 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1097024 | 1097024 | 2021-03-07 | Wayne | Michigan | 26163 | 103587 | 4174 |
1097025 | 1097025 | 2021-03-07 | Wexford | Michigan | 26165 | 1481 | 21 |
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);