legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "start" is on date 2009-01-06
This data as json, copyable, CSV (advanced)
Suggested facets: district, state_rank
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38404 | 38404 | Neil Abercrombie A000014 | rep | HI | 2009-01-06 | 2010-03-01 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38405 | 38405 | John Adler A000364 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://adler.house.gov | ||||||||||||
38407 | 38407 | Michael Arcuri A000363 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
38413 | 38413 | Brian Baird B001229 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.baird.house.gov | ||||||||||||
38417 | 38417 | James Barrett B001239 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/barrett | ||||||||||||
38420 | 38420 | Melissa Bean B001253 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
38427 | 38427 | Robert Berry B000420 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/berry/ | ||||||||||||
38434 | 38434 | Joseph Biden B000444 | sen | DE | 2009-01-06 | 2009-01-15 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
38435 | 38435 | John Boccieri B001263 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://boccieri.house.gov | ||||||||||||
38449 | 38449 | Frederick Boucher B000657 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
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 | ||||||||||||
38462 | 38462 | Henry Brown B001235 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 1 | http://brown.house.gov | ||||||||||||
38466 | 38466 | Virginia Brown-Waite B001247 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38475 | 38475 | Stephen Buyer B001203 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 4 | http://stevebuyer.house.gov | ||||||||||||
38476 | 38476 | Anh Cao C001079 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://josephcao.house.gov | ||||||||||||
38478 | 38478 | Christopher Carney C001065 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
38487 | 38487 | Michael Castle C000243 | rep | DE | 2009-01-06 | 2011-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38489 | 38489 | Travis Childers C001074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.childers.house.gov/ | ||||||||||||
38490 | 38490 | Kathleen Dahlkemper D000608 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://dahlkemper.house.gov | ||||||||||||
38494 | 38494 | Artur Davis D000602 | rep | AL | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38498 | 38498 | Lincoln Davis D000599 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38507 | 38507 | Nathan Deal D000168 | rep | GA | 2009-01-06 | 2010-03-22 | Republican | 9 | http://www.house.gov/deal | ||||||||||||
38514 | 38514 | William Delahunt D000210 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38523 | 38523 | Lincoln Diaz-Balart D000299 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38524 | 38524 | Steve Driehaus D000609 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://driehaus.house.gov | ||||||||||||
38534 | 38534 | Thomas Edwards E000063 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38543 | 38543 | Vernon Ehlers E000092 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/ehlers | ||||||||||||
38545 | 38545 | Brad Ellsworth E000289 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
38552 | 38552 | Bob Etheridge E000226 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38554 | 38554 | Mary Fallin F000453 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 5 | http://fallin.house.gov | ||||||||||||
38567 | 38567 | Barton Gordon G000309 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
38568 | 38568 | Parker Griffith G000557 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 5 | [ { "start": "2009-01-06", "end": "2009-12-22", "party": "Democrat" }, { "start": "2009-12-22", "end": "2011-01-03", "party": "Republican" } ] |
http://griffith.house.gov | |||||||||||
38570 | 38570 | John Hall H001039 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 19 | http://johnhall.house.gov | ||||||||||||
38571 | 38571 | Deborah Halvorson H001044 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://halvorson.house.gov | ||||||||||||
38573 | 38573 | Phil Hare H001040 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://hare.house.gov | ||||||||||||
38577 | 38577 | Stephanie Herseth Sandlin H001037 | rep | SD | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38582 | 38582 | Baron Hill H001030 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
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 | ||||||||||||
38599 | 38599 | Bob Inglis I000023 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 4 | http://inglis.house.gov | ||||||||||||
38601 | 38601 | Steve Kagen K000365 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://kagen.house.gov | ||||||||||||
38614 | 38614 | Paul Kanjorski K000008 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://kanjorski.house.gov | ||||||||||||
38622 | 38622 | Patrick Kennedy K000113 | rep | RI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://patrickkennedy.house.gov | ||||||||||||
38629 | 38629 | Carolyn Kilpatrick K000180 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38630 | 38630 | Mary Jo Kilroy K000372 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 15 | http://kilroy.house.gov | ||||||||||||
38632 | 38632 | Ron Klein K000366 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 22 | http://klein.house.gov | ||||||||||||
38633 | 38633 | Suzanne Kosmas K000370 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 24 | http://www.kosmas.house.gov | ||||||||||||
38634 | 38634 | Frank Kratovil K000371 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kratovil.house.gov | ||||||||||||
38643 | 38643 | John Linder L000321 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://linder.house.gov | ||||||||||||
38644 | 38644 | Betsy Markey M001172 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://betsymarkey.house.gov | ||||||||||||
38648 | 38648 | James Marshall M001146 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://jimmarshall.house.gov | ||||||||||||
38649 | 38649 | Eric Massa M001173 | rep | NY | 2009-01-06 | 2010-03-08 | Democrat | 29 | http://massa.house.gov | ||||||||||||
38658 | 38658 | John McHugh M000472 | rep | NY | 2009-01-06 | 2009-09-21 | Republican | 23 | http://mchugh.house.gov | ||||||||||||
38659 | 38659 | Michael McMahon M001174 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://mcmahon.house.gov | ||||||||||||
38663 | 38663 | Kendrick Meek M001148 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://kendrickmeek.house.gov | ||||||||||||
38666 | 38666 | Charles Melancon M001161 | rep | LA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://melancon.house.gov | ||||||||||||
38667 | 38667 | Walter Minnick M001175 | rep | ID | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://minnick.house.gov | ||||||||||||
38669 | 38669 | Harry Mitchell M001167 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38683 | 38683 | Alan Mollohan M000844 | rep | WV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38689 | 38689 | Dennis Moore M001140 | rep | KS | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://moore.house.gov | ||||||||||||
38691 | 38691 | Patrick Murphy M001168 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://patrickmurphy.house.gov | ||||||||||||
38710 | 38710 | John Murtha M001120 | rep | PA | 2009-01-06 | 2010-02-08 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38711 | 38711 | Glenn Nye N000183 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://nye.house.gov | ||||||||||||
38729 | 38729 | James Oberstar O000006 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://oberstar.house.gov | ||||||||||||
38750 | 38750 | David Obey O000007 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://obey.house.gov | ||||||||||||
38764 | 38764 | Solomon Ortiz O000107 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://ortiz.house.gov | ||||||||||||
38765 | 38765 | Thomas Perriello P000600 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://perriello.house.gov | ||||||||||||
38774 | 38774 | Earl Pomeroy P000422 | rep | ND | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38779 | 38779 | Adam Putnam P000586 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
38787 | 38787 | George Radanovich R000004 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38793 | 38793 | Ciro Rodriguez R000568 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 23 | http://rodriguez.house.gov | ||||||||||||
38796 | 38796 | John Salazar S001158 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/salazar | ||||||||||||
38797 | 38797 | Mark Schauer S001178 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://schauer.house.gov | ||||||||||||
38799 | 38799 | Joe Sestak S001169 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://sestak.house.gov | ||||||||||||
38807 | 38807 | John Shadegg S000275 | rep | AZ | 2009-01-06 | 2011-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38824 | 38824 | Ike Skelton S000465 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38831 | 38831 | Victor Snyder S000672 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38836 | 38836 | Hilda Solis S001153 | rep | CA | 2009-01-06 | 2009-02-24 | Democrat | 32 | http://solis.house.gov | ||||||||||||
38844 | 38844 | Mark Souder S001143 | rep | IN | 2009-01-06 | 2010-05-21 | Republican | 3 | http://souder.house.gov | ||||||||||||
38846 | 38846 | Zachary Space S001173 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://space.house.gov | ||||||||||||
38860 | 38860 | John Spratt S000749 | rep | SC | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38869 | 38869 | Bart Stupak S001045 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38880 | 38880 | John Tanner T000038 | rep | TN | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/tanner | ||||||||||||
38887 | 38887 | Ellen Tauscher T000057 | rep | CA | 2009-01-06 | 2009-06-26 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38898 | 38898 | Gene Taylor T000074 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38899 | 38899 | Harry Teague T000466 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://teague.house.gov | ||||||||||||
38907 | 38907 | Todd Tiahrt T000260 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38915 | 38915 | Zach Wamp W000119 | rep | TN | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
38920 | 38920 | Diane Watson W000794 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38927 | 38927 | Robert Wexler W000314 | rep | FL | 2009-01-06 | 2010-01-04 | Democrat | 19 | http://wexler.house.gov | ||||||||||||
38929 | 38929 | Charles Wilson W000801 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
38940 | 38940 | Dennis Cardoza C001050 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38944 | 38944 | Geoff Davis D000603 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
38947 | 38947 | Gabrielle Giffords G000554 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38956 | 38956 | Jane Harman H000213 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38964 | 38964 | Jay Inslee I000026 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38966 | 38966 | Christopher Lee L000568 | rep | NY | 2009-01-06 | 2011-01-03 | Republican | 26 | http://chrislee.house.gov | ||||||||||||
38971 | 38971 | Thaddeus McCotter M001147 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 11 | http://mccotter.house.gov | ||||||||||||
38983 | 38983 | Donald Payne P000149 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://www.house.gov/payne |
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);