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 state
This data as json, copyable, CSV (advanced)
Suggested facets: state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41681 | 41681 | Don Young Y000033 | rep | AK | 2007-01-04 | 2009-01-03 | Republican | 0 | http://donyoung.house.gov | ||||||||||||
37985 | 37985 | Robert Cramer C000868 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cramer.house.gov | ||||||||||||
38037 | 38037 | Terry Everett E000268 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.everett.house.gov | ||||||||||||
38493 | 38493 | Artur Davis D000602 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
39612 | 39612 | Jo Bonner B001244 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 1 | http://bonner.house.gov | ||||||||||||
39745 | 39745 | Spencer Bachus B000013 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bachus.house.gov | ||||||||||||
41909 | 41909 | Robert Aderholt A000055 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 4 | http://aderholt.house.gov | ||||||||||||
43173 | 43173 | Mike Rogers R000575 | rep | AL | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | ||||||||||||
38426 | 38426 | Robert Berry B000420 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38830 | 38830 | Victor Snyder S000672 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
39494 | 39494 | Mike Ross R000573 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
41995 | 41995 | John Boozman B001236 | rep | AR | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.house.gov/boozman | ||||||||||||
39838 | 39838 | Eni Faleomavaega F000010 | rep | AS | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | ||||||||||||
38313 | 38313 | Rick Renzi R000574 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 1 | http://www.house.gov/renzi | ||||||||||||
38668 | 38668 | Harry Mitchell M001167 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38806 | 38806 | John Shadegg S000275 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 3 | http://johnshadegg.house.gov | ||||||||||||
38946 | 38946 | Gabrielle Giffords G000554 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
40005 | 40005 | Ed Pastor P000099 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/pastor | ||||||||||||
40584 | 40584 | Trent Franks F000448 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/franks | ||||||||||||
40665 | 40665 | Jon Kyl K000352 | sen | AZ | 2007-01-04 | 2013-01-03 | 1 | Republican | http://kyl.senate.gov/ | 730 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4521 | 202-224-2207 | http://www.kyl.senate.gov/contact.cfm | 730 Hart Senate Office Building | |||||||
40801 | 40801 | Jeff Flake F000444 | rep | AZ | 2007-01-04 | 2009-01-03 | Republican | 6 | http://flake.house.gov | ||||||||||||
42472 | 42472 | Raúl Grijalva G000551 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/grijalva | ||||||||||||
38013 | 38013 | John Doolittle D000429 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://doolittle.house.gov | ||||||||||||
38128 | 38128 | Duncan Hunter H000981 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38193 | 38193 | Tom Lantos L000090 | rep | CA | 2007-01-04 | 2008-02-11 | Democrat | 12 | http://lantos.house.gov | ||||||||||||
38250 | 38250 | Juanita Millender-McDonald M000714 | rep | CA | 2007-01-04 | 2007-04-22 | Democrat | 37 | http://millender-mcdonald.house.gov | ||||||||||||
38786 | 38786 | George Radanovich R000004 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38835 | 38835 | Hilda Solis S001153 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 32 | http://solis.house.gov | ||||||||||||
38886 | 38886 | Ellen Tauscher T000057 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38919 | 38919 | Diane Watson W000794 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38939 | 38939 | Dennis Cardoza C001050 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38955 | 38955 | Jane Harman H000213 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
39015 | 39015 | Bob Filner F000116 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39115 | 39115 | Joe Baca B001234 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39155 | 39155 | Howard Berman B000410 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39169 | 39169 | Brian Bilbray B000461 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39177 | 39177 | Mary Bono Mack B001228 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39266 | 39266 | David Dreier D000492 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39295 | 39295 | Elton Gallegly G000021 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39316 | 39316 | Walter Herger H000528 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39397 | 39397 | Jerry Lewis L000274 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39406 | 39406 | Daniel Lungren L000517 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 3 | http://www.lungren.house.gov | ||||||||||||
39530 | 39530 | Fortney Stark S000810 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39578 | 39578 | Lynn Woolsey W000738 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://woolsey.house.gov | ||||||||||||
39781 | 39781 | John Campbell C001064 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39944 | 39944 | Howard McKeon M000508 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 25 | http://mckeon.house.gov | ||||||||||||
39958 | 39958 | Gary Miller M001139 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39978 | 39978 | George Miller M000725 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | ||||||||||||
40095 | 40095 | Henry Waxman W000215 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 30 | http://www.henrywaxman.house.gov | ||||||||||||
40272 | 40272 | Lois Capps C001036 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40303 | 40303 | Sam Farr F000030 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://www.house.gov/farr | ||||||||||||
40356 | 40356 | Michael Honda H001034 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 15 | http://www.house.gov/honda | ||||||||||||
40472 | 40472 | Loretta Sanchez S000030 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | ||||||||||||
40519 | 40519 | Xavier Becerra B000287 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
40983 | 40983 | Dana Rohrabacher R000409 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
41030 | 41030 | Edward Royce R000487 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 40 | http://www.royce.house.gov | ||||||||||||
41320 | 41320 | Susan Davis D000598 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41654 | 41654 | Devin Nunes N000181 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 21 | http://nunes.house.gov | ||||||||||||
41773 | 41773 | Dianne Feinstein F000062 | sen | CA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://feinstein.senate.gov | 331 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3841 | 202-228-3954 | http://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | |||||||
42067 | 42067 | Ken Calvert C000059 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
42215 | 42215 | Jim Costa C001059 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://www.house.gov/costa | ||||||||||||
42370 | 42370 | Anna Eshoo E000215 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
42730 | 42730 | Barbara Lee L000551 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://lee.house.gov | ||||||||||||
42746 | 42746 | Zoe Lofgren L000397 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://www.house.gov/lofgren | ||||||||||||
42839 | 42839 | Doris Matsui M001163 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
42847 | 42847 | Kevin McCarthy M001165 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | ||||||||||||
42919 | 42919 | Jerry McNerney M001166 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://mcnerney.house.gov | ||||||||||||
42992 | 42992 | Grace Napolitano N000179 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 38 | http://napolitano.house.gov | ||||||||||||
43082 | 43082 | Nancy Pelosi P000197 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43188 | 43188 | Lucille Roybal-Allard R000486 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43271 | 43271 | Adam Schiff S001150 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 29 | http://schiff.house.gov | ||||||||||||
43361 | 43361 | Brad Sherman S000344 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
43442 | 43442 | Linda Sánchez S001156 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43469 | 43469 | Mike Thompson T000460 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://mikethompson.house.gov | ||||||||||||
43577 | 43577 | Maxine Waters W000187 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
38253 | 38253 | Marilyn Musgrave M001152 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 4 | http://musgrave.house.gov | ||||||||||||
38348 | 38348 | Thomas Tancredo T000458 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 6 | http://tancredo.house.gov | ||||||||||||
38795 | 38795 | John Salazar S001158 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/salazar | ||||||||||||
39732 | 39732 | Mark Udall U000038 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://markudall.house.gov/HoR/CO02/Home.htm | ||||||||||||
42289 | 42289 | Diana DeGette D000197 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42663 | 42663 | Doug Lamborn L000564 | rep | CO | 2007-01-04 | 2009-01-03 | Republican | 5 | http://lamborn.house.gov | ||||||||||||
43090 | 43090 | Ed Perlmutter P000593 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://perlmutter.house.gov | ||||||||||||
38343 | 38343 | Christopher Shays S001144 | rep | CT | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
39062 | 39062 | Joseph Lieberman L000304 | sen | CT | 2007-01-04 | 2013-01-03 | 1 | Independent | http://lieberman.senate.gov/ | 706 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4041 | 202-224-9750 | http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue | 706 Hart Senate Office Building | |||||||
42223 | 42223 | Joe Courtney C001069 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42305 | 42305 | Rosa DeLauro D000216 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42701 | 42701 | John Larson L000557 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42962 | 42962 | Christopher Murphy M001169 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
43025 | 43025 | Eleanor Norton N000147 | rep | DC | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/norton | ||||||||||||
38486 | 38486 | Michael Castle C000243 | rep | DE | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
41764 | 41764 | Thomas Carper C000174 | sen | DE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://carper.senate.gov | 513 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/contact/ | 513 Hart Senate Office Building | |||||||
38040 | 38040 | Tom Feeney F000447 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 24 | http://www.house.gov/feeney | ||||||||||||
38148 | 38148 | Ric Keller K000361 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/keller/Frset.htm | ||||||||||||
38214 | 38214 | Tim Mahoney M001164 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://mahoney.house.gov | ||||||||||||
38371 | 38371 | David Weldon W000267 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 15 | http://weldon.house.gov | ||||||||||||
38455 | 38455 | Allen Boyd B000716 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38465 | 38465 | Virginia Brown-Waite B001247 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/brown-waite | ||||||||||||
38522 | 38522 | Lincoln Diaz-Balart D000299 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 21 | http://www.house.gov/diaz-balart | ||||||||||||
38631 | 38631 | Ron Klein K000366 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://klein.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);