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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
38059 | 38059 | Wayne Gilchrest G000180 | rep | MD | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/gilchrest | ||||||||||||
38069 | 38069 | Paul Gillmor G000210 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 5 | http://gillmor.house.gov | ||||||||||||
38075 | 38075 | Virgil Goode G000280 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/goode | ||||||||||||
38086 | 38086 | J. Hastert H000323 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 14 | http://www.house.gov/hastert | ||||||||||||
38091 | 38091 | Robin Hayes H001029 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/hayes | ||||||||||||
38100 | 38100 | David Hobson H000666 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/hobson | ||||||||||||
38106 | 38106 | Darlene Hooley H000762 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38112 | 38112 | Kenny Hulshof H000948 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/hulshof | ||||||||||||
38126 | 38126 | Duncan Hunter H000981 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38135 | 38135 | William Jefferson J000070 | rep | LA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38142 | 38142 | Stephanie Jones J000284 | rep | OH | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/tubbsjones | ||||||||||||
38146 | 38146 | Ric Keller K000361 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/keller/ | ||||||||||||
38163 | 38163 | Joseph Knollenberg K000288 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/knollenberg | ||||||||||||
38172 | 38172 | Ray LaHood L000552 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 18 | http://www.house.gov/lahood | ||||||||||||
38178 | 38178 | Nicholas Lampson L000043 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/lampson | ||||||||||||
38191 | 38191 | Tom Lantos L000090 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38199 | 38199 | Ron Lewis L000293 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/ronlewis | ||||||||||||
38223 | 38223 | James McCrery M000388 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/mccrery | ||||||||||||
38233 | 38233 | Michael McNulty M000590 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 21 | http://www.house.gov/mcnulty | ||||||||||||
38241 | 38241 | Martin Meehan M000627 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/meehan | ||||||||||||
38248 | 38248 | Juanita Millender-McDonald M000714 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 37 | http://www.house.gov/millender-mcdonald | ||||||||||||
38251 | 38251 | Marilyn Musgrave M001152 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/musgrave | ||||||||||||
38258 | 38258 | Charles Norwood N000159 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/norwood | ||||||||||||
38264 | 38264 | John Peterson P000263 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/johnpeterson | ||||||||||||
38270 | 38270 | Charles Pickering P000323 | rep | MS | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/pickering | ||||||||||||
38273 | 38273 | Jon Porter P000589 | rep | NV | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/porter | ||||||||||||
38281 | 38281 | Deborah Pryce P000555 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 15 | http://www.house.gov/pryce | ||||||||||||
38290 | 38290 | James Ramstad R000033 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ramstad | ||||||||||||
38308 | 38308 | Ralph Regula R000141 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 16 | http://www.house.gov/regula | ||||||||||||
38311 | 38311 | Rick Renzi R000574 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38316 | 38316 | Thomas Reynolds R000569 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 26 | http://www.house.gov/reynolds | ||||||||||||
38330 | 38330 | H. Saxton S000097 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/saxton | ||||||||||||
38341 | 38341 | Christopher Shays S001144 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38346 | 38346 | Thomas Tancredo T000458 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/tancredo | ||||||||||||
38362 | 38362 | James Walsh W000099 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 25 | http://www.house.gov/walsh | ||||||||||||
38369 | 38369 | David Weldon W000267 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 15 | http://www.house.gov/curtweldon | ||||||||||||
38376 | 38376 | Gerald Weller W000273 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/weller | ||||||||||||
38382 | 38382 | Heather Wilson W000789 | rep | NM | 2003-01-07 | 2005-01-03 | Republican | 1 | http://wilson.house.gov | ||||||||||||
38390 | 38390 | Albert Wynn W000784 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38410 | 38410 | Brian Baird B001229 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38414 | 38414 | James Barrett B001239 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38433 | 38433 | Joseph Biden B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
38446 | 38446 | Frederick Boucher B000657 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/boucher | ||||||||||||
38453 | 38453 | Allen Boyd B000716 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38459 | 38459 | Henry Brown B001235 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/henrybrown | ||||||||||||
38463 | 38463 | Virginia Brown-Waite B001247 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38472 | 38472 | Stephen Buyer B001203 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
38484 | 38484 | Michael Castle C000243 | rep | DE | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38491 | 38491 | Artur Davis D000602 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38495 | 38495 | Lincoln Davis D000599 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38504 | 38504 | Nathan Deal D000168 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 10 | http://www.house.gov/deal | ||||||||||||
38511 | 38511 | William Delahunt D000210 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38520 | 38520 | Lincoln Diaz-Balart D000299 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38531 | 38531 | Thomas Edwards E000063 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/edwards | ||||||||||||
38540 | 38540 | Vernon Ehlers E000092 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38549 | 38549 | Bob Etheridge E000226 | rep | NC | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38564 | 38564 | Barton Gordon G000309 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/gordon | ||||||||||||
38580 | 38580 | Baron Hill H001030 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/baronhill | ||||||||||||
38590 | 38590 | Peter Hoekstra H000676 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38611 | 38611 | Paul Kanjorski K000008 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/kanjorski | ||||||||||||
38619 | 38619 | Patrick Kennedy K000113 | rep | RI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/patrickkennedy | ||||||||||||
38626 | 38626 | Carolyn Kilpatrick K000180 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38640 | 38640 | John Linder L000321 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/linder | ||||||||||||
38645 | 38645 | James Marshall M001146 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/marshall | ||||||||||||
38655 | 38655 | John McHugh M000472 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 23 | http://www.house.gov/mchugh | ||||||||||||
38660 | 38660 | Kendrick Meek M001148 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/kenmeek | ||||||||||||
38680 | 38680 | Alan Mollohan M000844 | rep | WV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38686 | 38686 | Dennis Moore M001140 | rep | KS | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/moore | ||||||||||||
38707 | 38707 | John Murtha M001120 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38726 | 38726 | James Oberstar O000006 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/oberstar | ||||||||||||
38747 | 38747 | David Obey O000007 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/obey | ||||||||||||
38761 | 38761 | Solomon Ortiz O000107 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 27 | http://www.house.gov/ortiz | ||||||||||||
38771 | 38771 | Earl Pomeroy P000422 | rep | ND | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38776 | 38776 | Adam Putnam P000586 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 12 | http://www.house.gov/putnam | ||||||||||||
38784 | 38784 | George Radanovich R000004 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 19 | http://www.radanovich.house.gov | ||||||||||||
38791 | 38791 | Ciro Rodriguez R000568 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 28 | http://www.house.gov/rodriguez | ||||||||||||
38804 | 38804 | John Shadegg S000275 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
38821 | 38821 | Ike Skelton S000465 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38828 | 38828 | Victor Snyder S000672 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38833 | 38833 | Hilda Solis S001153 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38841 | 38841 | Mark Souder S001143 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/souder | ||||||||||||
38857 | 38857 | John Spratt S000749 | rep | SC | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38866 | 38866 | Bart Stupak S001045 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38877 | 38877 | John Tanner T000038 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/tanner/ | ||||||||||||
38884 | 38884 | Ellen Tauscher T000057 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38895 | 38895 | Gene Taylor T000074 | rep | MS | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38904 | 38904 | Todd Tiahrt T000260 | rep | KS | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38912 | 38912 | Zach Wamp W000119 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/wamp |
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);