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

24 rows where bill_id = "95-hr-12486" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 24
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
95-hr-12486,T000356 Sugar Stabilization Act 95-hr-12486 T000356 Rep. Traxler, Bob [D-MI-8] D     0
95-hr-12486,A000208 Sugar Stabilization Act 95-hr-12486 A000208 Rep. Andrews, Mark [R-ND-At Large] R     0
95-hr-12486,A000069 Sugar Stabilization Act 95-hr-12486 A000069 Rep. Akaka, Daniel K. [D-HI-2] D     0
95-hr-12486,B000243 Sugar Stabilization Act 95-hr-12486 B000243 Rep. Baucus, Max [D-MT-1] D MT   0
95-hr-12486,B000780 Sugar Stabilization Act 95-hr-12486 B000780 Rep. Breaux, John B. [D-LA-7] D     0
95-hr-12486,H000171 Sugar Stabilization Act 95-hr-12486 H000171 Rep. Hansen, George V. [R-ID-2] R ID   0
95-hr-12486,H000449 Sugar Stabilization Act 95-hr-12486 H000449 Rep. Heftel, Cecil [D-HI-1] D     0
95-hr-12486,H000901 Sugar Stabilization Act 95-hr-12486 H000901 Rep. Huckaby, Thomas J. (Jerry) [D-LA-5] D     0
95-hr-12486,J000099 Sugar Stabilization Act 95-hr-12486 J000099 Rep. Jenrette, John W., Jr. [D-SC-6] D     0
95-hr-12486,J000148 Sugar Stabilization Act 95-hr-12486 J000148 Rep. Johnson, James P. (Jim) [R-CO-4] R     0
95-hr-12486,L000221 Sugar Stabilization Act 95-hr-12486 L000221 Rep. Leggett, Robert L. [D-CA-4] D     0
95-hr-12486,L000417 Sugar Stabilization Act 95-hr-12486 L000417 Rep. Long, Gillis W. [D-LA-8] D LA   0
95-hr-12486,M000365 Sugar Stabilization Act 95-hr-12486 M000365 Rep. McCormack, Mike [D-WA-4] D     0
95-hr-12486,M000436 Sugar Stabilization Act 95-hr-12486 M000436 Rep. McFall, John J. [D-CA-14] D CA   0
95-hr-12486,M000923 Sugar Stabilization Act 95-hr-12486 M000923 Rep. Moore, W. Henson [R-LA-6] R     0
95-hr-12486,N000127 Sugar Stabilization Act 95-hr-12486 N000127 Rep. Nolan, Richard M. [D-MN-6] D MN   0
95-hr-12486,R000421 Sugar Stabilization Act 95-hr-12486 R000421 Rep. Roncalio, Teno [D-WY-At Large] D WY   0
95-hr-12486,S000406 Sugar Stabilization Act 95-hr-12486 S000406 Rep. Sikes, Robert L. F. [D-FL-1] D FL   0
95-hr-12486,S000454 Sugar Stabilization Act 95-hr-12486 S000454 Rep. Sisk, B. F. [D-CA-15] D CA   0
95-hr-12486,S000596 Sugar Stabilization Act 95-hr-12486 S000596 Rep. Smith, Neal Edward [D-IA-4] D IA   0
95-hr-12486,S000622 Sugar Stabilization Act 95-hr-12486 S000622 Rep. Smith, Virginia [R-NE-3] R     0
95-hr-12486,S000795 Sugar Stabilization Act 95-hr-12486 S000795 Rep. Stangeland, Arlan [R-MN-7] R     0
95-hr-12486,W000018 Sugar Stabilization Act 95-hr-12486 W000018 Rep. Waggonner, Joe D., Jr. [D-LA-4] D     0
95-hr-12486,C000788 Sugar Stabilization Act 95-hr-12486 C000788 Resident Commissioner Corrada, Baltasar [I-PR-At Large] I     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);