crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
48 rows where granule_id = "CREC-2017-10-03-pt1-PgH7712" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name >30
- A. Donald McEachin 1
- Alma S. Adams 1
- Ann Wagner 1
- Anna G. Eshoo 1
- Barbara Lee 1
- Bill Foster 1
- Bob Goodlatte 1
- Brian Babin 1
- Brian J. Mast 1
- Christopher H. Smith 1
- David P. Roe 1
- Diana DeGette 1
- Diane Black 1
- Eliot L. Engel 1
- Gwen Moore 1
- Jackie Speier 1
- Janice D. Schakowsky 1
- Jeff Fortenberry 1
- Jerrold Nadler 1
- John Conyers, Jr. 1
- Julia Brownley 1
- Karen C. Handel 1
- Katherine M. Clark 1
- Kevin McCarthy 1
- Lois Frankel 1
- Luke Messer 1
- Mark Walker 1
- Martha Roby 1
- Mike Johnson 1
- Mrs. McMORRIS RODGERS 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);