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

12 rows where title = "Vice Chairman" sorted by committee_id

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: rank

party 2

title 1

  • Vice Chairman · 12 ✖
Link bioguide_id committee_id ▼ member_name party title rank
L000585,HLIG01 L000585 HLIG01 Darin LaHood majority Vice Chairman 2
M001236,HSBA09 M001236 HSBA09 Tim Moore majority Vice Chairman 2
N000193,HSBA10 N000193 HSBA10 Zachary Nunn majority Vice Chairman 2
G000597,HSBA16 G000597 HSBA16 Andrew R. Garbarino majority Vice Chairman 2
L000583,HSBA20 L000583 HSBA20 Barry Loudermilk majority Vice Chairman 2
E000294,HSBA21 E000294 HSBA21 Tom Emmer majority Vice Chairman 2
S001227,JSEC S001227 JSEC Eric Schmitt majority Vice Chairman 1
M000355,JSLC M000355 JSLC Mitch McConnell majority Vice Chairman 1
S001195,JSTX S001195 JSTX Jason Smith majority Vice Chairman 1
C001088,SLET C001088 SLET Christopher A. Coons minority Vice Chairman 1
S001194,SLIA S001194 SLIA Brian Schatz minority Vice Chairman 1
W000805,SLIN W000805 SLIN Mark R. Warner minority Vice Chairman 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);