legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "end" is on date 2007-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41680 | 41680 | Don Young Y000033 | rep | AK | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/donyoung | ||||||||||||
37984 | 37984 | Robert Cramer C000868 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
38036 | 38036 | Terry Everett E000268 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38492 | 38492 | Artur Davis D000602 | rep | AL | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
39611 | 39611 | Jo Bonner B001244 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
39744 | 39744 | Spencer Bachus B000013 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/bachus | ||||||||||||
41908 | 41908 | Robert Aderholt A000055 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
43172 | 43172 | Mike Rogers R000575 | rep | AL | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
38425 | 38425 | Robert Berry B000420 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38829 | 38829 | Victor Snyder S000672 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
39493 | 39493 | Mike Ross R000573 | rep | AR | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
41994 | 41994 | John Boozman B001236 | rep | AR | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
39837 | 39837 | Eni Faleomavaega F000010 | rep | AS | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | ||||||||||||
37680 | 37680 | John Hayworth H000413 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37756 | 37756 | James Kolbe K000306 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
38312 | 38312 | Rick Renzi R000574 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38805 | 38805 | John Shadegg S000275 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
40004 | 40004 | Ed Pastor P000099 | rep | AZ | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/pastor | ||||||||||||
40583 | 40583 | Trent Franks F000448 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40664 | 40664 | Jon Kyl K000352 | sen | AZ | 2001-01-03 | 2007-01-03 | 1 | Republican | http://kyl.senate.gov/ | ||||||||||||
40800 | 40800 | Jeff Flake F000444 | rep | AZ | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/flake | ||||||||||||
42471 | 42471 | Raúl Grijalva G000551 | rep | AZ | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
37839 | 37839 | Richard Pombo P000419 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 11 | http://www.house.gov/pombo/pombo.htm | ||||||||||||
37919 | 37919 | William Thomas T000188 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 22 | http://www.house.gov/billthomas | ||||||||||||
38012 | 38012 | John Doolittle D000429 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/doolittle | ||||||||||||
38127 | 38127 | Duncan Hunter H000981 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38192 | 38192 | Tom Lantos L000090 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38249 | 38249 | Juanita Millender-McDonald M000714 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 37 | http://www.house.gov/millender-mcdonald | ||||||||||||
38785 | 38785 | George Radanovich R000004 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 19 | http://www.radanovich.house.gov | ||||||||||||
38834 | 38834 | Hilda Solis S001153 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38885 | 38885 | Ellen Tauscher T000057 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38918 | 38918 | Diane Watson W000794 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38938 | 38938 | Dennis Cardoza C001050 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38954 | 38954 | Jane Harman H000213 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
39014 | 39014 | Bob Filner F000116 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39114 | 39114 | Joe Baca B001234 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39154 | 39154 | Howard Berman B000410 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39168 | 39168 | Brian Bilbray B000461 | rep | CA | 2006-06-13 | 2007-01-03 | Republican | 50 | |||||||||||||
39176 | 39176 | Mary Bono Mack B001228 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
39265 | 39265 | David Dreier D000492 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39294 | 39294 | Elton Gallegly G000021 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39315 | 39315 | Walter Herger H000528 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39396 | 39396 | Jerry Lewis L000274 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39405 | 39405 | Daniel Lungren L000517 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 3 | |||||||||||||
39529 | 39529 | Fortney Stark S000810 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39577 | 39577 | Lynn Woolsey W000738 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/woolsey | ||||||||||||
39780 | 39780 | John Campbell C001064 | rep | CA | 2005-12-07 | 2007-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39943 | 39943 | Howard McKeon M000508 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 25 | http://www.house.gov/mckeon | ||||||||||||
39957 | 39957 | Gary Miller M001139 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39977 | 39977 | George Miller M000725 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | ||||||||||||
40094 | 40094 | Henry Waxman W000215 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 30 | http://www.house.gov/waxman | ||||||||||||
40271 | 40271 | Lois Capps C001036 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40302 | 40302 | Sam Farr F000030 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 17 | http://www.house.gov/farr | ||||||||||||
40355 | 40355 | Michael Honda H001034 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 15 | http://www.house.gov/honda | ||||||||||||
40471 | 40471 | Loretta Sanchez S000030 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 47 | http://www.house.gov/sanchez | ||||||||||||
40518 | 40518 | Xavier Becerra B000287 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
40982 | 40982 | Dana Rohrabacher R000409 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
41029 | 41029 | Edward Royce R000487 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 40 | http://www.house.gov/royce | ||||||||||||
41319 | 41319 | Susan Davis D000598 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41653 | 41653 | Devin Nunes N000181 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 21 | http://www.nunes.house.gov | ||||||||||||
41772 | 41772 | Dianne Feinstein F000062 | sen | CA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://feinstein.senate.gov | ||||||||||||
42066 | 42066 | Ken Calvert C000059 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
42214 | 42214 | Jim Costa C001059 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 20 | |||||||||||||
42369 | 42369 | Anna Eshoo E000215 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 14 | http://www-eshoo.house.gov | ||||||||||||
42729 | 42729 | Barbara Lee L000551 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 9 | http://www.house.gov/lee | ||||||||||||
42745 | 42745 | Zoe Lofgren L000397 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 16 | http://zoelofgren.house.gov | ||||||||||||
42838 | 42838 | Doris Matsui M001163 | rep | CA | 2005-03-10 | 2007-01-03 | Democrat | 5 | |||||||||||||
42991 | 42991 | Grace Napolitano N000179 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 38 | http://www.napolitano.house.gov | ||||||||||||
43081 | 43081 | Nancy Pelosi P000197 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43187 | 43187 | Lucille Roybal-Allard R000486 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43270 | 43270 | Adam Schiff S001150 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 29 | http://www.house.gov/schiff | ||||||||||||
43360 | 43360 | Brad Sherman S000344 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 27 | http://www.house.gov/sherman | ||||||||||||
43441 | 43441 | Linda Sánchez S001156 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43468 | 43468 | Mike Thompson T000460 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/mthompson | ||||||||||||
43576 | 43576 | Maxine Waters W000187 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
44447 | 44447 | Darrell Issa I000056 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
37516 | 37516 | Bob Beauprez B001240 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37690 | 37690 | Joel Hefley H000444 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/hefley | ||||||||||||
38252 | 38252 | Marilyn Musgrave M001152 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/musgrave | ||||||||||||
38347 | 38347 | Thomas Tancredo T000458 | rep | CO | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/tancredo | ||||||||||||
38794 | 38794 | John Salazar S001158 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
39731 | 39731 | Mark Udall U000038 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/markudall | ||||||||||||
42288 | 42288 | Diana DeGette D000197 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
37736 | 37736 | Nancy Johnson J000163 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37881 | 37881 | Robert Simmons S001152 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
38342 | 38342 | Christopher Shays S001144 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
42304 | 42304 | Rosa DeLauro D000216 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42700 | 42700 | John Larson L000557 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
43024 | 43024 | Eleanor Norton N000147 | rep | DC | 2005-01-04 | 2007-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
38485 | 38485 | Michael Castle C000243 | rep | DE | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
41763 | 41763 | Thomas Carper C000174 | sen | DE | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://carper.senate.gov | ||||||||||||
37531 | 37531 | Michael Bilirakis B000463 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
37592 | 37592 | James Davis D000114 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37671 | 37671 | Katherine Harris H001035 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 13 | http://www.house.gov/harris | ||||||||||||
37874 | 37874 | E. Shaw S000303 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 22 | http://www.house.gov/shaw | ||||||||||||
38039 | 38039 | Tom Feeney F000447 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38147 | 38147 | Ric Keller K000361 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/keller/ | ||||||||||||
38370 | 38370 | David Weldon W000267 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 15 | http://www.house.gov/curtweldon | ||||||||||||
38454 | 38454 | Allen Boyd B000716 | rep | FL | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/boyd |
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);