openregs: legislation_cosponsors: 46 rows where bill_id = "106-hconres-7" 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

46 rows where bill_id = "106-hconres-7" 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 ▲
106-hconres-7,S001147	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	S001147	Rep. Shows, Ronnie [D-MS-4]	D	MS	1999-03-17
106-hconres-7,B000013	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000013	Rep. Bachus, Spencer [R-AL-6]	R	AL	1999-03-17
106-hconres-7,U000031	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	U000031	Rep. Upton, Fred [R-MI-6]	R	MI	1999-03-17
106-hconres-7,N000081	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	N000081	Rep. Ney, Robert W. [R-OH-18]	R	OH	1999-03-17
106-hconres-7,C000100	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	C000100	Rep. Campbell, Tom [R-CA-15]	R	CA	1999-03-17
106-hconres-7,W000413	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	W000413	Rep. Whitfield, Ed [R-KY-1]	R	KY	1999-03-17
106-hconres-7,W000672	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	W000672	Rep. Wolf, Frank R. [R-VA-10]	R	VA	1999-03-17
106-hconres-7,T000253	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	T000253	Rep. Thurman, Karen L. [D-FL-5]	D	FL	1999-03-17
106-hconres-7,D000046	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	D000046	Rep. Danner, Pat [D-MO-6]	D	MO	1999-03-17
106-hconres-7,D000424	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	D000424	Rep. Dooley, Calvin M. [D-CA-20]	D	CA	1999-03-17
106-hconres-7,K000357	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	K000357	Rep. Kuykendall, Steven T. [R-CA-36]	R	CA	1999-03-17
106-hconres-7,L000169	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	L000169	Rep. Leach, James A. [R-IA-1]	R	IA	1999-03-17
106-hconres-7,K000078	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	K000078	Rep. Kelly, Sue W. [R-NY-19]	R	NY	1999-03-17
106-hconres-7,M000797	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	M000797	Rep. Mink, Patsy T. [D-HI-2]	D	HI	1999-03-17
106-hconres-7,L000553	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	L000553	Rep. LaTourette, Steven C. [R-OH-19]	R	OH	1999-03-17
106-hconres-7,R000258	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	R000258	Rep. Riley, Bob [R-AL-3]	R	AL	1999-03-17
106-hconres-7,H000074	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	H000074	Rep. Hall, Tony P. [D-OH-3]	D	OH	1999-03-17
106-hconres-7,H000807	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	H000807	Rep. Hostettler, John N. [R-IN-8]	R	IN	1999-03-17
106-hconres-7,M000206	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	M000206	Rep. Martinez, Matthew G. [D-CA-31]	D	CA	1999-03-17
106-hconres-7,M000472	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	M000472	Rep. McHugh, John M. [R-NY-24]	R	NY	1999-03-17
106-hconres-7,D000373	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	D000373	Rep. Dixon, Julian C. [D-CA-32]	D	CA	1999-03-17
106-hconres-7,M000941	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	M000941	Rep. Morella, Constance A. [R-MD-8]	R	MD	1999-03-17
106-hconres-7,F000116	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	F000116	Rep. Filner, Bob [D-CA-50]	D	CA	1999-03-17
106-hconres-7,B000400	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000400	Rep. Bentsen, Ken [D-TX-25]	D	TX	1999-03-17
106-hconres-7,B000403	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000403	Rep. Bereuter, Doug [R-NE-1]	R	NE	1999-03-17
106-hconres-7,N000002	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	N000002	Rep. Nadler, Jerrold [D-NY-8]	D	NY	1999-03-17
106-hconres-7,E000172	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	E000172	Rep. Emerson, Jo Ann [R-MO-8]	R	MO	1999-03-17
106-hconres-7,H000528	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	H000528	Rep. Herger, Wally [R-CA-2]	R	CA	1999-03-17
106-hconres-7,B000177	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000177	Rep. Barrett, Thomas M. [D-WI-5]	D	WI	1999-03-17
106-hconres-7,S000510	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	S000510	Rep. Smith, Adam [D-WA-9]	D	WA	1999-03-17
106-hconres-7,W000273	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	W000273	Rep. Weller, Jerry [R-IL-11]	R	IL	1999-03-17
106-hconres-7,P000583	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	P000583	Rep. Paul, Ron [R-TX-14]	R	TX	1999-03-17
106-hconres-7,S000344	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	S000344	Rep. Sherman, Brad [D-CA-24]	D	CA	1999-03-17
106-hconres-7,B000574	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000574	Rep. Blumenauer, Earl [D-OR-3]	D	OR	1999-03-17
106-hconres-7,R000462	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	R000462	Rep. Rothman, Steven R. [D-NJ-9]	D	NJ	1999-03-17
106-hconres-7,W000099	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	W000099	Rep. Walsh, James T. [R-NY-25]	R	NY	1999-03-17
106-hconres-7,B000179	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000179	Rep. Barrett, Bill [R-NE-3]	R	NE	1999-03-17
106-hconres-7,G000309	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	G000309	Rep. Gordon, Bart [D-TN-6]	D	TN	1999-03-17
106-hconres-7,P000099	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	P000099	Rep. Pastor, Ed [D-AZ-2]	D	AZ	1999-03-17
106-hconres-7,C001036	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	C001036	Rep. Capps, Lois [D-CA-22]	D	CA	1999-03-17
106-hconres-7,B000410	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000410	Rep. Berman, Howard L. [D-CA-26]	D	CA	1999-03-17
106-hconres-7,K000009	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	K000009	Rep. Kaptur, Marcy [D-OH-9]	D	OH	1999-03-17
106-hconres-7,O000164	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	O000164	Rep. Ose, Doug [R-CA-3]	R	CA	1999-03-17
106-hconres-7,H001030	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	H001030	Rep. Hill, Baron P. [D-IN-9]	D	IN	1999-03-17
106-hconres-7,B000619	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	B000619	Rep. Bonior, David E. [D-MI-10]	D	MI	1999-03-17
106-hconres-7,F000030	Expressing the sense of the Congress that the current Federal income tax deduction for interest paid on debt secured by a first or second home should not be further restricted. 106-hconres-7	F000030	Rep. Farr, Sam [D-CA-17]	D	CA	1999-03-17

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