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

13 rows where package_id = "CHRG-105hhrg50836" 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
1229 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Benjamin Payton Office of the President Tuskegee University TUSKEGEE UNIVERSITY  
1230 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Bob Robinson President Canyon Ferry Recreation Association Cabin Site Acquisition Subcommittee CANYON FERRY RECREATION ASSOCIATION CABIN SITE ACQUISITION SUBCOMMITTEE  
1226 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Darrell Knuffke Vice President of Regional Conservation The Wilderness Society THE WILDERNESS SOCIETY  
1220 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Don Barger Southeast Regional Director National Parks and Conservation Association NATIONAL PARKS AND CONSERVATION ASSOCIATION  
1227 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Eluid Martinez Commissioner, Acting Regional Director Bureau of Reclamation, United States Department of the Interior; accompanied by Larry Todd, Great Plains Region, Bureau of Reclamation, United States Department of the Interior BUREAU OF RECLAMATION, UNITED STATES DEPARTMENT OF THE INTERIOR; ACCOMPANIED BY LARRY TODD, GREAT PLAINS REGION, BUREAU OF RECLAMATION, UNITED STATES DEPARTMENT OF THE INTERIOR  
1228 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Gregory Paxton President/CEO Georgia Trust for Historic Preservation GEORGIA TRUST FOR HISTORIC PRESERVATION  
1231 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Jack Sautter   Chairperson, Broadwater Lake and Stream Committee, Townsend, Montana, prepared statement of CHAIRPERSON, BROADWATER LAKE AND STREAM COMMITTEE, TOWNSEND, MONTANA, PREPARED STATEMENT OF  
1225 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Jane Morton Galetto President Citizens United to Protect the Maurice River and its Tributaries, Inc CITIZENS UNITED TO PROTECT THE MAURICE RIVER AND ITS TRIBUTARIES, INC  
1223 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Jerry Fischer President/CEO Yosemite Motels YOSEMITE MOTELS  
1232 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Katherine Stevenson Associate Director, National Park Service Cultural Resources Stewardship and Partnerships, Department of the Interior CULTURAL RESOURCES STEWARDSHIP AND PARTNERSHIPS, DEPARTMENT OF THE INTERIOR  
1222 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Thomas Budewitz representing the Board of Commissioners Attorney, Broadwater County, Montana ATTORNEY, BROADWATER COUNTY, MONTANA  
1224 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Tom Fry Deputy Director Bureau of Land Management BUREAU OF LAND MANAGEMENT  
1221 HEARING ON H.R. 3963, H.R. 2125, H.R. 3950, H.R. 4144, H.R. 4211, H.R. 4230, AND H.R. 4287 CHRG-105hhrg50836 Virgil Binkley President, Board Member, Member Broadwater Rod and Gun Club, Canyon Ferry Fishing Association, Broadwater Stream and Lake Committee BROADWATER ROD AND GUN CLUB, CANYON FERRY FISHING ASSOCIATION, BROADWATER STREAM AND LAKE COMMITTEE  

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;