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

8 rows where package_id = "CHRG-112shrg76071" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
62492 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Beth Carr International Tax Services Partner, Ernst & Young LLP, New York, New York PARTNER, ERNST & YOUNG LLP, NEW YORK, NEW YORK  
62493 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Hon. William J. Wilkins Chief Counsel, Internal Revenue Service, Deputy Commissioner (International), Internal Revenue Service accompanied by Michael Danilack, Large Business and International Division ACCOMPANIED BY MICHAEL DANILACK, LARGE BUSINESS AND INTERNATIONAL DIVISION  
62489 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Jack T. Ciesielski President, R.G. Associates Inc., Baltimore, Maryland INC., BALTIMORE, MARYLAND  
62491 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Lester D. Ezrati Senior Vice President, Senior Vice President and Treasurer Tax, Hewlett-Packard Company, Palo Alto, California, accompanied by John N. McMullen, Hewlett-Packard Company, Palo Alto, California TAX, HEWLETT-PACKARD COMPANY, PALO ALTO, CALIFORNIA, ACCOMPANIED BY JOHN N. MCMULLEN, HEWLETT-PACKARD COMPANY, PALO ALTO, CALIFORNIA  
62488 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Reuven S. Avi-Yonah Irwin I. Cohn Professor of Law University of Michigan School of Law, Ann Arbor, Michigan UNIVERSITY OF MICHIGAN SCHOOL OF LAW, ANN ARBOR, MICHIGAN  
62487 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Stephen E. Shay Professor of Practice Harvard Law School, Cambridge, Massachusetts HARVARD LAW SCHOOL, CAMBRIDGE, MASSACHUSETTS  
62494 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 Susan M. Cosper Technical Director Financial Accounting Standards Board, Norwalk, Connecticut FINANCIAL ACCOUNTING STANDARDS BOARD, NORWALK, CONNECTICUT  
62490 OFFSHORE PROFIT SHIFTING AND THE U.S. TAX CODE CHRG-112shrg76071 William J. Sample Corporate Vice President Worldwide Tax, Microsoft Corporation, Redmond, Washington WORLDWIDE TAX, MICROSOFT CORPORATION, REDMOND, WASHINGTON  

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;