hearing_members

Committee members present at hearings.

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

29 rows where package_id = "CHRG-119hhrg62628" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119hhrg62628,Al Green LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Al Green committee member G000553
CHRG-119hhrg62628,Andrew Ogles LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Andrew Ogles committee member O000175
CHRG-119hhrg62628,Andrew R. Garbarino LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Andrew R. Garbarino committee member G000597
CHRG-119hhrg62628,August Pfluger LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 August Pfluger committee member P000048
CHRG-119hhrg62628,Bennie G. Thompson LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Bennie G. Thompson committee member T000193
CHRG-119hhrg62628,Brad Knott LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Brad Knott committee member K000405
CHRG-119hhrg62628,Carlos A. Gimenez LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Carlos A. Gimenez committee member G000593
CHRG-119hhrg62628,Clay Higgins LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Clay Higgins committee member H001077
CHRG-119hhrg62628,Dale W. Strong LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Dale W. Strong committee member S001220
CHRG-119hhrg62628,Daniel S. Goldman LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Daniel S. Goldman committee member G000599
CHRG-119hhrg62628,Delia C. Ramirez LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Delia C. Ramirez committee member R000617
CHRG-119hhrg62628,Elijah Crane LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Elijah Crane committee member C001132
CHRG-119hhrg62628,Eric Swalwell LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Eric Swalwell committee member S001193
CHRG-119hhrg62628,Gabe Evans LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Gabe Evans committee member E000300
CHRG-119hhrg62628,Josh Brecheen LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Josh Brecheen committee member B001317
CHRG-119hhrg62628,Julie Johnson LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Julie Johnson committee member J000310
CHRG-119hhrg62628,LaMonica McIver LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 LaMonica McIver committee member M001229
CHRG-119hhrg62628,Marjorie Taylor Greene LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Marjorie Taylor Greene committee member G000596
CHRG-119hhrg62628,Michael Guest LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Michael Guest committee member G000591
CHRG-119hhrg62628,Michael T. McCaul LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Michael T. McCaul committee member M001157
CHRG-119hhrg62628,Morgan Luttrell LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Morgan Luttrell committee member L000603
CHRG-119hhrg62628,Nellie Pou LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Nellie Pou committee member P000621
CHRG-119hhrg62628,Ryan Mackenzie LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Ryan Mackenzie committee member M001230
CHRG-119hhrg62628,Seth Magaziner LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Seth Magaziner committee member M001223
CHRG-119hhrg62628,Sheri Biggs LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Sheri Biggs committee member B001325
CHRG-119hhrg62628,Shri Thanedar LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Shri Thanedar committee member T000488
CHRG-119hhrg62628,Timothy M. Kennedy LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Timothy M. Kennedy committee member K000402
CHRG-119hhrg62628,Tony Gonzales LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Tony Gonzales committee member G000594
CHRG-119hhrg62628,Troy A. Carter LESSONS LEARNED: AN EXAMINATION OF MAJOR SECURITY INCIDENTS AT MASS GATHERING EVENTS CHRG-119hhrg62628 Troy A. Carter committee member C001125

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);