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
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
37519 | 37519 | Robert Bennett B000382 | sen | UT | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bennett.senate.gov | ||||||||||||
37547 | 37547 | Christopher Bond B000611 | sen | MO | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bond.senate.gov | ||||||||||||
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 | ||||||||||||
37611 | 37611 | Christopher Dodd D000388 | sen | CT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dodd.senate.gov | ||||||||||||
37621 | 37621 | Byron Dorgan D000432 | sen | ND | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dorgan.senate.gov | ||||||||||||
37636 | 37636 | Russell Feingold F000061 | sen | WI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://feingold.senate.gov | ||||||||||||
37663 | 37663 | Judd Gregg G000445 | sen | NH | 2005-01-04 | 2011-01-03 | 3 | Republican | http://gregg.senate.gov/ | ||||||||||||
37775 | 37775 | Blanche Lincoln L000035 | sen | AR | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
37887 | 37887 | Arlen Specter S000709 | sen | PA | 2005-01-04 | 2011-01-03 | 3 | Democrat | [ { "start": "2005-01-04", "end": "2009-04-30", "party": "Republican" }, { "start": "2009-04-30", "end": "2011-01-03", "party": "Democrat" } ] |
http://specter.senate.gov/ | |||||||||||
37921 | 37921 | George Voinovich V000126 | sen | OH | 2005-01-04 | 2011-01-03 | 3 | Republican | http://voinovich.senate.gov/ | ||||||||||||
38405 | 38405 | John Adler A000364 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://adler.house.gov | ||||||||||||
38407 | 38407 | Michael Arcuri A000363 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
38413 | 38413 | Brian Baird B001229 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.baird.house.gov | ||||||||||||
38417 | 38417 | James Barrett B001239 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38420 | 38420 | Melissa Bean B001253 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
38427 | 38427 | Robert Berry B000420 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/berry/ | ||||||||||||
38435 | 38435 | John Boccieri B001263 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://boccieri.house.gov | ||||||||||||
38449 | 38449 | Frederick Boucher B000657 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
38456 | 38456 | Allen Boyd B000716 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://boyd.house.gov | ||||||||||||
38457 | 38457 | Bobby Bright B001264 | rep | AL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.bright.house.gov | ||||||||||||
38462 | 38462 | Henry Brown B001235 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
38466 | 38466 | Virginia Brown-Waite B001247 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38475 | 38475 | Stephen Buyer B001203 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 4 | http://stevebuyer.house.gov | ||||||||||||
38476 | 38476 | Anh Cao C001079 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://josephcao.house.gov | ||||||||||||
38478 | 38478 | Christopher Carney C001065 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
38487 | 38487 | Michael Castle C000243 | rep | DE | 2009-01-06 | 2011-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38489 | 38489 | Travis Childers C001074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.childers.house.gov/ | ||||||||||||
38490 | 38490 | Kathleen Dahlkemper D000608 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://dahlkemper.house.gov | ||||||||||||
38494 | 38494 | Artur Davis D000602 | rep | AL | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38498 | 38498 | Lincoln Davis D000599 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38514 | 38514 | William Delahunt D000210 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38523 | 38523 | Lincoln Diaz-Balart D000299 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38524 | 38524 | Steve Driehaus D000609 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://driehaus.house.gov | ||||||||||||
38534 | 38534 | Thomas Edwards E000063 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38543 | 38543 | Vernon Ehlers E000092 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38545 | 38545 | Brad Ellsworth E000289 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
38552 | 38552 | Bob Etheridge E000226 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38554 | 38554 | Mary Fallin F000453 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
38567 | 38567 | Barton Gordon G000309 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
38568 | 38568 | Parker Griffith G000557 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 5 | [ { "start": "2009-01-06", "end": "2009-12-22", "party": "Democrat" }, { "start": "2009-12-22", "end": "2011-01-03", "party": "Republican" } ] |
http://griffith.house.gov | |||||||||||
38570 | 38570 | John Hall H001039 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 19 | http://johnhall.house.gov | ||||||||||||
38571 | 38571 | Deborah Halvorson H001044 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://halvorson.house.gov | ||||||||||||
38573 | 38573 | Phil Hare H001040 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://hare.house.gov | ||||||||||||
38577 | 38577 | Stephanie Herseth Sandlin H001037 | rep | SD | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38582 | 38582 | Baron Hill H001030 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
38584 | 38584 | Paul Hodes H001043 | rep | NH | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
38593 | 38593 | Peter Hoekstra H000676 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38599 | 38599 | Bob Inglis I000023 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 4 | http://inglis.house.gov | ||||||||||||
38601 | 38601 | Steve Kagen K000365 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://kagen.house.gov | ||||||||||||
38614 | 38614 | Paul Kanjorski K000008 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://kanjorski.house.gov | ||||||||||||
38622 | 38622 | Patrick Kennedy K000113 | rep | RI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://patrickkennedy.house.gov | ||||||||||||
38629 | 38629 | Carolyn Kilpatrick K000180 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38630 | 38630 | Mary Jo Kilroy K000372 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 15 | http://kilroy.house.gov | ||||||||||||
38632 | 38632 | Ron Klein K000366 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 22 | http://klein.house.gov | ||||||||||||
38633 | 38633 | Suzanne Kosmas K000370 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://www.kosmas.house.gov | ||||||||||||
38634 | 38634 | Frank Kratovil K000371 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kratovil.house.gov | ||||||||||||
38643 | 38643 | John Linder L000321 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://linder.house.gov | ||||||||||||
38644 | 38644 | Betsy Markey M001172 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://betsymarkey.house.gov | ||||||||||||
38648 | 38648 | James Marshall M001146 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://jimmarshall.house.gov | ||||||||||||
38659 | 38659 | Michael McMahon M001174 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://mcmahon.house.gov | ||||||||||||
38663 | 38663 | Kendrick Meek M001148 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://kendrickmeek.house.gov | ||||||||||||
38666 | 38666 | Charles Melancon M001161 | rep | LA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://melancon.house.gov | ||||||||||||
38667 | 38667 | Walter Minnick M001175 | rep | ID | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://minnick.house.gov | ||||||||||||
38669 | 38669 | Harry Mitchell M001167 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38683 | 38683 | Alan Mollohan M000844 | rep | WV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38689 | 38689 | Dennis Moore M001140 | rep | KS | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://moore.house.gov | ||||||||||||
38691 | 38691 | Patrick Murphy M001168 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://patrickmurphy.house.gov | ||||||||||||
38711 | 38711 | Glenn Nye N000183 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://nye.house.gov | ||||||||||||
38729 | 38729 | James Oberstar O000006 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://oberstar.house.gov | ||||||||||||
38750 | 38750 | David Obey O000007 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://obey.house.gov | ||||||||||||
38764 | 38764 | Solomon Ortiz O000107 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://ortiz.house.gov | ||||||||||||
38765 | 38765 | Thomas Perriello P000600 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://perriello.house.gov | ||||||||||||
38774 | 38774 | Earl Pomeroy P000422 | rep | ND | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38779 | 38779 | Adam Putnam P000586 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
38787 | 38787 | George Radanovich R000004 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38793 | 38793 | Ciro Rodriguez R000568 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 23 | http://rodriguez.house.gov | ||||||||||||
38796 | 38796 | John Salazar S001158 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/salazar | ||||||||||||
38797 | 38797 | Mark Schauer S001178 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://schauer.house.gov | ||||||||||||
38799 | 38799 | Joe Sestak S001169 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://sestak.house.gov | ||||||||||||
38807 | 38807 | John Shadegg S000275 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38824 | 38824 | Ike Skelton S000465 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38831 | 38831 | Victor Snyder S000672 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38846 | 38846 | Zachary Space S001173 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://space.house.gov | ||||||||||||
38860 | 38860 | John Spratt S000749 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38869 | 38869 | Bart Stupak S001045 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38880 | 38880 | John Tanner T000038 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/tanner | ||||||||||||
38898 | 38898 | Gene Taylor T000074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38899 | 38899 | Harry Teague T000466 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://teague.house.gov | ||||||||||||
38907 | 38907 | Todd Tiahrt T000260 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38915 | 38915 | Zach Wamp W000119 | rep | TN | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
38920 | 38920 | Diane Watson W000794 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38929 | 38929 | Charles Wilson W000801 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
38932 | 38932 | Scott Murphy M001178 | rep | NY | 2009-04-29 | 2011-01-03 | Democrat | 20 | http://scottmurphy.house.gov/ | ||||||||||||
38933 | 38933 | George LeMieux L000572 | sen | FL | 2009-09-10 | 2011-01-03 | 3 | Republican | appointment | http://lemieux.senate.gov/ | |||||||||||
38935 | 38935 | Charles Djou D000611 | rep | HI | 2010-05-22 | 2011-01-03 | Republican | 1 | http://djou.house.gov/ | ||||||||||||
38940 | 38940 | Dennis Cardoza C001050 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38944 | 38944 | Geoff Davis D000603 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
38947 | 38947 | Gabrielle Giffords G000554 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://giffords.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);