ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Caguas" 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 |
---|---|---|---|---|---|---|---|
1812461 | 1812461 | 2021-10-13 | Caguas | Puerto Rico | 72025 | 8890 | |
1809212 | 1809212 | 2021-10-12 | Caguas | Puerto Rico | 72025 | 8884 | |
1805962 | 1805962 | 2021-10-11 | Caguas | Puerto Rico | 72025 | 8884 | |
1802712 | 1802712 | 2021-10-10 | Caguas | Puerto Rico | 72025 | 8879 | |
1799463 | 1799463 | 2021-10-09 | Caguas | Puerto Rico | 72025 | 8879 | |
1796214 | 1796214 | 2021-10-08 | Caguas | Puerto Rico | 72025 | 8878 | |
1792965 | 1792965 | 2021-10-07 | Caguas | Puerto Rico | 72025 | 8874 | |
1789716 | 1789716 | 2021-10-06 | Caguas | Puerto Rico | 72025 | 8871 | |
1786468 | 1786468 | 2021-10-05 | Caguas | Puerto Rico | 72025 | 8869 | |
1783219 | 1783219 | 2021-10-04 | Caguas | Puerto Rico | 72025 | 8868 | |
1779970 | 1779970 | 2021-10-03 | Caguas | Puerto Rico | 72025 | 8867 | |
1776720 | 1776720 | 2021-10-02 | Caguas | Puerto Rico | 72025 | 8863 | |
1773470 | 1773470 | 2021-10-01 | Caguas | Puerto Rico | 72025 | 8857 | |
1770220 | 1770220 | 2021-09-30 | Caguas | Puerto Rico | 72025 | 8855 | |
1766971 | 1766971 | 2021-09-29 | Caguas | Puerto Rico | 72025 | 8853 | |
1763722 | 1763722 | 2021-09-28 | Caguas | Puerto Rico | 72025 | 8850 | |
1760473 | 1760473 | 2021-09-27 | Caguas | Puerto Rico | 72025 | 8849 | |
1757225 | 1757225 | 2021-09-26 | Caguas | Puerto Rico | 72025 | 8845 | |
1753977 | 1753977 | 2021-09-25 | Caguas | Puerto Rico | 72025 | 8835 | |
1750729 | 1750729 | 2021-09-24 | Caguas | Puerto Rico | 72025 | 8826 | |
1747480 | 1747480 | 2021-09-23 | Caguas | Puerto Rico | 72025 | 8815 | |
1744230 | 1744230 | 2021-09-22 | Caguas | Puerto Rico | 72025 | 8805 | |
1740981 | 1740981 | 2021-09-21 | Caguas | Puerto Rico | 72025 | 8795 | |
1737732 | 1737732 | 2021-09-20 | Caguas | Puerto Rico | 72025 | 8791 | |
1734482 | 1734482 | 2021-09-19 | Caguas | Puerto Rico | 72025 | 8783 | |
1731232 | 1731232 | 2021-09-18 | Caguas | Puerto Rico | 72025 | 8780 | |
1727982 | 1727982 | 2021-09-17 | Caguas | Puerto Rico | 72025 | 8764 | |
1724733 | 1724733 | 2021-09-16 | Caguas | Puerto Rico | 72025 | 8751 | |
1721484 | 1721484 | 2021-09-15 | Caguas | Puerto Rico | 72025 | 8738 | |
1718236 | 1718236 | 2021-09-14 | Caguas | Puerto Rico | 72025 | 8723 | |
1714988 | 1714988 | 2021-09-13 | Caguas | Puerto Rico | 72025 | 8725 | |
1711742 | 1711742 | 2021-09-12 | Caguas | Puerto Rico | 72025 | 8712 | |
1708495 | 1708495 | 2021-09-11 | Caguas | Puerto Rico | 72025 | 8699 | |
1705248 | 1705248 | 2021-09-10 | Caguas | Puerto Rico | 72025 | 8686 | |
1701998 | 1701998 | 2021-09-09 | Caguas | Puerto Rico | 72025 | 8645 | |
1698749 | 1698749 | 2021-09-08 | Caguas | Puerto Rico | 72025 | 8633 | |
1695501 | 1695501 | 2021-09-07 | Caguas | Puerto Rico | 72025 | 8628 | |
1692253 | 1692253 | 2021-09-06 | Caguas | Puerto Rico | 72025 | 8624 | |
1689004 | 1689004 | 2021-09-05 | Caguas | Puerto Rico | 72025 | 8599 | |
1685754 | 1685754 | 2021-09-04 | Caguas | Puerto Rico | 72025 | 8570 | |
1682503 | 1682503 | 2021-09-03 | Caguas | Puerto Rico | 72025 | 8541 | |
1679253 | 1679253 | 2021-09-02 | Caguas | Puerto Rico | 72025 | 8514 | |
1676005 | 1676005 | 2021-09-01 | Caguas | Puerto Rico | 72025 | 8503 | |
1672758 | 1672758 | 2021-08-31 | Caguas | Puerto Rico | 72025 | 8420 | |
1669510 | 1669510 | 2021-08-30 | Caguas | Puerto Rico | 72025 | 8417 | |
1666263 | 1666263 | 2021-08-29 | Caguas | Puerto Rico | 72025 | 8387 | |
1663015 | 1663015 | 2021-08-28 | Caguas | Puerto Rico | 72025 | 8361 | |
1659767 | 1659767 | 2021-08-27 | Caguas | Puerto Rico | 72025 | 8334 | |
1656518 | 1656518 | 2021-08-26 | Caguas | Puerto Rico | 72025 | 8301 | |
1653271 | 1653271 | 2021-08-25 | Caguas | Puerto Rico | 72025 | 8259 | |
1650024 | 1650024 | 2021-08-24 | Caguas | Puerto Rico | 72025 | 8232 | |
1646775 | 1646775 | 2021-08-23 | Caguas | Puerto Rico | 72025 | 8226 | |
1643526 | 1643526 | 2021-08-22 | Caguas | Puerto Rico | 72025 | 8210 | |
1640276 | 1640276 | 2021-08-21 | Caguas | Puerto Rico | 72025 | 8171 | |
1637026 | 1637026 | 2021-08-20 | Caguas | Puerto Rico | 72025 | 8099 | |
1633776 | 1633776 | 2021-08-19 | Caguas | Puerto Rico | 72025 | 8051 | |
1630529 | 1630529 | 2021-08-18 | Caguas | Puerto Rico | 72025 | 8039 | |
1627282 | 1627282 | 2021-08-17 | Caguas | Puerto Rico | 72025 | 8035 | |
1624035 | 1624035 | 2021-08-16 | Caguas | Puerto Rico | 72025 | 8015 | |
1620788 | 1620788 | 2021-08-15 | Caguas | Puerto Rico | 72025 | 7994 | |
1617540 | 1617540 | 2021-08-14 | Caguas | Puerto Rico | 72025 | 7928 | |
1614292 | 1614292 | 2021-08-13 | Caguas | Puerto Rico | 72025 | 7882 | |
1611043 | 1611043 | 2021-08-12 | Caguas | Puerto Rico | 72025 | 7843 | |
1607795 | 1607795 | 2021-08-11 | Caguas | Puerto Rico | 72025 | 7795 | |
1604546 | 1604546 | 2021-08-10 | Caguas | Puerto Rico | 72025 | 7777 | |
1601297 | 1601297 | 2021-08-09 | Caguas | Puerto Rico | 72025 | 7761 | |
1598049 | 1598049 | 2021-08-08 | Caguas | Puerto Rico | 72025 | 7736 | |
1594800 | 1594800 | 2021-08-07 | Caguas | Puerto Rico | 72025 | 7704 | |
1591551 | 1591551 | 2021-08-06 | Caguas | Puerto Rico | 72025 | 7698 | |
1588302 | 1588302 | 2021-08-05 | Caguas | Puerto Rico | 72025 | 7669 | |
1585052 | 1585052 | 2021-08-04 | Caguas | Puerto Rico | 72025 | 7636 | |
1581802 | 1581802 | 2021-08-03 | Caguas | Puerto Rico | 72025 | 7625 | |
1578553 | 1578553 | 2021-08-02 | Caguas | Puerto Rico | 72025 | 7621 | |
1575305 | 1575305 | 2021-08-01 | Caguas | Puerto Rico | 72025 | 7595 | |
1572057 | 1572057 | 2021-07-31 | Caguas | Puerto Rico | 72025 | 7571 | |
1568809 | 1568809 | 2021-07-30 | Caguas | Puerto Rico | 72025 | 7552 | |
1565561 | 1565561 | 2021-07-29 | Caguas | Puerto Rico | 72025 | 7518 | |
1562313 | 1562313 | 2021-07-28 | Caguas | Puerto Rico | 72025 | 7507 | |
1559065 | 1559065 | 2021-07-27 | Caguas | Puerto Rico | 72025 | 7502 | |
1555818 | 1555818 | 2021-07-26 | Caguas | Puerto Rico | 72025 | 7491 | |
1552571 | 1552571 | 2021-07-25 | Caguas | Puerto Rico | 72025 | 7476 | |
1549324 | 1549324 | 2021-07-24 | Caguas | Puerto Rico | 72025 | 7460 | |
1546077 | 1546077 | 2021-07-23 | Caguas | Puerto Rico | 72025 | 7450 | |
1542830 | 1542830 | 2021-07-22 | Caguas | Puerto Rico | 72025 | 7430 | |
1539582 | 1539582 | 2021-07-21 | Caguas | Puerto Rico | 72025 | 7429 | |
1536335 | 1536335 | 2021-07-20 | Caguas | Puerto Rico | 72025 | 7426 | |
1533087 | 1533087 | 2021-07-19 | Caguas | Puerto Rico | 72025 | 7418 | |
1529840 | 1529840 | 2021-07-18 | Caguas | Puerto Rico | 72025 | 7412 | |
1526593 | 1526593 | 2021-07-17 | Caguas | Puerto Rico | 72025 | 7400 | |
1523346 | 1523346 | 2021-07-16 | Caguas | Puerto Rico | 72025 | 7392 | |
1520098 | 1520098 | 2021-07-15 | Caguas | Puerto Rico | 72025 | 7383 | |
1516850 | 1516850 | 2021-07-14 | Caguas | Puerto Rico | 72025 | 7381 | |
1513603 | 1513603 | 2021-07-13 | Caguas | Puerto Rico | 72025 | 7381 | |
1510357 | 1510357 | 2021-07-12 | Caguas | Puerto Rico | 72025 | 7380 | |
1507110 | 1507110 | 2021-07-11 | Caguas | Puerto Rico | 72025 | 7378 | |
1503864 | 1503864 | 2021-07-10 | Caguas | Puerto Rico | 72025 | 7374 | |
1500618 | 1500618 | 2021-07-09 | Caguas | Puerto Rico | 72025 | 7370 | |
1497372 | 1497372 | 2021-07-08 | Caguas | Puerto Rico | 72025 | 7365 | |
1494125 | 1494125 | 2021-07-07 | Caguas | Puerto Rico | 72025 | 7363 | |
1490878 | 1490878 | 2021-07-06 | Caguas | Puerto Rico | 72025 | 7363 |
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);