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 end
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 | |||||||||||||
6178 | 6178 | George Wright W000760 | rep | CA | 1849-12-03 | 1851-03-03 | Independent | -1 | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
8602 | 8602 | Abijah Gilbert G000171 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
7074 | 7074 | William Gwin G000540 | sen | CA | 1850-09-10 | 1855-03-03 | 3 | Democrat | |||||||||||||
7645 | 7645 | Milton Latham L000110 | rep | CA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7795 | 7795 | James McDougall M000416 | rep | CA | 1853-12-05 | 1855-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 | |||||||||||||
7156 | 7156 | Joseph McKibbin M000514 | rep | CA | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7562 | 7562 | Charles Scott S000167 | rep | CA | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
6994 | 6994 | David Broderick B000857 | sen | CA | 1857-12-07 | 1859-12-31 | 1 | Democrat | |||||||||||||
7075 | 7075 | William Gwin G000540 | sen | CA | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
7563 | 7563 | Charles Scott S000167 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7646 | 7646 | Milton Latham L000110 | sen | CA | 1860-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
7786 | 7786 | Frederick Low L000469 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
7836 | 7836 | Timothy Phelps P000300 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
9337 | 9337 | Aaron Sargent S000065 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
8034 | 8034 | Thomas Shannon S000290 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8288 | 8288 | Cornelius Cole C000607 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8350 | 8350 | William Higby H000576 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
7796 | 7796 | James McDougall M000416 | sen | CA | 1861-07-04 | 1867-03-03 | 3 | Democrat | |||||||||||||
8086 | 8086 | John Bidwell B000447 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8176 | 8176 | Donald McRuer M000600 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8351 | 8351 | William Higby H000576 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
7931 | 7931 | John Conness C000695 | sen | CA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8352 | 8352 | William Higby H000576 | rep | CA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8641 | 8641 | James Johnson J000145 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8510 | 8510 | Samuel Axtell A000349 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8642 | 8642 | James Johnson J000145 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
9338 | 9338 | Aaron Sargent S000065 | rep | CA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8289 | 8289 | Cornelius Cole C000607 | sen | CA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8859 | 8859 | John Coghlan C000594 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9209 | 9209 | Sherman Houghton H000815 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9339 | 9339 | Aaron Sargent S000065 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8542 | 8542 | Eugene Casserly C000236 | sen | CA | 1869-03-04 | 1873-12-31 | 1 | Democrat | |||||||||||||
9121 | 9121 | Charles Clayton C000493 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9210 | 9210 | Sherman Houghton H000815 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9878 | 9878 | John Luttrell L000522 | rep | CA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10495 | 10495 | Horace Page P000017 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9608 | 9608 | William Piper P000364 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9879 | 9879 | John Luttrell L000522 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9977 | 9977 | Peter Wigginton W000449 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
10496 | 10496 | Horace Page P000017 | rep | CA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9340 | 9340 | Aaron Sargent S000065 | sen | CA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9880 | 9880 | John Luttrell L000522 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9978 | 9978 | Peter Wigginton W000449 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10057 | 10057 | Horace Davis D000105 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10492 | 10492 | Romualdo Pacheco P000003 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
10497 | 10497 | Horace Page P000017 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10493 | 10493 | Romualdo Pacheco P000003 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10498 | 10498 | Horace Page P000017 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10268 | 10268 | Campbell Berry B000415 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10494 | 10494 | Romualdo Pacheco P000003 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
10499 | 10499 | Horace Page P000017 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10868 | 10868 | William Rosecrans R000440 | rep | CA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10072 | 10072 | James Farley F000020 | sen | CA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11077 | 11077 | Barclay Henley H000498 | rep | CA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11119 | 11119 | James Louttit L000453 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11124 | 11124 | Henry Markham M000134 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11282 | 11282 | Abram Williams W000486 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Republican | |||||||||||||
11390 | 11390 | George Hearst H000428 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
11871 | 11871 | William Morrow M001006 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
12154 | 12154 | Charles Felton F000068 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
12238 | 12238 | Joseph McKenna M000500 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
11872 | 11872 | William Morrow M001006 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
12001 | 12001 | William Vandever V000031 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
12155 | 12155 | Charles Felton F000068 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 5 | |||||||||||||
12239 | 12239 | Joseph McKenna M000500 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
11725 | 11725 | John De Haven D000200 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11873 | 11873 | William Morrow M001006 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12002 | 12002 | William Vandever V000031 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
12240 | 12240 | Joseph McKenna M000500 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
12302 | 12302 | Leland Stanford S000793 | sen | CA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
12566 | 12566 | Thomas Geary G000113 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11391 | 11391 | George Hearst H000428 | sen | CA | 1887-12-05 | 1891-12-31 | 1 | Democrat | |||||||||||||
12146 | 12146 | John Cutting C001030 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 4 | |||||||||||||
12156 | 12156 | Charles Felton F000068 | sen | CA | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
12241 | 12241 | Joseph McKenna M000500 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 |
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);