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

14 rows where package_id = "CHRG-105hhrg51797" 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
1480 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Bob Retz        
1477 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Carol H. Jacoby   Division Engineer, Western Federal Lands Highway Division, Federal Highway Administration DIVISION ENGINEER, WESTERN FEDERAL LANDS HIGHWAY DIVISION, FEDERAL HIGHWAY ADMINISTRATION  
1479 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 David Mihalic Superintendent, National Park Service Glacier National Park GLACIER NATIONAL PARK  
1474 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Gary Hall   Mayor of Columbia Falls, Montana MAYOR OF COLUMBIA FALLS, MONTANA  
1473 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 George Darrow        
1482 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Joe Unterreiner President, Associated Chambers of the Flathead Valley      
1475 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 John E. Helton   Abbott Valley Homestead, Martin City, Montana ABBOTT VALLEY HOMESTEAD, MARTIN CITY, MONTANA  
1478 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Lowell Meznarich Glacier County Commissioner      
1483 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Onno Wieringa        
1470 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Rahn Armbruster        
1476 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Richard B. Hunt Vice-President Friends of Glacier, Inc FRIENDS OF GLACIER, INC  
1471 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Roscoe Black        
1481 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Running Crane Vice-Chairman Roger, Blackfeet Nation ROGER, BLACKFEET NATION  
1472 FUTURE MAINTENANCE AND REPAIR OF THE GOING-TO-THE-SUN ROAD IN GLACIER NATIONAL PARK CHRG-105hhrg51797 Will Brooke President Glacier/Waterton Visitor Association GLACIER/WATERTON VISITOR ASSOCIATION  

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;