legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 2005-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
39094 | 39094 | Gary Ackerman A000022 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
41907 | 41907 | Robert Aderholt A000055 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
39673 | 39673 | Robert Andrews A000210 | rep | NJ | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
37936 | 37936 | Thomas Allen A000357 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
39101 | 39101 | W. Akin A000358 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
37223 | 37223 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2003-01-07 | 2005-01-03 | Popular Democrat | 0 | http://www.house.gov/acevedo-vila | ||||||||||||
39616 | 39616 | Rodney Alexander A000361 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 5 | [ { "start": "2003-01-07", "end": "2004-08-09", "party": "Democrat" }, { "start": "2004-08-09", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/alexander/ | |||||||||||
39743 | 39743 | Spencer Bachus B000013 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/bachus | ||||||||||||
37947 | 37947 | Richard Baker B000072 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
37239 | 37239 | Cass Ballenger B000104 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/ballenger | ||||||||||||
39123 | 39123 | Roscoe Bartlett B000208 | rep | MD | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.bartlett.house.gov | ||||||||||||
40703 | 40703 | Joe Barton B000213 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/barton | ||||||||||||
39132 | 39132 | Charles Bass B000220 | rep | NH | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/bass | ||||||||||||
40517 | 40517 | Xavier Becerra B000287 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
37518 | 37518 | Robert Bennett B000382 | sen | UT | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bennett.senate.gov/ | ||||||||||||
39153 | 39153 | Howard Berman B000410 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
37530 | 37530 | Michael Bilirakis B000463 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
41948 | 41948 | Sanford Bishop B000490 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/bishop | ||||||||||||
41971 | 41971 | Earl Blumenauer B000574 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/blumenauer | ||||||||||||
41986 | 41986 | Roy Blunt B000575 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
37542 | 37542 | Sherwood Boehlert B000586 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 24 | http://www.house.gov/boehlert | ||||||||||||
40160 | 40160 | John Boehner B000589 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 8 | http://johnboehner.house.gov | ||||||||||||
37546 | 37546 | Christopher Bond B000611 | sen | MO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bond.senate.gov/ | ||||||||||||
37553 | 37553 | Henry Bonilla B000617 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 23 | http://www.house.gov/bonilla | ||||||||||||
39187 | 39187 | Leonard Boswell B000652 | rep | IA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
38446 | 38446 | Frederick Boucher B000657 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
40207 | 40207 | Barbara Boxer B000711 | sen | CA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://boxer.senate.gov/ | ||||||||||||
38453 | 38453 | Allen Boyd B000716 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
42002 | 42002 | Kevin Brady B000755 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
36521 | 36521 | John Breaux B000780 | sen | LA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://breaux.senate.gov/ | ||||||||||||
40260 | 40260 | Corrine Brown B000911 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
41735 | 41735 | Sherrod Brown B000944 | rep | OH | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/sherrodbrown | ||||||||||||
37559 | 37559 | Samuel Brownback B000953 | sen | KS | 1999-01-06 | 2005-01-03 | 3 | Republican | http://brownback.senate.gov/ | ||||||||||||
37567 | 37567 | Jim Bunning B001066 | sen | KY | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bunning.senate.gov/ | ||||||||||||
42046 | 42046 | Richard Burr B001135 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/burr | ||||||||||||
39203 | 39203 | Dan Burton B001149 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
38472 | 38472 | Stephen Buyer B001203 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
40726 | 40726 | Robert Brady B001227 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/robertbrady | ||||||||||||
39175 | 39175 | Mary Bono Mack B001228 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
38410 | 38410 | Brian Baird B001229 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
41919 | 41919 | Tammy Baldwin B001230 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
39138 | 39138 | Shelley Berkley B001231 | rep | NV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39160 | 39160 | Judy Biggert B001232 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
37513 | 37513 | Evan Bayh B001233 | sen | IN | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://bayh.senate.gov/ | ||||||||||||
39113 | 39113 | Joe Baca B001234 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
38459 | 38459 | Henry Brown B001235 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/henrybrown | ||||||||||||
41993 | 41993 | John Boozman B001236 | rep | AR | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
38414 | 38414 | James Barrett B001239 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
37515 | 37515 | Bob Beauprez B001240 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37240 | 37240 | Chris Bell B001241 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 25 | http://www.house.gov/bell | ||||||||||||
39754 | 39754 | Timothy Bishop B001242 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/timbishop | ||||||||||||
41958 | 41958 | Marsha Blackburn B001243 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/blackburn | ||||||||||||
39610 | 39610 | Jo Bonner B001244 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
40715 | 40715 | Madeleine Bordallo B001245 | rep | GU | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/bordallo | ||||||||||||
37555 | 37555 | Jeb Bradley B001246 | rep | NH | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bradley | ||||||||||||
38463 | 38463 | Virginia Brown-Waite B001247 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
42032 | 42032 | Michael Burgess B001248 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 26 | http://www.house.gov/burgess | ||||||||||||
37254 | 37254 | Max Burns B001249 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 12 | http://www.house.gov/burns | ||||||||||||
41290 | 41290 | Rob Bishop B001250 | rep | UT | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
42050 | 42050 | George Butterfield B001251 | rep | NC | 2004-07-21 | 2005-01-03 | Democrat | 1 | http://www.house.gov/butterfield/ | ||||||||||||
42065 | 42065 | Ken Calvert C000059 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
39774 | 39774 | Dave Camp C000071 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/camp | ||||||||||||
36544 | 36544 | Ben Campbell C000077 | sen | CO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://campbell.senate.gov/ | ||||||||||||
37966 | 37966 | Christopher Cannon C000116 | rep | UT | 2003-01-07 | 2005-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
41753 | 41753 | Benjamin Cardin C000141 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/cardin | ||||||||||||
37972 | 37972 | Julia Carson C000191 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.juliacarson.house.gov | ||||||||||||
38484 | 38484 | Michael Castle C000243 | rep | DE | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
42119 | 42119 | Steve Chabot C000266 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
39788 | 39788 | Donna Christensen C000380 | rep | VI | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
42163 | 42163 | James Clyburn C000537 | rep | SC | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/clyburn | ||||||||||||
40140 | 40140 | Howard Coble C000556 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/coble | ||||||||||||
37263 | 37263 | Michael Collins C000640 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/maccollins | ||||||||||||
40574 | 40574 | John Conyers C000714 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 14 | http://www.house.gov/conyers | ||||||||||||
42204 | 42204 | Jim Cooper C000754 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cooper | ||||||||||||
39227 | 39227 | Jerry Costello C000794 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
37578 | 37578 | C. Cox C000830 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 48 | http://cox.house.gov | ||||||||||||
37983 | 37983 | Robert Cramer C000868 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
37299 | 37299 | Philip Crane C000873 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/crane | ||||||||||||
42234 | 42234 | Michael Crapo C000880 | sen | ID | 1999-01-06 | 2005-01-03 | 3 | Republican | http://crapo.senate.gov/ | ||||||||||||
37990 | 37990 | Barbara Cubin C000962 | rep | WY | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
41200 | 41200 | Elijah Cummings C000984 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/cummings | ||||||||||||
37586 | 37586 | Randall Cunningham C000994 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
40270 | 40270 | Lois Capps C001036 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40736 | 40736 | Michael Capuano C001037 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/capuano | ||||||||||||
40751 | 40751 | Joseph Crowley C001038 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/crowley | ||||||||||||
37256 | 37256 | Brad Carson C001044 | rep | OK | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://carson.house.gov | ||||||||||||
40281 | 40281 | Ander Crenshaw C001045 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
39680 | 39680 | Eric Cantor C001046 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
42076 | 42076 | Shelley Capito C001047 | rep | WV | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/capito | ||||||||||||
40760 | 40760 | John Culberson C001048 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.culberson.house.gov | ||||||||||||
41300 | 41300 | Wm. Clay C001049 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
38937 | 38937 | Dennis Cardoza C001050 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
42092 | 42092 | John Carter C001051 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 31 | http://www.house.gov/carter | ||||||||||||
37569 | 37569 | Chris Chocola C001052 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/chocola | ||||||||||||
42181 | 42181 | Tom Cole C001053 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
44272 | 44272 | Ed Case C001055 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
39213 | 39213 | Ben Chandler C001058 | rep | KY | 2004-02-17 | 2005-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
36587 | 36587 | Thomas Daschle D000064 | sen | SD | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://daschle.senate.gov/ |
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);