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-02-23 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1057995 | 1057995 | 2021-02-23 | Alcona | Michigan | 26001 | 427 | 24 |
1057996 | 1057996 | 2021-02-23 | Alger | Michigan | 26003 | 582 | 5 |
1057997 | 1057997 | 2021-02-23 | Allegan | Michigan | 26005 | 7238 | 118 |
1057998 | 1057998 | 2021-02-23 | Alpena | Michigan | 26007 | 1473 | 47 |
1057999 | 1057999 | 2021-02-23 | Antrim | Michigan | 26009 | 918 | 19 |
1058000 | 1058000 | 2021-02-23 | Arenac | Michigan | 26011 | 745 | 24 |
1058001 | 1058001 | 2021-02-23 | Baraga | Michigan | 26013 | 773 | 33 |
1058002 | 1058002 | 2021-02-23 | Barry | Michigan | 26015 | 3722 | 43 |
1058003 | 1058003 | 2021-02-23 | Bay | Michigan | 26017 | 7357 | 284 |
1058004 | 1058004 | 2021-02-23 | Benzie | Michigan | 26019 | 904 | 31 |
1058005 | 1058005 | 2021-02-23 | Berrien | Michigan | 26021 | 11414 | 238 |
1058006 | 1058006 | 2021-02-23 | Branch | Michigan | 26023 | 4584 | 110 |
1058007 | 1058007 | 2021-02-23 | Calhoun | Michigan | 26025 | 9473 | 234 |
1058008 | 1058008 | 2021-02-23 | Cass | Michigan | 26027 | 3947 | 64 |
1058009 | 1058009 | 2021-02-23 | Charlevoix | Michigan | 26029 | 1038 | 13 |
1058010 | 1058010 | 2021-02-23 | Cheboygan | Michigan | 26031 | 932 | 35 |
1058011 | 1058011 | 2021-02-23 | Chippewa | Michigan | 26033 | 4821 | 43 |
1058012 | 1058012 | 2021-02-23 | Clare | Michigan | 26035 | 1598 | 69 |
1058013 | 1058013 | 2021-02-23 | Clinton | Michigan | 26037 | 5000 | 70 |
1058014 | 1058014 | 2021-02-23 | Crawford | Michigan | 26039 | 581 | 5 |
1058015 | 1058015 | 2021-02-23 | Delta | Michigan | 26041 | 3112 | 84 |
1058016 | 1058016 | 2021-02-23 | Dickinson | Michigan | 26043 | 2366 | 69 |
1058017 | 1058017 | 2021-02-23 | Eaton | Michigan | 26045 | 6195 | 150 |
1058018 | 1058018 | 2021-02-23 | Emmet | Michigan | 26047 | 1507 | 38 |
1058019 | 1058019 | 2021-02-23 | Genesee | Michigan | 26049 | 25272 | 750 |
1058020 | 1058020 | 2021-02-23 | Gladwin | Michigan | 26051 | 1471 | 43 |
1058021 | 1058021 | 2021-02-23 | Gogebic | Michigan | 26053 | 1261 | 47 |
1058022 | 1058022 | 2021-02-23 | Grand Traverse | Michigan | 26055 | 4210 | 68 |
1058023 | 1058023 | 2021-02-23 | Gratiot | Michigan | 26057 | 5640 | 105 |
1058024 | 1058024 | 2021-02-23 | Hillsdale | Michigan | 26059 | 3316 | 72 |
1058025 | 1058025 | 2021-02-23 | Houghton | Michigan | 26061 | 2620 | 40 |
1058026 | 1058026 | 2021-02-23 | Huron | Michigan | 26063 | 2110 | 59 |
1058027 | 1058027 | 2021-02-23 | Ingham | Michigan | 26065 | 16215 | 278 |
1058028 | 1058028 | 2021-02-23 | Ionia | Michigan | 26067 | 6958 | 74 |
1058029 | 1058029 | 2021-02-23 | Iosco | Michigan | 26069 | 1275 | 67 |
1058030 | 1058030 | 2021-02-23 | Iron | Michigan | 26071 | 927 | 49 |
1058031 | 1058031 | 2021-02-23 | Isabella | Michigan | 26073 | 3996 | 73 |
1058032 | 1058032 | 2021-02-23 | Jackson | Michigan | 26075 | 14050 | 246 |
1058033 | 1058033 | 2021-02-23 | Kalamazoo | Michigan | 26077 | 14826 | 319 |
1058034 | 1058034 | 2021-02-23 | Kalkaska | Michigan | 26079 | 594 | 15 |
1058035 | 1058035 | 2021-02-23 | Kent | Michigan | 26081 | 51387 | 702 |
1058036 | 1058036 | 2021-02-23 | Keweenaw | Michigan | 26083 | 141 | 2 |
1058037 | 1058037 | 2021-02-23 | Lake | Michigan | 26085 | 360 | 11 |
1058038 | 1058038 | 2021-02-23 | Lapeer | Michigan | 26087 | 5490 | 128 |
1058039 | 1058039 | 2021-02-23 | Leelanau | Michigan | 26089 | 863 | 14 |
1058040 | 1058040 | 2021-02-23 | Lenawee | Michigan | 26091 | 7652 | 127 |
1058041 | 1058041 | 2021-02-23 | Livingston | Michigan | 26093 | 10257 | 141 |
1058042 | 1058042 | 2021-02-23 | Luce | Michigan | 26095 | 1073 | 2 |
1058043 | 1058043 | 2021-02-23 | Mackinac | Michigan | 26097 | 440 | 3 |
1058044 | 1058044 | 2021-02-23 | Macomb | Michigan | 26099 | 58784 | 1959 |
1058045 | 1058045 | 2021-02-23 | Manistee | Michigan | 26101 | 1522 | 23 |
1058046 | 1058046 | 2021-02-23 | Marquette | Michigan | 26103 | 4795 | 56 |
1058047 | 1058047 | 2021-02-23 | Mason | Michigan | 26105 | 1230 | 26 |
1058048 | 1058048 | 2021-02-23 | Mecosta | Michigan | 26107 | 2007 | 19 |
1058049 | 1058049 | 2021-02-23 | Menominee | Michigan | 26109 | 1876 | 37 |
1058050 | 1058050 | 2021-02-23 | Midland | Michigan | 26111 | 4926 | 64 |
1058051 | 1058051 | 2021-02-23 | Missaukee | Michigan | 26113 | 763 | 17 |
1058052 | 1058052 | 2021-02-23 | Monroe | Michigan | 26115 | 9664 | 200 |
1058053 | 1058053 | 2021-02-23 | Montcalm | Michigan | 26117 | 5591 | 92 |
1058054 | 1058054 | 2021-02-23 | Montmorency | Michigan | 26119 | 357 | 17 |
1058055 | 1058055 | 2021-02-23 | Muskegon | Michigan | 26121 | 12667 | 315 |
1058056 | 1058056 | 2021-02-23 | Newaygo | Michigan | 26123 | 2807 | 50 |
1058057 | 1058057 | 2021-02-23 | Oakland | Michigan | 26125 | 74155 | 1980 |
1058058 | 1058058 | 2021-02-23 | Oceana | Michigan | 26127 | 1863 | 50 |
1058059 | 1058059 | 2021-02-23 | Ogemaw | Michigan | 26129 | 1111 | 34 |
1058060 | 1058060 | 2021-02-23 | Ontonagon | Michigan | 26131 | 410 | 20 |
1058061 | 1058061 | 2021-02-23 | Osceola | Michigan | 26133 | 1047 | 23 |
1058062 | 1058062 | 2021-02-23 | Oscoda | Michigan | 26135 | 395 | 19 |
1058063 | 1058063 | 2021-02-23 | Otsego | Michigan | 26137 | 1160 | 25 |
1058064 | 1058064 | 2021-02-23 | Ottawa | Michigan | 26139 | 22218 | 347 |
1058065 | 1058065 | 2021-02-23 | Presque Isle | Michigan | 26141 | 653 | 28 |
1058066 | 1058066 | 2021-02-23 | Roscommon | Michigan | 26143 | 1145 | 32 |
1058067 | 1058067 | 2021-02-23 | Saginaw | Michigan | 26145 | 15834 | 515 |
1058068 | 1058068 | 2021-02-23 | Sanilac | Michigan | 26151 | 2020 | 76 |
1058069 | 1058069 | 2021-02-23 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1058070 | 1058070 | 2021-02-23 | Shiawassee | Michigan | 26155 | 3769 | 78 |
1058071 | 1058071 | 2021-02-23 | St. Clair | Michigan | 26147 | 8609 | 254 |
1058072 | 1058072 | 2021-02-23 | St. Joseph | Michigan | 26149 | 4619 | 84 |
1058073 | 1058073 | 2021-02-23 | Tuscola | Michigan | 26157 | 3153 | 137 |
1058074 | 1058074 | 2021-02-23 | Unknown | Michigan | 0 | 12 | |
1058075 | 1058075 | 2021-02-23 | Van Buren | Michigan | 26159 | 4949 | 95 |
1058076 | 1058076 | 2021-02-23 | Washtenaw | Michigan | 26161 | 19036 | 251 |
1058077 | 1058077 | 2021-02-23 | Wayne | Michigan | 26163 | 100905 | 4126 |
1058078 | 1058078 | 2021-02-23 | Wexford | Michigan | 26165 | 1416 | 20 |
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);