legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2017-01-03 sorted by office
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, district, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40534 | 40534 | Tom Price P000591 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 6 | https://tomprice.house.gov | 100 Cannon HOB; Washington DC 20515-1006 | 202-225-4501 | 202-225-4656 | https://tomprice.house.gov/contact-me | 100 Cannon House Office Building | http://tomprice.house.gov/rss.xml | ||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
42028 | 42028 | Larry Bucshon B001275 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 8 | http://bucshon.house.gov | 1005 Longworth HOB; Washington DC 20515-1408 | 202-225-4636 | 202-225-3284 | https://bucshon.house.gov/contact-me/email-me | 1005 Longworth House Office Building | http://bucshon.house.gov/rss.xml | ||||||
43653 | 43653 | Todd Young Y000064 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43777 | 43777 | Cheri Bustos B001286 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://bustos.house.gov | 1009 Longworth HOB; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | http://bustos.house.gov/contact | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||
44090 | 44090 | Warren Davidson D000626 | rep | OH | 2016-06-09 | 2017-01-03 | Republican | 8 | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 1011 Longworth House Office Building | ||||||||||
41658 | 41658 | Devin Nunes N000181 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 22 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0522 | 202-225-2523 | 202-225-3404 | https://nunes.house.gov/contactform/default.aspx | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||
43729 | 43729 | Julia Brownley B001285 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 26 | http://juliabrownley.house.gov | 1019 Longworth HOB; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | https://juliabrownley.house.gov/contact/email-me | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||
40732 | 40732 | Robert Brady B001227 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://brady.house.gov | 102 Cannon HOB; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | https://brady.house.gov/contact-me/email-me | 102 Cannon House Office Building | http://brady.house.gov/rss.xml | ||||||
41648 | 41648 | Steve Stivers S001187 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 15 | http://stivers.house.gov | 1022 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | https://stivers.house.gov/forms/writeyourrep/ | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||
41126 | 41126 | Steve Knight K000387 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41223 | 41223 | Mark Meadows M001187 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth HOB; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | https://meadows.house.gov/email-me | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | ||||||
42430 | 42430 | Kay Granger G000377 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 12 | http://kaygranger.house.gov | 1026 Longworth HOB; Washington DC 20515-4312 | 202-225-5071 | 202-225-5683 | http://kaygranger.house.gov/contact-kay/email-me | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||
40630 | 40630 | Blake Farenthold F000460 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 27 | http://farenthold.house.gov | 1027 Longworth HOB; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | http://farentholdforms.house.gov/contact/email.htm | 1027 Longworth House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | ||||||
41252 | 41252 | Martha McSally M001197 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 2 | https://mcsally.house.gov | 1029 Longworth HOB; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | 1029 Longworth House Office Building | ||||||||
43681 | 43681 | Donald Payne P000604 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://payne.house.gov | 103 Cannon HOB; Washington DC 20515-3010 | 202-225-3436 | 202-225-4160 | http://payne.house.gov/contact/email-me | 103 Cannon House Office Building | http://payne.house.gov/rss.xml | ||||||
41345 | 41345 | Bill Flores F000461 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 17 | http://flores.house.gov | 1030 Longworth HOB; Washington DC 20515-4317 | 202-225-6105 | 202-225-0350 | https://billflores.house.gov/contact/ | 1030 Longworth House Office Building | http://flores.house.gov/common/rss//index.cfm?rss=25 | ||||||
43809 | 43809 | Kevin Cramer C001096 | rep | ND | 2015-01-06 | 2017-01-03 | Republican | 0 | http://cramer.house.gov | 1032 Longworth HOB; Washington DC 20515-3400 | 202-225-2611 | 202-226-0893 | https://cramer.house.gov/contact/email-me | 1032 Longworth House Office Building | http://cramer.house.gov/rss.xml | ||||||
41081 | 41081 | Timothy Walz W000799 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://walz.house.gov | 1034 Longworth HOB; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | http://walz.house.gov/contact | 1034 Longworth House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | ||||||
40395 | 40395 | Jim McDermott M000404 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://mcdermott.house.gov | 1035 Longworth HOB; Washington DC 20515-4707 | 202-225-3106 | 202-225-6197 | https://forms.house.gov/mcdermott/webforms/new/contact.shtml | 1035 Longworth House Office Building | http://mcdermott.house.gov/index.php?format=feed&type=rss | ||||||
43764 | 43764 | Lois Frankel F000462 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43587 | 43587 | Daniel Webster W000806 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 10 | http://webster.house.gov | 1039 Longworth HOB; Washington DC 20515-0910 | 202-225-2176 | 202-225-0999 | https://webster.house.gov/contact/contactform.htm | 1039 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | ||||||
43769 | 43769 | Tammy Duckworth D000622 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://duckworth.house.gov | 104 Cannon HOB; Washington DC 20515-1308 | 202-225-3711 | https://duckworth.house.gov/contact/email-me | 104 Cannon House Office Building | http://duckworth.house.gov/rss.xml | |||||||
42359 | 42359 | Jeff Duncan D000615 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 3 | http://jeffduncan.house.gov | 106 Cannon HOB; Washington DC 20515-4003 | 202-225-5301 | 202-225-3216 | https://jeffduncan.house.gov/contact-me/email-me | 106 Cannon House Office Building | http://jeffduncan.house.gov/rss.xml | ||||||
40506 | 40506 | Brad Ashford A000373 | rep | NE | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://ashford.house.gov | 107 Cannon HOB; Washington DC 20515-2702 | 202-225-4155 | 202-226-5452 | 107 Cannon House Office Building | ||||||||
43749 | 43749 | Alan Lowenthal L000579 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 47 | http://lowenthal.house.gov | 108 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 108 Cannon House Office Building | http://lowenthal.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 | ||||||
40363 | 40363 | Tim Huelskamp H001057 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 1 | http://huelskamp.house.gov | 1110 Longworth HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | https://huelskamp.house.gov/contact/email-me | 1110 Longworth House Office Building | http://huelskamp.house.gov/index.php?format=feed&type=rss | ||||||
41977 | 41977 | Earl Blumenauer B000574 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://blumenauer.house.gov | 1111 Longworth HOB; Washington DC 20515-3703 | 202-225-4811 | 202-225-8941 | https://forms.house.gov/blumenauer/webforms/issue_subscribe.html | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | ||||||
43850 | 43850 | Markwayne Mullin M001190 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 2 | http://mullin.house.gov | 1113 Longworth HOB; Washington DC 20515-3602 | 202-225-2701 | 202-225-3038 | https://mullin.house.gov/contact/email-me | 1113 Longworth House Office Building | http://mullin.house.gov/rss.xml | ||||||
43565 | 43565 | Debbie Wasserman Schultz W000797 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 23 | http://wassermanschultz.house.gov | 1114 Longworth HOB; Washington DC 20515-0923 | 202-225-7931 | 202-226-2052 | http://wassermanschultz.house.gov/contact/email-me.shtml | 1114 Longworth House Office Building | http://wassermanschultz.house.gov/atom.xml | ||||||
41193 | 41193 | Chris Collins C001092 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 27 | http://chriscollins.house.gov | 1117 Longworth HOB; Washington DC 20515-3227 | 202-225-5265 | 202-225-5910 | https://chriscollins.house.gov/contact/email-me | 1117 Longworth House Office Building | http://chriscollins.house.gov/rss.xml | ||||||
43914 | 43914 | Jason Smith S001195 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 8 | http://jasonsmith.house.gov | 1118 Longworth HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | https://jasonsmith.house.gov/contact/email-me | 1118 Longworth House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||
43626 | 43626 | Steve Womack W000809 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
40209 | 40209 | Barbara Boxer B000711 | sen | CA | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.boxer.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | 202-224-0454 | https://www.boxer.senate.gov/contact/shareyourviews.html | 112 Hart Senate Office Building | junior | ||||||
43759 | 43759 | Scott Peters P000608 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 52 | http://scottpeters.house.gov | 1122 Longworth HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
44036 | 44036 | John Katko K000386 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 24 | https://katko.house.gov | 1123 Longworth HOB; Washington DC 20515-3224 | 202-225-3701 | 202-225-4042 | 1123 Longworth House Office Building | ||||||||
43845 | 43845 | David Joyce J000295 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 14 | http://joyce.house.gov | 1124 Longworth HOB; Washington DC 20515-3514 | 202-225-5731 | 202-225-3307 | https://joyce.house.gov/email-me | 1124 Longworth House Office Building | http://joyce.house.gov/rss/press-releases.xml | ||||||
40307 | 40307 | Sam Farr F000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
40968 | 40968 | David Reichert R000578 | rep | WA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://reichert.house.gov | 1127 Longworth HOB; Washington DC 20515-4708 | 202-225-7761 | 202-225-4282 | https://reichert.house.gov/contact-me | 1127 Longworth House Office Building | http://reichert.house.gov/rss.xml | ||||||
40540 | 40540 | Ryan Zinke Z000018 | rep | MT | 2015-01-06 | 2017-01-03 | Republican | 0 | https://zinke.house.gov | 113 Cannon HOB; Washington DC 20515-2600 | 202-225-3211 | 202-225-5687 | 113 Cannon House Office Building | ||||||||
42505 | 42505 | Jaime Herrera Beutler H001056 | rep | WA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://herrerabeutler.house.gov | 1130 Longworth HOB; Washington DC 20515-4703 | 202-225-3536 | 202-225-3478 | http://herrerabeutler.house.gov/contact/ | 1130 Longworth House Office Building | http://herrerabeutler.house.gov/news/rss.aspx | ||||||
40713 | 40713 | Diane Black B001273 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 6 | http://black.house.gov | 1131 Longworth HOB; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | https://black.house.gov/contact-me/email-me | 1131 Longworth House Office Building | http://black.house.gov/rss.xml | ||||||
43342 | 43342 | Terri Sewell S001185 | rep | AL | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://sewell.house.gov | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | https://sewell.house.gov/email-me | 1133 Longworth House Office Building | http://sewell.house.gov/rss.xml | ||||||
41287 | 41287 | Justin Amash A000367 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 3 | http://amash.house.gov | 114 Cannon HOB; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | https://amash.house.gov/contact-me/email-me | 114 Cannon House Office Building | http://amash.house.gov/rss.xml | ||||||
40692 | 40692 | Lou Barletta B001269 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 11 | http://barletta.house.gov | 115 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | https://barletta.house.gov/contact/email-me | 115 Cannon House Office Building | http://barletta.house.gov/common/rss//index.cfm?rss=25 | ||||||
44004 | 44004 | Debbie Dingell D000624 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 12 | https://debbiedingell.house.gov | 116 Cannon HOB; Washington DC 20515-2212 | 202-225-4071 | 202-226-0371 | 116 Cannon House Office Building | ||||||||
44000 | 44000 | John Moolenaar M001194 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 4 | https://moolenaar.house.gov | 117 Cannon HOB; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | 117 Cannon House Office Building | ||||||||
44040 | 44040 | Brendan Boyle B001296 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 13 | https://boyle.house.gov | 118 Cannon HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | 118 Cannon House Office Building | ||||||||
41575 | 41575 | Bradley Byrne B001289 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 1 | https://byrne.house.gov | 119 Cannon HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://byrne.house.gov/contact/email-me | 119 Cannon House Office Building | |||||||
43122 | 43122 | Bill Posey P000599 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 8 | http://posey.house.gov | 120 Cannon HOB; Washington DC 20515-0908 | 202-225-3671 | 202-225-3516 | https://posey.house.gov/forms/writeyourrep/ | 120 Cannon House Office Building | http://posey.house.gov/news/rss.aspx?documenttypeid=1487 | ||||||
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 | ||||||
40600 | 40600 | Patrick Tiberi T000462 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 12 | http://tiberi.house.gov | 1203 Longworth HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | https://tiberi.house.gov/contact/contactform.htm | 1203 Longworth House Office Building | http://tiberi.house.gov/news/rss.aspx | ||||||
41112 | 41112 | Keith Rothfus R000598 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth HOB; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | https://rothfus.house.gov/email-keith | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | ||||||
43855 | 43855 | Scott Perry P000605 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://perry.house.gov | 1207 Longworth HOB; Washington DC 20515-3804 | 202-225-5836 | 202-226-1000 | http://perryforms.house.gov/forms/writeyourrep/ | 1207 Longworth House Office Building | http://perry.house.gov/rss.xml | ||||||
41189 | 41189 | Sean Duffy D000614 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 7 | https://duffy.house.gov | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 202-225-3240 | http://duffy.house.gov/contact | 1208 Longworth House Office Building | http://duffy.house.gov/rss.xml | ||||||
40295 | 40295 | Renee Ellmers E000291 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 2 | http://ellmers.house.gov | 1210 Longworth HOB; Washington DC 20515-3302 | 202-225-4531 | 202- 225-5662 | https://ellmersforms.house.gov/contact-us1 | 1210 Longworth House Office Building | http://ellmers.house.gov/common/rss//index.cfm?rss=49 | ||||||
40476 | 40476 | Loretta Sanchez S000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1211 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1211 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40505 | 40505 | Gwen Graham G000575 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://graham.house.gov | 1213 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1213 Longworth House Office Building | ||||||||
41324 | 41324 | Susan Davis D000598 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 53 | http://susandavis.house.gov | 1214 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1214 Longworth House Office Building | |||||||
42555 | 42555 | Bill Huizenga H001058 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 2 | http://huizenga.house.gov | 1217 Longworth HOB; Washington DC 20515-2202 | 202-225-4401 | 202-226-0779 | http://huizenga.house.gov/contact/ | 1217 Longworth House Office Building | http://huizenga.house.gov/news/rss.aspx | ||||||
43948 | 43948 | Ruben Gallego G000574 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1218 Longworth HOB; Washington DC 20515-0307 | 202-225-4065 | 1218 Longworth House Office Building | |||||||||
42659 | 42659 | Adam Kinzinger K000378 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 16 | http://kinzinger.house.gov | 1221 Longworth HOB; Washington DC 20515-1316 | 202-225-3635 | 202-225-3521 | https://kinzinger.house.gov/email-adam | 1221 Longworth House Office Building | http://kinzinger.house.gov/common/rss//index.cfm?rss=49 | ||||||
41256 | 41256 | Paul Cook C001094 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://cook.house.gov | 1222 Longworth HOB; Washington DC 20515-0508 | 202-225-5861 | https://cook.house.gov/contact/email-me | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
43956 | 43956 | Pete Aguilar A000371 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43691 | 43691 | Bill Foster F000454 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://foster.house.gov | 1224 Longworth HOB; Washington DC 20515-1311 | 202-225-3515 | 202-225-9420 | https://foster.house.gov/contact/email-me | 1224 Longworth House Office Building | http://foster.house.gov/rss.xml | ||||||
40523 | 40523 | Xavier Becerra B000287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
42521 | 42521 | James Himes H001047 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://himes.house.gov | 1227 Longworth HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||
43940 | 43940 | J. Hill H001072 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 2 | https://hill.house.gov | 1229 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1229 Longworth House Office Building | ||||||||
41296 | 41296 | Rob Bishop B001250 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 1 | http://robbishop.house.gov | 123 Cannon HOB; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | https://robbishop.house.gov/contact/contactform.htm | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | ||||||
42014 | 42014 | Mo Brooks B001274 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 5 | http://brooks.house.gov | 1230 Longworth HOB; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | https://brooks.house.gov/email-me | 1230 Longworth House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||
44064 | 44064 | Alexander Mooney M001195 | rep | WV | 2015-01-06 | 2017-01-03 | Republican | 2 | https://mooney.house.gov | 1232 Longworth HOB; Washington DC 20515-4802 | 202-225-2711 | 202-225-7856 | 1232 Longworth House Office Building | ||||||||
41044 | 41044 | Paul Ryan R000570 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 1 | http://paulryan.house.gov | 1233 Longworth HOB; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | https://paulryan.house.gov/contact/email.htm#.U032ra1dU_d | 1233 Longworth House Office Building | http://paulryan.house.gov/news/rss.aspx | ||||||
40921 | 40921 | Sander Levin L000263 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://levin.house.gov | 1236 Longworth HOB; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | https://levin.house.gov/contact-me/email-me | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | ||||||
44008 | 44008 | Brenda Lawrence L000581 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 14 | https://lawrence.house.gov | 1237 Longworth HOB; Washington DC 20515-2214 | 202-225-5802 | 202-226-2356 | 1237 Longworth House Office Building | ||||||||
43909 | 43909 | Robin Kelly K000385 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://robinkelly.house.gov | 1239 Longworth HOB; Washington DC 20515-1302 | 202-225-0773 | 202-225-4583 | https://robinkelly.house.gov/contact/email-me | 1239 Longworth House Office Building | http://robinkelly.house.gov/rss.xml | ||||||
43480 | 43480 | Glenn Thompson T000467 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://thompson.house.gov/contact-me/email-me | 124 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||
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 | ||||||
44020 | 44020 | Bonnie Watson Coleman W000822 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 12 | https://watsoncoleman.house.gov | 126 Cannon HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | 126 Cannon House Office Building | ||||||||
40942 | 40942 | Erik Paulsen P000594 | rep | MN | 2015-01-06 | 2017-01-03 | Republican | 3 | http://paulsen.house.gov | 127 Cannon HOB; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | https://paulsenforms.house.gov/contact-me | 127 Cannon House Office Building | http://paulsen.house.gov/common/rss//?rss=105 | ||||||
41144 | 41144 | Steve Russell R000604 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 5 | https://russell.house.gov | 128 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 128 Cannon House Office Building | ||||||||
43724 | 43724 | Eric Swalwell S001193 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://swalwell.house.gov | 129 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 129 Cannon House Office Building | ||||||||
43944 | 43944 | Bruce Westerman W000821 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 4 | https://westerman.house.gov | 130 Cannon HOB; Washington DC 20515-0404 | 202-225-3772 | 130 Cannon House Office Building | |||||||||
42860 | 42860 | Michael McCaul M001157 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 10 | http://mccaul.house.gov | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | https://mccaul.house.gov/contact/email-me | 131 Cannon House Office Building | |||||||
41214 | 41214 | John Isakson I000055 | sen | GA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | http://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
42219 | 42219 | Jim Costa C001059 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 16 | https://costa.house.gov | 1314 Longworth HOB; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||
43820 | 43820 | Grace Meng M001188 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://meng.house.gov | 1317 Longworth HOB; Washington DC 20515-3206 | 202-225-2601 | 202-225-1589 | https://meng.house.gov/contact/email-me | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | ||||||
43835 | 43835 | Brad Wenstrup W000815 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 2 | http://wenstrup.house.gov | 1318 Longworth HOB; Washington DC 20515-3502 | 202-225-3164 | 202-225-1992 | http://wenstrup.house.gov/contact/ | 1318 Longworth House Office Building | |||||||
43739 | 43739 | Raul Ruiz R000599 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | ||||||
40342 | 40342 | Joseph Heck H001055 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 3 | https://heck.house.gov | 132 Cannon HOB; Washington DC 20515-2803 | 202-225-3252 | 202- 225-2185 | https://heck.house.gov/contact-me | 132 Cannon House Office Building | http://heck.house.gov/rss.xml | ||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43840 | 43840 | Joyce Beatty B001281 | rep | OH | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://beatty.house.gov | 133 Cannon HOB; Washington DC 20515-3503 | 202-225-4324 | 202-225-1984 | https://beattyforms.house.gov/forms/writeyourrep/ | 133 Cannon House Office Building | http://beatty.house.gov/rss.xml | ||||||
41115 | 41115 | Beto O’Rourke O000170 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 16 | http://orourke.house.gov | 1330 Longworth HOB; Washington DC 20515-4316 | 202-225-4831 | https://orourkeforms.house.gov/forms/writeyourrep/ | 1330 Longworth House Office Building | http://orourke.house.gov/rss.xml | |||||||
44068 | 44068 | Aumua Amata Radewagen R000600 | rep | AS | 2015-01-06 | 2017-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth HOB; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
42442 | 42442 | Charles Grassley G000386 | sen | IA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | http://www.grassley.senate.gov/constituents/questions-and-comments | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
43815 | 43815 | Ann Kuster K000382 | rep | NH | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://kuster.house.gov | 137 Cannon HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | https://kuster.house.gov/contact/email-me | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||
42750 | 42750 | Zoe Lofgren L000397 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth HOB; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/contact/ | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||
40832 | 40832 | Trey Gowdy G000566 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 4 | https://gowdy.house.gov | 1404 Longworth HOB; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | https://gowdy.house.gov/forms/writeyourrep/default.aspx | 1404 Longworth House Office Building | http://gowdy.house.gov/news/rss.aspx | ||||||
40279 | 40279 | John Carney C001083 | rep | DE | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://johncarney.house.gov | 1406 Longworth HOB; Washington DC 20515-0800 | 202-225-4165 | 202-225-2291 | https://forms.house.gov/carney/webforms/email-me.shtml | 1406 Longworth House Office Building | http://johncarney.house.gov/index.php?format=feed&type=rss | ||||||
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 |
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);