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 office
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, rss_url, start (date)
Link | rowid | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office ▼ | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44091 | 44091 | Warren Davidson D000626 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 8 | https://davidson.house.gov | 1004 Longworth House Office Building; Washington DC 20515-3508 | 202-225-6205 | 1004 Longworth House Office Building | |||||||||
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 | |||||||
44224 | 44224 | Mike Gallagher G000579 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 8 | https://gallagher.house.gov | 1007 Longworth House Office Building; Washington DC 20515-4908 | 202-225-5665 | 1007 Longworth House Office Building | |||||||||
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 | |||||||
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 | |||||||
41659 | 41659 | Devin Nunes N000181 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 22 | https://nunes.house.gov | 1013 Longworth House Office Building; Washington DC 20515-0522 | 202-225-2523 | 202-225-3404 | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | |||||||
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 | |||||||
41649 | 41649 | Steve Stivers S001187 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 15 | https://stivers.house.gov | 1022 Longworth House Office Building; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | |||||||
41127 | 41127 | Steve Knight K000387 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth House Office Building; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41224 | 41224 | Mark Meadows M001187 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth House Office Building; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | |||||||
42431 | 42431 | Kay Granger G000377 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 12 | https://kaygranger.house.gov | 1026 Longworth House Office Building; Washington DC 20515-4312 | 202-225-5071 | 202-225-5683 | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | |||||||
43831 | 43831 | Sean Maloney M001185 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 18 | https://seanmaloney.house.gov | 1027 Longworth House Office Building; Washington DC 20515-3218 | 202-225-5441 | 202-225-3289 | 1027 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | |||||||
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 | |||||||||
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 | |||||||
44157 | 44157 | A. Ferguson F000465 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://ferguson.house.gov | 1032 Longworth House Office Building; Washington DC 20515-1003 | 202-225-5901 | 1032 Longworth House Office Building | |||||||||
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 | |||||||
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 | |||||||
43765 | 43765 | Lois Frankel F000462 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 21 | https://frankel.house.gov | 1037 Longworth House Office Building; Washington DC 20515-0921 | 202-225-9890 | 561-998-9048 | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | |||||||
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 | |||||||||
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 | |||||
44099 | 44099 | Dwight Evans E000296 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://evans.house.gov | 1105 Longworth House Office Building; Washington DC 20515-3802 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
42506 | 42506 | Jaime Herrera Beutler H001056 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://herrerabeutler.house.gov | 1107 Longworth House Office Building; Washington DC 20515-4703 | 202-225-3536 | 202-225-3478 | 1107 Longworth House Office Building | http://herrerabeutler.house.gov/news/rss.aspx | |||||||
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 | |||||||||
41568 | 41568 | George Holding H001065 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 2 | https://holding.house.gov | 1110 Longworth House Office Building; Washington DC 20515-3302 | 202-225-3032 | 919-782-4490 | 1110 Longworth House Office Building | http://holding.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 | |||||||
43851 | 43851 | Markwayne Mullin M001190 | rep | OK | 2017-01-03 | 2019-01-03 | Republican | 2 | https://mullin.house.gov | 1113 Longworth House Office Building; Washington DC 20515-3602 | 202-225-2701 | 202-225-3038 | 1113 Longworth House Office Building | http://mullin.house.gov/news/rss.aspx | |||||||
43566 | 43566 | Debbie Wasserman Schultz W000797 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 23 | https://wassermanschultz.house.gov | 1114 Longworth House Office Building; Washington DC 20515-0923 | 202-225-7931 | 202-226-2052 | 1114 Longworth House Office Building | http://wassermanschultz.house.gov/atom.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 | |||||||
43915 | 43915 | Jason Smith S001195 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 8 | https://jasonsmith.house.gov | 1118 Longworth House Office Building; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | 1118 Longworth House Office Building | http://jasonsmith.house.gov/rss.xml | |||||||
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 | ||||||||
43760 | 43760 | Scott Peters P000608 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1122 Longworth House Office Building; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | |||||||
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 | |||||||||
43846 | 43846 | David Joyce J000295 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 14 | https://joyce.house.gov | 1124 Longworth House Office Building; Washington DC 20515-3514 | 202-225-5731 | 202-225-3307 | 1124 Longworth House Office Building | http://joyce.house.gov/rss/press-releases.xml | |||||||
43230 | 43230 | Tim Ryan R000577 | rep | OH | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://timryan.house.gov | 1126 Longworth House Office Building; Washington DC 20515-3513 | 202-225-5261 | 202-225-3719 | 1126 Longworth House Office Building | http://timryan.house.gov/rss.xml | |||||||
40969 | 40969 | David Reichert R000578 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://reichert.house.gov | 1127 Longworth House Office Building; Washington DC 20515-4708 | 202-225-7761 | 202-225-4282 | 1127 Longworth House Office Building | http://reichert.house.gov/rss.xml | |||||||
44215 | 44215 | Vicente Gonzalez G000581 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 15 | https://gonzalez.house.gov | 113 Cannon House Office Building; Washington DC 20515-4315 | 202-225-2531 | 113 Cannon 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 | ||||||||
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 | |||||||
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 | ||||||||
42452 | 42452 | Sam Graves G000546 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building; Washington DC 20515-2506 | 202-225-7041 | 202-225-8221 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | |||||||
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 | |||||||
43953 | 43953 | Mark DeSaulnier D000623 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://desaulnier.house.gov | 115 Cannon House Office Building; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 115 Cannon House Office Building | ||||||||
44005 | 44005 | Debbie Dingell D000624 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 12 | https://debbiedingell.house.gov | 116 Cannon House Office Building; Washington DC 20515-2212 | 202-225-4071 | 202-226-0371 | 116 Cannon House Office Building | ||||||||
44001 | 44001 | John Moolenaar M001194 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 4 | https://moolenaar.house.gov | 117 Cannon House Office Building; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | 117 Cannon 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 | |||||||||
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 | ||||||||
41588 | 41588 | Francis Rooney R000607 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 19 | https://francisrooney.house.gov | 120 Cannon House Office Building; Washington DC 20515-0919 | 202-225-2536 | 202-225-0011 | 120 Cannon House Office Building | ||||||||
43333 | 43333 | Robert Scott S000185 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||||
41113 | 41113 | Keith Rothfus R000598 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth House Office Building; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | |||||||
43856 | 43856 | Scott Perry P000605 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://perry.house.gov | 1207 Longworth House Office Building; Washington DC 20515-3804 | 202-225-5836 | 202-226-1000 | 1207 Longworth House Office Building | http://perry.house.gov/rss.xml | |||||||
41137 | 41137 | Bruce Poliquin P000611 | rep | ME | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poliquin.house.gov | 1208 Longworth House Office Building; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | 1208 Longworth House Office Building | ||||||||
43588 | 43588 | Daniel Webster W000806 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 11 | https://webster.house.gov | 1210 Longworth House Office Building; Washington DC 20515-0911 | 202-225-1002 | 202-225-0999 | 1210 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | |||||||
41167 | 41167 | Karen Handel H001078 | rep | GA | 2017-06-26 | 2019-01-03 | Republican | 6 | https://handel.house.gov | 1211 Longworth House Office Building; Washington DC 20515-1006 | 202-225-4501 | 1211 Longworth House Office Building | |||||||||
44009 | 44009 | Brenda Lawrence L000581 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://lawrence.house.gov | 1213 Longworth House Office Building; Washington DC 20515-2214 | 202-225-5802 | 202-226-2356 | 1213 Longworth House Office Building | ||||||||
41325 | 41325 | Susan Davis D000598 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | 1214 Longworth House Office Building | ||||||||
44061 | 44061 | Glenn Grothman G000576 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 6 | https://grothman.house.gov | 1217 Longworth House Office Building; Washington DC 20515-4906 | 202-225-2476 | 202-225-2356 | 1217 Longworth House Office Building | ||||||||
43949 | 43949 | Ruben Gallego G000574 | rep | AZ | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1218 Longworth House Office Building; Washington DC 20515-0307 | 202-225-4065 | 1218 Longworth House Office Building | |||||||||
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 | |||||||
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 | |||||||
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 | ||||||||
43692 | 43692 | Bill Foster F000454 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://foster.house.gov | 1224 Longworth House Office Building; Washington DC 20515-1311 | 202-225-3515 | 202-225-9420 | 1224 Longworth House Office Building | http://foster.house.gov/rss.xml | |||||||
44236 | 44236 | Jimmy Gomez G000585 | rep | CA | 2017-07-11 | 2019-01-03 | Democrat | 34 | https://gomez.house.gov | 1226 Longworth House Office Building; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | |||||||||
42522 | 42522 | James Himes H001047 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | |||||||
43941 | 43941 | J. Hill H001072 | rep | AR | 2017-01-03 | 2019-01-03 | Republican | 2 | https://hill.house.gov | 1229 Longworth House Office Building; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1229 Longworth House Office Building | ||||||||
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 | |||||||
41097 | 41097 | Luke Messer M001189 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://messer.house.gov | 1230 Longworth House Office Building; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | 1230 Longworth House Office Building | http://messer.house.gov/rss.xml | |||||||
44065 | 44065 | Alexander Mooney M001195 | rep | WV | 2017-01-03 | 2019-01-03 | Republican | 2 | https://mooney.house.gov | 1232 Longworth House Office Building; Washington DC 20515-4802 | 202-225-2711 | 202-225-7856 | 1232 Longworth House Office Building | ||||||||
41045 | 41045 | Paul Ryan R000570 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://paulryan.house.gov | 1233 Longworth House Office Building; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | 1233 Longworth House Office Building | http://paulryan.house.gov/news/rss.aspx | |||||||
40922 | 40922 | Sander Levin L000263 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://levin.house.gov | 1236 Longworth House Office Building; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | |||||||
44145 | 44145 | Stephanie Murphy M001202 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://stephaniemurphy.house.gov | 1237 Longworth House Office Building; Washington DC 20515-0907 | 202-225-4035 | 1237 Longworth House Office Building | |||||||||
43910 | 43910 | Robin Kelly K000385 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://robinkelly.house.gov | 1239 Longworth House Office Building; Washington DC 20515-1302 | 202-225-0773 | 202-225-4583 | 1239 Longworth House Office Building | http://robinkelly.house.gov/rss.xml | |||||||
43481 | 43481 | Glenn Thompson T000467 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://thompson.house.gov | 124 Cannon House Office Building; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | 124 Cannon House Office Building | http://thompson.house.gov/rss.xml | |||||||
43750 | 43750 | Alan Lowenthal L000579 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 47 | https://lowenthal.house.gov | 125 Cannon House Office Building; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | 125 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | |||||||
44109 | 44109 | Tom O’Halleran O000171 | rep | AZ | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://ohalleran.house.gov | 126 Cannon House Office Building; Washington DC 20515-0301 | 202-225-3361 | 126 Cannon House Office Building | |||||||||
40943 | 40943 | Erik Paulsen P000594 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://paulsen.house.gov | 127 Cannon House Office Building; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | 127 Cannon House Office Building | http://paulsen.house.gov/common/rss//?rss=105 | |||||||
41145 | 41145 | Steve Russell R000604 | rep | OK | 2017-01-03 | 2019-01-03 | Republican | 5 | https://russell.house.gov | 128 Cannon House Office Building; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 128 Cannon House Office Building | ||||||||
43725 | 43725 | Eric Swalwell S001193 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 15 | https://swalwell.house.gov | 129 Cannon House Office Building; Washington DC 20515-0515 | 202-225-5065 | 129 Cannon House Office Building | |||||||||
43945 | 43945 | Bruce Westerman W000821 | rep | AR | 2017-01-03 | 2019-01-03 | Republican | 4 | https://westerman.house.gov | 130 Cannon House Office Building; Washington DC 20515-0404 | 202-225-3772 | 130 Cannon House Office Building | |||||||||
41586 | 41586 | Mark Walker W000819 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 6 | https://walker.house.gov | 1305 Longworth House Office Building; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | 1305 Longworth House Office Building | ||||||||
43648 | 43648 | John Yarmuth Y000062 | rep | KY | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://yarmuth.house.gov | 131 Cannon House Office Building; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | 131 Cannon House Office Building | ||||||||
42916 | 42916 | Cathy McMorris Rodgers M001159 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://mcmorris.house.gov | 1314 Longworth House Office Building; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | 1314 Longworth House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | |||||||
43821 | 43821 | Grace Meng M001188 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://meng.house.gov | 1317 Longworth House Office Building; Washington DC 20515-3206 | 202-225-2601 | 202-225-1589 | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | |||||||
44057 | 44057 | Dan Newhouse N000189 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://newhouse.house.gov | 1318 Longworth House Office Building; Washington DC 20515-4704 | 202-225-5816 | 202-225-3251 | 1318 Longworth House Office Building | ||||||||
43740 | 43740 | Raul Ruiz R000599 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth House Office Building; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | |||||||
43682 | 43682 | Donald Payne P000604 | rep | NJ | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://payne.house.gov | 132 Cannon House Office Building; Washington DC 20515-3010 | 202-225-3436 | 202-225-4160 | 132 Cannon House Office Building | http://payne.house.gov/rss.xml | |||||||
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 | |||||||||
43883 | 43883 | Roger Williams W000816 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 25 | https://williams.house.gov | 1323 Longworth House Office Building; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | 1323 Longworth House Office Building | http://williams.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 | |||||||
43788 | 43788 | Angus King K000383 | sen | ME | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | 202-224-1946 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | ||||
41116 | 41116 | Beto O’Rourke O000170 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://orourke.house.gov | 1330 Longworth House Office Building; Washington DC 20515-4316 | 202-225-4831 | 1330 Longworth House Office Building | http://orourke.house.gov/rss.xml | ||||||||
44142 | 44142 | Al Lawson L000586 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://lawson.house.gov | 1337 Longworth House Office Building; Washington DC 20515-0905 | 202-225-0123 | 1337 Longworth House Office Building | |||||||||
44069 | 44069 | Aumua Amata Radewagen R000600 | rep | AS | 2017-01-03 | 2019-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
42965 | 42965 | Christopher Murphy M001169 | sen | CT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | 202-225-5933 | http://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | |||||
43816 | 43816 | Ann Kuster K000382 | rep | NH | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://kuster.house.gov | 137 Cannon House Office Building; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | |||||||
42751 | 42751 | Zoe Lofgren L000397 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth House Office Building; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||||
43715 | 43715 | Jared Huffman H001068 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://huffman.house.gov | 1406 Longworth House Office Building; Washington DC 20515-0502 | 202-225-5161 | 202-225-5163 | 1406 Longworth House Office Building | http://huffman.house.gov/rss.xml | |||||||
43997 | 43997 | Seth Moulton M001196 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://moulton.house.gov | 1408 Longworth House Office Building; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | 1408 Longworth House Office Building | ||||||||
43095 | 43095 | Ed Perlmutter P000593 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://perlmutter.house.gov | 1410 Longworth House Office Building; Washington DC 20515-0607 | 202-225-2645 | 202-225-5278 | 1410 Longworth House Office Building | http://perlmutter.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);