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

14 rows where bill_id = "93-hr-8449" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 14
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
93-hr-8449,W000445 Flood Disaster Protection Act of 1973 93-hr-8449 W000445 Rep. Widnall, William B. [R-NJ-7] R     0
93-hr-8449,S001057 Flood Disaster Protection Act of 1973 93-hr-8449 S001057 Rep. Sullivan, Leonor K. (Mrs. John B.) [D-MO-3] D     0
93-hr-8449,A000222 Flood Disaster Protection Act of 1973 93-hr-8449 A000222 Rep. Ashley, Thomas L. [D-OH-9] D     0
93-hr-8449,M000930 Flood Disaster Protection Act of 1973 93-hr-8449 M000930 Rep. Moorhead, William S. [D-PA-14] D PA   0
93-hr-8449,S000860 Flood Disaster Protection Act of 1973 93-hr-8449 S000860 Rep. Stephens, Robert G., Jr. [D-GA-10] D     0
93-hr-8449,S000762 Flood Disaster Protection Act of 1973 93-hr-8449 S000762 Rep. St Germain, Fernand J. [D-RI-1] D     0
93-hr-8449,G000272 Flood Disaster Protection Act of 1973 93-hr-8449 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D     0
93-hr-8449,R000165 Flood Disaster Protection Act of 1973 93-hr-8449 R000165 Rep. Reuss, Henry S. [D-WI-5] D     0
93-hr-8449,H000164 Flood Disaster Protection Act of 1973 93-hr-8449 H000164 Rep. Hanna, Richard T. [D-CA-34] D     0
93-hr-8449,B000917 Flood Disaster Protection Act of 1973 93-hr-8449 B000917 Rep. Brown, Garry E. [R-MI-3] R     0
93-hr-8449,S000804 Flood Disaster Protection Act of 1973 93-hr-8449 S000804 Rep. Stanton, J. William [R-OH-11] R     0
93-hr-8449,B000506 Flood Disaster Protection Act of 1973 93-hr-8449 B000506 Rep. Blackburn, Ben [R-GA-4] R     0
93-hr-8449,H000440 Flood Disaster Protection Act of 1973 93-hr-8449 H000440 Rep. Heckler, Margaret M. [R-MA-10] R     0
93-hr-8449,R000469 Flood Disaster Protection Act of 1973 93-hr-8449 R000469 Rep. Rousselot, John H. [R-CA-24] R CA   0

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