legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
926 rows where state = "SC"
This data as json, copyable, CSV (advanced)
Suggested facets: district, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 12 ✖
- Democrat 534
- Republican 268
- Jackson 41
- Nullifier 32
- Federalist 21
- Whig 4
- Democratic Republican 2
- Jacksonian 2
- Anti Jacksonian 1
- Ind. Republican 1
- Jackson Republican 1
- Pro-Administration 1
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
16 | 16 | Ralph Izard I000053 | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
42 | 42 | Daniel Huger H000916 | rep | SC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
43 | 43 | Daniel Huger H000916 | rep | SC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
62 | 62 | Thomas Tucker T000403 | rep | SC | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
63 | 63 | Thomas Tucker T000403 | rep | SC | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
94 | 94 | Alexander Gillon G000211 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
117 | 117 | Andrew Pickens P000320 | rep | SC | 1793-12-02 | 1795-03-03 | 6 | ||||||||||||||
161 | 161 | Samuel Earle E000010 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 6 | |||||||||||||
205 | 205 | Jacob Read R000092 | sen | SC | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
233 | 233 | John Hunter H000982 | rep | SC | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
234 | 234 | John Hunter H000982 | sen | SC | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
240 | 240 | Lemuel Benton B000396 | rep | SC | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
241 | 241 | Lemuel Benton B000396 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 3 | |||||||||||||
242 | 242 | Lemuel Benton B000396 | rep | SC | 1797-05-15 | 1799-03-03 | Republican | 3 | |||||||||||||
301 | 301 | William Smith S000625 | rep | SC | 1797-05-15 | 1799-03-03 | Republican | 6 | |||||||||||||
302 | 302 | William Smith S000633 | rep | SC | 1789-03-04 | 1791-03-03 | Federalist | 1 | |||||||||||||
303 | 303 | William Smith S000633 | rep | SC | 1791-10-24 | 1793-03-03 | Federalist | 1 | |||||||||||||
304 | 304 | William Smith S000633 | rep | SC | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
305 | 305 | William Smith S000633 | rep | SC | 1795-12-07 | 1797-03-03 | Federalist | 1 | |||||||||||||
306 | 306 | William Smith S000633 | rep | SC | 1797-05-15 | 1799-03-03 | Federalist | 1 | |||||||||||||
408 | 408 | Abraham Nott N000161 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
416 | 416 | Thomas Pinckney P000357 | rep | SC | 1797-05-15 | 1799-03-03 | Federalist | 1 | |||||||||||||
417 | 417 | Thomas Pinckney P000357 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | Republican | |||||||||||||
519 | 519 | John Rutledge R000553 | rep | SC | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
520 | 520 | John Rutledge R000553 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
521 | 521 | John Rutledge R000553 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
548 | 548 | Pierce Butler B001186 | sen | SC | 1789-03-04 | 1793-03-03 | 2 | Democratic Republican | |||||||||||||
549 | 549 | Pierce Butler B001186 | sen | SC | 1793-12-02 | 1797-03-03 | 2 | Republican | |||||||||||||
550 | 550 | Pierce Butler B001186 | sen | SC | 1802-01-01 | 1805-03-03 | 3 | Republican | |||||||||||||
574 | 574 | John Earle E000008 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
582 | 582 | Wade Hampton H000140 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
583 | 583 | Wade Hampton H000140 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
595 | 595 | Thomas Lowndes L000482 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 1 | |||||||||||||
596 | 596 | Thomas Lowndes L000482 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 1 | |||||||||||||
673 | 673 | Levi Casey C000226 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
674 | 674 | Levi Casey C000226 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
752 | 752 | O’Brien Smith S000598 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
758 | 758 | Thomas Sumter S001073 | rep | SC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
759 | 759 | Thomas Sumter S001073 | rep | SC | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
760 | 760 | Thomas Sumter S001073 | rep | SC | 1797-05-15 | 1799-03-03 | Republican | 4 | |||||||||||||
761 | 761 | Thomas Sumter S001073 | rep | SC | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
762 | 762 | Thomas Sumter S001073 | rep | SC | 1801-12-07 | 1801-12-15 | Republican | 4 | |||||||||||||
763 | 763 | Thomas Sumter S001073 | sen | SC | 1801-12-15 | 1805-03-03 | 2 | Republican | |||||||||||||
764 | 764 | Thomas Sumter S001073 | sen | SC | 1805-12-02 | 1810-12-16 | 2 | Republican | |||||||||||||
938 | 938 | Lemuel Alston A000165 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
939 | 939 | Lemuel Alston A000165 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
950 | 950 | Joseph Calhoun C000045 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 6 | |||||||||||||
951 | 951 | Joseph Calhoun C000045 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1031 | 1031 | Robert Marion M000130 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1032 | 1032 | Robert Marion M000130 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
1033 | 1033 | Robert Marion M000130 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1088 | 1088 | Robert Witherspoon W000661 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1090 | 1090 | John Taylor T000085 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
1091 | 1091 | John Taylor T000085 | rep | SC | 1809-05-22 | 1810-12-30 | Republican | 4 | |||||||||||||
1092 | 1092 | John Taylor T000085 | sen | SC | 1810-12-31 | 1811-03-03 | 2 | Republican | |||||||||||||
1093 | 1093 | John Taylor T000085 | sen | SC | 1811-03-04 | 1816-11-15 | 2 | Republican | |||||||||||||
1122 | 1122 | William Butler B001194 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
1123 | 1123 | William Butler B001194 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1124 | 1124 | William Butler B001194 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1125 | 1125 | William Butler B001194 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1126 | 1126 | William Butler B001194 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1127 | 1127 | William Butler B001194 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1257 | 1257 | David Williams W000495 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1258 | 1258 | David Williams W000495 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1259 | 1259 | David Williams W000495 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1261 | 1261 | Richard Winn W000637 | rep | SC | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
1262 | 1262 | Richard Winn W000637 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 4 | |||||||||||||
1263 | 1263 | Richard Winn W000637 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1264 | 1264 | Richard Winn W000637 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
1265 | 1265 | Richard Winn W000637 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
1266 | 1266 | Richard Winn W000637 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 5 | |||||||||||||
1267 | 1267 | Richard Winn W000637 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1268 | 1268 | Richard Winn W000637 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1307 | 1307 | Langdon Cheves C000350 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1308 | 1308 | Langdon Cheves C000350 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1309 | 1309 | Langdon Cheves C000350 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1335 | 1335 | David Evans E000238 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1336 | 1336 | Samuel Farrow F000036 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1345 | 1345 | Theodore Gourdin G000345 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1369 | 1369 | John Kershaw K000149 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1495 | 1495 | John Chappell C000320 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1496 | 1496 | John Chappell C000320 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1607 | 1607 | Benjamin Huger H000915 | rep | SC | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
1608 | 1608 | Benjamin Huger H000915 | rep | SC | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
1609 | 1609 | Benjamin Huger H000915 | rep | SC | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
1610 | 1610 | Benjamin Huger H000915 | rep | SC | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
1659 | 1659 | William Mayrant M000288 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1674 | 1674 | Thomas Moore M000919 | rep | SC | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
1675 | 1675 | Thomas Moore M000919 | rep | SC | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
1676 | 1676 | Thomas Moore M000919 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
1677 | 1677 | Thomas Moore M000919 | rep | SC | 1807-10-26 | 1809-03-03 | Republican | 7 | |||||||||||||
1678 | 1678 | Thomas Moore M000919 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 7 | |||||||||||||
1679 | 1679 | Thomas Moore M000919 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
1680 | 1680 | Thomas Moore M000919 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1748 | 1748 | John Taylor T000084 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1774 | 1774 | William Woodward W000733 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1783 | 1783 | Robert Harper H000225 | rep | SC | 1793-12-02 | 1795-03-03 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);