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-09-29 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1765871 | 1765871 | 2021-09-29 | Alcona | Michigan | 26001 | 930 | 39 |
1765872 | 1765872 | 2021-09-29 | Alger | Michigan | 26003 | 866 | 7 |
1765873 | 1765873 | 2021-09-29 | Allegan | Michigan | 26005 | 13245 | 176 |
1765874 | 1765874 | 2021-09-29 | Alpena | Michigan | 26007 | 2769 | 69 |
1765875 | 1765875 | 2021-09-29 | Antrim | Michigan | 26009 | 1983 | 34 |
1765876 | 1765876 | 2021-09-29 | Arenac | Michigan | 26011 | 1469 | 31 |
1765877 | 1765877 | 2021-09-29 | Baraga | Michigan | 26013 | 1169 | 45 |
1765878 | 1765878 | 2021-09-29 | Barry | Michigan | 26015 | 7027 | 76 |
1765879 | 1765879 | 2021-09-29 | Bay | Michigan | 26017 | 12976 | 370 |
1765880 | 1765880 | 2021-09-29 | Benzie | Michigan | 26019 | 1483 | 38 |
1765881 | 1765881 | 2021-09-29 | Berrien | Michigan | 26021 | 18096 | 312 |
1765882 | 1765882 | 2021-09-29 | Branch | Michigan | 26023 | 6860 | 133 |
1765883 | 1765883 | 2021-09-29 | Calhoun | Michigan | 26025 | 16966 | 337 |
1765884 | 1765884 | 2021-09-29 | Cass | Michigan | 26027 | 6561 | 85 |
1765885 | 1765885 | 2021-09-29 | Charlevoix | Michigan | 26029 | 2145 | 29 |
1765886 | 1765886 | 2021-09-29 | Cheboygan | Michigan | 26031 | 2417 | 57 |
1765887 | 1765887 | 2021-09-29 | Chippewa | Michigan | 26033 | 6288 | 52 |
1765888 | 1765888 | 2021-09-29 | Clare | Michigan | 26035 | 3063 | 92 |
1765889 | 1765889 | 2021-09-29 | Clinton | Michigan | 26037 | 8837 | 102 |
1765890 | 1765890 | 2021-09-29 | Crawford | Michigan | 26039 | 1153 | 15 |
1765891 | 1765891 | 2021-09-29 | Delta | Michigan | 26041 | 5159 | 100 |
1765892 | 1765892 | 2021-09-29 | Dickinson | Michigan | 26043 | 3528 | 75 |
1765893 | 1765893 | 2021-09-29 | Eaton | Michigan | 26045 | 11870 | 228 |
1765894 | 1765894 | 2021-09-29 | Emmet | Michigan | 26047 | 2932 | 47 |
1765895 | 1765895 | 2021-09-29 | Genesee | Michigan | 26049 | 47361 | 1033 |
1765896 | 1765896 | 2021-09-29 | Gladwin | Michigan | 26051 | 2848 | 66 |
1765897 | 1765897 | 2021-09-29 | Gogebic | Michigan | 26053 | 1626 | 52 |
1765898 | 1765898 | 2021-09-29 | Grand Traverse | Michigan | 26055 | 7927 | 107 |
1765899 | 1765899 | 2021-09-29 | Gratiot | Michigan | 26057 | 7747 | 127 |
1765900 | 1765900 | 2021-09-29 | Hillsdale | Michigan | 26059 | 5485 | 109 |
1765901 | 1765901 | 2021-09-29 | Houghton | Michigan | 26061 | 3536 | 51 |
1765902 | 1765902 | 2021-09-29 | Huron | Michigan | 26063 | 4479 | 88 |
1765903 | 1765903 | 2021-09-29 | Ingham | Michigan | 26065 | 28537 | 432 |
1765904 | 1765904 | 2021-09-29 | Ionia | Michigan | 26067 | 10622 | 91 |
1765905 | 1765905 | 2021-09-29 | Iosco | Michigan | 26069 | 2551 | 85 |
1765906 | 1765906 | 2021-09-29 | Iron | Michigan | 26071 | 1264 | 53 |
1765907 | 1765907 | 2021-09-29 | Isabella | Michigan | 26073 | 7802 | 105 |
1765908 | 1765908 | 2021-09-29 | Jackson | Michigan | 26075 | 23831 | 347 |
1765909 | 1765909 | 2021-09-29 | Kalamazoo | Michigan | 26077 | 27187 | 434 |
1765910 | 1765910 | 2021-09-29 | Kalkaska | Michigan | 26079 | 1496 | 30 |
1765911 | 1765911 | 2021-09-29 | Kent | Michigan | 26081 | 84970 | 933 |
1765912 | 1765912 | 2021-09-29 | Keweenaw | Michigan | 26083 | 214 | 4 |
1765913 | 1765913 | 2021-09-29 | Lake | Michigan | 26085 | 814 | 18 |
1765914 | 1765914 | 2021-09-29 | Lapeer | Michigan | 26087 | 11001 | 236 |
1765915 | 1765915 | 2021-09-29 | Leelanau | Michigan | 26089 | 1495 | 22 |
1765916 | 1765916 | 2021-09-29 | Lenawee | Michigan | 26091 | 12857 | 192 |
1765917 | 1765917 | 2021-09-29 | Livingston | Michigan | 26093 | 20288 | 216 |
1765918 | 1765918 | 2021-09-29 | Luce | Michigan | 26095 | 1449 | 6 |
1765919 | 1765919 | 2021-09-29 | Mackinac | Michigan | 26097 | 1025 | 6 |
1765920 | 1765920 | 2021-09-29 | Macomb | Michigan | 26099 | 112792 | 2603 |
1765921 | 1765921 | 2021-09-29 | Manistee | Michigan | 26101 | 2290 | 33 |
1765922 | 1765922 | 2021-09-29 | Marquette | Michigan | 26103 | 7030 | 71 |
1765923 | 1765923 | 2021-09-29 | Mason | Michigan | 26105 | 2708 | 43 |
1765924 | 1765924 | 2021-09-29 | Mecosta | Michigan | 26107 | 3957 | 41 |
1765925 | 1765925 | 2021-09-29 | Menominee | Michigan | 26109 | 2874 | 48 |
1765926 | 1765926 | 2021-09-29 | Midland | Michigan | 26111 | 9052 | 115 |
1765927 | 1765927 | 2021-09-29 | Missaukee | Michigan | 26113 | 1695 | 30 |
1765928 | 1765928 | 2021-09-29 | Monroe | Michigan | 26115 | 18135 | 289 |
1765929 | 1765929 | 2021-09-29 | Montcalm | Michigan | 26117 | 9373 | 128 |
1765930 | 1765930 | 2021-09-29 | Montmorency | Michigan | 26119 | 782 | 23 |
1765931 | 1765931 | 2021-09-29 | Muskegon | Michigan | 26121 | 21239 | 410 |
1765932 | 1765932 | 2021-09-29 | Newaygo | Michigan | 26123 | 5789 | 71 |
1765933 | 1765933 | 2021-09-29 | Oakland | Michigan | 26125 | 135378 | 2585 |
1765934 | 1765934 | 2021-09-29 | Oceana | Michigan | 26127 | 3265 | 65 |
1765935 | 1765935 | 2021-09-29 | Ogemaw | Michigan | 26129 | 2213 | 46 |
1765936 | 1765936 | 2021-09-29 | Ontonagon | Michigan | 26131 | 569 | 22 |
1765937 | 1765937 | 2021-09-29 | Osceola | Michigan | 26133 | 2452 | 34 |
1765938 | 1765938 | 2021-09-29 | Oscoda | Michigan | 26135 | 818 | 32 |
1765939 | 1765939 | 2021-09-29 | Otsego | Michigan | 26137 | 2810 | 47 |
1765940 | 1765940 | 2021-09-29 | Ottawa | Michigan | 26139 | 37872 | 475 |
1765941 | 1765941 | 2021-09-29 | Presque Isle | Michigan | 26141 | 1228 | 35 |
1765942 | 1765942 | 2021-09-29 | Roscommon | Michigan | 26143 | 2149 | 59 |
1765943 | 1765943 | 2021-09-29 | Saginaw | Michigan | 26145 | 25841 | 659 |
1765944 | 1765944 | 2021-09-29 | Sanilac | Michigan | 26151 | 4571 | 128 |
1765945 | 1765945 | 2021-09-29 | Schoolcraft | Michigan | 26153 | 621 | 5 |
1765946 | 1765946 | 2021-09-29 | Shiawassee | Michigan | 26155 | 7721 | 120 |
1765947 | 1765947 | 2021-09-29 | St. Clair | Michigan | 26147 | 20531 | 486 |
1765948 | 1765948 | 2021-09-29 | St. Joseph | Michigan | 26149 | 7542 | 111 |
1765949 | 1765949 | 2021-09-29 | Tuscola | Michigan | 26157 | 6585 | 183 |
1765950 | 1765950 | 2021-09-29 | Unknown | Michigan | 898 | 18 | |
1765951 | 1765951 | 2021-09-29 | Van Buren | Michigan | 26159 | 8370 | 151 |
1765952 | 1765952 | 2021-09-29 | Washtenaw | Michigan | 26161 | 31188 | 324 |
1765953 | 1765953 | 2021-09-29 | Wayne | Michigan | 26163 | 186206 | 5404 |
1765954 | 1765954 | 2021-09-29 | Wexford | Michigan | 26165 | 3232 | 50 |
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);