legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
30 rows where district = 5 and "end" is on date 2005-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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/ | ||||||||||||
37443 | 37443 | George Nethercutt N000051 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nethercutt | ||||||||||||
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 | ||||||||||||
37718 | 37718 | Ernest Istook I000047 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/istook | ||||||||||||
37735 | 37735 | Nancy Johnson J000163 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37858 | 37858 | Martin Sabo S000005 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/sabo | ||||||||||||
37983 | 37983 | Robert Cramer C000868 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
38016 | 38016 | Rahm Emanuel E000287 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
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 | ||||||||||||
38106 | 38106 | Darlene Hooley H000762 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38241 | 38241 | Martin Meehan M000627 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/meehan | ||||||||||||
38264 | 38264 | John Peterson P000263 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/johnpeterson | ||||||||||||
38463 | 38463 | Virginia Brown-Waite B001247 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38857 | 38857 | John Spratt S000749 | rep | SC | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
39094 | 39094 | Gary Ackerman A000022 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39203 | 39203 | Dan Burton B001149 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
39358 | 39358 | Dale Kildee K000172 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39616 | 39616 | Rodney Alexander A000361 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 5 | [ { "start": "2003-01-07", "end": "2004-08-09", "party": "Democrat" }, { "start": "2004-08-09", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/alexander/ | |||||||||||
40327 | 40327 | Scott Garrett G000548 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/garrett | ||||||||||||
40865 | 40865 | Jeb Hensarling H001036 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hensarling | ||||||||||||
41237 | 41237 | John Lewis L000287 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/johnlewis | ||||||||||||
41365 | 41365 | Steve King K000362 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41457 | 41457 | F. Sensenbrenner S000244 | rep | WI | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/sensenbrenner | ||||||||||||
42046 | 42046 | Richard Burr B001135 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/burr | ||||||||||||
42204 | 42204 | Jim Cooper C000754 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cooper | ||||||||||||
42543 | 42543 | Steny Hoyer H000874 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/hoyer | ||||||||||||
43161 | 43161 | Harold Rogers R000395 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/rogers |
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);