legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "end" is on date 2023-01-03 and state = "TX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42011 | 42011 | Kevin Brady B000755 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building Washington DC 20515-4308 | 202-225-4901 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||||
42041 | 42041 | Michael Burgess B001248 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 26 | https://burgess.house.gov | 2161 Rayburn House Office Building Washington DC 20515-4326 | 202-225-7772 | 2161 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||||
42101 | 42101 | John Carter C001051 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 31 | https://carter.house.gov | 2208 Rayburn House Office Building Washington DC 20515-4331 | 202-225-3864 | 2208 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||||
42252 | 42252 | Henry Cuellar C001063 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
42342 | 42342 | Lloyd Doggett D000399 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 35 | https://doggett.house.gov | 2307 Rayburn House Office Building Washington DC 20515-4335 | 202-225-4865 | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | ||||||||
42414 | 42414 | Louie Gohmert G000552 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 1 | https://gohmert.house.gov | 2269 Rayburn House Office Building Washington DC 20515-4301 | 202-225-3035 | 2269 Rayburn House Office Building | http://gohmert.house.gov/news/rss.aspx | ||||||||
42433 | 42433 | Kay Granger G000377 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 12 | https://kaygranger.house.gov | 1026 Longworth House Office Building Washington DC 20515-4312 | 202-225-5071 | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||||
42463 | 42463 | Al Green G000553 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building Washington DC 20515-4309 | 202-225-7508 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 |
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);