openregs: legislation_cosponsors: 43 rows where bill_id = "108-s-1705" 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

43 rows where bill_id = "108-s-1705" 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
108-s-1705,J000072	Employment Non-Discrimination Act of 2003 108-s-1705	J000072	Sen. Jeffords, James M. [I-VT]	I	VT	2003-10-02	1
108-s-1705,C001040	Employment Non-Discrimination Act of 2003 108-s-1705	C001040	Sen. Chafee, Lincoln [R-RI]	R	RI	2003-10-02	1
108-s-1705,L000304	Employment Non-Discrimination Act of 2003 108-s-1705	L000304	Sen. Lieberman, Joseph I. [D-CT]	D	CT	2003-10-02	1
108-s-1705,A000069	Employment Non-Discrimination Act of 2003 108-s-1705	A000069	Sen. Akaka, Daniel K. [D-HI]	D	HI	2003-10-02	1
108-s-1705,B000243	Employment Non-Discrimination Act of 2003 108-s-1705	B000243	Sen. Baucus, Max [D-MT]	D	MT	2003-10-02	1
108-s-1705,B001233	Employment Non-Discrimination Act of 2003 108-s-1705	B001233	Sen. Bayh, Evan [D-IN]	D	IN	2003-10-02	1
108-s-1705,B000444	Employment Non-Discrimination Act of 2003 108-s-1705	B000444	Sen. Biden, Joseph R., Jr. [D-DE]	D	DE	2003-10-02	1
108-s-1705,B000468	Employment Non-Discrimination Act of 2003 108-s-1705	B000468	Sen. Bingaman, Jeff [D-NM]	D	NM	2003-10-02	1
108-s-1705,B000711	Employment Non-Discrimination Act of 2003 108-s-1705	B000711	Sen. Boxer, Barbara [D-CA]	D	CA	2003-10-02	1
108-s-1705,B000780	Employment Non-Discrimination Act of 2003 108-s-1705	B000780	Sen. Breaux, John B. [D-LA]	D	LA	2003-10-02	1
108-s-1705,C000127	Employment Non-Discrimination Act of 2003 108-s-1705	C000127	Sen. Cantwell, Maria [D-WA]	D	WA	2003-10-02	1
108-s-1705,C000174	Employment Non-Discrimination Act of 2003 108-s-1705	C000174	Sen. Carper, Thomas R. [D-DE]	D	DE	2003-10-02	1
108-s-1705,C001041	Employment Non-Discrimination Act of 2003 108-s-1705	C001041	Sen. Clinton, Hillary Rodham [D-NY]	D	NY	2003-10-02	1
108-s-1705,C001035	Employment Non-Discrimination Act of 2003 108-s-1705	C001035	Sen. Collins, Susan M. [R-ME]	R	ME	2003-10-02	1
108-s-1705,C001042	Employment Non-Discrimination Act of 2003 108-s-1705	C001042	Sen. Corzine, Jon S. [D-NJ]	D	NJ	2003-10-02	1
108-s-1705,D000064	Employment Non-Discrimination Act of 2003 108-s-1705	D000064	Sen. Daschle, Thomas A. [D-SD]	D	SD	2003-10-02	1
108-s-1705,D000596	Employment Non-Discrimination Act of 2003 108-s-1705	D000596	Sen. Dayton, Mark [D-MN]	D	MN	2003-10-02	1
108-s-1705,D000388	Employment Non-Discrimination Act of 2003 108-s-1705	D000388	Sen. Dodd, Christopher J. [D-CT]	D	CT	2003-10-02	1
108-s-1705,D000432	Employment Non-Discrimination Act of 2003 108-s-1705	D000432	Sen. Dorgan, Byron L. [D-ND]	D	ND	2003-10-02	1
108-s-1705,D000563	Employment Non-Discrimination Act of 2003 108-s-1705	D000563	Sen. Durbin, Richard J. [D-IL]	D	IL	2003-10-02	1
108-s-1705,E000286	Employment Non-Discrimination Act of 2003 108-s-1705	E000286	Sen. Edwards, John [D-NC]	D	NC	2003-10-02	1
108-s-1705,F000061	Employment Non-Discrimination Act of 2003 108-s-1705	F000061	Sen. Feingold, Russell D. [D-WI]	D	WI	2003-10-02	1
108-s-1705,F000062	Employment Non-Discrimination Act of 2003 108-s-1705	F000062	Sen. Feinstein, Dianne [D-CA]	D	CA	2003-10-02	1
108-s-1705,G000352	Employment Non-Discrimination Act of 2003 108-s-1705	G000352	Sen. Graham, Bob [D-FL]	D	FL	2003-10-02	1
108-s-1705,H000206	Employment Non-Discrimination Act of 2003 108-s-1705	H000206	Sen. Harkin, Tom [D-IA]	D	IA	2003-10-02	1
108-s-1705,I000025	Employment Non-Discrimination Act of 2003 108-s-1705	I000025	Sen. Inouye, Daniel K. [D-HI]	D	HI	2003-10-02	1
108-s-1705,K000148	Employment Non-Discrimination Act of 2003 108-s-1705	K000148	Sen. Kerry, John F. [D-MA]	D	MA	2003-10-02	1
108-s-1705,K000305	Employment Non-Discrimination Act of 2003 108-s-1705	K000305	Sen. Kohl, Herb [D-WI]	D	WI	2003-10-02	1
108-s-1705,L000550	Employment Non-Discrimination Act of 2003 108-s-1705	L000550	Sen. Landrieu, Mary L. [D-LA]	D	LA	2003-10-02	1
108-s-1705,L000123	Employment Non-Discrimination Act of 2003 108-s-1705	L000123	Sen. Lautenberg, Frank R. [D-NJ]	D	NJ	2003-10-02	1
108-s-1705,L000174	Employment Non-Discrimination Act of 2003 108-s-1705	L000174	Sen. Leahy, Patrick J. [D-VT]	D	VT	2003-10-02	1
108-s-1705,L000261	Employment Non-Discrimination Act of 2003 108-s-1705	L000261	Sen. Levin, Carl [D-MI]	D	MI	2003-10-02	1
108-s-1705,M000702	Employment Non-Discrimination Act of 2003 108-s-1705	M000702	Sen. Mikulski, Barbara A. [D-MD]	D	MD	2003-10-02	1
108-s-1705,M001111	Employment Non-Discrimination Act of 2003 108-s-1705	M001111	Sen. Murray, Patty [D-WA]	D	WA	2003-10-02	1
108-s-1705,N000032	Employment Non-Discrimination Act of 2003 108-s-1705	N000032	Sen. Nelson, Bill [D-FL]	D	FL	2003-10-02	1
108-s-1705,R000122	Employment Non-Discrimination Act of 2003 108-s-1705	R000122	Sen. Reed, Jack [D-RI]	D	RI	2003-10-02	1
108-s-1705,R000146	Employment Non-Discrimination Act of 2003 108-s-1705	R000146	Sen. Reid, Harry [D-NV]	D	NV	2003-10-02	1
108-s-1705,S000064	Employment Non-Discrimination Act of 2003 108-s-1705	S000064	Sen. Sarbanes, Paul S. [D-MD]	D	MD	2003-10-02	1
108-s-1705,S000148	Employment Non-Discrimination Act of 2003 108-s-1705	S000148	Sen. Schumer, Charles E. [D-NY]	D	NY	2003-10-02	1
108-s-1705,S001142	Employment Non-Discrimination Act of 2003 108-s-1705	S001142	Sen. Smith, Gordon H. [R-OR]	R	OR	2003-10-02	1
108-s-1705,S000709	Employment Non-Discrimination Act of 2003 108-s-1705	S000709	Sen. Specter, Arlen [R-PA]	R	PA	2003-10-02	1
108-s-1705,S000770	Employment Non-Discrimination Act of 2003 108-s-1705	S000770	Sen. Stabenow, Debbie [D-MI]	D	MI	2003-10-02	1
108-s-1705,W000779	Employment Non-Discrimination Act of 2003 108-s-1705	W000779	Sen. Wyden, Ron [D-OR]	D	OR	2003-10-02	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);