home / openregs

hearing_members

Committee members present at hearings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

32 rows where package_id = "CHRG-109hhrg35627" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 32
Link package_id name ▼ role bioguide_id
CHRG-109hhrg35627,Bennie G. Thompson POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Bennie G. Thompson committee member T000193
CHRG-109hhrg35627,Bill Pascrell, Jr. POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Bill Pascrell, Jr. committee member P000096
CHRG-109hhrg35627,Bob Etheridge POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Bob Etheridge committee member E000226
CHRG-109hhrg35627,Bobby Jindal POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Bobby Jindal committee member J000287
CHRG-109hhrg35627,Charles W. Dent POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Charles W. Dent committee member D000604
CHRG-109hhrg35627,Christopher Shays POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Christopher Shays committee member S001144
CHRG-109hhrg35627,Curt Weldon POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Curt Weldon committee member  
CHRG-109hhrg35627,Daniel E. Lungren POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Daniel E. Lungren committee member L000517
CHRG-109hhrg35627,David G. Reichert POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 David G. Reichert committee member R000578
CHRG-109hhrg35627,Don Young POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Don Young committee member Y000033
CHRG-109hhrg35627,Edward J. Markey POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Edward J. Markey committee member M000133
CHRG-109hhrg35627,Ginny Brown-Waite POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Ginny Brown-Waite committee member  
CHRG-109hhrg35627,James R. Langevin POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 James R. Langevin committee member L000559
CHRG-109hhrg35627,Jane Harman POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Jane Harman committee member H000213
CHRG-109hhrg35627,Jim Gibbons POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Jim Gibbons committee member  
CHRG-109hhrg35627,John Linder POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 John Linder committee member L000321
CHRG-109hhrg35627,Katherine Harris POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Katherine Harris committee member H001035
CHRG-109hhrg35627,Kendrick B. Meek POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Kendrick B. Meek committee member M001148
CHRG-109hhrg35627,Lamar Smith POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Lamar Smith committee member S000583
CHRG-109hhrg35627,Loretta Sanchez POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Loretta Sanchez committee member S000030
CHRG-109hhrg35627,Mark E. Souder POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Mark E. Souder committee member S001143
CHRG-109hhrg35627,Michael T. McCaul POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Michael T. McCaul committee member M001157
CHRG-109hhrg35627,Mike Rogers POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Mike Rogers committee member R000572
CHRG-109hhrg35627,Nita M. Lowey POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Nita M. Lowey committee member L000480
CHRG-109hhrg35627,Norman D. Dicks POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Norman D. Dicks committee member D000327
CHRG-109hhrg35627,Peter A. DeFazio POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Peter A. DeFazio committee member D000191
CHRG-109hhrg35627,Peter T. King POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Peter T. King committee member K000210
CHRG-109hhrg35627,Rob Simmons POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Rob Simmons committee member  
CHRG-109hhrg35627,Sheila Jackson Lee POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Sheila Jackson Lee committee member J000032
CHRG-109hhrg35627,Stevan Pearce POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Stevan Pearce committee member P000588
CHRG-109hhrg35627,Tom Davis POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Tom Davis committee member  
CHRG-109hhrg35627,Zoe Lofgren POLICE AS FIRST PREVENTERS: LOCAL STRATEGIES IN THE WAR ON TERROR CHRG-109hhrg35627 Zoe Lofgren committee member L000397

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE hearing_members (
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT NOT NULL,
    role TEXT,
    bioguide_id TEXT,
    PRIMARY KEY (package_id, name)
);
CREATE INDEX idx_hm_name ON hearing_members(name);
CREATE INDEX idx_hm_bioguide ON hearing_members(bioguide_id);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);
Powered by Datasette · Queries took 4.641ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API