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

220 rows where title = "Ranking Member" sorted by committee_id

✎ View and edit SQL

This data as json, CSV (advanced)

title 1

  • Ranking Member · 220 ✖

party 1

Link bioguide_id committee_id ▼ member_name party title rank
H001047,HLIG H001047 HLIG James A. Himes minority Ranking Member 1
G000585,HLIG01 G000585 HLIG01 Jimmy Gomez minority Ranking Member 1
G000583,HLIG02 G000583 HLIG02 Josh Gottheimer minority Ranking Member 1
Q000023,HLIG04 Q000023 HLIG04 Mike Quigley minority Ranking Member 1
C001072,HLIG06 C001072 HLIG06 André Carson minority Ranking Member 1
C001091,HLIG09 C001091 HLIG09 Joaquin Castro minority Ranking Member 1
H001085,HLIG11 H001085 HLIG11 Chrissy Houlahan minority Ranking Member 1
C001119,HSAG C001119 HSAG Angie Craig minority Ranking Member 1
H001081,HSAG03 H001081 HSAG03 Jahana Hayes minority Ranking Member 1
T000487,HSAG14 T000487 HSAG14 Jill N. Tokuda minority Ranking Member 1
S001226,HSAG15 S001226 HSAG15 Andrea Salinas minority Ranking Member 1
D000629,HSAG16 D000629 HSAG16 Sharice Davids minority Ranking Member 1
D000230,HSAG22 D000230 HSAG22 Donald G. Davis minority Ranking Member 1
C001059,HSAG29 C001059 HSAG29 Jim Costa minority Ranking Member 1
D000216,HSAP D000216 HSAP Rosa L. DeLauro minority Ranking Member 1
B000490,HSAP01 B000490 HSAP01 Sanford D. Bishop, Jr. minority Ranking Member 1
M001143,HSAP02 M001143 HSAP02 Betty McCollum minority Ranking Member 1
F000462,HSAP04 F000462 HSAP04 Lois Frankel minority Ranking Member 1
P000597,HSAP06 P000597 HSAP06 Chellie Pingree minority Ranking Member 1
D000216,HSAP07 D000216 HSAP07 Rosa L. DeLauro minority Ranking Member 1
K000009,HSAP10 K000009 HSAP10 Marcy Kaptur minority Ranking Member 1
U000040,HSAP15 U000040 HSAP15 Lauren Underwood minority Ranking Member 1
W000797,HSAP18 W000797 HSAP18 Debbie Wasserman Schultz minority Ranking Member 1
M001188,HSAP19 M001188 HSAP19 Grace Meng minority Ranking Member 1
C000537,HSAP20 C000537 HSAP20 James E. Clyburn minority Ranking Member 1
H000874,HSAP23 H000874 HSAP23 Steny H. Hoyer minority Ranking Member 1
E000297,HSAP24 E000297 HSAP24 Adriano Espaillat minority Ranking Member 1
S000510,HSAS S000510 HSAS Adam Smith minority Ranking Member 1
H001085,HSAS02 H001085 HSAS02 Chrissy Houlahan minority Ranking Member 1
G000559,HSAS03 G000559 HSAS03 John Garamendi minority Ranking Member 1
N000188,HSAS25 N000188 HSAS25 Donald Norcross minority Ranking Member 1
C001121,HSAS26 C001121 HSAS26 Jason Crow minority Ranking Member 1
C001069,HSAS28 C001069 HSAS28 Joe Courtney minority Ranking Member 1
M001196,HSAS29 M001196 HSAS29 Seth Moulton minority Ranking Member 1
K000389,HSAS35 K000389 HSAS35 Ro Khanna minority Ranking Member 1
W000187,HSBA W000187 HSBA Maxine Waters minority Ranking Member 1
C001061,HSBA04 C001061 HSBA04 Emanuel Cleaver minority Ranking Member 1
G000553,HSBA09 G000553 HSBA09 Al Green minority Ranking Member 1
B001281,HSBA10 B001281 HSBA10 Joyce Beatty minority Ranking Member 1
S000344,HSBA16 S000344 HSBA16 Brad Sherman minority Ranking Member 1
F000454,HSBA20 F000454 HSBA20 Bill Foster minority Ranking Member 1
L000562,HSBA21 L000562 HSBA21 Stephen F. Lynch minority Ranking Member 1
B001296,HSBU B001296 HSBU Brendan F. Boyle minority Ranking Member 1
S000185,HSED S000185 HSED Robert C. "Bobby" Scott minority Ranking Member 1
D000623,HSED02 D000623 HSED02 Mark DeSaulnier minority Ranking Member 1
O000173,HSED10 O000173 HSED10 Ilhan Omar minority Ranking Member 1
A000370,HSED13 A000370 HSED13 Alma S. Adams minority Ranking Member 1
B001278,HSED14 B001278 HSED14 Suzanne Bonamici minority Ranking Member 1
M001137,HSFA M001137 HSFA Gregory W. Meeks minority Ranking Member 1
B001287,HSFA05 B001287 HSFA05 Ami Bera minority Ranking Member 1
C001091,HSFA07 C001091 HSFA07 Joaquin Castro minority Ranking Member 1
C001127,HSFA13 C001127 HSFA13 Sheila Cherfilus-McCormick minority Ranking Member 1
K000375,HSFA14 K000375 HSFA14 William R. Keating minority Ranking Member 1
J000305,HSFA16 J000305 HSFA16 Sara Jacobs minority Ranking Member 1
M001217,HSFA17 M001217 HSFA17 Jared Moskowitz minority Ranking Member 1
K000400,HSFA19 K000400 HSFA19 Sydney Kamlager-Dove minority Ranking Member 1
G000598,HSGO G000598 HSGO Robert Garcia minority Ranking Member 1
F000476,HSGO05 F000476 HSGO05 Maxwell Frost minority Ranking Member 1
S001230,HSGO06 S001230 HSGO06 Suhas Subramanyam minority Ranking Member 1
B001313,HSGO12 B001313 HSGO12 Shontel M. Brown minority Ranking Member 1
S001218,HSGO16 S001218 HSGO16 Melanie A. Stansbury minority Ranking Member 1
M000687,HSGO24 M000687 HSGO24 Kweisi Mfume minority Ranking Member 1
K000391,HSGO27 K000391 HSGO27 Raja Krishnamoorthi minority Ranking Member 1
L000602,HSGO33 L000602 HSGO33 Summer L. Lee minority Ranking Member 1
M001206,HSHA M001206 HSHA Joseph D. Morelle minority Ranking Member 1
S001185,HSHA08 S001185 HSHA08 Terri A. Sewell minority Ranking Member 1
T000474,HSHA27 T000474 HSHA27 Norma J. Torres minority Ranking Member 1
T000193,HSHM T000193 HSHM Bennie G. Thompson minority Ranking Member 1
M001223,HSHM05 M001223 HSHM05 Seth Magaziner minority Ranking Member 1
M001229,HSHM07 M001229 HSHM07 LaMonica McIver minority Ranking Member 1
S001193,HSHM08 S001193 HSHM08 Eric Swalwell minority Ranking Member 1
T000488,HSHM09 T000488 HSHM09 Shri Thanedar minority Ranking Member 1
C001110,HSHM11 C001110 HSHM11 J. Luis Correa minority Ranking Member 1
K000402,HSHM12 K000402 HSHM12 Timothy M. Kennedy minority Ranking Member 1
P000034,HSIF P000034 HSIF Frank Pallone, Jr. minority Ranking Member 1
C001067,HSIF02 C001067 HSIF02 Yvette D. Clarke minority Ranking Member 1
C001066,HSIF03 C001066 HSIF03 Kathy Castor minority Ranking Member 1
D000197,HSIF14 D000197 HSIF14 Diana DeGette minority Ranking Member 1
M001163,HSIF16 M001163 HSIF16 Doris O. Matsui minority Ranking Member 1
S001145,HSIF17 S001145 HSIF17 Janice D. Schakowsky minority Ranking Member 1
T000469,HSIF18 T000469 HSIF18 Paul Tonko minority Ranking Member 1
H001068,HSII H001068 HSII Jared Huffman minority Ranking Member 1
A000381,HSII06 A000381 HSII06 Yassamin Ansari minority Ranking Member 1
N000191,HSII10 N000191 HSII10 Joe Neguse minority Ranking Member 1
H001094,HSII13 H001094 HSII13 Val T. Hoyle minority Ranking Member 1
D000635,HSII15 D000635 HSII15 Maxine Dexter minority Ranking Member 1
L000273,HSII24 L000273 HSII24 Teresa Leger Fernandez minority Ranking Member 1
R000606,HSJU R000606 HSJU Jamie Raskin minority Ranking Member 1
J000298,HSJU01 J000298 HSJU01 Pramila Jayapal minority Ranking Member 1
J000288,HSJU03 J000288 HSJU03 Henry C. "Hank" Johnson, Jr. minority Ranking Member 1
N000002,HSJU05 N000002 HSJU05 Jerrold Nadler minority Ranking Member 1
M001208,HSJU08 M001208 HSJU08 Lucy McBath minority Ranking Member 1
S001205,HSJU10 S001205 HSJU10 Mary Gay Scanlon minority Ranking Member 1
C001130,HSJU13 C001130 HSJU13 Jasmine Crockett minority Ranking Member 1
L000560,HSPW L000560 HSPW Rick Larsen minority Ranking Member 1
W000808,HSPW02 W000808 HSPW02 Frederica S. Wilson minority Ranking Member 1
C001072,HSPW05 C001072 HSPW05 André Carson minority Ranking Member 1
C001112,HSPW07 C001112 HSPW07 Salud O. Carbajal minority Ranking Member 1
N000147,HSPW12 N000147 HSPW12 Eleanor Holmes Norton minority Ranking Member 1
S001211,HSPW13 S001211 HSPW13 Greg Stanton minority Ranking Member 1

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