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 2022-04-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 |
---|---|---|---|---|---|---|---|
2386849 | 2386849 | 2022-04-08 | Alcona | Michigan | 26001 | 1724 | 71 |
2386850 | 2386850 | 2022-04-08 | Alger | Michigan | 26003 | 1865 | 13 |
2386851 | 2386851 | 2022-04-08 | Allegan | Michigan | 26005 | 27041 | 344 |
2386852 | 2386852 | 2022-04-08 | Alpena | Michigan | 26007 | 5596 | 136 |
2386853 | 2386853 | 2022-04-08 | Antrim | Michigan | 26009 | 4316 | 64 |
2386854 | 2386854 | 2022-04-08 | Arenac | Michigan | 26011 | 3195 | 67 |
2386855 | 2386855 | 2022-04-08 | Baraga | Michigan | 26013 | 2210 | 54 |
2386856 | 2386856 | 2022-04-08 | Barry | Michigan | 26015 | 14312 | 166 |
2386857 | 2386857 | 2022-04-08 | Bay | Michigan | 26017 | 26993 | 577 |
2386858 | 2386858 | 2022-04-08 | Benzie | Michigan | 26019 | 3424 | 65 |
2386859 | 2386859 | 2022-04-08 | Berrien | Michigan | 26021 | 34682 | 549 |
2386860 | 2386860 | 2022-04-08 | Branch | Michigan | 26023 | 12157 | 205 |
2386861 | 2386861 | 2022-04-08 | Calhoun | Michigan | 26025 | 34155 | 575 |
2386862 | 2386862 | 2022-04-08 | Cass | Michigan | 26027 | 11092 | 144 |
2386863 | 2386863 | 2022-04-08 | Charlevoix | Michigan | 26029 | 4908 | 60 |
2386864 | 2386864 | 2022-04-08 | Cheboygan | Michigan | 26031 | 4589 | 102 |
2386865 | 2386865 | 2022-04-08 | Chippewa | Michigan | 26033 | 11610 | 120 |
2386866 | 2386866 | 2022-04-08 | Clare | Michigan | 26035 | 6738 | 156 |
2386867 | 2386867 | 2022-04-08 | Clinton | Michigan | 26037 | 21228 | 209 |
2386868 | 2386868 | 2022-04-08 | Crawford | Michigan | 26039 | 2557 | 30 |
2386869 | 2386869 | 2022-04-08 | Delta | Michigan | 26041 | 9921 | 157 |
2386870 | 2386870 | 2022-04-08 | Dickinson | Michigan | 26043 | 7362 | 108 |
2386871 | 2386871 | 2022-04-08 | Eaton | Michigan | 26045 | 26768 | 397 |
2386872 | 2386872 | 2022-04-08 | Emmet | Michigan | 26047 | 6376 | 86 |
2386873 | 2386873 | 2022-04-08 | Genesee | Michigan | 26049 | 101180 | 1705 |
2386874 | 2386874 | 2022-04-08 | Gladwin | Michigan | 26051 | 5559 | 113 |
2386875 | 2386875 | 2022-04-08 | Gogebic | Michigan | 26053 | 3253 | 69 |
2386876 | 2386876 | 2022-04-08 | Grand Traverse | Michigan | 26055 | 17231 | 230 |
2386877 | 2386877 | 2022-04-08 | Gratiot | Michigan | 26057 | 13669 | 186 |
2386878 | 2386878 | 2022-04-08 | Hillsdale | Michigan | 26059 | 10331 | 204 |
2386879 | 2386879 | 2022-04-08 | Houghton | Michigan | 26061 | 7796 | 91 |
2386880 | 2386880 | 2022-04-08 | Huron | Michigan | 26063 | 8005 | 145 |
2386881 | 2386881 | 2022-04-08 | Ingham | Michigan | 26065 | 63972 | 760 |
2386882 | 2386882 | 2022-04-08 | Ionia | Michigan | 26067 | 19529 | 181 |
2386883 | 2386883 | 2022-04-08 | Iosco | Michigan | 26069 | 4799 | 141 |
2386884 | 2386884 | 2022-04-08 | Iron | Michigan | 26071 | 2643 | 87 |
2386885 | 2386885 | 2022-04-08 | Isabella | Michigan | 26073 | 15533 | 207 |
2386886 | 2386886 | 2022-04-08 | Jackson | Michigan | 26075 | 44550 | 582 |
2386887 | 2386887 | 2022-04-08 | Kalamazoo | Michigan | 26077 | 59098 | 670 |
2386888 | 2386888 | 2022-04-08 | Kalkaska | Michigan | 26079 | 3529 | 60 |
2386889 | 2386889 | 2022-04-08 | Kent | Michigan | 26081 | 166411 | 1517 |
2386890 | 2386890 | 2022-04-08 | Keweenaw | Michigan | 26083 | 513 | 13 |
2386891 | 2386891 | 2022-04-08 | Lake | Michigan | 26085 | 1840 | 37 |
2386892 | 2386892 | 2022-04-08 | Lapeer | Michigan | 26087 | 20784 | 427 |
2386893 | 2386893 | 2022-04-08 | Leelanau | Michigan | 26089 | 3581 | 53 |
2386894 | 2386894 | 2022-04-08 | Lenawee | Michigan | 26091 | 25928 | 328 |
2386895 | 2386895 | 2022-04-08 | Livingston | Michigan | 26093 | 46089 | 442 |
2386896 | 2386896 | 2022-04-08 | Luce | Michigan | 26095 | 2281 | 13 |
2386897 | 2386897 | 2022-04-08 | Mackinac | Michigan | 26097 | 2406 | 30 |
2386898 | 2386898 | 2022-04-08 | Macomb | Michigan | 26099 | 229921 | 3941 |
2386899 | 2386899 | 2022-04-08 | Manistee | Michigan | 26101 | 4463 | 89 |
2386900 | 2386900 | 2022-04-08 | Marquette | Michigan | 26103 | 15810 | 128 |
2386901 | 2386901 | 2022-04-08 | Mason | Michigan | 26105 | 6736 | 91 |
2386902 | 2386902 | 2022-04-08 | Mecosta | Michigan | 26107 | 8640 | 108 |
2386903 | 2386903 | 2022-04-08 | Menominee | Michigan | 26109 | 5621 | 70 |
2386904 | 2386904 | 2022-04-08 | Midland | Michigan | 26111 | 19021 | 223 |
2386905 | 2386905 | 2022-04-08 | Missaukee | Michigan | 26113 | 2904 | 60 |
2386906 | 2386906 | 2022-04-08 | Monroe | Michigan | 26115 | 37967 | 471 |
2386907 | 2386907 | 2022-04-08 | Montcalm | Michigan | 26117 | 17137 | 215 |
2386908 | 2386908 | 2022-04-08 | Montmorency | Michigan | 26119 | 1715 | 47 |
2386909 | 2386909 | 2022-04-08 | Muskegon | Michigan | 26121 | 41724 | 644 |
2386910 | 2386910 | 2022-04-08 | Newaygo | Michigan | 26123 | 11468 | 156 |
2386911 | 2386911 | 2022-04-08 | Oakland | Michigan | 26125 | 286376 | 3814 |
2386912 | 2386912 | 2022-04-08 | Oceana | Michigan | 26127 | 6331 | 89 |
2386913 | 2386913 | 2022-04-08 | Ogemaw | Michigan | 26129 | 4307 | 106 |
2386914 | 2386914 | 2022-04-08 | Ontonagon | Michigan | 26131 | 983 | 38 |
2386915 | 2386915 | 2022-04-08 | Osceola | Michigan | 26133 | 4995 | 80 |
2386916 | 2386916 | 2022-04-08 | Oscoda | Michigan | 26135 | 1434 | 55 |
2386917 | 2386917 | 2022-04-08 | Otsego | Michigan | 26137 | 5639 | 99 |
2386918 | 2386918 | 2022-04-08 | Ottawa | Michigan | 26139 | 74720 | 786 |
2386919 | 2386919 | 2022-04-08 | Presque Isle | Michigan | 26141 | 2061 | 58 |
2386920 | 2386920 | 2022-04-08 | Roscommon | Michigan | 26143 | 4613 | 113 |
2386921 | 2386921 | 2022-04-08 | Saginaw | Michigan | 26145 | 50318 | 945 |
2386922 | 2386922 | 2022-04-08 | Sanilac | Michigan | 26151 | 8670 | 190 |
2386923 | 2386923 | 2022-04-08 | Schoolcraft | Michigan | 26153 | 1750 | 16 |
2386924 | 2386924 | 2022-04-08 | Shiawassee | Michigan | 26155 | 17765 | 230 |
2386925 | 2386925 | 2022-04-08 | St. Clair | Michigan | 26147 | 40624 | 828 |
2386926 | 2386926 | 2022-04-08 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2386927 | 2386927 | 2022-04-08 | Tuscola | Michigan | 26157 | 13190 | 275 |
2386928 | 2386928 | 2022-04-08 | Unknown | Michigan | 11725 | 38 | |
2386929 | 2386929 | 2022-04-08 | Van Buren | Michigan | 26159 | 17012 | 266 |
2386930 | 2386930 | 2022-04-08 | Washtenaw | Michigan | 26161 | 76282 | 514 |
2386931 | 2386931 | 2022-04-08 | Wayne | Michigan | 26163 | 399533 | 7897 |
2386932 | 2386932 | 2022-04-08 | Wexford | Michigan | 26165 | 7066 | 106 |
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);