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-105hhrg51104" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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