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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41914 | 41914 | Robert Aderholt A000055 | rep | AL | 2017-01-03 | 2019-01-03 | Republican | 4 | https://aderholt.house.gov | 235 Cannon House Office Building; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | 235 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | |||||||
41288 | 41288 | Justin Amash A000367 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 3 | https://amash.house.gov | 114 Cannon House Office Building; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | 114 Cannon House Office Building | http://amash.house.gov/rss.xml | |||||||
43658 | 43658 | Mark Amodei A000369 | rep | NV | 2017-01-03 | 2019-01-03 | Republican | 2 | https://amodei.house.gov | 332 Cannon House Office Building; Washington DC 20515-2802 | 202-225-6155 | 202-225-5679 | 332 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | |||||||
43933 | 43933 | Alma Adams A000370 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 12 | https://adams.house.gov | 222 Cannon House Office Building; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | 222 Cannon House Office Building | ||||||||
43957 | 43957 | Pete Aguilar A000371 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth House Office Building; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43985 | 43985 | Rick Allen A000372 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 12 | https://allen.house.gov | 426 Cannon House Office Building; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | 426 Cannon House Office Building | ||||||||
41579 | 41579 | Ralph Abraham A000374 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon House Office Building; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | 417 Cannon House Office Building | ||||||||
44218 | 44218 | Jodey Arrington A000375 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building; Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
40710 | 40710 | Joe Barton B000213 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 6 | https://joebarton.house.gov | 2107 Rayburn House Office Building; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||
42009 | 42009 | Kevin Brady B000755 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building; Washington DC 20515-4308 | 202-225-4901 | 202-225-5524 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | |||||||
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& | |||||
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 | |||||||
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 | |||||
41965 | 41965 | Marsha Blackburn B001243 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 7 | https://blackburn.house.gov | 2266 Rayburn House Office Building; Washington DC 20515-4207 | 202-225-2811 | 202-225-3004 | 2266 Rayburn House Office Building | http://blackburn.house.gov/news/rss.aspx | |||||||
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 | |||||||
42039 | 42039 | Michael Burgess B001248 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 26 | https://burgess.house.gov | 2336 Rayburn House Office Building; Washington DC 20515-4326 | 202-225-7772 | 202-225-2919 | 2336 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | |||||||
41297 | 41297 | Rob Bishop B001250 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 1 | https://robbishop.house.gov | 123 Cannon House Office Building; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | |||||||
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/ | |||||||
41940 | 41940 | Gus Bilirakis B001257 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 12 | https://bilirakis.house.gov | 2112 Rayburn House Office Building; Washington DC 20515-0912 | 202-225-5755 | 202-225-4085 | 2112 Rayburn House Office Building | http://bilirakis.house.gov/index.php?format=feed&type=rss | |||||||
42023 | 42023 | Vern Buchanan B001260 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 16 | https://buchanan.house.gov | 2104 Rayburn House Office Building; Washington DC 20515-0916 | 202-225-5015 | 202-226-0828 | 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 | |||||
40693 | 40693 | Lou Barletta B001269 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 11 | https://barletta.house.gov | 2049 Rayburn House Office Building; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 2049 Rayburn House Office Building | http://barletta.house.gov/common/rss//index.cfm?rss=25 | |||||||
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 | |||||||
40714 | 40714 | Diane Black B001273 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://black.house.gov | 1131 Longworth House Office Building; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | 1131 Longworth House Office Building | http://black.house.gov/rss.xml | |||||||
42015 | 42015 | Mo Brooks B001274 | rep | AL | 2017-01-03 | 2019-01-03 | Republican | 5 | https://brooks.house.gov | 2400 Rayburn House Office Building; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | 2400 Rayburn House Office Building | http://brooks.house.gov/rss/press-releases.xml | |||||||
42029 | 42029 | Larry Bucshon B001275 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 8 | https://bucshon.house.gov | 1005 Longworth House Office Building; Washington DC 20515-1408 | 202-225-4636 | 202-225-3284 | 1005 Longworth House Office Building | http://bucshon.house.gov/rss.xml | |||||||
43664 | 43664 | Suzanne Bonamici B001278 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://bonamici.house.gov | 439 Cannon House Office Building; Washington DC 20515-3701 | 202-225-0855 | 202-225-9497 | 439 Cannon House Office Building | http://bonamici.house.gov/rss.xml | |||||||
43841 | 43841 | Joyce Beatty B001281 | rep | OH | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://beatty.house.gov | 133 Cannon House Office Building; Washington DC 20515-3503 | 202-225-4324 | 202-225-1984 | 133 Cannon House Office Building | http://beatty.house.gov/rss.xml | |||||||
43783 | 43783 | Garland Barr B001282 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 6 | https://barr.house.gov | 1427 Longworth House Office Building; Washington DC 20515-1706 | 202-225-4706 | 1427 Longworth House Office Building | http://barr.house.gov/rss.xml | ||||||||
41560 | 41560 | Susan Brooks B001284 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 5 | https://susanwbrooks.house.gov | 1030 Longworth House Office Building; Washington DC 20515-1405 | 202-225-2276 | 202-225-0016 | 1030 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | |||||||
43730 | 43730 | Julia Brownley B001285 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 1019 Longworth House Office Building; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | |||||||
43778 | 43778 | Cheri Bustos B001286 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://bustos.house.gov | 1009 Longworth House Office Building; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | |||||||
43720 | 43720 | Ami Bera B001287 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://bera.house.gov | 1431 Longworth House Office Building; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | 1431 Longworth House Office Building | http://bera.house.gov/rss.xml | |||||||
41576 | 41576 | Bradley Byrne B001289 | rep | AL | 2017-01-03 | 2019-01-03 | Republican | 1 | https://byrne.house.gov | 119 Cannon House Office Building; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | 119 Cannon House Office Building | ||||||||
41125 | 41125 | David Brat B001290 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://brat.house.gov | 1628 Longworth House Office Building; Washington DC 20515-4607 | 202-225-2815 | 1628 Longworth House Office Building | |||||||||
44045 | 44045 | Brian Babin B001291 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 36 | https://babin.house.gov | 316 Cannon House Office Building; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
44049 | 44049 | Donald Beyer B001292 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | 1119 Longworth House Office Building | ||||||||
41139 | 41139 | Mike Bishop B001293 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 8 | https://mikebishop.house.gov | 428 Cannon House Office Building; Washington DC 20515-2208 | 202-225-4872 | 202-225-5820 | 428 Cannon House Office Building | ||||||||
41133 | 41133 | Rod Blum B001294 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://blum.house.gov | 1108 Longworth House Office Building; Washington DC 20515-1501 | 202-225-2911 | 1108 Longworth House Office Building | |||||||||
43989 | 43989 | Mike Bost B001295 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 12 | https://bost.house.gov | 1440 Longworth House Office Building; Washington DC 20515-1312 | 202-225-5661 | 202-225-0285 | 1440 Longworth House Office Building | ||||||||
44041 | 44041 | Brendan Boyle B001296 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://boyle.house.gov | 1133 Longworth House Office Building; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | 1133 Longworth House Office Building | ||||||||
43969 | 43969 | Ken Buck B001297 | rep | CO | 2017-01-03 | 2019-01-03 | Republican | 4 | https://buck.house.gov | 1130 Longworth House Office Building; Washington DC 20515-0604 | 202-225-4676 | 202-225-5870 | 1130 Longworth House Office Building | ||||||||
44190 | 44190 | Don Bacon B001298 | rep | NE | 2017-01-03 | 2019-01-03 | Republican | 2 | https://bacon.house.gov | 1516 Longworth House Office Building; Washington DC 20515-2702 | 202-225-4155 | 1516 Longworth House Office Building | |||||||||
44163 | 44163 | Jim Banks B001299 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://banks.house.gov | 509 Cannon House Office Building; Washington DC 20515-1403 | 202-225-4436 | 509 Cannon House Office Building | |||||||||
44124 | 44124 | Nanette Barragán B001300 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 44 | https://barragan.house.gov | 1320 Longworth House Office Building; Washington DC 20515-0544 | 202-225-8220 | 1320 Longworth House Office Building | |||||||||
44184 | 44184 | Jack Bergman B001301 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://bergman.house.gov | 414 Cannon House Office Building; Washington DC 20515-2201 | 202-225-4735 | 414 Cannon House Office Building | |||||||||
44112 | 44112 | Andy Biggs B001302 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 5 | https://biggs.house.gov | 1626 Longworth House Office Building; Washington DC 20515-0305 | 202-225-2635 | 1626 Longworth House Office Building | |||||||||
44130 | 44130 | Lisa Blunt Rochester B001303 | rep | DE | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://bluntrochester.house.gov | 1123 Longworth House Office Building; Washington DC 20515-0800 | 202-225-4165 | 1123 Longworth House Office Building | |||||||||
44178 | 44178 | Anthony Brown B001304 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1505 Longworth House Office Building; Washington DC 20515-2004 | 202-225-8699 | 1505 Longworth House Office Building | |||||||||
44187 | 44187 | Ted Budd B001305 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building; Washington DC 20515-3313 | 202-225-4531 | 118 Cannon House Office Building | |||||||||
44257 | 44257 | Troy Balderson B001306 | rep | OH | 2018-09-05 | 2019-01-03 | Republican | 12 | https://balderson.house.gov/ | 1203 Longworth House Office Building; Washington DC 20515-3512 | 202-225-5355 | 1203 Longworth House Office Building | |||||||||
42072 | 42072 | Ken Calvert C000059 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | 2205 Rayburn House Office Building | http://calvert.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 | |||||
42125 | 42125 | Steve Chabot C000266 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 1 | https://chabot.house.gov | 2371 Rayburn House Office Building; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | 2371 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
40767 | 40767 | John Culberson C001048 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 7 | https://culberson.house.gov | 2161 Rayburn House Office Building; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | 2161 Rayburn House Office Building | http://culberson.house.gov/rss/ | |||||||
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 | ||||||||
42099 | 42099 | John Carter C001051 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 31 | https://carter.house.gov | 2110 Rayburn House Office Building; Washington DC 20515-4331 | 202-225-3864 | 202-225-5886 | 2110 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | |||||||
42188 | 42188 | Tom Cole C001053 | rep | OK | 2017-01-03 | 2019-01-03 | Republican | 4 | https://cole.house.gov | 2467 Rayburn House Office Building; Washington DC 20515-3604 | 202-225-6165 | 202-225-3512 | 2467 Rayburn House Office Building | http://cole.house.gov/rss.xml | |||||||
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 | |||||||
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 | |||||||
41315 | 41315 | K. Conaway C001062 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 11 | https://conaway.house.gov | 2430 Rayburn House Office Building; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | 2430 Rayburn House Office Building | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||
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 | |||||||
40748 | 40748 | Mike Coffman C001077 | rep | CO | 2017-01-03 | 2019-01-03 | Republican | 6 | https://coffman.house.gov | 2443 Rayburn House Office Building; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||
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 | |||||||
42241 | 42241 | Eric Crawford C001087 | rep | AR | 2017-01-03 | 2019-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | |||||||
43861 | 43861 | Matthew Cartwright C001090 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://cartwright.house.gov | 1034 Longworth House Office Building; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | 1034 Longworth House Office Building | http://cartwright.house.gov/rss.xml | |||||||
43878 | 43878 | Joaquin Castro C001091 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://castro.house.gov | 1221 Longworth House Office Building; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | 1221 Longworth House Office Building | http://castro.house.gov/rss.xml | |||||||
41194 | 41194 | Chris Collins C001092 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 27 | https://chriscollins.house.gov | 1117 Longworth House Office Building; Washington DC 20515-3227 | 202-225-5265 | 202-225-5910 | 1117 Longworth House Office Building | http://chriscollins.house.gov/rss.xml | |||||||
41552 | 41552 | Doug Collins C001093 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://dougcollins.house.gov | 1504 Longworth House Office Building; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | |||||||
41257 | 41257 | Paul Cook C001094 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://cook.house.gov | 1222 Longworth House Office Building; Washington DC 20515-0508 | 202-225-5861 | 202-225-6498 | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
43810 | 43810 | Kevin Cramer C001096 | rep | ND | 2017-01-03 | 2019-01-03 | Republican | 0 | https://cramer.house.gov | 1717 Longworth House Office Building; Washington DC 20515-3400 | 202-225-2611 | 202-226-0893 | 1717 Longworth House Office Building | http://cramer.house.gov/rss.xml | |||||||
43735 | 43735 | Tony Cárdenas C001097 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://cardenas.house.gov | 1510 Longworth House Office Building; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | 1510 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 | ||||||
43923 | 43923 | Katherine Clark C001101 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://katherineclark.house.gov | 1415 Longworth House Office Building; Washington DC 20515-2105 | 202-225-2836 | 202-226-0092 | 1415 Longworth House Office Building | ||||||||
43973 | 43973 | Earl Carter C001103 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://buddycarter.house.gov | 432 Cannon House Office Building; Washington DC 20515-1001 | 202-225-5831 | 202-226-2269 | 432 Cannon House Office Building | ||||||||
41151 | 41151 | Barbara Comstock C001105 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://comstock.house.gov | 229 Cannon House Office Building; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | 229 Cannon House Office Building | ||||||||
41147 | 41147 | Ryan Costello C001106 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://costello.house.gov | 326 Cannon House Office Building; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 326 Cannon House Office Building | ||||||||
41131 | 41131 | Carlos Curbelo C001107 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 26 | https://curbelo.house.gov | 1404 Longworth House Office Building; Washington DC 20515-0926 | 202-225-2778 | 1404 Longworth House Office Building | |||||||||
44095 | 44095 | James Comer C001108 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 1 | https://comer.house.gov | 1513 Longworth House Office Building; Washington DC 20515-1701 | 202-225-3115 | 1513 Longworth House Office Building | https://comer.house.gov/rss.xml | ||||||||
44227 | 44227 | Liz Cheney C001109 | rep | WY | 2017-01-03 | 2019-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building; Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
44127 | 44127 | J. Correa C001110 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 46 | https://correa.house.gov | 1039 Longworth House Office Building; Washington DC 20515-0546 | 202-225-2965 | 1039 Longworth House Office Building | |||||||||
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 |
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);