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

1,737 rows where party = "minority" sorted by committee_id

✎ View and edit SQL

This data as json, CSV (advanced)

title 5

party 1

  • minority · 1,737 ✖
Link bioguide_id committee_id ▼ member_name party title rank
H001047,HLIG H001047 HLIG James A. Himes minority Ranking Member 1
C001072,HLIG C001072 HLIG André Carson minority   2
C001091,HLIG C001091 HLIG Joaquin Castro minority   3
K000391,HLIG K000391 HLIG Raja Krishnamoorthi minority   4
C001121,HLIG C001121 HLIG Jason Crow minority   5
B001287,HLIG B001287 HLIG Ami Bera minority   6
P000610,HLIG P000610 HLIG Stacey E. Plaskett minority   7
G000583,HLIG G000583 HLIG Josh Gottheimer minority   8
G000585,HLIG G000585 HLIG Jimmy Gomez minority   9
H001085,HLIG H001085 HLIG Chrissy Houlahan minority   10
Q000023,HLIG Q000023 HLIG Mike Quigley minority   11
C001068,HLIG C001068 HLIG Steve Cohen minority   12
G000585,HLIG01 G000585 HLIG01 Jimmy Gomez minority Ranking Member 1
C001091,HLIG01 C001091 HLIG01 Joaquin Castro minority   2
K000391,HLIG01 K000391 HLIG01 Raja Krishnamoorthi minority   3
C001121,HLIG01 C001121 HLIG01 Jason Crow minority   4
G000583,HLIG02 G000583 HLIG02 Josh Gottheimer minority Ranking Member 1
C001091,HLIG02 C001091 HLIG02 Joaquin Castro minority   2
B001287,HLIG02 B001287 HLIG02 Ami Bera minority   3
C001068,HLIG02 C001068 HLIG02 Steve Cohen minority   4
Q000023,HLIG04 Q000023 HLIG04 Mike Quigley minority Ranking Member 1
H001085,HLIG04 H001085 HLIG04 Chrissy Houlahan minority   2
P000610,HLIG04 P000610 HLIG04 Stacey E. Plaskett minority   3
G000583,HLIG04 G000583 HLIG04 Josh Gottheimer minority   4
C001072,HLIG06 C001072 HLIG06 André Carson minority Ranking Member 1
B001287,HLIG06 B001287 HLIG06 Ami Bera minority   2
P000610,HLIG06 P000610 HLIG06 Stacey E. Plaskett minority   3
G000585,HLIG06 G000585 HLIG06 Jimmy Gomez minority   4
C001091,HLIG09 C001091 HLIG09 Joaquin Castro minority Ranking Member 1
H001085,HLIG11 H001085 HLIG11 Chrissy Houlahan minority Ranking Member 1
C001121,HLIG11 C001121 HLIG11 Jason Crow minority   2
Q000023,HLIG11 Q000023 HLIG11 Mike Quigley minority   3
C001068,HLIG11 C001068 HLIG11 Steve Cohen minority   4
C001119,HSAG C001119 HSAG Angie Craig minority Ranking Member 1
S001157,HSAG S001157 HSAG David Scott minority   2
C001059,HSAG C001059 HSAG Jim Costa minority   3
M000312,HSAG M000312 HSAG James P. McGovern minority   4
A000370,HSAG A000370 HSAG Alma S. Adams minority   5
H001081,HSAG H001081 HSAG Jahana Hayes minority   6
B001313,HSAG B001313 HSAG Shontel M. Brown minority   7
D000629,HSAG D000629 HSAG Sharice Davids minority   8
S001226,HSAG S001226 HSAG Andrea Salinas minority   9
D000230,HSAG D000230 HSAG Donald G. Davis minority   10
T000487,HSAG T000487 HSAG Jill N. Tokuda minority   11
B001315,HSAG B001315 HSAG Nikki Budzinski minority   12
S001225,HSAG S001225 HSAG Eric Sorensen minority   13
V000136,HSAG V000136 HSAG Gabe Vasquez minority   14
J000309,HSAG J000309 HSAG Jonathan L. Jackson minority   15
T000488,HSAG T000488 HSAG Shri Thanedar minority   16
G000605,HSAG G000605 HSAG Adam Gray minority   17
M001237,HSAG M001237 HSAG Kristen McDonald Rivet minority   18
F000481,HSAG F000481 HSAG Shomari Figures minority   19
V000138,HSAG V000138 HSAG Eugene Simon Vindman minority   20
R000622,HSAG R000622 HSAG Josh Riley minority   21
M001231,HSAG M001231 HSAG John W. Mannion minority   22
M001232,HSAG M001232 HSAG April McClain Delaney minority   23
P000597,HSAG P000597 HSAG Chellie Pingree minority   24
C001112,HSAG C001112 HSAG Salud O. Carbajal minority   25
H001081,HSAG03 H001081 HSAG03 Jahana Hayes minority Ranking Member 1
M000312,HSAG03 M000312 HSAG03 James P. McGovern minority   2
A000370,HSAG03 A000370 HSAG03 Alma S. Adams minority   3
B001313,HSAG03 B001313 HSAG03 Shontel M. Brown minority   4
S001226,HSAG03 S001226 HSAG03 Andrea Salinas minority   5
T000487,HSAG03 T000487 HSAG03 Jill N. Tokuda minority   6
J000309,HSAG03 J000309 HSAG03 Jonathan L. Jackson minority   7
F000481,HSAG03 F000481 HSAG03 Shomari Figures minority   8
T000487,HSAG14 T000487 HSAG14 Jill N. Tokuda minority Ranking Member 1
A000370,HSAG14 A000370 HSAG14 Alma S. Adams minority   2
D000629,HSAG14 D000629 HSAG14 Sharice Davids minority   3
B001315,HSAG14 B001315 HSAG14 Nikki Budzinski minority   4
S001225,HSAG14 S001225 HSAG14 Eric Sorensen minority   5
V000136,HSAG14 V000136 HSAG14 Gabe Vasquez minority   6
V000138,HSAG14 V000138 HSAG14 Eugene Simon Vindman minority   7
M001231,HSAG14 M001231 HSAG14 John W. Mannion minority   8
M001232,HSAG14 M001232 HSAG14 April McClain Delaney minority   9
S001226,HSAG15 S001226 HSAG15 Andrea Salinas minority Ranking Member 1
C001059,HSAG15 C001059 HSAG15 Jim Costa minority   2
V000136,HSAG15 V000136 HSAG15 Gabe Vasquez minority   3
G000605,HSAG15 G000605 HSAG15 Adam Gray minority   4
R000622,HSAG15 R000622 HSAG15 Josh Riley minority   5
D000629,HSAG16 D000629 HSAG16 Sharice Davids minority Ranking Member 1
S001157,HSAG16 S001157 HSAG16 David Scott minority   2
B001313,HSAG16 B001313 HSAG16 Shontel M. Brown minority   3
D000230,HSAG16 D000230 HSAG16 Donald G. Davis minority   4
B001315,HSAG16 B001315 HSAG16 Nikki Budzinski minority   5
S001225,HSAG16 S001225 HSAG16 Eric Sorensen minority   6
M001237,HSAG16 M001237 HSAG16 Kristen McDonald Rivet minority   7
D000230,HSAG22 D000230 HSAG22 Donald G. Davis minority Ranking Member 1
S001157,HSAG22 S001157 HSAG22 David Scott minority   2
B001315,HSAG22 B001315 HSAG22 Nikki Budzinski minority   3
J000309,HSAG22 J000309 HSAG22 Jonathan L. Jackson minority   4
T000488,HSAG22 T000488 HSAG22 Shri Thanedar minority   5
G000605,HSAG22 G000605 HSAG22 Adam Gray minority   6
M001237,HSAG22 M001237 HSAG22 Kristen McDonald Rivet minority   7
F000481,HSAG22 F000481 HSAG22 Shomari Figures minority   8
V000138,HSAG22 V000138 HSAG22 Eugene Simon Vindman minority   9
M001231,HSAG22 M001231 HSAG22 John W. Mannion minority   10
M001232,HSAG22 M001232 HSAG22 April McClain Delaney minority   11
C001059,HSAG29 C001059 HSAG29 Jim Costa minority Ranking Member 1
H001081,HSAG29 H001081 HSAG29 Jahana Hayes minority   2

Next page

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