legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "end" is on date 2007-01-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38252 | 38252 | Marilyn Musgrave M001152 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/musgrave | ||||||||||||
38259 | 38259 | Charles Norwood N000159 | rep | GA | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/norwood | ||||||||||||
38265 | 38265 | John Peterson P000263 | rep | PA | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/johnpeterson | ||||||||||||
38271 | 38271 | Charles Pickering P000323 | rep | MS | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/pickering | ||||||||||||
38274 | 38274 | Jon Porter P000589 | rep | NV | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/porter | ||||||||||||
38282 | 38282 | Deborah Pryce P000555 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 15 | http://www.house.gov/pryce | ||||||||||||
38291 | 38291 | James Ramstad R000033 | rep | MN | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/ramstad | ||||||||||||
38309 | 38309 | Ralph Regula R000141 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 16 | http://www.house.gov/regula | ||||||||||||
38312 | 38312 | Rick Renzi R000574 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38317 | 38317 | Thomas Reynolds R000569 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 26 | http://www.house.gov/reynolds | ||||||||||||
38331 | 38331 | H. Saxton S000097 | rep | NJ | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/saxton | ||||||||||||
38342 | 38342 | Christopher Shays S001144 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38347 | 38347 | Thomas Tancredo T000458 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/tancredo | ||||||||||||
38353 | 38353 | Craig Thomas T000162 | sen | WY | 2001-01-03 | 2007-01-03 | 1 | Republican | http://thomas.senate.gov/ | ||||||||||||
38363 | 38363 | James Walsh W000099 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 25 | http://www.house.gov/walsh | ||||||||||||
38370 | 38370 | David Weldon W000267 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 15 | http://www.house.gov/curtweldon | ||||||||||||
38377 | 38377 | Gerald Weller W000273 | rep | IL | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/weller | ||||||||||||
38383 | 38383 | Heather Wilson W000789 | rep | NM | 2005-01-04 | 2007-01-03 | Republican | 1 | http://wilson.house.gov | ||||||||||||
38391 | 38391 | Albert Wynn W000784 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38402 | 38402 | Neil Abercrombie A000014 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38411 | 38411 | Brian Baird B001229 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38415 | 38415 | James Barrett B001239 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38418 | 38418 | Melissa Bean B001253 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 8 | |||||||||||||
38425 | 38425 | Robert Berry B000420 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38447 | 38447 | Frederick Boucher B000657 | rep | VA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
38454 | 38454 | Allen Boyd B000716 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38460 | 38460 | Henry Brown B001235 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/henrybrown | ||||||||||||
38464 | 38464 | Virginia Brown-Waite B001247 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38473 | 38473 | Stephen Buyer B001203 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
38485 | 38485 | Michael Castle C000243 | rep | DE | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38492 | 38492 | Artur Davis D000602 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38496 | 38496 | Lincoln Davis D000599 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38505 | 38505 | Nathan Deal D000168 | rep | GA | 2005-01-04 | 2007-01-03 | Republican | 10 | http://www.house.gov/deal | ||||||||||||
38512 | 38512 | William Delahunt D000210 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38521 | 38521 | Lincoln Diaz-Balart D000299 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38532 | 38532 | Thomas Edwards E000063 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38541 | 38541 | Vernon Ehlers E000092 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38550 | 38550 | Bob Etheridge E000226 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38565 | 38565 | Barton Gordon G000309 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/gordon | ||||||||||||
38575 | 38575 | Stephanie Herseth Sandlin H001037 | rep | SD | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38591 | 38591 | Peter Hoekstra H000676 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38597 | 38597 | Bob Inglis I000023 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 4 | |||||||||||||
38612 | 38612 | Paul Kanjorski K000008 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/kanjorski | ||||||||||||
38620 | 38620 | Patrick Kennedy K000113 | rep | RI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/patrickkennedy | ||||||||||||
38627 | 38627 | Carolyn Kilpatrick K000180 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38641 | 38641 | John Linder L000321 | rep | GA | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/linder | ||||||||||||
38646 | 38646 | James Marshall M001146 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/marshall | ||||||||||||
38656 | 38656 | John McHugh M000472 | rep | NY | 2005-01-04 | 2007-01-03 | Republican | 23 | http://www.house.gov/mchugh | ||||||||||||
38661 | 38661 | Kendrick Meek M001148 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/kenmeek | ||||||||||||
38664 | 38664 | Charles Melancon M001161 | rep | LA | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
38681 | 38681 | Alan Mollohan M000844 | rep | WV | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38687 | 38687 | Dennis Moore M001140 | rep | KS | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/moore | ||||||||||||
38708 | 38708 | John Murtha M001120 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38727 | 38727 | James Oberstar O000006 | rep | MN | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/oberstar | ||||||||||||
38748 | 38748 | David Obey O000007 | rep | WI | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/obey | ||||||||||||
38762 | 38762 | Solomon Ortiz O000107 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 27 | http://www.house.gov/ortiz | ||||||||||||
38772 | 38772 | Earl Pomeroy P000422 | rep | ND | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38777 | 38777 | Adam Putnam P000586 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 12 | http://www.house.gov/putnam | ||||||||||||
38785 | 38785 | George Radanovich R000004 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 19 | http://www.radanovich.house.gov | ||||||||||||
38794 | 38794 | John Salazar S001158 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
38805 | 38805 | John Shadegg S000275 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
38822 | 38822 | Ike Skelton S000465 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38829 | 38829 | Victor Snyder S000672 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38834 | 38834 | Hilda Solis S001153 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38842 | 38842 | Mark Souder S001143 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/souder | ||||||||||||
38858 | 38858 | John Spratt S000749 | rep | SC | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38867 | 38867 | Bart Stupak S001045 | rep | MI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38878 | 38878 | John Tanner T000038 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/tanner/ | ||||||||||||
38885 | 38885 | Ellen Tauscher T000057 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38896 | 38896 | Gene Taylor T000074 | rep | MS | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38905 | 38905 | Todd Tiahrt T000260 | rep | KS | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38913 | 38913 | Zach Wamp W000119 | rep | TN | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
38918 | 38918 | Diane Watson W000794 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38925 | 38925 | Robert Wexler W000314 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 19 | http://www.wexler.house.gov | ||||||||||||
38938 | 38938 | Dennis Cardoza C001050 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38942 | 38942 | Geoff Davis D000603 | rep | KY | 2005-01-04 | 2007-01-03 | Republican | 4 | |||||||||||||
38954 | 38954 | Jane Harman H000213 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38962 | 38962 | Jay Inslee I000026 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38969 | 38969 | Thaddeus McCotter M001147 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/mccotter | ||||||||||||
38981 | 38981 | Donald Payne P000149 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38988 | 38988 | Anthony Weiner W000792 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38995 | 38995 | David Wu W000793 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39004 | 39004 | Jesse Jackson J000283 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.jessejacksonjr.org/ | ||||||||||||
39014 | 39014 | Bob Filner F000116 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39039 | 39039 | Daniel Akaka A000069 | sen | HI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://akaka.senate.gov | ||||||||||||
39044 | 39044 | Jeff Bingaman B000468 | sen | NM | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bingaman.senate.gov | ||||||||||||
39049 | 39049 | Kent Conrad C000705 | sen | ND | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://conrad.senate.gov | ||||||||||||
39053 | 39053 | Kay Hutchison H001016 | sen | TX | 2001-01-03 | 2007-01-03 | 1 | Republican | http://hutchison.senate.gov/ | ||||||||||||
39057 | 39057 | Herbert Kohl K000305 | sen | WI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://kohl.senate.gov/ | ||||||||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
39067 | 39067 | Richard Lugar L000504 | sen | IN | 2001-01-03 | 2007-01-03 | 1 | Republican | http://lugar.senate.gov/ | ||||||||||||
39069 | 39069 | Ben Nelson N000180 | sen | NE | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://bennelson.senate.gov/ | ||||||||||||
39080 | 39080 | Olympia Snowe S000663 | sen | ME | 2001-01-03 | 2007-01-03 | 1 | Republican | http://snowe.senate.gov/ | ||||||||||||
39095 | 39095 | Gary Ackerman A000022 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39102 | 39102 | W. Akin A000358 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
39114 | 39114 | Joe Baca B001234 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39124 | 39124 | Roscoe Bartlett B000208 | rep | MD | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.bartlett.house.gov | ||||||||||||
39133 | 39133 | Charles Bass B000220 | rep | NH | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/bass | ||||||||||||
39139 | 39139 | Shelley Berkley B001231 | rep | NV | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39154 | 39154 | Howard Berman B000410 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 28 | http://www.house.gov/berman |
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);