hearing_members

Committee members present at hearings.

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

24 rows where package_id = "CHRG-92hhrg85525p3" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-92hhrg85525p3,Albert W. Johnson Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Albert W. Johnson committee member J000114
CHRG-92hhrg85525p3,Bill Chappell Jr. Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Bill Chappell Jr. committee member  
CHRG-92hhrg85525p3,Charles H. Wilson Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Charles H. Wilson committee member W000570
CHRG-92hhrg85525p3,David N. Henderson Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 David N. Henderson committee member H000478
CHRG-92hhrg85525p3,Dominick V. Daniels Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Dominick V. Daniels committee member D000041
CHRG-92hhrg85525p3,Edward J. Derwinski Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Edward J. Derwinski committee member D000269
CHRG-92hhrg85525p3,Elwood H. Hillis Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Elwood H. Hillis committee member H000624
CHRG-92hhrg85525p3,Frank Brasco Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Frank Brasco committee member B000771
CHRG-92hhrg85525p3,H. R. Gross Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 H. R. Gross committee member  
CHRG-92hhrg85525p3,James A. McClure Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 James A. McClure committee member M000346
CHRG-92hhrg85525p3,James M. Hanley Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 James M. Hanley committee member H000158
CHRG-92hhrg85525p3,Jerome R. Waldie Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Jerome R. Waldie committee member W000035
CHRG-92hhrg85525p3,John H. Rousselot Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 John H. Rousselot committee member R000469
CHRG-92hhrg85525p3,Lawrence J. Hogan Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Lawrence J. Hogan committee member H000692
CHRG-92hhrg85525p3,Lee H. Hamilton Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Lee H. Hamilton committee member H000114
CHRG-92hhrg85525p3,Morris K. Udall Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Morris K. Udall committee member U000001
CHRG-92hhrg85525p3,Richard C. White Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Richard C. White committee member W000390
CHRG-92hhrg85525p3,Richard W. Mallary Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Richard W. Mallary committee member M000078
CHRG-92hhrg85525p3,Robert N. C. Nix Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Robert N. C. Nix committee member  
CHRG-92hhrg85525p3,Thaddeus J. Dulski Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Thaddeus J. Dulski committee member D000523
CHRG-92hhrg85525p3,Walter E. Powell Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 Walter E. Powell committee member P000485
CHRG-92hhrg85525p3,William D. Ford Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 William D. Ford committee member F000269
CHRG-92hhrg85525p3,William Lloyd Scott Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 William Lloyd Scott committee member S000187
CHRG-92hhrg85525p3,William O. Mills Review of administration of Federal employees' health benefits program. Part 3: Hearings, Ninety-second Congress, first [and second] session[s]. CHRG-92hhrg85525p3 William O. Mills committee member M000779

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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);