hearing_witnesses

Witnesses who testified at committee hearings, with parsed name, title, organization, and location.

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

29 rows where package_id = "CHRG-105hhrg51104" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
1345 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Bill Wright        
1341 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Brian Sanford        
1332 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Bruce Klinekole   Mescalero Apache Cattle Growers Association, Mescalero, New Mexico MESCALERO APACHE CATTLE GROWERS ASSOCIATION, MESCALERO, NEW MEXICO  
1328 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Bud Eppers        
1326 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Caren Cowan Executive Secretary New Mexico Cattle Growers, Albuquerque, New Mexico NEW MEXICO CATTLE GROWERS, ALBUQUERQUE, NEW MEXICO  
1342 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Carl Smith        
1320 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Charlie Chacon        
1321 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Claudio Chacon        
1324 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 David Cordova        
1340 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 David Sanchez        
1327 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 De Vargas   Ike, La Madera, New Mexico IKE, LA MADERA, NEW MEXICO  
1319 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Dennis Braden        
1343 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Ernest Torrez        
1329 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Gabe Estrada   Rancher, Las Vegas, New Mexico RANCHER, LAS VEGAS, NEW MEXICO  
1322 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Gerald Chacon District Director, Cooperative Extension Service Permittee, Santa Fe, New Mexico PERMITTEE, SANTA FE, NEW MEXICO  
1344 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Jake M. Vigil   Tres Piedras Carson National Forest District, El Rito, New Mexico TRES PIEDRAS CARSON NATIONAL FOREST DISTRICT, EL RITO, NEW MEXICO  
1330 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Jimmie Hall President Production Credit Association of New Mexico PRODUCTION CREDIT ASSOCIATION OF NEW MEXICO  
1331 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 John Horning Executive Director Forest Guardians, Santa Fe, New Mexico FOREST GUARDIANS, SANTA FE, NEW MEXICO  
1325 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Max Cordova President Truchas Land Grant Association, Chimayo, New Mexico TRUCHAS LAND GRANT ASSOCIATION, CHIMAYO, NEW MEXICO  
1337 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Moises Morales        
1335 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Palemon Martinez Secretary Northern New Mexico Stockmen's Association NORTHERN NEW MEXICO STOCKMEN'S ASSOCIATION  
1318 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Paul Bandy        
1323 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Porfirio Cisneros        
1338 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 R. C Posey        
1334 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Richard Lucero   Mayor, Espanola, New Mexico MAYOR, ESPANOLA, NEW MEXICO  
1333 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Robert Luce General Counsel Rio Grande Forest Products, Inc., Espanola, New Mexico RIO GRANDE FOREST PRODUCTS, INC., ESPANOLA, NEW MEXICO  
1317 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Sylvia Allen Arizona-New Mexico Field Director People for the USA PEOPLE FOR THE USA  
1339 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 Warren Reed        
1336 FOREST SERVICE MANAGEMENT OF THE NATIONAL FORESTS IN NORTHERN NEW MEXICO CHRG-105hhrg51104 William Moore        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_witnesses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT,
    title TEXT,
    organization TEXT,
    organization_normalized TEXT,
    location TEXT
);
CREATE INDEX idx_hw_package ON hearing_witnesses(package_id);
CREATE INDEX idx_hw_name ON hearing_witnesses(name);
CREATE INDEX idx_hw_org ON hearing_witnesses(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_hw_org_norm ON hearing_witnesses(organization_normalized) WHERE organization_normalized IS NOT NULL;