legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
43 rows where district = 2 and "end" is on date 2005-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37256 | 37256 | Brad Carson C001044 | rep | OK | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://carson.house.gov | ||||||||||||
37458 | 37458 | Edward Schrock S001151 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://schrock.house.gov | ||||||||||||
37507 | 37507 | James Turner T000424 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/turner | ||||||||||||
37569 | 37569 | Chris Chocola C001052 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/chocola | ||||||||||||
37651 | 37651 | James Gibbons G000152 | rep | NV | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/gibbons | ||||||||||||
37770 | 37770 | James Leach L000169 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/leach | ||||||||||||
37844 | 37844 | Jim Ryun R000566 | rep | KS | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/ryun | ||||||||||||
37880 | 37880 | Robert Simmons S001152 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
38035 | 38035 | Terry Everett E000268 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38135 | 38135 | William Jefferson J000070 | rep | LA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38199 | 38199 | Ron Lewis L000293 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/ronlewis | ||||||||||||
38453 | 38453 | Allen Boyd B000716 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38549 | 38549 | Bob Etheridge E000226 | rep | NC | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38590 | 38590 | Peter Hoekstra H000676 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38828 | 38828 | Victor Snyder S000672 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
39003 | 39003 | Jesse Jackson J000283 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.jessejacksonjr.org/ | ||||||||||||
39101 | 39101 | W. Akin A000358 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
39132 | 39132 | Charles Bass B000220 | rep | NH | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/bass | ||||||||||||
39314 | 39314 | Walter Herger H000528 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39730 | 39730 | Mark Udall U000038 | rep | CO | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/markudall | ||||||||||||
39913 | 39913 | Jim Matheson M001142 | rep | UT | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/matheson | ||||||||||||
39948 | 39948 | Michael Michaud M001149 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/michaud | ||||||||||||
40064 | 40064 | Lee Terry T000459 | rep | NE | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/terry | ||||||||||||
40171 | 40171 | Chaka Fattah F000043 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/fattah | ||||||||||||
40368 | 40368 | Steve Israel I000057 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/israel | ||||||||||||
40375 | 40375 | John Kline K000363 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/kline | ||||||||||||
40582 | 40582 | Trent Franks F000448 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40784 | 40784 | John Duncan D000533 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/duncan | ||||||||||||
40927 | 40927 | Frank LoBiondo L000554 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/lobiondo | ||||||||||||
40944 | 40944 | Stevan Pearce P000588 | rep | NM | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/pearce | ||||||||||||
41532 | 41532 | Greg Walden W000791 | rep | OR | 2003-01-07 | 2005-01-03 | Republican | 2 | http://walden.house.gov | ||||||||||||
41919 | 41919 | Tammy Baldwin B001230 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
41948 | 41948 | Sanford Bishop B000490 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/bishop | ||||||||||||
42076 | 42076 | Shelley Capito C001047 | rep | WV | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/capito | ||||||||||||
42672 | 42672 | James Langevin L000559 | rep | RI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/langevin | ||||||||||||
42687 | 42687 | Rick Larsen L000560 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/larsen | ||||||||||||
43007 | 43007 | Richard Neal N000015 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43115 | 43115 | Robert Portman P000449 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/portman | ||||||||||||
43198 | 43198 | C. Ruppersberger R000576 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | ||||||||||||
43371 | 43371 | Michael Simpson S001148 | rep | ID | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/simpson | ||||||||||||
43455 | 43455 | Bennie Thompson T000193 | rep | MS | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/thompson | ||||||||||||
43600 | 43600 | Joe Wilson W000795 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 2 | http://joewilson.house.gov/ | ||||||||||||
44272 | 44272 | Ed Case C001055 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/case |
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);