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 2009-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38403 | 38403 | Neil Abercrombie A000014 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
39096 | 39096 | Gary Ackerman A000022 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
41909 | 41909 | Robert Aderholt A000055 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
37228 | 37228 | Wayne Allard A000109 | sen | CO | 2003-01-07 | 2009-01-03 | 2 | Republican | http://allard.senate.gov | ||||||||||||
39675 | 39675 | Robert Andrews A000210 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
37938 | 37938 | Thomas Allen A000357 | rep | ME | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
39103 | 39103 | W. Akin A000358 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
41259 | 41259 | Lamar Alexander A000360 | sen | TN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://alexander.senate.gov/ | ||||||||||||
39618 | 39618 | Rodney Alexander A000361 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/alexander | ||||||||||||
39106 | 39106 | Jason Altmire A000362 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
38406 | 38406 | Michael Arcuri A000363 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
39745 | 39745 | Spencer Bachus B000013 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
39125 | 39125 | Roscoe Bartlett B000208 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
40705 | 40705 | Joe Barton B000213 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 6 | http://joebarton.house.gov | ||||||||||||
39664 | 39664 | Max Baucus B000243 | sen | MT | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://baucus.senate.gov | ||||||||||||
40519 | 40519 | Xavier Becerra B000287 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
39155 | 39155 | Howard Berman B000410 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
38426 | 38426 | Robert Berry B000420 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38433 | 38433 | Joseph Biden B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
39169 | 39169 | Brian Bilbray B000461 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
41950 | 41950 | Sanford Bishop B000490 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://bishop.house.gov | ||||||||||||
41973 | 41973 | Earl Blumenauer B000574 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://blumenauer.house.gov | ||||||||||||
41988 | 41988 | Roy Blunt B000575 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
40162 | 40162 | John Boehner B000589 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 8 | http://johnboehner.house.gov | ||||||||||||
39189 | 39189 | Leonard Boswell B000652 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
38448 | 38448 | Frederick Boucher B000657 | rep | VA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
38455 | 38455 | Allen Boyd B000716 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
42004 | 42004 | Kevin Brady B000755 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
40262 | 40262 | Corrine Brown B000911 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
39205 | 39205 | Dan Burton B001149 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
38474 | 38474 | Stephen Buyer B001203 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
40728 | 40728 | Robert Brady B001227 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/robertbrady | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
38412 | 38412 | Brian Baird B001229 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
41921 | 41921 | Tammy Baldwin B001230 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
39140 | 39140 | Shelley Berkley B001231 | rep | NV | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39162 | 39162 | Judy Biggert B001232 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
39115 | 39115 | Joe Baca B001234 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
38461 | 38461 | Henry Brown B001235 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
41995 | 41995 | John Boozman B001236 | rep | AR | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
38416 | 38416 | James Barrett B001239 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
39756 | 39756 | Timothy Bishop B001242 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://wwwc.house.gov/timbishop | ||||||||||||
41960 | 41960 | Marsha Blackburn B001243 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/blackburn | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
40717 | 40717 | Madeleine Bordallo B001245 | rep | GU | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/bordallo | ||||||||||||
38465 | 38465 | Virginia Brown-Waite B001247 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
42034 | 42034 | Michael Burgess B001248 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 26 | http://burgess.house.gov | ||||||||||||
41292 | 41292 | Rob Bishop B001250 | rep | UT | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
42052 | 42052 | George Butterfield B001251 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/butterfield | ||||||||||||
39750 | 39750 | John Barrow B001252 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://barrow.house.gov | ||||||||||||
38419 | 38419 | Melissa Bean B001253 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
39181 | 39181 | Dan Boren B001254 | rep | OK | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
40250 | 40250 | Charles Boustany B001255 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/boustany | ||||||||||||
39734 | 39734 | Michele Bachmann B001256 | rep | MN | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bachmann.house.gov | ||||||||||||
41935 | 41935 | Gus Bilirakis B001257 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 9 | http://bilirakis.house.gov | ||||||||||||
37950 | 37950 | Nancy Boyda B001258 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://boyda.house.gov | ||||||||||||
39760 | 39760 | Bruce Braley B001259 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
42018 | 42018 | Vern Buchanan B001260 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 13 | http://buchanan.house.gov | ||||||||||||
39764 | 39764 | Paul Broun B001262 | rep | GA | 2007-07-25 | 2009-01-03 | Republican | 10 | http://broun.house.gov/ | ||||||||||||
42067 | 42067 | Ken Calvert C000059 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
39776 | 39776 | Dave Camp C000071 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 4 | http://camp.house.gov | ||||||||||||
37968 | 37968 | Christopher Cannon C000116 | rep | UT | 2007-01-04 | 2009-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
38486 | 38486 | Michael Castle C000243 | rep | DE | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
42121 | 42121 | Steve Chabot C000266 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
39691 | 39691 | Saxby Chambliss C000286 | sen | GA | 2003-01-07 | 2009-01-03 | 2 | Republican | http://chambliss.senate.gov | ||||||||||||
39790 | 39790 | Donna Christensen C000380 | rep | VI | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
42165 | 42165 | James Clyburn C000537 | rep | SC | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
40142 | 40142 | Howard Coble C000556 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/coble | ||||||||||||
40625 | 40625 | Thad Cochran C000567 | sen | MS | 2003-01-07 | 2009-01-03 | 2 | Republican | http://cochran.senate.gov | ||||||||||||
40576 | 40576 | John Conyers C000714 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://www.house.gov/conyers | ||||||||||||
42206 | 42206 | Jim Cooper C000754 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
39229 | 39229 | Jerry Costello C000794 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
37281 | 37281 | Larry Craig C000858 | sen | ID | 2003-01-07 | 2009-01-03 | 2 | Republican | http://craig.senate.gov | ||||||||||||
37985 | 37985 | Robert Cramer C000868 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cramer.house.gov | ||||||||||||
37992 | 37992 | Barbara Cubin C000962 | rep | WY | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
41202 | 41202 | Elijah Cummings C000984 | rep | MD | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/cummings | ||||||||||||
41827 | 41827 | Susan Collins C001035 | sen | ME | 2003-01-07 | 2009-01-03 | 2 | Republican | http://collins.senate.gov | ||||||||||||
40272 | 40272 | Lois Capps C001036 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40738 | 40738 | Michael Capuano C001037 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/capuano | ||||||||||||
40753 | 40753 | Joseph Crowley C001038 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/crowley | ||||||||||||
40283 | 40283 | Ander Crenshaw C001045 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
39682 | 39682 | Eric Cantor C001046 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
42078 | 42078 | Shelley Capito C001047 | rep | WV | 2007-01-04 | 2009-01-03 | Republican | 2 | http://capito.house.gov | ||||||||||||
40762 | 40762 | John Culberson C001048 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 7 | http://culberson.house.gov | ||||||||||||
41302 | 41302 | Wm. Clay C001049 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
38939 | 38939 | Dennis Cardoza C001050 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
42094 | 42094 | John Carter C001051 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 31 | http://carter.house.gov | ||||||||||||
42183 | 42183 | Tom Cole C001053 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
41832 | 41832 | John Cornyn C001056 | sen | TX | 2003-01-07 | 2009-01-03 | 2 | Republican | http://cornyn.senate.gov/ | ||||||||||||
37257 | 37257 | Norm Coleman C001057 | sen | MN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://coleman.senate.gov | ||||||||||||
39215 | 39215 | Ben Chandler C001058 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
42215 | 42215 | Jim Costa C001059 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://www.house.gov/costa | ||||||||||||
39210 | 39210 | Russ Carnahan C001060 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
42150 | 42150 | Emanuel Cleaver C001061 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
41310 | 41310 | K. Conaway C001062 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 11 | http://www.house.gov/conaway | ||||||||||||
42245 | 42245 | Henry Cuellar C001063 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/cuellar | ||||||||||||
39781 | 39781 | John Campbell C001064 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
38477 | 38477 | Christopher Carney C001065 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
42107 | 42107 | Kathy Castor C001066 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://castor.house.gov | ||||||||||||
42141 | 42141 | Yvette Clarke C001067 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://clarke.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);