ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176861 | 2176861 | 2022-02-02 | Clay | Texas | 48077 | 1988 | 27 |
2173607 | 2173607 | 2022-02-01 | Clay | Texas | 48077 | 1980 | 27 |
2170355 | 2170355 | 2022-01-31 | Clay | Texas | 48077 | 1978 | 27 |
2167101 | 2167101 | 2022-01-30 | Clay | Texas | 48077 | 1977 | 27 |
2163846 | 2163846 | 2022-01-29 | Clay | Texas | 48077 | 1969 | 27 |
2160591 | 2160591 | 2022-01-28 | Clay | Texas | 48077 | 1954 | 27 |
2157335 | 2157335 | 2022-01-27 | Clay | Texas | 48077 | 1939 | 27 |
2154082 | 2154082 | 2022-01-26 | Clay | Texas | 48077 | 1932 | 27 |
2150830 | 2150830 | 2022-01-25 | Clay | Texas | 48077 | 1921 | 26 |
2147578 | 2147578 | 2022-01-24 | Clay | Texas | 48077 | 1917 | 26 |
2144324 | 2144324 | 2022-01-23 | Clay | Texas | 48077 | 1903 | 26 |
2141069 | 2141069 | 2022-01-22 | Clay | Texas | 48077 | 1890 | 26 |
2137813 | 2137813 | 2022-01-21 | Clay | Texas | 48077 | 1876 | 26 |
2134559 | 2134559 | 2022-01-20 | Clay | Texas | 48077 | 1861 | 26 |
2131307 | 2131307 | 2022-01-19 | Clay | Texas | 48077 | 1850 | 26 |
2128053 | 2128053 | 2022-01-18 | Clay | Texas | 48077 | 1838 | 26 |
2124801 | 2124801 | 2022-01-17 | Clay | Texas | 48077 | 1822 | 26 |
2121549 | 2121549 | 2022-01-16 | Clay | Texas | 48077 | 1811 | 26 |
2118297 | 2118297 | 2022-01-15 | Clay | Texas | 48077 | 1805 | 26 |
2115046 | 2115046 | 2022-01-14 | Clay | Texas | 48077 | 1789 | 26 |
2111794 | 2111794 | 2022-01-13 | Clay | Texas | 48077 | 1741 | 26 |
2108542 | 2108542 | 2022-01-12 | Clay | Texas | 48077 | 1723 | 26 |
2105291 | 2105291 | 2022-01-11 | Clay | Texas | 48077 | 1713 | 26 |
2102040 | 2102040 | 2022-01-10 | Clay | Texas | 48077 | 1706 | 26 |
2098789 | 2098789 | 2022-01-09 | Clay | Texas | 48077 | 1696 | 26 |
2095537 | 2095537 | 2022-01-08 | Clay | Texas | 48077 | 1694 | 26 |
2092285 | 2092285 | 2022-01-07 | Clay | Texas | 48077 | 1688 | 26 |
2089033 | 2089033 | 2022-01-06 | Clay | Texas | 48077 | 1680 | 26 |
2085782 | 2085782 | 2022-01-05 | Clay | Texas | 48077 | 1677 | 26 |
2082530 | 2082530 | 2022-01-04 | Clay | Texas | 48077 | 1673 | 26 |
2079278 | 2079278 | 2022-01-03 | Clay | Texas | 48077 | 1663 | 26 |
2076027 | 2076027 | 2022-01-02 | Clay | Texas | 48077 | 1644 | 26 |
2072776 | 2072776 | 2022-01-01 | Clay | Texas | 48077 | 1644 | 26 |
2069525 | 2069525 | 2021-12-31 | Clay | Texas | 48077 | 1644 | 26 |
2066274 | 2066274 | 2021-12-30 | Clay | Texas | 48077 | 1644 | 26 |
2063024 | 2063024 | 2021-12-29 | Clay | Texas | 48077 | 1642 | 26 |
2059774 | 2059774 | 2021-12-28 | Clay | Texas | 48077 | 1641 | 26 |
2056525 | 2056525 | 2021-12-27 | Clay | Texas | 48077 | 1636 | 26 |
2053276 | 2053276 | 2021-12-26 | Clay | Texas | 48077 | 1630 | 26 |
2050026 | 2050026 | 2021-12-25 | Clay | Texas | 48077 | 1630 | 26 |
2046776 | 2046776 | 2021-12-24 | Clay | Texas | 48077 | 1630 | 26 |
2043526 | 2043526 | 2021-12-23 | Clay | Texas | 48077 | 1630 | 26 |
2040277 | 2040277 | 2021-12-22 | Clay | Texas | 48077 | 1629 | 26 |
2037027 | 2037027 | 2021-12-21 | Clay | Texas | 48077 | 1623 | 26 |
2033777 | 2033777 | 2021-12-20 | Clay | Texas | 48077 | 1622 | 26 |
2030527 | 2030527 | 2021-12-19 | Clay | Texas | 48077 | 1622 | 26 |
2027276 | 2027276 | 2021-12-18 | Clay | Texas | 48077 | 1622 | 26 |
2024025 | 2024025 | 2021-12-17 | Clay | Texas | 48077 | 1621 | 25 |
2020774 | 2020774 | 2021-12-16 | Clay | Texas | 48077 | 1612 | 25 |
2017523 | 2017523 | 2021-12-15 | Clay | Texas | 48077 | 1611 | 25 |
2014273 | 2014273 | 2021-12-14 | Clay | Texas | 48077 | 1610 | 25 |
2011022 | 2011022 | 2021-12-13 | Clay | Texas | 48077 | 1610 | 25 |
2007771 | 2007771 | 2021-12-12 | Clay | Texas | 48077 | 1608 | 25 |
2004520 | 2004520 | 2021-12-11 | Clay | Texas | 48077 | 1608 | 25 |
2001269 | 2001269 | 2021-12-10 | Clay | Texas | 48077 | 1608 | 25 |
1998019 | 1998019 | 2021-12-09 | Clay | Texas | 48077 | 1604 | 25 |
1994768 | 1994768 | 2021-12-08 | Clay | Texas | 48077 | 1604 | 25 |
1991517 | 1991517 | 2021-12-07 | Clay | Texas | 48077 | 1602 | 25 |
1988266 | 1988266 | 2021-12-06 | Clay | Texas | 48077 | 1601 | 25 |
1985016 | 1985016 | 2021-12-05 | Clay | Texas | 48077 | 1601 | 25 |
1981766 | 1981766 | 2021-12-04 | Clay | Texas | 48077 | 1601 | 25 |
1978516 | 1978516 | 2021-12-03 | Clay | Texas | 48077 | 1598 | 25 |
1975266 | 1975266 | 2021-12-02 | Clay | Texas | 48077 | 1597 | 25 |
1972017 | 1972017 | 2021-12-01 | Clay | Texas | 48077 | 1597 | 25 |
1968767 | 1968767 | 2021-11-30 | Clay | Texas | 48077 | 1597 | 25 |
1965516 | 1965516 | 2021-11-29 | Clay | Texas | 48077 | 1596 | 25 |
1962264 | 1962264 | 2021-11-28 | Clay | Texas | 48077 | 1584 | 25 |
1959013 | 1959013 | 2021-11-27 | Clay | Texas | 48077 | 1584 | 25 |
1955762 | 1955762 | 2021-11-26 | Clay | Texas | 48077 | 1584 | 25 |
1952511 | 1952511 | 2021-11-25 | Clay | Texas | 48077 | 1584 | 25 |
1949260 | 1949260 | 2021-11-24 | Clay | Texas | 48077 | 1584 | 25 |
1946009 | 1946009 | 2021-11-23 | Clay | Texas | 48077 | 1576 | 25 |
1942758 | 1942758 | 2021-11-22 | Clay | Texas | 48077 | 1575 | 25 |
1939508 | 1939508 | 2021-11-21 | Clay | Texas | 48077 | 1575 | 25 |
1936258 | 1936258 | 2021-11-20 | Clay | Texas | 48077 | 1575 | 25 |
1933008 | 1933008 | 2021-11-19 | Clay | Texas | 48077 | 1575 | 25 |
1929757 | 1929757 | 2021-11-18 | Clay | Texas | 48077 | 1574 | 25 |
1926507 | 1926507 | 2021-11-17 | Clay | Texas | 48077 | 1574 | 25 |
1923257 | 1923257 | 2021-11-16 | Clay | Texas | 48077 | 1573 | 25 |
1920008 | 1920008 | 2021-11-15 | Clay | Texas | 48077 | 1572 | 25 |
1916758 | 1916758 | 2021-11-14 | Clay | Texas | 48077 | 1572 | 25 |
1913508 | 1913508 | 2021-11-13 | Clay | Texas | 48077 | 1572 | 25 |
1910258 | 1910258 | 2021-11-12 | Clay | Texas | 48077 | 1569 | 25 |
1907009 | 1907009 | 2021-11-11 | Clay | Texas | 48077 | 1569 | 24 |
1903760 | 1903760 | 2021-11-10 | Clay | Texas | 48077 | 1568 | 24 |
1900510 | 1900510 | 2021-11-09 | Clay | Texas | 48077 | 1568 | 24 |
1897260 | 1897260 | 2021-11-08 | Clay | Texas | 48077 | 1565 | 24 |
1894010 | 1894010 | 2021-11-07 | Clay | Texas | 48077 | 1565 | 24 |
1890760 | 1890760 | 2021-11-06 | Clay | Texas | 48077 | 1565 | 24 |
1887510 | 1887510 | 2021-11-05 | Clay | Texas | 48077 | 1563 | 23 |
1884260 | 1884260 | 2021-11-04 | Clay | Texas | 48077 | 1563 | 23 |
1881011 | 1881011 | 2021-11-03 | Clay | Texas | 48077 | 1554 | 23 |
1877762 | 1877762 | 2021-11-02 | Clay | Texas | 48077 | 1554 | 23 |
1874513 | 1874513 | 2021-11-01 | Clay | Texas | 48077 | 1549 | 23 |
1871264 | 1871264 | 2021-10-31 | Clay | Texas | 48077 | 1549 | 23 |
1868015 | 1868015 | 2021-10-30 | Clay | Texas | 48077 | 1549 | 23 |
1864766 | 1864766 | 2021-10-29 | Clay | Texas | 48077 | 1548 | 23 |
1861517 | 1861517 | 2021-10-28 | Clay | Texas | 48077 | 1548 | 23 |
1858268 | 1858268 | 2021-10-27 | Clay | Texas | 48077 | 1546 | 23 |
1855019 | 1855019 | 2021-10-26 | Clay | Texas | 48077 | 1544 | 23 |
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);