ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Adjuntas" 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 |
---|---|---|---|---|---|---|---|
1812449 | 1812449 | 2021-10-13 | Adjuntas | Puerto Rico | 72001 | 668 | |
1809200 | 1809200 | 2021-10-12 | Adjuntas | Puerto Rico | 72001 | 668 | |
1805950 | 1805950 | 2021-10-11 | Adjuntas | Puerto Rico | 72001 | 668 | |
1802700 | 1802700 | 2021-10-10 | Adjuntas | Puerto Rico | 72001 | 667 | |
1799451 | 1799451 | 2021-10-09 | Adjuntas | Puerto Rico | 72001 | 667 | |
1796202 | 1796202 | 2021-10-08 | Adjuntas | Puerto Rico | 72001 | 667 | |
1792953 | 1792953 | 2021-10-07 | Adjuntas | Puerto Rico | 72001 | 667 | |
1789704 | 1789704 | 2021-10-06 | Adjuntas | Puerto Rico | 72001 | 667 | |
1786456 | 1786456 | 2021-10-05 | Adjuntas | Puerto Rico | 72001 | 667 | |
1783207 | 1783207 | 2021-10-04 | Adjuntas | Puerto Rico | 72001 | 667 | |
1779958 | 1779958 | 2021-10-03 | Adjuntas | Puerto Rico | 72001 | 667 | |
1776708 | 1776708 | 2021-10-02 | Adjuntas | Puerto Rico | 72001 | 665 | |
1773458 | 1773458 | 2021-10-01 | Adjuntas | Puerto Rico | 72001 | 665 | |
1770208 | 1770208 | 2021-09-30 | Adjuntas | Puerto Rico | 72001 | 664 | |
1766959 | 1766959 | 2021-09-29 | Adjuntas | Puerto Rico | 72001 | 664 | |
1763710 | 1763710 | 2021-09-28 | Adjuntas | Puerto Rico | 72001 | 664 | |
1760461 | 1760461 | 2021-09-27 | Adjuntas | Puerto Rico | 72001 | 664 | |
1757213 | 1757213 | 2021-09-26 | Adjuntas | Puerto Rico | 72001 | 664 | |
1753965 | 1753965 | 2021-09-25 | Adjuntas | Puerto Rico | 72001 | 664 | |
1750717 | 1750717 | 2021-09-24 | Adjuntas | Puerto Rico | 72001 | 663 | |
1747468 | 1747468 | 2021-09-23 | Adjuntas | Puerto Rico | 72001 | 660 | |
1744218 | 1744218 | 2021-09-22 | Adjuntas | Puerto Rico | 72001 | 660 | |
1740969 | 1740969 | 2021-09-21 | Adjuntas | Puerto Rico | 72001 | 659 | |
1737720 | 1737720 | 2021-09-20 | Adjuntas | Puerto Rico | 72001 | 659 | |
1734470 | 1734470 | 2021-09-19 | Adjuntas | Puerto Rico | 72001 | 659 | |
1731220 | 1731220 | 2021-09-18 | Adjuntas | Puerto Rico | 72001 | 659 | |
1727970 | 1727970 | 2021-09-17 | Adjuntas | Puerto Rico | 72001 | 657 | |
1724721 | 1724721 | 2021-09-16 | Adjuntas | Puerto Rico | 72001 | 656 | |
1721472 | 1721472 | 2021-09-15 | Adjuntas | Puerto Rico | 72001 | 655 | |
1718224 | 1718224 | 2021-09-14 | Adjuntas | Puerto Rico | 72001 | 654 | |
1714976 | 1714976 | 2021-09-13 | Adjuntas | Puerto Rico | 72001 | 654 | |
1711730 | 1711730 | 2021-09-12 | Adjuntas | Puerto Rico | 72001 | 654 | |
1708483 | 1708483 | 2021-09-11 | Adjuntas | Puerto Rico | 72001 | 651 | |
1705236 | 1705236 | 2021-09-10 | Adjuntas | Puerto Rico | 72001 | 650 | |
1701986 | 1701986 | 2021-09-09 | Adjuntas | Puerto Rico | 72001 | 646 | |
1698737 | 1698737 | 2021-09-08 | Adjuntas | Puerto Rico | 72001 | 645 | |
1695489 | 1695489 | 2021-09-07 | Adjuntas | Puerto Rico | 72001 | 644 | |
1692241 | 1692241 | 2021-09-06 | Adjuntas | Puerto Rico | 72001 | 643 | |
1688992 | 1688992 | 2021-09-05 | Adjuntas | Puerto Rico | 72001 | 638 | |
1685742 | 1685742 | 2021-09-04 | Adjuntas | Puerto Rico | 72001 | 636 | |
1682491 | 1682491 | 2021-09-03 | Adjuntas | Puerto Rico | 72001 | 635 | |
1679241 | 1679241 | 2021-09-02 | Adjuntas | Puerto Rico | 72001 | 634 | |
1675993 | 1675993 | 2021-09-01 | Adjuntas | Puerto Rico | 72001 | 629 | |
1672746 | 1672746 | 2021-08-31 | Adjuntas | Puerto Rico | 72001 | 628 | |
1669498 | 1669498 | 2021-08-30 | Adjuntas | Puerto Rico | 72001 | 626 | |
1666251 | 1666251 | 2021-08-29 | Adjuntas | Puerto Rico | 72001 | 625 | |
1663003 | 1663003 | 2021-08-28 | Adjuntas | Puerto Rico | 72001 | 623 | |
1659755 | 1659755 | 2021-08-27 | Adjuntas | Puerto Rico | 72001 | 620 | |
1656506 | 1656506 | 2021-08-26 | Adjuntas | Puerto Rico | 72001 | 614 | |
1653259 | 1653259 | 2021-08-25 | Adjuntas | Puerto Rico | 72001 | 610 | |
1650012 | 1650012 | 2021-08-24 | Adjuntas | Puerto Rico | 72001 | 608 | |
1646763 | 1646763 | 2021-08-23 | Adjuntas | Puerto Rico | 72001 | 603 | |
1643514 | 1643514 | 2021-08-22 | Adjuntas | Puerto Rico | 72001 | 597 | |
1640264 | 1640264 | 2021-08-21 | Adjuntas | Puerto Rico | 72001 | 591 | |
1637014 | 1637014 | 2021-08-20 | Adjuntas | Puerto Rico | 72001 | 583 | |
1633764 | 1633764 | 2021-08-19 | Adjuntas | Puerto Rico | 72001 | 581 | |
1630517 | 1630517 | 2021-08-18 | Adjuntas | Puerto Rico | 72001 | 581 | |
1627270 | 1627270 | 2021-08-17 | Adjuntas | Puerto Rico | 72001 | 581 | |
1624023 | 1624023 | 2021-08-16 | Adjuntas | Puerto Rico | 72001 | 579 | |
1620776 | 1620776 | 2021-08-15 | Adjuntas | Puerto Rico | 72001 | 577 | |
1617528 | 1617528 | 2021-08-14 | Adjuntas | Puerto Rico | 72001 | 574 | |
1614280 | 1614280 | 2021-08-13 | Adjuntas | Puerto Rico | 72001 | 570 | |
1611031 | 1611031 | 2021-08-12 | Adjuntas | Puerto Rico | 72001 | 569 | |
1607783 | 1607783 | 2021-08-11 | Adjuntas | Puerto Rico | 72001 | 569 | |
1604534 | 1604534 | 2021-08-10 | Adjuntas | Puerto Rico | 72001 | 567 | |
1601285 | 1601285 | 2021-08-09 | Adjuntas | Puerto Rico | 72001 | 567 | |
1598037 | 1598037 | 2021-08-08 | Adjuntas | Puerto Rico | 72001 | 561 | |
1594788 | 1594788 | 2021-08-07 | Adjuntas | Puerto Rico | 72001 | 561 | |
1591539 | 1591539 | 2021-08-06 | Adjuntas | Puerto Rico | 72001 | 560 | |
1588290 | 1588290 | 2021-08-05 | Adjuntas | Puerto Rico | 72001 | 560 | |
1585040 | 1585040 | 2021-08-04 | Adjuntas | Puerto Rico | 72001 | 559 | |
1581790 | 1581790 | 2021-08-03 | Adjuntas | Puerto Rico | 72001 | 559 | |
1578541 | 1578541 | 2021-08-02 | Adjuntas | Puerto Rico | 72001 | 559 | |
1575293 | 1575293 | 2021-08-01 | Adjuntas | Puerto Rico | 72001 | 559 | |
1572045 | 1572045 | 2021-07-31 | Adjuntas | Puerto Rico | 72001 | 558 | |
1568797 | 1568797 | 2021-07-30 | Adjuntas | Puerto Rico | 72001 | 558 | |
1565549 | 1565549 | 2021-07-29 | Adjuntas | Puerto Rico | 72001 | 557 | |
1562301 | 1562301 | 2021-07-28 | Adjuntas | Puerto Rico | 72001 | 557 | |
1559053 | 1559053 | 2021-07-27 | Adjuntas | Puerto Rico | 72001 | 555 | |
1555806 | 1555806 | 2021-07-26 | Adjuntas | Puerto Rico | 72001 | 555 | |
1552559 | 1552559 | 2021-07-25 | Adjuntas | Puerto Rico | 72001 | 555 | |
1549312 | 1549312 | 2021-07-24 | Adjuntas | Puerto Rico | 72001 | 555 | |
1546065 | 1546065 | 2021-07-23 | Adjuntas | Puerto Rico | 72001 | 555 | |
1542818 | 1542818 | 2021-07-22 | Adjuntas | Puerto Rico | 72001 | 555 | |
1539570 | 1539570 | 2021-07-21 | Adjuntas | Puerto Rico | 72001 | 555 | |
1536323 | 1536323 | 2021-07-20 | Adjuntas | Puerto Rico | 72001 | 555 | |
1533075 | 1533075 | 2021-07-19 | Adjuntas | Puerto Rico | 72001 | 555 | |
1529828 | 1529828 | 2021-07-18 | Adjuntas | Puerto Rico | 72001 | 555 | |
1526581 | 1526581 | 2021-07-17 | Adjuntas | Puerto Rico | 72001 | 555 | |
1523334 | 1523334 | 2021-07-16 | Adjuntas | Puerto Rico | 72001 | 554 | |
1520086 | 1520086 | 2021-07-15 | Adjuntas | Puerto Rico | 72001 | 554 | |
1516838 | 1516838 | 2021-07-14 | Adjuntas | Puerto Rico | 72001 | 554 | |
1513591 | 1513591 | 2021-07-13 | Adjuntas | Puerto Rico | 72001 | 554 | |
1510345 | 1510345 | 2021-07-12 | Adjuntas | Puerto Rico | 72001 | 554 | |
1507098 | 1507098 | 2021-07-11 | Adjuntas | Puerto Rico | 72001 | 554 | |
1503852 | 1503852 | 2021-07-10 | Adjuntas | Puerto Rico | 72001 | 553 | |
1500606 | 1500606 | 2021-07-09 | Adjuntas | Puerto Rico | 72001 | 553 | |
1497360 | 1497360 | 2021-07-08 | Adjuntas | Puerto Rico | 72001 | 553 | |
1494113 | 1494113 | 2021-07-07 | Adjuntas | Puerto Rico | 72001 | 553 | |
1490866 | 1490866 | 2021-07-06 | Adjuntas | Puerto Rico | 72001 | 553 |
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);