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 2011-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38456 | 38456 | Allen Boyd B000716 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://boyd.house.gov | ||||||||||||
38457 | 38457 | Bobby Bright B001264 | rep | AL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.bright.house.gov | ||||||||||||
38476 | 38476 | Anh Cao C001079 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://josephcao.house.gov | ||||||||||||
38552 | 38552 | Bob Etheridge E000226 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38584 | 38584 | Paul Hodes H001043 | rep | NH | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
38593 | 38593 | Peter Hoekstra H000676 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/hoekstra | ||||||||||||
38711 | 38711 | Glenn Nye N000183 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://nye.house.gov | ||||||||||||
38831 | 38831 | Victor Snyder S000672 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38899 | 38899 | Harry Teague T000466 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://teague.house.gov | ||||||||||||
39006 | 39006 | Jesse Jackson J000283 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/jackson/ | ||||||||||||
39104 | 39104 | W. Akin A000358 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39182 | 39182 | Dan Boren B001254 | rep | OK | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
39317 | 39317 | Walter Herger H000528 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39508 | 39508 | Jean Schmidt S001164 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/schmidt | ||||||||||||
39916 | 39916 | Jim Matheson M001142 | rep | UT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/matheson | ||||||||||||
39951 | 39951 | Michael Michaud M001149 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://michaud.house.gov | ||||||||||||
40067 | 40067 | Lee Terry T000459 | rep | NE | 2009-01-06 | 2011-01-03 | Republican | 2 | http://leeterry.house.gov | ||||||||||||
40174 | 40174 | Chaka Fattah F000043 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/fattah | ||||||||||||
40371 | 40371 | Steve Israel I000057 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/israel | ||||||||||||
40378 | 40378 | John Kline K000363 | rep | MN | 2009-01-06 | 2011-01-03 | Republican | 2 | http://kline.house.gov | ||||||||||||
40585 | 40585 | Trent Franks F000448 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40773 | 40773 | Joe Donnelly D000607 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://donnelly.house.gov | ||||||||||||
40787 | 40787 | John Duncan D000533 | rep | TN | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/duncan/ | ||||||||||||
40877 | 40877 | Lynn Jenkins J000290 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 2 | http://lynnjenkins.house.gov | ||||||||||||
40930 | 40930 | Frank LoBiondo L000554 | rep | NJ | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/lobiondo | ||||||||||||
40953 | 40953 | Ted Poe P000592 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/poe | ||||||||||||
40958 | 40958 | Jared Polis P000598 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://polis.house.gov | ||||||||||||
41088 | 41088 | Dean Heller H001041 | rep | NV | 2009-01-06 | 2011-01-03 | Republican | 2 | http://heller.house.gov | ||||||||||||
41383 | 41383 | David Loebsack L000565 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://loebsack.house.gov | ||||||||||||
41535 | 41535 | Greg Walden W000791 | rep | OR | 2009-01-06 | 2011-01-03 | Republican | 2 | http://walden.house.gov | ||||||||||||
41922 | 41922 | Tammy Baldwin B001230 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | ||||||||||||
41951 | 41951 | Sanford Bishop B000490 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://bishop.house.gov | ||||||||||||
42079 | 42079 | Shelley Capito C001047 | rep | WV | 2009-01-06 | 2011-01-03 | Republican | 2 | http://capito.house.gov | ||||||||||||
42224 | 42224 | Joe Courtney C001069 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42480 | 42480 | Brett Guthrie G000558 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 2 | http://guthrie.house.gov | ||||||||||||
42526 | 42526 | Mazie Hirono H001042 | rep | HI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hirono.house.gov | ||||||||||||
42675 | 42675 | James Langevin L000559 | rep | RI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/langevin | ||||||||||||
42690 | 42690 | Rick Larsen L000560 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/larsen | ||||||||||||
43010 | 43010 | Richard Neal N000015 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
43201 | 43201 | C. Ruppersberger R000576 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | ||||||||||||
43374 | 43374 | Michael Simpson S001148 | rep | ID | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/simpson | ||||||||||||
43458 | 43458 | Bennie Thompson T000193 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
43603 | 43603 | Joe Wilson W000795 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 2 | http://joewilson.house.gov |
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);