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 = "Republican" and state = "MS" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, nickname, district, first_served, last_served, opensecrets_id, fec_ids, thomas_id, ballotpedia_id, terms_count, served_until, trade_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 18
  • 1 3

state 1

party 1

  • Republican · 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
N000186 Alan Nunnelee Alan Nunnelee   Republican MS House 1 2011-01-05 2015-02-06 0 N00031006 ["H0MS01043"] 412442 02034 8326   Alan Nunnelee Alan Nunnelee 1958-10-09 M 3 2015-02-06 2 71 9 2860 2417347
H000850 Albert Howe Albert Howe   Republican MS House 2 1873-12-01 1875-03-03 0   [] 405697       Albert R. Howe   1840-01-01 M 2 1875-03-03 0 0 0 0 0
P000323 Charles Pickering Charles Pickering Chip Republican MS House 3 1997-01-07 2009-01-03 0 N00003341 ["H6MS03046"] 400319 01513 279   Chip Pickering   1963-08-10 M 7 2009-01-03 0 268 61 4229 -2500
J000071 Elza Jeffords Elza Jeffords   Republican MS House 3 1883-12-03 1885-03-03 0   [] 405975       Elza Jeffords   1826-05-23 M 2 1885-03-03 0 0 0 0 0
H000238 George Harris George Harris   Republican MS House 1 1869-03-04 1873-03-03 0   [] 405116       George E. Harris   1827-01-06 M 3 1873-03-03 0 0 0 0 0
M000494 George McKee George McKee   Republican MS House 5 1867-03-04 1875-03-03 0   [] 407489       George C. McKee   1837-10-02 M 5 1875-03-03 0 0 0 0 0
H001045 Gregg Harper Gregg Harper   Republican MS House 3 2009-01-06 2019-01-03 0 N00029632 ["H8MS03067"] 412280 01933 101985   Gregg Harper   1956-06-01 M 6 2019-01-03 0 197 68 6998 2016448
B000189 Henry Barry Henry Barry   Republican MS House 3 1869-03-04 1875-03-03 0   [] 401188       Henry W. Barry     M 4 1875-03-03 0 0 0 0 0
N000107 Jason Niles Jason Niles   Republican MS House 4 1873-12-01 1875-03-03 0   [] 408191       Jason Niles   1814-12-19 M 2 1875-03-03 0 0 0 0 0
L000533 John Lynch John Lynch   Republican MS House 6 1873-12-01 1883-03-03 0   [] 407017       John R. Lynch   1847-09-10 M 6 1883-03-03 0 0 0 0 0
H000641 Jon Hinson Jon Hinson   Republican MS House 4 1979-01-15 1983-01-03 0   [] 405496 00543     Jon Hinson   1942-03-16 M 3 1983-01-03 0 0 58 0 0
M000963 Joseph Morphis Joseph Morphis   Republican MS House 2 1869-03-04 1873-03-03 0   [] 407931       Joseph L. Morphis   1831-04-17 M 3 1873-03-03 0 0 0 0 0
S000584 Larkin Smith Larkin Smith   Republican MS House 5 1989-01-03 1989-08-13 0   [] 410064 01076     Larkin I. Smith   1944-06-26 M 1 1989-08-13 0 0 1 0 0
P000221 Legrand Perce Legrand Perce   Republican MS House 5 1869-03-04 1873-03-03 0   [] 408624       Legrand W. Perce   1836-06-19 M 3 1873-03-03 0 0 0 0 0
G000591 Michael Guest Michael Guest   Republican MS House 3 2019-01-03 2027-01-03 1 N00042458 ["H8MS03125"] 412793       Michael Guest (politician) Michael Guest 1970-02-04 M 5   87 198 51 3112 2036430
P000066 Michael Parker Michael Parker Mike Republican MS House 4 1989-01-03 1999-01-03 0   [] 408476 00889     Michael Parker (politician)   1949-10-31 M 6 1999-01-03 0 45 16 0 0
E000235 Mike Ezell Mike Ezell   Republican MS House 4 2023-01-03 2027-01-03 1 N00048240 ["H2MS04258"] 456911   202526   Mike Ezell   1959-04-06 M 3   0 52 37 1711 1116359
W000065 Prentiss Walker Prentiss Walker   Republican MS House 4 1965-01-04 1967-01-03 0   [] 411244       Prentiss Walker   1917-08-23 M 2 1967-01-03 0 0 0 0 0
P000601 Steven Palazzo Steven M. Palazzo   Republican MS House 4 2011-01-05 2023-01-03 0 N00031958 ["H0MS04120"] 412443 02035 69521   Steven Palazzo Steven Palazzo 1970-02-21 M 7 2023-01-03 0 285 48 6744 3734317
K000388 Trent Kelly Trent Kelly   Republican MS House 1 2015-06-09 2027-01-03 1 N00037003 ["H6MS01131"] 412673 02294 156389   Trent Kelly Trent Kelly 1966-03-01 M 7   0 451 66 5338 2762140
F000347 William Franklin William Franklin   Republican MS House 2 1983-01-03 1987-01-03 0   [] 404295 00408     Webb Franklin   1941-12-13 M 3 1987-01-03 0 0 7 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);