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-05-02 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464990 | 2464990 | 2022-05-02 | Alcona | Michigan | 26001 | 1733 | 71 |
2464991 | 2464991 | 2022-05-02 | Alger | Michigan | 26003 | 1867 | 13 |
2464992 | 2464992 | 2022-05-02 | Allegan | Michigan | 26005 | 27205 | 347 |
2464993 | 2464993 | 2022-05-02 | Alpena | Michigan | 26007 | 5728 | 139 |
2464994 | 2464994 | 2022-05-02 | Antrim | Michigan | 26009 | 4383 | 65 |
2464995 | 2464995 | 2022-05-02 | Arenac | Michigan | 26011 | 3210 | 67 |
2464996 | 2464996 | 2022-05-02 | Baraga | Michigan | 26013 | 2213 | 54 |
2464997 | 2464997 | 2022-05-02 | Barry | Michigan | 26015 | 14391 | 167 |
2464998 | 2464998 | 2022-05-02 | Bay | Michigan | 26017 | 27154 | 582 |
2464999 | 2464999 | 2022-05-02 | Benzie | Michigan | 26019 | 3458 | 67 |
2465000 | 2465000 | 2022-05-02 | Berrien | Michigan | 26021 | 34962 | 555 |
2465001 | 2465001 | 2022-05-02 | Branch | Michigan | 26023 | 12194 | 206 |
2465002 | 2465002 | 2022-05-02 | Calhoun | Michigan | 26025 | 34477 | 573 |
2465003 | 2465003 | 2022-05-02 | Cass | Michigan | 26027 | 11134 | 144 |
2465004 | 2465004 | 2022-05-02 | Charlevoix | Michigan | 26029 | 4943 | 60 |
2465005 | 2465005 | 2022-05-02 | Cheboygan | Michigan | 26031 | 4618 | 103 |
2465006 | 2465006 | 2022-05-02 | Chippewa | Michigan | 26033 | 11670 | 120 |
2465007 | 2465007 | 2022-05-02 | Clare | Michigan | 26035 | 6762 | 157 |
2465008 | 2465008 | 2022-05-02 | Clinton | Michigan | 26037 | 21463 | 207 |
2465009 | 2465009 | 2022-05-02 | Crawford | Michigan | 26039 | 2585 | 31 |
2465010 | 2465010 | 2022-05-02 | Delta | Michigan | 26041 | 9951 | 157 |
2465011 | 2465011 | 2022-05-02 | Dickinson | Michigan | 26043 | 7412 | 108 |
2465012 | 2465012 | 2022-05-02 | Eaton | Michigan | 26045 | 27063 | 401 |
2465013 | 2465013 | 2022-05-02 | Emmet | Michigan | 26047 | 6460 | 86 |
2465014 | 2465014 | 2022-05-02 | Genesee | Michigan | 26049 | 102026 | 1715 |
2465015 | 2465015 | 2022-05-02 | Gladwin | Michigan | 26051 | 5580 | 114 |
2465016 | 2465016 | 2022-05-02 | Gogebic | Michigan | 26053 | 3270 | 69 |
2465017 | 2465017 | 2022-05-02 | Grand Traverse | Michigan | 26055 | 17427 | 233 |
2465018 | 2465018 | 2022-05-02 | Gratiot | Michigan | 26057 | 13722 | 192 |
2465019 | 2465019 | 2022-05-02 | Hillsdale | Michigan | 26059 | 10371 | 204 |
2465020 | 2465020 | 2022-05-02 | Houghton | Michigan | 26061 | 7867 | 92 |
2465021 | 2465021 | 2022-05-02 | Huron | Michigan | 26063 | 8034 | 145 |
2465022 | 2465022 | 2022-05-02 | Ingham | Michigan | 26065 | 64895 | 765 |
2465023 | 2465023 | 2022-05-02 | Ionia | Michigan | 26067 | 19643 | 181 |
2465024 | 2465024 | 2022-05-02 | Iosco | Michigan | 26069 | 4814 | 143 |
2465025 | 2465025 | 2022-05-02 | Iron | Michigan | 26071 | 2653 | 87 |
2465026 | 2465026 | 2022-05-02 | Isabella | Michigan | 26073 | 15632 | 208 |
2465027 | 2465027 | 2022-05-02 | Jackson | Michigan | 26075 | 44948 | 588 |
2465028 | 2465028 | 2022-05-02 | Kalamazoo | Michigan | 26077 | 59847 | 673 |
2465029 | 2465029 | 2022-05-02 | Kalkaska | Michigan | 26079 | 3564 | 60 |
2465030 | 2465030 | 2022-05-02 | Kent | Michigan | 26081 | 167891 | 1531 |
2465031 | 2465031 | 2022-05-02 | Keweenaw | Michigan | 26083 | 515 | 14 |
2465032 | 2465032 | 2022-05-02 | Lake | Michigan | 26085 | 1850 | 37 |
2465033 | 2465033 | 2022-05-02 | Lapeer | Michigan | 26087 | 20909 | 427 |
2465034 | 2465034 | 2022-05-02 | Leelanau | Michigan | 26089 | 3620 | 54 |
2465035 | 2465035 | 2022-05-02 | Lenawee | Michigan | 26091 | 26146 | 330 |
2465036 | 2465036 | 2022-05-02 | Livingston | Michigan | 26093 | 46705 | 450 |
2465037 | 2465037 | 2022-05-02 | Luce | Michigan | 26095 | 2292 | 14 |
2465038 | 2465038 | 2022-05-02 | Mackinac | Michigan | 26097 | 2421 | 31 |
2465039 | 2465039 | 2022-05-02 | Macomb | Michigan | 26099 | 233892 | 3961 |
2465040 | 2465040 | 2022-05-02 | Manistee | Michigan | 26101 | 4485 | 90 |
2465041 | 2465041 | 2022-05-02 | Marquette | Michigan | 26103 | 15951 | 130 |
2465042 | 2465042 | 2022-05-02 | Mason | Michigan | 26105 | 6793 | 95 |
2465043 | 2465043 | 2022-05-02 | Mecosta | Michigan | 26107 | 8699 | 106 |
2465044 | 2465044 | 2022-05-02 | Menominee | Michigan | 26109 | 5638 | 70 |
2465045 | 2465045 | 2022-05-02 | Midland | Michigan | 26111 | 19157 | 225 |
2465046 | 2465046 | 2022-05-02 | Missaukee | Michigan | 26113 | 2917 | 60 |
2465047 | 2465047 | 2022-05-02 | Monroe | Michigan | 26115 | 38305 | 473 |
2465048 | 2465048 | 2022-05-02 | Montcalm | Michigan | 26117 | 17219 | 216 |
2465049 | 2465049 | 2022-05-02 | Montmorency | Michigan | 26119 | 1732 | 48 |
2465050 | 2465050 | 2022-05-02 | Muskegon | Michigan | 26121 | 42067 | 649 |
2465051 | 2465051 | 2022-05-02 | Newaygo | Michigan | 26123 | 11514 | 158 |
2465052 | 2465052 | 2022-05-02 | Oakland | Michigan | 26125 | 292717 | 3837 |
2465053 | 2465053 | 2022-05-02 | Oceana | Michigan | 26127 | 6359 | 90 |
2465054 | 2465054 | 2022-05-02 | Ogemaw | Michigan | 26129 | 4321 | 106 |
2465055 | 2465055 | 2022-05-02 | Ontonagon | Michigan | 26131 | 996 | 38 |
2465056 | 2465056 | 2022-05-02 | Osceola | Michigan | 26133 | 5022 | 80 |
2465057 | 2465057 | 2022-05-02 | Oscoda | Michigan | 26135 | 1437 | 55 |
2465058 | 2465058 | 2022-05-02 | Otsego | Michigan | 26137 | 5674 | 100 |
2465059 | 2465059 | 2022-05-02 | Ottawa | Michigan | 26139 | 75339 | 782 |
2465060 | 2465060 | 2022-05-02 | Presque Isle | Michigan | 26141 | 2070 | 58 |
2465061 | 2465061 | 2022-05-02 | Roscommon | Michigan | 26143 | 4635 | 114 |
2465062 | 2465062 | 2022-05-02 | Saginaw | Michigan | 26145 | 50629 | 951 |
2465063 | 2465063 | 2022-05-02 | Sanilac | Michigan | 26151 | 8738 | 192 |
2465064 | 2465064 | 2022-05-02 | Schoolcraft | Michigan | 26153 | 1746 | 16 |
2465065 | 2465065 | 2022-05-02 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2465066 | 2465066 | 2022-05-02 | St. Clair | Michigan | 26147 | 41118 | 834 |
2465067 | 2465067 | 2022-05-02 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2465068 | 2465068 | 2022-05-02 | Tuscola | Michigan | 26157 | 13239 | 277 |
2465069 | 2465069 | 2022-05-02 | Unknown | Michigan | 16914 | 80 | |
2465070 | 2465070 | 2022-05-02 | Van Buren | Michigan | 26159 | 17155 | 270 |
2465071 | 2465071 | 2022-05-02 | Washtenaw | Michigan | 26161 | 80246 | 517 |
2465072 | 2465072 | 2022-05-02 | Wayne | Michigan | 26163 | 406822 | 7942 |
2465073 | 2465073 | 2022-05-02 | Wexford | Michigan | 26165 | 7106 | 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);