hearing_members

Committee members present at hearings.

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

7 rows where package_id = "CHRG-87jhrg64846p1" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-87jhrg64846p1,Henry S. Reuss Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 Henry S. Reuss committee member R000165
CHRG-87jhrg64846p1,Jacob K. Javits Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 Jacob K. Javits committee member J000064
CHRG-87jhrg64846p1,James Fulbright Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 James Fulbright committee member F000400
CHRG-87jhrg64846p1,John J. Sparkman Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 John J. Sparkman committee member S000701
CHRG-87jhrg64846p1,Richard Bolling Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 Richard Bolling committee member B000605
CHRG-87jhrg64846p1,William B. Widnall Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 William B. Widnall committee member W000445
CHRG-87jhrg64846p1,Wright Patman Government price statistics. Part 1: hearings before the Subcommittee on Economic Statistics of the Joint Economic Committee, Congress of the United States. CHRG-87jhrg64846p1 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);