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

34 rows where package_id = "CHRG-112hhrg78759" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 34
Link package_id name ▼ role bioguide_id
CHRG-112hhrg78759,Aaron Schock PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Aaron Schock committee member S001179
CHRG-112hhrg78759,Adrian Smith PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Adrian Smith committee member S001172
CHRG-112hhrg78759,Charles B. Rangel PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Charles B. Rangel committee member R000053
CHRG-112hhrg78759,Dave Camp PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Dave Camp committee member C000071
CHRG-112hhrg78759,David G. Reichert PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 David G. Reichert committee member R000578
CHRG-112hhrg78759,Devin Nunes PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Devin Nunes committee member N000181
CHRG-112hhrg78759,Diane Black PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Diane Black committee member B001273
CHRG-112hhrg78759,Earl Blumenauer PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Earl Blumenauer committee member B000574
CHRG-112hhrg78759,Erik Paulsen PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Erik Paulsen committee member P000594
CHRG-112hhrg78759,Fortney Pete Stark PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Fortney Pete Stark committee member S000810
CHRG-112hhrg78759,Jim Gerlach PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Jim Gerlach committee member G000549
CHRG-112hhrg78759,Jim McDermott PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Jim McDermott committee member M000404
CHRG-112hhrg78759,John B. Larson PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 John B. Larson committee member L000557
CHRG-112hhrg78759,John Lewis PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 John Lewis committee member L000285
CHRG-112hhrg78759,Joseph Crowley PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Joseph Crowley committee member C000943
CHRG-112hhrg78759,Kenny Marchant PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Kenny Marchant committee member M001158
CHRG-112hhrg78759,Kevin Brady PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Kevin Brady committee member B000755
CHRG-112hhrg78759,Lloyd Doggett PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Lloyd Doggett committee member D000399
CHRG-112hhrg78759,Lynn Jenkins PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Lynn Jenkins committee member J000290
CHRG-112hhrg78759,Mike Thompson PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Mike Thompson committee member T000460
CHRG-112hhrg78759,Patrick J. Tiberi PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Patrick J. Tiberi committee member T000462
CHRG-112hhrg78759,Paul D. Ryan PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Paul D. Ryan committee member R000570
CHRG-112hhrg78759,Peter J. Roskam PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Peter J. Roskam committee member R000580
CHRG-112hhrg78759,Richard E. Neal PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Richard E. Neal committee member N000015
CHRG-112hhrg78759,Rick Berg PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Rick Berg committee member B001272
CHRG-112hhrg78759,Ron Kind PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Ron Kind committee member K000188
CHRG-112hhrg78759,Sam Johnson PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Sam Johnson committee member J000174
CHRG-112hhrg78759,Sander M. Levin PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Sander M. Levin committee member L000263
CHRG-112hhrg78759,Shelley Berkley PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Shelley Berkley committee member B001231
CHRG-112hhrg78759,Tom Price PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Tom Price committee member P000591
CHRG-112hhrg78759,Tom Reed PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Tom Reed committee member R000585
CHRG-112hhrg78759,Vern Buchanan PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Vern Buchanan committee member B001260
CHRG-112hhrg78759,Wally Herger PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Wally Herger committee member H000528
CHRG-112hhrg78759,Xavier Becerra PROPOSAL TO REDUCE CHILD DEATHS DUE TO MALTREATMENT CHRG-112hhrg78759 Xavier Becerra committee member B000287

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