legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "start" is on date 2003-01-07 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37486 | 37486 | Ted Stevens S000888 | sen | AK | 2003-01-07 | 2009-01-03 | 2 | Republican | http://stevens.senate.gov/ | ||||||||||||
41679 | 41679 | Don Young Y000033 | rep | AK | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/donyoung | ||||||||||||
42958 | 42958 | Lisa Murkowski M001153 | sen | AK | 2003-01-07 | 2005-01-03 | 3 | Republican | appointment | http://murkowski.senate.gov/ | |||||||||||
37983 | 37983 | Robert Cramer C000868 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/cramer | ||||||||||||
38035 | 38035 | Terry Everett E000268 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/everett | ||||||||||||
38491 | 38491 | Artur Davis D000602 | rep | AL | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
39610 | 39610 | Jo Bonner B001244 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/bonner | ||||||||||||
39743 | 39743 | Spencer Bachus B000013 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/bachus | ||||||||||||
40526 | 40526 | Jefferson Sessions S001141 | sen | AL | 2003-01-07 | 2009-01-03 | 2 | Republican | http://sessions.senate.gov/ | ||||||||||||
41907 | 41907 | Robert Aderholt A000055 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/aderholt | ||||||||||||
43171 | 43171 | Mike Rogers R000575 | rep | AL | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
38424 | 38424 | Robert Berry B000420 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38828 | 38828 | Victor Snyder S000672 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
39492 | 39492 | Mike Ross R000573 | rep | AR | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39721 | 39721 | Mark Pryor P000590 | sen | AR | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://pryor.senate.gov | ||||||||||||
41993 | 41993 | John Boozman B001236 | rep | AR | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
39836 | 39836 | Eni Faleomavaega F000010 | rep | AS | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | ||||||||||||
37679 | 37679 | John Hayworth H000413 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hayworth | ||||||||||||
37755 | 37755 | James Kolbe K000306 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/kolbe | ||||||||||||
38311 | 38311 | Rick Renzi R000574 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38804 | 38804 | John Shadegg S000275 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/shadegg | ||||||||||||
40003 | 40003 | Ed Pastor P000099 | rep | AZ | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/pastor | ||||||||||||
40582 | 40582 | Trent Franks F000448 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40799 | 40799 | Jeff Flake F000444 | rep | AZ | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/flake | ||||||||||||
42470 | 42470 | Raúl Grijalva G000551 | rep | AZ | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
37319 | 37319 | Calvin Dooley D000424 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 20 | http://dooley.house.gov | ||||||||||||
37427 | 37427 | Robert Matsui M000249 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
37446 | 37446 | Doug Ose O000164 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/ose | ||||||||||||
37578 | 37578 | C. Cox C000830 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 48 | http://cox.house.gov | ||||||||||||
37586 | 37586 | Randall Cunningham C000994 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
37838 | 37838 | Richard Pombo P000419 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 11 | http://www.house.gov/pombo/pombo.htm | ||||||||||||
37918 | 37918 | William Thomas T000188 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 22 | http://www.house.gov/billthomas | ||||||||||||
38011 | 38011 | John Doolittle D000429 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/doolittle | ||||||||||||
38126 | 38126 | Duncan Hunter H000981 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38191 | 38191 | Tom Lantos L000090 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/lantos | ||||||||||||
38248 | 38248 | Juanita Millender-McDonald M000714 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 37 | http://www.house.gov/millender-mcdonald | ||||||||||||
38784 | 38784 | George Radanovich R000004 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 19 | http://www.radanovich.house.gov | ||||||||||||
38833 | 38833 | Hilda Solis S001153 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 32 | http://www.house.gov/solis | ||||||||||||
38884 | 38884 | Ellen Tauscher T000057 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38917 | 38917 | Diane Watson W000794 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38937 | 38937 | Dennis Cardoza C001050 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38953 | 38953 | Jane Harman H000213 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
39013 | 39013 | Bob Filner F000116 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39113 | 39113 | Joe Baca B001234 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39153 | 39153 | Howard Berman B000410 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39175 | 39175 | Mary Bono Mack B001228 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 45 | http://www.house.gov/bono | ||||||||||||
39264 | 39264 | David Dreier D000492 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39293 | 39293 | Elton Gallegly G000021 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39314 | 39314 | Walter Herger H000528 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39395 | 39395 | Jerry Lewis L000274 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39528 | 39528 | Fortney Stark S000810 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39576 | 39576 | Lynn Woolsey W000738 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/woolsey | ||||||||||||
39942 | 39942 | Howard McKeon M000508 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 25 | http://www.house.gov/mckeon | ||||||||||||
39956 | 39956 | Gary Miller M001139 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39976 | 39976 | George Miller M000725 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | ||||||||||||
40093 | 40093 | Henry Waxman W000215 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 30 | http://www.house.gov/waxman | ||||||||||||
40270 | 40270 | Lois Capps C001036 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40301 | 40301 | Sam Farr F000030 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 17 | http://www.house.gov/farr | ||||||||||||
40354 | 40354 | Michael Honda H001034 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 15 | http://www.house.gov/honda | ||||||||||||
40470 | 40470 | Loretta Sanchez S000030 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 47 | http://www.house.gov/sanchez | ||||||||||||
40517 | 40517 | Xavier Becerra B000287 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
40981 | 40981 | Dana Rohrabacher R000409 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
41028 | 41028 | Edward Royce R000487 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 40 | http://www.house.gov/royce | ||||||||||||
41318 | 41318 | Susan Davis D000598 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41652 | 41652 | Devin Nunes N000181 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 21 | http://www.nunes.house.gov | ||||||||||||
42065 | 42065 | Ken Calvert C000059 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 44 | http://www.house.gov/calvert | ||||||||||||
42368 | 42368 | Anna Eshoo E000215 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 14 | http://www-eshoo.house.gov | ||||||||||||
42728 | 42728 | Barbara Lee L000551 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/lee | ||||||||||||
42744 | 42744 | Zoe Lofgren L000397 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 16 | http://zoelofgren.house.gov | ||||||||||||
42990 | 42990 | Grace Napolitano N000179 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 38 | http://www.napolitano.house.gov | ||||||||||||
43080 | 43080 | Nancy Pelosi P000197 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43186 | 43186 | Lucille Roybal-Allard R000486 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43269 | 43269 | Adam Schiff S001150 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 29 | http://www.house.gov/schiff | ||||||||||||
43359 | 43359 | Brad Sherman S000344 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 27 | http://www.house.gov/sherman | ||||||||||||
43440 | 43440 | Linda Sánchez S001156 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43467 | 43467 | Mike Thompson T000460 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/mthompson | ||||||||||||
43575 | 43575 | Maxine Waters W000187 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
44446 | 44446 | Darrell Issa I000056 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
37228 | 37228 | Wayne Allard A000109 | sen | CO | 2003-01-07 | 2009-01-03 | 2 | Republican | http://allard.senate.gov | ||||||||||||
37438 | 37438 | Scott McInnis M000477 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 3 | http://www.house.gov/mcinnis | ||||||||||||
37515 | 37515 | Bob Beauprez B001240 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/beauprez | ||||||||||||
37689 | 37689 | Joel Hefley H000444 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/hefley | ||||||||||||
38251 | 38251 | Marilyn Musgrave M001152 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/musgrave | ||||||||||||
38346 | 38346 | Thomas Tancredo T000458 | rep | CO | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/tancredo | ||||||||||||
39730 | 39730 | Mark Udall U000038 | rep | CO | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/markudall | ||||||||||||
42287 | 42287 | Diana DeGette D000197 | rep | CO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
37735 | 37735 | Nancy Johnson J000163 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37880 | 37880 | Robert Simmons S001152 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
38341 | 38341 | Christopher Shays S001144 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
42303 | 42303 | Rosa DeLauro D000216 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42699 | 42699 | John Larson L000557 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
43023 | 43023 | Eleanor Norton N000147 | rep | DC | 2003-01-07 | 2005-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
38433 | 38433 | Joseph Biden B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
38484 | 38484 | Michael Castle C000243 | rep | DE | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
37305 | 37305 | Peter Deutsch D000275 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 20 | http://www.house.gov/deutsch | ||||||||||||
37363 | 37363 | Porter Goss G000336 | rep | FL | 2003-01-07 | 2004-09-23 | Republican | 14 | http://www.house.gov/goss | ||||||||||||
37530 | 37530 | Michael Bilirakis B000463 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 9 | http://www.house.gov/bilirakis | ||||||||||||
37591 | 37591 | James Davis D000114 | rep | FL | 2003-01-07 | 2005-01-03 | Democrat | 11 | http://www.house.gov/jimdavis | ||||||||||||
37641 | 37641 | Mark Foley F000238 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 16 | http://www.house.gov/foley | ||||||||||||
37670 | 37670 | Katherine Harris H001035 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 13 | http://www.house.gov/harris |
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);