legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
268 rows where party = "Republican" and state = "SC"
This data as json, copyable, CSV (advanced)
Suggested facets: district, phone, fax, contact_form, office, rss_url, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
161 | 161 | Samuel Earle E000010 | rep | SC | 1795-12-07 | 1797-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1799 | 1799 | Joseph Bellinger B000350 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
1878 | 1878 | Henry Middleton M000699 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1879 | 1879 | Henry Middleton M000699 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
1884 | 1884 | Wilson Nesbitt N000049 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
1975 | 1975 | Joseph Brevard B000808 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2013 | 2013 | Elias Earle E000007 | rep | SC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
2014 | 2014 | Elias Earle E000007 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
2015 | 2015 | Elias Earle E000007 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
2016 | 2016 | Elias Earle E000007 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2017 | 2017 | Elias Earle E000007 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 7 | |||||||||||||
2019 | 2019 | James Ervin E000209 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2020 | 2020 | James Ervin E000209 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 3 | |||||||||||||
2072 | 2072 | John McCreary M000383 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 8 | |||||||||||||
2100 | 2100 | Charles Pinckney P000354 | sen | SC | 1798-12-06 | 1799-03-03 | 2 | Republican | |||||||||||||
2101 | 2101 | Charles Pinckney P000354 | sen | SC | 1799-12-02 | 1801-03-03 | 2 | Republican | |||||||||||||
2102 | 2102 | Charles Pinckney P000354 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2130 | 2130 | Eldred Simkins S000414 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2131 | 2131 | Eldred Simkins S000414 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2259 | 2259 | William Lowndes L000483 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
2260 | 2260 | William Lowndes L000483 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
2261 | 2261 | William Lowndes L000483 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2262 | 2262 | William Lowndes L000483 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
2263 | 2263 | William Lowndes L000483 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 2 | |||||||||||||
2264 | 2264 | William Lowndes L000483 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2296 | 2296 | James Overstreet O000142 | rep | SC | 1819-12-06 | 1821-03-03 | Republican | 4 | |||||||||||||
2297 | 2297 | James Overstreet O000142 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2604 | 2604 | John Gaillard G000005 | sen | SC | 1804-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
2605 | 2605 | John Gaillard G000005 | sen | SC | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
2606 | 2606 | John Gaillard G000005 | sen | SC | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
2607 | 2607 | John Gaillard G000005 | sen | SC | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2616 | 2616 | Joseph Gist G000227 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2619 | 2619 | Andrew Govan G000346 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 |
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);