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 |
---|---|---|---|---|---|---|---|
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 | |
1487620 | 1487620 | 2021-07-05 | Aguada | Puerto Rico | 72003 | 1559 | |
1484373 | 1484373 | 2021-07-04 | Aguada | Puerto Rico | 72003 | 1559 | |
1481127 | 1481127 | 2021-07-03 | Aguada | Puerto Rico | 72003 | 1558 | |
1477880 | 1477880 | 2021-07-02 | Aguada | Puerto Rico | 72003 | 1557 | |
1474634 | 1474634 | 2021-07-01 | Aguada | Puerto Rico | 72003 | 1557 | |
1471388 | 1471388 | 2021-06-30 | Aguada | Puerto Rico | 72003 | 1557 | |
1468143 | 1468143 | 2021-06-29 | Aguada | Puerto Rico | 72003 | 1557 | |
1464898 | 1464898 | 2021-06-28 | Aguada | Puerto Rico | 72003 | 1558 | |
1461653 | 1461653 | 2021-06-27 | Aguada | Puerto Rico | 72003 | 1558 | |
1458408 | 1458408 | 2021-06-26 | Aguada | Puerto Rico | 72003 | 1558 | |
1455163 | 1455163 | 2021-06-25 | Aguada | Puerto Rico | 72003 | 1557 | |
1451918 | 1451918 | 2021-06-24 | Aguada | Puerto Rico | 72003 | 1556 | |
1448672 | 1448672 | 2021-06-23 | Aguada | Puerto Rico | 72003 | 1556 | |
1445427 | 1445427 | 2021-06-22 | Aguada | Puerto Rico | 72003 | 1557 | |
1442182 | 1442182 | 2021-06-21 | Aguada | Puerto Rico | 72003 | 1557 | |
1438937 | 1438937 | 2021-06-20 | Aguada | Puerto Rico | 72003 | 1557 | |
1435690 | 1435690 | 2021-06-19 | Aguada | Puerto Rico | 72003 | 1557 | |
1432443 | 1432443 | 2021-06-18 | Aguada | Puerto Rico | 72003 | 1556 | |
1429197 | 1429197 | 2021-06-17 | Aguada | Puerto Rico | 72003 | 1555 | |
1425952 | 1425952 | 2021-06-16 | Aguada | Puerto Rico | 72003 | 1555 | |
1422705 | 1422705 | 2021-06-15 | Aguada | Puerto Rico | 72003 | 1555 | |
1419459 | 1419459 | 2021-06-14 | Aguada | Puerto Rico | 72003 | 1555 | |
1416214 | 1416214 | 2021-06-13 | Aguada | Puerto Rico | 72003 | 1555 | |
1412968 | 1412968 | 2021-06-12 | Aguada | Puerto Rico | 72003 | 1555 | |
1409723 | 1409723 | 2021-06-11 | Aguada | Puerto Rico | 72003 | 1554 | |
1406478 | 1406478 | 2021-06-10 | Aguada | Puerto Rico | 72003 | 1554 | |
1403232 | 1403232 | 2021-06-09 | Aguada | Puerto Rico | 72003 | 1554 | |
1399987 | 1399987 | 2021-06-08 | Aguada | Puerto Rico | 72003 | 1554 | |
1396742 | 1396742 | 2021-06-07 | Aguada | Puerto Rico | 72003 | 1552 |
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);