crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
27 rows where granule_id = "CREC-2017-02-01-pt1-PgH840" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name 27
- A. Donald McEachin 1
- Alan S. Lowenthal 1
- Andy Barr 1
- Anthony G. Brown 1
- Bill Johnson 1
- Bob Gibbs 1
- Brenda L. Lawrence 1
- David B. McKinley 1
- Donald S. Beyer, Jr. 1
- Doug LaMalfa 1
- Doug Lamborn 1
- Evan H. Jenkins 1
- Harold Rogers 1
- Henry C. "Hank" Johnson, Jr. 1
- James B. Renacci 1
- James Comer 1
- Jared Huffman 1
- John A. Yarmuth 1
- Keith J. Rothfus 1
- Mike Bost 1
- Paul A. Gosar 1
- Peter A. DeFazio 1
- Raul M. Grijalva 1
- Rob Bishop 1
- Rodney Davis 1
- Scott R. Tipton 1
- Ted S. Yoho 1
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE crec_speakers (
granule_id TEXT NOT NULL REFERENCES congressional_record(granule_id),
speaker_name TEXT NOT NULL,
speaker_role TEXT,
bioguide_id TEXT,
party TEXT,
state TEXT,
PRIMARY KEY (granule_id, speaker_name)
);
CREATE INDEX idx_crec_speaker_name ON crec_speakers(speaker_name);
CREATE INDEX idx_crec_speaker_bioguide ON crec_speakers(bioguide_id);
CREATE INDEX idx_crec_speaker_granule ON crec_speakers(granule_id);