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

13 rows where party = "Jackson" and state = "NC" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

chamber 2

state 1

party 1

  • Jackson · 13 ✖

is_current 1

  • 0 13
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
M000586 Archibald McNeill Archibald McNeill   Jackson NC House 7 1821-12-03 1827-03-03 0   [] 412168       Archibald McNeill     M 4 1827-03-03 0 0 0 0 0
T000418 Daniel Turner Daniel Turner   Jackson NC House 6 1827-12-03 1829-03-03 0   [] 410987       Daniel Turner (North Carolina politician)   1796-09-21 M 2 1829-03-03 0 0 0 0 0
D000512 Edward Dudley Edward Dudley   Jackson NC House 5 1829-12-07 1831-03-03 0   [] 403622       Edward Bishop Dudley   1789-12-15 M 2 1831-03-03 0 0 0 0 0
I000028 James Iredell James Iredell   Jackson NC Senate   1828-01-01 1831-03-03 0   [] 405886       James Iredell Jr.   1788-11-02 M 1 1831-03-03 0 0 0 0 0
B000763 John Branch John Branch   Jackson NC House 2 1823-12-01 1833-03-03 0   [] 401722       John Branch   1782-11-04 M 6 1833-03-03 0 0 0 0 0
B000423 Lauchlin Bethune Lauchlin Bethune   Jackson NC House 7 1831-12-05 1833-03-03 0   [] 401409       Lauchlin Bethune   1785-04-15 M 2 1833-03-03 0 0 0 0 0
S000089 Lemuel Sawyer Lemuel Sawyer   Jackson NC House 1 1807-10-26 1829-03-03 0   [] 409601       Lemuel Sawyer     M 12 1829-03-03 0 0 0 0 0
M000034 Nathaniel Macon Nathaniel Macon   Jackson NC Senate   1791-10-24 1828-11-14 0   [] 407062       Nathaniel Macon   1757-12-17 M 7 1828-11-14 0 0 0 0 0
H000634 Richard Hines Richard Hines   Jackson NC House 3 1825-12-05 1827-03-03 0   [] 412052       Richard Hines     M 2 1827-03-03 0 0 0 0 0
C000193 Samuel Carson Samuel Carson   Jackson NC House 12 1825-12-05 1833-03-03 0   [] 402339       Samuel Price Carson   1798-01-22 M 5 1833-03-03 0 0 0 0 0
H000072 Thomas Hall Thomas Hall   Jackson NC House 3 1817-12-01 1835-03-03 0   [] 404956       Thomas H. Hall     M 10 1835-03-03 0 0 0 0 0
E000083 Weldon Edwards Weldon Edwards   Jackson NC House 6 1815-12-04 1827-03-03 0   [] 403775       Weldon Nathaniel Edwards   1788-01-25 M 7 1827-03-03 0 0 0 0 0
A000167 Willis Alston Willis Alston   Jackson NC House 2 1799-12-02 1831-03-03 0   [] 400822       Willis Alston     M 17 1831-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);