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

6 rows where package_id = "CHRG-110shrg50413" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
40545 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 Donald Young Managing Director, and Former FASB Board Member Young and Company LLC YOUNG AND COMPANY LLC  
40546 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 Elizabeth F. Mooney Analyst Capital Strategy Research, The Capital Group Companies CAPITAL STRATEGY RESEARCH, THE CAPITAL GROUP COMPANIES  
40547 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 George P. Miller Executive Director American Securitization Forum AMERICAN SECURITIZATION FORUM  
40543 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 John W. White Director, Deputy Chief Accountant Division of Corporation Finance, Securities and Exchange Commission, and James L. Kroeker, Securities and Exchange Commission DIVISION OF CORPORATION FINANCE, SECURITIES AND EXCHANGE COMMISSION, AND JAMES L. KROEKER, SECURITIES AND EXCHANGE COMMISSION  
40544 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 Joseph R. Mason Hermann Moyse Jr./Louisiana Bankers Association Professor of Finance E.J. Ourso College of Business, Louisiana State University E.J. OURSO COLLEGE OF BUSINESS, LOUISIANA STATE UNIVERSITY  
40542 TRANSPARENCY IN ACCOUNTING: PROPOSED CHANGES TO ACCOUNTING FOR OFF- BALANCE-SHEET ENTITIES CHRG-110shrg50413 Lawrence Smith Board Member Financial Accounting Standards Board (FASB) FINANCIAL ACCOUNTING STANDARDS BOARD (FASB)  

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;