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 url
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38778 | 38778 | Adam Putnam P000586 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
41909 | 41909 | Robert Aderholt A000055 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
43403 | 43403 | Adrian Smith S001172 | rep | NE | 2007-01-04 | 2009-01-03 | Republican | 3 | http://adriansmith.house.gov | ||||||||||||
39103 | 39103 | W. Akin A000358 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
41638 | 41638 | Alcee Hastings H000324 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 23 | http://alceehastings.house.gov | ||||||||||||
41259 | 41259 | Lamar Alexander A000360 | sen | TN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://alexander.senate.gov/ | ||||||||||||
37228 | 37228 | Wayne Allard A000109 | sen | CO | 2003-01-07 | 2009-01-03 | 2 | Republican | http://allard.senate.gov | ||||||||||||
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 | ||||||||||||
39734 | 39734 | Michele Bachmann B001256 | rep | MN | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bachmann.house.gov | ||||||||||||
39745 | 39745 | Spencer Bachus B000013 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
38581 | 38581 | Baron Hill H001030 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
39750 | 39750 | John Barrow B001252 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://barrow.house.gov | ||||||||||||
39125 | 39125 | Roscoe Bartlett B000208 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bartlett.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 | ||||||||||||
43457 | 43457 | Bennie Thompson T000193 | rep | MS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
38433 | 38433 | Joseph Biden B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
41935 | 41935 | Gus Bilirakis B001257 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 9 | http://bilirakis.house.gov | ||||||||||||
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 | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39189 | 39189 | Leonard Boswell B000652 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
37950 | 37950 | Nancy Boyda B001258 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://boyda.house.gov | ||||||||||||
43361 | 43361 | Brad Sherman S000344 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
39760 | 39760 | Bruce Braley B001259 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39764 | 39764 | Paul Broun B001262 | rep | GA | 2007-07-25 | 2009-01-03 | Republican | 10 | http://broun.house.gov/ | ||||||||||||
38461 | 38461 | Henry Brown B001235 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
42018 | 42018 | Vern Buchanan B001260 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 13 | http://buchanan.house.gov | ||||||||||||
42034 | 42034 | Michael Burgess B001248 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 26 | http://burgess.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 | ||||||||||||
40195 | 40195 | Candice Miller M001150 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 10 | http://candicemiller.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 | ||||||||||||
38477 | 38477 | Christopher Carney C001065 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
42084 | 42084 | André Carson C001072 | rep | IN | 2008-03-13 | 2009-01-03 | Democrat | 7 | http://carson.house.gov/ | ||||||||||||
42094 | 42094 | John Carter C001051 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 31 | http://carter.house.gov | ||||||||||||
42107 | 42107 | Kathy Castor C001066 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://castor.house.gov | ||||||||||||
38393 | 38393 | Donald Cazayoux C001073 | rep | LA | 2008-05-06 | 2009-01-03 | Democrat | 6 | http://cazayoux.house.gov/ | ||||||||||||
39691 | 39691 | Saxby Chambliss C000286 | sen | GA | 2003-01-07 | 2009-01-03 | 2 | Republican | http://chambliss.senate.gov | ||||||||||||
39215 | 39215 | Ben Chandler C001058 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
38928 | 38928 | Charles Wilson W000801 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
37968 | 37968 | Christopher Cannon C000116 | rep | UT | 2007-01-04 | 2009-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
42962 | 42962 | Christopher Murphy M001169 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42141 | 42141 | Yvette Clarke C001067 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://clarke.house.gov | ||||||||||||
42165 | 42165 | James Clyburn C000537 | rep | SC | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
40625 | 40625 | Thad Cochran C000567 | sen | MS | 2003-01-07 | 2009-01-03 | 2 | Republican | http://cochran.senate.gov | ||||||||||||
42173 | 42173 | Steve Cohen C001068 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://cohen.house.gov | ||||||||||||
37257 | 37257 | Norm Coleman C001057 | sen | MN | 2003-01-07 | 2009-01-03 | 2 | Republican | http://coleman.senate.gov | ||||||||||||
41427 | 41427 | Collin Peterson P000258 | rep | MN | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://collinpeterson.house.gov | ||||||||||||
41827 | 41827 | Susan Collins C001035 | sen | ME | 2003-01-07 | 2009-01-03 | 2 | Republican | http://collins.senate.gov | ||||||||||||
42206 | 42206 | Jim Cooper C000754 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
41832 | 41832 | John Cornyn C001056 | sen | TX | 2003-01-07 | 2009-01-03 | 2 | Republican | http://cornyn.senate.gov/ | ||||||||||||
42223 | 42223 | Joe Courtney C001069 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
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 | ||||||||||||
40283 | 40283 | Ander Crenshaw C001045 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
40762 | 40762 | John Culberson C001048 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 7 | http://culberson.house.gov | ||||||||||||
37993 | 37993 | David Davis D000606 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 1 | http://daviddavis.house.gov | ||||||||||||
43313 | 43313 | David Scott S001157 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://davidscott.house.gov | ||||||||||||
42276 | 42276 | Peter DeFazio D000191 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
40640 | 40640 | Charles Dent D000604 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 15 | http://dent.house.gov | ||||||||||||
37306 | 37306 | Elizabeth Dole D000601 | sen | NC | 2003-01-07 | 2009-01-03 | 2 | Republican | http://dole.senate.gov/ | ||||||||||||
37312 | 37312 | Pete Domenici D000407 | sen | NM | 2003-01-07 | 2009-01-03 | 2 | Republican | http://domenici.senate.gov | ||||||||||||
40288 | 40288 | Donna Edwards E000290 | rep | MD | 2008-06-19 | 2009-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | ||||||||||||
40772 | 40772 | Joe Donnelly D000607 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://donnelly.house.gov | ||||||||||||
41681 | 41681 | Don Young Y000033 | rep | AK | 2007-01-04 | 2009-01-03 | Republican | 0 | http://donyoung.house.gov | ||||||||||||
38013 | 38013 | John Doolittle D000429 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://doolittle.house.gov | ||||||||||||
38015 | 38015 | Thelma Drake D000605 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://drake.house.gov | ||||||||||||
39266 | 39266 | David Dreier D000492 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
41844 | 41844 | Richard Durbin D000563 | sen | IL | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://durbin.senate.gov | ||||||||||||
40792 | 40792 | Keith Ellison E000288 | rep | MN | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://ellison.house.gov | ||||||||||||
38544 | 38544 | Brad Ellsworth E000289 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
41263 | 41263 | Michael Enzi E000285 | sen | WY | 2003-01-07 | 2009-01-03 | 2 | Republican | http://enzi.senate.gov | ||||||||||||
42370 | 42370 | Anna Eshoo E000215 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
38553 | 38553 | Mary Fallin F000453 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
40801 | 40801 | Jeff Flake F000444 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 6 | http://flake.house.gov | ||||||||||||
41690 | 41690 | Jeff Fortenberry F000449 | rep | NE | 2007-01-04 | 2009-01-03 | Republican | 1 | http://fortenberry.house.gov | ||||||||||||
43688 | 43688 | Bill Foster F000454 | rep | IL | 2008-03-08 | 2009-01-03 | Democrat | 14 | http://foster.house.gov | ||||||||||||
42385 | 42385 | Virginia Foxx F000450 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
40811 | 40811 | Rodney Frelinghuysen F000372 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 11 | http://frelinghuysen.house.gov | ||||||||||||
41621 | 41621 | Marcia Fudge F000455 | rep | OH | 2008-11-19 | 2009-01-03 | Democrat | 11 | http://fudge.house.gov/ | ||||||||||||
40329 | 40329 | Scott Garrett G000548 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 5 | http://garrett.house.gov | ||||||||||||
38943 | 38943 | Geoff Davis D000603 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
39844 | 39844 | Jim Gerlach G000549 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 6 | http://gerlach.house.gov | ||||||||||||
38946 | 38946 | Gabrielle Giffords G000554 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
41893 | 41893 | Kirsten Gillibrand G000555 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://gillibrand.house.gov | ||||||||||||
42407 | 42407 | Louie Gohmert G000552 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 1 | http://gohmert.house.gov | ||||||||||||
39302 | 39302 | Charles Gonzalez G000544 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://gonzalez.house.gov | ||||||||||||
38566 | 38566 | Barton Gordon G000309 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
37460 | 37460 | Gordon Smith S001142 | sen | OR | 2003-01-07 | 2009-01-03 | 2 | Republican | http://gsmith.senate.gov/ | ||||||||||||
37371 | 37371 | Charles Hagel H001028 | sen | NE | 2003-01-07 | 2009-01-03 | 2 | Republican | http://hagel.senate.gov/ | ||||||||||||
43163 | 43163 | Harold Rogers R000395 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 5 | http://halrogers.house.gov | ||||||||||||
42594 | 42594 | Henry Johnson J000288 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://hankjohnson.house.gov | ||||||||||||
38572 | 38572 | Phil Hare H001040 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://hare.house.gov | ||||||||||||
39702 | 39702 | Thomas Harkin H000206 | sen | IA | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://harkin.senate.gov/ | ||||||||||||
39879 | 39879 | Doc Hastings H000329 | rep | WA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://hastings.house.gov | ||||||||||||
38093 | 38093 | Robin Hayes H001029 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 8 | http://hayes.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);