legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "start" is on date 2001-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36780 | 36780 | George Allen A000121 | sen | VA | 2001-01-03 | 2007-01-03 | 1 | Republican | http://allen.senate.gov | ||||||||||||
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 | |||||||||||||
36844 | 36844 | Conrad Burns B001126 | sen | MT | 2001-01-03 | 2007-01-03 | 1 | Republican | http://burns.senate.gov | ||||||||||||
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 | ||||||||||||
36856 | 36856 | Lincoln Chafee C001040 | sen | RI | 2001-01-03 | 2007-01-03 | 1 | Republican | http://chafee.senate.gov | ||||||||||||
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 | |||||||||||||
36881 | 36881 | Jon Corzine C001042 | sen | NJ | 2001-01-03 | 2006-01-17 | 1 | Democrat | http://corzine.senate.gov | ||||||||||||
36892 | 36892 | William Coyne C000846 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
36893 | 36893 | Mark Dayton D000596 | sen | MN | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://dayton.senate.gov | ||||||||||||
36899 | 36899 | Michael DeWine D000294 | sen | OH | 2001-01-03 | 2007-01-03 | 1 | Republican | http://dewine.senate.gov | ||||||||||||
36903 | 36903 | Robert Ehrlich E000093 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
36905 | 36905 | William Frist F000439 | sen | TN | 2001-01-03 | 2007-01-03 | 1 | Republican | http://frist.senate.gov | ||||||||||||
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 | |||||||||||||
36947 | 36947 | Tony Hall H000074 | rep | OH | 2001-01-03 | 2002-09-09 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
36975 | 36975 | Asa Hutchinson H001014 | rep | AR | 2001-01-03 | 2001-08-06 | Republican | 3 | |||||||||||||
36985 | 36985 | James Jeffords J000072 | sen | VT | 2001-01-03 | 2007-01-03 | 1 | Independent | [ { "start": "2001-01-03", "end": "2001-06-06", "party": "Republican" }, { "start": "2001-06-06", "end": "2007-01-03", "party": "Independent", "caucus": "Democrat" } ] |
http://jeffords.senate.gov/ | Democrat | ||||||||||
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 | |||||||||||||
37005 | 37005 | Steve Largent L000096 | rep | OK | 2001-01-03 | 2002-02-15 | Republican | 1 | |||||||||||||
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 | |||||||||||||
37039 | 37039 | Patsy Mink M000797 | rep | HI | 2001-01-03 | 2002-09-28 | Democrat | 2 | |||||||||||||
37054 | 37054 | John Moakley M000834 | rep | MA | 2001-01-03 | 2001-05-28 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
37092 | 37092 | Richard Santorum S000059 | sen | PA | 2001-01-03 | 2007-01-03 | 1 | Republican | http://santorum.senate.gov/ | ||||||||||||
37100 | 37100 | Paul Sarbanes S000064 | sen | MD | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://sarbanes.senate.gov/ | ||||||||||||
37108 | 37108 | Thomas Sawyer S000094 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
37112 | 37112 | Joe Scarborough S000106 | rep | FL | 2001-01-03 | 2001-09-05 | Republican | 1 | |||||||||||||
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 | |||||||||||||
37132 | 37132 | Elmer Shuster S000394 | rep | PA | 2001-01-03 | 2001-02-05 | Republican | 9 | |||||||||||||
37142 | 37142 | Norman Sisisky S000453 | rep | VA | 2001-01-03 | 2001-03-29 | Democrat | 4 | |||||||||||||
37153 | 37153 | Joseph Skeen S000463 | rep | NM | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37169 | 37169 | Floyd Spence S000718 | rep | SC | 2001-01-03 | 2001-08-16 | 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 | |||||||||||||
37196 | 37196 | James Traficant T000350 | rep | OH | 2001-01-03 | 2002-07-24 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
37222 | 37222 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2001-01-03 | 2003-01-03 | AL | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
37489 | 37489 | John Sununu S001078 | rep | NH | 2001-01-03 | 2003-01-03 | Republican | 1 |
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);