ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pickens" 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 |
---|---|---|---|---|---|---|---|
2176653 | 2176653 | 2022-02-02 | Pickens | South Carolina | 45077 | 43775 | 542 |
2173399 | 2173399 | 2022-02-01 | Pickens | South Carolina | 45077 | 43678 | 542 |
2170147 | 2170147 | 2022-01-31 | Pickens | South Carolina | 45077 | 43533 | 540 |
2166893 | 2166893 | 2022-01-30 | Pickens | South Carolina | 45077 | 42484 | 535 |
2163638 | 2163638 | 2022-01-29 | Pickens | South Carolina | 45077 | 42484 | 535 |
2160383 | 2160383 | 2022-01-28 | Pickens | South Carolina | 45077 | 42484 | 535 |
2157127 | 2157127 | 2022-01-27 | Pickens | South Carolina | 45077 | 41815 | 530 |
2153874 | 2153874 | 2022-01-26 | Pickens | South Carolina | 45077 | 41546 | 530 |
2150622 | 2150622 | 2022-01-25 | Pickens | South Carolina | 45077 | 38589 | 529 |
2147370 | 2147370 | 2022-01-24 | Pickens | South Carolina | 45077 | 38589 | 529 |
2144116 | 2144116 | 2022-01-23 | Pickens | South Carolina | 45077 | 38589 | 529 |
2140861 | 2140861 | 2022-01-22 | Pickens | South Carolina | 45077 | 38589 | 529 |
2137605 | 2137605 | 2022-01-21 | Pickens | South Carolina | 45077 | 38589 | 529 |
2134351 | 2134351 | 2022-01-20 | Pickens | South Carolina | 45077 | 38332 | 526 |
2131099 | 2131099 | 2022-01-19 | Pickens | South Carolina | 45077 | 38085 | 526 |
2127845 | 2127845 | 2022-01-18 | Pickens | South Carolina | 45077 | 37749 | 526 |
2124593 | 2124593 | 2022-01-17 | Pickens | South Carolina | 45077 | 34930 | 523 |
2121341 | 2121341 | 2022-01-16 | Pickens | South Carolina | 45077 | 34930 | 523 |
2118089 | 2118089 | 2022-01-15 | Pickens | South Carolina | 45077 | 34930 | 523 |
2114838 | 2114838 | 2022-01-14 | Pickens | South Carolina | 45077 | 34930 | 523 |
2111586 | 2111586 | 2022-01-13 | Pickens | South Carolina | 45077 | 34302 | 522 |
2108334 | 2108334 | 2022-01-12 | Pickens | South Carolina | 45077 | 33795 | 520 |
2105083 | 2105083 | 2022-01-11 | Pickens | South Carolina | 45077 | 33558 | 518 |
2101832 | 2101832 | 2022-01-10 | Pickens | South Carolina | 45077 | 33325 | 518 |
2098581 | 2098581 | 2022-01-09 | Pickens | South Carolina | 45077 | 31978 | 515 |
2095329 | 2095329 | 2022-01-08 | Pickens | South Carolina | 45077 | 31978 | 515 |
2092077 | 2092077 | 2022-01-07 | Pickens | South Carolina | 45077 | 31978 | 515 |
2088825 | 2088825 | 2022-01-06 | Pickens | South Carolina | 45077 | 31390 | 515 |
2085574 | 2085574 | 2022-01-05 | Pickens | South Carolina | 45077 | 31043 | 513 |
2082322 | 2082322 | 2022-01-04 | Pickens | South Carolina | 45077 | 30938 | 512 |
2079070 | 2079070 | 2022-01-03 | Pickens | South Carolina | 45077 | 29986 | 512 |
2075819 | 2075819 | 2022-01-02 | Pickens | South Carolina | 45077 | 29986 | 512 |
2072568 | 2072568 | 2022-01-01 | Pickens | South Carolina | 45077 | 29986 | 512 |
2069317 | 2069317 | 2021-12-31 | Pickens | South Carolina | 45077 | 29986 | 512 |
2066066 | 2066066 | 2021-12-30 | Pickens | South Carolina | 45077 | 29785 | 510 |
2062816 | 2062816 | 2021-12-29 | Pickens | South Carolina | 45077 | 29700 | 510 |
2059566 | 2059566 | 2021-12-28 | Pickens | South Carolina | 45077 | 29362 | 505 |
2056317 | 2056317 | 2021-12-27 | Pickens | South Carolina | 45077 | 29362 | 505 |
2053068 | 2053068 | 2021-12-26 | Pickens | South Carolina | 45077 | 29362 | 505 |
2049818 | 2049818 | 2021-12-25 | Pickens | South Carolina | 45077 | 29362 | 505 |
2046568 | 2046568 | 2021-12-24 | Pickens | South Carolina | 45077 | 29362 | 505 |
2043318 | 2043318 | 2021-12-23 | Pickens | South Carolina | 45077 | 29362 | 505 |
2040069 | 2040069 | 2021-12-22 | Pickens | South Carolina | 45077 | 29299 | 504 |
2036819 | 2036819 | 2021-12-21 | Pickens | South Carolina | 45077 | 29286 | 504 |
2033569 | 2033569 | 2021-12-20 | Pickens | South Carolina | 45077 | 29246 | 503 |
2030319 | 2030319 | 2021-12-19 | Pickens | South Carolina | 45077 | 29128 | 503 |
2027068 | 2027068 | 2021-12-18 | Pickens | South Carolina | 45077 | 29128 | 503 |
2023817 | 2023817 | 2021-12-17 | Pickens | South Carolina | 45077 | 29128 | 503 |
2020566 | 2020566 | 2021-12-16 | Pickens | South Carolina | 45077 | 29082 | 501 |
2017315 | 2017315 | 2021-12-15 | Pickens | South Carolina | 45077 | 29051 | 500 |
2014065 | 2014065 | 2021-12-14 | Pickens | South Carolina | 45077 | 29023 | 500 |
2010814 | 2010814 | 2021-12-13 | Pickens | South Carolina | 45077 | 29002 | 499 |
2007563 | 2007563 | 2021-12-12 | Pickens | South Carolina | 45077 | 28881 | 499 |
2004312 | 2004312 | 2021-12-11 | Pickens | South Carolina | 45077 | 28881 | 499 |
2001061 | 2001061 | 2021-12-10 | Pickens | South Carolina | 45077 | 28881 | 499 |
1997811 | 1997811 | 2021-12-09 | Pickens | South Carolina | 45077 | 28844 | 496 |
1994560 | 1994560 | 2021-12-08 | Pickens | South Carolina | 45077 | 28811 | 496 |
1991309 | 1991309 | 2021-12-07 | Pickens | South Carolina | 45077 | 28781 | 495 |
1988058 | 1988058 | 2021-12-06 | Pickens | South Carolina | 45077 | 28754 | 494 |
1984808 | 1984808 | 2021-12-05 | Pickens | South Carolina | 45077 | 28620 | 494 |
1981558 | 1981558 | 2021-12-04 | Pickens | South Carolina | 45077 | 28620 | 494 |
1978308 | 1978308 | 2021-12-03 | Pickens | South Carolina | 45077 | 28620 | 494 |
1975058 | 1975058 | 2021-12-02 | Pickens | South Carolina | 45077 | 28558 | 493 |
1971809 | 1971809 | 2021-12-01 | Pickens | South Carolina | 45077 | 28530 | 492 |
1968559 | 1968559 | 2021-11-30 | Pickens | South Carolina | 45077 | 28502 | 491 |
1965308 | 1965308 | 2021-11-29 | Pickens | South Carolina | 45077 | 28494 | 491 |
1962056 | 1962056 | 2021-11-28 | Pickens | South Carolina | 45077 | 28432 | 491 |
1958805 | 1958805 | 2021-11-27 | Pickens | South Carolina | 45077 | 28432 | 491 |
1955554 | 1955554 | 2021-11-26 | Pickens | South Carolina | 45077 | 28432 | 491 |
1952303 | 1952303 | 2021-11-25 | Pickens | South Carolina | 45077 | 28409 | 488 |
1949052 | 1949052 | 2021-11-24 | Pickens | South Carolina | 45077 | 28409 | 488 |
1945801 | 1945801 | 2021-11-23 | Pickens | South Carolina | 45077 | 28399 | 487 |
1942550 | 1942550 | 2021-11-22 | Pickens | South Carolina | 45077 | 28383 | 487 |
1939300 | 1939300 | 2021-11-21 | Pickens | South Carolina | 45077 | 28306 | 484 |
1936050 | 1936050 | 2021-11-20 | Pickens | South Carolina | 45077 | 28306 | 484 |
1932800 | 1932800 | 2021-11-19 | Pickens | South Carolina | 45077 | 28306 | 484 |
1929549 | 1929549 | 2021-11-18 | Pickens | South Carolina | 45077 | 28273 | 484 |
1926299 | 1926299 | 2021-11-17 | Pickens | South Carolina | 45077 | 28251 | 484 |
1923049 | 1923049 | 2021-11-16 | Pickens | South Carolina | 45077 | 28234 | 483 |
1919800 | 1919800 | 2021-11-15 | Pickens | South Carolina | 45077 | 28222 | 483 |
1916550 | 1916550 | 2021-11-14 | Pickens | South Carolina | 45077 | 28148 | 483 |
1913300 | 1913300 | 2021-11-13 | Pickens | South Carolina | 45077 | 28148 | 483 |
1910050 | 1910050 | 2021-11-12 | Pickens | South Carolina | 45077 | 28148 | 483 |
1906801 | 1906801 | 2021-11-11 | Pickens | South Carolina | 45077 | 28093 | 477 |
1903552 | 1903552 | 2021-11-10 | Pickens | South Carolina | 45077 | 28093 | 477 |
1900302 | 1900302 | 2021-11-09 | Pickens | South Carolina | 45077 | 28085 | 477 |
1897052 | 1897052 | 2021-11-08 | Pickens | South Carolina | 45077 | 28075 | 477 |
1893802 | 1893802 | 2021-11-07 | Pickens | South Carolina | 45077 | 27985 | 477 |
1890552 | 1890552 | 2021-11-06 | Pickens | South Carolina | 45077 | 27985 | 477 |
1887302 | 1887302 | 2021-11-05 | Pickens | South Carolina | 45077 | 27985 | 477 |
1884052 | 1884052 | 2021-11-04 | Pickens | South Carolina | 45077 | 27957 | 476 |
1880803 | 1880803 | 2021-11-03 | Pickens | South Carolina | 45077 | 27935 | 475 |
1877554 | 1877554 | 2021-11-02 | Pickens | South Carolina | 45077 | 27921 | 474 |
1874305 | 1874305 | 2021-11-01 | Pickens | South Carolina | 45077 | 27901 | 472 |
1871056 | 1871056 | 2021-10-31 | Pickens | South Carolina | 45077 | 27821 | 468 |
1867807 | 1867807 | 2021-10-30 | Pickens | South Carolina | 45077 | 27821 | 468 |
1864558 | 1864558 | 2021-10-29 | Pickens | South Carolina | 45077 | 27821 | 468 |
1861309 | 1861309 | 2021-10-28 | Pickens | South Carolina | 45077 | 27781 | 465 |
1858060 | 1858060 | 2021-10-27 | Pickens | South Carolina | 45077 | 27753 | 464 |
1854811 | 1854811 | 2021-10-26 | Pickens | South Carolina | 45077 | 27728 | 460 |
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);