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 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44461 | 44461 | Pete Sessions S000250 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44440 | 44440 | Cynthia Lummis L000571 | rep | WY | 2009-01-06 | 2011-01-03 | Republican | 0 | http://lummis.house.gov | ||||||||||||
44279 | 44279 | Ann Kirkpatrick K000368 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | ||||||||||||
43695 | 43695 | Dina Titus T000468 | rep | NV | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://titus.house.gov | ||||||||||||
43689 | 43689 | Bill Foster F000454 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://foster.house.gov | ||||||||||||
43644 | 43644 | John Yarmuth Y000062 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://yarmuth.house.gov | ||||||||||||
43617 | 43617 | Robert Wittman W000804 | rep | VA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.wittman.house.gov/ | ||||||||||||
43603 | 43603 | Joe Wilson W000795 | rep | SC | 2009-01-06 | 2011-01-03 | Republican | 2 | http://joewilson.house.gov | ||||||||||||
43592 | 43592 | Peter Welch W000800 | rep | VT | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://welch.house.gov | ||||||||||||
43578 | 43578 | Maxine Waters W000187 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
43562 | 43562 | Debbie Wasserman Schultz W000797 | rep | FL | 2009-01-06 | 2011-01-03 | Democrat | 20 | http://www.house.gov/schultz | ||||||||||||
43546 | 43546 | Nydia Velázquez V000081 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43533 | 43533 | Chris Van Hollen V000128 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://vanhollen.house.gov | ||||||||||||
43523 | 43523 | Fred Upton U000031 | rep | MI | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/upton | ||||||||||||
43505 | 43505 | Michael Turner T000463 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/miketurner | ||||||||||||
43490 | 43490 | Paul Tonko T000469 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 21 | http://tonko.house.gov | ||||||||||||
43477 | 43477 | Glenn Thompson T000467 | rep | PA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://thompson.house.gov | ||||||||||||
43470 | 43470 | Mike Thompson T000460 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://mikethompson.house.gov | ||||||||||||
43458 | 43458 | Bennie Thompson T000193 | rep | MS | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
43443 | 43443 | Linda Sánchez S001156 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43433 | 43433 | Jackie Speier S001175 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://speier.house.gov/ | ||||||||||||
43425 | 43425 | Christopher Smith S000522 | rep | NJ | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/chrissmith | ||||||||||||
43404 | 43404 | Adrian Smith S001172 | rep | NE | 2009-01-06 | 2011-01-03 | Republican | 3 | http://adriansmith.house.gov | ||||||||||||
43396 | 43396 | Adam Smith S000510 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/adamsmith | ||||||||||||
43383 | 43383 | Albio Sires S001165 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/sires | ||||||||||||
43374 | 43374 | Michael Simpson S001148 | rep | ID | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/simpson | ||||||||||||
43362 | 43362 | Brad Sherman S000344 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
43329 | 43329 | Robert Scott S000185 | rep | VA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43314 | 43314 | David Scott S001157 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://davidscott.house.gov | ||||||||||||
43279 | 43279 | Kurt Schrader S001180 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://schrader.house.gov | ||||||||||||
43272 | 43272 | Adam Schiff S001150 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 29 | http://schiff.house.gov | ||||||||||||
43261 | 43261 | Janice Schakowsky S001145 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/schakowsky | ||||||||||||
43249 | 43249 | Steve Scalise S001176 | rep | LA | 2009-01-06 | 2011-01-03 | Republican | 1 | http://scalise.house.gov/ | ||||||||||||
43241 | 43241 | John Sarbanes S001168 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://sarbanes.house.gov | ||||||||||||
43233 | 43233 | Gregorio Sablan S001177 | rep | MP | 2009-01-06 | 2011-01-03 | Democrat | 0 | [ { "start": "2009-01-06", "end": "2009-02-23", "party": "Independent" }, { "start": "2009-02-23", "end": "2011-01-03", "party": "Democrat" } ] |
http://sablan.house.gov | |||||||||||
43226 | 43226 | Tim Ryan R000577 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://timryan.house.gov | ||||||||||||
43216 | 43216 | Bobby Rush R000515 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43201 | 43201 | C. Ruppersberger R000576 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | ||||||||||||
43189 | 43189 | Lucille Roybal-Allard R000486 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43174 | 43174 | Mike Rogers R000575 | rep | AL | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
43164 | 43164 | Harold Rogers R000395 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 5 | http://halrogers.house.gov | ||||||||||||
43136 | 43136 | David Price P000523 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://price.house.gov | ||||||||||||
43119 | 43119 | Bill Posey P000599 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 15 | http://posey.house.gov | ||||||||||||
43103 | 43103 | Chellie Pingree P000597 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://pingree.house.gov | ||||||||||||
43098 | 43098 | Gary Peters P000595 | rep | MI | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://peters.house.gov | ||||||||||||
43091 | 43091 | Ed Perlmutter P000593 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://perlmutter.house.gov | ||||||||||||
43083 | 43083 | Nancy Pelosi P000197 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43063 | 43063 | Bill Pascrell P000096 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://pascrell.house.gov | ||||||||||||
43050 | 43050 | Frank Pallone P000034 | rep | NJ | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/pallone | ||||||||||||
43026 | 43026 | Eleanor Norton N000147 | rep | DC | 2009-01-06 | 2011-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
43010 | 43010 | Richard Neal N000015 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
42993 | 42993 | Grace Napolitano N000179 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 38 | http://napolitano.house.gov | ||||||||||||
42981 | 42981 | Jerrold Nadler N000002 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42963 | 42963 | Christopher Murphy M001169 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42955 | 42955 | Jerry Moran M000934 | rep | KS | 2009-01-06 | 2011-01-03 | Republican | 1 | http://www.jerrymoran.house.gov | ||||||||||||
42942 | 42942 | Gwen Moore M001160 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/gwenmoore | ||||||||||||
42933 | 42933 | Gregory Meeks M001137 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/meeks | ||||||||||||
42920 | 42920 | Jerry McNerney M001166 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://mcnerney.house.gov | ||||||||||||
42912 | 42912 | Cathy McMorris Rodgers M001159 | rep | WA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://mcmorris.house.gov | ||||||||||||
42897 | 42897 | Patrick McHenry M001156 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/mchenry | ||||||||||||
42888 | 42888 | James McGovern M000312 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42875 | 42875 | Betty McCollum M001143 | rep | MN | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/mccollum | ||||||||||||
42864 | 42864 | Tom McClintock M001177 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://mcclintock.house.gov | ||||||||||||
42857 | 42857 | Michael McCaul M001157 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/mccaul | ||||||||||||
42848 | 42848 | Kevin McCarthy M001165 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | ||||||||||||
42840 | 42840 | Doris Matsui M001163 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
42832 | 42832 | Edward Markey M000133 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42808 | 42808 | Carolyn Maloney M000087 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://maloney.house.gov | ||||||||||||
42793 | 42793 | Stephen Lynch L000562 | rep | MA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42782 | 42782 | Ben Luján L000570 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://lujan.house.gov | ||||||||||||
42775 | 42775 | Blaine Luetkemeyer L000569 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 9 | http://luetkemeyer.house.gov | ||||||||||||
42768 | 42768 | Frank Lucas L000491 | rep | OK | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.house.gov/lucas | ||||||||||||
42747 | 42747 | Zoe Lofgren L000397 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://www.house.gov/lofgren | ||||||||||||
42731 | 42731 | Barbara Lee L000551 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://lee.house.gov | ||||||||||||
42710 | 42710 | Robert Latta L000566 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 5 | http://latta.house.gov/ | ||||||||||||
42702 | 42702 | John Larson L000557 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42690 | 42690 | Rick Larsen L000560 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/larsen | ||||||||||||
42675 | 42675 | James Langevin L000559 | rep | RI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://www.house.gov/langevin | ||||||||||||
42664 | 42664 | Doug Lamborn L000564 | rep | CO | 2009-01-06 | 2011-01-03 | Republican | 5 | http://lamborn.house.gov | ||||||||||||
42650 | 42650 | Ron Kind K000188 | rep | WI | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/kind | ||||||||||||
42625 | 42625 | Marcy Kaptur K000009 | rep | OH | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://kaptur.house.gov | ||||||||||||
42605 | 42605 | Jim Jordan J000289 | rep | OH | 2009-01-06 | 2011-01-03 | Republican | 4 | http://jordan.house.gov | ||||||||||||
42595 | 42595 | Henry Johnson J000288 | rep | GA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://hankjohnson.house.gov | ||||||||||||
42587 | 42587 | Eddie Johnson J000126 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42566 | 42566 | Sheila Jackson Lee J000032 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.jacksonlee.house.gov/ | ||||||||||||
42546 | 42546 | Steny Hoyer H000874 | rep | MD | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://hoyer.house.gov | ||||||||||||
42526 | 42526 | Mazie Hirono H001042 | rep | HI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hirono.house.gov | ||||||||||||
42518 | 42518 | James Himes H001047 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://himes.house.gov | ||||||||||||
42511 | 42511 | Brian Higgins H001038 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://www.house.gov/higgins | ||||||||||||
42499 | 42499 | Martin Heinrich H001046 | rep | NM | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://heinrich.house.gov | ||||||||||||
42480 | 42480 | Brett Guthrie G000558 | rep | KY | 2009-01-06 | 2011-01-03 | Republican | 2 | http://guthrie.house.gov | ||||||||||||
42473 | 42473 | Raúl Grijalva G000551 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
42457 | 42457 | Al Green G000553 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://www.house.gov/algreen | ||||||||||||
42448 | 42448 | Sam Graves G000546 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42427 | 42427 | Kay Granger G000377 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 12 | http://kaygranger.house.gov | ||||||||||||
42408 | 42408 | Louie Gohmert G000552 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 1 | http://gohmert.house.gov | ||||||||||||
42386 | 42386 | Virginia Foxx F000450 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
42371 | 42371 | Anna Eshoo E000215 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
42350 | 42350 | Michael Doyle D000482 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://www.house.gov/doyle |
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);