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

18 rows where package_id = "CHRG-105hhrg52104" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
1572 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Anna Marie Crook   State Representative STATE REPRESENTATIVE  
1582 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Bill Moore   New Mexico Department of Agriculture, Las Cruces, New Mexico NEW MEXICO DEPARTMENT OF AGRICULTURE, LAS CRUCES, NEW MEXICO  
1576 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Bob Frost President New Mexico Cattle Growers Association NEW MEXICO CATTLE GROWERS ASSOCIATION  
1580 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Bobbie Mallory   State Representative STATE REPRESENTATIVE  
1574 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Bud Eppers Chairman New Mexico Public Lands Council, Roswell, New Mexico NEW MEXICO PUBLIC LANDS COUNCIL, ROSWELL, NEW MEXICO  
1571 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Caren Cowan   New Mexico Cattle Growers NEW MEXICO CATTLE GROWERS  
1577 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Carl Hahn        
1575 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Dr. John Fowler Professor of Agricultural Economics New Mexico State University, Las Cruces, New Mexico NEW MEXICO STATE UNIVERSITY, LAS CRUCES, NEW MEXICO  
1578 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Hon. Stuart Ingle   New Mexico State Senator, Portales, New Mexico NEW MEXICO STATE SENATOR, PORTALES, NEW MEXICO  
1569 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Hon. Walter Bradley Lieutenant Governor State of New Mexico, Santa Fe, New Mexico, as read by Mr. Dennis Roche STATE OF NEW MEXICO, SANTA FE, NEW MEXICO, AS READ BY MR. DENNIS ROCHE  
1586 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 John C. Williams General Manager Canadian River Municipal Water Authority CANADIAN RIVER MUNICIPAL WATER AUTHORITY  
1581 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Karen Mitchell        
1573 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Lewis Derrick        
1583 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Manuel Pacheco   Northern New Mexico Stockmen's Association, Taos, New Mexico NORTHERN NEW MEXICO STOCKMEN'S ASSOCIATION, TAOS, NEW MEXICO  
1584 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Mr. Hoyt Pattison   New Mexico Interstate Stream Commission, Clovis, New Mexico NEW MEXICO INTERSTATE STREAM COMMISSION, CLOVIS, NEW MEXICO  
1570 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Ms. Karen Budd-Falen Counsel New Mexico Cattle Growers Association, Cheyenne, Wyoming NEW MEXICO CATTLE GROWERS ASSOCIATION, CHEYENNE, WYOMING  
1579 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Sharon Lombardi Executive Director of Dairy Producers of New Mexico      
1585 HEARING ON THE ENDANGERED SPECIES ACT CHRG-105hhrg52104 Tom Payne        

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;