hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
34 rows where package_id = "CHRG-113hhrg89808" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-113hhrg89808,Blake Farenthold | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Blake Farenthold | committee member | F000460 |
| CHRG-113hhrg89808,Bob Goodlatte | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Bob Goodlatte | committee member | G000289 |
| CHRG-113hhrg89808,Cedric L. Richmond | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Cedric L. Richmond | committee member | R000588 |
| CHRG-113hhrg89808,Darrell E. Issa | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Darrell E. Issa | committee member | I000056 |
| CHRG-113hhrg89808,David N. Cicilline | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | David N. Cicilline | committee member | C001084 |
| CHRG-113hhrg89808,Doug Collins | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Doug Collins | committee member | C001093 |
| CHRG-113hhrg89808,George Holding | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | George Holding | committee member | H001065 |
| CHRG-113hhrg89808,Hakeem S. Jeffries | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Hakeem S. Jeffries | committee member | J000294 |
| CHRG-113hhrg89808,Howard Coble | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Howard Coble | committee member | C000556 |
| CHRG-113hhrg89808,Jason Chaffetz | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Jason Chaffetz | committee member | C001076 |
| CHRG-113hhrg89808,Jason Smith | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Jason Smith | committee member | S001195 |
| CHRG-113hhrg89808,Jerrold Nadler | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Jerrold Nadler | committee member | N000002 |
| CHRG-113hhrg89808,Jim Jordan | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Jim Jordan | committee member | J000289 |
| CHRG-113hhrg89808,Joe Garcia | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Joe Garcia | committee member | G000573 |
| CHRG-113hhrg89808,John Conyers, Jr. | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | John Conyers, Jr. | committee member | C000714 |
| CHRG-113hhrg89808,Judy Chu | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Judy Chu | committee member | C001080 |
| CHRG-113hhrg89808,Karen Bass | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Karen Bass | committee member | B001270 |
| CHRG-113hhrg89808,Lamar Smith | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Lamar Smith | committee member | S000583 |
| CHRG-113hhrg89808,Louie Gohmert | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Louie Gohmert | committee member | G000552 |
| CHRG-113hhrg89808,Luis V. Gutierrez | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Luis V. Gutierrez | committee member | |
| CHRG-113hhrg89808,Raul R. Labrador | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Raul R. Labrador | committee member | |
| CHRG-113hhrg89808,Ron DeSantis | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Ron DeSantis | committee member | D000621 |
| CHRG-113hhrg89808,Sheila Jackson Lee | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Sheila Jackson Lee | committee member | J000032 |
| CHRG-113hhrg89808,Spencer Bachus | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Spencer Bachus | committee member | B000013 |
| CHRG-113hhrg89808,Steve Chabot | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Steve Chabot | committee member | C000266 |
| CHRG-113hhrg89808,Steve Cohen | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Steve Cohen | committee member | C001068 |
| CHRG-113hhrg89808,Steve King | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Steve King | committee member | K000362 |
| CHRG-113hhrg89808,Suzan K. DelBene | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Suzan K. DelBene | committee member | D000617 |
| CHRG-113hhrg89808,Ted Poe | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Ted Poe | committee member | P000592 |
| CHRG-113hhrg89808,Theodore E. Deutch | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Theodore E. Deutch | committee member | D000610 |
| CHRG-113hhrg89808,Tom Marino | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Tom Marino | committee member | M001179 |
| CHRG-113hhrg89808,Trent Franks | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Trent Franks | committee member | F000448 |
| CHRG-113hhrg89808,Trey Gowdy | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Trey Gowdy | committee member | G000566 |
| CHRG-113hhrg89808,Zoe Lofgren | CHAPTER 12 OF TITLE 17 CHRG-113hhrg89808 | Zoe Lofgren | committee member | L000397 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);