legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
954 rows where party = "Republican" and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, rss_url, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
7931 | 7931 | John Conness C000695 | sen | CA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8034 | 8034 | Thomas Shannon S000290 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
8288 | 8288 | Cornelius Cole C000607 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8289 | 8289 | Cornelius Cole C000607 | sen | CA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8350 | 8350 | William Higby H000576 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8351 | 8351 | William Higby H000576 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8352 | 8352 | William Higby H000576 | rep | CA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8859 | 8859 | John Coghlan C000594 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9121 | 9121 | Charles Clayton C000493 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9209 | 9209 | Sherman Houghton H000815 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9210 | 9210 | Sherman Houghton H000815 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9337 | 9337 | Aaron Sargent S000065 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
9338 | 9338 | Aaron Sargent S000065 | rep | CA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9339 | 9339 | Aaron Sargent S000065 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9340 | 9340 | Aaron Sargent S000065 | sen | CA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10057 | 10057 | Horace Davis D000105 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10492 | 10492 | Romualdo Pacheco P000003 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
10493 | 10493 | Romualdo Pacheco P000003 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10494 | 10494 | Romualdo Pacheco P000003 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
10495 | 10495 | Horace Page P000017 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
10496 | 10496 | Horace Page P000017 | rep | CA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
10497 | 10497 | Horace Page P000017 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10498 | 10498 | Horace Page P000017 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10499 | 10499 | Horace Page P000017 | rep | CA | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
11725 | 11725 | John De Haven D000200 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11871 | 11871 | William Morrow M001006 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11872 | 11872 | William Morrow M001006 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
11873 | 11873 | William Morrow M001006 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12001 | 12001 | William Vandever V000031 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
12002 | 12002 | William Vandever V000031 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
12146 | 12146 | John Cutting C001030 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 4 | |||||||||||||
12154 | 12154 | Charles Felton F000068 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
12155 | 12155 | Charles Felton F000068 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 5 | |||||||||||||
12156 | 12156 | Charles Felton F000068 | sen | CA | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
12238 | 12238 | Joseph McKenna M000500 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
12239 | 12239 | Joseph McKenna M000500 | rep | CA | 1887-12-05 | 1889-03-03 | Republican | 3 | |||||||||||||
12240 | 12240 | Joseph McKenna M000500 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
12241 | 12241 | Joseph McKenna M000500 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
12302 | 12302 | Leland Stanford S000793 | sen | CA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
12303 | 12303 | Leland Stanford S000793 | sen | CA | 1891-12-07 | 1893-12-31 | 3 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
14281 | 14281 | Milton Daniels D000042 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
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 |
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);