legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,677 rows where state = "MA" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 19 ✖
- Republican 729
- Democrat 515
- Federalist 186
- Whig 133
- Adams 33
- American 11
- Democratic Republican 11
- Anti Jacksonian 7
- Anti Masonic 5
- Free Soil 4
- Jackson 3
- Ind. Democrat 2
- Ind. Republican 2
- Independent 2
- Pro-Administration 2
- Constitutional Unionist 1
- Ind. Republican-Democrat 1
- Liberal Republican 1
- Unionist 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44500 | 44500 | Jake Auchincloss A000148 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://auchincloss.house.gov | 1524 Longworth House Office Building Washington DC 20515-2104 | 202-225-5931 | 1524 Longworth House Office Building | |||||||||
44325 | 44325 | Ayanna Pressley P000617 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://pressley.house.gov | 1108 Longworth House Office Building Washington DC 20515-2107 | 202-225-5111 | 1108 Longworth House Office Building | |||||||||
44324 | 44324 | Ayanna Pressley P000617 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://pressley.house.gov | 1108 Longworth House Office Building Washington DC 20515-2107 | 202-225-5111 | 1108 Longworth House Office Building | |||||||||
44323 | 44323 | Lori Trahan T000482 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://trahan.house.gov | 2439 Rayburn House Office Building Washington DC 20515-2103 | 202-225-3411 | 2439 Rayburn House Office Building | |||||||||
44322 | 44322 | Lori Trahan T000482 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://trahan.house.gov | 1616 Longworth House Office Building Washington DC 20515-2103 | 202-225-3411 | 1616 Longworth House Office Building | |||||||||
43999 | 43999 | Seth Moulton M001196 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://moulton.house.gov | 1127 Longworth House Office Building Washington DC 20515-2106 | 202-225-8020 | 1127 Longworth House Office Building | |||||||||
43998 | 43998 | Seth Moulton M001196 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://moulton.house.gov | 1127 Longworth House Office Building Washington DC 20515-2106 | 202-225-8020 | 1127 Longworth House Office Building | |||||||||
43997 | 43997 | Seth Moulton M001196 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://moulton.house.gov | 1408 Longworth House Office Building; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | 1408 Longworth House Office Building | ||||||||
43996 | 43996 | Seth Moulton M001196 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 6 | https://moulton.house.gov | 1408 Longworth HOB; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | 1408 Longworth House Office Building | ||||||||
43925 | 43925 | Katherine Clark C001101 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://katherineclark.house.gov | 2448 Rayburn House Office Building Washington DC 20515-2105 | 202-225-2836 | 2448 Rayburn House Office Building | |||||||||
43924 | 43924 | Katherine Clark C001101 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://katherineclark.house.gov | 2448 Rayburn House Office Building Washington DC 20515-2105 | 202-225-2836 | 2448 Rayburn House Office Building | |||||||||
43923 | 43923 | Katherine Clark C001101 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://katherineclark.house.gov | 1415 Longworth House Office Building; Washington DC 20515-2105 | 202-225-2836 | 202-226-0092 | 1415 Longworth House Office Building | ||||||||
43922 | 43922 | Katherine Clark C001101 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 5 | https://katherineclark.house.gov | 1721 Longworth HOB; Washington DC 20515-2105 | 202-225-2836 | 202-226-0092 | https://katherineclark.house.gov/index.cfm/email-me | 1721 Longworth House Office Building | |||||||
43921 | 43921 | Katherine Clark C001101 | rep | MA | 2013-12-12 | 2015-01-03 | Democrat | 5 | http://katherineclark.house.gov | 2108 Rayburn HOB; Washington DC 20515-2105 | 202-225-2836 | https://katherineclark.house.gov/index.cfm/email-me | 2108 Rayburn House Office Building | ||||||||
43787 | 43787 | Elizabeth Warren W000817 | sen | MA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.warren.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | https://www.warren.senate.gov/?p=email_senator | 309 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | ||||||
43786 | 43786 | Elizabeth Warren W000817 | sen | MA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.warren.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | 202-228-2072 | https://www.warren.senate.gov/?p=email_senator | 317 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | |||||
43016 | 43016 | Richard Neal N000015 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://neal.house.gov | 372 Cannon House Office Building Washington DC 20515-2101 | 202-225-5601 | 372 Cannon House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||||
43015 | 43015 | Richard Neal N000015 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://neal.house.gov | 2309 Rayburn House Office Building Washington DC 20515-2101 | 202-225-5601 | 2309 Rayburn House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||||
43014 | 43014 | Richard Neal N000015 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://neal.house.gov | 341 Cannon House Office Building; Washington DC 20515-2101 | 202-225-5601 | 202-225-8112 | 341 Cannon House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | |||||||
43013 | 43013 | Richard Neal N000015 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://neal.house.gov | 341 Cannon HOB; Washington DC 20515-2101 | 202-225-5601 | 202-225-8112 | https://forms.house.gov/neal/webforms/Contact_Form.shtml | 341 Cannon House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||
43012 | 43012 | Richard Neal N000015 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://neal.house.gov | 2208 Rayburn HOB; Washington DC 20515-2101 | 202-225-5601 | 202-225-8112 | https://forms.house.gov/neal/webforms/Contact_Form.shtml | 2208 Rayburn House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||
43011 | 43011 | Richard Neal N000015 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/neal | 2208 Rayburn HOB; Washington DC 20515-2102 | 202-225-5601 | 202-225-8112 | http://www.house.gov/neal/write_neal.html | 2208 Rayburn House Office Building | |||||||
43010 | 43010 | Richard Neal N000015 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43009 | 43009 | Richard Neal N000015 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43008 | 43008 | Richard Neal N000015 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43007 | 43007 | Richard Neal N000015 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43006 | 43006 | Richard Neal N000015 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
43005 | 43005 | Richard Neal N000015 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
43004 | 43004 | Richard Neal N000015 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
43003 | 43003 | Richard Neal N000015 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
43002 | 43002 | Richard Neal N000015 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
43001 | 43001 | Richard Neal N000015 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
43000 | 43000 | Richard Neal N000015 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
42894 | 42894 | James McGovern M000312 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://mcgovern.house.gov | 370 Cannon House Office Building Washington DC 20515-2102 | 202-225-6101 | 370 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||||
42893 | 42893 | James McGovern M000312 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://mcgovern.house.gov | 408 Cannon House Office Building Washington DC 20515-2102 | 202-225-6101 | 408 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||||
42892 | 42892 | James McGovern M000312 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://mcgovern.house.gov | 438 Cannon House Office Building; Washington DC 20515-2102 | 202-225-6101 | 202-225-5759 | 438 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | |||||||
42891 | 42891 | James McGovern M000312 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://mcgovern.house.gov | 438 Cannon HOB; Washington DC 20515-2102 | 202-225-6101 | 202-225-5759 | https://mcgovern.house.gov/contact/email-me | 438 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||
42890 | 42890 | James McGovern M000312 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://mcgovern.house.gov | 438 Cannon HOB; Washington DC 20515-2102 | 202-225-6101 | 202-225-5759 | https://mcgovern.house.gov/contact/email-me | 438 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||
42889 | 42889 | James McGovern M000312 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | 438 Cannon HOB; Washington DC 20515-2103 | 202-225-6101 | 202-225-5759 | http://www.house.gov/writerep | 438 Cannon House Office Building | |||||||
42888 | 42888 | James McGovern M000312 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42887 | 42887 | James McGovern M000312 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42886 | 42886 | James McGovern M000312 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42885 | 42885 | James McGovern M000312 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42884 | 42884 | James McGovern M000312 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42883 | 42883 | James McGovern M000312 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42882 | 42882 | James McGovern M000312 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42837 | 42837 | Edward Markey M000133 | sen | MA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
42836 | 42836 | Edward Markey M000133 | sen | MA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
42835 | 42835 | Edward Markey M000133 | sen | MA | 2013-07-16 | 2015-01-03 | 2 | Democrat | http://www.markey.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2742 | http://www.markey.senate.gov/contact | 218 Russell Senate Office Building | junior | |||||||
42834 | 42834 | Edward Markey M000133 | rep | MA | 2013-01-03 | 2013-07-15 | Democrat | 5 | http://www.house.gov/markey | 2108 Rayburn HOB; Washington DC 20515-2107 | 202-225-2836 | 202-226-0092 | http://markey.house.gov/index.php?option=com_email_form&Itemid=124 | 2108 Rayburn House Office Building | http://markey.house.gov/rss.xml | ||||||
42833 | 42833 | Edward Markey M000133 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/markey | 2108 Rayburn HOB; Washington DC 20515-2107 | 202-225-2836 | 202-226-0092 | http://markey.house.gov/index.php?option=com_email_form&Itemid=124 | 2108 Rayburn House Office Building | |||||||
42832 | 42832 | Edward Markey M000133 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42831 | 42831 | Edward Markey M000133 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42830 | 42830 | Edward Markey M000133 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42829 | 42829 | Edward Markey M000133 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42828 | 42828 | Edward Markey M000133 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
42827 | 42827 | Edward Markey M000133 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
42826 | 42826 | Edward Markey M000133 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
42825 | 42825 | Edward Markey M000133 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
42824 | 42824 | Edward Markey M000133 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
42823 | 42823 | Edward Markey M000133 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
42822 | 42822 | Edward Markey M000133 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
42821 | 42821 | Edward Markey M000133 | rep | MA | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
42820 | 42820 | Edward Markey M000133 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
42819 | 42819 | Edward Markey M000133 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
42818 | 42818 | Edward Markey M000133 | rep | MA | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
42817 | 42817 | Edward Markey M000133 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
42816 | 42816 | Edward Markey M000133 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
42815 | 42815 | Edward Markey M000133 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
42799 | 42799 | Stephen Lynch L000562 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://lynch.house.gov | 2109 Rayburn House Office Building Washington DC 20515-2108 | 202-225-8273 | 2109 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||||
42798 | 42798 | Stephen Lynch L000562 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://lynch.house.gov | 2109 Rayburn House Office Building Washington DC 20515-2108 | 202-225-8273 | 2109 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||||
42797 | 42797 | Stephen Lynch L000562 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://lynch.house.gov | 2268 Rayburn House Office Building; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | 2268 Rayburn House Office Building | http://lynch.house.gov/rss.xml | |||||||
42796 | 42796 | Stephen Lynch L000562 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://lynch.house.gov | 2369 Rayburn HOB; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | https://lynch.house.gov/contact-me/email-me | 2369 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||
42795 | 42795 | Stephen Lynch L000562 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://lynch.house.gov | 2133 Rayburn HOB; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | https://lynch.house.gov/contact-me/email-me | 2133 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||
42794 | 42794 | Stephen Lynch L000562 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/lynch | 2348 Rayburn HOB; Washington DC 20515-2109 | 202-225-8273 | 202-225-3984 | http://www.house.gov/writerep | 2348 Rayburn House Office Building | |||||||
42793 | 42793 | Stephen Lynch L000562 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42792 | 42792 | Stephen Lynch L000562 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42791 | 42791 | Stephen Lynch L000562 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42790 | 42790 | Stephen Lynch L000562 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42789 | 42789 | Stephen Lynch L000562 | rep | MA | 2001-10-23 | 2003-01-03 | Democrat | 9 | |||||||||||||
42637 | 42637 | William Keating K000375 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://keating.house.gov | 2351 Rayburn House Office Building Washington DC 20515-2109 | 202-225-3111 | 2351 Rayburn House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||||
42636 | 42636 | William Keating K000375 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://keating.house.gov | 2351 Rayburn House Office Building Washington DC 20515-2109 | 202-225-3111 | 2351 Rayburn House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||||
42635 | 42635 | William Keating K000375 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://keating.house.gov | 2351 Rayburn House Office Building; Washington DC 20515-2109 | 202-225-3111 | 202-225-5658 | 2351 Rayburn House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | |||||||
42634 | 42634 | William Keating K000375 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://keating.house.gov | 315 Cannon HOB; Washington DC 20515-2109 | 202-225-3111 | 202-225-5658 | https://forms.house.gov/keating/webforms/contact.shtml | 315 Cannon House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||
42633 | 42633 | William Keating K000375 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://keating.house.gov | 315 Cannon HOB; Washington DC 20515-2109 | 202-225-3111 | 202-225-5658 | https://forms.house.gov/keating/webforms/contact.shtml | 315 Cannon House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||
42632 | 42632 | William Keating K000375 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://keating.house.gov/ | 315 Cannon HOB; Washington DC 20515-2110 | 202-225-3111 | 202-225-5658 | 315 Cannon House Office Building | ||||||||
41565 | 41565 | Joseph Kennedy K000379 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://kennedy.house.gov | 304 Cannon House Office Building Washington DC 20515-2104 | 202-225-5931 | 304 Cannon House Office Building | http://kennedy.house.gov/rss.xml | ||||||||
41564 | 41564 | Joseph Kennedy K000379 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kennedy.house.gov | 434 Cannon House Office Building; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | 434 Cannon House Office Building | http://kennedy.house.gov/rss.xml | |||||||
41563 | 41563 | Joseph Kennedy K000379 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://kennedy.house.gov | 306 Cannon HOB; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | https://kennedy.house.gov/contact/email-me | 306 Cannon House Office Building | http://kennedy.house.gov/rss.xml | ||||||
41562 | 41562 | Joseph Kennedy K000379 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://kennedy.house.gov | 1218 Longworth HOB; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | https://kennedy.house.gov/contact/email-me | 1218 Longworth House Office Building | http://kennedy.house.gov/rss.xml | ||||||
41076 | 41076 | Niki Tsongas T000465 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://tsongas.house.gov | 1714 Longworth House Office Building; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | |||||||
41075 | 41075 | Niki Tsongas T000465 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://tsongas.house.gov | 1714 Longworth HOB; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | https://tsongas.house.gov/e-mail-niki/ | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | ||||||
41074 | 41074 | Niki Tsongas T000465 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://tsongas.house.gov | 1607 Longworth HOB; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | https://tsongas.house.gov/e-mail-niki/ | 1607 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | ||||||
41073 | 41073 | Niki Tsongas T000465 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://tsongas.house.gov/ | 1607 Longworth HOB; Washington DC 20515-2105 | 202-225-3411 | 202-226-0771 | http://tsongas.house.gov/?sectionid=11&sectiontree=3,11 | 1607 Longworth House Office Building | |||||||
41072 | 41072 | Niki Tsongas T000465 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://tsongas.house.gov/ | ||||||||||||
41071 | 41071 | Niki Tsongas T000465 | rep | MA | 2007-10-16 | 2009-01-03 | Democrat | 5 | http://tsongas.house.gov/ | ||||||||||||
40743 | 40743 | Michael Capuano C001037 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth House Office Building; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | 1414 Longworth House Office Building | ||||||||
40742 | 40742 | Michael Capuano C001037 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40741 | 40741 | Michael Capuano C001037 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40740 | 40740 | Michael Capuano C001037 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2108 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth 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);