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-07-01 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1473546 | 1473546 | 2021-07-01 | Alcona | Michigan | 26001 | 739 | 33 |
1473547 | 1473547 | 2021-07-01 | Alger | Michigan | 26003 | 670 | 7 |
1473548 | 1473548 | 2021-07-01 | Allegan | Michigan | 26005 | 11189 | 161 |
1473549 | 1473549 | 2021-07-01 | Alpena | Michigan | 26007 | 2272 | 63 |
1473550 | 1473550 | 2021-07-01 | Antrim | Michigan | 26009 | 1636 | 30 |
1473551 | 1473551 | 2021-07-01 | Arenac | Michigan | 26011 | 1209 | 29 |
1473552 | 1473552 | 2021-07-01 | Baraga | Michigan | 26013 | 994 | 40 |
1473553 | 1473553 | 2021-07-01 | Barry | Michigan | 26015 | 5965 | 69 |
1473554 | 1473554 | 2021-07-01 | Bay | Michigan | 26017 | 11266 | 355 |
1473555 | 1473555 | 2021-07-01 | Benzie | Michigan | 26019 | 1281 | 36 |
1473556 | 1473556 | 2021-07-01 | Berrien | Michigan | 26021 | 15615 | 293 |
1473557 | 1473557 | 2021-07-01 | Branch | Michigan | 26023 | 5767 | 121 |
1473558 | 1473558 | 2021-07-01 | Calhoun | Michigan | 26025 | 14569 | 318 |
1473559 | 1473559 | 2021-07-01 | Cass | Michigan | 26027 | 5503 | 77 |
1473560 | 1473560 | 2021-07-01 | Charlevoix | Michigan | 26029 | 1682 | 22 |
1473561 | 1473561 | 2021-07-01 | Cheboygan | Michigan | 26031 | 1931 | 46 |
1473562 | 1473562 | 2021-07-01 | Chippewa | Michigan | 26033 | 5633 | 50 |
1473563 | 1473563 | 2021-07-01 | Clare | Michigan | 26035 | 2481 | 85 |
1473564 | 1473564 | 2021-07-01 | Clinton | Michigan | 26037 | 7658 | 93 |
1473565 | 1473565 | 2021-07-01 | Crawford | Michigan | 26039 | 996 | 14 |
1473566 | 1473566 | 2021-07-01 | Delta | Michigan | 26041 | 4057 | 95 |
1473567 | 1473567 | 2021-07-01 | Dickinson | Michigan | 26043 | 2755 | 74 |
1473568 | 1473568 | 2021-07-01 | Eaton | Michigan | 26045 | 10157 | 212 |
1473569 | 1473569 | 2021-07-01 | Emmet | Michigan | 26047 | 2384 | 43 |
1473570 | 1473570 | 2021-07-01 | Genesee | Michigan | 26049 | 41758 | 971 |
1473571 | 1473571 | 2021-07-01 | Gladwin | Michigan | 26051 | 2305 | 61 |
1473572 | 1473572 | 2021-07-01 | Gogebic | Michigan | 26053 | 1406 | 52 |
1473573 | 1473573 | 2021-07-01 | Grand Traverse | Michigan | 26055 | 6480 | 99 |
1473574 | 1473574 | 2021-07-01 | Gratiot | Michigan | 26057 | 6987 | 125 |
1473575 | 1473575 | 2021-07-01 | Hillsdale | Michigan | 26059 | 4402 | 93 |
1473576 | 1473576 | 2021-07-01 | Houghton | Michigan | 26061 | 3143 | 43 |
1473577 | 1473577 | 2021-07-01 | Huron | Michigan | 26063 | 4093 | 82 |
1473578 | 1473578 | 2021-07-01 | Ingham | Michigan | 26065 | 24912 | 392 |
1473579 | 1473579 | 2021-07-01 | Ionia | Michigan | 26067 | 9351 | 85 |
1473580 | 1473580 | 2021-07-01 | Iosco | Michigan | 26069 | 2007 | 74 |
1473581 | 1473581 | 2021-07-01 | Iron | Michigan | 26071 | 1054 | 53 |
1473582 | 1473582 | 2021-07-01 | Isabella | Michigan | 26073 | 6339 | 100 |
1473583 | 1473583 | 2021-07-01 | Jackson | Michigan | 26075 | 21056 | 324 |
1473584 | 1473584 | 2021-07-01 | Kalamazoo | Michigan | 26077 | 23192 | 402 |
1473585 | 1473585 | 2021-07-01 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1473586 | 1473586 | 2021-07-01 | Kent | Michigan | 26081 | 73779 | 864 |
1473587 | 1473587 | 2021-07-01 | Keweenaw | Michigan | 26083 | 174 | 2 |
1473588 | 1473588 | 2021-07-01 | Lake | Michigan | 26085 | 638 | 16 |
1473589 | 1473589 | 2021-07-01 | Lapeer | Michigan | 26087 | 9767 | 215 |
1473590 | 1473590 | 2021-07-01 | Leelanau | Michigan | 26089 | 1243 | 19 |
1473591 | 1473591 | 2021-07-01 | Lenawee | Michigan | 26091 | 10854 | 178 |
1473592 | 1473592 | 2021-07-01 | Livingston | Michigan | 26093 | 16807 | 197 |
1473593 | 1473593 | 2021-07-01 | Luce | Michigan | 26095 | 1339 | 6 |
1473594 | 1473594 | 2021-07-01 | Mackinac | Michigan | 26097 | 716 | 3 |
1473595 | 1473595 | 2021-07-01 | Macomb | Michigan | 26099 | 100663 | 2500 |
1473596 | 1473596 | 2021-07-01 | Manistee | Michigan | 26101 | 1981 | 24 |
1473597 | 1473597 | 2021-07-01 | Marquette | Michigan | 26103 | 5938 | 64 |
1473598 | 1473598 | 2021-07-01 | Mason | Michigan | 26105 | 2140 | 37 |
1473599 | 1473599 | 2021-07-01 | Mecosta | Michigan | 26107 | 3216 | 36 |
1473600 | 1473600 | 2021-07-01 | Menominee | Michigan | 26109 | 2130 | 43 |
1473601 | 1473601 | 2021-07-01 | Midland | Michigan | 26111 | 7577 | 94 |
1473602 | 1473602 | 2021-07-01 | Missaukee | Michigan | 26113 | 1513 | 27 |
1473603 | 1473603 | 2021-07-01 | Monroe | Michigan | 26115 | 15419 | 264 |
1473604 | 1473604 | 2021-07-01 | Montcalm | Michigan | 26117 | 8211 | 120 |
1473605 | 1473605 | 2021-07-01 | Montmorency | Michigan | 26119 | 618 | 20 |
1473606 | 1473606 | 2021-07-01 | Muskegon | Michigan | 26121 | 18432 | 382 |
1473607 | 1473607 | 2021-07-01 | Newaygo | Michigan | 26123 | 4900 | 68 |
1473608 | 1473608 | 2021-07-01 | Oakland | Michigan | 26125 | 118749 | 2446 |
1473609 | 1473609 | 2021-07-01 | Oceana | Michigan | 26127 | 2769 | 60 |
1473610 | 1473610 | 2021-07-01 | Ogemaw | Michigan | 26129 | 1747 | 43 |
1473611 | 1473611 | 2021-07-01 | Ontonagon | Michigan | 26131 | 482 | 21 |
1473612 | 1473612 | 2021-07-01 | Osceola | Michigan | 26133 | 1962 | 31 |
1473613 | 1473613 | 2021-07-01 | Oscoda | Michigan | 26135 | 691 | 31 |
1473614 | 1473614 | 2021-07-01 | Otsego | Michigan | 26137 | 2363 | 41 |
1473615 | 1473615 | 2021-07-01 | Ottawa | Michigan | 26139 | 32941 | 441 |
1473616 | 1473616 | 2021-07-01 | Presque Isle | Michigan | 26141 | 1057 | 34 |
1473617 | 1473617 | 2021-07-01 | Roscommon | Michigan | 26143 | 1900 | 55 |
1473618 | 1473618 | 2021-07-01 | Saginaw | Michigan | 26145 | 22527 | 634 |
1473619 | 1473619 | 2021-07-01 | Sanilac | Michigan | 26151 | 4261 | 125 |
1473620 | 1473620 | 2021-07-01 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1473621 | 1473621 | 2021-07-01 | Shiawassee | Michigan | 26155 | 6438 | 107 |
1473622 | 1473622 | 2021-07-01 | St. Clair | Michigan | 26147 | 18505 | 448 |
1473623 | 1473623 | 2021-07-01 | St. Joseph | Michigan | 26149 | 6256 | 101 |
1473624 | 1473624 | 2021-07-01 | Tuscola | Michigan | 26157 | 5668 | 174 |
1473625 | 1473625 | 2021-07-01 | Unknown | Michigan | 735 | 15 | |
1473626 | 1473626 | 2021-07-01 | Van Buren | Michigan | 26159 | 7147 | 130 |
1473627 | 1473627 | 2021-07-01 | Washtenaw | Michigan | 26161 | 27150 | 310 |
1473628 | 1473628 | 2021-07-01 | Wayne | Michigan | 26163 | 166066 | 5170 |
1473629 | 1473629 | 2021-07-01 | Wexford | Michigan | 26165 | 2902 | 48 |
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);