ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Abbeville" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176615 | 2176615 | 2022-02-02 | Abbeville | South Carolina | 45001 | 6307 | 59 |
2173361 | 2173361 | 2022-02-01 | Abbeville | South Carolina | 45001 | 6285 | 59 |
2170109 | 2170109 | 2022-01-31 | Abbeville | South Carolina | 45001 | 6271 | 59 |
2166855 | 2166855 | 2022-01-30 | Abbeville | South Carolina | 45001 | 6104 | 57 |
2163600 | 2163600 | 2022-01-29 | Abbeville | South Carolina | 45001 | 6104 | 57 |
2160345 | 2160345 | 2022-01-28 | Abbeville | South Carolina | 45001 | 6104 | 57 |
2157089 | 2157089 | 2022-01-27 | Abbeville | South Carolina | 45001 | 6040 | 57 |
2153836 | 2153836 | 2022-01-26 | Abbeville | South Carolina | 45001 | 6012 | 57 |
2150584 | 2150584 | 2022-01-25 | Abbeville | South Carolina | 45001 | 5703 | 57 |
2147332 | 2147332 | 2022-01-24 | Abbeville | South Carolina | 45001 | 5703 | 57 |
2144078 | 2144078 | 2022-01-23 | Abbeville | South Carolina | 45001 | 5703 | 57 |
2140823 | 2140823 | 2022-01-22 | Abbeville | South Carolina | 45001 | 5703 | 57 |
2137567 | 2137567 | 2022-01-21 | Abbeville | South Carolina | 45001 | 5703 | 57 |
2134313 | 2134313 | 2022-01-20 | Abbeville | South Carolina | 45001 | 5599 | 57 |
2131061 | 2131061 | 2022-01-19 | Abbeville | South Carolina | 45001 | 5548 | 57 |
2127807 | 2127807 | 2022-01-18 | Abbeville | South Carolina | 45001 | 5513 | 57 |
2124555 | 2124555 | 2022-01-17 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2121303 | 2121303 | 2022-01-16 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2118051 | 2118051 | 2022-01-15 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2114800 | 2114800 | 2022-01-14 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2111548 | 2111548 | 2022-01-13 | Abbeville | South Carolina | 45001 | 4931 | 57 |
2108296 | 2108296 | 2022-01-12 | Abbeville | South Carolina | 45001 | 4878 | 56 |
2105045 | 2105045 | 2022-01-11 | Abbeville | South Carolina | 45001 | 4846 | 56 |
2101794 | 2101794 | 2022-01-10 | Abbeville | South Carolina | 45001 | 4808 | 56 |
2098543 | 2098543 | 2022-01-09 | Abbeville | South Carolina | 45001 | 4533 | 56 |
2095291 | 2095291 | 2022-01-08 | Abbeville | South Carolina | 45001 | 4533 | 56 |
2092039 | 2092039 | 2022-01-07 | Abbeville | South Carolina | 45001 | 4533 | 56 |
2088787 | 2088787 | 2022-01-06 | Abbeville | South Carolina | 45001 | 4448 | 56 |
2085536 | 2085536 | 2022-01-05 | Abbeville | South Carolina | 45001 | 4407 | 56 |
2082284 | 2082284 | 2022-01-04 | Abbeville | South Carolina | 45001 | 4394 | 55 |
2079032 | 2079032 | 2022-01-03 | Abbeville | South Carolina | 45001 | 4282 | 54 |
2075781 | 2075781 | 2022-01-02 | Abbeville | South Carolina | 45001 | 4282 | 54 |
2072530 | 2072530 | 2022-01-01 | Abbeville | South Carolina | 45001 | 4282 | 54 |
2069279 | 2069279 | 2021-12-31 | Abbeville | South Carolina | 45001 | 4282 | 54 |
2066028 | 2066028 | 2021-12-30 | Abbeville | South Carolina | 45001 | 4234 | 54 |
2062778 | 2062778 | 2021-12-29 | Abbeville | South Carolina | 45001 | 4207 | 54 |
2059528 | 2059528 | 2021-12-28 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2056279 | 2056279 | 2021-12-27 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2053030 | 2053030 | 2021-12-26 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2049780 | 2049780 | 2021-12-25 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2046530 | 2046530 | 2021-12-24 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2043280 | 2043280 | 2021-12-23 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2040031 | 2040031 | 2021-12-22 | Abbeville | South Carolina | 45001 | 4147 | 53 |
2036781 | 2036781 | 2021-12-21 | Abbeville | South Carolina | 45001 | 4137 | 53 |
2033531 | 2033531 | 2021-12-20 | Abbeville | South Carolina | 45001 | 4128 | 53 |
2030281 | 2030281 | 2021-12-19 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2027030 | 2027030 | 2021-12-18 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2023779 | 2023779 | 2021-12-17 | Abbeville | South Carolina | 45001 | 4104 | 53 |
2020528 | 2020528 | 2021-12-16 | Abbeville | South Carolina | 45001 | 4090 | 53 |
2017277 | 2017277 | 2021-12-15 | Abbeville | South Carolina | 45001 | 4083 | 53 |
2014027 | 2014027 | 2021-12-14 | Abbeville | South Carolina | 45001 | 4074 | 53 |
2010776 | 2010776 | 2021-12-13 | Abbeville | South Carolina | 45001 | 4070 | 53 |
2007525 | 2007525 | 2021-12-12 | Abbeville | South Carolina | 45001 | 4032 | 53 |
2004274 | 2004274 | 2021-12-11 | Abbeville | South Carolina | 45001 | 4032 | 53 |
2001023 | 2001023 | 2021-12-10 | Abbeville | South Carolina | 45001 | 4032 | 53 |
1997773 | 1997773 | 2021-12-09 | Abbeville | South Carolina | 45001 | 4024 | 52 |
1994522 | 1994522 | 2021-12-08 | Abbeville | South Carolina | 45001 | 4013 | 52 |
1991271 | 1991271 | 2021-12-07 | Abbeville | South Carolina | 45001 | 4000 | 52 |
1988020 | 1988020 | 2021-12-06 | Abbeville | South Carolina | 45001 | 3998 | 52 |
1984770 | 1984770 | 2021-12-05 | Abbeville | South Carolina | 45001 | 3977 | 51 |
1981520 | 1981520 | 2021-12-04 | Abbeville | South Carolina | 45001 | 3977 | 51 |
1978270 | 1978270 | 2021-12-03 | Abbeville | South Carolina | 45001 | 3977 | 51 |
1975020 | 1975020 | 2021-12-02 | Abbeville | South Carolina | 45001 | 3972 | 51 |
1971771 | 1971771 | 2021-12-01 | Abbeville | South Carolina | 45001 | 3964 | 50 |
1968521 | 1968521 | 2021-11-30 | Abbeville | South Carolina | 45001 | 3959 | 50 |
1965270 | 1965270 | 2021-11-29 | Abbeville | South Carolina | 45001 | 3958 | 50 |
1962018 | 1962018 | 2021-11-28 | Abbeville | South Carolina | 45001 | 3939 | 50 |
1958767 | 1958767 | 2021-11-27 | Abbeville | South Carolina | 45001 | 3939 | 50 |
1955516 | 1955516 | 2021-11-26 | Abbeville | South Carolina | 45001 | 3939 | 50 |
1952265 | 1952265 | 2021-11-25 | Abbeville | South Carolina | 45001 | 3928 | 50 |
1949014 | 1949014 | 2021-11-24 | Abbeville | South Carolina | 45001 | 3928 | 50 |
1945763 | 1945763 | 2021-11-23 | Abbeville | South Carolina | 45001 | 3926 | 50 |
1942512 | 1942512 | 2021-11-22 | Abbeville | South Carolina | 45001 | 3922 | 50 |
1939262 | 1939262 | 2021-11-21 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1936012 | 1936012 | 2021-11-20 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1932762 | 1932762 | 2021-11-19 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1929511 | 1929511 | 2021-11-18 | Abbeville | South Carolina | 45001 | 3900 | 50 |
1926261 | 1926261 | 2021-11-17 | Abbeville | South Carolina | 45001 | 3895 | 50 |
1923011 | 1923011 | 2021-11-16 | Abbeville | South Carolina | 45001 | 3893 | 50 |
1919762 | 1919762 | 2021-11-15 | Abbeville | South Carolina | 45001 | 3893 | 50 |
1916512 | 1916512 | 2021-11-14 | Abbeville | South Carolina | 45001 | 3883 | 50 |
1913262 | 1913262 | 2021-11-13 | Abbeville | South Carolina | 45001 | 3883 | 50 |
1910012 | 1910012 | 2021-11-12 | Abbeville | South Carolina | 45001 | 3883 | 50 |
1906763 | 1906763 | 2021-11-11 | Abbeville | South Carolina | 45001 | 3879 | 50 |
1903514 | 1903514 | 2021-11-10 | Abbeville | South Carolina | 45001 | 3879 | 50 |
1900264 | 1900264 | 2021-11-09 | Abbeville | South Carolina | 45001 | 3875 | 50 |
1897014 | 1897014 | 2021-11-08 | Abbeville | South Carolina | 45001 | 3873 | 50 |
1893764 | 1893764 | 2021-11-07 | Abbeville | South Carolina | 45001 | 3854 | 50 |
1890514 | 1890514 | 2021-11-06 | Abbeville | South Carolina | 45001 | 3854 | 50 |
1887264 | 1887264 | 2021-11-05 | Abbeville | South Carolina | 45001 | 3854 | 50 |
1884014 | 1884014 | 2021-11-04 | Abbeville | South Carolina | 45001 | 3852 | 50 |
1880765 | 1880765 | 2021-11-03 | Abbeville | South Carolina | 45001 | 3845 | 50 |
1877516 | 1877516 | 2021-11-02 | Abbeville | South Carolina | 45001 | 3844 | 49 |
1874267 | 1874267 | 2021-11-01 | Abbeville | South Carolina | 45001 | 3843 | 49 |
1871018 | 1871018 | 2021-10-31 | Abbeville | South Carolina | 45001 | 3831 | 49 |
1867769 | 1867769 | 2021-10-30 | Abbeville | South Carolina | 45001 | 3831 | 49 |
1864520 | 1864520 | 2021-10-29 | Abbeville | South Carolina | 45001 | 3831 | 49 |
1861271 | 1861271 | 2021-10-28 | Abbeville | South Carolina | 45001 | 3829 | 49 |
1858022 | 1858022 | 2021-10-27 | Abbeville | South Carolina | 45001 | 3829 | 49 |
1854773 | 1854773 | 2021-10-26 | Abbeville | South Carolina | 45001 | 3827 | 49 |
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);