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-13751" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
95-hr-13751,C000263 Sugar Stabilization Act 95-hr-13751 C000263 Rep. Cederberg, Elford A. [R-MI-10] R     0
95-hr-13751,F000350 Sugar Stabilization Act 95-hr-13751 F000350 Rep. Fraser, Donald M. [D-MN-5] D     0
95-hr-13751,G000537 Sugar Stabilization Act 95-hr-13751 G000537 Rep. Guyer, Tennyson [R-OH-4] R     0
95-hr-13751,H000171 Sugar Stabilization Act 95-hr-13751 H000171 Rep. Hansen, George V. [R-ID-2] R ID   0
95-hr-13751,H000449 Sugar Stabilization Act 95-hr-13751 H000449 Rep. Heftel, Cecil [D-HI-1] D     0
95-hr-13751,I000029 Sugar Stabilization Act 95-hr-13751 I000029 Rep. Ireland, Andrew P. [D-FL-8] R     0
95-hr-13751,L000221 Sugar Stabilization Act 95-hr-13751 L000221 Rep. Leggett, Robert L. [D-CA-4] D     0
95-hr-13751,L000371 Sugar Stabilization Act 95-hr-13751 L000371 Rep. Livingston, Bob [R-LA-1] R     0
95-hr-13751,L000417 Sugar Stabilization Act 95-hr-13751 L000417 Rep. Long, Gillis W. [D-LA-8] D LA   0
95-hr-13751,M000436 Sugar Stabilization Act 95-hr-13751 M000436 Rep. McFall, John J. [D-CA-14] D CA   0
95-hr-13751,Q000010 Sugar Stabilization Act 95-hr-13751 Q000010 Rep. Quie, Albert H. [R-MN-1] R     0
95-hr-13751,R000421 Sugar Stabilization Act 95-hr-13751 R000421 Rep. Roncalio, Teno [D-WY-At Large] D WY   0
95-hr-13751,S000406 Sugar Stabilization Act 95-hr-13751 S000406 Rep. Sikes, Robert L. F. [D-FL-1] D FL   0
95-hr-13751,S000454 Sugar Stabilization Act 95-hr-13751 S000454 Rep. Sisk, B. F. [D-CA-15] D CA   0
95-hr-13751,S000596 Sugar Stabilization Act 95-hr-13751 S000596 Rep. Smith, Neal Edward [D-IA-4] D IA   0
95-hr-13751,S000795 Sugar Stabilization Act 95-hr-13751 S000795 Rep. Stangeland, Arlan [R-MN-7] R     0
95-hr-13751,T000362 Sugar Stabilization Act 95-hr-13751 T000362 Rep. Treen, David C. [R-LA-3] R     0
95-hr-13751,W000018 Sugar Stabilization Act 95-hr-13751 W000018 Rep. Waggonner, Joe D., Jr. [D-LA-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);