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

26 rows where package_id = "CHRG-118hhrg56669" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 26
Link package_id name ▼ role bioguide_id
CHRG-118hhrg56669,Aaron Bean HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Aaron Bean committee member B001314
CHRG-118hhrg56669,Beth Van Duyne HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Beth Van Duyne committee member V000134
CHRG-118hhrg56669,Blaine Luetkemeyer HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Blaine Luetkemeyer committee member L000569
CHRG-118hhrg56669,Celeste Maloy HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Celeste Maloy committee member M001228
CHRG-118hhrg56669,Chris Pappas HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Chris Pappas committee member P000614
CHRG-118hhrg56669,Daniel Meuser HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Daniel Meuser committee member M001204
CHRG-118hhrg56669,Dean Phillips HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Dean Phillips committee member P000616
CHRG-118hhrg56669,Elijah Crane HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Elijah Crane committee member C001132
CHRG-118hhrg56669,Greg Landsman HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Greg Landsman committee member L000601
CHRG-118hhrg56669,Hillary J. Scholten HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Hillary J. Scholten committee member S001221
CHRG-118hhrg56669,Jake Ellzey HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Jake Ellzey committee member E000071
CHRG-118hhrg56669,Jared F. Golden HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Jared F. Golden committee member G000592
CHRG-118hhrg56669,Judy Chu HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Judy Chu committee member C001080
CHRG-118hhrg56669,Marcus J. Molinaro HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Marcus J. Molinaro committee member M001221
CHRG-118hhrg56669,Maria Elvira Salazar HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Maria Elvira Salazar committee member S000168
CHRG-118hhrg56669,Marie Gluesenkamp Perez HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Marie Gluesenkamp Perez committee member G000600
CHRG-118hhrg56669,Mark Alford HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Mark Alford committee member A000379
CHRG-118hhrg56669,Morgan McGarvey HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Morgan McGarvey committee member M001220
CHRG-118hhrg56669,Nick LaLota HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Nick LaLota committee member L000598
CHRG-118hhrg56669,Nydia M. Velazquez HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Nydia M. Velazquez committee member  
CHRG-118hhrg56669,Pete Stauber HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Pete Stauber committee member S001212
CHRG-118hhrg56669,Roger Williams HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Roger Williams committee member W000816
CHRG-118hhrg56669,Sharice Davids HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Sharice Davids committee member D000629
CHRG-118hhrg56669,Shri Thanedar HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Shri Thanedar committee member T000488
CHRG-118hhrg56669,Tracey Mann HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Tracey Mann committee member M000871
CHRG-118hhrg56669,Wesley Hunt HOLDING THE SBA ACCOUNTABLE: TESTIMONY FROM SMALL BUSINESS ADMINISTRATOR GUZMAN CHRG-118hhrg56669 Wesley Hunt committee member H001095

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