ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72135 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 |
---|---|---|---|---|---|---|---|
1812517 | 1812517 | 2021-10-13 | Toa Alta | Puerto Rico | 72135 | 5698 | |
1809268 | 1809268 | 2021-10-12 | Toa Alta | Puerto Rico | 72135 | 5696 | |
1806018 | 1806018 | 2021-10-11 | Toa Alta | Puerto Rico | 72135 | 5695 | |
1802768 | 1802768 | 2021-10-10 | Toa Alta | Puerto Rico | 72135 | 5692 | |
1799519 | 1799519 | 2021-10-09 | Toa Alta | Puerto Rico | 72135 | 5692 | |
1796270 | 1796270 | 2021-10-08 | Toa Alta | Puerto Rico | 72135 | 5691 | |
1793021 | 1793021 | 2021-10-07 | Toa Alta | Puerto Rico | 72135 | 5688 | |
1789772 | 1789772 | 2021-10-06 | Toa Alta | Puerto Rico | 72135 | 5687 | |
1786524 | 1786524 | 2021-10-05 | Toa Alta | Puerto Rico | 72135 | 5686 | |
1783275 | 1783275 | 2021-10-04 | Toa Alta | Puerto Rico | 72135 | 5683 | |
1780026 | 1780026 | 2021-10-03 | Toa Alta | Puerto Rico | 72135 | 5682 | |
1776776 | 1776776 | 2021-10-02 | Toa Alta | Puerto Rico | 72135 | 5680 | |
1773526 | 1773526 | 2021-10-01 | Toa Alta | Puerto Rico | 72135 | 5676 | |
1770276 | 1770276 | 2021-09-30 | Toa Alta | Puerto Rico | 72135 | 5672 | |
1767027 | 1767027 | 2021-09-29 | Toa Alta | Puerto Rico | 72135 | 5672 | |
1763778 | 1763778 | 2021-09-28 | Toa Alta | Puerto Rico | 72135 | 5667 | |
1760529 | 1760529 | 2021-09-27 | Toa Alta | Puerto Rico | 72135 | 5665 | |
1757281 | 1757281 | 2021-09-26 | Toa Alta | Puerto Rico | 72135 | 5664 | |
1754033 | 1754033 | 2021-09-25 | Toa Alta | Puerto Rico | 72135 | 5660 | |
1750785 | 1750785 | 2021-09-24 | Toa Alta | Puerto Rico | 72135 | 5658 | |
1747536 | 1747536 | 2021-09-23 | Toa Alta | Puerto Rico | 72135 | 5652 | |
1744286 | 1744286 | 2021-09-22 | Toa Alta | Puerto Rico | 72135 | 5649 | |
1741037 | 1741037 | 2021-09-21 | Toa Alta | Puerto Rico | 72135 | 5645 | |
1737788 | 1737788 | 2021-09-20 | Toa Alta | Puerto Rico | 72135 | 5645 | |
1734538 | 1734538 | 2021-09-19 | Toa Alta | Puerto Rico | 72135 | 5641 | |
1731288 | 1731288 | 2021-09-18 | Toa Alta | Puerto Rico | 72135 | 5631 | |
1728038 | 1728038 | 2021-09-17 | Toa Alta | Puerto Rico | 72135 | 5620 | |
1724789 | 1724789 | 2021-09-16 | Toa Alta | Puerto Rico | 72135 | 5609 | |
1721540 | 1721540 | 2021-09-15 | Toa Alta | Puerto Rico | 72135 | 5597 | |
1718292 | 1718292 | 2021-09-14 | Toa Alta | Puerto Rico | 72135 | 5587 | |
1715044 | 1715044 | 2021-09-13 | Toa Alta | Puerto Rico | 72135 | 5586 | |
1711798 | 1711798 | 2021-09-12 | Toa Alta | Puerto Rico | 72135 | 5580 | |
1708551 | 1708551 | 2021-09-11 | Toa Alta | Puerto Rico | 72135 | 5566 | |
1705304 | 1705304 | 2021-09-10 | Toa Alta | Puerto Rico | 72135 | 5562 | |
1702054 | 1702054 | 2021-09-09 | Toa Alta | Puerto Rico | 72135 | 5540 | |
1698805 | 1698805 | 2021-09-08 | Toa Alta | Puerto Rico | 72135 | 5533 | |
1695557 | 1695557 | 2021-09-07 | Toa Alta | Puerto Rico | 72135 | 5522 | |
1692309 | 1692309 | 2021-09-06 | Toa Alta | Puerto Rico | 72135 | 5522 | |
1689060 | 1689060 | 2021-09-05 | Toa Alta | Puerto Rico | 72135 | 5506 | |
1685810 | 1685810 | 2021-09-04 | Toa Alta | Puerto Rico | 72135 | 5490 | |
1682559 | 1682559 | 2021-09-03 | Toa Alta | Puerto Rico | 72135 | 5467 | |
1679309 | 1679309 | 2021-09-02 | Toa Alta | Puerto Rico | 72135 | 5437 | |
1676061 | 1676061 | 2021-09-01 | Toa Alta | Puerto Rico | 72135 | 5416 | |
1672814 | 1672814 | 2021-08-31 | Toa Alta | Puerto Rico | 72135 | 5367 | |
1669566 | 1669566 | 2021-08-30 | Toa Alta | Puerto Rico | 72135 | 5358 | |
1666319 | 1666319 | 2021-08-29 | Toa Alta | Puerto Rico | 72135 | 5345 | |
1663071 | 1663071 | 2021-08-28 | Toa Alta | Puerto Rico | 72135 | 5324 | |
1659823 | 1659823 | 2021-08-27 | Toa Alta | Puerto Rico | 72135 | 5314 | |
1656574 | 1656574 | 2021-08-26 | Toa Alta | Puerto Rico | 72135 | 5279 | |
1653327 | 1653327 | 2021-08-25 | Toa Alta | Puerto Rico | 72135 | 5251 | |
1650080 | 1650080 | 2021-08-24 | Toa Alta | Puerto Rico | 72135 | 5235 | |
1646831 | 1646831 | 2021-08-23 | Toa Alta | Puerto Rico | 72135 | 5232 | |
1643582 | 1643582 | 2021-08-22 | Toa Alta | Puerto Rico | 72135 | 5222 | |
1640332 | 1640332 | 2021-08-21 | Toa Alta | Puerto Rico | 72135 | 5214 | |
1637082 | 1637082 | 2021-08-20 | Toa Alta | Puerto Rico | 72135 | 5186 | |
1633832 | 1633832 | 2021-08-19 | Toa Alta | Puerto Rico | 72135 | 5159 | |
1630585 | 1630585 | 2021-08-18 | Toa Alta | Puerto Rico | 72135 | 5149 | |
1627338 | 1627338 | 2021-08-17 | Toa Alta | Puerto Rico | 72135 | 5143 | |
1624091 | 1624091 | 2021-08-16 | Toa Alta | Puerto Rico | 72135 | 5138 | |
1620844 | 1620844 | 2021-08-15 | Toa Alta | Puerto Rico | 72135 | 5121 | |
1617596 | 1617596 | 2021-08-14 | Toa Alta | Puerto Rico | 72135 | 5094 | |
1614348 | 1614348 | 2021-08-13 | Toa Alta | Puerto Rico | 72135 | 5071 | |
1611099 | 1611099 | 2021-08-12 | Toa Alta | Puerto Rico | 72135 | 5051 | |
1607851 | 1607851 | 2021-08-11 | Toa Alta | Puerto Rico | 72135 | 5015 | |
1604602 | 1604602 | 2021-08-10 | Toa Alta | Puerto Rico | 72135 | 5000 | |
1601353 | 1601353 | 2021-08-09 | Toa Alta | Puerto Rico | 72135 | 4997 | |
1598105 | 1598105 | 2021-08-08 | Toa Alta | Puerto Rico | 72135 | 4981 | |
1594856 | 1594856 | 2021-08-07 | Toa Alta | Puerto Rico | 72135 | 4967 | |
1591607 | 1591607 | 2021-08-06 | Toa Alta | Puerto Rico | 72135 | 4962 | |
1588358 | 1588358 | 2021-08-05 | Toa Alta | Puerto Rico | 72135 | 4940 | |
1585108 | 1585108 | 2021-08-04 | Toa Alta | Puerto Rico | 72135 | 4915 | |
1581858 | 1581858 | 2021-08-03 | Toa Alta | Puerto Rico | 72135 | 4901 | |
1578609 | 1578609 | 2021-08-02 | Toa Alta | Puerto Rico | 72135 | 4901 | |
1575361 | 1575361 | 2021-08-01 | Toa Alta | Puerto Rico | 72135 | 4896 | |
1572113 | 1572113 | 2021-07-31 | Toa Alta | Puerto Rico | 72135 | 4876 | |
1568865 | 1568865 | 2021-07-30 | Toa Alta | Puerto Rico | 72135 | 4863 | |
1565617 | 1565617 | 2021-07-29 | Toa Alta | Puerto Rico | 72135 | 4860 | |
1562369 | 1562369 | 2021-07-28 | Toa Alta | Puerto Rico | 72135 | 4853 | |
1559121 | 1559121 | 2021-07-27 | Toa Alta | Puerto Rico | 72135 | 4853 | |
1555874 | 1555874 | 2021-07-26 | Toa Alta | Puerto Rico | 72135 | 4852 | |
1552627 | 1552627 | 2021-07-25 | Toa Alta | Puerto Rico | 72135 | 4850 | |
1549380 | 1549380 | 2021-07-24 | Toa Alta | Puerto Rico | 72135 | 4836 | |
1546133 | 1546133 | 2021-07-23 | Toa Alta | Puerto Rico | 72135 | 4830 | |
1542886 | 1542886 | 2021-07-22 | Toa Alta | Puerto Rico | 72135 | 4820 | |
1539638 | 1539638 | 2021-07-21 | Toa Alta | Puerto Rico | 72135 | 4819 | |
1536391 | 1536391 | 2021-07-20 | Toa Alta | Puerto Rico | 72135 | 4817 | |
1533143 | 1533143 | 2021-07-19 | Toa Alta | Puerto Rico | 72135 | 4812 | |
1529896 | 1529896 | 2021-07-18 | Toa Alta | Puerto Rico | 72135 | 4809 | |
1526649 | 1526649 | 2021-07-17 | Toa Alta | Puerto Rico | 72135 | 4806 | |
1523402 | 1523402 | 2021-07-16 | Toa Alta | Puerto Rico | 72135 | 4801 | |
1520154 | 1520154 | 2021-07-15 | Toa Alta | Puerto Rico | 72135 | 4799 | |
1516906 | 1516906 | 2021-07-14 | Toa Alta | Puerto Rico | 72135 | 4796 | |
1513659 | 1513659 | 2021-07-13 | Toa Alta | Puerto Rico | 72135 | 4796 | |
1510413 | 1510413 | 2021-07-12 | Toa Alta | Puerto Rico | 72135 | 4794 | |
1507166 | 1507166 | 2021-07-11 | Toa Alta | Puerto Rico | 72135 | 4793 | |
1503920 | 1503920 | 2021-07-10 | Toa Alta | Puerto Rico | 72135 | 4791 | |
1500674 | 1500674 | 2021-07-09 | Toa Alta | Puerto Rico | 72135 | 4787 | |
1497428 | 1497428 | 2021-07-08 | Toa Alta | Puerto Rico | 72135 | 4785 | |
1494181 | 1494181 | 2021-07-07 | Toa Alta | Puerto Rico | 72135 | 4785 | |
1490934 | 1490934 | 2021-07-06 | Toa Alta | Puerto Rico | 72135 | 4785 |
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);