ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45085 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 |
---|---|---|---|---|---|---|---|
2176657 | 2176657 | 2022-02-02 | Sumter | South Carolina | 45085 | 26106 | 340 |
2173403 | 2173403 | 2022-02-01 | Sumter | South Carolina | 45085 | 25992 | 337 |
2170151 | 2170151 | 2022-01-31 | Sumter | South Carolina | 45085 | 25928 | 337 |
2166897 | 2166897 | 2022-01-30 | Sumter | South Carolina | 45085 | 25462 | 329 |
2163642 | 2163642 | 2022-01-29 | Sumter | South Carolina | 45085 | 25462 | 329 |
2160387 | 2160387 | 2022-01-28 | Sumter | South Carolina | 45085 | 25462 | 329 |
2157131 | 2157131 | 2022-01-27 | Sumter | South Carolina | 45085 | 25205 | 327 |
2153878 | 2153878 | 2022-01-26 | Sumter | South Carolina | 45085 | 24966 | 327 |
2150626 | 2150626 | 2022-01-25 | Sumter | South Carolina | 45085 | 23758 | 327 |
2147374 | 2147374 | 2022-01-24 | Sumter | South Carolina | 45085 | 23758 | 327 |
2144120 | 2144120 | 2022-01-23 | Sumter | South Carolina | 45085 | 23758 | 327 |
2140865 | 2140865 | 2022-01-22 | Sumter | South Carolina | 45085 | 23758 | 327 |
2137609 | 2137609 | 2022-01-21 | Sumter | South Carolina | 45085 | 23758 | 327 |
2134355 | 2134355 | 2022-01-20 | Sumter | South Carolina | 45085 | 23396 | 324 |
2131103 | 2131103 | 2022-01-19 | Sumter | South Carolina | 45085 | 23189 | 324 |
2127849 | 2127849 | 2022-01-18 | Sumter | South Carolina | 45085 | 23021 | 324 |
2124597 | 2124597 | 2022-01-17 | Sumter | South Carolina | 45085 | 21621 | 323 |
2121345 | 2121345 | 2022-01-16 | Sumter | South Carolina | 45085 | 21621 | 323 |
2118093 | 2118093 | 2022-01-15 | Sumter | South Carolina | 45085 | 21621 | 323 |
2114842 | 2114842 | 2022-01-14 | Sumter | South Carolina | 45085 | 21621 | 323 |
2111590 | 2111590 | 2022-01-13 | Sumter | South Carolina | 45085 | 21220 | 322 |
2108338 | 2108338 | 2022-01-12 | Sumter | South Carolina | 45085 | 20955 | 322 |
2105087 | 2105087 | 2022-01-11 | Sumter | South Carolina | 45085 | 20640 | 320 |
2101836 | 2101836 | 2022-01-10 | Sumter | South Carolina | 45085 | 20403 | 320 |
2098585 | 2098585 | 2022-01-09 | Sumter | South Carolina | 45085 | 19563 | 316 |
2095333 | 2095333 | 2022-01-08 | Sumter | South Carolina | 45085 | 19563 | 316 |
2092081 | 2092081 | 2022-01-07 | Sumter | South Carolina | 45085 | 19563 | 316 |
2088829 | 2088829 | 2022-01-06 | Sumter | South Carolina | 45085 | 19229 | 316 |
2085578 | 2085578 | 2022-01-05 | Sumter | South Carolina | 45085 | 18980 | 316 |
2082326 | 2082326 | 2022-01-04 | Sumter | South Carolina | 45085 | 18813 | 313 |
2079074 | 2079074 | 2022-01-03 | Sumter | South Carolina | 45085 | 17974 | 312 |
2075823 | 2075823 | 2022-01-02 | Sumter | South Carolina | 45085 | 17974 | 312 |
2072572 | 2072572 | 2022-01-01 | Sumter | South Carolina | 45085 | 17974 | 312 |
2069321 | 2069321 | 2021-12-31 | Sumter | South Carolina | 45085 | 17974 | 312 |
2066070 | 2066070 | 2021-12-30 | Sumter | South Carolina | 45085 | 17795 | 312 |
2062820 | 2062820 | 2021-12-29 | Sumter | South Carolina | 45085 | 17669 | 312 |
2059570 | 2059570 | 2021-12-28 | Sumter | South Carolina | 45085 | 17343 | 310 |
2056321 | 2056321 | 2021-12-27 | Sumter | South Carolina | 45085 | 17343 | 310 |
2053072 | 2053072 | 2021-12-26 | Sumter | South Carolina | 45085 | 17343 | 310 |
2049822 | 2049822 | 2021-12-25 | Sumter | South Carolina | 45085 | 17343 | 310 |
2046572 | 2046572 | 2021-12-24 | Sumter | South Carolina | 45085 | 17343 | 310 |
2043322 | 2043322 | 2021-12-23 | Sumter | South Carolina | 45085 | 17343 | 310 |
2040073 | 2040073 | 2021-12-22 | Sumter | South Carolina | 45085 | 17277 | 309 |
2036823 | 2036823 | 2021-12-21 | Sumter | South Carolina | 45085 | 17242 | 309 |
2033573 | 2033573 | 2021-12-20 | Sumter | South Carolina | 45085 | 17222 | 309 |
2030323 | 2030323 | 2021-12-19 | Sumter | South Carolina | 45085 | 17120 | 309 |
2027072 | 2027072 | 2021-12-18 | Sumter | South Carolina | 45085 | 17120 | 309 |
2023821 | 2023821 | 2021-12-17 | Sumter | South Carolina | 45085 | 17120 | 309 |
2020570 | 2020570 | 2021-12-16 | Sumter | South Carolina | 45085 | 17079 | 308 |
2017319 | 2017319 | 2021-12-15 | Sumter | South Carolina | 45085 | 17041 | 307 |
2014069 | 2014069 | 2021-12-14 | Sumter | South Carolina | 45085 | 17023 | 307 |
2010818 | 2010818 | 2021-12-13 | Sumter | South Carolina | 45085 | 17013 | 307 |
2007567 | 2007567 | 2021-12-12 | Sumter | South Carolina | 45085 | 16949 | 306 |
2004316 | 2004316 | 2021-12-11 | Sumter | South Carolina | 45085 | 16949 | 306 |
2001065 | 2001065 | 2021-12-10 | Sumter | South Carolina | 45085 | 16949 | 306 |
1997815 | 1997815 | 2021-12-09 | Sumter | South Carolina | 45085 | 16921 | 306 |
1994564 | 1994564 | 2021-12-08 | Sumter | South Carolina | 45085 | 16890 | 306 |
1991313 | 1991313 | 2021-12-07 | Sumter | South Carolina | 45085 | 16876 | 306 |
1988062 | 1988062 | 2021-12-06 | Sumter | South Carolina | 45085 | 16868 | 306 |
1984812 | 1984812 | 2021-12-05 | Sumter | South Carolina | 45085 | 16804 | 305 |
1981562 | 1981562 | 2021-12-04 | Sumter | South Carolina | 45085 | 16804 | 305 |
1978312 | 1978312 | 2021-12-03 | Sumter | South Carolina | 45085 | 16804 | 305 |
1975062 | 1975062 | 2021-12-02 | Sumter | South Carolina | 45085 | 16755 | 305 |
1971813 | 1971813 | 2021-12-01 | Sumter | South Carolina | 45085 | 16737 | 304 |
1968563 | 1968563 | 2021-11-30 | Sumter | South Carolina | 45085 | 16726 | 304 |
1965312 | 1965312 | 2021-11-29 | Sumter | South Carolina | 45085 | 16713 | 304 |
1962060 | 1962060 | 2021-11-28 | Sumter | South Carolina | 45085 | 16653 | 304 |
1958809 | 1958809 | 2021-11-27 | Sumter | South Carolina | 45085 | 16653 | 304 |
1955558 | 1955558 | 2021-11-26 | Sumter | South Carolina | 45085 | 16653 | 304 |
1952307 | 1952307 | 2021-11-25 | Sumter | South Carolina | 45085 | 16636 | 303 |
1949056 | 1949056 | 2021-11-24 | Sumter | South Carolina | 45085 | 16636 | 303 |
1945805 | 1945805 | 2021-11-23 | Sumter | South Carolina | 45085 | 16617 | 303 |
1942554 | 1942554 | 2021-11-22 | Sumter | South Carolina | 45085 | 16607 | 303 |
1939304 | 1939304 | 2021-11-21 | Sumter | South Carolina | 45085 | 16549 | 302 |
1936054 | 1936054 | 2021-11-20 | Sumter | South Carolina | 45085 | 16549 | 302 |
1932804 | 1932804 | 2021-11-19 | Sumter | South Carolina | 45085 | 16549 | 302 |
1929553 | 1929553 | 2021-11-18 | Sumter | South Carolina | 45085 | 16517 | 302 |
1926303 | 1926303 | 2021-11-17 | Sumter | South Carolina | 45085 | 16480 | 301 |
1923053 | 1923053 | 2021-11-16 | Sumter | South Carolina | 45085 | 16474 | 301 |
1919804 | 1919804 | 2021-11-15 | Sumter | South Carolina | 45085 | 16464 | 300 |
1916554 | 1916554 | 2021-11-14 | Sumter | South Carolina | 45085 | 16420 | 300 |
1913304 | 1913304 | 2021-11-13 | Sumter | South Carolina | 45085 | 16420 | 300 |
1910054 | 1910054 | 2021-11-12 | Sumter | South Carolina | 45085 | 16420 | 300 |
1906805 | 1906805 | 2021-11-11 | Sumter | South Carolina | 45085 | 16391 | 296 |
1903556 | 1903556 | 2021-11-10 | Sumter | South Carolina | 45085 | 16391 | 296 |
1900306 | 1900306 | 2021-11-09 | Sumter | South Carolina | 45085 | 16371 | 296 |
1897056 | 1897056 | 2021-11-08 | Sumter | South Carolina | 45085 | 16361 | 296 |
1893806 | 1893806 | 2021-11-07 | Sumter | South Carolina | 45085 | 16320 | 293 |
1890556 | 1890556 | 2021-11-06 | Sumter | South Carolina | 45085 | 16320 | 293 |
1887306 | 1887306 | 2021-11-05 | Sumter | South Carolina | 45085 | 16320 | 293 |
1884056 | 1884056 | 2021-11-04 | Sumter | South Carolina | 45085 | 16296 | 293 |
1880807 | 1880807 | 2021-11-03 | Sumter | South Carolina | 45085 | 16282 | 293 |
1877558 | 1877558 | 2021-11-02 | Sumter | South Carolina | 45085 | 16273 | 293 |
1874309 | 1874309 | 2021-11-01 | Sumter | South Carolina | 45085 | 16260 | 293 |
1871060 | 1871060 | 2021-10-31 | Sumter | South Carolina | 45085 | 16202 | 293 |
1867811 | 1867811 | 2021-10-30 | Sumter | South Carolina | 45085 | 16202 | 293 |
1864562 | 1864562 | 2021-10-29 | Sumter | South Carolina | 45085 | 16202 | 293 |
1861313 | 1861313 | 2021-10-28 | Sumter | South Carolina | 45085 | 16162 | 293 |
1858064 | 1858064 | 2021-10-27 | Sumter | South Carolina | 45085 | 16140 | 292 |
1854815 | 1854815 | 2021-10-26 | Sumter | South Carolina | 45085 | 16125 | 292 |
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);