ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 45007 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 |
---|---|---|---|---|---|---|---|
2176618 | 2176618 | 2022-02-02 | Anderson | South Carolina | 45007 | 55482 | 864 |
2173364 | 2173364 | 2022-02-01 | Anderson | South Carolina | 45007 | 55291 | 864 |
2170112 | 2170112 | 2022-01-31 | Anderson | South Carolina | 45007 | 55116 | 862 |
2166858 | 2166858 | 2022-01-30 | Anderson | South Carolina | 45007 | 54138 | 857 |
2163603 | 2163603 | 2022-01-29 | Anderson | South Carolina | 45007 | 54138 | 857 |
2160348 | 2160348 | 2022-01-28 | Anderson | South Carolina | 45007 | 54138 | 857 |
2157092 | 2157092 | 2022-01-27 | Anderson | South Carolina | 45007 | 53518 | 855 |
2153839 | 2153839 | 2022-01-26 | Anderson | South Carolina | 45007 | 53143 | 855 |
2150587 | 2150587 | 2022-01-25 | Anderson | South Carolina | 45007 | 50597 | 855 |
2147335 | 2147335 | 2022-01-24 | Anderson | South Carolina | 45007 | 50597 | 855 |
2144081 | 2144081 | 2022-01-23 | Anderson | South Carolina | 45007 | 50597 | 855 |
2140826 | 2140826 | 2022-01-22 | Anderson | South Carolina | 45007 | 50597 | 855 |
2137570 | 2137570 | 2022-01-21 | Anderson | South Carolina | 45007 | 50597 | 855 |
2134316 | 2134316 | 2022-01-20 | Anderson | South Carolina | 45007 | 50055 | 854 |
2131064 | 2131064 | 2022-01-19 | Anderson | South Carolina | 45007 | 49836 | 851 |
2127810 | 2127810 | 2022-01-18 | Anderson | South Carolina | 45007 | 49551 | 851 |
2124558 | 2124558 | 2022-01-17 | Anderson | South Carolina | 45007 | 46573 | 841 |
2121306 | 2121306 | 2022-01-16 | Anderson | South Carolina | 45007 | 46573 | 841 |
2118054 | 2118054 | 2022-01-15 | Anderson | South Carolina | 45007 | 46573 | 841 |
2114803 | 2114803 | 2022-01-14 | Anderson | South Carolina | 45007 | 46573 | 841 |
2111551 | 2111551 | 2022-01-13 | Anderson | South Carolina | 45007 | 45624 | 840 |
2108299 | 2108299 | 2022-01-12 | Anderson | South Carolina | 45007 | 44877 | 835 |
2105048 | 2105048 | 2022-01-11 | Anderson | South Carolina | 45007 | 44626 | 831 |
2101797 | 2101797 | 2022-01-10 | Anderson | South Carolina | 45007 | 44425 | 831 |
2098546 | 2098546 | 2022-01-09 | Anderson | South Carolina | 45007 | 42592 | 827 |
2095294 | 2095294 | 2022-01-08 | Anderson | South Carolina | 45007 | 42592 | 827 |
2092042 | 2092042 | 2022-01-07 | Anderson | South Carolina | 45007 | 42592 | 827 |
2088790 | 2088790 | 2022-01-06 | Anderson | South Carolina | 45007 | 42062 | 827 |
2085539 | 2085539 | 2022-01-05 | Anderson | South Carolina | 45007 | 41472 | 826 |
2082287 | 2082287 | 2022-01-04 | Anderson | South Carolina | 45007 | 41326 | 822 |
2079035 | 2079035 | 2022-01-03 | Anderson | South Carolina | 45007 | 40080 | 819 |
2075784 | 2075784 | 2022-01-02 | Anderson | South Carolina | 45007 | 40080 | 819 |
2072533 | 2072533 | 2022-01-01 | Anderson | South Carolina | 45007 | 40080 | 819 |
2069282 | 2069282 | 2021-12-31 | Anderson | South Carolina | 45007 | 40080 | 819 |
2066031 | 2066031 | 2021-12-30 | Anderson | South Carolina | 45007 | 39779 | 817 |
2062781 | 2062781 | 2021-12-29 | Anderson | South Carolina | 45007 | 39600 | 817 |
2059531 | 2059531 | 2021-12-28 | Anderson | South Carolina | 45007 | 39027 | 811 |
2056282 | 2056282 | 2021-12-27 | Anderson | South Carolina | 45007 | 39027 | 811 |
2053033 | 2053033 | 2021-12-26 | Anderson | South Carolina | 45007 | 39027 | 811 |
2049783 | 2049783 | 2021-12-25 | Anderson | South Carolina | 45007 | 39027 | 811 |
2046533 | 2046533 | 2021-12-24 | Anderson | South Carolina | 45007 | 39027 | 811 |
2043283 | 2043283 | 2021-12-23 | Anderson | South Carolina | 45007 | 39027 | 811 |
2040034 | 2040034 | 2021-12-22 | Anderson | South Carolina | 45007 | 38942 | 811 |
2036784 | 2036784 | 2021-12-21 | Anderson | South Carolina | 45007 | 38888 | 811 |
2033534 | 2033534 | 2021-12-20 | Anderson | South Carolina | 45007 | 38822 | 810 |
2030284 | 2030284 | 2021-12-19 | Anderson | South Carolina | 45007 | 38610 | 808 |
2027033 | 2027033 | 2021-12-18 | Anderson | South Carolina | 45007 | 38610 | 808 |
2023782 | 2023782 | 2021-12-17 | Anderson | South Carolina | 45007 | 38610 | 808 |
2020531 | 2020531 | 2021-12-16 | Anderson | South Carolina | 45007 | 38535 | 806 |
2017280 | 2017280 | 2021-12-15 | Anderson | South Carolina | 45007 | 38489 | 805 |
2014030 | 2014030 | 2021-12-14 | Anderson | South Carolina | 45007 | 38442 | 802 |
2010779 | 2010779 | 2021-12-13 | Anderson | South Carolina | 45007 | 38406 | 801 |
2007528 | 2007528 | 2021-12-12 | Anderson | South Carolina | 45007 | 38200 | 801 |
2004277 | 2004277 | 2021-12-11 | Anderson | South Carolina | 45007 | 38200 | 801 |
2001026 | 2001026 | 2021-12-10 | Anderson | South Carolina | 45007 | 38200 | 801 |
1997776 | 1997776 | 2021-12-09 | Anderson | South Carolina | 45007 | 38117 | 800 |
1994525 | 1994525 | 2021-12-08 | Anderson | South Carolina | 45007 | 38057 | 799 |
1991274 | 1991274 | 2021-12-07 | Anderson | South Carolina | 45007 | 38029 | 798 |
1988023 | 1988023 | 2021-12-06 | Anderson | South Carolina | 45007 | 37981 | 798 |
1984773 | 1984773 | 2021-12-05 | Anderson | South Carolina | 45007 | 37770 | 794 |
1981523 | 1981523 | 2021-12-04 | Anderson | South Carolina | 45007 | 37770 | 794 |
1978273 | 1978273 | 2021-12-03 | Anderson | South Carolina | 45007 | 37770 | 794 |
1975023 | 1975023 | 2021-12-02 | Anderson | South Carolina | 45007 | 37709 | 793 |
1971774 | 1971774 | 2021-12-01 | Anderson | South Carolina | 45007 | 37671 | 791 |
1968524 | 1968524 | 2021-11-30 | Anderson | South Carolina | 45007 | 37627 | 791 |
1965273 | 1965273 | 2021-11-29 | Anderson | South Carolina | 45007 | 37601 | 791 |
1962021 | 1962021 | 2021-11-28 | Anderson | South Carolina | 45007 | 37451 | 788 |
1958770 | 1958770 | 2021-11-27 | Anderson | South Carolina | 45007 | 37451 | 788 |
1955519 | 1955519 | 2021-11-26 | Anderson | South Carolina | 45007 | 37451 | 788 |
1952268 | 1952268 | 2021-11-25 | Anderson | South Carolina | 45007 | 37404 | 786 |
1949017 | 1949017 | 2021-11-24 | Anderson | South Carolina | 45007 | 37404 | 786 |
1945766 | 1945766 | 2021-11-23 | Anderson | South Carolina | 45007 | 37384 | 786 |
1942515 | 1942515 | 2021-11-22 | Anderson | South Carolina | 45007 | 37359 | 786 |
1939265 | 1939265 | 2021-11-21 | Anderson | South Carolina | 45007 | 37232 | 784 |
1936015 | 1936015 | 2021-11-20 | Anderson | South Carolina | 45007 | 37232 | 784 |
1932765 | 1932765 | 2021-11-19 | Anderson | South Carolina | 45007 | 37232 | 784 |
1929514 | 1929514 | 2021-11-18 | Anderson | South Carolina | 45007 | 37191 | 782 |
1926264 | 1926264 | 2021-11-17 | Anderson | South Carolina | 45007 | 37152 | 780 |
1923014 | 1923014 | 2021-11-16 | Anderson | South Carolina | 45007 | 37129 | 778 |
1919765 | 1919765 | 2021-11-15 | Anderson | South Carolina | 45007 | 37110 | 778 |
1916515 | 1916515 | 2021-11-14 | Anderson | South Carolina | 45007 | 37032 | 772 |
1913265 | 1913265 | 2021-11-13 | Anderson | South Carolina | 45007 | 37032 | 772 |
1910015 | 1910015 | 2021-11-12 | Anderson | South Carolina | 45007 | 37032 | 772 |
1906766 | 1906766 | 2021-11-11 | Anderson | South Carolina | 45007 | 36926 | 765 |
1903517 | 1903517 | 2021-11-10 | Anderson | South Carolina | 45007 | 36926 | 765 |
1900267 | 1900267 | 2021-11-09 | Anderson | South Carolina | 45007 | 36916 | 765 |
1897017 | 1897017 | 2021-11-08 | Anderson | South Carolina | 45007 | 36897 | 765 |
1893767 | 1893767 | 2021-11-07 | Anderson | South Carolina | 45007 | 36795 | 760 |
1890517 | 1890517 | 2021-11-06 | Anderson | South Carolina | 45007 | 36795 | 760 |
1887267 | 1887267 | 2021-11-05 | Anderson | South Carolina | 45007 | 36795 | 760 |
1884017 | 1884017 | 2021-11-04 | Anderson | South Carolina | 45007 | 36762 | 758 |
1880768 | 1880768 | 2021-11-03 | Anderson | South Carolina | 45007 | 36730 | 753 |
1877519 | 1877519 | 2021-11-02 | Anderson | South Carolina | 45007 | 36710 | 748 |
1874270 | 1874270 | 2021-11-01 | Anderson | South Carolina | 45007 | 36692 | 748 |
1871021 | 1871021 | 2021-10-31 | Anderson | South Carolina | 45007 | 36570 | 747 |
1867772 | 1867772 | 2021-10-30 | Anderson | South Carolina | 45007 | 36570 | 747 |
1864523 | 1864523 | 2021-10-29 | Anderson | South Carolina | 45007 | 36570 | 747 |
1861274 | 1861274 | 2021-10-28 | Anderson | South Carolina | 45007 | 36473 | 743 |
1858025 | 1858025 | 2021-10-27 | Anderson | South Carolina | 45007 | 36437 | 736 |
1854776 | 1854776 | 2021-10-26 | Anderson | South Carolina | 45007 | 36410 | 734 |
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);