ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72031 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 |
---|---|---|---|---|---|---|---|
1812464 | 1812464 | 2021-10-13 | Carolina | Puerto Rico | 72031 | 12935 | |
1809215 | 1809215 | 2021-10-12 | Carolina | Puerto Rico | 72031 | 12923 | |
1805965 | 1805965 | 2021-10-11 | Carolina | Puerto Rico | 72031 | 12923 | |
1802715 | 1802715 | 2021-10-10 | Carolina | Puerto Rico | 72031 | 12909 | |
1799466 | 1799466 | 2021-10-09 | Carolina | Puerto Rico | 72031 | 12909 | |
1796217 | 1796217 | 2021-10-08 | Carolina | Puerto Rico | 72031 | 12897 | |
1792968 | 1792968 | 2021-10-07 | Carolina | Puerto Rico | 72031 | 12890 | |
1789719 | 1789719 | 2021-10-06 | Carolina | Puerto Rico | 72031 | 12879 | |
1786471 | 1786471 | 2021-10-05 | Carolina | Puerto Rico | 72031 | 12867 | |
1783222 | 1783222 | 2021-10-04 | Carolina | Puerto Rico | 72031 | 12866 | |
1779973 | 1779973 | 2021-10-03 | Carolina | Puerto Rico | 72031 | 12863 | |
1776723 | 1776723 | 2021-10-02 | Carolina | Puerto Rico | 72031 | 12840 | |
1773473 | 1773473 | 2021-10-01 | Carolina | Puerto Rico | 72031 | 12835 | |
1770223 | 1770223 | 2021-09-30 | Carolina | Puerto Rico | 72031 | 12823 | |
1766974 | 1766974 | 2021-09-29 | Carolina | Puerto Rico | 72031 | 12810 | |
1763725 | 1763725 | 2021-09-28 | Carolina | Puerto Rico | 72031 | 12782 | |
1760476 | 1760476 | 2021-09-27 | Carolina | Puerto Rico | 72031 | 12781 | |
1757228 | 1757228 | 2021-09-26 | Carolina | Puerto Rico | 72031 | 12771 | |
1753980 | 1753980 | 2021-09-25 | Carolina | Puerto Rico | 72031 | 12751 | |
1750732 | 1750732 | 2021-09-24 | Carolina | Puerto Rico | 72031 | 12722 | |
1747483 | 1747483 | 2021-09-23 | Carolina | Puerto Rico | 72031 | 12696 | |
1744233 | 1744233 | 2021-09-22 | Carolina | Puerto Rico | 72031 | 12684 | |
1740984 | 1740984 | 2021-09-21 | Carolina | Puerto Rico | 72031 | 12666 | |
1737735 | 1737735 | 2021-09-20 | Carolina | Puerto Rico | 72031 | 12664 | |
1734485 | 1734485 | 2021-09-19 | Carolina | Puerto Rico | 72031 | 12649 | |
1731235 | 1731235 | 2021-09-18 | Carolina | Puerto Rico | 72031 | 12624 | |
1727985 | 1727985 | 2021-09-17 | Carolina | Puerto Rico | 72031 | 12598 | |
1724736 | 1724736 | 2021-09-16 | Carolina | Puerto Rico | 72031 | 12578 | |
1721487 | 1721487 | 2021-09-15 | Carolina | Puerto Rico | 72031 | 12548 | |
1718239 | 1718239 | 2021-09-14 | Carolina | Puerto Rico | 72031 | 12513 | |
1714991 | 1714991 | 2021-09-13 | Carolina | Puerto Rico | 72031 | 12513 | |
1711745 | 1711745 | 2021-09-12 | Carolina | Puerto Rico | 72031 | 12491 | |
1708498 | 1708498 | 2021-09-11 | Carolina | Puerto Rico | 72031 | 12463 | |
1705251 | 1705251 | 2021-09-10 | Carolina | Puerto Rico | 72031 | 12440 | |
1702001 | 1702001 | 2021-09-09 | Carolina | Puerto Rico | 72031 | 12399 | |
1698752 | 1698752 | 2021-09-08 | Carolina | Puerto Rico | 72031 | 12374 | |
1695504 | 1695504 | 2021-09-07 | Carolina | Puerto Rico | 72031 | 12348 | |
1692256 | 1692256 | 2021-09-06 | Carolina | Puerto Rico | 72031 | 12346 | |
1689007 | 1689007 | 2021-09-05 | Carolina | Puerto Rico | 72031 | 12329 | |
1685757 | 1685757 | 2021-09-04 | Carolina | Puerto Rico | 72031 | 12298 | |
1682506 | 1682506 | 2021-09-03 | Carolina | Puerto Rico | 72031 | 12249 | |
1679256 | 1679256 | 2021-09-02 | Carolina | Puerto Rico | 72031 | 12187 | |
1676008 | 1676008 | 2021-09-01 | Carolina | Puerto Rico | 72031 | 12144 | |
1672761 | 1672761 | 2021-08-31 | Carolina | Puerto Rico | 72031 | 12072 | |
1669513 | 1669513 | 2021-08-30 | Carolina | Puerto Rico | 72031 | 12058 | |
1666266 | 1666266 | 2021-08-29 | Carolina | Puerto Rico | 72031 | 12022 | |
1663018 | 1663018 | 2021-08-28 | Carolina | Puerto Rico | 72031 | 11989 | |
1659770 | 1659770 | 2021-08-27 | Carolina | Puerto Rico | 72031 | 11942 | |
1656521 | 1656521 | 2021-08-26 | Carolina | Puerto Rico | 72031 | 11867 | |
1653274 | 1653274 | 2021-08-25 | Carolina | Puerto Rico | 72031 | 11784 | |
1650027 | 1650027 | 2021-08-24 | Carolina | Puerto Rico | 72031 | 11666 | |
1646778 | 1646778 | 2021-08-23 | Carolina | Puerto Rico | 72031 | 11660 | |
1643529 | 1643529 | 2021-08-22 | Carolina | Puerto Rico | 72031 | 11624 | |
1640279 | 1640279 | 2021-08-21 | Carolina | Puerto Rico | 72031 | 11574 | |
1637029 | 1637029 | 2021-08-20 | Carolina | Puerto Rico | 72031 | 11444 | |
1633779 | 1633779 | 2021-08-19 | Carolina | Puerto Rico | 72031 | 11385 | |
1630532 | 1630532 | 2021-08-18 | Carolina | Puerto Rico | 72031 | 11359 | |
1627285 | 1627285 | 2021-08-17 | Carolina | Puerto Rico | 72031 | 11347 | |
1624038 | 1624038 | 2021-08-16 | Carolina | Puerto Rico | 72031 | 11327 | |
1620791 | 1620791 | 2021-08-15 | Carolina | Puerto Rico | 72031 | 11293 | |
1617543 | 1617543 | 2021-08-14 | Carolina | Puerto Rico | 72031 | 11224 | |
1614295 | 1614295 | 2021-08-13 | Carolina | Puerto Rico | 72031 | 11171 | |
1611046 | 1611046 | 2021-08-12 | Carolina | Puerto Rico | 72031 | 11096 | |
1607798 | 1607798 | 2021-08-11 | Carolina | Puerto Rico | 72031 | 11041 | |
1604549 | 1604549 | 2021-08-10 | Carolina | Puerto Rico | 72031 | 10998 | |
1601300 | 1601300 | 2021-08-09 | Carolina | Puerto Rico | 72031 | 10970 | |
1598052 | 1598052 | 2021-08-08 | Carolina | Puerto Rico | 72031 | 10938 | |
1594803 | 1594803 | 2021-08-07 | Carolina | Puerto Rico | 72031 | 10887 | |
1591554 | 1591554 | 2021-08-06 | Carolina | Puerto Rico | 72031 | 10877 | |
1588305 | 1588305 | 2021-08-05 | Carolina | Puerto Rico | 72031 | 10827 | |
1585055 | 1585055 | 2021-08-04 | Carolina | Puerto Rico | 72031 | 10751 | |
1581805 | 1581805 | 2021-08-03 | Carolina | Puerto Rico | 72031 | 10727 | |
1578556 | 1578556 | 2021-08-02 | Carolina | Puerto Rico | 72031 | 10715 | |
1575308 | 1575308 | 2021-08-01 | Carolina | Puerto Rico | 72031 | 10689 | |
1572060 | 1572060 | 2021-07-31 | Carolina | Puerto Rico | 72031 | 10663 | |
1568812 | 1568812 | 2021-07-30 | Carolina | Puerto Rico | 72031 | 10625 | |
1565564 | 1565564 | 2021-07-29 | Carolina | Puerto Rico | 72031 | 10597 | |
1562316 | 1562316 | 2021-07-28 | Carolina | Puerto Rico | 72031 | 10580 | |
1559068 | 1559068 | 2021-07-27 | Carolina | Puerto Rico | 72031 | 10578 | |
1555821 | 1555821 | 2021-07-26 | Carolina | Puerto Rico | 72031 | 10574 | |
1552574 | 1552574 | 2021-07-25 | Carolina | Puerto Rico | 72031 | 10564 | |
1549327 | 1549327 | 2021-07-24 | Carolina | Puerto Rico | 72031 | 10548 | |
1546080 | 1546080 | 2021-07-23 | Carolina | Puerto Rico | 72031 | 10530 | |
1542833 | 1542833 | 2021-07-22 | Carolina | Puerto Rico | 72031 | 10492 | |
1539585 | 1539585 | 2021-07-21 | Carolina | Puerto Rico | 72031 | 10485 | |
1536338 | 1536338 | 2021-07-20 | Carolina | Puerto Rico | 72031 | 10480 | |
1533090 | 1533090 | 2021-07-19 | Carolina | Puerto Rico | 72031 | 10451 | |
1529843 | 1529843 | 2021-07-18 | Carolina | Puerto Rico | 72031 | 10443 | |
1526596 | 1526596 | 2021-07-17 | Carolina | Puerto Rico | 72031 | 10424 | |
1523349 | 1523349 | 2021-07-16 | Carolina | Puerto Rico | 72031 | 10406 | |
1520101 | 1520101 | 2021-07-15 | Carolina | Puerto Rico | 72031 | 10390 | |
1516853 | 1516853 | 2021-07-14 | Carolina | Puerto Rico | 72031 | 10379 | |
1513606 | 1513606 | 2021-07-13 | Carolina | Puerto Rico | 72031 | 10379 | |
1510360 | 1510360 | 2021-07-12 | Carolina | Puerto Rico | 72031 | 10377 | |
1507113 | 1507113 | 2021-07-11 | Carolina | Puerto Rico | 72031 | 10367 | |
1503867 | 1503867 | 2021-07-10 | Carolina | Puerto Rico | 72031 | 10363 | |
1500621 | 1500621 | 2021-07-09 | Carolina | Puerto Rico | 72031 | 10358 | |
1497375 | 1497375 | 2021-07-08 | Carolina | Puerto Rico | 72031 | 10352 | |
1494128 | 1494128 | 2021-07-07 | Carolina | Puerto Rico | 72031 | 10351 | |
1490881 | 1490881 | 2021-07-06 | Carolina | Puerto Rico | 72031 | 10349 |
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);