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

20 rows where bill_id = "115-hr-660" 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

  • 1 17
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hr-660,V000129 Bureau of Reclamation Transparency Act 115-hr-660 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2017-03-01 0
115-hr-660,H001071 Bureau of Reclamation Transparency Act 115-hr-660 H001071 Rep. Hice, Jody B. [R-GA-10] R GA 2017-03-01 0
115-hr-660,M001177 Bureau of Reclamation Transparency Act 115-hr-660 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2017-02-01 0
115-hr-660,A000369 Bureau of Reclamation Transparency Act 115-hr-660 A000369 Rep. Amodei, Mark E. [R-NV-2] R NV 2017-01-24 1
115-hr-660,B001302 Bureau of Reclamation Transparency Act 115-hr-660 B001302 Rep. Biggs, Andy [R-AZ-5] R AZ 2017-01-24 1
115-hr-660,C001090 Bureau of Reclamation Transparency Act 115-hr-660 C001090 Rep. Cartwright, Matt [D-PA-17] D PA 2017-01-24 1
115-hr-660,C001059 Bureau of Reclamation Transparency Act 115-hr-660 C001059 Rep. Costa, Jim [D-CA-16] D CA 2017-01-24 1
115-hr-660,D000612 Bureau of Reclamation Transparency Act 115-hr-660 D000612 Rep. Denham, Jeff [R-CA-10] R CA 2017-01-24 1
115-hr-660,F000460 Bureau of Reclamation Transparency Act 115-hr-660 F000460 Rep. Farenthold, Blake [R-TX-27] R TX 2017-01-24 1
115-hr-660,F000448 Bureau of Reclamation Transparency Act 115-hr-660 F000448 Rep. Franks, Trent [R-AZ-8] R AZ 2017-01-24 1
115-hr-660,G000559 Bureau of Reclamation Transparency Act 115-hr-660 G000559 Rep. Garamendi, John [D-CA-3] D CA 2017-01-24 1
115-hr-660,G000552 Bureau of Reclamation Transparency Act 115-hr-660 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2017-01-24 1
115-hr-660,H001068 Bureau of Reclamation Transparency Act 115-hr-660 H001068 Rep. Huffman, Jared [D-CA-2] D CA 2017-01-24 1
115-hr-660,M001197 Bureau of Reclamation Transparency Act 115-hr-660 M001197 Rep. McSally, Martha [R-AZ-2] R AZ 2017-01-24 1
115-hr-660,N000189 Bureau of Reclamation Transparency Act 115-hr-660 N000189 Rep. Newhouse, Dan [R-WA-4] R WA 2017-01-24 1
115-hr-660,P000588 Bureau of Reclamation Transparency Act 115-hr-660 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2017-01-24 1
115-hr-660,S001191 Bureau of Reclamation Transparency Act 115-hr-660 S001191 Rep. Sinema, Kyrsten [D-AZ-9] D AZ 2017-01-24 1
115-hr-660,T000470 Bureau of Reclamation Transparency Act 115-hr-660 T000470 Rep. Tipton, Scott R. [R-CO-3] R CO 2017-01-24 1
115-hr-660,L000578 Bureau of Reclamation Transparency Act 115-hr-660 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2017-01-24 1
115-hr-660,B001273 Bureau of Reclamation Transparency Act 115-hr-660 B001273 Rep. Black, Diane [R-TN-6] R TN 2017-01-24 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);