home / openregs

committee_memberships

Current committee membership for all members of Congress. Includes titles (Chairman, Ranking Member) and party affiliation. Linked to congress_members via bioguide_id.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

4 rows where title = "Chairwoman" sorted by committee_id

✎ View and edit SQL

This data as json, CSV (advanced)

title 1

  • Chairwoman · 4 ✖

party 1

  • majority 4
Link bioguide_id committee_id ▼ member_name party title rank
W000812,HLIG11 W000812 HLIG11 Ann Wagner majority Chairwoman 1
M000194,HSGO12 M000194 HSGO12 Nancy Mace majority Chairwoman 1
M001215,HSVR03 M001215 HSVR03 Mariannette Miller-Meeks majority Chairwoman 1
K000399,HSVR08 K000399 HSVR08 Jennifer A. Kiggans majority Chairwoman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE committee_memberships (
    bioguide_id TEXT NOT NULL,
    committee_id TEXT NOT NULL,
    member_name TEXT,
    party TEXT,
    title TEXT,
    rank INTEGER,
    PRIMARY KEY (bioguide_id, committee_id)
);
CREATE INDEX idx_cm_committee ON committee_memberships(committee_id);
CREATE INDEX idx_cm_bioguide ON committee_memberships(bioguide_id);
CREATE INDEX idx_cm_title ON committee_memberships(title);
Powered by Datasette · Queries took 93.48ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API