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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5979 | 5979 | Edward Gilbert G000172 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6357 | 6357 | Edward Marshall M000151 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6359 | 6359 | Joseph McCorkle M000362 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6482 | 6482 | John Weller W000274 | sen | CA | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6802 | 6802 | James Denver D000261 | rep | CA | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
6837 | 6837 | Philemon Herbert H000526 | rep | CA | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
6994 | 6994 | David Broderick B000857 | sen | CA | 1857-12-07 | 1859-12-31 | 1 | Democrat | |||||||||||||
7074 | 7074 | William Gwin G000540 | sen | CA | 1850-09-10 | 1855-03-03 | 3 | Democrat | |||||||||||||
7075 | 7075 | William Gwin G000540 | sen | CA | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7156 | 7156 | Joseph McKibbin M000514 | rep | CA | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7328 | 7328 | John Burch B001068 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7438 | 7438 | Henry Haun H000353 | sen | CA | 1859-12-05 | 1861-03-03 | 1 | Democrat | |||||||||||||
7562 | 7562 | Charles Scott S000167 | rep | CA | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7563 | 7563 | Charles Scott S000167 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7645 | 7645 | Milton Latham L000110 | rep | CA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7646 | 7646 | Milton Latham L000110 | sen | CA | 1860-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
7795 | 7795 | James McDougall M000416 | rep | CA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7796 | 7796 | James McDougall M000416 | sen | CA | 1861-07-04 | 1867-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
8542 | 8542 | Eugene Casserly C000236 | sen | CA | 1869-03-04 | 1873-12-31 | 1 | Democrat | |||||||||||||
8602 | 8602 | Abijah Gilbert G000171 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
8641 | 8641 | James Johnson J000145 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8642 | 8642 | James Johnson J000145 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9608 | 9608 | William Piper P000364 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9878 | 9878 | John Luttrell L000522 | rep | CA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9879 | 9879 | John Luttrell L000522 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9880 | 9880 | John Luttrell L000522 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9977 | 9977 | Peter Wigginton W000449 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9978 | 9978 | Peter Wigginton W000449 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10072 | 10072 | James Farley F000020 | sen | CA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10268 | 10268 | Campbell Berry B000415 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10661 | 10661 | James Budd B001034 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10729 | 10729 | John Glascock G000229 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10868 | 10868 | William Rosecrans R000440 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10869 | 10869 | William Rosecrans R000440 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10905 | 10905 | Charles Sumner S001069 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10911 | 10911 | Pleasant Tully T000407 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11076 | 11076 | Barclay Henley H000498 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11077 | 11077 | Barclay Henley H000498 | rep | CA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11390 | 11390 | George Hearst H000428 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
11391 | 11391 | George Hearst H000428 | sen | CA | 1887-12-05 | 1891-12-31 | 1 | Democrat | |||||||||||||
11528 | 11528 | Thomas Thompson T000219 | rep | CA | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11607 | 11607 | Marion Biggs B000458 | rep | CA | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
11608 | 11608 | Marion Biggs B000458 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11673 | 11673 | Thomas Clunie C000536 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14383 | 14383 | Edward Livernash L000365 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14539 | 14539 | William Wynn W000785 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
16930 | 16930 | James Phelan P000290 | sen | CA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
17801 | 17801 | William Kettner K000155 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
17802 | 17802 | William Kettner K000155 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17803 | 17803 | William Kettner K000155 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
19063 | 19063 | John Raker R000019 | rep | CA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
19064 | 19064 | John Raker R000019 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19065 | 19065 | John Raker R000019 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19066 | 19066 | John Raker R000019 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19067 | 19067 | John Raker R000019 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19068 | 19068 | John Raker R000019 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19069 | 19069 | John Raker R000019 | rep | CA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19070 | 19070 | John Raker R000019 | rep | CA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21178 | 21178 | John Burke B001094 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
21195 | 21195 | Denver Church C000387 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
21196 | 21196 | Denver Church C000387 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
21197 | 21197 | Denver Church C000387 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
21198 | 21198 | Denver Church C000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21397 | 21397 | William McAdoo M000293 | sen | CA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
21812 | 21812 | John Hoeppel H000677 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
21813 | 21813 | John Hoeppel H000677 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
22092 | 22092 | Charles Colden C000605 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22094 | 22094 | Charles Colden C000605 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22111 | 22111 | John Dockweiler D000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22113 | 22113 | John Dockweiler D000387 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
22296 | 22296 | John McGrath M000457 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22297 | 22297 | John McGrath M000457 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22298 | 22298 | John McGrath M000457 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22299 | 22299 | John McGroarty M000462 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22300 | 22300 | John McGroarty M000462 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22430 | 22430 | Henry Stubbs S001038 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 10 |
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);