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 caucus
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36521 | 36521 | John Breaux B000780 | sen | LA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://breaux.senate.gov/ | ||||||||||||
36544 | 36544 | Ben Campbell C000077 | sen | CO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://campbell.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/ | ||||||||||||
36609 | 36609 | Peter Fitzgerald F000442 | sen | IL | 1999-01-06 | 2005-01-03 | 3 | Republican | http://fitzgerald.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/ | ||||||||||||
36723 | 36723 | Don Nickles N000102 | sen | OK | 1999-01-06 | 2005-01-03 | 3 | Republican | http://nickles.senate.gov/ | ||||||||||||
36778 | 36778 | Zell Miller M001141 | sen | GA | 2000-07-24 | 2005-01-03 | 3 | Democrat | appointment | http://miller.senate.gov/ | |||||||||||
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 | ||||||||||||
37513 | 37513 | Evan Bayh B001233 | sen | IN | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://bayh.senate.gov/ | ||||||||||||
37515 | 37515 | Bob Beauprez B001240 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37518 | 37518 | Robert Bennett B000382 | sen | UT | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bennett.senate.gov/ | ||||||||||||
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 | ||||||||||||
37546 | 37546 | Christopher Bond B000611 | sen | MO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bond.senate.gov/ | ||||||||||||
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 | ||||||||||||
37559 | 37559 | Samuel Brownback B000953 | sen | KS | 1999-01-06 | 2005-01-03 | 3 | Republican | http://brownback.senate.gov/ | ||||||||||||
37567 | 37567 | Jim Bunning B001066 | sen | KY | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bunning.senate.gov/ | ||||||||||||
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 | ||||||||||||
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/ | ||||||||||||
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 | ||||||||||||
37662 | 37662 | Judd Gregg G000445 | sen | NH | 1999-01-06 | 2005-01-03 | 3 | Republican | http://gregg.senate.gov/ | ||||||||||||
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 | ||||||||||||
37774 | 37774 | Blanche Lincoln L000035 | sen | AR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
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 | ||||||||||||
37886 | 37886 | Arlen Specter S000709 | sen | PA | 1999-01-06 | 2005-01-03 | 3 | Republican | http://specter.senate.gov/ | ||||||||||||
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 | ||||||||||||
37920 | 37920 | George Voinovich V000126 | sen | OH | 1999-01-06 | 2005-01-03 | 3 | Republican | http://voinovich.senate.gov/ | ||||||||||||
37930 | 37930 | W. Weldon W000268 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 7 | http://curtweldon.house.gov/ |
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);