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

18 rows where bill_id = "95-hr-12938" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
95-hr-12938,A000219 Uranium Mill Site Restoration Act 95-hr-12938 A000219 Rep. Armstrong, William L. [R-CO-5] R     0
95-hr-12938,B000244 Uranium Mill Site Restoration Act 95-hr-12938 B000244 Rep. Bauman, Robert E. [R-MD-1] R     0
95-hr-12938,E000077 Uranium Mill Site Restoration Act 95-hr-12938 E000077 Rep. Edwards, Mickey [R-OK-5] R     0
95-hr-12938,H000171 Uranium Mill Site Restoration Act 95-hr-12938 H000171 Rep. Hansen, George V. [R-ID-2] R ID   0
95-hr-12938,J000148 Uranium Mill Site Restoration Act 95-hr-12938 J000148 Rep. Johnson, James P. (Jim) [R-CO-4] R     0
95-hr-12938,K000025 Uranium Mill Site Restoration Act 95-hr-12938 K000025 Rep. Kazen, Abraham, Jr. [D-TX-23] D     0
95-hr-12938,L000506 Uranium Mill Site Restoration Act 95-hr-12938 L000506 Rep. Lujan, Manuel, Jr. [R-NM-1] R     0
95-hr-12938,M000399 Uranium Mill Site Restoration Act 95-hr-12938 M000399 Rep. McDade, Joseph M. [R-PA-10] R     0
95-hr-12938,M001088 Uranium Mill Site Restoration Act 95-hr-12938 M001088 Rep. Murphy, Austin J. [D-PA-22] D     0
95-hr-12938,R000188 Uranium Mill Site Restoration Act 95-hr-12938 R000188 Rep. Rhodes, John J. [R-AZ-1] R     0
95-hr-12938,R000421 Uranium Mill Site Restoration Act 95-hr-12938 R000421 Rep. Roncalio, Teno [D-WY-At Large] D WY   0
95-hr-12938,R000495 Uranium Mill Site Restoration Act 95-hr-12938 R000495 Rep. Rudd, Eldon D. [R-AZ-4] R     0
95-hr-12938,R000510 Uranium Mill Site Restoration Act 95-hr-12938 R000510 Rep. Runnels, Harold L. [D-NM-2] D     0
95-hr-12938,R000512 Uranium Mill Site Restoration Act 95-hr-12938 R000512 Rep. Ruppe, Philip E. [R-MI-11] R     0
95-hr-12938,S000472 Uranium Mill Site Restoration Act 95-hr-12938 S000472 Rep. Skubitz, Joe [R-KS-5] R     0
95-hr-12938,S001044 Uranium Mill Site Restoration Act 95-hr-12938 S001044 Rep. Stump, Bob [D-AZ-3] R     0
95-hr-12938,S001138 Uranium Mill Site Restoration Act 95-hr-12938 S001138 Rep. Symms, Steven D. [R-ID-1] R     0
95-hr-12938,W000227 Uranium Mill Site Restoration Act 95-hr-12938 W000227 Rep. Weaver, James H. [D-OR-4] D     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);