legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1983-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41669 | 41669 | Don Young Y000033 | rep | AK | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
32957 | 32957 | William Edwards E000084 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33692 | 33692 | William Nichols N000095 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33902 | 33902 | Ronnie Flippo F000208 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
34378 | 34378 | William Dickinson D000326 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34434 | 34434 | Ben Erdreich E000201 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
35701 | 35701 | Tom Bevill B000431 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
43348 | 43348 | Richard Shelby S000320 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
32906 | 32906 | Edwin Bethune B000422 | rep | AR | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34169 | 34169 | William Alexander A000103 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34202 | 34202 | Beryl Anthony A000213 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
34519 | 34519 | John Hammerschmidt H000124 | rep | AR | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
33778 | 33778 | Fofó Sunia S001077 | rep | AS | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33054 | 33054 | James McNulty M000589 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33402 | 33402 | Eldon Rudd R000495 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33878 | 33878 | Dennis DeConcini D000185 | sen | AZ | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
35024 | 35024 | Morris Udall U000001 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
37173 | 37173 | Robert Stump S001044 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
40646 | 40646 | John McCain M000303 | rep | AZ | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
32918 | 32918 | Phillip Burton B001156 | rep | CA | 1983-01-03 | 1983-04-10 | Democrat | 5 | |||||||||||||
33086 | 33086 | Jerry Patterson P000121 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 38 | |||||||||||||
33252 | 33252 | Eugene Chappie C000322 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
33266 | 33266 | Bobbi Fiedler F000102 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 21 | |||||||||||||
33453 | 33453 | Edwin Zschau Z000014 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
33481 | 33481 | Robert Badham B000024 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 40 | |||||||||||||
33810 | 33810 | Jim Bates B000236 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 44 | |||||||||||||
33831 | 33831 | Douglas Bosco B000648 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33857 | 33857 | Anthony Coelho C000581 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 15 | |||||||||||||
33943 | 33943 | Augustus Hawkins H000367 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 29 | |||||||||||||
34042 | 34042 | Charles Pashayan P000097 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 17 | |||||||||||||
34092 | 34092 | Norman Shumway S000393 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 14 | |||||||||||||
34140 | 34140 | Pete Wilson W000607 | sen | CA | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34181 | 34181 | Glenn Anderson A000189 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 32 | |||||||||||||
34357 | 34357 | William Dannemeyer D000044 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 39 | |||||||||||||
34406 | 34406 | Mervyn Dymally D000592 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 31 | |||||||||||||
34658 | 34658 | Robert Lagomarsino L000020 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 19 | |||||||||||||
34684 | 34684 | Meldon Levine L000264 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 27 | |||||||||||||
34690 | 34690 | William Lowery L000479 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 41 | |||||||||||||
34908 | 34908 | Edward Roybal R000485 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 25 | |||||||||||||
35209 | 35209 | William Edwards E000064 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
35360 | 35360 | Richard Lehman L000225 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
35404 | 35404 | Alfred McCandless M000306 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 37 | |||||||||||||
35496 | 35496 | Leon Panetta P000047 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 16 | |||||||||||||
35686 | 35686 | Anthony Beilenson B000318 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
35911 | 35911 | Norman Mineta M000794 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 13 | |||||||||||||
35938 | 35938 | Carlos Moorhead M000926 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 22 | |||||||||||||
36148 | 36148 | Ronald Dellums D000222 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
36165 | 36165 | Victor Fazio F000053 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
36428 | 36428 | Esteban Torres T000316 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 34 | |||||||||||||
36531 | 36531 | George Brown B000918 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 36 | |||||||||||||
36594 | 36594 | Julian Dixon D000373 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 28 | |||||||||||||
36687 | 36687 | Matthew Martínez M000206 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 30 | |||||||||||||
36724 | 36724 | Ron Packard P000005 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 43 | |||||||||||||
37417 | 37417 | Robert Matsui M000249 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
37908 | 37908 | William Thomas T000188 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 20 | |||||||||||||
38116 | 38116 | Duncan Hunter H000981 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 45 | |||||||||||||
38181 | 38181 | Tom Lantos L000090 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
39143 | 39143 | Howard Berman B000410 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 26 | |||||||||||||
39254 | 39254 | David Dreier D000492 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 33 | |||||||||||||
39385 | 39385 | Jerry Lewis L000274 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 35 | |||||||||||||
39402 | 39402 | Daniel Lungren L000517 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 42 | |||||||||||||
39518 | 39518 | Fortney Stark S000810 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
39966 | 39966 | George Miller M000725 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
40083 | 40083 | Henry Waxman W000215 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 24 | |||||||||||||
40201 | 40201 | Barbara Boxer B000711 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33022 | 33022 | Raymond Kogovsek K000304 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33331 | 33331 | Kenneth Kramer K000322 | rep | CO | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
33803 | 33803 | Timothy Wirth W000647 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
34284 | 34284 | George Brown B000919 | rep | CO | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
36029 | 36029 | Patricia Schroeder S000142 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
36353 | 36353 | Daniel Schaefer S000109 | rep | CO | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
33119 | 33119 | William Ratchford R000067 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33172 | 33172 | Lowell Weicker W000253 | sen | CT | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
33676 | 33676 | Stewart McKinney M000527 | rep | CT | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
34026 | 34026 | Bruce Morrison M000992 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
36273 | 36273 | Barbara Kennelly K000118 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
36622 | 36622 | Sam Gejdenson G000120 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
37725 | 37725 | Nancy Johnson J000163 | rep | CT | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
33895 | 33895 | Walter Fauntroy F000046 | rep | DC | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
36021 | 36021 | William Roth R000460 | sen | DE | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
41758 | 41758 | Thomas Carper C000174 | rep | DE | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
32921 | 32921 | Lawton Chiles C000356 | sen | FL | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33280 | 33280 | Don Fuqua F000430 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33536 | 33536 | William Chappell C000321 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33667 | 33667 | Kenneth MacKay M000023 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33681 | 33681 | Daniel Mica M000688 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
34059 | 34059 | Claude Pepper P000218 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
34250 | 34250 | Charles Bennett B000371 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
34456 | 34456 | Dante Fascell F000041 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
34598 | 34598 | Andrew Ireland I000029 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
34668 | 34668 | William Lehman L000226 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 17 | |||||||||||||
34970 | 34970 | Lawrence Smith S000586 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 16 | |||||||||||||
35339 | 35339 | Earl Hutto H001018 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
35367 | 35367 | Thomas Lewis L000295 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
35831 | 35831 | Sam Gibbons G000153 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
35895 | 35895 | Connie Mack M000019 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 13 | |||||||||||||
36697 | 36697 | Bill McCollum M000350 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
37520 | 37520 | Michael Bilirakis B000463 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 9 | |||||||||||||
37863 | 37863 | E. Shaw S000303 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 15 | |||||||||||||
39628 | 39628 | C. Young Y000031 | rep | FL | 1983-01-03 | 1985-01-03 | Republican | 8 |
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);