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

25 rows where bill_id = "96-hr-7259" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 25
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-7259,S000829 Small Business Employee Ownership Act of 1980 96-hr-7259 S000829 Rep. Steed, Tom [D-OK-4] D     0
96-hr-7259,C000780 Small Business Employee Ownership Act of 1980 96-hr-7259 C000780 Rep. Corman, James C. [D-CA-21] D     0
96-hr-7259,A000052 Small Business Employee Ownership Act of 1980 96-hr-7259 A000052 Rep. Addabbo, Joseph P. [D-NY-7] D NY   0
96-hr-7259,S000762 Small Business Employee Ownership Act of 1980 96-hr-7259 S000762 Rep. St Germain, Fernand J. [D-RI-1] D     0
96-hr-7259,M000826 Small Business Employee Ownership Act of 1980 96-hr-7259 M000826 Rep. Mitchell, Parren J. [D-MD-7] D     0
96-hr-7259,H000158 Small Business Employee Ownership Act of 1980 96-hr-7259 H000158 Rep. Hanley, James M. [D-NY-32] D NY   0
96-hr-7259,L000556 Small Business Employee Ownership Act of 1980 96-hr-7259 L000556 Rep. LaFalce, John J. [D-NY-36] D     0
96-hr-7259,B000298 Small Business Employee Ownership Act of 1980 96-hr-7259 B000298 Rep. Bedell, Berkley W. [D-IA-6] D     0
96-hr-7259,R000232 Small Business Employee Ownership Act of 1980 96-hr-7259 R000232 Rep. Richmond, Frederick W. [D-NY-14] D     0
96-hr-7259,B000083 Small Business Employee Ownership Act of 1980 96-hr-7259 B000083 Rep. Baldus, Alvin J. [D-WI-3] D     0
96-hr-7259,N000127 Small Business Employee Ownership Act of 1980 96-hr-7259 N000127 Rep. Nolan, Richard M. [D-MN-6] D MN   0
96-hr-7259,N000163 Small Business Employee Ownership Act of 1980 96-hr-7259 N000163 Rep. Nowak, Henry [D-NY-37] D     0
96-hr-7259,L000508 Small Business Employee Ownership Act of 1980 96-hr-7259 L000508 Rep. Luken, Thomas A. [D-OH-2] D     0
96-hr-7259,K000172 Small Business Employee Ownership Act of 1980 96-hr-7259 K000172 Rep. Kildee, Dale E. [D-MI-7] D     0
96-hr-7259,E000233 Small Business Employee Ownership Act of 1980 96-hr-7259 E000233 Rep. Evans, Billy Lee [D-GA-8] D     0
96-hr-7259,B000153 Small Business Employee Ownership Act of 1980 96-hr-7259 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D     0
96-hr-7259,L000167 Small Business Employee Ownership Act of 1980 96-hr-7259 L000167 Rep. Leach, Claude (Buddy), Jr. [D-LA-4] D     0
96-hr-7259,H000074 Small Business Employee Ownership Act of 1980 96-hr-7259 H000074 Rep. Hall, Tony P. [D-OH-3] D     0
96-hr-7259,B000403 Small Business Employee Ownership Act of 1980 96-hr-7259 B000403 Rep. Bereuter, Doug [R-NE-1] R     0
96-hr-7259,S000716 Small Business Employee Ownership Act of 1980 96-hr-7259 S000716 Rep. Spellman, Gladys Noon [D-MD-5] D     0
96-hr-7259,C000709 Small Business Employee Ownership Act of 1980 96-hr-7259 C000709 Rep. Conte, Silvio O. [R-MA-1] R     0
96-hr-7259,S000804 Small Business Employee Ownership Act of 1980 96-hr-7259 S000804 Rep. Stanton, J. William [R-OH-11] R     0
96-hr-7259,S000663 Small Business Employee Ownership Act of 1980 96-hr-7259 S000663 Rep. Snowe, Olympia J. [R-ME-2] R     0
96-hr-7259,Q000007 Small Business Employee Ownership Act of 1980 96-hr-7259 Q000007 Rep. Quayle, Dan [R-IN-4] R     0
96-hr-7259,T000053 Small Business Employee Ownership Act of 1980 96-hr-7259 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R     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);