legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "start" is on date 2017-01-03 and state = "TX"
This data as json, copyable, CSV (advanced)
Suggested facets: end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40631 | 40631 | Blake Farenthold F000460 | rep | TX | 2017-01-03 | 2018-04-06 | Republican | 27 | https://farenthold.house.gov | 2331 Rayburn House Office Building; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | 2331 Rayburn House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | |||||||
40710 | 40710 | Joe Barton B000213 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 6 | https://joebarton.house.gov | 2107 Rayburn House Office Building; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | |||||||
40767 | 40767 | John Culberson C001048 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 7 | https://culberson.house.gov | 2161 Rayburn House Office Building; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | 2161 Rayburn House Office Building | http://culberson.house.gov/rss/ | |||||||
40846 | 40846 | Gene Green G000410 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://green.house.gov | 2470 Rayburn House Office Building; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | |||||||
40872 | 40872 | Jeb Hensarling H001036 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 5 | https://hensarling.house.gov | 2228 Rayburn House Office Building; Washington DC 20515-4305 | 202-225-3484 | 202-226-4888 | 2228 Rayburn House Office Building | http://hensarling.house.gov/atom.xml | |||||||
40895 | 40895 | Sam Johnson J000174 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 3 | https://samjohnson.house.gov | 2304 Rayburn House Office Building; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | 2304 Rayburn House Office Building | http://samjohnson.house.gov/news/rss.aspx | |||||||
40957 | 40957 | Ted Poe P000592 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poe.house.gov | 2132 Rayburn House Office Building; Washington DC 20515-4302 | 202-225-6565 | 202-225-5547 | 2132 Rayburn House Office Building | http://poe.house.gov/index.php?format=feed&type=rss | |||||||
41070 | 41070 | Lamar Smith S000583 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 21 | https://lamarsmith.house.gov | 2409 Rayburn House Office Building; Washington DC 20515-4321 | 202-225-4236 | 202-225-8628 | 2409 Rayburn House Office Building | http://lamarsmith.house.gov/news/rss.aspx | |||||||
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 | ||||||||
41227 | 41227 | John Ratcliffe R000601 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 4 | https://ratcliffe.house.gov | 325 Cannon House Office Building; Washington DC 20515-4304 | 202-225-6673 | 202-225-3332 | 325 Cannon House Office Building | ||||||||
41315 | 41315 | K. Conaway C001062 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 11 | https://conaway.house.gov | 2430 Rayburn House Office Building; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | 2430 Rayburn House Office Building | ||||||||
41346 | 41346 | Bill Flores F000461 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 17 | https://flores.house.gov | 2440 Rayburn House Office Building; Washington DC 20515-4317 | 202-225-6105 | 202-225-0350 | 2440 Rayburn House Office Building | http://flores.house.gov/common/rss//index.cfm?rss=25 | |||||||
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 | |||||||
41417 | 41417 | Pete Olson O000168 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 22 | https://olson.house.gov | 2133 Rayburn House Office Building; Washington DC 20515-4322 | 202-225-5951 | 202-225-5241 | 2133 Rayburn House Office Building | feed://olson.house.gov/common/rss/?rss=82 | |||||||
41505 | 41505 | Mac Thornberry T000238 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 13 | https://thornberry.house.gov | 2208 Rayburn House Office Building; Washington DC 20515-4313 | 202-225-3706 | 202-225-3486 | 2208 Rayburn House Office Building | ||||||||
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 | |||||||||
41700 | 41700 | Filemon Vela V000132 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 34 | https://vela.house.gov | 437 Cannon House Office Building; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | 437 Cannon House Office Building | http://vela.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 | |||||||
42039 | 42039 | Michael Burgess B001248 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 26 | https://burgess.house.gov | 2336 Rayburn House Office Building; Washington DC 20515-4326 | 202-225-7772 | 202-225-2919 | 2336 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | |||||||
42099 | 42099 | John Carter C001051 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 31 | https://carter.house.gov | 2110 Rayburn House Office Building; Washington DC 20515-4331 | 202-225-3864 | 202-225-5886 | 2110 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | |||||||
42250 | 42250 | Henry Cuellar C001063 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 28 | https://cuellar.house.gov | 2209 Rayburn House Office Building; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | |||||||
42340 | 42340 | Lloyd Doggett D000399 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 35 | https://doggett.house.gov | 2307 Rayburn House Office Building; Washington DC 20515-4335 | 202-225-4865 | 202-225-3073 | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | |||||||
42412 | 42412 | Louie Gohmert G000552 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 1 | https://gohmert.house.gov | 2243 Rayburn House Office Building; Washington DC 20515-4301 | 202-225-3035 | 202-226-1230 | 2243 Rayburn House Office Building | http://gohmert.house.gov/news/rss.aspx | |||||||
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 | |||||||
42461 | 42461 | Al Green G000553 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building; Washington DC 20515-4309 | 202-225-7508 | 202-225-2947 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | |||||||
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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||||
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 |
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);