ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-04-20" 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 |
---|---|---|---|---|---|---|---|
2425918 | 2425918 | 2022-04-20 | Alcona | Michigan | 26001 | 1731 | 71 |
2425919 | 2425919 | 2022-04-20 | Alger | Michigan | 26003 | 1867 | 13 |
2425920 | 2425920 | 2022-04-20 | Allegan | Michigan | 26005 | 27133 | 346 |
2425921 | 2425921 | 2022-04-20 | Alpena | Michigan | 26007 | 5699 | 138 |
2425922 | 2425922 | 2022-04-20 | Antrim | Michigan | 26009 | 4346 | 64 |
2425923 | 2425923 | 2022-04-20 | Arenac | Michigan | 26011 | 3200 | 67 |
2425924 | 2425924 | 2022-04-20 | Baraga | Michigan | 26013 | 2210 | 54 |
2425925 | 2425925 | 2022-04-20 | Barry | Michigan | 26015 | 14350 | 167 |
2425926 | 2425926 | 2022-04-20 | Bay | Michigan | 26017 | 27082 | 581 |
2425927 | 2425927 | 2022-04-20 | Benzie | Michigan | 26019 | 3440 | 66 |
2425928 | 2425928 | 2022-04-20 | Berrien | Michigan | 26021 | 34849 | 551 |
2425929 | 2425929 | 2022-04-20 | Branch | Michigan | 26023 | 12185 | 205 |
2425930 | 2425930 | 2022-04-20 | Calhoun | Michigan | 26025 | 34338 | 574 |
2425931 | 2425931 | 2022-04-20 | Cass | Michigan | 26027 | 11116 | 144 |
2425932 | 2425932 | 2022-04-20 | Charlevoix | Michigan | 26029 | 4918 | 60 |
2425933 | 2425933 | 2022-04-20 | Cheboygan | Michigan | 26031 | 4607 | 103 |
2425934 | 2425934 | 2022-04-20 | Chippewa | Michigan | 26033 | 11643 | 120 |
2425935 | 2425935 | 2022-04-20 | Clare | Michigan | 26035 | 6748 | 156 |
2425936 | 2425936 | 2022-04-20 | Clinton | Michigan | 26037 | 21354 | 208 |
2425937 | 2425937 | 2022-04-20 | Crawford | Michigan | 26039 | 2576 | 30 |
2425938 | 2425938 | 2022-04-20 | Delta | Michigan | 26041 | 9935 | 157 |
2425939 | 2425939 | 2022-04-20 | Dickinson | Michigan | 26043 | 7372 | 108 |
2425940 | 2425940 | 2022-04-20 | Eaton | Michigan | 26045 | 26926 | 400 |
2425941 | 2425941 | 2022-04-20 | Emmet | Michigan | 26047 | 6405 | 86 |
2425942 | 2425942 | 2022-04-20 | Genesee | Michigan | 26049 | 101611 | 1711 |
2425943 | 2425943 | 2022-04-20 | Gladwin | Michigan | 26051 | 5566 | 113 |
2425944 | 2425944 | 2022-04-20 | Gogebic | Michigan | 26053 | 3265 | 69 |
2425945 | 2425945 | 2022-04-20 | Grand Traverse | Michigan | 26055 | 17342 | 233 |
2425946 | 2425946 | 2022-04-20 | Gratiot | Michigan | 26057 | 13698 | 192 |
2425947 | 2425947 | 2022-04-20 | Hillsdale | Michigan | 26059 | 10342 | 204 |
2425948 | 2425948 | 2022-04-20 | Houghton | Michigan | 26061 | 7836 | 92 |
2425949 | 2425949 | 2022-04-20 | Huron | Michigan | 26063 | 8011 | 145 |
2425950 | 2425950 | 2022-04-20 | Ingham | Michigan | 26065 | 64433 | 764 |
2425951 | 2425951 | 2022-04-20 | Ionia | Michigan | 26067 | 19598 | 181 |
2425952 | 2425952 | 2022-04-20 | Iosco | Michigan | 26069 | 4810 | 142 |
2425953 | 2425953 | 2022-04-20 | Iron | Michigan | 26071 | 2649 | 87 |
2425954 | 2425954 | 2022-04-20 | Isabella | Michigan | 26073 | 15584 | 208 |
2425955 | 2425955 | 2022-04-20 | Jackson | Michigan | 26075 | 44757 | 585 |
2425956 | 2425956 | 2022-04-20 | Kalamazoo | Michigan | 26077 | 59524 | 674 |
2425957 | 2425957 | 2022-04-20 | Kalkaska | Michigan | 26079 | 3547 | 60 |
2425958 | 2425958 | 2022-04-20 | Kent | Michigan | 26081 | 167281 | 1526 |
2425959 | 2425959 | 2022-04-20 | Keweenaw | Michigan | 26083 | 511 | 13 |
2425960 | 2425960 | 2022-04-20 | Lake | Michigan | 26085 | 1842 | 37 |
2425961 | 2425961 | 2022-04-20 | Lapeer | Michigan | 26087 | 20857 | 427 |
2425962 | 2425962 | 2022-04-20 | Leelanau | Michigan | 26089 | 3603 | 54 |
2425963 | 2425963 | 2022-04-20 | Lenawee | Michigan | 26091 | 26056 | 329 |
2425964 | 2425964 | 2022-04-20 | Livingston | Michigan | 26093 | 46432 | 448 |
2425965 | 2425965 | 2022-04-20 | Luce | Michigan | 26095 | 2280 | 14 |
2425966 | 2425966 | 2022-04-20 | Mackinac | Michigan | 26097 | 2410 | 30 |
2425967 | 2425967 | 2022-04-20 | Macomb | Michigan | 26099 | 232167 | 3958 |
2425968 | 2425968 | 2022-04-20 | Manistee | Michigan | 26101 | 4475 | 90 |
2425969 | 2425969 | 2022-04-20 | Marquette | Michigan | 26103 | 15867 | 130 |
2425970 | 2425970 | 2022-04-20 | Mason | Michigan | 26105 | 6766 | 92 |
2425971 | 2425971 | 2022-04-20 | Mecosta | Michigan | 26107 | 8664 | 108 |
2425972 | 2425972 | 2022-04-20 | Menominee | Michigan | 26109 | 5625 | 70 |
2425973 | 2425973 | 2022-04-20 | Midland | Michigan | 26111 | 19090 | 223 |
2425974 | 2425974 | 2022-04-20 | Missaukee | Michigan | 26113 | 2914 | 60 |
2425975 | 2425975 | 2022-04-20 | Monroe | Michigan | 26115 | 38147 | 473 |
2425976 | 2425976 | 2022-04-20 | Montcalm | Michigan | 26117 | 17188 | 216 |
2425977 | 2425977 | 2022-04-20 | Montmorency | Michigan | 26119 | 1717 | 48 |
2425978 | 2425978 | 2022-04-20 | Muskegon | Michigan | 26121 | 41913 | 648 |
2425979 | 2425979 | 2022-04-20 | Newaygo | Michigan | 26123 | 11485 | 158 |
2425980 | 2425980 | 2022-04-20 | Oakland | Michigan | 26125 | 289946 | 3829 |
2425981 | 2425981 | 2022-04-20 | Oceana | Michigan | 26127 | 6345 | 90 |
2425982 | 2425982 | 2022-04-20 | Ogemaw | Michigan | 26129 | 4312 | 106 |
2425983 | 2425983 | 2022-04-20 | Ontonagon | Michigan | 26131 | 994 | 38 |
2425984 | 2425984 | 2022-04-20 | Osceola | Michigan | 26133 | 5016 | 80 |
2425985 | 2425985 | 2022-04-20 | Oscoda | Michigan | 26135 | 1434 | 55 |
2425986 | 2425986 | 2022-04-20 | Otsego | Michigan | 26137 | 5650 | 100 |
2425987 | 2425987 | 2022-04-20 | Ottawa | Michigan | 26139 | 75061 | 788 |
2425988 | 2425988 | 2022-04-20 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2425989 | 2425989 | 2022-04-20 | Roscommon | Michigan | 26143 | 4627 | 114 |
2425990 | 2425990 | 2022-04-20 | Saginaw | Michigan | 26145 | 50475 | 950 |
2425991 | 2425991 | 2022-04-20 | Sanilac | Michigan | 26151 | 8702 | 191 |
2425992 | 2425992 | 2022-04-20 | Schoolcraft | Michigan | 26153 | 1747 | 16 |
2425993 | 2425993 | 2022-04-20 | Shiawassee | Michigan | 26155 | 17831 | 230 |
2425994 | 2425994 | 2022-04-20 | St. Clair | Michigan | 26147 | 40814 | 832 |
2425995 | 2425995 | 2022-04-20 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2425996 | 2425996 | 2022-04-20 | Tuscola | Michigan | 26157 | 13213 | 276 |
2425997 | 2425997 | 2022-04-20 | Unknown | Michigan | 12218 | 39 | |
2425998 | 2425998 | 2022-04-20 | Van Buren | Michigan | 26159 | 17084 | 270 |
2425999 | 2425999 | 2022-04-20 | Washtenaw | Michigan | 26161 | 77992 | 515 |
2426000 | 2426000 | 2022-04-20 | Wayne | Michigan | 26163 | 403423 | 7924 |
2426001 | 2426001 | 2022-04-20 | Wexford | Michigan | 26165 | 7086 | 106 |
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);