ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lexington" 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 |
---|---|---|---|---|---|---|---|
2176646 | 2176646 | 2022-02-02 | Lexington | South Carolina | 45063 | 90286 | 774 |
2173392 | 2173392 | 2022-02-01 | Lexington | South Carolina | 45063 | 90035 | 768 |
2170140 | 2170140 | 2022-01-31 | Lexington | South Carolina | 45063 | 89719 | 768 |
2166886 | 2166886 | 2022-01-30 | Lexington | South Carolina | 45063 | 87809 | 755 |
2163631 | 2163631 | 2022-01-29 | Lexington | South Carolina | 45063 | 87809 | 755 |
2160376 | 2160376 | 2022-01-28 | Lexington | South Carolina | 45063 | 87809 | 755 |
2157120 | 2157120 | 2022-01-27 | Lexington | South Carolina | 45063 | 86560 | 754 |
2153867 | 2153867 | 2022-01-26 | Lexington | South Carolina | 45063 | 85620 | 754 |
2150615 | 2150615 | 2022-01-25 | Lexington | South Carolina | 45063 | 80874 | 754 |
2147363 | 2147363 | 2022-01-24 | Lexington | South Carolina | 45063 | 80874 | 754 |
2144109 | 2144109 | 2022-01-23 | Lexington | South Carolina | 45063 | 80874 | 754 |
2140854 | 2140854 | 2022-01-22 | Lexington | South Carolina | 45063 | 80874 | 754 |
2137598 | 2137598 | 2022-01-21 | Lexington | South Carolina | 45063 | 80874 | 754 |
2134344 | 2134344 | 2022-01-20 | Lexington | South Carolina | 45063 | 79336 | 752 |
2131092 | 2131092 | 2022-01-19 | Lexington | South Carolina | 45063 | 78081 | 752 |
2127838 | 2127838 | 2022-01-18 | Lexington | South Carolina | 45063 | 77360 | 752 |
2124586 | 2124586 | 2022-01-17 | Lexington | South Carolina | 45063 | 72181 | 747 |
2121334 | 2121334 | 2022-01-16 | Lexington | South Carolina | 45063 | 72181 | 747 |
2118082 | 2118082 | 2022-01-15 | Lexington | South Carolina | 45063 | 72181 | 747 |
2114831 | 2114831 | 2022-01-14 | Lexington | South Carolina | 45063 | 72181 | 747 |
2111579 | 2111579 | 2022-01-13 | Lexington | South Carolina | 45063 | 70861 | 747 |
2108327 | 2108327 | 2022-01-12 | Lexington | South Carolina | 45063 | 69550 | 745 |
2105076 | 2105076 | 2022-01-11 | Lexington | South Carolina | 45063 | 68833 | 739 |
2101825 | 2101825 | 2022-01-10 | Lexington | South Carolina | 45063 | 68116 | 739 |
2098574 | 2098574 | 2022-01-09 | Lexington | South Carolina | 45063 | 64770 | 736 |
2095322 | 2095322 | 2022-01-08 | Lexington | South Carolina | 45063 | 64770 | 736 |
2092070 | 2092070 | 2022-01-07 | Lexington | South Carolina | 45063 | 64770 | 736 |
2088818 | 2088818 | 2022-01-06 | Lexington | South Carolina | 45063 | 63788 | 735 |
2085567 | 2085567 | 2022-01-05 | Lexington | South Carolina | 45063 | 62667 | 734 |
2082315 | 2082315 | 2022-01-04 | Lexington | South Carolina | 45063 | 62027 | 733 |
2079063 | 2079063 | 2022-01-03 | Lexington | South Carolina | 45063 | 59455 | 731 |
2075812 | 2075812 | 2022-01-02 | Lexington | South Carolina | 45063 | 59455 | 731 |
2072561 | 2072561 | 2022-01-01 | Lexington | South Carolina | 45063 | 59455 | 731 |
2069310 | 2069310 | 2021-12-31 | Lexington | South Carolina | 45063 | 59455 | 731 |
2066059 | 2066059 | 2021-12-30 | Lexington | South Carolina | 45063 | 58697 | 731 |
2062809 | 2062809 | 2021-12-29 | Lexington | South Carolina | 45063 | 58190 | 731 |
2059559 | 2059559 | 2021-12-28 | Lexington | South Carolina | 45063 | 57092 | 729 |
2056310 | 2056310 | 2021-12-27 | Lexington | South Carolina | 45063 | 57092 | 729 |
2053061 | 2053061 | 2021-12-26 | Lexington | South Carolina | 45063 | 57092 | 729 |
2049811 | 2049811 | 2021-12-25 | Lexington | South Carolina | 45063 | 57092 | 729 |
2046561 | 2046561 | 2021-12-24 | Lexington | South Carolina | 45063 | 57092 | 729 |
2043311 | 2043311 | 2021-12-23 | Lexington | South Carolina | 45063 | 57092 | 729 |
2040062 | 2040062 | 2021-12-22 | Lexington | South Carolina | 45063 | 56958 | 730 |
2036812 | 2036812 | 2021-12-21 | Lexington | South Carolina | 45063 | 56892 | 728 |
2033562 | 2033562 | 2021-12-20 | Lexington | South Carolina | 45063 | 56819 | 728 |
2030312 | 2030312 | 2021-12-19 | Lexington | South Carolina | 45063 | 56566 | 726 |
2027061 | 2027061 | 2021-12-18 | Lexington | South Carolina | 45063 | 56566 | 726 |
2023810 | 2023810 | 2021-12-17 | Lexington | South Carolina | 45063 | 56566 | 726 |
2020559 | 2020559 | 2021-12-16 | Lexington | South Carolina | 45063 | 56472 | 726 |
2017308 | 2017308 | 2021-12-15 | Lexington | South Carolina | 45063 | 56410 | 726 |
2014058 | 2014058 | 2021-12-14 | Lexington | South Carolina | 45063 | 56371 | 726 |
2010807 | 2010807 | 2021-12-13 | Lexington | South Carolina | 45063 | 56322 | 726 |
2007556 | 2007556 | 2021-12-12 | Lexington | South Carolina | 45063 | 56131 | 725 |
2004305 | 2004305 | 2021-12-11 | Lexington | South Carolina | 45063 | 56131 | 725 |
2001054 | 2001054 | 2021-12-10 | Lexington | South Carolina | 45063 | 56131 | 725 |
1997804 | 1997804 | 2021-12-09 | Lexington | South Carolina | 45063 | 56039 | 724 |
1994553 | 1994553 | 2021-12-08 | Lexington | South Carolina | 45063 | 55958 | 723 |
1991302 | 1991302 | 2021-12-07 | Lexington | South Carolina | 45063 | 55921 | 721 |
1988051 | 1988051 | 2021-12-06 | Lexington | South Carolina | 45063 | 55883 | 721 |
1984801 | 1984801 | 2021-12-05 | Lexington | South Carolina | 45063 | 55713 | 721 |
1981551 | 1981551 | 2021-12-04 | Lexington | South Carolina | 45063 | 55713 | 721 |
1978301 | 1978301 | 2021-12-03 | Lexington | South Carolina | 45063 | 55713 | 721 |
1975051 | 1975051 | 2021-12-02 | Lexington | South Carolina | 45063 | 55638 | 721 |
1971802 | 1971802 | 2021-12-01 | Lexington | South Carolina | 45063 | 55564 | 720 |
1968552 | 1968552 | 2021-11-30 | Lexington | South Carolina | 45063 | 55512 | 720 |
1965301 | 1965301 | 2021-11-29 | Lexington | South Carolina | 45063 | 55483 | 720 |
1962049 | 1962049 | 2021-11-28 | Lexington | South Carolina | 45063 | 55311 | 718 |
1958798 | 1958798 | 2021-11-27 | Lexington | South Carolina | 45063 | 55311 | 718 |
1955547 | 1955547 | 2021-11-26 | Lexington | South Carolina | 45063 | 55311 | 718 |
1952296 | 1952296 | 2021-11-25 | Lexington | South Carolina | 45063 | 55255 | 718 |
1949045 | 1949045 | 2021-11-24 | Lexington | South Carolina | 45063 | 55255 | 718 |
1945794 | 1945794 | 2021-11-23 | Lexington | South Carolina | 45063 | 55238 | 717 |
1942543 | 1942543 | 2021-11-22 | Lexington | South Carolina | 45063 | 55204 | 717 |
1939293 | 1939293 | 2021-11-21 | Lexington | South Carolina | 45063 | 55046 | 717 |
1936043 | 1936043 | 2021-11-20 | Lexington | South Carolina | 45063 | 55046 | 717 |
1932793 | 1932793 | 2021-11-19 | Lexington | South Carolina | 45063 | 55046 | 717 |
1929542 | 1929542 | 2021-11-18 | Lexington | South Carolina | 45063 | 54993 | 716 |
1926292 | 1926292 | 2021-11-17 | Lexington | South Carolina | 45063 | 54956 | 716 |
1923042 | 1923042 | 2021-11-16 | Lexington | South Carolina | 45063 | 54941 | 714 |
1919793 | 1919793 | 2021-11-15 | Lexington | South Carolina | 45063 | 54913 | 714 |
1916543 | 1916543 | 2021-11-14 | Lexington | South Carolina | 45063 | 54811 | 708 |
1913293 | 1913293 | 2021-11-13 | Lexington | South Carolina | 45063 | 54811 | 708 |
1910043 | 1910043 | 2021-11-12 | Lexington | South Carolina | 45063 | 54811 | 708 |
1906794 | 1906794 | 2021-11-11 | Lexington | South Carolina | 45063 | 54719 | 706 |
1903545 | 1903545 | 2021-11-10 | Lexington | South Carolina | 45063 | 54719 | 706 |
1900295 | 1900295 | 2021-11-09 | Lexington | South Carolina | 45063 | 54700 | 705 |
1897045 | 1897045 | 2021-11-08 | Lexington | South Carolina | 45063 | 54683 | 705 |
1893795 | 1893795 | 2021-11-07 | Lexington | South Carolina | 45063 | 54569 | 706 |
1890545 | 1890545 | 2021-11-06 | Lexington | South Carolina | 45063 | 54569 | 706 |
1887295 | 1887295 | 2021-11-05 | Lexington | South Carolina | 45063 | 54569 | 706 |
1884045 | 1884045 | 2021-11-04 | Lexington | South Carolina | 45063 | 54512 | 706 |
1880796 | 1880796 | 2021-11-03 | Lexington | South Carolina | 45063 | 54474 | 708 |
1877547 | 1877547 | 2021-11-02 | Lexington | South Carolina | 45063 | 54429 | 707 |
1874298 | 1874298 | 2021-11-01 | Lexington | South Carolina | 45063 | 54415 | 707 |
1871049 | 1871049 | 2021-10-31 | Lexington | South Carolina | 45063 | 54287 | 706 |
1867800 | 1867800 | 2021-10-30 | Lexington | South Carolina | 45063 | 54287 | 706 |
1864551 | 1864551 | 2021-10-29 | Lexington | South Carolina | 45063 | 54287 | 706 |
1861302 | 1861302 | 2021-10-28 | Lexington | South Carolina | 45063 | 54199 | 705 |
1858053 | 1858053 | 2021-10-27 | Lexington | South Carolina | 45063 | 54146 | 704 |
1854804 | 1854804 | 2021-10-26 | Lexington | South Carolina | 45063 | 54107 | 700 |
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);