legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
476 rows where "start" is on date 1993-01-05 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36718 | 36718 | Frank Murkowski M001085 | sen | AK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
41674 | 41674 | Don Young Y000033 | rep | AK | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
35706 | 35706 | Tom Bevill B000431 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35715 | 35715 | John Browder B000897 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36849 | 36849 | H. Callahan C000052 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36963 | 36963 | Earl Hilliard H000621 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
37978 | 37978 | Robert Cramer C000868 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
38030 | 38030 | Terry Everett E000268 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
39738 | 39738 | Spencer Bachus B000013 | rep | AL | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
43351 | 43351 | Richard Shelby S000320 | sen | AL | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1994-11-09", "party": "Democrat" }, { "start": "1994-11-09", "end": "2005-01-03", "party": "Republican" } ] |
||||||||||||
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36054 | 36054 | Raymond Thornton T000243 | rep | AR | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36262 | 36262 | Tim Hutchinson H001015 | rep | AR | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
36588 | 36588 | Jay Dickey D000312 | rep | AR | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
37772 | 37772 | Blanche Lincoln L000035 | rep | AR | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
39831 | 39831 | Eni Faleomavaega F000010 | rep | AS | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
35170 | 35170 | Samuel Coppersmith C000767 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35225 | 35225 | Karan English E000186 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
37178 | 37178 | Robert Stump S001044 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37750 | 37750 | James Kolbe K000306 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
39998 | 39998 | Ed Pastor P000099 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
40649 | 40649 | John McCain M000303 | sen | AZ | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
40662 | 40662 | Jon Kyl K000352 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
35214 | 35214 | William Edwards E000064 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
35313 | 35313 | Daniel Hamburg H000096 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35326 | 35326 | Michael Huffington H000912 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 22 | |||||||||||||
35365 | 35365 | Richard Lehman L000225 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
35409 | 35409 | Alfred McCandless M000306 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 44 | |||||||||||||
35501 | 35501 | Leon Panetta P000047 | rep | CA | 1993-01-05 | 1993-01-21 | Democrat | 17 | |||||||||||||
35564 | 35564 | Lynn Schenk S000119 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 49 | |||||||||||||
35681 | 35681 | William Baker B000078 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
35691 | 35691 | Anthony Beilenson B000318 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 24 | |||||||||||||
35779 | 35779 | Robert Dornan D000435 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 46 | |||||||||||||
35916 | 35916 | Norman Mineta M000794 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35943 | 35943 | Carlos Moorhead M000926 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 27 | |||||||||||||
36058 | 36058 | Walter Tucker T000405 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 37 | |||||||||||||
36153 | 36153 | Ronald Dellums D000222 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36170 | 36170 | Victor Fazio F000053 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36281 | 36281 | Jay Kim K000181 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 41 | |||||||||||||
36433 | 36433 | Esteban Torres T000316 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 34 | |||||||||||||
36536 | 36536 | George Brown B000918 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 42 | |||||||||||||
36599 | 36599 | Julian Dixon D000373 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 32 | |||||||||||||
36692 | 36692 | Matthew Martínez M000206 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 31 | |||||||||||||
36729 | 36729 | Ron Packard P000005 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 48 | |||||||||||||
36873 | 36873 | Gary Condit C000670 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
36968 | 36968 | Stephen Horn H000789 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 38 | |||||||||||||
37314 | 37314 | Calvin Dooley D000424 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 20 | |||||||||||||
37422 | 37422 | Robert Matsui M000249 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
37573 | 37573 | C. Cox C000830 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 47 | |||||||||||||
37581 | 37581 | Randall Cunningham C000994 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 51 | |||||||||||||
37833 | 37833 | Richard Pombo P000419 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 11 | |||||||||||||
37913 | 37913 | William Thomas T000188 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 21 | |||||||||||||
38006 | 38006 | John Doolittle D000429 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
38121 | 38121 | Duncan Hunter H000981 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 52 | |||||||||||||
38186 | 38186 | Tom Lantos L000090 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
38949 | 38949 | Jane Harman H000213 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 36 | |||||||||||||
39008 | 39008 | Bob Filner F000116 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 50 | |||||||||||||
39148 | 39148 | Howard Berman B000410 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 26 | |||||||||||||
39259 | 39259 | David Dreier D000492 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 28 | |||||||||||||
39288 | 39288 | Elton Gallegly G000021 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 23 | |||||||||||||
39309 | 39309 | Walter Herger H000528 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
39390 | 39390 | Jerry Lewis L000274 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 40 | |||||||||||||
39523 | 39523 | Fortney Stark S000810 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
39571 | 39571 | Lynn Woolsey W000738 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
39937 | 39937 | Howard McKeon M000508 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 25 | |||||||||||||
39971 | 39971 | George Miller M000725 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
40088 | 40088 | Henry Waxman W000215 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 29 | |||||||||||||
40206 | 40206 | Barbara Boxer B000711 | sen | CA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
40512 | 40512 | Xavier Becerra B000287 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
40976 | 40976 | Dana Rohrabacher R000409 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 45 | |||||||||||||
41023 | 41023 | Edward Royce R000487 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 39 | |||||||||||||
42060 | 42060 | Ken Calvert C000059 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 43 | |||||||||||||
42363 | 42363 | Anna Eshoo E000215 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
43075 | 43075 | Nancy Pelosi P000197 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
43181 | 43181 | Lucille Roybal-Allard R000486 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 33 | |||||||||||||
43570 | 43570 | Maxine Waters W000187 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 35 | |||||||||||||
36034 | 36034 | Patricia Schroeder S000142 | rep | CO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36358 | 36358 | Daniel Schaefer S000109 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36369 | 36369 | David Skaggs S000462 | rep | CO | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36543 | 36543 | Ben Campbell C000077 | sen | CO | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1995-03-03", "party": "Democrat" }, { "start": "1995-03-03", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
37225 | 37225 | Wayne Allard A000109 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
37433 | 37433 | Scott McInnis M000477 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37684 | 37684 | Joel Hefley H000444 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
35812 | 35812 | Gary Franks F000348 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
36278 | 36278 | Barbara Kennelly K000118 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36627 | 36627 | Sam Gejdenson G000120 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
37609 | 37609 | Christopher Dodd D000388 | sen | CT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37730 | 37730 | Nancy Johnson J000163 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
38336 | 38336 | Christopher Shays S001144 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
43018 | 43018 | Eleanor Norton N000147 | rep | DC | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
38479 | 38479 | Michael Castle C000243 | rep | DE | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
35121 | 35121 | James Bacchus B000008 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35344 | 35344 | Earl Hutto H001018 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35372 | 35372 | Thomas Lewis L000295 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 16 | |||||||||||||
35836 | 35836 | Sam Gibbons G000153 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
35880 | 35880 | Harry Johnston J000187 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
35973 | 35973 | Douglas Peterson P000259 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36550 | 36550 | Charles Canady C000107 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 12 | |||||||||||||
36613 | 36613 | Tillie Fowler F000328 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 4 |
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);