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

20 rows where bill_id = "103-hconres-29" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 1

  • 0 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hconres-29,R000486 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1993-05-12 0
103-hconres-29,W000784 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 1993-04-28 0
103-hconres-29,P000066 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 P000066 Rep. Parker, Mike [D-MS-4] D MS 1993-04-22 0
103-hconres-29,T000326 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 1993-04-22 0
103-hconres-29,M000117 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 M000117 Rep. Manton, Thomas J. [D-NY-7] D NY 1993-04-20 0
103-hconres-29,B000392 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1993-04-01 0
103-hconres-29,R000435 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-18] R FL 1993-04-01 0
103-hconres-29,S000522 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1993-03-31 0
103-hconres-29,U000031 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 U000031 Rep. Upton, Fred [R-MI-6] R MI 1993-03-24 0
103-hconres-29,M000477 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 M000477 Rep. McInnis, Scott [R-CO-3] R CO 1993-03-11 0
103-hconres-29,A000217 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 A000217 Rep. Armey, Richard K. [R-TX-26] R TX 1993-03-10 0
103-hconres-29,Y000031 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 Y000031 Rep. Young, C. W. Bill [R-FL-10] R FL 1993-02-24 0
103-hconres-29,H001022 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1993-02-24 0
103-hconres-29,S000675 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 S000675 Rep. Solomon, Gerald B. H. [R-NY-22] R NY 1993-02-16 0
103-hconres-29,B000078 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 B000078 Rep. Baker, Bill [R-CA-10] R CA 1993-02-16 0
103-hconres-29,N000147 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 1993-02-16 0
103-hconres-29,C000107 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1993-02-16 0
103-hconres-29,H000621 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 H000621 Rep. Hilliard, Earl F. [D-AL-7] D AL 1993-02-16 0
103-hconres-29,K000172 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 K000172 Rep. Kildee, Dale E. [D-MI-9] D MI 1993-02-16 0
103-hconres-29,M001138 Expressing the sense of Congress with respect to the United States Customs Child Pornography and Protection Unit. 103-hconres-29 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 1993-02-16 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);