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-03-27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1161876 | 1161876 | 2021-03-27 | Alcona | Michigan | 26001 | 459 | 25 |
1161877 | 1161877 | 2021-03-27 | Alger | Michigan | 26003 | 594 | 5 |
1161878 | 1161878 | 2021-03-27 | Allegan | Michigan | 26005 | 8048 | 118 |
1161879 | 1161879 | 2021-03-27 | Alpena | Michigan | 26007 | 1575 | 48 |
1161880 | 1161880 | 2021-03-27 | Antrim | Michigan | 26009 | 1158 | 20 |
1161881 | 1161881 | 2021-03-27 | Arenac | Michigan | 26011 | 792 | 27 |
1161882 | 1161882 | 2021-03-27 | Baraga | Michigan | 26013 | 794 | 34 |
1161883 | 1161883 | 2021-03-27 | Barry | Michigan | 26015 | 4117 | 50 |
1161884 | 1161884 | 2021-03-27 | Bay | Michigan | 26017 | 8134 | 302 |
1161885 | 1161885 | 2021-03-27 | Benzie | Michigan | 26019 | 993 | 32 |
1161886 | 1161886 | 2021-03-27 | Berrien | Michigan | 26021 | 12603 | 250 |
1161887 | 1161887 | 2021-03-27 | Branch | Michigan | 26023 | 4817 | 111 |
1161888 | 1161888 | 2021-03-27 | Calhoun | Michigan | 26025 | 10896 | 246 |
1161889 | 1161889 | 2021-03-27 | Cass | Michigan | 26027 | 4494 | 68 |
1161890 | 1161890 | 2021-03-27 | Charlevoix | Michigan | 26029 | 1158 | 13 |
1161891 | 1161891 | 2021-03-27 | Cheboygan | Michigan | 26031 | 1228 | 38 |
1161892 | 1161892 | 2021-03-27 | Chippewa | Michigan | 26033 | 5082 | 46 |
1161893 | 1161893 | 2021-03-27 | Clare | Michigan | 26035 | 1698 | 69 |
1161894 | 1161894 | 2021-03-27 | Clinton | Michigan | 26037 | 5757 | 75 |
1161895 | 1161895 | 2021-03-27 | Crawford | Michigan | 26039 | 693 | 5 |
1161896 | 1161896 | 2021-03-27 | Delta | Michigan | 26041 | 3267 | 86 |
1161897 | 1161897 | 2021-03-27 | Dickinson | Michigan | 26043 | 2426 | 71 |
1161898 | 1161898 | 2021-03-27 | Eaton | Michigan | 26045 | 7257 | 160 |
1161899 | 1161899 | 2021-03-27 | Emmet | Michigan | 26047 | 1660 | 39 |
1161900 | 1161900 | 2021-03-27 | Genesee | Michigan | 26049 | 29401 | 774 |
1161901 | 1161901 | 2021-03-27 | Gladwin | Michigan | 26051 | 1586 | 43 |
1161902 | 1161902 | 2021-03-27 | Gogebic | Michigan | 26053 | 1320 | 49 |
1161903 | 1161903 | 2021-03-27 | Grand Traverse | Michigan | 26055 | 4848 | 77 |
1161904 | 1161904 | 2021-03-27 | Gratiot | Michigan | 26057 | 5807 | 109 |
1161905 | 1161905 | 2021-03-27 | Hillsdale | Michigan | 26059 | 3604 | 79 |
1161906 | 1161906 | 2021-03-27 | Houghton | Michigan | 26061 | 2807 | 39 |
1161907 | 1161907 | 2021-03-27 | Huron | Michigan | 26063 | 2835 | 62 |
1161908 | 1161908 | 2021-03-27 | Ingham | Michigan | 26065 | 18753 | 298 |
1161909 | 1161909 | 2021-03-27 | Ionia | Michigan | 26067 | 7464 | 79 |
1161910 | 1161910 | 2021-03-27 | Iosco | Michigan | 26069 | 1348 | 67 |
1161911 | 1161911 | 2021-03-27 | Iron | Michigan | 26071 | 933 | 51 |
1161912 | 1161912 | 2021-03-27 | Isabella | Michigan | 26073 | 4326 | 77 |
1161913 | 1161913 | 2021-03-27 | Jackson | Michigan | 26075 | 16200 | 263 |
1161914 | 1161914 | 2021-03-27 | Kalamazoo | Michigan | 26077 | 16947 | 328 |
1161915 | 1161915 | 2021-03-27 | Kalkaska | Michigan | 26079 | 746 | 15 |
1161916 | 1161916 | 2021-03-27 | Kent | Michigan | 26081 | 55436 | 735 |
1161917 | 1161917 | 2021-03-27 | Keweenaw | Michigan | 26083 | 155 | 2 |
1161918 | 1161918 | 2021-03-27 | Lake | Michigan | 26085 | 414 | 11 |
1161919 | 1161919 | 2021-03-27 | Lapeer | Michigan | 26087 | 6646 | 138 |
1161920 | 1161920 | 2021-03-27 | Leelanau | Michigan | 26089 | 977 | 15 |
1161921 | 1161921 | 2021-03-27 | Lenawee | Michigan | 26091 | 8303 | 136 |
1161922 | 1161922 | 2021-03-27 | Livingston | Michigan | 26093 | 11911 | 154 |
1161923 | 1161923 | 2021-03-27 | Luce | Michigan | 26095 | 1106 | 2 |
1161924 | 1161924 | 2021-03-27 | Mackinac | Michigan | 26097 | 480 | 3 |
1161925 | 1161925 | 2021-03-27 | Macomb | Michigan | 26099 | 69538 | 2025 |
1161926 | 1161926 | 2021-03-27 | Manistee | Michigan | 26101 | 1621 | 23 |
1161927 | 1161927 | 2021-03-27 | Marquette | Michigan | 26103 | 5018 | 57 |
1161928 | 1161928 | 2021-03-27 | Mason | Michigan | 26105 | 1333 | 27 |
1161929 | 1161929 | 2021-03-27 | Mecosta | Michigan | 26107 | 2181 | 22 |
1161930 | 1161930 | 2021-03-27 | Menominee | Michigan | 26109 | 1923 | 41 |
1161931 | 1161931 | 2021-03-27 | Midland | Michigan | 26111 | 5490 | 68 |
1161932 | 1161932 | 2021-03-27 | Missaukee | Michigan | 26113 | 1046 | 20 |
1161933 | 1161933 | 2021-03-27 | Monroe | Michigan | 26115 | 11197 | 212 |
1161934 | 1161934 | 2021-03-27 | Montcalm | Michigan | 26117 | 5968 | 96 |
1161935 | 1161935 | 2021-03-27 | Montmorency | Michigan | 26119 | 387 | 18 |
1161936 | 1161936 | 2021-03-27 | Muskegon | Michigan | 26121 | 13179 | 318 |
1161937 | 1161937 | 2021-03-27 | Newaygo | Michigan | 26123 | 3257 | 54 |
1161938 | 1161938 | 2021-03-27 | Oakland | Michigan | 26125 | 84984 | 2054 |
1161939 | 1161939 | 2021-03-27 | Oceana | Michigan | 26127 | 1973 | 51 |
1161940 | 1161940 | 2021-03-27 | Ogemaw | Michigan | 26129 | 1162 | 34 |
1161941 | 1161941 | 2021-03-27 | Ontonagon | Michigan | 26131 | 431 | 21 |
1161942 | 1161942 | 2021-03-27 | Osceola | Michigan | 26133 | 1248 | 23 |
1161943 | 1161943 | 2021-03-27 | Oscoda | Michigan | 26135 | 441 | 20 |
1161944 | 1161944 | 2021-03-27 | Otsego | Michigan | 26137 | 1542 | 28 |
1161945 | 1161945 | 2021-03-27 | Ottawa | Michigan | 26139 | 24182 | 361 |
1161946 | 1161946 | 2021-03-27 | Presque Isle | Michigan | 26141 | 725 | 28 |
1161947 | 1161947 | 2021-03-27 | Roscommon | Michigan | 26143 | 1458 | 39 |
1161948 | 1161948 | 2021-03-27 | Saginaw | Michigan | 26145 | 17059 | 542 |
1161949 | 1161949 | 2021-03-27 | Sanilac | Michigan | 26151 | 2774 | 82 |
1161950 | 1161950 | 2021-03-27 | Schoolcraft | Michigan | 26153 | 280 | 5 |
1161951 | 1161951 | 2021-03-27 | Shiawassee | Michigan | 26155 | 4288 | 84 |
1161952 | 1161952 | 2021-03-27 | St. Clair | Michigan | 26147 | 11268 | 273 |
1161953 | 1161953 | 2021-03-27 | St. Joseph | Michigan | 26149 | 5104 | 90 |
1161954 | 1161954 | 2021-03-27 | Tuscola | Michigan | 26157 | 3815 | 140 |
1161955 | 1161955 | 2021-03-27 | Unknown | Michigan | 0 | 12 | |
1161956 | 1161956 | 2021-03-27 | Van Buren | Michigan | 26159 | 5447 | 99 |
1161957 | 1161957 | 2021-03-27 | Washtenaw | Michigan | 26161 | 20950 | 257 |
1161958 | 1161958 | 2021-03-27 | Wayne | Michigan | 26163 | 114868 | 4246 |
1161959 | 1161959 | 2021-03-27 | Wexford | Michigan | 26165 | 1970 | 24 |
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);