legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2019-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, district, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40680 | 40680 | Claire McCaskill M001170 | sen | MO | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.mccaskill.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/contact | 503 Hart Senate Office Building | senior | http://mccaskill.senate.gov/rss/?p=news | |||||
40689 | 40689 | Bill Nelson N000032 | sen | FL | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.billnelson.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | 202-228-2183 | https://www.billnelson.senate.gov/contact-bill | 716 Hart Senate Office Building | senior | ||||||
40722 | 40722 | Madeleine Bordallo B001245 | rep | GU | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://bordallo.house.gov | 2441 Rayburn House Office Building; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | |||||||
40733 | 40733 | Robert Brady B001227 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://brady.house.gov | 2004 Rayburn House Office Building; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | 2004 Rayburn House Office Building | http://brady.house.gov/rss.xml | |||||||
40743 | 40743 | Michael Capuano C001037 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth House Office Building; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | 1414 Longworth House Office Building | ||||||||
40758 | 40758 | Joseph Crowley C001038 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://crowley.house.gov | 1035 Longworth House Office Building; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | 1035 Longworth House Office Building | http://crowley.house.gov/rss.xml | |||||||
40775 | 40775 | Joe Donnelly D000607 | sen | IN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.donnelly.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-4814 | 202-225-6798 | https://www.donnelly.senate.gov/contact/email-joe | 720 Hart Senate Office Building | senior | http://www.donnelly.senate.gov/rss/feeds/?type=all | |||||
40797 | 40797 | Keith Ellison E000288 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://ellison.house.gov | 2263 Rayburn House Office Building; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | |||||||
40846 | 40846 | Gene Green G000410 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://green.house.gov | 2470 Rayburn House Office Building; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | |||||||
40859 | 40859 | Luis Gutiérrez G000535 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://gutierrez.house.gov | 2408 Rayburn House Office Building; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | |||||||
40922 | 40922 | Sander Levin L000263 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://levin.house.gov | 1236 Longworth House Office Building; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | |||||||
40962 | 40962 | Jared Polis P000598 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://polis.house.gov | 1727 Longworth House Office Building; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | 1727 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | |||||||
41076 | 41076 | Niki Tsongas T000465 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://tsongas.house.gov | 1714 Longworth House Office Building; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | |||||||
41082 | 41082 | Timothy Walz W000799 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://walz.house.gov | 2313 Rayburn House Office Building; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | 2313 Rayburn House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | |||||||
41094 | 41094 | Elizabeth Esty E000293 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://esty.house.gov | 221 Cannon House Office Building; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | 221 Cannon House Office Building | http://esty.house.gov/rss.xml | |||||||
41100 | 41100 | John Delaney D000620 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://delaney.house.gov | 1632 Longworth House Office Building; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | |||||||
41106 | 41106 | Richard Nolan N000127 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://nolan.house.gov | 2366 Rayburn House Office Building; Washington DC 20515-2308 | 202-225-6211 | 202-225-0699 | 2366 Rayburn House Office Building | http://nolan.house.gov/rss.xml | |||||||
41110 | 41110 | Heidi Heitkamp H001069 | sen | ND | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heitkamp.senate.gov/public | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | 202-224-7776 | http://www.heitkamp.senate.gov/public/index.cfm/contact | 516 Hart Senate Office Building | junior | http://www.heitkamp.senate.gov/public/index.cfm/rss/feed | |||||
41116 | 41116 | Beto O’Rourke O000170 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://orourke.house.gov | 1330 Longworth House Office Building; Washington DC 20515-4316 | 202-225-4831 | 1330 Longworth House Office Building | http://orourke.house.gov/rss.xml | ||||||||
41157 | 41157 | Colleen Hanabusa H001050 | rep | HI | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://hanabusa.house.gov | 422 Cannon House Office Building; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | 422 Cannon House Office Building | https://hanabusa.house.gov/rss.xml | |||||||
41161 | 41161 | Carol Shea-Porter S001170 | rep | NH | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://shea-porter.house.gov | 1530 Longworth House Office Building; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | |||||||
41163 | 41163 | Ruben Kihuen K000390 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kihuen.house.gov | 313 Cannon House Office Building; Washington DC 20515-2804 | 202-225-9894 | 313 Cannon House Office Building | |||||||||
41168 | 41168 | Brenda Jones J000303 | rep | MI | 2018-11-29 | 2019-01-03 | Democrat | 13 | 2426 Rayburn House Office Building; Washington DC 20515-2213 | 202-225-5126 | 2426 Rayburn House Office Building | ||||||||||
41207 | 41207 | Elijah Cummings C000984 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://cummings.house.gov | 2163 Rayburn House Office Building; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | 2163 Rayburn House Office Building | http://cummings.house.gov/rss.xml | |||||||
41244 | 41244 | John Lewis L000287 | rep | GA | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://johnlewis.house.gov | 343 Cannon House Office Building; Washington DC 20515-1005 | 202-225-3801 | 202-225-0351 | 343 Cannon House Office Building | http://johnlewis.house.gov/rss.xml | |||||||
41307 | 41307 | Wm. Clay C001049 | rep | MO | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | 2428 Rayburn House Office Building | ||||||||
41325 | 41325 | Susan Davis D000598 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | 1214 Longworth House Office Building | ||||||||
41341 | 41341 | Eliot Engel E000179 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://engel.house.gov | 2462 Rayburn House Office Building; Washington DC 20515-3216 | 202-225-2464 | 202-225-5513 | 2462 Rayburn House Office Building | ||||||||
41380 | 41380 | Daniel Lipinski L000563 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://lipinski.house.gov | 2346 Rayburn House Office Building; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | |||||||
41387 | 41387 | David Loebsack L000565 | rep | IA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://loebsack.house.gov | 1527 Longworth House Office Building; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | |||||||
41403 | 41403 | Nita Lowey L000480 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://lowey.house.gov | 2365 Rayburn House Office Building; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | |||||||
41432 | 41432 | Collin Peterson P000258 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://collinpeterson.house.gov | 2204 Rayburn House Office Building; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | |||||||
41480 | 41480 | José Serrano S000248 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 15 | https://serrano.house.gov | 2354 Rayburn House Office Building; Washington DC 20515-3215 | 202-225-4361 | 202-225-6001 | 2354 Rayburn House Office Building | http://serrano.house.gov/rss.xml | |||||||
41528 | 41528 | Peter Visclosky V000108 | rep | IN | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://visclosky.house.gov | 2328 Rayburn House Office Building; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | |||||||
41556 | 41556 | Tulsi Gabbard G000571 | rep | HI | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://gabbard.house.gov | 1433 Longworth House Office Building; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | 1433 Longworth House Office Building | http://gabbard.house.gov/rss.xml | |||||||
41564 | 41564 | Joseph Kennedy K000379 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kennedy.house.gov | 434 Cannon House Office Building; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | 434 Cannon House Office Building | http://kennedy.house.gov/rss.xml | |||||||
41572 | 41572 | Denny Heck H001064 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://dennyheck.house.gov | 2452 Cannon House Office Building; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | 2452 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | |||||||
41614 | 41614 | Cedric Richmond R000588 | rep | LA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://richmond.house.gov | 420 Cannon House Office Building; Washington DC 20515-1802 | 202-225-6636 | 202-225-1988 | 420 Cannon House Office Building | http://richmond.house.gov/rss.xml | |||||||
41626 | 41626 | Marcia Fudge F000455 | rep | OH | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://fudge.house.gov | 2344 Rayburn House Office Building; Washington DC 20515-3511 | 202-225-7032 | 202-225-1339 | 2344 Rayburn House Office Building | http://fudge.house.gov/common/rss//index.cfm?rss=25 | |||||||
41643 | 41643 | Alcee Hastings H000324 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | |||||||
41700 | 41700 | Filemon Vela V000132 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 34 | https://vela.house.gov | 437 Cannon House Office Building; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | |||||||
41717 | 41717 | Charlie Crist C001111 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://crist.house.gov | 427 Cannon House Office Building; Washington DC 20515-0913 | 202-225-5961 | 427 Cannon House Office Building | |||||||||
41724 | 41724 | Theodore Deutch D000610 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 22 | https://teddeutch.house.gov | 2447 Rayburn House Office Building; Washington DC 20515-0922 | 202-225-3001 | 202-225-5974 | 2447 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | |||||||
41727 | 41727 | A. McEachin M001200 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building; Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
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& | |||||
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 | |||||
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 | |||||
41774 | 41774 | Dianne Feinstein F000062 | sen | CA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | 202-228-3954 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | |||||
41777 | 41777 | Amy Klobuchar K000367 | sen | MN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3244 | 202-228-2186 | http://www.klobuchar.senate.gov/public/index.cfm/contact | 302 Hart Senate Office Building | senior | ||||||
41788 | 41788 | Robert Menendez M000639 | sen | NJ | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | 202-228-2197 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | |||||
41805 | 41805 | Debbie Stabenow S000770 | sen | MI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | 202-228-0325 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | |||||
41808 | 41808 | Jon Tester T000464 | sen | MT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | 202-224-8594 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | |||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
41896 | 41896 | Kirsten Gillibrand G000555 | sen | NY | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | 202-228-0282 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | |||||
41902 | 41902 | Joe Manchin M001183 | sen | WV | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | 202-228-0002 | http://www.manchin.senate.gov/public/index.cfm/contact-form | 306 Hart Senate Office Building | senior | http://www.manchin.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
41929 | 41929 | Karen Bass B001270 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 37 | https://bass.house.gov | 2241 Rayburn House Office Building; Washington DC 20515-0537 | 202-225-7084 | 202-225-2422 | 2241 Rayburn House Office Building | http://bass.house.gov/rss.xml | |||||||
41955 | 41955 | Sanford Bishop B000490 | rep | GA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://bishop.house.gov | 2407 Rayburn House Office Building; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | |||||||
41978 | 41978 | Earl Blumenauer B000574 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://blumenauer.house.gov | 1111 Longworth House Office Building; Washington DC 20515-3703 | 202-225-4811 | 202-225-8941 | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | |||||||
42057 | 42057 | George Butterfield B001251 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://butterfield.house.gov | 2080 Rayburn House Office Building; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | 2080 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | |||||||
42089 | 42089 | André Carson C001072 | rep | IN | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://carson.house.gov | 2135 Rayburn House Office Building; Washington DC 20515-1407 | 202-225-4011 | 202-225-5633 | 2135 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | |||||||
42112 | 42112 | Kathy Castor C001066 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://castor.house.gov | 2052 Rayburn House Office Building; Washington DC 20515-0914 | 202-225-3376 | 202-225-5652 | 2052 Rayburn House Office Building | http://castor.house.gov/news/rss.aspx | |||||||
42132 | 42132 | Judy Chu C001080 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | |||||||
42138 | 42138 | David Cicilline C001084 | rep | RI | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://cicilline.house.gov | 2244 Rayburn House Office Building; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | 2244 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | |||||||
42146 | 42146 | Yvette Clarke C001067 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://clarke.house.gov | 2058 Rayburn House Office Building; Washington DC 20515-3209 | 202-225-6231 | 202-226-0112 | 2058 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | |||||||
42155 | 42155 | Emanuel Cleaver C001061 | rep | MO | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | |||||||
42170 | 42170 | James Clyburn C000537 | rep | SC | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://clyburn.house.gov | 242 Cannon House Office Building; Washington DC 20515-4006 | 202-225-3315 | 202-225-2313 | 242 Cannon House Office Building | http://clyburn.house.gov/rss.xml | |||||||
42178 | 42178 | Steve Cohen C001068 | rep | TN | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://cohen.house.gov | 2404 Rayburn House Office Building; Washington DC 20515-4209 | 202-225-3265 | 202-225-5663 | 2404 Rayburn House Office Building | http://cohen.house.gov/rss.xml | |||||||
42195 | 42195 | Gerald Connolly C001078 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | |||||||
42211 | 42211 | Jim Cooper C000754 | rep | TN | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://cooper.house.gov | 1536 Longworth House Office Building; Washington DC 20515-4205 | 202-225-4311 | 202-226-1035 | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | |||||||
42220 | 42220 | Jim Costa C001059 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | |||||||
42228 | 42228 | Joe Courtney C001069 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://courtney.house.gov | 2348 Rayburn House Office Building; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | |||||||
42250 | 42250 | Henry Cuellar C001063 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 28 | https://cuellar.house.gov | 2209 Rayburn House Office Building; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | |||||||
42263 | 42263 | Danny Davis D000096 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | |||||||
42281 | 42281 | Peter DeFazio D000191 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building; Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42294 | 42294 | Diana DeGette D000197 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | |||||||
42310 | 42310 | Rosa DeLauro D000216 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | |||||||
42340 | 42340 | Lloyd Doggett D000399 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 35 | https://doggett.house.gov | 2307 Rayburn House Office Building; Washington DC 20515-4335 | 202-225-4865 | 202-225-3073 | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | |||||||
42354 | 42354 | Michael Doyle D000482 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://doyle.house.gov | 239 Cannon House Office Building; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | |||||||
42375 | 42375 | Anna Eshoo E000215 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 18 | http://eshoo.house.gov | 241 Cannon House Office Building; Washington DC 20515-0518 | 202-225-8104 | 202-225-8890 | 241 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | |||||||
42397 | 42397 | John Garamendi G000559 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://garamendi.house.gov | 2438 Rayburn House Office Building; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | |||||||
42461 | 42461 | Al Green G000553 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building; Washington DC 20515-4309 | 202-225-7508 | 202-225-2947 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | |||||||
42477 | 42477 | Raúl Grijalva G000551 | rep | AZ | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building; Washington DC 20515-0303 | 202-225-2435 | 202-225-1541 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | |||||||
42501 | 42501 | Martin Heinrich H001046 | sen | NM | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | 202-225-4975 | http://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | junior | ||||||
42515 | 42515 | Brian Higgins H001038 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 26 | https://higgins.house.gov | 2459 Rayburn House Office Building; Washington DC 20515-3226 | 202-225-3306 | 202-226-0347 | 2459 Rayburn House Office Building | http://higgins.house.gov/rss.xml | |||||||
42522 | 42522 | James Himes H001047 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | |||||||
42528 | 42528 | Mazie Hirono H001042 | sen | HI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | 202-225-4987 | https://www.hirono.senate.gov/contact | 730 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | |||||
42550 | 42550 | Steny Hoyer H000874 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://hoyer.house.gov | 1705 Longworth House Office Building; Washington DC 20515-2005 | 202-225-4131 | 202-225-4300 | 1705 Longworth House Office Building | http://hoyer.house.gov/index.php?format=feed&type=rss | |||||||
42570 | 42570 | Sheila Jackson Lee J000032 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2187 Rayburn House Office Building; Washington DC 20515-4318 | 202-225-3816 | 202-225-3317 | 2187 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | |||||||
42591 | 42591 | Eddie Johnson J000126 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2468 Rayburn House Office Building; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | |||||||
42599 | 42599 | Henry Johnson J000288 | rep | GA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://hankjohnson.house.gov | 2240 Rayburn House Office Building; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | |||||||
42629 | 42629 | Marcy Kaptur K000009 | rep | OH | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://kaptur.house.gov | 2186 Rayburn House Office Building; Washington DC 20515-3509 | 202-225-4146 | 202-225-7711 | 2186 Rayburn House Office Building | http://kaptur.house.gov/index.php?format=feed&type=rss | |||||||
42635 | 42635 | William Keating K000375 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://keating.house.gov | 2351 Rayburn House Office Building; Washington DC 20515-2109 | 202-225-3111 | 202-225-5658 | 2351 Rayburn House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | |||||||
42654 | 42654 | Ron Kind K000188 | rep | WI | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://kind.house.gov | 1502 Longworth House Office Building; Washington DC 20515-4903 | 202-225-5506 | 202-225-5739 | 1502 Longworth House Office Building | http://kind.house.gov/common/rss/?rss=52 | |||||||
42679 | 42679 | James Langevin L000559 | rep | RI | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://langevin.house.gov | 2077 Rayburn House Office Building; Washington DC 20515-3902 | 202-225-2735 | 202-225-5976 | 2077 Rayburn House Office Building | http://langevin.house.gov/rss.xml | |||||||
42694 | 42694 | Rick Larsen L000560 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://larsen.house.gov | 2113 Rayburn House Office Building; Washington DC 20515-4702 | 202-225-2605 | 202-225-4420 | 2113 Rayburn House Office Building | http://larsen.house.gov/rss.xml | |||||||
42706 | 42706 | John Larson L000557 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | |||||||
42735 | 42735 | Barbara Lee L000551 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://lee.house.gov | 2267 Rayburn House Office Building; Washington DC 20515-0513 | 202-225-2661 | 202-225-9817 | 2267 Rayburn House Office Building | http://lee.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);