hearing_members

Committee members present at hearings.

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

10 rows where package_id = "CHRG-87jhrg64846p2" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-87jhrg64846p2,Claiborne Pell Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Claiborne Pell committee member P000193
CHRG-87jhrg64846p2,Henry S. Reuss Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Henry S. Reuss committee member R000165
CHRG-87jhrg64846p2,Jacob K. Javits Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Jacob K. Javits committee member J000064
CHRG-87jhrg64846p2,James Fulbright Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 James Fulbright committee member F000400
CHRG-87jhrg64846p2,John J. Sparkman Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 John J. Sparkman committee member S000701
CHRG-87jhrg64846p2,Martha W. Griffiths Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Martha W. Griffiths committee member G000471
CHRG-87jhrg64846p2,Richard Bolling Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Richard Bolling committee member B000605
CHRG-87jhrg64846p2,William B. Widnall Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 William B. Widnall committee member W000445
CHRG-87jhrg64846p2,William Proxmire Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 William Proxmire committee member P000553
CHRG-87jhrg64846p2,Wright Patman Government price statistics. Part 2: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p2 Wright Patman committee member  

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