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-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 |
---|---|---|---|---|---|---|---|
671821 | 671821 | 2020-10-27 | Alcona | Michigan | 26001 | 54 | 2 |
671822 | 671822 | 2020-10-27 | Alger | Michigan | 26003 | 112 | 1 |
671823 | 671823 | 2020-10-27 | Allegan | Michigan | 26005 | 1289 | 7 |
671824 | 671824 | 2020-10-27 | Alpena | Michigan | 26007 | 161 | 14 |
671825 | 671825 | 2020-10-27 | Antrim | Michigan | 26009 | 133 | 0 |
671826 | 671826 | 2020-10-27 | Arenac | Michigan | 26011 | 98 | 3 |
671827 | 671827 | 2020-10-27 | Baraga | Michigan | 26013 | 89 | 4 |
671828 | 671828 | 2020-10-27 | Barry | Michigan | 26015 | 688 | 6 |
671829 | 671829 | 2020-10-27 | Bay | Michigan | 26017 | 1404 | 62 |
671830 | 671830 | 2020-10-27 | Benzie | Michigan | 26019 | 124 | 2 |
671831 | 671831 | 2020-10-27 | Berrien | Michigan | 26021 | 2810 | 81 |
671832 | 671832 | 2020-10-27 | Branch | Michigan | 26023 | 1690 | 34 |
671833 | 671833 | 2020-10-27 | Calhoun | Michigan | 26025 | 2870 | 71 |
671834 | 671834 | 2020-10-27 | Cass | Michigan | 26027 | 1015 | 24 |
671835 | 671835 | 2020-10-27 | Charlevoix | Michigan | 26029 | 192 | 4 |
671836 | 671836 | 2020-10-27 | Cheboygan | Michigan | 26031 | 150 | 2 |
671837 | 671837 | 2020-10-27 | Chippewa | Michigan | 26033 | 148 | 0 |
671838 | 671838 | 2020-10-27 | Clare | Michigan | 26035 | 276 | 11 |
671839 | 671839 | 2020-10-27 | Clinton | Michigan | 26037 | 1125 | 16 |
671840 | 671840 | 2020-10-27 | Crawford | Michigan | 26039 | 152 | 5 |
671841 | 671841 | 2020-10-27 | Delta | Michigan | 26041 | 1201 | 26 |
671842 | 671842 | 2020-10-27 | Dickinson | Michigan | 26043 | 636 | 20 |
671843 | 671843 | 2020-10-27 | Eaton | Michigan | 26045 | 1156 | 11 |
671844 | 671844 | 2020-10-27 | Emmet | Michigan | 26047 | 255 | 4 |
671845 | 671845 | 2020-10-27 | Genesee | Michigan | 26049 | 6799 | 338 |
671846 | 671846 | 2020-10-27 | Gladwin | Michigan | 26051 | 209 | 2 |
671847 | 671847 | 2020-10-27 | Gogebic | Michigan | 26053 | 404 | 7 |
671848 | 671848 | 2020-10-27 | Grand Traverse | Michigan | 26055 | 795 | 13 |
671849 | 671849 | 2020-10-27 | Gratiot | Michigan | 26057 | 520 | 16 |
671850 | 671850 | 2020-10-27 | Hillsdale | Michigan | 26059 | 513 | 29 |
671851 | 671851 | 2020-10-27 | Houghton | Michigan | 26061 | 929 | 9 |
671852 | 671852 | 2020-10-27 | Huron | Michigan | 26063 | 273 | 5 |
671853 | 671853 | 2020-10-27 | Ingham | Michigan | 26065 | 4630 | 65 |
671854 | 671854 | 2020-10-27 | Ionia | Michigan | 26067 | 896 | 9 |
671855 | 671855 | 2020-10-27 | Iosco | Michigan | 26069 | 289 | 16 |
671856 | 671856 | 2020-10-27 | Iron | Michigan | 26071 | 441 | 25 |
671857 | 671857 | 2020-10-27 | Isabella | Michigan | 26073 | 1039 | 15 |
671858 | 671858 | 2020-10-27 | Jackson | Michigan | 26075 | 3498 | 88 |
671859 | 671859 | 2020-10-27 | Kalamazoo | Michigan | 26077 | 4817 | 106 |
671860 | 671860 | 2020-10-27 | Kalkaska | Michigan | 26079 | 131 | 4 |
671861 | 671861 | 2020-10-27 | Kent | Michigan | 26081 | 14419 | 184 |
671862 | 671862 | 2020-10-27 | Keweenaw | Michigan | 26083 | 20 | 0 |
671863 | 671863 | 2020-10-27 | Lake | Michigan | 26085 | 64 | 1 |
671864 | 671864 | 2020-10-27 | Lapeer | Michigan | 26087 | 1222 | 45 |
671865 | 671865 | 2020-10-27 | Leelanau | Michigan | 26089 | 152 | 2 |
671866 | 671866 | 2020-10-27 | Lenawee | Michigan | 26091 | 1869 | 23 |
671867 | 671867 | 2020-10-27 | Livingston | Michigan | 26093 | 2132 | 34 |
671868 | 671868 | 2020-10-27 | Luce | Michigan | 26095 | 302 | 0 |
671869 | 671869 | 2020-10-27 | Mackinac | Michigan | 26097 | 158 | 0 |
671870 | 671870 | 2020-10-27 | Macomb | Michigan | 26099 | 18793 | 1092 |
671871 | 671871 | 2020-10-27 | Manistee | Michigan | 26101 | 149 | 3 |
671872 | 671872 | 2020-10-27 | Marquette | Michigan | 26103 | 1045 | 15 |
671873 | 671873 | 2020-10-27 | Mason | Michigan | 26105 | 246 | 1 |
671874 | 671874 | 2020-10-27 | Mecosta | Michigan | 26107 | 528 | 4 |
671875 | 671875 | 2020-10-27 | Menominee | Michigan | 26109 | 715 | 5 |
671876 | 671876 | 2020-10-27 | Midland | Michigan | 26111 | 1037 | 14 |
671877 | 671877 | 2020-10-27 | Missaukee | Michigan | 26113 | 91 | 1 |
671878 | 671878 | 2020-10-27 | Monroe | Michigan | 26115 | 2046 | 36 |
671879 | 671879 | 2020-10-27 | Montcalm | Michigan | 26117 | 647 | 13 |
671880 | 671880 | 2020-10-27 | Montmorency | Michigan | 26119 | 27 | 0 |
671881 | 671881 | 2020-10-27 | Muskegon | Michigan | 26121 | 3161 | 86 |
671882 | 671882 | 2020-10-27 | Newaygo | Michigan | 26123 | 633 | 3 |
671883 | 671883 | 2020-10-27 | Oakland | Michigan | 26125 | 25069 | 1237 |
671884 | 671884 | 2020-10-27 | Oceana | Michigan | 26127 | 624 | 6 |
671885 | 671885 | 2020-10-27 | Ogemaw | Michigan | 26129 | 114 | 5 |
671886 | 671886 | 2020-10-27 | Ontonagon | Michigan | 26131 | 103 | 0 |
671887 | 671887 | 2020-10-27 | Osceola | Michigan | 26133 | 177 | 1 |
671888 | 671888 | 2020-10-27 | Oscoda | Michigan | 26135 | 56 | 2 |
671889 | 671889 | 2020-10-27 | Otsego | Michigan | 26137 | 265 | 12 |
671890 | 671890 | 2020-10-27 | Ottawa | Michigan | 26139 | 5156 | 73 |
671891 | 671891 | 2020-10-27 | Presque Isle | Michigan | 26141 | 66 | 1 |
671892 | 671892 | 2020-10-27 | Roscommon | Michigan | 26143 | 185 | 6 |
671893 | 671893 | 2020-10-27 | Saginaw | Michigan | 26145 | 3877 | 154 |
671894 | 671894 | 2020-10-27 | Sanilac | Michigan | 26151 | 200 | 7 |
671895 | 671895 | 2020-10-27 | Schoolcraft | Michigan | 26153 | 74 | 1 |
671896 | 671896 | 2020-10-27 | Shiawassee | Michigan | 26155 | 719 | 34 |
671897 | 671897 | 2020-10-27 | St. Clair | Michigan | 26147 | 1545 | 64 |
671898 | 671898 | 2020-10-27 | St. Joseph | Michigan | 26149 | 1210 | 21 |
671899 | 671899 | 2020-10-27 | Tuscola | Michigan | 26157 | 671 | 35 |
671900 | 671900 | 2020-10-27 | Unknown | Michigan | 1046 | 4 | |
671901 | 671901 | 2020-10-27 | Van Buren | Michigan | 26159 | 1092 | 19 |
671902 | 671902 | 2020-10-27 | Washtenaw | Michigan | 26161 | 5964 | 128 |
671903 | 671903 | 2020-10-27 | Wayne | Michigan | 26163 | 40422 | 3052 |
671904 | 671904 | 2020-10-27 | Wexford | Michigan | 26165 | 182 | 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);