ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
475 rows where deaths = 27 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Missaukee 60
- Hillsdale 42
- Mason 27
- Shiawassee 25
- Tuscola 23
- Arenac 22
- Kalkaska 22
- Roscommon 20
- Branch 19
- Antrim 18
- Livingston 17
- Otsego 16
- Charlevoix 12
- Mecosta 11
- Ontonagon 9
- Ingham 7
- Lake 7
- Osceola 7
- Midland 6
- Unknown 6
- Bay 5
- Cass 5
- Cheboygan 5
- Mackinac 5
- Monroe 5
- Newaygo 5
- Presque Isle 5
- Clare 4
- Ogemaw 4
- Alcona 3
- …
state 1
- Michigan · 475 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217773 | 2217773 | 2022-02-15 | Mackinac | Michigan | 26097 | 2314 | 27 |
2214522 | 2214522 | 2022-02-14 | Mackinac | Michigan | 26097 | 2314 | 27 |
2211270 | 2211270 | 2022-02-13 | Mackinac | Michigan | 26097 | 2312 | 27 |
2208017 | 2208017 | 2022-02-12 | Mackinac | Michigan | 26097 | 2312 | 27 |
2204764 | 2204764 | 2022-02-11 | Mackinac | Michigan | 26097 | 2312 | 27 |
2195034 | 2195034 | 2022-02-08 | Unknown | Michigan | 10260 | 27 | |
2107201 | 2107201 | 2022-01-12 | Unknown | Michigan | 4158 | 27 | |
2081175 | 2081175 | 2022-01-04 | Ontonagon | Michigan | 26131 | 759 | 27 |
2077923 | 2077923 | 2022-01-03 | Ontonagon | Michigan | 26131 | 759 | 27 |
2074672 | 2074672 | 2022-01-02 | Ontonagon | Michigan | 26131 | 752 | 27 |
2071421 | 2071421 | 2022-01-01 | Ontonagon | Michigan | 26131 | 752 | 27 |
2068170 | 2068170 | 2021-12-31 | Ontonagon | Michigan | 26131 | 752 | 27 |
2064919 | 2064919 | 2021-12-30 | Ontonagon | Michigan | 26131 | 752 | 27 |
2061669 | 2061669 | 2021-12-29 | Ontonagon | Michigan | 26131 | 752 | 27 |
2058420 | 2058420 | 2021-12-28 | Ontonagon | Michigan | 26131 | 747 | 27 |
2055171 | 2055171 | 2021-12-27 | Ontonagon | Michigan | 26131 | 747 | 27 |
1990138 | 1990138 | 2021-12-07 | Lake | Michigan | 26085 | 1253 | 27 |
1986888 | 1986888 | 2021-12-06 | Lake | Michigan | 26085 | 1253 | 27 |
1983638 | 1983638 | 2021-12-05 | Lake | Michigan | 26085 | 1225 | 27 |
1980388 | 1980388 | 2021-12-04 | Lake | Michigan | 26085 | 1225 | 27 |
1977138 | 1977138 | 2021-12-03 | Lake | Michigan | 26085 | 1225 | 27 |
1973888 | 1973888 | 2021-12-02 | Lake | Michigan | 26085 | 1206 | 27 |
1970639 | 1970639 | 2021-12-01 | Lake | Michigan | 26085 | 1206 | 27 |
1928381 | 1928381 | 2021-11-18 | Leelanau | Michigan | 26089 | 1916 | 27 |
1925131 | 1925131 | 2021-11-17 | Leelanau | Michigan | 26089 | 1916 | 27 |
1710656 | 1710656 | 2021-09-12 | Charlevoix | Michigan | 26029 | 1979 | 27 |
1707409 | 1707409 | 2021-09-11 | Charlevoix | Michigan | 26029 | 1979 | 27 |
1704162 | 1704162 | 2021-09-10 | Charlevoix | Michigan | 26029 | 1979 | 27 |
1700912 | 1700912 | 2021-09-09 | Charlevoix | Michigan | 26029 | 1976 | 27 |
1697663 | 1697663 | 2021-09-08 | Charlevoix | Michigan | 26029 | 1963 | 27 |
1694415 | 1694415 | 2021-09-07 | Charlevoix | Michigan | 26029 | 1941 | 27 |
1691166 | 1691166 | 2021-09-06 | Charlevoix | Michigan | 26029 | 1940 | 27 |
1687916 | 1687916 | 2021-09-05 | Charlevoix | Michigan | 26029 | 1940 | 27 |
1684666 | 1684666 | 2021-09-04 | Charlevoix | Michigan | 26029 | 1940 | 27 |
1681415 | 1681415 | 2021-09-03 | Charlevoix | Michigan | 26029 | 1940 | 27 |
1678167 | 1678167 | 2021-09-02 | Charlevoix | Michigan | 26029 | 1938 | 27 |
1674919 | 1674919 | 2021-09-01 | Charlevoix | Michigan | 26029 | 1932 | 27 |
1597004 | 1597004 | 2021-08-08 | Missaukee | Michigan | 26113 | 1529 | 27 |
1593755 | 1593755 | 2021-08-07 | Missaukee | Michigan | 26113 | 1529 | 27 |
1590506 | 1590506 | 2021-08-06 | Missaukee | Michigan | 26113 | 1529 | 27 |
1587257 | 1587257 | 2021-08-05 | Missaukee | Michigan | 26113 | 1527 | 27 |
1584006 | 1584006 | 2021-08-04 | Missaukee | Michigan | 26113 | 1527 | 27 |
1580757 | 1580757 | 2021-08-03 | Missaukee | Michigan | 26113 | 1527 | 27 |
1577508 | 1577508 | 2021-08-02 | Missaukee | Michigan | 26113 | 1524 | 27 |
1574260 | 1574260 | 2021-08-01 | Missaukee | Michigan | 26113 | 1524 | 27 |
1571012 | 1571012 | 2021-07-31 | Missaukee | Michigan | 26113 | 1524 | 27 |
1567764 | 1567764 | 2021-07-30 | Missaukee | Michigan | 26113 | 1524 | 27 |
1564516 | 1564516 | 2021-07-29 | Missaukee | Michigan | 26113 | 1523 | 27 |
1561268 | 1561268 | 2021-07-28 | Missaukee | Michigan | 26113 | 1523 | 27 |
1558020 | 1558020 | 2021-07-27 | Missaukee | Michigan | 26113 | 1523 | 27 |
1554773 | 1554773 | 2021-07-26 | Missaukee | Michigan | 26113 | 1522 | 27 |
1551526 | 1551526 | 2021-07-25 | Missaukee | Michigan | 26113 | 1522 | 27 |
1548279 | 1548279 | 2021-07-24 | Missaukee | Michigan | 26113 | 1522 | 27 |
1545032 | 1545032 | 2021-07-23 | Missaukee | Michigan | 26113 | 1522 | 27 |
1541767 | 1541767 | 2021-07-22 | Kalkaska | Michigan | 26079 | 1151 | 27 |
1541784 | 1541784 | 2021-07-22 | Missaukee | Michigan | 26113 | 1520 | 27 |
1538520 | 1538520 | 2021-07-21 | Kalkaska | Michigan | 26079 | 1151 | 27 |
1538537 | 1538537 | 2021-07-21 | Missaukee | Michigan | 26113 | 1520 | 27 |
1535273 | 1535273 | 2021-07-20 | Kalkaska | Michigan | 26079 | 1151 | 27 |
1535290 | 1535290 | 2021-07-20 | Missaukee | Michigan | 26113 | 1520 | 27 |
1532025 | 1532025 | 2021-07-19 | Kalkaska | Michigan | 26079 | 1147 | 27 |
1532042 | 1532042 | 2021-07-19 | Missaukee | Michigan | 26113 | 1519 | 27 |
1528778 | 1528778 | 2021-07-18 | Kalkaska | Michigan | 26079 | 1147 | 27 |
1528795 | 1528795 | 2021-07-18 | Missaukee | Michigan | 26113 | 1519 | 27 |
1525531 | 1525531 | 2021-07-17 | Kalkaska | Michigan | 26079 | 1147 | 27 |
1525548 | 1525548 | 2021-07-17 | Missaukee | Michigan | 26113 | 1519 | 27 |
1522284 | 1522284 | 2021-07-16 | Kalkaska | Michigan | 26079 | 1147 | 27 |
1522301 | 1522301 | 2021-07-16 | Missaukee | Michigan | 26113 | 1519 | 27 |
1519035 | 1519035 | 2021-07-15 | Kalkaska | Michigan | 26079 | 1146 | 27 |
1519052 | 1519052 | 2021-07-15 | Missaukee | Michigan | 26113 | 1518 | 27 |
1515788 | 1515788 | 2021-07-14 | Kalkaska | Michigan | 26079 | 1146 | 27 |
1515805 | 1515805 | 2021-07-14 | Missaukee | Michigan | 26113 | 1518 | 27 |
1512542 | 1512542 | 2021-07-13 | Kalkaska | Michigan | 26079 | 1146 | 27 |
1512559 | 1512559 | 2021-07-13 | Missaukee | Michigan | 26113 | 1518 | 27 |
1509295 | 1509295 | 2021-07-12 | Kalkaska | Michigan | 26079 | 1145 | 27 |
1509312 | 1509312 | 2021-07-12 | Missaukee | Michigan | 26113 | 1517 | 27 |
1506049 | 1506049 | 2021-07-11 | Kalkaska | Michigan | 26079 | 1145 | 27 |
1506066 | 1506066 | 2021-07-11 | Missaukee | Michigan | 26113 | 1517 | 27 |
1502803 | 1502803 | 2021-07-10 | Kalkaska | Michigan | 26079 | 1145 | 27 |
1502820 | 1502820 | 2021-07-10 | Missaukee | Michigan | 26113 | 1517 | 27 |
1499557 | 1499557 | 2021-07-09 | Kalkaska | Michigan | 26079 | 1145 | 27 |
1499574 | 1499574 | 2021-07-09 | Missaukee | Michigan | 26113 | 1517 | 27 |
1496311 | 1496311 | 2021-07-08 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1496328 | 1496328 | 2021-07-08 | Missaukee | Michigan | 26113 | 1515 | 27 |
1493064 | 1493064 | 2021-07-07 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1493081 | 1493081 | 2021-07-07 | Missaukee | Michigan | 26113 | 1515 | 27 |
1489817 | 1489817 | 2021-07-06 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1489834 | 1489834 | 2021-07-06 | Missaukee | Michigan | 26113 | 1515 | 27 |
1486570 | 1486570 | 2021-07-05 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1486587 | 1486587 | 2021-07-05 | Missaukee | Michigan | 26113 | 1513 | 27 |
1483324 | 1483324 | 2021-07-04 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1483341 | 1483341 | 2021-07-04 | Missaukee | Michigan | 26113 | 1513 | 27 |
1480078 | 1480078 | 2021-07-03 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1480095 | 1480095 | 2021-07-03 | Missaukee | Michigan | 26113 | 1513 | 27 |
1476831 | 1476831 | 2021-07-02 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1476848 | 1476848 | 2021-07-02 | Missaukee | Michigan | 26113 | 1513 | 27 |
1473585 | 1473585 | 2021-07-01 | Kalkaska | Michigan | 26079 | 1144 | 27 |
1473602 | 1473602 | 2021-07-01 | Missaukee | Michigan | 26113 | 1513 | 27 |
1470356 | 1470356 | 2021-06-30 | Missaukee | Michigan | 26113 | 1513 | 27 |
1467111 | 1467111 | 2021-06-29 | Missaukee | Michigan | 26113 | 1513 | 27 |
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);