ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Denton" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1842043 | 1842043 | 2021-10-22 | Denton | Texas | 48121 | 106582 | 998 |
1838794 | 1838794 | 2021-10-21 | Denton | Texas | 48121 | 106351 | 995 |
1835545 | 1835545 | 2021-10-20 | Denton | Texas | 48121 | 106088 | 985 |
1832296 | 1832296 | 2021-10-19 | Denton | Texas | 48121 | 105739 | 981 |
1829047 | 1829047 | 2021-10-18 | Denton | Texas | 48121 | 105437 | 973 |
1825798 | 1825798 | 2021-10-17 | Denton | Texas | 48121 | 105172 | 972 |
1822549 | 1822549 | 2021-10-16 | Denton | Texas | 48121 | 105172 | 971 |
1819300 | 1819300 | 2021-10-15 | Denton | Texas | 48121 | 105172 | 969 |
1816051 | 1816051 | 2021-10-14 | Denton | Texas | 48121 | 104843 | 965 |
1812803 | 1812803 | 2021-10-13 | Denton | Texas | 48121 | 104490 | 961 |
1809554 | 1809554 | 2021-10-12 | Denton | Texas | 48121 | 104080 | 956 |
1806304 | 1806304 | 2021-10-11 | Denton | Texas | 48121 | 103750 | 953 |
1803054 | 1803054 | 2021-10-10 | Denton | Texas | 48121 | 103345 | 953 |
1799805 | 1799805 | 2021-10-09 | Denton | Texas | 48121 | 103345 | 950 |
1796556 | 1796556 | 2021-10-08 | Denton | Texas | 48121 | 103345 | 945 |
1793307 | 1793307 | 2021-10-07 | Denton | Texas | 48121 | 102980 | 938 |
1790058 | 1790058 | 2021-10-06 | Denton | Texas | 48121 | 102565 | 933 |
1786810 | 1786810 | 2021-10-05 | Denton | Texas | 48121 | 102218 | 928 |
1783561 | 1783561 | 2021-10-04 | Denton | Texas | 48121 | 101775 | 928 |
1780312 | 1780312 | 2021-10-03 | Denton | Texas | 48121 | 101276 | 928 |
1777062 | 1777062 | 2021-10-02 | Denton | Texas | 48121 | 101276 | 927 |
1773812 | 1773812 | 2021-10-01 | Denton | Texas | 48121 | 101276 | 927 |
1770562 | 1770562 | 2021-09-30 | Denton | Texas | 48121 | 100912 | 926 |
1767313 | 1767313 | 2021-09-29 | Denton | Texas | 48121 | 100516 | 921 |
1764064 | 1764064 | 2021-09-28 | Denton | Texas | 48121 | 100007 | 916 |
1760815 | 1760815 | 2021-09-27 | Denton | Texas | 48121 | 99575 | 910 |
1757567 | 1757567 | 2021-09-26 | Denton | Texas | 48121 | 98910 | 910 |
1754319 | 1754319 | 2021-09-25 | Denton | Texas | 48121 | 98910 | 910 |
1751071 | 1751071 | 2021-09-24 | Denton | Texas | 48121 | 98910 | 907 |
1747822 | 1747822 | 2021-09-23 | Denton | Texas | 48121 | 98461 | 899 |
1744572 | 1744572 | 2021-09-22 | Denton | Texas | 48121 | 97996 | 891 |
1741323 | 1741323 | 2021-09-21 | Denton | Texas | 48121 | 97522 | 886 |
1738074 | 1738074 | 2021-09-20 | Denton | Texas | 48121 | 96986 | 884 |
1734824 | 1734824 | 2021-09-19 | Denton | Texas | 48121 | 96307 | 883 |
1731574 | 1731574 | 2021-09-18 | Denton | Texas | 48121 | 96307 | 882 |
1728324 | 1728324 | 2021-09-17 | Denton | Texas | 48121 | 96307 | 879 |
1725075 | 1725075 | 2021-09-16 | Denton | Texas | 48121 | 95732 | 877 |
1721826 | 1721826 | 2021-09-15 | Denton | Texas | 48121 | 95222 | 871 |
1718578 | 1718578 | 2021-09-14 | Denton | Texas | 48121 | 94675 | 867 |
1715330 | 1715330 | 2021-09-13 | Denton | Texas | 48121 | 94032 | 861 |
1712084 | 1712084 | 2021-09-12 | Denton | Texas | 48121 | 93227 | 860 |
1708837 | 1708837 | 2021-09-11 | Denton | Texas | 48121 | 93227 | 860 |
1705590 | 1705590 | 2021-09-10 | Denton | Texas | 48121 | 93227 | 856 |
1702340 | 1702340 | 2021-09-09 | Denton | Texas | 48121 | 92764 | 851 |
1699091 | 1699091 | 2021-09-08 | Denton | Texas | 48121 | 92195 | 849 |
1695843 | 1695843 | 2021-09-07 | Denton | Texas | 48121 | 91622 | 845 |
1692595 | 1692595 | 2021-09-06 | Denton | Texas | 48121 | 90570 | 841 |
1689346 | 1689346 | 2021-09-05 | Denton | Texas | 48121 | 90570 | 841 |
1686096 | 1686096 | 2021-09-04 | Denton | Texas | 48121 | 90570 | 840 |
1682845 | 1682845 | 2021-09-03 | Denton | Texas | 48121 | 90570 | 839 |
1679595 | 1679595 | 2021-09-02 | Denton | Texas | 48121 | 90124 | 836 |
1676347 | 1676347 | 2021-09-01 | Denton | Texas | 48121 | 89790 | 834 |
1673100 | 1673100 | 2021-08-31 | Denton | Texas | 48121 | 89374 | 830 |
1669852 | 1669852 | 2021-08-30 | Denton | Texas | 48121 | 88916 | 829 |
1666605 | 1666605 | 2021-08-29 | Denton | Texas | 48121 | 88221 | 829 |
1663357 | 1663357 | 2021-08-28 | Denton | Texas | 48121 | 88221 | 828 |
1660109 | 1660109 | 2021-08-27 | Denton | Texas | 48121 | 88221 | 824 |
1656860 | 1656860 | 2021-08-26 | Denton | Texas | 48121 | 87828 | 821 |
1653613 | 1653613 | 2021-08-25 | Denton | Texas | 48121 | 87402 | 818 |
1650366 | 1650366 | 2021-08-24 | Denton | Texas | 48121 | 86996 | 814 |
1647117 | 1647117 | 2021-08-23 | Denton | Texas | 48121 | 86481 | 813 |
1643868 | 1643868 | 2021-08-22 | Denton | Texas | 48121 | 85855 | 812 |
1640618 | 1640618 | 2021-08-21 | Denton | Texas | 48121 | 85855 | 812 |
1637368 | 1637368 | 2021-08-20 | Denton | Texas | 48121 | 85855 | 809 |
1634118 | 1634118 | 2021-08-19 | Denton | Texas | 48121 | 85457 | 808 |
1630871 | 1630871 | 2021-08-18 | Denton | Texas | 48121 | 85030 | 805 |
1627624 | 1627624 | 2021-08-17 | Denton | Texas | 48121 | 84629 | 802 |
1624377 | 1624377 | 2021-08-16 | Denton | Texas | 48121 | 84214 | 801 |
1621130 | 1621130 | 2021-08-15 | Denton | Texas | 48121 | 83509 | 801 |
1617882 | 1617882 | 2021-08-14 | Denton | Texas | 48121 | 83509 | 800 |
1614634 | 1614634 | 2021-08-13 | Denton | Texas | 48121 | 83509 | 800 |
1611385 | 1611385 | 2021-08-12 | Denton | Texas | 48121 | 83129 | 799 |
1608137 | 1608137 | 2021-08-11 | Denton | Texas | 48121 | 82631 | 797 |
1604888 | 1604888 | 2021-08-10 | Denton | Texas | 48121 | 82101 | 795 |
1601639 | 1601639 | 2021-08-09 | Denton | Texas | 48121 | 81621 | 793 |
1598391 | 1598391 | 2021-08-08 | Denton | Texas | 48121 | 80840 | 793 |
1595142 | 1595142 | 2021-08-07 | Denton | Texas | 48121 | 80840 | 793 |
1591893 | 1591893 | 2021-08-06 | Denton | Texas | 48121 | 80840 | 793 |
1588644 | 1588644 | 2021-08-05 | Denton | Texas | 48121 | 80500 | 793 |
1585394 | 1585394 | 2021-08-04 | Denton | Texas | 48121 | 80333 | 792 |
1582144 | 1582144 | 2021-08-03 | Denton | Texas | 48121 | 80161 | 792 |
1578895 | 1578895 | 2021-08-02 | Denton | Texas | 48121 | 79982 | 790 |
1575647 | 1575647 | 2021-08-01 | Denton | Texas | 48121 | 79711 | 790 |
1572399 | 1572399 | 2021-07-31 | Denton | Texas | 48121 | 79711 | 790 |
1569151 | 1569151 | 2021-07-30 | Denton | Texas | 48121 | 79711 | 790 |
1565903 | 1565903 | 2021-07-29 | Denton | Texas | 48121 | 79563 | 790 |
1562655 | 1562655 | 2021-07-28 | Denton | Texas | 48121 | 79359 | 790 |
1559407 | 1559407 | 2021-07-27 | Denton | Texas | 48121 | 79128 | 789 |
1556160 | 1556160 | 2021-07-26 | Denton | Texas | 48121 | 78924 | 788 |
1552913 | 1552913 | 2021-07-25 | Denton | Texas | 48121 | 78793 | 788 |
1549666 | 1549666 | 2021-07-24 | Denton | Texas | 48121 | 78793 | 788 |
1546419 | 1546419 | 2021-07-23 | Denton | Texas | 48121 | 78793 | 787 |
1543172 | 1543172 | 2021-07-22 | Denton | Texas | 48121 | 78678 | 787 |
1539924 | 1539924 | 2021-07-21 | Denton | Texas | 48121 | 78476 | 786 |
1536677 | 1536677 | 2021-07-20 | Denton | Texas | 48121 | 78267 | 785 |
1533429 | 1533429 | 2021-07-19 | Denton | Texas | 48121 | 78102 | 785 |
1530182 | 1530182 | 2021-07-18 | Denton | Texas | 48121 | 77935 | 785 |
1526935 | 1526935 | 2021-07-17 | Denton | Texas | 48121 | 77935 | 785 |
1523688 | 1523688 | 2021-07-16 | Denton | Texas | 48121 | 77935 | 783 |
1520440 | 1520440 | 2021-07-15 | Denton | Texas | 48121 | 77820 | 783 |
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);