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

22 rows where party = "Democrat" and state = "UT" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_name, last_name, nickname, 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 · 22 ✖

is_current 1

  • 0 22
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
H000851 Allan Howe Allan Howe   Democrat UT House 2 1975-01-14 1977-01-03 0   [] 405698 00565     Allan Turner Howe   1927-09-06 M 2 1977-01-03 0 0 0 0 0
M001209 Ben McAdams Ben McAdams   Democrat UT House 4 2019-01-03 2021-01-03 0 N00042013 ["H8UT04053"] 412829   117512   Ben McAdams Ben McAdams 1974-12-05 M 2 2021-01-03 0 52 14 952 9126485
K000199 David King David King   Democrat UT House 2 1959-01-07 1967-01-03 0   [] 406360       David S. King   1917-06-20 M 5 1967-01-03 0 0 0 0 0
O000156 Douglas Owens Douglas Owens   Democrat UT House 2 1973-01-03 1993-01-03 0   [] 408407 00884     Wayne Owens   1937-05-02 M 11 1993-01-03 0 0 0 0 0
T000164 Elbert Thomas Elbert Thomas   Democrat UT Senate   1933-03-09 1951-01-03 0   [] 410745       Elbert D. Thomas   1883-06-17 M 4 1951-01-03 0 0 0 0 0
M001033 Frank Moss Frank Moss   Democrat UT Senate   1959-01-07 1977-01-03 0   [] 408000 01406     Frank Moss   1911-09-23 M 4 1977-01-03 0 0 0 0 0
M000290 James Mays James Mays   Democrat UT House 2 1915-12-06 1921-03-03 0   [] 407305       James Henry Mays   1868-06-29 M 4 1921-03-03 0 0 0 0 0
R000341 James Robinson James Robinson   Democrat UT House 2 1933-03-09 1947-01-03 0   [] 409312       J. W. Robinson   1878-01-19 M 8 1947-01-03 0 0 0 0 0
M001142 Jim Matheson Jim Matheson   Democrat UT House 4 2001-01-03 2015-01-03 0 N00009753 ["H0UT02096"] 400255 01671 50722   Jim Matheson Jim Matheson 1960-03-21 M 8 2015-01-03 0 274 85 8693 6498109
C000023 John Caine John Caine   Democrat UT House -1 1881-12-05 1893-03-03 0   [] 402184       John T. Caine   1829-01-08 M 7 1893-03-03 0 0 0 0 0
K000225 John Kinney John Kinney   Democrat UT House -1 1863-12-07 1865-03-03 0   [] 406384       John F. Kinney   1816-04-02 M 2 1865-03-03 0 0 0 0 0
R000073 Joseph Rawlins Joseph Rawlins   Democrat UT Senate   1893-08-07 1903-03-03 0   [] 409053       Joseph L. Rawlins   1850-03-28 M 2 1903-03-03 0 0 0 0 0
S000332 Karen Shepherd Karen Shepherd   Democrat UT House 2 1993-01-05 1995-01-03 0   [] 409829 01050     Karen Shepherd   1940-07-05 F 2 1995-01-03 0 12 0 0 0
M000490 Koln McKay Koln McKay   Democrat UT House 1 1971-01-21 1981-01-03 0   [] 407485 00777     K. Gunn McKay   1925-02-23 M 6 1981-01-03 0 0 0 0 0
W000278 Milton Welling Milton Welling   Democrat UT House 1 1917-04-02 1921-03-03 0   [] 411443       Milton H. Welling   1876-01-25 M 3 1921-03-03 0 0 0 0 0
P000264 Morris Peterson Morris Peterson   Democrat UT House 1 1961-01-03 1963-01-03 0   [] 408665       M. Blaine Peterson   1906-03-26 M 2 1963-01-03 0 0 0 0 0
M001082 Orrice Murdock Orrice Murdock Abe Democrat UT Senate   1933-03-09 1947-01-03 0   [] 408047       Abe Murdock   1893-07-18 M 3 1947-01-03 0 0 0 0 0
B000649 Reva Bosone Reva Bosone   Democrat UT House 2 1949-01-03 1953-01-03 0   [] 401613       Reva Beck Bosone   1895-04-02 F 3 1953-01-03 0 0 0 0 0
G000379 Walter Granger Walter Granger   Democrat UT House 1 1941-01-03 1953-01-03 0   [] 404730       Walter K. Granger   1888-10-11 M 7 1953-01-03 0 0 0 0 0
H000767 William Hooper William Hooper   Democrat UT House -1 1859-12-05 1873-03-03 0   [] 405617       William Henry Hooper   1813-12-25 M 8 1873-03-03 0 0 0 0 0
K000216 William King William King   Democrat UT Senate   1897-03-15 1941-01-03 0   [] 406376       William H. King   1863-06-03 M 8 1941-01-03 0 0 0 0 0
O000108 William Orton William Orton   Democrat UT House 3 1991-01-03 1997-01-03 0   [] 408364 00881     Bill Orton   1948-09-22 M 4 1997-01-03 0 95 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);