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

37 rows where title = "Vice Chair" sorted by committee_id

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: rank

title 1

  • Vice Chair · 37 ✖

party 1

  • majority 37
Link bioguide_id committee_id ▼ member_name party title rank
S001189,HSAG S001189 HSAG Austin Scott majority Vice Chair 3
D000594,HSAG03 D000594 HSAG03 Monica De La Cruz majority Vice Chair 2
B001307,HSAG14 B001307 HSAG14 James R. Baird majority Vice Chair 2
M001212,HSAG15 M001212 HSAG15 Barry Moore majority Vice Chair 2
R000603,HSAG16 R000603 HSAG16 David Rouzer majority Vice Chair 2
R000612,HSAG22 R000612 HSAG22 John W. Rose majority Vice Chair 2
V000135,HSAG29 V000135 HSAG29 Derrick Van Orden majority Vice Chair 2
D000600,HSAP D000600 HSAP Mario Diaz-Balart majority Vice Chair 7
F000472,HSAP01 F000472 HSAP01 Scott Franklin majority Vice Chair 9
E000071,HSAP02 E000071 HSAP02 Jake Ellzey majority Vice Chair 8
E000246,HSAP04 E000246 HSAP04 Chuck Edwards majority Vice Chair 5
M001228,HSAP06 M001228 HSAP06 Celeste Maloy majority Vice Chair 7
L000595,HSAP07 L000595 HSAP07 Julia Letlow majority Vice Chair 6
C001115,HSAP10 C001115 HSAP10 Michael Cloud majority Vice Chair 7
C001133,HSAP15 C001133 HSAP15 Juan Ciscomani majority Vice Chair 7
A000379,HSAP18 A000379 HSAP18 Mark Alford majority Vice Chair 7
S001220,HSAP19 S001220 HSAP19 Dale W. Strong majority Vice Chair 7
B000740,HSAP20 B000740 HSAP20 Stephanie I. Bice majority Vice Chair 8
L000598,HSAP23 L000598 HSAP23 Nick LaLota majority Vice Chair 8
M001235,HSAP24 M001235 HSAP24 Riley M. Moore majority Vice Chair 5
L000597,HSHA L000597 HSHA Laurel M. Lee majority Vice Chair 7
M001157,HSHM M001157 HSHM Michael T. McCaul majority Vice Chair 2
D000628,HSIF D000628 HSIF Neal P. Dunn majority Vice Chair 8
B001306,HSIF02 B001306 HSIF02 Troy Balderson majority Vice Chair 2
W000814,HSIF03 W000814 HSIF03 Randy K. Weber, Sr. majority Vice Chair 2
H001086,HSIF14 H001086 HSIF14 Diana Harshbarger majority Vice Chair 2
A000372,HSIF16 A000372 HSIF16 Rick W. Allen majority Vice Chair 2
F000469,HSIF17 F000469 HSIF17 Russ Fulcher majority Vice Chair 2
C001120,HSIF18 C001120 HSIF18 Dan Crenshaw majority Vice Chair 2
W000804,HSII W000804 HSII Robert J. Wittman majority Vice Chair 2
B001323,HSII06 B001323 HSII06 Nicholas J. Begich III majority Vice Chair 13
K000403,HSII10 K000403 HSII10 Mike Kennedy majority Vice Chair 9
E000235,HSII13 E000235 HSII13 Mike Ezell majority Vice Chair 10
B000825,HSII15 B000825 HSII15 Lauren Boebert majority Vice Chair 2
R000600,HSII24 R000600 HSII24 Aumua Amata Coleman Radewagen majority Vice Chair 2
C001087,HSPW C001087 HSPW Eric A. "Rick" Crawford majority Vice Chair 2
S001213,JSPR S001213 JSPR Bryan Steil majority Vice Chair 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 113.409ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API