ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Richland" 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 |
---|---|---|---|---|---|---|---|
2176654 | 2176654 | 2022-02-02 | Richland | South Carolina | 45079 | 114617 | 843 |
2173400 | 2173400 | 2022-02-01 | Richland | South Carolina | 45079 | 114292 | 834 |
2170148 | 2170148 | 2022-01-31 | Richland | South Carolina | 45079 | 114014 | 834 |
2166894 | 2166894 | 2022-01-30 | Richland | South Carolina | 45079 | 111938 | 825 |
2163639 | 2163639 | 2022-01-29 | Richland | South Carolina | 45079 | 111938 | 825 |
2160384 | 2160384 | 2022-01-28 | Richland | South Carolina | 45079 | 111938 | 825 |
2157128 | 2157128 | 2022-01-27 | Richland | South Carolina | 45079 | 110423 | 820 |
2153875 | 2153875 | 2022-01-26 | Richland | South Carolina | 45079 | 109697 | 820 |
2150623 | 2150623 | 2022-01-25 | Richland | South Carolina | 45079 | 105365 | 818 |
2147371 | 2147371 | 2022-01-24 | Richland | South Carolina | 45079 | 105365 | 818 |
2144117 | 2144117 | 2022-01-23 | Richland | South Carolina | 45079 | 105365 | 818 |
2140862 | 2140862 | 2022-01-22 | Richland | South Carolina | 45079 | 105365 | 818 |
2137606 | 2137606 | 2022-01-21 | Richland | South Carolina | 45079 | 105365 | 818 |
2134352 | 2134352 | 2022-01-20 | Richland | South Carolina | 45079 | 104055 | 817 |
2131100 | 2131100 | 2022-01-19 | Richland | South Carolina | 45079 | 102973 | 817 |
2127846 | 2127846 | 2022-01-18 | Richland | South Carolina | 45079 | 102249 | 817 |
2124594 | 2124594 | 2022-01-17 | Richland | South Carolina | 45079 | 95494 | 812 |
2121342 | 2121342 | 2022-01-16 | Richland | South Carolina | 45079 | 95494 | 812 |
2118090 | 2118090 | 2022-01-15 | Richland | South Carolina | 45079 | 95494 | 812 |
2114839 | 2114839 | 2022-01-14 | Richland | South Carolina | 45079 | 95494 | 812 |
2111587 | 2111587 | 2022-01-13 | Richland | South Carolina | 45079 | 93834 | 811 |
2108335 | 2108335 | 2022-01-12 | Richland | South Carolina | 45079 | 91971 | 811 |
2105084 | 2105084 | 2022-01-11 | Richland | South Carolina | 45079 | 90724 | 810 |
2101833 | 2101833 | 2022-01-10 | Richland | South Carolina | 45079 | 89803 | 807 |
2098582 | 2098582 | 2022-01-09 | Richland | South Carolina | 45079 | 85356 | 806 |
2095330 | 2095330 | 2022-01-08 | Richland | South Carolina | 45079 | 85356 | 806 |
2092078 | 2092078 | 2022-01-07 | Richland | South Carolina | 45079 | 85356 | 806 |
2088826 | 2088826 | 2022-01-06 | Richland | South Carolina | 45079 | 83761 | 806 |
2085575 | 2085575 | 2022-01-05 | Richland | South Carolina | 45079 | 81927 | 805 |
2082323 | 2082323 | 2022-01-04 | Richland | South Carolina | 45079 | 80959 | 805 |
2079071 | 2079071 | 2022-01-03 | Richland | South Carolina | 45079 | 76175 | 801 |
2075820 | 2075820 | 2022-01-02 | Richland | South Carolina | 45079 | 76175 | 801 |
2072569 | 2072569 | 2022-01-01 | Richland | South Carolina | 45079 | 76175 | 801 |
2069318 | 2069318 | 2021-12-31 | Richland | South Carolina | 45079 | 76175 | 801 |
2066067 | 2066067 | 2021-12-30 | Richland | South Carolina | 45079 | 74853 | 801 |
2062817 | 2062817 | 2021-12-29 | Richland | South Carolina | 45079 | 74208 | 801 |
2059567 | 2059567 | 2021-12-28 | Richland | South Carolina | 45079 | 72050 | 800 |
2056318 | 2056318 | 2021-12-27 | Richland | South Carolina | 45079 | 72050 | 800 |
2053069 | 2053069 | 2021-12-26 | Richland | South Carolina | 45079 | 72050 | 800 |
2049819 | 2049819 | 2021-12-25 | Richland | South Carolina | 45079 | 72050 | 800 |
2046569 | 2046569 | 2021-12-24 | Richland | South Carolina | 45079 | 72050 | 800 |
2043319 | 2043319 | 2021-12-23 | Richland | South Carolina | 45079 | 72050 | 800 |
2040070 | 2040070 | 2021-12-22 | Richland | South Carolina | 45079 | 71773 | 800 |
2036820 | 2036820 | 2021-12-21 | Richland | South Carolina | 45079 | 71662 | 799 |
2033570 | 2033570 | 2021-12-20 | Richland | South Carolina | 45079 | 71579 | 799 |
2030320 | 2030320 | 2021-12-19 | Richland | South Carolina | 45079 | 71257 | 799 |
2027069 | 2027069 | 2021-12-18 | Richland | South Carolina | 45079 | 71257 | 799 |
2023818 | 2023818 | 2021-12-17 | Richland | South Carolina | 45079 | 71257 | 799 |
2020567 | 2020567 | 2021-12-16 | Richland | South Carolina | 45079 | 71171 | 799 |
2017316 | 2017316 | 2021-12-15 | Richland | South Carolina | 45079 | 71089 | 799 |
2014066 | 2014066 | 2021-12-14 | Richland | South Carolina | 45079 | 71064 | 798 |
2010815 | 2010815 | 2021-12-13 | Richland | South Carolina | 45079 | 71012 | 796 |
2007564 | 2007564 | 2021-12-12 | Richland | South Carolina | 45079 | 70854 | 795 |
2004313 | 2004313 | 2021-12-11 | Richland | South Carolina | 45079 | 70854 | 795 |
2001062 | 2001062 | 2021-12-10 | Richland | South Carolina | 45079 | 70854 | 795 |
1997812 | 1997812 | 2021-12-09 | Richland | South Carolina | 45079 | 70767 | 793 |
1994561 | 1994561 | 2021-12-08 | Richland | South Carolina | 45079 | 70701 | 792 |
1991310 | 1991310 | 2021-12-07 | Richland | South Carolina | 45079 | 70663 | 791 |
1988059 | 1988059 | 2021-12-06 | Richland | South Carolina | 45079 | 70622 | 790 |
1984809 | 1984809 | 2021-12-05 | Richland | South Carolina | 45079 | 70437 | 789 |
1981559 | 1981559 | 2021-12-04 | Richland | South Carolina | 45079 | 70437 | 789 |
1978309 | 1978309 | 2021-12-03 | Richland | South Carolina | 45079 | 70437 | 789 |
1975059 | 1975059 | 2021-12-02 | Richland | South Carolina | 45079 | 70359 | 789 |
1971810 | 1971810 | 2021-12-01 | Richland | South Carolina | 45079 | 70268 | 787 |
1968560 | 1968560 | 2021-11-30 | Richland | South Carolina | 45079 | 70222 | 783 |
1965309 | 1965309 | 2021-11-29 | Richland | South Carolina | 45079 | 70200 | 782 |
1962057 | 1962057 | 2021-11-28 | Richland | South Carolina | 45079 | 70094 | 781 |
1958806 | 1958806 | 2021-11-27 | Richland | South Carolina | 45079 | 70094 | 781 |
1955555 | 1955555 | 2021-11-26 | Richland | South Carolina | 45079 | 70094 | 781 |
1952304 | 1952304 | 2021-11-25 | Richland | South Carolina | 45079 | 70053 | 780 |
1949053 | 1949053 | 2021-11-24 | Richland | South Carolina | 45079 | 70053 | 780 |
1945802 | 1945802 | 2021-11-23 | Richland | South Carolina | 45079 | 70038 | 778 |
1942551 | 1942551 | 2021-11-22 | Richland | South Carolina | 45079 | 70016 | 778 |
1939301 | 1939301 | 2021-11-21 | Richland | South Carolina | 45079 | 69864 | 776 |
1936051 | 1936051 | 2021-11-20 | Richland | South Carolina | 45079 | 69864 | 776 |
1932801 | 1932801 | 2021-11-19 | Richland | South Carolina | 45079 | 69864 | 776 |
1929550 | 1929550 | 2021-11-18 | Richland | South Carolina | 45079 | 69802 | 776 |
1926300 | 1926300 | 2021-11-17 | Richland | South Carolina | 45079 | 69725 | 776 |
1923050 | 1923050 | 2021-11-16 | Richland | South Carolina | 45079 | 69719 | 777 |
1919801 | 1919801 | 2021-11-15 | Richland | South Carolina | 45079 | 69692 | 776 |
1916551 | 1916551 | 2021-11-14 | Richland | South Carolina | 45079 | 69563 | 774 |
1913301 | 1913301 | 2021-11-13 | Richland | South Carolina | 45079 | 69563 | 774 |
1910051 | 1910051 | 2021-11-12 | Richland | South Carolina | 45079 | 69563 | 774 |
1906802 | 1906802 | 2021-11-11 | Richland | South Carolina | 45079 | 69450 | 771 |
1903553 | 1903553 | 2021-11-10 | Richland | South Carolina | 45079 | 69450 | 771 |
1900303 | 1900303 | 2021-11-09 | Richland | South Carolina | 45079 | 69426 | 769 |
1897053 | 1897053 | 2021-11-08 | Richland | South Carolina | 45079 | 69407 | 769 |
1893803 | 1893803 | 2021-11-07 | Richland | South Carolina | 45079 | 69303 | 768 |
1890553 | 1890553 | 2021-11-06 | Richland | South Carolina | 45079 | 69303 | 768 |
1887303 | 1887303 | 2021-11-05 | Richland | South Carolina | 45079 | 69303 | 768 |
1884053 | 1884053 | 2021-11-04 | Richland | South Carolina | 45079 | 69247 | 767 |
1880804 | 1880804 | 2021-11-03 | Richland | South Carolina | 45079 | 69170 | 767 |
1877555 | 1877555 | 2021-11-02 | Richland | South Carolina | 45079 | 69134 | 765 |
1874306 | 1874306 | 2021-11-01 | Richland | South Carolina | 45079 | 69101 | 764 |
1871057 | 1871057 | 2021-10-31 | Richland | South Carolina | 45079 | 68971 | 761 |
1867808 | 1867808 | 2021-10-30 | Richland | South Carolina | 45079 | 68971 | 761 |
1864559 | 1864559 | 2021-10-29 | Richland | South Carolina | 45079 | 68971 | 761 |
1861310 | 1861310 | 2021-10-28 | Richland | South Carolina | 45079 | 68863 | 760 |
1858061 | 1858061 | 2021-10-27 | Richland | South Carolina | 45079 | 68801 | 759 |
1854812 | 1854812 | 2021-10-26 | Richland | South Carolina | 45079 | 68768 | 756 |
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);