openregs: hearing_members: 7 rows where package_id = "CHRG-87jhrg90999" sorted by name

Committee members present at hearings.

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

7 rows where package_id = "CHRG-87jhrg90999" sorted by name

descending

Link	package_id	name ▼	role	bioguide_id
CHRG-87jhrg90999,Chet Holifield	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	Chet Holifield	committee member
CHRG-87jhrg90999,Craig Hosmer	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	Craig Hosmer	committee member	H000802
CHRG-87jhrg90999,George Aiken	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	George Aiken	committee member	A000062
CHRG-87jhrg90999,Henry M. Jackson	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	Henry M. Jackson	committee member	J000013
CHRG-87jhrg90999,John O. Pastore	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	John O. Pastore	committee member	P000100
CHRG-87jhrg90999,Melvin Price	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	Melvin Price	committee member
CHRG-87jhrg90999,Wallace F. Bennett	United States policy toward the International Atomic Energy Agency. hearing before the Joint Committee on Atomic Energy, Congress of the United States, Eighty-seventh Congress, second session, on the United States policy toward the international atomic energy agency, August 2, 1962. CHRG-87jhrg90999	Wallace F. Bennett	committee member	B000384

Advanced export

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

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);
CREATE INDEX idx_hearing_members_bioguide ON hearing_members(bioguide_id);