ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Lajas" 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 |
---|---|---|---|---|---|---|---|
1841729 | 1841729 | 2021-10-22 | Lajas | Puerto Rico | 72079 | 814 | |
1838480 | 1838480 | 2021-10-21 | Lajas | Puerto Rico | 72079 | 813 | |
1835231 | 1835231 | 2021-10-20 | Lajas | Puerto Rico | 72079 | 812 | |
1831982 | 1831982 | 2021-10-19 | Lajas | Puerto Rico | 72079 | 810 | |
1828733 | 1828733 | 2021-10-18 | Lajas | Puerto Rico | 72079 | 810 | |
1825484 | 1825484 | 2021-10-17 | Lajas | Puerto Rico | 72079 | 810 | |
1822235 | 1822235 | 2021-10-16 | Lajas | Puerto Rico | 72079 | 810 | |
1818986 | 1818986 | 2021-10-15 | Lajas | Puerto Rico | 72079 | 810 | |
1815737 | 1815737 | 2021-10-14 | Lajas | Puerto Rico | 72079 | 808 | |
1812489 | 1812489 | 2021-10-13 | Lajas | Puerto Rico | 72079 | 805 | |
1809240 | 1809240 | 2021-10-12 | Lajas | Puerto Rico | 72079 | 801 | |
1805990 | 1805990 | 2021-10-11 | Lajas | Puerto Rico | 72079 | 801 | |
1802740 | 1802740 | 2021-10-10 | Lajas | Puerto Rico | 72079 | 801 | |
1799491 | 1799491 | 2021-10-09 | Lajas | Puerto Rico | 72079 | 801 | |
1796242 | 1796242 | 2021-10-08 | Lajas | Puerto Rico | 72079 | 797 | |
1792993 | 1792993 | 2021-10-07 | Lajas | Puerto Rico | 72079 | 795 | |
1789744 | 1789744 | 2021-10-06 | Lajas | Puerto Rico | 72079 | 792 | |
1786496 | 1786496 | 2021-10-05 | Lajas | Puerto Rico | 72079 | 792 | |
1783247 | 1783247 | 2021-10-04 | Lajas | Puerto Rico | 72079 | 792 | |
1779998 | 1779998 | 2021-10-03 | Lajas | Puerto Rico | 72079 | 792 | |
1776748 | 1776748 | 2021-10-02 | Lajas | Puerto Rico | 72079 | 791 | |
1773498 | 1773498 | 2021-10-01 | Lajas | Puerto Rico | 72079 | 790 | |
1770248 | 1770248 | 2021-09-30 | Lajas | Puerto Rico | 72079 | 790 | |
1766999 | 1766999 | 2021-09-29 | Lajas | Puerto Rico | 72079 | 790 | |
1763750 | 1763750 | 2021-09-28 | Lajas | Puerto Rico | 72079 | 789 | |
1760501 | 1760501 | 2021-09-27 | Lajas | Puerto Rico | 72079 | 789 | |
1757253 | 1757253 | 2021-09-26 | Lajas | Puerto Rico | 72079 | 787 | |
1754005 | 1754005 | 2021-09-25 | Lajas | Puerto Rico | 72079 | 787 | |
1750757 | 1750757 | 2021-09-24 | Lajas | Puerto Rico | 72079 | 786 | |
1747508 | 1747508 | 2021-09-23 | Lajas | Puerto Rico | 72079 | 785 | |
1744258 | 1744258 | 2021-09-22 | Lajas | Puerto Rico | 72079 | 785 | |
1741009 | 1741009 | 2021-09-21 | Lajas | Puerto Rico | 72079 | 782 | |
1737760 | 1737760 | 2021-09-20 | Lajas | Puerto Rico | 72079 | 782 | |
1734510 | 1734510 | 2021-09-19 | Lajas | Puerto Rico | 72079 | 779 | |
1731260 | 1731260 | 2021-09-18 | Lajas | Puerto Rico | 72079 | 777 | |
1728010 | 1728010 | 2021-09-17 | Lajas | Puerto Rico | 72079 | 774 | |
1724761 | 1724761 | 2021-09-16 | Lajas | Puerto Rico | 72079 | 772 | |
1721512 | 1721512 | 2021-09-15 | Lajas | Puerto Rico | 72079 | 771 | |
1718264 | 1718264 | 2021-09-14 | Lajas | Puerto Rico | 72079 | 768 | |
1715016 | 1715016 | 2021-09-13 | Lajas | Puerto Rico | 72079 | 767 | |
1711770 | 1711770 | 2021-09-12 | Lajas | Puerto Rico | 72079 | 766 | |
1708523 | 1708523 | 2021-09-11 | Lajas | Puerto Rico | 72079 | 765 | |
1705276 | 1705276 | 2021-09-10 | Lajas | Puerto Rico | 72079 | 765 | |
1702026 | 1702026 | 2021-09-09 | Lajas | Puerto Rico | 72079 | 764 | |
1698777 | 1698777 | 2021-09-08 | Lajas | Puerto Rico | 72079 | 761 | |
1695529 | 1695529 | 2021-09-07 | Lajas | Puerto Rico | 72079 | 756 | |
1692281 | 1692281 | 2021-09-06 | Lajas | Puerto Rico | 72079 | 756 | |
1689032 | 1689032 | 2021-09-05 | Lajas | Puerto Rico | 72079 | 756 | |
1685782 | 1685782 | 2021-09-04 | Lajas | Puerto Rico | 72079 | 756 | |
1682531 | 1682531 | 2021-09-03 | Lajas | Puerto Rico | 72079 | 756 | |
1679281 | 1679281 | 2021-09-02 | Lajas | Puerto Rico | 72079 | 756 | |
1676033 | 1676033 | 2021-09-01 | Lajas | Puerto Rico | 72079 | 754 | |
1672786 | 1672786 | 2021-08-31 | Lajas | Puerto Rico | 72079 | 746 | |
1669538 | 1669538 | 2021-08-30 | Lajas | Puerto Rico | 72079 | 746 | |
1666291 | 1666291 | 2021-08-29 | Lajas | Puerto Rico | 72079 | 739 | |
1663043 | 1663043 | 2021-08-28 | Lajas | Puerto Rico | 72079 | 737 | |
1659795 | 1659795 | 2021-08-27 | Lajas | Puerto Rico | 72079 | 736 | |
1656546 | 1656546 | 2021-08-26 | Lajas | Puerto Rico | 72079 | 734 | |
1653299 | 1653299 | 2021-08-25 | Lajas | Puerto Rico | 72079 | 731 | |
1650052 | 1650052 | 2021-08-24 | Lajas | Puerto Rico | 72079 | 726 | |
1646803 | 1646803 | 2021-08-23 | Lajas | Puerto Rico | 72079 | 726 | |
1643554 | 1643554 | 2021-08-22 | Lajas | Puerto Rico | 72079 | 719 | |
1640304 | 1640304 | 2021-08-21 | Lajas | Puerto Rico | 72079 | 718 | |
1637054 | 1637054 | 2021-08-20 | Lajas | Puerto Rico | 72079 | 713 | |
1633804 | 1633804 | 2021-08-19 | Lajas | Puerto Rico | 72079 | 700 | |
1630557 | 1630557 | 2021-08-18 | Lajas | Puerto Rico | 72079 | 696 | |
1627310 | 1627310 | 2021-08-17 | Lajas | Puerto Rico | 72079 | 692 | |
1624063 | 1624063 | 2021-08-16 | Lajas | Puerto Rico | 72079 | 692 | |
1620816 | 1620816 | 2021-08-15 | Lajas | Puerto Rico | 72079 | 689 | |
1617568 | 1617568 | 2021-08-14 | Lajas | Puerto Rico | 72079 | 685 | |
1614320 | 1614320 | 2021-08-13 | Lajas | Puerto Rico | 72079 | 682 | |
1611071 | 1611071 | 2021-08-12 | Lajas | Puerto Rico | 72079 | 680 | |
1607823 | 1607823 | 2021-08-11 | Lajas | Puerto Rico | 72079 | 678 | |
1604574 | 1604574 | 2021-08-10 | Lajas | Puerto Rico | 72079 | 677 | |
1601325 | 1601325 | 2021-08-09 | Lajas | Puerto Rico | 72079 | 676 | |
1598077 | 1598077 | 2021-08-08 | Lajas | Puerto Rico | 72079 | 674 | |
1594828 | 1594828 | 2021-08-07 | Lajas | Puerto Rico | 72079 | 673 | |
1591579 | 1591579 | 2021-08-06 | Lajas | Puerto Rico | 72079 | 670 | |
1588330 | 1588330 | 2021-08-05 | Lajas | Puerto Rico | 72079 | 668 | |
1585080 | 1585080 | 2021-08-04 | Lajas | Puerto Rico | 72079 | 660 | |
1581830 | 1581830 | 2021-08-03 | Lajas | Puerto Rico | 72079 | 652 | |
1578581 | 1578581 | 2021-08-02 | Lajas | Puerto Rico | 72079 | 652 | |
1575333 | 1575333 | 2021-08-01 | Lajas | Puerto Rico | 72079 | 649 | |
1572085 | 1572085 | 2021-07-31 | Lajas | Puerto Rico | 72079 | 648 | |
1568837 | 1568837 | 2021-07-30 | Lajas | Puerto Rico | 72079 | 644 | |
1565589 | 1565589 | 2021-07-29 | Lajas | Puerto Rico | 72079 | 642 | |
1562341 | 1562341 | 2021-07-28 | Lajas | Puerto Rico | 72079 | 638 | |
1559093 | 1559093 | 2021-07-27 | Lajas | Puerto Rico | 72079 | 630 | |
1555846 | 1555846 | 2021-07-26 | Lajas | Puerto Rico | 72079 | 629 | |
1552599 | 1552599 | 2021-07-25 | Lajas | Puerto Rico | 72079 | 628 | |
1549352 | 1549352 | 2021-07-24 | Lajas | Puerto Rico | 72079 | 625 | |
1546105 | 1546105 | 2021-07-23 | Lajas | Puerto Rico | 72079 | 622 | |
1542858 | 1542858 | 2021-07-22 | Lajas | Puerto Rico | 72079 | 617 | |
1539610 | 1539610 | 2021-07-21 | Lajas | Puerto Rico | 72079 | 617 | |
1536363 | 1536363 | 2021-07-20 | Lajas | Puerto Rico | 72079 | 617 | |
1533115 | 1533115 | 2021-07-19 | Lajas | Puerto Rico | 72079 | 617 | |
1529868 | 1529868 | 2021-07-18 | Lajas | Puerto Rico | 72079 | 614 | |
1526621 | 1526621 | 2021-07-17 | Lajas | Puerto Rico | 72079 | 614 | |
1523374 | 1523374 | 2021-07-16 | Lajas | Puerto Rico | 72079 | 612 | |
1520126 | 1520126 | 2021-07-15 | Lajas | Puerto Rico | 72079 | 611 |
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);