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

12 rows where is_current = 1 and state = "WA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_served, last_served, thomas_id, ballotpedia_id, birthday, gender, terms_count, trade_count, vote_count, first_served (date), last_served (date), birthday (date), fec_ids (array)

party 2

chamber 2

state 1

is_current 1

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
S000510 Adam Smith Adam Smith   Democrat WA House 9 1997-01-07 2027-01-03 1 N00007833 ["H6WA09025"] 400379 01528 845   Adam Smith (Washington politician) Adam Smith 1965-06-15 M 16   18 716 182 14314 5979737
N000189 Dan Newhouse Dan Newhouse   Republican WA House 4 2015-01-06 2027-01-03 1 N00036403 ["H4WA04104"] 412660 02275 51522   Dan Newhouse Dan Newhouse 1955-07-10 M 7   181 398 150 5621 7842638
R000621 Emily Randall Emily Randall   Democrat WA House 6 2025-01-03 2027-01-03 1 N00054078 ["H4WA06117"] 457030       Emily Randall   1985-10-30 F 2   11 46 10 445 3319039
S001216 Kim Schrier Kim Schrier   Democrat WA House 8 2019-01-03 2027-01-03 1 N00041606 ["H8WA08189"] 412835   181124   Kim Schrier Kim Schrier 1968-08-23 F 5   41 103 91 3087 21845828
C000127 Maria Cantwell Maria Cantwell   Democrat WA Senate   1993-01-05 2031-01-03 1 N00007836 ["S8WA00194", "H2WA01054"] 300018 00172 27122 S275 Maria Cantwell Maria Cantwell 1958-10-13 F 7   6 1780 462 8615 620082
G000600 Marie Gluesenkamp Perez Marie Gluesenkamp Perez   Democrat WA House 3 2023-01-03 2027-01-03 1 N00050490 ["H2WA03217"] 456949   207307   Marie Gluesenkamp Perez Marie Gluesenkamp Perez 1988-06-06 F 3   0 37 50 1686 8813928
S001159 Marilyn Strickland Marilyn Strickland   Democrat WA House 10 2021-01-03 2027-01-03 1 N00046320 ["H0WA10034"] 456854       Marilyn Strickland   1962-09-25 F 4   0 69 54 2135 2998578
B001322 Michael Baumgartner Michael Baumgartner   Republican WA House 5 2025-01-03 2027-01-03 1 N00033716 ["H4WA05234"] 457029       Michael Baumgartner   1975-12-13 M 2   0 43 14 445 638527
M001111 Patty Murray Patty Murray   Democrat WA Senate   1993-01-05 2029-01-03 1 N00007876 ["S2WA00189"] 300076 01409 53358 S229 Patty Murray Patty Murray 1950-10-11 F 7   161 3339 541 9287 30543004
J000298 Pramila Jayapal Pramila Jayapal   Democrat WA House 7 2017-01-03 2027-01-03 1 N00038858 ["H6WA07458"] 412730   153141   Pramila Jayapal Pramila Jayapal 1965-09-21 F 6   0 290 159 4296 2266750
L000560 Rick Larsen Rick Larsen   Democrat WA House 2 2001-01-03 2027-01-03 1 N00009759 ["H0WA02080"] 400232 01675 56231   Rick Larsen Rick Larsen 1965-06-15 M 14   75 322 158 14314 9150718
D000617 Suzan DelBene Suzan K. DelBene   Democrat WA House 1 2012-11-13 2027-01-03 1 N00030693 ["H0WA08046"] 412505 02096 126272   Suzan DelBene Suzan DelBene 1962-02-17 F 8   716 234 137 6880 9470734

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);