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

1 row where organization = "2003, was proposed to accelerate the process of research, development, purchase, " and package_id = "CHRG-109hhrg29726" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

organization 1

  • 2003, was proposed to accelerate the process of research, development, purchase, · 1 ✖
id package_id name ▼ title organization organization_normalized location
24351 PROJECT BIOSHIELD REAUTHORIZATION ISSUES HEARING BEFORE THE SUBCOMMITTEE ON HEALTH OF THE COMMITTEE ON ENERGY AND COMMERCE HOUSE OF REPRESENTATIVES ONE HUNDRED NINTH CONGRESS SECOND SESSION CHRG-109hhrg29726 of the Union address on January 28 and availability of effective countermeasures against agents of bioterror. Then HHS Secretary Tommy Thompson and Department of Homeland Security (DHS) Secretary Tom Ridge jointly transmitted the ``Project BioShield Act of 2003'' to Congress on February 26 2003, was proposed to accelerate the process of research, development, purchase, 2003, WAS PROPOSED TO ACCELERATE THE PROCESS OF RESEARCH, DEVELOPMENT, PURCHASE,  

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;