openregs: legislation_cosponsors: 136 rows where bill_id = "103-hconres-233" 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

136 rows where bill_id = "103-hconres-233" 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 ▲
103-hconres-233,R000436	A Child is Waiting Resolution 103-hconres-233	R000436	Rep. Rose, Charlie [D-NC-7]	D	NC	1994-10-06
103-hconres-233,N000002	A Child is Waiting Resolution 103-hconres-233	N000002	Rep. Nadler, Jerrold [D-NY-8]	D	NY	1994-10-06
103-hconres-233,C000127	A Child is Waiting Resolution 103-hconres-233	C000127	Rep. Cantwell, Maria [D-WA-1]	D	WA	1994-10-06
103-hconres-233,N000015	A Child is Waiting Resolution 103-hconres-233	N000015	Rep. Neal, Richard E. [D-MA-2]	D	MA	1994-10-06
103-hconres-233,C000178	A Child is Waiting Resolution 103-hconres-233	C000178	Rep. Carr, Bob [D-MI-8]	D	MI	1994-08-16
103-hconres-233,P000523	A Child is Waiting Resolution 103-hconres-233	P000523	Rep. Price, David E. [D-NC-4]	D	NC	1994-08-16
103-hconres-233,D000373	A Child is Waiting Resolution 103-hconres-233	D000373	Rep. Dixon, Julian C. [D-CA-32]	D	CA	1994-08-16
103-hconres-233,W000187	A Child is Waiting Resolution 103-hconres-233	W000187	Rep. Waters, Maxine [D-CA-35]	D	CA	1994-08-16
103-hconres-233,T000316	A Child is Waiting Resolution 103-hconres-233	T000316	Rep. Torres, Esteban Edward [D-CA-34]	D	CA	1994-08-16
103-hconres-233,B000997	A Child is Waiting Resolution 103-hconres-233	B000997	Rep. Bryant, John W. [D-TX-5]	D	TX	1994-08-16
103-hconres-233,T000405	A Child is Waiting Resolution 103-hconres-233	T000405	Rep. Tucker, Walter R., III [D-CA-37]	D	CA	1994-08-16
103-hconres-233,M000249	A Child is Waiting Resolution 103-hconres-233	M000249	Rep. Matsui, Robert T. [D-CA-5]	D	CA	1994-08-16
103-hconres-233,F000261	A Child is Waiting Resolution 103-hconres-233	F000261	Rep. Ford, Harold E. [D-TN-9]	D	TN	1994-08-16
103-hconres-233,H000074	A Child is Waiting Resolution 103-hconres-233	H000074	Rep. Hall, Tony P. [D-OH-3]	D	OH	1994-07-27
103-hconres-233,S000480	A Child is Waiting Resolution 103-hconres-233	S000480	Rep. Slaughter, Louise McIntosh [D-NY-28]	D	NY	1994-07-27
103-hconres-233,V000087	A Child is Waiting Resolution 103-hconres-233	V000087	Rep. Vento, Bruce F. [D-MN-4]	D	MN	1994-07-27
103-hconres-233,A000211	A Child is Waiting Resolution 103-hconres-233	A000211	Rep. Andrews, Thomas H. [D-ME-1]	D	ME	1994-07-27
103-hconres-233,B000410	A Child is Waiting Resolution 103-hconres-233	B000410	Rep. Berman, Howard L. [D-CA-26]	D	CA	1994-07-27
103-hconres-233,K000110	A Child is Waiting Resolution 103-hconres-233	K000110	Rep. Kennedy, Joseph P., II [D-MA-8]	D	MA	1994-07-27
103-hconres-233,M000797	A Child is Waiting Resolution 103-hconres-233	M000797	Rep. Mink, Patsy T. [D-HI-2]	D	HI	1994-07-27
103-hconres-233,V000081	A Child is Waiting Resolution 103-hconres-233	V000081	Rep. Velazquez, Nydia M. [D-NY-12]	D	NY	1994-07-27
103-hconres-233,C000141	A Child is Waiting Resolution 103-hconres-233	C000141	Rep. Cardin, Benjamin L. [D-MD-3]	D	MD	1994-07-27
103-hconres-233,N000016	A Child is Waiting Resolution 103-hconres-233	N000016	Rep. Neal, Stephen L. [D-NC-5]	D	NC	1994-07-27
103-hconres-233,W000207	A Child is Waiting Resolution 103-hconres-233	W000207	Rep. Watt, Melvin L. [D-NC-12]	D	NC	1994-07-27
103-hconres-233,M000015	A Child is Waiting Resolution 103-hconres-233	M000015	Rep. Machtley, Ronald K. [R-RI-1]	R	RI	1994-07-27
103-hconres-233,W000779	A Child is Waiting Resolution 103-hconres-233	W000779	Rep. Wyden, Ron [D-OR-3]	D	OR	1994-07-27
103-hconres-233,T000350	A Child is Waiting Resolution 103-hconres-233	T000350	Rep. Traficant, James A., Jr. [D-OH-17]	D	OH	1994-07-27
103-hconres-233,S001139	A Child is Waiting Resolution 103-hconres-233	S001139	Rep. Synar, Mike [D-OK-2]	D	OK	1994-07-27
103-hconres-233,P000149	A Child is Waiting Resolution 103-hconres-233	P000149	Rep. Payne, Donald M. [D-NJ-10]	D	NJ	1994-07-27
103-hconres-233,A000022	A Child is Waiting Resolution 103-hconres-233	A000022	Rep. Ackerman, Gary L. [D-NY-5]	D	NY	1994-07-27
103-hconres-233,K000328	A Child is Waiting Resolution 103-hconres-233	K000328	Rep. Kreidler, Mike [D-WA-9]	D	WA	1994-07-27
103-hconres-233,S000185	A Child is Waiting Resolution 103-hconres-233	S000185	Rep. Scott, Robert C. "Bobby" [D-VA-3]	D	VA	1994-07-27
103-hconres-233,M000466	A Child is Waiting Resolution 103-hconres-233	M000466	Rep. McHale, Paul [D-PA-15]	D	PA	1994-07-27
103-hconres-233,B000918	A Child is Waiting Resolution 103-hconres-233	B000918	Rep. Brown, George E., Jr. [D-CA-42]	D	CA	1994-07-27
103-hconres-233,J000126	A Child is Waiting Resolution 103-hconres-233	J000126	Rep. Johnson, Eddie Bernice [D-TX-30]	D	TX	1994-07-27
103-hconres-233,E000215	A Child is Waiting Resolution 103-hconres-233	E000215	Rep. Eshoo, Anna G. [D-CA-14]	D	CA	1994-07-27
103-hconres-233,C000634	A Child is Waiting Resolution 103-hconres-233	C000634	Rep. Collins, Cardiss [D-IL-7]	D	IL	1994-07-27
103-hconres-233,K000118	A Child is Waiting Resolution 103-hconres-233	K000118	Rep. Kennelly, Barbara B. [D-CT-1]	D	CT	1994-07-27
103-hconres-233,M000628	A Child is Waiting Resolution 103-hconres-233	M000628	Rep. Meek, Carrie P. [D-FL-17]	D	FL	1994-07-27
103-hconres-233,C000846	A Child is Waiting Resolution 103-hconres-233	C000846	Rep. Coyne, William J. [D-PA-14]	D	PA	1994-07-27
103-hconres-233,M000794	A Child is Waiting Resolution 103-hconres-233	M000794	Rep. Mineta, Norman Y. [D-CA-15]	D	CA	1994-06-28
103-hconres-233,M000933	A Child is Waiting Resolution 103-hconres-233	M000933	Rep. Moran, James P. [D-VA-8]	D	VA	1994-06-28
103-hconres-233,M000523	A Child is Waiting Resolution 103-hconres-233	M000523	Rep. McKinney, Cynthia A. [D-GA-11]	D	GA	1994-06-28
103-hconres-233,H000096	A Child is Waiting Resolution 103-hconres-233	H000096	Rep. Hamburg, Dan [D-CA-1]	D	CA	1994-06-28
103-hconres-233,D000327	A Child is Waiting Resolution 103-hconres-233	D000327	Rep. Dicks, Norman D. [D-WA-6]	D	WA	1994-06-28
103-hconres-233,C000714	A Child is Waiting Resolution 103-hconres-233	C000714	Rep. Conyers, John, Jr. [D-MI-14]	D	MI	1994-06-28
103-hconres-233,P000328	A Child is Waiting Resolution 103-hconres-233	P000328	Rep. Pickle, J. J. [D-TX-10]	D	TX	1994-06-28
103-hconres-233,S000148	A Child is Waiting Resolution 103-hconres-233	S000148	Rep. Schumer, Charles E. [D-NY-9]	D	NY	1994-06-28
103-hconres-233,F000235	A Child is Waiting Resolution 103-hconres-233	F000235	Rep. Foglietta, Thomas M. [D-PA-1]	D	PA	1994-06-28
103-hconres-233,L000119	A Child is Waiting Resolution 103-hconres-233	L000119	Rep. Laughlin, Greg [D-TX-14]	D	TX	1994-06-28
103-hconres-233,B000576	A Child is Waiting Resolution 103-hconres-233	B000576	Rep. Blute, Peter I. [R-MA-3]	R	MA	1994-06-28
103-hconres-233,S000094	A Child is Waiting Resolution 103-hconres-233	S000094	Rep. Sawyer, Tom [D-OH-14]	D	OH	1994-06-28
103-hconres-233,E000250	A Child is Waiting Resolution 103-hconres-233	E000250	Rep. Evans, Lane [D-IL-17]	D	IL	1994-06-16
103-hconres-233,W000215	A Child is Waiting Resolution 103-hconres-233	W000215	Rep. Waxman, Henry A. [D-CA-29]	D	CA	1994-06-16
103-hconres-233,M000388	A Child is Waiting Resolution 103-hconres-233	M000388	Rep. McCrery, Jim [R-LA-5]	R	LA	1994-06-16
103-hconres-233,S001113	A Child is Waiting Resolution 103-hconres-233	S001113	Rep. Swett, Dick [D-NH-2]	D	NH	1994-06-16
103-hconres-233,O000159	A Child is Waiting Resolution 103-hconres-233	O000159	Rep. Owens, Major R. [D-NY-11]	D	NY	1994-06-16
103-hconres-233,J000163	A Child is Waiting Resolution 103-hconres-233	J000163	Rep. Johnson, Nancy L. [R-CT-6]	R	CT	1994-06-16
103-hconres-233,W000784	A Child is Waiting Resolution 103-hconres-233	W000784	Rep. Wynn, Albert Russell [D-MD-4]	D	MD	1994-06-16
103-hconres-233,F000110	A Child is Waiting Resolution 103-hconres-233	F000110	Rep. Fields, Cleo [D-LA-4]	D	LA	1994-06-16
103-hconres-233,W000738	A Child is Waiting Resolution 103-hconres-233	W000738	Rep. Woolsey, Lynn C. [D-CA-6]	D	CA	1994-06-16
103-hconres-233,Y000013	A Child is Waiting Resolution 103-hconres-233	Y000013	Rep. Yates, Sidney R. [D-IL-9]	D	IL	1994-06-16
103-hconres-233,F000184	A Child is Waiting Resolution 103-hconres-233	F000184	Rep. Flake, Floyd H. [D-NY-6]	D	NY	1994-06-16
103-hconres-233,H000627	A Child is Waiting Resolution 103-hconres-233	H000627	Rep. Hinchey, Maurice D. [D-NY-26]	D	NY	1994-06-16
103-hconres-233,W000268	A Child is Waiting Resolution 103-hconres-233	W000268	Rep. Weldon, Curt [R-PA-7]	R	PA	1994-06-16
103-hconres-233,T000314	A Child is Waiting Resolution 103-hconres-233	T000314	Rep. Torkildsen, Peter G. [R-MA-6]	R	MA	1994-06-16
103-hconres-233,B000318	A Child is Waiting Resolution 103-hconres-233	B000318	Rep. Beilenson, Anthony C. [D-CA-24]	D	CA	1994-06-16
103-hconres-233,H000621	A Child is Waiting Resolution 103-hconres-233	H000621	Rep. Hilliard, Earl F. [D-AL-7]	D	AL	1994-06-16
103-hconres-233,H001022	A Child is Waiting Resolution 103-hconres-233	H001022	Rep. Hyde, Henry J. [R-IL-6]	R	IL	1994-06-16
103-hconres-233,F000434	A Child is Waiting Resolution 103-hconres-233	F000434	Rep. Furse, Elizabeth [D-OR-1]	D	OR	1994-06-16
103-hconres-233,D000355	A Child is Waiting Resolution 103-hconres-233	D000355	Rep. Dingell, John D. [D-MI-16]	D	MI	1994-06-16
103-hconres-233,K000259	A Child is Waiting Resolution 103-hconres-233	K000259	Rep. Kleczka, Gerald D. [D-WI-4]	D	WI	1994-06-16
103-hconres-233,C000767	A Child is Waiting Resolution 103-hconres-233	C000767	Rep. Coppersmith, Sam [D-AZ-1]	D	AZ	1994-06-16
103-hconres-233,M000941	A Child is Waiting Resolution 103-hconres-233	M000941	Rep. Morella, Constance A. [R-MD-8]	R	MD	1994-06-16
103-hconres-233,R000229	A Child is Waiting Resolution 103-hconres-233	R000229	Rep. Richardson, Bill [D-NM-3]	D	NM	1994-06-16
103-hconres-233,T000317	A Child is Waiting Resolution 103-hconres-233	T000317	Rep. Torricelli, Robert G. [D-NJ-9]	D	NJ	1994-06-16
103-hconres-233,J000187	A Child is Waiting Resolution 103-hconres-233	J000187	Rep. Johnston, Harry [D-FL-19]	D	FL	1994-06-16
103-hconres-233,M000133	A Child is Waiting Resolution 103-hconres-233	M000133	Rep. Markey, Edward J. [D-MA-7]	D	MA	1994-06-16
103-hconres-233,S000142	A Child is Waiting Resolution 103-hconres-233	S000142	Rep. Schroeder, Patricia [D-CO-1]	D	CO	1994-06-16
103-hconres-233,S000477	A Child is Waiting Resolution 103-hconres-233	S000477	Rep. Slattery, Jim [D-KS-2]	D	KS	1994-05-26
103-hconres-233,B000517	A Child is Waiting Resolution 103-hconres-233	B000517	Rep. Blackwell, Lucien E. [D-PA-2]	D	PA	1994-05-26
103-hconres-233,M000725	A Child is Waiting Resolution 103-hconres-233	M000725	Rep. Miller, George [D-CA-7]	D	CA	1994-05-26
103-hconres-233,F000116	A Child is Waiting Resolution 103-hconres-233	F000116	Rep. Filner, Bob [D-CA-50]	D	CA	1994-05-26
103-hconres-233,W000326	A Child is Waiting Resolution 103-hconres-233	W000326	Rep. Wheat, Alan [D-MO-5]	D	MO	1994-05-26
103-hconres-233,R000011	A Child is Waiting Resolution 103-hconres-233	R000011	Rep. Rahall, Nick J., II [D-WV-3]	D	WV	1994-05-26
103-hconres-233,L000287	A Child is Waiting Resolution 103-hconres-233	L000287	Rep. Lewis, John [D-GA-5]	D	GA	1994-05-26
103-hconres-233,R000515	A Child is Waiting Resolution 103-hconres-233	R000515	Rep. Rush, Bobby L. [D-IL-1]	D	IL	1994-05-26
103-hconres-233,P000265	A Child is Waiting Resolution 103-hconres-233	P000265	Rep. Petri, Thomas E. [R-WI-6]	R	WI	1994-05-26
103-hconres-233,O000006	A Child is Waiting Resolution 103-hconres-233	O000006	Rep. Oberstar, James L. [D-MN-8]	D	MN	1994-05-26
103-hconres-233,F000339	A Child is Waiting Resolution 103-hconres-233	F000339	Rep. Frank, Barney [D-MA-4]	D	MA	1994-05-26
103-hconres-233,J000177	A Child is Waiting Resolution 103-hconres-233	J000177	Rep. Johnson, Tim [D-SD-At Large]	D	SD	1994-05-26
103-hconres-233,G000410	A Child is Waiting Resolution 103-hconres-233	G000410	Rep. Green, Gene [D-TX-29]	D	TX	1994-05-26
103-hconres-233,M000342	A Child is Waiting Resolution 103-hconres-233	M000342	Rep. McCloskey, Frank [D-IN-8]	D	IN	1994-05-26
103-hconres-233,U000031	A Child is Waiting Resolution 103-hconres-233	U000031	Rep. Upton, Fred [R-MI-6]	R	MI	1994-05-26
103-hconres-233,B000151	A Child is Waiting Resolution 103-hconres-233	B000151	Rep. Barlow, Tom [D-KY-1]	D	KY	1994-05-26
103-hconres-233,B000490	A Child is Waiting Resolution 103-hconres-233	B000490	Rep. Bishop, Sanford D., Jr. [D-GA-2]	D	GA	1994-05-26
103-hconres-233,A000014	A Child is Waiting Resolution 103-hconres-233	A000014	Rep. Abercrombie, Neil [D-HI-1]	D	HI	1994-05-26
103-hconres-233,B000462	A Child is Waiting Resolution 103-hconres-233	B000462	Rep. Bilbray, James H. [D-NV-1]	D	NV	1994-05-26
103-hconres-233,C000488	A Child is Waiting Resolution 103-hconres-233	C000488	Rep. Clay, William (Bill) [D-MO-1]	D	MO	1994-05-26
103-hconres-233,M000206	A Child is Waiting Resolution 103-hconres-233	M000206	Rep. Martinez, Matthew G. [D-CA-31]	D	CA	1994-05-26

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