ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Charleston" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176624 | 2176624 | 2022-02-02 | Charleston | South Carolina | 45019 | 106668 | 826 |
2173370 | 2173370 | 2022-02-01 | Charleston | South Carolina | 45019 | 106203 | 810 |
2170118 | 2170118 | 2022-01-31 | Charleston | South Carolina | 45019 | 105922 | 810 |
2166864 | 2166864 | 2022-01-30 | Charleston | South Carolina | 45019 | 103499 | 796 |
2163609 | 2163609 | 2022-01-29 | Charleston | South Carolina | 45019 | 103499 | 796 |
2160354 | 2160354 | 2022-01-28 | Charleston | South Carolina | 45019 | 103499 | 796 |
2157098 | 2157098 | 2022-01-27 | Charleston | South Carolina | 45019 | 102217 | 786 |
2153845 | 2153845 | 2022-01-26 | Charleston | South Carolina | 45019 | 101191 | 785 |
2150593 | 2150593 | 2022-01-25 | Charleston | South Carolina | 45019 | 96862 | 780 |
2147341 | 2147341 | 2022-01-24 | Charleston | South Carolina | 45019 | 96862 | 780 |
2144087 | 2144087 | 2022-01-23 | Charleston | South Carolina | 45019 | 96862 | 780 |
2140832 | 2140832 | 2022-01-22 | Charleston | South Carolina | 45019 | 96862 | 780 |
2137576 | 2137576 | 2022-01-21 | Charleston | South Carolina | 45019 | 96862 | 780 |
2134322 | 2134322 | 2022-01-20 | Charleston | South Carolina | 45019 | 95208 | 779 |
2131070 | 2131070 | 2022-01-19 | Charleston | South Carolina | 45019 | 94092 | 774 |
2127816 | 2127816 | 2022-01-18 | Charleston | South Carolina | 45019 | 93398 | 774 |
2124564 | 2124564 | 2022-01-17 | Charleston | South Carolina | 45019 | 88396 | 772 |
2121312 | 2121312 | 2022-01-16 | Charleston | South Carolina | 45019 | 88396 | 772 |
2118060 | 2118060 | 2022-01-15 | Charleston | South Carolina | 45019 | 88396 | 772 |
2114809 | 2114809 | 2022-01-14 | Charleston | South Carolina | 45019 | 88396 | 772 |
2111557 | 2111557 | 2022-01-13 | Charleston | South Carolina | 45019 | 86847 | 771 |
2108305 | 2108305 | 2022-01-12 | Charleston | South Carolina | 45019 | 85515 | 767 |
2105054 | 2105054 | 2022-01-11 | Charleston | South Carolina | 45019 | 84332 | 766 |
2101803 | 2101803 | 2022-01-10 | Charleston | South Carolina | 45019 | 83608 | 766 |
2098552 | 2098552 | 2022-01-09 | Charleston | South Carolina | 45019 | 79240 | 761 |
2095300 | 2095300 | 2022-01-08 | Charleston | South Carolina | 45019 | 79240 | 761 |
2092048 | 2092048 | 2022-01-07 | Charleston | South Carolina | 45019 | 79240 | 761 |
2088796 | 2088796 | 2022-01-06 | Charleston | South Carolina | 45019 | 78131 | 761 |
2085545 | 2085545 | 2022-01-05 | Charleston | South Carolina | 45019 | 76452 | 756 |
2082293 | 2082293 | 2022-01-04 | Charleston | South Carolina | 45019 | 75669 | 756 |
2079041 | 2079041 | 2022-01-03 | Charleston | South Carolina | 45019 | 71954 | 755 |
2075790 | 2075790 | 2022-01-02 | Charleston | South Carolina | 45019 | 71954 | 755 |
2072539 | 2072539 | 2022-01-01 | Charleston | South Carolina | 45019 | 71954 | 755 |
2069288 | 2069288 | 2021-12-31 | Charleston | South Carolina | 45019 | 71954 | 755 |
2066037 | 2066037 | 2021-12-30 | Charleston | South Carolina | 45019 | 71118 | 754 |
2062787 | 2062787 | 2021-12-29 | Charleston | South Carolina | 45019 | 70371 | 754 |
2059537 | 2059537 | 2021-12-28 | Charleston | South Carolina | 45019 | 68566 | 753 |
2056288 | 2056288 | 2021-12-27 | Charleston | South Carolina | 45019 | 68566 | 753 |
2053039 | 2053039 | 2021-12-26 | Charleston | South Carolina | 45019 | 68566 | 753 |
2049789 | 2049789 | 2021-12-25 | Charleston | South Carolina | 45019 | 68566 | 753 |
2046539 | 2046539 | 2021-12-24 | Charleston | South Carolina | 45019 | 68566 | 753 |
2043289 | 2043289 | 2021-12-23 | Charleston | South Carolina | 45019 | 68566 | 753 |
2040040 | 2040040 | 2021-12-22 | Charleston | South Carolina | 45019 | 68341 | 753 |
2036790 | 2036790 | 2021-12-21 | Charleston | South Carolina | 45019 | 68194 | 752 |
2033540 | 2033540 | 2021-12-20 | Charleston | South Carolina | 45019 | 68127 | 752 |
2030290 | 2030290 | 2021-12-19 | Charleston | South Carolina | 45019 | 67819 | 749 |
2027039 | 2027039 | 2021-12-18 | Charleston | South Carolina | 45019 | 67819 | 749 |
2023788 | 2023788 | 2021-12-17 | Charleston | South Carolina | 45019 | 67819 | 749 |
2020537 | 2020537 | 2021-12-16 | Charleston | South Carolina | 45019 | 67746 | 749 |
2017286 | 2017286 | 2021-12-15 | Charleston | South Carolina | 45019 | 67679 | 748 |
2014036 | 2014036 | 2021-12-14 | Charleston | South Carolina | 45019 | 67640 | 748 |
2010785 | 2010785 | 2021-12-13 | Charleston | South Carolina | 45019 | 67609 | 748 |
2007534 | 2007534 | 2021-12-12 | Charleston | South Carolina | 45019 | 67416 | 747 |
2004283 | 2004283 | 2021-12-11 | Charleston | South Carolina | 45019 | 67416 | 747 |
2001032 | 2001032 | 2021-12-10 | Charleston | South Carolina | 45019 | 67416 | 747 |
1997782 | 1997782 | 2021-12-09 | Charleston | South Carolina | 45019 | 67289 | 745 |
1994531 | 1994531 | 2021-12-08 | Charleston | South Carolina | 45019 | 67206 | 745 |
1991280 | 1991280 | 2021-12-07 | Charleston | South Carolina | 45019 | 67170 | 745 |
1988029 | 1988029 | 2021-12-06 | Charleston | South Carolina | 45019 | 67126 | 745 |
1984779 | 1984779 | 2021-12-05 | Charleston | South Carolina | 45019 | 66882 | 741 |
1981529 | 1981529 | 2021-12-04 | Charleston | South Carolina | 45019 | 66882 | 741 |
1978279 | 1978279 | 2021-12-03 | Charleston | South Carolina | 45019 | 66882 | 741 |
1975029 | 1975029 | 2021-12-02 | Charleston | South Carolina | 45019 | 66802 | 740 |
1971780 | 1971780 | 2021-12-01 | Charleston | South Carolina | 45019 | 66717 | 739 |
1968530 | 1968530 | 2021-11-30 | Charleston | South Carolina | 45019 | 66650 | 736 |
1965279 | 1965279 | 2021-11-29 | Charleston | South Carolina | 45019 | 66616 | 736 |
1962027 | 1962027 | 2021-11-28 | Charleston | South Carolina | 45019 | 66472 | 735 |
1958776 | 1958776 | 2021-11-27 | Charleston | South Carolina | 45019 | 66472 | 735 |
1955525 | 1955525 | 2021-11-26 | Charleston | South Carolina | 45019 | 66472 | 735 |
1952274 | 1952274 | 2021-11-25 | Charleston | South Carolina | 45019 | 66420 | 735 |
1949023 | 1949023 | 2021-11-24 | Charleston | South Carolina | 45019 | 66420 | 735 |
1945772 | 1945772 | 2021-11-23 | Charleston | South Carolina | 45019 | 66361 | 732 |
1942521 | 1942521 | 2021-11-22 | Charleston | South Carolina | 45019 | 66340 | 732 |
1939271 | 1939271 | 2021-11-21 | Charleston | South Carolina | 45019 | 66186 | 730 |
1936021 | 1936021 | 2021-11-20 | Charleston | South Carolina | 45019 | 66186 | 730 |
1932771 | 1932771 | 2021-11-19 | Charleston | South Carolina | 45019 | 66186 | 730 |
1929520 | 1929520 | 2021-11-18 | Charleston | South Carolina | 45019 | 66122 | 728 |
1926270 | 1926270 | 2021-11-17 | Charleston | South Carolina | 45019 | 66071 | 728 |
1923020 | 1923020 | 2021-11-16 | Charleston | South Carolina | 45019 | 66039 | 727 |
1919771 | 1919771 | 2021-11-15 | Charleston | South Carolina | 45019 | 66006 | 727 |
1916521 | 1916521 | 2021-11-14 | Charleston | South Carolina | 45019 | 65862 | 726 |
1913271 | 1913271 | 2021-11-13 | Charleston | South Carolina | 45019 | 65862 | 726 |
1910021 | 1910021 | 2021-11-12 | Charleston | South Carolina | 45019 | 65862 | 726 |
1906772 | 1906772 | 2021-11-11 | Charleston | South Carolina | 45019 | 65738 | 724 |
1903523 | 1903523 | 2021-11-10 | Charleston | South Carolina | 45019 | 65738 | 724 |
1900273 | 1900273 | 2021-11-09 | Charleston | South Carolina | 45019 | 65731 | 721 |
1897023 | 1897023 | 2021-11-08 | Charleston | South Carolina | 45019 | 65710 | 720 |
1893773 | 1893773 | 2021-11-07 | Charleston | South Carolina | 45019 | 65544 | 720 |
1890523 | 1890523 | 2021-11-06 | Charleston | South Carolina | 45019 | 65544 | 720 |
1887273 | 1887273 | 2021-11-05 | Charleston | South Carolina | 45019 | 65544 | 720 |
1884023 | 1884023 | 2021-11-04 | Charleston | South Carolina | 45019 | 65480 | 720 |
1880774 | 1880774 | 2021-11-03 | Charleston | South Carolina | 45019 | 65430 | 720 |
1877525 | 1877525 | 2021-11-02 | Charleston | South Carolina | 45019 | 65408 | 717 |
1874276 | 1874276 | 2021-11-01 | Charleston | South Carolina | 45019 | 65382 | 716 |
1871027 | 1871027 | 2021-10-31 | Charleston | South Carolina | 45019 | 65233 | 713 |
1867778 | 1867778 | 2021-10-30 | Charleston | South Carolina | 45019 | 65233 | 713 |
1864529 | 1864529 | 2021-10-29 | Charleston | South Carolina | 45019 | 65233 | 713 |
1861280 | 1861280 | 2021-10-28 | Charleston | South Carolina | 45019 | 65143 | 712 |
1858031 | 1858031 | 2021-10-27 | Charleston | South Carolina | 45019 | 65089 | 708 |
1854782 | 1854782 | 2021-10-26 | Charleston | South Carolina | 45019 | 65048 | 703 |
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);