ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where "date" is on date 2020-06-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 |
---|---|---|---|---|---|---|---|
278855 | 278855 | 2020-06-27 | Alcona | Michigan | 26001 | 21 | 1 |
278856 | 278856 | 2020-06-27 | Alger | Michigan | 26003 | 3 | 0 |
278857 | 278857 | 2020-06-27 | Allegan | Michigan | 26005 | 303 | 6 |
278858 | 278858 | 2020-06-27 | Alpena | Michigan | 26007 | 117 | 12 |
278859 | 278859 | 2020-06-27 | Antrim | Michigan | 26009 | 18 | 0 |
278860 | 278860 | 2020-06-27 | Arenac | Michigan | 26011 | 38 | 2 |
278861 | 278861 | 2020-06-27 | Baraga | Michigan | 26013 | 4 | 0 |
278862 | 278862 | 2020-06-27 | Barry | Michigan | 26015 | 96 | 2 |
278863 | 278863 | 2020-06-27 | Bay | Michigan | 26017 | 386 | 30 |
278864 | 278864 | 2020-06-27 | Benzie | Michigan | 26019 | 7 | 0 |
278865 | 278865 | 2020-06-27 | Berrien | Michigan | 26021 | 928 | 60 |
278866 | 278866 | 2020-06-27 | Branch | Michigan | 26023 | 1048 | 25 |
278867 | 278867 | 2020-06-27 | Calhoun | Michigan | 26025 | 523 | 32 |
278868 | 278868 | 2020-06-27 | Cass | Michigan | 26027 | 134 | 4 |
278869 | 278869 | 2020-06-27 | Charlevoix | Michigan | 26029 | 29 | 2 |
278870 | 278870 | 2020-06-27 | Cheboygan | Michigan | 26031 | 28 | 2 |
278871 | 278871 | 2020-06-27 | Chippewa | Michigan | 26033 | 4 | 0 |
278872 | 278872 | 2020-06-27 | Clare | Michigan | 26035 | 27 | 3 |
278873 | 278873 | 2020-06-27 | Clinton | Michigan | 26037 | 215 | 12 |
278874 | 278874 | 2020-06-27 | Crawford | Michigan | 26039 | 68 | 5 |
278875 | 278875 | 2020-06-27 | Delta | Michigan | 26041 | 21 | 3 |
278876 | 278876 | 2020-06-27 | Dickinson | Michigan | 26043 | 7 | 2 |
278877 | 278877 | 2020-06-27 | Eaton | Michigan | 26045 | 311 | 7 |
278878 | 278878 | 2020-06-27 | Emmet | Michigan | 26047 | 27 | 2 |
278879 | 278879 | 2020-06-27 | Genesee | Michigan | 26049 | 2683 | 288 |
278880 | 278880 | 2020-06-27 | Gladwin | Michigan | 26051 | 26 | 1 |
278881 | 278881 | 2020-06-27 | Gogebic | Michigan | 26053 | 7 | 1 |
278882 | 278882 | 2020-06-27 | Grand Traverse | Michigan | 26055 | 46 | 5 |
278883 | 278883 | 2020-06-27 | Gratiot | Michigan | 26057 | 98 | 13 |
278884 | 278884 | 2020-06-27 | Hillsdale | Michigan | 26059 | 192 | 25 |
278885 | 278885 | 2020-06-27 | Houghton | Michigan | 26061 | 11 | 0 |
278886 | 278886 | 2020-06-27 | Huron | Michigan | 26063 | 65 | 3 |
278887 | 278887 | 2020-06-27 | Ingham | Michigan | 26065 | 980 | 29 |
278888 | 278888 | 2020-06-27 | Ionia | Michigan | 26067 | 197 | 4 |
278889 | 278889 | 2020-06-27 | Iosco | Michigan | 26069 | 112 | 10 |
278890 | 278890 | 2020-06-27 | Iron | Michigan | 26071 | 5 | 1 |
278891 | 278891 | 2020-06-27 | Isabella | Michigan | 26073 | 121 | 8 |
278892 | 278892 | 2020-06-27 | Jackson | Michigan | 26075 | 2082 | 52 |
278893 | 278893 | 2020-06-27 | Kalamazoo | Michigan | 26077 | 1055 | 67 |
278894 | 278894 | 2020-06-27 | Kalkaska | Michigan | 26079 | 32 | 2 |
278895 | 278895 | 2020-06-27 | Kent | Michigan | 26081 | 4822 | 132 |
278896 | 278896 | 2020-06-27 | Keweenaw | Michigan | 26083 | 1 | 0 |
278897 | 278897 | 2020-06-27 | Lake | Michigan | 26085 | 7 | 0 |
278898 | 278898 | 2020-06-27 | Lapeer | Michigan | 26087 | 595 | 38 |
278899 | 278899 | 2020-06-27 | Leelanau | Michigan | 26089 | 16 | 0 |
278900 | 278900 | 2020-06-27 | Lenawee | Michigan | 26091 | 938 | 10 |
278901 | 278901 | 2020-06-27 | Livingston | Michigan | 26093 | 602 | 29 |
278902 | 278902 | 2020-06-27 | Luce | Michigan | 26095 | 4 | 0 |
278903 | 278903 | 2020-06-27 | Mackinac | Michigan | 26097 | 8 | 0 |
278904 | 278904 | 2020-06-27 | Macomb | Michigan | 26099 | 7511 | 910 |
278905 | 278905 | 2020-06-27 | Manistee | Michigan | 26101 | 28 | 0 |
278906 | 278906 | 2020-06-27 | Marquette | Michigan | 26103 | 64 | 11 |
278907 | 278907 | 2020-06-27 | Mason | Michigan | 26105 | 45 | 0 |
278908 | 278908 | 2020-06-27 | Mecosta | Michigan | 26107 | 29 | 2 |
278909 | 278909 | 2020-06-27 | Menominee | Michigan | 26109 | 15 | 0 |
278910 | 278910 | 2020-06-27 | Midland | Michigan | 26111 | 160 | 9 |
278911 | 278911 | 2020-06-27 | Missaukee | Michigan | 26113 | 28 | 1 |
278912 | 278912 | 2020-06-27 | Monroe | Michigan | 26115 | 602 | 21 |
278913 | 278913 | 2020-06-27 | Montcalm | Michigan | 26117 | 88 | 1 |
278914 | 278914 | 2020-06-27 | Montmorency | Michigan | 26119 | 5 | 0 |
278915 | 278915 | 2020-06-27 | Muskegon | Michigan | 26121 | 806 | 50 |
278916 | 278916 | 2020-06-27 | Newaygo | Michigan | 26123 | 163 | 0 |
278917 | 278917 | 2020-06-27 | Oakland | Michigan | 26125 | 11886 | 1085 |
278918 | 278918 | 2020-06-27 | Oceana | Michigan | 26127 | 249 | 3 |
278919 | 278919 | 2020-06-27 | Ogemaw | Michigan | 26129 | 32 | 2 |
278920 | 278920 | 2020-06-27 | Osceola | Michigan | 26133 | 26 | 0 |
278921 | 278921 | 2020-06-27 | Oscoda | Michigan | 26135 | 14 | 1 |
278922 | 278922 | 2020-06-27 | Otsego | Michigan | 26137 | 133 | 10 |
278923 | 278923 | 2020-06-27 | Ottawa | Michigan | 26139 | 1020 | 51 |
278924 | 278924 | 2020-06-27 | Presque Isle | Michigan | 26141 | 12 | 0 |
278925 | 278925 | 2020-06-27 | Roscommon | Michigan | 26143 | 26 | 0 |
278926 | 278926 | 2020-06-27 | Saginaw | Michigan | 26145 | 1261 | 123 |
278927 | 278927 | 2020-06-27 | Sanilac | Michigan | 26151 | 44 | 6 |
278928 | 278928 | 2020-06-27 | Schoolcraft | Michigan | 26153 | 4 | 0 |
278929 | 278929 | 2020-06-27 | Shiawassee | Michigan | 26155 | 269 | 27 |
278930 | 278930 | 2020-06-27 | St. Clair | Michigan | 26147 | 547 | 49 |
278931 | 278931 | 2020-06-27 | St. Joseph | Michigan | 26149 | 276 | 3 |
278932 | 278932 | 2020-06-27 | Tuscola | Michigan | 26157 | 233 | 26 |
278933 | 278933 | 2020-06-27 | Unknown | Michigan | 156 | 2 | |
278934 | 278934 | 2020-06-27 | Van Buren | Michigan | 26159 | 224 | 7 |
278935 | 278935 | 2020-06-27 | Washtenaw | Michigan | 26161 | 2151 | 114 |
278936 | 278936 | 2020-06-27 | Wayne | Michigan | 26163 | 22603 | 2710 |
278937 | 278937 | 2020-06-27 | Wexford | Michigan | 26165 | 24 | 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);