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

27 rows where is_current = 0, party = "Democrat" and state = "NM" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, district, first_served, last_served, opensecrets_id, fec_ids, thomas_id, ballotpedia_id, gender, 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)

chamber 2

state 1

party 1

  • Democrat · 27 ✖

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
J000210 Andrieus Jones Andrieus Jones   Democrat NM Senate   1917-04-02 1927-12-20 0   [] 406105       Andrieus A. Jones   1862-05-16 M 2 1927-12-20 0 0 0 0 0
F000085 Antonio Fernández Antonio Fernández   Democrat NM House 0 1943-01-06 1956-11-07 0   [] 404043       Antonio M. Fernández   1902-01-17 M 7 1956-11-07 0 0 0 0 0
J000272 Antonio Joseph Antonio Joseph   Democrat NM House -1 1885-12-07 1895-03-03 0   [] 406164       Antonio Joseph (politician)   1846-08-25 M 6 1895-03-03 0 0 0 0 0
H000334 Carl Hatch Carl Hatch   Democrat NM Senate   1933-10-10 1949-01-03 0   [] 405204       Carl Hatch   1889-11-27 M 3 1949-01-03 0 0 0 0 0
A000186 Clinton Anderson Clinton Anderson   Democrat NM Senate   1941-01-03 1973-01-03 0   [] 400841       Clinton Anderson   1895-10-23 M 6 1973-01-03 0 0 0 0 0
H001080 Debra Haaland Debra A. Haaland   Democrat NM House 1 2019-01-03 2021-03-16 0 N00040933 ["H8NM01331"] 412800   149368   Deb Haaland Debra Haaland 1960-12-02 F 2 2021-03-16 0 57 52 1029 1108030
C000338 Dennis Chavez Dennis Chavez   Democrat NM Senate   1931-12-07 1962-11-18 0   [] 402478       Dennis Chávez   1888-04-08 M 6 1962-11-18 0 0 0 0 0
W000049 E. Walker E. Walker   Democrat NM House 0 1965-01-04 1969-01-03 0   [] 411228       E. S. Johnny Walker   1911-06-18 M 3 1969-01-03 0 0 0 0 0
M000118 Francisco Manzanares Francisco Manzanares   Democrat NM House -1 1883-12-03 1885-03-03 0   [] 407142       Francisco Antonio Manzanares   1843-01-25 M 2 1885-03-03 0 0 0 0 0
L000519 Georgia Lusk Georgia Lusk   Democrat NM House 0 1947-01-03 1949-01-03 0   [] 407004       Georgia Lee Lusk   1893-05-12 F 2 1949-01-03 0 0 0 0 0
R000510 Harold Runnels Harold Runnels   Democrat NM House 2 1971-01-21 1981-01-03 0   [] 409469 01001     Harold L. Runnels   1924-03-17 M 6 1981-01-03 0 0 66 0 0
T000466 Harry Teague Harry Teague   Democrat NM House 2 2009-01-06 2011-01-03 0 N00029556 ["H8NM02032"] 412316 01938 102408   Harry Teague Harry Teague 1949-06-29 M 2 2011-01-03 0 60 28 1655 1592031
F000083 Harvey Fergusson Harvey Fergusson   Democrat NM House 1 1897-03-15 1915-03-03 0   [] 404041       Harvey Butler Fergusson   1848-09-09 M 10 1915-03-03 0 0 0 0 0
B000468 Jeff Bingaman Jeff Bingaman   Democrat NM Senate   1983-01-03 2013-01-03 0 N00006518 ["S2NM00021"] 300009 01285 53326 S167 Jeff Bingaman Jeff Bingaman 1943-10-03 M 6 2013-01-03 0 3043 679 4464 301000
D000228 John Dempsey John Dempsey   Democrat NM House 0 1935-01-03 1959-01-03 0   [] 403367       John J. Dempsey   1879-06-22 M 13 1959-01-03 0 0 0 0 0
M000705 John Miles John Miles   Democrat NM House 0 1949-01-03 1951-01-03 0   [] 407688       John E. Miles   1884-07-28 M 2 1951-01-03 0 0 0 0 0
M001004 John Morrow John Morrow   Democrat NM House 1 1923-12-03 1929-03-03 0   [] 407972       John Morrow (New Mexico politician)   1865-04-19 M 4 1929-03-03 0 0 0 0 0
M000876 Joseph Montoya Joseph Montoya   Democrat NM Senate   1957-01-03 1977-01-03 0   [] 407848 01403     Joseph Montoya   1915-09-24 M 4 1977-01-03 0 0 89 0 0
G000022 José Gallegos José Gallegos   Democrat NM House -1 1853-12-05 1873-03-03 0   [] 404398       José Manuel Gallegos   1815-10-30 M 11 1873-03-03 0 0 0 0 0
L000580 Michelle Lujan Grisham Michelle Lujan Grisham   Democrat NM House 1 2013-01-03 2018-12-31 0 N00029400 ["H8NM01257"] 412558 02146 102404   Michelle Lujan Grisham Michelle Lujan Grisham 1959-10-24 F 3 2018-12-31 0 269 79 3738 2242229
W000255 Richard Weightman Richard Weightman   Democrat NM House -1 1851-12-01 1853-03-03 0   [] 411423       Richard Hanson Weightman   1816-12-28 M 2 1853-03-03 0 0 0 0 0
B000774 Sam Bratton Sam Bratton   Democrat NM Senate   1925-12-07 1933-12-31 0   [] 401733       Sam G. Bratton   1888-08-19 M 2 1933-12-31 0 0 0 0 0
M000990 Thomas Morris Thomas Morris   Democrat NM House 0 1959-01-07 1969-01-03 0   [] 407958       Thomas G. Morris   1919-08-20 M 6 1969-01-03 0 0 0 0 0
U000039 Tom Udall Tom Udall   Democrat NM Senate   1999-01-06 2021-01-03 0 N00006561 ["H8NM03097", "S8NM00184"] 400413 01567 22658 S326 Tom Udall Tom Udall 1948-05-18 M 4 2021-01-03 0 1411 371 7889 2408770
R000229 William Richardson William Richardson   Democrat NM House 3 1983-01-03 1997-02-13 0   [] 409205 00958     Bill Richardson Bill Richardson 1947-11-15 M 8 1997-02-13 0 409 265 0 0
W000117 William Walton William Walton   Democrat NM House 1 1917-04-02 1919-03-03 0   [] 411293       William B. Walton   1871-01-23 M 2 1919-03-03 0 0 0 0 0
T000484 Xochitl Torres Small Xochitl Torres Small   Democrat NM House 2 2019-01-03 2021-01-03 0 N00042467 ["H8NM02248"] 412801   177978   Xochitl Torres Small Xochitl Torres Small 1984-11-15 F 2 2021-01-03 0 34 21 952 18092678

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