hearing_members

Committee members present at hearings.

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

14 rows where package_id = "CHRG-88hhrg39554add" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-88hhrg39554add,Ancher Nelsen Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Ancher Nelsen committee member N000028
CHRG-88hhrg39554add,Donald G. Brotzman Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Donald G. Brotzman committee member B000893
CHRG-88hhrg39554add,Fred B. Rooney Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Fred B. Rooney committee member  
CHRG-88hhrg39554add,Gillis W. Long Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Gillis W. Long committee member L000417
CHRG-88hhrg39554add,Harley O. Staggers Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Harley O. Staggers committee member S000778
CHRG-88hhrg39554add,J. J. Pickle Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add J. J. Pickle committee member  
CHRG-88hhrg39554add,James T. Broyhill Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add James T. Broyhill committee member B000966
CHRG-88hhrg39554add,John D. Dingell Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add John D. Dingell committee member D000355
CHRG-88hhrg39554add,John E. Moss Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add John E. Moss committee member M001036
CHRG-88hhrg39554add,John Jarman Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add John Jarman committee member J000057
CHRG-88hhrg39554add,Lionel Van Deerlin Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Lionel Van Deerlin committee member V000024
CHRG-88hhrg39554add,Paul G. Rogers Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Paul G. Rogers committee member R000401
CHRG-88hhrg39554add,Samuel L. Devine Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Samuel L. Devine committee member D000279
CHRG-88hhrg39554add,Torbert H. Macdonald Cigarette labeling and advertising: Addendum to Hearings held June 23,24,25,29, and July 2. 1964, on bills regulating the labeling and advertising of cigarettes and relating to health problems associated with smoking CHRG-88hhrg39554add Torbert H. Macdonald committee member M000005

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