legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
53 rows where "start" is on date 1999-01-06 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36539 | 36539 | George Brown B000918 | rep | CA | 1999-01-06 | 1999-07-15 | Democrat | 42 | |||||||||||||
36549 | 36549 | Tom Campbell C000100 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 15 | |||||||||||||
36602 | 36602 | Julian Dixon D000373 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 32 | |||||||||||||
36669 | 36669 | Steven Kuykendall K000357 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 36 | |||||||||||||
36695 | 36695 | Matthew Martínez M000206 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 31 | [ { "start": "1999-01-06", "end": "2000-07-27", "party": "Democrat" }, { "start": "2000-07-27", "end": "2001-01-03", "party": "Republican" } ] |
||||||||||||
36732 | 36732 | Ron Packard P000005 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 48 | |||||||||||||
36754 | 36754 | James Rogan R000386 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 27 | |||||||||||||
36876 | 36876 | Gary Condit C000670 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
36971 | 36971 | Stephen Horn H000789 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 38 | |||||||||||||
37317 | 37317 | Calvin Dooley D000424 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 20 | |||||||||||||
37425 | 37425 | Robert Matsui M000249 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37444 | 37444 | Doug Ose O000164 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37576 | 37576 | C. Cox C000830 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 47 | |||||||||||||
37584 | 37584 | Randall Cunningham C000994 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 51 | |||||||||||||
37836 | 37836 | Richard Pombo P000419 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
37916 | 37916 | William Thomas T000188 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 21 | |||||||||||||
38009 | 38009 | John Doolittle D000429 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38124 | 38124 | Duncan Hunter H000981 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 52 | |||||||||||||
38189 | 38189 | Tom Lantos L000090 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 12 | |||||||||||||
38246 | 38246 | Juanita Millender-McDonald M000714 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 37 | |||||||||||||
38782 | 38782 | George Radanovich R000004 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 19 | |||||||||||||
38882 | 38882 | Ellen Tauscher T000057 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 10 | |||||||||||||
39011 | 39011 | Bob Filner F000116 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 50 | |||||||||||||
39151 | 39151 | Howard Berman B000410 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 26 | |||||||||||||
39167 | 39167 | Brian Bilbray B000461 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 49 | |||||||||||||
39173 | 39173 | Mary Bono Mack B001228 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 44 | |||||||||||||
39262 | 39262 | David Dreier D000492 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 28 | |||||||||||||
39291 | 39291 | Elton Gallegly G000021 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 23 | |||||||||||||
39312 | 39312 | Walter Herger H000528 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
39393 | 39393 | Jerry Lewis L000274 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 40 | |||||||||||||
39526 | 39526 | Fortney Stark S000810 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 13 | |||||||||||||
39574 | 39574 | Lynn Woolsey W000738 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
39940 | 39940 | Howard McKeon M000508 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 25 | |||||||||||||
39954 | 39954 | Gary Miller M001139 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 41 | |||||||||||||
39974 | 39974 | George Miller M000725 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
40091 | 40091 | Henry Waxman W000215 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 29 | |||||||||||||
40207 | 40207 | Barbara Boxer B000711 | sen | CA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://boxer.senate.gov/ | ||||||||||||
40268 | 40268 | Lois Capps C001036 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 22 | |||||||||||||
40299 | 40299 | Sam Farr F000030 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
40468 | 40468 | Loretta Sanchez S000030 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 46 | |||||||||||||
40515 | 40515 | Xavier Becerra B000287 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 30 | |||||||||||||
40979 | 40979 | Dana Rohrabacher R000409 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 45 | |||||||||||||
41026 | 41026 | Edward Royce R000487 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 39 | |||||||||||||
42063 | 42063 | Ken Calvert C000059 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 43 | |||||||||||||
42366 | 42366 | Anna Eshoo E000215 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 14 | |||||||||||||
42726 | 42726 | Barbara Lee L000551 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
42742 | 42742 | Zoe Lofgren L000397 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 16 | |||||||||||||
42988 | 42988 | Grace Napolitano N000179 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 34 | |||||||||||||
43078 | 43078 | Nancy Pelosi P000197 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
43184 | 43184 | Lucille Roybal-Allard R000486 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 33 | |||||||||||||
43357 | 43357 | Brad Sherman S000344 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 24 | |||||||||||||
43465 | 43465 | Mike Thompson T000460 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
43573 | 43573 | Maxine Waters W000187 | rep | CA | 1999-01-06 | 2001-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);