legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2005-01-04 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38402 | 38402 | Neil Abercrombie A000014 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
39095 | 39095 | Gary Ackerman A000022 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
41908 | 41908 | Robert Aderholt A000055 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
39674 | 39674 | Robert Andrews A000210 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
37937 | 37937 | Thomas Allen A000357 | rep | ME | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
39102 | 39102 | W. Akin A000358 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
39617 | 39617 | Rodney Alexander A000361 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/alexander/ | ||||||||||||
39744 | 39744 | Spencer Bachus B000013 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/bachus | ||||||||||||
37948 | 37948 | Richard Baker B000072 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
39124 | 39124 | Roscoe Bartlett B000208 | rep | MD | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.bartlett.house.gov | ||||||||||||
40704 | 40704 | Joe Barton B000213 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/barton | ||||||||||||
39133 | 39133 | Charles Bass B000220 | rep | NH | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/bass | ||||||||||||
40518 | 40518 | Xavier Becerra B000287 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
37519 | 37519 | Robert Bennett B000382 | sen | UT | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bennett.senate.gov | ||||||||||||
39154 | 39154 | Howard Berman B000410 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
38425 | 38425 | Robert Berry B000420 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
37531 | 37531 | Michael Bilirakis B000463 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
41949 | 41949 | Sanford Bishop B000490 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/bishop | ||||||||||||
41972 | 41972 | Earl Blumenauer B000574 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/blumenauer | ||||||||||||
41987 | 41987 | Roy Blunt B000575 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
37543 | 37543 | Sherwood Boehlert B000586 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 24 | http://www.house.gov/boehlert | ||||||||||||
40161 | 40161 | John Boehner B000589 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 8 | http://johnboehner.house.gov | ||||||||||||
37547 | 37547 | Christopher Bond B000611 | sen | MO | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bond.senate.gov | ||||||||||||
37554 | 37554 | Henry Bonilla B000617 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 23 | http://www.house.gov/bonilla | ||||||||||||
39188 | 39188 | Leonard Boswell B000652 | rep | IA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
38447 | 38447 | Frederick Boucher B000657 | rep | VA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
40208 | 40208 | Barbara Boxer B000711 | sen | CA | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://boxer.senate.gov | ||||||||||||
38454 | 38454 | Allen Boyd B000716 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
42003 | 42003 | Kevin Brady B000755 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
40261 | 40261 | Corrine Brown B000911 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
41736 | 41736 | Sherrod Brown B000944 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/sherrodbrown | ||||||||||||
37560 | 37560 | Samuel Brownback B000953 | sen | KS | 2005-01-04 | 2011-01-03 | 3 | Republican | http://brownback.senate.gov | ||||||||||||
37568 | 37568 | Jim Bunning B001066 | sen | KY | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bunning.senate.gov | ||||||||||||
42047 | 42047 | Richard Burr B001135 | sen | NC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://burr.senate.gov | ||||||||||||
39204 | 39204 | Dan Burton B001149 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
38473 | 38473 | Stephen Buyer B001203 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
40727 | 40727 | Robert Brady B001227 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/robertbrady | ||||||||||||
39176 | 39176 | Mary Bono Mack B001228 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
38411 | 38411 | Brian Baird B001229 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
41920 | 41920 | Tammy Baldwin B001230 | rep | WI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
39139 | 39139 | Shelley Berkley B001231 | rep | NV | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39161 | 39161 | Judy Biggert B001232 | rep | IL | 2005-01-04 | 2007-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
39114 | 39114 | Joe Baca B001234 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
38460 | 38460 | Henry Brown B001235 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/henrybrown | ||||||||||||
41994 | 41994 | John Boozman B001236 | rep | AR | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
38415 | 38415 | James Barrett B001239 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
37516 | 37516 | Bob Beauprez B001240 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
39755 | 39755 | Timothy Bishop B001242 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/timbishop | ||||||||||||
41959 | 41959 | Marsha Blackburn B001243 | rep | TN | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/blackburn | ||||||||||||
39611 | 39611 | Jo Bonner B001244 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
40716 | 40716 | Madeleine Bordallo B001245 | rep | GU | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/bordallo | ||||||||||||
37556 | 37556 | Jeb Bradley B001246 | rep | NH | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/bradley | ||||||||||||
38464 | 38464 | Virginia Brown-Waite B001247 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
42033 | 42033 | Michael Burgess B001248 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 26 | http://www.house.gov/burgess | ||||||||||||
41291 | 41291 | Rob Bishop B001250 | rep | UT | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
42051 | 42051 | George Butterfield B001251 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 1 | |||||||||||||
39749 | 39749 | John Barrow B001252 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 12 | |||||||||||||
38418 | 38418 | Melissa Bean B001253 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 8 | |||||||||||||
39180 | 39180 | Dan Boren B001254 | rep | OK | 2005-01-04 | 2007-01-03 | Democrat | 2 | |||||||||||||
40249 | 40249 | Charles Boustany B001255 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 7 | |||||||||||||
42066 | 42066 | Ken Calvert C000059 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
39775 | 39775 | Dave Camp C000071 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/camp | ||||||||||||
37967 | 37967 | Christopher Cannon C000116 | rep | UT | 2005-01-04 | 2007-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
41754 | 41754 | Benjamin Cardin C000141 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/cardin | ||||||||||||
37973 | 37973 | Julia Carson C000191 | rep | IN | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.juliacarson.house.gov | ||||||||||||
38485 | 38485 | Michael Castle C000243 | rep | DE | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
42120 | 42120 | Steve Chabot C000266 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
39789 | 39789 | Donna Christensen C000380 | rep | VI | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
42164 | 42164 | James Clyburn C000537 | rep | SC | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/clyburn | ||||||||||||
40141 | 40141 | Howard Coble C000556 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/coble | ||||||||||||
39797 | 39797 | Thomas Coburn C000560 | sen | OK | 2005-01-04 | 2011-01-03 | 3 | Republican | http://coburn.senate.gov | ||||||||||||
40575 | 40575 | John Conyers C000714 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www.house.gov/conyers | ||||||||||||
42205 | 42205 | Jim Cooper C000754 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cooper | ||||||||||||
39228 | 39228 | Jerry Costello C000794 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
37579 | 37579 | C. Cox C000830 | rep | CA | 2005-01-04 | 2005-08-02 | Republican | 48 | http://cox.house.gov | ||||||||||||
37984 | 37984 | Robert Cramer C000868 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
42235 | 42235 | Michael Crapo C000880 | sen | ID | 2005-01-04 | 2011-01-03 | 3 | Republican | http://crapo.senate.gov | ||||||||||||
37991 | 37991 | Barbara Cubin C000962 | rep | WY | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
41201 | 41201 | Elijah Cummings C000984 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/cummings | ||||||||||||
37587 | 37587 | Randall Cunningham C000994 | rep | CA | 2005-01-04 | 2005-12-01 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
40271 | 40271 | Lois Capps C001036 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40737 | 40737 | Michael Capuano C001037 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/capuano | ||||||||||||
40752 | 40752 | Joseph Crowley C001038 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/crowley | ||||||||||||
40282 | 40282 | Ander Crenshaw C001045 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
39681 | 39681 | Eric Cantor C001046 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
42077 | 42077 | Shelley Capito C001047 | rep | WV | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/capito | ||||||||||||
40761 | 40761 | John Culberson C001048 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.culberson.house.gov | ||||||||||||
41301 | 41301 | Wm. Clay C001049 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
38938 | 38938 | Dennis Cardoza C001050 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
42093 | 42093 | John Carter C001051 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 31 | http://www.house.gov/carter | ||||||||||||
37570 | 37570 | Chris Chocola C001052 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/chocola | ||||||||||||
42182 | 42182 | Tom Cole C001053 | rep | OK | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
44273 | 44273 | Ed Case C001055 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
39214 | 39214 | Ben Chandler C001058 | rep | KY | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
42214 | 42214 | Jim Costa C001059 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 20 | |||||||||||||
39209 | 39209 | Russ Carnahan C001060 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
42149 | 42149 | Emanuel Cleaver C001061 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 5 | |||||||||||||
41309 | 41309 | K. Conaway C001062 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 11 | |||||||||||||
42244 | 42244 | Henry Cuellar C001063 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 28 |
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);