ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 217 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Dorchester 13
- Colleton 12
- Kershaw 9
- Aiken 7
- Georgetown 7
- Orangeburg 4
- Beaufort 3
- Berkeley 3
- Charleston 3
- Lancaster 3
- Lexington 2
- Florence 1
- Greenwood 1
- Horry 1
- Richland 1
state 1
- South Carolina · 70 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329478 | 2329478 | 2022-03-21 | Colleton | South Carolina | 45029 | 8813 | 217 |
2326226 | 2326226 | 2022-03-20 | Colleton | South Carolina | 45029 | 8813 | 217 |
2322973 | 2322973 | 2022-03-19 | Colleton | South Carolina | 45029 | 8813 | 217 |
2319719 | 2319719 | 2022-03-18 | Colleton | South Carolina | 45029 | 8813 | 217 |
2316465 | 2316465 | 2022-03-17 | Colleton | South Carolina | 45029 | 8813 | 217 |
2313212 | 2313212 | 2022-03-16 | Colleton | South Carolina | 45029 | 8813 | 217 |
2309959 | 2309959 | 2022-03-15 | Colleton | South Carolina | 45029 | 8813 | 217 |
2306706 | 2306706 | 2022-03-14 | Colleton | South Carolina | 45029 | 8818 | 217 |
2303455 | 2303455 | 2022-03-13 | Colleton | South Carolina | 45029 | 8818 | 217 |
2300203 | 2300203 | 2022-03-12 | Colleton | South Carolina | 45029 | 8818 | 217 |
2296951 | 2296951 | 2022-03-11 | Colleton | South Carolina | 45029 | 8818 | 217 |
2293699 | 2293699 | 2022-03-10 | Colleton | South Carolina | 45029 | 8816 | 217 |
2280698 | 2280698 | 2022-03-06 | Georgetown | South Carolina | 45043 | 15757 | 217 |
2277445 | 2277445 | 2022-03-05 | Georgetown | South Carolina | 45043 | 15757 | 217 |
2274192 | 2274192 | 2022-03-04 | Georgetown | South Carolina | 45043 | 15757 | 217 |
2270939 | 2270939 | 2022-03-03 | Georgetown | South Carolina | 45043 | 15748 | 217 |
2267687 | 2267687 | 2022-03-02 | Georgetown | South Carolina | 45043 | 15745 | 217 |
2264434 | 2264434 | 2022-03-01 | Georgetown | South Carolina | 45043 | 15742 | 217 |
2261184 | 2261184 | 2022-02-28 | Georgetown | South Carolina | 45043 | 15739 | 217 |
2040058 | 2040058 | 2021-12-22 | Kershaw | South Carolina | 45055 | 12779 | 217 |
2036808 | 2036808 | 2021-12-21 | Kershaw | South Carolina | 45055 | 12753 | 217 |
2033558 | 2033558 | 2021-12-20 | Kershaw | South Carolina | 45055 | 12746 | 217 |
2030308 | 2030308 | 2021-12-19 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2027057 | 2027057 | 2021-12-18 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2023806 | 2023806 | 2021-12-17 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2020555 | 2020555 | 2021-12-16 | Kershaw | South Carolina | 45055 | 12662 | 217 |
2017304 | 2017304 | 2021-12-15 | Kershaw | South Carolina | 45055 | 12649 | 217 |
2014054 | 2014054 | 2021-12-14 | Kershaw | South Carolina | 45055 | 12638 | 217 |
1838548 | 1838548 | 2021-10-21 | Greenwood | South Carolina | 45047 | 12257 | 217 |
1802813 | 1802813 | 2021-10-10 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1799564 | 1799564 | 2021-10-09 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1796315 | 1796315 | 2021-10-08 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1643606 | 1643606 | 2021-08-22 | Berkeley | South Carolina | 45015 | 22063 | 217 |
1640356 | 1640356 | 2021-08-21 | Berkeley | South Carolina | 45015 | 22063 | 217 |
1637106 | 1637106 | 2021-08-20 | Berkeley | South Carolina | 45015 | 22063 | 217 |
1620867 | 1620867 | 2021-08-15 | Beaufort | South Carolina | 45013 | 19931 | 217 |
1617619 | 1617619 | 2021-08-14 | Beaufort | South Carolina | 45013 | 19931 | 217 |
1614371 | 1614371 | 2021-08-13 | Beaufort | South Carolina | 45013 | 19931 | 217 |
1312440 | 1312440 | 2021-05-12 | Dorchester | South Carolina | 45035 | 17830 | 217 |
1309193 | 1309193 | 2021-05-11 | Dorchester | South Carolina | 45035 | 17811 | 217 |
1305947 | 1305947 | 2021-05-10 | Dorchester | South Carolina | 45035 | 17798 | 217 |
1302701 | 1302701 | 2021-05-09 | Dorchester | South Carolina | 45035 | 17786 | 217 |
1299454 | 1299454 | 2021-05-08 | Dorchester | South Carolina | 45035 | 17770 | 217 |
1296207 | 1296207 | 2021-05-07 | Dorchester | South Carolina | 45035 | 17746 | 217 |
1292961 | 1292961 | 2021-05-06 | Dorchester | South Carolina | 45035 | 17717 | 217 |
1286469 | 1286469 | 2021-05-04 | Dorchester | South Carolina | 45035 | 17675 | 217 |
1283223 | 1283223 | 2021-05-03 | Dorchester | South Carolina | 45035 | 17668 | 217 |
1279976 | 1279976 | 2021-05-02 | Dorchester | South Carolina | 45035 | 17653 | 217 |
1276729 | 1276729 | 2021-05-01 | Dorchester | South Carolina | 45035 | 17629 | 217 |
1273482 | 1273482 | 2021-04-30 | Dorchester | South Carolina | 45035 | 17602 | 217 |
1270235 | 1270235 | 2021-04-29 | Dorchester | South Carolina | 45035 | 17498 | 217 |
1221511 | 1221511 | 2021-04-14 | Aiken | South Carolina | 45003 | 16772 | 217 |
1218263 | 1218263 | 2021-04-13 | Aiken | South Carolina | 45003 | 16744 | 217 |
1215015 | 1215015 | 2021-04-12 | Aiken | South Carolina | 45003 | 16723 | 217 |
1211768 | 1211768 | 2021-04-11 | Aiken | South Carolina | 45003 | 16707 | 217 |
1208519 | 1208519 | 2021-04-10 | Aiken | South Carolina | 45003 | 16684 | 217 |
1205271 | 1205271 | 2021-04-09 | Aiken | South Carolina | 45003 | 16661 | 217 |
1202023 | 1202023 | 2021-04-08 | Aiken | South Carolina | 45003 | 16635 | 217 |
1088412 | 1088412 | 2021-03-04 | Orangeburg | South Carolina | 45075 | 8843 | 217 |
1085167 | 1085167 | 2021-03-03 | Orangeburg | South Carolina | 45075 | 8813 | 217 |
1081921 | 1081921 | 2021-03-02 | Orangeburg | South Carolina | 45075 | 8803 | 217 |
1078675 | 1078675 | 2021-03-01 | Orangeburg | South Carolina | 45075 | 8793 | 217 |
786566 | 786566 | 2020-12-01 | Florence | South Carolina | 45041 | 6783 | 217 |
734649 | 734649 | 2020-11-15 | Lexington | South Carolina | 45063 | 10375 | 217 |
731403 | 731403 | 2020-11-14 | Lexington | South Carolina | 45063 | 10309 | 217 |
650307 | 650307 | 2020-10-20 | Horry | South Carolina | 45051 | 11983 | 217 |
530397 | 530397 | 2020-09-13 | Richland | South Carolina | 45079 | 13638 | 217 |
452779 | 452779 | 2020-08-20 | Charleston | South Carolina | 45019 | 13111 | 217 |
449551 | 449551 | 2020-08-19 | Charleston | South Carolina | 45019 | 13062 | 217 |
446323 | 446323 | 2020-08-18 | Charleston | South Carolina | 45019 | 12956 | 217 |
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);