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-04-27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1262551 | 1262551 | 2021-04-27 | Alcona | Michigan | 26001 | 691 | 26 |
1262552 | 1262552 | 2021-04-27 | Alger | Michigan | 26003 | 644 | 6 |
1262553 | 1262553 | 2021-04-27 | Allegan | Michigan | 26005 | 10176 | 126 |
1262554 | 1262554 | 2021-04-27 | Alpena | Michigan | 26007 | 2035 | 55 |
1262555 | 1262555 | 2021-04-27 | Antrim | Michigan | 26009 | 1512 | 27 |
1262556 | 1262556 | 2021-04-27 | Arenac | Michigan | 26011 | 1049 | 28 |
1262557 | 1262557 | 2021-04-27 | Baraga | Michigan | 26013 | 840 | 34 |
1262558 | 1262558 | 2021-04-27 | Barry | Michigan | 26015 | 5372 | 61 |
1262559 | 1262559 | 2021-04-27 | Bay | Michigan | 26017 | 10376 | 321 |
1262560 | 1262560 | 2021-04-27 | Benzie | Michigan | 26019 | 1197 | 32 |
1262561 | 1262561 | 2021-04-27 | Berrien | Michigan | 26021 | 14516 | 267 |
1262562 | 1262562 | 2021-04-27 | Branch | Michigan | 26023 | 5367 | 118 |
1262563 | 1262563 | 2021-04-27 | Calhoun | Michigan | 26025 | 13257 | 269 |
1262564 | 1262564 | 2021-04-27 | Cass | Michigan | 26027 | 5154 | 73 |
1262565 | 1262565 | 2021-04-27 | Charlevoix | Michigan | 26029 | 1563 | 18 |
1262566 | 1262566 | 2021-04-27 | Cheboygan | Michigan | 26031 | 1768 | 41 |
1262567 | 1262567 | 2021-04-27 | Chippewa | Michigan | 26033 | 5469 | 48 |
1262568 | 1262568 | 2021-04-27 | Clare | Michigan | 26035 | 2215 | 73 |
1262569 | 1262569 | 2021-04-27 | Clinton | Michigan | 26037 | 7209 | 81 |
1262570 | 1262570 | 2021-04-27 | Crawford | Michigan | 26039 | 928 | 11 |
1262571 | 1262571 | 2021-04-27 | Delta | Michigan | 26041 | 3781 | 88 |
1262572 | 1262572 | 2021-04-27 | Dickinson | Michigan | 26043 | 2653 | 73 |
1262573 | 1262573 | 2021-04-27 | Eaton | Michigan | 26045 | 9555 | 182 |
1262574 | 1262574 | 2021-04-27 | Emmet | Michigan | 26047 | 2201 | 41 |
1262575 | 1262575 | 2021-04-27 | Genesee | Michigan | 26049 | 38927 | 856 |
1262576 | 1262576 | 2021-04-27 | Gladwin | Michigan | 26051 | 2150 | 46 |
1262577 | 1262577 | 2021-04-27 | Gogebic | Michigan | 26053 | 1360 | 50 |
1262578 | 1262578 | 2021-04-27 | Grand Traverse | Michigan | 26055 | 6131 | 87 |
1262579 | 1262579 | 2021-04-27 | Gratiot | Michigan | 26057 | 6542 | 114 |
1262580 | 1262580 | 2021-04-27 | Hillsdale | Michigan | 26059 | 4109 | 82 |
1262581 | 1262581 | 2021-04-27 | Houghton | Michigan | 26061 | 3020 | 40 |
1262582 | 1262582 | 2021-04-27 | Huron | Michigan | 26063 | 3856 | 72 |
1262583 | 1262583 | 2021-04-27 | Ingham | Michigan | 26065 | 23428 | 342 |
1262584 | 1262584 | 2021-04-27 | Ionia | Michigan | 26067 | 8615 | 81 |
1262585 | 1262585 | 2021-04-27 | Iosco | Michigan | 26069 | 1831 | 69 |
1262586 | 1262586 | 2021-04-27 | Iron | Michigan | 26071 | 989 | 51 |
1262587 | 1262587 | 2021-04-27 | Isabella | Michigan | 26073 | 5729 | 83 |
1262588 | 1262588 | 2021-04-27 | Jackson | Michigan | 26075 | 19840 | 288 |
1262589 | 1262589 | 2021-04-27 | Kalamazoo | Michigan | 26077 | 21252 | 353 |
1262590 | 1262590 | 2021-04-27 | Kalkaska | Michigan | 26079 | 1023 | 20 |
1262591 | 1262591 | 2021-04-27 | Kent | Michigan | 26081 | 67175 | 780 |
1262592 | 1262592 | 2021-04-27 | Keweenaw | Michigan | 26083 | 171 | 2 |
1262593 | 1262593 | 2021-04-27 | Lake | Michigan | 26085 | 570 | 14 |
1262594 | 1262594 | 2021-04-27 | Lapeer | Michigan | 26087 | 9052 | 177 |
1262595 | 1262595 | 2021-04-27 | Leelanau | Michigan | 26089 | 1183 | 17 |
1262596 | 1262596 | 2021-04-27 | Lenawee | Michigan | 26091 | 10229 | 157 |
1262597 | 1262597 | 2021-04-27 | Livingston | Michigan | 26093 | 15604 | 171 |
1262598 | 1262598 | 2021-04-27 | Luce | Michigan | 26095 | 1204 | 3 |
1262599 | 1262599 | 2021-04-27 | Mackinac | Michigan | 26097 | 610 | 3 |
1262600 | 1262600 | 2021-04-27 | Macomb | Michigan | 26099 | 93859 | 2197 |
1262601 | 1262601 | 2021-04-27 | Manistee | Michigan | 26101 | 1888 | 23 |
1262602 | 1262602 | 2021-04-27 | Marquette | Michigan | 26103 | 5692 | 59 |
1262603 | 1262603 | 2021-04-27 | Mason | Michigan | 26105 | 1962 | 31 |
1262604 | 1262604 | 2021-04-27 | Mecosta | Michigan | 26107 | 2918 | 27 |
1262605 | 1262605 | 2021-04-27 | Menominee | Michigan | 26109 | 2038 | 41 |
1262606 | 1262606 | 2021-04-27 | Midland | Michigan | 26111 | 6887 | 77 |
1262607 | 1262607 | 2021-04-27 | Missaukee | Michigan | 26113 | 1390 | 23 |
1262608 | 1262608 | 2021-04-27 | Monroe | Michigan | 26115 | 14361 | 236 |
1262609 | 1262609 | 2021-04-27 | Montcalm | Michigan | 26117 | 7414 | 105 |
1262610 | 1262610 | 2021-04-27 | Montmorency | Michigan | 26119 | 528 | 18 |
1262611 | 1262611 | 2021-04-27 | Muskegon | Michigan | 26121 | 16161 | 335 |
1262612 | 1262612 | 2021-04-27 | Newaygo | Michigan | 26123 | 4326 | 58 |
1262613 | 1262613 | 2021-04-27 | Oakland | Michigan | 26125 | 109374 | 2181 |
1262614 | 1262614 | 2021-04-27 | Oceana | Michigan | 26127 | 2555 | 53 |
1262615 | 1262615 | 2021-04-27 | Ogemaw | Michigan | 26129 | 1528 | 36 |
1262616 | 1262616 | 2021-04-27 | Ontonagon | Michigan | 26131 | 452 | 21 |
1262617 | 1262617 | 2021-04-27 | Osceola | Michigan | 26133 | 1744 | 25 |
1262618 | 1262618 | 2021-04-27 | Oscoda | Michigan | 26135 | 580 | 24 |
1262619 | 1262619 | 2021-04-27 | Otsego | Michigan | 26137 | 2160 | 35 |
1262620 | 1262620 | 2021-04-27 | Ottawa | Michigan | 26139 | 30191 | 391 |
1262621 | 1262621 | 2021-04-27 | Presque Isle | Michigan | 26141 | 953 | 31 |
1262622 | 1262622 | 2021-04-27 | Roscommon | Michigan | 26143 | 1784 | 47 |
1262623 | 1262623 | 2021-04-27 | Saginaw | Michigan | 26145 | 20534 | 568 |
1262624 | 1262624 | 2021-04-27 | Sanilac | Michigan | 26151 | 4051 | 102 |
1262625 | 1262625 | 2021-04-27 | Schoolcraft | Michigan | 26153 | 349 | 5 |
1262626 | 1262626 | 2021-04-27 | Shiawassee | Michigan | 26155 | 5913 | 95 |
1262627 | 1262627 | 2021-04-27 | St. Clair | Michigan | 26147 | 17108 | 380 |
1262628 | 1262628 | 2021-04-27 | St. Joseph | Michigan | 26149 | 5770 | 94 |
1262629 | 1262629 | 2021-04-27 | Tuscola | Michigan | 26157 | 5319 | 157 |
1262630 | 1262630 | 2021-04-27 | Unknown | Michigan | 144 | 17 | |
1262631 | 1262631 | 2021-04-27 | Van Buren | Michigan | 26159 | 6630 | 112 |
1262632 | 1262632 | 2021-04-27 | Washtenaw | Michigan | 26161 | 25731 | 276 |
1262633 | 1262633 | 2021-04-27 | Wayne | Michigan | 26163 | 152526 | 4579 |
1262634 | 1262634 | 2021-04-27 | Wexford | Michigan | 26165 | 2648 | 36 |
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);