legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "start" is on date 2003-01-07 sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37273 | 37273 | Larry Combest C000653 | rep | TX | 2003-01-07 | 2003-05-31 | Republican | 19 | http://www.house.gov/combest | ||||||||||||
37328 | 37328 | Ernest Fletcher F000441 | rep | KY | 2003-01-07 | 2003-12-08 | Republican | 6 | http://www.house.gov/fletcher | ||||||||||||
37384 | 37384 | William Janklow J000286 | rep | SD | 2003-01-07 | 2004-01-20 | Republican | 0 | http://www.house.gov/janklow | ||||||||||||
37229 | 37229 | Frank Ballance B001238 | rep | NC | 2003-01-07 | 2004-06-11 | Democrat | 1 | http://www.house.gov/ballance | ||||||||||||
37253 | 37253 | Douglas Bereuter B000403 | rep | NE | 2003-01-07 | 2004-08-31 | Republican | 1 | http://www.house.gov/bereuter | ||||||||||||
37363 | 37363 | Porter Goss G000336 | rep | FL | 2003-01-07 | 2004-09-23 | Republican | 14 | http://www.house.gov/goss | ||||||||||||
37223 | 37223 | Aníbal Acevedo-Vilá A000359 | rep | PR | 2003-01-07 | 2005-01-03 | Popular Democrat | 0 | http://www.house.gov/acevedo-vila | ||||||||||||
37239 | 37239 | Cass Ballenger B000104 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/ballenger | ||||||||||||
37240 | 37240 | Chris Bell B001241 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 25 | http://www.house.gov/bell | ||||||||||||
37254 | 37254 | Max Burns B001249 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 12 | http://www.house.gov/burns | ||||||||||||
37256 | 37256 | Brad Carson C001044 | rep | OK | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://carson.house.gov | ||||||||||||
37263 | 37263 | Michael Collins C000640 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/maccollins | ||||||||||||
37299 | 37299 | Philip Crane C000873 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/crane | ||||||||||||
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 | ||||||||||||
37325 | 37325 | Jennifer Dunn D000549 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/dunn | ||||||||||||
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 | ||||||||||||
37369 | 37369 | James Greenwood G000439 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/greenwood | ||||||||||||
37374 | 37374 | Joseph Hoeffel H001031 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/hoeffel | ||||||||||||
37383 | 37383 | Amory Houghton H000814 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 29 | http://www.house.gov/houghton | ||||||||||||
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/ | ||||||||||||
37438 | 37438 | Scott McInnis M000477 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/mcinnis | ||||||||||||
37443 | 37443 | George Nethercutt N000051 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nethercutt | ||||||||||||
37446 | 37446 | Doug Ose O000164 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ose | ||||||||||||
37452 | 37452 | Jack Quinn Q000016 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 27 | http://www.house.gov/quinn | ||||||||||||
37456 | 37456 | Max Sandlin S000044 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/sandlin | ||||||||||||
37458 | 37458 | Edward Schrock S001151 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://schrock.house.gov | ||||||||||||
37466 | 37466 | Nick Smith S000597 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/nicksmith | ||||||||||||
37479 | 37479 | Charles Stenholm S000851 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/stenholm | ||||||||||||
37503 | 37503 | William Tauzin T000058 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/tauzin | ||||||||||||
37507 | 37507 | James Turner T000424 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/turner | ||||||||||||
37515 | 37515 | Bob Beauprez B001240 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37530 | 37530 | Michael Bilirakis B000463 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
37542 | 37542 | Sherwood Boehlert B000586 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 24 | http://www.house.gov/boehlert | ||||||||||||
37553 | 37553 | Henry Bonilla B000617 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 23 | http://www.house.gov/bonilla | ||||||||||||
37555 | 37555 | Jeb Bradley B001246 | rep | NH | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bradley | ||||||||||||
37569 | 37569 | Chris Chocola C001052 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/chocola | ||||||||||||
37578 | 37578 | C. Cox C000830 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 48 | http://cox.house.gov | ||||||||||||
37586 | 37586 | Randall Cunningham C000994 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
37591 | 37591 | James Davis D000114 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37602 | 37602 | Thomas DeLay D000217 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 22 | http://tomdelay.house.gov | ||||||||||||
37632 | 37632 | Lane Evans E000250 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/evans | ||||||||||||
37641 | 37641 | Mark Foley F000238 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 16 | http://www.house.gov/foley | ||||||||||||
37646 | 37646 | Harold Ford F000262 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/ford | ||||||||||||
37651 | 37651 | James Gibbons G000152 | rep | NV | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/gibbons | ||||||||||||
37655 | 37655 | Mark Green G000545 | rep | WI | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/markgreen | ||||||||||||
37668 | 37668 | Gilbert Gutknecht G000536 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.gil.house.gov | ||||||||||||
37670 | 37670 | Katherine Harris H001035 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/harris | ||||||||||||
37673 | 37673 | Melissa Hart H001033 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://hart.house.gov | ||||||||||||
37679 | 37679 | John Hayworth H000413 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37689 | 37689 | Joel Hefley H000444 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hefley | ||||||||||||
37695 | 37695 | John Hostettler H000807 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/hostettler | ||||||||||||
37711 | 37711 | Henry Hyde H001022 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/hyde | ||||||||||||
37718 | 37718 | Ernest Istook I000047 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/istook | ||||||||||||
37723 | 37723 | William Jenkins J000082 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/jenkins | ||||||||||||
37735 | 37735 | Nancy Johnson J000163 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37741 | 37741 | Sue Kelly K000078 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 19 | http://www.house.gov/suekelly | ||||||||||||
37744 | 37744 | Mark Kennedy K000358 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 6 | http://markkennedy.house.gov | ||||||||||||
37755 | 37755 | James Kolbe K000306 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
37770 | 37770 | James Leach L000169 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/leach | ||||||||||||
37787 | 37787 | Robert Ney N000081 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 18 | http://www.house.gov/ney | ||||||||||||
37792 | 37792 | Anne Northup N000143 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/northup | ||||||||||||
37800 | 37800 | James Nussle N000172 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://nussle.house.gov | ||||||||||||
37803 | 37803 | Thomas Osborne O000165 | rep | NE | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/osborne | ||||||||||||
37806 | 37806 | C.L. Otter O000166 | rep | ID | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/otter | ||||||||||||
37818 | 37818 | Major Owens O000159 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/owens | ||||||||||||
37831 | 37831 | Michael Oxley O000163 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/oxley | ||||||||||||
37838 | 37838 | Richard Pombo P000419 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/pombo/pombo.htm | ||||||||||||
37844 | 37844 | Jim Ryun R000566 | rep | KS | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/ryun | ||||||||||||
37858 | 37858 | Martin Sabo S000005 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/sabo | ||||||||||||
37873 | 37873 | E. Shaw S000303 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 22 | http://www.house.gov/shaw | ||||||||||||
37877 | 37877 | Donald Sherwood S001146 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/sherwood | ||||||||||||
37880 | 37880 | Robert Simmons S001152 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
37892 | 37892 | Ted Strickland S001004 | rep | OH | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/strickland | ||||||||||||
37896 | 37896 | John Sweeney S001149 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 20 | http://www.house.gov/sweeney | ||||||||||||
37904 | 37904 | Charles Taylor T000067 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/charlestaylor | ||||||||||||
37918 | 37918 | William Thomas T000188 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 22 | http://www.house.gov/billthomas | ||||||||||||
37930 | 37930 | W. Weldon W000268 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 7 | http://curtweldon.house.gov/ | ||||||||||||
37936 | 37936 | Thomas Allen A000357 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37947 | 37947 | Richard Baker B000072 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
37966 | 37966 | Christopher Cannon C000116 | rep | UT | 2003-01-07 | 2005-01-03 | Republican | 3 | http://chriscannon.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 | ||||||||||||
37990 | 37990 | Barbara Cubin C000962 | rep | WY | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
37995 | 37995 | Jo Ann Davis D000597 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/joanndavis | ||||||||||||
38002 | 38002 | Thomas Davis D000136 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/tomdavis | ||||||||||||
38011 | 38011 | John Doolittle D000429 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/doolittle | ||||||||||||
38016 | 38016 | Rahm Emanuel E000287 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38023 | 38023 | Philip English E000187 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/english | ||||||||||||
38035 | 38035 | Terry Everett E000268 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38038 | 38038 | Tom Feeney F000447 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38042 | 38042 | Michael Ferguson F000443 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/ferguson | ||||||||||||
38050 | 38050 | Vito Fossella F000440 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/fossella |
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);