ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 26053 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717162 | 1717162 | 2021-09-14 | Gogebic | Michigan | 26053 | 1567 | 53 |
1713914 | 1713914 | 2021-09-13 | Gogebic | Michigan | 26053 | 1567 | 53 |
1710668 | 1710668 | 2021-09-12 | Gogebic | Michigan | 26053 | 1561 | 53 |
1707421 | 1707421 | 2021-09-11 | Gogebic | Michigan | 26053 | 1561 | 53 |
1704174 | 1704174 | 2021-09-10 | Gogebic | Michigan | 26053 | 1561 | 53 |
1700924 | 1700924 | 2021-09-09 | Gogebic | Michigan | 26053 | 1549 | 53 |
1697675 | 1697675 | 2021-09-08 | Gogebic | Michigan | 26053 | 1549 | 53 |
1694427 | 1694427 | 2021-09-07 | Gogebic | Michigan | 26053 | 1547 | 53 |
1691178 | 1691178 | 2021-09-06 | Gogebic | Michigan | 26053 | 1536 | 53 |
1687928 | 1687928 | 2021-09-05 | Gogebic | Michigan | 26053 | 1536 | 53 |
1684678 | 1684678 | 2021-09-04 | Gogebic | Michigan | 26053 | 1536 | 53 |
1681427 | 1681427 | 2021-09-03 | Gogebic | Michigan | 26053 | 1536 | 53 |
1678179 | 1678179 | 2021-09-02 | Gogebic | Michigan | 26053 | 1530 | 53 |
1674931 | 1674931 | 2021-09-01 | Gogebic | Michigan | 26053 | 1530 | 53 |
1671683 | 1671683 | 2021-08-31 | Gogebic | Michigan | 26053 | 1526 | 53 |
1668436 | 1668436 | 2021-08-30 | Gogebic | Michigan | 26053 | 1526 | 53 |
1665189 | 1665189 | 2021-08-29 | Gogebic | Michigan | 26053 | 1518 | 53 |
1661941 | 1661941 | 2021-08-28 | Gogebic | Michigan | 26053 | 1518 | 53 |
1658693 | 1658693 | 2021-08-27 | Gogebic | Michigan | 26053 | 1518 | 53 |
1655444 | 1655444 | 2021-08-26 | Gogebic | Michigan | 26053 | 1517 | 53 |
1652197 | 1652197 | 2021-08-25 | Gogebic | Michigan | 26053 | 1517 | 53 |
1648949 | 1648949 | 2021-08-24 | Gogebic | Michigan | 26053 | 1508 | 53 |
1645700 | 1645700 | 2021-08-23 | Gogebic | Michigan | 26053 | 1508 | 53 |
1642451 | 1642451 | 2021-08-22 | Gogebic | Michigan | 26053 | 1505 | 53 |
1639201 | 1639201 | 2021-08-21 | Gogebic | Michigan | 26053 | 1505 | 53 |
1635951 | 1635951 | 2021-08-20 | Gogebic | Michigan | 26053 | 1505 | 53 |
1632701 | 1632701 | 2021-08-19 | Gogebic | Michigan | 26053 | 1509 | 53 |
1629454 | 1629454 | 2021-08-18 | Gogebic | Michigan | 26053 | 1509 | 53 |
1626207 | 1626207 | 2021-08-17 | Gogebic | Michigan | 26053 | 1492 | 53 |
1622960 | 1622960 | 2021-08-16 | Gogebic | Michigan | 26053 | 1492 | 53 |
1619713 | 1619713 | 2021-08-15 | Gogebic | Michigan | 26053 | 1490 | 53 |
1616465 | 1616465 | 2021-08-14 | Gogebic | Michigan | 26053 | 1490 | 53 |
1613217 | 1613217 | 2021-08-13 | Gogebic | Michigan | 26053 | 1490 | 53 |
1609968 | 1609968 | 2021-08-12 | Gogebic | Michigan | 26053 | 1483 | 53 |
1606720 | 1606720 | 2021-08-11 | Gogebic | Michigan | 26053 | 1483 | 53 |
1603471 | 1603471 | 2021-08-10 | Gogebic | Michigan | 26053 | 1475 | 53 |
1600222 | 1600222 | 2021-08-09 | Gogebic | Michigan | 26053 | 1475 | 53 |
1596974 | 1596974 | 2021-08-08 | Gogebic | Michigan | 26053 | 1470 | 53 |
1593725 | 1593725 | 2021-08-07 | Gogebic | Michigan | 26053 | 1470 | 53 |
1590476 | 1590476 | 2021-08-06 | Gogebic | Michigan | 26053 | 1470 | 53 |
1587227 | 1587227 | 2021-08-05 | Gogebic | Michigan | 26053 | 1457 | 53 |
1583976 | 1583976 | 2021-08-04 | Gogebic | Michigan | 26053 | 1457 | 53 |
1580727 | 1580727 | 2021-08-03 | Gogebic | Michigan | 26053 | 1457 | 53 |
1577478 | 1577478 | 2021-08-02 | Gogebic | Michigan | 26053 | 1449 | 53 |
1574230 | 1574230 | 2021-08-01 | Gogebic | Michigan | 26053 | 1449 | 53 |
1570982 | 1570982 | 2021-07-31 | Gogebic | Michigan | 26053 | 1449 | 53 |
1567734 | 1567734 | 2021-07-30 | Gogebic | Michigan | 26053 | 1449 | 53 |
1564486 | 1564486 | 2021-07-29 | Gogebic | Michigan | 26053 | 1447 | 53 |
1561238 | 1561238 | 2021-07-28 | Gogebic | Michigan | 26053 | 1447 | 53 |
1557990 | 1557990 | 2021-07-27 | Gogebic | Michigan | 26053 | 1447 | 53 |
1554743 | 1554743 | 2021-07-26 | Gogebic | Michigan | 26053 | 1444 | 53 |
1551496 | 1551496 | 2021-07-25 | Gogebic | Michigan | 26053 | 1444 | 53 |
1548249 | 1548249 | 2021-07-24 | Gogebic | Michigan | 26053 | 1444 | 53 |
1545002 | 1545002 | 2021-07-23 | Gogebic | Michigan | 26053 | 1444 | 53 |
1541754 | 1541754 | 2021-07-22 | Gogebic | Michigan | 26053 | 1444 | 53 |
1538507 | 1538507 | 2021-07-21 | Gogebic | Michigan | 26053 | 1444 | 53 |
1535260 | 1535260 | 2021-07-20 | Gogebic | Michigan | 26053 | 1444 | 53 |
1532012 | 1532012 | 2021-07-19 | Gogebic | Michigan | 26053 | 1437 | 52 |
1528765 | 1528765 | 2021-07-18 | Gogebic | Michigan | 26053 | 1437 | 52 |
1525518 | 1525518 | 2021-07-17 | Gogebic | Michigan | 26053 | 1437 | 52 |
1522271 | 1522271 | 2021-07-16 | Gogebic | Michigan | 26053 | 1437 | 52 |
1519022 | 1519022 | 2021-07-15 | Gogebic | Michigan | 26053 | 1425 | 52 |
1515775 | 1515775 | 2021-07-14 | Gogebic | Michigan | 26053 | 1425 | 52 |
1512529 | 1512529 | 2021-07-13 | Gogebic | Michigan | 26053 | 1425 | 52 |
1509282 | 1509282 | 2021-07-12 | Gogebic | Michigan | 26053 | 1416 | 52 |
1506036 | 1506036 | 2021-07-11 | Gogebic | Michigan | 26053 | 1416 | 52 |
1502790 | 1502790 | 2021-07-10 | Gogebic | Michigan | 26053 | 1416 | 52 |
1499544 | 1499544 | 2021-07-09 | Gogebic | Michigan | 26053 | 1416 | 52 |
1496298 | 1496298 | 2021-07-08 | Gogebic | Michigan | 26053 | 1411 | 52 |
1493051 | 1493051 | 2021-07-07 | Gogebic | Michigan | 26053 | 1411 | 52 |
1489804 | 1489804 | 2021-07-06 | Gogebic | Michigan | 26053 | 1411 | 52 |
1486557 | 1486557 | 2021-07-05 | Gogebic | Michigan | 26053 | 1406 | 52 |
1483311 | 1483311 | 2021-07-04 | Gogebic | Michigan | 26053 | 1406 | 52 |
1480065 | 1480065 | 2021-07-03 | Gogebic | Michigan | 26053 | 1406 | 52 |
1476818 | 1476818 | 2021-07-02 | Gogebic | Michigan | 26053 | 1406 | 52 |
1473572 | 1473572 | 2021-07-01 | Gogebic | Michigan | 26053 | 1406 | 52 |
1470326 | 1470326 | 2021-06-30 | Gogebic | Michigan | 26053 | 1406 | 52 |
1467081 | 1467081 | 2021-06-29 | Gogebic | Michigan | 26053 | 1405 | 52 |
1463836 | 1463836 | 2021-06-28 | Gogebic | Michigan | 26053 | 1405 | 52 |
1460591 | 1460591 | 2021-06-27 | Gogebic | Michigan | 26053 | 1405 | 52 |
1457346 | 1457346 | 2021-06-26 | Gogebic | Michigan | 26053 | 1405 | 52 |
1454101 | 1454101 | 2021-06-25 | Gogebic | Michigan | 26053 | 1405 | 52 |
1450856 | 1450856 | 2021-06-24 | Gogebic | Michigan | 26053 | 1405 | 52 |
1447610 | 1447610 | 2021-06-23 | Gogebic | Michigan | 26053 | 1405 | 52 |
1444365 | 1444365 | 2021-06-22 | Gogebic | Michigan | 26053 | 1405 | 52 |
1441120 | 1441120 | 2021-06-21 | Gogebic | Michigan | 26053 | 1405 | 52 |
1437874 | 1437874 | 2021-06-20 | Gogebic | Michigan | 26053 | 1405 | 52 |
1434627 | 1434627 | 2021-06-19 | Gogebic | Michigan | 26053 | 1405 | 52 |
1431380 | 1431380 | 2021-06-18 | Gogebic | Michigan | 26053 | 1405 | 52 |
1428135 | 1428135 | 2021-06-17 | Gogebic | Michigan | 26053 | 1405 | 52 |
1424890 | 1424890 | 2021-06-16 | Gogebic | Michigan | 26053 | 1405 | 52 |
1421642 | 1421642 | 2021-06-15 | Gogebic | Michigan | 26053 | 1405 | 52 |
1418397 | 1418397 | 2021-06-14 | Gogebic | Michigan | 26053 | 1405 | 51 |
1415152 | 1415152 | 2021-06-13 | Gogebic | Michigan | 26053 | 1405 | 51 |
1411906 | 1411906 | 2021-06-12 | Gogebic | Michigan | 26053 | 1405 | 51 |
1408661 | 1408661 | 2021-06-11 | Gogebic | Michigan | 26053 | 1405 | 51 |
1405416 | 1405416 | 2021-06-10 | Gogebic | Michigan | 26053 | 1404 | 51 |
1402170 | 1402170 | 2021-06-09 | Gogebic | Michigan | 26053 | 1404 | 51 |
1398925 | 1398925 | 2021-06-08 | Gogebic | Michigan | 26053 | 1404 | 51 |
1395679 | 1395679 | 2021-06-07 | Gogebic | Michigan | 26053 | 1404 | 50 |
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);