openregs: crec_speakers: 27 rows where granule_id = "CREC-2017-01-13-pt1-PgH520" sorted by speaker

Normalized speaker data from the Congressional Record. Links members of Congress to their floor speeches, remarks, and procedural actions. 1,800+ unique speakers.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

27 rows where granule_id = "CREC-2017-01-13-pt1-PgH520" sorted by speaker_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	granule_id	speaker_name ▼	speaker_role	bioguide_id	party	state
CREC-2017-01-13-pt1-PgH520,A. Donald McEachin	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	A. Donald McEachin	speaking	M001200	D	VA
CREC-2017-01-13-pt1-PgH520,Adam Smith	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Adam Smith	speaking	S000510	D	WA
CREC-2017-01-13-pt1-PgH520,Brad R. Wenstrup	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Brad R. Wenstrup	speaking	W000815	R	OH
CREC-2017-01-13-pt1-PgH520,Bradley Byrne	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Bradley Byrne	speaking	B001289	R	AL
CREC-2017-01-13-pt1-PgH520,Don Bacon	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Don Bacon	speaking	B001298	R	NE
CREC-2017-01-13-pt1-PgH520,Duncan Hunter	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Duncan Hunter	speaking	H001048	R	CA
CREC-2017-01-13-pt1-PgH520,Earl Blumenauer	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Earl Blumenauer	speaking	B000574	D	OR
CREC-2017-01-13-pt1-PgH520,Jacky Rosen	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Jacky Rosen	speaking	R000608	D	NV
CREC-2017-01-13-pt1-PgH520,Jim Banks	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Jim Banks	speaking	B001299	R	IN
CREC-2017-01-13-pt1-PgH520,Joe Wilson	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Joe Wilson	speaking	W000795	R	SC
CREC-2017-01-13-pt1-PgH520,K. Michael Conaway	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	K. Michael Conaway	speaking	C001062	R	TX
CREC-2017-01-13-pt1-PgH520,Keith J. Rothfus	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Keith J. Rothfus	speaking	R000598	R	PA
CREC-2017-01-13-pt1-PgH520,Mac Thornberry	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Mac Thornberry	speaking	T000238	R	TX
CREC-2017-01-13-pt1-PgH520,Marcy Kaptur	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Marcy Kaptur	speaking	K000009	D	OH
CREC-2017-01-13-pt1-PgH520,Michael R. Turner	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Michael R. Turner	speaking	T000463	R	OH
CREC-2017-01-13-pt1-PgH520,Mike Coffman	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Mike Coffman	speaking	C001077	R	CO
CREC-2017-01-13-pt1-PgH520,Mike Gallagher	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Mike Gallagher	speaking	G000579	R	WI
CREC-2017-01-13-pt1-PgH520,Mike Rogers	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Mike Rogers	speaking	R000575	R	AL
CREC-2017-01-13-pt1-PgH520,Ro Khanna	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Ro Khanna	speaking	K000389	D	CA
CREC-2017-01-13-pt1-PgH520,Robert J. Wittman	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Robert J. Wittman	speaking	W000804	R	VA
CREC-2017-01-13-pt1-PgH520,Ron DeSantis	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Ron DeSantis	speaking	D000621	R	FL
CREC-2017-01-13-pt1-PgH520,Scott Taylor	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Scott Taylor	speaking	T000477	R	VA
CREC-2017-01-13-pt1-PgH520,Sheila Jackson Lee	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Sheila Jackson Lee	speaking	J000032	D	TX
CREC-2017-01-13-pt1-PgH520,Steve Russell	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Steve Russell	speaking	R000604	R	OK
CREC-2017-01-13-pt1-PgH520,Susan A. Davis	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Susan A. Davis	speaking	D000598	D	CA
CREC-2017-01-13-pt1-PgH520,Trent Kelly	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Trent Kelly	speaking	K000388	R	MS
CREC-2017-01-13-pt1-PgH520,Vicky Hartzler	PROVIDING FOR EXCEPTION TO LIMITATION AGAINST APPOINTMENT OF PERSONS AS SECRETARY OF DEFENSE WITHIN SEVEN YEARS OF RELIEF FROM ACTIVE DUTY CREC-2017-01-13-pt1-PgH520	Vicky Hartzler	speaking	H001053	R	MO

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);