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 2003-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37222 | 37222 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2001-01-03 | 2003-01-03 | AL | 0 | |||||||||||||
36141 | 36141 | J. Cleland C001034 | sen | GA | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36443 | 36443 | Robert Torricelli T000317 | sen | NJ | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36793 | 36793 | John Baldacci B000081 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
36798 | 36798 | James Barcia B000134 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
36807 | 36807 | Thomas Barrett B000177 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
36811 | 36811 | Ken Bentsen B000400 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 25 | |||||||||||||
36814 | 36814 | Rod Blagojevich B000518 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
36827 | 36827 | David Bonior B000619 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
36837 | 36837 | Robert Borski B000644 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
36862 | 36862 | Eva Clayton C000494 | rep | NC | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
36870 | 36870 | Robert Clement C000503 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
36877 | 36877 | Gary Condit C000670 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
36892 | 36892 | William Coyne C000846 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
36967 | 36967 | Earl Hilliard H000621 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
37000 | 37000 | John LaFalce L000556 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 29 | |||||||||||||
37009 | 37009 | William Luther L000521 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
37012 | 37012 | James Maloney M000090 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37016 | 37016 | Frank Mascara M000212 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37021 | 37021 | Carrie Meek M000628 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37064 | 37064 | David Phelps P000584 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 19 | |||||||||||||
37071 | 37071 | Lynn Rivers R000281 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
37077 | 37077 | Timothy Roemer R000385 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
37108 | 37108 | Thomas Sawyer S000094 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
37117 | 37117 | Ronnie Shows S001147 | rep | MS | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37187 | 37187 | Karen Thurman T000253 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37201 | 37201 | Robert Underwood U000014 | rep | GU | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
37255 | 37255 | Brad Carson C001044 | rep | OK | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
37304 | 37304 | Peter Deutsch D000275 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37318 | 37318 | Calvin Dooley D000424 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37340 | 37340 | Jonas Frost F000392 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 24 | |||||||||||||
37354 | 37354 | Richard Gephardt G000132 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
37373 | 37373 | Joseph Hoeffel H001031 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
37387 | 37387 | Christopher John J000110 | rep | LA | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
37398 | 37398 | Gerald Kleczka K000259 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37409 | 37409 | William Lipinski L000342 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
37412 | 37412 | Kenneth Lucas L000558 | rep | KY | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37426 | 37426 | Robert Matsui M000249 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37431 | 37431 | Karen McCarthy M000316 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37455 | 37455 | Max Sandlin S000044 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37478 | 37478 | Charles Stenholm S000851 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37506 | 37506 | James Turner T000424 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
37590 | 37590 | James Davis D000114 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
37631 | 37631 | Lane Evans E000250 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37645 | 37645 | Harold Ford F000262 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
37781 | 37781 | Cynthia McKinney M000523 | rep | GA | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37817 | 37817 | Major Owens O000159 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
37857 | 37857 | Martin Sabo S000005 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37891 | 37891 | Ted Strickland S001004 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
37935 | 37935 | Thomas Allen A000357 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37971 | 37971 | Julia Carson C000191 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
37982 | 37982 | Robert Cramer C000868 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38105 | 38105 | Darlene Hooley H000762 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38134 | 38134 | William Jefferson J000070 | rep | LA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38141 | 38141 | Stephanie Jones J000284 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
38177 | 38177 | Nicholas Lampson L000043 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38190 | 38190 | Tom Lantos L000090 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
38232 | 38232 | Michael McNulty M000590 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 21 | |||||||||||||
38240 | 38240 | Martin Meehan M000627 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38247 | 38247 | Juanita Millender-McDonald M000714 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 37 | |||||||||||||
38389 | 38389 | Albert Wynn W000784 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
38400 | 38400 | Neil Abercrombie A000014 | rep | HI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38409 | 38409 | Brian Baird B001229 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
38423 | 38423 | Robert Berry B000420 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38432 | 38432 | Joseph Biden B000444 | sen | DE | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
38445 | 38445 | Frederick Boucher B000657 | rep | VA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38452 | 38452 | Allen Boyd B000716 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38510 | 38510 | William Delahunt D000210 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38530 | 38530 | Thomas Edwards E000063 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
38548 | 38548 | Bob Etheridge E000226 | rep | NC | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38563 | 38563 | Barton Gordon G000309 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
38579 | 38579 | Baron Hill H001030 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38610 | 38610 | Paul Kanjorski K000008 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
38618 | 38618 | Patrick Kennedy K000113 | rep | RI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38625 | 38625 | Carolyn Kilpatrick K000180 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 15 | |||||||||||||
38679 | 38679 | Alan Mollohan M000844 | rep | WV | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38685 | 38685 | Dennis Moore M001140 | rep | KS | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
38706 | 38706 | John Murtha M001120 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
38725 | 38725 | James Oberstar O000006 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
38746 | 38746 | David Obey O000007 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
38760 | 38760 | Solomon Ortiz O000107 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 27 | |||||||||||||
38770 | 38770 | Earl Pomeroy P000422 | rep | ND | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
38790 | 38790 | Ciro Rodriguez R000568 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 28 | |||||||||||||
38820 | 38820 | Ike Skelton S000465 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
38827 | 38827 | Victor Snyder S000672 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
38832 | 38832 | Hilda Solis S001153 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 31 | |||||||||||||
38856 | 38856 | John Spratt S000749 | rep | SC | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38865 | 38865 | Bart Stupak S001045 | rep | MI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38876 | 38876 | John Tanner T000038 | rep | TN | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
38883 | 38883 | Ellen Tauscher T000057 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38894 | 38894 | Gene Taylor T000074 | rep | MS | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38916 | 38916 | Diane Watson W000794 | rep | CA | 2001-06-07 | 2003-01-03 | Democrat | 32 | |||||||||||||
38923 | 38923 | Robert Wexler W000314 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 19 | |||||||||||||
38952 | 38952 | Jane Harman H000213 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 36 | |||||||||||||
38960 | 38960 | Jay Inslee I000026 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38979 | 38979 | Donald Payne P000149 | rep | NJ | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38986 | 38986 | Anthony Weiner W000792 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38993 | 38993 | David Wu W000793 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
39002 | 39002 | Jesse Jackson J000283 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 2 |
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);