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 2021-11-08 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1895840 | 1895840 | 2021-11-08 | Alcona | Michigan | 26001 | 1199 | 44 |
1895841 | 1895841 | 2021-11-08 | Alger | Michigan | 26003 | 1031 | 9 |
1895842 | 1895842 | 2021-11-08 | Allegan | Michigan | 26005 | 15630 | 201 |
1895843 | 1895843 | 2021-11-08 | Alpena | Michigan | 26007 | 3441 | 73 |
1895844 | 1895844 | 2021-11-08 | Antrim | Michigan | 26009 | 2529 | 38 |
1895845 | 1895845 | 2021-11-08 | Arenac | Michigan | 26011 | 1903 | 37 |
1895846 | 1895846 | 2021-11-08 | Baraga | Michigan | 26013 | 1422 | 47 |
1895847 | 1895847 | 2021-11-08 | Barry | Michigan | 26015 | 8325 | 92 |
1895848 | 1895848 | 2021-11-08 | Bay | Michigan | 26017 | 15601 | 399 |
1895849 | 1895849 | 2021-11-08 | Benzie | Michigan | 26019 | 1768 | 40 |
1895850 | 1895850 | 2021-11-08 | Berrien | Michigan | 26021 | 19904 | 333 |
1895851 | 1895851 | 2021-11-08 | Branch | Michigan | 26023 | 7645 | 137 |
1895852 | 1895852 | 2021-11-08 | Calhoun | Michigan | 26025 | 19554 | 360 |
1895853 | 1895853 | 2021-11-08 | Cass | Michigan | 26027 | 7361 | 93 |
1895854 | 1895854 | 2021-11-08 | Charlevoix | Michigan | 26029 | 2691 | 38 |
1895855 | 1895855 | 2021-11-08 | Cheboygan | Michigan | 26031 | 3012 | 68 |
1895856 | 1895856 | 2021-11-08 | Chippewa | Michigan | 26033 | 7109 | 68 |
1895857 | 1895857 | 2021-11-08 | Clare | Michigan | 26035 | 4073 | 107 |
1895858 | 1895858 | 2021-11-08 | Clinton | Michigan | 26037 | 10751 | 118 |
1895859 | 1895859 | 2021-11-08 | Crawford | Michigan | 26039 | 1468 | 17 |
1895860 | 1895860 | 2021-11-08 | Delta | Michigan | 26041 | 6042 | 111 |
1895861 | 1895861 | 2021-11-08 | Dickinson | Michigan | 26043 | 4144 | 84 |
1895862 | 1895862 | 2021-11-08 | Eaton | Michigan | 26045 | 13967 | 249 |
1895863 | 1895863 | 2021-11-08 | Emmet | Michigan | 26047 | 3590 | 51 |
1895864 | 1895864 | 2021-11-08 | Genesee | Michigan | 26049 | 54552 | 1107 |
1895865 | 1895865 | 2021-11-08 | Gladwin | Michigan | 26051 | 3462 | 77 |
1895866 | 1895866 | 2021-11-08 | Gogebic | Michigan | 26053 | 1874 | 54 |
1895867 | 1895867 | 2021-11-08 | Grand Traverse | Michigan | 26055 | 9463 | 121 |
1895868 | 1895868 | 2021-11-08 | Gratiot | Michigan | 26057 | 9146 | 134 |
1895869 | 1895869 | 2021-11-08 | Hillsdale | Michigan | 26059 | 6481 | 130 |
1895870 | 1895870 | 2021-11-08 | Houghton | Michigan | 26061 | 4459 | 56 |
1895871 | 1895871 | 2021-11-08 | Huron | Michigan | 26063 | 5100 | 96 |
1895872 | 1895872 | 2021-11-08 | Ingham | Michigan | 26065 | 32467 | 461 |
1895873 | 1895873 | 2021-11-08 | Ionia | Michigan | 26067 | 12307 | 111 |
1895874 | 1895874 | 2021-11-08 | Iosco | Michigan | 26069 | 3208 | 98 |
1895875 | 1895875 | 2021-11-08 | Iron | Michigan | 26071 | 1509 | 59 |
1895876 | 1895876 | 2021-11-08 | Isabella | Michigan | 26073 | 9506 | 135 |
1895877 | 1895877 | 2021-11-08 | Jackson | Michigan | 26075 | 27376 | 376 |
1895878 | 1895878 | 2021-11-08 | Kalamazoo | Michigan | 26077 | 31026 | 467 |
1895879 | 1895879 | 2021-11-08 | Kalkaska | Michigan | 26079 | 1879 | 40 |
1895880 | 1895880 | 2021-11-08 | Kent | Michigan | 26081 | 97462 | 1015 |
1895881 | 1895881 | 2021-11-08 | Keweenaw | Michigan | 26083 | 289 | 5 |
1895882 | 1895882 | 2021-11-08 | Lake | Michigan | 26085 | 1020 | 22 |
1895883 | 1895883 | 2021-11-08 | Lapeer | Michigan | 26087 | 12559 | 261 |
1895884 | 1895884 | 2021-11-08 | Leelanau | Michigan | 26089 | 1755 | 25 |
1895885 | 1895885 | 2021-11-08 | Lenawee | Michigan | 26091 | 15441 | 210 |
1895886 | 1895886 | 2021-11-08 | Livingston | Michigan | 26093 | 24591 | 249 |
1895887 | 1895887 | 2021-11-08 | Luce | Michigan | 26095 | 1625 | 6 |
1895888 | 1895888 | 2021-11-08 | Mackinac | Michigan | 26097 | 1349 | 12 |
1895889 | 1895889 | 2021-11-08 | Macomb | Michigan | 26099 | 126411 | 2741 |
1895890 | 1895890 | 2021-11-08 | Manistee | Michigan | 26101 | 2621 | 40 |
1895891 | 1895891 | 2021-11-08 | Marquette | Michigan | 26103 | 8393 | 82 |
1895892 | 1895892 | 2021-11-08 | Mason | Michigan | 26105 | 3396 | 48 |
1895893 | 1895893 | 2021-11-08 | Mecosta | Michigan | 26107 | 4982 | 53 |
1895894 | 1895894 | 2021-11-08 | Menominee | Michigan | 26109 | 3512 | 52 |
1895895 | 1895895 | 2021-11-08 | Midland | Michigan | 26111 | 10896 | 145 |
1895896 | 1895896 | 2021-11-08 | Missaukee | Michigan | 26113 | 1916 | 40 |
1895897 | 1895897 | 2021-11-08 | Monroe | Michigan | 26115 | 21490 | 310 |
1895898 | 1895898 | 2021-11-08 | Montcalm | Michigan | 26117 | 11294 | 138 |
1895899 | 1895899 | 2021-11-08 | Montmorency | Michigan | 26119 | 1059 | 29 |
1895900 | 1895900 | 2021-11-08 | Muskegon | Michigan | 26121 | 24657 | 432 |
1895901 | 1895901 | 2021-11-08 | Newaygo | Michigan | 26123 | 6927 | 85 |
1895902 | 1895902 | 2021-11-08 | Oakland | Michigan | 26125 | 151251 | 2711 |
1895903 | 1895903 | 2021-11-08 | Oceana | Michigan | 26127 | 3893 | 71 |
1895904 | 1895904 | 2021-11-08 | Ogemaw | Michigan | 26129 | 2826 | 62 |
1895905 | 1895905 | 2021-11-08 | Ontonagon | Michigan | 26131 | 651 | 22 |
1895906 | 1895906 | 2021-11-08 | Osceola | Michigan | 26133 | 3221 | 43 |
1895907 | 1895907 | 2021-11-08 | Oscoda | Michigan | 26135 | 1016 | 39 |
1895908 | 1895908 | 2021-11-08 | Otsego | Michigan | 26137 | 3490 | 61 |
1895909 | 1895909 | 2021-11-08 | Ottawa | Michigan | 26139 | 43452 | 514 |
1895910 | 1895910 | 2021-11-08 | Presque Isle | Michigan | 26141 | 1450 | 39 |
1895911 | 1895911 | 2021-11-08 | Roscommon | Michigan | 26143 | 2765 | 67 |
1895912 | 1895912 | 2021-11-08 | Saginaw | Michigan | 26145 | 29739 | 690 |
1895913 | 1895913 | 2021-11-08 | Sanilac | Michigan | 26151 | 5225 | 139 |
1895914 | 1895914 | 2021-11-08 | Schoolcraft | Michigan | 26153 | 882 | 5 |
1895915 | 1895915 | 2021-11-08 | Shiawassee | Michigan | 26155 | 9256 | 133 |
1895916 | 1895916 | 2021-11-08 | St. Clair | Michigan | 26147 | 23270 | 527 |
1895917 | 1895917 | 2021-11-08 | St. Joseph | Michigan | 26149 | 8833 | 121 |
1895918 | 1895918 | 2021-11-08 | Tuscola | Michigan | 26157 | 7798 | 202 |
1895919 | 1895919 | 2021-11-08 | Unknown | Michigan | 1513 | 14 | |
1895920 | 1895920 | 2021-11-08 | Van Buren | Michigan | 26159 | 9684 | 166 |
1895921 | 1895921 | 2021-11-08 | Washtenaw | Michigan | 26161 | 35252 | 340 |
1895922 | 1895922 | 2021-11-08 | Wayne | Michigan | 26163 | 206233 | 5644 |
1895923 | 1895923 | 2021-11-08 | Wexford | Michigan | 26165 | 3932 | 57 |
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);