ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Hertford" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111081 | 2111081 | 2022-01-13 | Hertford | North Carolina | 37091 | 3815 | 77 |
2107829 | 2107829 | 2022-01-12 | Hertford | North Carolina | 37091 | 3693 | 76 |
2104578 | 2104578 | 2022-01-11 | Hertford | North Carolina | 37091 | 3652 | 77 |
2101327 | 2101327 | 2022-01-10 | Hertford | North Carolina | 37091 | 3615 | 77 |
2098076 | 2098076 | 2022-01-09 | Hertford | North Carolina | 37091 | 3403 | 76 |
2094824 | 2094824 | 2022-01-08 | Hertford | North Carolina | 37091 | 3403 | 76 |
2091572 | 2091572 | 2022-01-07 | Hertford | North Carolina | 37091 | 3403 | 76 |
2088321 | 2088321 | 2022-01-06 | Hertford | North Carolina | 37091 | 3325 | 74 |
2085069 | 2085069 | 2022-01-05 | Hertford | North Carolina | 37091 | 3264 | 74 |
2081817 | 2081817 | 2022-01-04 | Hertford | North Carolina | 37091 | 3192 | 74 |
2078565 | 2078565 | 2022-01-03 | Hertford | North Carolina | 37091 | 3174 | 73 |
2075314 | 2075314 | 2022-01-02 | Hertford | North Carolina | 37091 | 3070 | 73 |
2072063 | 2072063 | 2022-01-01 | Hertford | North Carolina | 37091 | 3070 | 73 |
2068812 | 2068812 | 2021-12-31 | Hertford | North Carolina | 37091 | 3070 | 73 |
2065561 | 2065561 | 2021-12-30 | Hertford | North Carolina | 37091 | 3020 | 73 |
2062311 | 2062311 | 2021-12-29 | Hertford | North Carolina | 37091 | 3002 | 73 |
2059062 | 2059062 | 2021-12-28 | Hertford | North Carolina | 37091 | 2996 | 73 |
2055813 | 2055813 | 2021-12-27 | Hertford | North Carolina | 37091 | 2969 | 72 |
2052563 | 2052563 | 2021-12-26 | Hertford | North Carolina | 37091 | 2969 | 72 |
2049313 | 2049313 | 2021-12-25 | Hertford | North Carolina | 37091 | 2969 | 72 |
2046063 | 2046063 | 2021-12-24 | Hertford | North Carolina | 37091 | 2969 | 72 |
2042813 | 2042813 | 2021-12-23 | Hertford | North Carolina | 37091 | 2969 | 72 |
2039564 | 2039564 | 2021-12-22 | Hertford | North Carolina | 37091 | 2969 | 72 |
2036314 | 2036314 | 2021-12-21 | Hertford | North Carolina | 37091 | 2960 | 72 |
2033064 | 2033064 | 2021-12-20 | Hertford | North Carolina | 37091 | 2959 | 72 |
2029814 | 2029814 | 2021-12-19 | Hertford | North Carolina | 37091 | 2953 | 72 |
2026563 | 2026563 | 2021-12-18 | Hertford | North Carolina | 37091 | 2953 | 72 |
2023312 | 2023312 | 2021-12-17 | Hertford | North Carolina | 37091 | 2953 | 72 |
2020061 | 2020061 | 2021-12-16 | Hertford | North Carolina | 37091 | 2942 | 73 |
2016810 | 2016810 | 2021-12-15 | Hertford | North Carolina | 37091 | 2939 | 73 |
2013560 | 2013560 | 2021-12-14 | Hertford | North Carolina | 37091 | 2937 | 73 |
2010309 | 2010309 | 2021-12-13 | Hertford | North Carolina | 37091 | 2937 | 72 |
2007058 | 2007058 | 2021-12-12 | Hertford | North Carolina | 37091 | 2927 | 72 |
2003807 | 2003807 | 2021-12-11 | Hertford | North Carolina | 37091 | 2927 | 72 |
2000556 | 2000556 | 2021-12-10 | Hertford | North Carolina | 37091 | 2927 | 72 |
1997306 | 1997306 | 2021-12-09 | Hertford | North Carolina | 37091 | 2926 | 72 |
1994055 | 1994055 | 2021-12-08 | Hertford | North Carolina | 37091 | 2923 | 72 |
1990804 | 1990804 | 2021-12-07 | Hertford | North Carolina | 37091 | 2916 | 72 |
1987553 | 1987553 | 2021-12-06 | Hertford | North Carolina | 37091 | 2916 | 72 |
1984303 | 1984303 | 2021-12-05 | Hertford | North Carolina | 37091 | 2903 | 72 |
1981053 | 1981053 | 2021-12-04 | Hertford | North Carolina | 37091 | 2903 | 72 |
1977803 | 1977803 | 2021-12-03 | Hertford | North Carolina | 37091 | 2903 | 72 |
1974553 | 1974553 | 2021-12-02 | Hertford | North Carolina | 37091 | 2902 | 72 |
1971304 | 1971304 | 2021-12-01 | Hertford | North Carolina | 37091 | 2901 | 72 |
1968054 | 1968054 | 2021-11-30 | Hertford | North Carolina | 37091 | 2901 | 72 |
1964803 | 1964803 | 2021-11-29 | Hertford | North Carolina | 37091 | 2900 | 72 |
1961551 | 1961551 | 2021-11-28 | Hertford | North Carolina | 37091 | 2892 | 72 |
1958300 | 1958300 | 2021-11-27 | Hertford | North Carolina | 37091 | 2892 | 72 |
1955049 | 1955049 | 2021-11-26 | Hertford | North Carolina | 37091 | 2892 | 72 |
1951798 | 1951798 | 2021-11-25 | Hertford | North Carolina | 37091 | 2892 | 72 |
1948547 | 1948547 | 2021-11-24 | Hertford | North Carolina | 37091 | 2892 | 72 |
1945296 | 1945296 | 2021-11-23 | Hertford | North Carolina | 37091 | 2889 | 72 |
1942045 | 1942045 | 2021-11-22 | Hertford | North Carolina | 37091 | 2889 | 72 |
1938795 | 1938795 | 2021-11-21 | Hertford | North Carolina | 37091 | 2885 | 72 |
1935545 | 1935545 | 2021-11-20 | Hertford | North Carolina | 37091 | 2885 | 72 |
1932295 | 1932295 | 2021-11-19 | Hertford | North Carolina | 37091 | 2885 | 72 |
1929044 | 1929044 | 2021-11-18 | Hertford | North Carolina | 37091 | 2883 | 72 |
1925794 | 1925794 | 2021-11-17 | Hertford | North Carolina | 37091 | 2882 | 72 |
1922545 | 1922545 | 2021-11-16 | Hertford | North Carolina | 37091 | 2881 | 72 |
1919295 | 1919295 | 2021-11-15 | Hertford | North Carolina | 37091 | 2878 | 72 |
1916045 | 1916045 | 2021-11-14 | Hertford | North Carolina | 37091 | 2875 | 72 |
1912795 | 1912795 | 2021-11-13 | Hertford | North Carolina | 37091 | 2875 | 72 |
1909545 | 1909545 | 2021-11-12 | Hertford | North Carolina | 37091 | 2875 | 72 |
1906296 | 1906296 | 2021-11-11 | Hertford | North Carolina | 37091 | 2873 | 72 |
1903047 | 1903047 | 2021-11-10 | Hertford | North Carolina | 37091 | 2873 | 72 |
1899797 | 1899797 | 2021-11-09 | Hertford | North Carolina | 37091 | 2871 | 72 |
1896547 | 1896547 | 2021-11-08 | Hertford | North Carolina | 37091 | 2870 | 72 |
1893297 | 1893297 | 2021-11-07 | Hertford | North Carolina | 37091 | 2865 | 72 |
1890047 | 1890047 | 2021-11-06 | Hertford | North Carolina | 37091 | 2865 | 72 |
1886797 | 1886797 | 2021-11-05 | Hertford | North Carolina | 37091 | 2865 | 72 |
1883548 | 1883548 | 2021-11-04 | Hertford | North Carolina | 37091 | 2862 | 72 |
1880299 | 1880299 | 2021-11-03 | Hertford | North Carolina | 37091 | 2860 | 72 |
1877050 | 1877050 | 2021-11-02 | Hertford | North Carolina | 37091 | 2857 | 72 |
1873801 | 1873801 | 2021-11-01 | Hertford | North Carolina | 37091 | 2857 | 71 |
1870552 | 1870552 | 2021-10-31 | Hertford | North Carolina | 37091 | 2856 | 71 |
1867303 | 1867303 | 2021-10-30 | Hertford | North Carolina | 37091 | 2856 | 71 |
1864054 | 1864054 | 2021-10-29 | Hertford | North Carolina | 37091 | 2856 | 71 |
1860805 | 1860805 | 2021-10-28 | Hertford | North Carolina | 37091 | 2852 | 71 |
1857556 | 1857556 | 2021-10-27 | Hertford | North Carolina | 37091 | 2844 | 71 |
1854307 | 1854307 | 2021-10-26 | Hertford | North Carolina | 37091 | 2842 | 71 |
1851058 | 1851058 | 2021-10-25 | Hertford | North Carolina | 37091 | 2839 | 71 |
1847808 | 1847808 | 2021-10-24 | Hertford | North Carolina | 37091 | 2827 | 71 |
1844558 | 1844558 | 2021-10-23 | Hertford | North Carolina | 37091 | 2827 | 71 |
1841308 | 1841308 | 2021-10-22 | Hertford | North Carolina | 37091 | 2827 | 71 |
1838059 | 1838059 | 2021-10-21 | Hertford | North Carolina | 37091 | 2823 | 70 |
1834810 | 1834810 | 2021-10-20 | Hertford | North Carolina | 37091 | 2815 | 70 |
1831561 | 1831561 | 2021-10-19 | Hertford | North Carolina | 37091 | 2812 | 70 |
1828312 | 1828312 | 2021-10-18 | Hertford | North Carolina | 37091 | 2810 | 70 |
1825063 | 1825063 | 2021-10-17 | Hertford | North Carolina | 37091 | 2787 | 70 |
1821814 | 1821814 | 2021-10-16 | Hertford | North Carolina | 37091 | 2787 | 70 |
1818565 | 1818565 | 2021-10-15 | Hertford | North Carolina | 37091 | 2787 | 70 |
1815316 | 1815316 | 2021-10-14 | Hertford | North Carolina | 37091 | 2765 | 70 |
1812068 | 1812068 | 2021-10-13 | Hertford | North Carolina | 37091 | 2758 | 70 |
1808819 | 1808819 | 2021-10-12 | Hertford | North Carolina | 37091 | 2736 | 69 |
1805568 | 1805568 | 2021-10-11 | Hertford | North Carolina | 37091 | 2734 | 69 |
1802319 | 1802319 | 2021-10-10 | Hertford | North Carolina | 37091 | 2716 | 69 |
1799070 | 1799070 | 2021-10-09 | Hertford | North Carolina | 37091 | 2716 | 69 |
1795821 | 1795821 | 2021-10-08 | Hertford | North Carolina | 37091 | 2716 | 69 |
1792572 | 1792572 | 2021-10-07 | Hertford | North Carolina | 37091 | 2705 | 69 |
1789323 | 1789323 | 2021-10-06 | Hertford | North Carolina | 37091 | 2693 | 69 |
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);