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 = "96-hr-6944" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 24
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-6944,P000230 National Usury Act 96-hr-6944 P000230 Rep. Perkins, Carl Dewey [D-KY-7] D     0
96-hr-6944,T000075 National Usury Act 96-hr-6944 T000075 Rep. Taylor, G. [R-MO-7] R     0
96-hr-6944,S000795 National Usury Act 96-hr-6944 S000795 Rep. Stangeland, Arlan [R-MN-7] R     0
96-hr-6944,S000675 National Usury Act 96-hr-6944 S000675 Rep. Solomon, Gerald B. H. [R-NY-22] R     0
96-hr-6944,C000201 National Usury Act 96-hr-6944 C000201 Rep. Carter, Tim Lee [R-KY-5] R     0
96-hr-6944,S000948 National Usury Act 96-hr-6944 S000948 Rep. Stokes, Louis [D-OH-21] D OH   0
96-hr-6944,H000171 National Usury Act 96-hr-6944 H000171 Rep. Hansen, George V. [R-ID-2] R ID   0
96-hr-6944,H000719 National Usury Act 96-hr-6944 H000719 Rep. Holland, Kenneth L. [D-SC-5] D     0
96-hr-6944,E000233 National Usury Act 96-hr-6944 E000233 Rep. Evans, Billy Lee [D-GA-8] D     0
96-hr-6944,M001044 National Usury Act 96-hr-6944 M001044 Rep. Mottl, Ronald M. [D-OH-23] D     0
96-hr-6944,D000125 National Usury Act 96-hr-6944 D000125 Rep. Davis, Mendel J. [D-SC-1] D     0
96-hr-6944,W000528 National Usury Act 96-hr-6944 W000528 Rep. Williams, Lyle [R-OH-17] R     0
96-hr-6944,H000878 National Usury Act 96-hr-6944 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D     0
96-hr-6944,H000124 National Usury Act 96-hr-6944 H000124 Rep. Hammerschmidt, John P. [R-AR-3] R AR   0
96-hr-6944,S000217 National Usury Act 96-hr-6944 S000217 Rep. Sebelius, Keith G. [R-KS-1] R     0
96-hr-6944,W000194 National Usury Act 96-hr-6944 W000194 Rep. Watkins, Wes [D-OK-3] R     0
96-hr-6944,G000272 National Usury Act 96-hr-6944 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D     0
96-hr-6944,H000448 National Usury Act 96-hr-6944 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D     0
96-hr-6944,Y000051 National Usury Act 96-hr-6944 Y000051 Rep. Young, Robert A. [D-MO-2] D     0
96-hr-6944,C000165 National Usury Act 96-hr-6944 C000165 Rep. Carney, William [R-NY-1] R     0
96-hr-6944,S000716 National Usury Act 96-hr-6944 S000716 Rep. Spellman, Gladys Noon [D-MD-5] D     0
96-hr-6944,R000383 National Usury Act 96-hr-6944 R000383 Rep. Roe, Robert A. [D-NJ-8] D     0
96-hr-6944,B000431 National Usury Act 96-hr-6944 B000431 Rep. Bevill, Tom [D-AL-4] D     0
96-hr-6944,D000279 National Usury Act 96-hr-6944 D000279 Rep. Devine, Samuel L. [R-OH-12] 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);