ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and fips = 37043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176123 | 2176123 | 2022-02-02 | Clay | North Carolina | 37043 | 2382 | 38 |
2172870 | 2172870 | 2022-02-01 | Clay | North Carolina | 37043 | 2362 | 38 |
2169617 | 2169617 | 2022-01-31 | Clay | North Carolina | 37043 | 2350 | 38 |
2166362 | 2166362 | 2022-01-30 | Clay | North Carolina | 37043 | 2285 | 38 |
2163107 | 2163107 | 2022-01-29 | Clay | North Carolina | 37043 | 2285 | 38 |
2159852 | 2159852 | 2022-01-28 | Clay | North Carolina | 37043 | 2285 | 38 |
2156597 | 2156597 | 2022-01-27 | Clay | North Carolina | 37043 | 2263 | 38 |
2153344 | 2153344 | 2022-01-26 | Clay | North Carolina | 37043 | 2255 | 38 |
2150092 | 2150092 | 2022-01-25 | Clay | North Carolina | 37043 | 2211 | 38 |
2146840 | 2146840 | 2022-01-24 | Clay | North Carolina | 37043 | 2191 | 38 |
2143586 | 2143586 | 2022-01-23 | Clay | North Carolina | 37043 | 2111 | 38 |
2140331 | 2140331 | 2022-01-22 | Clay | North Carolina | 37043 | 2111 | 38 |
2137075 | 2137075 | 2022-01-21 | Clay | North Carolina | 37043 | 2111 | 38 |
2133822 | 2133822 | 2022-01-20 | Clay | North Carolina | 37043 | 2094 | 38 |
2130570 | 2130570 | 2022-01-19 | Clay | North Carolina | 37043 | 2082 | 38 |
2127316 | 2127316 | 2022-01-18 | Clay | North Carolina | 37043 | 2054 | 38 |
2124064 | 2124064 | 2022-01-17 | Clay | North Carolina | 37043 | 1992 | 38 |
2120812 | 2120812 | 2022-01-16 | Clay | North Carolina | 37043 | 1992 | 38 |
2117560 | 2117560 | 2022-01-15 | Clay | North Carolina | 37043 | 1992 | 38 |
2114309 | 2114309 | 2022-01-14 | Clay | North Carolina | 37043 | 1992 | 38 |
2111057 | 2111057 | 2022-01-13 | Clay | North Carolina | 37043 | 1969 | 38 |
2107805 | 2107805 | 2022-01-12 | Clay | North Carolina | 37043 | 1954 | 38 |
2104554 | 2104554 | 2022-01-11 | Clay | North Carolina | 37043 | 1926 | 38 |
2101303 | 2101303 | 2022-01-10 | Clay | North Carolina | 37043 | 1900 | 38 |
2098052 | 2098052 | 2022-01-09 | Clay | North Carolina | 37043 | 1860 | 38 |
2094800 | 2094800 | 2022-01-08 | Clay | North Carolina | 37043 | 1860 | 38 |
2091548 | 2091548 | 2022-01-07 | Clay | North Carolina | 37043 | 1860 | 38 |
2088297 | 2088297 | 2022-01-06 | Clay | North Carolina | 37043 | 1848 | 38 |
2085045 | 2085045 | 2022-01-05 | Clay | North Carolina | 37043 | 1826 | 38 |
2081793 | 2081793 | 2022-01-04 | Clay | North Carolina | 37043 | 1804 | 38 |
2078541 | 2078541 | 2022-01-03 | Clay | North Carolina | 37043 | 1799 | 38 |
2075290 | 2075290 | 2022-01-02 | Clay | North Carolina | 37043 | 1773 | 38 |
2072039 | 2072039 | 2022-01-01 | Clay | North Carolina | 37043 | 1773 | 38 |
2068788 | 2068788 | 2021-12-31 | Clay | North Carolina | 37043 | 1773 | 38 |
2065537 | 2065537 | 2021-12-30 | Clay | North Carolina | 37043 | 1763 | 38 |
2062287 | 2062287 | 2021-12-29 | Clay | North Carolina | 37043 | 1759 | 38 |
2059038 | 2059038 | 2021-12-28 | Clay | North Carolina | 37043 | 1759 | 38 |
2055789 | 2055789 | 2021-12-27 | Clay | North Carolina | 37043 | 1744 | 38 |
2052539 | 2052539 | 2021-12-26 | Clay | North Carolina | 37043 | 1744 | 38 |
2049289 | 2049289 | 2021-12-25 | Clay | North Carolina | 37043 | 1744 | 38 |
2046039 | 2046039 | 2021-12-24 | Clay | North Carolina | 37043 | 1744 | 38 |
2042789 | 2042789 | 2021-12-23 | Clay | North Carolina | 37043 | 1744 | 38 |
2039540 | 2039540 | 2021-12-22 | Clay | North Carolina | 37043 | 1744 | 38 |
2036290 | 2036290 | 2021-12-21 | Clay | North Carolina | 37043 | 1743 | 38 |
2033040 | 2033040 | 2021-12-20 | Clay | North Carolina | 37043 | 1743 | 38 |
2029790 | 2029790 | 2021-12-19 | Clay | North Carolina | 37043 | 1738 | 38 |
2026539 | 2026539 | 2021-12-18 | Clay | North Carolina | 37043 | 1738 | 38 |
2023288 | 2023288 | 2021-12-17 | Clay | North Carolina | 37043 | 1738 | 38 |
2020037 | 2020037 | 2021-12-16 | Clay | North Carolina | 37043 | 1736 | 38 |
2016786 | 2016786 | 2021-12-15 | Clay | North Carolina | 37043 | 1736 | 38 |
2013536 | 2013536 | 2021-12-14 | Clay | North Carolina | 37043 | 1735 | 38 |
2010285 | 2010285 | 2021-12-13 | Clay | North Carolina | 37043 | 1734 | 38 |
2007034 | 2007034 | 2021-12-12 | Clay | North Carolina | 37043 | 1727 | 38 |
2003783 | 2003783 | 2021-12-11 | Clay | North Carolina | 37043 | 1727 | 38 |
2000532 | 2000532 | 2021-12-10 | Clay | North Carolina | 37043 | 1727 | 38 |
1997282 | 1997282 | 2021-12-09 | Clay | North Carolina | 37043 | 1725 | 38 |
1994031 | 1994031 | 2021-12-08 | Clay | North Carolina | 37043 | 1724 | 38 |
1990780 | 1990780 | 2021-12-07 | Clay | North Carolina | 37043 | 1723 | 38 |
1987529 | 1987529 | 2021-12-06 | Clay | North Carolina | 37043 | 1720 | 38 |
1984279 | 1984279 | 2021-12-05 | Clay | North Carolina | 37043 | 1712 | 38 |
1981029 | 1981029 | 2021-12-04 | Clay | North Carolina | 37043 | 1712 | 38 |
1977779 | 1977779 | 2021-12-03 | Clay | North Carolina | 37043 | 1712 | 38 |
1974529 | 1974529 | 2021-12-02 | Clay | North Carolina | 37043 | 1709 | 38 |
1971280 | 1971280 | 2021-12-01 | Clay | North Carolina | 37043 | 1705 | 38 |
1968030 | 1968030 | 2021-11-30 | Clay | North Carolina | 37043 | 1700 | 38 |
1964779 | 1964779 | 2021-11-29 | Clay | North Carolina | 37043 | 1700 | 38 |
1961527 | 1961527 | 2021-11-28 | Clay | North Carolina | 37043 | 1698 | 38 |
1958276 | 1958276 | 2021-11-27 | Clay | North Carolina | 37043 | 1698 | 38 |
1955025 | 1955025 | 2021-11-26 | Clay | North Carolina | 37043 | 1698 | 38 |
1951774 | 1951774 | 2021-11-25 | Clay | North Carolina | 37043 | 1698 | 38 |
1948523 | 1948523 | 2021-11-24 | Clay | North Carolina | 37043 | 1698 | 38 |
1945272 | 1945272 | 2021-11-23 | Clay | North Carolina | 37043 | 1697 | 38 |
1942021 | 1942021 | 2021-11-22 | Clay | North Carolina | 37043 | 1696 | 38 |
1938771 | 1938771 | 2021-11-21 | Clay | North Carolina | 37043 | 1695 | 38 |
1935521 | 1935521 | 2021-11-20 | Clay | North Carolina | 37043 | 1695 | 38 |
1932271 | 1932271 | 2021-11-19 | Clay | North Carolina | 37043 | 1695 | 38 |
1929020 | 1929020 | 2021-11-18 | Clay | North Carolina | 37043 | 1695 | 38 |
1925770 | 1925770 | 2021-11-17 | Clay | North Carolina | 37043 | 1695 | 38 |
1922521 | 1922521 | 2021-11-16 | Clay | North Carolina | 37043 | 1684 | 36 |
1919271 | 1919271 | 2021-11-15 | Clay | North Carolina | 37043 | 1683 | 36 |
1916021 | 1916021 | 2021-11-14 | Clay | North Carolina | 37043 | 1680 | 36 |
1912771 | 1912771 | 2021-11-13 | Clay | North Carolina | 37043 | 1680 | 36 |
1909521 | 1909521 | 2021-11-12 | Clay | North Carolina | 37043 | 1680 | 36 |
1906272 | 1906272 | 2021-11-11 | Clay | North Carolina | 37043 | 1670 | 36 |
1903023 | 1903023 | 2021-11-10 | Clay | North Carolina | 37043 | 1670 | 36 |
1899773 | 1899773 | 2021-11-09 | Clay | North Carolina | 37043 | 1665 | 36 |
1896523 | 1896523 | 2021-11-08 | Clay | North Carolina | 37043 | 1665 | 36 |
1893273 | 1893273 | 2021-11-07 | Clay | North Carolina | 37043 | 1661 | 36 |
1890023 | 1890023 | 2021-11-06 | Clay | North Carolina | 37043 | 1661 | 36 |
1886773 | 1886773 | 2021-11-05 | Clay | North Carolina | 37043 | 1661 | 36 |
1883524 | 1883524 | 2021-11-04 | Clay | North Carolina | 37043 | 1659 | 36 |
1880275 | 1880275 | 2021-11-03 | Clay | North Carolina | 37043 | 1660 | 36 |
1877026 | 1877026 | 2021-11-02 | Clay | North Carolina | 37043 | 1660 | 36 |
1873777 | 1873777 | 2021-11-01 | Clay | North Carolina | 37043 | 1660 | 36 |
1870528 | 1870528 | 2021-10-31 | Clay | North Carolina | 37043 | 1656 | 36 |
1867279 | 1867279 | 2021-10-30 | Clay | North Carolina | 37043 | 1656 | 36 |
1864030 | 1864030 | 2021-10-29 | Clay | North Carolina | 37043 | 1656 | 36 |
1860781 | 1860781 | 2021-10-28 | Clay | North Carolina | 37043 | 1654 | 36 |
1857532 | 1857532 | 2021-10-27 | Clay | North Carolina | 37043 | 1653 | 36 |
1854283 | 1854283 | 2021-10-26 | Clay | North Carolina | 37043 | 1650 | 36 |
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);