ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-03-15" 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 |
---|---|---|---|---|---|---|---|
1122913 | 1122913 | 2021-03-15 | Alcona | Michigan | 26001 | 436 | 24 |
1122914 | 1122914 | 2021-03-15 | Alger | Michigan | 26003 | 584 | 5 |
1122915 | 1122915 | 2021-03-15 | Allegan | Michigan | 26005 | 7598 | 118 |
1122916 | 1122916 | 2021-03-15 | Alpena | Michigan | 26007 | 1512 | 48 |
1122917 | 1122917 | 2021-03-15 | Antrim | Michigan | 26009 | 1024 | 20 |
1122918 | 1122918 | 2021-03-15 | Arenac | Michigan | 26011 | 772 | 25 |
1122919 | 1122919 | 2021-03-15 | Baraga | Michigan | 26013 | 786 | 34 |
1122920 | 1122920 | 2021-03-15 | Barry | Michigan | 26015 | 3897 | 49 |
1122921 | 1122921 | 2021-03-15 | Bay | Michigan | 26017 | 7697 | 297 |
1122922 | 1122922 | 2021-03-15 | Benzie | Michigan | 26019 | 949 | 32 |
1122923 | 1122923 | 2021-03-15 | Berrien | Michigan | 26021 | 11981 | 247 |
1122924 | 1122924 | 2021-03-15 | Branch | Michigan | 26023 | 4674 | 111 |
1122925 | 1122925 | 2021-03-15 | Calhoun | Michigan | 26025 | 10213 | 239 |
1122926 | 1122926 | 2021-03-15 | Cass | Michigan | 26027 | 4222 | 67 |
1122927 | 1122927 | 2021-03-15 | Charlevoix | Michigan | 26029 | 1098 | 13 |
1122928 | 1122928 | 2021-03-15 | Cheboygan | Michigan | 26031 | 1101 | 38 |
1122929 | 1122929 | 2021-03-15 | Chippewa | Michigan | 26033 | 4912 | 43 |
1122930 | 1122930 | 2021-03-15 | Clare | Michigan | 26035 | 1637 | 69 |
1122931 | 1122931 | 2021-03-15 | Clinton | Michigan | 26037 | 5301 | 72 |
1122932 | 1122932 | 2021-03-15 | Crawford | Michigan | 26039 | 624 | 5 |
1122933 | 1122933 | 2021-03-15 | Delta | Michigan | 26041 | 3191 | 85 |
1122934 | 1122934 | 2021-03-15 | Dickinson | Michigan | 26043 | 2389 | 70 |
1122935 | 1122935 | 2021-03-15 | Eaton | Michigan | 26045 | 6611 | 158 |
1122936 | 1122936 | 2021-03-15 | Emmet | Michigan | 26047 | 1582 | 39 |
1122937 | 1122937 | 2021-03-15 | Genesee | Michigan | 26049 | 26979 | 762 |
1122938 | 1122938 | 2021-03-15 | Gladwin | Michigan | 26051 | 1510 | 43 |
1122939 | 1122939 | 2021-03-15 | Gogebic | Michigan | 26053 | 1298 | 49 |
1122940 | 1122940 | 2021-03-15 | Grand Traverse | Michigan | 26055 | 4543 | 73 |
1122941 | 1122941 | 2021-03-15 | Gratiot | Michigan | 26057 | 5713 | 108 |
1122942 | 1122942 | 2021-03-15 | Hillsdale | Michigan | 26059 | 3448 | 77 |
1122943 | 1122943 | 2021-03-15 | Houghton | Michigan | 26061 | 2703 | 39 |
1122944 | 1122944 | 2021-03-15 | Huron | Michigan | 26063 | 2400 | 60 |
1122945 | 1122945 | 2021-03-15 | Ingham | Michigan | 26065 | 17251 | 287 |
1122946 | 1122946 | 2021-03-15 | Ionia | Michigan | 26067 | 7212 | 79 |
1122947 | 1122947 | 2021-03-15 | Iosco | Michigan | 26069 | 1294 | 67 |
1122948 | 1122948 | 2021-03-15 | Iron | Michigan | 26071 | 927 | 49 |
1122949 | 1122949 | 2021-03-15 | Isabella | Michigan | 26073 | 4125 | 73 |
1122950 | 1122950 | 2021-03-15 | Jackson | Michigan | 26075 | 14736 | 257 |
1122951 | 1122951 | 2021-03-15 | Kalamazoo | Michigan | 26077 | 15739 | 324 |
1122952 | 1122952 | 2021-03-15 | Kalkaska | Michigan | 26079 | 675 | 15 |
1122953 | 1122953 | 2021-03-15 | Kent | Michigan | 26081 | 53185 | 721 |
1122954 | 1122954 | 2021-03-15 | Keweenaw | Michigan | 26083 | 148 | 2 |
1122955 | 1122955 | 2021-03-15 | Lake | Michigan | 26085 | 380 | 11 |
1122956 | 1122956 | 2021-03-15 | Lapeer | Michigan | 26087 | 5924 | 132 |
1122957 | 1122957 | 2021-03-15 | Leelanau | Michigan | 26089 | 925 | 15 |
1122958 | 1122958 | 2021-03-15 | Lenawee | Michigan | 26091 | 8003 | 131 |
1122959 | 1122959 | 2021-03-15 | Livingston | Michigan | 26093 | 11000 | 151 |
1122960 | 1122960 | 2021-03-15 | Luce | Michigan | 26095 | 1094 | 2 |
1122961 | 1122961 | 2021-03-15 | Mackinac | Michigan | 26097 | 450 | 3 |
1122962 | 1122962 | 2021-03-15 | Macomb | Michigan | 26099 | 62710 | 2000 |
1122963 | 1122963 | 2021-03-15 | Manistee | Michigan | 26101 | 1555 | 23 |
1122964 | 1122964 | 2021-03-15 | Marquette | Michigan | 26103 | 4869 | 57 |
1122965 | 1122965 | 2021-03-15 | Mason | Michigan | 26105 | 1266 | 26 |
1122966 | 1122966 | 2021-03-15 | Mecosta | Michigan | 26107 | 2074 | 21 |
1122967 | 1122967 | 2021-03-15 | Menominee | Michigan | 26109 | 1898 | 38 |
1122968 | 1122968 | 2021-03-15 | Midland | Michigan | 26111 | 5221 | 66 |
1122969 | 1122969 | 2021-03-15 | Missaukee | Michigan | 26113 | 900 | 18 |
1122970 | 1122970 | 2021-03-15 | Monroe | Michigan | 26115 | 10379 | 207 |
1122971 | 1122971 | 2021-03-15 | Montcalm | Michigan | 26117 | 5731 | 96 |
1122972 | 1122972 | 2021-03-15 | Montmorency | Michigan | 26119 | 372 | 18 |
1122973 | 1122973 | 2021-03-15 | Muskegon | Michigan | 26121 | 12842 | 318 |
1122974 | 1122974 | 2021-03-15 | Newaygo | Michigan | 26123 | 3043 | 52 |
1122975 | 1122975 | 2021-03-15 | Oakland | Michigan | 26125 | 78091 | 2027 |
1122976 | 1122976 | 2021-03-15 | Oceana | Michigan | 26127 | 1912 | 50 |
1122977 | 1122977 | 2021-03-15 | Ogemaw | Michigan | 26129 | 1130 | 34 |
1122978 | 1122978 | 2021-03-15 | Ontonagon | Michigan | 26131 | 422 | 21 |
1122979 | 1122979 | 2021-03-15 | Osceola | Michigan | 26133 | 1119 | 23 |
1122980 | 1122980 | 2021-03-15 | Oscoda | Michigan | 26135 | 405 | 19 |
1122981 | 1122981 | 2021-03-15 | Otsego | Michigan | 26137 | 1319 | 27 |
1122982 | 1122982 | 2021-03-15 | Ottawa | Michigan | 26139 | 22949 | 359 |
1122983 | 1122983 | 2021-03-15 | Presque Isle | Michigan | 26141 | 672 | 28 |
1122984 | 1122984 | 2021-03-15 | Roscommon | Michigan | 26143 | 1262 | 34 |
1122985 | 1122985 | 2021-03-15 | Saginaw | Michigan | 26145 | 16439 | 535 |
1122986 | 1122986 | 2021-03-15 | Sanilac | Michigan | 26151 | 2296 | 77 |
1122987 | 1122987 | 2021-03-15 | Schoolcraft | Michigan | 26153 | 267 | 5 |
1122988 | 1122988 | 2021-03-15 | Shiawassee | Michigan | 26155 | 3986 | 83 |
1122989 | 1122989 | 2021-03-15 | St. Clair | Michigan | 26147 | 9452 | 262 |
1122990 | 1122990 | 2021-03-15 | St. Joseph | Michigan | 26149 | 4920 | 87 |
1122991 | 1122991 | 2021-03-15 | Tuscola | Michigan | 26157 | 3414 | 139 |
1122992 | 1122992 | 2021-03-15 | Unknown | Michigan | 0 | 13 | |
1122993 | 1122993 | 2021-03-15 | Van Buren | Michigan | 26159 | 5146 | 98 |
1122994 | 1122994 | 2021-03-15 | Washtenaw | Michigan | 26161 | 19948 | 254 |
1122995 | 1122995 | 2021-03-15 | Wayne | Michigan | 26163 | 106614 | 4196 |
1122996 | 1122996 | 2021-03-15 | Wexford | Michigan | 26165 | 1611 | 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);