ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-12-20" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
847040 | 847040 | 2020-12-20 | Alcona | Michigan | 26001 | 322 | 13 |
847041 | 847041 | 2020-12-20 | Alger | Michigan | 26003 | 407 | 2 |
847042 | 847042 | 2020-12-20 | Allegan | Michigan | 26005 | 5355 | 55 |
847043 | 847043 | 2020-12-20 | Alpena | Michigan | 26007 | 1063 | 23 |
847044 | 847044 | 2020-12-20 | Antrim | Michigan | 26009 | 577 | 8 |
847045 | 847045 | 2020-12-20 | Arenac | Michigan | 26011 | 567 | 23 |
847046 | 847046 | 2020-12-20 | Baraga | Michigan | 26013 | 604 | 28 |
847047 | 847047 | 2020-12-20 | Barry | Michigan | 26015 | 2741 | 28 |
847048 | 847048 | 2020-12-20 | Bay | Michigan | 26017 | 5818 | 164 |
847049 | 847049 | 2020-12-20 | Benzie | Michigan | 26019 | 607 | 19 |
847050 | 847050 | 2020-12-20 | Berrien | Michigan | 26021 | 8840 | 166 |
847051 | 847051 | 2020-12-20 | Branch | Michigan | 26023 | 3720 | 80 |
847052 | 847052 | 2020-12-20 | Calhoun | Michigan | 26025 | 7495 | 169 |
847053 | 847053 | 2020-12-20 | Cass | Michigan | 26027 | 2942 | 39 |
847054 | 847054 | 2020-12-20 | Charlevoix | Michigan | 26029 | 821 | 9 |
847055 | 847055 | 2020-12-20 | Cheboygan | Michigan | 26031 | 694 | 29 |
847056 | 847056 | 2020-12-20 | Chippewa | Michigan | 26033 | 2600 | 18 |
847057 | 847057 | 2020-12-20 | Clare | Michigan | 26035 | 1119 | 30 |
847058 | 847058 | 2020-12-20 | Clinton | Michigan | 26037 | 3539 | 33 |
847059 | 847059 | 2020-12-20 | Crawford | Michigan | 26039 | 444 | 6 |
847060 | 847060 | 2020-12-20 | Delta | Michigan | 26041 | 2820 | 73 |
847061 | 847061 | 2020-12-20 | Dickinson | Michigan | 26043 | 2079 | 64 |
847062 | 847062 | 2020-12-20 | Eaton | Michigan | 26045 | 4266 | 79 |
847063 | 847063 | 2020-12-20 | Emmet | Michigan | 26047 | 1169 | 33 |
847064 | 847064 | 2020-12-20 | Genesee | Michigan | 26049 | 20216 | 538 |
847065 | 847065 | 2020-12-20 | Gladwin | Michigan | 26051 | 1094 | 23 |
847066 | 847066 | 2020-12-20 | Gogebic | Michigan | 26053 | 991 | 32 |
847067 | 847067 | 2020-12-20 | Grand Traverse | Michigan | 26055 | 2766 | 39 |
847068 | 847068 | 2020-12-20 | Gratiot | Michigan | 26057 | 3981 | 60 |
847069 | 847069 | 2020-12-20 | Hillsdale | Michigan | 26059 | 2255 | 50 |
847070 | 847070 | 2020-12-20 | Houghton | Michigan | 26061 | 1928 | 26 |
847071 | 847071 | 2020-12-20 | Huron | Michigan | 26063 | 1406 | 35 |
847072 | 847072 | 2020-12-20 | Ingham | Michigan | 26065 | 11827 | 166 |
847073 | 847073 | 2020-12-20 | Ionia | Michigan | 26067 | 4596 | 41 |
847074 | 847074 | 2020-12-20 | Iosco | Michigan | 26069 | 1045 | 43 |
847075 | 847075 | 2020-12-20 | Iron | Michigan | 26071 | 789 | 37 |
847076 | 847076 | 2020-12-20 | Isabella | Michigan | 26073 | 3166 | 36 |
847077 | 847077 | 2020-12-20 | Jackson | Michigan | 26075 | 9815 | 162 |
847078 | 847078 | 2020-12-20 | Kalamazoo | Michigan | 26077 | 11581 | 221 |
847079 | 847079 | 2020-12-20 | Kalkaska | Michigan | 26079 | 464 | 10 |
847080 | 847080 | 2020-12-20 | Kent | Michigan | 26081 | 41084 | 503 |
847081 | 847081 | 2020-12-20 | Keweenaw | Michigan | 26083 | 76 | 2 |
847082 | 847082 | 2020-12-20 | Lake | Michigan | 26085 | 283 | 8 |
847083 | 847083 | 2020-12-20 | Lapeer | Michigan | 26087 | 4036 | 93 |
847084 | 847084 | 2020-12-20 | Leelanau | Michigan | 26089 | 569 | 5 |
847085 | 847085 | 2020-12-20 | Lenawee | Michigan | 26091 | 4915 | 59 |
847086 | 847086 | 2020-12-20 | Livingston | Michigan | 26093 | 7399 | 65 |
847087 | 847087 | 2020-12-20 | Luce | Michigan | 26095 | 970 | 0 |
847088 | 847088 | 2020-12-20 | Mackinac | Michigan | 26097 | 361 | 2 |
847089 | 847089 | 2020-12-20 | Macomb | Michigan | 26099 | 47426 | 1520 |
847090 | 847090 | 2020-12-20 | Manistee | Michigan | 26101 | 554 | 14 |
847091 | 847091 | 2020-12-20 | Marquette | Michigan | 26103 | 4267 | 49 |
847092 | 847092 | 2020-12-20 | Mason | Michigan | 26105 | 890 | 15 |
847093 | 847093 | 2020-12-20 | Mecosta | Michigan | 26107 | 1576 | 12 |
847094 | 847094 | 2020-12-20 | Menominee | Michigan | 26109 | 1571 | 23 |
847095 | 847095 | 2020-12-20 | Midland | Michigan | 26111 | 3697 | 36 |
847096 | 847096 | 2020-12-20 | Missaukee | Michigan | 26113 | 405 | 8 |
847097 | 847097 | 2020-12-20 | Monroe | Michigan | 26115 | 7105 | 130 |
847098 | 847098 | 2020-12-20 | Montcalm | Michigan | 26117 | 3028 | 56 |
847099 | 847099 | 2020-12-20 | Montmorency | Michigan | 26119 | 255 | 8 |
847100 | 847100 | 2020-12-20 | Muskegon | Michigan | 26121 | 10759 | 249 |
847101 | 847101 | 2020-12-20 | Newaygo | Michigan | 26123 | 2114 | 28 |
847102 | 847102 | 2020-12-20 | Oakland | Michigan | 26125 | 57698 | 1543 |
847103 | 847103 | 2020-12-20 | Oceana | Michigan | 26127 | 1537 | 34 |
847104 | 847104 | 2020-12-20 | Ogemaw | Michigan | 26129 | 843 | 26 |
847105 | 847105 | 2020-12-20 | Ontonagon | Michigan | 26131 | 302 | 15 |
847106 | 847106 | 2020-12-20 | Osceola | Michigan | 26133 | 776 | 14 |
847107 | 847107 | 2020-12-20 | Oscoda | Michigan | 26135 | 279 | 14 |
847108 | 847108 | 2020-12-20 | Otsego | Michigan | 26137 | 966 | 21 |
847109 | 847109 | 2020-12-20 | Ottawa | Michigan | 26139 | 17700 | 241 |
847110 | 847110 | 2020-12-20 | Presque Isle | Michigan | 26141 | 471 | 5 |
847111 | 847111 | 2020-12-20 | Roscommon | Michigan | 26143 | 907 | 26 |
847112 | 847112 | 2020-12-20 | Saginaw | Michigan | 26145 | 11519 | 347 |
847113 | 847113 | 2020-12-20 | Sanilac | Michigan | 26151 | 1357 | 53 |
847114 | 847114 | 2020-12-20 | Schoolcraft | Michigan | 26153 | 211 | 4 |
847115 | 847115 | 2020-12-20 | Shiawassee | Michigan | 26155 | 2689 | 55 |
847116 | 847116 | 2020-12-20 | St. Clair | Michigan | 26147 | 6467 | 134 |
847117 | 847117 | 2020-12-20 | St. Joseph | Michigan | 26149 | 3353 | 48 |
847118 | 847118 | 2020-12-20 | Tuscola | Michigan | 26157 | 2379 | 81 |
847119 | 847119 | 2020-12-20 | Unknown | Michigan | 5340 | 24 | |
847120 | 847120 | 2020-12-20 | Van Buren | Michigan | 26159 | 3853 | 73 |
847121 | 847121 | 2020-12-20 | Washtenaw | Michigan | 26161 | 13251 | 180 |
847122 | 847122 | 2020-12-20 | Wayne | Michigan | 26163 | 80316 | 3517 |
847123 | 847123 | 2020-12-20 | Wexford | Michigan | 26165 | 940 | 16 |
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);