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 = "IL" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
H000770 Albert Hopkins Albert Hopkins   Republican IL Senate   1885-12-07 1909-03-03 0   [] 405620       Albert J. Hopkins   1846-08-15 M 5 1909-03-03 0 0 0 0 0
B000874 Charles Brooks Charles Brooks   Republican IL Senate   1940-01-01 1949-01-03 0   [] 401831       C. Wayland Brooks   1897-03-08 M 2 1949-01-03 0 0 0 0 0
D000233 Charles Deneen Charles Deneen   Republican IL Senate   1925-12-07 1931-03-03 0   [] 403371       Charles S. Deneen   1863-05-04 M 2 1931-03-03 0 0 0 0 0
F000037 Charles Farwell Charles Farwell   Republican IL Senate   1871-03-04 1891-03-03 0   [] 403998       Charles B. Farwell   1823-07-01 M 4 1891-03-03 0 0 0 0 0
P000222 Charles Percy Charles Percy   Republican IL Senate   1967-01-10 1985-01-03 0   [] 408625 01418     Charles H. Percy   1919-09-27 M 4 1985-01-03 0 0 359 0 0
D000360 Everett Dirksen Everett Dirksen   Republican IL Senate   1933-03-09 1969-01-03 0   [] 403477       Everett Dirksen   1896-01-04 M 7 1969-01-03 0 0 0 0 0
L000403 John Logan John Logan   Republican IL Senate   1859-12-05 1887-03-03 0   [] 406894       John A. Logan   1826-02-09 M 5 1887-03-03 0 0 0 0 0
M000369 Joseph McCormick Joseph McCormick   Republican IL Senate   1917-04-02 1925-03-03 0   [] 407374       Medill McCormick   1877-05-16 M 2 1925-03-03 0 0 0 0 0
S000348 Lawrence Sherman Lawrence Sherman   Republican IL Senate   1913-04-07 1921-03-03 0   [] 409844       Lawrence Y. Sherman   1858-11-08 M 2 1921-03-03 0 0 0 0 0
T000392 Lyman Trumbull Lyman Trumbull   Republican IL Senate   1855-12-03 1873-03-03 0   [] 410961       Lyman Trumbull   1813-10-12 M 4 1873-03-03 0 0 0 0 0
K000360 Mark Kirk Mark Kirk   Republican IL Senate   2001-01-03 2017-01-03 0 N00012539 ["H0IL10120", "S0IL00261"] 400222 01647 33502 S339 Mark Kirk Mark Kirk 1959-09-15 M 3 2017-01-03 0 909 253 7493 23326088
E000078 Ninian Edwards Ninian Edwards   Republican IL Senate   1818-12-03 1824-03-04 0   [] 403770       Ninian Edwards   1775-03-17 M 2 1824-03-04 0 0 0 0 0
B000960 Orville Browning Orville Browning   Republican IL Senate   1861-07-04 1863-12-31 0   [] 401912       Orville Hickman Browning   1806-02-10 M 1 1863-12-31 0 0 0 0 0
G000238 Otis Glenn Otis Glenn   Republican IL Senate   1928-12-03 1933-03-03 0   [] 404600       Otis F. Glenn   1879-08-27 M 1 1933-03-03 0 0 0 0 0
F000442 Peter Fitzgerald Peter Fitzgerald   Republican IL Senate   1999-01-06 2005-01-03 0 N00004690 ["H4IL08043", "S8IL00082"] 300044 01571   S268 Peter Fitzgerald (politician)   1960-10-20 M 2 2005-01-03 0 299 33 1980 0
S000602 Ralph Smith Ralph Smith   Republican IL Senate   1969-09-17 1971-01-03 0   [] 410080       Ralph T. Smith   1915-10-06 M 1 1971-01-03 0 0 0 0 0
O000048 Richard Oglesby Richard Oglesby   Republican IL Senate   1873-12-01 1879-03-03 0   [] 408331       Richard J. Oglesby   1824-07-25 M 2 1879-03-03 0 0 0 0 0
Y000012 Richard Yates Richard Yates   Republican IL Senate   1851-12-01 1871-03-03 0   [] 411945       Richard Yates (politician)   1815-01-18 M 4 1871-03-03 0 0 0 0 0
C000973 Shelby Cullom Shelby Cullom   Republican IL Senate   1865-12-04 1913-03-03 0   [] 403084       Shelby M. Cullom   1829-11-22 M 9 1913-03-03 0 0 0 0 0
L000444 William Lorimer William Lorimer   Republican IL Senate   1895-12-02 1913-03-03 0   [] 406935       William Lorimer (politician)   1861-04-27 M 4 1913-03-03 0 0 0 0 0
M000521 William McKinley William McKinley   Republican IL Senate   1905-12-04 1927-03-04 0   [] 407514       William B. McKinley   1856-09-05 M 4 1927-03-04 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);