legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,731 rows where state = "TX" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44545 | 44545 | Mayra Flores F000473 | rep | TX | 2022-06-21 | 2023-01-03 | Republican | 34 | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | ||||||||||
44540 | 44540 | Jake Ellzey E000071 | rep | TX | 2021-07-30 | 2023-01-03 | Republican | 6 | https://ellzey.house.gov | 1725 Longworth House Office Building Washington DC 20515-4306 | 202-225-2002 | 1725 Longworth House Office Building | |||||||||
44525 | 44525 | Beth Van Duyne V000134 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 24 | https://vanduyne.house.gov | 1337 Longworth House Office Building Washington DC 20515-4324 | 202-225-6605 | 1337 Longworth House Office Building | |||||||||
44524 | 44524 | Ernest Gonzales G000594 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 23 | https://gonzales.house.gov | 1009 Longworth House Office Building Washington DC 20515-4323 | 202-225-4511 | 1009 Longworth House Office Building | |||||||||
44523 | 44523 | Troy Nehls N000026 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 22 | https://nehls.house.gov | 1104 Longworth House Office Building Washington DC 20515-4322 | 202-225-5951 | 1104 Longworth House Office Building | |||||||||
44522 | 44522 | Ronny Jackson J000304 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 13 | https://jackson.house.gov | 118 Cannon House Office Building Washington DC 20515-4313 | 202-225-3706 | 118 Cannon House Office Building | |||||||||
44521 | 44521 | August Pfluger P000048 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 11 | https://pfluger.house.gov | 1531 Longworth House Office Building Washington DC 20515-4311 | 202-225-3605 | 1531 Longworth House Office Building | |||||||||
44520 | 44520 | Patrick Fallon F000246 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 4 | https://fallon.house.gov | 1118 Longworth House Office Building Washington DC 20515-4304 | 202-225-6673 | 1118 Longworth House Office Building | |||||||||
44466 | 44466 | Pete Sessions S000250 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 17 | https://sessions.house.gov | 2204 Rayburn House Office Building Washington DC 20515-4317 | 202-225-6105 | 2204 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||||
44465 | 44465 | Pete Sessions S000250 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn House Office Building; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | |||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
44461 | 44461 | Pete Sessions S000250 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44460 | 44460 | Pete Sessions S000250 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44459 | 44459 | Pete Sessions S000250 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44458 | 44458 | Pete Sessions S000250 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44457 | 44457 | Pete Sessions S000250 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
44456 | 44456 | Pete Sessions S000250 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
44455 | 44455 | Pete Sessions S000250 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
44399 | 44399 | Colin Allred A000376 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 32 | https://allred.house.gov | 114 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 114 Cannon House Office Building | |||||||||
44398 | 44398 | Colin Allred A000376 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://allred.house.gov | 328 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 328 Cannon House Office Building | |||||||||
44397 | 44397 | Sylvia Garcia G000587 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://sylviagarcia.house.gov | 1620 Longworth House Office Building Washington DC 20515-4329 | 202-225-1688 | 1620 Longworth House Office Building | |||||||||
44396 | 44396 | Sylvia Garcia G000587 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 29 | https://sylviagarcia.house.gov | 1620 Longworth House Office Building Washington DC 20515-4329 | 202-225-1688 | 1620 Longworth House Office Building | |||||||||
44395 | 44395 | Chip Roy R000614 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 21 | https://roy.house.gov | 1005 Longworth House Office Building Washington DC 20515-4321 | 202-225-4236 | 1005 Longworth House Office Building | |||||||||
44394 | 44394 | Chip Roy R000614 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 21 | https://roy.house.gov | 1319 Longworth House Office Building Washington DC 20515-4321 | 202-225-4236 | 1319 Longworth House Office Building | |||||||||
44393 | 44393 | Veronica Escobar E000299 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://escobar.house.gov | 1505 Longworth House Office Building Washington DC 20515-4316 | 202-225-4831 | 1505 Longworth House Office Building | |||||||||
44392 | 44392 | Veronica Escobar E000299 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://escobar.house.gov | 1505 Longworth House Office Building Washington DC 20515-4316 | 202-225-4831 | 1505 Longworth House Office Building | |||||||||
44391 | 44391 | Lizzie Fletcher F000468 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://fletcher.house.gov | 119 Cannon House Office Building Washington DC 20515-4307 | 202-225-2571 | 119 Cannon House Office Building | |||||||||
44390 | 44390 | Lizzie Fletcher F000468 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://fletcher.house.gov | 1429 Longworth House Office Building Washington DC 20515-4307 | 202-225-2571 | 1429 Longworth House Office Building | |||||||||
44389 | 44389 | Lance Gooden G000589 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 5 | https://gooden.house.gov | 1722 Longworth House Office Building Washington DC 20515-4305 | 202-225-3484 | 1722 Longworth House Office Building | |||||||||
44388 | 44388 | Lance Gooden G000589 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 5 | https://gooden.house.gov | 425 Cannon House Office Building Washington DC 20515-4305 | 202-225-3484 | 425 Cannon House Office Building | |||||||||
44387 | 44387 | Van Taylor T000479 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 3 | https://vantaylor.house.gov | 1404 Longworth House Office Building Washington DC 20515-4303 | 202-225-4201 | 1404 Longworth House Office Building | |||||||||
44386 | 44386 | Van Taylor T000479 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 3 | https://vantaylor.house.gov | 1404 Longworth House Office Building Washington DC 20515-4303 | 202-225-4201 | 1404 Longworth House Office Building | |||||||||
44385 | 44385 | Dan Crenshaw C001120 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 2 | https://crenshaw.house.gov | 413 Cannon House Office Building Washington DC 20515-4302 | 202-225-6565 | 413 Cannon House Office Building | |||||||||
44384 | 44384 | Dan Crenshaw C001120 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 2 | https://crenshaw.house.gov | 413 Cannon House Office Building Washington DC 20515-4302 | 202-225-6565 | 413 Cannon House Office Building | |||||||||
44256 | 44256 | Michael Cloud C001115 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 27 | https://cloud.house.gov | 512 Cannon House Office Building Washington DC 20515-4327 | 202-225-7742 | 512 Cannon House Office Building | |||||||||
44255 | 44255 | Michael Cloud C001115 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 27 | https://cloud.house.gov | 1314 Longworth House Office Building Washington DC 20515-4327 | 202-225-7742 | 1314 Longworth House Office Building | |||||||||
44254 | 44254 | Michael Cloud C001115 | rep | TX | 2018-07-10 | 2019-01-03 | Republican | 27 | https://cloud.house.gov/ | 2331 Rayburn House Office Building; Washington DC 20515-4327 | 202-225-7742 | 2331 Rayburn House Office Building | |||||||||
44220 | 44220 | Jodey Arrington A000375 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 19 | https://arrington.house.gov | 1107 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1107 Longworth House Office Building | |||||||||
44219 | 44219 | Jodey Arrington A000375 | rep | TX | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44217 | 44217 | Vicente Gonzalez G000581 | rep | TX | 2021-01-03 | 2023-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 | |||||||||
44216 | 44216 | Vicente Gonzalez G000581 | rep | TX | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44047 | 44047 | Brian Babin B001291 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 36 | https://babin.house.gov | 2236 Rayburn House Office Building Washington DC 20515-4336 | 202-225-1555 | 2236 Rayburn House Office Building | |||||||||
44046 | 44046 | Brian Babin B001291 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 36 | https://babin.house.gov | 2236 Rayburn House Office Building Washington DC 20515-4336 | 202-225-1555 | 2236 Rayburn House Office Building | |||||||||
44045 | 44045 | Brian Babin B001291 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 36 | https://babin.house.gov | 316 Cannon House Office Building; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
44044 | 44044 | Brian Babin B001291 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 36 | http://babin.house.gov | 316 Cannon HOB; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
43890 | 43890 | Marc Veasey V000131 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 33 | https://veasey.house.gov | 2348 Rayburn House Office Building Washington DC 20515-4333 | 202-225-9897 | 2348 Rayburn House Office Building | http://veasey.house.gov/rss.xml | ||||||||
43889 | 43889 | Marc Veasey V000131 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 33 | https://veasey.house.gov | 2348 Rayburn House Office Building Washington DC 20515-4333 | 202-225-9897 | 2348 Rayburn House Office Building | http://veasey.house.gov/rss.xml | ||||||||
43888 | 43888 | Marc Veasey V000131 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 33 | https://veasey.house.gov | 1519 Longworth House Office Building; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | 1519 Longworth House Office Building | http://veasey.house.gov/rss.xml | |||||||
43887 | 43887 | Marc Veasey V000131 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | ||||||
43886 | 43886 | Marc Veasey V000131 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | |||||||
43885 | 43885 | Roger Williams W000816 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 25 | https://williams.house.gov | 1708 Longworth House Office Building Washington DC 20515-4325 | 202-225-9896 | 1708 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||||
43884 | 43884 | Roger Williams W000816 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 25 | https://williams.house.gov | 1708 Longworth House Office Building Washington DC 20515-4325 | 202-225-9896 | 1708 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||||
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 | |||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43881 | 43881 | Roger Williams W000816 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 25 | http://williams.house.gov | 1122 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1122 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43880 | 43880 | Joaquin Castro C001091 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://castro.house.gov | 2241 Rayburn House Office Building Washington DC 20515-4320 | 202-225-3236 | 2241 Rayburn House Office Building | http://castro.house.gov/rss.xml | ||||||||
43879 | 43879 | Joaquin Castro C001091 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://castro.house.gov | 2241 Rayburn House Office Building Washington DC 20515-4320 | 202-225-3236 | 2241 Rayburn House Office Building | http://castro.house.gov/rss.xml | ||||||||
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 | |||||||
43877 | 43877 | Joaquin Castro C001091 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://castro.house.gov | 212 Cannon HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | https://castro.house.gov/contact/email-me | 212 Cannon House Office Building | http://castro.house.gov/rss.xml | ||||||
43876 | 43876 | Joaquin Castro C001091 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://castro.house.gov | 212 Cannon HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | https://castro.house.gov/contact/email-me | 212 Cannon House Office Building | http://castro.house.gov/rss.xml | ||||||
43875 | 43875 | Randy Weber W000814 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 14 | https://weber.house.gov | 107 Cannon House Office Building Washington DC 20515-4314 | 202-225-2831 | 107 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||||
43874 | 43874 | Randy Weber W000814 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 14 | https://weber.house.gov | 107 Cannon House Office Building Washington DC 20515-4314 | 202-225-2831 | 107 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||||
43873 | 43873 | Randy Weber W000814 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 14 | https://weber.house.gov | 1708 Longworth House Office Building; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | 1708 Longworth House Office Building | http://weber.house.gov/rss.xml | |||||||
43872 | 43872 | Randy Weber W000814 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
43871 | 43871 | Randy Weber W000814 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
43870 | 43870 | Ted Cruz C001098 | sen | TX | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cruz.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5922 | https://www.cruz.senate.gov/?p=form&id=16 | 127a Russell Senate Office Building | junior | |||||||
43869 | 43869 | Ted Cruz C001098 | sen | TX | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.cruz.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-5922 | 202-228-3398 | https://www.cruz.senate.gov/?p=form&id=16 | 404 Russell Senate Office Building | junior | ||||||
42863 | 42863 | Michael McCaul M001157 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building Washington DC 20515-4310 | 202-225-2401 | 2001 Rayburn House Office Building | |||||||||
42862 | 42862 | Michael McCaul M001157 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building Washington DC 20515-4310 | 202-225-2401 | 2001 Rayburn House Office Building | |||||||||
42861 | 42861 | Michael McCaul M001157 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | 2001 Rayburn House Office Building | ||||||||
42860 | 42860 | Michael McCaul M001157 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 10 | http://mccaul.house.gov | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | https://mccaul.house.gov/contact/email-me | 131 Cannon House Office Building | |||||||
42859 | 42859 | Michael McCaul M001157 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 10 | http://mccaul.house.gov | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | https://mccaul.house.gov/contact/email-me | 131 Cannon House Office Building | |||||||
42858 | 42858 | Michael McCaul M001157 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mccaul | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | http://www.house.gov/writerep | 131 Cannon House Office Building | |||||||
42857 | 42857 | Michael McCaul M001157 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/mccaul | ||||||||||||
42856 | 42856 | Michael McCaul M001157 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/mccaul | ||||||||||||
42855 | 42855 | Michael McCaul M001157 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 10 | |||||||||||||
42593 | 42593 | Eddie Johnson J000126 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2306 Rayburn House Office Building Washington DC 20515-4330 | 202-225-8885 | 2306 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||||
42592 | 42592 | Eddie Johnson J000126 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2306 Rayburn House Office Building Washington DC 20515-4330 | 202-225-8885 | 2306 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||||
42591 | 42591 | Eddie Johnson J000126 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2468 Rayburn House Office Building; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | |||||||
42590 | 42590 | Eddie Johnson J000126 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
42589 | 42589 | Eddie Johnson J000126 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
42588 | 42588 | Eddie Johnson J000126 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | http://www.house.gov/ebjohnson/IMA/issue_subscribe.shtml | 2468 Rayburn House Office Building | |||||||
42587 | 42587 | Eddie Johnson J000126 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42586 | 42586 | Eddie Johnson J000126 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42585 | 42585 | Eddie Johnson J000126 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42584 | 42584 | Eddie Johnson J000126 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42583 | 42583 | Eddie Johnson J000126 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
42582 | 42582 | Eddie Johnson J000126 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 30 | |||||||||||||
42581 | 42581 | Eddie Johnson J000126 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
42580 | 42580 | Eddie Johnson J000126 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
42579 | 42579 | Eddie Johnson J000126 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
42572 | 42572 | Sheila Jackson Lee J000032 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2426 Rayburn House Office Building Washington DC 20515-4318 | 202-225-3816 | 2426 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||||
42571 | 42571 | Sheila Jackson Lee J000032 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2079 Rayburn House Office Building Washington DC 20515-4318 | 202-225-3816 | 2079 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||||
42570 | 42570 | Sheila Jackson Lee J000032 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2187 Rayburn House Office Building; Washington DC 20515-4318 | 202-225-3816 | 202-225-3317 | 2187 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | |||||||
42569 | 42569 | Sheila Jackson Lee J000032 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://jacksonlee.house.gov | 2252 Rayburn HOB; Washington DC 20515-4318 | 202-225-3816 | 202-225-3317 | http://jacksonlee.house.gov/contact/ | 2252 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||
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 |
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);