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

19 rows where chamber = "Senate", party = "Republican" and state = "CT" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

party 1

  • Republican · 19 ✖

is_current 1

  • 0 19

chamber 1

  • Senate · 19 ✖
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
B000577 Elijah Boardman Elijah Boardman   Republican CT Senate   1821-12-03 1823-12-31 0   [] 401548       Elijah Boardman   1760-03-07 M 1 1823-12-31 0 0 0 0 0
B000769 Frank Brandegee Frank Brandegee   Republican CT Senate   1902-11-04 1924-10-14 0   [] 401728       Frank B. Brandegee   1864-07-08 M 4 1924-10-14 0 0 0 0 0
W000032 Frederic Walcott Frederic Walcott   Republican CT Senate   1929-04-15 1935-01-03 0   [] 411211       Frederic C. Walcott   1869-02-19 M 2 1935-01-03 0 0 0 0 0
M000547 George McLean George McLean   Republican CT Senate   1911-04-04 1929-03-03 0   [] 407539       George P. McLean   1857-10-07 M 4 1929-03-03 0 0 0 0 0
B000470 Hiram Bingham Hiram Bingham   Republican CT Senate   1925-01-08 1933-03-03 0   [] 401451       Hiram Bingham III   1875-11-19 M 2 1933-03-03 0 0 0 0 0
D000369 James Dixon James Dixon   Republican CT Senate   1845-12-01 1869-03-03 0   [] 403486       James Dixon   1814-08-05 M 5 1869-03-03 0 0 0 0 0
L000083 James Lanman James Lanman   Republican CT Senate   1819-12-06 1825-03-03 0   [] 406592       James Lanman   1767-06-14 M 2 1825-03-03 0 0 0 0 0
D000025 John Danaher John Danaher   Republican CT Senate   1939-01-03 1945-01-03 0   [] 403166       John A. Danaher   1899-01-09 M 2 1945-01-03 0 0 0 0 0
H000377 Joseph Hawley Joseph Hawley   Republican CT Senate   1871-03-04 1905-03-03 0   [] 405245       Joseph R. Hawley   1826-10-31 M 6 1905-03-03 0 0 0 0 0
F000308 Lafayette Foster Lafayette Foster   Republican CT Senate   1855-12-03 1867-03-03 0   [] 404257       Lafayette S. Foster   1806-11-22 M 3 1867-03-03 0 0 0 0 0
W000253 Lowell Weicker Lowell Weicker   Republican CT Senate   1969-01-03 1989-01-03 0   [] 411421 01453     Lowell Weicker   1931-05-16 M 4 1989-01-03 0 0 221 0 0
B001044 Morgan Bulkeley Morgan Bulkeley   Republican CT Senate   1905-12-04 1911-03-03 0   [] 401994       Morgan Bulkeley   1837-12-26 M 2 1911-03-03 0 0 0 0 0
F000094 Orris Ferry Orris Ferry   Republican CT Senate   1859-12-05 1875-12-31 0   [] 404051       Orris S. Ferry   1823-08-15 M 3 1875-12-31 0 0 0 0 0
P000382 Orville Platt Orville Platt   Republican CT Senate   1879-03-18 1905-04-21 0   [] 408776       Orville H. Platt   1827-07-19 M 5 1905-04-21 0 0 0 0 0
B001167 Prescott Bush Prescott Bush   Republican CT Senate   1952-01-01 1963-01-03 0   [] 402109       Prescott Bush   1895-05-15 M 2 1963-01-03 0 0 0 0 0
B000095 Raymond Baldwin Raymond Baldwin   Republican CT Senate   1946-12-27 1949-12-16 0   [] 401097       Raymond E. Baldwin   1893-08-31 M 1 1949-12-16 0 0 0 0 0
H000293 Thomas Hart Thomas Hart   Republican CT Senate   1945-02-15 1947-01-03 0   [] 405166       Thomas C. Hart   1877-06-12 M 1 1947-01-03 0 0 0 0 0
B001021 William Buckingham William Buckingham   Republican CT Senate   1869-03-04 1875-03-03 0   [] 401971       William A. Buckingham   1804-05-28 M 2 1875-03-03 0 0 0 0 0
P000575 William Purtell William Purtell   Republican CT Senate   1952-08-29 1959-01-03 0   [] 408958       William A. Purtell   1897-05-06 M 2 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);