openregs: legislation_cosponsors: 38 rows where bill_id = "103-hr-3288" 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

38 rows where bill_id = "103-hr-3288" 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
103-hr-3288,B000179	Public Accommodations Exception Act of 1993 103-hr-3288	B000179	Rep. Barrett, Bill [R-NE-3]	R	NE	1994-08-02	0
103-hr-3288,M000933	Public Accommodations Exception Act of 1993 103-hr-3288	M000933	Rep. Moran, James P. [D-VA-8]	D	VA	1994-07-26	0
103-hr-3288,L000381	Public Accommodations Exception Act of 1993 103-hr-3288	L000381	Rep. Lloyd, Marilyn [D-TN-3]	D	TN	1994-07-26	0
103-hr-3288,C000873	Public Accommodations Exception Act of 1993 103-hr-3288	C000873	Rep. Crane, Philip M. [R-IL-8]	R	IL	1994-07-14	0
103-hr-3288,C000059	Public Accommodations Exception Act of 1993 103-hr-3288	C000059	Rep. Calvert, Ken [R-CA-43]	R	CA	1994-07-12	0
103-hr-3288,S001113	Public Accommodations Exception Act of 1993 103-hr-3288	S001113	Rep. Swett, Dick [D-NH-2]	D	NH	1994-06-28	0
103-hr-3288,S001044	Public Accommodations Exception Act of 1993 103-hr-3288	S001044	Rep. Stump, Bob [R-AZ-3]	R	AZ	1994-06-09	0
103-hr-3288,U000031	Public Accommodations Exception Act of 1993 103-hr-3288	U000031	Rep. Upton, Fred [R-MI-6]	R	MI	1994-06-08	0
103-hr-3288,G000121	Public Accommodations Exception Act of 1993 103-hr-3288	G000121	Rep. Gekas, George W. [R-PA-17]	R	PA	1994-05-26	0
103-hr-3288,F000349	Public Accommodations Exception Act of 1993 103-hr-3288	F000349	Rep. Franks, Bob [R-NJ-7]	R	NJ	1994-05-12	0
103-hr-3288,K000328	Public Accommodations Exception Act of 1993 103-hr-3288	K000328	Rep. Kreidler, Mike [D-WA-9]	D	WA	1994-04-26	0
103-hr-3288,N000172	Public Accommodations Exception Act of 1993 103-hr-3288	N000172	Rep. Nussle, Jim [R-IA-2]	R	IA	1994-04-26	0
103-hr-3288,D000191	Public Accommodations Exception Act of 1993 103-hr-3288	D000191	Rep. DeFazio, Peter A. [D-OR-4]	D	OR	1994-04-20	0
103-hr-3288,F000049	Public Accommodations Exception Act of 1993 103-hr-3288	F000049	Rep. Fawell, Harris W. [R-IL-13]	R	IL	1994-04-18	0
103-hr-3288,L000267	Public Accommodations Exception Act of 1993 103-hr-3288	L000267	Rep. Levy, David A. [R-NY-4]	R	NY	1994-04-13	0
103-hr-3288,A000210	Public Accommodations Exception Act of 1993 103-hr-3288	A000210	Rep. Andrews, Robert E. [D-NJ-1]	D	NJ	1994-04-13	0
103-hr-3288,M000865	Public Accommodations Exception Act of 1993 103-hr-3288	M000865	Rep. Montgomery, G. V. (Sonny) [D-MS-3]	D	MS	1994-04-12	0
103-hr-3288,K000220	Public Accommodations Exception Act of 1993 103-hr-3288	K000220	Rep. Kingston, Jack [R-GA-1]	R	GA	1994-04-12	0
103-hr-3288,G000291	Public Accommodations Exception Act of 1993 103-hr-3288	G000291	Rep. Goodling, William F. [R-PA-19]	R	PA	1994-03-24	0
103-hr-3288,G000025	Public Accommodations Exception Act of 1993 103-hr-3288	G000025	Rep. Gallo, Dean A. [R-NJ-11]	R	NJ	1994-03-24	0
103-hr-3288,H000676	Public Accommodations Exception Act of 1993 103-hr-3288	H000676	Rep. Hoekstra, Peter [R-MI-2]	R	MI	1994-03-22	0
103-hr-3288,F000235	Public Accommodations Exception Act of 1993 103-hr-3288	F000235	Rep. Foglietta, Thomas M. [D-PA-1]	D	PA	1994-03-21	0
103-hr-3288,M001088	Public Accommodations Exception Act of 1993 103-hr-3288	M001088	Rep. Murphy, Austin J. [D-PA-20]	D	PA	1994-03-10	0
103-hr-3288,W000672	Public Accommodations Exception Act of 1993 103-hr-3288	W000672	Rep. Wolf, Frank R. [R-VA-10]	R	VA	1994-03-02	0
103-hr-3288,P000152	Public Accommodations Exception Act of 1993 103-hr-3288	P000152	Rep. Payne, Lewis F., Jr. [D-VA-5]	D	VA	1994-02-28	0
103-hr-3288,L000556	Public Accommodations Exception Act of 1993 103-hr-3288	L000556	Rep. LaFalce, John J. [D-NY-29]	D	NY	1994-02-10	0
103-hr-3288,G000289	Public Accommodations Exception Act of 1993 103-hr-3288	G000289	Rep. Goodlatte, Bob [R-VA-6]	R	VA	1994-02-07	0
103-hr-3288,S000477	Public Accommodations Exception Act of 1993 103-hr-3288	S000477	Rep. Slattery, Jim [D-KS-2]	D	KS	1994-02-03	0
103-hr-3288,R000243	Public Accommodations Exception Act of 1993 103-hr-3288	R000243	Rep. Ridge, Thomas J. [R-PA-21]	R	PA	1994-02-03	0
103-hr-3288,K000274	Public Accommodations Exception Act of 1993 103-hr-3288	K000274	Rep. Klug, Scott L. [R-WI-2]	R	WI	1994-02-03	0
103-hr-3288,F000328	Public Accommodations Exception Act of 1993 103-hr-3288	F000328	Rep. Fowler, Tillie [R-FL-4]	R	FL	1994-02-01	0
103-hr-3288,Z000004	Public Accommodations Exception Act of 1993 103-hr-3288	Z000004	Rep. Zeliff, William H., Jr. [R-NH-1]	R	NH	1994-02-01	0
103-hr-3288,R000307	Public Accommodations Exception Act of 1993 103-hr-3288	R000307	Rep. Roberts, Pat [R-KS-1]	R	KS	1994-02-01	0
103-hr-3288,M000015	Public Accommodations Exception Act of 1993 103-hr-3288	M000015	Rep. Machtley, Ronald K. [R-RI-1]	R	RI	1994-01-25	0
103-hr-3288,P000555	Public Accommodations Exception Act of 1993 103-hr-3288	P000555	Rep. Pryce, Deborah [R-OH-15]	R	OH	1994-01-25	0
103-hr-3288,Q000016	Public Accommodations Exception Act of 1993 103-hr-3288	Q000016	Rep. Quinn, Jack [R-NY-30]	R	NY	1994-01-25	0
103-hr-3288,S001144	Public Accommodations Exception Act of 1993 103-hr-3288	S001144	Rep. Shays, Christopher [R-CT-4]	R	CT	1994-01-25	0
103-hr-3288,P000099	Public Accommodations Exception Act of 1993 103-hr-3288	P000099	Rep. Pastor, Ed [D-AZ-2]	D	AZ	1993-10-14	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);