ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
616 rows where county = "Hartley", deaths = 2 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2105355 | 2105355 | 2022-01-11 | Hartley | Texas | 48205 | 1018 | 2 |
2102104 | 2102104 | 2022-01-10 | Hartley | Texas | 48205 | 1017 | 2 |
2098853 | 2098853 | 2022-01-09 | Hartley | Texas | 48205 | 1017 | 2 |
2095601 | 2095601 | 2022-01-08 | Hartley | Texas | 48205 | 1017 | 2 |
2092349 | 2092349 | 2022-01-07 | Hartley | Texas | 48205 | 1013 | 2 |
2089097 | 2089097 | 2022-01-06 | Hartley | Texas | 48205 | 1011 | 2 |
2085846 | 2085846 | 2022-01-05 | Hartley | Texas | 48205 | 1007 | 2 |
2082594 | 2082594 | 2022-01-04 | Hartley | Texas | 48205 | 1007 | 2 |
2079342 | 2079342 | 2022-01-03 | Hartley | Texas | 48205 | 1005 | 2 |
2076091 | 2076091 | 2022-01-02 | Hartley | Texas | 48205 | 1000 | 2 |
2072840 | 2072840 | 2022-01-01 | Hartley | Texas | 48205 | 1000 | 2 |
2069589 | 2069589 | 2021-12-31 | Hartley | Texas | 48205 | 1000 | 2 |
2066338 | 2066338 | 2021-12-30 | Hartley | Texas | 48205 | 1000 | 2 |
2063088 | 2063088 | 2021-12-29 | Hartley | Texas | 48205 | 995 | 2 |
2059838 | 2059838 | 2021-12-28 | Hartley | Texas | 48205 | 991 | 2 |
2056589 | 2056589 | 2021-12-27 | Hartley | Texas | 48205 | 986 | 2 |
2053340 | 2053340 | 2021-12-26 | Hartley | Texas | 48205 | 979 | 2 |
2050090 | 2050090 | 2021-12-25 | Hartley | Texas | 48205 | 979 | 2 |
2046840 | 2046840 | 2021-12-24 | Hartley | Texas | 48205 | 979 | 2 |
2043590 | 2043590 | 2021-12-23 | Hartley | Texas | 48205 | 979 | 2 |
2040341 | 2040341 | 2021-12-22 | Hartley | Texas | 48205 | 976 | 2 |
2037091 | 2037091 | 2021-12-21 | Hartley | Texas | 48205 | 974 | 2 |
2033841 | 2033841 | 2021-12-20 | Hartley | Texas | 48205 | 973 | 2 |
2030591 | 2030591 | 2021-12-19 | Hartley | Texas | 48205 | 973 | 2 |
2027340 | 2027340 | 2021-12-18 | Hartley | Texas | 48205 | 973 | 2 |
2024089 | 2024089 | 2021-12-17 | Hartley | Texas | 48205 | 972 | 2 |
2020838 | 2020838 | 2021-12-16 | Hartley | Texas | 48205 | 971 | 2 |
2017587 | 2017587 | 2021-12-15 | Hartley | Texas | 48205 | 969 | 2 |
2014337 | 2014337 | 2021-12-14 | Hartley | Texas | 48205 | 968 | 2 |
2011086 | 2011086 | 2021-12-13 | Hartley | Texas | 48205 | 966 | 2 |
2007835 | 2007835 | 2021-12-12 | Hartley | Texas | 48205 | 966 | 2 |
2004584 | 2004584 | 2021-12-11 | Hartley | Texas | 48205 | 964 | 2 |
2001333 | 2001333 | 2021-12-10 | Hartley | Texas | 48205 | 953 | 2 |
1998083 | 1998083 | 2021-12-09 | Hartley | Texas | 48205 | 954 | 2 |
1994832 | 1994832 | 2021-12-08 | Hartley | Texas | 48205 | 954 | 2 |
1991581 | 1991581 | 2021-12-07 | Hartley | Texas | 48205 | 953 | 2 |
1988330 | 1988330 | 2021-12-06 | Hartley | Texas | 48205 | 951 | 2 |
1985080 | 1985080 | 2021-12-05 | Hartley | Texas | 48205 | 950 | 2 |
1981830 | 1981830 | 2021-12-04 | Hartley | Texas | 48205 | 950 | 2 |
1978580 | 1978580 | 2021-12-03 | Hartley | Texas | 48205 | 949 | 2 |
1975330 | 1975330 | 2021-12-02 | Hartley | Texas | 48205 | 949 | 2 |
1972081 | 1972081 | 2021-12-01 | Hartley | Texas | 48205 | 946 | 2 |
1968831 | 1968831 | 2021-11-30 | Hartley | Texas | 48205 | 938 | 2 |
1965580 | 1965580 | 2021-11-29 | Hartley | Texas | 48205 | 935 | 2 |
1962328 | 1962328 | 2021-11-28 | Hartley | Texas | 48205 | 936 | 2 |
1959077 | 1959077 | 2021-11-27 | Hartley | Texas | 48205 | 936 | 2 |
1955826 | 1955826 | 2021-11-26 | Hartley | Texas | 48205 | 936 | 2 |
1952575 | 1952575 | 2021-11-25 | Hartley | Texas | 48205 | 936 | 2 |
1949324 | 1949324 | 2021-11-24 | Hartley | Texas | 48205 | 936 | 2 |
1946073 | 1946073 | 2021-11-23 | Hartley | Texas | 48205 | 936 | 2 |
1942822 | 1942822 | 2021-11-22 | Hartley | Texas | 48205 | 934 | 2 |
1939572 | 1939572 | 2021-11-21 | Hartley | Texas | 48205 | 934 | 2 |
1936322 | 1936322 | 2021-11-20 | Hartley | Texas | 48205 | 934 | 2 |
1933072 | 1933072 | 2021-11-19 | Hartley | Texas | 48205 | 934 | 2 |
1929821 | 1929821 | 2021-11-18 | Hartley | Texas | 48205 | 935 | 2 |
1926571 | 1926571 | 2021-11-17 | Hartley | Texas | 48205 | 935 | 2 |
1923321 | 1923321 | 2021-11-16 | Hartley | Texas | 48205 | 928 | 2 |
1920072 | 1920072 | 2021-11-15 | Hartley | Texas | 48205 | 922 | 2 |
1916822 | 1916822 | 2021-11-14 | Hartley | Texas | 48205 | 922 | 2 |
1913572 | 1913572 | 2021-11-13 | Hartley | Texas | 48205 | 922 | 2 |
1910322 | 1910322 | 2021-11-12 | Hartley | Texas | 48205 | 890 | 2 |
1907073 | 1907073 | 2021-11-11 | Hartley | Texas | 48205 | 890 | 2 |
1903824 | 1903824 | 2021-11-10 | Hartley | Texas | 48205 | 885 | 2 |
1900574 | 1900574 | 2021-11-09 | Hartley | Texas | 48205 | 885 | 2 |
1897324 | 1897324 | 2021-11-08 | Hartley | Texas | 48205 | 873 | 2 |
1894074 | 1894074 | 2021-11-07 | Hartley | Texas | 48205 | 873 | 2 |
1890824 | 1890824 | 2021-11-06 | Hartley | Texas | 48205 | 873 | 2 |
1887574 | 1887574 | 2021-11-05 | Hartley | Texas | 48205 | 870 | 2 |
1884324 | 1884324 | 2021-11-04 | Hartley | Texas | 48205 | 869 | 2 |
1881075 | 1881075 | 2021-11-03 | Hartley | Texas | 48205 | 867 | 2 |
1877826 | 1877826 | 2021-11-02 | Hartley | Texas | 48205 | 867 | 2 |
1874577 | 1874577 | 2021-11-01 | Hartley | Texas | 48205 | 867 | 2 |
1871328 | 1871328 | 2021-10-31 | Hartley | Texas | 48205 | 867 | 2 |
1868079 | 1868079 | 2021-10-30 | Hartley | Texas | 48205 | 867 | 2 |
1864830 | 1864830 | 2021-10-29 | Hartley | Texas | 48205 | 867 | 2 |
1861581 | 1861581 | 2021-10-28 | Hartley | Texas | 48205 | 857 | 2 |
1858332 | 1858332 | 2021-10-27 | Hartley | Texas | 48205 | 857 | 2 |
1855083 | 1855083 | 2021-10-26 | Hartley | Texas | 48205 | 857 | 2 |
1851834 | 1851834 | 2021-10-25 | Hartley | Texas | 48205 | 851 | 2 |
1848584 | 1848584 | 2021-10-24 | Hartley | Texas | 48205 | 851 | 2 |
1845334 | 1845334 | 2021-10-23 | Hartley | Texas | 48205 | 851 | 2 |
1842084 | 1842084 | 2021-10-22 | Hartley | Texas | 48205 | 849 | 2 |
1838835 | 1838835 | 2021-10-21 | Hartley | Texas | 48205 | 849 | 2 |
1835586 | 1835586 | 2021-10-20 | Hartley | Texas | 48205 | 848 | 2 |
1832337 | 1832337 | 2021-10-19 | Hartley | Texas | 48205 | 848 | 2 |
1829088 | 1829088 | 2021-10-18 | Hartley | Texas | 48205 | 841 | 2 |
1825839 | 1825839 | 2021-10-17 | Hartley | Texas | 48205 | 841 | 2 |
1822590 | 1822590 | 2021-10-16 | Hartley | Texas | 48205 | 841 | 2 |
1819341 | 1819341 | 2021-10-15 | Hartley | Texas | 48205 | 840 | 2 |
1816092 | 1816092 | 2021-10-14 | Hartley | Texas | 48205 | 833 | 2 |
1812844 | 1812844 | 2021-10-13 | Hartley | Texas | 48205 | 833 | 2 |
1809595 | 1809595 | 2021-10-12 | Hartley | Texas | 48205 | 827 | 2 |
1806345 | 1806345 | 2021-10-11 | Hartley | Texas | 48205 | 827 | 2 |
1803095 | 1803095 | 2021-10-10 | Hartley | Texas | 48205 | 827 | 2 |
1799846 | 1799846 | 2021-10-09 | Hartley | Texas | 48205 | 827 | 2 |
1796597 | 1796597 | 2021-10-08 | Hartley | Texas | 48205 | 827 | 2 |
1793348 | 1793348 | 2021-10-07 | Hartley | Texas | 48205 | 827 | 2 |
1790099 | 1790099 | 2021-10-06 | Hartley | Texas | 48205 | 819 | 2 |
1786851 | 1786851 | 2021-10-05 | Hartley | Texas | 48205 | 820 | 2 |
1783602 | 1783602 | 2021-10-04 | Hartley | Texas | 48205 | 818 | 2 |
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);