hearing_members

Committee members present at hearings.

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

15 rows where package_id = "CHRG-91shrg49480O" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-91shrg49480O,Daniel K. Inouye Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Daniel K. Inouye committee member I000025
CHRG-91shrg49480O,Ernest F. Hollings Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Ernest F. Hollings committee member H000725
CHRG-91shrg49480O,Frank E. Moss Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Frank E. Moss committee member M001033
CHRG-91shrg49480O,Howard H. Baker Jr. Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Howard H. Baker Jr. committee member  
CHRG-91shrg49480O,Howard W. Cannon Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Howard W. Cannon committee member C000120
CHRG-91shrg49480O,Hugh Scott Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Hugh Scott committee member S000174
CHRG-91shrg49480O,James B. Pearson Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O James B. Pearson committee member P000166
CHRG-91shrg49480O,John O. Pastore Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O John O. Pastore committee member P000100
CHRG-91shrg49480O,Marlow W. Cook Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Marlow W. Cook committee member C000721
CHRG-91shrg49480O,Norris Cotton Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Norris Cotton committee member C000802
CHRG-91shrg49480O,Philip A. Hart Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Philip A. Hart committee member H000291
CHRG-91shrg49480O,Robert P. Griffin Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Robert P. Griffin committee member G000465
CHRG-91shrg49480O,Russell B. Long Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Russell B. Long committee member L000428
CHRG-91shrg49480O,Vance Hartke Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Vance Hartke committee member  
CHRG-91shrg49480O,Warren G. Magnuson Regulation of trade in drugs: hearings before the Consumer Subcommittee of the Committee on Commerce, United States Senate, Ninety-first Congress, second session, on S. 1575, to regulate trade in drugs and devices by prohibiting the dispensing of drugs or devices by medical practitioners and their participation in profits from the dispensing of such products, except under certain circumstances, and for other purposes, June 16 and 17, 1970. CHRG-91shrg49480O Warren G. Magnuson committee member M000053

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);