legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,660 rows where state = "VA" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, fax, state_rank, rss_url, start (date), end (date)
party 23 ✖
- Democrat 770
- Republican 569
- Jackson 105
- Whig 53
- Federalist 52
- Adams 13
- Unionist 11
- Conservative 8
- Anti Jacksonian 7
- Jacksonian 7
- Readjuster 6
- Anti-Administration 5
- Democratic Republican 5
- Anti-Jacksonian 4
- Ind. Democrat 4
- Independent 4
- Readjuster Democrat 2
- American 1
- Ind. Republican-Democrat 1
- Independent Democrat 1
- Pro-Administration 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | 9 | ||||||||||||||
65 | 65 | Alexander White W000352 | rep | VA | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
66 | 66 | Alexander White W000352 | rep | VA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
97 | 97 | Samuel Griffin G000466 | rep | VA | 1789-03-04 | 1791-03-03 | 10 | ||||||||||||||
98 | 98 | Samuel Griffin G000466 | rep | VA | 1791-10-24 | 1793-03-03 | 10 | ||||||||||||||
99 | 99 | Samuel Griffin G000466 | rep | VA | 1793-12-02 | 1795-03-03 | 13 | ||||||||||||||
104 | 104 | Richard Lee L000200 | rep | VA | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
105 | 105 | Richard Lee L000200 | rep | VA | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
106 | 106 | Richard Lee L000200 | rep | VA | 1793-12-02 | 1795-03-03 | 17 | ||||||||||||||
114 | 114 | Joseph Neville N000055 | rep | VA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
132 | 132 | Francis Walker W000051 | rep | VA | 1793-12-02 | 1795-03-03 | 14 | ||||||||||||||
169 | 169 | George Hancock H000148 | rep | VA | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
326 | 326 | John Brown B000929 | rep | VA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
327 | 327 | John Brown B000929 | rep | VA | 1791-03-04 | 1792-06-01 | -1 | ||||||||||||||
2368 | 2368 | John Taylor T000086 | sen | VA | 1792-10-18 | 1793-03-02 | 2 | ||||||||||||||
2369 | 2369 | John Taylor T000086 | sen | VA | 1793-03-04 | 1794-05-11 | 2 | ||||||||||||||
2437 | 2437 | Jabez Leftwich L000216 | rep | VA | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2489 | 2489 | Arthur Smith S000515 | rep | VA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2510 | 2510 | George Tucker T000397 | rep | VA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2536 | 2536 | Jared Williams W000510 | rep | VA | 1823-12-01 | 1825-03-03 | 17 | ||||||||||||||
2722 | 2722 | William Smith S000626 | rep | VA | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
3306 | 3306 | William Armstrong A000284 | rep | VA | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3307 | 3307 | William Armstrong A000284 | rep | VA | 1831-12-05 | 1833-03-03 | 16 | ||||||||||||||
3366 | 3366 | Philip Doddridge D000391 | rep | VA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3367 | 3367 | Philip Doddridge D000391 | rep | VA | 1831-12-05 | 1833-03-03 | 18 | ||||||||||||||
3783 | 3783 | John Randolph R000047 | rep | VA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
3784 | 3784 | John Randolph R000047 | rep | VA | 1825-12-05 | 1825-12-26 | -1 | ||||||||||||||
3787 | 3787 | John Randolph R000047 | rep | VA | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
4657 | 4657 | John Tyler T000450 | sen | VA | 1833-12-02 | 1837-03-03 | 1 | ||||||||||||||
2596 | 2596 | Benjamin Estil E000223 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 22 | |||||||||||||
2704 | 2704 | Alfred Powell P000478 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 17 | |||||||||||||
2724 | 2724 | Robert Taylor T000097 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
2869 | 2869 | Isaac Leffler L000214 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 18 | |||||||||||||
3304 | 3304 | William Armstrong A000284 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 16 | |||||||||||||
3305 | 3305 | William Armstrong A000284 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 16 | |||||||||||||
3465 | 3465 | Lewis Maxwell M000269 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 21 | |||||||||||||
3516 | 3516 | Thomas Newton N000078 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 1 | |||||||||||||
3517 | 3517 | Thomas Newton N000078 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 1 | |||||||||||||
4550 | 4550 | Charles Mercer M000642 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 14 | |||||||||||||
4551 | 4551 | Charles Mercer M000642 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 14 | |||||||||||||
5023 | 5023 | John Taliaferro T000027 | rep | VA | 1825-12-05 | 1827-03-03 | Adams | 13 | |||||||||||||
5024 | 5024 | John Taliaferro T000027 | rep | VA | 1827-12-03 | 1829-03-03 | Adams | 13 | |||||||||||||
7687 | 7687 | John Carlile C000150 | rep | VA | 1855-12-03 | 1857-03-03 | American | 11 | |||||||||||||
3466 | 3466 | Lewis Maxwell M000269 | rep | VA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 21 | |||||||||||||
3467 | 3467 | Lewis Maxwell M000269 | rep | VA | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 21 | |||||||||||||
3594 | 3594 | John Allen A000132 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 20 | |||||||||||||
3679 | 3679 | James Gholson G000148 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 4 | |||||||||||||
3758 | 3758 | Samuel Moore M000917 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 17 | |||||||||||||
3825 | 3825 | Edgar Wilson W000574 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 21 | |||||||||||||
3873 | 3873 | Nathaniel Claiborne C000405 | rep | VA | 1835-12-07 | 1837-03-03 | Anti Jacksonian | 7 | |||||||||||||
12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
19 | 19 | Richard Lee L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
266 | 266 | Carter Harrison H000266 | rep | VA | 1793-12-02 | 1795-03-03 | Anti-Administration | 10 | |||||||||||||
1791 | 1791 | James Monroe M000858 | sen | VA | 1790-11-09 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
1792 | 1792 | James Monroe M000858 | sen | VA | 1791-03-04 | 1794-05-27 | 1 | Anti-Administration | |||||||||||||
3657 | 3657 | Thomas Davenport D000079 | rep | VA | 1833-12-02 | 1835-03-03 | Anti-Jacksonian | 6 | |||||||||||||
3807 | 3807 | William Taylor T000105 | rep | VA | 1833-12-02 | 1835-03-03 | Anti-Jacksonian | 9 | |||||||||||||
3829 | 3829 | Benjamin Leigh L000232 | sen | VA | 1834-02-26 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3830 | 3830 | Benjamin Leigh L000232 | sen | VA | 1835-12-07 | 1836-07-04 | 2 | Anti-Jacksonian | |||||||||||||
4478 | 4478 | James Garland G000067 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 12 | |||||||||||||
7092 | 7092 | George Hopkins H000774 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 18 | |||||||||||||
8526 | 8526 | George Booker B000627 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 4 | |||||||||||||
8601 | 8601 | James Gibson G000162 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 8 | |||||||||||||
8669 | 8669 | Lewis McKenzie M000507 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 7 | |||||||||||||
8670 | 8670 | William Milnes M000784 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 6 | |||||||||||||
8702 | 8702 | Robert Ridgway R000248 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
8883 | 8883 | Richard Duke D000521 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
4116 | 4116 | Richard Parker P000069 | sen | VA | 1836-01-01 | 1837-12-31 | 2 | Democrat | |||||||||||||
4142 | 4142 | James Bouldin B000662 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4293 | 4293 | William Morgan M000960 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 21 | |||||||||||||
4316 | 4316 | John Patton P000140 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4335 | 4335 | William Roane R000293 | sen | VA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4363 | 4363 | Archibald Stuart S001032 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4400 | 4400 | Andrew Beirne B000319 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4401 | 4401 | Andrew Beirne B000319 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4441 | 4441 | Robert Craig C000859 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4477 | 4477 | James Garland G000067 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 12 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4599 | 4599 | Francis Rives R000284 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4600 | 4600 | Francis Rives R000284 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4607 | 4607 | Green Samuels S000028 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4682 | 4682 | Linn Banks B000115 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4683 | 4683 | Linn Banks B000115 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4684 | 4684 | Linn Banks B000115 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
4729 | 4729 | George Cary C000213 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
4823 | 4823 | William Harris H000257 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
4829 | 4829 | Samuel Hays H000407 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4974 | 4974 | William Rives R000285 | sen | VA | 1836-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
5170 | 5170 | Walter Coles C000625 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
5171 | 5171 | Walter Coles C000625 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5172 | 5172 | Walter Coles C000625 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5173 | 5173 | Walter Coles C000625 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5205 | 5205 | Thomas Gilmer G000218 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5234 | 5234 | John Jones J000240 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
5235 | 5235 | John Jones J000240 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
5236 | 5236 | John Jones J000240 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5237 | 5237 | John Jones J000240 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5245 | 5245 | William Lucas L000494 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
5246 | 5246 | William Lucas L000494 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 10 |
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);