openregs: legislation_cosponsors: 39 rows where bill_id = "102-hconres-285" 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

39 rows where bill_id = "102-hconres-285" 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 ▲
102-hconres-285,M000306	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	M000306	Rep. McCandless, Alfred A. (Al) [R-CA-37]	R	CA	1992-05-13
102-hconres-285,H000151	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	H000151	Rep. Hancock, Mel [R-MO-7]	R	MO	1992-04-07
102-hconres-285,H000444	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	H000444	Rep. Hefley, Joel [R-CO-5]	R	CO	1992-04-07
102-hconres-285,M000684	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	M000684	Rep. Meyers, Jan [R-KS-3]	R	KS	1992-04-07
102-hconres-285,B000072	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	B000072	Rep. Baker, Richard H. [R-LA-6]	R	LA	1992-03-12
102-hconres-285,B000213	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	B000213	Rep. Barton, Joe [R-TX-6]	R	TX	1992-03-12
102-hconres-285,B000589	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	B000589	Rep. Boehner, John A. [R-OH-8]	R	OH	1992-03-12
102-hconres-285,B001066	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	B001066	Rep. Bunning, Jim [R-KY-4]	R	KY	1992-03-12
102-hconres-285,C000830	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	C000830	Rep. Cox, Christopher [R-CA-40]	R	CA	1992-03-12
102-hconres-285,C000873	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	C000873	Rep. Crane, Philip M. [R-IL-12]	R	IL	1992-03-12
102-hconres-285,D000044	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	D000044	Rep. Dannemeyer, William E. [R-CA-39]	R	CA	1992-03-12
102-hconres-285,D000429	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	D000429	Rep. Doolittle, John T. [R-CA-14]	R	CA	1992-03-12
102-hconres-285,D000435	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	D000435	Rep. Dornan, Robert K. [R-CA-38]	R	CA	1992-03-12
102-hconres-285,F000049	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	F000049	Rep. Fawell, Harris W. [R-IL-13]	R	IL	1992-03-12
102-hconres-285,G000180	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	G000180	Rep. Gilchrest, Wayne T. [R-MD-1]	R	MD	1992-03-12
102-hconres-285,G000225	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	G000225	Rep. Gingrich, Newt [R-GA-6]	R	GA	1992-03-12
102-hconres-285,G000291	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	G000291	Rep. Goodling, William F. [R-PA-19]	R	PA	1992-03-12
102-hconres-285,H000323	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	H000323	Rep. Hastert, J. Dennis [R-IL-14]	R	IL	1992-03-12
102-hconres-285,H000666	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	H000666	Rep. Hobson, David L. [R-OH-7]	R	OH	1992-03-12
102-hconres-285,I000024	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	I000024	Rep. Inhofe, James M. [R-OK-1]	R	OK	1992-03-12
102-hconres-285,J000174	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	J000174	Rep. Johnson, Sam [R-TX-3]	R	TX	1992-03-12
102-hconres-285,L000020	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	L000020	Rep. Lagomarsino, Robert J. [R-CA-19]	R	CA	1992-03-12
102-hconres-285,L000169	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	L000169	Rep. Leach, James A. [R-IA-1]	R	IA	1992-03-12
102-hconres-285,L000479	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	L000479	Rep. Lowery, Bill [R-CA-41]	R	CA	1992-03-12
102-hconres-285,M000388	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	M000388	Rep. McCrery, Jim [R-LA-4]	R	LA	1992-03-12
102-hconres-285,N000016	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	N000016	Rep. Neal, Stephen L. [D-NC-5]	D	NC	1992-03-12
102-hconres-285,O000163	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	O000163	Rep. Oxley, Michael G. [R-OH-4]	R	OH	1992-03-12
102-hconres-285,P000005	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	P000005	Rep. Packard, Ron [R-CA-43]	R	CA	1992-03-12
102-hconres-285,P000148	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	P000148	Rep. Paxon, Bill [R-NY-31]	R	NY	1992-03-12
102-hconres-285,R000072	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	R000072	Rep. Ravenel, Arthur, Jr. [R-SC-1]	R	SC	1992-03-12
102-hconres-285,R000189	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	R000189	Rep. Rhodes, John J., III [R-AZ-1]	R	AZ	1992-03-12
102-hconres-285,R000252	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	R000252	Rep. Riggs, Frank [R-CA-1]	R	CA	1992-03-12
102-hconres-285,S000059	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000059	Rep. Santorum, Rick [R-PA-18]	R	PA	1992-03-12
102-hconres-285,S000097	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000097	Rep. Saxton, Jim [R-NJ-13]	R	NJ	1992-03-12
102-hconres-285,S000146	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000146	Rep. Schulze, Richard T. [R-PA-5]	R	PA	1992-03-12
102-hconres-285,S000244	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000244	Rep. Sensenbrenner, F. James, Jr. [R-WI-9]	R	WI	1992-03-12
102-hconres-285,S000675	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000675	Rep. Solomon, Gerald B. H. [R-NY-24]	R	NY	1992-03-12
102-hconres-285,S000822	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S000822	Rep. Stearns, Cliff [R-FL-6]	R	FL	1992-03-12
102-hconres-285,S001044	Expressing the sense of the Congress that the President has the authority to, and should, implement the indexation of the basis of assets for purposes of determining the amount of gain which is subject to taxation. 102-hconres-285	S001044	Rep. Stump, Bob [R-AZ-3]	R	AZ	1992-03-12

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