hearing_members

Committee members present at hearings.

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

44 rows where package_id = "CHRG-105hhrg50754" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-105hhrg50754,Adam Smith H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Adam Smith committee member S000510
CHRG-105hhrg50754,Barbara Cubin H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Barbara Cubin committee member C000962
CHRG-105hhrg50754,Bill Delahunt H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Bill Delahunt committee member  
CHRG-105hhrg50754,Bob Schaffer H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Bob Schaffer committee member S000112
CHRG-105hhrg50754,Bruce F. Vento H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Bruce F. Vento committee member V000087
CHRG-105hhrg50754,Calvin M. Dooley H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Calvin M. Dooley committee member D000424
CHRG-105hhrg50754,Chris Cannon H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Chris Cannon committee member  
CHRG-105hhrg50754,Christopher John H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Christopher John committee member J000110
CHRG-105hhrg50754,Dale E. Kildee H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Dale E. Kildee committee member K000172
CHRG-105hhrg50754,Don Young H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Don Young committee member Y000033
CHRG-105hhrg50754,Edward J. Markey H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Edward J. Markey committee member M000133
CHRG-105hhrg50754,Elton Gallegly H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Elton Gallegly committee member G000021
CHRG-105hhrg50754,Frank Pallone, Jr. H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Frank Pallone, Jr. committee member P000034
CHRG-105hhrg50754,George Miller H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 George Miller committee member M000725
CHRG-105hhrg50754,George Radanovich H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 George Radanovich committee member R000004
CHRG-105hhrg50754,Helen Chenoweth-Hage H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Helen Chenoweth-Hage committee member C000345
CHRG-105hhrg50754,James V. Hansen H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 James V. Hansen committee member H000172
CHRG-105hhrg50754,Jim Gibbons H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Jim Gibbons committee member  
CHRG-105hhrg50754,Jim Saxton H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Jim Saxton committee member  
CHRG-105hhrg50754,Joel Hefley H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Joel Hefley committee member H000444
CHRG-105hhrg50754,John B. Shadegg H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 John B. Shadegg committee member S000275
CHRG-105hhrg50754,John E. Peterson H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 John E. Peterson committee member P000262
CHRG-105hhrg50754,John Ensign H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 John Ensign committee member E000194
CHRG-105hhrg50754,John J. Duncan, Jr. H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 John J. Duncan, Jr. committee member D000533
CHRG-105hhrg50754,John T. Doolittle H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 John T. Doolittle committee member D000429
CHRG-105hhrg50754,Ken Calvert H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Ken Calvert committee member C000059
CHRG-105hhrg50754,Kevin Brady H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Kevin Brady committee member B000755
CHRG-105hhrg50754,Linda Smith H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Linda Smith committee member S000587
CHRG-105hhrg50754,Lloyd Doggett H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Lloyd Doggett committee member D000399
CHRG-105hhrg50754,Mac Thornberry H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Mac Thornberry committee member T000238
CHRG-105hhrg50754,Maurice D. Hinchey H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Maurice D. Hinchey committee member H000627
CHRG-105hhrg50754,Mike Crapo H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Mike Crapo committee member C000880
CHRG-105hhrg50754,Neil Abercrombie H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Neil Abercrombie committee member A000014
CHRG-105hhrg50754,Nick J. Rahall II H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Nick J. Rahall II committee member R000011
CHRG-105hhrg50754,Owen B. Pickett H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Owen B. Pickett committee member P000326
CHRG-105hhrg50754,Patrick J. Kennedy H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Patrick J. Kennedy committee member K000113
CHRG-105hhrg50754,Peter A. DeFazio H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Peter A. DeFazio committee member D000191
CHRG-105hhrg50754,Richard W. Pombo H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Richard W. Pombo committee member P000419
CHRG-105hhrg50754,Rick Hill H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Rick Hill committee member H000605
CHRG-105hhrg50754,Robert Smith H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Robert Smith committee member S000604
CHRG-105hhrg50754,Ron Kind H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Ron Kind committee member K000188
CHRG-105hhrg50754,Sam Farr H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Sam Farr committee member F000030
CHRG-105hhrg50754,Solomon P. Ortiz H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Solomon P. Ortiz committee member O000107
CHRG-105hhrg50754,Wayne T. Gilchrest H.R. 3478, AND H.R. 745 CHRG-105hhrg50754 Wayne T. Gilchrest committee member G000180

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