crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
31 rows where granule_id = "CREC-2017-07-25-pt1-PgH6268" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name >30
- A. Donald McEachin 1
- Al Lawson, Jr. 1
- Andy Barr 1
- Barry Loudermilk 1
- Bill Foster 1
- Bill Huizenga 1
- Blaine Luetkemeyer 1
- Bob Goodlatte 1
- Brad Sherman 1
- Carolyn B. Maloney 1
- Claudia Tenney 1
- David A. Trott 1
- David Kustoff 1
- David N. Cicilline 1
- Henry C. "Hank" Johnson, Jr. 1
- Jeb Hensarling 1
- John P. Sarbanes 1
- Keith Ellison 1
- Keith J. Rothfus 1
- Mark Takano 1
- Matt Cartwright 1
- Maxine Waters 1
- Michael E. Capuano 1
- Nancy Pelosi 1
- Nydia M. Velazquez 1
- Robert C. "Bobby" Scott 1
- Roger Williams 1
- Scott R. Tipton 1
- Sheila Jackson Lee 1
- Susan A. Davis 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);