legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2011-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
38990 | 38990 | Anthony Weiner W000792 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38997 | 38997 | David Wu W000793 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39006 | 39006 | Jesse Jackson J000283 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/jackson/ | ||||||||||||
39016 | 39016 | Bob Filner F000116 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39028 | 39028 | Daniel Inouye I000025 | sen | HI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
39097 | 39097 | Gary Ackerman A000022 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://ackerman.house.gov/ | ||||||||||||
39104 | 39104 | W. Akin A000358 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39109 | 39109 | Steve Austria A000365 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 7 | http://austria.house.gov | ||||||||||||
39116 | 39116 | Joe Baca B001234 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39126 | 39126 | Roscoe Bartlett B000208 | rep | MD | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39141 | 39141 | Shelley Berkley B001231 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://berkley.house.gov | ||||||||||||
39156 | 39156 | Howard Berman B000410 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39163 | 39163 | Judy Biggert B001232 | rep | IL | 2009-01-06 | 2011-01-03 | Republican | 13 | http://judybiggert.house.gov | ||||||||||||
39170 | 39170 | Brian Bilbray B000461 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39178 | 39178 | Mary Bono Mack B001228 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39182 | 39182 | Dan Boren B001254 | rep | OK | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
39190 | 39190 | Leonard Boswell B000652 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39206 | 39206 | Dan Burton B001149 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 5 | http://burton.house.gov | ||||||||||||
39211 | 39211 | Russ Carnahan C001060 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39216 | 39216 | Ben Chandler C001058 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39230 | 39230 | Jerry Costello C000794 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39233 | 39233 | Mark Critz C001081 | rep | PA | 2010-05-20 | 2011-01-03 | Democrat | 12 | http://critz.house.gov/ | ||||||||||||
39251 | 39251 | Norman Dicks D000327 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39267 | 39267 | David Dreier D000492 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39283 | 39283 | Barney Frank F000339 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39296 | 39296 | Elton Gallegly G000021 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39303 | 39303 | Charles Gonzalez G000544 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 20 | http://gonzalez.house.gov | ||||||||||||
39317 | 39317 | Walter Herger H000528 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39327 | 39327 | Maurice Hinchey H000627 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 22 | http://www.house.gov/hinchey | ||||||||||||
39337 | 39337 | Tim Holden H000712 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://www.holden.house.gov | ||||||||||||
39343 | 39343 | Timothy Johnson J000285 | rep | IL | 2009-01-06 | 2011-01-03 | Republican | 15 | http://www.house.gov/timjohnson | ||||||||||||
39361 | 39361 | Dale Kildee K000172 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39363 | 39363 | Larry Kissell K000369 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://kissell.house.gov | ||||||||||||
39371 | 39371 | Dennis Kucinich K000336 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://kucinich.house.gov | ||||||||||||
39380 | 39380 | Steven LaTourette L000553 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 14 | http://www.house.gov/latourette | ||||||||||||
39398 | 39398 | Jerry Lewis L000274 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39407 | 39407 | Daniel Lungren L000517 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.lungren.house.gov | ||||||||||||
39411 | 39411 | Connie Mack M001155 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 14 | http://www.house.gov/mack | ||||||||||||
39421 | 39421 | Donald Manzullo M001138 | rep | IL | 2009-01-06 | 2011-01-03 | Republican | 16 | http://manzullo.house.gov | ||||||||||||
39426 | 39426 | R. Miller M001154 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/bradmiller | ||||||||||||
39435 | 39435 | Sue Myrick M001134 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 9 | http://www.house.gov/myrick | ||||||||||||
39446 | 39446 | John Olver O000085 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39458 | 39458 | Ronald Paul P000583 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 14 | http://www.house.gov/paul | ||||||||||||
39464 | 39464 | Mike Pence P000587 | rep | IN | 2009-01-06 | 2011-01-03 | Republican | 6 | http://mikepence.house.gov | ||||||||||||
39470 | 39470 | Todd Platts P000585 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 19 | http://www.house.gov/platts | ||||||||||||
39477 | 39477 | Dennis Rehberg R000571 | rep | MT | 2009-01-06 | 2011-01-03 | Republican | 0 | http://www.house.gov/rehberg | ||||||||||||
39485 | 39485 | Silvestre Reyes R000170 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://wwwc.house.gov/reyes | ||||||||||||
39488 | 39488 | Laura Richardson R000581 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 37 | http://richardson.house.gov/ | ||||||||||||
39495 | 39495 | Mike Ross R000573 | rep | AR | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39503 | 39503 | Steven Rothman R000462 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://rothman.house.gov | ||||||||||||
39508 | 39508 | Jean Schmidt S001164 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/schmidt | ||||||||||||
39511 | 39511 | Heath Shuler S001171 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://shuler.house.gov | ||||||||||||
39531 | 39531 | Fortney Stark S000810 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39543 | 39543 | Clifford Stearns S000822 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/stearns | ||||||||||||
39549 | 39549 | John Sullivan S001155 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.house.gov/sullivan | ||||||||||||
39552 | 39552 | Betty Sutton S001174 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://sutton.house.gov | ||||||||||||
39567 | 39567 | Edolphus Towns T000326 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 10 | http://www.house.gov/towns | ||||||||||||
39579 | 39579 | Lynn Woolsey W000738 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://woolsey.house.gov | ||||||||||||
39587 | 39587 | Jim DeMint D000595 | sen | SC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://demint.senate.gov | ||||||||||||
39595 | 39595 | Jo Ann Emerson E000172 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39613 | 39613 | Jo Bonner B001244 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39619 | 39619 | Rodney Alexander A000361 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://alexander.house.gov/ | ||||||||||||
39641 | 39641 | C. Young Y000031 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/young | ||||||||||||
39653 | 39653 | Melvin Watt W000207 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/watt | ||||||||||||
39676 | 39676 | Robert Andrews A000210 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/andrews | ||||||||||||
39683 | 39683 | Eric Cantor C001046 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 7 | http://cantor.house.gov | ||||||||||||
39735 | 39735 | Michele Bachmann B001256 | rep | MN | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachmann.house.gov | ||||||||||||
39746 | 39746 | Spencer Bachus B000013 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
39751 | 39751 | John Barrow B001252 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://barrow.house.gov | ||||||||||||
39757 | 39757 | Timothy Bishop B001242 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://wwwc.house.gov/timbishop | ||||||||||||
39761 | 39761 | Bruce Braley B001259 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39765 | 39765 | Paul Broun B001262 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 10 | http://broun.house.gov/ | ||||||||||||
39777 | 39777 | Dave Camp C000071 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 4 | http://camp.house.gov | ||||||||||||
39782 | 39782 | John Campbell C001064 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39791 | 39791 | Donna Christensen C000380 | rep | VI | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/christian-christensen | ||||||||||||
39797 | 39797 | Thomas Coburn C000560 | sen | OK | 2005-01-04 | 2011-01-03 | 3 | Republican | http://coburn.senate.gov | ||||||||||||
39826 | 39826 | John Dingell D000355 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 15 | http://www.house.gov/dingell | ||||||||||||
39839 | 39839 | Eni Faleomavaega F000010 | rep | AS | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | ||||||||||||
39845 | 39845 | Jim Gerlach G000549 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 6 | http://gerlach.house.gov | ||||||||||||
39851 | 39851 | Phil Gingrey G000550 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 11 | http://www.house.gov/gingrey | ||||||||||||
39870 | 39870 | Ralph Hall H000067 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/ralphhall | ||||||||||||
39880 | 39880 | Doc Hastings H000329 | rep | WA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://hastings.house.gov | ||||||||||||
39888 | 39888 | Rush Holt H001032 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://holt.house.gov | ||||||||||||
39899 | 39899 | Jack Kingston K000220 | rep | GA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://kingston.house.gov | ||||||||||||
39909 | 39909 | Tom Latham L000111 | rep | IA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39916 | 39916 | Jim Matheson M001142 | rep | UT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/matheson | ||||||||||||
39925 | 39925 | Carolyn McCarthy M000309 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/carolynmccarthy | ||||||||||||
39934 | 39934 | Mike McIntyre M000485 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/mcintyre | ||||||||||||
39945 | 39945 | Howard McKeon M000508 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 25 | http://mckeon.house.gov | ||||||||||||
39951 | 39951 | Michael Michaud M001149 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://michaud.house.gov | ||||||||||||
39959 | 39959 | Gary Miller M001139 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39979 | 39979 | George Miller M000725 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | ||||||||||||
39991 | 39991 | James Moran M000933 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/moran | ||||||||||||
39994 | 39994 | William Owens O000169 | rep | NY | 2009-11-03 | 2011-01-03 | Democrat | 23 | http://owens.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);