ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 48085 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949264 | 1949264 | 2021-11-24 | Collin | Texas | 48085 | 132045 | 1163 |
1946013 | 1946013 | 2021-11-23 | Collin | Texas | 48085 | 131941 | 1161 |
1942762 | 1942762 | 2021-11-22 | Collin | Texas | 48085 | 131717 | 1158 |
1939512 | 1939512 | 2021-11-21 | Collin | Texas | 48085 | 131507 | 1158 |
1936262 | 1936262 | 2021-11-20 | Collin | Texas | 48085 | 131507 | 1158 |
1933012 | 1933012 | 2021-11-19 | Collin | Texas | 48085 | 131486 | 1158 |
1929761 | 1929761 | 2021-11-18 | Collin | Texas | 48085 | 131486 | 1157 |
1926511 | 1926511 | 2021-11-17 | Collin | Texas | 48085 | 130817 | 1155 |
1923261 | 1923261 | 2021-11-16 | Collin | Texas | 48085 | 130817 | 1153 |
1920012 | 1920012 | 2021-11-15 | Collin | Texas | 48085 | 130817 | 1151 |
1916762 | 1916762 | 2021-11-14 | Collin | Texas | 48085 | 130817 | 1151 |
1913512 | 1913512 | 2021-11-13 | Collin | Texas | 48085 | 130817 | 1151 |
1910262 | 1910262 | 2021-11-12 | Collin | Texas | 48085 | 130747 | 1149 |
1907013 | 1907013 | 2021-11-11 | Collin | Texas | 48085 | 130578 | 1147 |
1903764 | 1903764 | 2021-11-10 | Collin | Texas | 48085 | 130389 | 1142 |
1900514 | 1900514 | 2021-11-09 | Collin | Texas | 48085 | 130389 | 1142 |
1897264 | 1897264 | 2021-11-08 | Collin | Texas | 48085 | 130343 | 1140 |
1894014 | 1894014 | 2021-11-07 | Collin | Texas | 48085 | 130260 | 1140 |
1890764 | 1890764 | 2021-11-06 | Collin | Texas | 48085 | 130133 | 1139 |
1887514 | 1887514 | 2021-11-05 | Collin | Texas | 48085 | 130014 | 1138 |
1884264 | 1884264 | 2021-11-04 | Collin | Texas | 48085 | 129892 | 1136 |
1881015 | 1881015 | 2021-11-03 | Collin | Texas | 48085 | 129803 | 1131 |
1877766 | 1877766 | 2021-11-02 | Collin | Texas | 48085 | 129729 | 1130 |
1874517 | 1874517 | 2021-11-01 | Collin | Texas | 48085 | 129641 | 1130 |
1871268 | 1871268 | 2021-10-31 | Collin | Texas | 48085 | 129547 | 1130 |
1868019 | 1868019 | 2021-10-30 | Collin | Texas | 48085 | 129447 | 1129 |
1864770 | 1864770 | 2021-10-29 | Collin | Texas | 48085 | 129302 | 1127 |
1861521 | 1861521 | 2021-10-28 | Collin | Texas | 48085 | 129153 | 1122 |
1858272 | 1858272 | 2021-10-27 | Collin | Texas | 48085 | 129019 | 1119 |
1855023 | 1855023 | 2021-10-26 | Collin | Texas | 48085 | 128882 | 1117 |
1851774 | 1851774 | 2021-10-25 | Collin | Texas | 48085 | 128707 | 1115 |
1848524 | 1848524 | 2021-10-24 | Collin | Texas | 48085 | 128614 | 1115 |
1845274 | 1845274 | 2021-10-23 | Collin | Texas | 48085 | 128487 | 1115 |
1842024 | 1842024 | 2021-10-22 | Collin | Texas | 48085 | 128337 | 1107 |
1838775 | 1838775 | 2021-10-21 | Collin | Texas | 48085 | 128184 | 1101 |
1835526 | 1835526 | 2021-10-20 | Collin | Texas | 48085 | 128037 | 1097 |
1832277 | 1832277 | 2021-10-19 | Collin | Texas | 48085 | 127923 | 1090 |
1829028 | 1829028 | 2021-10-18 | Collin | Texas | 48085 | 127723 | 1081 |
1825779 | 1825779 | 2021-10-17 | Collin | Texas | 48085 | 127569 | 1081 |
1822530 | 1822530 | 2021-10-16 | Collin | Texas | 48085 | 127472 | 1079 |
1819281 | 1819281 | 2021-10-15 | Collin | Texas | 48085 | 127260 | 1075 |
1816032 | 1816032 | 2021-10-14 | Collin | Texas | 48085 | 127110 | 1070 |
1812784 | 1812784 | 2021-10-13 | Collin | Texas | 48085 | 126948 | 1066 |
1809535 | 1809535 | 2021-10-12 | Collin | Texas | 48085 | 126826 | 1065 |
1806285 | 1806285 | 2021-10-11 | Collin | Texas | 48085 | 126634 | 1062 |
1803035 | 1803035 | 2021-10-10 | Collin | Texas | 48085 | 126354 | 1062 |
1799786 | 1799786 | 2021-10-09 | Collin | Texas | 48085 | 126282 | 1061 |
1796537 | 1796537 | 2021-10-08 | Collin | Texas | 48085 | 126045 | 1056 |
1793288 | 1793288 | 2021-10-07 | Collin | Texas | 48085 | 125767 | 1050 |
1790039 | 1790039 | 2021-10-06 | Collin | Texas | 48085 | 125490 | 1046 |
1786791 | 1786791 | 2021-10-05 | Collin | Texas | 48085 | 125307 | 1042 |
1783542 | 1783542 | 2021-10-04 | Collin | Texas | 48085 | 125057 | 1036 |
1780293 | 1780293 | 2021-10-03 | Collin | Texas | 48085 | 124827 | 1035 |
1777043 | 1777043 | 2021-10-02 | Collin | Texas | 48085 | 124630 | 1032 |
1773793 | 1773793 | 2021-10-01 | Collin | Texas | 48085 | 124367 | 1025 |
1770543 | 1770543 | 2021-09-30 | Collin | Texas | 48085 | 123828 | 1021 |
1767294 | 1767294 | 2021-09-29 | Collin | Texas | 48085 | 123792 | 1014 |
1764045 | 1764045 | 2021-09-28 | Collin | Texas | 48085 | 123388 | 1009 |
1760796 | 1760796 | 2021-09-27 | Collin | Texas | 48085 | 123037 | 1005 |
1757548 | 1757548 | 2021-09-26 | Collin | Texas | 48085 | 122807 | 1004 |
1754300 | 1754300 | 2021-09-25 | Collin | Texas | 48085 | 122350 | 1002 |
1751052 | 1751052 | 2021-09-24 | Collin | Texas | 48085 | 122158 | 999 |
1747803 | 1747803 | 2021-09-23 | Collin | Texas | 48085 | 121831 | 992 |
1744553 | 1744553 | 2021-09-22 | Collin | Texas | 48085 | 121738 | 983 |
1741304 | 1741304 | 2021-09-21 | Collin | Texas | 48085 | 121267 | 979 |
1738055 | 1738055 | 2021-09-20 | Collin | Texas | 48085 | 120916 | 974 |
1734805 | 1734805 | 2021-09-19 | Collin | Texas | 48085 | 120808 | 970 |
1731555 | 1731555 | 2021-09-18 | Collin | Texas | 48085 | 120640 | 970 |
1728305 | 1728305 | 2021-09-17 | Collin | Texas | 48085 | 119778 | 961 |
1725056 | 1725056 | 2021-09-16 | Collin | Texas | 48085 | 119342 | 959 |
1721807 | 1721807 | 2021-09-15 | Collin | Texas | 48085 | 118827 | 954 |
1718559 | 1718559 | 2021-09-14 | Collin | Texas | 48085 | 118184 | 948 |
1715311 | 1715311 | 2021-09-13 | Collin | Texas | 48085 | 117706 | 943 |
1712065 | 1712065 | 2021-09-12 | Collin | Texas | 48085 | 117227 | 942 |
1708818 | 1708818 | 2021-09-11 | Collin | Texas | 48085 | 116794 | 942 |
1705571 | 1705571 | 2021-09-10 | Collin | Texas | 48085 | 116337 | 936 |
1702321 | 1702321 | 2021-09-09 | Collin | Texas | 48085 | 115857 | 931 |
1699072 | 1699072 | 2021-09-08 | Collin | Texas | 48085 | 115292 | 923 |
1695824 | 1695824 | 2021-09-07 | Collin | Texas | 48085 | 114760 | 921 |
1692576 | 1692576 | 2021-09-06 | Collin | Texas | 48085 | 113940 | 920 |
1689327 | 1689327 | 2021-09-05 | Collin | Texas | 48085 | 113224 | 920 |
1686077 | 1686077 | 2021-09-04 | Collin | Texas | 48085 | 112998 | 917 |
1682826 | 1682826 | 2021-09-03 | Collin | Texas | 48085 | 111873 | 913 |
1679576 | 1679576 | 2021-09-02 | Collin | Texas | 48085 | 111426 | 909 |
1676328 | 1676328 | 2021-09-01 | Collin | Texas | 48085 | 110296 | 908 |
1673081 | 1673081 | 2021-08-31 | Collin | Texas | 48085 | 109432 | 903 |
1669833 | 1669833 | 2021-08-30 | Collin | Texas | 48085 | 108946 | 900 |
1666586 | 1666586 | 2021-08-29 | Collin | Texas | 48085 | 108784 | 900 |
1663338 | 1663338 | 2021-08-28 | Collin | Texas | 48085 | 108127 | 899 |
1660090 | 1660090 | 2021-08-27 | Collin | Texas | 48085 | 107533 | 898 |
1656841 | 1656841 | 2021-08-26 | Collin | Texas | 48085 | 107066 | 896 |
1653594 | 1653594 | 2021-08-25 | Collin | Texas | 48085 | 106605 | 893 |
1650347 | 1650347 | 2021-08-24 | Collin | Texas | 48085 | 106039 | 887 |
1647098 | 1647098 | 2021-08-23 | Collin | Texas | 48085 | 105208 | 883 |
1643849 | 1643849 | 2021-08-22 | Collin | Texas | 48085 | 105061 | 883 |
1640599 | 1640599 | 2021-08-21 | Collin | Texas | 48085 | 104956 | 883 |
1637349 | 1637349 | 2021-08-20 | Collin | Texas | 48085 | 104318 | 881 |
1634099 | 1634099 | 2021-08-19 | Collin | Texas | 48085 | 103913 | 881 |
1630852 | 1630852 | 2021-08-18 | Collin | Texas | 48085 | 103653 | 878 |
1627605 | 1627605 | 2021-08-17 | Collin | Texas | 48085 | 103234 | 877 |
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);