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-12754" 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-12754,L000561 Small Business Regulatory Relief Act 95-hr-12754 L000561 Rep. LeFante, Joseph A. [D-NJ-14] D     0
95-hr-12754,L000187 Small Business Regulatory Relief Act 95-hr-12754 L000187 Rep. Lederer, Raymond F. [D-PA-3] D     0
95-hr-12754,L000226 Small Business Regulatory Relief Act 95-hr-12754 L000226 Rep. Lehman, William [D-FL-13] D     0
95-hr-12754,L000381 Small Business Regulatory Relief Act 95-hr-12754 L000381 Rep. Lloyd, Marilyn [D-TN-3] D     0
95-hr-12754,L000447 Small Business Regulatory Relief Act 95-hr-12754 L000447 Rep. Lott, Trent [R-MS-5] R     0
95-hr-12754,L000508 Small Business Regulatory Relief Act 95-hr-12754 L000508 Rep. Luken, Thomas A. [D-OH-2] D     0
95-hr-12754,M000143 Small Business Regulatory Relief Act 95-hr-12754 M000143 Rep. Marriott, David Daniel [R-UT-2] R     0
95-hr-12754,M000702 Small Business Regulatory Relief Act 95-hr-12754 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD   0
95-hr-12754,M000718 Small Business Regulatory Relief Act 95-hr-12754 M000718 Rep. Miller, Clarence E. [R-OH-10] R     0
95-hr-12754,M001044 Small Business Regulatory Relief Act 95-hr-12754 M001044 Rep. Mottl, Ronald M. [D-OH-23] D     0
95-hr-12754,N000016 Small Business Regulatory Relief Act 95-hr-12754 N000016 Rep. Neal, Stephen L. [D-NC-5] D     0
95-hr-12754,N000127 Small Business Regulatory Relief Act 95-hr-12754 N000127 Rep. Nolan, Richard M. [D-MN-6] D MN   0
95-hr-12754,O000134 Small Business Regulatory Relief Act 95-hr-12754 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY   0
95-hr-12754,P000170 Small Business Regulatory Relief Act 95-hr-12754 P000170 Rep. Pease, Donald J. [D-OH-13] D     0
95-hr-12754,P000218 Small Business Regulatory Relief Act 95-hr-12754 P000218 Rep. Pepper, Claude [D-FL-14] D FL   0
95-hr-12754,Q000010 Small Business Regulatory Relief Act 95-hr-12754 Q000010 Rep. Quie, Albert H. [R-MN-1] R     0
95-hr-12754,S000217 Small Business Regulatory Relief Act 95-hr-12754 S000217 Rep. Sebelius, Keith G. [R-KS-1] R     0
95-hr-12754,S000406 Small Business Regulatory Relief Act 95-hr-12754 S000406 Rep. Sikes, Robert L. F. [D-FL-1] D FL   0
95-hr-12754,S000465 Small Business Regulatory Relief Act 95-hr-12754 S000465 Rep. Skelton, Ike [D-MO-4] D     0
95-hr-12754,S000829 Small Business Regulatory Relief Act 95-hr-12754 S000829 Rep. Steed, Tom [D-OK-4] D     0
95-hr-12754,S001044 Small Business Regulatory Relief Act 95-hr-12754 S001044 Rep. Stump, Bob [D-AZ-3] R     0
95-hr-12754,T000234 Small Business Regulatory Relief Act 95-hr-12754 T000234 Rep. Thone, Charles [R-NE-1] R     0
95-hr-12754,V000112 Small Business Regulatory Relief Act 95-hr-12754 V000112 Rep. Volkmer, Harold L. [D-MO-9] D     0
95-hr-12754,W000121 Small Business Regulatory Relief Act 95-hr-12754 W000121 Rep. Wampler, William C. [R-VA-9] R VA   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);