legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
52 rows where "end" is on date 2003-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36877 | 36877 | Gary Condit C000670 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
36972 | 36972 | Stephen Horn H000789 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 38 | |||||||||||||
37318 | 37318 | Calvin Dooley D000424 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 20 | |||||||||||||
37426 | 37426 | Robert Matsui M000249 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37445 | 37445 | Doug Ose O000164 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
37577 | 37577 | C. Cox C000830 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 47 | |||||||||||||
37585 | 37585 | Randall Cunningham C000994 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 51 | |||||||||||||
37837 | 37837 | Richard Pombo P000419 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 11 | |||||||||||||
37917 | 37917 | William Thomas T000188 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 21 | |||||||||||||
38010 | 38010 | John Doolittle D000429 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38125 | 38125 | Duncan Hunter H000981 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 52 | |||||||||||||
38190 | 38190 | Tom Lantos L000090 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
38247 | 38247 | Juanita Millender-McDonald M000714 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 37 | |||||||||||||
38783 | 38783 | George Radanovich R000004 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 19 | |||||||||||||
38832 | 38832 | Hilda Solis S001153 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 31 | |||||||||||||
38883 | 38883 | Ellen Tauscher T000057 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
38916 | 38916 | Diane Watson W000794 | rep | CA | 2001-06-07 | 2003-01-03 | Democrat | 32 | |||||||||||||
38952 | 38952 | Jane Harman H000213 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 36 | |||||||||||||
39012 | 39012 | Bob Filner F000116 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 50 | |||||||||||||
39112 | 39112 | Joe Baca B001234 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 42 | |||||||||||||
39152 | 39152 | Howard Berman B000410 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 26 | |||||||||||||
39174 | 39174 | Mary Bono Mack B001228 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 44 | |||||||||||||
39263 | 39263 | David Dreier D000492 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 28 | |||||||||||||
39292 | 39292 | Elton Gallegly G000021 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 23 | |||||||||||||
39313 | 39313 | Walter Herger H000528 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
39394 | 39394 | Jerry Lewis L000274 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 40 | |||||||||||||
39527 | 39527 | Fortney Stark S000810 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
39575 | 39575 | Lynn Woolsey W000738 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
39941 | 39941 | Howard McKeon M000508 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 25 | |||||||||||||
39955 | 39955 | Gary Miller M001139 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 41 | |||||||||||||
39975 | 39975 | George Miller M000725 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
40092 | 40092 | Henry Waxman W000215 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 29 | |||||||||||||
40269 | 40269 | Lois Capps C001036 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 22 | |||||||||||||
40300 | 40300 | Sam Farr F000030 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
40353 | 40353 | Michael Honda H001034 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 15 | |||||||||||||
40469 | 40469 | Loretta Sanchez S000030 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 46 | |||||||||||||
40516 | 40516 | Xavier Becerra B000287 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
40980 | 40980 | Dana Rohrabacher R000409 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 45 | |||||||||||||
41027 | 41027 | Edward Royce R000487 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 39 | |||||||||||||
41317 | 41317 | Susan Davis D000598 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 49 | |||||||||||||
42064 | 42064 | Ken Calvert C000059 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 43 | |||||||||||||
42367 | 42367 | Anna Eshoo E000215 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
42727 | 42727 | Barbara Lee L000551 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
42743 | 42743 | Zoe Lofgren L000397 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 16 | |||||||||||||
42989 | 42989 | Grace Napolitano N000179 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 34 | |||||||||||||
43079 | 43079 | Nancy Pelosi P000197 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
43185 | 43185 | Lucille Roybal-Allard R000486 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 33 | |||||||||||||
43268 | 43268 | Adam Schiff S001150 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 27 | |||||||||||||
43358 | 43358 | Brad Sherman S000344 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 24 | |||||||||||||
43466 | 43466 | Mike Thompson T000460 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
43574 | 43574 | Maxine Waters W000187 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 35 | |||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 |
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);