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

10 rows where package_id = "CHRG-105jhrg48113" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
2455 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Bobby L. Harnage President American Federation of Government Employees AMERICAN FEDERATION OF GOVERNMENT EMPLOYEES  
2451 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Bryan Logan Chief Executive Officer Earth Data International EARTH DATA INTERNATIONAL  
2453 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Douglas K. Stevens Jr., Partner of Information Technology Services Group under Grant Thornton, LLP, representing the U.S. Chamber of Commerce UNDER GRANT THORNTON, LLP, REPRESENTING THE U.S. CHAMBER OF COMMERCE  
2448 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 G. Edward DeSeve Acting Deputy Director for Management U.S. Office of Management and Budget U.S. OFFICE OF MANAGEMENT AND BUDGET  
2447 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Hon. Craig Thomas   a U.S. Senator from the State of Wyoming A U.S. SENATOR FROM THE STATE OF WYOMING  
2452 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Larry Trammell Corporate Vice President and General Manager Science Applications International Corp SCIENCE APPLICATIONS INTERNATIONAL CORP  
2456 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Michael B. Styles National President, Federal Managers Association      
2454 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Robert M. Tobias National President The National Treasury Employees Union THE NATIONAL TREASURY EMPLOYEES UNION  
2449 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Skip Stitt former Deputy Mayor City of Indianapolis, testifying on behalf of Hon. Steven Goldsmith, Mayor, City of Indianapolis CITY OF INDIANAPOLIS, TESTIFYING ON BEHALF OF HON. STEVEN GOLDSMITH, MAYOR, CITY OF INDIANAPOLIS  
2450 A FREE MARKET APPROACH TO FEDERAL CONTRACTING: THE FAIR COMPETITION ACT OF 1998 AND THE COMPETITION IN COMMERCIAL ACTIVITIES OF 1998 CHRG-105jhrg48113 Steve Kelman Ph.D., Weatherhead Professor of Public Management Harvard University HARVARD UNIVERSITY  

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;