ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
752921 | 752921 | 2020-11-21 | Alcona | Michigan | 26001 | 127 | 3 |
752922 | 752922 | 2020-11-21 | Alger | Michigan | 26003 | 223 | 2 |
752923 | 752923 | 2020-11-21 | Allegan | Michigan | 26005 | 3348 | 20 |
752924 | 752924 | 2020-11-21 | Alpena | Michigan | 26007 | 452 | 16 |
752925 | 752925 | 2020-11-21 | Antrim | Michigan | 26009 | 324 | 5 |
752926 | 752926 | 2020-11-21 | Arenac | Michigan | 26011 | 309 | 11 |
752927 | 752927 | 2020-11-21 | Baraga | Michigan | 26013 | 392 | 6 |
752928 | 752928 | 2020-11-21 | Barry | Michigan | 26015 | 1707 | 12 |
752929 | 752929 | 2020-11-21 | Bay | Michigan | 26017 | 3634 | 81 |
752930 | 752930 | 2020-11-21 | Benzie | Michigan | 26019 | 295 | 4 |
752931 | 752931 | 2020-11-21 | Berrien | Michigan | 26021 | 5619 | 106 |
752932 | 752932 | 2020-11-21 | Branch | Michigan | 26023 | 2766 | 50 |
752933 | 752933 | 2020-11-21 | Calhoun | Michigan | 26025 | 5309 | 111 |
752934 | 752934 | 2020-11-21 | Cass | Michigan | 26027 | 1926 | 28 |
752935 | 752935 | 2020-11-21 | Charlevoix | Michigan | 26029 | 459 | 6 |
752936 | 752936 | 2020-11-21 | Cheboygan | Michigan | 26031 | 389 | 16 |
752937 | 752937 | 2020-11-21 | Chippewa | Michigan | 26033 | 676 | 2 |
752938 | 752938 | 2020-11-21 | Clare | Michigan | 26035 | 624 | 22 |
752939 | 752939 | 2020-11-21 | Clinton | Michigan | 26037 | 2396 | 19 |
752940 | 752940 | 2020-11-21 | Crawford | Michigan | 26039 | 284 | 5 |
752941 | 752941 | 2020-11-21 | Delta | Michigan | 26041 | 2286 | 56 |
752942 | 752942 | 2020-11-21 | Dickinson | Michigan | 26043 | 1527 | 30 |
752943 | 752943 | 2020-11-21 | Eaton | Michigan | 26045 | 2564 | 29 |
752944 | 752944 | 2020-11-21 | Emmet | Michigan | 26047 | 835 | 27 |
752945 | 752945 | 2020-11-21 | Genesee | Michigan | 26049 | 12517 | 399 |
752946 | 752946 | 2020-11-21 | Gladwin | Michigan | 26051 | 643 | 8 |
752947 | 752947 | 2020-11-21 | Gogebic | Michigan | 26053 | 702 | 20 |
752948 | 752948 | 2020-11-21 | Grand Traverse | Michigan | 26055 | 1586 | 18 |
752949 | 752949 | 2020-11-21 | Gratiot | Michigan | 26057 | 1351 | 27 |
752950 | 752950 | 2020-11-21 | Hillsdale | Michigan | 26059 | 1348 | 34 |
752951 | 752951 | 2020-11-21 | Houghton | Michigan | 26061 | 1416 | 11 |
752952 | 752952 | 2020-11-21 | Huron | Michigan | 26063 | 592 | 13 |
752953 | 752953 | 2020-11-21 | Ingham | Michigan | 26065 | 7733 | 97 |
752954 | 752954 | 2020-11-21 | Ionia | Michigan | 26067 | 2638 | 13 |
752955 | 752955 | 2020-11-21 | Iosco | Michigan | 26069 | 591 | 20 |
752956 | 752956 | 2020-11-21 | Iron | Michigan | 26071 | 674 | 32 |
752957 | 752957 | 2020-11-21 | Isabella | Michigan | 26073 | 2114 | 18 |
752958 | 752958 | 2020-11-21 | Jackson | Michigan | 26075 | 5825 | 110 |
752959 | 752959 | 2020-11-21 | Kalamazoo | Michigan | 26077 | 8256 | 157 |
752960 | 752960 | 2020-11-21 | Kalkaska | Michigan | 26079 | 293 | 4 |
752961 | 752961 | 2020-11-21 | Kent | Michigan | 26081 | 28340 | 292 |
752962 | 752962 | 2020-11-21 | Keweenaw | Michigan | 26083 | 62 | 1 |
752963 | 752963 | 2020-11-21 | Lake | Michigan | 26085 | 165 | 3 |
752964 | 752964 | 2020-11-21 | Lapeer | Michigan | 26087 | 2263 | 55 |
752965 | 752965 | 2020-11-21 | Leelanau | Michigan | 26089 | 319 | 2 |
752966 | 752966 | 2020-11-21 | Lenawee | Michigan | 26091 | 2833 | 26 |
752967 | 752967 | 2020-11-21 | Livingston | Michigan | 26093 | 4560 | 43 |
752968 | 752968 | 2020-11-21 | Luce | Michigan | 26095 | 571 | 0 |
752969 | 752969 | 2020-11-21 | Mackinac | Michigan | 26097 | 246 | 0 |
752970 | 752970 | 2020-11-21 | Macomb | Michigan | 26099 | 32074 | 1218 |
752971 | 752971 | 2020-11-21 | Manistee | Michigan | 26101 | 310 | 5 |
752972 | 752972 | 2020-11-21 | Marquette | Michigan | 26103 | 3391 | 25 |
752973 | 752973 | 2020-11-21 | Mason | Michigan | 26105 | 504 | 9 |
752974 | 752974 | 2020-11-21 | Mecosta | Michigan | 26107 | 1030 | 7 |
752975 | 752975 | 2020-11-21 | Menominee | Michigan | 26109 | 1186 | 12 |
752976 | 752976 | 2020-11-21 | Midland | Michigan | 26111 | 2564 | 23 |
752977 | 752977 | 2020-11-21 | Missaukee | Michigan | 26113 | 238 | 2 |
752978 | 752978 | 2020-11-21 | Monroe | Michigan | 26115 | 4351 | 60 |
752979 | 752979 | 2020-11-21 | Montcalm | Michigan | 26117 | 1540 | 21 |
752980 | 752980 | 2020-11-21 | Montmorency | Michigan | 26119 | 115 | 2 |
752981 | 752981 | 2020-11-21 | Muskegon | Michigan | 26121 | 7289 | 150 |
752982 | 752982 | 2020-11-21 | Newaygo | Michigan | 26123 | 1308 | 15 |
752983 | 752983 | 2020-11-21 | Oakland | Michigan | 26125 | 40381 | 1310 |
752984 | 752984 | 2020-11-21 | Oceana | Michigan | 26127 | 1039 | 13 |
752985 | 752985 | 2020-11-21 | Ogemaw | Michigan | 26129 | 387 | 10 |
752986 | 752986 | 2020-11-21 | Ontonagon | Michigan | 26131 | 257 | 11 |
752987 | 752987 | 2020-11-21 | Osceola | Michigan | 26133 | 417 | 3 |
752988 | 752988 | 2020-11-21 | Oscoda | Michigan | 26135 | 118 | 2 |
752989 | 752989 | 2020-11-21 | Otsego | Michigan | 26137 | 631 | 16 |
752990 | 752990 | 2020-11-21 | Ottawa | Michigan | 26139 | 11706 | 124 |
752991 | 752991 | 2020-11-21 | Presque Isle | Michigan | 26141 | 196 | 3 |
752992 | 752992 | 2020-11-21 | Roscommon | Michigan | 26143 | 478 | 7 |
752993 | 752993 | 2020-11-21 | Saginaw | Michigan | 26145 | 7367 | 204 |
752994 | 752994 | 2020-11-21 | Sanilac | Michigan | 26151 | 548 | 12 |
752995 | 752995 | 2020-11-21 | Schoolcraft | Michigan | 26153 | 163 | 2 |
752996 | 752996 | 2020-11-21 | Shiawassee | Michigan | 26155 | 1626 | 38 |
752997 | 752997 | 2020-11-21 | St. Clair | Michigan | 26147 | 3620 | 78 |
752998 | 752998 | 2020-11-21 | St. Joseph | Michigan | 26149 | 2266 | 31 |
752999 | 752999 | 2020-11-21 | Tuscola | Michigan | 26157 | 1426 | 46 |
753000 | 753000 | 2020-11-21 | Unknown | Michigan | 4518 | 8 | |
753001 | 753001 | 2020-11-21 | Van Buren | Michigan | 26159 | 2352 | 32 |
753002 | 753002 | 2020-11-21 | Washtenaw | Michigan | 26161 | 9086 | 137 |
753003 | 753003 | 2020-11-21 | Wayne | Michigan | 26163 | 57116 | 3156 |
753004 | 753004 | 2020-11-21 | Wexford | Michigan | 26165 | 471 | 12 |
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);