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

31 rows where package_id = "CHRG-118jhrg54590" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 31
Link package_id name ▼ role bioguide_id
CHRG-118jhrg54590,Andrew R. Garbarino THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Andrew R. Garbarino committee member G000597
CHRG-118jhrg54590,Anthony D'Esposito THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Anthony D'Esposito committee member D000632
CHRG-118jhrg54590,August Pfluger THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 August Pfluger committee member P000048
CHRG-118jhrg54590,Bennie G. Thompson THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Bennie G. Thompson committee member T000193
CHRG-118jhrg54590,Carlos A. Gimenez THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Carlos A. Gimenez committee member G000593
CHRG-118jhrg54590,Clay Higgins THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Clay Higgins committee member H001077
CHRG-118jhrg54590,Dale W. Strong THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Dale W. Strong committee member S001220
CHRG-118jhrg54590,Dan Bishop THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Dan Bishop committee member B001311
CHRG-118jhrg54590,Daniel S. Goldman THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Daniel S. Goldman committee member G000599
CHRG-118jhrg54590,Delia C. Ramirez THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Delia C. Ramirez committee member R000617
CHRG-118jhrg54590,Dina Titus THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Dina Titus committee member T000468
CHRG-118jhrg54590,Donald M. Payne, Jr. THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Donald M. Payne, Jr. committee member P000604
CHRG-118jhrg54590,Elijah Crane THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Elijah Crane committee member C001132
CHRG-118jhrg54590,Eric Swalwell THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Eric Swalwell committee member S001193
CHRG-118jhrg54590,Glenn Ivey THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Glenn Ivey committee member I000058
CHRG-118jhrg54590,Josh Brecheen THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Josh Brecheen committee member B001317
CHRG-118jhrg54590,Laurel M. Lee THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Laurel M. Lee committee member L000597
CHRG-118jhrg54590,Marjorie Taylor Greene THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Marjorie Taylor Greene committee member G000596
CHRG-118jhrg54590,Michael Guest THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Michael Guest committee member G000591
CHRG-118jhrg54590,Michael T. McCaul THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Michael T. McCaul committee member M001157
CHRG-118jhrg54590,Mike Ezell THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Mike Ezell committee member E000235
CHRG-118jhrg54590,Morgan Luttrell THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Morgan Luttrell committee member L000603
CHRG-118jhrg54590,Nick LaLota THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Nick LaLota committee member L000598
CHRG-118jhrg54590,Robert Garcia THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Robert Garcia committee member G000047
CHRG-118jhrg54590,Robert Menendez of New Jersey THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Robert Menendez of New Jersey committee member  
CHRG-118jhrg54590,Seth Magaziner THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Seth Magaziner committee member M001223
CHRG-118jhrg54590,Sheila Jackson Lee of Texas THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Sheila Jackson Lee of Texas committee member  
CHRG-118jhrg54590,Shri Thanedar THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Shri Thanedar committee member T000488
CHRG-118jhrg54590,Tony Gonzales THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Tony Gonzales committee member G000594
CHRG-118jhrg54590,Troy Carter THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Troy Carter committee member C001125
CHRG-118jhrg54590,Yvette D. Clarke THE REAL COST OF AN OPEN BORDER: HOW AMERICANS ARE PAYING THE PRICE CHRG-118jhrg54590 Yvette D. Clarke committee member C001067

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 234.112ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API