ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72101 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 |
---|---|---|---|---|---|---|---|
1841740 | 1841740 | 2021-10-22 | Morovis | Puerto Rico | 72101 | 1977 | |
1838491 | 1838491 | 2021-10-21 | Morovis | Puerto Rico | 72101 | 1977 | |
1835242 | 1835242 | 2021-10-20 | Morovis | Puerto Rico | 72101 | 1975 | |
1831993 | 1831993 | 2021-10-19 | Morovis | Puerto Rico | 72101 | 1975 | |
1828744 | 1828744 | 2021-10-18 | Morovis | Puerto Rico | 72101 | 1975 | |
1825495 | 1825495 | 2021-10-17 | Morovis | Puerto Rico | 72101 | 1975 | |
1822246 | 1822246 | 2021-10-16 | Morovis | Puerto Rico | 72101 | 1975 | |
1818997 | 1818997 | 2021-10-15 | Morovis | Puerto Rico | 72101 | 1975 | |
1815748 | 1815748 | 2021-10-14 | Morovis | Puerto Rico | 72101 | 1975 | |
1812500 | 1812500 | 2021-10-13 | Morovis | Puerto Rico | 72101 | 1975 | |
1809251 | 1809251 | 2021-10-12 | Morovis | Puerto Rico | 72101 | 1975 | |
1806001 | 1806001 | 2021-10-11 | Morovis | Puerto Rico | 72101 | 1975 | |
1802751 | 1802751 | 2021-10-10 | Morovis | Puerto Rico | 72101 | 1973 | |
1799502 | 1799502 | 2021-10-09 | Morovis | Puerto Rico | 72101 | 1973 | |
1796253 | 1796253 | 2021-10-08 | Morovis | Puerto Rico | 72101 | 1973 | |
1793004 | 1793004 | 2021-10-07 | Morovis | Puerto Rico | 72101 | 1972 | |
1789755 | 1789755 | 2021-10-06 | Morovis | Puerto Rico | 72101 | 1971 | |
1786507 | 1786507 | 2021-10-05 | Morovis | Puerto Rico | 72101 | 1967 | |
1783258 | 1783258 | 2021-10-04 | Morovis | Puerto Rico | 72101 | 1967 | |
1780009 | 1780009 | 2021-10-03 | Morovis | Puerto Rico | 72101 | 1967 | |
1776759 | 1776759 | 2021-10-02 | Morovis | Puerto Rico | 72101 | 1966 | |
1773509 | 1773509 | 2021-10-01 | Morovis | Puerto Rico | 72101 | 1965 | |
1770259 | 1770259 | 2021-09-30 | Morovis | Puerto Rico | 72101 | 1964 | |
1767010 | 1767010 | 2021-09-29 | Morovis | Puerto Rico | 72101 | 1962 | |
1763761 | 1763761 | 2021-09-28 | Morovis | Puerto Rico | 72101 | 1958 | |
1760512 | 1760512 | 2021-09-27 | Morovis | Puerto Rico | 72101 | 1958 | |
1757264 | 1757264 | 2021-09-26 | Morovis | Puerto Rico | 72101 | 1957 | |
1754016 | 1754016 | 2021-09-25 | Morovis | Puerto Rico | 72101 | 1956 | |
1750768 | 1750768 | 2021-09-24 | Morovis | Puerto Rico | 72101 | 1956 | |
1747519 | 1747519 | 2021-09-23 | Morovis | Puerto Rico | 72101 | 1956 | |
1744269 | 1744269 | 2021-09-22 | Morovis | Puerto Rico | 72101 | 1956 | |
1741020 | 1741020 | 2021-09-21 | Morovis | Puerto Rico | 72101 | 1954 | |
1737771 | 1737771 | 2021-09-20 | Morovis | Puerto Rico | 72101 | 1954 | |
1734521 | 1734521 | 2021-09-19 | Morovis | Puerto Rico | 72101 | 1953 | |
1731271 | 1731271 | 2021-09-18 | Morovis | Puerto Rico | 72101 | 1953 | |
1728021 | 1728021 | 2021-09-17 | Morovis | Puerto Rico | 72101 | 1951 | |
1724772 | 1724772 | 2021-09-16 | Morovis | Puerto Rico | 72101 | 1950 | |
1721523 | 1721523 | 2021-09-15 | Morovis | Puerto Rico | 72101 | 1949 | |
1718275 | 1718275 | 2021-09-14 | Morovis | Puerto Rico | 72101 | 1945 | |
1715027 | 1715027 | 2021-09-13 | Morovis | Puerto Rico | 72101 | 1945 | |
1711781 | 1711781 | 2021-09-12 | Morovis | Puerto Rico | 72101 | 1944 | |
1708534 | 1708534 | 2021-09-11 | Morovis | Puerto Rico | 72101 | 1939 | |
1705287 | 1705287 | 2021-09-10 | Morovis | Puerto Rico | 72101 | 1937 | |
1702037 | 1702037 | 2021-09-09 | Morovis | Puerto Rico | 72101 | 1928 | |
1698788 | 1698788 | 2021-09-08 | Morovis | Puerto Rico | 72101 | 1929 | |
1695540 | 1695540 | 2021-09-07 | Morovis | Puerto Rico | 72101 | 1928 | |
1692292 | 1692292 | 2021-09-06 | Morovis | Puerto Rico | 72101 | 1928 | |
1689043 | 1689043 | 2021-09-05 | Morovis | Puerto Rico | 72101 | 1925 | |
1685793 | 1685793 | 2021-09-04 | Morovis | Puerto Rico | 72101 | 1920 | |
1682542 | 1682542 | 2021-09-03 | Morovis | Puerto Rico | 72101 | 1917 | |
1679292 | 1679292 | 2021-09-02 | Morovis | Puerto Rico | 72101 | 1913 | |
1676044 | 1676044 | 2021-09-01 | Morovis | Puerto Rico | 72101 | 1910 | |
1672797 | 1672797 | 2021-08-31 | Morovis | Puerto Rico | 72101 | 1893 | |
1669549 | 1669549 | 2021-08-30 | Morovis | Puerto Rico | 72101 | 1892 | |
1666302 | 1666302 | 2021-08-29 | Morovis | Puerto Rico | 72101 | 1888 | |
1663054 | 1663054 | 2021-08-28 | Morovis | Puerto Rico | 72101 | 1885 | |
1659806 | 1659806 | 2021-08-27 | Morovis | Puerto Rico | 72101 | 1883 | |
1656557 | 1656557 | 2021-08-26 | Morovis | Puerto Rico | 72101 | 1880 | |
1653310 | 1653310 | 2021-08-25 | Morovis | Puerto Rico | 72101 | 1877 | |
1650063 | 1650063 | 2021-08-24 | Morovis | Puerto Rico | 72101 | 1876 | |
1646814 | 1646814 | 2021-08-23 | Morovis | Puerto Rico | 72101 | 1876 | |
1643565 | 1643565 | 2021-08-22 | Morovis | Puerto Rico | 72101 | 1872 | |
1640315 | 1640315 | 2021-08-21 | Morovis | Puerto Rico | 72101 | 1865 | |
1637065 | 1637065 | 2021-08-20 | Morovis | Puerto Rico | 72101 | 1849 | |
1633815 | 1633815 | 2021-08-19 | Morovis | Puerto Rico | 72101 | 1845 | |
1630568 | 1630568 | 2021-08-18 | Morovis | Puerto Rico | 72101 | 1844 | |
1627321 | 1627321 | 2021-08-17 | Morovis | Puerto Rico | 72101 | 1841 | |
1624074 | 1624074 | 2021-08-16 | Morovis | Puerto Rico | 72101 | 1839 | |
1620827 | 1620827 | 2021-08-15 | Morovis | Puerto Rico | 72101 | 1836 | |
1617579 | 1617579 | 2021-08-14 | Morovis | Puerto Rico | 72101 | 1826 | |
1614331 | 1614331 | 2021-08-13 | Morovis | Puerto Rico | 72101 | 1822 | |
1611082 | 1611082 | 2021-08-12 | Morovis | Puerto Rico | 72101 | 1815 | |
1607834 | 1607834 | 2021-08-11 | Morovis | Puerto Rico | 72101 | 1806 | |
1604585 | 1604585 | 2021-08-10 | Morovis | Puerto Rico | 72101 | 1802 | |
1601336 | 1601336 | 2021-08-09 | Morovis | Puerto Rico | 72101 | 1800 | |
1598088 | 1598088 | 2021-08-08 | Morovis | Puerto Rico | 72101 | 1798 | |
1594839 | 1594839 | 2021-08-07 | Morovis | Puerto Rico | 72101 | 1791 | |
1591590 | 1591590 | 2021-08-06 | Morovis | Puerto Rico | 72101 | 1790 | |
1588341 | 1588341 | 2021-08-05 | Morovis | Puerto Rico | 72101 | 1786 | |
1585091 | 1585091 | 2021-08-04 | Morovis | Puerto Rico | 72101 | 1782 | |
1581841 | 1581841 | 2021-08-03 | Morovis | Puerto Rico | 72101 | 1777 | |
1578592 | 1578592 | 2021-08-02 | Morovis | Puerto Rico | 72101 | 1777 | |
1575344 | 1575344 | 2021-08-01 | Morovis | Puerto Rico | 72101 | 1773 | |
1572096 | 1572096 | 2021-07-31 | Morovis | Puerto Rico | 72101 | 1773 | |
1568848 | 1568848 | 2021-07-30 | Morovis | Puerto Rico | 72101 | 1770 | |
1565600 | 1565600 | 2021-07-29 | Morovis | Puerto Rico | 72101 | 1767 | |
1562352 | 1562352 | 2021-07-28 | Morovis | Puerto Rico | 72101 | 1766 | |
1559104 | 1559104 | 2021-07-27 | Morovis | Puerto Rico | 72101 | 1765 | |
1555857 | 1555857 | 2021-07-26 | Morovis | Puerto Rico | 72101 | 1765 | |
1552610 | 1552610 | 2021-07-25 | Morovis | Puerto Rico | 72101 | 1762 | |
1549363 | 1549363 | 2021-07-24 | Morovis | Puerto Rico | 72101 | 1760 | |
1546116 | 1546116 | 2021-07-23 | Morovis | Puerto Rico | 72101 | 1760 | |
1542869 | 1542869 | 2021-07-22 | Morovis | Puerto Rico | 72101 | 1750 | |
1539621 | 1539621 | 2021-07-21 | Morovis | Puerto Rico | 72101 | 1749 | |
1536374 | 1536374 | 2021-07-20 | Morovis | Puerto Rico | 72101 | 1749 | |
1533126 | 1533126 | 2021-07-19 | Morovis | Puerto Rico | 72101 | 1749 | |
1529879 | 1529879 | 2021-07-18 | Morovis | Puerto Rico | 72101 | 1749 | |
1526632 | 1526632 | 2021-07-17 | Morovis | Puerto Rico | 72101 | 1749 | |
1523385 | 1523385 | 2021-07-16 | Morovis | Puerto Rico | 72101 | 1749 | |
1520137 | 1520137 | 2021-07-15 | Morovis | Puerto Rico | 72101 | 1749 |
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);