legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "end" is on date 2007-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36893 | 36893 | Mark Dayton D000596 | sen | MN | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://dayton.senate.gov | ||||||||||||
37100 | 37100 | Paul Sarbanes S000064 | sen | MD | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://sarbanes.senate.gov/ | ||||||||||||
37592 | 37592 | James Davis D000114 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37633 | 37633 | Lane Evans E000250 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/evans | ||||||||||||
37647 | 37647 | Harold Ford F000262 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/ford | ||||||||||||
37782 | 37782 | Cynthia McKinney M000523 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 4 | |||||||||||||
37819 | 37819 | Major Owens O000159 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/owens | ||||||||||||
37859 | 37859 | Martin Sabo S000005 | rep | MN | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/sabo | ||||||||||||
37893 | 37893 | Ted Strickland S001004 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/strickland | ||||||||||||
37937 | 37937 | Thomas Allen A000357 | rep | ME | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37961 | 37961 | Robert Byrd B001210 | sen | WV | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://byrd.senate.gov | ||||||||||||
37973 | 37973 | Julia Carson C000191 | rep | IN | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.juliacarson.house.gov | ||||||||||||
37975 | 37975 | Hillary Clinton C001041 | sen | NY | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://clinton.senate.gov | ||||||||||||
37984 | 37984 | Robert Cramer C000868 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
38017 | 38017 | Rahm Emanuel E000287 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38107 | 38107 | Darlene Hooley H000762 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38136 | 38136 | William Jefferson J000070 | rep | LA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38143 | 38143 | Stephanie Jones J000284 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/tubbsjones | ||||||||||||
38156 | 38156 | Edward Kennedy K000105 | sen | MA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://kennedy.senate.gov/ | ||||||||||||
38192 | 38192 | Tom Lantos L000090 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38234 | 38234 | Michael McNulty M000590 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 21 | http://www.house.gov/mcnulty | ||||||||||||
38242 | 38242 | Martin Meehan M000627 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/meehan | ||||||||||||
38249 | 38249 | Juanita Millender-McDonald M000714 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 37 | http://www.house.gov/millender-mcdonald | ||||||||||||
38391 | 38391 | Albert Wynn W000784 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38402 | 38402 | Neil Abercrombie A000014 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38411 | 38411 | Brian Baird B001229 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38418 | 38418 | Melissa Bean B001253 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 8 | |||||||||||||
38425 | 38425 | Robert Berry B000420 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38447 | 38447 | Frederick Boucher B000657 | rep | VA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
38454 | 38454 | Allen Boyd B000716 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38492 | 38492 | Artur Davis D000602 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38496 | 38496 | Lincoln Davis D000599 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38512 | 38512 | William Delahunt D000210 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38532 | 38532 | Thomas Edwards E000063 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38550 | 38550 | Bob Etheridge E000226 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38565 | 38565 | Barton Gordon G000309 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/gordon | ||||||||||||
38575 | 38575 | Stephanie Herseth Sandlin H001037 | rep | SD | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38612 | 38612 | Paul Kanjorski K000008 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/kanjorski | ||||||||||||
38620 | 38620 | Patrick Kennedy K000113 | rep | RI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/patrickkennedy | ||||||||||||
38627 | 38627 | Carolyn Kilpatrick K000180 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38646 | 38646 | James Marshall M001146 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/marshall | ||||||||||||
38661 | 38661 | Kendrick Meek M001148 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/kenmeek | ||||||||||||
38664 | 38664 | Charles Melancon M001161 | rep | LA | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
38681 | 38681 | Alan Mollohan M000844 | rep | WV | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38687 | 38687 | Dennis Moore M001140 | rep | KS | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/moore | ||||||||||||
38708 | 38708 | John Murtha M001120 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38727 | 38727 | James Oberstar O000006 | rep | MN | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/oberstar | ||||||||||||
38748 | 38748 | David Obey O000007 | rep | WI | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/obey | ||||||||||||
38762 | 38762 | Solomon Ortiz O000107 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 27 | http://www.house.gov/ortiz | ||||||||||||
38772 | 38772 | Earl Pomeroy P000422 | rep | ND | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38794 | 38794 | John Salazar S001158 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
38822 | 38822 | Ike Skelton S000465 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38829 | 38829 | Victor Snyder S000672 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38834 | 38834 | Hilda Solis S001153 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38858 | 38858 | John Spratt S000749 | rep | SC | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38867 | 38867 | Bart Stupak S001045 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38878 | 38878 | John Tanner T000038 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/tanner/ | ||||||||||||
38885 | 38885 | Ellen Tauscher T000057 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38896 | 38896 | Gene Taylor T000074 | rep | MS | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38918 | 38918 | Diane Watson W000794 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38925 | 38925 | Robert Wexler W000314 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 19 | http://www.wexler.house.gov | ||||||||||||
38938 | 38938 | Dennis Cardoza C001050 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38954 | 38954 | Jane Harman H000213 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38962 | 38962 | Jay Inslee I000026 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38981 | 38981 | Donald Payne P000149 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38988 | 38988 | Anthony Weiner W000792 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38995 | 38995 | David Wu W000793 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39004 | 39004 | Jesse Jackson J000283 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.jessejacksonjr.org/ | ||||||||||||
39014 | 39014 | Bob Filner F000116 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39039 | 39039 | Daniel Akaka A000069 | sen | HI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://akaka.senate.gov | ||||||||||||
39044 | 39044 | Jeff Bingaman B000468 | sen | NM | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bingaman.senate.gov | ||||||||||||
39049 | 39049 | Kent Conrad C000705 | sen | ND | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://conrad.senate.gov | ||||||||||||
39057 | 39057 | Herbert Kohl K000305 | sen | WI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://kohl.senate.gov/ | ||||||||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
39069 | 39069 | Ben Nelson N000180 | sen | NE | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bennelson.senate.gov/ | ||||||||||||
39095 | 39095 | Gary Ackerman A000022 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39114 | 39114 | Joe Baca B001234 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39139 | 39139 | Shelley Berkley B001231 | rep | NV | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39154 | 39154 | Howard Berman B000410 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39180 | 39180 | Dan Boren B001254 | rep | OK | 2005-01-04 | 2007-01-03 | Democrat | 2 | |||||||||||||
39188 | 39188 | Leonard Boswell B000652 | rep | IA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
39209 | 39209 | Russ Carnahan C001060 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
39214 | 39214 | Ben Chandler C001058 | rep | KY | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39228 | 39228 | Jerry Costello C000794 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39249 | 39249 | Norman Dicks D000327 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39281 | 39281 | Barney Frank F000339 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39301 | 39301 | Charles Gonzalez G000544 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 20 | http://www.house.gov/gonzalez | ||||||||||||
39325 | 39325 | Maurice Hinchey H000627 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 22 | http://www.house.gov/hinchey | ||||||||||||
39335 | 39335 | Tim Holden H000712 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/holden | ||||||||||||
39359 | 39359 | Dale Kildee K000172 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39369 | 39369 | Dennis Kucinich K000336 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/kucinich | ||||||||||||
39424 | 39424 | R. Miller M001154 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/bradmiller/ | ||||||||||||
39444 | 39444 | John Olver O000085 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39483 | 39483 | Silvestre Reyes R000170 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 16 | http://www.house.gov/reyes | ||||||||||||
39493 | 39493 | Mike Ross R000573 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39501 | 39501 | Steven Rothman R000462 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://rothman.house.gov | ||||||||||||
39529 | 39529 | Fortney Stark S000810 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39565 | 39565 | Edolphus Towns T000326 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/towns | ||||||||||||
39577 | 39577 | Lynn Woolsey W000738 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/woolsey | ||||||||||||
39651 | 39651 | Melvin Watt W000207 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/watt |
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);