legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,270 rows where state = "PA" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- Republican 1,811
- Democrat 1,015
- Jackson 124
- Whig 105
- Federalist 62
- Anti Masonic 39
- Ind. Republican-Democrat 17
- Adams 13
- Ind. Republican 8
- American 5
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44421 | 44421 | Fred Keller K000395 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | |||||||||
44420 | 44420 | Fred Keller K000395 | rep | PA | 2019-06-03 | 2021-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | |||||||||
44373 | 44373 | Guy Reschenthaler R000610 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://reschenthaler.house.gov | 409 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 409 Cannon House Office Building | |||||||||
44372 | 44372 | Guy Reschenthaler R000610 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 14 | https://reschenthaler.house.gov | 531 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 531 Cannon House Office Building | |||||||||
44371 | 44371 | John Joyce J000302 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 13 | https://johnjoyce.house.gov | 1221 Longworth House Office Building Washington DC 20515-3813 | 202-225-2431 | 1221 Longworth House Office Building | |||||||||
44370 | 44370 | John Joyce J000302 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 13 | https://johnjoyce.house.gov | 1337 Longworth House Office Building Washington DC 20515-3813 | 202-225-2431 | 1337 Longworth House Office Building | |||||||||
44369 | 44369 | Daniel Meuser M001204 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://meuser.house.gov | 414 Cannon House Office Building Washington DC 20515-3809 | 202-225-6511 | 414 Cannon House Office Building | |||||||||
44368 | 44368 | Daniel Meuser M001204 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 9 | https://meuser.house.gov | 326 Cannon House Office Building Washington DC 20515-3809 | 202-225-6511 | 326 Cannon House Office Building | |||||||||
44367 | 44367 | Chrissy Houlahan H001085 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://houlahan.house.gov | 1218 Longworth House Office Building Washington DC 20515-3806 | 202-225-4315 | 1218 Longworth House Office Building | |||||||||
44366 | 44366 | Chrissy Houlahan H001085 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://houlahan.house.gov | 1218 Longworth House Office Building Washington DC 20515-3806 | 202-225-4315 | 1218 Longworth House Office Building | |||||||||
44365 | 44365 | Madeleine Dean D000631 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://dean.house.gov | 120 Cannon House Office Building Washington DC 20515-3804 | 202-225-4731 | 120 Cannon House Office Building | |||||||||
44364 | 44364 | Madeleine Dean D000631 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://dean.house.gov | 129 Cannon House Office Building Washington DC 20515-3804 | 202-225-4731 | 129 Cannon House Office Building | |||||||||
44271 | 44271 | Susan Wild W000826 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://wild.house.gov | 1027 Longworth House Office Building Washington DC 20515-3807 | 202-225-6411 | 1027 Longworth House Office Building | |||||||||
44270 | 44270 | Susan Wild W000826 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://wild.house.gov | 1607 Longworth House Office Building Washington DC 20515-3807 | 202-225-6411 | 1607 Longworth House Office Building | |||||||||
44269 | 44269 | Susan Wild W000826 | rep | PA | 2018-11-27 | 2019-01-03 | Democrat | 15 | https://wild.house.gov | 2082 Rayburn House Office Building; Washington DC 20515-3815 | 202-225-6411 | 2082 Rayburn House Office Building | |||||||||
44268 | 44268 | Mary Scanlon S001205 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://scanlon.house.gov | 1227 Longworth House Office Building Washington DC 20515-3805 | 202-225-2011 | 1227 Longworth House Office Building | |||||||||
44267 | 44267 | Mary Scanlon S001205 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://scanlon.house.gov | 1535 Longworth House Office Building Washington DC 20515-3805 | 202-225-2011 | 1535 Longworth House Office Building | |||||||||
44266 | 44266 | Mary Scanlon S001205 | rep | PA | 2018-11-13 | 2019-01-03 | Democrat | 7 | https://scanlon.house.gov | 2305 Rayburn House Office Building; Washington DC 20515-3807 | 202-225-2011 | 2305 Rayburn House Office Building | |||||||||
44250 | 44250 | Conor Lamb L000588 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://lamb.house.gov | 1224 Longworth House Office Building Washington DC 20515-3817 | 202-225-2301 | 1224 Longworth House Office Building | |||||||||
44249 | 44249 | Conor Lamb L000588 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://lamb.house.gov | 1224 Longworth House Office Building Washington DC 20515-3817 | 202-225-2301 | 1224 Longworth House Office Building | |||||||||
44248 | 44248 | Conor Lamb L000588 | rep | PA | 2018-04-12 | 2019-01-03 | Democrat | 18 | https://lamb.house.gov/ | 2332 Rayburn House Office Building; Washington DC 20515-3818 | 202-225-2301 | 2332 Rayburn House Office Building | |||||||||
44209 | 44209 | Lloyd Smucker S001199 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 11 | https://smucker.house.gov | 302 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 302 Cannon House Office Building | |||||||||
44208 | 44208 | Lloyd Smucker S001199 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 11 | https://smucker.house.gov | 127 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 127 Cannon House Office Building | |||||||||
44207 | 44207 | Lloyd Smucker S001199 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 16 | https://smucker.house.gov | 516 Cannon House Office Building; Washington DC 20515-3816 | 202-225-2411 | 516 Cannon House Office Building | |||||||||
44206 | 44206 | Brian Fitzpatrick F000466 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://fitzpatrick.house.gov | 271 Cannon House Office Building Washington DC 20515-3801 | 202-225-4276 | 271 Cannon House Office Building | |||||||||
44205 | 44205 | Brian Fitzpatrick F000466 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://fitzpatrick.house.gov | 1722 Longworth House Office Building Washington DC 20515-3801 | 202-225-4276 | 1722 Longworth House Office Building | |||||||||
44204 | 44204 | Brian Fitzpatrick F000466 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://fitzpatrick.house.gov | 514 Cannon House Office Building; Washington DC 20515-3808 | 202-225-4276 | 514 Cannon House Office Building | |||||||||
44101 | 44101 | Dwight Evans E000296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
44100 | 44100 | Dwight Evans E000296 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
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 | ||||||||
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 | |||||||
44043 | 44043 | Brendan Boyle B001296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://boyle.house.gov | 1133 Longworth House Office Building Washington DC 20515-3802 | 202-225-6111 | 1133 Longworth House Office Building | |||||||||
44042 | 44042 | Brendan Boyle B001296 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://boyle.house.gov | 1133 Longworth House Office Building Washington DC 20515-3802 | 202-225-6111 | 1133 Longworth House Office Building | |||||||||
44041 | 44041 | Brendan Boyle B001296 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://boyle.house.gov | 1133 Longworth House Office Building; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | 1133 Longworth House Office Building | ||||||||
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 | ||||||||
43863 | 43863 | Matthew Cartwright C001090 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://cartwright.house.gov | 2102 Rayburn House Office Building Washington DC 20515-3808 | 202-225-5546 | 2102 Rayburn House Office Building | http://cartwright.house.gov/rss.xml | ||||||||
43862 | 43862 | Matthew Cartwright C001090 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://cartwright.house.gov | 1034 Longworth House Office Building Washington DC 20515-3808 | 202-225-5546 | 1034 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||||
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 | |||||||
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 | ||||||
43859 | 43859 | Matthew Cartwright C001090 | rep | PA | 2013-01-03 | 2015-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 | ||||||
43858 | 43858 | Scott Perry P000605 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 10 | https://perry.house.gov | 2160 Rayburn House Office Building Washington DC 20515-3810 | 202-225-5836 | 2160 Rayburn House Office Building | http://perry.house.gov/rss.xml | ||||||||
43857 | 43857 | Scott Perry P000605 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 10 | https://perry.house.gov | 1207 Longworth House Office Building Washington DC 20515-3810 | 202-225-5836 | 1207 Longworth House Office Building | http://perry.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 | |||||||
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 | ||||||
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 | ||||||
43501 | 43501 | Patrick Toomey T000461 | sen | PA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.toomey.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | https://www.toomey.senate.gov/?p=contact | 455 Dirksen Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43500 | 43500 | Patrick Toomey T000461 | sen | PA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.toomey.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | http://www.toomey.senate.gov/?p=contact | 248 Russell Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43499 | 43499 | Patrick Toomey T000461 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 15 | http://www.house.gov/toomey | ||||||||||||
43498 | 43498 | Patrick Toomey T000461 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 15 | |||||||||||||
43497 | 43497 | Patrick Toomey T000461 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 15 | |||||||||||||
43483 | 43483 | Glenn Thompson T000467 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 15 | https://thompson.house.gov | 400 Cannon House Office Building Washington DC 20515-3815 | 202-225-5121 | 400 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||||
43482 | 43482 | Glenn Thompson T000467 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 15 | https://thompson.house.gov | 400 Cannon House Office Building Washington DC 20515-3815 | 202-225-5121 | 400 Cannon House Office Building | http://thompson.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 | |||||||
43480 | 43480 | Glenn Thompson T000467 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://thompson.house.gov/contact-me/email-me | 124 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||
43479 | 43479 | Glenn Thompson T000467 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://thompson.house.gov/contact-me/email-me | 124 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||
43478 | 43478 | Glenn Thompson T000467 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://forms.house.gov/thompson/contact-form.shtml | 124 Cannon House Office Building | |||||||
43477 | 43477 | Glenn Thompson T000467 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://thompson.house.gov | ||||||||||||
42643 | 42643 | Mike Kelly K000376 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 16 | https://kelly.house.gov | 1707 Longworth House Office Building Washington DC 20515-3816 | 202-225-5406 | 1707 Longworth House Office Building | http://kelly.house.gov/rss.xml | ||||||||
42642 | 42642 | Mike Kelly K000376 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 16 | https://kelly.house.gov | 1707 Longworth House Office Building Washington DC 20515-3816 | 202-225-5406 | 1707 Longworth House Office Building | http://kelly.house.gov/rss.xml | ||||||||
42641 | 42641 | Mike Kelly K000376 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://kelly.house.gov | 1707 Longworth House Office Building; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | 1707 Longworth House Office Building | http://kelly.house.gov/rss.xml | |||||||
42640 | 42640 | Mike Kelly K000376 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://kelly.house.gov | 1519 Longworth HOB; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | https://kelly.house.gov/contact-me/email-me | 1519 Longworth House Office Building | http://kelly.house.gov/rss.xml | ||||||
42639 | 42639 | Mike Kelly K000376 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://kelly.house.gov | 1519 Longworth HOB; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | https://kelly.house.gov/contact-me/email-me | 1519 Longworth House Office Building | http://kelly.house.gov/rss.xml | ||||||
42638 | 42638 | Mike Kelly K000376 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://kelly.house.gov/ | 515 Cannon HOB; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | 515 Cannon House Office Building | ||||||||
42356 | 42356 | Michael Doyle D000482 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://doyle.house.gov | 270 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 270 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
42355 | 42355 | Michael Doyle D000482 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://doyle.house.gov | 306 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 306 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
42354 | 42354 | Michael Doyle D000482 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://doyle.house.gov | 239 Cannon House Office Building; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | |||||||
42353 | 42353 | Michael Doyle D000482 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://doyle.house.gov | 239 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | https://doyle.house.gov/contact-me/email-me | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||
42352 | 42352 | Michael Doyle D000482 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 14 | http://doyle.house.gov | 239 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | https://doyle.house.gov/contact-me/email-me | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||
42351 | 42351 | Michael Doyle D000482 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://www.house.gov/doyle | 401 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | http://www.house.gov/doyle/email_mike.shtml | 401 Cannon House Office Building | |||||||
42350 | 42350 | Michael Doyle D000482 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42349 | 42349 | Michael Doyle D000482 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42348 | 42348 | Michael Doyle D000482 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42347 | 42347 | Michael Doyle D000482 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42346 | 42346 | Michael Doyle D000482 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
42345 | 42345 | Michael Doyle D000482 | rep | PA | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
42344 | 42344 | Michael Doyle D000482 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
42343 | 42343 | Michael Doyle D000482 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
41769 | 41769 | Robert Casey C001070 | sen | PA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | https://www.casey.senate.gov/contact | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | ||||||
41768 | 41768 | Robert Casey C001070 | sen | PA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | 202-228-0604 | https://www.casey.senate.gov/contact/ | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | |||||
41767 | 41767 | Robert Casey C001070 | sen | PA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://casey.senate.gov/ | 393 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6324 | 202-228-0604 | http://www.casey.senate.gov/contact/ | 393 Russell Senate Office Building | |||||||
41173 | 41173 | Tom Marino M001179 | rep | PA | 2019-01-03 | 2019-01-23 | Republican | 12 | https://marino.house.gov | 1717 Longworth House Office Building; Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | http://marino.house.gov/rss.xml | ||||||||
41172 | 41172 | Tom Marino M001179 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://marino.house.gov | 2242 Rayburn House Office Building; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | 2242 Rayburn House Office Building | http://marino.house.gov/rss.xml | |||||||
41171 | 41171 | Tom Marino M001179 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 10 | http://marino.house.gov | 410 Cannon HOB; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | https://marino.house.gov/contact-me/email-me | 410 Cannon House Office Building | http://marino.house.gov/rss.xml | ||||||
41170 | 41170 | Tom Marino M001179 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://marino.house.gov | 410 Cannon HOB; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | https://marino.house.gov/contact-me/email-me | 410 Cannon House Office Building | http://marino.house.gov/rss.xml | ||||||
41169 | 41169 | Tom Marino M001179 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 10 | http://marino.house.gov/ | 410 Cannon HOB; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | 410 Cannon House Office Building | ||||||||
41147 | 41147 | Ryan Costello C001106 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://costello.house.gov | 326 Cannon House Office Building; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 326 Cannon House Office Building | ||||||||
41146 | 41146 | Ryan Costello C001106 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 6 | https://costello.house.gov | 427 Cannon HOB; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 427 Cannon 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 | |||||||
41112 | 41112 | Keith Rothfus R000598 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth HOB; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | https://rothfus.house.gov/email-keith | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | ||||||
41111 | 41111 | Keith Rothfus R000598 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 12 | http://rothfus.house.gov | 503 Cannon HOB; Washington DC 20515-3812 | 202-225-2065 | https://rothfus.house.gov/email-keith | 503 Cannon House Office Building | http://rothfus.house.gov/rss.xml | |||||||
41054 | 41054 | Bill Shuster S001154 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://shuster.house.gov | 2079 Rayburn House Office Building; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | 2079 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | |||||||
41053 | 41053 | Bill Shuster S001154 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://shuster.house.gov | 2268 Rayburn HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://shuster.house.gov/contact-form/ | 2268 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | ||||||
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 | ||||||
41051 | 41051 | Bill Shuster S001154 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://www.house.gov/shuster | 204 Cannon HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://www.house.gov/shuster/zipauth.htm | 204 Cannon House Office Building | |||||||
41050 | 41050 | Bill Shuster S001154 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 9 | http://www.house.gov/shuster | ||||||||||||
41049 | 41049 | Bill Shuster S001154 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/shuster | ||||||||||||
41048 | 41048 | Bill Shuster S001154 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/shuster | ||||||||||||
41047 | 41047 | Bill Shuster S001154 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/shuster | ||||||||||||
41046 | 41046 | Bill Shuster S001154 | rep | PA | 2001-05-17 | 2003-01-03 | Republican | 9 | |||||||||||||
40733 | 40733 | Robert Brady B001227 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://brady.house.gov | 2004 Rayburn House Office Building; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | 2004 Rayburn House Office Building | http://brady.house.gov/rss.xml |
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);