hearing_members

Committee members present at hearings.

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

16 rows where package_id = "CHRG-93shrg41809Op4" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-93shrg41809Op4,Alan Cranston Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Alan Cranston committee member C000877
CHRG-93shrg41809Op4,Claiborne Pell Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Claiborne Pell committee member P000193
CHRG-93shrg41809Op4,Edward M. Kennedy Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Edward M. Kennedy committee member K000105
CHRG-93shrg41809Op4,Gaylord Nelson Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Gaylord Nelson committee member N000033
CHRG-93shrg41809Op4,Harold E. Hughes Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Harold E. Hughes committee member H000922
CHRG-93shrg41809Op4,Harrison A. Williams Jr. Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Harrison A. Williams Jr. committee member  
CHRG-93shrg41809Op4,J. Glenn Beall Jr. Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 J. Glenn Beall Jr. committee member  
CHRG-93shrg41809Op4,Jacob K. Javits Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Jacob K. Javits committee member J000064
CHRG-93shrg41809Op4,Jennings Randolph Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Jennings Randolph committee member R000046
CHRG-93shrg41809Op4,Peter H. Dominick Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Peter H. Dominick committee member D000409
CHRG-93shrg41809Op4,Richard S. Schweiker Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Richard S. Schweiker committee member S000159
CHRG-93shrg41809Op4,Robert T. Stafford Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Robert T. Stafford committee member S000776
CHRG-93shrg41809Op4,Robert Taft Jr. Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Robert Taft Jr. committee member  
CHRG-93shrg41809Op4,Thomas F. Eagleton Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Thomas F. Eagleton committee member E000004
CHRG-93shrg41809Op4,Walter F. Mondale Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 Walter F. Mondale committee member M000851
CHRG-93shrg41809Op4,William D. Hathaway Children's Charities, 1974. Part 4: Hearings before the Subcommittee on Children and Youth of the Committee on Labor and Public Welfare, United States Senate, Ninety-third Congress, second session, on examination of the kind of services children receive through charity, how charities obtain funds from the public, and how much they spend on fundraising, general management, and program services. October 10, 1974. CHRG-93shrg41809Op4 William D. Hathaway committee member H000346

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