legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
38 rows where district = 3 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37355 | 37355 | Richard Gephardt G000132 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://dickgephardt.house.gov | ||||||||||||
37410 | 37410 | William Lipinski L000342 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/lipinski | ||||||||||||
37438 | 37438 | Scott McInnis M000477 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/mcinnis | ||||||||||||
37446 | 37446 | Doug Ose O000164 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ose | ||||||||||||
37503 | 37503 | William Tauzin T000058 | rep | LA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/tauzin | ||||||||||||
37792 | 37792 | Anne Northup N000143 | rep | KY | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/northup | ||||||||||||
37803 | 37803 | Thomas Osborne O000165 | rep | NE | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/osborne | ||||||||||||
37966 | 37966 | Christopher Cannon C000116 | rep | UT | 2003-01-07 | 2005-01-03 | Republican | 3 | http://chriscannon.house.gov | ||||||||||||
38023 | 38023 | Philip English E000187 | rep | PA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/english | ||||||||||||
38270 | 38270 | Charles Pickering P000323 | rep | MS | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/pickering | ||||||||||||
38273 | 38273 | Jon Porter P000589 | rep | NV | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/porter | ||||||||||||
38290 | 38290 | James Ramstad R000033 | rep | MN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ramstad | ||||||||||||
38330 | 38330 | H. Saxton S000097 | rep | NJ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/saxton | ||||||||||||
38410 | 38410 | Brian Baird B001229 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38414 | 38414 | James Barrett B001239 | rep | SC | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38540 | 38540 | Vernon Ehlers E000092 | rep | MI | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38645 | 38645 | James Marshall M001146 | rep | GA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/marshall | ||||||||||||
38686 | 38686 | Dennis Moore M001140 | rep | KS | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/moore | ||||||||||||
38804 | 38804 | John Shadegg S000275 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
38841 | 38841 | Mark Souder S001143 | rep | IN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/souder | ||||||||||||
38912 | 38912 | Zach Wamp W000119 | rep | TN | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
39187 | 39187 | Leonard Boswell B000652 | rep | IA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
40040 | 40040 | Nick Rahall R000011 | rep | WV | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/rahall | ||||||||||||
40260 | 40260 | Corrine Brown B000911 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | ||||||||||||
40888 | 40888 | Sam Johnson J000174 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/samjohnson | ||||||||||||
41178 | 41178 | Walter Jones J000255 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 3 | http://jones.house.gov | ||||||||||||
41280 | 41280 | Tom Udall U000039 | rep | NM | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/tomudall | ||||||||||||
41356 | 41356 | Peter King K000210 | rep | NY | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/king | ||||||||||||
41753 | 41753 | Benjamin Cardin C000141 | rep | MD | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/cardin | ||||||||||||
41971 | 41971 | Earl Blumenauer B000574 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/blumenauer | ||||||||||||
41993 | 41993 | John Boozman B001236 | rep | AR | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
42303 | 42303 | Rosa DeLauro D000216 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42647 | 42647 | Ron Kind K000188 | rep | WI | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/kind | ||||||||||||
42765 | 42765 | Frank Lucas L000491 | rep | OK | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/lucas | ||||||||||||
42885 | 42885 | James McGovern M000312 | rep | MA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
43171 | 43171 | Mike Rogers R000575 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
43326 | 43326 | Robert Scott S000185 | rep | VA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43502 | 43502 | Michael Turner T000463 | rep | OH | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/miketurner |
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);