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

13 rows where bill_id = "115-hr-6992" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 11
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hr-6992,B001284 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 B001284 Rep. Brooks, Susan W. [R-IN-5] R IN 2018-12-03 0
115-hr-6992,B001289 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 B001289 Rep. Byrne, Bradley [R-AL-1] R AL 2018-11-28 0
115-hr-6992,D000619 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 D000619 Rep. Davis, Rodney [R-IL-13] R IL 2018-11-20 0
115-hr-6992,C001106 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 C001106 Rep. Costello, Ryan A. [R-PA-6] R PA 2018-10-23 0
115-hr-6992,B000490 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2018-10-16 0
115-hr-6992,B001298 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 B001298 Rep. Bacon, Don [R-NE-2] R NE 2018-10-12 0
115-hr-6992,G000576 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 G000576 Rep. Grothman, Glenn [R-WI-6] R WI 2018-10-12 0
115-hr-6992,F000466 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 F000466 Rep. Fitzpatrick, Brian K. [R-PA-8] R PA 2018-10-05 0
115-hr-6992,S001189 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 S001189 Rep. Scott, Austin [R-GA-8] R GA 2018-10-05 0
115-hr-6992,K000188 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 K000188 Rep. Kind, Ron [D-WI-3] D WI 2018-10-02 0
115-hr-6992,C001072 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 C001072 Rep. Carson, Andre [D-IN-7] D IN 2018-10-02 0
115-hr-6992,M001194 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 M001194 Rep. Moolenaar, John R. [R-MI-4] R MI 2018-09-28 1
115-hr-6992,C001063 Protecting and Securing Chemical Facilities from Terrorist Attacks Act of 2018 115-hr-6992 C001063 Rep. Cuellar, Henry [D-TX-28] D TX 2018-09-28 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);