legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2017-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://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 | ||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44443 | 44443 | Cynthia Lummis L000571 | rep | WY | 2015-01-06 | 2017-01-03 | Republican | 0 | http://lummis.house.gov | 2433 Rayburn HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 2433 Rayburn House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
44281 | 44281 | Ann Kirkpatrick K000368 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | 201 Cannon HOB; Washington DC 20515-0301 | 202-225-3361 | 202-225-3462 | https://kirkpatrick.house.gov/contact/email-me | 201 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||
44098 | 44098 | Dwight Evans E000296 | rep | PA | 2016-11-14 | 2017-01-03 | Democrat | 2 | https://evans.house.gov/ | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | https://evans.house.gov/contact/email | 2301 Rayburn House Office Building | https://evans.house.gov/rss.xml | |||||||
44094 | 44094 | James Comer C001108 | rep | KY | 2016-11-14 | 2017-01-03 | Republican | 1 | https://comer.house.gov/ | 2184 Rayburn HOB; Washington DC 20515-1701 | 202-225-3115 | https://comer.house.gov/contact/email | 2184 Rayburn House Office Building | https://comer.house.gov/rss.xml | |||||||
44090 | 44090 | Warren Davidson D000626 | rep | OH | 2016-06-09 | 2017-01-03 | Republican | 8 | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 1011 Longworth House Office Building | ||||||||||
44086 | 44086 | Darin LaHood L000585 | rep | IL | 2015-09-17 | 2017-01-03 | Republican | 18 | https://lahood.house.gov/ | 2464 Rayburn HOB; Washington DC 20515-1318 | 202-225-6201 | https://lahood.house.gov/contact/email | 2464 Rayburn House Office Building | ||||||||
44082 | 44082 | Trent Kelly K000388 | rep | MS | 2015-06-09 | 2017-01-03 | Republican | 1 | https://trentkelly.house.gov | 1427 Longworth HOB; Washington DC 20515-2401 | 202-225-4306 | https://trentkelly.house.gov/contact | 1427 Longworth House Office Building | ||||||||
44068 | 44068 | Aumua Amata Radewagen R000600 | rep | AS | 2015-01-06 | 2017-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth HOB; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
44064 | 44064 | Alexander Mooney M001195 | rep | WV | 2015-01-06 | 2017-01-03 | Republican | 2 | https://mooney.house.gov | 1232 Longworth HOB; Washington DC 20515-4802 | 202-225-2711 | 202-225-7856 | 1232 Longworth House Office Building | ||||||||
44060 | 44060 | Glenn Grothman G000576 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 6 | http://grothman.house.gov | 501 Cannon HOB; Washington DC 20515-4906 | 202-225-2476 | 202-225-2356 | 501 Cannon House Office Building | ||||||||
44056 | 44056 | Dan Newhouse N000189 | rep | WA | 2015-01-06 | 2017-01-03 | Republican | 4 | https://newhouse.house.gov | 1641 Longworth HOB; Washington DC 20515-4704 | 202-225-5816 | 202-225-3251 | 1641 Longworth House Office Building | ||||||||
44052 | 44052 | Stacey Plaskett P000610 | rep | VI | 2015-01-06 | 2017-01-03 | Democrat | 0 | https://plaskett.house.gov | 509 Cannon HOB; Washington DC 20515-5500 | 202-225-1790 | 202-225-5517 | 509 Cannon House Office Building | ||||||||
44048 | 44048 | Donald Beyer B001292 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://beyer.house.gov | 431 Cannon HOB; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | 431 Cannon House Office Building | ||||||||
44044 | 44044 | Brian Babin B001291 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 36 | http://babin.house.gov | 316 Cannon HOB; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
44040 | 44040 | Brendan Boyle B001296 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 13 | https://boyle.house.gov | 118 Cannon HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | 118 Cannon House Office Building | ||||||||
44036 | 44036 | John Katko K000386 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 24 | https://katko.house.gov | 1123 Longworth HOB; Washington DC 20515-3224 | 202-225-3701 | 202-225-4042 | 1123 Longworth House Office Building | ||||||||
44032 | 44032 | Elise Stefanik S001196 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 21 | https://stefanik.house.gov | 512 Cannon HOB; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | 512 Cannon House Office Building | ||||||||
44028 | 44028 | Kathleen Rice R000602 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://kathleenrice.house.gov | 1508 Longworth HOB; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | 1508 Longworth House Office Building | ||||||||
44024 | 44024 | Lee Zeldin Z000017 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 1 | https://zeldin.house.gov | 1517 Longworth HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | 1517 Longworth House Office Building | ||||||||
44020 | 44020 | Bonnie Watson Coleman W000822 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 12 | https://watsoncoleman.house.gov | 126 Cannon HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | 126 Cannon House Office Building | ||||||||
44016 | 44016 | David Rouzer R000603 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 7 | https://rouzer.house.gov | 424 Cannon HOB; Washington DC 20515-3307 | 202-225-2731 | 202-225-5773 | 424 Cannon House Office Building | ||||||||
44012 | 44012 | Tom Emmer E000294 | rep | MN | 2015-01-06 | 2017-01-03 | Republican | 6 | https://emmer.house.gov | 503 Cannon HOB; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | 503 Cannon House Office Building | ||||||||
44008 | 44008 | Brenda Lawrence L000581 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 14 | https://lawrence.house.gov | 1237 Longworth HOB; Washington DC 20515-2214 | 202-225-5802 | 202-226-2356 | 1237 Longworth House Office Building | ||||||||
44004 | 44004 | Debbie Dingell D000624 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 12 | https://debbiedingell.house.gov | 116 Cannon HOB; Washington DC 20515-2212 | 202-225-4071 | 202-226-0371 | 116 Cannon House Office Building | ||||||||
44000 | 44000 | John Moolenaar M001194 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 4 | https://moolenaar.house.gov | 117 Cannon HOB; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | 117 Cannon House Office Building | ||||||||
43996 | 43996 | Seth Moulton M001196 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 6 | https://moulton.house.gov | 1408 Longworth HOB; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | 1408 Longworth House Office Building | ||||||||
43992 | 43992 | Garret Graves G000577 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 6 | https://garretgraves.house.gov | 204 Cannon HOB; Washington DC 20515-1806 | 202-225-3901 | 202-225-7313 | 204 Cannon House Office Building | ||||||||
43988 | 43988 | Mike Bost B001295 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 12 | https://bost.house.gov | 1440 Longworth HOB; Washington DC 20515-1312 | 202-225-5661 | 202-225-0285 | 1440 Longworth House Office Building | ||||||||
43984 | 43984 | Rick Allen A000372 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 12 | http://allen.house.gov | 513 Cannon HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | 513 Cannon House Office Building | ||||||||
43980 | 43980 | Barry Loudermilk L000583 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 11 | http://loudermilk.house.gov | 238 Cannon HOB; Washington DC 20515-1011 | 202-225-2931 | 202-225-2944 | 238 Cannon House Office Building | ||||||||
43976 | 43976 | Jody Hice H001071 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 10 | https://hice.house.gov | 1516 Longworth HOB; Washington DC 20515-1010 | 202-225-4101 | 202-226-0776 | 1516 Longworth House Office Building | ||||||||
43972 | 43972 | Earl Carter C001103 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://buddycarter.house.gov | 432 Cannon HOB; Washington DC 20515-1001 | 202-225-5831 | 202-226-2269 | 432 Cannon House Office Building | ||||||||
43968 | 43968 | Ken Buck B001297 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 4 | https://buck.house.gov | 416 Cannon HOB; Washington DC 20515-0604 | 202-225-4676 | 202-225-5870 | 416 Cannon House Office Building | ||||||||
43964 | 43964 | Norma Torres T000474 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 35 | https://torres.house.gov | 516 Cannon HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | 516 Cannon House Office Building | ||||||||
43960 | 43960 | Ted Lieu L000582 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 33 | https://lieu.house.gov | 415 Cannon HOB; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | 415 Cannon House Office Building | ||||||||
43956 | 43956 | Pete Aguilar A000371 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43952 | 43952 | Mark DeSaulnier D000623 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 11 | https://desaulnier.house.gov | 327 Cannon HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 327 Cannon House Office Building | ||||||||
43948 | 43948 | Ruben Gallego G000574 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1218 Longworth HOB; Washington DC 20515-0307 | 202-225-4065 | 1218 Longworth House Office Building | |||||||||
43944 | 43944 | Bruce Westerman W000821 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 4 | https://westerman.house.gov | 130 Cannon HOB; Washington DC 20515-0404 | 202-225-3772 | 130 Cannon House Office Building | |||||||||
43940 | 43940 | J. Hill H001072 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 2 | https://hill.house.gov | 1229 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1229 Longworth House Office Building | ||||||||
43936 | 43936 | Gary Palmer P000609 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 6 | https://palmer.house.gov | 206 Cannon HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | 206 Cannon House Office Building | ||||||||
43932 | 43932 | Alma Adams A000370 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 12 | http://adams.house.gov | 222 Cannon HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://adams.house.gov/contact | 222 Cannon House Office Building | |||||||
43927 | 43927 | Donald Norcross N000188 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://norcross.house.gov | 1531 Longworth HOB; Washington DC 20515-3001 | 202-225-6501 | 202-225-6583 | http://norcross.house.gov/contact | 1531 Longworth House Office Building | |||||||
43922 | 43922 | Katherine Clark C001101 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 5 | https://katherineclark.house.gov | 1721 Longworth HOB; Washington DC 20515-2105 | 202-225-2836 | 202-226-0092 | https://katherineclark.house.gov/index.cfm/email-me | 1721 Longworth House Office Building | |||||||
43914 | 43914 | Jason Smith S001195 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 8 | http://jasonsmith.house.gov | 1118 Longworth HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | https://jasonsmith.house.gov/contact/email-me | 1118 Longworth House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||
43909 | 43909 | Robin Kelly K000385 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://robinkelly.house.gov | 1239 Longworth HOB; Washington DC 20515-1302 | 202-225-0773 | 202-225-4583 | https://robinkelly.house.gov/contact/email-me | 1239 Longworth House Office Building | http://robinkelly.house.gov/rss.xml | ||||||
43904 | 43904 | Mark Pocan P000607 | rep | WI | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://pocan.house.gov | 313 Cannon HOB; Washington DC 20515-4902 | 202-225-2906 | 202-225-6942 | https://pocan.house.gov/contact/email-me | 313 Cannon House Office Building | http://pocan.house.gov/rss.xml | ||||||
43899 | 43899 | Derek Kilmer K000381 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://kilmer.house.gov | 1520 Longworth HOB; Washington DC 20515-4706 | 202-225-5916 | https://kilmer.house.gov/contact/email-me | 1520 Longworth House Office Building | http://kilmer.house.gov/rss.xml | |||||||
43892 | 43892 | Chris Stewart S001192 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43887 | 43887 | Marc Veasey V000131 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | ||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43877 | 43877 | Joaquin Castro C001091 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://castro.house.gov | 212 Cannon HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | https://castro.house.gov/contact/email-me | 212 Cannon House Office Building | http://castro.house.gov/rss.xml | ||||||
43872 | 43872 | Randy Weber W000814 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
43865 | 43865 | Tom Rice R000597 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 7 | http://rice.house.gov | 223 Cannon HOB; Washington DC 20515-4007 | 202-225-9895 | https://tomriceforms.house.gov/forms/writeyourrep/ | 223 Cannon House Office Building | http://rice.house.gov/rss.xml | |||||||
43860 | 43860 | Matthew Cartwright C001090 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://cartwright.house.gov | 1419 Longworth HOB; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | https://cartwrightforms.house.gov/forms/writeyourrep/ | 1419 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||
43855 | 43855 | Scott Perry P000605 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://perry.house.gov | 1207 Longworth HOB; Washington DC 20515-3804 | 202-225-5836 | 202-226-1000 | http://perryforms.house.gov/forms/writeyourrep/ | 1207 Longworth House Office Building | http://perry.house.gov/rss.xml | ||||||
43850 | 43850 | Markwayne Mullin M001190 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 2 | http://mullin.house.gov | 1113 Longworth HOB; Washington DC 20515-3602 | 202-225-2701 | 202-225-3038 | https://mullin.house.gov/contact/email-me | 1113 Longworth House Office Building | http://mullin.house.gov/rss.xml | ||||||
43845 | 43845 | David Joyce J000295 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 14 | http://joyce.house.gov | 1124 Longworth HOB; Washington DC 20515-3514 | 202-225-5731 | 202-225-3307 | https://joyce.house.gov/email-me | 1124 Longworth House Office Building | http://joyce.house.gov/rss/press-releases.xml | ||||||
43840 | 43840 | Joyce Beatty B001281 | rep | OH | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://beatty.house.gov | 133 Cannon HOB; Washington DC 20515-3503 | 202-225-4324 | 202-225-1984 | https://beattyforms.house.gov/forms/writeyourrep/ | 133 Cannon House Office Building | http://beatty.house.gov/rss.xml | ||||||
43835 | 43835 | Brad Wenstrup W000815 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 2 | http://wenstrup.house.gov | 1318 Longworth HOB; Washington DC 20515-3502 | 202-225-3164 | 202-225-1992 | http://wenstrup.house.gov/contact/ | 1318 Longworth House Office Building | |||||||
43830 | 43830 | Sean Maloney M001185 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://seanmaloney.house.gov | 1529 Longworth HOB; Washington DC 20515-3218 | 202-225-5441 | 202-225-3289 | https://seanmaloney.house.gov/contact/email-me | 1529 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||
43825 | 43825 | Hakeem Jeffries J000294 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://jeffries.house.gov | 1607 Longworth HOB; Washington DC 20515-3208 | 202-225-5936 | https://jeffriesforms.house.gov/contact/ | 1607 Longworth House Office Building | http://jeffries.house.gov/rss.xml | |||||||
43820 | 43820 | Grace Meng M001188 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://meng.house.gov | 1317 Longworth HOB; Washington DC 20515-3206 | 202-225-2601 | 202-225-1589 | https://meng.house.gov/contact/email-me | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | ||||||
43815 | 43815 | Ann Kuster K000382 | rep | NH | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://kuster.house.gov | 137 Cannon HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | https://kuster.house.gov/contact/email-me | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||
43809 | 43809 | Kevin Cramer C001096 | rep | ND | 2015-01-06 | 2017-01-03 | Republican | 0 | http://cramer.house.gov | 1032 Longworth HOB; Washington DC 20515-3400 | 202-225-2611 | 202-226-0893 | https://cramer.house.gov/contact/email-me | 1032 Longworth House Office Building | http://cramer.house.gov/rss.xml | ||||||
43804 | 43804 | Richard Hudson H001067 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 8 | http://hudson.house.gov | 429 Cannon HOB; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | https://hudson.house.gov/email-me | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | ||||||
43796 | 43796 | Ann Wagner W000812 | rep | MO | 2015-01-06 | 2017-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 | |||||||
43791 | 43791 | Daniel Kildee K000380 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://dankildee.house.gov | 227 Cannon HOB; Washington DC 20515-2205 | 202-225-3611 | 202-225-6393 | https://dankildee.house.gov/contact/email-me | 227 Cannon House Office Building | http://dankildee.house.gov/rss.xml | ||||||
43782 | 43782 | Garland Barr B001282 | rep | KY | 2015-01-06 | 2017-01-03 | Republican | 6 | https://barr.house.gov | 1432 Longworth HOB; Washington DC 20515-1706 | 202-225-4706 | https://barr.house.gov/contact/email-me | 1432 Longworth House Office Building | http://barr.house.gov/rss.xml | |||||||
43777 | 43777 | Cheri Bustos B001286 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://bustos.house.gov | 1009 Longworth HOB; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | http://bustos.house.gov/contact | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||
43772 | 43772 | Rodney Davis D000619 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 13 | http://rodneydavis.house.gov | 1740 Longworth HOB; Washington DC 20515-1313 | 202-225-2371 | 217-791-6168 | https://rodneydavisforms.house.gov/contact/ | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | ||||||
43769 | 43769 | Tammy Duckworth D000622 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://duckworth.house.gov | 104 Cannon HOB; Washington DC 20515-1308 | 202-225-3711 | https://duckworth.house.gov/contact/email-me | 104 Cannon House Office Building | http://duckworth.house.gov/rss.xml | |||||||
43764 | 43764 | Lois Frankel F000462 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43759 | 43759 | Scott Peters P000608 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 52 | http://scottpeters.house.gov | 1122 Longworth HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43754 | 43754 | Juan Vargas V000130 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
43749 | 43749 | Alan Lowenthal L000579 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 47 | http://lowenthal.house.gov | 108 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
43744 | 43744 | Mark Takano T000472 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | ||||||
43739 | 43739 | Raul Ruiz R000599 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | ||||||
43734 | 43734 | Tony Cárdenas C001097 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 29 | http://cardenas.house.gov | 1510 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1510 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43729 | 43729 | Julia Brownley B001285 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 26 | http://juliabrownley.house.gov | 1019 Longworth HOB; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | https://juliabrownley.house.gov/contact/email-me | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||
43724 | 43724 | Eric Swalwell S001193 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://swalwell.house.gov | 129 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 129 Cannon House Office Building | ||||||||
43719 | 43719 | Ami Bera B001287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://bera.house.gov | 1535 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1535 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
43714 | 43714 | Jared Huffman H001068 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://huffman.house.gov | 1630 Longworth HOB; Washington DC 20515-0502 | 202-225-5161 | 202-225-5163 | https://huffman.house.gov/contact/email-me | 1630 Longworth House Office Building | http://huffman.house.gov/rss.xml | ||||||
43709 | 43709 | Doug LaMalfa L000578 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://lamalfa.house.gov | 322 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43705 | 43705 | Kyrsten Sinema S001191 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 9 | https://sinema.house.gov | 1530 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1530 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
43697 | 43697 | Dina Titus T000468 | rep | NV | 2015-01-06 | 2017-01-03 | Democrat | 1 | https://titus.house.gov | 401 Cannon HOB; Washington DC 20515-2801 | 202-225-5965 | https://titus.house.gov/contact/email-me | 401 Cannon House Office Building | http://titus.house.gov/rss.xml | |||||||
43691 | 43691 | Bill Foster F000454 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://foster.house.gov | 1224 Longworth HOB; Washington DC 20515-1311 | 202-225-3515 | 202-225-9420 | https://foster.house.gov/contact/email-me | 1224 Longworth House Office Building | http://foster.house.gov/rss.xml | ||||||
43686 | 43686 | Brian Schatz S001194 | sen | HI | 2015-01-06 | 2017-01-03 | 3 | Democrat | 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 | ||||||
43681 | 43681 | Donald Payne P000604 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://payne.house.gov | 103 Cannon HOB; Washington DC 20515-3010 | 202-225-3436 | 202-225-4160 | http://payne.house.gov/contact/email-me | 103 Cannon House Office Building | http://payne.house.gov/rss.xml | ||||||
43675 | 43675 | Thomas Massie M001184 | rep | KY | 2015-01-06 | 2017-01-03 | Republican | 4 | http://massie.house.gov | 314 Cannon HOB; Washington DC 20515-1704 | 202-225-3465 | 202-225-0003 | http://massieforms.house.gov/contact/ | 314 Cannon House Office Building | http://massie.house.gov/rss.xml | ||||||
43669 | 43669 | Suzan DelBene D000617 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://delbene.house.gov | 318 Cannon HOB; Washington DC 20515-4701 | 202-225-6311 | 202-226-1606 | http://delbene.house.gov/contact-me/email-me | 318 Cannon House Office Building | http://delbene.house.gov/rss.xml | ||||||
43663 | 43663 | Suzanne Bonamici B001278 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://bonamici.house.gov | 439 Cannon HOB; Washington DC 20515-3701 | 202-225-0855 | 202-225-9497 | https://bonamici.house.gov/contact-me/email-me | 439 Cannon House Office Building | http://bonamici.house.gov/rss.xml | ||||||
43657 | 43657 | Mark Amodei A000369 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 2 | http://amodei.house.gov | 332 Cannon HOB; Washington DC 20515-2802 | 202-225-6155 | 202-225-5679 | https://amodei.house.gov/contact-us | 332 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||
43653 | 43653 | Todd Young Y000064 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43647 | 43647 | John Yarmuth Y000062 | rep | KY | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://yarmuth.house.gov | 403 Cannon HOB; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | http://yarmuth.house.gov/contact-john2/ | 403 Cannon House Office Building | |||||||
43641 | 43641 | Ron Wyden W000779 | sen | OR | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | http://www.wyden.senate.gov/contact | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
43626 | 43626 | Steve Womack W000809 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.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);