hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
49 rows where package_id = "CHRG-108hhrg89863" sorted by name
This data as json, CSV (advanced)
organization >30
- James M. ``Jim'' Jones 5
- a Representative in Congress from the State of Michigan 4
- a Representative in Congress from the State of Ohio 3
- Laurie Moncrief 2
- Peter Dooner 2
- Walter A. Niemand 2
- - 1
- '' National Association of Metal Finishers, Metal Finishing Suppliers Association, American Electroplaters & Surface Finishers, and Georgia Industry Association, and Dixie Industrial Finishing Company 1
- A.J. Rose Manufacturing Company 1
- American Iron and Steel Institute 1
- Andrew Sharkey 1
- Bakersfield Tank Company 1
- Charles A. Bradford 1
- Committee on Pipe and Tube Imports 201 Coalition, and Wheatland Tube Company 1
- Dan DiMicco 1
- David P. Schulingkamp 1
- David Pritchard 1
- E&E Manufacturing Company 1
- International Longshoremen's Association No. 3000 1
- James O. Campbell 1
- Leo W. Gerard 1
- Lester Trilla 1
- MacLean-Fogg Company 1
- Magneco/Metrel 1
- Metaldyne Corporation 1
- Nucor Corporation 1
- Paul Nixon 1
- Port of New Orleans 1
- Schmald Tool & Die, and Coalition for the Advancement of Michigan Tooling Industries 1
- Texas Free Trade Coalition, and West Gulf Maritime Association 1
- …
| id | package_id | name ▼ | title | organization | organization_normalized | location |
|---|---|---|---|---|---|---|
| 16402 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | A.J. Rose Manufacturing Company | David Pritchard | DAVID PRITCHARD | ||
| 16403 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | American Electroplaters & Surface Finishers | James M. ``Jim'' Jones | JAMES M. ``JIM'' JONES | ||
| 16404 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | American Iron and Steel Institute | Andrew Sharkey | ANDREW SHARKEY | ||
| 16439 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Andrew Sharkey | American Iron and Steel Institute | AMERICAN IRON AND STEEL INSTITUTE | ||
| 16405 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Bakersfield Tank Company | Paul Nixon | PAUL NIXON | ||
| 16406 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Bradford Research | Charles A. Bradford | CHARLES A. BRADFORD | ||
| 16410 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Charles W. Connors | Magneco/Metrel | MAGNECO/METREL | ||
| 16424 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Charles W. Connors Magneco/Metrel | ||||
| 16408 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Coalition for the Advancement of Michigan Tooling Industries | Laurie Moncrief | LAURIE MONCRIEF | ||
| 16409 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Committee on Pipe and Tube Imports 201 Coalition | Peter Dooner | PETER DOONER | ||
| 16411 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Dan DiMicco | Nucor Corporation | NUCOR CORPORATION | ||
| 16438 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | David P. Schulingkamp | Port of New Orleans | PORT OF NEW ORLEANS | ||
| 16436 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | David Pritchard | A.J. Rose Manufacturing Company | A.J. ROSE MANUFACTURING COMPANY | ||
| 16412 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Dixie Industrial Finishing Company | James M. ``Jim'' Jones | JAMES M. ``JIM'' JONES | ||
| 16414 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | E&E Manufacturing Company | Wes Smith | WES SMITH | ||
| 16415 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Georgia Industry Association | James M. ``Jim'' Jones | JAMES M. ``JIM'' JONES | ||
| 16401 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Anibal Acevedo-Vila | a Representative in Congress from the Commonwealth of Puerto Rico | A REPRESENTATIVE IN CONGRESS FROM THE COMMONWEALTH OF PUERTO RICO | ||
| 16442 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Bart Stupak | a Representative in Congress from the State of Michigan | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF MICHIGAN | ||
| 16421 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Dennis J. Kucinich | a Representative in Congress from the State of Ohio | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF OHIO | ||
| 16425 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Donald A. Manzullo | a Representative in Congress from the State of Illinois | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF ILLINOIS | ||
| 16420 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Joe Knollenberg | a Representative in Congress from the State of Michigan | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF MICHIGAN | ||
| 16417 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Peter Hoekstra | a Representative in Congress from the State of Michigan | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF MICHIGAN | ||
| 16447 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Peter J. Visclosky | a Representative in Congress from the State of Indiana | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF INDIANA | ||
| 16431 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Robert W. Ney | a Representative in Congress from the State of Ohio | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF OHIO | ||
| 16441 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Ted Strickland | a Representative in Congress from the State of Ohio | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF OHIO | ||
| 16426 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Hon. Thaddeus G. McCotter | a Representative in Congress from the State of Michigan | A REPRESENTATIVE IN CONGRESS FROM THE STATE OF MICHIGAN | ||
| 16418 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | International Longshoremen's Association Local No. 3000 | James O. Campbell | JAMES O. CAMPBELL | ||
| 16419 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | James M. ``Jim Jones | '' National Association of Metal Finishers, Metal Finishing Suppliers Association, American Electroplaters & Surface Finishers, and Georgia Industry Association, and Dixie Industrial Finishing Company | '' NATIONAL ASSOCIATION OF METAL FINISHERS, METAL FINISHING SUPPLIERS ASSOCIATION, AMERICAN ELECTROPLATERS & SURFACE FINISHERS, AND GEORGIA INDUSTRY ASSOCIATION, AND DIXIE INDUSTRIAL FINISHING COMPANY | ||
| 16407 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | James O. Campbell | International Longshoremen's Association No. 3000 | INTERNATIONAL LONGSHOREMEN'S ASSOCIATION NO. 3000 | ||
| 16429 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Laurie Moncrief | Schmald Tool & Die, and Coalition for the Advancement of Michigan Tooling Industries | SCHMALD TOOL & DIE, AND COALITION FOR THE ADVANCEMENT OF MICHIGAN TOOLING INDUSTRIES | ||
| 16416 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Leo W. Gerard | United Steelworkers of America | UNITED STEELWORKERS OF AMERICA | ||
| 16423 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | MacLean-Fogg Company | Timothy N. Taylor | TIMOTHY N. TAYLOR | ||
| 16428 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Metal Finishing Suppliers Association | James M. ``Jim'' Jones | JAMES M. ``JIM'' JONES | ||
| 16427 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Metaldyne Corporation | Timothy D. Leuliette | TIMOTHY D. LEULIETTE | ||
| 16430 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | National Association of Metal Finishers | James M. ``Jim'' Jones | JAMES M. ``JIM'' JONES | ||
| 16434 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Nucor Corporation | Dan DiMicco | DAN DIMICCO | ||
| 16433 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Paul Nixon | Bakersfield Tank Company | BAKERSFIELD TANK COMPANY | ||
| 16413 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Peter Dooner | Committee on Pipe and Tube Imports 201 Coalition, and Wheatland Tube Company | COMMITTEE ON PIPE AND TUBE IMPORTS 201 COALITION, AND WHEATLAND TUBE COMPANY | ||
| 16435 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Port of New Orleans | David P. Schulingkamp | DAVID P. SCHULINGKAMP | ||
| 16437 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Schmald Tool & Die | Laurie Moncrief | LAURIE MONCRIEF | ||
| 16444 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Texas Free Trade Coalition | Walter A. Niemand | WALTER A. NIEMAND | ||
| 16422 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Timothy D. Leuliette | Metaldyne Corporation | METALDYNE CORPORATION | ||
| 16443 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Timothy N. Taylor | MacLean-Fogg Company | MACLEAN-FOGG COMPANY | ||
| 16445 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Trilla Steel Drum Corporation | Lester Trilla | LESTER TRILLA | ||
| 16446 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | United Steelworkers of America | Leo W. Gerard | LEO W. GERARD | ||
| 16432 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Walter A. Niemand | Texas Free Trade Coalition, and West Gulf Maritime Association | TEXAS FREE TRADE COALITION, AND WEST GULF MARITIME ASSOCIATION | ||
| 16440 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Wes Smith | E&E Manufacturing Company | E&E MANUFACTURING COMPANY | ||
| 16448 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | West Gulf Maritime Association | Walter A. Niemand | WALTER A. NIEMAND | ||
| 16449 | IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 | Wheatland Tube Company | Peter Dooner | PETER DOONER |
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;