legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
47 rows where "start" is on date 1987-01-06 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33483 | 33483 | Robert Badham B000024 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 40 | |||||||||||||
33528 | 33528 | Sala Burton B001158 | rep | CA | 1987-01-06 | 1987-02-01 | Democrat | 5 | |||||||||||||
33542 | 33542 | Alan Cranston C000877 | sen | CA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33636 | 33636 | Ernest Konnyu K000309 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 12 | |||||||||||||
33812 | 33812 | Jim Bates B000236 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 44 | |||||||||||||
33833 | 33833 | Douglas Bosco B000648 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
33859 | 33859 | Anthony Coelho C000581 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 15 | |||||||||||||
33945 | 33945 | Augustus Hawkins H000367 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 29 | |||||||||||||
34044 | 34044 | Charles Pashayan P000097 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 17 | |||||||||||||
34094 | 34094 | Norman Shumway S000393 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 14 | |||||||||||||
34183 | 34183 | Glenn Anderson A000189 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 32 | |||||||||||||
34359 | 34359 | William Dannemeyer D000044 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 39 | |||||||||||||
34408 | 34408 | Mervyn Dymally D000592 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 31 | |||||||||||||
34660 | 34660 | Robert Lagomarsino L000020 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 19 | |||||||||||||
34686 | 34686 | Meldon Levine L000264 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 27 | |||||||||||||
34692 | 34692 | William Lowery L000479 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 41 | |||||||||||||
34910 | 34910 | Edward Roybal R000485 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 25 | |||||||||||||
35211 | 35211 | William Edwards E000064 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 10 | |||||||||||||
35362 | 35362 | Richard Lehman L000225 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 18 | |||||||||||||
35406 | 35406 | Alfred McCandless M000306 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 37 | |||||||||||||
35498 | 35498 | Leon Panetta P000047 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 16 | |||||||||||||
35688 | 35688 | Anthony Beilenson B000318 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 23 | |||||||||||||
35776 | 35776 | Robert Dornan D000435 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 38 | |||||||||||||
35913 | 35913 | Norman Mineta M000794 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 13 | |||||||||||||
35940 | 35940 | Carlos Moorhead M000926 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 22 | |||||||||||||
36150 | 36150 | Ronald Dellums D000222 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 8 | |||||||||||||
36167 | 36167 | Victor Fazio F000053 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
36430 | 36430 | Esteban Torres T000316 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 34 | |||||||||||||
36533 | 36533 | George Brown B000918 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 36 | |||||||||||||
36596 | 36596 | Julian Dixon D000373 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 28 | |||||||||||||
36689 | 36689 | Matthew Martínez M000206 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 30 | |||||||||||||
36726 | 36726 | Ron Packard P000005 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 43 | |||||||||||||
37419 | 37419 | Robert Matsui M000249 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
37910 | 37910 | William Thomas T000188 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 20 | |||||||||||||
38118 | 38118 | Duncan Hunter H000981 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 45 | |||||||||||||
38183 | 38183 | Tom Lantos L000090 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 11 | |||||||||||||
39145 | 39145 | Howard Berman B000410 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 26 | |||||||||||||
39256 | 39256 | David Dreier D000492 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 33 | |||||||||||||
39285 | 39285 | Elton Gallegly G000021 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 21 | |||||||||||||
39306 | 39306 | Walter Herger H000528 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
39387 | 39387 | Jerry Lewis L000274 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 35 | |||||||||||||
39404 | 39404 | Daniel Lungren L000517 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 42 | |||||||||||||
39520 | 39520 | Fortney Stark S000810 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 9 | |||||||||||||
39968 | 39968 | George Miller M000725 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
40085 | 40085 | Henry Waxman W000215 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 24 | |||||||||||||
40203 | 40203 | Barbara Boxer B000711 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
43072 | 43072 | Nancy Pelosi P000197 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 5 |
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);