legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "start" is on date 2017-01-03 sorted by fax
This data as json, copyable, CSV (advanced)
Suggested facets: party, rss_url, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40511 | 40511 | Mike Pompeo P000602 | rep | KS | 2017-01-03 | 2017-01-23 | Republican | 4 | http://pompeo.house.gov | 2452 Rayburn HOB; Washington DC 20515-1604 | 202-225-6216 | 2452 Rayburn House Office Building | http://pompeo.house.gov/news/rss.aspx | ||||||||
40524 | 40524 | Xavier Becerra B000287 | rep | CA | 2017-01-03 | 2017-01-24 | Democrat | 34 | https://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||||
40950 | 40950 | Stevan Pearce P000588 | rep | NM | 2017-01-03 | 2019-01-03 | Republican | 2 | https://pearce.house.gov | 2432 Rayburn House Office Building; Washington DC 20515-3102 | 202-225-2365 | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | ||||||||
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 | ||||||||
41125 | 41125 | David Brat B001290 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://brat.house.gov | 1628 Longworth House Office Building; Washington DC 20515-4607 | 202-225-2815 | 1628 Longworth House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
41135 | 41135 | David Young Y000066 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://davidyoung.house.gov | 240 Cannon House Office Building; Washington DC 20515-1503 | 202-225-5476 | 240 Cannon House Office Building | |||||||||
41141 | 41141 | Dave Trott T000475 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 11 | https://trott.house.gov | 1722 Longworth House Office Building; Washington DC 20515-2211 | 202-225-8171 | 1722 Longworth House Office Building | |||||||||
41153 | 41153 | Daniel Donovan D000625 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 11 | https://donovan.house.gov | 1541 Longworth House Office Building; Washington DC 20515-3211 | 202-225-3371 | 1541 Longworth House Office Building | |||||||||
41162 | 41162 | Jason Lewis L000587 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 2 | https://jasonlewis.house.gov | 418 Cannon House Office Building; Washington DC 20515-2302 | 202-225-2271 | 418 Cannon House Office Building | |||||||||
41163 | 41163 | Ruben Kihuen K000390 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kihuen.house.gov | 313 Cannon House Office Building; Washington DC 20515-2804 | 202-225-9894 | 313 Cannon House Office Building | |||||||||
41165 | 41165 | Scott Taylor T000477 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 2 | https://taylor.house.gov | 412 Cannon House Office Building; Washington DC 20515-4602 | 202-225-4215 | 412 Cannon House Office Building | |||||||||
41166 | 41166 | Thomas Garrett G000580 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://tomgarrett.house.gov | 415 Cannon House Office Building; Washington DC 20515-4605 | 202-225-4711 | 415 Cannon House Office Building | |||||||||
41548 | 41548 | Ted Yoho Y000065 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoho.house.gov | 511 Cannon House Office Building; Washington DC 20515-0903 | 202-225-5744 | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | ||||||||
41582 | 41582 | Will Hurd H001073 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 23 | https://hurd.house.gov | 317 Cannon House Office Building; Washington DC 20515-4323 | 202-225-4511 | 317 Cannon House Office Building | |||||||||
41590 | 41590 | Paul Mitchell M001201 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 10 | https://mitchell.house.gov | 211 Cannon House Office Building; Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | |||||||||
41617 | 41617 | Kamala Harris H001075 | sen | CA | 2017-01-03 | 2021-01-18 | 3 | Democrat | https://www.harris.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.harris.senate.gov/contact | 112 Hart Senate Office Building | junior | |||||||
41717 | 41717 | Charlie Crist C001111 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://crist.house.gov | 427 Cannon House Office Building; Washington DC 20515-0913 | 202-225-5961 | 427 Cannon House Office Building | |||||||||
41727 | 41727 | A. McEachin M001200 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building; Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
42281 | 42281 | Peter DeFazio D000191 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building; Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42685 | 42685 | James Lankford L000575 | sen | OK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lankford.senate.gov | 316 Hart Senate Office Building Washington DC 20510 | 202-224-5754 | https://www.lankford.senate.gov/contact/email | 316 Hart Senate Office Building | junior | |||||||
42739 | 42739 | Mike Lee L000577 | sen | UT | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lee.senate.gov | 363 Russell Senate Office Building Washington DC 20510 | 202-224-5444 | https://www.lee.senate.gov/public/index.cfm/contact | 363 Russell Senate Office Building | senior | http://www.lee.senate.gov/public/index.cfm/rss/feed | ||||||
43118 | 43118 | Robert Portman P000449 | sen | OH | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | https://www.portman.senate.gov/public/index.cfm/contact?p=contact-form | 448 Russell Senate Office Building | junior | http://www.portman.senate.gov/public/index.cfm/rss/feed | ||||||
43698 | 43698 | Dina Titus T000468 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://titus.house.gov | 2464 Rayburn House Office Building; Washington DC 20515-2801 | 202-225-5965 | 2464 Rayburn House Office Building | http://titus.house.gov/rss.xml | ||||||||
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 | |||||||||
43770 | 43770 | Tammy Duckworth D000622 | sen | IL | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.duckworth.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | https://www.duckworth.senate.gov/content/contact-senator | 524 Hart Senate Office Building | junior | |||||||
43783 | 43783 | Garland Barr B001282 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 6 | https://barr.house.gov | 1427 Longworth House Office Building; Washington DC 20515-1706 | 202-225-4706 | 1427 Longworth House Office Building | http://barr.house.gov/rss.xml | ||||||||
43826 | 43826 | Hakeem Jeffries J000294 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://jeffries.house.gov | 1607 Longworth House Office Building; Washington DC 20515-3208 | 202-225-5936 | 1607 Longworth House Office Building | http://jeffries.house.gov/rss.xml | ||||||||
43866 | 43866 | Tom Rice R000597 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 7 | https://rice.house.gov | 223 Cannon House Office Building; Washington DC 20515-4007 | 202-225-9895 | 223 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||||
43900 | 43900 | Derek Kilmer K000381 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://kilmer.house.gov | 1520 Longworth House Office Building; Washington DC 20515-4706 | 202-225-5916 | 1520 Longworth House Office Building | http://kilmer.house.gov/rss.xml | ||||||||
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 | |||||||||
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 | |||||||||
44083 | 44083 | Trent Kelly K000388 | rep | MS | 2017-01-03 | 2019-01-03 | Republican | 1 | https://trentkelly.house.gov | 1721 Longworth House Office Building; Washington DC 20515-2401 | 202-225-4306 | 1721 Longworth House Office Building | |||||||||
44087 | 44087 | Darin LaHood L000585 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 18 | https://lahood.house.gov | 1424 Longworth House Office Building; Washington DC 20515-1318 | 202-225-6201 | 1424 Longworth House Office Building | |||||||||
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 | |||||||||
44095 | 44095 | James Comer C001108 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 1 | https://comer.house.gov | 1513 Longworth House Office Building; Washington DC 20515-1701 | 202-225-3115 | 1513 Longworth House Office Building | https://comer.house.gov/rss.xml | ||||||||
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 | ||||||||
44102 | 44102 | John Kennedy K000393 | sen | LA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.kennedy.senate.gov/public | 416 Russell Senate Office Building Washington DC 20510 | 202-224-4623 | https://www.kennedy.senate.gov/public/email-me | 416 Russell Senate Office Building | junior | |||||||
44103 | 44103 | Margaret Hassan H001076 | sen | NH | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.hassan.senate.gov | 324 Hart Senate Office Building Washington DC 20510 | 202-224-3324 | https://www.hassan.senate.gov/content/contact-senator | 324 Hart Senate Office Building | junior | |||||||
44104 | 44104 | Catherine Cortez Masto C001113 | sen | NV | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.cortezmasto.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | https://www.cortezmasto.senate.gov/contact | 313 Hart Senate Office Building | senior | |||||||
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 | |||||||||
44112 | 44112 | Andy Biggs B001302 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 5 | https://biggs.house.gov | 1626 Longworth House Office Building; Washington DC 20515-0305 | 202-225-2635 | 1626 Longworth House Office Building | |||||||||
44115 | 44115 | Ro Khanna K000389 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://khanna.house.gov | 513 Cannon House Office Building; Washington DC 20515-0517 | 202-225-2631 | 513 Cannon House Office Building | |||||||||
44118 | 44118 | Jimmy Panetta P000613 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://panetta.house.gov | 228 Cannon House Office Building; Washington DC 20515-0520 | 202-225-2861 | 228 Cannon House Office Building | |||||||||
44121 | 44121 | Salud Carbajal C001112 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 24 | https://carbajal.house.gov | 212 Cannon House Office Building; Washington DC 20515-0524 | 202-225-3601 | 212 Cannon House Office Building | |||||||||
44124 | 44124 | Nanette Barragán B001300 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 44 | https://barragan.house.gov | 1320 Longworth House Office Building; Washington DC 20515-0544 | 202-225-8220 | 1320 Longworth House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
44133 | 44133 | Matt Gaetz G000578 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 1 | https://gaetz.house.gov | 507 Cannon House Office Building; Washington DC 20515-0901 | 202-225-4136 | 507 Cannon House Office Building | |||||||||
44136 | 44136 | Neal Dunn D000628 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 2 | https://dunn.house.gov | 423 Cannon House Office Building; Washington DC 20515-0902 | 202-225-5235 | 423 Cannon House Office Building | |||||||||
44139 | 44139 | John Rutherford R000609 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 4 | https://rutherford.house.gov | 230 Cannon House Office Building; Washington DC 20515-0904 | 202-225-2501 | 230 Cannon House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
44148 | 44148 | Darren Soto S001200 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://soto.house.gov | 1429 Longworth House Office Building; Washington DC 20515-0909 | 202-225-9889 | 1429 Longworth House Office Building | |||||||||
44151 | 44151 | Val Demings D000627 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://demings.house.gov | 238 Cannon House Office Building; Washington DC 20515-0910 | 202-225-2176 | 238 Cannon House Office Building | |||||||||
44154 | 44154 | Brian Mast M001199 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 18 | https://mast.house.gov | 2182 Rayburn House Office Building; Washington DC 20515-0918 | 202-225-3026 | 2182 Rayburn House Office Building | |||||||||
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 | |||||||||
44160 | 44160 | Raja Krishnamoorthi K000391 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://krishnamoorthi.house.gov | 515 Cannon House Office Building; Washington DC 20515-1308 | 202-225-3711 | 515 Cannon House Office Building | |||||||||
44163 | 44163 | Jim Banks B001299 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://banks.house.gov | 509 Cannon House Office Building; Washington DC 20515-1403 | 202-225-4436 | 509 Cannon House Office Building | |||||||||
44166 | 44166 | Trey Hollingsworth H001074 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 9 | https://hollingsworth.house.gov | 1641 Longworth House Office Building; Washington DC 20515-1409 | 202-225-5315 | 1641 Longworth House Office Building | |||||||||
44169 | 44169 | Roger Marshall M001198 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 1 | https://marshall.house.gov | 312 Cannon House Office Building; Washington DC 20515-1601 | 202-225-2715 | 312 Cannon House Office Building | |||||||||
44172 | 44172 | Clay Higgins H001077 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://clayhiggins.house.gov | 1711 Longworth House Office Building; Washington DC 20515-1803 | 202-225-2031 | 1711 Longworth House Office Building | |||||||||
44175 | 44175 | Mike Johnson J000299 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://mikejohnson.house.gov | 327 Cannon House Office Building; Washington DC 20515-1804 | 202-225-2777 | 327 Cannon House Office Building | |||||||||
44178 | 44178 | Anthony Brown B001304 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1505 Longworth House Office Building; Washington DC 20515-2004 | 202-225-8699 | 1505 Longworth House Office Building | |||||||||
44181 | 44181 | Jamie Raskin R000606 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://raskin.house.gov | 431 Cannon House Office Building; Washington DC 20515-2008 | 202-225-5341 | 431 Cannon House Office Building | |||||||||
44184 | 44184 | Jack Bergman B001301 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://bergman.house.gov | 414 Cannon House Office Building; Washington DC 20515-2201 | 202-225-4735 | 414 Cannon House Office Building | |||||||||
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 | |||||||||
44190 | 44190 | Don Bacon B001298 | rep | NE | 2017-01-03 | 2019-01-03 | Republican | 2 | https://bacon.house.gov | 1516 Longworth House Office Building; Washington DC 20515-2702 | 202-225-4155 | 1516 Longworth House Office Building | |||||||||
44193 | 44193 | Josh Gottheimer G000583 | rep | NJ | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://gottheimer.house.gov | 213 Cannon House Office Building; Washington DC 20515-3005 | 202-225-4465 | 213 Cannon House Office Building | |||||||||
44196 | 44196 | Jacky Rosen R000608 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://rosen.house.gov | 413 Cannon House Office Building; Washington DC 20515-2803 | 202-225-3252 | 413 Cannon 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 | |||||||||
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 | |||||||||
44210 | 44210 | Jenniffer González-Colón G000582 | rep | PR | 2017-01-03 | 2021-01-03 | Republican | 0 | https://gonzalez-colon.house.gov | 1609 Longworth House Office Building Washington DC 20515-5401 | 202-225-2615 | 1609 Longworth House Office Building | |||||||||
44212 | 44212 | David Kustoff K000392 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 8 | https://kustoff.house.gov | 508 Cannon House Office Building; Washington DC 20515-4208 | 202-225-4714 | 508 Cannon House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
44221 | 44221 | Pramila Jayapal J000298 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://jayapal.house.gov | 319 Cannon House Office Building; Washington DC 20515-4707 | 202-225-3106 | 319 Cannon House Office Building | |||||||||
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 | |||||||||
44227 | 44227 | Liz Cheney C001109 | rep | WY | 2017-01-03 | 2019-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building; Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
42971 | 42971 | Patty Murray M001111 | sen | WA | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.murray.senate.gov | 154 Russell Senate Office Building Washington DC 20510 | 202-224-2621 | 202-224-0238 | https://www.murray.senate.gov/write-to-patty/ | 154 Russell Senate Office Building | senior | http://www.murray.senate.gov/public/?a=rss.feed | |||||
43355 | 43355 | Richard Shelby S000320 | sen | AL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
42724 | 42724 | Patrick Leahy L000174 | sen | VT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
42961 | 42961 | Lisa Murkowski M001153 | sen | AK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | https://www.murkowski.senate.gov/public/index.cfm/contact | 522 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
42443 | 42443 | Charles Grassley G000386 | sen | IA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | https://www.grassley.senate.gov/contact | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
42531 | 42531 | John Hoeven H001061 | sen | ND | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | https://www.hoeven.senate.gov/contact/email-the-senator/form | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed | |||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
43676 | 43676 | Thomas Massie M001184 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 4 | https://massie.house.gov | 2453 Rayburn House Office Building; Washington DC 20515-1704 | 202-225-3465 | 202-225-0003 | 2453 Rayburn House Office Building | http://massie.house.gov/rss.xml | |||||||
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 | ||||||||
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 | |||||||
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 | ||||||||
42997 | 42997 | Grace Napolitano N000179 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 32 | https://napolitano.house.gov | 1610 Longworth House Office Building; Washington DC 20515-0532 | 202-225-5256 | 202-225-0027 | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | |||||||
40581 | 40581 | John Conyers C000714 | rep | MI | 2017-01-03 | 2017-12-05 | Democrat | 13 | https://conyers.house.gov | 2426 Rayburn HOB; Washington DC 20515-2213 | 202-225-5126 | 202-225-0072 | 2426 Rayburn House Office Building | http://conyers.house.gov/index.cfm/rss/feed | |||||||
41411 | 41411 | Kenny Marchant M001158 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 24 | https://marchant.house.gov | 2369 Rayburn House Office Building; Washington DC 20515-4324 | 202-225-6605 | 202-225-0074 | 2369 Rayburn House Office Building | http://marchant.house.gov/news/rss.aspx | |||||||
42467 | 42467 | H. Griffith G000568 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx | |||||||
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 | |||||||
43302 | 43302 | David Schweikert S001183 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 6 | https://schweikert.house.gov | 2059 Rayburn House Office Building; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | 2059 Rayburn House Office Building | http://schweikert.house.gov/rss/press-releases.xml | |||||||
41572 | 41572 | Denny Heck H001064 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://dennyheck.house.gov | 2452 Cannon House Office Building; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | 2452 Cannon House Office Building | http://dennyheck.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);