congress_members

All current and historical members of Congress (12,700+) from the congress-legislators project. Includes bioguide_id (universal key), party, state, chamber, and cross-reference IDs for OpenSecrets, FEC, GovTrack, and more.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

21 rows where chamber = "Senate", party = "Republican" and state = "CA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, first_served, last_served, thomas_id, ballotpedia_id, terms_count, served_until, bills_sponsored, first_served (date), last_served (date), birthday (date), served_until (date)

state 1

party 1

  • Republican · 21 ✖

is_current 1

  • 0 21

chamber 1

  • Senate · 21 ✖
bioguide_id first_name last_name full_name ▼ nickname party state chamber district first_served last_served is_current opensecrets_id fec_ids govtrack_id thomas_id votesmart_id lis_id wikipedia_id ballotpedia_id birthday gender terms_count served_until trade_count speech_count bills_sponsored vote_count fec_total_received
S000065 Aaron Sargent Aaron Sargent   Republican CA Senate   1861-07-04 1879-03-03 0   [] 409577       Aaron A. Sargent   1827-09-28 M 4 1879-03-03 0 0 0 0 0
W000486 Abram Williams Abram Williams   Republican CA Senate   1886-01-01 1887-03-03 0   [] 411643       Abram Williams   1832-02-03 M 1 1887-03-03 0 0 0 0 0
F000068 Charles Felton Charles Felton   Republican CA Senate   1885-12-07 1893-03-03 0   [] 404026       Charles N. Felton   1832-01-01 M 2 1893-03-03 0 0 0 0 0
C000607 Cornelius Cole Cornelius Cole   Republican CA Senate   1863-12-07 1873-03-03 0   [] 402736       Cornelius Cole   1822-09-17 M 2 1873-03-03 0 0 0 0 0
F000207 Frank Flint Frank Flint   Republican CA Senate   1905-12-04 1911-03-03 0   [] 404162       Frank Flint   1862-07-15 M 2 1911-03-03 0 0 0 0 0
M001092 George Murphy George Murphy   Republican CA Senate   1965-01-04 1971-01-03 0   [] 408056       George Murphy   1902-07-04 M 2 1971-01-03 0 0 0 0 0
P000232 George Perkins George Perkins   Republican CA Senate   1893-08-07 1915-03-03 0   [] 408635       George C. Perkins   1839-08-23 M 4 1915-03-03 0 0 0 0 0
J000140 Hiram Johnson Hiram Johnson   Republican CA Senate   1917-04-02 1945-12-31 0   [] 406039       Hiram Johnson   1866-09-02 M 5 1945-12-31 0 0 0 0 0
C000695 John Conness John Conness   Republican CA Senate   1863-12-07 1869-03-03 0   [] 402820       John Conness   1821-09-22 M 2 1869-03-03 0 0 0 0 0
M000740 John Miller John Miller   Republican CA Senate   1881-12-05 1887-03-03 0   [] 407717       John Franklin Miller (California politician)   1831-11-21 M 2 1887-03-03 0 0 0 0 0
S000269 John Seymour John Seymour   Republican CA Senate   1991-01-07 1993-01-03 0   [] 409770 01434   S218 John Seymour (California politician)   1937-12-03 M 1 1993-01-03 0 0 44 0 0
W000743 John Works John Works   Republican CA Senate   1911-04-04 1917-03-03 0   [] 411892       John D. Works   1847-03-29 M 2 1917-03-03 0 0 0 0 0
S000793 Leland Stanford Leland Stanford   Republican CA Senate   1885-12-07 1893-12-31 0   [] 410259       Leland Stanford   1824-03-09 M 2 1893-12-31 0 0 0 0 0
B000630 Newton Booth Newton Booth   Republican CA Senate   1875-12-06 1881-03-03 0   [] 401595       Newton Booth   1825-12-30 M 2 1881-03-03 0 0 0 0 0
W000607 Pete Wilson Pete Wilson   Republican CA Senate   1983-01-03 1991-12-31 0   [] 411762 01456   S165 Pete Wilson   1933-08-23 M 2 1991-12-31 0 0 144 0 0
N000116 Richard Nixon Richard Nixon   Republican CA Senate   1947-01-03 1953-12-31 0   [] 408200       Richard Nixon Richard Nixon 1913-01-09 M 2 1953-12-31 0 0 0 0 0
H000384 Samuel Hayakawa Samuel Hayakawa   Republican CA Senate   1977-01-04 1983-01-03 0   [] 405252 01356     S. I. Hayakawa   1906-07-18 M 2 1983-01-03 0 0 115 0 0
S000380 Samuel Shortridge Samuel Shortridge   Republican CA Senate   1921-04-11 1933-03-03 0   [] 409874       Samuel M. Shortridge   1861-08-03 M 3 1933-03-03 0 0 0 0 0
B000138 Thomas Bard Thomas Bard   Republican CA Senate   1900-02-07 1905-03-03 0   [] 401139       Thomas R. Bard   1841-12-08 M 1 1905-03-03 0 0 0 0 0
K000335 Thomas Kuchel Thomas Kuchel   Republican CA Senate   1953-01-03 1969-01-03 0   [] 406489       Thomas Kuchel   1910-08-15 M 3 1969-01-03 0 0 0 0 0
K000292 William Knowland William Knowland   Republican CA Senate   1945-08-14 1959-01-03 0   [] 406448       William Knowland   1908-06-26 M 3 1959-01-03 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE congress_members (
    bioguide_id TEXT PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    full_name TEXT,
    nickname TEXT,
    party TEXT,
    state TEXT,
    chamber TEXT,
    district INTEGER,
    first_served TEXT,
    last_served TEXT,
    is_current INTEGER,
    opensecrets_id TEXT,
    fec_ids TEXT,
    govtrack_id INTEGER,
    thomas_id TEXT,
    votesmart_id INTEGER,
    lis_id TEXT,
    wikipedia_id TEXT,
    ballotpedia_id TEXT,
    birthday TEXT,
    gender TEXT,
    terms_count INTEGER,
    served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);