ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Fajardo" 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 |
---|---|---|---|---|---|---|---|
1812475 | 1812475 | 2021-10-13 | Fajardo | Puerto Rico | 72053 | 2158 | |
1809226 | 1809226 | 2021-10-12 | Fajardo | Puerto Rico | 72053 | 2158 | |
1805976 | 1805976 | 2021-10-11 | Fajardo | Puerto Rico | 72053 | 2158 | |
1802726 | 1802726 | 2021-10-10 | Fajardo | Puerto Rico | 72053 | 2154 | |
1799477 | 1799477 | 2021-10-09 | Fajardo | Puerto Rico | 72053 | 2154 | |
1796228 | 1796228 | 2021-10-08 | Fajardo | Puerto Rico | 72053 | 2148 | |
1792979 | 1792979 | 2021-10-07 | Fajardo | Puerto Rico | 72053 | 2145 | |
1789730 | 1789730 | 2021-10-06 | Fajardo | Puerto Rico | 72053 | 2140 | |
1786482 | 1786482 | 2021-10-05 | Fajardo | Puerto Rico | 72053 | 2139 | |
1783233 | 1783233 | 2021-10-04 | Fajardo | Puerto Rico | 72053 | 2139 | |
1779984 | 1779984 | 2021-10-03 | Fajardo | Puerto Rico | 72053 | 2138 | |
1776734 | 1776734 | 2021-10-02 | Fajardo | Puerto Rico | 72053 | 2138 | |
1773484 | 1773484 | 2021-10-01 | Fajardo | Puerto Rico | 72053 | 2136 | |
1770234 | 1770234 | 2021-09-30 | Fajardo | Puerto Rico | 72053 | 2134 | |
1766985 | 1766985 | 2021-09-29 | Fajardo | Puerto Rico | 72053 | 2132 | |
1763736 | 1763736 | 2021-09-28 | Fajardo | Puerto Rico | 72053 | 2132 | |
1760487 | 1760487 | 2021-09-27 | Fajardo | Puerto Rico | 72053 | 2131 | |
1757239 | 1757239 | 2021-09-26 | Fajardo | Puerto Rico | 72053 | 2130 | |
1753991 | 1753991 | 2021-09-25 | Fajardo | Puerto Rico | 72053 | 2127 | |
1750743 | 1750743 | 2021-09-24 | Fajardo | Puerto Rico | 72053 | 2126 | |
1747494 | 1747494 | 2021-09-23 | Fajardo | Puerto Rico | 72053 | 2125 | |
1744244 | 1744244 | 2021-09-22 | Fajardo | Puerto Rico | 72053 | 2125 | |
1740995 | 1740995 | 2021-09-21 | Fajardo | Puerto Rico | 72053 | 2123 | |
1737746 | 1737746 | 2021-09-20 | Fajardo | Puerto Rico | 72053 | 2121 | |
1734496 | 1734496 | 2021-09-19 | Fajardo | Puerto Rico | 72053 | 2117 | |
1731246 | 1731246 | 2021-09-18 | Fajardo | Puerto Rico | 72053 | 2113 | |
1727996 | 1727996 | 2021-09-17 | Fajardo | Puerto Rico | 72053 | 2112 | |
1724747 | 1724747 | 2021-09-16 | Fajardo | Puerto Rico | 72053 | 2110 | |
1721498 | 1721498 | 2021-09-15 | Fajardo | Puerto Rico | 72053 | 2099 | |
1718250 | 1718250 | 2021-09-14 | Fajardo | Puerto Rico | 72053 | 2098 | |
1715002 | 1715002 | 2021-09-13 | Fajardo | Puerto Rico | 72053 | 2098 | |
1711756 | 1711756 | 2021-09-12 | Fajardo | Puerto Rico | 72053 | 2088 | |
1708509 | 1708509 | 2021-09-11 | Fajardo | Puerto Rico | 72053 | 2080 | |
1705262 | 1705262 | 2021-09-10 | Fajardo | Puerto Rico | 72053 | 2073 | |
1702012 | 1702012 | 2021-09-09 | Fajardo | Puerto Rico | 72053 | 2070 | |
1698763 | 1698763 | 2021-09-08 | Fajardo | Puerto Rico | 72053 | 2068 | |
1695515 | 1695515 | 2021-09-07 | Fajardo | Puerto Rico | 72053 | 2068 | |
1692267 | 1692267 | 2021-09-06 | Fajardo | Puerto Rico | 72053 | 2068 | |
1689018 | 1689018 | 2021-09-05 | Fajardo | Puerto Rico | 72053 | 2063 | |
1685768 | 1685768 | 2021-09-04 | Fajardo | Puerto Rico | 72053 | 2061 | |
1682517 | 1682517 | 2021-09-03 | Fajardo | Puerto Rico | 72053 | 2054 | |
1679267 | 1679267 | 2021-09-02 | Fajardo | Puerto Rico | 72053 | 2048 | |
1676019 | 1676019 | 2021-09-01 | Fajardo | Puerto Rico | 72053 | 2041 | |
1672772 | 1672772 | 2021-08-31 | Fajardo | Puerto Rico | 72053 | 2015 | |
1669524 | 1669524 | 2021-08-30 | Fajardo | Puerto Rico | 72053 | 2013 | |
1666277 | 1666277 | 2021-08-29 | Fajardo | Puerto Rico | 72053 | 2003 | |
1663029 | 1663029 | 2021-08-28 | Fajardo | Puerto Rico | 72053 | 2001 | |
1659781 | 1659781 | 2021-08-27 | Fajardo | Puerto Rico | 72053 | 1996 | |
1656532 | 1656532 | 2021-08-26 | Fajardo | Puerto Rico | 72053 | 1984 | |
1653285 | 1653285 | 2021-08-25 | Fajardo | Puerto Rico | 72053 | 1975 | |
1650038 | 1650038 | 2021-08-24 | Fajardo | Puerto Rico | 72053 | 1970 | |
1646789 | 1646789 | 2021-08-23 | Fajardo | Puerto Rico | 72053 | 1970 | |
1643540 | 1643540 | 2021-08-22 | Fajardo | Puerto Rico | 72053 | 1959 | |
1640290 | 1640290 | 2021-08-21 | Fajardo | Puerto Rico | 72053 | 1945 | |
1637040 | 1637040 | 2021-08-20 | Fajardo | Puerto Rico | 72053 | 1928 | |
1633790 | 1633790 | 2021-08-19 | Fajardo | Puerto Rico | 72053 | 1911 | |
1630543 | 1630543 | 2021-08-18 | Fajardo | Puerto Rico | 72053 | 1905 | |
1627296 | 1627296 | 2021-08-17 | Fajardo | Puerto Rico | 72053 | 1902 | |
1624049 | 1624049 | 2021-08-16 | Fajardo | Puerto Rico | 72053 | 1898 | |
1620802 | 1620802 | 2021-08-15 | Fajardo | Puerto Rico | 72053 | 1892 | |
1617554 | 1617554 | 2021-08-14 | Fajardo | Puerto Rico | 72053 | 1885 | |
1614306 | 1614306 | 2021-08-13 | Fajardo | Puerto Rico | 72053 | 1873 | |
1611057 | 1611057 | 2021-08-12 | Fajardo | Puerto Rico | 72053 | 1854 | |
1607809 | 1607809 | 2021-08-11 | Fajardo | Puerto Rico | 72053 | 1843 | |
1604560 | 1604560 | 2021-08-10 | Fajardo | Puerto Rico | 72053 | 1840 | |
1601311 | 1601311 | 2021-08-09 | Fajardo | Puerto Rico | 72053 | 1838 | |
1598063 | 1598063 | 2021-08-08 | Fajardo | Puerto Rico | 72053 | 1832 | |
1594814 | 1594814 | 2021-08-07 | Fajardo | Puerto Rico | 72053 | 1826 | |
1591565 | 1591565 | 2021-08-06 | Fajardo | Puerto Rico | 72053 | 1819 | |
1588316 | 1588316 | 2021-08-05 | Fajardo | Puerto Rico | 72053 | 1804 | |
1585066 | 1585066 | 2021-08-04 | Fajardo | Puerto Rico | 72053 | 1788 | |
1581816 | 1581816 | 2021-08-03 | Fajardo | Puerto Rico | 72053 | 1785 | |
1578567 | 1578567 | 2021-08-02 | Fajardo | Puerto Rico | 72053 | 1784 | |
1575319 | 1575319 | 2021-08-01 | Fajardo | Puerto Rico | 72053 | 1779 | |
1572071 | 1572071 | 2021-07-31 | Fajardo | Puerto Rico | 72053 | 1762 | |
1568823 | 1568823 | 2021-07-30 | Fajardo | Puerto Rico | 72053 | 1749 | |
1565575 | 1565575 | 2021-07-29 | Fajardo | Puerto Rico | 72053 | 1744 | |
1562327 | 1562327 | 2021-07-28 | Fajardo | Puerto Rico | 72053 | 1740 | |
1559079 | 1559079 | 2021-07-27 | Fajardo | Puerto Rico | 72053 | 1734 | |
1555832 | 1555832 | 2021-07-26 | Fajardo | Puerto Rico | 72053 | 1729 | |
1552585 | 1552585 | 2021-07-25 | Fajardo | Puerto Rico | 72053 | 1724 | |
1549338 | 1549338 | 2021-07-24 | Fajardo | Puerto Rico | 72053 | 1721 | |
1546091 | 1546091 | 2021-07-23 | Fajardo | Puerto Rico | 72053 | 1717 | |
1542844 | 1542844 | 2021-07-22 | Fajardo | Puerto Rico | 72053 | 1712 | |
1539596 | 1539596 | 2021-07-21 | Fajardo | Puerto Rico | 72053 | 1707 | |
1536349 | 1536349 | 2021-07-20 | Fajardo | Puerto Rico | 72053 | 1706 | |
1533101 | 1533101 | 2021-07-19 | Fajardo | Puerto Rico | 72053 | 1703 | |
1529854 | 1529854 | 2021-07-18 | Fajardo | Puerto Rico | 72053 | 1699 | |
1526607 | 1526607 | 2021-07-17 | Fajardo | Puerto Rico | 72053 | 1699 | |
1523360 | 1523360 | 2021-07-16 | Fajardo | Puerto Rico | 72053 | 1699 | |
1520112 | 1520112 | 2021-07-15 | Fajardo | Puerto Rico | 72053 | 1699 | |
1516864 | 1516864 | 2021-07-14 | Fajardo | Puerto Rico | 72053 | 1699 | |
1513617 | 1513617 | 2021-07-13 | Fajardo | Puerto Rico | 72053 | 1699 | |
1510371 | 1510371 | 2021-07-12 | Fajardo | Puerto Rico | 72053 | 1698 | |
1507124 | 1507124 | 2021-07-11 | Fajardo | Puerto Rico | 72053 | 1696 | |
1503878 | 1503878 | 2021-07-10 | Fajardo | Puerto Rico | 72053 | 1695 | |
1500632 | 1500632 | 2021-07-09 | Fajardo | Puerto Rico | 72053 | 1693 | |
1497386 | 1497386 | 2021-07-08 | Fajardo | Puerto Rico | 72053 | 1691 | |
1494139 | 1494139 | 2021-07-07 | Fajardo | Puerto Rico | 72053 | 1691 | |
1490892 | 1490892 | 2021-07-06 | Fajardo | Puerto Rico | 72053 | 1691 |
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);