legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
21 rows where district = 8 and "end" is on date 2005-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37263 | 37263 | Michael Collins C000640 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/maccollins | ||||||||||||
37299 | 37299 | Philip Crane C000873 | rep | IL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/crane | ||||||||||||
37325 | 37325 | Jennifer Dunn D000549 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/dunn | ||||||||||||
37369 | 37369 | James Greenwood G000439 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/greenwood | ||||||||||||
37655 | 37655 | Mark Green G000545 | rep | WI | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/markgreen | ||||||||||||
37695 | 37695 | John Hostettler H000807 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/hostettler | ||||||||||||
37755 | 37755 | James Kolbe K000306 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
38091 | 38091 | Robin Hayes H001029 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/hayes | ||||||||||||
38146 | 38146 | Ric Keller K000361 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/keller/ | ||||||||||||
38726 | 38726 | James Oberstar O000006 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/oberstar | ||||||||||||
38877 | 38877 | John Tanner T000038 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/tanner/ | ||||||||||||
39592 | 39592 | Jo Ann Emerson E000172 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39988 | 39988 | James Moran M000933 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/moran | ||||||||||||
40047 | 40047 | Mike Rogers R000572 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/mikerogers | ||||||||||||
40160 | 40160 | John Boehner B000589 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 8 | http://johnboehner.house.gov | ||||||||||||
40736 | 40736 | Michael Capuano C001037 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/capuano | ||||||||||||
42002 | 42002 | Kevin Brady B000755 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
42978 | 42978 | Jerrold Nadler N000002 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
43060 | 43060 | Bill Pascrell P000096 | rep | NJ | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.pascrell.house.gov | ||||||||||||
43080 | 43080 | Nancy Pelosi P000197 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43530 | 43530 | Chris Van Hollen V000128 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/vanhollen |
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);