hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where package_id = "CHRG-109shrg32151" sorted by name
This data as json, CSV (advanced)
| id | package_id | name ▼ | title | organization | location |
|---|---|---|---|---|---|
| 27742 | OVERSIGHT HEARING: U.S. REFUGEE ADMISSIONS AND POLICY CHRG-109shrg32151 | Ellen R. Sauerbrey | Assistant Secretary, D.C | Bureau of Population, Refugees and Migration, Department of State, Washington | |
| 27743 | OVERSIGHT HEARING: U.S. REFUGEE ADMISSIONS AND POLICY CHRG-109shrg32151 | Jonathan R. Scharfen | Deputy Director, U.S. Citizenship and Immigration Services, D.C | Department of Homeland Security, Washington | |
| 27741 | OVERSIGHT HEARING: U.S. REFUGEE ADMISSIONS AND POLICY CHRG-109shrg32151 | Michael J. Horowitz | Director, D.C | Project for Civil Justice Reform and Project for International Religious Liberty, Hudson Institute, Washington | |
| 27740 | OVERSIGHT HEARING: U.S. REFUGEE ADMISSIONS AND POLICY CHRG-109shrg32151 | Rev. Kenneth Gavin | S.J., Vice Chair, and National Director, Jesuit Refugee Service/USA, D.C | Refugee Council USA, Washington |
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,
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 != '';