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 2020-10-23 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
658846 | 658846 | 2020-10-23 | Alcona | Michigan | 26001 | 52 | 2 |
658847 | 658847 | 2020-10-23 | Alger | Michigan | 26003 | 104 | 1 |
658848 | 658848 | 2020-10-23 | Allegan | Michigan | 26005 | 1165 | 7 |
658849 | 658849 | 2020-10-23 | Alpena | Michigan | 26007 | 156 | 14 |
658850 | 658850 | 2020-10-23 | Antrim | Michigan | 26009 | 110 | 0 |
658851 | 658851 | 2020-10-23 | Arenac | Michigan | 26011 | 90 | 3 |
658852 | 658852 | 2020-10-23 | Baraga | Michigan | 26013 | 78 | 4 |
658853 | 658853 | 2020-10-23 | Barry | Michigan | 26015 | 590 | 5 |
658854 | 658854 | 2020-10-23 | Bay | Michigan | 26017 | 1312 | 60 |
658855 | 658855 | 2020-10-23 | Benzie | Michigan | 26019 | 114 | 2 |
658856 | 658856 | 2020-10-23 | Berrien | Michigan | 26021 | 2609 | 81 |
658857 | 658857 | 2020-10-23 | Branch | Michigan | 26023 | 1654 | 33 |
658858 | 658858 | 2020-10-23 | Calhoun | Michigan | 26025 | 2541 | 65 |
658859 | 658859 | 2020-10-23 | Cass | Michigan | 26027 | 926 | 24 |
658860 | 658860 | 2020-10-23 | Charlevoix | Michigan | 26029 | 161 | 4 |
658861 | 658861 | 2020-10-23 | Cheboygan | Michigan | 26031 | 130 | 2 |
658862 | 658862 | 2020-10-23 | Chippewa | Michigan | 26033 | 124 | 0 |
658863 | 658863 | 2020-10-23 | Clare | Michigan | 26035 | 244 | 9 |
658864 | 658864 | 2020-10-23 | Clinton | Michigan | 26037 | 1007 | 14 |
658865 | 658865 | 2020-10-23 | Crawford | Michigan | 26039 | 146 | 5 |
658866 | 658866 | 2020-10-23 | Delta | Michigan | 26041 | 1111 | 22 |
658867 | 658867 | 2020-10-23 | Dickinson | Michigan | 26043 | 550 | 17 |
658868 | 658868 | 2020-10-23 | Eaton | Michigan | 26045 | 1039 | 11 |
658869 | 658869 | 2020-10-23 | Emmet | Michigan | 26047 | 214 | 4 |
658870 | 658870 | 2020-10-23 | Genesee | Michigan | 26049 | 6356 | 331 |
658871 | 658871 | 2020-10-23 | Gladwin | Michigan | 26051 | 178 | 2 |
658872 | 658872 | 2020-10-23 | Gogebic | Michigan | 26053 | 348 | 2 |
658873 | 658873 | 2020-10-23 | Grand Traverse | Michigan | 26055 | 728 | 13 |
658874 | 658874 | 2020-10-23 | Gratiot | Michigan | 26057 | 451 | 16 |
658875 | 658875 | 2020-10-23 | Hillsdale | Michigan | 26059 | 490 | 28 |
658876 | 658876 | 2020-10-23 | Houghton | Michigan | 26061 | 895 | 9 |
658877 | 658877 | 2020-10-23 | Huron | Michigan | 26063 | 260 | 5 |
658878 | 658878 | 2020-10-23 | Ingham | Michigan | 26065 | 4456 | 62 |
658879 | 658879 | 2020-10-23 | Ionia | Michigan | 26067 | 809 | 9 |
658880 | 658880 | 2020-10-23 | Iosco | Michigan | 26069 | 273 | 15 |
658881 | 658881 | 2020-10-23 | Iron | Michigan | 26071 | 404 | 21 |
658882 | 658882 | 2020-10-23 | Isabella | Michigan | 26073 | 979 | 15 |
658883 | 658883 | 2020-10-23 | Jackson | Michigan | 26075 | 3338 | 86 |
658884 | 658884 | 2020-10-23 | Kalamazoo | Michigan | 26077 | 4504 | 102 |
658885 | 658885 | 2020-10-23 | Kalkaska | Michigan | 26079 | 120 | 4 |
658886 | 658886 | 2020-10-23 | Kent | Michigan | 26081 | 13396 | 182 |
658887 | 658887 | 2020-10-23 | Keweenaw | Michigan | 26083 | 18 | 0 |
658888 | 658888 | 2020-10-23 | Lake | Michigan | 26085 | 56 | 0 |
658889 | 658889 | 2020-10-23 | Lapeer | Michigan | 26087 | 1163 | 45 |
658890 | 658890 | 2020-10-23 | Leelanau | Michigan | 26089 | 140 | 2 |
658891 | 658891 | 2020-10-23 | Lenawee | Michigan | 26091 | 1806 | 23 |
658892 | 658892 | 2020-10-23 | Livingston | Michigan | 26093 | 1951 | 34 |
658893 | 658893 | 2020-10-23 | Luce | Michigan | 26095 | 295 | 0 |
658894 | 658894 | 2020-10-23 | Mackinac | Michigan | 26097 | 152 | 0 |
658895 | 658895 | 2020-10-23 | Macomb | Michigan | 26099 | 17954 | 1083 |
658896 | 658896 | 2020-10-23 | Manistee | Michigan | 26101 | 134 | 3 |
658897 | 658897 | 2020-10-23 | Marquette | Michigan | 26103 | 932 | 13 |
658898 | 658898 | 2020-10-23 | Mason | Michigan | 26105 | 211 | 1 |
658899 | 658899 | 2020-10-23 | Mecosta | Michigan | 26107 | 437 | 4 |
658900 | 658900 | 2020-10-23 | Menominee | Michigan | 26109 | 663 | 3 |
658901 | 658901 | 2020-10-23 | Midland | Michigan | 26111 | 917 | 14 |
658902 | 658902 | 2020-10-23 | Missaukee | Michigan | 26113 | 83 | 1 |
658903 | 658903 | 2020-10-23 | Monroe | Michigan | 26115 | 1928 | 32 |
658904 | 658904 | 2020-10-23 | Montcalm | Michigan | 26117 | 566 | 10 |
658905 | 658905 | 2020-10-23 | Montmorency | Michigan | 26119 | 23 | 0 |
658906 | 658906 | 2020-10-23 | Muskegon | Michigan | 26121 | 2948 | 84 |
658907 | 658907 | 2020-10-23 | Newaygo | Michigan | 26123 | 566 | 3 |
658908 | 658908 | 2020-10-23 | Oakland | Michigan | 26125 | 24025 | 1233 |
658909 | 658909 | 2020-10-23 | Oceana | Michigan | 26127 | 599 | 6 |
658910 | 658910 | 2020-10-23 | Ogemaw | Michigan | 26129 | 98 | 5 |
658911 | 658911 | 2020-10-23 | Ontonagon | Michigan | 26131 | 79 | 0 |
658912 | 658912 | 2020-10-23 | Osceola | Michigan | 26133 | 138 | 0 |
658913 | 658913 | 2020-10-23 | Oscoda | Michigan | 26135 | 54 | 1 |
658914 | 658914 | 2020-10-23 | Otsego | Michigan | 26137 | 246 | 12 |
658915 | 658915 | 2020-10-23 | Ottawa | Michigan | 26139 | 4708 | 72 |
658916 | 658916 | 2020-10-23 | Presque Isle | Michigan | 26141 | 47 | 1 |
658917 | 658917 | 2020-10-23 | Roscommon | Michigan | 26143 | 158 | 5 |
658918 | 658918 | 2020-10-23 | Saginaw | Michigan | 26145 | 3621 | 152 |
658919 | 658919 | 2020-10-23 | Sanilac | Michigan | 26151 | 178 | 7 |
658920 | 658920 | 2020-10-23 | Schoolcraft | Michigan | 26153 | 62 | 1 |
658921 | 658921 | 2020-10-23 | Shiawassee | Michigan | 26155 | 667 | 34 |
658922 | 658922 | 2020-10-23 | St. Clair | Michigan | 26147 | 1435 | 64 |
658923 | 658923 | 2020-10-23 | St. Joseph | Michigan | 26149 | 1144 | 16 |
658924 | 658924 | 2020-10-23 | Tuscola | Michigan | 26157 | 626 | 35 |
658925 | 658925 | 2020-10-23 | Unknown | Michigan | 937 | 4 | |
658926 | 658926 | 2020-10-23 | Van Buren | Michigan | 26159 | 1001 | 18 |
658927 | 658927 | 2020-10-23 | Washtenaw | Michigan | 26161 | 5634 | 127 |
658928 | 658928 | 2020-10-23 | Wayne | Michigan | 26163 | 39350 | 3042 |
658929 | 658929 | 2020-10-23 | Wexford | Michigan | 26165 | 166 | 4 |
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);