legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2007-01-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44460 | 44460 | Pete Sessions S000250 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
43643 | 43643 | John Yarmuth Y000062 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://yarmuth.house.gov | ||||||||||||
43602 | 43602 | Joe Wilson W000795 | rep | SC | 2007-01-04 | 2009-01-03 | Republican | 2 | http://joewilson.house.gov | ||||||||||||
43591 | 43591 | Peter Welch W000800 | rep | VT | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://welch.house.gov | ||||||||||||
43577 | 43577 | Maxine Waters W000187 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
43561 | 43561 | Debbie Wasserman Schultz W000797 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://www.house.gov/schultz | ||||||||||||
43553 | 43553 | Tim Walberg W000798 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 7 | http://walberg.house.gov | ||||||||||||
43545 | 43545 | Nydia Velázquez V000081 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43532 | 43532 | Chris Van Hollen V000128 | rep | MD | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://vanhollen.house.gov | ||||||||||||
43522 | 43522 | Fred Upton U000031 | rep | MI | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/upton | ||||||||||||
43504 | 43504 | Michael Turner T000463 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/miketurner | ||||||||||||
43469 | 43469 | Mike Thompson T000460 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://mikethompson.house.gov | ||||||||||||
43457 | 43457 | Bennie Thompson T000193 | rep | MS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://benniethompson.house.gov | ||||||||||||
43442 | 43442 | Linda Sánchez S001156 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43424 | 43424 | Christopher Smith S000522 | rep | NJ | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/chrissmith | ||||||||||||
43403 | 43403 | Adrian Smith S001172 | rep | NE | 2007-01-04 | 2009-01-03 | Republican | 3 | http://adriansmith.house.gov | ||||||||||||
43395 | 43395 | Adam Smith S000510 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/adamsmith | ||||||||||||
43382 | 43382 | Albio Sires S001165 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/sires | ||||||||||||
43373 | 43373 | Michael Simpson S001148 | rep | ID | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/simpson | ||||||||||||
43361 | 43361 | Brad Sherman S000344 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
43328 | 43328 | Robert Scott S000185 | rep | VA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43313 | 43313 | David Scott S001157 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://davidscott.house.gov | ||||||||||||
43271 | 43271 | Adam Schiff S001150 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 29 | http://schiff.house.gov | ||||||||||||
43260 | 43260 | Janice Schakowsky S001145 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/schakowsky | ||||||||||||
43240 | 43240 | John Sarbanes S001168 | rep | MD | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://sarbanes.house.gov | ||||||||||||
43225 | 43225 | Tim Ryan R000577 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://timryan.house.gov | ||||||||||||
43215 | 43215 | Bobby Rush R000515 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43200 | 43200 | C. Ruppersberger R000576 | rep | MD | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | ||||||||||||
43188 | 43188 | Lucille Roybal-Allard R000486 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43173 | 43173 | Mike Rogers R000575 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
43163 | 43163 | Harold Rogers R000395 | rep | KY | 2007-01-04 | 2009-01-03 | Republican | 5 | http://halrogers.house.gov | ||||||||||||
43135 | 43135 | David Price P000523 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://price.house.gov | ||||||||||||
43090 | 43090 | Ed Perlmutter P000593 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://perlmutter.house.gov | ||||||||||||
43082 | 43082 | Nancy Pelosi P000197 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43062 | 43062 | Bill Pascrell P000096 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://pascrell.house.gov | ||||||||||||
43049 | 43049 | Frank Pallone P000034 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://www.house.gov/pallone | ||||||||||||
43025 | 43025 | Eleanor Norton N000147 | rep | DC | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
43009 | 43009 | Richard Neal N000015 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
42992 | 42992 | Grace Napolitano N000179 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 38 | http://napolitano.house.gov | ||||||||||||
42980 | 42980 | Jerrold Nadler N000002 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42962 | 42962 | Christopher Murphy M001169 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42954 | 42954 | Jerry Moran M000934 | rep | KS | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.jerrymoran.house.gov | ||||||||||||
42941 | 42941 | Gwen Moore M001160 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/gwenmoore | ||||||||||||
42932 | 42932 | Gregory Meeks M001137 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://www.house.gov/meeks | ||||||||||||
42919 | 42919 | Jerry McNerney M001166 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://mcnerney.house.gov | ||||||||||||
42911 | 42911 | Cathy McMorris Rodgers M001159 | rep | WA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://mcmorris.house.gov | ||||||||||||
42896 | 42896 | Patrick McHenry M001156 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/mchenry | ||||||||||||
42887 | 42887 | James McGovern M000312 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42874 | 42874 | Betty McCollum M001143 | rep | MN | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/mccollum | ||||||||||||
42856 | 42856 | Michael McCaul M001157 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/mccaul | ||||||||||||
42847 | 42847 | Kevin McCarthy M001165 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | ||||||||||||
42839 | 42839 | Doris Matsui M001163 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
42831 | 42831 | Edward Markey M000133 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42807 | 42807 | Carolyn Maloney M000087 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://maloney.house.gov | ||||||||||||
42792 | 42792 | Stephen Lynch L000562 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42767 | 42767 | Frank Lucas L000491 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/lucas | ||||||||||||
42746 | 42746 | Zoe Lofgren L000397 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://www.house.gov/lofgren | ||||||||||||
42730 | 42730 | Barbara Lee L000551 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://lee.house.gov | ||||||||||||
42701 | 42701 | John Larson L000557 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42689 | 42689 | Rick Larsen L000560 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/larsen | ||||||||||||
42674 | 42674 | James Langevin L000559 | rep | RI | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/langevin | ||||||||||||
42663 | 42663 | Doug Lamborn L000564 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 5 | http://lamborn.house.gov | ||||||||||||
42649 | 42649 | Ron Kind K000188 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/kind | ||||||||||||
42624 | 42624 | Marcy Kaptur K000009 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://kaptur.house.gov | ||||||||||||
42604 | 42604 | Jim Jordan J000289 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 4 | http://jordan.house.gov | ||||||||||||
42594 | 42594 | Henry Johnson J000288 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://hankjohnson.house.gov | ||||||||||||
42586 | 42586 | Eddie Johnson J000126 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42565 | 42565 | Sheila Jackson Lee J000032 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://www.jacksonlee.house.gov/ | ||||||||||||
42545 | 42545 | Steny Hoyer H000874 | rep | MD | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://hoyer.house.gov | ||||||||||||
42525 | 42525 | Mazie Hirono H001042 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://hirono.house.gov | ||||||||||||
42510 | 42510 | Brian Higgins H001038 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://www.house.gov/higgins | ||||||||||||
42472 | 42472 | Raúl Grijalva G000551 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
42456 | 42456 | Al Green G000553 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/algreen | ||||||||||||
42447 | 42447 | Sam Graves G000546 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42426 | 42426 | Kay Granger G000377 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 12 | http://kaygranger.house.gov | ||||||||||||
42407 | 42407 | Louie Gohmert G000552 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 1 | http://gohmert.house.gov | ||||||||||||
42385 | 42385 | Virginia Foxx F000450 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
42370 | 42370 | Anna Eshoo E000215 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
42349 | 42349 | Michael Doyle D000482 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42335 | 42335 | Lloyd Doggett D000399 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 25 | http://www.house.gov/doggett | ||||||||||||
42321 | 42321 | Mario Diaz-Balart D000600 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42305 | 42305 | Rosa DeLauro D000216 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42289 | 42289 | Diana DeGette D000197 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42276 | 42276 | Peter DeFazio D000191 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
42258 | 42258 | Danny Davis D000096 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42245 | 42245 | Henry Cuellar C001063 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/cuellar | ||||||||||||
42223 | 42223 | Joe Courtney C001069 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42215 | 42215 | Jim Costa C001059 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://www.house.gov/costa | ||||||||||||
42206 | 42206 | Jim Cooper C000754 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cooper.house.gov | ||||||||||||
42183 | 42183 | Tom Cole C001053 | rep | OK | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
42173 | 42173 | Steve Cohen C001068 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://cohen.house.gov | ||||||||||||
42165 | 42165 | James Clyburn C000537 | rep | SC | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://clyburn.house.gov | ||||||||||||
42150 | 42150 | Emanuel Cleaver C001061 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
42141 | 42141 | Yvette Clarke C001067 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://clarke.house.gov | ||||||||||||
42121 | 42121 | Steve Chabot C000266 | rep | OH | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
42107 | 42107 | Kathy Castor C001066 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://castor.house.gov | ||||||||||||
42094 | 42094 | John Carter C001051 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 31 | http://carter.house.gov | ||||||||||||
42078 | 42078 | Shelley Capito C001047 | rep | WV | 2007-01-04 | 2009-01-03 | Republican | 2 | http://capito.house.gov | ||||||||||||
42067 | 42067 | Ken Calvert C000059 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 44 | http://calvert.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);