ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72013 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 |
---|---|---|---|---|---|---|---|
1812455 | 1812455 | 2021-10-13 | Arecibo | Puerto Rico | 72013 | 4584 | |
1809206 | 1809206 | 2021-10-12 | Arecibo | Puerto Rico | 72013 | 4578 | |
1805956 | 1805956 | 2021-10-11 | Arecibo | Puerto Rico | 72013 | 4576 | |
1802706 | 1802706 | 2021-10-10 | Arecibo | Puerto Rico | 72013 | 4569 | |
1799457 | 1799457 | 2021-10-09 | Arecibo | Puerto Rico | 72013 | 4569 | |
1796208 | 1796208 | 2021-10-08 | Arecibo | Puerto Rico | 72013 | 4562 | |
1792959 | 1792959 | 2021-10-07 | Arecibo | Puerto Rico | 72013 | 4557 | |
1789710 | 1789710 | 2021-10-06 | Arecibo | Puerto Rico | 72013 | 4547 | |
1786462 | 1786462 | 2021-10-05 | Arecibo | Puerto Rico | 72013 | 4543 | |
1783213 | 1783213 | 2021-10-04 | Arecibo | Puerto Rico | 72013 | 4541 | |
1779964 | 1779964 | 2021-10-03 | Arecibo | Puerto Rico | 72013 | 4542 | |
1776714 | 1776714 | 2021-10-02 | Arecibo | Puerto Rico | 72013 | 4533 | |
1773464 | 1773464 | 2021-10-01 | Arecibo | Puerto Rico | 72013 | 4530 | |
1770214 | 1770214 | 2021-09-30 | Arecibo | Puerto Rico | 72013 | 4526 | |
1766965 | 1766965 | 2021-09-29 | Arecibo | Puerto Rico | 72013 | 4519 | |
1763716 | 1763716 | 2021-09-28 | Arecibo | Puerto Rico | 72013 | 4511 | |
1760467 | 1760467 | 2021-09-27 | Arecibo | Puerto Rico | 72013 | 4511 | |
1757219 | 1757219 | 2021-09-26 | Arecibo | Puerto Rico | 72013 | 4503 | |
1753971 | 1753971 | 2021-09-25 | Arecibo | Puerto Rico | 72013 | 4496 | |
1750723 | 1750723 | 2021-09-24 | Arecibo | Puerto Rico | 72013 | 4476 | |
1747474 | 1747474 | 2021-09-23 | Arecibo | Puerto Rico | 72013 | 4463 | |
1744224 | 1744224 | 2021-09-22 | Arecibo | Puerto Rico | 72013 | 4451 | |
1740975 | 1740975 | 2021-09-21 | Arecibo | Puerto Rico | 72013 | 4436 | |
1737726 | 1737726 | 2021-09-20 | Arecibo | Puerto Rico | 72013 | 4435 | |
1734476 | 1734476 | 2021-09-19 | Arecibo | Puerto Rico | 72013 | 4425 | |
1731226 | 1731226 | 2021-09-18 | Arecibo | Puerto Rico | 72013 | 4420 | |
1727976 | 1727976 | 2021-09-17 | Arecibo | Puerto Rico | 72013 | 4413 | |
1724727 | 1724727 | 2021-09-16 | Arecibo | Puerto Rico | 72013 | 4389 | |
1721478 | 1721478 | 2021-09-15 | Arecibo | Puerto Rico | 72013 | 4367 | |
1718230 | 1718230 | 2021-09-14 | Arecibo | Puerto Rico | 72013 | 4364 | |
1714982 | 1714982 | 2021-09-13 | Arecibo | Puerto Rico | 72013 | 4363 | |
1711736 | 1711736 | 2021-09-12 | Arecibo | Puerto Rico | 72013 | 4349 | |
1708489 | 1708489 | 2021-09-11 | Arecibo | Puerto Rico | 72013 | 4339 | |
1705242 | 1705242 | 2021-09-10 | Arecibo | Puerto Rico | 72013 | 4329 | |
1701992 | 1701992 | 2021-09-09 | Arecibo | Puerto Rico | 72013 | 4300 | |
1698743 | 1698743 | 2021-09-08 | Arecibo | Puerto Rico | 72013 | 4289 | |
1695495 | 1695495 | 2021-09-07 | Arecibo | Puerto Rico | 72013 | 4279 | |
1692247 | 1692247 | 2021-09-06 | Arecibo | Puerto Rico | 72013 | 4276 | |
1688998 | 1688998 | 2021-09-05 | Arecibo | Puerto Rico | 72013 | 4267 | |
1685748 | 1685748 | 2021-09-04 | Arecibo | Puerto Rico | 72013 | 4246 | |
1682497 | 1682497 | 2021-09-03 | Arecibo | Puerto Rico | 72013 | 4230 | |
1679247 | 1679247 | 2021-09-02 | Arecibo | Puerto Rico | 72013 | 4213 | |
1675999 | 1675999 | 2021-09-01 | Arecibo | Puerto Rico | 72013 | 4196 | |
1672752 | 1672752 | 2021-08-31 | Arecibo | Puerto Rico | 72013 | 4138 | |
1669504 | 1669504 | 2021-08-30 | Arecibo | Puerto Rico | 72013 | 4124 | |
1666257 | 1666257 | 2021-08-29 | Arecibo | Puerto Rico | 72013 | 4103 | |
1663009 | 1663009 | 2021-08-28 | Arecibo | Puerto Rico | 72013 | 4087 | |
1659761 | 1659761 | 2021-08-27 | Arecibo | Puerto Rico | 72013 | 4068 | |
1656512 | 1656512 | 2021-08-26 | Arecibo | Puerto Rico | 72013 | 4032 | |
1653265 | 1653265 | 2021-08-25 | Arecibo | Puerto Rico | 72013 | 3999 | |
1650018 | 1650018 | 2021-08-24 | Arecibo | Puerto Rico | 72013 | 3992 | |
1646769 | 1646769 | 2021-08-23 | Arecibo | Puerto Rico | 72013 | 3983 | |
1643520 | 1643520 | 2021-08-22 | Arecibo | Puerto Rico | 72013 | 3974 | |
1640270 | 1640270 | 2021-08-21 | Arecibo | Puerto Rico | 72013 | 3955 | |
1637020 | 1637020 | 2021-08-20 | Arecibo | Puerto Rico | 72013 | 3904 | |
1633770 | 1633770 | 2021-08-19 | Arecibo | Puerto Rico | 72013 | 3889 | |
1630523 | 1630523 | 2021-08-18 | Arecibo | Puerto Rico | 72013 | 3884 | |
1627276 | 1627276 | 2021-08-17 | Arecibo | Puerto Rico | 72013 | 3882 | |
1624029 | 1624029 | 2021-08-16 | Arecibo | Puerto Rico | 72013 | 3875 | |
1620782 | 1620782 | 2021-08-15 | Arecibo | Puerto Rico | 72013 | 3863 | |
1617534 | 1617534 | 2021-08-14 | Arecibo | Puerto Rico | 72013 | 3837 | |
1614286 | 1614286 | 2021-08-13 | Arecibo | Puerto Rico | 72013 | 3820 | |
1611037 | 1611037 | 2021-08-12 | Arecibo | Puerto Rico | 72013 | 3799 | |
1607789 | 1607789 | 2021-08-11 | Arecibo | Puerto Rico | 72013 | 3789 | |
1604540 | 1604540 | 2021-08-10 | Arecibo | Puerto Rico | 72013 | 3780 | |
1601291 | 1601291 | 2021-08-09 | Arecibo | Puerto Rico | 72013 | 3777 | |
1598043 | 1598043 | 2021-08-08 | Arecibo | Puerto Rico | 72013 | 3774 | |
1594794 | 1594794 | 2021-08-07 | Arecibo | Puerto Rico | 72013 | 3760 | |
1591545 | 1591545 | 2021-08-06 | Arecibo | Puerto Rico | 72013 | 3750 | |
1588296 | 1588296 | 2021-08-05 | Arecibo | Puerto Rico | 72013 | 3729 | |
1585046 | 1585046 | 2021-08-04 | Arecibo | Puerto Rico | 72013 | 3713 | |
1581796 | 1581796 | 2021-08-03 | Arecibo | Puerto Rico | 72013 | 3705 | |
1578547 | 1578547 | 2021-08-02 | Arecibo | Puerto Rico | 72013 | 3705 | |
1575299 | 1575299 | 2021-08-01 | Arecibo | Puerto Rico | 72013 | 3691 | |
1572051 | 1572051 | 2021-07-31 | Arecibo | Puerto Rico | 72013 | 3678 | |
1568803 | 1568803 | 2021-07-30 | Arecibo | Puerto Rico | 72013 | 3667 | |
1565555 | 1565555 | 2021-07-29 | Arecibo | Puerto Rico | 72013 | 3661 | |
1562307 | 1562307 | 2021-07-28 | Arecibo | Puerto Rico | 72013 | 3641 | |
1559059 | 1559059 | 2021-07-27 | Arecibo | Puerto Rico | 72013 | 3640 | |
1555812 | 1555812 | 2021-07-26 | Arecibo | Puerto Rico | 72013 | 3637 | |
1552565 | 1552565 | 2021-07-25 | Arecibo | Puerto Rico | 72013 | 3631 | |
1549318 | 1549318 | 2021-07-24 | Arecibo | Puerto Rico | 72013 | 3623 | |
1546071 | 1546071 | 2021-07-23 | Arecibo | Puerto Rico | 72013 | 3613 | |
1542824 | 1542824 | 2021-07-22 | Arecibo | Puerto Rico | 72013 | 3601 | |
1539576 | 1539576 | 2021-07-21 | Arecibo | Puerto Rico | 72013 | 3599 | |
1536329 | 1536329 | 2021-07-20 | Arecibo | Puerto Rico | 72013 | 3597 | |
1533081 | 1533081 | 2021-07-19 | Arecibo | Puerto Rico | 72013 | 3596 | |
1529834 | 1529834 | 2021-07-18 | Arecibo | Puerto Rico | 72013 | 3593 | |
1526587 | 1526587 | 2021-07-17 | Arecibo | Puerto Rico | 72013 | 3592 | |
1523340 | 1523340 | 2021-07-16 | Arecibo | Puerto Rico | 72013 | 3591 | |
1520092 | 1520092 | 2021-07-15 | Arecibo | Puerto Rico | 72013 | 3582 | |
1516844 | 1516844 | 2021-07-14 | Arecibo | Puerto Rico | 72013 | 3582 | |
1513597 | 1513597 | 2021-07-13 | Arecibo | Puerto Rico | 72013 | 3582 | |
1510351 | 1510351 | 2021-07-12 | Arecibo | Puerto Rico | 72013 | 3580 | |
1507104 | 1507104 | 2021-07-11 | Arecibo | Puerto Rico | 72013 | 3576 | |
1503858 | 1503858 | 2021-07-10 | Arecibo | Puerto Rico | 72013 | 3575 | |
1500612 | 1500612 | 2021-07-09 | Arecibo | Puerto Rico | 72013 | 3571 | |
1497366 | 1497366 | 2021-07-08 | Arecibo | Puerto Rico | 72013 | 3571 | |
1494119 | 1494119 | 2021-07-07 | Arecibo | Puerto Rico | 72013 | 3571 | |
1490872 | 1490872 | 2021-07-06 | Arecibo | Puerto Rico | 72013 | 3571 |
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);