openregs: legislation_cosponsors: 6 rows where bill_id = "111-hres-1069" 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

6 rows where bill_id = "111-hres-1069" 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
111-hres-1069,F000454	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	F000454	Rep. Foster, Bill [D-IL-14]	D	IL	2010-02-23	0
111-hres-1069,R000462	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	R000462	Rep. Rothman, Steven R. [D-NJ-9]	D	NJ	2010-02-23	0
111-hres-1069,H001032	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	H001032	Rep. Holt, Rush [D-NJ-12]	D	NJ	2010-02-03	1
111-hres-1069,E000092	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	E000092	Rep. Ehlers, Vernon J. [R-MI-3]	R	MI	2010-02-03	1
111-hres-1069,L000554	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	L000554	Rep. LoBiondo, Frank A. [R-NJ-2]	R	NJ	2010-02-03	1
111-hres-1069,P000096	Congratulating Willard S. Boyle and George E. Smith for being awarded the Nobel Prize in physics. 111-hres-1069	P000096	Rep. Pascrell, Bill, Jr. [D-NJ-8]	D	NJ	2010-02-03	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);