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 = "House", party = "Democrat" and state = "DE" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, opensecrets_id, fec_ids, thomas_id, ballotpedia_id, gender, terms_count, speech_count, bills_sponsored, vote_count, fec_total_received, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)

is_current 2

  • 0 20
  • 1 1

state 1

party 1

  • Democrat · 21 ✖

chamber 1

  • House · 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
P000407 Albert Polk Albert Polk   Democrat DE House 0 1917-04-02 1919-03-03 0   [] 408800       Albert F. Polk   1869-10-11 M 2 1919-03-03 0 0 0 0 0
B000457 Benjamin Biggs Benjamin Biggs   Democrat DE House 0 1869-03-04 1873-03-03 0   [] 401442       Benjamin T. Biggs   1821-10-01 M 3 1873-03-03 0 0 0 0 0
L000443 Charles Lore Charles Lore   Democrat DE House 0 1883-12-03 1887-03-03 0   [] 406934       Charles B. Lore   1831-03-16 M 3 1887-03-03 0 0 0 0 0
M000178 Edward Martin Edward Martin   Democrat DE House 0 1879-03-18 1883-03-03 0   [] 407200       Edward L. Martin   1837-03-29 M 3 1883-03-03 0 0 0 0 0
B000853 Franklin Brockson Franklin Brockson   Democrat DE House 0 1913-04-07 1915-03-03 0   [] 401810       Franklin Brockson   1865-08-06 M 2 1915-03-03 0 0 0 0 0
M000418 Harris McDowell Harris McDowell   Democrat DE House 0 1955-01-05 1967-01-03 0   [] 407418       Harris McDowell   1906-02-10 M 7 1967-01-03 0 0 0 0 0
H000823 Henry Houston Henry Houston   Democrat DE House 0 1903-11-09 1905-03-03 0   [] 405670       Henry A. Houston   1847-07-10 M 2 1905-03-03 0 0 0 0 0
W000506 James Williams James Williams   Democrat DE House 0 1875-12-06 1879-03-03 0   [] 411663       James Williams (Delaware politician)   1825-08-04 M 3 1879-03-03 0 0 0 0 0
C001083 John Carney John C. Carney Jr.   Democrat DE House 0 2011-01-05 2017-01-03 0 N00030736 ["H0DE01017"] 412407 01999 53658   John Carney (Delaware politician) John C. Carney Jr. 1956-05-20 M 4 2017-01-03 0 96 67 4134 2741276
C000257 John Causey John Causey   Democrat DE House 0 1891-12-07 1895-03-03 0   [] 402401       John W. Causey   1841-09-19 M 3 1895-03-03 0 0 0 0 0
N000099 John Nicholson John Nicholson   Democrat DE House 0 1865-12-04 1869-03-03 0   [] 408184       John A. Nicholson   1827-11-17 M 3 1869-03-03 0 0 0 0 0
P000209 John Penington John Penington   Democrat DE House 0 1887-12-05 1891-03-03 0   [] 408612       John B. Penington   1825-12-20 M 3 1891-03-03 0 0 0 0 0
H000156 Levin Handy Levin Handy   Democrat DE House 0 1897-03-15 1899-03-03 0   [] 405038       L. Irving Handy   1861-12-24 M 2 1899-03-03 0 0 0 0 0
T000357 Philip Traynor Philip Traynor   Democrat DE House 0 1941-01-03 1947-01-03 0   [] 410927       Philip A. Traynor   1874-05-31 M 4 1947-01-03 0 0 0 0 0
M001238 Sarah McBride Sarah McBride   Democrat DE House 0 2025-01-03 2027-01-03 1 N00052698 ["H4DE00045"] 456985       Sarah McBride   1990-08-09 F 2   0 27 6 445 1127494
R000353 Thomas Robinson Thomas Robinson   Democrat DE House 0 1839-12-02 1841-03-03 0   [] 409324       Thomas Robinson Jr.     M 2 1841-03-03 0 0 0 0 0
A000050 Wilbur Adams Wilbur Adams   Democrat DE House 0 1933-03-09 1935-01-03 0   [] 400711       Wilbur L. Adams   1884-10-23 M 2 1935-01-03 0 0 0 0 0
A000151 William Allen William Allen   Democrat DE House 0 1937-01-05 1939-01-03 0   [] 400806       William F. Allen (Delaware politician)   1883-01-19 M 2 1939-01-03 0 0 0 0 0
B000712 William Boyce William Boyce   Democrat DE House 0 1923-12-03 1925-03-03 0   [] 401673       William H. Boyce   1855-11-28 M 2 1925-03-03 0 0 0 0 0
T000120 William Temple William Temple   Democrat DE House 0 1863-12-07 1865-03-03 0   [] 410702       William Temple (politician)   1814-02-28 M 2 1865-03-03 0 0 0 0 0
W000409 William Whiteley William Whiteley   Democrat DE House 0 1857-12-07 1861-03-03 0   [] 411569       William G. Whiteley   1819-08-07 M 3 1861-03-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);