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 url
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
43932 | 43932 | Alma Adams A000370 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 12 | http://adams.house.gov | 222 Cannon HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://adams.house.gov/contact | 222 Cannon House Office Building | |||||||
43407 | 43407 | Adrian Smith S001172 | rep | NE | 2015-01-06 | 2017-01-03 | Republican | 3 | http://adriansmith.house.gov | 2241 Rayburn HOB; Washington DC 20515-2703 | 202-225-6435 | 202-225-0207 | https://adriansmith.house.gov/contact-me/email-me | 2241 Rayburn House Office Building | http://adriansmith.house.gov/rss.xml | ||||||
41642 | 41642 | Alcee Hastings H000324 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | https://alceehastings.house.gov/forms/writeyourrep/?zip5=33407&zip4=3224 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||
42460 | 42460 | Al Green G000553 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://algreen.house.gov | 2347 Rayburn HOB; Washington DC 20515-4309 | 202-225-7508 | 202-225-2947 | https://algreen.house.gov/contact-me/email-me | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||
43984 | 43984 | Rick Allen A000372 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 12 | http://allen.house.gov | 513 Cannon HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | 513 Cannon House Office Building | ||||||||
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 | ||||||
43657 | 43657 | Mark Amodei A000369 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 2 | http://amodei.house.gov | 332 Cannon HOB; Washington DC 20515-2802 | 202-225-6155 | 202-225-5679 | https://amodei.house.gov/contact-us | 332 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||
43307 | 43307 | Austin Scott S001189 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://austinscott.house.gov | 2417 Rayburn HOB; Washington DC 20515-1008 | 202-225-6531 | 202-225-3013 | https://austinscott.house.gov/email-me/ | 2417 Rayburn House Office Building | http://austinscott.house.gov/index.php?format=feed&type=rss | ||||||
44044 | 44044 | Brian Babin B001291 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 36 | http://babin.house.gov | 316 Cannon HOB; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
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 | ||||||
41928 | 41928 | Karen Bass B001270 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 37 | http://bass.house.gov | 408 Cannon HOB; Washington DC 20515-0537 | 202-225-7084 | 202-225-2422 | https://bass.house.gov/contact-me/email-me | 408 Cannon House Office Building | http://bass.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 | ||||||
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 | ||||||
40248 | 40248 | Dan Benishek B001271 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 1 | http://benishek.house.gov | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | https://benishek.house.gov/contact-me/email-me | 514 Cannon House Office Building | http://benishek.house.gov/rss.xml | ||||||
43461 | 43461 | Bennie Thompson T000193 | rep | MS | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||
43719 | 43719 | Ami Bera B001287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://bera.house.gov | 1535 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1535 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
44048 | 44048 | Donald Beyer B001292 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://beyer.house.gov | 431 Cannon HOB; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | 431 Cannon House Office Building | ||||||||
42575 | 42575 | Bill Johnson J000292 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 6 | http://billjohnson.house.gov | 1710 Longworth HOB; Washington DC 20515-3506 | 202-225-5705 | 202-225-5907 | http://billjohnson.house.gov/contact/default.aspx | 1710 Longworth House Office Building | http://billjohnson.house.gov/constituentservices/opendoorsschedule.htm | ||||||
41954 | 41954 | Sanford Bishop B000490 | rep | GA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://bishop.house.gov | 2407 Rayburn HOB; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | http://bishop.house.gov/contact | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||
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 | ||||||
41964 | 41964 | Marsha Blackburn B001243 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 7 | http://blackburn.house.gov | 2266 Rayburn HOB; Washington DC 20515-4207 | 202-225-2811 | 202-225-3004 | https://blackburn.house.gov/contactform/email.htm | 2266 Rayburn House Office Building | http://blackburn.house.gov/news/rss.aspx | ||||||
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 | ||||||
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 | ||||||
43663 | 43663 | Suzanne Bonamici B001278 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://bonamici.house.gov | 439 Cannon HOB; Washington DC 20515-3701 | 202-225-0855 | 202-225-9497 | https://bonamici.house.gov/contact-me/email-me | 439 Cannon House Office Building | http://bonamici.house.gov/rss.xml | ||||||
40721 | 40721 | Madeleine Bordallo B001245 | rep | GU | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://bordallo.house.gov | 2441 Rayburn HOB; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | https://bordallo.house.gov/contact-me | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | ||||||
40254 | 40254 | Charles Boustany B001255 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://boustany.house.gov | 1431 Longworth HOB; Washington DC 20515-1803 | 202-225-2031 | 202-225-5724 | https://boustanyforms.house.gov/contact-me/ | 1431 Longworth House Office Building | http://www.house.gov/common/rss/index.cfm?rss=82 | ||||||
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 | ||||||
41124 | 41124 | David Brat B001290 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://brat.house.gov | 330 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | http://brat.house.gov/contact | 330 Cannon House Office Building | ||||||||
40637 | 40637 | Jim Bridenstine B001283 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 1 | http://bridenstine.house.gov | 216 Cannon HOB; Washington DC 20515-3601 | 202-225-2211 | 918-935-2716 | https://bridenstineforms.house.gov/forms/writeyourrep/ | 216 Cannon House Office Building | http://bridenstine.house.gov/rss.xml | ||||||
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 | ||||||
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 | ||||||
43972 | 43972 | Earl Carter C001103 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://buddycarter.house.gov | 432 Cannon HOB; Washington DC 20515-1001 | 202-225-5831 | 202-226-2269 | 432 Cannon House Office Building | ||||||||
42038 | 42038 | Michael Burgess B001248 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 26 | http://burgess.house.gov | 2336 Rayburn HOB; Washington DC 20515-4326 | 202-225-7772 | 202-225-2919 | http://burgess.house.gov/contact/356345.htm | 2336 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||
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 | ||||||
42056 | 42056 | George Butterfield B001251 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://butterfield.house.gov | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | https://butterfield.house.gov/email-congressman-butterfield | 2305 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||
42071 | 42071 | Ken Calvert C000059 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 42 | http://calvert.house.gov | 2205 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
40276 | 40276 | Lois Capps C001036 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 24 | http://capps.house.gov | 2231 Rayburn HOB; Washington DC 20515-0524 | 202-225-3601 | 202-225-5632 | https://capps.house.gov/contact-me/email-me | 2231 Rayburn House Office Building | http://capps.house.gov/rss.xml | ||||||
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 | |||||||
43734 | 43734 | Tony Cárdenas C001097 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 29 | http://cardenas.house.gov | 1510 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1510 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
42088 | 42088 | André Carson C001072 | rep | IN | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://carson.house.gov | 2453 Rayburn HOB; Washington DC 20515-1407 | 202-225-4011 | 202-225-5633 | https://carson.house.gov/contact/email-me | 2453 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||
42098 | 42098 | John Carter C001051 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 31 | http://carter.house.gov | 2110 Rayburn HOB; Washington DC 20515-4331 | 202-225-3864 | 202-225-5886 | https://carter.house.gov/email-john2 | 2110 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||
43860 | 43860 | Matthew Cartwright C001090 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://cartwright.house.gov | 1419 Longworth HOB; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | https://cartwrightforms.house.gov/forms/writeyourrep/ | 1419 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||
42111 | 42111 | Kathy Castor C001066 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://castor.house.gov | 205 Cannon HOB; Washington DC 20515-0914 | 202-225-3376 | 202-225-5652 | https://castor.house.gov/contact/contactform.htm | 205 Cannon House Office Building | http://castor.house.gov/news/rss.aspx | ||||||
43877 | 43877 | Joaquin Castro C001091 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://castro.house.gov | 212 Cannon HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | https://castro.house.gov/contact/email-me | 212 Cannon House Office Building | http://castro.house.gov/rss.xml | ||||||
42124 | 42124 | Steve Chabot C000266 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 1 | http://chabot.house.gov | 2371 Rayburn HOB; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | https://chabot.house.gov/forms/writeyourrep/?zip5=45202&zip4=3003 | 2371 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||
40545 | 40545 | Jason Chaffetz C001076 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 3 | http://chaffetz.house.gov | 2236 Rayburn HOB; Washington DC 20515-4403 | 202-225-7751 | 202-225-5629 | https://chaffetz.house.gov/contact-me/email-me | 2236 Rayburn House Office Building | http://chaffetz.house.gov/rss.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 | ||||||
43428 | 43428 | Christopher Smith S000522 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 4 | http://chrissmith.house.gov | 2373 Rayburn HOB; Washington DC 20515-3004 | 202-225-3765 | 202-225-7768 | https://chrissmith.house.gov/contact/write.htm | 2373 Rayburn House Office Building | http://chrissmith.house.gov/news/rss.aspx | ||||||
42131 | 42131 | Judy Chu C001080 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 27 | http://chu.house.gov | 2423 Rayburn HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||
42137 | 42137 | David Cicilline C001084 | rep | RI | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://cicilline.house.gov | 2244 Rayburn HOB; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | https://cicilline.house.gov/contact-me/email-me | 2244 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | ||||||
42145 | 42145 | Yvette Clarke C001067 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://clarke.house.gov | 2351 Rayburn HOB; Washington DC 20515-3209 | 202-225-6231 | 202-226-0112 | https://clarke.house.gov/contact/email-me | 2351 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | ||||||
40500 | 40500 | Curtis Clawson C001102 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 19 | http://clawson.house.gov | 228 Cannon HOB; Washington DC 20515-0919 | 202-225-2536 | 228 Cannon House Office Building | |||||||||
42154 | 42154 | Emanuel Cleaver C001061 | rep | MO | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://cleaver.house.gov | 2335 Rayburn HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | https://cleaver.house.gov/contact/email-me | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||
42169 | 42169 | James Clyburn C000537 | rep | SC | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://clyburn.house.gov | 242 Cannon HOB; Washington DC 20515-4006 | 202-225-3315 | 202-225-2313 | https://clyburn.house.gov/contact-me/email-me | 242 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||
40747 | 40747 | Mike Coffman C001077 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 6 | http://coffman.house.gov | 2443 Rayburn HOB; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | https://coffman.house.gov/contact/email-me | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | ||||||
42177 | 42177 | Steve Cohen C001068 | rep | TN | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://cohen.house.gov | 2404 Rayburn HOB; Washington DC 20515-4209 | 202-225-3265 | 202-225-5663 | https://cohen.house.gov/contact-me/email-me | 2404 Rayburn House Office Building | http://cohen.house.gov/rss.xml | ||||||
42187 | 42187 | Tom Cole C001053 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 4 | http://cole.house.gov | 2467 Rayburn HOB; Washington DC 20515-3604 | 202-225-6165 | 202-225-3512 | https://coleforms.house.gov/contact/default.aspx | 2467 Rayburn House Office Building | http://cole.house.gov/rss.xml | ||||||
41431 | 41431 | Collin Peterson P000258 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2204 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | https://collinpeterson.house.gov/contact-me/email-me | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | ||||||
41314 | 41314 | K. Conaway C001062 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 11 | http://conaway.house.gov | 2430 Rayburn HOB; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | https://conaway.house.gov/forms/writeyourrep/default.aspx | 2430 Rayburn House Office Building | |||||||
42194 | 42194 | Gerald Connolly C001078 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://connolly.house.gov | 2238 Rayburn HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
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 | |||||||
42210 | 42210 | Jim Cooper C000754 | rep | TN | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://cooper.house.gov | 1536 Longworth HOB; Washington DC 20515-4205 | 202-225-4311 | 202-226-1035 | https://cooper.house.gov/contact/email-me | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | ||||||
42227 | 42227 | Joe Courtney C001069 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://courtney.house.gov | 2348 Rayburn HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | https://courtney.house.gov/email-joe1 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
42240 | 42240 | Eric Crawford C001087 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 1 | http://crawford.house.gov | 1711 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | http://crawford.house.gov/contact/ | 1711 Longworth House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||
40757 | 40757 | Joseph Crowley C001038 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://crowley.house.gov | 1436 Longworth HOB; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | https://crowley.house.gov/contact-me/email-me | 1436 Longworth House Office Building | http://crowley.house.gov/rss.xml | ||||||
42249 | 42249 | Henry Cuellar C001063 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 28 | http://cuellar.house.gov | 2209 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
40766 | 40766 | John Culberson C001048 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 7 | http://culberson.house.gov | 2372 Rayburn HOB; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | https://culbersonforms.house.gov/forms/writeyourrep/default.aspx | 2372 Rayburn House Office Building | http://culberson.house.gov/rss/ | ||||||
41206 | 41206 | Elijah Cummings C000984 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://cummings.house.gov | 2230 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://cummings.house.gov/contact-me/email-me | 2230 Rayburn House Office Building | http://cummings.house.gov/rss.xml | ||||||
41130 | 41130 | Carlos Curbelo C001107 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 26 | http://curbelo.house.gov | 1429 Longworth HOB; Washington DC 20515-0926 | 202-225-2778 | 1429 Longworth House Office Building | |||||||||
43791 | 43791 | Daniel Kildee K000380 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://dankildee.house.gov | 227 Cannon HOB; Washington DC 20515-2205 | 202-225-3611 | 202-225-6393 | https://dankildee.house.gov/contact/email-me | 227 Cannon House Office Building | http://dankildee.house.gov/rss.xml | ||||||
43317 | 43317 | David Scott S001157 | rep | GA | 2015-01-06 | 2017-01-03 | Democrat | 13 | http://davidscott.house.gov | 225 Cannon HOB; Washington DC 20515-1013 | 202-225-2939 | 202-225-4628 | https://davidscott.house.gov/contact/contactform.htm | 225 Cannon House Office Building | http://davidscott.house.gov/news/rss.aspx | ||||||
42262 | 42262 | Danny Davis D000096 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://davis.house.gov | 2159 Rayburn HOB; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | https://davis.house.gov/email-me | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||
42280 | 42280 | Peter DeFazio D000191 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42293 | 42293 | Diana DeGette D000197 | rep | CO | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://degette.house.gov | 2368 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | https://degette.house.gov/contact/send-me-an-email/email-me | 2368 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
41099 | 41099 | John Delaney D000620 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://delaney.house.gov | 1632 Longworth HOB; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | https://delaney.house.gov/contact/email-me | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | ||||||
42309 | 42309 | Rosa DeLauro D000216 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
43669 | 43669 | Suzan DelBene D000617 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://delbene.house.gov | 318 Cannon HOB; Washington DC 20515-4701 | 202-225-6311 | 202-226-1606 | http://delbene.house.gov/contact-me/email-me | 318 Cannon House Office Building | http://delbene.house.gov/rss.xml | ||||||
40770 | 40770 | Jeff Denham D000612 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 10 | http://denham.house.gov | 1730 Longworth HOB; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | https://denham.house.gov/contact-me/email-me | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | ||||||
41021 | 41021 | Dennis Ross R000593 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 15 | http://dennisross.house.gov | 229 Cannon HOB; Washington DC 20515-0915 | 202-225-1252 | 202-226-0585 | https://dennisross.house.gov/forms/writeyourrep/ | 229 Cannon House Office Building | http://dennisross.house.gov/news/rss.aspx | ||||||
41571 | 41571 | Denny Heck H001064 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://dennyheck.house.gov | 425 Cannon HOB; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | https://dennyheck.house.gov/contact/email-me | 425 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | ||||||
40655 | 40655 | Ron DeSantis D000621 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 6 | http://desantis.house.gov | 308 Cannon HOB; Washington DC 20515-0906 | 202-225-2706 | 202-226-6299 | https://desantis.house.gov/contact/email-me | 308 Cannon House Office Building | http://desantis.house.gov/rss.xml | ||||||
42339 | 42339 | Lloyd Doggett D000399 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 35 | http://doggett.house.gov | 2307 Rayburn HOB; Washington DC 20515-4335 | 202-225-4865 | 202-225-3073 | https://forms.house.gov/doggett/webforms/issue_subscribe.htm | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | ||||||
40292 | 40292 | Donna Edwards E000290 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://donnaedwards.house.gov | 2445 Rayburn HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | https://forms.house.gov/formdonnaedwards/issue_subscribe.shtml | 2445 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=24 | ||||||
41685 | 41685 | Don Young Y000033 | rep | AK | 2015-01-06 | 2017-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0200 | 202-225-5765 | 202-225-0425 | https://donyoung.house.gov/forms/writeyourrep/ | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||
41551 | 41551 | Doug Collins C001093 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://dougcollins.house.gov | 1504 Longworth HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
42353 | 42353 | Michael Doyle D000482 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://doyle.house.gov | 239 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | https://doyle.house.gov/contact-me/email-me | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||
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 | |||||||
40790 | 40790 | John Duncan D000533 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 2 | http://duncan.house.gov | 2207 Rayburn HOB; Washington DC 20515-4202 | 202-225-5435 | 202-225-6440 | https://duncan.house.gov/contact-me/email-me | 2207 Rayburn House Office Building | http://duncan.house.gov/rss.xml | ||||||
42590 | 42590 | Eddie Johnson J000126 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
40796 | 40796 | Keith Ellison E000288 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://ellison.house.gov | 2263 Rayburn HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/contact | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
41340 | 41340 | Eliot Engel E000179 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 16 | http://engel.house.gov | 2462 Rayburn HOB; Washington DC 20515-3216 | 202-225-2464 | 202-225-5513 | https://engel.house.gov/write-your-rep1 | 2462 Rayburn House Office Building | |||||||
42374 | 42374 | Anna Eshoo E000215 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://eshoo.house.gov | 241 Cannon HOB; Washington DC 20515-0518 | 202-225-8104 | 202-225-8890 | https://eshoo.house.gov/email-me/ | 241 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||
41093 | 41093 | Elizabeth Esty E000293 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://esty.house.gov | 405 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 405 Cannon House Office Building | http://esty.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 | ||||||
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 | ||||||
40310 | 40310 | Stephen Fincher F000458 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 8 | http://fincher.house.gov | 2452 Rayburn HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | https://fincher.house.gov/contact/email-me#.U06uR_ldWVo | 2452 Rayburn House Office Building | http://fincher.house.gov/rss.xml | ||||||
40314 | 40314 | Michael Fitzpatrick F000451 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://fitzpatrick.house.gov | 2400 Rayburn HOB; Washington DC 20515-3808 | 202-225-4276 | 202- 225-9511 | https://fitzpatrick.house.gov/contact-me/email-me | 2400 Rayburn House Office Building | http://fitzpatrick.house.gov/rss.xml |
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);