legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "start" is on date 2001-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41678 | 41678 | Don Young Y000033 | rep | AK | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
36853 | 36853 | H. Callahan C000052 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
36967 | 36967 | Earl Hilliard H000621 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
37067 | 37067 | Bob Riley R000258 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37982 | 37982 | Robert Cramer C000868 | rep | AL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
38034 | 38034 | Terry Everett E000268 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
39742 | 39742 | Spencer Bachus B000013 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
41906 | 41906 | Robert Aderholt A000055 | rep | AL | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
36975 | 36975 | Asa Hutchinson H001014 | rep | AR | 2001-01-03 | 2001-08-06 | Republican | 3 | |||||||||||||
38423 | 38423 | Robert Berry B000420 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38827 | 38827 | Victor Snyder S000672 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
39491 | 39491 | Mike Ross R000573 | rep | AR | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
39835 | 39835 | Eni Faleomavaega F000010 | rep | AS | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
37182 | 37182 | Robert Stump S001044 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37678 | 37678 | John Hayworth H000413 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37754 | 37754 | James Kolbe K000306 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
38803 | 38803 | John Shadegg S000275 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
40002 | 40002 | Ed Pastor P000099 | rep | AZ | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
40664 | 40664 | Jon Kyl K000352 | sen | AZ | 2001-01-03 | 2007-01-03 | 1 | Republican | http://kyl.senate.gov/ | ||||||||||||
40798 | 40798 | Jeff Flake F000444 | rep | AZ | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
36877 | 36877 | Gary Condit C000670 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
36972 | 36972 | Stephen Horn H000789 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 38 | |||||||||||||
37318 | 37318 | Calvin Dooley D000424 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37426 | 37426 | Robert Matsui M000249 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37445 | 37445 | Doug Ose O000164 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37577 | 37577 | C. Cox C000830 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 47 | |||||||||||||
37585 | 37585 | Randall Cunningham C000994 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 51 | |||||||||||||
37837 | 37837 | Richard Pombo P000419 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
37917 | 37917 | William Thomas T000188 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 21 | |||||||||||||
38010 | 38010 | John Doolittle D000429 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38125 | 38125 | Duncan Hunter H000981 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 52 | |||||||||||||
38190 | 38190 | Tom Lantos L000090 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
38247 | 38247 | Juanita Millender-McDonald M000714 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 37 | |||||||||||||
38783 | 38783 | George Radanovich R000004 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 19 | |||||||||||||
38832 | 38832 | Hilda Solis S001153 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 31 | |||||||||||||
38883 | 38883 | Ellen Tauscher T000057 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38952 | 38952 | Jane Harman H000213 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 36 | |||||||||||||
39012 | 39012 | Bob Filner F000116 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 50 | |||||||||||||
39112 | 39112 | Joe Baca B001234 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 42 | |||||||||||||
39152 | 39152 | Howard Berman B000410 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 26 | |||||||||||||
39174 | 39174 | Mary Bono Mack B001228 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 44 | |||||||||||||
39263 | 39263 | David Dreier D000492 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 28 | |||||||||||||
39292 | 39292 | Elton Gallegly G000021 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 23 | |||||||||||||
39313 | 39313 | Walter Herger H000528 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
39394 | 39394 | Jerry Lewis L000274 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 40 | |||||||||||||
39527 | 39527 | Fortney Stark S000810 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
39575 | 39575 | Lynn Woolsey W000738 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
39941 | 39941 | Howard McKeon M000508 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 25 | |||||||||||||
39955 | 39955 | Gary Miller M001139 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 41 | |||||||||||||
39975 | 39975 | George Miller M000725 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
40092 | 40092 | Henry Waxman W000215 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 29 | |||||||||||||
40269 | 40269 | Lois Capps C001036 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 22 | |||||||||||||
40300 | 40300 | Sam Farr F000030 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
40353 | 40353 | Michael Honda H001034 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 15 | |||||||||||||
40469 | 40469 | Loretta Sanchez S000030 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 46 | |||||||||||||
40516 | 40516 | Xavier Becerra B000287 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
40980 | 40980 | Dana Rohrabacher R000409 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 45 | |||||||||||||
41027 | 41027 | Edward Royce R000487 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 39 | |||||||||||||
41317 | 41317 | Susan Davis D000598 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 49 | |||||||||||||
41772 | 41772 | Dianne Feinstein F000062 | sen | CA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://feinstein.senate.gov | ||||||||||||
42064 | 42064 | Ken Calvert C000059 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 43 | |||||||||||||
42367 | 42367 | Anna Eshoo E000215 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
42727 | 42727 | Barbara Lee L000551 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
42743 | 42743 | Zoe Lofgren L000397 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 16 | |||||||||||||
42989 | 42989 | Grace Napolitano N000179 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 34 | |||||||||||||
43079 | 43079 | Nancy Pelosi P000197 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
43185 | 43185 | Lucille Roybal-Allard R000486 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 33 | |||||||||||||
43268 | 43268 | Adam Schiff S001150 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 27 | |||||||||||||
43358 | 43358 | Brad Sherman S000344 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 24 | |||||||||||||
43466 | 43466 | Mike Thompson T000460 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
43574 | 43574 | Maxine Waters W000187 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 35 | |||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
37115 | 37115 | Bob Schaffer S000112 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
37437 | 37437 | Scott McInnis M000477 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37688 | 37688 | Joel Hefley H000444 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
38345 | 38345 | Thomas Tancredo T000458 | rep | CO | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
39729 | 39729 | Mark Udall U000038 | rep | CO | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
42286 | 42286 | Diana DeGette D000197 | rep | CO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37012 | 37012 | James Maloney M000090 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37734 | 37734 | Nancy Johnson J000163 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37879 | 37879 | Robert Simmons S001152 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
38340 | 38340 | Christopher Shays S001144 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
42302 | 42302 | Rosa DeLauro D000216 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42698 | 42698 | John Larson L000557 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
43022 | 43022 | Eleanor Norton N000147 | rep | DC | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
38483 | 38483 | Michael Castle C000243 | rep | DE | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
41763 | 41763 | Thomas Carper C000174 | sen | DE | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://carper.senate.gov | ||||||||||||
37021 | 37021 | Carrie Meek M000628 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
37026 | 37026 | Dan Miller M000720 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 13 | |||||||||||||
37112 | 37112 | Joe Scarborough S000106 | rep | FL | 2001-01-03 | 2001-09-05 | Republican | 1 | |||||||||||||
37187 | 37187 | Karen Thurman T000253 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37304 | 37304 | Peter Deutsch D000275 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37362 | 37362 | Porter Goss G000336 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 14 | |||||||||||||
37529 | 37529 | Michael Bilirakis B000463 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 9 | |||||||||||||
37590 | 37590 | James Davis D000114 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 11 | |||||||||||||
37640 | 37640 | Mark Foley F000238 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 16 | |||||||||||||
37872 | 37872 | E. Shaw S000303 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 22 | |||||||||||||
38145 | 38145 | Ric Keller K000361 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
38368 | 38368 | David Weldon W000267 | rep | FL | 2001-01-03 | 2003-01-03 | Republican | 15 |
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);