ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72007 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 |
---|---|---|---|---|---|---|---|
1812452 | 1812452 | 2021-10-13 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1809203 | 1809203 | 2021-10-12 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1805953 | 1805953 | 2021-10-11 | Aguas Buenas | Puerto Rico | 72007 | 1629 | |
1802703 | 1802703 | 2021-10-10 | Aguas Buenas | Puerto Rico | 72007 | 1628 | |
1799454 | 1799454 | 2021-10-09 | Aguas Buenas | Puerto Rico | 72007 | 1628 | |
1796205 | 1796205 | 2021-10-08 | Aguas Buenas | Puerto Rico | 72007 | 1627 | |
1792956 | 1792956 | 2021-10-07 | Aguas Buenas | Puerto Rico | 72007 | 1626 | |
1789707 | 1789707 | 2021-10-06 | Aguas Buenas | Puerto Rico | 72007 | 1624 | |
1786459 | 1786459 | 2021-10-05 | Aguas Buenas | Puerto Rico | 72007 | 1624 | |
1783210 | 1783210 | 2021-10-04 | Aguas Buenas | Puerto Rico | 72007 | 1624 | |
1779961 | 1779961 | 2021-10-03 | Aguas Buenas | Puerto Rico | 72007 | 1624 | |
1776711 | 1776711 | 2021-10-02 | Aguas Buenas | Puerto Rico | 72007 | 1624 | |
1773461 | 1773461 | 2021-10-01 | Aguas Buenas | Puerto Rico | 72007 | 1623 | |
1770211 | 1770211 | 2021-09-30 | Aguas Buenas | Puerto Rico | 72007 | 1623 | |
1766962 | 1766962 | 2021-09-29 | Aguas Buenas | Puerto Rico | 72007 | 1623 | |
1763713 | 1763713 | 2021-09-28 | Aguas Buenas | Puerto Rico | 72007 | 1623 | |
1760464 | 1760464 | 2021-09-27 | Aguas Buenas | Puerto Rico | 72007 | 1622 | |
1757216 | 1757216 | 2021-09-26 | Aguas Buenas | Puerto Rico | 72007 | 1620 | |
1753968 | 1753968 | 2021-09-25 | Aguas Buenas | Puerto Rico | 72007 | 1620 | |
1750720 | 1750720 | 2021-09-24 | Aguas Buenas | Puerto Rico | 72007 | 1619 | |
1747471 | 1747471 | 2021-09-23 | Aguas Buenas | Puerto Rico | 72007 | 1618 | |
1744221 | 1744221 | 2021-09-22 | Aguas Buenas | Puerto Rico | 72007 | 1618 | |
1740972 | 1740972 | 2021-09-21 | Aguas Buenas | Puerto Rico | 72007 | 1617 | |
1737723 | 1737723 | 2021-09-20 | Aguas Buenas | Puerto Rico | 72007 | 1617 | |
1734473 | 1734473 | 2021-09-19 | Aguas Buenas | Puerto Rico | 72007 | 1615 | |
1731223 | 1731223 | 2021-09-18 | Aguas Buenas | Puerto Rico | 72007 | 1614 | |
1727973 | 1727973 | 2021-09-17 | Aguas Buenas | Puerto Rico | 72007 | 1613 | |
1724724 | 1724724 | 2021-09-16 | Aguas Buenas | Puerto Rico | 72007 | 1608 | |
1721475 | 1721475 | 2021-09-15 | Aguas Buenas | Puerto Rico | 72007 | 1604 | |
1718227 | 1718227 | 2021-09-14 | Aguas Buenas | Puerto Rico | 72007 | 1600 | |
1714979 | 1714979 | 2021-09-13 | Aguas Buenas | Puerto Rico | 72007 | 1600 | |
1711733 | 1711733 | 2021-09-12 | Aguas Buenas | Puerto Rico | 72007 | 1600 | |
1708486 | 1708486 | 2021-09-11 | Aguas Buenas | Puerto Rico | 72007 | 1597 | |
1705239 | 1705239 | 2021-09-10 | Aguas Buenas | Puerto Rico | 72007 | 1595 | |
1701989 | 1701989 | 2021-09-09 | Aguas Buenas | Puerto Rico | 72007 | 1591 | |
1698740 | 1698740 | 2021-09-08 | Aguas Buenas | Puerto Rico | 72007 | 1591 | |
1695492 | 1695492 | 2021-09-07 | Aguas Buenas | Puerto Rico | 72007 | 1589 | |
1692244 | 1692244 | 2021-09-06 | Aguas Buenas | Puerto Rico | 72007 | 1588 | |
1688995 | 1688995 | 2021-09-05 | Aguas Buenas | Puerto Rico | 72007 | 1587 | |
1685745 | 1685745 | 2021-09-04 | Aguas Buenas | Puerto Rico | 72007 | 1584 | |
1682494 | 1682494 | 2021-09-03 | Aguas Buenas | Puerto Rico | 72007 | 1576 | |
1679244 | 1679244 | 2021-09-02 | Aguas Buenas | Puerto Rico | 72007 | 1569 | |
1675996 | 1675996 | 2021-09-01 | Aguas Buenas | Puerto Rico | 72007 | 1567 | |
1672749 | 1672749 | 2021-08-31 | Aguas Buenas | Puerto Rico | 72007 | 1554 | |
1669501 | 1669501 | 2021-08-30 | Aguas Buenas | Puerto Rico | 72007 | 1554 | |
1666254 | 1666254 | 2021-08-29 | Aguas Buenas | Puerto Rico | 72007 | 1550 | |
1663006 | 1663006 | 2021-08-28 | Aguas Buenas | Puerto Rico | 72007 | 1546 | |
1659758 | 1659758 | 2021-08-27 | Aguas Buenas | Puerto Rico | 72007 | 1540 | |
1656509 | 1656509 | 2021-08-26 | Aguas Buenas | Puerto Rico | 72007 | 1533 | |
1653262 | 1653262 | 2021-08-25 | Aguas Buenas | Puerto Rico | 72007 | 1526 | |
1650015 | 1650015 | 2021-08-24 | Aguas Buenas | Puerto Rico | 72007 | 1526 | |
1646766 | 1646766 | 2021-08-23 | Aguas Buenas | Puerto Rico | 72007 | 1526 | |
1643517 | 1643517 | 2021-08-22 | Aguas Buenas | Puerto Rico | 72007 | 1522 | |
1640267 | 1640267 | 2021-08-21 | Aguas Buenas | Puerto Rico | 72007 | 1521 | |
1637017 | 1637017 | 2021-08-20 | Aguas Buenas | Puerto Rico | 72007 | 1502 | |
1633767 | 1633767 | 2021-08-19 | Aguas Buenas | Puerto Rico | 72007 | 1496 | |
1630520 | 1630520 | 2021-08-18 | Aguas Buenas | Puerto Rico | 72007 | 1494 | |
1627273 | 1627273 | 2021-08-17 | Aguas Buenas | Puerto Rico | 72007 | 1493 | |
1624026 | 1624026 | 2021-08-16 | Aguas Buenas | Puerto Rico | 72007 | 1490 | |
1620779 | 1620779 | 2021-08-15 | Aguas Buenas | Puerto Rico | 72007 | 1486 | |
1617531 | 1617531 | 2021-08-14 | Aguas Buenas | Puerto Rico | 72007 | 1461 | |
1614283 | 1614283 | 2021-08-13 | Aguas Buenas | Puerto Rico | 72007 | 1457 | |
1611034 | 1611034 | 2021-08-12 | Aguas Buenas | Puerto Rico | 72007 | 1454 | |
1607786 | 1607786 | 2021-08-11 | Aguas Buenas | Puerto Rico | 72007 | 1452 | |
1604537 | 1604537 | 2021-08-10 | Aguas Buenas | Puerto Rico | 72007 | 1449 | |
1601288 | 1601288 | 2021-08-09 | Aguas Buenas | Puerto Rico | 72007 | 1449 | |
1598040 | 1598040 | 2021-08-08 | Aguas Buenas | Puerto Rico | 72007 | 1447 | |
1594791 | 1594791 | 2021-08-07 | Aguas Buenas | Puerto Rico | 72007 | 1440 | |
1591542 | 1591542 | 2021-08-06 | Aguas Buenas | Puerto Rico | 72007 | 1439 | |
1588293 | 1588293 | 2021-08-05 | Aguas Buenas | Puerto Rico | 72007 | 1431 | |
1585043 | 1585043 | 2021-08-04 | Aguas Buenas | Puerto Rico | 72007 | 1427 | |
1581793 | 1581793 | 2021-08-03 | Aguas Buenas | Puerto Rico | 72007 | 1424 | |
1578544 | 1578544 | 2021-08-02 | Aguas Buenas | Puerto Rico | 72007 | 1424 | |
1575296 | 1575296 | 2021-08-01 | Aguas Buenas | Puerto Rico | 72007 | 1421 | |
1572048 | 1572048 | 2021-07-31 | Aguas Buenas | Puerto Rico | 72007 | 1413 | |
1568800 | 1568800 | 2021-07-30 | Aguas Buenas | Puerto Rico | 72007 | 1408 | |
1565552 | 1565552 | 2021-07-29 | Aguas Buenas | Puerto Rico | 72007 | 1405 | |
1562304 | 1562304 | 2021-07-28 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1559056 | 1559056 | 2021-07-27 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1555809 | 1555809 | 2021-07-26 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1552562 | 1552562 | 2021-07-25 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1549315 | 1549315 | 2021-07-24 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1546068 | 1546068 | 2021-07-23 | Aguas Buenas | Puerto Rico | 72007 | 1404 | |
1542821 | 1542821 | 2021-07-22 | Aguas Buenas | Puerto Rico | 72007 | 1400 | |
1539573 | 1539573 | 2021-07-21 | Aguas Buenas | Puerto Rico | 72007 | 1400 | |
1536326 | 1536326 | 2021-07-20 | Aguas Buenas | Puerto Rico | 72007 | 1400 | |
1533078 | 1533078 | 2021-07-19 | Aguas Buenas | Puerto Rico | 72007 | 1399 | |
1529831 | 1529831 | 2021-07-18 | Aguas Buenas | Puerto Rico | 72007 | 1398 | |
1526584 | 1526584 | 2021-07-17 | Aguas Buenas | Puerto Rico | 72007 | 1398 | |
1523337 | 1523337 | 2021-07-16 | Aguas Buenas | Puerto Rico | 72007 | 1395 | |
1520089 | 1520089 | 2021-07-15 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1516841 | 1516841 | 2021-07-14 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1513594 | 1513594 | 2021-07-13 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1510348 | 1510348 | 2021-07-12 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1507101 | 1507101 | 2021-07-11 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1503855 | 1503855 | 2021-07-10 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1500609 | 1500609 | 2021-07-09 | Aguas Buenas | Puerto Rico | 72007 | 1393 | |
1497363 | 1497363 | 2021-07-08 | Aguas Buenas | Puerto Rico | 72007 | 1393 | |
1494116 | 1494116 | 2021-07-07 | Aguas Buenas | Puerto Rico | 72007 | 1392 | |
1490869 | 1490869 | 2021-07-06 | Aguas Buenas | Puerto Rico | 72007 | 1392 |
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);