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

46 rows where package_id = "CHRG-116hhrg42434" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 46
Link package_id name ▼ role bioguide_id
CHRG-116hhrg42434,Abigail Davis Spanberger THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Abigail Davis Spanberger committee member S001209
CHRG-116hhrg42434,Adam Kinzinger THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Adam Kinzinger committee member K000378
CHRG-116hhrg42434,Adriano Espaillat THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Adriano Espaillat committee member E000297
CHRG-116hhrg42434,Albio Sires THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Albio Sires committee member S001165
CHRG-116hhrg42434,Ami Bera THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ami Bera committee member B001287
CHRG-116hhrg42434,Andy Levin THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Andy Levin committee member L000592
CHRG-116hhrg42434,Ann Wagner THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ann Wagner committee member W000812
CHRG-116hhrg42434,Brad Sherman THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Brad Sherman committee member S000344
CHRG-116hhrg42434,Brian J. Mast THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Brian J. Mast committee member M001199
CHRG-116hhrg42434,Brian K. Fitzpatrick THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Brian K. Fitzpatrick committee member F000466
CHRG-116hhrg42434,Chrissy Houlahan THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Chrissy Houlahan committee member H001085
CHRG-116hhrg42434,Christopher H. Smith THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Christopher H. Smith committee member S000522
CHRG-116hhrg42434,Colin Z. Allred THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Colin Z. Allred committee member A000376
CHRG-116hhrg42434,David J. Trone THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 David J. Trone committee member T000483
CHRG-116hhrg42434,David N. Cicilline THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 David N. Cicilline committee member C001084
CHRG-116hhrg42434,Dina Titus THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Dina Titus committee member T000468
CHRG-116hhrg42434,Eliot L. Engel THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Eliot L. Engel committee member E000179
CHRG-116hhrg42434,F. James Sensenbrenner, Jr. THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 F. James Sensenbrenner, Jr. committee member S000244
CHRG-116hhrg42434,Francis Rooney THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Francis Rooney committee member R000607
CHRG-116hhrg42434,Gerald E. Connolly THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Gerald E. Connolly committee member C001078
CHRG-116hhrg42434,Greg Pence THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Greg Pence committee member P000615
CHRG-116hhrg42434,Gregory W. Meeks THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Gregory W. Meeks committee member M001137
CHRG-116hhrg42434,Guy Reschenthaler THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Guy Reschenthaler committee member R000610
CHRG-116hhrg42434,Ilhan Omar THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ilhan Omar committee member O000173
CHRG-116hhrg42434,Jim Costa THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Jim Costa committee member C001059
CHRG-116hhrg42434,Joaquin Castro THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Joaquin Castro committee member C001091
CHRG-116hhrg42434,Joe Wilson THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Joe Wilson committee member W000795
CHRG-116hhrg42434,John R. Curtis THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 John R. Curtis committee member C001114
CHRG-116hhrg42434,Juan Vargas THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Juan Vargas committee member V000130
CHRG-116hhrg42434,Karen Bass THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Karen Bass committee member B001270
CHRG-116hhrg42434,Ken Buck THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ken Buck committee member B001297
CHRG-116hhrg42434,Lee M. Zeldin THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Lee M. Zeldin committee member Z000017
CHRG-116hhrg42434,Michael Guest THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Michael Guest committee member G000591
CHRG-116hhrg42434,Michael T. McCaul THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Michael T. McCaul committee member M001157
CHRG-116hhrg42434,Ron Wright THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ron Wright committee member W000827
CHRG-116hhrg42434,Scott Perry THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Scott Perry committee member P000605
CHRG-116hhrg42434,Steve Chabot THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Steve Chabot committee member C000266
CHRG-116hhrg42434,Steve Watkins THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Steve Watkins committee member W000824
CHRG-116hhrg42434,Susan Wild THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Susan Wild committee member W000826
CHRG-116hhrg42434,Ted Lieu THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ted Lieu committee member L000582
CHRG-116hhrg42434,Ted S. Yoho THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Ted S. Yoho committee member Y000065
CHRG-116hhrg42434,Theodore E. Deutch THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Theodore E. Deutch committee member D000610
CHRG-116hhrg42434,Tim Burchett THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Tim Burchett committee member B001309
CHRG-116hhrg42434,Tom Malinowski THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Tom Malinowski committee member M001203
CHRG-116hhrg42434,Vicente Gonzalez THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 Vicente Gonzalez committee member G000581
CHRG-116hhrg42434,William R. Keating THE WESTERN HEMISPHERE DRUG POLICY COMMISSION: CHARTING A NEW PATH FORWARD CHRG-116hhrg42434 William R. Keating committee member K000375

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);
Powered by Datasette · Queries took 22.28ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API