hearing_members

Committee members present at hearings.

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

12 rows where package_id = "CHRG-87hhrg89097" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-87hhrg89097,Ancher Nelsen Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Ancher Nelsen committee member N000028
CHRG-87hhrg89097,Dan Rostenkowski Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Dan Rostenkowski committee member  
CHRG-87hhrg89097,Harley O. Staggers Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Harley O. Staggers committee member S000778
CHRG-87hhrg89097,Harold R. Collier Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Harold R. Collier committee member C000629
CHRG-87hhrg89097,John D. Dingell Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 John D. Dingell committee member D000355
CHRG-87hhrg89097,John E. Moss Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 John E. Moss committee member M001036
CHRG-87hhrg89097,John Jarman Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 John Jarman committee member J000057
CHRG-87hhrg89097,Paul G. Rogers Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Paul G. Rogers committee member R000401
CHRG-87hhrg89097,Peter H. Dominick Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Peter H. Dominick committee member D000409
CHRG-87hhrg89097,Samuel L. Devine Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Samuel L. Devine committee member D000279
CHRG-87hhrg89097,Torbert H. Macdonald Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Torbert H. Macdonald committee member M000005
CHRG-87hhrg89097,Vernon W. Thomson Fish protein concentrate: hearings before a subcommittee of the Committee on Interstate and Foreign Commerce, Eighty-seventh Congress, second session, on H.R. 9101, H.R. 9102, H.R. 9331, [and] H.R. 10587, bills to amend clause (3) of section 402 (a) of the Federal Food, Drug, and Cosmetic Act, August 8, 9, 1962. CHRG-87hhrg89097 Vernon W. Thomson committee member T000233

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