ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72009 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 |
---|---|---|---|---|---|---|---|
1812453 | 1812453 | 2021-10-13 | Aibonito | Puerto Rico | 72009 | 1021 | |
1809204 | 1809204 | 2021-10-12 | Aibonito | Puerto Rico | 72009 | 1021 | |
1805954 | 1805954 | 2021-10-11 | Aibonito | Puerto Rico | 72009 | 1021 | |
1802704 | 1802704 | 2021-10-10 | Aibonito | Puerto Rico | 72009 | 1021 | |
1799455 | 1799455 | 2021-10-09 | Aibonito | Puerto Rico | 72009 | 1021 | |
1796206 | 1796206 | 2021-10-08 | Aibonito | Puerto Rico | 72009 | 1019 | |
1792957 | 1792957 | 2021-10-07 | Aibonito | Puerto Rico | 72009 | 1018 | |
1789708 | 1789708 | 2021-10-06 | Aibonito | Puerto Rico | 72009 | 1015 | |
1786460 | 1786460 | 2021-10-05 | Aibonito | Puerto Rico | 72009 | 1014 | |
1783211 | 1783211 | 2021-10-04 | Aibonito | Puerto Rico | 72009 | 1014 | |
1779962 | 1779962 | 2021-10-03 | Aibonito | Puerto Rico | 72009 | 1013 | |
1776712 | 1776712 | 2021-10-02 | Aibonito | Puerto Rico | 72009 | 1013 | |
1773462 | 1773462 | 2021-10-01 | Aibonito | Puerto Rico | 72009 | 1013 | |
1770212 | 1770212 | 2021-09-30 | Aibonito | Puerto Rico | 72009 | 1013 | |
1766963 | 1766963 | 2021-09-29 | Aibonito | Puerto Rico | 72009 | 1013 | |
1763714 | 1763714 | 2021-09-28 | Aibonito | Puerto Rico | 72009 | 1011 | |
1760465 | 1760465 | 2021-09-27 | Aibonito | Puerto Rico | 72009 | 1011 | |
1757217 | 1757217 | 2021-09-26 | Aibonito | Puerto Rico | 72009 | 1009 | |
1753969 | 1753969 | 2021-09-25 | Aibonito | Puerto Rico | 72009 | 1006 | |
1750721 | 1750721 | 2021-09-24 | Aibonito | Puerto Rico | 72009 | 1005 | |
1747472 | 1747472 | 2021-09-23 | Aibonito | Puerto Rico | 72009 | 1002 | |
1744222 | 1744222 | 2021-09-22 | Aibonito | Puerto Rico | 72009 | 1002 | |
1740973 | 1740973 | 2021-09-21 | Aibonito | Puerto Rico | 72009 | 1002 | |
1737724 | 1737724 | 2021-09-20 | Aibonito | Puerto Rico | 72009 | 1002 | |
1734474 | 1734474 | 2021-09-19 | Aibonito | Puerto Rico | 72009 | 1001 | |
1731224 | 1731224 | 2021-09-18 | Aibonito | Puerto Rico | 72009 | 997 | |
1727974 | 1727974 | 2021-09-17 | Aibonito | Puerto Rico | 72009 | 997 | |
1724725 | 1724725 | 2021-09-16 | Aibonito | Puerto Rico | 72009 | 995 | |
1721476 | 1721476 | 2021-09-15 | Aibonito | Puerto Rico | 72009 | 995 | |
1718228 | 1718228 | 2021-09-14 | Aibonito | Puerto Rico | 72009 | 994 | |
1714980 | 1714980 | 2021-09-13 | Aibonito | Puerto Rico | 72009 | 994 | |
1711734 | 1711734 | 2021-09-12 | Aibonito | Puerto Rico | 72009 | 990 | |
1708487 | 1708487 | 2021-09-11 | Aibonito | Puerto Rico | 72009 | 981 | |
1705240 | 1705240 | 2021-09-10 | Aibonito | Puerto Rico | 72009 | 972 | |
1701990 | 1701990 | 2021-09-09 | Aibonito | Puerto Rico | 72009 | 969 | |
1698741 | 1698741 | 2021-09-08 | Aibonito | Puerto Rico | 72009 | 969 | |
1695493 | 1695493 | 2021-09-07 | Aibonito | Puerto Rico | 72009 | 968 | |
1692245 | 1692245 | 2021-09-06 | Aibonito | Puerto Rico | 72009 | 968 | |
1688996 | 1688996 | 2021-09-05 | Aibonito | Puerto Rico | 72009 | 962 | |
1685746 | 1685746 | 2021-09-04 | Aibonito | Puerto Rico | 72009 | 959 | |
1682495 | 1682495 | 2021-09-03 | Aibonito | Puerto Rico | 72009 | 955 | |
1679245 | 1679245 | 2021-09-02 | Aibonito | Puerto Rico | 72009 | 951 | |
1675997 | 1675997 | 2021-09-01 | Aibonito | Puerto Rico | 72009 | 947 | |
1672750 | 1672750 | 2021-08-31 | Aibonito | Puerto Rico | 72009 | 931 | |
1669502 | 1669502 | 2021-08-30 | Aibonito | Puerto Rico | 72009 | 929 | |
1666255 | 1666255 | 2021-08-29 | Aibonito | Puerto Rico | 72009 | 922 | |
1663007 | 1663007 | 2021-08-28 | Aibonito | Puerto Rico | 72009 | 919 | |
1659759 | 1659759 | 2021-08-27 | Aibonito | Puerto Rico | 72009 | 917 | |
1656510 | 1656510 | 2021-08-26 | Aibonito | Puerto Rico | 72009 | 909 | |
1653263 | 1653263 | 2021-08-25 | Aibonito | Puerto Rico | 72009 | 906 | |
1650016 | 1650016 | 2021-08-24 | Aibonito | Puerto Rico | 72009 | 903 | |
1646767 | 1646767 | 2021-08-23 | Aibonito | Puerto Rico | 72009 | 903 | |
1643518 | 1643518 | 2021-08-22 | Aibonito | Puerto Rico | 72009 | 903 | |
1640268 | 1640268 | 2021-08-21 | Aibonito | Puerto Rico | 72009 | 900 | |
1637018 | 1637018 | 2021-08-20 | Aibonito | Puerto Rico | 72009 | 895 | |
1633768 | 1633768 | 2021-08-19 | Aibonito | Puerto Rico | 72009 | 893 | |
1630521 | 1630521 | 2021-08-18 | Aibonito | Puerto Rico | 72009 | 888 | |
1627274 | 1627274 | 2021-08-17 | Aibonito | Puerto Rico | 72009 | 886 | |
1624027 | 1624027 | 2021-08-16 | Aibonito | Puerto Rico | 72009 | 885 | |
1620780 | 1620780 | 2021-08-15 | Aibonito | Puerto Rico | 72009 | 883 | |
1617532 | 1617532 | 2021-08-14 | Aibonito | Puerto Rico | 72009 | 874 | |
1614284 | 1614284 | 2021-08-13 | Aibonito | Puerto Rico | 72009 | 870 | |
1611035 | 1611035 | 2021-08-12 | Aibonito | Puerto Rico | 72009 | 863 | |
1607787 | 1607787 | 2021-08-11 | Aibonito | Puerto Rico | 72009 | 862 | |
1604538 | 1604538 | 2021-08-10 | Aibonito | Puerto Rico | 72009 | 857 | |
1601289 | 1601289 | 2021-08-09 | Aibonito | Puerto Rico | 72009 | 855 | |
1598041 | 1598041 | 2021-08-08 | Aibonito | Puerto Rico | 72009 | 852 | |
1594792 | 1594792 | 2021-08-07 | Aibonito | Puerto Rico | 72009 | 849 | |
1591543 | 1591543 | 2021-08-06 | Aibonito | Puerto Rico | 72009 | 848 | |
1588294 | 1588294 | 2021-08-05 | Aibonito | Puerto Rico | 72009 | 846 | |
1585044 | 1585044 | 2021-08-04 | Aibonito | Puerto Rico | 72009 | 839 | |
1581794 | 1581794 | 2021-08-03 | Aibonito | Puerto Rico | 72009 | 838 | |
1578545 | 1578545 | 2021-08-02 | Aibonito | Puerto Rico | 72009 | 837 | |
1575297 | 1575297 | 2021-08-01 | Aibonito | Puerto Rico | 72009 | 832 | |
1572049 | 1572049 | 2021-07-31 | Aibonito | Puerto Rico | 72009 | 828 | |
1568801 | 1568801 | 2021-07-30 | Aibonito | Puerto Rico | 72009 | 825 | |
1565553 | 1565553 | 2021-07-29 | Aibonito | Puerto Rico | 72009 | 824 | |
1562305 | 1562305 | 2021-07-28 | Aibonito | Puerto Rico | 72009 | 822 | |
1559057 | 1559057 | 2021-07-27 | Aibonito | Puerto Rico | 72009 | 819 | |
1555810 | 1555810 | 2021-07-26 | Aibonito | Puerto Rico | 72009 | 819 | |
1552563 | 1552563 | 2021-07-25 | Aibonito | Puerto Rico | 72009 | 819 | |
1549316 | 1549316 | 2021-07-24 | Aibonito | Puerto Rico | 72009 | 818 | |
1546069 | 1546069 | 2021-07-23 | Aibonito | Puerto Rico | 72009 | 818 | |
1542822 | 1542822 | 2021-07-22 | Aibonito | Puerto Rico | 72009 | 816 | |
1539574 | 1539574 | 2021-07-21 | Aibonito | Puerto Rico | 72009 | 816 | |
1536327 | 1536327 | 2021-07-20 | Aibonito | Puerto Rico | 72009 | 816 | |
1533079 | 1533079 | 2021-07-19 | Aibonito | Puerto Rico | 72009 | 816 | |
1529832 | 1529832 | 2021-07-18 | Aibonito | Puerto Rico | 72009 | 816 | |
1526585 | 1526585 | 2021-07-17 | Aibonito | Puerto Rico | 72009 | 816 | |
1523338 | 1523338 | 2021-07-16 | Aibonito | Puerto Rico | 72009 | 816 | |
1520090 | 1520090 | 2021-07-15 | Aibonito | Puerto Rico | 72009 | 816 | |
1516842 | 1516842 | 2021-07-14 | Aibonito | Puerto Rico | 72009 | 816 | |
1513595 | 1513595 | 2021-07-13 | Aibonito | Puerto Rico | 72009 | 816 | |
1510349 | 1510349 | 2021-07-12 | Aibonito | Puerto Rico | 72009 | 816 | |
1507102 | 1507102 | 2021-07-11 | Aibonito | Puerto Rico | 72009 | 816 | |
1503856 | 1503856 | 2021-07-10 | Aibonito | Puerto Rico | 72009 | 816 | |
1500610 | 1500610 | 2021-07-09 | Aibonito | Puerto Rico | 72009 | 816 | |
1497364 | 1497364 | 2021-07-08 | Aibonito | Puerto Rico | 72009 | 815 | |
1494117 | 1494117 | 2021-07-07 | Aibonito | Puerto Rico | 72009 | 815 | |
1490870 | 1490870 | 2021-07-06 | Aibonito | Puerto Rico | 72009 | 815 |
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);