ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
263 rows where deaths = 28 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- McCormick 140
- Dillon 25
- Oconee 11
- Saluda 11
- Abbeville 7
- Cherokee 7
- Bamberg 6
- Chester 5
- Fairfield 5
- York 5
- Edgefield 4
- Jasper 4
- Marlboro 4
- Barnwell 3
- Calhoun 3
- Colleton 3
- Marion 3
- Berkeley 2
- Hampton 2
- Horry 2
- Union 2
- Anderson 1
- Chesterfield 1
- Darlington 1
- Florence 1
- Greenwood 1
- Lancaster 1
- Laurens 1
- Lexington 1
- Newberry 1
state 1
- South Carolina · 263 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 1721591 | 1721591 | 2021-09-15 | McCormick | South Carolina | 45065 | 1236 | 28 |
| 1718343 | 1718343 | 2021-09-14 | McCormick | South Carolina | 45065 | 1236 | 28 |
| 1715095 | 1715095 | 2021-09-13 | McCormick | South Carolina | 45065 | 1233 | 28 |
| 1711849 | 1711849 | 2021-09-12 | McCormick | South Carolina | 45065 | 1218 | 28 |
| 1708602 | 1708602 | 2021-09-11 | McCormick | South Carolina | 45065 | 1218 | 28 |
| 1705355 | 1705355 | 2021-09-10 | McCormick | South Carolina | 45065 | 1218 | 28 |
| 1702105 | 1702105 | 2021-09-09 | McCormick | South Carolina | 45065 | 1215 | 28 |
| 1698856 | 1698856 | 2021-09-08 | McCormick | South Carolina | 45065 | 1211 | 28 |
| 1695608 | 1695608 | 2021-09-07 | McCormick | South Carolina | 45065 | 1211 | 28 |
| 1692360 | 1692360 | 2021-09-06 | McCormick | South Carolina | 45065 | 1208 | 28 |
| 1689111 | 1689111 | 2021-09-05 | McCormick | South Carolina | 45065 | 1191 | 28 |
| 1685861 | 1685861 | 2021-09-04 | McCormick | South Carolina | 45065 | 1191 | 28 |
| 1682610 | 1682610 | 2021-09-03 | McCormick | South Carolina | 45065 | 1191 | 28 |
| 1679360 | 1679360 | 2021-09-02 | McCormick | South Carolina | 45065 | 1184 | 28 |
| 1676112 | 1676112 | 2021-09-01 | McCormick | South Carolina | 45065 | 1172 | 28 |
| 1672865 | 1672865 | 2021-08-31 | McCormick | South Carolina | 45065 | 1160 | 28 |
| 1669617 | 1669617 | 2021-08-30 | McCormick | South Carolina | 45065 | 1152 | 28 |
| 1666370 | 1666370 | 2021-08-29 | McCormick | South Carolina | 45065 | 1137 | 28 |
| 1663122 | 1663122 | 2021-08-28 | McCormick | South Carolina | 45065 | 1137 | 28 |
| 1659874 | 1659874 | 2021-08-27 | McCormick | South Carolina | 45065 | 1137 | 28 |
| 1656625 | 1656625 | 2021-08-26 | McCormick | South Carolina | 45065 | 1133 | 28 |
| 1653378 | 1653378 | 2021-08-25 | McCormick | South Carolina | 45065 | 1123 | 28 |
| 1650131 | 1650131 | 2021-08-24 | McCormick | South Carolina | 45065 | 1122 | 28 |
| 1646882 | 1646882 | 2021-08-23 | McCormick | South Carolina | 45065 | 1118 | 28 |
| 1643633 | 1643633 | 2021-08-22 | McCormick | South Carolina | 45065 | 1108 | 28 |
| 1640383 | 1640383 | 2021-08-21 | McCormick | South Carolina | 45065 | 1108 | 28 |
| 1637133 | 1637133 | 2021-08-20 | McCormick | South Carolina | 45065 | 1108 | 28 |
| 1633883 | 1633883 | 2021-08-19 | McCormick | South Carolina | 45065 | 1107 | 28 |
| 1630636 | 1630636 | 2021-08-18 | McCormick | South Carolina | 45065 | 1105 | 28 |
| 1627389 | 1627389 | 2021-08-17 | McCormick | South Carolina | 45065 | 1104 | 28 |
| 1624142 | 1624142 | 2021-08-16 | McCormick | South Carolina | 45065 | 1104 | 28 |
| 1620895 | 1620895 | 2021-08-15 | McCormick | South Carolina | 45065 | 1100 | 28 |
| 1617647 | 1617647 | 2021-08-14 | McCormick | South Carolina | 45065 | 1100 | 28 |
| 1614399 | 1614399 | 2021-08-13 | McCormick | South Carolina | 45065 | 1100 | 28 |
| 1611150 | 1611150 | 2021-08-12 | McCormick | South Carolina | 45065 | 1095 | 28 |
| 1607902 | 1607902 | 2021-08-11 | McCormick | South Carolina | 45065 | 1087 | 28 |
| 1604653 | 1604653 | 2021-08-10 | McCormick | South Carolina | 45065 | 1085 | 28 |
| 1601404 | 1601404 | 2021-08-09 | McCormick | South Carolina | 45065 | 1084 | 28 |
| 1598156 | 1598156 | 2021-08-08 | McCormick | South Carolina | 45065 | 1075 | 28 |
| 1594907 | 1594907 | 2021-08-07 | McCormick | South Carolina | 45065 | 1075 | 28 |
| 1591658 | 1591658 | 2021-08-06 | McCormick | South Carolina | 45065 | 1075 | 28 |
| 1588409 | 1588409 | 2021-08-05 | McCormick | South Carolina | 45065 | 1071 | 28 |
| 1585159 | 1585159 | 2021-08-04 | McCormick | South Carolina | 45065 | 1068 | 28 |
| 1581909 | 1581909 | 2021-08-03 | McCormick | South Carolina | 45065 | 1069 | 28 |
| 1578660 | 1578660 | 2021-08-02 | McCormick | South Carolina | 45065 | 1067 | 28 |
| 1575412 | 1575412 | 2021-08-01 | McCormick | South Carolina | 45065 | 1061 | 28 |
| 1572164 | 1572164 | 2021-07-31 | McCormick | South Carolina | 45065 | 1061 | 28 |
| 1568916 | 1568916 | 2021-07-30 | McCormick | South Carolina | 45065 | 1061 | 28 |
| 1565668 | 1565668 | 2021-07-29 | McCormick | South Carolina | 45065 | 1057 | 28 |
| 1562420 | 1562420 | 2021-07-28 | McCormick | South Carolina | 45065 | 1052 | 28 |
| 1559172 | 1559172 | 2021-07-27 | McCormick | South Carolina | 45065 | 1051 | 28 |
| 1555925 | 1555925 | 2021-07-26 | McCormick | South Carolina | 45065 | 1051 | 28 |
| 1552678 | 1552678 | 2021-07-25 | McCormick | South Carolina | 45065 | 1043 | 28 |
| 1549431 | 1549431 | 2021-07-24 | McCormick | South Carolina | 45065 | 1043 | 28 |
| 1546184 | 1546184 | 2021-07-23 | McCormick | South Carolina | 45065 | 1043 | 28 |
| 1542937 | 1542937 | 2021-07-22 | McCormick | South Carolina | 45065 | 1040 | 28 |
| 1539689 | 1539689 | 2021-07-21 | McCormick | South Carolina | 45065 | 1038 | 28 |
| 1536442 | 1536442 | 2021-07-20 | McCormick | South Carolina | 45065 | 1038 | 28 |
| 1533194 | 1533194 | 2021-07-19 | McCormick | South Carolina | 45065 | 1038 | 28 |
| 1529947 | 1529947 | 2021-07-18 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1526700 | 1526700 | 2021-07-17 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1523453 | 1523453 | 2021-07-16 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1520205 | 1520205 | 2021-07-15 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1516957 | 1516957 | 2021-07-14 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1513710 | 1513710 | 2021-07-13 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1510464 | 1510464 | 2021-07-12 | McCormick | South Carolina | 45065 | 1037 | 28 |
| 1507217 | 1507217 | 2021-07-11 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1503971 | 1503971 | 2021-07-10 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1500725 | 1500725 | 2021-07-09 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1497479 | 1497479 | 2021-07-08 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1494232 | 1494232 | 2021-07-07 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1490985 | 1490985 | 2021-07-06 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1487738 | 1487738 | 2021-07-05 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1484491 | 1484491 | 2021-07-04 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1481245 | 1481245 | 2021-07-03 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1477998 | 1477998 | 2021-07-02 | McCormick | South Carolina | 45065 | 1036 | 28 |
| 1474752 | 1474752 | 2021-07-01 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1471506 | 1471506 | 2021-06-30 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1468261 | 1468261 | 2021-06-29 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1465016 | 1465016 | 2021-06-28 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1461771 | 1461771 | 2021-06-27 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1458526 | 1458526 | 2021-06-26 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1455281 | 1455281 | 2021-06-25 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1452036 | 1452036 | 2021-06-24 | McCormick | South Carolina | 45065 | 1034 | 28 |
| 1448790 | 1448790 | 2021-06-23 | McCormick | South Carolina | 45065 | 1035 | 28 |
| 1445545 | 1445545 | 2021-06-22 | McCormick | South Carolina | 45065 | 1033 | 28 |
| 1442300 | 1442300 | 2021-06-21 | McCormick | South Carolina | 45065 | 1033 | 28 |
| 1439055 | 1439055 | 2021-06-20 | McCormick | South Carolina | 45065 | 1033 | 28 |
| 1435808 | 1435808 | 2021-06-19 | McCormick | South Carolina | 45065 | 1033 | 28 |
| 1432561 | 1432561 | 2021-06-18 | McCormick | South Carolina | 45065 | 1033 | 28 |
| 1429315 | 1429315 | 2021-06-17 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1426070 | 1426070 | 2021-06-16 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1422823 | 1422823 | 2021-06-15 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1419577 | 1419577 | 2021-06-14 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1416332 | 1416332 | 2021-06-13 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1413086 | 1413086 | 2021-06-12 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1409841 | 1409841 | 2021-06-11 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1406596 | 1406596 | 2021-06-10 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1403350 | 1403350 | 2021-06-09 | McCormick | South Carolina | 45065 | 1032 | 28 |
| 1400105 | 1400105 | 2021-06-08 | McCormick | South Carolina | 45065 | 1032 | 28 |
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);