ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 127 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Colleton 18
- Orangeburg 7
- Williamsburg 5
- Dillon 4
- Spartanburg 4
- Chester 3
- Chesterfield 3
- Richland 3
- Greenwood 2
- Anderson 1
- Berkeley 1
- Dorchester 1
- Kershaw 1
- Lexington 1
- Newberry 1
- Oconee 1
- Sumter 1
- Union 1
- York 1
state 1
- South Carolina · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2173377 | 2173377 | 2022-02-01 | Dillon | South Carolina | 45033 | 9294 | 127 |
2173404 | 2173404 | 2022-02-01 | Union | South Carolina | 45087 | 7162 | 127 |
2170125 | 2170125 | 2022-01-31 | Dillon | South Carolina | 45033 | 9268 | 127 |
2157105 | 2157105 | 2022-01-27 | Dillon | South Carolina | 45033 | 8991 | 127 |
2153852 | 2153852 | 2022-01-26 | Dillon | South Carolina | 45033 | 8944 | 127 |
2134324 | 2134324 | 2022-01-20 | Chester | South Carolina | 45023 | 8543 | 127 |
2131072 | 2131072 | 2022-01-19 | Chester | South Carolina | 45023 | 8483 | 127 |
2127818 | 2127818 | 2022-01-18 | Chester | South Carolina | 45023 | 8411 | 127 |
1893808 | 1893808 | 2021-11-07 | Williamsburg | South Carolina | 45089 | 5669 | 127 |
1890558 | 1890558 | 2021-11-06 | Williamsburg | South Carolina | 45089 | 5669 | 127 |
1887308 | 1887308 | 2021-11-05 | Williamsburg | South Carolina | 45089 | 5669 | 127 |
1884058 | 1884058 | 2021-11-04 | Williamsburg | South Carolina | 45089 | 5665 | 127 |
1880809 | 1880809 | 2021-11-03 | Williamsburg | South Carolina | 45089 | 5664 | 127 |
1757310 | 1757310 | 2021-09-26 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1754062 | 1754062 | 2021-09-25 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1750814 | 1750814 | 2021-09-24 | Chesterfield | South Carolina | 45025 | 6608 | 127 |
1737840 | 1737840 | 2021-09-20 | Newberry | South Carolina | 45071 | 6963 | 127 |
1344906 | 1344906 | 2021-05-22 | Colleton | South Carolina | 45029 | 3654 | 127 |
1341658 | 1341658 | 2021-05-21 | Colleton | South Carolina | 45029 | 3653 | 127 |
1338410 | 1338410 | 2021-05-20 | Colleton | South Carolina | 45029 | 3651 | 127 |
1335163 | 1335163 | 2021-05-19 | Colleton | South Carolina | 45029 | 3649 | 127 |
1331916 | 1331916 | 2021-05-18 | Colleton | South Carolina | 45029 | 3646 | 127 |
1328669 | 1328669 | 2021-05-17 | Colleton | South Carolina | 45029 | 3646 | 127 |
1325423 | 1325423 | 2021-05-16 | Colleton | South Carolina | 45029 | 3646 | 127 |
1322177 | 1322177 | 2021-05-15 | Colleton | South Carolina | 45029 | 3644 | 127 |
1318931 | 1318931 | 2021-05-14 | Colleton | South Carolina | 45029 | 3629 | 127 |
1315683 | 1315683 | 2021-05-13 | Colleton | South Carolina | 45029 | 3622 | 127 |
1312437 | 1312437 | 2021-05-12 | Colleton | South Carolina | 45029 | 3619 | 127 |
1309190 | 1309190 | 2021-05-11 | Colleton | South Carolina | 45029 | 3619 | 127 |
1305944 | 1305944 | 2021-05-10 | Colleton | South Carolina | 45029 | 3612 | 127 |
1302698 | 1302698 | 2021-05-09 | Colleton | South Carolina | 45029 | 3612 | 127 |
1299451 | 1299451 | 2021-05-08 | Colleton | South Carolina | 45029 | 3609 | 127 |
1296204 | 1296204 | 2021-05-07 | Colleton | South Carolina | 45029 | 3607 | 127 |
1292958 | 1292958 | 2021-05-06 | Colleton | South Carolina | 45029 | 3604 | 127 |
1289712 | 1289712 | 2021-05-05 | Colleton | South Carolina | 45029 | 3603 | 127 |
1107889 | 1107889 | 2021-03-10 | Oconee | South Carolina | 45073 | 8605 | 127 |
1098142 | 1098142 | 2021-03-07 | Kershaw | South Carolina | 45055 | 6785 | 127 |
981289 | 981289 | 2021-01-30 | Greenwood | South Carolina | 45047 | 6158 | 127 |
978043 | 978043 | 2021-01-29 | Greenwood | South Carolina | 45047 | 6045 | 127 |
955312 | 955312 | 2021-01-22 | Berkeley | South Carolina | 45015 | 11706 | 127 |
935874 | 935874 | 2021-01-16 | Sumter | South Carolina | 45085 | 6814 | 127 |
880678 | 880678 | 2020-12-30 | Dorchester | South Carolina | 45035 | 8181 | 127 |
750892 | 750892 | 2020-11-20 | York | South Carolina | 45091 | 8738 | 127 |
614630 | 614630 | 2020-10-09 | Orangeburg | South Carolina | 45075 | 3188 | 127 |
611389 | 611389 | 2020-10-08 | Orangeburg | South Carolina | 45075 | 3180 | 127 |
608147 | 608147 | 2020-10-07 | Orangeburg | South Carolina | 45075 | 3172 | 127 |
601662 | 601662 | 2020-10-05 | Orangeburg | South Carolina | 45075 | 3155 | 127 |
598419 | 598419 | 2020-10-04 | Orangeburg | South Carolina | 45075 | 3151 | 127 |
595176 | 595176 | 2020-10-03 | Orangeburg | South Carolina | 45075 | 3150 | 127 |
591935 | 591935 | 2020-10-02 | Orangeburg | South Carolina | 45075 | 3139 | 127 |
501249 | 501249 | 2020-09-04 | Anderson | South Carolina | 45007 | 3320 | 127 |
468952 | 468952 | 2020-08-25 | Spartanburg | South Carolina | 45083 | 4778 | 127 |
465724 | 465724 | 2020-08-24 | Spartanburg | South Carolina | 45083 | 4715 | 127 |
462495 | 462495 | 2020-08-23 | Spartanburg | South Carolina | 45083 | 4702 | 127 |
459267 | 459267 | 2020-08-22 | Spartanburg | South Carolina | 45083 | 4685 | 127 |
452801 | 452801 | 2020-08-20 | Lexington | South Carolina | 45063 | 5347 | 127 |
378716 | 378716 | 2020-07-28 | Richland | South Carolina | 45079 | 7235 | 127 |
375500 | 375500 | 2020-07-27 | Richland | South Carolina | 45079 | 7092 | 127 |
372287 | 372287 | 2020-07-26 | Richland | South Carolina | 45079 | 7007 | 127 |
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);