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 party
This data as json, copyable, CSV (advanced)
Suggested facets: state, district, start (date)
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 | ||||||||||||
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 | ||||||||||||
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/ | |||||||||||
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 | ||||||||||||
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 | ||||||||||||
38478 | 38478 | Christopher Carney C001065 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
38567 | 38567 | Barton Gordon G000309 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://gordon.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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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/ | ||||||||||||
38940 | 38940 | Dennis Cardoza C001050 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38947 | 38947 | Gabrielle Giffords G000554 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38956 | 38956 | Jane Harman H000213 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38964 | 38964 | Jay Inslee I000026 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38983 | 38983 | Donald Payne P000149 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38990 | 38990 | Anthony Weiner W000792 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38997 | 38997 | David Wu W000793 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39006 | 39006 | Jesse Jackson J000283 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/jackson/ | ||||||||||||
39016 | 39016 | Bob Filner F000116 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39028 | 39028 | Daniel Inouye I000025 | sen | HI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
39097 | 39097 | Gary Ackerman A000022 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ackerman.house.gov/ | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39116 | 39116 | Joe Baca B001234 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39141 | 39141 | Shelley Berkley B001231 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://berkley.house.gov | ||||||||||||
39156 | 39156 | Howard Berman B000410 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39182 | 39182 | Dan Boren B001254 | rep | OK | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
39190 | 39190 | Leonard Boswell B000652 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39211 | 39211 | Russ Carnahan C001060 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39216 | 39216 | Ben Chandler C001058 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39230 | 39230 | Jerry Costello C000794 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39233 | 39233 | Mark Critz C001081 | rep | PA | 2010-05-20 | 2011-01-03 | Democrat | 12 | http://critz.house.gov/ | ||||||||||||
39251 | 39251 | Norman Dicks D000327 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39283 | 39283 | Barney Frank F000339 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39303 | 39303 | Charles Gonzalez G000544 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 20 | http://gonzalez.house.gov | ||||||||||||
39327 | 39327 | Maurice Hinchey H000627 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 22 | http://www.house.gov/hinchey | ||||||||||||
39337 | 39337 | Tim Holden H000712 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://www.holden.house.gov | ||||||||||||
39361 | 39361 | Dale Kildee K000172 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39363 | 39363 | Larry Kissell K000369 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://kissell.house.gov | ||||||||||||
39371 | 39371 | Dennis Kucinich K000336 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://kucinich.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);