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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29512 | 29512 | Watkins Abbitt A000002 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29514 | 29514 | Watkins Abbitt A000002 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29515 | 29515 | Watkins Abbitt A000002 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
29516 | 29516 | Watkins Abbitt A000002 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29517 | 29517 | Watkins Abbitt A000002 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29520 | 29520 | Watkins Abbitt A000002 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29521 | 29521 | Watkins Abbitt A000002 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29522 | 29522 | Watkins Abbitt A000002 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29523 | 29523 | Watkins Abbitt A000002 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
3286 | 3286 | Mark Alexander A000099 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 18 | |||||||||||||
3287 | 3287 | Mark Alexander A000099 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 18 | |||||||||||||
3288 | 3288 | Mark Alexander A000099 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 4 | |||||||||||||
3289 | 3289 | Mark Alexander A000099 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
3290 | 3290 | Mark Alexander A000099 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3292 | 3292 | Mark Alexander A000099 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
36779 | 36779 | George Allen A000121 | rep | VA | 1991-11-05 | 1993-01-03 | Republican | 7 | |||||||||||||
36780 | 36780 | George Allen A000121 | sen | VA | 2001-01-03 | 2007-01-03 | 1 | Republican | http://allen.senate.gov | ||||||||||||
3594 | 3594 | John Allen A000132 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 20 | |||||||||||||
3293 | 3293 | Robert Allen A000143 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 17 | |||||||||||||
3294 | 3294 | Robert Allen A000143 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3295 | 3295 | Robert Allen A000143 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 17 | |||||||||||||
24250 | 24250 | James Almond A000163 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24251 | 24251 | James Almond A000163 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
4667 | 4667 | William Archer A000275 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 17 | |||||||||||||
4668 | 4668 | William Archer A000275 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 17 | |||||||||||||
4669 | 4669 | William Archer A000275 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 3 | |||||||||||||
4670 | 4670 | William Archer A000275 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
4671 | 4671 | William Archer A000275 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4673 | 4673 | William Archer A000275 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4674 | 4674 | William Archer A000275 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
4675 | 4675 | William Archer A000275 | sen | VA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
5603 | 5603 | Archibald Atkinson A000328 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5605 | 5605 | Archibald Atkinson A000328 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
1798 | 1798 | Archibald Austin A000340 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 16 | |||||||||||||
6212 | 6212 | Thomas Averett A000343 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6213 | 6213 | Thomas Averett A000343 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
8511 | 8511 | Richard Ayer A000351 | rep | VA | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
1099 | 1099 | John Baker B000067 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
2377 | 2377 | William Ball B000103 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2378 | 2378 | William Ball B000103 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2379 | 2379 | William Ball B000103 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2380 | 2380 | William Ball B000103 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2194 | 2194 | James Barbour B000127 | sen | VA | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
3309 | 3309 | John Barbour B000128 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 15 | |||||||||||||
3310 | 3310 | John Barbour B000128 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 15 | |||||||||||||
3311 | 3311 | John Barbour B000128 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 15 | |||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3313 | 3313 | John Barbour B000128 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 15 | |||||||||||||
11585 | 11585 | John Barbour B000129 | rep | VA | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
11586 | 11586 | John Barbour B000129 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
11587 | 11587 | John Barbour B000129 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11588 | 11588 | John Barbour B000129 | sen | VA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
3039 | 3039 | Philip Barbour B000131 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
3040 | 3040 | Philip Barbour B000131 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
3041 | 3041 | Philip Barbour B000131 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 11 | |||||||||||||
3042 | 3042 | Philip Barbour B000131 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 11 | |||||||||||||
3043 | 3043 | Philip Barbour B000131 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
3044 | 3044 | Philip Barbour B000131 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 11 | |||||||||||||
3045 | 3045 | Philip Barbour B000131 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4686 | 4686 | Richard Barton B000214 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 15 | |||||||||||||
2781 | 2781 | Burwell Bassett B000224 | rep | VA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
2782 | 2782 | Burwell Bassett B000224 | rep | VA | 1807-10-26 | 1809-03-03 | Republican | 12 | |||||||||||||
2783 | 2783 | Burwell Bassett B000224 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 12 | |||||||||||||
2784 | 2784 | Burwell Bassett B000224 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
2785 | 2785 | Burwell Bassett B000224 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
2786 | 2786 | Burwell Bassett B000224 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 13 | |||||||||||||
2787 | 2787 | Burwell Bassett B000224 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2788 | 2788 | Burwell Bassett B000224 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2789 | 2789 | Burwell Bassett B000224 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
2790 | 2790 | Burwell Bassett B000224 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
36492 | 36492 | Herbert Bateman B000229 | rep | VA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
36493 | 36493 | Herbert Bateman B000229 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
36494 | 36494 | Herbert Bateman B000229 | rep | VA | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
36495 | 36495 | Herbert Bateman B000229 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
36496 | 36496 | Herbert Bateman B000229 | rep | VA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36497 | 36497 | Herbert Bateman B000229 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36498 | 36498 | Herbert Bateman B000229 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36499 | 36499 | Herbert Bateman B000229 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36500 | 36500 | Herbert Bateman B000229 | rep | VA | 1999-01-06 | 2000-09-11 | Republican | 1 | |||||||||||||
6762 | 6762 | Thomas Bayly B000259 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6763 | 6763 | Thomas Bayly B000259 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
6764 | 6764 | Thomas Bayly B000259 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6765 | 6765 | Thomas Bayly B000259 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6766 | 6766 | Thomas Bayly B000259 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 7 |
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);