legislation_cosponsors

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

8 rows where bill_id = "112-hres-775" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hres-775,B001230 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2012-09-10 1
112-hres-775,K000188 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 K000188 Rep. Kind, Ron [D-WI-3] D WI 2012-09-10 1
112-hres-775,M001160 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2012-09-10 1
112-hres-775,S000244 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2012-09-10 1
112-hres-775,R000587 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 R000587 Rep. Ribble, Reid J. [R-WI-8] R WI 2012-09-10 1
112-hres-775,D000614 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 D000614 Rep. Duffy, Sean P. [R-WI-7] R WI 2012-09-10 1
112-hres-775,P000265 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2012-09-10 1
112-hres-775,R000487 Condemning the shooting that killed six innocent people at the Sikh Temple of Wisconsin in Oak Creek, Wisconsin, on August 5, 2012. 112-hres-775 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2012-09-10 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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