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 2005-01-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44459 | 44459 | Pete Sessions S000250 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44447 | 44447 | Darrell Issa I000056 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44273 | 44273 | Ed Case C001055 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
43640 | 43640 | Ron Wyden W000779 | sen | OR | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://wyden.senate.gov/ | ||||||||||||
43601 | 43601 | Joe Wilson W000795 | rep | SC | 2005-01-04 | 2007-01-03 | Republican | 2 | http://joewilson.house.gov/ | ||||||||||||
43576 | 43576 | Maxine Waters W000187 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
43560 | 43560 | Debbie Wasserman Schultz W000797 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 20 | |||||||||||||
43544 | 43544 | Nydia Velázquez V000081 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43531 | 43531 | Chris Van Hollen V000128 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/vanhollen | ||||||||||||
43521 | 43521 | Fred Upton U000031 | rep | MI | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/upton | ||||||||||||
43503 | 43503 | Michael Turner T000463 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/miketurner | ||||||||||||
43487 | 43487 | John Thune T000250 | sen | SD | 2005-01-04 | 2011-01-03 | 3 | Republican | http://thune.senate.gov/ | ||||||||||||
43468 | 43468 | Mike Thompson T000460 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/mthompson | ||||||||||||
43456 | 43456 | Bennie Thompson T000193 | rep | MS | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/thompson | ||||||||||||
43441 | 43441 | Linda Sánchez S001156 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43423 | 43423 | Christopher Smith S000522 | rep | NJ | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/chrissmith | ||||||||||||
43394 | 43394 | Adam Smith S000510 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/adamsmith | ||||||||||||
43372 | 43372 | Michael Simpson S001148 | rep | ID | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/simpson | ||||||||||||
43360 | 43360 | Brad Sherman S000344 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 27 | http://www.house.gov/sherman | ||||||||||||
43353 | 43353 | Richard Shelby S000320 | sen | AL | 2005-01-04 | 2011-01-03 | 3 | Republican | http://shelby.senate.gov/ | ||||||||||||
43327 | 43327 | Robert Scott S000185 | rep | VA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/scott | ||||||||||||
43312 | 43312 | David Scott S001157 | rep | GA | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/davidscott | ||||||||||||
43296 | 43296 | Charles Schumer S000148 | sen | NY | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://schumer.senate.gov/ | ||||||||||||
43270 | 43270 | Adam Schiff S001150 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 29 | http://www.house.gov/schiff | ||||||||||||
43259 | 43259 | Janice Schakowsky S001145 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/schakowsky | ||||||||||||
43224 | 43224 | Tim Ryan R000577 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/timryan | ||||||||||||
43214 | 43214 | Bobby Rush R000515 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/rush | ||||||||||||
43199 | 43199 | C. Ruppersberger R000576 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | ||||||||||||
43187 | 43187 | Lucille Roybal-Allard R000486 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43172 | 43172 | Mike Rogers R000575 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
43162 | 43162 | Harold Rogers R000395 | rep | KY | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/rogers | ||||||||||||
43134 | 43134 | David Price P000523 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/price | ||||||||||||
43116 | 43116 | Robert Portman P000449 | rep | OH | 2005-01-04 | 2005-04-29 | Republican | 2 | http://www.house.gov/portman | ||||||||||||
43081 | 43081 | Nancy Pelosi P000197 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43061 | 43061 | Bill Pascrell P000096 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.pascrell.house.gov | ||||||||||||
43048 | 43048 | Frank Pallone P000034 | rep | NJ | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/pallone | ||||||||||||
43024 | 43024 | Eleanor Norton N000147 | rep | DC | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
43008 | 43008 | Richard Neal N000015 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/neal | ||||||||||||
42991 | 42991 | Grace Napolitano N000179 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 38 | http://www.napolitano.house.gov | ||||||||||||
42979 | 42979 | Jerrold Nadler N000002 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42969 | 42969 | Patty Murray M001111 | sen | WA | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://murray.senate.gov/ | ||||||||||||
42959 | 42959 | Lisa Murkowski M001153 | sen | AK | 2005-01-04 | 2011-01-03 | 3 | Republican | http://murkowski.senate.gov/ | ||||||||||||
42953 | 42953 | Jerry Moran M000934 | rep | KS | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/moranks01 | ||||||||||||
42940 | 42940 | Gwen Moore M001160 | rep | WI | 2005-01-04 | 2007-01-03 | Democrat | 4 | |||||||||||||
42931 | 42931 | Gregory Meeks M001137 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/meeks | ||||||||||||
42910 | 42910 | Cathy McMorris Rodgers M001159 | rep | WA | 2005-01-04 | 2007-01-03 | Republican | 5 | |||||||||||||
42895 | 42895 | Patrick McHenry M001156 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 10 | |||||||||||||
42886 | 42886 | James McGovern M000312 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | ||||||||||||
42873 | 42873 | Betty McCollum M001143 | rep | MN | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/mccollum | ||||||||||||
42855 | 42855 | Michael McCaul M001157 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 10 | |||||||||||||
42830 | 42830 | Edward Markey M000133 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/markey | ||||||||||||
42806 | 42806 | Carolyn Maloney M000087 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www.house.gov/maloney | ||||||||||||
42791 | 42791 | Stephen Lynch L000562 | rep | MA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/lynch | ||||||||||||
42766 | 42766 | Frank Lucas L000491 | rep | OK | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/lucas | ||||||||||||
42745 | 42745 | Zoe Lofgren L000397 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 16 | http://zoelofgren.house.gov | ||||||||||||
42729 | 42729 | Barbara Lee L000551 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/lee | ||||||||||||
42722 | 42722 | Patrick Leahy L000174 | sen | VT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://leahy.senate.gov/ | ||||||||||||
42700 | 42700 | John Larson L000557 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42688 | 42688 | Rick Larsen L000560 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/larsen | ||||||||||||
42673 | 42673 | James Langevin L000559 | rep | RI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/langevin | ||||||||||||
42648 | 42648 | Ron Kind K000188 | rep | WI | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/kind | ||||||||||||
42623 | 42623 | Marcy Kaptur K000009 | rep | OH | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/kaptur | ||||||||||||
42585 | 42585 | Eddie Johnson J000126 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | ||||||||||||
42564 | 42564 | Sheila Jackson Lee J000032 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 18 | http://www.house.gov/jacksonlee | ||||||||||||
42544 | 42544 | Steny Hoyer H000874 | rep | MD | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/hoyer | ||||||||||||
42509 | 42509 | Brian Higgins H001038 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 27 | |||||||||||||
42471 | 42471 | Raúl Grijalva G000551 | rep | AZ | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
42455 | 42455 | Al Green G000553 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 9 | |||||||||||||
42446 | 42446 | Sam Graves G000546 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42441 | 42441 | Charles Grassley G000386 | sen | IA | 2005-01-04 | 2011-01-03 | 3 | Republican | http://grassley.senate.gov | ||||||||||||
42425 | 42425 | Kay Granger G000377 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 12 | http://kaygranger.house.gov | ||||||||||||
42406 | 42406 | Louie Gohmert G000552 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 1 | |||||||||||||
42384 | 42384 | Virginia Foxx F000450 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 5 | |||||||||||||
42369 | 42369 | Anna Eshoo E000215 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www-eshoo.house.gov | ||||||||||||
42348 | 42348 | Michael Doyle D000482 | rep | PA | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www.house.gov/doyle | ||||||||||||
42334 | 42334 | Lloyd Doggett D000399 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 25 | http://www.house.gov/doggett | ||||||||||||
42320 | 42320 | Mario Diaz-Balart D000600 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42304 | 42304 | Rosa DeLauro D000216 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42288 | 42288 | Diana DeGette D000197 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42275 | 42275 | Peter DeFazio D000191 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/defazio/ | ||||||||||||
42257 | 42257 | Danny Davis D000096 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42244 | 42244 | Henry Cuellar C001063 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 28 | |||||||||||||
42235 | 42235 | Michael Crapo C000880 | sen | ID | 2005-01-04 | 2011-01-03 | 3 | Republican | http://crapo.senate.gov | ||||||||||||
42214 | 42214 | Jim Costa C001059 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 20 | |||||||||||||
42205 | 42205 | Jim Cooper C000754 | rep | TN | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cooper | ||||||||||||
42182 | 42182 | Tom Cole C001053 | rep | OK | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/cole | ||||||||||||
42164 | 42164 | James Clyburn C000537 | rep | SC | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/clyburn | ||||||||||||
42149 | 42149 | Emanuel Cleaver C001061 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 5 | |||||||||||||
42120 | 42120 | Steve Chabot C000266 | rep | OH | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/chabot | ||||||||||||
42093 | 42093 | John Carter C001051 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 31 | http://www.house.gov/carter | ||||||||||||
42077 | 42077 | Shelley Capito C001047 | rep | WV | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/capito | ||||||||||||
42066 | 42066 | Ken Calvert C000059 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
42051 | 42051 | George Butterfield B001251 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 1 | |||||||||||||
42047 | 42047 | Richard Burr B001135 | sen | NC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://burr.senate.gov | ||||||||||||
42033 | 42033 | Michael Burgess B001248 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 26 | http://www.house.gov/burgess | ||||||||||||
42003 | 42003 | Kevin Brady B000755 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/brady | ||||||||||||
41994 | 41994 | John Boozman B001236 | rep | AR | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
41987 | 41987 | Roy Blunt B000575 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
41972 | 41972 | Earl Blumenauer B000574 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/blumenauer | ||||||||||||
41959 | 41959 | Marsha Blackburn B001243 | rep | TN | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/blackburn |
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);