ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Halifax" and fips = 37083 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176143 | 2176143 | 2022-02-02 | Halifax | North Carolina | 37083 | 13269 | 162 |
2172890 | 2172890 | 2022-02-01 | Halifax | North Carolina | 37083 | 13188 | 159 |
2169637 | 2169637 | 2022-01-31 | Halifax | North Carolina | 37083 | 13160 | 159 |
2166382 | 2166382 | 2022-01-30 | Halifax | North Carolina | 37083 | 12997 | 158 |
2163127 | 2163127 | 2022-01-29 | Halifax | North Carolina | 37083 | 12997 | 158 |
2159872 | 2159872 | 2022-01-28 | Halifax | North Carolina | 37083 | 12997 | 158 |
2156617 | 2156617 | 2022-01-27 | Halifax | North Carolina | 37083 | 12910 | 155 |
2153364 | 2153364 | 2022-01-26 | Halifax | North Carolina | 37083 | 12804 | 153 |
2150112 | 2150112 | 2022-01-25 | Halifax | North Carolina | 37083 | 12680 | 152 |
2146860 | 2146860 | 2022-01-24 | Halifax | North Carolina | 37083 | 12626 | 152 |
2143606 | 2143606 | 2022-01-23 | Halifax | North Carolina | 37083 | 12298 | 152 |
2140351 | 2140351 | 2022-01-22 | Halifax | North Carolina | 37083 | 12298 | 152 |
2137095 | 2137095 | 2022-01-21 | Halifax | North Carolina | 37083 | 12298 | 152 |
2133842 | 2133842 | 2022-01-20 | Halifax | North Carolina | 37083 | 12057 | 150 |
2130590 | 2130590 | 2022-01-19 | Halifax | North Carolina | 37083 | 11928 | 150 |
2127336 | 2127336 | 2022-01-18 | Halifax | North Carolina | 37083 | 11844 | 150 |
2124084 | 2124084 | 2022-01-17 | Halifax | North Carolina | 37083 | 11120 | 150 |
2120832 | 2120832 | 2022-01-16 | Halifax | North Carolina | 37083 | 11120 | 150 |
2117580 | 2117580 | 2022-01-15 | Halifax | North Carolina | 37083 | 11120 | 150 |
2114329 | 2114329 | 2022-01-14 | Halifax | North Carolina | 37083 | 11120 | 150 |
2111077 | 2111077 | 2022-01-13 | Halifax | North Carolina | 37083 | 10944 | 150 |
2107825 | 2107825 | 2022-01-12 | Halifax | North Carolina | 37083 | 10709 | 150 |
2104574 | 2104574 | 2022-01-11 | Halifax | North Carolina | 37083 | 10570 | 150 |
2101323 | 2101323 | 2022-01-10 | Halifax | North Carolina | 37083 | 10426 | 149 |
2098072 | 2098072 | 2022-01-09 | Halifax | North Carolina | 37083 | 9822 | 147 |
2094820 | 2094820 | 2022-01-08 | Halifax | North Carolina | 37083 | 9822 | 147 |
2091568 | 2091568 | 2022-01-07 | Halifax | North Carolina | 37083 | 9822 | 147 |
2088317 | 2088317 | 2022-01-06 | Halifax | North Carolina | 37083 | 9618 | 146 |
2085065 | 2085065 | 2022-01-05 | Halifax | North Carolina | 37083 | 9418 | 146 |
2081813 | 2081813 | 2022-01-04 | Halifax | North Carolina | 37083 | 9123 | 146 |
2078561 | 2078561 | 2022-01-03 | Halifax | North Carolina | 37083 | 9040 | 146 |
2075310 | 2075310 | 2022-01-02 | Halifax | North Carolina | 37083 | 8708 | 146 |
2072059 | 2072059 | 2022-01-01 | Halifax | North Carolina | 37083 | 8708 | 146 |
2068808 | 2068808 | 2021-12-31 | Halifax | North Carolina | 37083 | 8708 | 146 |
2065557 | 2065557 | 2021-12-30 | Halifax | North Carolina | 37083 | 8523 | 146 |
2062307 | 2062307 | 2021-12-29 | Halifax | North Carolina | 37083 | 8380 | 146 |
2059058 | 2059058 | 2021-12-28 | Halifax | North Carolina | 37083 | 8368 | 146 |
2055809 | 2055809 | 2021-12-27 | Halifax | North Carolina | 37083 | 8227 | 146 |
2052559 | 2052559 | 2021-12-26 | Halifax | North Carolina | 37083 | 8227 | 146 |
2049309 | 2049309 | 2021-12-25 | Halifax | North Carolina | 37083 | 8227 | 146 |
2046059 | 2046059 | 2021-12-24 | Halifax | North Carolina | 37083 | 8227 | 146 |
2042809 | 2042809 | 2021-12-23 | Halifax | North Carolina | 37083 | 8227 | 146 |
2039560 | 2039560 | 2021-12-22 | Halifax | North Carolina | 37083 | 8227 | 146 |
2036310 | 2036310 | 2021-12-21 | Halifax | North Carolina | 37083 | 8211 | 146 |
2033060 | 2033060 | 2021-12-20 | Halifax | North Carolina | 37083 | 8209 | 145 |
2029810 | 2029810 | 2021-12-19 | Halifax | North Carolina | 37083 | 8173 | 145 |
2026559 | 2026559 | 2021-12-18 | Halifax | North Carolina | 37083 | 8173 | 145 |
2023308 | 2023308 | 2021-12-17 | Halifax | North Carolina | 37083 | 8173 | 145 |
2020057 | 2020057 | 2021-12-16 | Halifax | North Carolina | 37083 | 8161 | 145 |
2016806 | 2016806 | 2021-12-15 | Halifax | North Carolina | 37083 | 8151 | 145 |
2013556 | 2013556 | 2021-12-14 | Halifax | North Carolina | 37083 | 8134 | 145 |
2010305 | 2010305 | 2021-12-13 | Halifax | North Carolina | 37083 | 8133 | 145 |
2007054 | 2007054 | 2021-12-12 | Halifax | North Carolina | 37083 | 8112 | 144 |
2003803 | 2003803 | 2021-12-11 | Halifax | North Carolina | 37083 | 8112 | 144 |
2000552 | 2000552 | 2021-12-10 | Halifax | North Carolina | 37083 | 8112 | 144 |
1997302 | 1997302 | 2021-12-09 | Halifax | North Carolina | 37083 | 8107 | 144 |
1994051 | 1994051 | 2021-12-08 | Halifax | North Carolina | 37083 | 8100 | 144 |
1990800 | 1990800 | 2021-12-07 | Halifax | North Carolina | 37083 | 8093 | 144 |
1987549 | 1987549 | 2021-12-06 | Halifax | North Carolina | 37083 | 8091 | 144 |
1984299 | 1984299 | 2021-12-05 | Halifax | North Carolina | 37083 | 8073 | 144 |
1981049 | 1981049 | 2021-12-04 | Halifax | North Carolina | 37083 | 8073 | 144 |
1977799 | 1977799 | 2021-12-03 | Halifax | North Carolina | 37083 | 8073 | 144 |
1974549 | 1974549 | 2021-12-02 | Halifax | North Carolina | 37083 | 8069 | 144 |
1971300 | 1971300 | 2021-12-01 | Halifax | North Carolina | 37083 | 8061 | 144 |
1968050 | 1968050 | 2021-11-30 | Halifax | North Carolina | 37083 | 8057 | 144 |
1964799 | 1964799 | 2021-11-29 | Halifax | North Carolina | 37083 | 8056 | 144 |
1961547 | 1961547 | 2021-11-28 | Halifax | North Carolina | 37083 | 8039 | 144 |
1958296 | 1958296 | 2021-11-27 | Halifax | North Carolina | 37083 | 8039 | 144 |
1955045 | 1955045 | 2021-11-26 | Halifax | North Carolina | 37083 | 8039 | 144 |
1951794 | 1951794 | 2021-11-25 | Halifax | North Carolina | 37083 | 8039 | 144 |
1948543 | 1948543 | 2021-11-24 | Halifax | North Carolina | 37083 | 8039 | 144 |
1945292 | 1945292 | 2021-11-23 | Halifax | North Carolina | 37083 | 8036 | 144 |
1942041 | 1942041 | 2021-11-22 | Halifax | North Carolina | 37083 | 8034 | 144 |
1938791 | 1938791 | 2021-11-21 | Halifax | North Carolina | 37083 | 8029 | 144 |
1935541 | 1935541 | 2021-11-20 | Halifax | North Carolina | 37083 | 8029 | 144 |
1932291 | 1932291 | 2021-11-19 | Halifax | North Carolina | 37083 | 8029 | 144 |
1929040 | 1929040 | 2021-11-18 | Halifax | North Carolina | 37083 | 8027 | 144 |
1925790 | 1925790 | 2021-11-17 | Halifax | North Carolina | 37083 | 8016 | 144 |
1922541 | 1922541 | 2021-11-16 | Halifax | North Carolina | 37083 | 8013 | 144 |
1919291 | 1919291 | 2021-11-15 | Halifax | North Carolina | 37083 | 8013 | 143 |
1916041 | 1916041 | 2021-11-14 | Halifax | North Carolina | 37083 | 8004 | 143 |
1912791 | 1912791 | 2021-11-13 | Halifax | North Carolina | 37083 | 8004 | 143 |
1909541 | 1909541 | 2021-11-12 | Halifax | North Carolina | 37083 | 8004 | 143 |
1906292 | 1906292 | 2021-11-11 | Halifax | North Carolina | 37083 | 7997 | 143 |
1903043 | 1903043 | 2021-11-10 | Halifax | North Carolina | 37083 | 7997 | 143 |
1899793 | 1899793 | 2021-11-09 | Halifax | North Carolina | 37083 | 7991 | 143 |
1896543 | 1896543 | 2021-11-08 | Halifax | North Carolina | 37083 | 7987 | 143 |
1893293 | 1893293 | 2021-11-07 | Halifax | North Carolina | 37083 | 7965 | 142 |
1890043 | 1890043 | 2021-11-06 | Halifax | North Carolina | 37083 | 7965 | 142 |
1886793 | 1886793 | 2021-11-05 | Halifax | North Carolina | 37083 | 7965 | 142 |
1883544 | 1883544 | 2021-11-04 | Halifax | North Carolina | 37083 | 7955 | 141 |
1880295 | 1880295 | 2021-11-03 | Halifax | North Carolina | 37083 | 7950 | 141 |
1877046 | 1877046 | 2021-11-02 | Halifax | North Carolina | 37083 | 7943 | 140 |
1873797 | 1873797 | 2021-11-01 | Halifax | North Carolina | 37083 | 7940 | 139 |
1870548 | 1870548 | 2021-10-31 | Halifax | North Carolina | 37083 | 7918 | 139 |
1867299 | 1867299 | 2021-10-30 | Halifax | North Carolina | 37083 | 7918 | 139 |
1864050 | 1864050 | 2021-10-29 | Halifax | North Carolina | 37083 | 7918 | 139 |
1860801 | 1860801 | 2021-10-28 | Halifax | North Carolina | 37083 | 7898 | 139 |
1857552 | 1857552 | 2021-10-27 | Halifax | North Carolina | 37083 | 7876 | 139 |
1854303 | 1854303 | 2021-10-26 | Halifax | North Carolina | 37083 | 7865 | 139 |
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);