legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
476 rows where "end" is on date 2015-01-03 sorted by office
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, party, state_rank
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40533 | 40533 | Tom Price P000591 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 6 | http://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 | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-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 | ||||||
42027 | 42027 | Larry Bucshon B001275 | rep | IN | 2013-01-03 | 2015-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 | ||||||
43652 | 43652 | Todd Young Y000064 | rep | IN | 2013-01-03 | 2015-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 | ||||||
43776 | 43776 | Cheri Bustos B001286 | rep | IL | 2013-01-03 | 2015-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 | ||||||
40165 | 40165 | John Boehner B000589 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 8 | http://boehner.house.gov | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 202-225-0704 | http://boehner.house.gov/contact/ | 1011 Longworth House Office Building | http://boehner.house.gov/news/rss.aspx | ||||||
41657 | 41657 | Devin Nunes N000181 | rep | CA | 2013-01-03 | 2015-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 | ||||||
43728 | 43728 | Julia Brownley B001285 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40731 | 40731 | Robert Brady B001227 | rep | PA | 2013-01-03 | 2015-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 | ||||||
41647 | 41647 | Steve Stivers S001187 | rep | OH | 2013-01-03 | 2015-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 | ||||||
42494 | 42494 | Vicky Hartzler H001053 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 4 | http://hartzler.house.gov | 1023 Longworth HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-0148 | https://hartzler.house.gov/contact-me/email-me | 1023 Longworth House Office Building | http://hartzler.house.gov/rss.xml | ||||||
41722 | 41722 | Theodore Deutch D000610 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 21 | http://teddeutch.house.gov | 1024 Longworth HOB; Washington DC 20515-0921 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/forms/writeyourrep/default.aspx | 1024 Longworth House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||
42429 | 42429 | Kay Granger G000377 | rep | TX | 2013-01-03 | 2015-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 | ||||||
40879 | 40879 | Lynn Jenkins J000290 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 2 | http://lynnjenkins.house.gov | 1027 Longworth HOB; Washington DC 20515-1602 | 202-225-6601 | 202-225-7986 | https://lynnjenkins.house.gov/contact-me | 1027 Longworth House Office Building | http://lynnjenkins.house.gov/common/rss/?rss=220 | ||||||
40117 | 40117 | Ron Barber B001279 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://barber.house.gov | 1029 Longworth HOB; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | https://barber.house.gov/contact/email-me | 1029 Longworth House Office Building | http://barber.house.gov/rss.xml | ||||||
43680 | 43680 | Donald Payne P000604 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 10 | http://payne.house.gov | 103 Cannon HOB; Washington DC 20515-3010 | 202-225-3436 | http://payne.house.gov/contact/email-me | 103 Cannon House Office Building | http://payne.house.gov/rss.xml | |||||||
41344 | 41344 | Bill Flores F000461 | rep | TX | 2013-01-03 | 2015-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 | ||||||
43808 | 43808 | Kevin Cramer C001096 | rep | ND | 2013-01-03 | 2015-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 | ||||||
41080 | 41080 | Timothy Walz W000799 | rep | MN | 2013-01-03 | 2015-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 | ||||||
40394 | 40394 | Jim McDermott M000404 | rep | WA | 2013-01-03 | 2015-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 | ||||||
43763 | 43763 | Lois Frankel F000462 | rep | FL | 2013-01-03 | 2015-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 | ||||||
43586 | 43586 | Daniel Webster W000806 | rep | FL | 2013-01-03 | 2015-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 | ||||||
43768 | 43768 | Tammy Duckworth D000622 | rep | IL | 2013-01-03 | 2015-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 | |||||||
40599 | 40599 | Patrick Tiberi T000462 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 12 | http://tiberi.house.gov | 106 Cannon HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | https://tiberi.house.gov/contact/contactform.htm | 106 Cannon House Office Building | http://tiberi.house.gov/news/rss.aspx | ||||||
40509 | 40509 | Mike Pompeo P000602 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 4 | http://pompeo.house.gov | 107 Cannon HOB; Washington DC 20515-1604 | 202-225-6216 | 202-225-3489 | https://pompeo.house.gov/contact/contactform.htm?zip5=$ADDRESS_ZIP5 | 107 Cannon House Office Building | http://pompeo.house.gov/news/rss.aspx | ||||||
43281 | 43281 | Kurt Schrader S001180 | rep | OR | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://schrader.house.gov | 108 Cannon HOB; Washington DC 20515-3705 | 202-225-5711 | 202-225-5699 | https://schrader.house.gov/forms/writeyourrep/ | 108 Cannon House Office Building | http://schrader.house.gov/news/rss.aspx | ||||||
42677 | 42677 | James Langevin L000559 | rep | RI | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://langevin.house.gov | 109 Cannon HOB; Washington DC 20515-3902 | 202-225-2735 | 202-225-5976 | https://langevin.house.gov/contact-me/email-me | 109 Cannon House Office Building | http://langevin.house.gov/rss.xml | ||||||
41276 | 41276 | Pat Roberts R000307 | sen | KS | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.roberts.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-4774 | 202-224-3514 | http://www.roberts.senate.gov/public/index.cfm?p=EmailPat | 109 Hart Senate Office Building | senior | http://www.roberts.senate.gov/public/?a=rss.feed | |||||
41283 | 41283 | Tom Udall U000039 | sen | NM | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.tomudall.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-6621 | 202-228-3261 | http://www.tomudall.senate.gov/?p=contact | 110 Hart Senate Office Building | senior | http://tomudall.senate.gov/rss/?p=blog | |||||
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 | ||||||
39686 | 39686 | Mark Begich B001265 | sen | AK | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.begich.senate.gov | 111 Russell Senate Office Building Washington DC 20510 | 202-224-3004 | 202-224-2354 | http://www.begich.senate.gov/public/index.cfm?p=EmailSenator | 111 Russell Senate Office Building | junior | http://www.begich.senate.gov/public/?a=rss.feed | |||||
41409 | 41409 | Kenny Marchant M001158 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 24 | http://marchant.house.gov | 1110 Longworth HOB; Washington DC 20515-4324 | 202-225-6605 | 202-225-0074 | https://marchant.house.gov/contact/contactform.htm | 1110 Longworth House Office Building | http://marchant.house.gov/news/rss.aspx | ||||||
41976 | 41976 | Earl Blumenauer B000574 | rep | OR | 2013-01-03 | 2015-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 | ||||||
43849 | 43849 | Markwayne Mullin M001190 | rep | OK | 2013-01-03 | 2015-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 | ||||||
40475 | 40475 | Loretta Sanchez S000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1114 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
41192 | 41192 | Chris Collins C001092 | rep | NY | 2013-01-03 | 2015-01-03 | Republican | 27 | http://chriscollins.house.gov | 1117 Longworth HOB; Washington DC 20515-3227 | 202-225-5265 | https://chriscollins.house.gov/contact/email-me | 1117 Longworth House Office Building | http://chriscollins.house.gov/rss.xml | |||||||
40309 | 40309 | Stephen Fincher F000458 | rep | TN | 2013-01-03 | 2015-01-03 | Republican | 8 | http://fincher.house.gov | 1118 Longworth HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | https://fincher.house.gov/contact/email-me#.U06uR_ldWVo | 1118 Longworth House Office Building | http://fincher.house.gov/rss.xml | ||||||
43625 | 43625 | Steve Womack W000809 | rep | AR | 2013-01-03 | 2015-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 | ||||||
43881 | 43881 | Roger Williams W000816 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 25 | http://williams.house.gov | 1122 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1122 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
40499 | 40499 | Curtis Clawson C001102 | rep | FL | 2014-06-24 | 2015-01-03 | Republican | 19 | 1123 Longworth HOB; Washington DC 20515-0919 | 202-225-2536 | 1123 Longworth House Office Building | ||||||||||
43145 | 43145 | Mike Quigley Q000023 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://quigley.house.gov | 1124 Longworth HOB; Washington DC 20515-1305 | 202-225-4061 | 202-225-5603 | https://quigleyforms.house.gov/forms/writeyourrep/ | 1124 Longworth House Office Building | http://quigley.house.gov/index.php?format=feed&type=rss | ||||||
40306 | 40306 | Sam Farr F000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://www.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 | ||||||
40967 | 40967 | David Reichert R000578 | rep | WA | 2013-01-03 | 2015-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 | ||||||
44442 | 44442 | Cynthia Lummis L000571 | rep | WY | 2013-01-03 | 2015-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 113 Cannon House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
40626 | 40626 | Thad Cochran C000567 | sen | MS | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.cochran.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | 202-224-9450 | http://www.cochran.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | senior | http://www.cochran.senate.gov/public/index.cfm/rss/feed | |||||
42504 | 42504 | Jaime Herrera Beutler H001056 | rep | WA | 2013-01-03 | 2015-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 | ||||||
42104 | 42104 | Bill Cassidy C001075 | rep | LA | 2013-01-03 | 2015-01-03 | Republican | 6 | http://cassidy.house.gov | 1131 Longworth HOB; Washington DC 20515-1806 | 202-225-3901 | 202-225-7313 | https://cassidy.house.gov/contact/email-me | 1131 Longworth House Office Building | http://cassidy.house.gov/rss.xml | ||||||
43341 | 43341 | Terri Sewell S001185 | rep | AL | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://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 | ||||||
41286 | 41286 | Justin Amash A000367 | rep | MI | 2013-01-03 | 2015-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 | ||||||
40691 | 40691 | Lou Barletta B001269 | rep | PA | 2013-01-03 | 2015-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 | ||||||
42358 | 42358 | Jeff Duncan D000615 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 3 | http://jeffduncan.house.gov | 116 Cannon HOB; Washington DC 20515-4003 | 202-225-5301 | 202-225-3216 | https://jeffduncan.house.gov/contact-me/email-me | 116 Cannon House Office Building | http://jeffduncan.house.gov/rss.xml | ||||||
40629 | 40629 | Blake Farenthold F000460 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 27 | http://farenthold.house.gov | 117 Cannon HOB; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | http://farentholdforms.house.gov/contact/email.htm | 117 Cannon House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | ||||||
43564 | 43564 | Debbie Wasserman Schultz W000797 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 23 | http://wassermanschultz.house.gov | 118 Cannon HOB; Washington DC 20515-0923 | 202-225-7931 | 202-226-2052 | http://wassermanschultz.house.gov/contact/email-me.shtml | 118 Cannon House Office Building | http://wassermanschultz.house.gov/atom.xml | ||||||
42520 | 42520 | James Himes H001047 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 119 Cannon House Office Building | http://himes.house.gov/rss.xml | ||||||
43121 | 43121 | Bill Posey P000599 | rep | FL | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
39882 | 39882 | Doc Hastings H000329 | rep | WA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://hastings.house.gov | 1203 Longworth HOB; Washington DC 20515-4704 | 202-225-5816 | 202-225-3251 | https://hastings.house.gov/contact/contactform.htm | 1203 Longworth House Office Building | http://hastings.house.gov/news/rss.aspx | ||||||
43300 | 43300 | David Schweikert S001183 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 6 | http://schweikert.house.gov | 1205 Longworth HOB; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | https://schweikert.house.gov/contact-form | 1205 Longworth House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||
40537 | 40537 | Mick Mulvaney M001182 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 5 | http://mulvaney.house.gov | 1207 Longworth HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | https://mulvaney.house.gov/email-mick/ | 1207 Longworth House Office Building | http://mulvaney.house.gov/index.php?format=feed&type=rss | ||||||
41188 | 41188 | Sean Duffy D000614 | rep | WI | 2013-01-03 | 2015-01-03 | Republican | 7 | http://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 | ||||||
42922 | 42922 | Jerry McNerney M001166 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | https://mcnerney.house.gov/contact/email-me | 1210 Longworth House Office Building | http://mcnerney.house.gov/rss.xml | ||||||
40893 | 40893 | Sam Johnson J000174 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 3 | http://samjohnson.house.gov | 1211 Longworth HOB; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | http://samjohnson.house.gov/contact/ | 1211 Longworth House Office Building | http://samjohnson.house.gov/news/rss.aspx | ||||||
39890 | 39890 | Rush Holt H001032 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://holt.house.gov | 1214 Longworth HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | https://holt.house.gov/email-me | 1214 Longworth House Office Building | http://holt.house.gov/index.php?format=feed&type=rss | ||||||
42554 | 42554 | Bill Huizenga H001058 | rep | MI | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
42658 | 42658 | Adam Kinzinger K000378 | rep | IL | 2013-01-03 | 2015-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 | ||||||
41255 | 41255 | Paul Cook C001094 | rep | CA | 2013-01-03 | 2015-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 | |||||||
43834 | 43834 | Brad Wenstrup W000815 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 2 | http://wenstrup.house.gov | 1223 Longworth HOB; Washington DC 20515-3502 | 202-225-3164 | http://wenstrup.house.gov/contact/ | 1223 Longworth House Office Building | ||||||||
43690 | 43690 | Bill Foster F000454 | rep | IL | 2013-01-03 | 2015-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 | ||||||
40522 | 40522 | Xavier Becerra B000287 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40059 | 40059 | Allyson Schwartz S001162 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://schwartz.house.gov | 1227 Longworth HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | http://schwartz.house.gov/serving-you/email-me | 1227 Longworth House Office Building | http://schwartz.house.gov/rss.xml | ||||||
40061 | 40061 | Steve Southerland S001186 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 2 | http://southerland.house.gov | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | https://southerland.house.gov/index.cfm/email-me | 1229 Longworth House Office Building | http://southerland.house.gov/index.cfm/rss/feed | ||||||
41295 | 41295 | Rob Bishop B001250 | rep | UT | 2013-01-03 | 2015-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 | ||||||
42013 | 42013 | Mo Brooks B001274 | rep | AL | 2013-01-03 | 2015-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 | ||||||
39855 | 39855 | Tim Griffin G000567 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 2 | http://griffin.house.gov | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | https://timgriffinforms.house.gov/forms/writeyourrep/ | 1232 Longworth House Office Building | http://griffin.house.gov/rss.xml | ||||||
41043 | 41043 | Paul Ryan R000570 | rep | WI | 2013-01-03 | 2015-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 | ||||||
40920 | 40920 | Sander Levin L000263 | rep | MI | 2013-01-03 | 2015-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 | ||||||
43704 | 43704 | Kyrsten Sinema S001191 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://sinema.house.gov | 1237 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1237 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
40054 | 40054 | Jon Runyan R000594 | rep | NJ | 2013-01-03 | 2015-01-03 | Republican | 3 | http://runyan.house.gov | 1239 Longworth HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | https://runyan.house.gov/contact-me/email-me | 1239 Longworth House Office Building | http://runyan.house.gov/rss.xml | ||||||
43479 | 43479 | Glenn Thompson T000467 | rep | PA | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
43854 | 43854 | Scott Perry P000605 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://perry.house.gov | 126 Cannon HOB; Washington DC 20515-3804 | 202-225-5836 | 202-226-1000 | http://perryforms.house.gov/forms/writeyourrep/ | 126 Cannon House Office Building | http://perry.house.gov/rss.xml | ||||||
40941 | 40941 | Erik Paulsen P000594 | rep | MN | 2013-01-03 | 2015-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 | ||||||
41898 | 41898 | Christopher Coons C001088 | sen | DE | 2010-11-15 | 2015-01-03 | 2 | Democrat | http://www.coons.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | http://www.coons.senate.gov/contact/ | 127a Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
42136 | 42136 | David Cicilline C001084 | rep | RI | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://cicilline.house.gov | 128 Cannon HOB; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | https://cicilline.house.gov/contact-me/email-me | 128 Cannon House Office Building | http://cicilline.house.gov/rss.xml | ||||||
40362 | 40362 | Tim Huelskamp H001057 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 1 | http://huelskamp.house.gov | 129 Cannon HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | https://huelskamp.house.gov/contact/email-me | 129 Cannon House Office Building | http://huelskamp.house.gov/index.php?format=feed&type=rss | ||||||
40971 | 40971 | James Renacci R000586 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 16 | http://renacci.house.gov | 130 Cannon HOB; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | https://renacci.house.gov/index.cfm/contact-form | 130 Cannon House Office Building | http://renacci.house.gov/common/rss//index.cfm?rss=25 | ||||||
42859 | 42859 | Michael McCaul M001157 | rep | TX | 2013-01-03 | 2015-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 | |||||||
42218 | 42218 | Jim Costa C001059 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 16 | http://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 | ||||||
43819 | 43819 | Grace Meng M001188 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 6 | http://meng.house.gov | 1317 Longworth HOB; Washington DC 20515-3206 | 202-225-2601 | https://meng.house.gov/contact/email-me | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | |||||||
43105 | 43105 | Chellie Pingree P000597 | rep | ME | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://pingree.house.gov/email-me | 1318 Longworth House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||
43738 | 43738 | Raul Ruiz R000599 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 36 | http://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | |||||||
40341 | 40341 | Joseph Heck H001055 | rep | NV | 2013-01-03 | 2015-01-03 | Republican | 3 | http://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 | ||||||
40936 | 40936 | Kristi Noem N000184 | rep | SD | 2013-01-03 | 2015-01-03 | Republican | 0 | http://noem.house.gov | 1323 Longworth HOB; Washington DC 20515-4100 | 202-225-2801 | 202-225-5823 | http://noem.house.gov/index.cfm/email-kristi | 1323 Longworth House Office Building | http://noem.house.gov/index.cfm/rss/feed | ||||||
40902 | 40902 | Leonard Lance L000567 | rep | NJ | 2013-01-03 | 2015-01-03 | Republican | 7 | http://lance.house.gov | 133 Cannon HOB; Washington DC 20515-3007 | 202-225-5361 | 202-225-9460 | https://lance.house.gov/contact-me1 | 133 Cannon House Office Building | http://lance.house.gov/rss-button/rss-button/ | ||||||
44276 | 44276 | Steven Horsford H001066 | rep | NV | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://horsford.house.gov | 1330 Longworth HOB; Washington DC 20515-2804 | 202-225-9894 | https://horsford.house.gov/contact/email-me | 1330 Longworth House Office Building | http://horsford.house.gov/rss.xml | |||||||
43824 | 43824 | Hakeem Jeffries J000294 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://jeffries.house.gov | 1339 Longworth HOB; Washington DC 20515-3208 | 202-225-5936 | https://jeffriesforms.house.gov/contact/ | 1339 Longworth House Office Building | http://jeffries.house.gov/rss.xml | |||||||
39711 | 39711 | Tim Johnson J000177 | sen | SD | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.johnson.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | 202-228-5765 | http://www.johnson.senate.gov/public/index.cfm?p=ContactForm | 136 Hart Senate Office Building | senior | http://www.johnson.senate.gov/public/?a=rss.feed | |||||
43814 | 43814 | Ann Kuster K000382 | rep | NH | 2013-01-03 | 2015-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 | ||||||
42749 | 42749 | Zoe Lofgren L000397 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 19 | http://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 |
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);