legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
42 rows where district = 1 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37456 | 37456 | Max Sandlin S000044 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/sandlin | ||||||||||||
37555 | 37555 | Jeb Bradley B001246 | rep | NH | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bradley | ||||||||||||
37668 | 37668 | Gilbert Gutknecht G000536 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.gil.house.gov | ||||||||||||
37723 | 37723 | William Jenkins J000082 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/jenkins | ||||||||||||
37800 | 37800 | James Nussle N000172 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://nussle.house.gov | ||||||||||||
37806 | 37806 | C.L. Otter O000166 | rep | ID | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/otter | ||||||||||||
37936 | 37936 | Thomas Allen A000357 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37995 | 37995 | Jo Ann Davis D000597 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/joanndavis | ||||||||||||
38059 | 38059 | Wayne Gilchrest G000180 | rep | MD | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/gilchrest | ||||||||||||
38311 | 38311 | Rick Renzi R000574 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38382 | 38382 | Heather Wilson W000789 | rep | NM | 2003-01-07 | 2005-01-03 | Republican | 1 | http://wilson.house.gov | ||||||||||||
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38459 | 38459 | Henry Brown B001235 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/henrybrown | ||||||||||||
38619 | 38619 | Patrick Kennedy K000113 | rep | RI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/patrickkennedy | ||||||||||||
38680 | 38680 | Alan Mollohan M000844 | rep | WV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38866 | 38866 | Bart Stupak S001045 | rep | MI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38961 | 38961 | Jay Inslee I000026 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38994 | 38994 | David Wu W000793 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39138 | 39138 | Shelley Berkley B001231 | rep | NV | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39443 | 39443 | John Olver O000085 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39546 | 39546 | John Sullivan S001155 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/sullivan | ||||||||||||
39610 | 39610 | Jo Bonner B001244 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
39673 | 39673 | Robert Andrews A000210 | rep | NJ | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
39754 | 39754 | Timothy Bishop B001242 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/timbishop | ||||||||||||
39896 | 39896 | Jack Kingston K000220 | rep | GA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/kingston | ||||||||||||
40182 | 40182 | Ed Whitfield W000413 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/whitfield | ||||||||||||
40243 | 40243 | David Vitter V000127 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://vitter.house.gov | ||||||||||||
40409 | 40409 | Jeff Miller M001144 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/jeffmiller | ||||||||||||
40726 | 40726 | Robert Brady B001227 | rep | PA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/robertbrady | ||||||||||||
41038 | 41038 | Paul Ryan R000570 | rep | WI | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/ryan | ||||||||||||
41290 | 41290 | Rob Bishop B001250 | rep | UT | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/robbishop | ||||||||||||
41300 | 41300 | Wm. Clay C001049 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41521 | 41521 | Peter Visclosky V000108 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/visclosky | ||||||||||||
41820 | 41820 | Roger Wicker W000437 | rep | MS | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/wicker | ||||||||||||
42050 | 42050 | George Butterfield B001251 | rep | NC | 2004-07-21 | 2005-01-03 | Democrat | 1 | http://www.house.gov/butterfield/ | ||||||||||||
42119 | 42119 | Steve Chabot C000266 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
42287 | 42287 | Diana DeGette D000197 | rep | CO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42699 | 42699 | John Larson L000557 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42952 | 42952 | Jerry Moran M000934 | rep | KS | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/moranks01 | ||||||||||||
43213 | 43213 | Bobby Rush R000515 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43467 | 43467 | Mike Thompson T000460 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/mthompson |
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);