legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2011-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39097 | 39097 | Gary Ackerman A000022 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ackerman.house.gov/ | ||||||||||||
41910 | 41910 | Robert Aderholt A000055 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
39676 | 39676 | Robert Andrews A000210 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
39104 | 39104 | W. Akin A000358 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39619 | 39619 | Rodney Alexander A000361 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://alexander.house.gov/ | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
38407 | 38407 | Michael Arcuri A000363 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
38405 | 38405 | John Adler A000364 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://adler.house.gov | ||||||||||||
39109 | 39109 | Steve Austria A000365 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 7 | http://austria.house.gov | ||||||||||||
39746 | 39746 | Spencer Bachus B000013 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
39126 | 39126 | Roscoe Bartlett B000208 | rep | MD | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
40706 | 40706 | Joe Barton B000213 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 6 | http://joebarton.house.gov | ||||||||||||
40520 | 40520 | Xavier Becerra B000287 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
37519 | 37519 | Robert Bennett B000382 | sen | UT | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bennett.senate.gov | ||||||||||||
39156 | 39156 | Howard Berman B000410 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
38427 | 38427 | Robert Berry B000420 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/berry/ | ||||||||||||
39170 | 39170 | Brian Bilbray B000461 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
41951 | 41951 | Sanford Bishop B000490 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://bishop.house.gov | ||||||||||||
41974 | 41974 | Earl Blumenauer B000574 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://blumenauer.house.gov | ||||||||||||
41989 | 41989 | Roy Blunt B000575 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 7 | http://blunt.house.gov/ | ||||||||||||
40163 | 40163 | John Boehner B000589 | rep | OH | 2009-01-06 | 2011-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 | ||||||||||||
39190 | 39190 | Leonard Boswell B000652 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
38449 | 38449 | Frederick Boucher B000657 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
40208 | 40208 | Barbara Boxer B000711 | sen | CA | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://boxer.senate.gov | ||||||||||||
38456 | 38456 | Allen Boyd B000716 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://boyd.house.gov | ||||||||||||
42005 | 42005 | Kevin Brady B000755 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
40263 | 40263 | Corrine Brown B000911 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
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 | ||||||||||||
39206 | 39206 | Dan Burton B001149 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 5 | http://burton.house.gov | ||||||||||||
38475 | 38475 | Stephen Buyer B001203 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 4 | http://stevebuyer.house.gov | ||||||||||||
40729 | 40729 | Robert Brady B001227 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.brady.house.gov | ||||||||||||
39178 | 39178 | Mary Bono Mack B001228 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
38413 | 38413 | Brian Baird B001229 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.baird.house.gov | ||||||||||||
41922 | 41922 | Tammy Baldwin B001230 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
39141 | 39141 | Shelley Berkley B001231 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://berkley.house.gov | ||||||||||||
39163 | 39163 | Judy Biggert B001232 | rep | IL | 2009-01-06 | 2011-01-03 | Republican | 13 | http://judybiggert.house.gov | ||||||||||||
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
39116 | 39116 | Joe Baca B001234 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
38462 | 38462 | Henry Brown B001235 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
41996 | 41996 | John Boozman B001236 | rep | AR | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.boozman.house.gov/ | ||||||||||||
38417 | 38417 | James Barrett B001239 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
39757 | 39757 | Timothy Bishop B001242 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://wwwc.house.gov/timbishop | ||||||||||||
41961 | 41961 | Marsha Blackburn B001243 | rep | TN | 2009-01-06 | 2011-01-03 | Republican | 7 | http://www.house.gov/blackburn | ||||||||||||
39613 | 39613 | Jo Bonner B001244 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
40718 | 40718 | Madeleine Bordallo B001245 | rep | GU | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/bordallo | ||||||||||||
38466 | 38466 | Virginia Brown-Waite B001247 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
42035 | 42035 | Michael Burgess B001248 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 26 | http://burgess.house.gov | ||||||||||||
41293 | 41293 | Rob Bishop B001250 | rep | UT | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
42053 | 42053 | George Butterfield B001251 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/butterfield | ||||||||||||
39751 | 39751 | John Barrow B001252 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://barrow.house.gov | ||||||||||||
38420 | 38420 | Melissa Bean B001253 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
39182 | 39182 | Dan Boren B001254 | rep | OK | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
40251 | 40251 | Charles Boustany B001255 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://www.house.gov/boustany | ||||||||||||
39735 | 39735 | Michele Bachmann B001256 | rep | MN | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachmann.house.gov | ||||||||||||
41936 | 41936 | Gus Bilirakis B001257 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 9 | http://bilirakis.house.gov | ||||||||||||
39761 | 39761 | Bruce Braley B001259 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
42019 | 42019 | Vern Buchanan B001260 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 13 | http://buchanan.house.gov | ||||||||||||
39765 | 39765 | Paul Broun B001262 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 10 | http://broun.house.gov/ | ||||||||||||
38435 | 38435 | John Boccieri B001263 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://boccieri.house.gov | ||||||||||||
38457 | 38457 | Bobby Bright B001264 | rep | AL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.bright.house.gov | ||||||||||||
41932 | 41932 | Michael Bennet B001267 | sen | CO | 2009-01-22 | 2011-01-03 | 3 | Democrat | appointment | http://bennet.senate.gov/ | |||||||||||
42068 | 42068 | Ken Calvert C000059 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
39777 | 39777 | Dave Camp C000071 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 4 | http://camp.house.gov | ||||||||||||
38487 | 38487 | Michael Castle C000243 | rep | DE | 2009-01-06 | 2011-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
39791 | 39791 | Donna Christensen C000380 | rep | VI | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
42166 | 42166 | James Clyburn C000537 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
40143 | 40143 | Howard Coble C000556 | rep | NC | 2009-01-06 | 2011-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 | ||||||||||||
40577 | 40577 | John Conyers C000714 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://www.house.gov/conyers | ||||||||||||
42207 | 42207 | Jim Cooper C000754 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
39230 | 39230 | Jerry Costello C000794 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
42235 | 42235 | Michael Crapo C000880 | sen | ID | 2005-01-04 | 2011-01-03 | 3 | Republican | http://crapo.senate.gov | ||||||||||||
41203 | 41203 | Elijah Cummings C000984 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/cummings | ||||||||||||
40273 | 40273 | Lois Capps C001036 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40739 | 40739 | Michael Capuano C001037 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/capuano | ||||||||||||
40754 | 40754 | Joseph Crowley C001038 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/crowley | ||||||||||||
40284 | 40284 | Ander Crenshaw C001045 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
39683 | 39683 | Eric Cantor C001046 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
42079 | 42079 | Shelley Capito C001047 | rep | WV | 2009-01-06 | 2011-01-03 | Republican | 2 | http://capito.house.gov | ||||||||||||
40763 | 40763 | John Culberson C001048 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 7 | http://culberson.house.gov | ||||||||||||
41303 | 41303 | Wm. Clay C001049 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
38940 | 38940 | Dennis Cardoza C001050 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
42095 | 42095 | John Carter C001051 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 31 | http://carter.house.gov | ||||||||||||
42184 | 42184 | Tom Cole C001053 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
39216 | 39216 | Ben Chandler C001058 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
42216 | 42216 | Jim Costa C001059 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 20 | http://www.house.gov/costa | ||||||||||||
39211 | 39211 | Russ Carnahan C001060 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
42151 | 42151 | Emanuel Cleaver C001061 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
41311 | 41311 | K. Conaway C001062 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 11 | http://www.house.gov/conaway | ||||||||||||
42246 | 42246 | Henry Cuellar C001063 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/cuellar | ||||||||||||
39782 | 39782 | John Campbell C001064 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
38478 | 38478 | Christopher Carney C001065 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
42108 | 42108 | Kathy Castor C001066 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://castor.house.gov | ||||||||||||
42142 | 42142 | Yvette Clarke C001067 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://clarke.house.gov | ||||||||||||
42174 | 42174 | Steve Cohen C001068 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://cohen.house.gov | ||||||||||||
42224 | 42224 | Joe Courtney C001069 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42085 | 42085 | André Carson C001072 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://carson.house.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);