legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
45 rows where "end" is on date 1985-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
33526 | 33526 | Sala Burton B001158 | rep | CA | 1983-06-21 | 1985-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 |
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);