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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44528 | 44528 | Robert Good G000595 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 5 | https://good.house.gov | 1213 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1213 Longworth House Office Building | |||||||||
44407 | 44407 | Jennifer Wexton W000825 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://wexton.house.gov | 1217 Longworth House Office Building Washington DC 20515-4610 | 202-225-5136 | 1217 Longworth House Office Building | |||||||||
44406 | 44406 | Jennifer Wexton W000825 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://wexton.house.gov | 1217 Longworth House Office Building Washington DC 20515-4610 | 202-225-5136 | 1217 Longworth House Office Building | |||||||||
44405 | 44405 | Abigail Spanberger S001209 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://spanberger.house.gov | 1431 Longworth House Office Building Washington DC 20515-4607 | 202-225-2815 | 1431 Longworth House Office Building | |||||||||
44404 | 44404 | Abigail Spanberger S001209 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://spanberger.house.gov | 1239 Longworth House Office Building Washington DC 20515-4607 | 202-225-2815 | 1239 Longworth House Office Building | |||||||||
44403 | 44403 | Ben Cline C001118 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 6 | https://cline.house.gov | 2443 Rayburn House Office Building Washington DC 20515-4606 | 202-225-5431 | 2443 Rayburn House Office Building | |||||||||
44402 | 44402 | Ben Cline C001118 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 6 | https://cline.house.gov | 1009 Longworth House Office Building Washington DC 20515-4606 | 202-225-5431 | 1009 Longworth House Office Building | |||||||||
44401 | 44401 | Elaine Luria L000591 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://luria.house.gov | 412 Cannon House Office Building Washington DC 20515-4602 | 202-225-4215 | 412 Cannon House Office Building | |||||||||
44400 | 44400 | Elaine Luria L000591 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://luria.house.gov | 534 Cannon House Office Building Washington DC 20515-4602 | 202-225-4215 | 534 Cannon House Office Building | |||||||||
44051 | 44051 | Donald Beyer B001292 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building Washington DC 20515-4608 | 202-225-4376 | 1119 Longworth House Office Building | |||||||||
44050 | 44050 | Donald Beyer B001292 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building Washington DC 20515-4608 | 202-225-4376 | 1119 Longworth House Office Building | |||||||||
44049 | 44049 | Donald Beyer B001292 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | 1119 Longworth House Office Building | ||||||||
44048 | 44048 | Donald Beyer B001292 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://beyer.house.gov | 431 Cannon HOB; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | 431 Cannon House Office Building | ||||||||
43897 | 43897 | Timothy Kaine K000384 | sen | VA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | ||||||
43896 | 43896 | Timothy Kaine K000384 | sen | VA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | 202-228-6363 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | |||||
43623 | 43623 | Robert Wittman W000804 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building Washington DC 20515-4601 | 202-225-4261 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||||
43622 | 43622 | Robert Wittman W000804 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building Washington DC 20515-4601 | 202-225-4261 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||||
43621 | 43621 | Robert Wittman W000804 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | |||||||
43620 | 43620 | Robert Wittman W000804 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 1 | https://wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43619 | 43619 | Robert Wittman W000804 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 1 | http://www.wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43618 | 43618 | Robert Wittman W000804 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.wittman.house.gov/ | 1317 Longworth HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm | 1317 Longworth House Office Building | |||||||
43617 | 43617 | Robert Wittman W000804 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.wittman.house.gov/ | ||||||||||||
43616 | 43616 | Robert Wittman W000804 | rep | VA | 2007-12-13 | 2009-01-03 | Republican | 1 | http://www.wittman.house.gov/ | ||||||||||||
43335 | 43335 | Robert Scott S000185 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 2328 Rayburn House Office Building Washington DC 20515-4603 | 202-225-8351 | 2328 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
43334 | 43334 | Robert Scott S000185 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building Washington DC 20515-4603 | 202-225-8351 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
43333 | 43333 | Robert Scott S000185 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | |||||||
43332 | 43332 | Robert Scott S000185 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://bobbyscott.house.gov | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | https://bobbyscott.house.gov/contact/email-me | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
43331 | 43331 | Robert Scott S000185 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://www.bobbyscott.house.gov | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | https://bobbyscott.house.gov/email-bobby-scott | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
43330 | 43330 | Robert Scott S000185 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/scott | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | http://www.house.gov/writerep | 1201 Longworth House Office Building | |||||||
43329 | 43329 | Robert Scott S000185 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43328 | 43328 | Robert Scott S000185 | rep | VA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43327 | 43327 | Robert Scott S000185 | rep | VA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43326 | 43326 | Robert Scott S000185 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43325 | 43325 | Robert Scott S000185 | rep | VA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
43324 | 43324 | Robert Scott S000185 | rep | VA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
43323 | 43323 | Robert Scott S000185 | rep | VA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
43322 | 43322 | Robert Scott S000185 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
43321 | 43321 | Robert Scott S000185 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
42469 | 42469 | H. Griffith G000568 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building Washington DC 20515-4609 | 202-225-3861 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx | ||||||||
42468 | 42468 | H. Griffith G000568 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building Washington DC 20515-4609 | 202-225-3861 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx | ||||||||
42467 | 42467 | H. Griffith G000568 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx | |||||||
42466 | 42466 | H. Griffith G000568 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://morgangriffith.house.gov | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | https://morgangriffith.house.gov/contact/contactform.htm | 1108 Longworth House Office Building | http://morgangriffith.house.gov/news/rss.aspx | ||||||
42465 | 42465 | H. Griffith G000568 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://morgangriffith.house.gov | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | https://morgangriffith.house.gov/contact/contactform.htm | 1108 Longworth House Office Building | http://morgangriffith.house.gov/news/rss.aspx | ||||||
42464 | 42464 | H. Griffith G000568 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://morgangriffith.house.gov/ | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 1108 Longworth House Office Building | ||||||||
42197 | 42197 | Gerald Connolly C001078 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
42196 | 42196 | Gerald Connolly C001078 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
42195 | 42195 | Gerald Connolly C001078 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | |||||||
42194 | 42194 | Gerald Connolly C001078 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://connolly.house.gov | 2238 Rayburn HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
42193 | 42193 | Gerald Connolly C001078 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://connolly.house.gov | 424 Cannon HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 424 Cannon House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
42192 | 42192 | Gerald Connolly C001078 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://connolly.house.gov | 424 Cannon HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 424 Cannon House Office Building | |||||||
42191 | 42191 | Gerald Connolly C001078 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://connolly.house.gov | ||||||||||||
41892 | 41892 | Mark Warner W000805 | sen | VA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | https://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | ||||||
41891 | 41891 | Mark Warner W000805 | sen | VA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41890 | 41890 | Mark Warner W000805 | sen | VA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.warner.senate.gov | 475 Russell Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public//index.cfm?p=ContactPage#form_f9db6196-2dc7-4cda-8add-f8435a71318a | 475 Russell Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41729 | 41729 | A. McEachin M001200 | rep | VA | 2021-01-03 | 2022-11-28 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41728 | 41728 | A. McEachin M001200 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41727 | 41727 | A. McEachin M001200 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building; Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41609 | 41609 | Denver Riggleman R000611 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://riggleman.house.gov | 1022 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1022 Longworth House Office Building | |||||||||
41166 | 41166 | Thomas Garrett G000580 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://tomgarrett.house.gov | 415 Cannon House Office Building; Washington DC 20515-4605 | 202-225-4711 | 415 Cannon House Office Building | |||||||||
41165 | 41165 | Scott Taylor T000477 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 2 | https://taylor.house.gov | 412 Cannon House Office Building; Washington DC 20515-4602 | 202-225-4215 | 412 Cannon House Office Building | |||||||||
41151 | 41151 | Barbara Comstock C001105 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://comstock.house.gov | 229 Cannon House Office Building; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | 229 Cannon House Office Building | ||||||||
41150 | 41150 | Barbara Comstock C001105 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 10 | https://comstock.house.gov | 226 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | 226 Cannon House Office Building | ||||||||
41125 | 41125 | David Brat B001290 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://brat.house.gov | 1628 Longworth House Office Building; Washington DC 20515-4607 | 202-225-2815 | 1628 Longworth House Office Building | |||||||||
41124 | 41124 | David Brat B001290 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://brat.house.gov | 330 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | http://brat.house.gov/contact | 330 Cannon House Office Building | ||||||||
41123 | 41123 | David Brat B001290 | rep | VA | 2014-11-12 | 2015-01-03 | Republican | 7 | http://brat.house.gov/ | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | http://brat.house.gov/contact | 303 Cannon House Office Building | |||||||
40829 | 40829 | Bob Goodlatte G000289 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://goodlatte.house.gov | 2309 Rayburn House Office Building; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | |||||||
40828 | 40828 | Bob Goodlatte G000289 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 6 | http://goodlatte.house.gov | 2309 Rayburn HOB; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | http://goodlatte.house.gov/contacts/new | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | ||||||
40827 | 40827 | Bob Goodlatte G000289 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 6 | http://goodlatte.house.gov | 2309 Rayburn HOB; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | http://goodlatte.house.gov/contacts/new | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | ||||||
40826 | 40826 | Bob Goodlatte G000289 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/goodlatte | 2240 Rayburn HOB; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | http://www.house.gov/goodlatte/emailbob.htm | 2240 Rayburn House Office Building | |||||||
40825 | 40825 | Bob Goodlatte G000289 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/goodlatte | ||||||||||||
40824 | 40824 | Bob Goodlatte G000289 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/goodlatte | ||||||||||||
40823 | 40823 | Bob Goodlatte G000289 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/goodlatte | ||||||||||||
40822 | 40822 | Bob Goodlatte G000289 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/goodlatte | ||||||||||||
40821 | 40821 | Bob Goodlatte G000289 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
40820 | 40820 | Bob Goodlatte G000289 | rep | VA | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
40819 | 40819 | Bob Goodlatte G000289 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
40818 | 40818 | Bob Goodlatte G000289 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40817 | 40817 | Bob Goodlatte G000289 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
40466 | 40466 | Edward Rigell R000589 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 2 | http://rigell.house.gov | 418 Cannon HOB; Washington DC 20515-4602 | 202-225-4215 | 202-225-4218 | https://rigell.house.gov/contact/contactform.htm | 418 Cannon House Office Building | http://rigell.house.gov/news/rss.aspx | ||||||
40465 | 40465 | Edward Rigell R000589 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 2 | http://rigell.house.gov | 418 Cannon HOB; Washington DC 20515-4602 | 202-225-4215 | 202-225-4218 | https://rigell.house.gov/contact/contactform.htm | 418 Cannon House Office Building | http://rigell.house.gov/news/rss.aspx | ||||||
40464 | 40464 | Edward Rigell R000589 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 2 | http://rigell.house.gov/ | 327 Cannon HOB; Washington DC 20515-4602 | 202-225-4215 | 202-225-4218 | 327 Cannon House Office Building | ||||||||
40366 | 40366 | Robert Hurt H001060 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 5 | https://hurt.house.gov | 125 Cannon HOB; Washington DC 20515-4605 | 202-225-4711 | 202-225-5681 | https://hurt.house.gov/index.cfm/email-me | 125 Cannon House Office Building | http://hurt.house.gov/index.cfm/rss/feed | ||||||
40365 | 40365 | Robert Hurt H001060 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 5 | http://hurt.house.gov | 125 Cannon HOB; Washington DC 20515-4605 | 202-225-4711 | 202-225-5681 | https://hurt.house.gov/index.cfm/email-me | 125 Cannon House Office Building | http://hurt.house.gov/index.cfm/rss/feed | ||||||
40364 | 40364 | Robert Hurt H001060 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://hurt.house.gov/ | 1516 Longworth HOB; Washington DC 20515-4605 | 202-225-4711 | 202-225-5681 | 1516 Longworth House Office Building | ||||||||
40326 | 40326 | J. Forbes F000445 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://forbes.house.gov | 2135 Rayburn HOB; Washington DC 20515-4604 | 202-225-6365 | 202-226-1170 | https://forbes.house.gov/contact/contactform.htm | 2135 Rayburn House Office Building | http://forbes.house.gov/news/rss.aspx | ||||||
40325 | 40325 | J. Forbes F000445 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://forbes.house.gov | 2135 Rayburn HOB; Washington DC 20515-4604 | 202-225-6365 | 202-226-1170 | https://forbes.house.gov/contact/contactform.htm | 2135 Rayburn House Office Building | http://forbes.house.gov/news/rss.aspx | ||||||
40324 | 40324 | J. Forbes F000445 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 4 | http://www.house.gov/forbes | 2438 Rayburn HOB; Washington DC 20515-4604 | 202-225-6365 | 202-226-1170 | http://forbes.house.gov/zipauth.html | 2438 Rayburn House Office Building | |||||||
40323 | 40323 | J. Forbes F000445 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40322 | 40322 | J. Forbes F000445 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40321 | 40321 | J. Forbes F000445 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40320 | 40320 | J. Forbes F000445 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40319 | 40319 | J. Forbes F000445 | rep | VA | 2001-06-26 | 2003-01-03 | Republican | 4 | |||||||||||||
40115 | 40115 | Frank Wolf W000672 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://wolf.house.gov | 233 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | https://wolf.house.gov/contact/email-me#.U06IH-ZdUrw | 233 Cannon House Office Building | http://wolf.house.gov/common/rss//index.cfm?rss=34 | ||||||
40114 | 40114 | Frank Wolf W000672 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/wolf | 241 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | http://www.house.gov/formwolf/contact_email/emailzip.shtml | 241 Cannon House Office Building | |||||||
40113 | 40113 | Frank Wolf W000672 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/wolf | ||||||||||||
40112 | 40112 | Frank Wolf W000672 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/wolf | ||||||||||||
40111 | 40111 | Frank Wolf W000672 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 10 | http://www.house.gov/wolf | ||||||||||||
40110 | 40110 | Frank Wolf W000672 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/wolf | ||||||||||||
40109 | 40109 | Frank Wolf W000672 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 10 | |||||||||||||
40108 | 40108 | Frank Wolf W000672 | rep | VA | 1999-01-06 | 2001-01-03 | Republican | 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);