legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2013-01-03 sorted by contact_form
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41912 | 41912 | Robert Aderholt A000055 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://aderholt.house.gov | 2369 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 2369 Rayburn House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
39678 | 39678 | Robert Andrews A000210 | rep | NJ | 2013-01-03 | 2014-02-18 | Democrat | 1 | http://andrews.house.gov | 2265 Rayburn HOB; Washington DC 20515-3001 | 202-225-6501 | http://andrews.house.gov/contact-me/email-me | 2265 Rayburn House Office Building | http://andrews.house.gov/rss.xml | |||||||
39753 | 39753 | John Barrow B001252 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://barrow.house.gov | 2202 Rayburn HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | http://barrowforms.house.gov/contact/ | 2202 Rayburn House Office Building | http://barrow.house.gov/rss.xml | ||||||
40522 | 40522 | Xavier Becerra B000287 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
42574 | 42574 | Bill Johnson J000292 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 6 | http://billjohnson.house.gov | 1710 Longworth HOB; Washington DC 20515-3506 | 202-225-5705 | 202-225-5907 | http://billjohnson.house.gov/contact/default.aspx | 1710 Longworth House Office Building | http://billjohnson.house.gov/constituentservices/opendoorsschedule.htm | ||||||
41953 | 41953 | Sanford Bishop B000490 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://bishop.house.gov | 2429 Rayburn HOB; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | http://bishop.house.gov/contact | 2429 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||
40165 | 40165 | John Boehner B000589 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 8 | http://boehner.house.gov | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 202-225-0704 | http://boehner.house.gov/contact/ | 1011 Longworth House Office Building | http://boehner.house.gov/news/rss.aspx | ||||||
39763 | 39763 | Bruce Braley B001259 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://braley.house.gov | 2263 Rayburn HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | http://braley.house.gov/contact | 2263 Rayburn House Office Building | http://braley.house.gov/rss.xml | ||||||
42482 | 42482 | Brett Guthrie G000558 | rep | KY | 2013-01-03 | 2015-01-03 | Republican | 2 | http://guthrie.house.gov | 308 Cannon HOB; Washington DC 20515-1702 | 202-225-3501 | 202-226-2019 | http://brettguthrieforms.house.gov/contact/ | 308 Cannon House Office Building | http://guthrie.house.gov/common/rss/?rss=24 | ||||||
42037 | 42037 | Michael Burgess B001248 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 26 | http://burgess.house.gov | 2336 Rayburn HOB; Washington DC 20515-4326 | 202-225-7772 | 202-225-2919 | http://burgess.house.gov/contact/356345.htm | 2336 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||
43776 | 43776 | Cheri Bustos B001286 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://bustos.house.gov | 1009 Longworth HOB; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | http://bustos.house.gov/contact | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||
39779 | 39779 | Dave Camp C000071 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 4 | http://camp.house.gov | 341 Cannon HOB; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | http://camp.house.gov/contact/ | 341 Cannon House Office Building | http://camp.house.gov/news/rss.aspx | ||||||
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 | ||||||
42130 | 42130 | Judy Chu C001080 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 27 | http://chu.house.gov | 1520 Longworth HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 1520 Longworth House Office Building | http://chu.house.gov/rss.xml | ||||||
40145 | 40145 | Howard Coble C000556 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 6 | http://coble.house.gov | 2188 Rayburn HOB; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | http://coble.house.gov/contact/zipcheck.htm | 2188 Rayburn House Office Building | http://coble.house.gov/news/rss.aspx | ||||||
42239 | 42239 | Eric Crawford C001087 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 1 | http://crawford.house.gov | 1711 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | http://crawford.house.gov/contact/ | 1711 Longworth House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||
43668 | 43668 | Suzan DelBene D000617 | rep | WA | 2013-01-03 | 2015-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 | ||||||
42314 | 42314 | Scott DesJarlais D000616 | rep | TN | 2013-01-03 | 2015-01-03 | Republican | 4 | http://desjarlais.house.gov | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | http://desjarlais.house.gov/contact/email-me | 413 Cannon House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||
41188 | 41188 | Sean Duffy D000614 | rep | WI | 2013-01-03 | 2015-01-03 | Republican | 7 | http://duffy.house.gov | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 202-225-3240 | http://duffy.house.gov/contact | 1208 Longworth House Office Building | http://duffy.house.gov/rss.xml | ||||||
40795 | 40795 | Keith Ellison E000288 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://ellison.house.gov | 2244 Rayburn HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/contact | 2244 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | ||||||
40124 | 40124 | William Enyart E000292 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://enyart.house.gov | 1722 Longworth HOB; Washington DC 20515-1312 | 202-225-5661 | http://enyart.house.gov/contact | 1722 Longworth House Office Building | http://enyart.house.gov/rss.xml | |||||||
41092 | 41092 | Elizabeth Esty E000293 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://esty.house.gov | 509 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 509 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
40629 | 40629 | Blake Farenthold F000460 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 27 | http://farenthold.house.gov | 117 Cannon HOB; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | http://farentholdforms.house.gov/contact/email.htm | 117 Cannon House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | ||||||
39685 | 39685 | Eric Cantor C001046 | rep | VA | 2013-01-03 | 2014-08-18 | Republican | 7 | http://cantor.house.gov | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | http://form-cantor.house.gov/index.php | 303 Cannon House Office Building | http://cantor.house.gov/rss.xml | ||||||
40123 | 40123 | Joe Garcia G000573 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://garcia.house.gov | 1440 Longworth HOB; Washington DC 20515-0926 | 202-225-2778 | http://garciaforms.house.gov/email-me/ | 1440 Longworth House Office Building | http://garcia.house.gov/rss.xml | |||||||
39961 | 39961 | Gary Miller M001139 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 31 | http://garymiller.house.gov | 2467 Rayburn HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | http://garymiller.house.gov/contact/ | 2467 Rayburn House Office Building | http://garymiller.house.gov/news/rss.aspx | ||||||
40335 | 40335 | Christopher Gibson G000564 | rep | NY | 2013-01-03 | 2015-01-03 | Republican | 19 | http://gibson.house.gov | 1708 Longworth HOB; Washington DC 20515-3219 | 202-225-5614 | 202-225-1168 | http://gibson.house.gov/contact/ | 1708 Longworth House Office Building | http://gibson.house.gov/news/rss.aspx | ||||||
42410 | 42410 | Louie Gohmert G000552 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 1 | http://gohmert.house.gov | 2243 Rayburn HOB; Washington DC 20515-4301 | 202-225-3035 | 202-226-1230 | http://gohmert.house.gov/contact/ | 2243 Rayburn House Office Building | http://gohmert.house.gov/news/rss.aspx | ||||||
40827 | 40827 | Bob Goodlatte G000289 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 6 | http://goodlatte.house.gov | 2309 Rayburn HOB; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | http://goodlatte.house.gov/contacts/new | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | ||||||
40857 | 40857 | Luis Gutiérrez G000535 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://gutierrez.house.gov | 2408 Rayburn HOB; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | http://gutierrezforms.house.gov/contact/ | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | ||||||
42504 | 42504 | Jaime Herrera Beutler H001056 | rep | WA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://herrerabeutler.house.gov | 1130 Longworth HOB; Washington DC 20515-4703 | 202-225-3536 | 202-225-3478 | http://herrerabeutler.house.gov/contact/ | 1130 Longworth House Office Building | http://herrerabeutler.house.gov/news/rss.aspx | ||||||
42513 | 42513 | Brian Higgins H001038 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://higgins.house.gov | 2459 Rayburn HOB; Washington DC 20515-3226 | 202-225-3306 | 202-226-0347 | http://higgins.house.gov/contact/email-brian | 2459 Rayburn House Office Building | http://higgins.house.gov/rss.xml | ||||||
40359 | 40359 | Michael Honda H001034 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
42554 | 42554 | Bill Huizenga H001058 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 2 | http://huizenga.house.gov | 1217 Longworth HOB; Washington DC 20515-2202 | 202-225-4401 | 202-226-0779 | http://huizenga.house.gov/contact/ | 1217 Longworth House Office Building | http://huizenga.house.gov/news/rss.aspx | ||||||
44451 | 44451 | Darrell Issa I000056 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 49 | http://issa.house.gov | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2347 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
42568 | 42568 | Sheila Jackson Lee J000032 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 18 | http://jacksonlee.house.gov | 2160 Rayburn HOB; Washington DC 20515-4318 | 202-225-3816 | 202-225-3317 | http://jacksonlee.house.gov/contact/ | 2160 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||
42607 | 42607 | Jim Jordan J000289 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 4 | http://jordan.house.gov | 1524 Longworth HOB; Washington DC 20515-3504 | 202-225-2676 | 202-226-0577 | http://jordan.house.gov/contact/ | 1524 Longworth House Office Building | http://jordan.house.gov/news/rss.aspx | ||||||
42429 | 42429 | Kay Granger G000377 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 12 | http://kaygranger.house.gov | 1026 Longworth HOB; Washington DC 20515-4312 | 202-225-5071 | 202-225-5683 | http://kaygranger.house.gov/contact-kay/email-me | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||
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 | ||||||
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 | |||||||
41068 | 41068 | Lamar Smith S000583 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 21 | http://lamarsmith.house.gov | 2409 Rayburn HOB; Washington DC 20515-4321 | 202-225-4236 | 202-225-8628 | http://lamarsmith.house.gov/contact/email-lamar | 2409 Rayburn House Office Building | http://lamarsmith.house.gov/news/rss.aspx | ||||||
42692 | 42692 | Rick Larsen L000560 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://larsen.house.gov | 2113 Rayburn HOB; Washington DC 20515-4702 | 202-225-2605 | 202-225-4420 | http://larsen.house.gov/contact-rick/email-rick | 2113 Rayburn House Office Building | http://larsen.house.gov/rss.xml | ||||||
42733 | 42733 | Barbara Lee L000551 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://lee.house.gov | 2267 Rayburn HOB; Washington DC 20515-0513 | 202-225-2661 | 202-225-9817 | http://lee.house.gov/contact-the-office/email-me | 2267 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||
40069 | 40069 | Lee Terry T000459 | rep | NE | 2013-01-03 | 2015-01-03 | Republican | 2 | http://leeterry.house.gov | 2266 Rayburn HOB; Washington DC 20515-2702 | 202-225-4155 | 202-226-5452 | http://leeterry.house.gov/contact/ | 2266 Rayburn House Office Building | http://leeterry.house.gov/index.php?format=feed&type=rss | ||||||
42749 | 42749 | Zoe Lofgren L000397 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 19 | http://lofgren.house.gov | 1401 Longworth HOB; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/contact/ | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||
43748 | 43748 | Alan Lowenthal L000579 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 47 | http://lowenthal.house.gov | 515 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 515 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
40667 | 40667 | Michelle Lujan Grisham L000580 | rep | NM | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://lujangrisham.house.gov | 214 Cannon HOB; Washington DC 20515-3101 | 202-225-6316 | 202-225-4975 | http://lujangrisham.house.gov/contact/email-me/ | 214 Cannon House Office Building | http://lujangrisham.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 | ||||||
42324 | 42324 | Mario Diaz-Balart D000600 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 25 | http://mariodiazbalart.house.gov | 436 Cannon HOB; Washington DC 20515-0925 | 202-225-4211 | 202-225-8576 | http://mariodiazbalart.house.gov/contact-mario/write-rep-diaz-balart | 436 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||
42834 | 42834 | Edward Markey M000133 | rep | MA | 2013-01-03 | 2013-07-15 | Democrat | 5 | http://www.house.gov/markey | 2108 Rayburn HOB; Washington DC 20515-2107 | 202-225-2836 | 202-226-0092 | http://markey.house.gov/index.php?option=com_email_form&Itemid=124 | 2108 Rayburn House Office Building | http://markey.house.gov/rss.xml | ||||||
43674 | 43674 | Thomas Massie M001184 | rep | KY | 2013-01-03 | 2015-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 | ||||||
42899 | 42899 | Patrick McHenry M001156 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 10 | http://mchenry.house.gov | 2334 Rayburn HOB; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | http://mchenry.house.gov/contact/zipauth.htm | 2334 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||
39953 | 39953 | Michael Michaud M001149 | rep | ME | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://michaud.house.gov | 1724 Longworth HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | http://michaud.house.gov/email | 1724 Longworth House Office Building | http://michaud.house.gov/rss.xml | ||||||
43176 | 43176 | Mike Rogers R000575 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://mike-rogers.house.gov | 324 Cannon HOB; Washington DC 20515-0103 | 202-225-3261 | 202-226-8485 | http://mike-rogers.house.gov/contact-mike/email-me | 324 Cannon House Office Building | http://mike-rogers.house.gov/rss.xml | ||||||
40122 | 40122 | Gloria Negrete McLeod N000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 35 | http://negretemcleod.house.gov | 1641 Longworth HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | http://negretemcleod.house.gov/EmailGloria | 1641 Longworth House Office Building | http://negretemcleod.house.gov/rss.xml | ||||||
40936 | 40936 | Kristi Noem N000184 | rep | SD | 2013-01-03 | 2015-01-03 | Republican | 0 | http://noem.house.gov | 1323 Longworth HOB; Washington DC 20515-4100 | 202-225-2801 | 202-225-5823 | http://noem.house.gov/index.cfm/email-kristi | 1323 Longworth House Office Building | http://noem.house.gov/index.cfm/rss/feed | ||||||
39996 | 39996 | William Owens O000169 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 21 | http://owens.house.gov | 405 Cannon HOB; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | http://owens.house.gov/contact/ | 405 Cannon House Office Building | http://owens.house.gov/news/rss.aspx | ||||||
43034 | 43034 | Steven Palazzo P000601 | rep | MS | 2013-01-03 | 2015-01-03 | Republican | 4 | http://palazzo.house.gov | 331 Cannon HOB; Washington DC 20515-2404 | 202-225-5772 | 202-225-7074 | http://palazzo.house.gov/contact/ | 331 Cannon House Office Building | http://palazzo.house.gov/rss.xml | ||||||
40495 | 40495 | Patrick Murphy M001191 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 18 | http://patrickmurphy.house.gov | 1517 Longworth HOB; Washington DC 20515-0918 | 202-225-3026 | 202-225-8398 | http://patrickmurphy.house.gov/contact/ | 1517 Longworth House Office Building | http://patrickmurphy.house.gov/news/rss.aspx | ||||||
43680 | 43680 | Donald Payne P000604 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 10 | http://payne.house.gov | 103 Cannon HOB; Washington DC 20515-3010 | 202-225-3436 | http://payne.house.gov/contact/email-me | 103 Cannon House Office Building | http://payne.house.gov/rss.xml | |||||||
43085 | 43085 | Nancy Pelosi P000197 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://pelosi.house.gov | 235 Cannon HOB; Washington DC 20515-0512 | 202-225-4965 | 202-225-8259 | http://pelosi.house.gov/contact-me/email-me | 235 Cannon House Office Building | http://pelosi.house.gov/atom.xml | ||||||
43854 | 43854 | Scott Perry P000605 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://perry.house.gov | 126 Cannon HOB; Washington DC 20515-3804 | 202-225-5836 | 202-226-1000 | http://perryforms.house.gov/forms/writeyourrep/ | 126 Cannon House Office Building | http://perry.house.gov/rss.xml | ||||||
40026 | 40026 | Thomas Petri P000265 | rep | WI | 2013-01-03 | 2015-01-03 | Republican | 6 | http://petri.house.gov | 2462 Rayburn HOB; Washington DC 20515-4906 | 202-225-2476 | 202-225-2356 | http://petri.house.gov/contact-me/email-me | 2462 Rayburn House Office Building | http://petri.house.gov/rss.xml | ||||||
39656 | 39656 | Trey Radel R000596 | rep | FL | 2013-01-03 | 2014-01-27 | Republican | 19 | http://radel.house.gov | 1123 Longworth HOB; Washington DC 20515-0919 | 202-225-2536 | http://radel.house.gov/contact | 1123 Longworth House Office Building | http://radel.house.gov/news/rss.aspx | |||||||
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 | ||||||
43203 | 43203 | C. Ruppersberger R000576 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://ruppersberger.house.gov | 2416 Rayburn HOB; Washington DC 20515-2002 | 202-225-3061 | 202-225-3094 | http://ruppersberger.house.gov/contact-dutch/email-dutch | 2416 Rayburn House Office Building | http://dutch.house.gov/atom.xml | ||||||
43235 | 43235 | Gregorio Sablan S001177 | rep | MP | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://sablan.house.gov | 423 Cannon HOB; Washington DC 20515-5201 | 202-225-2646 | 202-226-4249 | http://sablan.house.gov/email-me | 423 Cannon House Office Building | http://sablan.house.gov/rss.xml | ||||||
40893 | 40893 | Sam Johnson J000174 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 3 | http://samjohnson.house.gov | 1211 Longworth HOB; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | http://samjohnson.house.gov/contact/ | 1211 Longworth House Office Building | http://samjohnson.house.gov/news/rss.aspx | ||||||
43243 | 43243 | John Sarbanes S001168 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://sarbanes.house.gov | 2444 Rayburn HOB; Washington DC 20515-2003 | 202-225-4016 | 202-225-9219 | http://sarbanes.house.gov/federal.asp | 2444 Rayburn House Office Building | http://sarbanes.house.gov/rss_news.asp | ||||||
40059 | 40059 | Allyson Schwartz S001162 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://schwartz.house.gov | 1227 Longworth HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | http://schwartz.house.gov/serving-you/email-me | 1227 Longworth House Office Building | http://schwartz.house.gov/rss.xml | ||||||
41462 | 41462 | F. Sensenbrenner S000244 | rep | WI | 2013-01-03 | 2015-01-03 | Republican | 5 | http://sensenbrenner.house.gov | 2449 Rayburn HOB; Washington DC 20515-4905 | 202-225-5101 | 202-225-3190 | http://sensenbrenner.house.gov/contact/email.htm | 2449 Rayburn House Office Building | http://sensenbrenner.house.gov/news/rss.aspx | ||||||
43364 | 43364 | Brad Sherman S000344 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 30 | http://bradsherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0530 | 202-225-5911 | 202-225-5879 | http://sherman.house.gov/contact/contact-congressman-sherman-form | 2242 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | ||||||
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 | ||||||
43376 | 43376 | Michael Simpson S001148 | rep | ID | 2013-01-03 | 2015-01-03 | Republican | 2 | http://simpson.house.gov | 2312 Rayburn HOB; Washington DC 20515-1202 | 202-225-5531 | 202-225-8216 | http://simpson.house.gov/contact/ | 2312 Rayburn House Office Building | http://simpson.house.gov/news/rss.aspx | ||||||
40479 | 40479 | Marlin Stutzman S001188 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 3 | http://stutzman.house.gov | 1728 Longworth HOB; Washington DC 20515-1403 | 202-225-4436 | 202-226-9870 | http://stutzman.house.gov/contacts/new | 1728 Longworth House Office Building | http://stutzman.house.gov/press_releases.rss | ||||||
43723 | 43723 | Eric Swalwell S001193 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 15 | http://swalwell.house.gov | 501 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 501 Cannon House Office Building | ||||||||
43228 | 43228 | Tim Ryan R000577 | rep | OH | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://timryan.house.gov | 1421 Longworth HOB; Washington DC 20515-3513 | 202-225-5261 | 202-225-3719 | http://timryanforms.house.gov/contact/ | 1421 Longworth House Office Building | http://timryan.house.gov/rss.xml | ||||||
41248 | 41248 | Tom Graves G000560 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 14 | http://tomgraves.house.gov | 432 Cannon HOB; Washington DC 20515-1014 | 202-225-5211 | 202-225-8272 | http://tomgraves.house.gov/contact/ | 432 Cannon House Office Building | http://tomgraves.house.gov/news/rss.aspx | ||||||
43507 | 43507 | Michael Turner T000463 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 10 | http://turner.house.gov | 2239 Rayburn HOB; Washington DC 20515-3510 | 202-225-6465 | 202-225-6754 | http://turner.house.gov/contact/ | 2239 Rayburn House Office Building | http://turner.house.gov/news/rss.aspx | ||||||
43525 | 43525 | Fred Upton U000031 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 6 | http://upton.house.gov | 2183 Rayburn HOB; Washington DC 20515-2206 | 202-225-3761 | 202-225-4986 | http://upton.house.gov/contact/zipauth.htm | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-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 | ||||||
43535 | 43535 | Chris Van Hollen V000128 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://vanhollen.house.gov | 1707 Longworth HOB; Washington DC 20515-2008 | 202-225-5341 | 202-225-0375 | http://vanhollen.house.gov/contact/ | 1707 Longworth House Office Building | http://vanhollen.house.gov/news/rss.aspx | ||||||
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 | |||||||
41080 | 41080 | Timothy Walz W000799 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://walz.house.gov | 1034 Longworth HOB; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | http://walz.house.gov/contact | 1034 Longworth House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | ||||||
43564 | 43564 | Debbie Wasserman Schultz W000797 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 23 | http://wassermanschultz.house.gov | 118 Cannon HOB; Washington DC 20515-0923 | 202-225-7931 | 202-226-2052 | http://wassermanschultz.house.gov/contact/email-me.shtml | 118 Cannon House Office Building | http://wassermanschultz.house.gov/atom.xml | ||||||
43834 | 43834 | Brad Wenstrup W000815 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 2 | http://wenstrup.house.gov | 1223 Longworth HOB; Washington DC 20515-3502 | 202-225-3164 | http://wenstrup.house.gov/contact/ | 1223 Longworth 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 | |||||
43812 | 43812 | Deb Fischer F000463 | sen | NE | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | 202-228-1325 | http://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.senate.gov/public/index.cfm/rss/feed | |||||
40678 | 40678 | Orrin Hatch H000338 | sen | UT | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.hatch.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-5251 | 202-224-6331 | http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin | 104 Hart Senate Office Building | senior | http://www.hatch.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||
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 | |||||
41091 | 41091 | Dean Heller H001041 | sen | NV | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.heller.senate.gov/public | 324 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | 202-228-6753 | http://www.heller.senate.gov/public/index.cfm/contact-form | 324 Hart Senate Office Building | senior | http://www.heller.senate.gov/public/index.cfm/rss/feed | |||||
40741 | 40741 | Michael Capuano C001037 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
39597 | 39597 | Jo Ann Emerson E000172 | rep | MO | 2013-01-03 | 2013-01-22 | Republican | 8 | http://emerson.house.gov | 2230 Rayburn HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | http://www.house.gov/emerson/contact/ | 2230 Rayburn House Office Building | |||||||
42218 | 42218 | Jim Costa C001059 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 16 | http://costa.house.gov | 1314 Longworth HOB; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||
39853 | 39853 | Phil Gingrey G000550 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 11 | http://gingrey.house.gov | 442 Cannon HOB; Washington DC 20515-1011 | 202-225-2931 | 202-225-2944 | http://www.house.gov/formgingrey/IMA/issue.htm | 442 Cannon House Office Building | http://gingrey.house.gov/news/rss.aspx | ||||||
39655 | 39655 | Melvin Watt W000207 | rep | NC | 2013-01-03 | 2014-01-06 | Democrat | 12 | http://watt.house.gov | 2304 Rayburn HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://www.house.gov/formwatt/IMA/issue_subscribe.htm | 2304 Rayburn House Office Building | http://watt.house.gov/index.php?format=feed&type=rss |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);