ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Jayuya" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1841726 | 1841726 | 2021-10-22 | Jayuya | Puerto Rico | 72073 | 650 | |
1838477 | 1838477 | 2021-10-21 | Jayuya | Puerto Rico | 72073 | 650 | |
1835228 | 1835228 | 2021-10-20 | Jayuya | Puerto Rico | 72073 | 650 | |
1831979 | 1831979 | 2021-10-19 | Jayuya | Puerto Rico | 72073 | 650 | |
1828730 | 1828730 | 2021-10-18 | Jayuya | Puerto Rico | 72073 | 650 | |
1825481 | 1825481 | 2021-10-17 | Jayuya | Puerto Rico | 72073 | 650 | |
1822232 | 1822232 | 2021-10-16 | Jayuya | Puerto Rico | 72073 | 648 | |
1818983 | 1818983 | 2021-10-15 | Jayuya | Puerto Rico | 72073 | 647 | |
1815734 | 1815734 | 2021-10-14 | Jayuya | Puerto Rico | 72073 | 647 | |
1812486 | 1812486 | 2021-10-13 | Jayuya | Puerto Rico | 72073 | 647 | |
1809237 | 1809237 | 2021-10-12 | Jayuya | Puerto Rico | 72073 | 647 | |
1805987 | 1805987 | 2021-10-11 | Jayuya | Puerto Rico | 72073 | 647 | |
1802737 | 1802737 | 2021-10-10 | Jayuya | Puerto Rico | 72073 | 645 | |
1799488 | 1799488 | 2021-10-09 | Jayuya | Puerto Rico | 72073 | 645 | |
1796239 | 1796239 | 2021-10-08 | Jayuya | Puerto Rico | 72073 | 645 | |
1792990 | 1792990 | 2021-10-07 | Jayuya | Puerto Rico | 72073 | 644 | |
1789741 | 1789741 | 2021-10-06 | Jayuya | Puerto Rico | 72073 | 644 | |
1786493 | 1786493 | 2021-10-05 | Jayuya | Puerto Rico | 72073 | 643 | |
1783244 | 1783244 | 2021-10-04 | Jayuya | Puerto Rico | 72073 | 643 | |
1779995 | 1779995 | 2021-10-03 | Jayuya | Puerto Rico | 72073 | 643 | |
1776745 | 1776745 | 2021-10-02 | Jayuya | Puerto Rico | 72073 | 643 | |
1773495 | 1773495 | 2021-10-01 | Jayuya | Puerto Rico | 72073 | 643 | |
1770245 | 1770245 | 2021-09-30 | Jayuya | Puerto Rico | 72073 | 643 | |
1766996 | 1766996 | 2021-09-29 | Jayuya | Puerto Rico | 72073 | 641 | |
1763747 | 1763747 | 2021-09-28 | Jayuya | Puerto Rico | 72073 | 641 | |
1760498 | 1760498 | 2021-09-27 | Jayuya | Puerto Rico | 72073 | 641 | |
1757250 | 1757250 | 2021-09-26 | Jayuya | Puerto Rico | 72073 | 639 | |
1754002 | 1754002 | 2021-09-25 | Jayuya | Puerto Rico | 72073 | 639 | |
1750754 | 1750754 | 2021-09-24 | Jayuya | Puerto Rico | 72073 | 639 | |
1747505 | 1747505 | 2021-09-23 | Jayuya | Puerto Rico | 72073 | 639 | |
1744255 | 1744255 | 2021-09-22 | Jayuya | Puerto Rico | 72073 | 639 | |
1741006 | 1741006 | 2021-09-21 | Jayuya | Puerto Rico | 72073 | 639 | |
1737757 | 1737757 | 2021-09-20 | Jayuya | Puerto Rico | 72073 | 639 | |
1734507 | 1734507 | 2021-09-19 | Jayuya | Puerto Rico | 72073 | 639 | |
1731257 | 1731257 | 2021-09-18 | Jayuya | Puerto Rico | 72073 | 638 | |
1728007 | 1728007 | 2021-09-17 | Jayuya | Puerto Rico | 72073 | 637 | |
1724758 | 1724758 | 2021-09-16 | Jayuya | Puerto Rico | 72073 | 637 | |
1721509 | 1721509 | 2021-09-15 | Jayuya | Puerto Rico | 72073 | 636 | |
1718261 | 1718261 | 2021-09-14 | Jayuya | Puerto Rico | 72073 | 635 | |
1715013 | 1715013 | 2021-09-13 | Jayuya | Puerto Rico | 72073 | 634 | |
1711767 | 1711767 | 2021-09-12 | Jayuya | Puerto Rico | 72073 | 633 | |
1708520 | 1708520 | 2021-09-11 | Jayuya | Puerto Rico | 72073 | 633 | |
1705273 | 1705273 | 2021-09-10 | Jayuya | Puerto Rico | 72073 | 632 | |
1702023 | 1702023 | 2021-09-09 | Jayuya | Puerto Rico | 72073 | 630 | |
1698774 | 1698774 | 2021-09-08 | Jayuya | Puerto Rico | 72073 | 630 | |
1695526 | 1695526 | 2021-09-07 | Jayuya | Puerto Rico | 72073 | 630 | |
1692278 | 1692278 | 2021-09-06 | Jayuya | Puerto Rico | 72073 | 630 | |
1689029 | 1689029 | 2021-09-05 | Jayuya | Puerto Rico | 72073 | 630 | |
1685779 | 1685779 | 2021-09-04 | Jayuya | Puerto Rico | 72073 | 630 | |
1682528 | 1682528 | 2021-09-03 | Jayuya | Puerto Rico | 72073 | 630 | |
1679278 | 1679278 | 2021-09-02 | Jayuya | Puerto Rico | 72073 | 628 | |
1676030 | 1676030 | 2021-09-01 | Jayuya | Puerto Rico | 72073 | 628 | |
1672783 | 1672783 | 2021-08-31 | Jayuya | Puerto Rico | 72073 | 625 | |
1669535 | 1669535 | 2021-08-30 | Jayuya | Puerto Rico | 72073 | 625 | |
1666288 | 1666288 | 2021-08-29 | Jayuya | Puerto Rico | 72073 | 625 | |
1663040 | 1663040 | 2021-08-28 | Jayuya | Puerto Rico | 72073 | 623 | |
1659792 | 1659792 | 2021-08-27 | Jayuya | Puerto Rico | 72073 | 623 | |
1656543 | 1656543 | 2021-08-26 | Jayuya | Puerto Rico | 72073 | 623 | |
1653296 | 1653296 | 2021-08-25 | Jayuya | Puerto Rico | 72073 | 622 | |
1650049 | 1650049 | 2021-08-24 | Jayuya | Puerto Rico | 72073 | 622 | |
1646800 | 1646800 | 2021-08-23 | Jayuya | Puerto Rico | 72073 | 622 | |
1643551 | 1643551 | 2021-08-22 | Jayuya | Puerto Rico | 72073 | 622 | |
1640301 | 1640301 | 2021-08-21 | Jayuya | Puerto Rico | 72073 | 621 | |
1637051 | 1637051 | 2021-08-20 | Jayuya | Puerto Rico | 72073 | 619 | |
1633801 | 1633801 | 2021-08-19 | Jayuya | Puerto Rico | 72073 | 619 | |
1630554 | 1630554 | 2021-08-18 | Jayuya | Puerto Rico | 72073 | 619 | |
1627307 | 1627307 | 2021-08-17 | Jayuya | Puerto Rico | 72073 | 619 | |
1624060 | 1624060 | 2021-08-16 | Jayuya | Puerto Rico | 72073 | 619 | |
1620813 | 1620813 | 2021-08-15 | Jayuya | Puerto Rico | 72073 | 619 | |
1617565 | 1617565 | 2021-08-14 | Jayuya | Puerto Rico | 72073 | 617 | |
1614317 | 1614317 | 2021-08-13 | Jayuya | Puerto Rico | 72073 | 617 | |
1611068 | 1611068 | 2021-08-12 | Jayuya | Puerto Rico | 72073 | 614 | |
1607820 | 1607820 | 2021-08-11 | Jayuya | Puerto Rico | 72073 | 610 | |
1604571 | 1604571 | 2021-08-10 | Jayuya | Puerto Rico | 72073 | 610 | |
1601322 | 1601322 | 2021-08-09 | Jayuya | Puerto Rico | 72073 | 610 | |
1598074 | 1598074 | 2021-08-08 | Jayuya | Puerto Rico | 72073 | 606 | |
1594825 | 1594825 | 2021-08-07 | Jayuya | Puerto Rico | 72073 | 605 | |
1591576 | 1591576 | 2021-08-06 | Jayuya | Puerto Rico | 72073 | 605 | |
1588327 | 1588327 | 2021-08-05 | Jayuya | Puerto Rico | 72073 | 605 | |
1585077 | 1585077 | 2021-08-04 | Jayuya | Puerto Rico | 72073 | 604 | |
1581827 | 1581827 | 2021-08-03 | Jayuya | Puerto Rico | 72073 | 603 | |
1578578 | 1578578 | 2021-08-02 | Jayuya | Puerto Rico | 72073 | 602 | |
1575330 | 1575330 | 2021-08-01 | Jayuya | Puerto Rico | 72073 | 602 | |
1572082 | 1572082 | 2021-07-31 | Jayuya | Puerto Rico | 72073 | 602 | |
1568834 | 1568834 | 2021-07-30 | Jayuya | Puerto Rico | 72073 | 601 | |
1565586 | 1565586 | 2021-07-29 | Jayuya | Puerto Rico | 72073 | 601 | |
1562338 | 1562338 | 2021-07-28 | Jayuya | Puerto Rico | 72073 | 601 | |
1559090 | 1559090 | 2021-07-27 | Jayuya | Puerto Rico | 72073 | 601 | |
1555843 | 1555843 | 2021-07-26 | Jayuya | Puerto Rico | 72073 | 601 | |
1552596 | 1552596 | 2021-07-25 | Jayuya | Puerto Rico | 72073 | 600 | |
1549349 | 1549349 | 2021-07-24 | Jayuya | Puerto Rico | 72073 | 598 | |
1546102 | 1546102 | 2021-07-23 | Jayuya | Puerto Rico | 72073 | 597 | |
1542855 | 1542855 | 2021-07-22 | Jayuya | Puerto Rico | 72073 | 596 | |
1539607 | 1539607 | 2021-07-21 | Jayuya | Puerto Rico | 72073 | 596 | |
1536360 | 1536360 | 2021-07-20 | Jayuya | Puerto Rico | 72073 | 596 | |
1533112 | 1533112 | 2021-07-19 | Jayuya | Puerto Rico | 72073 | 596 | |
1529865 | 1529865 | 2021-07-18 | Jayuya | Puerto Rico | 72073 | 596 | |
1526618 | 1526618 | 2021-07-17 | Jayuya | Puerto Rico | 72073 | 596 | |
1523371 | 1523371 | 2021-07-16 | Jayuya | Puerto Rico | 72073 | 595 | |
1520123 | 1520123 | 2021-07-15 | Jayuya | Puerto Rico | 72073 | 595 |
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);