ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guaynabo" 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 |
---|---|---|---|---|---|---|---|
1841720 | 1841720 | 2021-10-22 | Guaynabo | Puerto Rico | 72061 | 6821 | |
1838471 | 1838471 | 2021-10-21 | Guaynabo | Puerto Rico | 72061 | 6820 | |
1835222 | 1835222 | 2021-10-20 | Guaynabo | Puerto Rico | 72061 | 6811 | |
1831973 | 1831973 | 2021-10-19 | Guaynabo | Puerto Rico | 72061 | 6807 | |
1828724 | 1828724 | 2021-10-18 | Guaynabo | Puerto Rico | 72061 | 6807 | |
1825475 | 1825475 | 2021-10-17 | Guaynabo | Puerto Rico | 72061 | 6806 | |
1822226 | 1822226 | 2021-10-16 | Guaynabo | Puerto Rico | 72061 | 6804 | |
1818977 | 1818977 | 2021-10-15 | Guaynabo | Puerto Rico | 72061 | 6800 | |
1815728 | 1815728 | 2021-10-14 | Guaynabo | Puerto Rico | 72061 | 6787 | |
1812480 | 1812480 | 2021-10-13 | Guaynabo | Puerto Rico | 72061 | 6780 | |
1809231 | 1809231 | 2021-10-12 | Guaynabo | Puerto Rico | 72061 | 6775 | |
1805981 | 1805981 | 2021-10-11 | Guaynabo | Puerto Rico | 72061 | 6774 | |
1802731 | 1802731 | 2021-10-10 | Guaynabo | Puerto Rico | 72061 | 6766 | |
1799482 | 1799482 | 2021-10-09 | Guaynabo | Puerto Rico | 72061 | 6766 | |
1796233 | 1796233 | 2021-10-08 | Guaynabo | Puerto Rico | 72061 | 6764 | |
1792984 | 1792984 | 2021-10-07 | Guaynabo | Puerto Rico | 72061 | 6760 | |
1789735 | 1789735 | 2021-10-06 | Guaynabo | Puerto Rico | 72061 | 6751 | |
1786487 | 1786487 | 2021-10-05 | Guaynabo | Puerto Rico | 72061 | 6749 | |
1783238 | 1783238 | 2021-10-04 | Guaynabo | Puerto Rico | 72061 | 6747 | |
1779989 | 1779989 | 2021-10-03 | Guaynabo | Puerto Rico | 72061 | 6741 | |
1776739 | 1776739 | 2021-10-02 | Guaynabo | Puerto Rico | 72061 | 6735 | |
1773489 | 1773489 | 2021-10-01 | Guaynabo | Puerto Rico | 72061 | 6735 | |
1770239 | 1770239 | 2021-09-30 | Guaynabo | Puerto Rico | 72061 | 6731 | |
1766990 | 1766990 | 2021-09-29 | Guaynabo | Puerto Rico | 72061 | 6716 | |
1763741 | 1763741 | 2021-09-28 | Guaynabo | Puerto Rico | 72061 | 6710 | |
1760492 | 1760492 | 2021-09-27 | Guaynabo | Puerto Rico | 72061 | 6710 | |
1757244 | 1757244 | 2021-09-26 | Guaynabo | Puerto Rico | 72061 | 6708 | |
1753996 | 1753996 | 2021-09-25 | Guaynabo | Puerto Rico | 72061 | 6696 | |
1750748 | 1750748 | 2021-09-24 | Guaynabo | Puerto Rico | 72061 | 6688 | |
1747499 | 1747499 | 2021-09-23 | Guaynabo | Puerto Rico | 72061 | 6674 | |
1744249 | 1744249 | 2021-09-22 | Guaynabo | Puerto Rico | 72061 | 6668 | |
1741000 | 1741000 | 2021-09-21 | Guaynabo | Puerto Rico | 72061 | 6665 | |
1737751 | 1737751 | 2021-09-20 | Guaynabo | Puerto Rico | 72061 | 6663 | |
1734501 | 1734501 | 2021-09-19 | Guaynabo | Puerto Rico | 72061 | 6659 | |
1731251 | 1731251 | 2021-09-18 | Guaynabo | Puerto Rico | 72061 | 6654 | |
1728001 | 1728001 | 2021-09-17 | Guaynabo | Puerto Rico | 72061 | 6647 | |
1724752 | 1724752 | 2021-09-16 | Guaynabo | Puerto Rico | 72061 | 6633 | |
1721503 | 1721503 | 2021-09-15 | Guaynabo | Puerto Rico | 72061 | 6611 | |
1718255 | 1718255 | 2021-09-14 | Guaynabo | Puerto Rico | 72061 | 6601 | |
1715007 | 1715007 | 2021-09-13 | Guaynabo | Puerto Rico | 72061 | 6600 | |
1711761 | 1711761 | 2021-09-12 | Guaynabo | Puerto Rico | 72061 | 6591 | |
1708514 | 1708514 | 2021-09-11 | Guaynabo | Puerto Rico | 72061 | 6574 | |
1705267 | 1705267 | 2021-09-10 | Guaynabo | Puerto Rico | 72061 | 6559 | |
1702017 | 1702017 | 2021-09-09 | Guaynabo | Puerto Rico | 72061 | 6535 | |
1698768 | 1698768 | 2021-09-08 | Guaynabo | Puerto Rico | 72061 | 6520 | |
1695520 | 1695520 | 2021-09-07 | Guaynabo | Puerto Rico | 72061 | 6508 | |
1692272 | 1692272 | 2021-09-06 | Guaynabo | Puerto Rico | 72061 | 6508 | |
1689023 | 1689023 | 2021-09-05 | Guaynabo | Puerto Rico | 72061 | 6496 | |
1685773 | 1685773 | 2021-09-04 | Guaynabo | Puerto Rico | 72061 | 6475 | |
1682522 | 1682522 | 2021-09-03 | Guaynabo | Puerto Rico | 72061 | 6453 | |
1679272 | 1679272 | 2021-09-02 | Guaynabo | Puerto Rico | 72061 | 6422 | |
1676024 | 1676024 | 2021-09-01 | Guaynabo | Puerto Rico | 72061 | 6403 | |
1672777 | 1672777 | 2021-08-31 | Guaynabo | Puerto Rico | 72061 | 6332 | |
1669529 | 1669529 | 2021-08-30 | Guaynabo | Puerto Rico | 72061 | 6326 | |
1666282 | 1666282 | 2021-08-29 | Guaynabo | Puerto Rico | 72061 | 6297 | |
1663034 | 1663034 | 2021-08-28 | Guaynabo | Puerto Rico | 72061 | 6276 | |
1659786 | 1659786 | 2021-08-27 | Guaynabo | Puerto Rico | 72061 | 6246 | |
1656537 | 1656537 | 2021-08-26 | Guaynabo | Puerto Rico | 72061 | 6215 | |
1653290 | 1653290 | 2021-08-25 | Guaynabo | Puerto Rico | 72061 | 6180 | |
1650043 | 1650043 | 2021-08-24 | Guaynabo | Puerto Rico | 72061 | 6154 | |
1646794 | 1646794 | 2021-08-23 | Guaynabo | Puerto Rico | 72061 | 6144 | |
1643545 | 1643545 | 2021-08-22 | Guaynabo | Puerto Rico | 72061 | 6122 | |
1640295 | 1640295 | 2021-08-21 | Guaynabo | Puerto Rico | 72061 | 6096 | |
1637045 | 1637045 | 2021-08-20 | Guaynabo | Puerto Rico | 72061 | 6030 | |
1633795 | 1633795 | 2021-08-19 | Guaynabo | Puerto Rico | 72061 | 5985 | |
1630548 | 1630548 | 2021-08-18 | Guaynabo | Puerto Rico | 72061 | 5971 | |
1627301 | 1627301 | 2021-08-17 | Guaynabo | Puerto Rico | 72061 | 5959 | |
1624054 | 1624054 | 2021-08-16 | Guaynabo | Puerto Rico | 72061 | 5943 | |
1620807 | 1620807 | 2021-08-15 | Guaynabo | Puerto Rico | 72061 | 5916 | |
1617559 | 1617559 | 2021-08-14 | Guaynabo | Puerto Rico | 72061 | 5882 | |
1614311 | 1614311 | 2021-08-13 | Guaynabo | Puerto Rico | 72061 | 5850 | |
1611062 | 1611062 | 2021-08-12 | Guaynabo | Puerto Rico | 72061 | 5798 | |
1607814 | 1607814 | 2021-08-11 | Guaynabo | Puerto Rico | 72061 | 5765 | |
1604565 | 1604565 | 2021-08-10 | Guaynabo | Puerto Rico | 72061 | 5732 | |
1601316 | 1601316 | 2021-08-09 | Guaynabo | Puerto Rico | 72061 | 5728 | |
1598068 | 1598068 | 2021-08-08 | Guaynabo | Puerto Rico | 72061 | 5698 | |
1594819 | 1594819 | 2021-08-07 | Guaynabo | Puerto Rico | 72061 | 5654 | |
1591570 | 1591570 | 2021-08-06 | Guaynabo | Puerto Rico | 72061 | 5646 | |
1588321 | 1588321 | 2021-08-05 | Guaynabo | Puerto Rico | 72061 | 5616 | |
1585071 | 1585071 | 2021-08-04 | Guaynabo | Puerto Rico | 72061 | 5577 | |
1581821 | 1581821 | 2021-08-03 | Guaynabo | Puerto Rico | 72061 | 5566 | |
1578572 | 1578572 | 2021-08-02 | Guaynabo | Puerto Rico | 72061 | 5562 | |
1575324 | 1575324 | 2021-08-01 | Guaynabo | Puerto Rico | 72061 | 5541 | |
1572076 | 1572076 | 2021-07-31 | Guaynabo | Puerto Rico | 72061 | 5514 | |
1568828 | 1568828 | 2021-07-30 | Guaynabo | Puerto Rico | 72061 | 5487 | |
1565580 | 1565580 | 2021-07-29 | Guaynabo | Puerto Rico | 72061 | 5468 | |
1562332 | 1562332 | 2021-07-28 | Guaynabo | Puerto Rico | 72061 | 5455 | |
1559084 | 1559084 | 2021-07-27 | Guaynabo | Puerto Rico | 72061 | 5454 | |
1555837 | 1555837 | 2021-07-26 | Guaynabo | Puerto Rico | 72061 | 5453 | |
1552590 | 1552590 | 2021-07-25 | Guaynabo | Puerto Rico | 72061 | 5443 | |
1549343 | 1549343 | 2021-07-24 | Guaynabo | Puerto Rico | 72061 | 5425 | |
1546096 | 1546096 | 2021-07-23 | Guaynabo | Puerto Rico | 72061 | 5415 | |
1542849 | 1542849 | 2021-07-22 | Guaynabo | Puerto Rico | 72061 | 5387 | |
1539601 | 1539601 | 2021-07-21 | Guaynabo | Puerto Rico | 72061 | 5383 | |
1536354 | 1536354 | 2021-07-20 | Guaynabo | Puerto Rico | 72061 | 5382 | |
1533106 | 1533106 | 2021-07-19 | Guaynabo | Puerto Rico | 72061 | 5378 | |
1529859 | 1529859 | 2021-07-18 | Guaynabo | Puerto Rico | 72061 | 5362 | |
1526612 | 1526612 | 2021-07-17 | Guaynabo | Puerto Rico | 72061 | 5358 | |
1523365 | 1523365 | 2021-07-16 | Guaynabo | Puerto Rico | 72061 | 5354 | |
1520117 | 1520117 | 2021-07-15 | Guaynabo | Puerto Rico | 72061 | 5345 |
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);