openregs: legislation_cosponsors: 61 rows where bill_id = "105-hr-983" sorted by sponsorship

Cosponsors for tracked legislation. Distinguishes original cosponsors (signed on at introduction) from later additions. Linked to congress_members via bioguide_id.

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

61 rows where bill_id = "105-hr-983" sorted by sponsorship_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	bill_id	bioguide_id	full_name	party	state	sponsorship_date ▲	is_original_cosponsor
105-hr-983,S000030	Civil Rights Procedures Protection Act of 1996 105-hr-983	S000030	Rep. Sanchez, Loretta [D-CA-46]	D	CA	1998-03-17	0
105-hr-983,E000179	Civil Rights Procedures Protection Act of 1996 105-hr-983	E000179	Rep. Engel, Eliot L. [D-NY-17]	D	NY	1997-11-13	0
105-hr-983,S000185	Civil Rights Procedures Protection Act of 1996 105-hr-983	S000185	Rep. Scott, Robert C. "Bobby" [D-VA-3]	D	VA	1997-10-28	0
105-hr-983,K000336	Civil Rights Procedures Protection Act of 1996 105-hr-983	K000336	Rep. Kucinich, Dennis J. [D-OH-10]	D	OH	1997-10-28	0
105-hr-983,M000309	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000309	Rep. McCarthy, Carolyn [D-NY-4]	D	NY	1997-10-28	0
105-hr-983,M000714	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000714	Rep. Millender-McDonald, Juanita [D-CA-37]	D	CA	1997-10-22	0
105-hr-983,B000177	Civil Rights Procedures Protection Act of 1996 105-hr-983	B000177	Rep. Barrett, Thomas M. [D-WI-5]	D	WI	1997-10-09	0
105-hr-983,G000535	Civil Rights Procedures Protection Act of 1996 105-hr-983	G000535	Rep. Gutierrez, Luis V. [D-IL-4]	D	IL	1997-10-09	0
105-hr-983,S000480	Civil Rights Procedures Protection Act of 1996 105-hr-983	S000480	Rep. Slaughter, Louise McIntosh [D-NY-28]	D	NY	1997-10-07	0
105-hr-983,T000057	Civil Rights Procedures Protection Act of 1996 105-hr-983	T000057	Rep. Tauscher, Ellen O. [D-CA-10]	D	CA	1997-10-07	0
105-hr-983,U000014	Civil Rights Procedures Protection Act of 1996 105-hr-983	U000014	Del. Underwood, Robert A. [D-GU-At Large]	D	GU	1997-10-07	0
105-hr-983,T000253	Civil Rights Procedures Protection Act of 1996 105-hr-983	T000253	Rep. Thurman, Karen L. [D-FL-5]	D	FL	1997-10-07	0
105-hr-983,T000326	Civil Rights Procedures Protection Act of 1996 105-hr-983	T000326	Rep. Towns, Edolphus [D-NY-10]	D	NY	1997-09-26	0
105-hr-983,W000187	Civil Rights Procedures Protection Act of 1996 105-hr-983	W000187	Rep. Waters, Maxine [D-CA-35]	D	CA	1997-09-26	0
105-hr-983,M000087	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000087	Rep. Maloney, Carolyn B. [D-NY-14]	D	NY	1997-09-04	0
105-hr-983,B000619	Civil Rights Procedures Protection Act of 1996 105-hr-983	B000619	Rep. Bonior, David E. [D-MI-10]	D	MI	1997-07-28	0
105-hr-983,C000380	Civil Rights Procedures Protection Act of 1996 105-hr-983	C000380	Del. Christian-Green, Donna M. [D-VI-At Large]	D	VI	1997-07-24	0
105-hr-983,M000312	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000312	Rep. McGovern, James P. [D-MA-3]	D	MA	1997-07-22	0
105-hr-983,R000053	Civil Rights Procedures Protection Act of 1996 105-hr-983	R000053	Rep. Rangel, Charles B. [D-NY-15]	D	NY	1997-07-17	0
105-hr-983,M000090	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000090	Rep. Maloney, James H. [D-CT-5]	D	CT	1997-07-11	0
105-hr-983,K000172	Civil Rights Procedures Protection Act of 1996 105-hr-983	K000172	Rep. Kildee, Dale E. [D-MI-9]	D	MI	1997-06-19	0
105-hr-983,K000259	Civil Rights Procedures Protection Act of 1996 105-hr-983	K000259	Rep. Kleczka, Gerald D. [D-WI-4]	D	WI	1997-06-12	0
105-hr-983,M000316	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000316	Rep. McCarthy, Karen [D-MO-5]	D	MO	1997-06-10	0
105-hr-983,P000452	Civil Rights Procedures Protection Act of 1996 105-hr-983	P000452	Rep. Poshard, Glenn [D-IL-19]	D	IL	1997-06-10	0
105-hr-983,L000397	Civil Rights Procedures Protection Act of 1996 105-hr-983	L000397	Rep. Lofgren, Zoe [D-CA-16]	D	CA	1997-06-10	0
105-hr-983,H000627	Civil Rights Procedures Protection Act of 1996 105-hr-983	H000627	Rep. Hinchey, Maurice D. [D-NY-26]	D	NY	1997-05-14	0
105-hr-983,D000216	Civil Rights Procedures Protection Act of 1996 105-hr-983	D000216	Rep. DeLauro, Rosa L. [D-CT-3]	D	CT	1997-04-30	0
105-hr-983,W000738	Civil Rights Procedures Protection Act of 1996 105-hr-983	W000738	Rep. Woolsey, Lynn C. [D-CA-6]	D	CA	1997-04-24	0
105-hr-983,W000207	Civil Rights Procedures Protection Act of 1996 105-hr-983	W000207	Rep. Watt, Melvin L. [D-NC-12]	D	NC	1997-04-23	0
105-hr-983,Y000013	Civil Rights Procedures Protection Act of 1996 105-hr-983	Y000013	Rep. Yates, Sidney R. [D-IL-9]	D	IL	1997-04-23	0
105-hr-983,L000287	Civil Rights Procedures Protection Act of 1996 105-hr-983	L000287	Rep. Lewis, John [D-GA-5]	D	GA	1997-04-15	0
105-hr-983,F000116	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000116	Rep. Filner, Bob [D-CA-50]	D	CA	1997-04-15	0
105-hr-983,M000725	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000725	Rep. Miller, George [D-CA-7]	D	CA	1997-04-08	0
105-hr-983,D000096	Civil Rights Procedures Protection Act of 1996 105-hr-983	D000096	Rep. Davis, Danny K. [D-IL-7]	D	IL	1997-03-21	0
105-hr-983,M000206	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000206	Rep. Martinez, Matthew G. [D-CA-31]	D	CA	1997-03-18	0
105-hr-983,J000070	Civil Rights Procedures Protection Act of 1996 105-hr-983	J000070	Rep. Jefferson, William J. [D-LA-2]	D	LA	1997-03-18	0
105-hr-983,D000197	Civil Rights Procedures Protection Act of 1996 105-hr-983	D000197	Rep. DeGette, Diana [D-CO-1]	D	CO	1997-03-12	0
105-hr-983,E000250	Civil Rights Procedures Protection Act of 1996 105-hr-983	E000250	Rep. Evans, Lane [D-IL-17]	D	IL	1997-03-12	0
105-hr-983,N000015	Civil Rights Procedures Protection Act of 1996 105-hr-983	N000015	Rep. Neal, Richard E. [D-MA-2]	D	MA	1997-03-12	0
105-hr-983,M000941	Civil Rights Procedures Protection Act of 1996 105-hr-983	M000941	Rep. Morella, Constance A. [R-MD-8]	R	MD	1997-03-06	1
105-hr-983,E000215	Civil Rights Procedures Protection Act of 1996 105-hr-983	E000215	Rep. Eshoo, Anna G. [D-CA-14]	D	CA	1997-03-06	1
105-hr-983,J000283	Civil Rights Procedures Protection Act of 1996 105-hr-983	J000283	Rep. Jackson, Jesse L., Jr. [D-IL-2]	D	IL	1997-03-06	1
105-hr-983,F000434	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000434	Rep. Furse, Elizabeth [D-OR-1]	D	OR	1997-03-06	1
105-hr-983,G000272	Civil Rights Procedures Protection Act of 1996 105-hr-983	G000272	Rep. Gonzalez, Henry B. [D-TX-20]	D	TX	1997-03-06	1
105-hr-983,B000410	Civil Rights Procedures Protection Act of 1996 105-hr-983	B000410	Rep. Berman, Howard L. [D-CA-26]	D	CA	1997-03-06	1
105-hr-983,O000085	Civil Rights Procedures Protection Act of 1996 105-hr-983	O000085	Rep. Olver, John W. [D-MA-1]	D	MA	1997-03-06	1
105-hr-983,P000197	Civil Rights Procedures Protection Act of 1996 105-hr-983	P000197	Rep. Pelosi, Nancy [D-CA-8]	D	CA	1997-03-06	1
105-hr-983,J000126	Civil Rights Procedures Protection Act of 1996 105-hr-983	J000126	Rep. Johnson, Eddie Bernice [D-TX-30]	D	TX	1997-03-06	1
105-hr-983,T000266	Civil Rights Procedures Protection Act of 1996 105-hr-983	T000266	Rep. Tierney, John F. [D-MA-6]	D	MA	1997-03-06	1
105-hr-983,F000392	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000392	Rep. Frost, Martin [D-TX-24]	D	TX	1997-03-06	1
105-hr-983,D000222	Civil Rights Procedures Protection Act of 1996 105-hr-983	D000222	Rep. Dellums, Ronald V. [D-CA-9]	D	CA	1997-03-06	1
105-hr-983,V000087	Civil Rights Procedures Protection Act of 1996 105-hr-983	V000087	Rep. Vento, Bruce F. [D-MN-4]	D	MN	1997-03-06	1
105-hr-983,F000339	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000339	Rep. Frank, Barney [D-MA-4]	D	MA	1997-03-06	1
105-hr-983,F000184	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000184	Rep. Flake, Floyd H. [D-NY-6]	D	NY	1997-03-06	1
105-hr-983,S000810	Civil Rights Procedures Protection Act of 1996 105-hr-983	S000810	Rep. Stark, Fortney Pete [D-CA-13]	D	CA	1997-03-06	1
105-hr-983,R000515	Civil Rights Procedures Protection Act of 1996 105-hr-983	R000515	Rep. Rush, Bobby L. [D-IL-1]	D	IL	1997-03-06	1
105-hr-983,N000002	Civil Rights Procedures Protection Act of 1996 105-hr-983	N000002	Rep. Nadler, Jerrold [D-NY-8]	D	NY	1997-03-06	1
105-hr-983,R000417	Civil Rights Procedures Protection Act of 1996 105-hr-983	R000417	Resident Commissioner Romero-Barcelo, Carlos A. [D-PR-At Large]	D	PR	1997-03-06	1
105-hr-983,F000010	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000010	Del. Faleomavaega, Eni F. H. [D-AS-At Large]	D	AS	1997-03-06	1
105-hr-983,F000043	Civil Rights Procedures Protection Act of 1996 105-hr-983	F000043	Rep. Fattah, Chaka [D-PA-2]	D	PA	1997-03-06	1
105-hr-983,N000147	Civil Rights Procedures Protection Act of 1996 105-hr-983	N000147	Del. Norton, Eleanor Holmes [D-DC-At Large]	D	DC	1997-03-06	1

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE legislation_cosponsors (
    bill_id TEXT NOT NULL REFERENCES legislation(bill_id),
    bioguide_id TEXT NOT NULL,
    full_name TEXT,
    party TEXT,
    state TEXT,
    sponsorship_date TEXT,
    is_original_cosponsor INTEGER,
    PRIMARY KEY (bill_id, bioguide_id)
);
CREATE INDEX idx_lc_bioguide ON legislation_cosponsors(bioguide_id);
CREATE INDEX idx_lc_bill ON legislation_cosponsors(bill_id);
CREATE INDEX idx_lc_original ON legislation_cosponsors(is_original_cosponsor);