ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where date = "2020-06-10" 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 |
---|---|---|---|---|---|---|---|
225815 | 225815 | 2020-06-10 | Alcona | Michigan | 26001 | 21 | 1 |
225816 | 225816 | 2020-06-10 | Alger | Michigan | 26003 | 1 | 0 |
225817 | 225817 | 2020-06-10 | Allegan | Michigan | 26005 | 274 | 6 |
225818 | 225818 | 2020-06-10 | Alpena | Michigan | 26007 | 113 | 9 |
225819 | 225819 | 2020-06-10 | Antrim | Michigan | 26009 | 14 | 0 |
225820 | 225820 | 2020-06-10 | Arenac | Michigan | 26011 | 38 | 1 |
225821 | 225821 | 2020-06-10 | Baraga | Michigan | 26013 | 1 | 0 |
225822 | 225822 | 2020-06-10 | Barry | Michigan | 26015 | 89 | 2 |
225823 | 225823 | 2020-06-10 | Bay | Michigan | 26017 | 372 | 27 |
225824 | 225824 | 2020-06-10 | Benzie | Michigan | 26019 | 5 | 0 |
225825 | 225825 | 2020-06-10 | Berrien | Michigan | 26021 | 870 | 57 |
225826 | 225826 | 2020-06-10 | Branch | Michigan | 26023 | 948 | 25 |
225827 | 225827 | 2020-06-10 | Calhoun | Michigan | 26025 | 475 | 26 |
225828 | 225828 | 2020-06-10 | Cass | Michigan | 26027 | 110 | 4 |
225829 | 225829 | 2020-06-10 | Charlevoix | Michigan | 26029 | 22 | 1 |
225830 | 225830 | 2020-06-10 | Cheboygan | Michigan | 26031 | 26 | 1 |
225831 | 225831 | 2020-06-10 | Chippewa | Michigan | 26033 | 4 | 0 |
225832 | 225832 | 2020-06-10 | Clare | Michigan | 26035 | 24 | 2 |
225833 | 225833 | 2020-06-10 | Clinton | Michigan | 26037 | 187 | 11 |
225834 | 225834 | 2020-06-10 | Crawford | Michigan | 26039 | 63 | 5 |
225835 | 225835 | 2020-06-10 | Delta | Michigan | 26041 | 20 | 2 |
225836 | 225836 | 2020-06-10 | Dickinson | Michigan | 26043 | 6 | 2 |
225837 | 225837 | 2020-06-10 | Eaton | Michigan | 26045 | 255 | 7 |
225838 | 225838 | 2020-06-10 | Emmet | Michigan | 26047 | 27 | 2 |
225839 | 225839 | 2020-06-10 | Genesee | Michigan | 26049 | 2558 | 282 |
225840 | 225840 | 2020-06-10 | Gladwin | Michigan | 26051 | 20 | 1 |
225841 | 225841 | 2020-06-10 | Gogebic | Michigan | 26053 | 5 | 1 |
225842 | 225842 | 2020-06-10 | Grand Traverse | Michigan | 26055 | 40 | 5 |
225843 | 225843 | 2020-06-10 | Gratiot | Michigan | 26057 | 94 | 11 |
225844 | 225844 | 2020-06-10 | Hillsdale | Michigan | 26059 | 179 | 25 |
225845 | 225845 | 2020-06-10 | Houghton | Michigan | 26061 | 8 | 0 |
225846 | 225846 | 2020-06-10 | Huron | Michigan | 26063 | 60 | 1 |
225847 | 225847 | 2020-06-10 | Ingham | Michigan | 26065 | 810 | 28 |
225848 | 225848 | 2020-06-10 | Ionia | Michigan | 26067 | 180 | 4 |
225849 | 225849 | 2020-06-10 | Iosco | Michigan | 26069 | 111 | 10 |
225850 | 225850 | 2020-06-10 | Iron | Michigan | 26071 | 2 | 0 |
225851 | 225851 | 2020-06-10 | Isabella | Michigan | 26073 | 95 | 7 |
225852 | 225852 | 2020-06-10 | Jackson | Michigan | 26075 | 2051 | 52 |
225853 | 225853 | 2020-06-10 | Kalamazoo | Michigan | 26077 | 940 | 63 |
225854 | 225854 | 2020-06-10 | Kalkaska | Michigan | 26079 | 31 | 2 |
225855 | 225855 | 2020-06-10 | Kent | Michigan | 26081 | 4267 | 108 |
225856 | 225856 | 2020-06-10 | Keweenaw | Michigan | 26083 | 1 | 0 |
225857 | 225857 | 2020-06-10 | Lake | Michigan | 26085 | 7 | 0 |
225858 | 225858 | 2020-06-10 | Lapeer | Michigan | 26087 | 516 | 39 |
225859 | 225859 | 2020-06-10 | Leelanau | Michigan | 26089 | 12 | 0 |
225860 | 225860 | 2020-06-10 | Lenawee | Michigan | 26091 | 919 | 10 |
225861 | 225861 | 2020-06-10 | Livingston | Michigan | 26093 | 567 | 29 |
225862 | 225862 | 2020-06-10 | Luce | Michigan | 26095 | 4 | 0 |
225863 | 225863 | 2020-06-10 | Mackinac | Michigan | 26097 | 8 | 0 |
225864 | 225864 | 2020-06-10 | Macomb | Michigan | 26099 | 7239 | 881 |
225865 | 225865 | 2020-06-10 | Manistee | Michigan | 26101 | 24 | 1 |
225866 | 225866 | 2020-06-10 | Marquette | Michigan | 26103 | 59 | 11 |
225867 | 225867 | 2020-06-10 | Mason | Michigan | 26105 | 38 | 0 |
225868 | 225868 | 2020-06-10 | Mecosta | Michigan | 26107 | 24 | 2 |
225869 | 225869 | 2020-06-10 | Menominee | Michigan | 26109 | 9 | 0 |
225870 | 225870 | 2020-06-10 | Midland | Michigan | 26111 | 138 | 9 |
225871 | 225871 | 2020-06-10 | Missaukee | Michigan | 26113 | 23 | 1 |
225872 | 225872 | 2020-06-10 | Monroe | Michigan | 26115 | 560 | 21 |
225873 | 225873 | 2020-06-10 | Montcalm | Michigan | 26117 | 83 | 1 |
225874 | 225874 | 2020-06-10 | Montmorency | Michigan | 26119 | 5 | 0 |
225875 | 225875 | 2020-06-10 | Muskegon | Michigan | 26121 | 726 | 40 |
225876 | 225876 | 2020-06-10 | Newaygo | Michigan | 26123 | 125 | 0 |
225877 | 225877 | 2020-06-10 | Oakland | Michigan | 26125 | 11262 | 1058 |
225878 | 225878 | 2020-06-10 | Oceana | Michigan | 26127 | 103 | 3 |
225879 | 225879 | 2020-06-10 | Ogemaw | Michigan | 26129 | 31 | 2 |
225880 | 225880 | 2020-06-10 | Osceola | Michigan | 26133 | 18 | 0 |
225881 | 225881 | 2020-06-10 | Oscoda | Michigan | 26135 | 8 | 1 |
225882 | 225882 | 2020-06-10 | Otsego | Michigan | 26137 | 131 | 10 |
225883 | 225883 | 2020-06-10 | Ottawa | Michigan | 26139 | 909 | 48 |
225884 | 225884 | 2020-06-10 | Presque Isle | Michigan | 26141 | 11 | 0 |
225885 | 225885 | 2020-06-10 | Roscommon | Michigan | 26143 | 24 | 0 |
225886 | 225886 | 2020-06-10 | Saginaw | Michigan | 26145 | 1139 | 115 |
225887 | 225887 | 2020-06-10 | Sanilac | Michigan | 26151 | 43 | 6 |
225888 | 225888 | 2020-06-10 | Schoolcraft | Michigan | 26153 | 4 | 0 |
225889 | 225889 | 2020-06-10 | Shiawassee | Michigan | 26155 | 262 | 27 |
225890 | 225890 | 2020-06-10 | St. Clair | Michigan | 26147 | 517 | 45 |
225891 | 225891 | 2020-06-10 | St. Joseph | Michigan | 26149 | 160 | 3 |
225892 | 225892 | 2020-06-10 | Tuscola | Michigan | 26157 | 206 | 25 |
225893 | 225893 | 2020-06-10 | Unknown | Michigan | 203 | 3 | |
225894 | 225894 | 2020-06-10 | Van Buren | Michigan | 26159 | 195 | 7 |
225895 | 225895 | 2020-06-10 | Washtenaw | Michigan | 26161 | 2037 | 111 |
225896 | 225896 | 2020-06-10 | Wayne | Michigan | 26163 | 21593 | 2655 |
225897 | 225897 | 2020-06-10 | Wexford | Michigan | 26165 | 18 | 3 |
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);