legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where district = 4 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37399 | 37399 | Gerald Kleczka K000259 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/kleczka | ||||||||||||
37413 | 37413 | Kenneth Lucas L000558 | rep | KY | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/kenlucas | ||||||||||||
37414 | 37414 | Denise Majette M001145 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/majette | ||||||||||||
37673 | 37673 | Melissa Hart H001033 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://hart.house.gov | ||||||||||||
37831 | 37831 | Michael Oxley O000163 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/oxley | ||||||||||||
38011 | 38011 | John Doolittle D000429 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/doolittle | ||||||||||||
38223 | 38223 | James McCrery M000388 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/mccrery | ||||||||||||
38251 | 38251 | Marilyn Musgrave M001152 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/musgrave | ||||||||||||
38341 | 38341 | Christopher Shays S001144 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38390 | 38390 | Albert Wynn W000784 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/wynn | ||||||||||||
38472 | 38472 | Stephen Buyer B001203 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/buyer | ||||||||||||
38495 | 38495 | Lincoln Davis D000599 | rep | TN | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38821 | 38821 | Ike Skelton S000465 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
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 | ||||||||||||
39280 | 39280 | Barney Frank F000339 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39492 | 39492 | Mike Ross R000573 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39586 | 39586 | Jim DeMint D000595 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.demint.house.gov | ||||||||||||
39774 | 39774 | Dave Camp C000071 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/camp | ||||||||||||
39867 | 39867 | Ralph Hall H000067 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 4 | [ { "start": "2003-01-07", "end": "2004-01-05", "party": "Democrat" }, { "start": "2004-01-05", "end": "2005-01-03", "party": "Republican" } ] |
http://www.house.gov/ralphhall | |||||||||||
39877 | 39877 | Doc Hastings H000329 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/hastings | ||||||||||||
39906 | 39906 | Tom Latham L000111 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39922 | 39922 | Carolyn McCarthy M000309 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/carolynmccarthy/ | ||||||||||||
40003 | 40003 | Ed Pastor P000099 | rep | AZ | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/pastor | ||||||||||||
40281 | 40281 | Ander Crenshaw C001045 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://crenshaw.house.gov | ||||||||||||
40320 | 40320 | J. Forbes F000445 | rep | VA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/forbes | ||||||||||||
40852 | 40852 | Luis Gutiérrez G000535 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/gutierrez | ||||||||||||
41907 | 41907 | Robert Aderholt A000055 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
42181 | 42181 | Tom Cole C001053 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
42274 | 42274 | Peter DeFazio D000191 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/defazio/ | ||||||||||||
42872 | 42872 | Betty McCollum M001143 | rep | MN | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/mccollum | ||||||||||||
43133 | 43133 | David Price P000523 | rep | NC | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/price | ||||||||||||
43422 | 43422 | Christopher Smith S000522 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/chrissmith |
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);