ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 78 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502039 | 2502039 | 2022-05-13 | Saluda | South Carolina | 45081 | 3968 | 78 |
2498781 | 2498781 | 2022-05-12 | Saluda | South Carolina | 45081 | 3968 | 78 |
2495523 | 2495523 | 2022-05-11 | Saluda | South Carolina | 45081 | 3968 | 78 |
2492265 | 2492265 | 2022-05-10 | Saluda | South Carolina | 45081 | 3962 | 78 |
2489007 | 2489007 | 2022-05-09 | Saluda | South Carolina | 45081 | 3962 | 78 |
2485750 | 2485750 | 2022-05-08 | Saluda | South Carolina | 45081 | 3962 | 78 |
2482492 | 2482492 | 2022-05-07 | Saluda | South Carolina | 45081 | 3962 | 78 |
2479234 | 2479234 | 2022-05-06 | Saluda | South Carolina | 45081 | 3962 | 78 |
2475976 | 2475976 | 2022-05-05 | Saluda | South Carolina | 45081 | 3962 | 78 |
2472719 | 2472719 | 2022-05-04 | Saluda | South Carolina | 45081 | 3962 | 78 |
2469463 | 2469463 | 2022-05-03 | Saluda | South Carolina | 45081 | 3962 | 78 |
2238430 | 2238430 | 2022-02-21 | Hampton | South Carolina | 45049 | 4977 | 78 |
2235179 | 2235179 | 2022-02-20 | Hampton | South Carolina | 45049 | 4977 | 78 |
2231928 | 2231928 | 2022-02-19 | Hampton | South Carolina | 45049 | 4977 | 78 |
2228677 | 2228677 | 2022-02-18 | Hampton | South Carolina | 45049 | 4977 | 78 |
2225426 | 2225426 | 2022-02-17 | Hampton | South Carolina | 45049 | 4970 | 78 |
2222175 | 2222175 | 2022-02-16 | Hampton | South Carolina | 45049 | 4964 | 78 |
2218924 | 2218924 | 2022-02-15 | Hampton | South Carolina | 45049 | 4960 | 78 |
2215673 | 2215673 | 2022-02-14 | Hampton | South Carolina | 45049 | 4956 | 78 |
2212422 | 2212422 | 2022-02-13 | Hampton | South Carolina | 45049 | 4922 | 78 |
2209169 | 2209169 | 2022-02-12 | Hampton | South Carolina | 45049 | 4922 | 78 |
2205916 | 2205916 | 2022-02-11 | Hampton | South Carolina | 45049 | 4922 | 78 |
2202663 | 2202663 | 2022-02-10 | Hampton | South Carolina | 45049 | 4922 | 78 |
2199409 | 2199409 | 2022-02-09 | Hampton | South Carolina | 45049 | 4915 | 78 |
2196155 | 2196155 | 2022-02-08 | Hampton | South Carolina | 45049 | 4903 | 78 |
2192901 | 2192901 | 2022-02-07 | Hampton | South Carolina | 45049 | 4889 | 78 |
2189647 | 2189647 | 2022-02-06 | Hampton | South Carolina | 45049 | 4862 | 78 |
2186394 | 2186394 | 2022-02-05 | Hampton | South Carolina | 45049 | 4862 | 78 |
2183142 | 2183142 | 2022-02-04 | Hampton | South Carolina | 45049 | 4862 | 78 |
2179890 | 2179890 | 2022-02-03 | Hampton | South Carolina | 45049 | 4809 | 78 |
2176639 | 2176639 | 2022-02-02 | Hampton | South Carolina | 45049 | 4788 | 78 |
2173385 | 2173385 | 2022-02-01 | Hampton | South Carolina | 45049 | 4777 | 78 |
2170133 | 2170133 | 2022-01-31 | Hampton | South Carolina | 45049 | 4743 | 78 |
1968551 | 1968551 | 2021-11-30 | Lee | South Carolina | 45061 | 2653 | 78 |
1965300 | 1965300 | 2021-11-29 | Lee | South Carolina | 45061 | 2647 | 78 |
1962048 | 1962048 | 2021-11-28 | Lee | South Carolina | 45061 | 2636 | 78 |
1958797 | 1958797 | 2021-11-27 | Lee | South Carolina | 45061 | 2636 | 78 |
1955546 | 1955546 | 2021-11-26 | Lee | South Carolina | 45061 | 2636 | 78 |
1838551 | 1838551 | 2021-10-21 | Jasper | South Carolina | 45053 | 3919 | 78 |
1838558 | 1838558 | 2021-10-21 | Marlboro | South Carolina | 45069 | 4795 | 78 |
1835302 | 1835302 | 2021-10-20 | Jasper | South Carolina | 45053 | 3917 | 78 |
1832053 | 1832053 | 2021-10-19 | Jasper | South Carolina | 45053 | 3914 | 78 |
1828804 | 1828804 | 2021-10-18 | Jasper | South Carolina | 45053 | 3910 | 78 |
1825555 | 1825555 | 2021-10-17 | Jasper | South Carolina | 45053 | 3904 | 78 |
1822306 | 1822306 | 2021-10-16 | Jasper | South Carolina | 45053 | 3904 | 78 |
1819057 | 1819057 | 2021-10-15 | Jasper | South Carolina | 45053 | 3904 | 78 |
1815808 | 1815808 | 2021-10-14 | Jasper | South Carolina | 45053 | 3902 | 78 |
1780048 | 1780048 | 2021-10-03 | Barnwell | South Carolina | 45011 | 3761 | 78 |
1776798 | 1776798 | 2021-10-02 | Barnwell | South Carolina | 45011 | 3761 | 78 |
1773548 | 1773548 | 2021-10-01 | Barnwell | South Carolina | 45011 | 3761 | 78 |
1770298 | 1770298 | 2021-09-30 | Barnwell | South Carolina | 45011 | 3753 | 78 |
1767049 | 1767049 | 2021-09-29 | Barnwell | South Carolina | 45011 | 3746 | 78 |
1763800 | 1763800 | 2021-09-28 | Barnwell | South Carolina | 45011 | 3744 | 78 |
1760551 | 1760551 | 2021-09-27 | Barnwell | South Carolina | 45011 | 3742 | 78 |
1559149 | 1559149 | 2021-07-27 | Chester | South Carolina | 45023 | 4373 | 78 |
1555902 | 1555902 | 2021-07-26 | Chester | South Carolina | 45023 | 4367 | 78 |
1176058 | 1176058 | 2021-03-31 | Fairfield | South Carolina | 45039 | 2272 | 78 |
1111142 | 1111142 | 2021-03-11 | Union | South Carolina | 45087 | 2716 | 78 |
1088391 | 1088391 | 2021-03-04 | Dillon | South Carolina | 45033 | 3987 | 78 |
1085146 | 1085146 | 2021-03-03 | Dillon | South Carolina | 45033 | 3971 | 78 |
1081900 | 1081900 | 2021-03-02 | Dillon | South Carolina | 45033 | 3966 | 78 |
1078654 | 1078654 | 2021-03-01 | Dillon | South Carolina | 45033 | 3961 | 78 |
1075409 | 1075409 | 2021-02-28 | Dillon | South Carolina | 45033 | 3957 | 78 |
1072163 | 1072163 | 2021-02-27 | Dillon | South Carolina | 45033 | 3948 | 78 |
1068917 | 1068917 | 2021-02-26 | Dillon | South Carolina | 45033 | 3901 | 78 |
1065672 | 1065672 | 2021-02-25 | Dillon | South Carolina | 45033 | 3894 | 78 |
1062427 | 1062427 | 2021-02-24 | Dillon | South Carolina | 45033 | 3887 | 78 |
994296 | 994296 | 2021-02-03 | Williamsburg | South Carolina | 45089 | 3362 | 78 |
974789 | 974789 | 2021-01-28 | Colleton | South Carolina | 45029 | 2729 | 78 |
955340 | 955340 | 2021-01-22 | Newberry | South Carolina | 45071 | 3571 | 78 |
952095 | 952095 | 2021-01-21 | Newberry | South Carolina | 45071 | 3539 | 78 |
948850 | 948850 | 2021-01-20 | Newberry | South Carolina | 45071 | 3515 | 78 |
935868 | 935868 | 2021-01-16 | Oconee | South Carolina | 45073 | 6550 | 78 |
932623 | 932623 | 2021-01-15 | Oconee | South Carolina | 45073 | 6401 | 78 |
880682 | 880682 | 2020-12-30 | Georgetown | South Carolina | 45043 | 3888 | 78 |
877437 | 877437 | 2020-12-29 | Georgetown | South Carolina | 45043 | 3828 | 78 |
874192 | 874192 | 2020-12-28 | Georgetown | South Carolina | 45043 | 3780 | 78 |
874200 | 874200 | 2020-12-28 | Laurens | South Carolina | 45059 | 3492 | 78 |
870947 | 870947 | 2020-12-27 | Georgetown | South Carolina | 45043 | 3752 | 78 |
870955 | 870955 | 2020-12-27 | Laurens | South Carolina | 45059 | 3469 | 78 |
867710 | 867710 | 2020-12-26 | Laurens | South Carolina | 45059 | 3336 | 78 |
851484 | 851484 | 2020-12-21 | Lancaster | South Carolina | 45057 | 4632 | 78 |
848239 | 848239 | 2020-12-20 | Lancaster | South Carolina | 45057 | 4576 | 78 |
747624 | 747624 | 2020-11-19 | Greenwood | South Carolina | 45047 | 2874 | 78 |
744378 | 744378 | 2020-11-18 | Greenwood | South Carolina | 45047 | 2839 | 78 |
741131 | 741131 | 2020-11-17 | Greenwood | South Carolina | 45047 | 2826 | 78 |
737885 | 737885 | 2020-11-16 | Greenwood | South Carolina | 45047 | 2794 | 78 |
734641 | 734641 | 2020-11-15 | Greenwood | South Carolina | 45047 | 2791 | 78 |
731395 | 731395 | 2020-11-14 | Greenwood | South Carolina | 45047 | 2778 | 78 |
728151 | 728151 | 2020-11-13 | Greenwood | South Carolina | 45047 | 2759 | 78 |
724907 | 724907 | 2020-11-12 | Greenwood | South Carolina | 45047 | 2736 | 78 |
721664 | 721664 | 2020-11-11 | Greenwood | South Carolina | 45047 | 2714 | 78 |
718421 | 718421 | 2020-11-10 | Greenwood | South Carolina | 45047 | 2705 | 78 |
715178 | 715178 | 2020-11-09 | Greenwood | South Carolina | 45047 | 2681 | 78 |
711934 | 711934 | 2020-11-08 | Greenwood | South Carolina | 45047 | 2675 | 78 |
601667 | 601667 | 2020-10-05 | Sumter | South Carolina | 45085 | 3270 | 78 |
598424 | 598424 | 2020-10-04 | Sumter | South Carolina | 45085 | 3269 | 78 |
595181 | 595181 | 2020-10-03 | Sumter | South Carolina | 45085 | 3269 | 78 |
591940 | 591940 | 2020-10-02 | Sumter | South Carolina | 45085 | 3259 | 78 |
588699 | 588699 | 2020-10-01 | Sumter | South Carolina | 45085 | 3247 | 78 |
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);