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

9 rows where package_id = "CHRG-108shrg94598" 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
21030 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 A Bad Treaty Returns...............................129-145 Article        
21032 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Bernard H. Oxman professor of law; director Ocean and Coastal Law Program, University of Miami School of Law OCEAN AND COASTAL LAW PROGRAM, UNIVERSITY OF MIAMI SCHOOL OF LAW  
21027 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Frank Gaffney Jr., president and CEO The Center for Security Policy THE CENTER FOR SECURITY POLICY  
21034 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 John F. Turner Assistant Secretary, Chief Legal Counsel Bureau of Ocean and International Environmental and Scientific Affairs, U.S. Department of State: Accompanied by: William H. Taft IV, U.S. Department of State BUREAU OF OCEAN AND INTERNATIONAL ENVIRONMENTAL AND SCIENTIFIC AFFAIRS, U.S. DEPARTMENT OF STATE: ACCOMPANIED BY: WILLIAM H. TAFT IV, U.S. DEPARTMENT OF STATE  
21031 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Law of the Sea Treaty: A Defective Document That Should Not Be Ratified.....................................95-126 Responses to additional questions from: Senator Inhofe Report        
21028 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Paul L. Kelly senior vice president, Incorporated; member Rowan Companies, U.S. Commission on Ocean Policy ROWAN COMPANIES, U.S. COMMISSION ON OCEAN POLICY  
21029 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Peter Leitner   author, ``Reforming the Law of the Sea Treaty: Opportunities Missed, Precedents Set, and U.S. Sovereignty Threatened'' AUTHOR, ``REFORMING THE LAW OF THE SEA TREATY: OPPORTUNITIES MISSED, PRECEDENTS SET, AND U.S. SOVEREIGNTY THREATENED''  
21035 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 Responses to additional questions from: Senator Inhofe...........................................73        
21033 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 The American Journal of International Law Article   Vol. 88:477; Vol. 88:488; Vol. 88:687..........................166-187 Prepared statement VOL. 88:477; VOL. 88:488; VOL. 88:687..........................166-187 PREPARED STATEMENT  

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;