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
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36141 | 36141 | J. Cleland C001034 | sen | GA | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36261 | 36261 | Jesse Helms H000463 | sen | NC | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36264 | 36264 | Tim Hutchinson H001015 | sen | AR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36377 | 36377 | Robert Smith S000606 | sen | NH | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36417 | 36417 | Fred Thompson T000457 | sen | TN | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36427 | 36427 | J. Thurmond T000254 | sen | SC | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36443 | 36443 | Robert Torricelli T000317 | sen | NJ | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36789 | 36789 | Richard Armey A000217 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 26 | |||||||||||||
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 | |||||||||||||
36802 | 36802 | Bob Barr B000169 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
36841 | 36841 | Ed Bryant B000996 | rep | TN | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
36853 | 36853 | H. Callahan C000052 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
36880 | 36880 | John Cooksey C000735 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
36892 | 36892 | William Coyne C000846 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
36903 | 36903 | Robert Ehrlich E000093 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
36909 | 36909 | Greg Ganske G000041 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
36919 | 36919 | George Gekas G000121 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 17 | |||||||||||||
36934 | 36934 | Benjamin Gilman G000212 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 20 | |||||||||||||
36935 | 36935 | Felix Grucci G000547 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
36958 | 36958 | James Hansen H000172 | rep | UT | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
36962 | 36962 | Van Hilleary H000615 | rep | TN | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
36967 | 36967 | Earl Hilliard H000621 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
36972 | 36972 | Stephen Horn H000789 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 38 | |||||||||||||
36986 | 36986 | Brian Kerns K000359 | rep | IN | 2001-01-03 | 2003-01-03 | Republican | 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 | |||||||||||||
37026 | 37026 | Dan Miller M000720 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 13 | |||||||||||||
37062 | 37062 | Constance Morella M000941 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37064 | 37064 | David Phelps P000584 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 19 | |||||||||||||
37067 | 37067 | Bob Riley R000258 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
37088 | 37088 | Marge Roukema R000465 | rep | NJ | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37108 | 37108 | Thomas Sawyer S000094 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
37115 | 37115 | Bob Schaffer S000112 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37117 | 37117 | Ronnie Shows S001147 | rep | MS | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
37153 | 37153 | Joseph Skeen S000463 | rep | NM | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37182 | 37182 | Robert Stump S001044 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
37211 | 37211 | Wes Watkins W000194 | rep | OK | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37215 | 37215 | J.C. Watts W000210 | rep | OK | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37216 | 37216 | Dean Barkley B001237 | sen | MN | 2002-11-05 | 2003-01-03 | 2 | Independent | appointment | ||||||||||||
37222 | 37222 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2001-01-03 | 2003-01-03 | AL | 0 | |||||||||||||
37227 | 37227 | Wayne Allard A000109 | sen | CO | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37238 | 37238 | Cass Ballenger B000104 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 10 | |||||||||||||
37252 | 37252 | Douglas Bereuter B000403 | rep | NE | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37255 | 37255 | Brad Carson C001044 | rep | OK | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
37262 | 37262 | Michael Collins C000640 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37272 | 37272 | Larry Combest C000653 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 19 | |||||||||||||
37280 | 37280 | Larry Craig C000858 | sen | ID | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37298 | 37298 | Philip Crane C000873 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37304 | 37304 | Peter Deutsch D000275 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37311 | 37311 | Pete Domenici D000407 | sen | NM | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37318 | 37318 | Calvin Dooley D000424 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37324 | 37324 | Jennifer Dunn D000549 | rep | WA | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37327 | 37327 | Ernest Fletcher F000441 | rep | KY | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
37362 | 37362 | Porter Goss G000336 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 14 | |||||||||||||
37368 | 37368 | James Greenwood G000439 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37370 | 37370 | Charles Hagel H001028 | sen | NE | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37373 | 37373 | Joseph Hoeffel H001031 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
37382 | 37382 | Amory Houghton H000814 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 31 | |||||||||||||
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 | |||||||||||||
37437 | 37437 | Scott McInnis M000477 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37442 | 37442 | George Nethercutt N000051 | rep | WA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
37445 | 37445 | Doug Ose O000164 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37451 | 37451 | Jack Quinn Q000016 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 30 | |||||||||||||
37455 | 37455 | Max Sandlin S000044 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37457 | 37457 | Edward Schrock S001151 | rep | VA | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37459 | 37459 | Gordon Smith S001142 | sen | OR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37465 | 37465 | Nick Smith S000597 | rep | MI | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
37478 | 37478 | Charles Stenholm S000851 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37485 | 37485 | Ted Stevens S000888 | sen | AK | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37489 | 37489 | John Sununu S001078 | rep | NH | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37502 | 37502 | William Tauzin T000058 | rep | LA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37506 | 37506 | James Turner T000424 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
37511 | 37511 | John Warner W000154 | sen | VA | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37529 | 37529 | Michael Bilirakis B000463 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 9 | |||||||||||||
37541 | 37541 | Sherwood Boehlert B000586 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 23 | |||||||||||||
37552 | 37552 | Henry Bonilla B000617 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 23 |
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);