committee_memberships
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
118 rows where title = "Ex Officio" sorted by committee_id
This data as json, CSV (advanced)
Suggested facets: bioguide_id, member_name, rank
| Link | bioguide_id | committee_id ▼ | member_name | party | title | rank |
|---|---|---|---|---|---|---|
| T000250,SLIN | T000250 | SLIN | John Thune | majority | Ex Officio | 10 |
| W000437,SLIN | W000437 | SLIN | Roger F. Wicker | majority | Ex Officio | 11 |
| R000122,SLIN | R000122 | SLIN | Jack Reed | minority | Ex Officio | 9 |
| S000148,SLIN | S000148 | SLIN | Charles E. Schumer | minority | Ex Officio | 10 |
| B001236,SSAF13 | B001236 | SSAF13 | John Boozman | majority | Ex Officio | 7 |
| K000367,SSAF13 | K000367 | SSAF13 | Amy Klobuchar | minority | Ex Officio | 6 |
| B001236,SSAF14 | B001236 | SSAF14 | John Boozman | majority | Ex Officio | 7 |
| K000367,SSAF14 | K000367 | SSAF14 | Amy Klobuchar | minority | Ex Officio | 6 |
| B001236,SSAF15 | B001236 | SSAF15 | John Boozman | majority | Ex Officio | 7 |
| K000367,SSAF15 | K000367 | SSAF15 | Amy Klobuchar | minority | Ex Officio | 6 |
| B001236,SSAF16 | B001236 | SSAF16 | John Boozman | majority | Ex Officio | 7 |
| K000367,SSAF16 | K000367 | SSAF16 | Amy Klobuchar | minority | Ex Officio | 6 |
| B001236,SSAF17 | B001236 | SSAF17 | John Boozman | majority | Ex Officio | 7 |
| K000367,SSAF17 | K000367 | SSAF17 | Amy Klobuchar | minority | Ex Officio | 6 |
| M001111,SSAP01 | M001111 | SSAP01 | Patty Murray | minority | Ex Officio | 8 |
| C001035,SSAP08 | C001035 | SSAP08 | Susan M. Collins | majority | Ex Officio | 4 |
| M001111,SSAP08 | M001111 | SSAP08 | Patty Murray | minority | Ex Officio | 3 |
| C001035,SSAP14 | C001035 | SSAP14 | Susan M. Collins | majority | Ex Officio | 7 |
| M001111,SSAP16 | M001111 | SSAP16 | Patty Murray | minority | Ex Officio | 9 |
| C001035,SSAP17 | C001035 | SSAP17 | Susan M. Collins | majority | Ex Officio | 8 |
| M001111,SSAP17 | M001111 | SSAP17 | Patty Murray | minority | Ex Officio | 7 |
| C001035,SSAP18 | C001035 | SSAP18 | Susan M. Collins | majority | Ex Officio | 10 |
| C001035,SSAP20 | C001035 | SSAP20 | Susan M. Collins | majority | Ex Officio | 8 |
| M001111,SSAP20 | M001111 | SSAP20 | Patty Murray | minority | Ex Officio | 7 |
| C001035,SSAP22 | C001035 | SSAP22 | Susan M. Collins | majority | Ex Officio | 10 |
| M001111,SSAP23 | M001111 | SSAP23 | Patty Murray | minority | Ex Officio | 5 |
| W000437,SSAS13 | W000437 | SSAS13 | Roger F. Wicker | majority | Ex Officio | 7 |
| R000122,SSAS13 | R000122 | SSAS13 | Jack Reed | minority | Ex Officio | 6 |
| W000437,SSAS14 | W000437 | SSAS14 | Roger F. Wicker | majority | Ex Officio | 8 |
| R000122,SSAS14 | R000122 | SSAS14 | Jack Reed | minority | Ex Officio | 7 |
| W000437,SSAS15 | W000437 | SSAS15 | Roger F. Wicker | majority | Ex Officio | 7 |
| R000122,SSAS15 | R000122 | SSAS15 | Jack Reed | minority | Ex Officio | 6 |
| W000437,SSAS16 | W000437 | SSAS16 | Roger F. Wicker | majority | Ex Officio | 7 |
| R000122,SSAS16 | R000122 | SSAS16 | Jack Reed | minority | Ex Officio | 6 |
| W000437,SSAS17 | W000437 | SSAS17 | Roger F. Wicker | majority | Ex Officio | 6 |
| R000122,SSAS17 | R000122 | SSAS17 | Jack Reed | minority | Ex Officio | 5 |
| W000437,SSAS20 | W000437 | SSAS20 | Roger F. Wicker | majority | Ex Officio | 9 |
| R000122,SSAS20 | R000122 | SSAS20 | Jack Reed | minority | Ex Officio | 8 |
| W000437,SSAS21 | W000437 | SSAS21 | Roger F. Wicker | majority | Ex Officio | 6 |
| R000122,SSAS21 | R000122 | SSAS21 | Jack Reed | minority | Ex Officio | 5 |
| S001184,SSBK04 | S001184 | SSBK04 | Tim Scott | majority | Ex Officio | 9 |
| W000817,SSBK04 | W000817 | SSBK04 | Elizabeth Warren | minority | Ex Officio | 8 |
| S001184,SSBK05 | S001184 | SSBK05 | Tim Scott | majority | Ex Officio | 5 |
| W000817,SSBK05 | W000817 | SSBK05 | Elizabeth Warren | minority | Ex Officio | 4 |
| S001184,SSBK08 | S001184 | SSBK08 | Tim Scott | majority | Ex Officio | 9 |
| W000817,SSBK08 | W000817 | SSBK08 | Elizabeth Warren | minority | Ex Officio | 8 |
| S001184,SSBK09 | S001184 | SSBK09 | Tim Scott | majority | Ex Officio | 7 |
| W000817,SSBK09 | W000817 | SSBK09 | Elizabeth Warren | minority | Ex Officio | 6 |
| S001184,SSBK12 | S001184 | SSBK12 | Tim Scott | majority | Ex Officio | 6 |
| W000817,SSBK12 | W000817 | SSBK12 | Elizabeth Warren | minority | Ex Officio | 5 |
| S001184,SSBK13 | S001184 | SSBK13 | Tim Scott | majority | Ex Officio | 6 |
| W000817,SSBK13 | W000817 | SSBK13 | Elizabeth Warren | minority | Ex Officio | 5 |
| C001098,SSCM33 | C001098 | SSCM33 | Ted Cruz | majority | Ex Officio | 7 |
| C000127,SSCM33 | C000127 | SSCM33 | Maria Cantwell | minority | Ex Officio | 6 |
| C001098,SSCM34 | C001098 | SSCM34 | Ted Cruz | majority | Ex Officio | 15 |
| C000127,SSCM34 | C000127 | SSCM34 | Maria Cantwell | minority | Ex Officio | 13 |
| C001098,SSCM35 | C001098 | SSCM35 | Ted Cruz | majority | Ex Officio | 9 |
| C000127,SSCM35 | C000127 | SSCM35 | Maria Cantwell | minority | Ex Officio | 8 |
| C001098,SSCM36 | C001098 | SSCM36 | Ted Cruz | majority | Ex Officio | 6 |
| C000127,SSCM36 | C000127 | SSCM36 | Maria Cantwell | minority | Ex Officio | 5 |
| C001098,SSCM37 | C001098 | SSCM37 | Ted Cruz | majority | Ex Officio | 7 |
| C000127,SSCM37 | C000127 | SSCM37 | Maria Cantwell | minority | Ex Officio | 6 |
| C001098,SSCM38 | C001098 | SSCM38 | Ted Cruz | majority | Ex Officio | 9 |
| C000127,SSCM38 | C000127 | SSCM38 | Maria Cantwell | minority | Ex Officio | 8 |
| L000577,SSEG01 | L000577 | SSEG01 | Mike Lee | majority | Ex Officio | 9 |
| H001046,SSEG01 | H001046 | SSEG01 | Martin Heinrich | minority | Ex Officio | 8 |
| L000577,SSEG03 | L000577 | SSEG03 | Mike Lee | majority | Ex Officio | 8 |
| H001046,SSEG03 | H001046 | SSEG03 | Martin Heinrich | minority | Ex Officio | 7 |
| L000577,SSEG04 | L000577 | SSEG04 | Mike Lee | majority | Ex Officio | 5 |
| H001046,SSEG04 | H001046 | SSEG04 | Martin Heinrich | minority | Ex Officio | 4 |
| L000577,SSEG07 | L000577 | SSEG07 | Mike Lee | majority | Ex Officio | 7 |
| H001046,SSEG07 | H001046 | SSEG07 | Martin Heinrich | minority | Ex Officio | 6 |
| C001047,SSEV08 | C001047 | SSEV08 | Shelley Moore Capito | majority | Ex Officio | 9 |
| W000802,SSEV08 | W000802 | SSEV08 | Sheldon Whitehouse | minority | Ex Officio | 8 |
| C001047,SSEV09 | C001047 | SSEV09 | Shelley Moore Capito | majority | Ex Officio | 6 |
| W000802,SSEV09 | W000802 | SSEV09 | Sheldon Whitehouse | minority | Ex Officio | 5 |
| C001047,SSEV10 | C001047 | SSEV10 | Shelley Moore Capito | majority | Ex Officio | 9 |
| W000802,SSEV10 | W000802 | SSEV10 | Sheldon Whitehouse | minority | Ex Officio | 8 |
| C001047,SSEV15 | C001047 | SSEV15 | Shelley Moore Capito | majority | Ex Officio | 7 |
| W000802,SSEV15 | W000802 | SSEV15 | Sheldon Whitehouse | minority | Ex Officio | 6 |
| C000880,SSFI02 | C000880 | SSFI02 | Mike Crapo | majority | Ex Officio | 4 |
| W000779,SSFI02 | W000779 | SSFI02 | Ron Wyden | minority | Ex Officio | 3 |
| C000880,SSFI10 | C000880 | SSFI10 | Mike Crapo | majority | Ex Officio | 12 |
| W000779,SSFI10 | W000779 | SSFI10 | Ron Wyden | minority | Ex Officio | 11 |
| C000880,SSFI11 | C000880 | SSFI11 | Mike Crapo | majority | Ex Officio | 10 |
| W000779,SSFI11 | W000779 | SSFI11 | Ron Wyden | minority | Ex Officio | 9 |
| C000880,SSFI12 | C000880 | SSFI12 | Mike Crapo | majority | Ex Officio | 7 |
| W000779,SSFI12 | W000779 | SSFI12 | Ron Wyden | minority | Ex Officio | 6 |
| C000880,SSFI13 | C000880 | SSFI13 | Mike Crapo | majority | Ex Officio | 9 |
| W000779,SSFI13 | W000779 | SSFI13 | Ron Wyden | minority | Ex Officio | 8 |
| C000880,SSFI14 | C000880 | SSFI14 | Mike Crapo | majority | Ex Officio | 3 |
| W000779,SSFI14 | W000779 | SSFI14 | Ron Wyden | minority | Ex Officio | 2 |
| R000584,SSFR01 | R000584 | SSFR01 | James E. Risch | majority | Ex Officio | 6 |
| S001181,SSFR01 | S001181 | SSFR01 | Jeanne Shaheen | minority | Ex Officio | 5 |
| R000584,SSFR02 | R000584 | SSFR02 | James E. Risch | majority | Ex Officio | 6 |
| S001181,SSFR02 | S001181 | SSFR02 | Jeanne Shaheen | minority | Ex Officio | 5 |
| R000584,SSFR06 | R000584 | SSFR06 | James E. Risch | majority | Ex Officio | 6 |
| S001181,SSFR06 | S001181 | SSFR06 | Jeanne Shaheen | minority | Ex Officio | 5 |
| R000584,SSFR07 | R000584 | SSFR07 | James E. Risch | majority | Ex Officio | 6 |
| S001181,SSFR07 | S001181 | SSFR07 | Jeanne Shaheen | minority | Ex Officio | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);