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-19 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
253793 | 253793 | 2020-06-19 | Alcona | Michigan | 26001 | 21 | 1 |
253794 | 253794 | 2020-06-19 | Alger | Michigan | 26003 | 2 | 0 |
253795 | 253795 | 2020-06-19 | Allegan | Michigan | 26005 | 292 | 6 |
253796 | 253796 | 2020-06-19 | Alpena | Michigan | 26007 | 115 | 12 |
253797 | 253797 | 2020-06-19 | Antrim | Michigan | 26009 | 14 | 0 |
253798 | 253798 | 2020-06-19 | Arenac | Michigan | 26011 | 38 | 1 |
253799 | 253799 | 2020-06-19 | Baraga | Michigan | 26013 | 1 | 0 |
253800 | 253800 | 2020-06-19 | Barry | Michigan | 26015 | 94 | 2 |
253801 | 253801 | 2020-06-19 | Bay | Michigan | 26017 | 379 | 29 |
253802 | 253802 | 2020-06-19 | Benzie | Michigan | 26019 | 5 | 0 |
253803 | 253803 | 2020-06-19 | Berrien | Michigan | 26021 | 911 | 60 |
253804 | 253804 | 2020-06-19 | Branch | Michigan | 26023 | 1040 | 25 |
253805 | 253805 | 2020-06-19 | Calhoun | Michigan | 26025 | 503 | 30 |
253806 | 253806 | 2020-06-19 | Cass | Michigan | 26027 | 119 | 4 |
253807 | 253807 | 2020-06-19 | Charlevoix | Michigan | 26029 | 25 | 2 |
253808 | 253808 | 2020-06-19 | Cheboygan | Michigan | 26031 | 26 | 2 |
253809 | 253809 | 2020-06-19 | Chippewa | Michigan | 26033 | 4 | 0 |
253810 | 253810 | 2020-06-19 | Clare | Michigan | 26035 | 26 | 2 |
253811 | 253811 | 2020-06-19 | Clinton | Michigan | 26037 | 195 | 11 |
253812 | 253812 | 2020-06-19 | Crawford | Michigan | 26039 | 66 | 5 |
253813 | 253813 | 2020-06-19 | Delta | Michigan | 26041 | 21 | 2 |
253814 | 253814 | 2020-06-19 | Dickinson | Michigan | 26043 | 7 | 2 |
253815 | 253815 | 2020-06-19 | Eaton | Michigan | 26045 | 265 | 7 |
253816 | 253816 | 2020-06-19 | Emmet | Michigan | 26047 | 27 | 2 |
253817 | 253817 | 2020-06-19 | Genesee | Michigan | 26049 | 2619 | 283 |
253818 | 253818 | 2020-06-19 | Gladwin | Michigan | 26051 | 23 | 1 |
253819 | 253819 | 2020-06-19 | Gogebic | Michigan | 26053 | 6 | 1 |
253820 | 253820 | 2020-06-19 | Grand Traverse | Michigan | 26055 | 43 | 5 |
253821 | 253821 | 2020-06-19 | Gratiot | Michigan | 26057 | 98 | 13 |
253822 | 253822 | 2020-06-19 | Hillsdale | Michigan | 26059 | 183 | 25 |
253823 | 253823 | 2020-06-19 | Houghton | Michigan | 26061 | 8 | 0 |
253824 | 253824 | 2020-06-19 | Huron | Michigan | 26063 | 60 | 1 |
253825 | 253825 | 2020-06-19 | Ingham | Michigan | 26065 | 831 | 29 |
253826 | 253826 | 2020-06-19 | Ionia | Michigan | 26067 | 192 | 4 |
253827 | 253827 | 2020-06-19 | Iosco | Michigan | 26069 | 112 | 10 |
253828 | 253828 | 2020-06-19 | Iron | Michigan | 26071 | 4 | 0 |
253829 | 253829 | 2020-06-19 | Isabella | Michigan | 26073 | 106 | 8 |
253830 | 253830 | 2020-06-19 | Jackson | Michigan | 26075 | 2055 | 52 |
253831 | 253831 | 2020-06-19 | Kalamazoo | Michigan | 26077 | 984 | 64 |
253832 | 253832 | 2020-06-19 | Kalkaska | Michigan | 26079 | 31 | 2 |
253833 | 253833 | 2020-06-19 | Kent | Michigan | 26081 | 4557 | 122 |
253834 | 253834 | 2020-06-19 | Keweenaw | Michigan | 26083 | 1 | 0 |
253835 | 253835 | 2020-06-19 | Lake | Michigan | 26085 | 7 | 0 |
253836 | 253836 | 2020-06-19 | Lapeer | Michigan | 26087 | 534 | 38 |
253837 | 253837 | 2020-06-19 | Leelanau | Michigan | 26089 | 12 | 0 |
253838 | 253838 | 2020-06-19 | Lenawee | Michigan | 26091 | 927 | 10 |
253839 | 253839 | 2020-06-19 | Livingston | Michigan | 26093 | 582 | 29 |
253840 | 253840 | 2020-06-19 | Luce | Michigan | 26095 | 4 | 0 |
253841 | 253841 | 2020-06-19 | Mackinac | Michigan | 26097 | 8 | 0 |
253842 | 253842 | 2020-06-19 | Macomb | Michigan | 26099 | 7362 | 902 |
253843 | 253843 | 2020-06-19 | Manistee | Michigan | 26101 | 26 | 0 |
253844 | 253844 | 2020-06-19 | Marquette | Michigan | 26103 | 61 | 11 |
253845 | 253845 | 2020-06-19 | Mason | Michigan | 26105 | 40 | 0 |
253846 | 253846 | 2020-06-19 | Mecosta | Michigan | 26107 | 27 | 2 |
253847 | 253847 | 2020-06-19 | Menominee | Michigan | 26109 | 9 | 0 |
253848 | 253848 | 2020-06-19 | Midland | Michigan | 26111 | 156 | 9 |
253849 | 253849 | 2020-06-19 | Missaukee | Michigan | 26113 | 24 | 1 |
253850 | 253850 | 2020-06-19 | Monroe | Michigan | 26115 | 575 | 21 |
253851 | 253851 | 2020-06-19 | Montcalm | Michigan | 26117 | 83 | 1 |
253852 | 253852 | 2020-06-19 | Montmorency | Michigan | 26119 | 5 | 0 |
253853 | 253853 | 2020-06-19 | Muskegon | Michigan | 26121 | 768 | 46 |
253854 | 253854 | 2020-06-19 | Newaygo | Michigan | 26123 | 131 | 0 |
253855 | 253855 | 2020-06-19 | Oakland | Michigan | 26125 | 11485 | 1071 |
253856 | 253856 | 2020-06-19 | Oceana | Michigan | 26127 | 163 | 3 |
253857 | 253857 | 2020-06-19 | Ogemaw | Michigan | 26129 | 32 | 2 |
253858 | 253858 | 2020-06-19 | Osceola | Michigan | 26133 | 25 | 0 |
253859 | 253859 | 2020-06-19 | Oscoda | Michigan | 26135 | 9 | 1 |
253860 | 253860 | 2020-06-19 | Otsego | Michigan | 26137 | 131 | 10 |
253861 | 253861 | 2020-06-19 | Ottawa | Michigan | 26139 | 966 | 51 |
253862 | 253862 | 2020-06-19 | Presque Isle | Michigan | 26141 | 12 | 0 |
253863 | 253863 | 2020-06-19 | Roscommon | Michigan | 26143 | 26 | 0 |
253864 | 253864 | 2020-06-19 | Saginaw | Michigan | 26145 | 1183 | 120 |
253865 | 253865 | 2020-06-19 | Sanilac | Michigan | 26151 | 44 | 6 |
253866 | 253866 | 2020-06-19 | Schoolcraft | Michigan | 26153 | 4 | 0 |
253867 | 253867 | 2020-06-19 | Shiawassee | Michigan | 26155 | 265 | 27 |
253868 | 253868 | 2020-06-19 | St. Clair | Michigan | 26147 | 525 | 48 |
253869 | 253869 | 2020-06-19 | St. Joseph | Michigan | 26149 | 210 | 3 |
253870 | 253870 | 2020-06-19 | Tuscola | Michigan | 26157 | 246 | 26 |
253871 | 253871 | 2020-06-19 | Unknown | Michigan | 161 | 2 | |
253872 | 253872 | 2020-06-19 | Van Buren | Michigan | 26159 | 213 | 7 |
253873 | 253873 | 2020-06-19 | Washtenaw | Michigan | 26161 | 2110 | 113 |
253874 | 253874 | 2020-06-19 | Wayne | Michigan | 26163 | 22018 | 2683 |
253875 | 253875 | 2020-06-19 | Wexford | Michigan | 26165 | 22 | 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);