legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,660 rows where state = "VA"
This data as json, copyable, CSV (advanced)
party 21 ✖
- Democrat 770
- Republican 510
- Jackson 105
- Whig 53
- Federalist 34
- Adams 13
- Unionist 11
- Conservative 8
- Anti Jacksonian 7
- Jacksonian 7
- Readjuster 6
- Anti-Jacksonian 4
- Ind. Democrat 4
- Independent 4
- Anti-Administration 2
- Readjuster Democrat 2
- American 1
- Ind. Republican-Democrat 1
- Independent Democrat 1
- Unconditional Unionist 1
- Union 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
904 | 904 | Abram Trigg T000368 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 4 | |||||||||||||
905 | 905 | Abram Trigg T000368 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
906 | 906 | Abram Trigg T000368 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
907 | 907 | Abram Trigg T000368 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
908 | 908 | Abram Trigg T000368 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
909 | 909 | Abram Trigg T000368 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 6 | |||||||||||||
926 | 926 | Alexander Wilson W000568 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
927 | 927 | Alexander Wilson W000568 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
928 | 928 | Alexander Wilson W000568 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 5 | |||||||||||||
933 | 933 | James Madison M000043 | rep | VA | 1789-03-04 | 1791-03-03 | Republican | 5 | |||||||||||||
934 | 934 | James Madison M000043 | rep | VA | 1791-10-24 | 1793-03-03 | Republican | 5 | |||||||||||||
935 | 935 | James Madison M000043 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 15 | |||||||||||||
936 | 936 | James Madison M000043 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 15 | |||||||||||||
945 | 945 | Richard Brent B000802 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 17 | |||||||||||||
946 | 946 | Richard Brent B000802 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 17 | |||||||||||||
947 | 947 | Richard Brent B000802 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 17 | |||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
973 | 973 | David Garland G000066 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 21 | |||||||||||||
1001 | 1001 | Walter Jones J000254 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 19 | |||||||||||||
1002 | 1002 | Walter Jones J000254 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1003 | 1003 | Walter Jones J000254 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1004 | 1004 | Walter Jones J000254 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
1005 | 1005 | Walter Jones J000254 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1020 | 1020 | John Love L000456 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
1021 | 1021 | John Love L000456 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1035 | 1035 | William McKinley M000520 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1044 | 1044 | Wilson Nicholas N000086 | sen | VA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
1045 | 1045 | Wilson Nicholas N000086 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 21 | |||||||||||||
1046 | 1046 | Wilson Nicholas N000086 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 21 | |||||||||||||
1072 | 1072 | Jacob Swoope S001125 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1099 | 1099 | John Baker B000067 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
1154 | 1154 | William Giles G000183 | rep | VA | 1790-12-07 | 1791-03-03 | Republican | 9 | |||||||||||||
1155 | 1155 | William Giles G000183 | rep | VA | 1791-10-24 | 1793-03-03 | Republican | 9 | |||||||||||||
1156 | 1156 | William Giles G000183 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
1157 | 1157 | William Giles G000183 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 9 | |||||||||||||
1158 | 1158 | William Giles G000183 | rep | VA | 1797-05-15 | 1798-10-02 | Republican | 9 | |||||||||||||
1159 | 1159 | William Giles G000183 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
1160 | 1160 | William Giles G000183 | sen | VA | 1804-11-05 | 1804-12-04 | 1 | Republican | |||||||||||||
1161 | 1161 | William Giles G000183 | sen | VA | 1804-12-04 | 1805-03-03 | 2 | Republican | |||||||||||||
1162 | 1162 | William Giles G000183 | sen | VA | 1805-03-04 | 1811-03-03 | 2 | Republican | |||||||||||||
1163 | 1163 | William Giles G000183 | sen | VA | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1170 | 1170 | Edwin Gray G000394 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 10 | |||||||||||||
1171 | 1171 | Edwin Gray G000394 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 10 | |||||||||||||
1172 | 1172 | Edwin Gray G000394 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 19 | |||||||||||||
1173 | 1173 | Edwin Gray G000394 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 19 | |||||||||||||
1174 | 1174 | Edwin Gray G000394 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 19 | |||||||||||||
1175 | 1175 | Edwin Gray G000394 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 19 | |||||||||||||
1176 | 1176 | Edwin Gray G000394 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 19 | |||||||||||||
1260 | 1260 | Thomas Wilson W000615 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1274 | 1274 | Thomas Bayly B000260 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1306 | 1306 | Hugh Caperton C000131 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1318 | 1318 | John Dawson D000151 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 15 | |||||||||||||
1319 | 1319 | John Dawson D000151 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 15 | |||||||||||||
1320 | 1320 | John Dawson D000151 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 15 | |||||||||||||
1321 | 1321 | John Dawson D000151 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
1322 | 1322 | John Dawson D000151 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
1323 | 1323 | John Dawson D000151 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 10 | |||||||||||||
1324 | 1324 | John Dawson D000151 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 10 | |||||||||||||
1325 | 1325 | John Dawson D000151 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 10 | |||||||||||||
1326 | 1326 | John Dawson D000151 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1406 | 1406 | John Smith S000564 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
1407 | 1407 | John Smith S000564 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
1408 | 1408 | John Smith S000564 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1409 | 1409 | John Smith S000564 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1410 | 1410 | John Smith S000564 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1411 | 1411 | John Smith S000564 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1412 | 1412 | John Smith S000564 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1425 | 1425 | Francis White W000367 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1471 | 1471 | James Breckinridge B000785 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
1472 | 1472 | James Breckinridge B000785 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 5 | |||||||||||||
1473 | 1473 | James Breckinridge B000785 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1474 | 1474 | James Breckinridge B000785 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1502 | 1502 | Matthew Clay C000487 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 6 | |||||||||||||
1503 | 1503 | Matthew Clay C000487 | rep | VA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
1504 | 1504 | Matthew Clay C000487 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
1505 | 1505 | Matthew Clay C000487 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
1506 | 1506 | Matthew Clay C000487 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1507 | 1507 | Matthew Clay C000487 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 14 | |||||||||||||
1508 | 1508 | Matthew Clay C000487 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 14 | |||||||||||||
1509 | 1509 | Matthew Clay C000487 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1513 | 1513 | John Clopton C000531 | rep | VA | 1795-12-07 | 1797-03-03 | Republican | 13 | |||||||||||||
1514 | 1514 | John Clopton C000531 | rep | VA | 1797-05-15 | 1799-03-03 | Republican | 13 | |||||||||||||
1515 | 1515 | John Clopton C000531 | rep | VA | 1801-12-07 | 1803-03-03 | Republican | 13 | |||||||||||||
1516 | 1516 | John Clopton C000531 | rep | VA | 1803-10-17 | 1805-03-03 | Republican | 22 | |||||||||||||
1517 | 1517 | John Clopton C000531 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 22 | |||||||||||||
1518 | 1518 | John Clopton C000531 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 22 | |||||||||||||
1519 | 1519 | John Clopton C000531 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 22 | |||||||||||||
1520 | 1520 | John Clopton C000531 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 22 | |||||||||||||
1521 | 1521 | John Clopton C000531 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 23 | |||||||||||||
1522 | 1522 | John Clopton C000531 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 | |||||||||||||
1570 | 1570 | Thomas Gholson G000150 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 17 | |||||||||||||
1571 | 1571 | Thomas Gholson G000150 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 17 | |||||||||||||
1572 | 1572 | Thomas Gholson G000150 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 17 | |||||||||||||
1573 | 1573 | Thomas Gholson G000150 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 18 | |||||||||||||
1574 | 1574 | Thomas Gholson G000150 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1601 | 1601 | Aylett Hawes H000361 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1602 | 1602 | Aylett Hawes H000361 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
1603 | 1603 | Aylett Hawes H000361 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1613 | 1613 | John Hungerford H000967 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 8 |
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);