ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72097 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 |
---|---|---|---|---|---|---|---|
1841738 | 1841738 | 2021-10-22 | Mayaguez | Puerto Rico | 72097 | 3880 | |
1838489 | 1838489 | 2021-10-21 | Mayaguez | Puerto Rico | 72097 | 3877 | |
1835240 | 1835240 | 2021-10-20 | Mayaguez | Puerto Rico | 72097 | 3875 | |
1831991 | 1831991 | 2021-10-19 | Mayaguez | Puerto Rico | 72097 | 3873 | |
1828742 | 1828742 | 2021-10-18 | Mayaguez | Puerto Rico | 72097 | 3873 | |
1825493 | 1825493 | 2021-10-17 | Mayaguez | Puerto Rico | 72097 | 3870 | |
1822244 | 1822244 | 2021-10-16 | Mayaguez | Puerto Rico | 72097 | 3868 | |
1818995 | 1818995 | 2021-10-15 | Mayaguez | Puerto Rico | 72097 | 3864 | |
1815746 | 1815746 | 2021-10-14 | Mayaguez | Puerto Rico | 72097 | 3862 | |
1812498 | 1812498 | 2021-10-13 | Mayaguez | Puerto Rico | 72097 | 3862 | |
1809249 | 1809249 | 2021-10-12 | Mayaguez | Puerto Rico | 72097 | 3862 | |
1805999 | 1805999 | 2021-10-11 | Mayaguez | Puerto Rico | 72097 | 3863 | |
1802749 | 1802749 | 2021-10-10 | Mayaguez | Puerto Rico | 72097 | 3858 | |
1799500 | 1799500 | 2021-10-09 | Mayaguez | Puerto Rico | 72097 | 3858 | |
1796251 | 1796251 | 2021-10-08 | Mayaguez | Puerto Rico | 72097 | 3857 | |
1793002 | 1793002 | 2021-10-07 | Mayaguez | Puerto Rico | 72097 | 3856 | |
1789753 | 1789753 | 2021-10-06 | Mayaguez | Puerto Rico | 72097 | 3851 | |
1786505 | 1786505 | 2021-10-05 | Mayaguez | Puerto Rico | 72097 | 3847 | |
1783256 | 1783256 | 2021-10-04 | Mayaguez | Puerto Rico | 72097 | 3846 | |
1780007 | 1780007 | 2021-10-03 | Mayaguez | Puerto Rico | 72097 | 3845 | |
1776757 | 1776757 | 2021-10-02 | Mayaguez | Puerto Rico | 72097 | 3844 | |
1773507 | 1773507 | 2021-10-01 | Mayaguez | Puerto Rico | 72097 | 3844 | |
1770257 | 1770257 | 2021-09-30 | Mayaguez | Puerto Rico | 72097 | 3844 | |
1767008 | 1767008 | 2021-09-29 | Mayaguez | Puerto Rico | 72097 | 3840 | |
1763759 | 1763759 | 2021-09-28 | Mayaguez | Puerto Rico | 72097 | 3837 | |
1760510 | 1760510 | 2021-09-27 | Mayaguez | Puerto Rico | 72097 | 3836 | |
1757262 | 1757262 | 2021-09-26 | Mayaguez | Puerto Rico | 72097 | 3833 | |
1754014 | 1754014 | 2021-09-25 | Mayaguez | Puerto Rico | 72097 | 3829 | |
1750766 | 1750766 | 2021-09-24 | Mayaguez | Puerto Rico | 72097 | 3821 | |
1747517 | 1747517 | 2021-09-23 | Mayaguez | Puerto Rico | 72097 | 3818 | |
1744267 | 1744267 | 2021-09-22 | Mayaguez | Puerto Rico | 72097 | 3815 | |
1741018 | 1741018 | 2021-09-21 | Mayaguez | Puerto Rico | 72097 | 3807 | |
1737769 | 1737769 | 2021-09-20 | Mayaguez | Puerto Rico | 72097 | 3805 | |
1734519 | 1734519 | 2021-09-19 | Mayaguez | Puerto Rico | 72097 | 3799 | |
1731269 | 1731269 | 2021-09-18 | Mayaguez | Puerto Rico | 72097 | 3797 | |
1728019 | 1728019 | 2021-09-17 | Mayaguez | Puerto Rico | 72097 | 3792 | |
1724770 | 1724770 | 2021-09-16 | Mayaguez | Puerto Rico | 72097 | 3787 | |
1721521 | 1721521 | 2021-09-15 | Mayaguez | Puerto Rico | 72097 | 3780 | |
1718273 | 1718273 | 2021-09-14 | Mayaguez | Puerto Rico | 72097 | 3778 | |
1715025 | 1715025 | 2021-09-13 | Mayaguez | Puerto Rico | 72097 | 3777 | |
1711779 | 1711779 | 2021-09-12 | Mayaguez | Puerto Rico | 72097 | 3772 | |
1708532 | 1708532 | 2021-09-11 | Mayaguez | Puerto Rico | 72097 | 3765 | |
1705285 | 1705285 | 2021-09-10 | Mayaguez | Puerto Rico | 72097 | 3755 | |
1702035 | 1702035 | 2021-09-09 | Mayaguez | Puerto Rico | 72097 | 3738 | |
1698786 | 1698786 | 2021-09-08 | Mayaguez | Puerto Rico | 72097 | 3734 | |
1695538 | 1695538 | 2021-09-07 | Mayaguez | Puerto Rico | 72097 | 3727 | |
1692290 | 1692290 | 2021-09-06 | Mayaguez | Puerto Rico | 72097 | 3724 | |
1689041 | 1689041 | 2021-09-05 | Mayaguez | Puerto Rico | 72097 | 3721 | |
1685791 | 1685791 | 2021-09-04 | Mayaguez | Puerto Rico | 72097 | 3701 | |
1682540 | 1682540 | 2021-09-03 | Mayaguez | Puerto Rico | 72097 | 3680 | |
1679290 | 1679290 | 2021-09-02 | Mayaguez | Puerto Rico | 72097 | 3657 | |
1676042 | 1676042 | 2021-09-01 | Mayaguez | Puerto Rico | 72097 | 3649 | |
1672795 | 1672795 | 2021-08-31 | Mayaguez | Puerto Rico | 72097 | 3611 | |
1669547 | 1669547 | 2021-08-30 | Mayaguez | Puerto Rico | 72097 | 3608 | |
1666300 | 1666300 | 2021-08-29 | Mayaguez | Puerto Rico | 72097 | 3599 | |
1663052 | 1663052 | 2021-08-28 | Mayaguez | Puerto Rico | 72097 | 3586 | |
1659804 | 1659804 | 2021-08-27 | Mayaguez | Puerto Rico | 72097 | 3565 | |
1656555 | 1656555 | 2021-08-26 | Mayaguez | Puerto Rico | 72097 | 3551 | |
1653308 | 1653308 | 2021-08-25 | Mayaguez | Puerto Rico | 72097 | 3520 | |
1650061 | 1650061 | 2021-08-24 | Mayaguez | Puerto Rico | 72097 | 3495 | |
1646812 | 1646812 | 2021-08-23 | Mayaguez | Puerto Rico | 72097 | 3495 | |
1643563 | 1643563 | 2021-08-22 | Mayaguez | Puerto Rico | 72097 | 3487 | |
1640313 | 1640313 | 2021-08-21 | Mayaguez | Puerto Rico | 72097 | 3472 | |
1637063 | 1637063 | 2021-08-20 | Mayaguez | Puerto Rico | 72097 | 3447 | |
1633813 | 1633813 | 2021-08-19 | Mayaguez | Puerto Rico | 72097 | 3404 | |
1630566 | 1630566 | 2021-08-18 | Mayaguez | Puerto Rico | 72097 | 3399 | |
1627319 | 1627319 | 2021-08-17 | Mayaguez | Puerto Rico | 72097 | 3395 | |
1624072 | 1624072 | 2021-08-16 | Mayaguez | Puerto Rico | 72097 | 3387 | |
1620825 | 1620825 | 2021-08-15 | Mayaguez | Puerto Rico | 72097 | 3377 | |
1617577 | 1617577 | 2021-08-14 | Mayaguez | Puerto Rico | 72097 | 3343 | |
1614329 | 1614329 | 2021-08-13 | Mayaguez | Puerto Rico | 72097 | 3315 | |
1611080 | 1611080 | 2021-08-12 | Mayaguez | Puerto Rico | 72097 | 3257 | |
1607832 | 1607832 | 2021-08-11 | Mayaguez | Puerto Rico | 72097 | 3225 | |
1604583 | 1604583 | 2021-08-10 | Mayaguez | Puerto Rico | 72097 | 3206 | |
1601334 | 1601334 | 2021-08-09 | Mayaguez | Puerto Rico | 72097 | 3194 | |
1598086 | 1598086 | 2021-08-08 | Mayaguez | Puerto Rico | 72097 | 3154 | |
1594837 | 1594837 | 2021-08-07 | Mayaguez | Puerto Rico | 72097 | 3138 | |
1591588 | 1591588 | 2021-08-06 | Mayaguez | Puerto Rico | 72097 | 3109 | |
1588339 | 1588339 | 2021-08-05 | Mayaguez | Puerto Rico | 72097 | 3065 | |
1585089 | 1585089 | 2021-08-04 | Mayaguez | Puerto Rico | 72097 | 3024 | |
1581839 | 1581839 | 2021-08-03 | Mayaguez | Puerto Rico | 72097 | 3014 | |
1578590 | 1578590 | 2021-08-02 | Mayaguez | Puerto Rico | 72097 | 3006 | |
1575342 | 1575342 | 2021-08-01 | Mayaguez | Puerto Rico | 72097 | 2985 | |
1572094 | 1572094 | 2021-07-31 | Mayaguez | Puerto Rico | 72097 | 2956 | |
1568846 | 1568846 | 2021-07-30 | Mayaguez | Puerto Rico | 72097 | 2929 | |
1565598 | 1565598 | 2021-07-29 | Mayaguez | Puerto Rico | 72097 | 2906 | |
1562350 | 1562350 | 2021-07-28 | Mayaguez | Puerto Rico | 72097 | 2880 | |
1559102 | 1559102 | 2021-07-27 | Mayaguez | Puerto Rico | 72097 | 2855 | |
1555855 | 1555855 | 2021-07-26 | Mayaguez | Puerto Rico | 72097 | 2850 | |
1552608 | 1552608 | 2021-07-25 | Mayaguez | Puerto Rico | 72097 | 2837 | |
1549361 | 1549361 | 2021-07-24 | Mayaguez | Puerto Rico | 72097 | 2808 | |
1546114 | 1546114 | 2021-07-23 | Mayaguez | Puerto Rico | 72097 | 2775 | |
1542867 | 1542867 | 2021-07-22 | Mayaguez | Puerto Rico | 72097 | 2703 | |
1539619 | 1539619 | 2021-07-21 | Mayaguez | Puerto Rico | 72097 | 2680 | |
1536372 | 1536372 | 2021-07-20 | Mayaguez | Puerto Rico | 72097 | 2669 | |
1533124 | 1533124 | 2021-07-19 | Mayaguez | Puerto Rico | 72097 | 2653 | |
1529877 | 1529877 | 2021-07-18 | Mayaguez | Puerto Rico | 72097 | 2627 | |
1526630 | 1526630 | 2021-07-17 | Mayaguez | Puerto Rico | 72097 | 2614 | |
1523383 | 1523383 | 2021-07-16 | Mayaguez | Puerto Rico | 72097 | 2604 | |
1520135 | 1520135 | 2021-07-15 | Mayaguez | Puerto Rico | 72097 | 2591 |
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);