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-90shrg20207" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-90shrg20207,Albert Gore Jr. Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Albert Gore Jr. committee member  
CHRG-90shrg20207,Claiborne Pell Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Claiborne Pell committee member P000193
CHRG-90shrg20207,Clifford P. Case Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Clifford P. Case committee member C000220
CHRG-90shrg20207,Frank Church Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Frank Church committee member C000388
CHRG-90shrg20207,George Aiken Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 George Aiken committee member A000062
CHRG-90shrg20207,James Fulbright Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 James Fulbright committee member F000400
CHRG-90shrg20207,John J. Sparkman Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 John J. Sparkman committee member S000701
CHRG-90shrg20207,Mike Mansfield Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Mike Mansfield committee member  
CHRG-90shrg20207,Stuart Symington Nomination of James Russell Wiggins: hearing before the Committee on Foreign Relations, United States Senate, Ninetieth Congress, second session, on the nomination of James Russell Wiggins, to be the Representative of the United States of America to the United Nations with the rank and status of Ambassador Extraordinary and Plenipotentiary, and the Representative of the United States of America in the Security Council of the United Nations, September 30, 1968. CHRG-90shrg20207 Stuart Symington 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);