openregs: legislation_cosponsors: 7 rows where bill_id = "111-hr-5569" 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

7 rows where bill_id = "111-hr-5569" 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-hr-5569,B001247	National Flood Insurance Program Extension Act of 2010 111-hr-5569	B001247	Rep. Brown-Waite, Ginny [R-FL-5]	R	FL	2010-06-23	0
111-hr-5569,H000636	National Flood Insurance Program Extension Act of 2010 111-hr-5569	H000636	Rep. Hinojosa, Ruben [D-TX-15]	D	TX	2010-06-23	0
111-hr-5569,H000324	National Flood Insurance Program Extension Act of 2010 111-hr-5569	H000324	Rep. Hastings, Alcee L. [D-FL-23]	D	FL	2010-06-23	0
111-hr-5569,C000754	National Flood Insurance Program Extension Act of 2010 111-hr-5569	C000754	Rep. Cooper, Jim [D-TN-5]	D	TN	2010-06-23	0
111-hr-5569,F000339	National Flood Insurance Program Extension Act of 2010 111-hr-5569	F000339	Rep. Frank, Barney [D-MA-4]	D	MA	2010-06-22	1
111-hr-5569,K000008	National Flood Insurance Program Extension Act of 2010 111-hr-5569	K000008	Rep. Kanjorski, Paul E. [D-PA-11]	D	PA	2010-06-22	1
111-hr-5569,J000255	National Flood Insurance Program Extension Act of 2010 111-hr-5569	J000255	Rep. Jones, Walter B., Jr. [R-NC-3]	R	NC	2010-06-22	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);