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-6841" 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
96-hr-6841,G000291 Commodity Letter of Credit Act 96-hr-6841 G000291 Rep. Goodling, William F. [R-PA-19] R     0
96-hr-6841,A000221 Commodity Letter of Credit Act 96-hr-6841 A000221 Rep. Ashbrook, John M. [R-OH-17] R     0
96-hr-6841,G000132 Commodity Letter of Credit Act 96-hr-6841 G000132 Rep. Gephardt, Richard A. [D-MO-3] D     0
96-hr-6841,C000488 Commodity Letter of Credit Act 96-hr-6841 C000488 Rep. Clay, William (Bill) [D-MO-1] D     0
96-hr-6841,G000268 Commodity Letter of Credit Act 96-hr-6841 G000268 Rep. Goldwater, Barry, Jr. [R-CA-20] R     0
96-hr-6841,H000878 Commodity Letter of Credit Act 96-hr-6841 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D     0
96-hr-6841,D000355 Commodity Letter of Credit Act 96-hr-6841 D000355 Rep. Dingell, John D. [D-MI-16] D MI   0
96-hr-6841,S001138 Commodity Letter of Credit Act 96-hr-6841 S001138 Rep. Symms, Steven D. [R-ID-1] R     0
96-hr-6841,C000714 Commodity Letter of Credit Act 96-hr-6841 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI   0
96-hr-6841,S000948 Commodity Letter of Credit Act 96-hr-6841 S000948 Rep. Stokes, Louis [D-OH-21] D OH   0
96-hr-6841,W000406 Commodity Letter of Credit Act 96-hr-6841 W000406 Rep. Whitehurst, G. William [R-VA-2] R     0
96-hr-6841,D000222 Commodity Letter of Credit Act 96-hr-6841 D000222 Rep. Dellums, Ronald V. [D-CA-8] D     0
96-hr-6841,I000029 Commodity Letter of Credit Act 96-hr-6841 I000029 Rep. Ireland, Andrew P. [D-FL-8] R     0
96-hr-6841,H000641 Commodity Letter of Credit Act 96-hr-6841 H000641 Rep. Hinson, Jon C. [R-MS-4] R     0
96-hr-6841,W000419 Commodity Letter of Credit Act 96-hr-6841 W000419 Rep. Whitley, Charles O., Sr. [D-NC-3] D     0
96-hr-6841,F000078 Commodity Letter of Credit Act 96-hr-6841 F000078 Rep. Fenwick, Millicent H. [R-NJ-5] R     0
96-hr-6841,V000087 Commodity Letter of Credit Act 96-hr-6841 V000087 Rep. Vento, Bruce F. [D-MN-4] D     0
96-hr-6841,G000225 Commodity Letter of Credit Act 96-hr-6841 G000225 Rep. Gingrich, Newt [R-GA-6] R     0
96-hr-6841,M000702 Commodity Letter of Credit Act 96-hr-6841 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD   0
96-hr-6841,T000053 Commodity Letter of Credit Act 96-hr-6841 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R     0
96-hr-6841,H001018 Commodity Letter of Credit Act 96-hr-6841 H001018 Rep. Hutto, Earl [D-FL-1] D     0
96-hr-6841,H000930 Commodity Letter of Credit Act 96-hr-6841 H000930 Rep. Hughes, William J. [D-NJ-2] D     0
96-hr-6841,B000619 Commodity Letter of Credit Act 96-hr-6841 B000619 Rep. Bonior, David E. [D-MI-12] D     0
96-hr-6841,S000465 Commodity Letter of Credit Act 96-hr-6841 S000465 Rep. Skelton, Ike [D-MO-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);