ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-10-31" 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 |
---|---|---|---|---|---|---|---|
1869845 | 1869845 | 2021-10-31 | Alcona | Michigan | 26001 | 1153 | 43 |
1869846 | 1869846 | 2021-10-31 | Alger | Michigan | 26003 | 1002 | 9 |
1869847 | 1869847 | 2021-10-31 | Allegan | Michigan | 26005 | 14894 | 193 |
1869848 | 1869848 | 2021-10-31 | Alpena | Michigan | 26007 | 3196 | 73 |
1869849 | 1869849 | 2021-10-31 | Antrim | Michigan | 26009 | 2411 | 38 |
1869850 | 1869850 | 2021-10-31 | Arenac | Michigan | 26011 | 1831 | 34 |
1869851 | 1869851 | 2021-10-31 | Baraga | Michigan | 26013 | 1341 | 47 |
1869852 | 1869852 | 2021-10-31 | Barry | Michigan | 26015 | 7927 | 85 |
1869853 | 1869853 | 2021-10-31 | Bay | Michigan | 26017 | 15044 | 391 |
1869854 | 1869854 | 2021-10-31 | Benzie | Michigan | 26019 | 1663 | 40 |
1869855 | 1869855 | 2021-10-31 | Berrien | Michigan | 26021 | 19396 | 331 |
1869856 | 1869856 | 2021-10-31 | Branch | Michigan | 26023 | 7374 | 137 |
1869857 | 1869857 | 2021-10-31 | Calhoun | Michigan | 26025 | 18951 | 354 |
1869858 | 1869858 | 2021-10-31 | Cass | Michigan | 26027 | 7174 | 92 |
1869859 | 1869859 | 2021-10-31 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1869860 | 1869860 | 2021-10-31 | Cheboygan | Michigan | 26031 | 2898 | 66 |
1869861 | 1869861 | 2021-10-31 | Chippewa | Michigan | 26033 | 6959 | 68 |
1869862 | 1869862 | 2021-10-31 | Clare | Michigan | 26035 | 3883 | 103 |
1869863 | 1869863 | 2021-10-31 | Clinton | Michigan | 26037 | 10230 | 112 |
1869864 | 1869864 | 2021-10-31 | Crawford | Michigan | 26039 | 1377 | 17 |
1869865 | 1869865 | 2021-10-31 | Delta | Michigan | 26041 | 5853 | 106 |
1869866 | 1869866 | 2021-10-31 | Dickinson | Michigan | 26043 | 4035 | 82 |
1869867 | 1869867 | 2021-10-31 | Eaton | Michigan | 26045 | 13325 | 247 |
1869868 | 1869868 | 2021-10-31 | Emmet | Michigan | 26047 | 3470 | 51 |
1869869 | 1869869 | 2021-10-31 | Genesee | Michigan | 26049 | 52652 | 1093 |
1869870 | 1869870 | 2021-10-31 | Gladwin | Michigan | 26051 | 3312 | 73 |
1869871 | 1869871 | 2021-10-31 | Gogebic | Michigan | 26053 | 1831 | 54 |
1869872 | 1869872 | 2021-10-31 | Grand Traverse | Michigan | 26055 | 9022 | 118 |
1869873 | 1869873 | 2021-10-31 | Gratiot | Michigan | 26057 | 8780 | 132 |
1869874 | 1869874 | 2021-10-31 | Hillsdale | Michigan | 26059 | 6260 | 124 |
1869875 | 1869875 | 2021-10-31 | Houghton | Michigan | 26061 | 4211 | 55 |
1869876 | 1869876 | 2021-10-31 | Huron | Michigan | 26063 | 4867 | 96 |
1869877 | 1869877 | 2021-10-31 | Ingham | Michigan | 26065 | 31296 | 459 |
1869878 | 1869878 | 2021-10-31 | Ionia | Michigan | 26067 | 11896 | 100 |
1869879 | 1869879 | 2021-10-31 | Iosco | Michigan | 26069 | 3057 | 96 |
1869880 | 1869880 | 2021-10-31 | Iron | Michigan | 26071 | 1439 | 57 |
1869881 | 1869881 | 2021-10-31 | Isabella | Michigan | 26073 | 9168 | 124 |
1869882 | 1869882 | 2021-10-31 | Jackson | Michigan | 26075 | 26280 | 367 |
1869883 | 1869883 | 2021-10-31 | Kalamazoo | Michigan | 26077 | 29966 | 458 |
1869884 | 1869884 | 2021-10-31 | Kalkaska | Michigan | 26079 | 1799 | 38 |
1869885 | 1869885 | 2021-10-31 | Kent | Michigan | 26081 | 94331 | 999 |
1869886 | 1869886 | 2021-10-31 | Keweenaw | Michigan | 26083 | 262 | 5 |
1869887 | 1869887 | 2021-10-31 | Lake | Michigan | 26085 | 981 | 22 |
1869888 | 1869888 | 2021-10-31 | Lapeer | Michigan | 26087 | 12189 | 255 |
1869889 | 1869889 | 2021-10-31 | Leelanau | Michigan | 26089 | 1650 | 25 |
1869890 | 1869890 | 2021-10-31 | Lenawee | Michigan | 26091 | 14830 | 206 |
1869891 | 1869891 | 2021-10-31 | Livingston | Michigan | 26093 | 23452 | 245 |
1869892 | 1869892 | 2021-10-31 | Luce | Michigan | 26095 | 1599 | 6 |
1869893 | 1869893 | 2021-10-31 | Mackinac | Michigan | 26097 | 1301 | 12 |
1869894 | 1869894 | 2021-10-31 | Macomb | Michigan | 26099 | 122692 | 2704 |
1869895 | 1869895 | 2021-10-31 | Manistee | Michigan | 26101 | 2531 | 38 |
1869896 | 1869896 | 2021-10-31 | Marquette | Michigan | 26103 | 8100 | 82 |
1869897 | 1869897 | 2021-10-31 | Mason | Michigan | 26105 | 3184 | 47 |
1869898 | 1869898 | 2021-10-31 | Mecosta | Michigan | 26107 | 4775 | 47 |
1869899 | 1869899 | 2021-10-31 | Menominee | Michigan | 26109 | 3383 | 51 |
1869900 | 1869900 | 2021-10-31 | Midland | Michigan | 26111 | 10458 | 136 |
1869901 | 1869901 | 2021-10-31 | Missaukee | Michigan | 26113 | 1864 | 38 |
1869902 | 1869902 | 2021-10-31 | Monroe | Michigan | 26115 | 20747 | 306 |
1869903 | 1869903 | 2021-10-31 | Montcalm | Michigan | 26117 | 10921 | 133 |
1869904 | 1869904 | 2021-10-31 | Montmorency | Michigan | 26119 | 971 | 26 |
1869905 | 1869905 | 2021-10-31 | Muskegon | Michigan | 26121 | 23669 | 427 |
1869906 | 1869906 | 2021-10-31 | Newaygo | Michigan | 26123 | 6677 | 84 |
1869907 | 1869907 | 2021-10-31 | Oakland | Michigan | 26125 | 146943 | 2692 |
1869908 | 1869908 | 2021-10-31 | Oceana | Michigan | 26127 | 3739 | 70 |
1869909 | 1869909 | 2021-10-31 | Ogemaw | Michigan | 26129 | 2763 | 60 |
1869910 | 1869910 | 2021-10-31 | Ontonagon | Michigan | 26131 | 618 | 22 |
1869911 | 1869911 | 2021-10-31 | Osceola | Michigan | 26133 | 3114 | 41 |
1869912 | 1869912 | 2021-10-31 | Oscoda | Michigan | 26135 | 965 | 38 |
1869913 | 1869913 | 2021-10-31 | Otsego | Michigan | 26137 | 3300 | 57 |
1869914 | 1869914 | 2021-10-31 | Ottawa | Michigan | 26139 | 41778 | 505 |
1869915 | 1869915 | 2021-10-31 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1869916 | 1869916 | 2021-10-31 | Roscommon | Michigan | 26143 | 2592 | 66 |
1869917 | 1869917 | 2021-10-31 | Saginaw | Michigan | 26145 | 28720 | 678 |
1869918 | 1869918 | 2021-10-31 | Sanilac | Michigan | 26151 | 5039 | 136 |
1869919 | 1869919 | 2021-10-31 | Schoolcraft | Michigan | 26153 | 816 | 5 |
1869920 | 1869920 | 2021-10-31 | Shiawassee | Michigan | 26155 | 8802 | 130 |
1869921 | 1869921 | 2021-10-31 | St. Clair | Michigan | 26147 | 22662 | 517 |
1869922 | 1869922 | 2021-10-31 | St. Joseph | Michigan | 26149 | 8533 | 121 |
1869923 | 1869923 | 2021-10-31 | Tuscola | Michigan | 26157 | 7507 | 197 |
1869924 | 1869924 | 2021-10-31 | Unknown | Michigan | 1258 | 15 | |
1869925 | 1869925 | 2021-10-31 | Van Buren | Michigan | 26159 | 9372 | 166 |
1869926 | 1869926 | 2021-10-31 | Washtenaw | Michigan | 26161 | 34142 | 339 |
1869927 | 1869927 | 2021-10-31 | Wayne | Michigan | 26163 | 200547 | 5600 |
1869928 | 1869928 | 2021-10-31 | Wexford | Michigan | 26165 | 3738 | 53 |
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);