ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cameron" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812772 | 1812772 | 2021-10-13 | Cameron | Texas | 48061 | 64822 | 1943 |
1809523 | 1809523 | 2021-10-12 | Cameron | Texas | 48061 | 64555 | 1942 |
1806273 | 1806273 | 2021-10-11 | Cameron | Texas | 48061 | 64555 | 1937 |
1803023 | 1803023 | 2021-10-10 | Cameron | Texas | 48061 | 64555 | 1937 |
1799774 | 1799774 | 2021-10-09 | Cameron | Texas | 48061 | 64555 | 1937 |
1796525 | 1796525 | 2021-10-08 | Cameron | Texas | 48061 | 64394 | 1937 |
1793276 | 1793276 | 2021-10-07 | Cameron | Texas | 48061 | 64270 | 1917 |
1790027 | 1790027 | 2021-10-06 | Cameron | Texas | 48061 | 64184 | 1910 |
1786779 | 1786779 | 2021-10-05 | Cameron | Texas | 48061 | 64082 | 1908 |
1783530 | 1783530 | 2021-10-04 | Cameron | Texas | 48061 | 63896 | 1908 |
1780281 | 1780281 | 2021-10-03 | Cameron | Texas | 48061 | 63896 | 1905 |
1777031 | 1777031 | 2021-10-02 | Cameron | Texas | 48061 | 63896 | 1905 |
1773781 | 1773781 | 2021-10-01 | Cameron | Texas | 48061 | 63769 | 1901 |
1770531 | 1770531 | 2021-09-30 | Cameron | Texas | 48061 | 63628 | 1901 |
1767282 | 1767282 | 2021-09-29 | Cameron | Texas | 48061 | 63553 | 1901 |
1764033 | 1764033 | 2021-09-28 | Cameron | Texas | 48061 | 63441 | 1898 |
1760784 | 1760784 | 2021-09-27 | Cameron | Texas | 48061 | 63227 | 1895 |
1757536 | 1757536 | 2021-09-26 | Cameron | Texas | 48061 | 63227 | 1895 |
1754288 | 1754288 | 2021-09-25 | Cameron | Texas | 48061 | 63120 | 1895 |
1751040 | 1751040 | 2021-09-24 | Cameron | Texas | 48061 | 63120 | 1895 |
1747791 | 1747791 | 2021-09-23 | Cameron | Texas | 48061 | 62927 | 1890 |
1744541 | 1744541 | 2021-09-22 | Cameron | Texas | 48061 | 62791 | 1886 |
1741292 | 1741292 | 2021-09-21 | Cameron | Texas | 48061 | 62541 | 1886 |
1738043 | 1738043 | 2021-09-20 | Cameron | Texas | 48061 | 62289 | 1876 |
1734793 | 1734793 | 2021-09-19 | Cameron | Texas | 48061 | 62289 | 1876 |
1731543 | 1731543 | 2021-09-18 | Cameron | Texas | 48061 | 62289 | 1876 |
1728293 | 1728293 | 2021-09-17 | Cameron | Texas | 48061 | 62157 | 1876 |
1725044 | 1725044 | 2021-09-16 | Cameron | Texas | 48061 | 61935 | 1859 |
1721795 | 1721795 | 2021-09-15 | Cameron | Texas | 48061 | 61774 | 1859 |
1718547 | 1718547 | 2021-09-14 | Cameron | Texas | 48061 | 61583 | 1840 |
1715299 | 1715299 | 2021-09-13 | Cameron | Texas | 48061 | 61192 | 1824 |
1712053 | 1712053 | 2021-09-12 | Cameron | Texas | 48061 | 61192 | 1824 |
1708806 | 1708806 | 2021-09-11 | Cameron | Texas | 48061 | 61192 | 1824 |
1705559 | 1705559 | 2021-09-10 | Cameron | Texas | 48061 | 60950 | 1815 |
1702309 | 1702309 | 2021-09-09 | Cameron | Texas | 48061 | 60791 | 1806 |
1699060 | 1699060 | 2021-09-08 | Cameron | Texas | 48061 | 60553 | 1796 |
1695812 | 1695812 | 2021-09-07 | Cameron | Texas | 48061 | 60138 | 1793 |
1692564 | 1692564 | 2021-09-06 | Cameron | Texas | 48061 | 60138 | 1793 |
1689315 | 1689315 | 2021-09-05 | Cameron | Texas | 48061 | 60138 | 1793 |
1686065 | 1686065 | 2021-09-04 | Cameron | Texas | 48061 | 60138 | 1793 |
1682814 | 1682814 | 2021-09-03 | Cameron | Texas | 48061 | 59833 | 1792 |
1679564 | 1679564 | 2021-09-02 | Cameron | Texas | 48061 | 59649 | 1789 |
1676316 | 1676316 | 2021-09-01 | Cameron | Texas | 48061 | 59351 | 1786 |
1673069 | 1673069 | 2021-08-31 | Cameron | Texas | 48061 | 58963 | 1773 |
1669821 | 1669821 | 2021-08-30 | Cameron | Texas | 48061 | 58560 | 1766 |
1666574 | 1666574 | 2021-08-29 | Cameron | Texas | 48061 | 58560 | 1766 |
1663326 | 1663326 | 2021-08-28 | Cameron | Texas | 48061 | 58560 | 1766 |
1660078 | 1660078 | 2021-08-27 | Cameron | Texas | 48061 | 58390 | 1766 |
1656829 | 1656829 | 2021-08-26 | Cameron | Texas | 48061 | 58017 | 1759 |
1653582 | 1653582 | 2021-08-25 | Cameron | Texas | 48061 | 57784 | 1754 |
1650335 | 1650335 | 2021-08-24 | Cameron | Texas | 48061 | 57404 | 1750 |
1647086 | 1647086 | 2021-08-23 | Cameron | Texas | 48061 | 57009 | 1750 |
1643837 | 1643837 | 2021-08-22 | Cameron | Texas | 48061 | 57009 | 1750 |
1640587 | 1640587 | 2021-08-21 | Cameron | Texas | 48061 | 56720 | 1750 |
1637337 | 1637337 | 2021-08-20 | Cameron | Texas | 48061 | 56720 | 1750 |
1634087 | 1634087 | 2021-08-19 | Cameron | Texas | 48061 | 56307 | 1742 |
1630840 | 1630840 | 2021-08-18 | Cameron | Texas | 48061 | 56077 | 1739 |
1627593 | 1627593 | 2021-08-17 | Cameron | Texas | 48061 | 55740 | 1738 |
1624346 | 1624346 | 2021-08-16 | Cameron | Texas | 48061 | 55180 | 1731 |
1621099 | 1621099 | 2021-08-15 | Cameron | Texas | 48061 | 55180 | 1731 |
1617851 | 1617851 | 2021-08-14 | Cameron | Texas | 48061 | 55180 | 1731 |
1614603 | 1614603 | 2021-08-13 | Cameron | Texas | 48061 | 54661 | 1731 |
1611354 | 1611354 | 2021-08-12 | Cameron | Texas | 48061 | 54365 | 1728 |
1608106 | 1608106 | 2021-08-11 | Cameron | Texas | 48061 | 54228 | 1726 |
1604857 | 1604857 | 2021-08-10 | Cameron | Texas | 48061 | 53899 | 1723 |
1601608 | 1601608 | 2021-08-09 | Cameron | Texas | 48061 | 53312 | 1719 |
1598360 | 1598360 | 2021-08-08 | Cameron | Texas | 48061 | 53312 | 1719 |
1595111 | 1595111 | 2021-08-07 | Cameron | Texas | 48061 | 53312 | 1719 |
1591862 | 1591862 | 2021-08-06 | Cameron | Texas | 48061 | 52702 | 1719 |
1588613 | 1588613 | 2021-08-05 | Cameron | Texas | 48061 | 45068 | 1715 |
1585363 | 1585363 | 2021-08-04 | Cameron | Texas | 48061 | 44963 | 1713 |
1582113 | 1582113 | 2021-08-03 | Cameron | Texas | 48061 | 44817 | 1712 |
1578864 | 1578864 | 2021-08-02 | Cameron | Texas | 48061 | 44509 | 1711 |
1575616 | 1575616 | 2021-08-01 | Cameron | Texas | 48061 | 44509 | 1711 |
1572368 | 1572368 | 2021-07-31 | Cameron | Texas | 48061 | 44509 | 1711 |
1569120 | 1569120 | 2021-07-30 | Cameron | Texas | 48061 | 44358 | 1708 |
1565872 | 1565872 | 2021-07-29 | Cameron | Texas | 48061 | 44176 | 1706 |
1562624 | 1562624 | 2021-07-28 | Cameron | Texas | 48061 | 44091 | 1705 |
1559376 | 1559376 | 2021-07-27 | Cameron | Texas | 48061 | 43970 | 1705 |
1556129 | 1556129 | 2021-07-26 | Cameron | Texas | 48061 | 43743 | 1705 |
1552882 | 1552882 | 2021-07-25 | Cameron | Texas | 48061 | 43743 | 1705 |
1549635 | 1549635 | 2021-07-24 | Cameron | Texas | 48061 | 43743 | 1705 |
1546388 | 1546388 | 2021-07-23 | Cameron | Texas | 48061 | 43604 | 1704 |
1543141 | 1543141 | 2021-07-22 | Cameron | Texas | 48061 | 43488 | 1703 |
1539893 | 1539893 | 2021-07-21 | Cameron | Texas | 48061 | 43438 | 1703 |
1536646 | 1536646 | 2021-07-20 | Cameron | Texas | 48061 | 43340 | 1702 |
1533398 | 1533398 | 2021-07-19 | Cameron | Texas | 48061 | 43147 | 1701 |
1530151 | 1530151 | 2021-07-18 | Cameron | Texas | 48061 | 43147 | 1701 |
1526904 | 1526904 | 2021-07-17 | Cameron | Texas | 48061 | 43147 | 1701 |
1523657 | 1523657 | 2021-07-16 | Cameron | Texas | 48061 | 43045 | 1696 |
1520409 | 1520409 | 2021-07-15 | Cameron | Texas | 48061 | 42988 | 1696 |
1517161 | 1517161 | 2021-07-14 | Cameron | Texas | 48061 | 42912 | 1696 |
1513914 | 1513914 | 2021-07-13 | Cameron | Texas | 48061 | 42874 | 1695 |
1510668 | 1510668 | 2021-07-12 | Cameron | Texas | 48061 | 42701 | 1691 |
1507421 | 1507421 | 2021-07-11 | Cameron | Texas | 48061 | 42701 | 1691 |
1504175 | 1504175 | 2021-07-10 | Cameron | Texas | 48061 | 42701 | 1691 |
1500929 | 1500929 | 2021-07-09 | Cameron | Texas | 48061 | 42629 | 1691 |
1497683 | 1497683 | 2021-07-08 | Cameron | Texas | 48061 | 42581 | 1690 |
1494436 | 1494436 | 2021-07-07 | Cameron | Texas | 48061 | 42530 | 1690 |
1491189 | 1491189 | 2021-07-06 | Cameron | Texas | 48061 | 42400 | 1690 |
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);