legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where start = "2007-01-04"
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37938 | 37938 | Thomas Allen A000357 | rep | ME | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37949 | 37949 | Richard Baker B000072 | rep | LA | 2007-01-04 | 2008-02-02 | Republican | 6 | http://baker.house.gov | ||||||||||||
37950 | 37950 | Nancy Boyda B001258 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://boyda.house.gov | ||||||||||||
37962 | 37962 | Robert Byrd B001210 | sen | WV | 2007-01-04 | 2010-06-28 | 1 | Democrat | http://byrd.senate.gov | ||||||||||||
37968 | 37968 | Christopher Cannon C000116 | rep | UT | 2007-01-04 | 2009-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
37974 | 37974 | Julia Carson C000191 | rep | IN | 2007-01-04 | 2007-12-15 | Democrat | 7 | http://juliacarson.house.gov | ||||||||||||
37976 | 37976 | Hillary Clinton C001041 | sen | NY | 2007-01-04 | 2009-01-21 | 1 | Democrat | http://clinton.senate.gov | ||||||||||||
37985 | 37985 | Robert Cramer C000868 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cramer.house.gov | ||||||||||||
37992 | 37992 | Barbara Cubin C000962 | rep | WY | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/cubin | ||||||||||||
37993 | 37993 | David Davis D000606 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 1 | http://daviddavis.house.gov | ||||||||||||
37997 | 37997 | Jo Ann Davis D000597 | rep | VA | 2007-01-04 | 2007-10-06 | Republican | 1 | http://joanndavis.house.gov | ||||||||||||
38004 | 38004 | Thomas Davis D000136 | rep | VA | 2007-01-04 | 2008-11-24 | Republican | 11 | http://tomdavis.house.gov | ||||||||||||
38013 | 38013 | John Doolittle D000429 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://doolittle.house.gov | ||||||||||||
38015 | 38015 | Thelma Drake D000605 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://drake.house.gov | ||||||||||||
38018 | 38018 | Rahm Emanuel E000287 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38025 | 38025 | Philip English E000187 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/english | ||||||||||||
38029 | 38029 | John Ensign E000194 | sen | NV | 2007-01-04 | 2011-05-03 | 1 | Republican | http://ensign.senate.gov | 119 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | |||||||||||
38037 | 38037 | Terry Everett E000268 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.everett.house.gov | ||||||||||||
38040 | 38040 | Tom Feeney F000447 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38044 | 38044 | Michael Ferguson F000443 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/ferguson | ||||||||||||
38046 | 38046 | Luis Fortuño F000452 | rep | PR | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/fortuno | ||||||||||||
38052 | 38052 | Vito Fossella F000440 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 13 | http://www.house.gov/fossella | ||||||||||||
38061 | 38061 | Wayne Gilchrest G000180 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/gilchrest | ||||||||||||
38071 | 38071 | Paul Gillmor G000210 | rep | OH | 2007-01-04 | 2007-09-05 | Republican | 5 | http://gillmor.house.gov | ||||||||||||
38077 | 38077 | Virgil Goode G000280 | rep | VA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/goode | ||||||||||||
38088 | 38088 | J. Hastert H000323 | rep | IL | 2007-01-04 | 2007-11-26 | Republican | 14 | http://www.house.gov/hastert | ||||||||||||
38093 | 38093 | Robin Hayes H001029 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 8 | http://hayes.house.gov | ||||||||||||
38102 | 38102 | David Hobson H000666 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/hobson | ||||||||||||
38108 | 38108 | Darlene Hooley H000762 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38114 | 38114 | Kenny Hulshof H000948 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 9 | http://hulshof.house.gov | ||||||||||||
38128 | 38128 | Duncan Hunter H000981 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38137 | 38137 | William Jefferson J000070 | rep | LA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38139 | 38139 | Bobby Jindal J000287 | rep | LA | 2007-01-04 | 2008-01-14 | Republican | 1 | http://www.house.gov/jindal | ||||||||||||
38144 | 38144 | Stephanie Jones J000284 | rep | OH | 2007-01-04 | 2008-08-20 | Democrat | 11 | http://www.house.gov/tubbsjones | ||||||||||||
38148 | 38148 | Ric Keller K000361 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/keller/Frset.htm | ||||||||||||
38157 | 38157 | Edward Kennedy K000105 | sen | MA | 2007-01-04 | 2009-08-25 | 1 | Democrat | http://kennedy.senate.gov/ | ||||||||||||
38165 | 38165 | Joseph Knollenberg K000288 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/knollenberg | ||||||||||||
38167 | 38167 | John Kuhl K000364 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 29 | http://www.house.gov/kuhl | ||||||||||||
38174 | 38174 | Ray LaHood L000552 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 18 | http://www.house.gov/lahood | ||||||||||||
38179 | 38179 | Nicholas Lampson L000043 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://lampson.house.gov | ||||||||||||
38193 | 38193 | Tom Lantos L000090 | rep | CA | 2007-01-04 | 2008-02-11 | Democrat | 12 | http://lantos.house.gov | ||||||||||||
38201 | 38201 | Ron Lewis L000293 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/ronlewis | ||||||||||||
38213 | 38213 | Trent Lott L000447 | sen | MS | 2007-01-04 | 2007-12-18 | 1 | Republican | http://lott.senate.gov/ | ||||||||||||
38214 | 38214 | Tim Mahoney M001164 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://mahoney.house.gov | ||||||||||||
38225 | 38225 | James McCrery M000388 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://mccrery.house.gov | ||||||||||||
38235 | 38235 | Michael McNulty M000590 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 21 | http://www.house.gov/mcnulty | ||||||||||||
38243 | 38243 | Martin Meehan M000627 | rep | MA | 2007-01-04 | 2007-07-01 | Democrat | 5 | http://www.house.gov/meehan | ||||||||||||
38250 | 38250 | Juanita Millender-McDonald M000714 | rep | CA | 2007-01-04 | 2007-04-22 | Democrat | 37 | http://millender-mcdonald.house.gov | ||||||||||||
38253 | 38253 | Marilyn Musgrave M001152 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 4 | http://musgrave.house.gov | ||||||||||||
38260 | 38260 | Charles Norwood N000159 | rep | GA | 2007-01-04 | 2007-02-13 | Republican | 10 | http://www.house.gov/norwood | ||||||||||||
38266 | 38266 | John Peterson P000263 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/johnpeterson | ||||||||||||
38272 | 38272 | Charles Pickering P000323 | rep | MS | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/pickering | ||||||||||||
38275 | 38275 | Jon Porter P000589 | rep | NV | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/porter | ||||||||||||
38283 | 38283 | Deborah Pryce P000555 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 15 | http://www.house.gov/pryce | ||||||||||||
38292 | 38292 | James Ramstad R000033 | rep | MN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/ramstad | ||||||||||||
38310 | 38310 | Ralph Regula R000141 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 16 | http://wwwc.house.gov/regula | ||||||||||||
38313 | 38313 | Rick Renzi R000574 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38318 | 38318 | Thomas Reynolds R000569 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 26 | http://reynolds.house.gov | ||||||||||||
38319 | 38319 | Bill Sali S001167 | rep | ID | 2007-01-04 | 2009-01-03 | Republican | 1 | http://sali.house.gov | ||||||||||||
38332 | 38332 | H. Saxton S000097 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/saxton | ||||||||||||
38343 | 38343 | Christopher Shays S001144 | rep | CT | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38348 | 38348 | Thomas Tancredo T000458 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 6 | http://tancredo.house.gov | ||||||||||||
38354 | 38354 | Craig Thomas T000162 | sen | WY | 2007-01-04 | 2007-06-04 | 1 | Republican | http://thomas.senate.gov/ | ||||||||||||
38364 | 38364 | James Walsh W000099 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 25 | http://www.house.gov/walsh | ||||||||||||
38371 | 38371 | David Weldon W000267 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 15 | http://weldon.house.gov | ||||||||||||
38378 | 38378 | Gerald Weller W000273 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 11 | http://www.house.gov/weller | ||||||||||||
38384 | 38384 | Heather Wilson W000789 | rep | NM | 2007-01-04 | 2009-01-03 | Republican | 1 | http://wilson.house.gov | ||||||||||||
38392 | 38392 | Albert Wynn W000784 | rep | MD | 2007-01-04 | 2008-05-31 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38403 | 38403 | Neil Abercrombie A000014 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38406 | 38406 | Michael Arcuri A000363 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
38412 | 38412 | Brian Baird B001229 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38416 | 38416 | James Barrett B001239 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38419 | 38419 | Melissa Bean B001253 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
38426 | 38426 | Robert Berry B000420 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38448 | 38448 | Frederick Boucher B000657 | rep | VA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
38455 | 38455 | Allen Boyd B000716 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38461 | 38461 | Henry Brown B001235 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
38465 | 38465 | Virginia Brown-Waite B001247 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38474 | 38474 | Stephen Buyer B001203 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
38477 | 38477 | Christopher Carney C001065 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
38486 | 38486 | Michael Castle C000243 | rep | DE | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38493 | 38493 | Artur Davis D000602 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38497 | 38497 | Lincoln Davis D000599 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38506 | 38506 | Nathan Deal D000168 | rep | GA | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/deal | ||||||||||||
38513 | 38513 | William Delahunt D000210 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38522 | 38522 | Lincoln Diaz-Balart D000299 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38533 | 38533 | Thomas Edwards E000063 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38542 | 38542 | Vernon Ehlers E000092 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38544 | 38544 | Brad Ellsworth E000289 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
38551 | 38551 | Bob Etheridge E000226 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38553 | 38553 | Mary Fallin F000453 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
38566 | 38566 | Barton Gordon G000309 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
38569 | 38569 | John Hall H001039 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 19 | http://johnhall.house.gov | ||||||||||||
38572 | 38572 | Phil Hare H001040 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://hare.house.gov | ||||||||||||
38576 | 38576 | Stephanie Herseth Sandlin H001037 | rep | SD | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38581 | 38581 | Baron Hill H001030 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
38583 | 38583 | Paul Hodes H001043 | rep | NH | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
38592 | 38592 | Peter Hoekstra H000676 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38598 | 38598 | Bob Inglis I000023 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 4 | http://inglis.house.gov | ||||||||||||
38600 | 38600 | Steve Kagen K000365 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://kagen.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);