crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
30 rows where granule_id = "CREC-2018-01-19-pt1-PgH560" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name 30
- A. Donald McEachin 1
- Ami Bera 1
- Barbara Lee 1
- Betty McCollum 1
- Blake Farenthold 1
- Bob Goodlatte 1
- Brian Babin 1
- Carolyn B. Maloney 1
- Christopher H. Smith 1
- Diane Black 1
- Janice D. Schakowsky 1
- Jerrold Nadler 1
- Jim Banks 1
- Judy Chu 1
- Keith J. Rothfus 1
- Kristi L. Noem 1
- Lois Frankel 1
- Marsha Blackburn 1
- Martha Roby 1
- Paul Mitchell 1
- Pramila Jayapal 1
- Ralph Norman 1
- Robert B. Aderholt 1
- Rosa L. DeLauro 1
- Sheila Jackson Lee 1
- Steve Cohen 1
- Suzanne Bonamici 1
- Ted Budd 1
- Vicky Hartzler 1
- Virginia Foxx 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);