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

11 rows where is_current = 1 and state = "MA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

chamber 2

state 1

party 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
P000617 Ayanna Pressley Ayanna Pressley   Democrat MA House 7 2019-01-03 2027-01-03 1 N00042581 ["H8MA07032"] 412782   122700   Ayanna Pressley Ayanna Pressley 1974-02-03 F 5   0 166 131 3087 822700
M000133 Edward Markey Edward J. Markey Ed Democrat MA Senate   1975-01-14 2027-01-03 1 N00000270 ["H6MA07101", "S4MA00028"] 400253 00735 26900 S369 Ed Markey Ed Markey 1946-07-11 M 9   0 1900 957 12493 14910347
W000817 Elizabeth Warren Elizabeth Warren   Democrat MA Senate   2013-01-03 2031-01-03 1 N00033492 ["S2MA00170"] 412542 02182 141272 S366 Elizabeth Warren Elizabeth Warren 1949-06-22 F 4   0 904 446 4823 7656779
A000148 Jake Auchincloss Jake Auchincloss   Democrat MA House 4 2021-01-03 2027-01-03 1 N00045506 ["H0MA04192"] 456825       Jake Auchincloss   1988-01-29 M 4   8 100 23 2135 2575966
M000312 James McGovern James P. McGovern Jim Democrat MA House 2 1997-01-07 2027-01-03 1 N00000179 ["H4MA03022"] 400263 01504 552   Jim McGovern (American politician) Jim McGovern (Massachusetts) 1959-11-20 M 16   3 2215 363 14314 3639513
C001101 Katherine Clark Katherine M. Clark   Democrat MA House 5 2013-12-12 2027-01-03 1 N00035278 ["H4MA05084"] 412600 02196 35858   Katherine Clark Katherine Clark 1963-07-17 F 8   617 211 80 6188 7464235
T000482 Lori Trahan Lori Trahan   Democrat MA House 3 2019-01-03 2027-01-03 1 N00041808 ["H8MA03106"] 412781   182310   Lori Trahan Lori Trahan 1973-10-27 F 5   2 110 69 3087 2374186
N000015 Richard Neal Richard E. Neal   Democrat MA House 1 1989-01-03 2027-01-03 1 N00000153 ["H8MA02041"] 400291 00854 26895   Richard Neal Richard Neal 1949-02-14 M 20   0 890 145 14314 18600852
M001196 Seth Moulton Seth Moulton   Democrat MA House 6 2015-01-06 2027-01-03 1 N00035431 ["H4MA06090"] 412632 02246 146299   Seth Moulton Seth Moulton 1978-10-24 M 7   20 106 101 5621 5034179
L000562 Stephen Lynch Stephen F. Lynch   Democrat MA House 8 2001-10-23 2027-01-03 1 N00013855 ["H2MA09072", "S0MA00083"] 400249 01686 4844   Stephen Lynch (politician) Stephen Lynch 1955-03-31 M 14   14 513 213 14314 5435650
K000375 William Keating William R. Keating   Democrat MA House 9 2011-01-05 2027-01-03 1 N00031933 ["H0MA10082"] 412435 02025 4743   Bill Keating (politician) Bill Keating 1952-09-06 M 9   187 493 136 8430 4779675

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