legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2,177 rows where state = "CA"
This data as json, copyable, CSV (advanced)
party 7 ✖
- Democrat 1,161
- Republican 904
- Populist 3
- Progressive 3
- Prohibitionist 3
- Independent 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12469 | 12469 | Anthony Caminetti C000069 | rep | CA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12470 | 12470 | Anthony Caminetti C000069 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12475 | 12475 | Marion Cannon C000122 | rep | CA | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
12531 | 12531 | Warren English E000189 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12566 | 12566 | Thomas Geary G000113 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12567 | 12567 | Thomas Geary G000113 | rep | CA | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12568 | 12568 | Thomas Geary G000113 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12924 | 12924 | William Bowers B000692 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 6 | |||||||||||||
12925 | 12925 | William Bowers B000692 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12926 | 12926 | William Bowers B000692 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
13043 | 13043 | Grove Johnson J000134 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13243 | 13243 | Charles Barlow B000149 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13272 | 13272 | Curtis Castle C000241 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13328 | 13328 | Samuel Hilborn H000583 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
13329 | 13329 | Samuel Hilborn H000583 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
13330 | 13330 | Samuel Hilborn H000583 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13331 | 13331 | Samuel Hilborn H000583 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13384 | 13384 | James Maguire M000059 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13385 | 13385 | James Maguire M000059 | rep | CA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13386 | 13386 | James Maguire M000059 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
13640 | 13640 | Marion De Vries D000277 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13641 | 13641 | Marion De Vries D000277 | rep | CA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13816 | 13816 | Russell Waters W000188 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
13908 | 13908 | Frank Coombs C000741 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14051 | 14051 | Eugene Loud L000448 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 5 | |||||||||||||
14052 | 14052 | Eugene Loud L000448 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14053 | 14053 | Eugene Loud L000448 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
14054 | 14054 | Eugene Loud L000448 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14055 | 14055 | Eugene Loud L000448 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14056 | 14056 | Eugene Loud L000448 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14218 | 14218 | Samuel Woods W000726 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14219 | 14219 | Samuel Woods W000726 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14281 | 14281 | Milton Daniels D000042 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14286 | 14286 | Edward De Nivernais D000230 | rep | CA | 1903-11-09 | 1905-03-03 | Democratic and Union Labor | -1 | |||||||||||||
14383 | 14383 | Edward Livernash L000365 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14413 | 14413 | Victor Metcalf M000672 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
14414 | 14414 | Victor Metcalf M000672 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14415 | 14415 | Victor Metcalf M000672 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14539 | 14539 | William Wynn W000785 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14673 | 14673 | James Gillett G000202 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14674 | 14674 | James Gillett G000202 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15447 | 15447 | William Englebright E000183 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15448 | 15448 | William Englebright E000183 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15449 | 15449 | William Englebright E000183 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15638 | 15638 | Duncan McKinlay M000518 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
15639 | 15639 | Duncan McKinlay M000518 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15640 | 15640 | Duncan McKinlay M000518 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15641 | 15641 | James McLachlan M000532 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
15642 | 15642 | James McLachlan M000532 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
15643 | 15643 | James McLachlan M000532 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
15644 | 15644 | James McLachlan M000532 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
15645 | 15645 | James McLachlan M000532 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15646 | 15646 | James McLachlan M000532 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
15696 | 15696 | George Perkins P000232 | sen | CA | 1893-08-07 | 1897-03-03 | 3 | Republican | |||||||||||||
15697 | 15697 | George Perkins P000232 | sen | CA | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
15698 | 15698 | George Perkins P000232 | sen | CA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15699 | 15699 | George Perkins P000232 | sen | CA | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
16121 | 16121 | James Needham N000021 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
16122 | 16122 | James Needham N000021 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
16123 | 16123 | James Needham N000021 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
16124 | 16124 | James Needham N000021 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
16125 | 16125 | James Needham N000021 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
16126 | 16126 | James Needham N000021 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
16127 | 16127 | James Needham N000021 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16182 | 16182 | Sylvester Smith S000614 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
16183 | 16183 | Sylvester Smith S000614 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
16184 | 16184 | Sylvester Smith S000614 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
16185 | 16185 | Sylvester Smith S000614 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 8 | |||||||||||||
16239 | 16239 | John Works W000743 | sen | CA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16290 | 16290 | Charles Bell B000334 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
16425 | 16425 | Joseph Knowland K000291 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
16426 | 16426 | Joseph Knowland K000291 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
16427 | 16427 | Joseph Knowland K000291 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
16428 | 16428 | Joseph Knowland K000291 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
16429 | 16429 | Joseph Knowland K000291 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
16430 | 16430 | Joseph Knowland K000291 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
16689 | 16689 | Henry Benedict B000359 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
16835 | 16835 | William Kent K000127 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16836 | 16836 | William Kent K000127 | rep | CA | 1913-04-07 | 1915-03-03 | Independent | 1 | |||||||||||||
16837 | 16837 | William Kent K000127 | rep | CA | 1915-12-06 | 1917-03-03 | Independent | 1 | |||||||||||||
16930 | 16930 | James Phelan P000290 | sen | CA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17009 | 17009 | William Stephens S000861 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
17010 | 17010 | William Stephens S000861 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17011 | 17011 | William Stephens S000861 | rep | CA | 1915-12-06 | 1917-03-03 | Progressive | 10 | |||||||||||||
17252 | 17252 | Everis Hayes H000389 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
17253 | 17253 | Everis Hayes H000389 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
17254 | 17254 | Everis Hayes H000389 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
17255 | 17255 | Everis Hayes H000389 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
17256 | 17256 | Everis Hayes H000389 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
17257 | 17257 | Everis Hayes H000389 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17258 | 17258 | Everis Hayes H000389 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17774 | 17774 | Hugh Hersman H000546 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17800 | 17800 | William Kettner K000155 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 11 |
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);