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

16 rows where party = "Whig" and state = "IN" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, last_name, district, first_served, last_served, terms_count, served_until, first_served (date), last_served (date), birthday (date), served_until (date)

chamber 2

state 1

party 1

  • Whig · 16 ✖

is_current 1

  • 0 16
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
S000519 Caleb Smith Caleb Smith   Whig IN House 4 1843-12-04 1849-03-03 0   [] 410003       Caleb B. Smith   1808-04-16 M 4 1849-03-03 0 0 0 0 0
W000076 David Wallace David Wallace   Whig IN House 6 1841-05-31 1843-03-03 0   [] 411255       David Wallace (Indiana politician)   1799-04-24 M 2 1843-03-03 0 0 0 0 0
M000443 Edward McGaughey Edward McGaughey   Whig IN House 7 1845-12-01 1851-03-03 0   [] 407442       Edward W. McGaughey   1817-01-16 M 4 1851-03-03 0 0 0 0 0
E000169 Elisha Embree Elisha Embree   Whig IN House 1 1847-12-06 1849-03-03 0   [] 403860       Elisha Embree   1801-09-28 M 2 1849-03-03 0 0 0 0 0
D000547 George Dunn George Dunn   Whig IN House 4 1837-09-04 1839-03-03 0   [] 403655       George Hedford Dunn   1794-11-15 M 2 1839-03-03 0 0 0 0 0
P000548 George Proffit George Proffit   Whig IN House 1 1839-12-02 1843-03-03 0   [] 408932       George H. Proffit   1807-09-04 M 3 1843-03-03 0 0 0 0 0
C000884 James Cravens James Cravens   Whig IN House 4 1841-05-31 1843-03-03 0   [] 402996       James H. Cravens   1802-08-02 M 2 1843-03-03 0 0 0 0 0
R000066 James Rariden James Rariden   Whig IN House 5 1837-09-04 1841-03-03 0   [] 409046       James Rariden   1795-02-14 M 3 1841-03-03 0 0 0 0 0
E000277 John Ewing John Ewing   Whig IN House 2 1833-12-02 1839-03-03 0   [] 403956       John Ewing (Indiana politician)   1789-05-19 M 4 1839-03-03 0 0 0 0 0
W000382 Joseph White Joseph White   Whig IN House 3 1841-05-31 1843-03-03 0   [] 412117       Joseph L. White     M 2 1843-03-03 0 0 0 0 0
S000599 Oliver Smith Oliver Smith   Whig IN Senate   1827-12-03 1843-03-03 0   [] 410077       Oliver H. Smith   1794-10-23 M 3 1843-03-03 0 0 0 0 0
T000214 Richard Thompson Richard Thompson   Whig IN House 7 1841-05-31 1849-03-03 0   [] 410793       Richard W. Thompson   1809-06-09 M 5 1849-03-03 0 0 0 0 0
P000071 Samuel Parker Samuel Parker   Whig IN House 5 1851-12-01 1855-03-03 0   [] 408481       Samuel W. Parker   1805-09-09 M 3 1855-03-03 0 0 0 0 0
S000024 Samuel Sample Samuel Sample   Whig IN House 9 1843-12-04 1845-03-03 0   [] 409543       Samuel C. Sample   1796-08-15 M 2 1845-03-03 0 0 0 0 0
G000361 William Graham William Graham   Whig IN House 3 1837-09-04 1839-03-03 0   [] 404715       William Graham (Indiana politician)   1782-03-16 M 2 1839-03-03 0 0 0 0 0
H000536 William Herod William Herod   Whig IN House 6 1835-12-07 1839-03-03 0   [] 405398       William Herod   1801-03-31 M 3 1839-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);