ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72003 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 |
---|---|---|---|---|---|---|---|
1812450 | 1812450 | 2021-10-13 | Aguada | Puerto Rico | 72003 | 2415 | |
1809201 | 1809201 | 2021-10-12 | Aguada | Puerto Rico | 72003 | 2414 | |
1805951 | 1805951 | 2021-10-11 | Aguada | Puerto Rico | 72003 | 2414 | |
1802701 | 1802701 | 2021-10-10 | Aguada | Puerto Rico | 72003 | 2413 | |
1799452 | 1799452 | 2021-10-09 | Aguada | Puerto Rico | 72003 | 2413 | |
1796203 | 1796203 | 2021-10-08 | Aguada | Puerto Rico | 72003 | 2411 | |
1792954 | 1792954 | 2021-10-07 | Aguada | Puerto Rico | 72003 | 2409 | |
1789705 | 1789705 | 2021-10-06 | Aguada | Puerto Rico | 72003 | 2409 | |
1786457 | 1786457 | 2021-10-05 | Aguada | Puerto Rico | 72003 | 2407 | |
1783208 | 1783208 | 2021-10-04 | Aguada | Puerto Rico | 72003 | 2406 | |
1779959 | 1779959 | 2021-10-03 | Aguada | Puerto Rico | 72003 | 2406 | |
1776709 | 1776709 | 2021-10-02 | Aguada | Puerto Rico | 72003 | 2405 | |
1773459 | 1773459 | 2021-10-01 | Aguada | Puerto Rico | 72003 | 2405 | |
1770209 | 1770209 | 2021-09-30 | Aguada | Puerto Rico | 72003 | 2404 | |
1766960 | 1766960 | 2021-09-29 | Aguada | Puerto Rico | 72003 | 2404 | |
1763711 | 1763711 | 2021-09-28 | Aguada | Puerto Rico | 72003 | 2403 | |
1760462 | 1760462 | 2021-09-27 | Aguada | Puerto Rico | 72003 | 2403 | |
1757214 | 1757214 | 2021-09-26 | Aguada | Puerto Rico | 72003 | 2403 | |
1753966 | 1753966 | 2021-09-25 | Aguada | Puerto Rico | 72003 | 2399 | |
1750718 | 1750718 | 2021-09-24 | Aguada | Puerto Rico | 72003 | 2389 | |
1747469 | 1747469 | 2021-09-23 | Aguada | Puerto Rico | 72003 | 2387 | |
1744219 | 1744219 | 2021-09-22 | Aguada | Puerto Rico | 72003 | 2387 | |
1740970 | 1740970 | 2021-09-21 | Aguada | Puerto Rico | 72003 | 2378 | |
1737721 | 1737721 | 2021-09-20 | Aguada | Puerto Rico | 72003 | 2378 | |
1734471 | 1734471 | 2021-09-19 | Aguada | Puerto Rico | 72003 | 2377 | |
1731221 | 1731221 | 2021-09-18 | Aguada | Puerto Rico | 72003 | 2373 | |
1727971 | 1727971 | 2021-09-17 | Aguada | Puerto Rico | 72003 | 2373 | |
1724722 | 1724722 | 2021-09-16 | Aguada | Puerto Rico | 72003 | 2371 | |
1721473 | 1721473 | 2021-09-15 | Aguada | Puerto Rico | 72003 | 2368 | |
1718225 | 1718225 | 2021-09-14 | Aguada | Puerto Rico | 72003 | 2365 | |
1714977 | 1714977 | 2021-09-13 | Aguada | Puerto Rico | 72003 | 2365 | |
1711731 | 1711731 | 2021-09-12 | Aguada | Puerto Rico | 72003 | 2364 | |
1708484 | 1708484 | 2021-09-11 | Aguada | Puerto Rico | 72003 | 2363 | |
1705237 | 1705237 | 2021-09-10 | Aguada | Puerto Rico | 72003 | 2362 | |
1701987 | 1701987 | 2021-09-09 | Aguada | Puerto Rico | 72003 | 2361 | |
1698738 | 1698738 | 2021-09-08 | Aguada | Puerto Rico | 72003 | 2361 | |
1695490 | 1695490 | 2021-09-07 | Aguada | Puerto Rico | 72003 | 2357 | |
1692242 | 1692242 | 2021-09-06 | Aguada | Puerto Rico | 72003 | 2357 | |
1688993 | 1688993 | 2021-09-05 | Aguada | Puerto Rico | 72003 | 2355 | |
1685743 | 1685743 | 2021-09-04 | Aguada | Puerto Rico | 72003 | 2346 | |
1682492 | 1682492 | 2021-09-03 | Aguada | Puerto Rico | 72003 | 2335 | |
1679242 | 1679242 | 2021-09-02 | Aguada | Puerto Rico | 72003 | 2323 | |
1675994 | 1675994 | 2021-09-01 | Aguada | Puerto Rico | 72003 | 2314 | |
1672747 | 1672747 | 2021-08-31 | Aguada | Puerto Rico | 72003 | 2283 | |
1669499 | 1669499 | 2021-08-30 | Aguada | Puerto Rico | 72003 | 2283 | |
1666252 | 1666252 | 2021-08-29 | Aguada | Puerto Rico | 72003 | 2280 | |
1663004 | 1663004 | 2021-08-28 | Aguada | Puerto Rico | 72003 | 2265 | |
1659756 | 1659756 | 2021-08-27 | Aguada | Puerto Rico | 72003 | 2256 | |
1656507 | 1656507 | 2021-08-26 | Aguada | Puerto Rico | 72003 | 2246 | |
1653260 | 1653260 | 2021-08-25 | Aguada | Puerto Rico | 72003 | 2239 | |
1650013 | 1650013 | 2021-08-24 | Aguada | Puerto Rico | 72003 | 2221 | |
1646764 | 1646764 | 2021-08-23 | Aguada | Puerto Rico | 72003 | 2219 | |
1643515 | 1643515 | 2021-08-22 | Aguada | Puerto Rico | 72003 | 2210 | |
1640265 | 1640265 | 2021-08-21 | Aguada | Puerto Rico | 72003 | 2191 | |
1637015 | 1637015 | 2021-08-20 | Aguada | Puerto Rico | 72003 | 2165 | |
1633765 | 1633765 | 2021-08-19 | Aguada | Puerto Rico | 72003 | 2137 | |
1630518 | 1630518 | 2021-08-18 | Aguada | Puerto Rico | 72003 | 2136 | |
1627271 | 1627271 | 2021-08-17 | Aguada | Puerto Rico | 72003 | 2134 | |
1624024 | 1624024 | 2021-08-16 | Aguada | Puerto Rico | 72003 | 2131 | |
1620777 | 1620777 | 2021-08-15 | Aguada | Puerto Rico | 72003 | 2115 | |
1617529 | 1617529 | 2021-08-14 | Aguada | Puerto Rico | 72003 | 2090 | |
1614281 | 1614281 | 2021-08-13 | Aguada | Puerto Rico | 72003 | 2083 | |
1611032 | 1611032 | 2021-08-12 | Aguada | Puerto Rico | 72003 | 2056 | |
1607784 | 1607784 | 2021-08-11 | Aguada | Puerto Rico | 72003 | 2026 | |
1604535 | 1604535 | 2021-08-10 | Aguada | Puerto Rico | 72003 | 2018 | |
1601286 | 1601286 | 2021-08-09 | Aguada | Puerto Rico | 72003 | 2013 | |
1598038 | 1598038 | 2021-08-08 | Aguada | Puerto Rico | 72003 | 1999 | |
1594789 | 1594789 | 2021-08-07 | Aguada | Puerto Rico | 72003 | 1974 | |
1591540 | 1591540 | 2021-08-06 | Aguada | Puerto Rico | 72003 | 1950 | |
1588291 | 1588291 | 2021-08-05 | Aguada | Puerto Rico | 72003 | 1914 | |
1585041 | 1585041 | 2021-08-04 | Aguada | Puerto Rico | 72003 | 1876 | |
1581791 | 1581791 | 2021-08-03 | Aguada | Puerto Rico | 72003 | 1853 | |
1578542 | 1578542 | 2021-08-02 | Aguada | Puerto Rico | 72003 | 1846 | |
1575294 | 1575294 | 2021-08-01 | Aguada | Puerto Rico | 72003 | 1820 | |
1572046 | 1572046 | 2021-07-31 | Aguada | Puerto Rico | 72003 | 1793 | |
1568798 | 1568798 | 2021-07-30 | Aguada | Puerto Rico | 72003 | 1750 | |
1565550 | 1565550 | 2021-07-29 | Aguada | Puerto Rico | 72003 | 1735 | |
1562302 | 1562302 | 2021-07-28 | Aguada | Puerto Rico | 72003 | 1714 | |
1559054 | 1559054 | 2021-07-27 | Aguada | Puerto Rico | 72003 | 1699 | |
1555807 | 1555807 | 2021-07-26 | Aguada | Puerto Rico | 72003 | 1697 | |
1552560 | 1552560 | 2021-07-25 | Aguada | Puerto Rico | 72003 | 1685 | |
1549313 | 1549313 | 2021-07-24 | Aguada | Puerto Rico | 72003 | 1670 | |
1546066 | 1546066 | 2021-07-23 | Aguada | Puerto Rico | 72003 | 1637 | |
1542819 | 1542819 | 2021-07-22 | Aguada | Puerto Rico | 72003 | 1607 | |
1539571 | 1539571 | 2021-07-21 | Aguada | Puerto Rico | 72003 | 1599 | |
1536324 | 1536324 | 2021-07-20 | Aguada | Puerto Rico | 72003 | 1596 | |
1533076 | 1533076 | 2021-07-19 | Aguada | Puerto Rico | 72003 | 1595 | |
1529829 | 1529829 | 2021-07-18 | Aguada | Puerto Rico | 72003 | 1589 | |
1526582 | 1526582 | 2021-07-17 | Aguada | Puerto Rico | 72003 | 1581 | |
1523335 | 1523335 | 2021-07-16 | Aguada | Puerto Rico | 72003 | 1569 | |
1520087 | 1520087 | 2021-07-15 | Aguada | Puerto Rico | 72003 | 1564 | |
1516839 | 1516839 | 2021-07-14 | Aguada | Puerto Rico | 72003 | 1562 | |
1513592 | 1513592 | 2021-07-13 | Aguada | Puerto Rico | 72003 | 1562 | |
1510346 | 1510346 | 2021-07-12 | Aguada | Puerto Rico | 72003 | 1561 | |
1507099 | 1507099 | 2021-07-11 | Aguada | Puerto Rico | 72003 | 1561 | |
1503853 | 1503853 | 2021-07-10 | Aguada | Puerto Rico | 72003 | 1561 | |
1500607 | 1500607 | 2021-07-09 | Aguada | Puerto Rico | 72003 | 1560 | |
1497361 | 1497361 | 2021-07-08 | Aguada | Puerto Rico | 72003 | 1559 | |
1494114 | 1494114 | 2021-07-07 | Aguada | Puerto Rico | 72003 | 1559 | |
1490867 | 1490867 | 2021-07-06 | Aguada | Puerto Rico | 72003 | 1559 |
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);