ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72019 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 |
---|---|---|---|---|---|---|---|
1812458 | 1812458 | 2021-10-13 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1809209 | 1809209 | 2021-10-12 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1805959 | 1805959 | 2021-10-11 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1802709 | 1802709 | 2021-10-10 | Barranquitas | Puerto Rico | 72019 | 1843 | |
1799460 | 1799460 | 2021-10-09 | Barranquitas | Puerto Rico | 72019 | 1843 | |
1796211 | 1796211 | 2021-10-08 | Barranquitas | Puerto Rico | 72019 | 1843 | |
1792962 | 1792962 | 2021-10-07 | Barranquitas | Puerto Rico | 72019 | 1841 | |
1789713 | 1789713 | 2021-10-06 | Barranquitas | Puerto Rico | 72019 | 1837 | |
1786465 | 1786465 | 2021-10-05 | Barranquitas | Puerto Rico | 72019 | 1836 | |
1783216 | 1783216 | 2021-10-04 | Barranquitas | Puerto Rico | 72019 | 1835 | |
1779967 | 1779967 | 2021-10-03 | Barranquitas | Puerto Rico | 72019 | 1834 | |
1776717 | 1776717 | 2021-10-02 | Barranquitas | Puerto Rico | 72019 | 1834 | |
1773467 | 1773467 | 2021-10-01 | Barranquitas | Puerto Rico | 72019 | 1833 | |
1770217 | 1770217 | 2021-09-30 | Barranquitas | Puerto Rico | 72019 | 1833 | |
1766968 | 1766968 | 2021-09-29 | Barranquitas | Puerto Rico | 72019 | 1832 | |
1763719 | 1763719 | 2021-09-28 | Barranquitas | Puerto Rico | 72019 | 1830 | |
1760470 | 1760470 | 2021-09-27 | Barranquitas | Puerto Rico | 72019 | 1830 | |
1757222 | 1757222 | 2021-09-26 | Barranquitas | Puerto Rico | 72019 | 1830 | |
1753974 | 1753974 | 2021-09-25 | Barranquitas | Puerto Rico | 72019 | 1830 | |
1750726 | 1750726 | 2021-09-24 | Barranquitas | Puerto Rico | 72019 | 1829 | |
1747477 | 1747477 | 2021-09-23 | Barranquitas | Puerto Rico | 72019 | 1828 | |
1744227 | 1744227 | 2021-09-22 | Barranquitas | Puerto Rico | 72019 | 1828 | |
1740978 | 1740978 | 2021-09-21 | Barranquitas | Puerto Rico | 72019 | 1825 | |
1737729 | 1737729 | 2021-09-20 | Barranquitas | Puerto Rico | 72019 | 1825 | |
1734479 | 1734479 | 2021-09-19 | Barranquitas | Puerto Rico | 72019 | 1825 | |
1731229 | 1731229 | 2021-09-18 | Barranquitas | Puerto Rico | 72019 | 1817 | |
1727979 | 1727979 | 2021-09-17 | Barranquitas | Puerto Rico | 72019 | 1815 | |
1724730 | 1724730 | 2021-09-16 | Barranquitas | Puerto Rico | 72019 | 1813 | |
1721481 | 1721481 | 2021-09-15 | Barranquitas | Puerto Rico | 72019 | 1812 | |
1718233 | 1718233 | 2021-09-14 | Barranquitas | Puerto Rico | 72019 | 1802 | |
1714985 | 1714985 | 2021-09-13 | Barranquitas | Puerto Rico | 72019 | 1802 | |
1711739 | 1711739 | 2021-09-12 | Barranquitas | Puerto Rico | 72019 | 1798 | |
1708492 | 1708492 | 2021-09-11 | Barranquitas | Puerto Rico | 72019 | 1796 | |
1705245 | 1705245 | 2021-09-10 | Barranquitas | Puerto Rico | 72019 | 1792 | |
1701995 | 1701995 | 2021-09-09 | Barranquitas | Puerto Rico | 72019 | 1787 | |
1698746 | 1698746 | 2021-09-08 | Barranquitas | Puerto Rico | 72019 | 1787 | |
1695498 | 1695498 | 2021-09-07 | Barranquitas | Puerto Rico | 72019 | 1786 | |
1692250 | 1692250 | 2021-09-06 | Barranquitas | Puerto Rico | 72019 | 1786 | |
1689001 | 1689001 | 2021-09-05 | Barranquitas | Puerto Rico | 72019 | 1785 | |
1685751 | 1685751 | 2021-09-04 | Barranquitas | Puerto Rico | 72019 | 1781 | |
1682500 | 1682500 | 2021-09-03 | Barranquitas | Puerto Rico | 72019 | 1778 | |
1679250 | 1679250 | 2021-09-02 | Barranquitas | Puerto Rico | 72019 | 1773 | |
1676002 | 1676002 | 2021-09-01 | Barranquitas | Puerto Rico | 72019 | 1772 | |
1672755 | 1672755 | 2021-08-31 | Barranquitas | Puerto Rico | 72019 | 1769 | |
1669507 | 1669507 | 2021-08-30 | Barranquitas | Puerto Rico | 72019 | 1767 | |
1666260 | 1666260 | 2021-08-29 | Barranquitas | Puerto Rico | 72019 | 1761 | |
1663012 | 1663012 | 2021-08-28 | Barranquitas | Puerto Rico | 72019 | 1757 | |
1659764 | 1659764 | 2021-08-27 | Barranquitas | Puerto Rico | 72019 | 1750 | |
1656515 | 1656515 | 2021-08-26 | Barranquitas | Puerto Rico | 72019 | 1744 | |
1653268 | 1653268 | 2021-08-25 | Barranquitas | Puerto Rico | 72019 | 1733 | |
1650021 | 1650021 | 2021-08-24 | Barranquitas | Puerto Rico | 72019 | 1729 | |
1646772 | 1646772 | 2021-08-23 | Barranquitas | Puerto Rico | 72019 | 1728 | |
1643523 | 1643523 | 2021-08-22 | Barranquitas | Puerto Rico | 72019 | 1725 | |
1640273 | 1640273 | 2021-08-21 | Barranquitas | Puerto Rico | 72019 | 1719 | |
1637023 | 1637023 | 2021-08-20 | Barranquitas | Puerto Rico | 72019 | 1710 | |
1633773 | 1633773 | 2021-08-19 | Barranquitas | Puerto Rico | 72019 | 1708 | |
1630526 | 1630526 | 2021-08-18 | Barranquitas | Puerto Rico | 72019 | 1705 | |
1627279 | 1627279 | 2021-08-17 | Barranquitas | Puerto Rico | 72019 | 1703 | |
1624032 | 1624032 | 2021-08-16 | Barranquitas | Puerto Rico | 72019 | 1699 | |
1620785 | 1620785 | 2021-08-15 | Barranquitas | Puerto Rico | 72019 | 1697 | |
1617537 | 1617537 | 2021-08-14 | Barranquitas | Puerto Rico | 72019 | 1694 | |
1614289 | 1614289 | 2021-08-13 | Barranquitas | Puerto Rico | 72019 | 1693 | |
1611040 | 1611040 | 2021-08-12 | Barranquitas | Puerto Rico | 72019 | 1688 | |
1607792 | 1607792 | 2021-08-11 | Barranquitas | Puerto Rico | 72019 | 1684 | |
1604543 | 1604543 | 2021-08-10 | Barranquitas | Puerto Rico | 72019 | 1680 | |
1601294 | 1601294 | 2021-08-09 | Barranquitas | Puerto Rico | 72019 | 1679 | |
1598046 | 1598046 | 2021-08-08 | Barranquitas | Puerto Rico | 72019 | 1676 | |
1594797 | 1594797 | 2021-08-07 | Barranquitas | Puerto Rico | 72019 | 1671 | |
1591548 | 1591548 | 2021-08-06 | Barranquitas | Puerto Rico | 72019 | 1666 | |
1588299 | 1588299 | 2021-08-05 | Barranquitas | Puerto Rico | 72019 | 1665 | |
1585049 | 1585049 | 2021-08-04 | Barranquitas | Puerto Rico | 72019 | 1656 | |
1581799 | 1581799 | 2021-08-03 | Barranquitas | Puerto Rico | 72019 | 1654 | |
1578550 | 1578550 | 2021-08-02 | Barranquitas | Puerto Rico | 72019 | 1654 | |
1575302 | 1575302 | 2021-08-01 | Barranquitas | Puerto Rico | 72019 | 1652 | |
1572054 | 1572054 | 2021-07-31 | Barranquitas | Puerto Rico | 72019 | 1650 | |
1568806 | 1568806 | 2021-07-30 | Barranquitas | Puerto Rico | 72019 | 1643 | |
1565558 | 1565558 | 2021-07-29 | Barranquitas | Puerto Rico | 72019 | 1638 | |
1562310 | 1562310 | 2021-07-28 | Barranquitas | Puerto Rico | 72019 | 1634 | |
1559062 | 1559062 | 2021-07-27 | Barranquitas | Puerto Rico | 72019 | 1632 | |
1555815 | 1555815 | 2021-07-26 | Barranquitas | Puerto Rico | 72019 | 1631 | |
1552568 | 1552568 | 2021-07-25 | Barranquitas | Puerto Rico | 72019 | 1631 | |
1549321 | 1549321 | 2021-07-24 | Barranquitas | Puerto Rico | 72019 | 1628 | |
1546074 | 1546074 | 2021-07-23 | Barranquitas | Puerto Rico | 72019 | 1628 | |
1542827 | 1542827 | 2021-07-22 | Barranquitas | Puerto Rico | 72019 | 1626 | |
1539579 | 1539579 | 2021-07-21 | Barranquitas | Puerto Rico | 72019 | 1624 | |
1536332 | 1536332 | 2021-07-20 | Barranquitas | Puerto Rico | 72019 | 1623 | |
1533084 | 1533084 | 2021-07-19 | Barranquitas | Puerto Rico | 72019 | 1621 | |
1529837 | 1529837 | 2021-07-18 | Barranquitas | Puerto Rico | 72019 | 1620 | |
1526590 | 1526590 | 2021-07-17 | Barranquitas | Puerto Rico | 72019 | 1620 | |
1523343 | 1523343 | 2021-07-16 | Barranquitas | Puerto Rico | 72019 | 1618 | |
1520095 | 1520095 | 2021-07-15 | Barranquitas | Puerto Rico | 72019 | 1618 | |
1516847 | 1516847 | 2021-07-14 | Barranquitas | Puerto Rico | 72019 | 1617 | |
1513600 | 1513600 | 2021-07-13 | Barranquitas | Puerto Rico | 72019 | 1617 | |
1510354 | 1510354 | 2021-07-12 | Barranquitas | Puerto Rico | 72019 | 1616 | |
1507107 | 1507107 | 2021-07-11 | Barranquitas | Puerto Rico | 72019 | 1616 | |
1503861 | 1503861 | 2021-07-10 | Barranquitas | Puerto Rico | 72019 | 1615 | |
1500615 | 1500615 | 2021-07-09 | Barranquitas | Puerto Rico | 72019 | 1615 | |
1497369 | 1497369 | 2021-07-08 | Barranquitas | Puerto Rico | 72019 | 1615 | |
1494122 | 1494122 | 2021-07-07 | Barranquitas | Puerto Rico | 72019 | 1615 | |
1490875 | 1490875 | 2021-07-06 | Barranquitas | Puerto Rico | 72019 | 1615 |
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);