hearing_members

Committee members present at hearings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

17 rows where package_id = "CHRG-97shrg83938O" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-97shrg83938O,Barry Goldwater Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Barry Goldwater committee member G000267
CHRG-97shrg83938O,Carl Levin Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Carl Levin committee member L000261
CHRG-97shrg83938O,Dan Quayle Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Dan Quayle committee member  
CHRG-97shrg83938O,Gary W. Hart Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Gary W. Hart committee member H000287
CHRG-97shrg83938O,Gordon J. Humphrey Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Gordon J. Humphrey committee member H000951
CHRG-97shrg83938O,Harry F. Byrd Jr. Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Harry F. Byrd Jr. committee member  
CHRG-97shrg83938O,Henry M. Jackson Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Henry M. Jackson committee member J000013
CHRG-97shrg83938O,Howard W. Cannon Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Howard W. Cannon committee member C000120
CHRG-97shrg83938O,J. James Exon Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O J. James Exon committee member E000284
CHRG-97shrg83938O,Jeremiah Denton Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Jeremiah Denton committee member D000259
CHRG-97shrg83938O,John C. Stennis Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O John C. Stennis committee member S000852
CHRG-97shrg83938O,John G. Tower Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O John G. Tower committee member T000322
CHRG-97shrg83938O,John Warner Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O John Warner committee member W000153
CHRG-97shrg83938O,Roger W. Jepsen Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Roger W. Jepsen committee member J000101
CHRG-97shrg83938O,Sam Nunn Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Sam Nunn committee member  
CHRG-97shrg83938O,Strom Thurmond Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O Strom Thurmond committee member  
CHRG-97shrg83938O,William S. Cohen Nominations of Russell D. Hale, Herman E. Roser, George A. Sawyer, and Edward J. Philbin: hearing before the Committee on Armed Services, United States Senate, Ninety-seventh Congress, first session, on nominations of Russell D. Hale, of Virginia, to be an assistant secretary of the Air Force, Herman E. Roser, of New Mexico, to be an assistant secretary of energy (defense programs), George A. Sawyer, of New Jersey, to be assistant secretary of the Navy, Edward J. Philbin, of California, to be duputy assistant secretary of defense for reserve affairs, June 11, 1981. CHRG-97shrg83938O William S. Cohen committee member C000599

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_members (
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT NOT NULL,
    role TEXT,
    bioguide_id TEXT,
    PRIMARY KEY (package_id, name)
);
CREATE INDEX idx_hm_name ON hearing_members(name);
CREATE INDEX idx_hm_bioguide ON hearing_members(bioguide_id);