legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where state = "VI"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, url, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32056 | 32056 | Melvin Evans E000254 | rep | VI | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
35669 | 35669 | Ron de Lugo D000209 | rep | VI | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
35670 | 35670 | Ron de Lugo D000209 | rep | VI | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
35671 | 35671 | Ron de Lugo D000209 | rep | VI | 1977-01-04 | 1979-01-03 | Democrat | 0 | |||||||||||||
35672 | 35672 | Ron de Lugo D000209 | rep | VI | 1981-01-05 | 1983-01-03 | Democrat | 0 | |||||||||||||
35673 | 35673 | Ron de Lugo D000209 | rep | VI | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
35674 | 35674 | Ron de Lugo D000209 | rep | VI | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
35675 | 35675 | Ron de Lugo D000209 | rep | VI | 1987-01-06 | 1989-01-03 | Democrat | 0 | |||||||||||||
35676 | 35676 | Ron de Lugo D000209 | rep | VI | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
35677 | 35677 | Ron de Lugo D000209 | rep | VI | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
35678 | 35678 | Ron de Lugo D000209 | rep | VI | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
35814 | 35814 | Victor Frazer F000351 | rep | VI | 1995-01-04 | 1997-01-03 | Independent | 0 | |||||||||||||
39785 | 39785 | Donna Christensen C000380 | rep | VI | 1997-01-07 | 1999-01-03 | Democrat | 0 | |||||||||||||
39786 | 39786 | Donna Christensen C000380 | rep | VI | 1999-01-06 | 2001-01-03 | Democrat | 0 | |||||||||||||
39787 | 39787 | Donna Christensen C000380 | rep | VI | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
39788 | 39788 | Donna Christensen C000380 | rep | VI | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
39789 | 39789 | Donna Christensen C000380 | rep | VI | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
39790 | 39790 | Donna Christensen C000380 | rep | VI | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
39791 | 39791 | Donna Christensen C000380 | rep | VI | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
39792 | 39792 | Donna Christensen C000380 | rep | VI | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.donnachristensen.house.gov/ | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | |||||||||
39793 | 39793 | Donna Christensen C000380 | rep | VI | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://donnachristensen.house.gov | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | https://donnachristensen.house.gov/contact-me/email-me | 1510 Longworth House Office Building | http://donnachristensen.house.gov/rss.xml | ||||||
44052 | 44052 | Stacey Plaskett P000610 | rep | VI | 2015-01-06 | 2017-01-03 | Democrat | 0 | https://plaskett.house.gov | 509 Cannon HOB; Washington DC 20515-5500 | 202-225-1790 | 202-225-5517 | 509 Cannon House Office Building | ||||||||
44053 | 44053 | Stacey Plaskett P000610 | rep | VI | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://plaskett.house.gov | 331 Cannon House Office Building; Washington DC 20515-5500 | 202-225-1790 | 202-225-5517 | 331 Cannon House Office Building | ||||||||
44054 | 44054 | Stacey Plaskett P000610 | rep | VI | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://plaskett.house.gov | 2404 Rayburn House Office Building Washington DC 20515-5500 | 202-225-1790 | 2404 Rayburn House Office Building | |||||||||
44055 | 44055 | Stacey Plaskett P000610 | rep | VI | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://plaskett.house.gov | 2404 Rayburn House Office Building Washington DC 20515-5500 | 202-225-1790 | 2404 Rayburn House Office Building |
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);