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

13 rows where bill_id = "103-hr-4737" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 11
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4737,M000466 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 M000466 Rep. McHale, Paul [D-PA-15] D PA 1994-10-07 0
103-hr-4737,S000332 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 S000332 Rep. Shepherd, Karen [D-UT-2] D UT 1994-08-10 0
103-hr-4737,F000434 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1994-08-08 0
103-hr-4737,R000486 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1994-08-01 0
103-hr-4737,M000794 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 M000794 Rep. Mineta, Norman Y. [D-CA-15] D CA 1994-08-01 0
103-hr-4737,B000918 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 B000918 Rep. Brown, George E., Jr. [D-CA-42] D CA 1994-07-26 0
103-hr-4737,V000087 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1994-07-25 0
103-hr-4737,J000070 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1994-07-22 0
103-hr-4737,W000738 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1994-07-19 0
103-hr-4737,Y000013 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1994-07-19 0
103-hr-4737,M000725 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 M000725 Rep. Miller, George [D-CA-7] D CA 1994-07-19 0
103-hr-4737,S001040 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1994-07-13 1
103-hr-4737,U000017 To modify the negotiating objectives of the United States for future trade agreements, and for other purposes. 103-hr-4737 U000017 Rep. Unsoeld, Jolene [D-WA-3] D WA 1994-07-13 1

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);