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-105hhrg51878" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
1491 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Dan Beard Senior Vice President Public Policy, National Audubon Society PUBLIC POLICY, NATIONAL AUDUBON SOCIETY Washington, DC
1495 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 David Koland Executive Director North Dakota Rural Water Systems Association NORTH DAKOTA RURAL WATER SYSTEMS ASSOCIATION  
1496 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Eluid Martinez Commissioner U.S. Bureau of Reclamation, Department of Interior U.S. BUREAU OF RECLAMATION, DEPARTMENT OF INTERIOR Washington, DC
1493 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Hon. Bruce Furness   Mayor, Fargo, North Dakota MAYOR, FARGO, NORTH DAKOTA  
1501 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Hon. Edward Schafer   Governor, State of North Dakota GOVERNOR, STATE OF NORTH DAKOTA  
1492 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Hon. John Dorso   State Representative and Majority Leader, North Dakota State House of Representatives STATE REPRESENTATIVE AND MAJORITY LEADER, NORTH DAKOTA STATE HOUSE OF REPRESENTATIVES  
1498 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Michelle McCormack   Southwest Water Authority, North Dakota SOUTHWEST WATER AUTHORITY, NORTH DAKOTA  
1494 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Norman Haak Chairman Garrison Diversion Conservancy District, North Dakota GARRISON DIVERSION CONSERVANCY DISTRICT, NORTH DAKOTA  
1499 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Ronald Nargang Deputy Commissioner Minnesota Department of Natural Resources MINNESOTA DEPARTMENT OF NATURAL RESOURCES  
1497 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Russell Mason Sr., Chairman Three Affiliated Tribes, North Dakota THREE AFFILIATED TRIBES, NORTH DAKOTA  
1500 GARRISON UNIT REFORMULATION CHRG-105hhrg51878 Scott Peterson President North Dakota Chapter of The Wildlife Society NORTH DAKOTA CHAPTER OF THE WILDLIFE SOCIETY  

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;