ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26145 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717208 | 1717208 | 2021-09-14 | Saginaw | Michigan | 26145 | 24611 | 652 |
1713960 | 1713960 | 2021-09-13 | Saginaw | Michigan | 26145 | 24611 | 652 |
1710714 | 1710714 | 2021-09-12 | Saginaw | Michigan | 26145 | 24436 | 652 |
1707467 | 1707467 | 2021-09-11 | Saginaw | Michigan | 26145 | 24436 | 652 |
1704220 | 1704220 | 2021-09-10 | Saginaw | Michigan | 26145 | 24436 | 652 |
1700970 | 1700970 | 2021-09-09 | Saginaw | Michigan | 26145 | 24272 | 649 |
1697721 | 1697721 | 2021-09-08 | Saginaw | Michigan | 26145 | 24272 | 649 |
1694473 | 1694473 | 2021-09-07 | Saginaw | Michigan | 26145 | 24191 | 647 |
1691224 | 1691224 | 2021-09-06 | Saginaw | Michigan | 26145 | 24070 | 647 |
1687974 | 1687974 | 2021-09-05 | Saginaw | Michigan | 26145 | 24070 | 647 |
1684724 | 1684724 | 2021-09-04 | Saginaw | Michigan | 26145 | 24070 | 647 |
1681473 | 1681473 | 2021-09-03 | Saginaw | Michigan | 26145 | 24070 | 647 |
1678225 | 1678225 | 2021-09-02 | Saginaw | Michigan | 26145 | 23960 | 646 |
1674977 | 1674977 | 2021-09-01 | Saginaw | Michigan | 26145 | 23960 | 646 |
1671729 | 1671729 | 2021-08-31 | Saginaw | Michigan | 26145 | 23857 | 646 |
1668482 | 1668482 | 2021-08-30 | Saginaw | Michigan | 26145 | 23857 | 646 |
1665235 | 1665235 | 2021-08-29 | Saginaw | Michigan | 26145 | 23763 | 646 |
1661987 | 1661987 | 2021-08-28 | Saginaw | Michigan | 26145 | 23763 | 646 |
1658739 | 1658739 | 2021-08-27 | Saginaw | Michigan | 26145 | 23763 | 646 |
1655490 | 1655490 | 2021-08-26 | Saginaw | Michigan | 26145 | 23656 | 646 |
1652243 | 1652243 | 2021-08-25 | Saginaw | Michigan | 26145 | 23656 | 646 |
1648995 | 1648995 | 2021-08-24 | Saginaw | Michigan | 26145 | 23554 | 645 |
1645746 | 1645746 | 2021-08-23 | Saginaw | Michigan | 26145 | 23554 | 645 |
1642497 | 1642497 | 2021-08-22 | Saginaw | Michigan | 26145 | 23459 | 645 |
1639247 | 1639247 | 2021-08-21 | Saginaw | Michigan | 26145 | 23459 | 645 |
1635997 | 1635997 | 2021-08-20 | Saginaw | Michigan | 26145 | 23459 | 645 |
1632747 | 1632747 | 2021-08-19 | Saginaw | Michigan | 26145 | 23358 | 645 |
1629500 | 1629500 | 2021-08-18 | Saginaw | Michigan | 26145 | 23358 | 645 |
1626253 | 1626253 | 2021-08-17 | Saginaw | Michigan | 26145 | 23282 | 645 |
1623006 | 1623006 | 2021-08-16 | Saginaw | Michigan | 26145 | 23282 | 645 |
1619759 | 1619759 | 2021-08-15 | Saginaw | Michigan | 26145 | 23199 | 644 |
1616511 | 1616511 | 2021-08-14 | Saginaw | Michigan | 26145 | 23199 | 644 |
1613263 | 1613263 | 2021-08-13 | Saginaw | Michigan | 26145 | 23199 | 644 |
1610014 | 1610014 | 2021-08-12 | Saginaw | Michigan | 26145 | 23123 | 643 |
1606766 | 1606766 | 2021-08-11 | Saginaw | Michigan | 26145 | 23123 | 643 |
1603517 | 1603517 | 2021-08-10 | Saginaw | Michigan | 26145 | 23046 | 643 |
1600268 | 1600268 | 2021-08-09 | Saginaw | Michigan | 26145 | 23046 | 643 |
1597020 | 1597020 | 2021-08-08 | Saginaw | Michigan | 26145 | 22976 | 642 |
1593771 | 1593771 | 2021-08-07 | Saginaw | Michigan | 26145 | 22976 | 642 |
1590522 | 1590522 | 2021-08-06 | Saginaw | Michigan | 26145 | 22976 | 642 |
1587273 | 1587273 | 2021-08-05 | Saginaw | Michigan | 26145 | 22892 | 642 |
1584022 | 1584022 | 2021-08-04 | Saginaw | Michigan | 26145 | 22892 | 642 |
1580773 | 1580773 | 2021-08-03 | Saginaw | Michigan | 26145 | 22892 | 642 |
1577524 | 1577524 | 2021-08-02 | Saginaw | Michigan | 26145 | 22817 | 642 |
1574276 | 1574276 | 2021-08-01 | Saginaw | Michigan | 26145 | 22817 | 642 |
1571028 | 1571028 | 2021-07-31 | Saginaw | Michigan | 26145 | 22817 | 642 |
1567780 | 1567780 | 2021-07-30 | Saginaw | Michigan | 26145 | 22817 | 642 |
1564532 | 1564532 | 2021-07-29 | Saginaw | Michigan | 26145 | 22723 | 642 |
1561284 | 1561284 | 2021-07-28 | Saginaw | Michigan | 26145 | 22723 | 642 |
1558036 | 1558036 | 2021-07-27 | Saginaw | Michigan | 26145 | 22723 | 642 |
1554789 | 1554789 | 2021-07-26 | Saginaw | Michigan | 26145 | 22671 | 640 |
1551542 | 1551542 | 2021-07-25 | Saginaw | Michigan | 26145 | 22671 | 640 |
1548295 | 1548295 | 2021-07-24 | Saginaw | Michigan | 26145 | 22671 | 640 |
1545048 | 1545048 | 2021-07-23 | Saginaw | Michigan | 26145 | 22671 | 640 |
1541800 | 1541800 | 2021-07-22 | Saginaw | Michigan | 26145 | 22625 | 639 |
1538553 | 1538553 | 2021-07-21 | Saginaw | Michigan | 26145 | 22625 | 639 |
1535306 | 1535306 | 2021-07-20 | Saginaw | Michigan | 26145 | 22625 | 639 |
1532058 | 1532058 | 2021-07-19 | Saginaw | Michigan | 26145 | 22594 | 638 |
1528811 | 1528811 | 2021-07-18 | Saginaw | Michigan | 26145 | 22594 | 638 |
1525564 | 1525564 | 2021-07-17 | Saginaw | Michigan | 26145 | 22594 | 638 |
1522317 | 1522317 | 2021-07-16 | Saginaw | Michigan | 26145 | 22594 | 638 |
1519068 | 1519068 | 2021-07-15 | Saginaw | Michigan | 26145 | 22562 | 638 |
1515821 | 1515821 | 2021-07-14 | Saginaw | Michigan | 26145 | 22562 | 638 |
1512575 | 1512575 | 2021-07-13 | Saginaw | Michigan | 26145 | 22562 | 638 |
1509328 | 1509328 | 2021-07-12 | Saginaw | Michigan | 26145 | 22548 | 637 |
1506082 | 1506082 | 2021-07-11 | Saginaw | Michigan | 26145 | 22548 | 637 |
1502836 | 1502836 | 2021-07-10 | Saginaw | Michigan | 26145 | 22548 | 637 |
1499590 | 1499590 | 2021-07-09 | Saginaw | Michigan | 26145 | 22548 | 637 |
1496344 | 1496344 | 2021-07-08 | Saginaw | Michigan | 26145 | 22535 | 634 |
1493097 | 1493097 | 2021-07-07 | Saginaw | Michigan | 26145 | 22535 | 634 |
1489850 | 1489850 | 2021-07-06 | Saginaw | Michigan | 26145 | 22535 | 634 |
1486603 | 1486603 | 2021-07-05 | Saginaw | Michigan | 26145 | 22529 | 634 |
1483357 | 1483357 | 2021-07-04 | Saginaw | Michigan | 26145 | 22529 | 634 |
1480111 | 1480111 | 2021-07-03 | Saginaw | Michigan | 26145 | 22529 | 634 |
1476864 | 1476864 | 2021-07-02 | Saginaw | Michigan | 26145 | 22529 | 634 |
1473618 | 1473618 | 2021-07-01 | Saginaw | Michigan | 26145 | 22527 | 634 |
1470372 | 1470372 | 2021-06-30 | Saginaw | Michigan | 26145 | 22525 | 634 |
1467127 | 1467127 | 2021-06-29 | Saginaw | Michigan | 26145 | 22525 | 634 |
1463882 | 1463882 | 2021-06-28 | Saginaw | Michigan | 26145 | 22521 | 633 |
1460637 | 1460637 | 2021-06-27 | Saginaw | Michigan | 26145 | 22517 | 633 |
1457392 | 1457392 | 2021-06-26 | Saginaw | Michigan | 26145 | 22517 | 633 |
1454147 | 1454147 | 2021-06-25 | Saginaw | Michigan | 26145 | 22517 | 633 |
1450902 | 1450902 | 2021-06-24 | Saginaw | Michigan | 26145 | 22514 | 633 |
1447656 | 1447656 | 2021-06-23 | Saginaw | Michigan | 26145 | 22514 | 631 |
1444411 | 1444411 | 2021-06-22 | Saginaw | Michigan | 26145 | 22503 | 631 |
1441166 | 1441166 | 2021-06-21 | Saginaw | Michigan | 26145 | 22501 | 630 |
1437920 | 1437920 | 2021-06-20 | Saginaw | Michigan | 26145 | 22497 | 630 |
1434673 | 1434673 | 2021-06-19 | Saginaw | Michigan | 26145 | 22497 | 630 |
1431426 | 1431426 | 2021-06-18 | Saginaw | Michigan | 26145 | 22497 | 630 |
1428181 | 1428181 | 2021-06-17 | Saginaw | Michigan | 26145 | 22494 | 629 |
1424936 | 1424936 | 2021-06-16 | Saginaw | Michigan | 26145 | 22490 | 627 |
1421688 | 1421688 | 2021-06-15 | Saginaw | Michigan | 26145 | 22484 | 627 |
1418443 | 1418443 | 2021-06-14 | Saginaw | Michigan | 26145 | 22482 | 627 |
1415198 | 1415198 | 2021-06-13 | Saginaw | Michigan | 26145 | 22474 | 626 |
1411952 | 1411952 | 2021-06-12 | Saginaw | Michigan | 26145 | 22474 | 626 |
1408707 | 1408707 | 2021-06-11 | Saginaw | Michigan | 26145 | 22473 | 622 |
1405462 | 1405462 | 2021-06-10 | Saginaw | Michigan | 26145 | 22471 | 622 |
1402216 | 1402216 | 2021-06-09 | Saginaw | Michigan | 26145 | 22467 | 621 |
1398971 | 1398971 | 2021-06-08 | Saginaw | Michigan | 26145 | 22456 | 620 |
1395725 | 1395725 | 2021-06-07 | Saginaw | Michigan | 26145 | 22450 | 618 |
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);