crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
22 rows where granule_id = "CREC-2017-09-07-pt1-PgH7135" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name 22
- A. Donald McEachin 1
- Andy Harris 1
- Betty McCollum 1
- Bruce Poliquin 1
- David E. Price 1
- Denny Heck 1
- Derek Kilmer 1
- Don Bacon 1
- Erik Paulsen 1
- Glenn Thompson 1
- H. Morgan Griffith 1
- James R. Langevin 1
- Jody B. Hice 1
- Ken Calvert 1
- Leonard Lance 1
- Louise McIntosh Slaughter 1
- Martha McSally 1
- Raul M. Grijalva 1
- Sheila Jackson Lee 1
- Stacey E. Plaskett 1
- Tom Emmer 1
- Tom O'Halleran 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);