legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 2009-01-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38657 | 38657 | John McHugh M000472 | rep | NY | 2007-01-04 | 2009-01-03 | Republican | 23 | http://mchugh.house.gov | ||||||||||||
38662 | 38662 | Kendrick Meek M001148 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://kendrickmeek.house.gov | ||||||||||||
38665 | 38665 | Charles Melancon M001161 | rep | LA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://melancon.house.gov | ||||||||||||
38668 | 38668 | Harry Mitchell M001167 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38682 | 38682 | Alan Mollohan M000844 | rep | WV | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38688 | 38688 | Dennis Moore M001140 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://moore.house.gov | ||||||||||||
38690 | 38690 | Patrick Murphy M001168 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://patrickmurphy.house.gov | ||||||||||||
38709 | 38709 | John Murtha M001120 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38728 | 38728 | James Oberstar O000006 | rep | MN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://oberstar.house.gov | ||||||||||||
38749 | 38749 | David Obey O000007 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://obey.house.gov | ||||||||||||
38763 | 38763 | Solomon Ortiz O000107 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://ortiz.house.gov | ||||||||||||
38773 | 38773 | Earl Pomeroy P000422 | rep | ND | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38778 | 38778 | Adam Putnam P000586 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 12 | http://adamputnam.house.gov | ||||||||||||
38786 | 38786 | George Radanovich R000004 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38792 | 38792 | Ciro Rodriguez R000568 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 23 | http://rodriguez.house.gov | ||||||||||||
38795 | 38795 | John Salazar S001158 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/salazar | ||||||||||||
38798 | 38798 | Joe Sestak S001169 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://sestak.house.gov | ||||||||||||
38806 | 38806 | John Shadegg S000275 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38823 | 38823 | Ike Skelton S000465 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38830 | 38830 | Victor Snyder S000672 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38835 | 38835 | Hilda Solis S001153 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 32 | http://solis.house.gov | ||||||||||||
38843 | 38843 | Mark Souder S001143 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://souder.house.gov | ||||||||||||
38845 | 38845 | Zachary Space S001173 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://space.house.gov | ||||||||||||
38859 | 38859 | John Spratt S000749 | rep | SC | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38868 | 38868 | Bart Stupak S001045 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38879 | 38879 | John Tanner T000038 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/tanner | ||||||||||||
38886 | 38886 | Ellen Tauscher T000057 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38897 | 38897 | Gene Taylor T000074 | rep | MS | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38906 | 38906 | Todd Tiahrt T000260 | rep | KS | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/tiahrt | ||||||||||||
38914 | 38914 | Zach Wamp W000119 | rep | TN | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/wamp | ||||||||||||
38919 | 38919 | Diane Watson W000794 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38926 | 38926 | Robert Wexler W000314 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 19 | http://wexler.house.gov | ||||||||||||
38928 | 38928 | Charles Wilson W000801 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
38939 | 38939 | Dennis Cardoza C001050 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38943 | 38943 | Geoff Davis D000603 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 4 | http://geoffdavis.house.gov | ||||||||||||
38946 | 38946 | Gabrielle Giffords G000554 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38955 | 38955 | Jane Harman H000213 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38963 | 38963 | Jay Inslee I000026 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38970 | 38970 | Thaddeus McCotter M001147 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 11 | http://mccotter.house.gov | ||||||||||||
38982 | 38982 | Donald Payne P000149 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38989 | 38989 | Anthony Weiner W000792 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38996 | 38996 | David Wu W000793 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39005 | 39005 | Jesse Jackson J000283 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/jackson/ | ||||||||||||
39015 | 39015 | Bob Filner F000116 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39096 | 39096 | Gary Ackerman A000022 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39103 | 39103 | W. Akin A000358 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39106 | 39106 | Jason Altmire A000362 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39115 | 39115 | Joe Baca B001234 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39125 | 39125 | Roscoe Bartlett B000208 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39140 | 39140 | Shelley Berkley B001231 | rep | NV | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39155 | 39155 | Howard Berman B000410 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39162 | 39162 | Judy Biggert B001232 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 13 | http://www.house.gov/biggert | ||||||||||||
39169 | 39169 | Brian Bilbray B000461 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39181 | 39181 | Dan Boren B001254 | rep | OK | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
39189 | 39189 | Leonard Boswell B000652 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39205 | 39205 | Dan Burton B001149 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/burton | ||||||||||||
39210 | 39210 | Russ Carnahan C001060 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39215 | 39215 | Ben Chandler C001058 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39229 | 39229 | Jerry Costello C000794 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39250 | 39250 | Norman Dicks D000327 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39266 | 39266 | David Dreier D000492 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39282 | 39282 | Barney Frank F000339 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39295 | 39295 | Elton Gallegly G000021 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39302 | 39302 | Charles Gonzalez G000544 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://gonzalez.house.gov | ||||||||||||
39316 | 39316 | Walter Herger H000528 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39326 | 39326 | Maurice Hinchey H000627 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://www.house.gov/hinchey | ||||||||||||
39336 | 39336 | Tim Holden H000712 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://www.holden.house.gov | ||||||||||||
39342 | 39342 | Timothy Johnson J000285 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 15 | http://www.house.gov/timjohnson | ||||||||||||
39360 | 39360 | Dale Kildee K000172 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39370 | 39370 | Dennis Kucinich K000336 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://kucinich.house.gov | ||||||||||||
39379 | 39379 | Steven LaTourette L000553 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/latourette | ||||||||||||
39397 | 39397 | Jerry Lewis L000274 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39406 | 39406 | Daniel Lungren L000517 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.lungren.house.gov | ||||||||||||
39410 | 39410 | Connie Mack M001155 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/mack | ||||||||||||
39420 | 39420 | Donald Manzullo M001138 | rep | IL | 2007-01-04 | 2009-01-03 | Republican | 16 | http://manzullo.house.gov | ||||||||||||
39425 | 39425 | R. Miller M001154 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/bradmiller | ||||||||||||
39434 | 39434 | Sue Myrick M001134 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 9 | http://www.house.gov/myrick | ||||||||||||
39445 | 39445 | John Olver O000085 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39457 | 39457 | Ronald Paul P000583 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 14 | http://www.house.gov/paul | ||||||||||||
39463 | 39463 | Mike Pence P000587 | rep | IN | 2007-01-04 | 2009-01-03 | Republican | 6 | http://mikepence.house.gov | ||||||||||||
39469 | 39469 | Todd Platts P000585 | rep | PA | 2007-01-04 | 2009-01-03 | Republican | 19 | http://www.house.gov/platts | ||||||||||||
39476 | 39476 | Dennis Rehberg R000571 | rep | MT | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/rehberg | ||||||||||||
39484 | 39484 | Silvestre Reyes R000170 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://wwwc.house.gov/reyes | ||||||||||||
39487 | 39487 | Laura Richardson R000581 | rep | CA | 2007-09-04 | 2009-01-03 | Democrat | 37 | http://richardson.house.gov/ | ||||||||||||
39494 | 39494 | Mike Ross R000573 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39502 | 39502 | Steven Rothman R000462 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://rothman.house.gov | ||||||||||||
39507 | 39507 | Jean Schmidt S001164 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/schmidt | ||||||||||||
39510 | 39510 | Heath Shuler S001171 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://shuler.house.gov | ||||||||||||
39530 | 39530 | Fortney Stark S000810 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39542 | 39542 | Clifford Stearns S000822 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/stearns | ||||||||||||
39548 | 39548 | John Sullivan S001155 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/sullivan | ||||||||||||
39551 | 39551 | Betty Sutton S001174 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://sutton.house.gov | ||||||||||||
39566 | 39566 | Edolphus Towns T000326 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/towns | ||||||||||||
39578 | 39578 | Lynn Woolsey W000738 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://woolsey.house.gov | ||||||||||||
39594 | 39594 | Jo Ann Emerson E000172 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39601 | 39601 | John Kerry K000148 | sen | MA | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://kerry.senate.gov/ | ||||||||||||
39607 | 39607 | Frank Lautenberg L000123 | sen | NJ | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://lautenberg.senate.gov/ | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39618 | 39618 | Rodney Alexander A000361 | rep | LA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/alexander |
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);