hearing_members

Committee members present at hearings.

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

9 rows where package_id = "CHRG-89shrg65451" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-89shrg65451,Alan Bible Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Alan Bible committee member B000436
CHRG-89shrg65451,Frank Church Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Frank Church committee member C000388
CHRG-89shrg65451,Frank E. Moss Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Frank E. Moss committee member M001033
CHRG-89shrg65451,Gaylord Nelson Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Gaylord Nelson committee member N000033
CHRG-89shrg65451,George McGovern Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 George McGovern committee member M000452
CHRG-89shrg65451,Henry M. Jackson Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Henry M. Jackson committee member J000013
CHRG-89shrg65451,Lee Metcalf Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Lee Metcalf committee member M000671
CHRG-89shrg65451,Paul J. Fannin Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Paul J. Fannin committee member F000013
CHRG-89shrg65451,Quentin N. Burdick Connecticut River Parkway and Recreation Area: hearing before the Subcommittee on Parks and Recreation of the Committee on Interior and Insular Affairs, United States Senate, Eighty-ninth Congress, second session on S. 2460 a bill to authorize the establishment of the Connecticut River National Parkway and Recreation Area, in the States of Connecticut, Massachusetts, Vermont, and New Hampshire, and for other purposes. May 20, 1966. CHRG-89shrg65451 Quentin N. Burdick committee member B001077

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