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 2009-01-06 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38787 | 38787 | George Radanovich R000004 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 19 | http://radanovich.house.gov | ||||||||||||
38836 | 38836 | Hilda Solis S001153 | rep | CA | 2009-01-06 | 2009-02-24 | Democrat | 32 | http://solis.house.gov | ||||||||||||
38887 | 38887 | Ellen Tauscher T000057 | rep | CA | 2009-01-06 | 2009-06-26 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38920 | 38920 | Diane Watson W000794 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38940 | 38940 | Dennis Cardoza C001050 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38956 | 38956 | Jane Harman H000213 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
39016 | 39016 | Bob Filner F000116 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39116 | 39116 | Joe Baca B001234 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39156 | 39156 | Howard Berman B000410 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39170 | 39170 | Brian Bilbray B000461 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39178 | 39178 | Mary Bono Mack B001228 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 45 | http://bono.house.gov | ||||||||||||
39267 | 39267 | David Dreier D000492 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 26 | http://dreier.house.gov | ||||||||||||
39296 | 39296 | Elton Gallegly G000021 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 24 | http://www.house.gov/gallegly | ||||||||||||
39317 | 39317 | Walter Herger H000528 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 2 | http://www.house.gov/herger | ||||||||||||
39398 | 39398 | Jerry Lewis L000274 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | ||||||||||||
39407 | 39407 | Daniel Lungren L000517 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 3 | http://www.lungren.house.gov | ||||||||||||
39488 | 39488 | Laura Richardson R000581 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 37 | http://richardson.house.gov/ | ||||||||||||
39531 | 39531 | Fortney Stark S000810 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39579 | 39579 | Lynn Woolsey W000738 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://woolsey.house.gov | ||||||||||||
39782 | 39782 | John Campbell C001064 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39945 | 39945 | Howard McKeon M000508 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 25 | http://mckeon.house.gov | ||||||||||||
39959 | 39959 | Gary Miller M001139 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 42 | http://www.house.gov/garymiller | ||||||||||||
39979 | 39979 | George Miller M000725 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | ||||||||||||
40096 | 40096 | Henry Waxman W000215 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 30 | http://www.henrywaxman.house.gov | ||||||||||||
40273 | 40273 | Lois Capps C001036 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 23 | http://www.house.gov/capps | ||||||||||||
40304 | 40304 | Sam Farr F000030 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 17 | http://www.house.gov/farr | ||||||||||||
40357 | 40357 | Michael Honda H001034 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 15 | http://www.house.gov/honda | ||||||||||||
40473 | 40473 | Loretta Sanchez S000030 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | ||||||||||||
40520 | 40520 | Xavier Becerra B000287 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
40984 | 40984 | Dana Rohrabacher R000409 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | ||||||||||||
41031 | 41031 | Edward Royce R000487 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 40 | http://www.royce.house.gov | ||||||||||||
41216 | 41216 | Duncan Hunter H001048 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 52 | http://hunter.house.gov | ||||||||||||
41321 | 41321 | Susan Davis D000598 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41655 | 41655 | Devin Nunes N000181 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 21 | http://nunes.house.gov | ||||||||||||
42068 | 42068 | Ken Calvert C000059 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 44 | http://calvert.house.gov | ||||||||||||
42216 | 42216 | Jim Costa C001059 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 20 | http://www.house.gov/costa | ||||||||||||
42371 | 42371 | Anna Eshoo E000215 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 14 | http://eshoo.house.gov | ||||||||||||
42731 | 42731 | Barbara Lee L000551 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://lee.house.gov | ||||||||||||
42747 | 42747 | Zoe Lofgren L000397 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 16 | http://www.house.gov/lofgren | ||||||||||||
42840 | 42840 | Doris Matsui M001163 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/matsui | ||||||||||||
42848 | 42848 | Kevin McCarthy M001165 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | ||||||||||||
42864 | 42864 | Tom McClintock M001177 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://mcclintock.house.gov | ||||||||||||
42920 | 42920 | Jerry McNerney M001166 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 11 | http://mcnerney.house.gov | ||||||||||||
42993 | 42993 | Grace Napolitano N000179 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 38 | http://napolitano.house.gov | ||||||||||||
43083 | 43083 | Nancy Pelosi P000197 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/pelosi | ||||||||||||
43189 | 43189 | Lucille Roybal-Allard R000486 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | ||||||||||||
43272 | 43272 | Adam Schiff S001150 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 29 | http://schiff.house.gov | ||||||||||||
43362 | 43362 | Brad Sherman S000344 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 27 | http://bradsherman.house.gov | ||||||||||||
43433 | 43433 | Jackie Speier S001175 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://speier.house.gov/ | ||||||||||||
43443 | 43443 | Linda Sánchez S001156 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | ||||||||||||
43470 | 43470 | Mike Thompson T000460 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://mikethompson.house.gov | ||||||||||||
43578 | 43578 | Maxine Waters W000187 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 35 | http://www.house.gov/waters | ||||||||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa |
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);