legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2013-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, party, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41912 | 41912 | Robert Aderholt A000055 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://aderholt.house.gov | 2369 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 2369 Rayburn House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
39678 | 39678 | Robert Andrews A000210 | rep | NJ | 2013-01-03 | 2014-02-18 | Democrat | 1 | http://andrews.house.gov | 2265 Rayburn HOB; Washington DC 20515-3001 | 202-225-6501 | http://andrews.house.gov/contact-me/email-me | 2265 Rayburn House Office Building | http://andrews.house.gov/rss.xml | |||||||
39621 | 39621 | Rodney Alexander A000361 | rep | LA | 2013-01-03 | 2013-09-27 | Republican | 5 | http://alexander.house.gov | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | https://alexander.house.gov/email-me | 316 Cannon House Office Building | http://alexander.house.gov/rss/press-releases-statements.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 | ||||||
43656 | 43656 | Mark Amodei A000369 | rep | NV | 2013-01-03 | 2015-01-03 | Republican | 2 | http://amodei.house.gov | 222 Cannon HOB; Washington DC 20515-2802 | 202-225-6155 | 202-225-5679 | https://amodei.house.gov/contact-us | 222 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||
39748 | 39748 | Spencer Bachus B000013 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 6 | http://bachus.house.gov | 2246 Rayburn HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | https://bachus.house.gov/email-me | 2246 Rayburn House Office Building | http://bachus.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||
40708 | 40708 | Joe Barton B000213 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 6 | http://joebarton.house.gov | 2107 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | https://joebarton.house.gov/contact1/ | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
41953 | 41953 | Sanford Bishop B000490 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://bishop.house.gov | 2429 Rayburn HOB; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | http://bishop.house.gov/contact | 2429 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||
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 | ||||||
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 | ||||||
42007 | 42007 | Kevin Brady B000755 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 8 | http://kevinbrady.house.gov | 301 Cannon HOB; Washington DC 20515-4308 | 202-225-4901 | 202-225-5524 | https://kevinbrady.house.gov/contact-form | 301 Cannon House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||
40265 | 40265 | Corrine Brown B000911 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://corrinebrown.house.gov | 2111 Rayburn HOB; Washington DC 20515-0905 | 202-225-0123 | 202-225-2256 | https://forms.house.gov/corrinebrown/webforms/contact-me.shtml | 2111 Rayburn House Office Building | http://corrinebrown.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
41738 | 41738 | Sherrod Brown B000944 | sen | OH | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.brown.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-2315 | 202-228-6321 | http://www.brown.senate.gov/contact/ | 713 Hart Senate Office Building | senior | http://www.brown.senate.gov/rss/feeds/?type=all& | |||||
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 | ||||||
41924 | 41924 | Tammy Baldwin B001230 | sen | WI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | 202-225-6942 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | |||||
39759 | 39759 | Timothy Bishop B001242 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://timbishop.house.gov | 306 Cannon HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | https://timbishop.house.gov/email-me | 306 Cannon House Office Building | http://timbishop.house.gov/rss/latest-news.xml | ||||||
41963 | 41963 | Marsha Blackburn B001243 | rep | TN | 2013-01-03 | 2015-01-03 | Republican | 7 | http://blackburn.house.gov | 217 Cannon HOB; Washington DC 20515-4207 | 202-225-2811 | 202-225-3004 | https://blackburn.house.gov/contactform/email.htm | 217 Cannon House Office Building | http://blackburn.house.gov/news/rss.aspx | ||||||
39615 | 39615 | Jo Bonner B001244 | rep | AL | 2013-01-03 | 2013-08-02 | Republican | 1 | http://bonner.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://forms.house.gov/bonner/webforms/issue_subscribe.html | 2236 Rayburn House Office Building | http://bonner.house.gov/index.php?format=feed&type=rss | ||||||
40720 | 40720 | Madeleine Bordallo B001245 | rep | GU | 2013-01-03 | 2015-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 | ||||||
42037 | 42037 | Michael Burgess B001248 | rep | TX | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
42055 | 42055 | George Butterfield B001251 | rep | NC | 2013-01-03 | 2015-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/ | ||||||
39753 | 39753 | John Barrow B001252 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://barrow.house.gov | 2202 Rayburn HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | http://barrowforms.house.gov/contact/ | 2202 Rayburn House Office Building | http://barrow.house.gov/rss.xml | ||||||
40253 | 40253 | Charles Boustany B001255 | rep | LA | 2013-01-03 | 2015-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 | ||||||
39737 | 39737 | Michele Bachmann B001256 | rep | MN | 2013-01-03 | 2015-01-03 | Republican | 6 | http://bachmann.house.gov | 2417 Rayburn HOB; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | https://bachmann.house.gov/contact/email-michele | 2417 Rayburn House Office Building | http://bachmann.house.gov/rss.xml | ||||||
41938 | 41938 | Gus Bilirakis B001257 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 12 | http://bilirakis.house.gov | 2313 Rayburn HOB; Washington DC 20515-0912 | 202-225-5755 | 202-225-4085 | https://bilirakis.house.gov/email-congressman-bilirakis/ | 2313 Rayburn House Office Building | http://bilirakis.house.gov/index.php?format=feed&type=rss | ||||||
39763 | 39763 | Bruce Braley B001259 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://braley.house.gov | 2263 Rayburn HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | http://braley.house.gov/contact | 2263 Rayburn House Office Building | http://braley.house.gov/rss.xml | ||||||
42021 | 42021 | Vern Buchanan B001260 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 16 | http://buchanan.house.gov | 2104 Rayburn HOB; Washington DC 20515-0916 | 202-225-5015 | 202-226-0828 | https://buchanan.house.gov/email-me | 2104 Rayburn House Office Building | http://buchanan.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=2 | ||||||
41814 | 41814 | John Barrasso B001261 | sen | WY | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | 202-224-1724 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | junior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
39767 | 39767 | Paul Broun B001262 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://broun.house.gov | 2437 Rayburn HOB; Washington DC 20515-1010 | 202-225-4101 | 202-226-0776 | https://broun.house.gov/forms/writeyourrep/ | 2437 Rayburn House Office Building | http://broun.house.gov/news/rss.aspx | ||||||
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 | ||||||
41927 | 41927 | Karen Bass B001270 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40247 | 40247 | Dan Benishek B001271 | rep | MI | 2013-01-03 | 2015-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 | ||||||
40712 | 40712 | Diane Black B001273 | rep | TN | 2013-01-03 | 2015-01-03 | Republican | 6 | http://black.house.gov | 1531 Longworth HOB; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | https://black.house.gov/contact-me/email-me | 1531 Longworth House Office Building | http://black.house.gov/rss.xml | ||||||
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 | ||||||
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 | ||||||
43662 | 43662 | Suzanne Bonamici B001278 | rep | OR | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
40125 | 40125 | Kerry Bentivolio B001280 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 11 | http://bentivolio.house.gov | 226 Cannon HOB; Washington DC 20515-2211 | 202-225-8171 | https://bentivolio.house.gov/contact/email-me | 226 Cannon House Office Building | http://bentivolio.house.gov/rss.xml | |||||||
43839 | 43839 | Joyce Beatty B001281 | rep | OH | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://beatty.house.gov | 417 Cannon HOB; Washington DC 20515-3503 | 202-225-4324 | https://beattyforms.house.gov/forms/writeyourrep/ | 417 Cannon House Office Building | http://beatty.house.gov/rss.xml | |||||||
43781 | 43781 | Garland Barr B001282 | rep | KY | 2013-01-03 | 2015-01-03 | Republican | 6 | http://barr.house.gov | 1432 Longworth HOB; Washington DC 20515-1706 | 202-225-4706 | https://barr.house.gov/contact/email-me | 1432 Longworth House Office Building | http://barr.house.gov/rss.xml | |||||||
40636 | 40636 | Jim Bridenstine B001283 | rep | OK | 2013-01-03 | 2015-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 | ||||||
41558 | 41558 | Susan Brooks B001284 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 5 | http://susanwbrooks.house.gov | 1505 Longworth HOB; Washington DC 20515-1405 | 202-225-2276 | https://susanwbrooks.house.gov/contact/email-me | 1505 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | |||||||
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 | ||||||
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 | ||||||
43718 | 43718 | Ami Bera B001287 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://bera.house.gov | 1408 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1408 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
42070 | 42070 | Ken Calvert C000059 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 42 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2269 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
39779 | 39779 | Dave Camp C000071 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 4 | http://camp.house.gov | 341 Cannon HOB; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | http://camp.house.gov/contact/ | 341 Cannon House Office Building | http://camp.house.gov/news/rss.aspx | ||||||
41743 | 41743 | Maria Cantwell C000127 | sen | WA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | |||||
41756 | 41756 | Benjamin Cardin C000141 | sen | MD | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cardin.senate.gov | 509 Hart Senate Office Building Washington DC 20510 | 202-224-4524 | 202-224-1651 | http://www.cardin.senate.gov/contact/ | 509 Hart Senate Office Building | senior | http://www.cardin.senate.gov/rss/feeds/?type=all | |||||
41765 | 41765 | Thomas Carper C000174 | sen | DE | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.carper.senate.gov/public | 513 Hart Senate Office Building Washington DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/public/index.cfm/email-senator-carper | 513 Hart Senate Office Building | senior | http://www.carper.senate.gov/public/index.cfm/rss/feed | |||||
42123 | 42123 | Steve Chabot C000266 | rep | OH | 2013-01-03 | 2015-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 | ||||||
39793 | 39793 | Donna Christensen C000380 | rep | VI | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://donnachristensen.house.gov | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | https://donnachristensen.house.gov/contact-me/email-me | 1510 Longworth House Office Building | http://donnachristensen.house.gov/rss.xml | ||||||
42168 | 42168 | James Clyburn C000537 | rep | SC | 2013-01-03 | 2015-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 | ||||||
40145 | 40145 | Howard Coble C000556 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 6 | http://coble.house.gov | 2188 Rayburn HOB; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | http://coble.house.gov/contact/zipcheck.htm | 2188 Rayburn House Office Building | http://coble.house.gov/news/rss.aspx | ||||||
40579 | 40579 | John Conyers C000714 | rep | MI | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://conyers.house.gov | 2426 Rayburn HOB; Washington DC 20515-2213 | 202-225-5126 | 202-225-0072 | https://conyers.house.gov/index.cfm/online-contact-form | 2426 Rayburn House Office Building | http://conyers.house.gov/index.cfm/rss/feed | ||||||
42209 | 42209 | Jim Cooper C000754 | rep | TN | 2013-01-03 | 2015-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 | ||||||
41205 | 41205 | Elijah Cummings C000984 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://cummings.house.gov | 2235 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://cummings.house.gov/contact-me/email-me | 2235 Rayburn House Office Building | http://cummings.house.gov/rss.xml | ||||||
40275 | 40275 | Lois Capps C001036 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40741 | 40741 | Michael Capuano C001037 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40756 | 40756 | Joseph Crowley C001038 | rep | NY | 2013-01-03 | 2015-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 | ||||||
40286 | 40286 | Ander Crenshaw C001045 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://crenshaw.house.gov | 440 Cannon HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/write/crenshaw/email-me.shtml | 440 Cannon House Office Building | |||||||
39685 | 39685 | Eric Cantor C001046 | rep | VA | 2013-01-03 | 2014-08-18 | Republican | 7 | http://cantor.house.gov | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | http://form-cantor.house.gov/index.php | 303 Cannon House Office Building | http://cantor.house.gov/rss.xml | ||||||
42081 | 42081 | Shelley Capito C001047 | rep | WV | 2013-01-03 | 2015-01-03 | Republican | 2 | http://capito.house.gov | 2366 Rayburn HOB; Washington DC 20515-4802 | 202-225-2711 | 202-225-7856 | https://capitoforms.house.gov/email-shelley/ | 2366 Rayburn House Office Building | http://capito.house.gov/common/rss//index.cfm?rss=85 | ||||||
40765 | 40765 | John Culberson C001048 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 7 | http://culberson.house.gov | 2352 Rayburn HOB; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | https://culbersonforms.house.gov/forms/writeyourrep/default.aspx | 2352 Rayburn House Office Building | http://culberson.house.gov/rss/ | ||||||
41305 | 41305 | Wm. Clay C001049 | rep | MO | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://lacyclay.house.gov | 2418 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact-form/ | 2418 Rayburn House Office Building | |||||||
42097 | 42097 | John Carter C001051 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 31 | http://carter.house.gov | 409 Cannon HOB; Washington DC 20515-4331 | 202-225-3864 | 202-225-5886 | https://carter.house.gov/email-john2 | 409 Cannon House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||
42186 | 42186 | Tom Cole C001053 | rep | OK | 2013-01-03 | 2015-01-03 | Republican | 4 | http://cole.house.gov | 2458 Rayburn HOB; Washington DC 20515-3604 | 202-225-6165 | 202-225-3512 | https://coleforms.house.gov/contact/default.aspx | 2458 Rayburn House Office Building | http://cole.house.gov/rss.xml | ||||||
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 | ||||||
42153 | 42153 | Emanuel Cleaver C001061 | rep | MO | 2013-01-03 | 2015-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 | ||||||
41313 | 41313 | K. Conaway C001062 | rep | TX | 2013-01-03 | 2015-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 | |||||||
42248 | 42248 | Henry Cuellar C001063 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 28 | http://cuellar.house.gov | 2431 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2431 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
39784 | 39784 | John Campbell C001064 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 45 | http://www.campbell.house.gov | 2331 Rayburn HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | https://campbell.house.gov/email-me | 2331 Rayburn House Office Building | http://www.campbell.house.gov/rss/press1.xml | ||||||
42110 | 42110 | Kathy Castor C001066 | rep | FL | 2013-01-03 | 2015-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 | ||||||
42144 | 42144 | Yvette Clarke C001067 | rep | NY | 2013-01-03 | 2015-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 | ||||||
42176 | 42176 | Steve Cohen C001068 | rep | TN | 2013-01-03 | 2015-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 | ||||||
42226 | 42226 | Joe Courtney C001069 | rep | CT | 2013-01-03 | 2015-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 | ||||||
41768 | 41768 | Robert Casey C001070 | sen | PA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | 202-228-0604 | https://www.casey.senate.gov/contact/ | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | |||||
40671 | 40671 | Bob Corker C001071 | sen | TN | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.corker.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | 202-228-0566 | https://www.corker.senate.gov/public/index.cfm/emailme | 425 Dirksen Senate Office Building | junior | http://www.corker.senate.gov/public/index.cfm/rss/feed | |||||
42087 | 42087 | André Carson C001072 | rep | IN | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
40544 | 40544 | Jason Chaffetz C001076 | rep | UT | 2013-01-03 | 2015-01-03 | Republican | 3 | http://chaffetz.house.gov | 2464 Rayburn HOB; Washington DC 20515-4403 | 202-225-7751 | 202-225-5629 | https://chaffetz.house.gov/contact-me/email-me | 2464 Rayburn House Office Building | http://chaffetz.house.gov/rss.xml | ||||||
40746 | 40746 | Mike Coffman C001077 | rep | CO | 2013-01-03 | 2015-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 | ||||||
42193 | 42193 | Gerald Connolly C001078 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://connolly.house.gov | 424 Cannon HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 424 Cannon House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
42130 | 42130 | Judy Chu C001080 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 27 | http://chu.house.gov | 1520 Longworth HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 1520 Longworth House Office Building | http://chu.house.gov/rss.xml | ||||||
40278 | 40278 | John Carney C001083 | rep | DE | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
42239 | 42239 | Eric Crawford C001087 | rep | AR | 2013-01-03 | 2015-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 | ||||||
43859 | 43859 | Matthew Cartwright C001090 | rep | PA | 2013-01-03 | 2015-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 | ||||||
43876 | 43876 | Joaquin Castro C001091 | rep | TX | 2013-01-03 | 2015-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 | ||||||
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 | |||||||
41550 | 41550 | Doug Collins C001093 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://dougcollins.house.gov | 513 Cannon HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 513 Cannon House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
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 | |||||||
43701 | 43701 | Tom Cotton C001095 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 4 | http://cotton.house.gov | 415 Cannon HOB; Washington DC 20515-0404 | 202-225-3772 | https://cotton.house.gov/contact/email-me | 415 Cannon House Office Building | http://cotton.house.gov/rss.xml | |||||||
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 | ||||||
43733 | 43733 | Tony Cárdenas C001097 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 29 | http://cardenas.house.gov | 1508 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1508 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43869 | 43869 | Ted Cruz C001098 | sen | TX | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.cruz.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-5922 | 202-228-3398 | https://www.cruz.senate.gov/?p=form&id=16 | 404 Russell Senate Office Building | junior | ||||||
42261 | 42261 | Danny Davis D000096 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.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 | ||||||
42279 | 42279 | Peter DeFazio D000191 | rep | OR | 2013-01-03 | 2015-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 |
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);