legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2005-01-04 sorted by how
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
37516 | 37516 | Bob Beauprez B001240 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37519 | 37519 | Robert Bennett B000382 | sen | UT | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bennett.senate.gov | ||||||||||||
37531 | 37531 | Michael Bilirakis B000463 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
37543 | 37543 | Sherwood Boehlert B000586 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 24 | http://www.house.gov/boehlert | ||||||||||||
37547 | 37547 | Christopher Bond B000611 | sen | MO | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bond.senate.gov | ||||||||||||
37554 | 37554 | Henry Bonilla B000617 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 23 | http://www.house.gov/bonilla | ||||||||||||
37556 | 37556 | Jeb Bradley B001246 | rep | NH | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/bradley | ||||||||||||
37560 | 37560 | Samuel Brownback B000953 | sen | KS | 2005-01-04 | 2011-01-03 | 3 | Republican | http://brownback.senate.gov | ||||||||||||
37568 | 37568 | Jim Bunning B001066 | sen | KY | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bunning.senate.gov | ||||||||||||
37570 | 37570 | Chris Chocola C001052 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/chocola | ||||||||||||
37579 | 37579 | C. Cox C000830 | rep | CA | 2005-01-04 | 2005-08-02 | Republican | 48 | http://cox.house.gov | ||||||||||||
37587 | 37587 | Randall Cunningham C000994 | rep | CA | 2005-01-04 | 2005-12-01 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
37592 | 37592 | James Davis D000114 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37603 | 37603 | Thomas DeLay D000217 | rep | TX | 2005-01-04 | 2006-06-09 | Republican | 22 | http://tomdelay.house.gov | ||||||||||||
37611 | 37611 | Christopher Dodd D000388 | sen | CT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dodd.senate.gov | ||||||||||||
37621 | 37621 | Byron Dorgan D000432 | sen | ND | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dorgan.senate.gov | ||||||||||||
37633 | 37633 | Lane Evans E000250 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/evans | ||||||||||||
37636 | 37636 | Russell Feingold F000061 | sen | WI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://feingold.senate.gov | ||||||||||||
37642 | 37642 | Mark Foley F000238 | rep | FL | 2005-01-04 | 2006-09-29 | Republican | 16 | http://www.house.gov/foley | ||||||||||||
37647 | 37647 | Harold Ford F000262 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/ford | ||||||||||||
37652 | 37652 | James Gibbons G000152 | rep | NV | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/gibbons | ||||||||||||
37656 | 37656 | Mark Green G000545 | rep | WI | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/markgreen | ||||||||||||
37663 | 37663 | Judd Gregg G000445 | sen | NH | 2005-01-04 | 2011-01-03 | 3 | Republican | http://gregg.senate.gov/ | ||||||||||||
37669 | 37669 | Gilbert Gutknecht G000536 | rep | MN | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.gil.house.gov | ||||||||||||
37671 | 37671 | Katherine Harris H001035 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 13 | http://www.house.gov/harris | ||||||||||||
37674 | 37674 | Melissa Hart H001033 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://hart.house.gov | ||||||||||||
37680 | 37680 | John Hayworth H000413 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37690 | 37690 | Joel Hefley H000444 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/hefley | ||||||||||||
37696 | 37696 | John Hostettler H000807 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/hostettler | ||||||||||||
37712 | 37712 | Henry Hyde H001022 | rep | IL | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/hyde | ||||||||||||
37719 | 37719 | Ernest Istook I000047 | rep | OK | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/istook | ||||||||||||
37724 | 37724 | William Jenkins J000082 | rep | TN | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/jenkins | ||||||||||||
37736 | 37736 | Nancy Johnson J000163 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37742 | 37742 | Sue Kelly K000078 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 19 | http://www.house.gov/suekelly | ||||||||||||
37745 | 37745 | Mark Kennedy K000358 | rep | MN | 2005-01-04 | 2007-01-03 | Republican | 6 | http://markkennedy.house.gov | ||||||||||||
37756 | 37756 | James Kolbe K000306 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
37771 | 37771 | James Leach L000169 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/leach | ||||||||||||
37775 | 37775 | Blanche Lincoln L000035 | sen | AR | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
37776 | 37776 | Mel Martinez M001162 | sen | FL | 2005-01-04 | 2009-09-09 | 3 | Republican | http://martinez.senate.gov | ||||||||||||
37782 | 37782 | Cynthia McKinney M000523 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 4 | |||||||||||||
37788 | 37788 | Robert Ney N000081 | rep | OH | 2005-01-04 | 2006-11-03 | Republican | 18 | http://www.house.gov/ney | ||||||||||||
37793 | 37793 | Anne Northup N000143 | rep | KY | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/northup | ||||||||||||
37801 | 37801 | James Nussle N000172 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 1 | http://nussle.house.gov | ||||||||||||
37804 | 37804 | Thomas Osborne O000165 | rep | NE | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/osborne | ||||||||||||
37807 | 37807 | C.L. Otter O000166 | rep | ID | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/otter | ||||||||||||
37819 | 37819 | Major Owens O000159 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/owens | ||||||||||||
37832 | 37832 | Michael Oxley O000163 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/oxley | ||||||||||||
37839 | 37839 | Richard Pombo P000419 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/pombo/pombo.htm | ||||||||||||
37845 | 37845 | Jim Ryun R000566 | rep | KS | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/ryun | ||||||||||||
37859 | 37859 | Martin Sabo S000005 | rep | MN | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/sabo | ||||||||||||
37860 | 37860 | Ken Salazar S001163 | sen | CO | 2005-01-04 | 2009-01-21 | 3 | Democrat | http://salazar.senate.gov | ||||||||||||
37861 | 37861 | John Schwarz S001161 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 7 | |||||||||||||
37874 | 37874 | E. Shaw S000303 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 22 | http://www.house.gov/shaw | ||||||||||||
37878 | 37878 | Donald Sherwood S001146 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 10 | http://www.house.gov/sherwood | ||||||||||||
37881 | 37881 | Robert Simmons S001152 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
37882 | 37882 | Michael Sodrel S001160 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 9 | |||||||||||||
37887 | 37887 | Arlen Specter S000709 | sen | PA | 2005-01-04 | 2011-01-03 | 3 | Democrat | [ { "start": "2005-01-04", "end": "2009-04-30", "party": "Republican" }, { "start": "2009-04-30", "end": "2011-01-03", "party": "Democrat" } ] |
http://specter.senate.gov/ | |||||||||||
37893 | 37893 | Ted Strickland S001004 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/strickland | ||||||||||||
37897 | 37897 | John Sweeney S001149 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 20 | http://www.house.gov/sweeney | ||||||||||||
37905 | 37905 | Charles Taylor T000067 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/charlestaylor | ||||||||||||
37919 | 37919 | William Thomas T000188 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 22 | http://www.house.gov/billthomas | ||||||||||||
37921 | 37921 | George Voinovich V000126 | sen | OH | 2005-01-04 | 2011-01-03 | 3 | Republican | http://voinovich.senate.gov/ | ||||||||||||
37931 | 37931 | W. Weldon W000268 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 7 | http://curtweldon.house.gov/ | ||||||||||||
37937 | 37937 | Thomas Allen A000357 | rep | ME | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37948 | 37948 | Richard Baker B000072 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/baker | ||||||||||||
37967 | 37967 | Christopher Cannon C000116 | rep | UT | 2005-01-04 | 2007-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
37973 | 37973 | Julia Carson C000191 | rep | IN | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.juliacarson.house.gov | ||||||||||||
37984 | 37984 | Robert Cramer C000868 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
37991 | 37991 | Barbara Cubin C000962 | rep | WY | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
37996 | 37996 | Jo Ann Davis D000597 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/joanndavis | ||||||||||||
38003 | 38003 | Thomas Davis D000136 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/tomdavis | ||||||||||||
38012 | 38012 | John Doolittle D000429 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/doolittle | ||||||||||||
38014 | 38014 | Thelma Drake D000605 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 2 | |||||||||||||
38017 | 38017 | Rahm Emanuel E000287 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38024 | 38024 | Philip English E000187 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/english | ||||||||||||
38036 | 38036 | Terry Everett E000268 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38039 | 38039 | Tom Feeney F000447 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38043 | 38043 | Michael Ferguson F000443 | rep | NJ | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/ferguson | ||||||||||||
38045 | 38045 | Luis Fortuño F000452 | rep | PR | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/fortuno | ||||||||||||
38051 | 38051 | Vito Fossella F000440 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 13 | http://www.house.gov/fossella | ||||||||||||
38060 | 38060 | Wayne Gilchrest G000180 | rep | MD | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/gilchrest | ||||||||||||
38070 | 38070 | Paul Gillmor G000210 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 5 | http://gillmor.house.gov | ||||||||||||
38076 | 38076 | Virgil Goode G000280 | rep | VA | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/goode | ||||||||||||
38087 | 38087 | J. Hastert H000323 | rep | IL | 2005-01-04 | 2007-01-03 | Republican | 14 | http://www.house.gov/hastert | ||||||||||||
38092 | 38092 | Robin Hayes H001029 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/hayes | ||||||||||||
38101 | 38101 | David Hobson H000666 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/hobson | ||||||||||||
38107 | 38107 | Darlene Hooley H000762 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38113 | 38113 | Kenny Hulshof H000948 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/hulshof | ||||||||||||
38127 | 38127 | Duncan Hunter H000981 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38136 | 38136 | William Jefferson J000070 | rep | LA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38138 | 38138 | Bobby Jindal J000287 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 1 | |||||||||||||
38143 | 38143 | Stephanie Jones J000284 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/tubbsjones | ||||||||||||
38147 | 38147 | Ric Keller K000361 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/keller/ | ||||||||||||
38164 | 38164 | Joseph Knollenberg K000288 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/knollenberg | ||||||||||||
38166 | 38166 | John Kuhl K000364 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 29 | |||||||||||||
38173 | 38173 | Ray LaHood L000552 | rep | IL | 2005-01-04 | 2007-01-03 | Republican | 18 | http://www.house.gov/lahood | ||||||||||||
38192 | 38192 | Tom Lantos L000090 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38200 | 38200 | Ron Lewis L000293 | rep | KY | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/ronlewis | ||||||||||||
38224 | 38224 | James McCrery M000388 | rep | LA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/mccrery |
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);