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-01-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 |
---|---|---|---|---|---|---|---|
2129886 | 2129886 | 2022-01-19 | Alcona | Michigan | 26001 | 1547 | 60 |
2129887 | 2129887 | 2022-01-19 | Alger | Michigan | 26003 | 1620 | 11 |
2129888 | 2129888 | 2022-01-19 | Allegan | Michigan | 26005 | 23475 | 302 |
2129889 | 2129889 | 2022-01-19 | Alpena | Michigan | 26007 | 4904 | 120 |
2129890 | 2129890 | 2022-01-19 | Antrim | Michigan | 26009 | 3708 | 53 |
2129891 | 2129891 | 2022-01-19 | Arenac | Michigan | 26011 | 2735 | 58 |
2129892 | 2129892 | 2022-01-19 | Baraga | Michigan | 26013 | 1935 | 52 |
2129893 | 2129893 | 2022-01-19 | Barry | Michigan | 26015 | 12389 | 143 |
2129894 | 2129894 | 2022-01-19 | Bay | Michigan | 26017 | 23164 | 514 |
2129895 | 2129895 | 2022-01-19 | Benzie | Michigan | 26019 | 2903 | 58 |
2129896 | 2129896 | 2022-01-19 | Berrien | Michigan | 26021 | 30389 | 444 |
2129897 | 2129897 | 2022-01-19 | Branch | Michigan | 26023 | 10505 | 176 |
2129898 | 2129898 | 2022-01-19 | Calhoun | Michigan | 26025 | 29427 | 511 |
2129899 | 2129899 | 2022-01-19 | Cass | Michigan | 26027 | 10079 | 120 |
2129900 | 2129900 | 2022-01-19 | Charlevoix | Michigan | 26029 | 4328 | 54 |
2129901 | 2129901 | 2022-01-19 | Cheboygan | Michigan | 26031 | 4112 | 85 |
2129902 | 2129902 | 2022-01-19 | Chippewa | Michigan | 26033 | 9864 | 91 |
2129903 | 2129903 | 2022-01-19 | Clare | Michigan | 26035 | 5773 | 145 |
2129904 | 2129904 | 2022-01-19 | Clinton | Michigan | 26037 | 16975 | 177 |
2129905 | 2129905 | 2022-01-19 | Crawford | Michigan | 26039 | 2158 | 23 |
2129906 | 2129906 | 2022-01-19 | Delta | Michigan | 26041 | 8591 | 140 |
2129907 | 2129907 | 2022-01-19 | Dickinson | Michigan | 26043 | 6245 | 96 |
2129908 | 2129908 | 2022-01-19 | Eaton | Michigan | 26045 | 22738 | 341 |
2129909 | 2129909 | 2022-01-19 | Emmet | Michigan | 26047 | 5575 | 65 |
2129910 | 2129910 | 2022-01-19 | Genesee | Michigan | 26049 | 89365 | 1486 |
2129911 | 2129911 | 2022-01-19 | Gladwin | Michigan | 26051 | 4899 | 102 |
2129912 | 2129912 | 2022-01-19 | Gogebic | Michigan | 26053 | 2832 | 63 |
2129913 | 2129913 | 2022-01-19 | Grand Traverse | Michigan | 26055 | 14632 | 191 |
2129914 | 2129914 | 2022-01-19 | Gratiot | Michigan | 26057 | 11771 | 172 |
2129915 | 2129915 | 2022-01-19 | Hillsdale | Michigan | 26059 | 8953 | 178 |
2129916 | 2129916 | 2022-01-19 | Houghton | Michigan | 26061 | 6741 | 81 |
2129917 | 2129917 | 2022-01-19 | Huron | Michigan | 26063 | 7044 | 132 |
2129918 | 2129918 | 2022-01-19 | Ingham | Michigan | 26065 | 53823 | 639 |
2129919 | 2129919 | 2022-01-19 | Ionia | Michigan | 26067 | 17078 | 157 |
2129920 | 2129920 | 2022-01-19 | Iosco | Michigan | 26069 | 4239 | 122 |
2129921 | 2129921 | 2022-01-19 | Iron | Michigan | 26071 | 2176 | 74 |
2129922 | 2129922 | 2022-01-19 | Isabella | Michigan | 26073 | 13416 | 175 |
2129923 | 2129923 | 2022-01-19 | Jackson | Michigan | 26075 | 39659 | 501 |
2129924 | 2129924 | 2022-01-19 | Kalamazoo | Michigan | 26077 | 50700 | 584 |
2129925 | 2129925 | 2022-01-19 | Kalkaska | Michigan | 26079 | 2923 | 48 |
2129926 | 2129926 | 2022-01-19 | Kent | Michigan | 26081 | 147270 | 1349 |
2129927 | 2129927 | 2022-01-19 | Keweenaw | Michigan | 26083 | 445 | 11 |
2129928 | 2129928 | 2022-01-19 | Lake | Michigan | 26085 | 1548 | 33 |
2129929 | 2129929 | 2022-01-19 | Lapeer | Michigan | 26087 | 18633 | 370 |
2129930 | 2129930 | 2022-01-19 | Leelanau | Michigan | 26089 | 3061 | 44 |
2129931 | 2129931 | 2022-01-19 | Lenawee | Michigan | 26091 | 22801 | 279 |
2129932 | 2129932 | 2022-01-19 | Livingston | Michigan | 26093 | 40320 | 385 |
2129933 | 2129933 | 2022-01-19 | Luce | Michigan | 26095 | 2092 | 7 |
2129934 | 2129934 | 2022-01-19 | Mackinac | Michigan | 26097 | 2032 | 25 |
2129935 | 2129935 | 2022-01-19 | Macomb | Michigan | 26099 | 202557 | 3459 |
2129936 | 2129936 | 2022-01-19 | Manistee | Michigan | 26101 | 3699 | 73 |
2129937 | 2129937 | 2022-01-19 | Marquette | Michigan | 26103 | 13182 | 103 |
2129938 | 2129938 | 2022-01-19 | Mason | Michigan | 26105 | 5423 | 76 |
2129939 | 2129939 | 2022-01-19 | Mecosta | Michigan | 26107 | 7259 | 88 |
2129940 | 2129940 | 2022-01-19 | Menominee | Michigan | 26109 | 4830 | 64 |
2129941 | 2129941 | 2022-01-19 | Midland | Michigan | 26111 | 16363 | 199 |
2129942 | 2129942 | 2022-01-19 | Missaukee | Michigan | 26113 | 2461 | 56 |
2129943 | 2129943 | 2022-01-19 | Monroe | Michigan | 26115 | 33819 | 403 |
2129944 | 2129944 | 2022-01-19 | Montcalm | Michigan | 26117 | 14970 | 187 |
2129945 | 2129945 | 2022-01-19 | Montmorency | Michigan | 26119 | 1505 | 43 |
2129946 | 2129946 | 2022-01-19 | Muskegon | Michigan | 26121 | 37014 | 565 |
2129947 | 2129947 | 2022-01-19 | Newaygo | Michigan | 26123 | 9766 | 136 |
2129948 | 2129948 | 2022-01-19 | Oakland | Michigan | 26125 | 249397 | 3341 |
2129949 | 2129949 | 2022-01-19 | Oceana | Michigan | 26127 | 5428 | 86 |
2129950 | 2129950 | 2022-01-19 | Ogemaw | Michigan | 26129 | 3728 | 87 |
2129951 | 2129951 | 2022-01-19 | Ontonagon | Michigan | 26131 | 885 | 31 |
2129952 | 2129952 | 2022-01-19 | Osceola | Michigan | 26133 | 4348 | 67 |
2129953 | 2129953 | 2022-01-19 | Oscoda | Michigan | 26135 | 1289 | 51 |
2129954 | 2129954 | 2022-01-19 | Otsego | Michigan | 26137 | 4903 | 89 |
2129955 | 2129955 | 2022-01-19 | Ottawa | Michigan | 26139 | 65259 | 703 |
2129956 | 2129956 | 2022-01-19 | Presque Isle | Michigan | 26141 | 1875 | 52 |
2129957 | 2129957 | 2022-01-19 | Roscommon | Michigan | 26143 | 4064 | 109 |
2129958 | 2129958 | 2022-01-19 | Saginaw | Michigan | 26145 | 43416 | 842 |
2129959 | 2129959 | 2022-01-19 | Sanilac | Michigan | 26151 | 7695 | 171 |
2129960 | 2129960 | 2022-01-19 | Schoolcraft | Michigan | 26153 | 1492 | 10 |
2129961 | 2129961 | 2022-01-19 | Shiawassee | Michigan | 26155 | 15259 | 203 |
2129962 | 2129962 | 2022-01-19 | St. Clair | Michigan | 26147 | 36208 | 733 |
2129963 | 2129963 | 2022-01-19 | St. Joseph | Michigan | 26149 | 12078 | 178 |
2129964 | 2129964 | 2022-01-19 | Tuscola | Michigan | 26157 | 11442 | 253 |
2129965 | 2129965 | 2022-01-19 | Unknown | Michigan | 6055 | 28 | |
2129966 | 2129966 | 2022-01-19 | Van Buren | Michigan | 26159 | 14939 | 234 |
2129967 | 2129967 | 2022-01-19 | Washtenaw | Michigan | 26161 | 63407 | 459 |
2129968 | 2129968 | 2022-01-19 | Wayne | Michigan | 26163 | 352129 | 6921 |
2129969 | 2129969 | 2022-01-19 | Wexford | Michigan | 26165 | 5669 | 92 |
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);