ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Guilford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176142 | 2176142 | 2022-02-02 | Guilford | North Carolina | 37081 | 108642 | 998 |
2172889 | 2172889 | 2022-02-01 | Guilford | North Carolina | 37081 | 108255 | 994 |
2169636 | 2169636 | 2022-01-31 | Guilford | North Carolina | 37081 | 107857 | 994 |
2166381 | 2166381 | 2022-01-30 | Guilford | North Carolina | 37081 | 105961 | 986 |
2163126 | 2163126 | 2022-01-29 | Guilford | North Carolina | 37081 | 105961 | 986 |
2159871 | 2159871 | 2022-01-28 | Guilford | North Carolina | 37081 | 105961 | 986 |
2156616 | 2156616 | 2022-01-27 | Guilford | North Carolina | 37081 | 105316 | 986 |
2153363 | 2153363 | 2022-01-26 | Guilford | North Carolina | 37081 | 104506 | 986 |
2150111 | 2150111 | 2022-01-25 | Guilford | North Carolina | 37081 | 103880 | 986 |
2146859 | 2146859 | 2022-01-24 | Guilford | North Carolina | 37081 | 103041 | 986 |
2143605 | 2143605 | 2022-01-23 | Guilford | North Carolina | 37081 | 99325 | 983 |
2140350 | 2140350 | 2022-01-22 | Guilford | North Carolina | 37081 | 99325 | 983 |
2137094 | 2137094 | 2022-01-21 | Guilford | North Carolina | 37081 | 99325 | 983 |
2133841 | 2133841 | 2022-01-20 | Guilford | North Carolina | 37081 | 98121 | 980 |
2130589 | 2130589 | 2022-01-19 | Guilford | North Carolina | 37081 | 97389 | 975 |
2127335 | 2127335 | 2022-01-18 | Guilford | North Carolina | 37081 | 96669 | 975 |
2124083 | 2124083 | 2022-01-17 | Guilford | North Carolina | 37081 | 90012 | 964 |
2120831 | 2120831 | 2022-01-16 | Guilford | North Carolina | 37081 | 90012 | 964 |
2117579 | 2117579 | 2022-01-15 | Guilford | North Carolina | 37081 | 90012 | 964 |
2114328 | 2114328 | 2022-01-14 | Guilford | North Carolina | 37081 | 90012 | 964 |
2111076 | 2111076 | 2022-01-13 | Guilford | North Carolina | 37081 | 88802 | 962 |
2107824 | 2107824 | 2022-01-12 | Guilford | North Carolina | 37081 | 87716 | 957 |
2104573 | 2104573 | 2022-01-11 | Guilford | North Carolina | 37081 | 86252 | 955 |
2101322 | 2101322 | 2022-01-10 | Guilford | North Carolina | 37081 | 85477 | 955 |
2098071 | 2098071 | 2022-01-09 | Guilford | North Carolina | 37081 | 82668 | 950 |
2094819 | 2094819 | 2022-01-08 | Guilford | North Carolina | 37081 | 82668 | 950 |
2091567 | 2091567 | 2022-01-07 | Guilford | North Carolina | 37081 | 82668 | 950 |
2088316 | 2088316 | 2022-01-06 | Guilford | North Carolina | 37081 | 81576 | 950 |
2085064 | 2085064 | 2022-01-05 | Guilford | North Carolina | 37081 | 80654 | 947 |
2081812 | 2081812 | 2022-01-04 | Guilford | North Carolina | 37081 | 80005 | 947 |
2078560 | 2078560 | 2022-01-03 | Guilford | North Carolina | 37081 | 79667 | 947 |
2075309 | 2075309 | 2022-01-02 | Guilford | North Carolina | 37081 | 77557 | 947 |
2072058 | 2072058 | 2022-01-01 | Guilford | North Carolina | 37081 | 77557 | 947 |
2068807 | 2068807 | 2021-12-31 | Guilford | North Carolina | 37081 | 77557 | 947 |
2065556 | 2065556 | 2021-12-30 | Guilford | North Carolina | 37081 | 76722 | 943 |
2062306 | 2062306 | 2021-12-29 | Guilford | North Carolina | 37081 | 76072 | 937 |
2059057 | 2059057 | 2021-12-28 | Guilford | North Carolina | 37081 | 75651 | 937 |
2055808 | 2055808 | 2021-12-27 | Guilford | North Carolina | 37081 | 74053 | 936 |
2052558 | 2052558 | 2021-12-26 | Guilford | North Carolina | 37081 | 74053 | 936 |
2049308 | 2049308 | 2021-12-25 | Guilford | North Carolina | 37081 | 74053 | 936 |
2046058 | 2046058 | 2021-12-24 | Guilford | North Carolina | 37081 | 74053 | 936 |
2042808 | 2042808 | 2021-12-23 | Guilford | North Carolina | 37081 | 74053 | 936 |
2039559 | 2039559 | 2021-12-22 | Guilford | North Carolina | 37081 | 74053 | 936 |
2036309 | 2036309 | 2021-12-21 | Guilford | North Carolina | 37081 | 73826 | 936 |
2033059 | 2033059 | 2021-12-20 | Guilford | North Carolina | 37081 | 73685 | 936 |
2029809 | 2029809 | 2021-12-19 | Guilford | North Carolina | 37081 | 73138 | 932 |
2026558 | 2026558 | 2021-12-18 | Guilford | North Carolina | 37081 | 73138 | 932 |
2023307 | 2023307 | 2021-12-17 | Guilford | North Carolina | 37081 | 73138 | 932 |
2020056 | 2020056 | 2021-12-16 | Guilford | North Carolina | 37081 | 72981 | 932 |
2016805 | 2016805 | 2021-12-15 | Guilford | North Carolina | 37081 | 72787 | 932 |
2013555 | 2013555 | 2021-12-14 | Guilford | North Carolina | 37081 | 72566 | 932 |
2010304 | 2010304 | 2021-12-13 | Guilford | North Carolina | 37081 | 72471 | 929 |
2007053 | 2007053 | 2021-12-12 | Guilford | North Carolina | 37081 | 72045 | 929 |
2003802 | 2003802 | 2021-12-11 | Guilford | North Carolina | 37081 | 72045 | 929 |
2000551 | 2000551 | 2021-12-10 | Guilford | North Carolina | 37081 | 72045 | 929 |
1997301 | 1997301 | 2021-12-09 | Guilford | North Carolina | 37081 | 71892 | 929 |
1994050 | 1994050 | 2021-12-08 | Guilford | North Carolina | 37081 | 71726 | 929 |
1990799 | 1990799 | 2021-12-07 | Guilford | North Carolina | 37081 | 71601 | 925 |
1987548 | 1987548 | 2021-12-06 | Guilford | North Carolina | 37081 | 71476 | 925 |
1984298 | 1984298 | 2021-12-05 | Guilford | North Carolina | 37081 | 71076 | 925 |
1981048 | 1981048 | 2021-12-04 | Guilford | North Carolina | 37081 | 71076 | 925 |
1977798 | 1977798 | 2021-12-03 | Guilford | North Carolina | 37081 | 71076 | 925 |
1974548 | 1974548 | 2021-12-02 | Guilford | North Carolina | 37081 | 70916 | 925 |
1971299 | 1971299 | 2021-12-01 | Guilford | North Carolina | 37081 | 70723 | 924 |
1968049 | 1968049 | 2021-11-30 | Guilford | North Carolina | 37081 | 70574 | 923 |
1964798 | 1964798 | 2021-11-29 | Guilford | North Carolina | 37081 | 70511 | 920 |
1961546 | 1961546 | 2021-11-28 | Guilford | North Carolina | 37081 | 70140 | 916 |
1958295 | 1958295 | 2021-11-27 | Guilford | North Carolina | 37081 | 70140 | 916 |
1955044 | 1955044 | 2021-11-26 | Guilford | North Carolina | 37081 | 70140 | 916 |
1951793 | 1951793 | 2021-11-25 | Guilford | North Carolina | 37081 | 70140 | 916 |
1948542 | 1948542 | 2021-11-24 | Guilford | North Carolina | 37081 | 70140 | 916 |
1945291 | 1945291 | 2021-11-23 | Guilford | North Carolina | 37081 | 70072 | 915 |
1942040 | 1942040 | 2021-11-22 | Guilford | North Carolina | 37081 | 70005 | 914 |
1938790 | 1938790 | 2021-11-21 | Guilford | North Carolina | 37081 | 69744 | 913 |
1935540 | 1935540 | 2021-11-20 | Guilford | North Carolina | 37081 | 69744 | 913 |
1932290 | 1932290 | 2021-11-19 | Guilford | North Carolina | 37081 | 69744 | 913 |
1929039 | 1929039 | 2021-11-18 | Guilford | North Carolina | 37081 | 69636 | 910 |
1925789 | 1925789 | 2021-11-17 | Guilford | North Carolina | 37081 | 69542 | 910 |
1922540 | 1922540 | 2021-11-16 | Guilford | North Carolina | 37081 | 69475 | 904 |
1919290 | 1919290 | 2021-11-15 | Guilford | North Carolina | 37081 | 69391 | 901 |
1916040 | 1916040 | 2021-11-14 | Guilford | North Carolina | 37081 | 69106 | 901 |
1912790 | 1912790 | 2021-11-13 | Guilford | North Carolina | 37081 | 69106 | 901 |
1909540 | 1909540 | 2021-11-12 | Guilford | North Carolina | 37081 | 69106 | 901 |
1906291 | 1906291 | 2021-11-11 | Guilford | North Carolina | 37081 | 68927 | 896 |
1903042 | 1903042 | 2021-11-10 | Guilford | North Carolina | 37081 | 68927 | 896 |
1899792 | 1899792 | 2021-11-09 | Guilford | North Carolina | 37081 | 68852 | 894 |
1896542 | 1896542 | 2021-11-08 | Guilford | North Carolina | 37081 | 68783 | 894 |
1893292 | 1893292 | 2021-11-07 | Guilford | North Carolina | 37081 | 68533 | 892 |
1890042 | 1890042 | 2021-11-06 | Guilford | North Carolina | 37081 | 68533 | 892 |
1886792 | 1886792 | 2021-11-05 | Guilford | North Carolina | 37081 | 68533 | 892 |
1883543 | 1883543 | 2021-11-04 | Guilford | North Carolina | 37081 | 68439 | 889 |
1880294 | 1880294 | 2021-11-03 | Guilford | North Carolina | 37081 | 68295 | 889 |
1877045 | 1877045 | 2021-11-02 | Guilford | North Carolina | 37081 | 68236 | 885 |
1873796 | 1873796 | 2021-11-01 | Guilford | North Carolina | 37081 | 68151 | 880 |
1870547 | 1870547 | 2021-10-31 | Guilford | North Carolina | 37081 | 67913 | 871 |
1867298 | 1867298 | 2021-10-30 | Guilford | North Carolina | 37081 | 67913 | 871 |
1864049 | 1864049 | 2021-10-29 | Guilford | North Carolina | 37081 | 67913 | 871 |
1860800 | 1860800 | 2021-10-28 | Guilford | North Carolina | 37081 | 67832 | 870 |
1857551 | 1857551 | 2021-10-27 | Guilford | North Carolina | 37081 | 67719 | 870 |
1854302 | 1854302 | 2021-10-26 | Guilford | North Carolina | 37081 | 67649 | 869 |
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);