ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 154 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Newberry 30
- Cherokee 11
- Clarendon 7
- Georgetown 3
- Beaufort 2
- Lexington 2
- Aiken 1
- Berkeley 1
- Charleston 1
- Chesterfield 1
- Dorchester 1
- Greenwood 1
- Lancaster 1
- Laurens 1
- Orangeburg 1
- Richland 1
state 1
- South Carolina · 65 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280690 | 2280690 | 2022-03-06 | Clarendon | South Carolina | 45027 | 8676 | 154 |
2277437 | 2277437 | 2022-03-05 | Clarendon | South Carolina | 45027 | 8676 | 154 |
2274184 | 2274184 | 2022-03-04 | Clarendon | South Carolina | 45027 | 8676 | 154 |
2270931 | 2270931 | 2022-03-03 | Clarendon | South Carolina | 45027 | 8675 | 154 |
2267679 | 2267679 | 2022-03-02 | Clarendon | South Carolina | 45027 | 8674 | 154 |
2264426 | 2264426 | 2022-03-01 | Clarendon | South Carolina | 45027 | 8672 | 154 |
2261176 | 2261176 | 2022-02-28 | Clarendon | South Carolina | 45027 | 8669 | 154 |
2157124 | 2157124 | 2022-01-27 | Newberry | South Carolina | 45071 | 12058 | 154 |
2153871 | 2153871 | 2022-01-26 | Newberry | South Carolina | 45071 | 11945 | 154 |
2150619 | 2150619 | 2022-01-25 | Newberry | South Carolina | 45071 | 11424 | 154 |
2147367 | 2147367 | 2022-01-24 | Newberry | South Carolina | 45071 | 11424 | 154 |
2144113 | 2144113 | 2022-01-23 | Newberry | South Carolina | 45071 | 11424 | 154 |
2140858 | 2140858 | 2022-01-22 | Newberry | South Carolina | 45071 | 11424 | 154 |
2137602 | 2137602 | 2022-01-21 | Newberry | South Carolina | 45071 | 11424 | 154 |
2134348 | 2134348 | 2022-01-20 | Newberry | South Carolina | 45071 | 11250 | 154 |
2131096 | 2131096 | 2022-01-19 | Newberry | South Carolina | 45071 | 11048 | 154 |
2127842 | 2127842 | 2022-01-18 | Newberry | South Carolina | 45071 | 10962 | 154 |
2124590 | 2124590 | 2022-01-17 | Newberry | South Carolina | 45071 | 10099 | 154 |
2121338 | 2121338 | 2022-01-16 | Newberry | South Carolina | 45071 | 10099 | 154 |
2118086 | 2118086 | 2022-01-15 | Newberry | South Carolina | 45071 | 10099 | 154 |
2114835 | 2114835 | 2022-01-14 | Newberry | South Carolina | 45071 | 10099 | 154 |
2111583 | 2111583 | 2022-01-13 | Newberry | South Carolina | 45071 | 9851 | 154 |
2108331 | 2108331 | 2022-01-12 | Newberry | South Carolina | 45071 | 9291 | 154 |
2105080 | 2105080 | 2022-01-11 | Newberry | South Carolina | 45071 | 9216 | 154 |
2101829 | 2101829 | 2022-01-10 | Newberry | South Carolina | 45071 | 9152 | 154 |
2098578 | 2098578 | 2022-01-09 | Newberry | South Carolina | 45071 | 8828 | 154 |
2095326 | 2095326 | 2022-01-08 | Newberry | South Carolina | 45071 | 8828 | 154 |
2092074 | 2092074 | 2022-01-07 | Newberry | South Carolina | 45071 | 8828 | 154 |
2088822 | 2088822 | 2022-01-06 | Newberry | South Carolina | 45071 | 8748 | 154 |
2085571 | 2085571 | 2022-01-05 | Newberry | South Carolina | 45071 | 8553 | 154 |
2082319 | 2082319 | 2022-01-04 | Newberry | South Carolina | 45071 | 8454 | 154 |
2059563 | 2059563 | 2021-12-28 | Newberry | South Carolina | 45071 | 7926 | 154 |
2056314 | 2056314 | 2021-12-27 | Newberry | South Carolina | 45071 | 7926 | 154 |
2053065 | 2053065 | 2021-12-26 | Newberry | South Carolina | 45071 | 7926 | 154 |
2049815 | 2049815 | 2021-12-25 | Newberry | South Carolina | 45071 | 7926 | 154 |
2046565 | 2046565 | 2021-12-24 | Newberry | South Carolina | 45071 | 7926 | 154 |
2043315 | 2043315 | 2021-12-23 | Newberry | South Carolina | 45071 | 7926 | 154 |
2040043 | 2040043 | 2021-12-22 | Chesterfield | South Carolina | 45025 | 7876 | 154 |
1689098 | 1689098 | 2021-09-05 | Georgetown | South Carolina | 45043 | 8273 | 154 |
1685848 | 1685848 | 2021-09-04 | Georgetown | South Carolina | 45043 | 8273 | 154 |
1682597 | 1682597 | 2021-09-03 | Georgetown | South Carolina | 45043 | 8273 | 154 |
1331912 | 1331912 | 2021-05-18 | Cherokee | South Carolina | 45021 | 6086 | 154 |
1328665 | 1328665 | 2021-05-17 | Cherokee | South Carolina | 45021 | 6082 | 154 |
1325419 | 1325419 | 2021-05-16 | Cherokee | South Carolina | 45021 | 6082 | 154 |
1322173 | 1322173 | 2021-05-15 | Cherokee | South Carolina | 45021 | 6081 | 154 |
1318927 | 1318927 | 2021-05-14 | Cherokee | South Carolina | 45021 | 6055 | 154 |
1315679 | 1315679 | 2021-05-13 | Cherokee | South Carolina | 45021 | 6050 | 154 |
1312433 | 1312433 | 2021-05-12 | Cherokee | South Carolina | 45021 | 6049 | 154 |
1309186 | 1309186 | 2021-05-11 | Cherokee | South Carolina | 45021 | 6044 | 154 |
1305940 | 1305940 | 2021-05-10 | Cherokee | South Carolina | 45021 | 6042 | 154 |
1302694 | 1302694 | 2021-05-09 | Cherokee | South Carolina | 45021 | 6036 | 154 |
1299447 | 1299447 | 2021-05-08 | Cherokee | South Carolina | 45021 | 6029 | 154 |
1150087 | 1150087 | 2021-03-23 | Lancaster | South Carolina | 45057 | 9968 | 154 |
1059195 | 1059195 | 2021-02-23 | Laurens | South Carolina | 45059 | 6187 | 154 |
1039713 | 1039713 | 2021-02-17 | Greenwood | South Carolina | 45047 | 6804 | 154 |
1010489 | 1010489 | 2021-02-08 | Berkeley | South Carolina | 45015 | 13441 | 154 |
994258 | 994258 | 2021-02-03 | Beaufort | South Carolina | 45013 | 13719 | 154 |
991012 | 991012 | 2021-02-02 | Beaufort | South Carolina | 45013 | 13644 | 154 |
991023 | 991023 | 2021-02-02 | Dorchester | South Carolina | 45035 | 12838 | 154 |
945570 | 945570 | 2021-01-19 | Aiken | South Carolina | 45003 | 11380 | 154 |
893681 | 893681 | 2021-01-03 | Orangeburg | South Carolina | 45075 | 5326 | 154 |
553048 | 553048 | 2020-09-20 | Lexington | South Carolina | 45063 | 6737 | 154 |
549809 | 549809 | 2020-09-19 | Lexington | South Carolina | 45063 | 6714 | 154 |
423774 | 423774 | 2020-08-11 | Richland | South Carolina | 45079 | 8917 | 154 |
381903 | 381903 | 2020-07-29 | Charleston | South Carolina | 45019 | 11125 | 154 |
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);