openregs: hearing_witnesses: 9 rows where package_id = "CHRG-109shrg71811" sorted by name

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

9 rows where package_id = "CHRG-109shrg71811" sorted by name

descending

id	package_id	name ▼	title	organization	organization_normalized
29059	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Chris Boskin	Nominee to be a Member of the Board of Directors	Corporation for Public Broadcasting	CORPORATION FOR PUBLIC BROADCASTING
29062	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Dr. Sharon Lynn Hays	Nominee to be Associate Director	Office of Science and Technology Policy	OFFICE OF SCIENCE AND TECHNOLOGY POLICY
29067	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Hon. Arlen Specter		U.S. Senator from Pennsylvania	U.S. SENATOR FROM PENNSYLVANIA
29066	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Hon. Charles Darwin Snelling	Nominee to be a Member of the Board of Directors	Metropolitan Washington Airports Authority	METROPOLITAN WASHINGTON AIRPORTS AUTHORITY
29064	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Hon. David Pryor	Nominee to be a Member of the Board of Directors	Corporation for Public Broadcasting	CORPORATION FOR PUBLIC BROADCASTING
29060	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Hon. Vernon Ehlers		U.S. Representative from Michigan	U.S. REPRESENTATIVE FROM MICHIGAN
29063	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Jr. Johnson	'' Nominee to be Administrator	Collister ``Terry, Saint Lawrence Seaway Development Corporation	COLLISTER ``TERRY, SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION
29061	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Ph.D. Glassman	Nominee to be Under Secretary for Economic Affairs	Hon. Cynthia A., Department of Commerce	HON. CYNTHIA A., DEPARTMENT OF COMMERCE
29065	NOMINATIONS TO THE DEPARTMENT OF COMMERCE, DEPARTMENT OF TRANSPORTATION, CORPORATION FOR PUBLIC BROADCASTING, OFFICE OF SCIENCE AND TECHNOLOGY POLICY, METROPOLITAN WASHINGTON AIRPORTS AUTHORITY, AND SAINT LAWRENCE SEAWAY DEVELOPMENT CORPORATION CHRG-109shrg71811	Scovel III	Calvin L., Nominee to be Inspector General	Department of Transportation	DEPARTMENT OF TRANSPORTATION

Advanced export

JSON shape: default, array, newline-delimited, object

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;