legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2,177 rows where state = "CA" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, state_rank, start (date), end (date)
party 7 ✖
- Democrat 1,210
- Republican 954
- Independent 3
- Populist 3
- Progressive 3
- Prohibitionist 3
- Democratic and Union Labor 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26156 | 26156 | John Allen A000133 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26158 | 26158 | John Allen A000133 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26159 | 26159 | John Allen A000133 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26160 | 26160 | John Allen A000133 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
34174 | 34174 | Glenn Anderson A000189 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
34175 | 34175 | Glenn Anderson A000189 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
34176 | 34176 | Glenn Anderson A000189 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 35 | |||||||||||||
34177 | 34177 | Glenn Anderson A000189 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
34178 | 34178 | Glenn Anderson A000189 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
34179 | 34179 | Glenn Anderson A000189 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 32 | |||||||||||||
34180 | 34180 | Glenn Anderson A000189 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 32 | |||||||||||||
34181 | 34181 | Glenn Anderson A000189 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 32 | |||||||||||||
34182 | 34182 | Glenn Anderson A000189 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 32 | |||||||||||||
34183 | 34183 | Glenn Anderson A000189 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 32 | |||||||||||||
34184 | 34184 | Glenn Anderson A000189 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 32 | |||||||||||||
34185 | 34185 | Glenn Anderson A000189 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 32 | |||||||||||||
25120 | 25120 | John Anderson A000196 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25121 | 25121 | John Anderson A000196 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25122 | 25122 | John Anderson A000196 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25123 | 25123 | John Anderson A000196 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25124 | 25124 | John Anderson A000196 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25125 | 25125 | John Anderson A000196 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25126 | 25126 | John Anderson A000196 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8510 | 8510 | Samuel Axtell A000349 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
43956 | 43956 | Pete Aguilar A000371 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43957 | 43957 | Pete Aguilar A000371 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth House Office Building; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43958 | 43958 | Pete Aguilar A000371 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
43959 | 43959 | Pete Aguilar A000371 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
33478 | 33478 | Robert Badham B000024 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 40 | |||||||||||||
33479 | 33479 | Robert Badham B000024 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 40 | |||||||||||||
33480 | 33480 | Robert Badham B000024 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 40 | |||||||||||||
33481 | 33481 | Robert Badham B000024 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 40 | |||||||||||||
33482 | 33482 | Robert Badham B000024 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 40 | |||||||||||||
33483 | 33483 | Robert Badham B000024 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 40 | |||||||||||||
35681 | 35681 | William Baker B000078 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
35682 | 35682 | William Baker B000078 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
28310 | 28310 | John Baldwin B000092 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
28311 | 28311 | John Baldwin B000092 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28312 | 28312 | John Baldwin B000092 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
28313 | 28313 | John Baldwin B000092 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28314 | 28314 | John Baldwin B000092 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
28315 | 28315 | John Baldwin B000092 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
20113 | 20113 | Henry Barbour B000126 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20114 | 20114 | Henry Barbour B000126 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20115 | 20115 | Henry Barbour B000126 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20116 | 20116 | Henry Barbour B000126 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
20117 | 20117 | Henry Barbour B000126 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
20118 | 20118 | Henry Barbour B000126 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20119 | 20119 | Henry Barbour B000126 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
13566 | 13566 | John Barham B000140 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13567 | 13567 | John Barham B000140 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13568 | 13568 | John Barham B000140 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13243 | 13243 | Charles Barlow B000149 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
33810 | 33810 | Jim Bates B000236 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 44 | |||||||||||||
33811 | 33811 | Jim Bates B000236 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 44 | |||||||||||||
33812 | 33812 | Jim Bates B000236 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 44 | |||||||||||||
33813 | 33813 | Jim Bates B000236 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 44 | |||||||||||||
40512 | 40512 | Xavier Becerra B000287 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 30 | |||||||||||||
40513 | 40513 | Xavier Becerra B000287 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
40514 | 40514 | Xavier Becerra B000287 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
40515 | 40515 | Xavier Becerra B000287 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 30 | |||||||||||||
40516 | 40516 | Xavier Becerra B000287 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
40517 | 40517 | Xavier Becerra B000287 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
40518 | 40518 | Xavier Becerra B000287 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 31 | http://www.house.gov/becerra | ||||||||||||
40519 | 40519 | Xavier Becerra B000287 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
40520 | 40520 | Xavier Becerra B000287 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 31 | http://becerra.house.gov | ||||||||||||
40521 | 40521 | Xavier Becerra B000287 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 31 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0531 | 202-225-6235 | 202-225-2202 | http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm | 1226 Longworth House Office Building | |||||||
40522 | 40522 | Xavier Becerra B000287 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
40523 | 40523 | Xavier Becerra B000287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
40524 | 40524 | Xavier Becerra B000287 | rep | CA | 2017-01-03 | 2017-01-24 | Democrat | 34 | https://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||||
35683 | 35683 | Anthony Beilenson B000318 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
35684 | 35684 | Anthony Beilenson B000318 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
35685 | 35685 | Anthony Beilenson B000318 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
35686 | 35686 | Anthony Beilenson B000318 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
35687 | 35687 | Anthony Beilenson B000318 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 23 | |||||||||||||
35688 | 35688 | Anthony Beilenson B000318 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 23 | |||||||||||||
35689 | 35689 | Anthony Beilenson B000318 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 23 | |||||||||||||
35690 | 35690 | Anthony Beilenson B000318 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 23 | |||||||||||||
35691 | 35691 | Anthony Beilenson B000318 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 24 | |||||||||||||
35692 | 35692 | Anthony Beilenson B000318 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 24 | |||||||||||||
30838 | 30838 | Alphonzo Bell B000330 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
30839 | 30839 | Alphonzo Bell B000330 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
30840 | 30840 | Alphonzo Bell B000330 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 28 | |||||||||||||
30841 | 30841 | Alphonzo Bell B000330 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 28 | |||||||||||||
30842 | 30842 | Alphonzo Bell B000330 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 28 | |||||||||||||
30843 | 30843 | Alphonzo Bell B000330 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 28 | |||||||||||||
30844 | 30844 | Alphonzo Bell B000330 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 28 | |||||||||||||
30845 | 30845 | Alphonzo Bell B000330 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 27 | |||||||||||||
16290 | 16290 | Charles Bell B000334 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
16689 | 16689 | Henry Benedict B000359 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
39143 | 39143 | Howard Berman B000410 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 26 | |||||||||||||
39144 | 39144 | Howard Berman B000410 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 26 | |||||||||||||
39145 | 39145 | Howard Berman B000410 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 26 | |||||||||||||
39146 | 39146 | Howard Berman B000410 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 26 | |||||||||||||
39147 | 39147 | Howard Berman B000410 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 26 |
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);