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 phone
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, fax, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41890 | 41890 | Mark Warner W000805 | sen | VA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.warner.senate.gov | 475 Russell Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public//index.cfm?p=ContactPage#form_f9db6196-2dc7-4cda-8add-f8435a71318a | 475 Russell Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41845 | 41845 | Richard Durbin D000563 | sen | IL | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | 202-228-0400 | http://www.durbin.senate.gov/public/index.cfm/contact | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | |||||
39722 | 39722 | Mark Pryor P000590 | sen | AR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.pryor.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2353 | 202-228-0908 | http://www.pryor.senate.gov/contact/form | 255 Dirksen Senate Office Building | senior | http://www.pryor.senate.gov/public/index.cfm/rss/feed | |||||
41828 | 41828 | Susan Collins C001035 | sen | ME | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | 202-224-2693 | http://www.collins.senate.gov/public/index.cfm/email | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | |||||
41870 | 41870 | Mitch McConnell M000355 | sen | KY | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.mcconnell.senate.gov | 317 Russell Senate Office Building Washington DC 20510 | 202-224-2541 | 202-224-2499 | http://www.mcconnell.senate.gov/public/index.cfm?p=ContactForm | 317 Russell Senate Office Building | senior | http://www.mcconnell.senate.gov/public/?a=rss.feed | |||||
40128 | 40128 | John Walsh W000818 | sen | MT | 2014-02-11 | 2015-01-03 | 2 | Democrat | appointment | http://www.walsh.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | http://www.walsh.senate.gov/contact.cfm | 511 Hart Senate Office Building | junior | ||||||
42835 | 42835 | Edward Markey M000133 | sen | MA | 2013-07-16 | 2015-01-03 | 2 | Democrat | http://www.markey.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2742 | http://www.markey.senate.gov/contact | 218 Russell Senate Office Building | junior | |||||||
41884 | 41884 | James Risch R000584 | sen | ID | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
41887 | 41887 | Jeanne Shaheen S001181 | sen | NH | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.shaheen.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | http://www.shaheen.senate.gov/contact/ | 520 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41833 | 41833 | John Cornyn C001056 | sen | TX | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | 202-228-2856 | http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | |||||
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 | |||||
43918 | 43918 | Cory Booker B001288 | sen | NJ | 2013-10-31 | 2015-01-03 | 2 | Democrat | http://www.booker.senate.gov | 141 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | http://www.booker.senate.gov/?p=contact | 141 Hart Senate Office Building | junior | |||||||
39703 | 39703 | Thomas Harkin H000206 | sen | IA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.harkin.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | 202-224-9369 | http://www.harkin.senate.gov/contact.cfm | 731 Hart Senate Office Building | junior | http://www.harkin.senate.gov/rss/rss.cfm | |||||
41264 | 41264 | Michael Enzi E000285 | sen | WY | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.enzi.senate.gov | 379A Russell Senate Office Building Washington DC 20510 | 202-224-3424 | 202-228-0359 | http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi | 379a Russell Senate Office Building | senior | http://www.enzi.senate.gov/public/index.cfm/rss/feed | |||||
39692 | 39692 | Saxby Chambliss C000286 | sen | GA | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.chambliss.senate.gov | 416 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | 202-224-0103 | http://www.chambliss.senate.gov/public/index.cfm?p=Email | 416 Russell Senate Office Building | senior | http://www.chambliss.senate.gov/public/index.cfm/rss/feed | |||||
41873 | 41873 | Jeff Merkley M001176 | sen | OR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.merkley.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | 202-228-3997 | http://www.merkley.senate.gov/contact/ | 313 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | |||||
43685 | 43685 | Brian Schatz S001194 | sen | HI | 2012-12-27 | 2015-01-03 | 3 | Democrat | appointment | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | |||||
40527 | 40527 | Jefferson Sessions S001141 | sen | AL | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.sessions.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
40146 | 40146 | Mike Johanns J000291 | sen | NE | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.johanns.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-4224 | 202-228-0436 | http://www.johanns.senate.gov/public/?p=EmailSenatorJohanns | 404 Russell Senate Office Building | senior | http://www.johanns.senate.gov/public/?a=RSS.Feed | |||||
41881 | 41881 | John Reed R000122 | sen | RI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | http://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
41863 | 41863 | James Inhofe I000024 | sen | OK | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | 202-228-0380 | http://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | |||||
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 | |||||
41260 | 41260 | Lamar Alexander A000360 | sen | TN | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.alexander.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4944 | 202-228-3398 | http://www.alexander.senate.gov/public/index.cfm?p=Email | 455 Dirksen Senate Office Building | senior | http://www.alexander.senate.gov/public/?a=rss.feed | |||||
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 | |||||
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 | |||||
40590 | 40590 | Alan Franken F000457 | sen | MN | 2009-07-07 | 2015-01-03 | 2 | Democrat | http://www.franken.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | 202-224-0044 | http://www.franken.senate.gov/?p=email_al | 309 Hart Senate Office Building | junior | http://franken.senate.gov/rss/?p=hot_topic | |||||
39798 | 39798 | Thomas Coburn C000560 | sen | OK | 2011-01-05 | 2015-01-03 | 3 | Republican | http://www.coburn.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-5754 | 202-224-6008 | http://www.coburn.senate.gov/public/?p=ContactForm#form_904650a1-34fd-4705-aec9-87815cbf9cb4 | 172 Russell Senate Office Building | junior | ||||||
39714 | 39714 | Mary Landrieu L000550 | sen | LA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.landrieu.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | 202-224-9735 | http://www.landrieu.senate.gov/?p=contact | 703 Hart Senate Office Building | senior | http://www.landrieu.senate.gov/rss/ | |||||
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 | |||||
39733 | 39733 | Mark Udall U000038 | sen | CO | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.markudall.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-5941 | 202-226-7840 | http://www.markudall.senate.gov/?p=contact_us | 730 Hart Senate Office Building | senior | http://markudall.senate.gov/rss/?p=blog | |||||
41853 | 41853 | Lindsey Graham G000359 | sen | SC | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.lgraham.senate.gov | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | 202-224-3808 | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Contact.EmailSenatorGraham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
43337 | 43337 | Tim Scott S001184 | sen | SC | 2013-01-03 | 2015-01-03 | 3 | Republican | appointment | http://www.scott.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | http://www.scott.senate.gov/contact/email-me | 167 Russell Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | ||||
39720 | 39720 | Carl Levin L000261 | sen | MI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.levin.senate.gov | 269 Russell Senate Office Building Washington DC 20510 | 202-224-6221 | 202-224-1388 | https://www.levin.senate.gov/contact/email/ | 269 Russell Senate Office Building | senior | http://www.levin.senate.gov/rss/feeds/?type=all | |||||
39693 | 39693 | Kay Hagan H001049 | sen | NC | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.hagan.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | 202-228-2563 | http://www.hagan.senate.gov/contact/ | 521 Dirksen Senate Office Building | junior | http://www.hagan.senate.gov/rss | |||||
39727 | 39727 | John Rockefeller R000361 | sen | WV | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.rockefeller.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-6472 | 202-224-7665 | http://www.rockefeller.senate.gov/public/index.cfm/email-jay | 531 Hart Senate Office Building | senior | http://www.rockefeller.senate.gov/public/index.cfm/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 | |||||
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 | ||||||
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 | ||||||
43758 | 43758 | Scott Peters P000608 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 52 | http://scottpeters.house.gov | 2410 Rayburn HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43908 | 43908 | Robin Kelly K000385 | rep | IL | 2013-04-09 | 2015-01-03 | Democrat | 2 | http://robinkelly.house.gov | 2419 Rayburn HOB; Washington DC 20515-1302 | 202-225-0773 | 202-225-4583 | https://robinkelly.house.gov/contact/email-me | 2419 Rayburn House Office Building | http://robinkelly.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 | ||||||
40424 | 40424 | Richard Nugent N000185 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 11 | http://nugent.house.gov | 1727 Longworth HOB; Washington DC 20515-0911 | 202-225-1002 | 202- 226-6559 | https://nugent.house.gov/contact/email-me | 1727 Longworth House Office Building | http://nugent.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 | ||||||
41020 | 41020 | Dennis Ross R000593 | rep | FL | 2013-01-03 | 2015-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 | ||||||
41641 | 41641 | Alcee Hastings H000324 | rep | FL | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
43931 | 43931 | Alma Adams A000370 | rep | NC | 2014-11-12 | 2015-01-03 | Democrat | 12 | http://adams.house.gov/ | 2304 Rayburn HOB; Washington DC 20515-3312 | 202-225-1510 | http://adams.house.gov/contact | 2304 Rayburn House Office Building | ||||||||
40119 | 40119 | Steve Stockman S000937 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 36 | http://stockman.house.gov | 326 Cannon HOB; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | https://stockman.house.gov/contact/email-me | 326 Cannon House Office Building | http://stockman.house.gov/rss.xml | ||||||
42597 | 42597 | Henry Johnson J000288 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://hankjohnson.house.gov | 2240 Rayburn HOB; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | https://hankjohnson.house.gov/contact-me/email-me | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||
43795 | 43795 | Ann Wagner W000812 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 2 | http://wagner.house.gov | 435 Cannon HOB; Washington DC 20515-2502 | 202-225-1621 | https://wagner.house.gov/contact/email-me | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
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 | ||||||
40844 | 40844 | Gene Green G000410 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 29 | http://green.house.gov | 2470 Rayburn HOB; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | https://green.house.gov/contact-me/email-me | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | ||||||
43191 | 43191 | Lucille Roybal-Allard R000486 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 40 | http://roybal-allard.house.gov | 2330 Rayburn HOB; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | http://roybal-allard.house.gov/contact/ | 2330 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||
43138 | 43138 | David Price P000523 | rep | NC | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | https://price.house.gov/contact | 2162 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
42395 | 42395 | John Garamendi G000559 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://garamendi.house.gov | 2438 Rayburn HOB; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | https://garamendi.house.gov/contact-me/email-me | 2438 Rayburn House Office Building | http://garamendi.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 | ||||||
39947 | 39947 | Howard McKeon M000508 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 25 | http://mckeon.house.gov | 2310 Rayburn HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | https://mckeon.house.gov/forms/writeyourrep/default.aspx | 2310 Rayburn House Office Building | http://mckeon.house.gov/news/rss.aspx | ||||||
41107 | 41107 | Robert Pittenger P000606 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 9 | http://pittenger.house.gov | 224 Cannon HOB; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | https://pittenger.house.gov/contact/email-me | 224 Cannon House Office Building | http://pittenger.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 | ||||||
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 | ||||||
42914 | 42914 | Cathy McMorris Rodgers M001159 | rep | WA | 2013-01-03 | 2015-01-03 | Republican | 5 | http://mcmorris.house.gov | 203 Cannon HOB; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | https://mcmorrisforms.house.gov/write-to-cathy1 | 203 Cannon House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | ||||||
40633 | 40633 | Patrick Meehan M001181 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 7 | http://meehan.house.gov | 204 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | https://meehan.house.gov/email-me | 204 Cannon House Office Building | http://meehan.house.gov/rss/latest-news.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 | ||||||
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 | ||||||
41323 | 41323 | Susan Davis D000598 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1526 Longworth House Office Building | |||||||
41111 | 41111 | Keith Rothfus R000598 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 12 | http://rothfus.house.gov | 503 Cannon HOB; Washington DC 20515-3812 | 202-225-2065 | https://rothfus.house.gov/email-keith | 503 Cannon House Office Building | http://rothfus.house.gov/rss.xml | |||||||
42388 | 42388 | Virginia Foxx F000450 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 5 | http://foxx.house.gov | 2350 Rayburn HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | https://foxx.house.gov/forms/writeyourrep/?zip5=&zip4= | 2350 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||
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 | ||||||
39981 | 39981 | George Miller M000725 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://georgemiller.house.gov | 2205 Rayburn HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | https://georgemiller.house.gov/contact-me/email-me | 2205 Rayburn House Office Building | http://georgemiller.house.gov/rss.xml | ||||||
40198 | 40198 | Candice Miller M001150 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 10 | http://candicemiller.house.gov | 320 Cannon HOB; Washington DC 20515-2210 | 202-225-2106 | 202-226-1169 | http://candicemiller.house.gov/contact | 320 Cannon House Office Building | http://candicemiller.house.gov/rss.xml | ||||||
43263 | 43263 | Janice Schakowsky S001145 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://schakowsky.house.gov | 2367 Rayburn HOB; Washington DC 20515-1309 | 202-225-2111 | 202-226-6890 | https://schakowsky.house.gov/write-to-congresswoman-jan-schakowsky | 2367 Rayburn House Office Building | http://schakowsky.house.gov/index.php?format=feed&type=rss | ||||||
42683 | 42683 | James Lankford L000575 | rep | OK | 2013-01-03 | 2015-01-03 | Republican | 5 | http://lankford.house.gov | 228 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | https://lankford.house.gov/contact-me/ | 228 Cannon House Office Building | http://lankford.house.gov/rss.xml | ||||||
42352 | 42352 | Michael Doyle D000482 | rep | PA | 2013-01-03 | 2015-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 | ||||||
40960 | 40960 | Jared Polis P000598 | rep | CO | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://polis.house.gov | 1433 Longworth HOB; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | https://polis.house.gov/forms/writeyourrep/default.aspx | 1433 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | ||||||
41430 | 41430 | Collin Peterson P000258 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2109 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | https://collinpeterson.house.gov/contact-me/email-me | 2109 Rayburn House Office Building | http://collinpeterson.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 | ||||||
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 | ||||||
43580 | 43580 | Maxine Waters W000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 43 | http://waters.house.gov | 2221 Rayburn HOB; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | https://waters.house.gov/contact/contactform.htm | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||
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 | ||||||
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 | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
42704 | 42704 | John Larson L000557 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://www.larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
40380 | 40380 | John Kline K000363 | rep | MN | 2013-01-03 | 2015-01-03 | Republican | 2 | http://kline.house.gov | 2439 Rayburn HOB; Washington DC 20515-2302 | 202-225-2271 | 202-225-2595 | http://kline.house.gov/contact/ | 2439 Rayburn House Office Building | http://kline.house.gov/common/rss/?rss=47 | ||||||
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 | |||||||
40552 | 40552 | Tim Murphy M001151 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 18 | http://murphy.house.gov | 2332 Rayburn HOB; Washington DC 20515-3818 | 202-225-2301 | 202-225-1844 | https://murphy.house.gov/contact-me | 2332 Rayburn House Office Building | http://murphy.house.gov/common/rss/?rss=44 | ||||||
43743 | 43743 | Mark Takano T000472 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 41 | http://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.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 | ||||||
42416 | 42416 | Paul Gosar G000565 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 4 | http://gosar.house.gov | 504 Cannon HOB; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | https://gosar.house.gov/contact-me/email-me | 504 Cannon House Office Building | http://gosar.house.gov/rss.xml | ||||||
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 | ||||||
43548 | 43548 | Nydia Velázquez V000081 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | http://velazquez.house.gov/IMA/issue_subscribe.shtml | 2302 Rayburn House Office Building | |||||||
40948 | 40948 | Stevan Pearce P000588 | rep | NM | 2013-01-03 | 2015-01-03 | Republican | 2 | http://pearce.house.gov | 2432 Rayburn HOB; Washington DC 20515-3102 | 202-225-2365 | https://pearce.house.gov/contact-me/email-me | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | |||||||
43771 | 43771 | Rodney Davis D000619 | rep | IL | 2013-01-03 | 2015-01-03 | Republican | 13 | http://rodneydavis.house.gov | 1740 Longworth HOB; Washington DC 20515-1313 | 202-225-2371 | https://rodneydavisforms.house.gov/contact/ | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | |||||||
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 | |||||||
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 | |||||||
40436 | 40436 | Joseph Pitts P000373 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 16 | http://pitts.house.gov | 420 Cannon HOB; Washington DC 20515-3816 | 202-225-2411 | 202-225-2013 | https://pitts.house.gov/contact-me/legislative-contact-form | 420 Cannon House Office Building | http://pitts.house.gov/rss.xml | ||||||
40986 | 40986 | Dana Rohrabacher R000409 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 48 | http://rohrabacher.house.gov | 2300 Rayburn HOB; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | https://rohrabacher.house.gov/contact/email-me | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | ||||||
41052 | 41052 | Bill Shuster S001154 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://shuster.house.gov | 2209 Rayburn HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://shuster.house.gov/contact-form/ | 2209 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | ||||||
42475 | 42475 | Raúl Grijalva G000551 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://grijalva.house.gov | 1511 Longworth HOB; Washington DC 20515-0303 | 202-225-2435 | 202-225-1541 | https://grijalvaforms.house.gov/email-raul | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||
43605 | 43605 | Joe Wilson W000795 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 2 | http://joewilson.house.gov | 2229 Rayburn HOB; Washington DC 20515-4002 | 202-225-2452 | 202-225-2455 | https://joewilson.house.gov/forms/writeyourrep/default.aspx | 2229 Rayburn House Office Building | http://joewilson.house.gov/news/rss.aspx |
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);