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

11 rows where package_id = "CHRG-106hhrg71648" 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
5930 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 ALSTOM Transportation Inc.   Tim Gillespie TIM GILLESPIE  
5931 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 American Association of Port Authorities   Alexandria, Virginia, Jean Godwin ALEXANDRIA, VIRGINIA, JEAN GODWIN  
5932 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 American Consulting Engineers Council and Anderson & Associates Inc. Tim Stowe INC. TIM STOWE  
5933 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 American Road and Transportation Builders Association   and Parsons Transportation Group, William H. George AND PARSONS TRANSPORTATION GROUP, WILLIAM H. GEORGE  
5934 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 Association of American Railroads   and Union Pacific Corporation, Bernard R. Gutschewski AND UNION PACIFIC CORPORATION, BERNARD R. GUTSCHEWSKI  
5935 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 Georgia Regional Transportation Authority   Catherine L. Ross CATHERINE L. ROSS  
5936 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 High Speed Ground Transportation Association   Mark R. Dysart MARK R. DYSART  
5939 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 Hon. James L. Oberstar   a Representative in Congress from the State of Minnesota A REPRESENTATIVE IN CONGRESS FROM THE STATE OF MINNESOTA  
5940 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 Hon. Tommy G. Thompson   Governor of Wisconsin, and National Railroad Passenger Corporation GOVERNOR OF WISCONSIN, AND NATIONAL RAILROAD PASSENGER CORPORATION  
5937 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 Morgan Stanley Dean Witter   James B. Query JAMES B. QUERY  
5938 TAX TREATMENT OF TRANSPORTATION CHRG-106hhrg71648 North Carolina Department of Transportation Deputy Secretary for Transportation David D. King, and Intercity Passenger Rail, Raleigh, North Carolina DAVID D. KING, AND INTERCITY PASSENGER RAIL, RALEIGH, NORTH CAROLINA  

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;