legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where party = "Democrat" and state = "VT"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, type, start, district, phone, fax, office, rss_url, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4471 | 4471 | Isaac Fletcher F000201 | rep | VT | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4472 | 4472 | Isaac Fletcher F000201 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4611 | 4611 | John Smith S000565 | rep | VT | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5409 | 5409 | Paul Dillingham D000346 | rep | VT | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5410 | 5410 | Paul Dillingham D000346 | rep | VT | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
6089 | 6089 | Lucius Peck P000178 | rep | VT | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6090 | 6090 | Lucius Peck P000178 | rep | VT | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6216 | 6216 | Thomas Bartlett B000209 | rep | VT | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
26914 | 26914 | William Meyer M000682 | rep | VT | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
42717 | 42717 | Patrick Leahy L000174 | sen | VT | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
42718 | 42718 | Patrick Leahy L000174 | sen | VT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
42719 | 42719 | Patrick Leahy L000174 | sen | VT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
42720 | 42720 | Patrick Leahy L000174 | sen | VT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
42721 | 42721 | Patrick Leahy L000174 | sen | VT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://leahy.senate.gov/ | ||||||||||||
42722 | 42722 | Patrick Leahy L000174 | sen | VT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://leahy.senate.gov/ | ||||||||||||
42723 | 42723 | Patrick Leahy L000174 | sen | VT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
42724 | 42724 | Patrick Leahy L000174 | sen | VT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
43591 | 43591 | Peter Welch W000800 | rep | VT | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://welch.house.gov | ||||||||||||
43592 | 43592 | Peter Welch W000800 | rep | VT | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://welch.house.gov | ||||||||||||
43593 | 43593 | Peter Welch W000800 | rep | VT | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://welch.house.gov | 1404 Longworth HOB; Washington DC 20515-4501 | 202-225-4115 | 202-225-6790 | http://www.house.gov/formwelch/issue_subscribe.htm | 1404 Longworth House Office Building | |||||||
43594 | 43594 | Peter Welch W000800 | rep | VT | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://www.welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43595 | 43595 | Peter Welch W000800 | rep | VT | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43596 | 43596 | Peter Welch W000800 | rep | VT | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://welch.house.gov | 2303 Rayburn House Office Building; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | |||||||
43597 | 43597 | Peter Welch W000800 | rep | VT | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://welch.house.gov | 2187 Rayburn House Office Building Washington DC 20515-4500 | 202-225-4115 | 2187 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||||
43598 | 43598 | Peter Welch W000800 | rep | VT | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://welch.house.gov | 2187 Rayburn House Office Building Washington DC 20515-4500 | 202-225-4115 | 2187 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss |
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);