legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
52 rows where "start" is on date 1997-01-07 and state = "CA"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36137 | 36137 | Sonny Bono B000622 | rep | CA | 1997-01-07 | 1998-01-05 | Republican | 44 | |||||||||||||
36138 | 36138 | Walter Capps C000134 | rep | CA | 1997-01-07 | 1997-10-28 | Democrat | 22 | |||||||||||||
36155 | 36155 | Ronald Dellums D000222 | rep | CA | 1997-01-07 | 1998-02-07 | Democrat | 9 | |||||||||||||
36172 | 36172 | Victor Fazio F000053 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
36283 | 36283 | Jay Kim K000181 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 41 | |||||||||||||
36350 | 36350 | Frank Riggs R000252 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36435 | 36435 | Esteban Torres T000316 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 34 | |||||||||||||
36538 | 36538 | George Brown B000918 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 42 | |||||||||||||
36548 | 36548 | Tom Campbell C000100 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 15 | |||||||||||||
36601 | 36601 | Julian Dixon D000373 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 32 | |||||||||||||
36694 | 36694 | Matthew Martínez M000206 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 31 | |||||||||||||
36731 | 36731 | Ron Packard P000005 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 48 | |||||||||||||
36753 | 36753 | James Rogan R000386 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 27 | |||||||||||||
36875 | 36875 | Gary Condit C000670 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
36970 | 36970 | Stephen Horn H000789 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 38 | |||||||||||||
37316 | 37316 | Calvin Dooley D000424 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 20 | |||||||||||||
37424 | 37424 | Robert Matsui M000249 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37575 | 37575 | C. Cox C000830 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 47 | |||||||||||||
37583 | 37583 | Randall Cunningham C000994 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 51 | |||||||||||||
37835 | 37835 | Richard Pombo P000419 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 11 | |||||||||||||
37915 | 37915 | William Thomas T000188 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 21 | |||||||||||||
38008 | 38008 | John Doolittle D000429 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
38123 | 38123 | Duncan Hunter H000981 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 52 | |||||||||||||
38188 | 38188 | Tom Lantos L000090 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 12 | |||||||||||||
38245 | 38245 | Juanita Millender-McDonald M000714 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 37 | |||||||||||||
38781 | 38781 | George Radanovich R000004 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 19 | |||||||||||||
38881 | 38881 | Ellen Tauscher T000057 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
38951 | 38951 | Jane Harman H000213 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 36 | |||||||||||||
39010 | 39010 | Bob Filner F000116 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 50 | |||||||||||||
39150 | 39150 | Howard Berman B000410 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 26 | |||||||||||||
39166 | 39166 | Brian Bilbray B000461 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 49 | |||||||||||||
39261 | 39261 | David Dreier D000492 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 28 | |||||||||||||
39290 | 39290 | Elton Gallegly G000021 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 23 | |||||||||||||
39311 | 39311 | Walter Herger H000528 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
39392 | 39392 | Jerry Lewis L000274 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 40 | |||||||||||||
39525 | 39525 | Fortney Stark S000810 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 13 | |||||||||||||
39573 | 39573 | Lynn Woolsey W000738 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
39939 | 39939 | Howard McKeon M000508 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 25 | |||||||||||||
39973 | 39973 | George Miller M000725 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
40090 | 40090 | Henry Waxman W000215 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 29 | |||||||||||||
40298 | 40298 | Sam Farr F000030 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
40467 | 40467 | Loretta Sanchez S000030 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 46 | |||||||||||||
40514 | 40514 | Xavier Becerra B000287 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
40978 | 40978 | Dana Rohrabacher R000409 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 45 | |||||||||||||
41025 | 41025 | Edward Royce R000487 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 39 | |||||||||||||
42062 | 42062 | Ken Calvert C000059 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 43 | |||||||||||||
42365 | 42365 | Anna Eshoo E000215 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
42741 | 42741 | Zoe Lofgren L000397 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 16 | |||||||||||||
43077 | 43077 | Nancy Pelosi P000197 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
43183 | 43183 | Lucille Roybal-Allard R000486 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 33 | |||||||||||||
43356 | 43356 | Brad Sherman S000344 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 24 | |||||||||||||
43572 | 43572 | Maxine Waters W000187 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 35 |
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);