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

55 rows where package_id = "CHRG-109hhrg31465" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 55
Link package_id name ▼ role bioguide_id
CHRG-109hhrg31465,Albert Russell Wynn CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Albert Russell Wynn committee member W000784
CHRG-109hhrg31465,Anna G. Eshoo CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Anna G. Eshoo committee member E000215
CHRG-109hhrg31465,Barbara Cubin CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Barbara Cubin committee member C000962
CHRG-109hhrg31465,Bart Gordon CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Bart Gordon committee member  
CHRG-109hhrg31465,Bart Stupak CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Bart Stupak committee member S001045
CHRG-109hhrg31465,Bobby L. Rush CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Bobby L. Rush committee member R000515
CHRG-109hhrg31465,Charles A. Gonzalez CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Charles A. Gonzalez committee member G000544
CHRG-109hhrg31465,Charles F. Bass CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Charles F. Bass committee member B000220
CHRG-109hhrg31465,Charles W. Norwood CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Charles W. Norwood committee member N000159
CHRG-109hhrg31465,Cliff Stearns CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Cliff Stearns committee member S000822
CHRG-109hhrg31465,Diana DeGette CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Diana DeGette committee member D000197
CHRG-109hhrg31465,Ed Whitfield CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Ed Whitfield committee member W000413
CHRG-109hhrg31465,Edolphus Towns CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Edolphus Towns committee member T000326
CHRG-109hhrg31465,Edward J. Markey CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Edward J. Markey committee member M000133
CHRG-109hhrg31465,Eliot L. Engel CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Eliot L. Engel committee member E000179
CHRG-109hhrg31465,Frank Pallone, Jr. CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Frank Pallone, Jr. committee member P000034
CHRG-109hhrg31465,Fred Upton CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Fred Upton committee member U000031
CHRG-109hhrg31465,Gene Green CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Gene Green committee member G000410
CHRG-109hhrg31465,George Radanovich CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 George Radanovich committee member R000004
CHRG-109hhrg31465,Greg Walden CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Greg Walden committee member W000791
CHRG-109hhrg31465,Heather Wilson CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Heather Wilson committee member W000789
CHRG-109hhrg31465,Henry A. Waxman CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Henry A. Waxman committee member W000215
CHRG-109hhrg31465,Hilda L. Solis CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Hilda L. Solis committee member S001153
CHRG-109hhrg31465,Janice D. Schakowsky CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Janice D. Schakowsky committee member S001145
CHRG-109hhrg31465,Jay Inslee CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Jay Inslee committee member I000026
CHRG-109hhrg31465,Jim Davis CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Jim Davis committee member  
CHRG-109hhrg31465,Joe Barton CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Joe Barton committee member B000213
CHRG-109hhrg31465,John B. Shadegg CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 John B. Shadegg committee member S000275
CHRG-109hhrg31465,John D. Dingell CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 John D. Dingell committee member D000355
CHRG-109hhrg31465,John Shimkus CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 John Shimkus committee member S000364
CHRG-109hhrg31465,John Sullivan CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 John Sullivan committee member S001055
CHRG-109hhrg31465,Joseph R. Pitts CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Joseph R. Pitts committee member P000373
CHRG-109hhrg31465,Lee Terry CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Lee Terry committee member T000459
CHRG-109hhrg31465,Lois Capps CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Lois Capps committee member C001036
CHRG-109hhrg31465,Marsha Blackburn CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Marsha Blackburn committee member B001243
CHRG-109hhrg31465,Mary Bono Mack CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Mary Bono Mack committee member B001228
CHRG-109hhrg31465,Michael Bilirakis CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Michael Bilirakis committee member B000463
CHRG-109hhrg31465,Michael C. Burgess CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Michael C. Burgess committee member B001248
CHRG-109hhrg31465,Michael F. Doyle CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Michael F. Doyle committee member D000482
CHRG-109hhrg31465,Mike Ferguson CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Mike Ferguson committee member  
CHRG-109hhrg31465,Mike Rogers CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Mike Rogers committee member R000572
CHRG-109hhrg31465,Mike Ross CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Mike Ross committee member R000573
CHRG-109hhrg31465,Nathan Deal CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Nathan Deal committee member D000168
CHRG-109hhrg31465,Paul E. Gillmor CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Paul E. Gillmor committee member G000210
CHRG-109hhrg31465,Ralph M. Hall CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Ralph M. Hall committee member H000067
CHRG-109hhrg31465,Rick Boucher CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Rick Boucher committee member  
CHRG-109hhrg31465,Roy Blunt CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Roy Blunt committee member B000575
CHRG-109hhrg31465,Sherrod Brown CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Sherrod Brown committee member B000944
CHRG-109hhrg31465,Steve Buyer CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Steve Buyer committee member  
CHRG-109hhrg31465,Sue Wilkins Myrick CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Sue Wilkins Myrick committee member M001134
CHRG-109hhrg31465,Tammy Baldwin CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Tammy Baldwin committee member B001230
CHRG-109hhrg31465,Ted Strickland CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Ted Strickland committee member S001004
CHRG-109hhrg31465,Thomas H. Allen CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Thomas H. Allen committee member A000147
CHRG-109hhrg31465,Tim Murphy CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Tim Murphy committee member M001151
CHRG-109hhrg31465,Vito Fossella CONTACT LENS SALES: IS MARKET REGULATION THE PRESCRIPTION? CHRG-109hhrg31465 Vito Fossella committee member F000440

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