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-03-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 |
---|---|---|---|---|---|---|---|
1135900 | 1135900 | 2021-03-19 | Alcona | Michigan | 26001 | 441 | 25 |
1135901 | 1135901 | 2021-03-19 | Alger | Michigan | 26003 | 589 | 5 |
1135902 | 1135902 | 2021-03-19 | Allegan | Michigan | 26005 | 7729 | 118 |
1135903 | 1135903 | 2021-03-19 | Alpena | Michigan | 26007 | 1530 | 48 |
1135904 | 1135904 | 2021-03-19 | Antrim | Michigan | 26009 | 1060 | 20 |
1135905 | 1135905 | 2021-03-19 | Arenac | Michigan | 26011 | 773 | 26 |
1135906 | 1135906 | 2021-03-19 | Baraga | Michigan | 26013 | 785 | 34 |
1135907 | 1135907 | 2021-03-19 | Barry | Michigan | 26015 | 3957 | 49 |
1135908 | 1135908 | 2021-03-19 | Bay | Michigan | 26017 | 7817 | 298 |
1135909 | 1135909 | 2021-03-19 | Benzie | Michigan | 26019 | 963 | 32 |
1135910 | 1135910 | 2021-03-19 | Berrien | Michigan | 26021 | 12194 | 247 |
1135911 | 1135911 | 2021-03-19 | Branch | Michigan | 26023 | 4721 | 111 |
1135912 | 1135912 | 2021-03-19 | Calhoun | Michigan | 26025 | 10445 | 240 |
1135913 | 1135913 | 2021-03-19 | Cass | Michigan | 26027 | 4323 | 67 |
1135914 | 1135914 | 2021-03-19 | Charlevoix | Michigan | 26029 | 1125 | 13 |
1135915 | 1135915 | 2021-03-19 | Cheboygan | Michigan | 26031 | 1152 | 38 |
1135916 | 1135916 | 2021-03-19 | Chippewa | Michigan | 26033 | 4946 | 44 |
1135917 | 1135917 | 2021-03-19 | Clare | Michigan | 26035 | 1645 | 69 |
1135918 | 1135918 | 2021-03-19 | Clinton | Michigan | 26037 | 5455 | 74 |
1135919 | 1135919 | 2021-03-19 | Crawford | Michigan | 26039 | 639 | 5 |
1135920 | 1135920 | 2021-03-19 | Delta | Michigan | 26041 | 3216 | 85 |
1135921 | 1135921 | 2021-03-19 | Dickinson | Michigan | 26043 | 2401 | 71 |
1135922 | 1135922 | 2021-03-19 | Eaton | Michigan | 26045 | 6797 | 159 |
1135923 | 1135923 | 2021-03-19 | Emmet | Michigan | 26047 | 1595 | 39 |
1135924 | 1135924 | 2021-03-19 | Genesee | Michigan | 26049 | 27628 | 767 |
1135925 | 1135925 | 2021-03-19 | Gladwin | Michigan | 26051 | 1528 | 43 |
1135926 | 1135926 | 2021-03-19 | Gogebic | Michigan | 26053 | 1305 | 49 |
1135927 | 1135927 | 2021-03-19 | Grand Traverse | Michigan | 26055 | 4651 | 74 |
1135928 | 1135928 | 2021-03-19 | Gratiot | Michigan | 26057 | 5727 | 108 |
1135929 | 1135929 | 2021-03-19 | Hillsdale | Michigan | 26059 | 3505 | 77 |
1135930 | 1135930 | 2021-03-19 | Houghton | Michigan | 26061 | 2746 | 39 |
1135931 | 1135931 | 2021-03-19 | Huron | Michigan | 26063 | 2525 | 61 |
1135932 | 1135932 | 2021-03-19 | Ingham | Michigan | 26065 | 17666 | 290 |
1135933 | 1135933 | 2021-03-19 | Ionia | Michigan | 26067 | 7289 | 78 |
1135934 | 1135934 | 2021-03-19 | Iosco | Michigan | 26069 | 1306 | 67 |
1135935 | 1135935 | 2021-03-19 | Iron | Michigan | 26071 | 928 | 50 |
1135936 | 1135936 | 2021-03-19 | Isabella | Michigan | 26073 | 4170 | 74 |
1135937 | 1135937 | 2021-03-19 | Jackson | Michigan | 26075 | 15211 | 258 |
1135938 | 1135938 | 2021-03-19 | Kalamazoo | Michigan | 26077 | 16069 | 325 |
1135939 | 1135939 | 2021-03-19 | Kalkaska | Michigan | 26079 | 692 | 15 |
1135940 | 1135940 | 2021-03-19 | Kent | Michigan | 26081 | 53744 | 724 |
1135941 | 1135941 | 2021-03-19 | Keweenaw | Michigan | 26083 | 153 | 2 |
1135942 | 1135942 | 2021-03-19 | Lake | Michigan | 26085 | 392 | 11 |
1135943 | 1135943 | 2021-03-19 | Lapeer | Michigan | 26087 | 6100 | 135 |
1135944 | 1135944 | 2021-03-19 | Leelanau | Michigan | 26089 | 940 | 15 |
1135945 | 1135945 | 2021-03-19 | Lenawee | Michigan | 26091 | 8081 | 131 |
1135946 | 1135946 | 2021-03-19 | Livingston | Michigan | 26093 | 11225 | 152 |
1135947 | 1135947 | 2021-03-19 | Luce | Michigan | 26095 | 1098 | 2 |
1135948 | 1135948 | 2021-03-19 | Mackinac | Michigan | 26097 | 459 | 3 |
1135949 | 1135949 | 2021-03-19 | Macomb | Michigan | 26099 | 64517 | 2007 |
1135950 | 1135950 | 2021-03-19 | Manistee | Michigan | 26101 | 1585 | 23 |
1135951 | 1135951 | 2021-03-19 | Marquette | Michigan | 26103 | 4915 | 57 |
1135952 | 1135952 | 2021-03-19 | Mason | Michigan | 26105 | 1289 | 27 |
1135953 | 1135953 | 2021-03-19 | Mecosta | Michigan | 26107 | 2095 | 21 |
1135954 | 1135954 | 2021-03-19 | Menominee | Michigan | 26109 | 1905 | 40 |
1135955 | 1135955 | 2021-03-19 | Midland | Michigan | 26111 | 5286 | 66 |
1135956 | 1135956 | 2021-03-19 | Missaukee | Michigan | 26113 | 954 | 19 |
1135957 | 1135957 | 2021-03-19 | Monroe | Michigan | 26115 | 10651 | 209 |
1135958 | 1135958 | 2021-03-19 | Montcalm | Michigan | 26117 | 5778 | 96 |
1135959 | 1135959 | 2021-03-19 | Montmorency | Michigan | 26119 | 376 | 18 |
1135960 | 1135960 | 2021-03-19 | Muskegon | Michigan | 26121 | 12931 | 318 |
1135961 | 1135961 | 2021-03-19 | Newaygo | Michigan | 26123 | 3127 | 53 |
1135962 | 1135962 | 2021-03-19 | Oakland | Michigan | 26125 | 79999 | 2039 |
1135963 | 1135963 | 2021-03-19 | Oceana | Michigan | 26127 | 1931 | 50 |
1135964 | 1135964 | 2021-03-19 | Ogemaw | Michigan | 26129 | 1141 | 34 |
1135965 | 1135965 | 2021-03-19 | Ontonagon | Michigan | 26131 | 424 | 21 |
1135966 | 1135966 | 2021-03-19 | Osceola | Michigan | 26133 | 1163 | 23 |
1135967 | 1135967 | 2021-03-19 | Oscoda | Michigan | 26135 | 413 | 20 |
1135968 | 1135968 | 2021-03-19 | Otsego | Michigan | 26137 | 1392 | 28 |
1135969 | 1135969 | 2021-03-19 | Ottawa | Michigan | 26139 | 23276 | 360 |
1135970 | 1135970 | 2021-03-19 | Presque Isle | Michigan | 26141 | 679 | 28 |
1135971 | 1135971 | 2021-03-19 | Roscommon | Michigan | 26143 | 1334 | 37 |
1135972 | 1135972 | 2021-03-19 | Saginaw | Michigan | 26145 | 16664 | 539 |
1135973 | 1135973 | 2021-03-19 | Sanilac | Michigan | 26151 | 2442 | 79 |
1135974 | 1135974 | 2021-03-19 | Schoolcraft | Michigan | 26153 | 272 | 5 |
1135975 | 1135975 | 2021-03-19 | Shiawassee | Michigan | 26155 | 4058 | 83 |
1135976 | 1135976 | 2021-03-19 | St. Clair | Michigan | 26147 | 9979 | 263 |
1135977 | 1135977 | 2021-03-19 | St. Joseph | Michigan | 26149 | 4980 | 87 |
1135978 | 1135978 | 2021-03-19 | Tuscola | Michigan | 26157 | 3535 | 139 |
1135979 | 1135979 | 2021-03-19 | Unknown | Michigan | 0 | 12 | |
1135980 | 1135980 | 2021-03-19 | Van Buren | Michigan | 26159 | 5263 | 98 |
1135981 | 1135981 | 2021-03-19 | Washtenaw | Michigan | 26161 | 20226 | 255 |
1135982 | 1135982 | 2021-03-19 | Wayne | Michigan | 26163 | 108800 | 4205 |
1135983 | 1135983 | 2021-03-19 | Wexford | Michigan | 26165 | 1768 | 22 |
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);