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

8 rows where package_id = "CHRG-106shrg71375" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
7175 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Bill Bushnell Legislative Assistant to Representative Raymond Bunt, Jr. 147th District, Montgomery County, House of Representatives Commonwealth of Pennsylvania 147TH DISTRICT, MONTGOMERY COUNTY, HOUSE OF REPRESENTATIVES COMMONWEALTH OF PENNSYLVANIA  
7172 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Danny Sells Associate Chief, Natural Resources Conservation Service U.S. Department of Agriculture U.S. DEPARTMENT OF AGRICULTURE Washington, DC
7176 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Hon. James R. Matthews Commissioner, PA. County of Montgomery COUNTY OF MONTGOMERY Norristown, PA
7177 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Janet L. Oertly Natural Resources Conservation Service Pennsylvania State Conservationist, U.S. Department of Agriculture PENNSYLVANIA STATE CONSERVATIONIST, U.S. DEPARTMENT OF AGRICULTURE Philadelphia, PA
7170 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 John C. Keene Professor Department of City and Regional Planning, University of Pennsylvania DEPARTMENT OF CITY AND REGIONAL PLANNING, UNIVERSITY OF PENNSYLVANIA Philadelphia, PA
7174 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Marion Bowland Executive Director Pennsylvania Farmlink PENNSYLVANIA FARMLINK Manheim, PA
7171 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Mary Heinricht Regional Director for the Mid-Atlantic American Farmland Trust     Culpeper, VA
7173 FARMLAND PROTECTION PROGRAM CHRG-106shrg71375 Omar Beam   Recipient, Farmland Protection Program RECIPIENT, FARMLAND PROTECTION PROGRAM Elverson, PA

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;