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-08-12 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
425799 | 425799 | 2020-08-12 | Alcona | Michigan | 26001 | 29 | 1 |
425800 | 425800 | 2020-08-12 | Alger | Michigan | 26003 | 15 | 0 |
425801 | 425801 | 2020-08-12 | Allegan | Michigan | 26005 | 542 | 6 |
425802 | 425802 | 2020-08-12 | Alpena | Michigan | 26007 | 130 | 13 |
425803 | 425803 | 2020-08-12 | Antrim | Michigan | 26009 | 41 | 0 |
425804 | 425804 | 2020-08-12 | Arenac | Michigan | 26011 | 43 | 3 |
425805 | 425805 | 2020-08-12 | Baraga | Michigan | 26013 | 5 | 0 |
425806 | 425806 | 2020-08-12 | Barry | Michigan | 26015 | 191 | 2 |
425807 | 425807 | 2020-08-12 | Bay | Michigan | 26017 | 654 | 32 |
425808 | 425808 | 2020-08-12 | Benzie | Michigan | 26019 | 30 | 1 |
425809 | 425809 | 2020-08-12 | Berrien | Michigan | 26021 | 1454 | 67 |
425810 | 425810 | 2020-08-12 | Branch | Michigan | 26023 | 1182 | 25 |
425811 | 425811 | 2020-08-12 | Calhoun | Michigan | 26025 | 811 | 42 |
425812 | 425812 | 2020-08-12 | Cass | Michigan | 26027 | 340 | 14 |
425813 | 425813 | 2020-08-12 | Charlevoix | Michigan | 26029 | 54 | 2 |
425814 | 425814 | 2020-08-12 | Cheboygan | Michigan | 26031 | 50 | 2 |
425815 | 425815 | 2020-08-12 | Chippewa | Michigan | 26033 | 44 | 0 |
425816 | 425816 | 2020-08-12 | Clare | Michigan | 26035 | 74 | 3 |
425817 | 425817 | 2020-08-12 | Clinton | Michigan | 26037 | 426 | 13 |
425818 | 425818 | 2020-08-12 | Crawford | Michigan | 26039 | 107 | 5 |
425819 | 425819 | 2020-08-12 | Delta | Michigan | 26041 | 104 | 3 |
425820 | 425820 | 2020-08-12 | Dickinson | Michigan | 26043 | 58 | 2 |
425821 | 425821 | 2020-08-12 | Eaton | Michigan | 26045 | 461 | 8 |
425822 | 425822 | 2020-08-12 | Emmet | Michigan | 26047 | 66 | 2 |
425823 | 425823 | 2020-08-12 | Genesee | Michigan | 26049 | 3683 | 296 |
425824 | 425824 | 2020-08-12 | Gladwin | Michigan | 26051 | 59 | 2 |
425825 | 425825 | 2020-08-12 | Gogebic | Michigan | 26053 | 125 | 1 |
425826 | 425826 | 2020-08-12 | Grand Traverse | Michigan | 26055 | 226 | 5 |
425827 | 425827 | 2020-08-12 | Gratiot | Michigan | 26057 | 163 | 15 |
425828 | 425828 | 2020-08-12 | Hillsdale | Michigan | 26059 | 278 | 25 |
425829 | 425829 | 2020-08-12 | Houghton | Michigan | 26061 | 50 | 0 |
425830 | 425830 | 2020-08-12 | Huron | Michigan | 26063 | 161 | 4 |
425831 | 425831 | 2020-08-12 | Ingham | Michigan | 26065 | 1570 | 32 |
425832 | 425832 | 2020-08-12 | Ionia | Michigan | 26067 | 278 | 7 |
425833 | 425833 | 2020-08-12 | Iosco | Michigan | 26069 | 134 | 12 |
425834 | 425834 | 2020-08-12 | Iron | Michigan | 26071 | 20 | 1 |
425835 | 425835 | 2020-08-12 | Isabella | Michigan | 26073 | 210 | 9 |
425836 | 425836 | 2020-08-12 | Jackson | Michigan | 26075 | 2447 | 56 |
425837 | 425837 | 2020-08-12 | Kalamazoo | Michigan | 26077 | 1686 | 83 |
425838 | 425838 | 2020-08-12 | Kalkaska | Michigan | 26079 | 55 | 4 |
425839 | 425839 | 2020-08-12 | Kent | Michigan | 26081 | 7635 | 157 |
425840 | 425840 | 2020-08-12 | Keweenaw | Michigan | 26083 | 3 | 0 |
425841 | 425841 | 2020-08-12 | Lake | Michigan | 26085 | 27 | 0 |
425842 | 425842 | 2020-08-12 | Lapeer | Michigan | 26087 | 779 | 40 |
425843 | 425843 | 2020-08-12 | Leelanau | Michigan | 26089 | 73 | 0 |
425844 | 425844 | 2020-08-12 | Lenawee | Michigan | 26091 | 1170 | 16 |
425845 | 425845 | 2020-08-12 | Livingston | Michigan | 26093 | 905 | 29 |
425846 | 425846 | 2020-08-12 | Luce | Michigan | 26095 | 33 | 0 |
425847 | 425847 | 2020-08-12 | Mackinac | Michigan | 26097 | 26 | 0 |
425848 | 425848 | 2020-08-12 | Macomb | Michigan | 26099 | 11036 | 954 |
425849 | 425849 | 2020-08-12 | Manistee | Michigan | 26101 | 52 | 0 |
425850 | 425850 | 2020-08-12 | Marquette | Michigan | 26103 | 172 | 11 |
425851 | 425851 | 2020-08-12 | Mason | Michigan | 26105 | 104 | 0 |
425852 | 425852 | 2020-08-12 | Mecosta | Michigan | 26107 | 69 | 2 |
425853 | 425853 | 2020-08-12 | Menominee | Michigan | 26109 | 150 | 0 |
425854 | 425854 | 2020-08-12 | Midland | Michigan | 26111 | 344 | 10 |
425855 | 425855 | 2020-08-12 | Missaukee | Michigan | 26113 | 41 | 1 |
425856 | 425856 | 2020-08-12 | Monroe | Michigan | 26115 | 1016 | 25 |
425857 | 425857 | 2020-08-12 | Montcalm | Michigan | 26117 | 195 | 1 |
425858 | 425858 | 2020-08-12 | Montmorency | Michigan | 26119 | 8 | 0 |
425859 | 425859 | 2020-08-12 | Muskegon | Michigan | 26121 | 1412 | 59 |
425860 | 425860 | 2020-08-12 | Newaygo | Michigan | 26123 | 259 | 0 |
425861 | 425861 | 2020-08-12 | Oakland | Michigan | 26125 | 15876 | 1133 |
425862 | 425862 | 2020-08-12 | Oceana | Michigan | 26127 | 480 | 6 |
425863 | 425863 | 2020-08-12 | Ogemaw | Michigan | 26129 | 54 | 3 |
425864 | 425864 | 2020-08-12 | Ontonagon | Michigan | 26131 | 18 | 0 |
425865 | 425865 | 2020-08-12 | Osceola | Michigan | 26133 | 71 | 0 |
425866 | 425866 | 2020-08-12 | Oscoda | Michigan | 26135 | 24 | 1 |
425867 | 425867 | 2020-08-12 | Otsego | Michigan | 26137 | 146 | 11 |
425868 | 425868 | 2020-08-12 | Ottawa | Michigan | 26139 | 1874 | 58 |
425869 | 425869 | 2020-08-12 | Presque Isle | Michigan | 26141 | 20 | 1 |
425870 | 425870 | 2020-08-12 | Roscommon | Michigan | 26143 | 55 | 2 |
425871 | 425871 | 2020-08-12 | Saginaw | Michigan | 26145 | 2075 | 128 |
425872 | 425872 | 2020-08-12 | Sanilac | Michigan | 26151 | 109 | 6 |
425873 | 425873 | 2020-08-12 | Schoolcraft | Michigan | 26153 | 13 | 0 |
425874 | 425874 | 2020-08-12 | Shiawassee | Michigan | 26155 | 348 | 28 |
425875 | 425875 | 2020-08-12 | St. Clair | Michigan | 26147 | 829 | 53 |
425876 | 425876 | 2020-08-12 | St. Joseph | Michigan | 26149 | 603 | 9 |
425877 | 425877 | 2020-08-12 | Tuscola | Michigan | 26157 | 362 | 29 |
425878 | 425878 | 2020-08-12 | Unknown | Michigan | 241 | 4 | |
425879 | 425879 | 2020-08-12 | Van Buren | Michigan | 26159 | 461 | 10 |
425880 | 425880 | 2020-08-12 | Washtenaw | Michigan | 26161 | 3111 | 122 |
425881 | 425881 | 2020-08-12 | Wayne | Michigan | 26163 | 28416 | 2830 |
425882 | 425882 | 2020-08-12 | Wexford | Michigan | 26165 | 74 | 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);