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 2005-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36521 | 36521 | John Breaux B000780 | sen | LA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://breaux.senate.gov/ | ||||||||||||
36587 | 36587 | Thomas Daschle D000064 | sen | SD | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://daschle.senate.gov/ | ||||||||||||
36603 | 36603 | John Edwards E000286 | sen | NC | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://edwards.senate.gov/ | ||||||||||||
36646 | 36646 | Bob Graham G000352 | sen | FL | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://graham.senate.gov/ | ||||||||||||
36655 | 36655 | Ernest Hollings H000725 | sen | SC | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://hollings.senate.gov/ | ||||||||||||
36778 | 36778 | Zell Miller M001141 | sen | GA | 2000-07-24 | 2005-01-03 | 3 | Democrat | appointment | http://miller.senate.gov/ | |||||||||||
37240 | 37240 | Chris Bell B001241 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 25 | http://www.house.gov/bell | ||||||||||||
37256 | 37256 | Brad Carson C001044 | rep | OK | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://carson.house.gov | ||||||||||||
37305 | 37305 | Peter Deutsch D000275 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 20 | http://www.house.gov/deutsch | ||||||||||||
37319 | 37319 | Calvin Dooley D000424 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 20 | http://dooley.house.gov | ||||||||||||
37341 | 37341 | Jonas Frost F000392 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 24 | http://www.house.gov/frost | ||||||||||||
37355 | 37355 | Richard Gephardt G000132 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://dickgephardt.house.gov | ||||||||||||
37374 | 37374 | Joseph Hoeffel H001031 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/hoeffel | ||||||||||||
37388 | 37388 | Christopher John J000110 | rep | LA | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/john | ||||||||||||
37399 | 37399 | Gerald Kleczka K000259 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/kleczka | ||||||||||||
37410 | 37410 | William Lipinski L000342 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/lipinski | ||||||||||||
37413 | 37413 | Kenneth Lucas L000558 | rep | KY | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/kenlucas | ||||||||||||
37414 | 37414 | Denise Majette M001145 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/majette | ||||||||||||
37427 | 37427 | Robert Matsui M000249 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
37432 | 37432 | Karen McCarthy M000316 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://mccarthy.house.gov/ | ||||||||||||
37456 | 37456 | Max Sandlin S000044 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/sandlin | ||||||||||||
37479 | 37479 | Charles Stenholm S000851 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/stenholm | ||||||||||||
37507 | 37507 | James Turner T000424 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/turner | ||||||||||||
37513 | 37513 | Evan Bayh B001233 | sen | IN | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://bayh.senate.gov/ | ||||||||||||
37591 | 37591 | James Davis D000114 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37610 | 37610 | Christopher Dodd D000388 | sen | CT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dodd.senate.gov/ | ||||||||||||
37620 | 37620 | Byron Dorgan D000432 | sen | ND | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dorgan.senate.gov/ | ||||||||||||
37632 | 37632 | Lane Evans E000250 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/evans | ||||||||||||
37635 | 37635 | Russell Feingold F000061 | sen | WI | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://feingold.senate.gov/ | ||||||||||||
37646 | 37646 | Harold Ford F000262 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/ford | ||||||||||||
37774 | 37774 | Blanche Lincoln L000035 | sen | AR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
37818 | 37818 | Major Owens O000159 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/owens | ||||||||||||
37858 | 37858 | Martin Sabo S000005 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/sabo | ||||||||||||
37892 | 37892 | Ted Strickland S001004 | rep | OH | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/strickland | ||||||||||||
37936 | 37936 | Thomas Allen A000357 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37972 | 37972 | Julia Carson C000191 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.juliacarson.house.gov | ||||||||||||
37983 | 37983 | Robert Cramer C000868 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
38016 | 38016 | Rahm Emanuel E000287 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38106 | 38106 | Darlene Hooley H000762 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38135 | 38135 | William Jefferson J000070 | rep | LA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38142 | 38142 | Stephanie Jones J000284 | rep | OH | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/tubbsjones | ||||||||||||
38178 | 38178 | Nicholas Lampson L000043 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/lampson | ||||||||||||
38191 | 38191 | Tom Lantos L000090 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38233 | 38233 | Michael McNulty M000590 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 21 | http://www.house.gov/mcnulty | ||||||||||||
38241 | 38241 | Martin Meehan M000627 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/meehan | ||||||||||||
38248 | 38248 | Juanita Millender-McDonald M000714 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 37 | http://www.house.gov/millender-mcdonald | ||||||||||||
38390 | 38390 | Albert Wynn W000784 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38410 | 38410 | Brian Baird B001229 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38446 | 38446 | Frederick Boucher B000657 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
38453 | 38453 | Allen Boyd B000716 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38491 | 38491 | Artur Davis D000602 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38495 | 38495 | Lincoln Davis D000599 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38511 | 38511 | William Delahunt D000210 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38531 | 38531 | Thomas Edwards E000063 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/edwards | ||||||||||||
38549 | 38549 | Bob Etheridge E000226 | rep | NC | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38564 | 38564 | Barton Gordon G000309 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/gordon | ||||||||||||
38574 | 38574 | Stephanie Herseth Sandlin H001037 | rep | SD | 2004-06-03 | 2005-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38580 | 38580 | Baron Hill H001030 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/baronhill | ||||||||||||
38611 | 38611 | Paul Kanjorski K000008 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/kanjorski | ||||||||||||
38619 | 38619 | Patrick Kennedy K000113 | rep | RI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/patrickkennedy | ||||||||||||
38626 | 38626 | Carolyn Kilpatrick K000180 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38645 | 38645 | James Marshall M001146 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/marshall | ||||||||||||
38660 | 38660 | Kendrick Meek M001148 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/kenmeek | ||||||||||||
38680 | 38680 | Alan Mollohan M000844 | rep | WV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38686 | 38686 | Dennis Moore M001140 | rep | KS | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/moore | ||||||||||||
38707 | 38707 | John Murtha M001120 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38726 | 38726 | James Oberstar O000006 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/oberstar | ||||||||||||
38747 | 38747 | David Obey O000007 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/obey | ||||||||||||
38761 | 38761 | Solomon Ortiz O000107 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 27 | http://www.house.gov/ortiz | ||||||||||||
38771 | 38771 | Earl Pomeroy P000422 | rep | ND | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38791 | 38791 | Ciro Rodriguez R000568 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 28 | http://www.house.gov/rodriguez | ||||||||||||
38821 | 38821 | Ike Skelton S000465 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38828 | 38828 | Victor Snyder S000672 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38833 | 38833 | Hilda Solis S001153 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38857 | 38857 | John Spratt S000749 | rep | SC | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38866 | 38866 | Bart Stupak S001045 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38877 | 38877 | John Tanner T000038 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/tanner/ | ||||||||||||
38884 | 38884 | Ellen Tauscher T000057 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38895 | 38895 | Gene Taylor T000074 | rep | MS | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38917 | 38917 | Diane Watson W000794 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38924 | 38924 | Robert Wexler W000314 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 19 | http://www.wexler.house.gov | ||||||||||||
38937 | 38937 | Dennis Cardoza C001050 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38953 | 38953 | Jane Harman H000213 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38961 | 38961 | Jay Inslee I000026 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38980 | 38980 | Donald Payne P000149 | rep | NJ | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38987 | 38987 | Anthony Weiner W000792 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38994 | 38994 | David Wu W000793 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39003 | 39003 | Jesse Jackson J000283 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.jessejacksonjr.org/ | ||||||||||||
39013 | 39013 | Bob Filner F000116 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39027 | 39027 | Daniel Inouye I000025 | sen | HI | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
39094 | 39094 | Gary Ackerman A000022 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39113 | 39113 | Joe Baca B001234 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39138 | 39138 | Shelley Berkley B001231 | rep | NV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39153 | 39153 | Howard Berman B000410 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39187 | 39187 | Leonard Boswell B000652 | rep | IA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
39213 | 39213 | Ben Chandler C001058 | rep | KY | 2004-02-17 | 2005-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39227 | 39227 | Jerry Costello C000794 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39248 | 39248 | Norman Dicks D000327 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/dicks |
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);