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

30 rows where bill_id = "103-hr-4148" 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 30
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4148,Y000013 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1994-06-22 0
103-hr-4148,T000314 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 T000314 Rep. Torkildsen, Peter G. [R-MA-6] R MA 1994-06-17 0
103-hr-4148,S000119 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 S000119 Rep. Schenk, Lynn [D-CA-49] D CA 1994-06-17 0
103-hr-4148,G000535 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1994-06-17 0
103-hr-4148,S000248 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 1994-05-26 0
103-hr-4148,H000621 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 H000621 Rep. Hilliard, Earl F. [D-AL-7] D AL 1994-05-25 0
103-hr-4148,M000941 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1994-05-25 0
103-hr-4148,D000222 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1994-05-12 0
103-hr-4148,N000147 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 1994-05-05 0
103-hr-4148,N000015 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 1994-05-05 0
103-hr-4148,M000133 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 1994-05-05 0
103-hr-4148,O000085 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 O000085 Rep. Olver, John W. [D-MA-1] D MA 1994-05-03 0
103-hr-4148,A000014 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 A000014 Rep. Abercrombie, Neil [D-HI-1] D HI 1994-05-03 0
103-hr-4148,M000087 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 1994-04-28 0
103-hr-4148,S000142 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 S000142 Rep. Schroeder, Patricia [D-CO-1] D CO 1994-04-28 0
103-hr-4148,U000017 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 U000017 Rep. Unsoeld, Jolene [D-WA-3] D WA 1994-04-28 0
103-hr-4148,O000159 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 O000159 Rep. Owens, Major R. [D-NY-11] D NY 1994-04-28 0
103-hr-4148,W000738 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1994-04-28 0
103-hr-4148,W000177 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 W000177 Rep. Washington, Craig A. [D-TX-18] D TX 1994-04-21 0
103-hr-4148,K000110 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 K000110 Rep. Kennedy, Joseph P., II [D-MA-8] D MA 1994-04-21 0
103-hr-4148,N000002 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 1994-04-19 0
103-hr-4148,K000328 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 K000328 Rep. Kreidler, Mike [D-WA-9] D WA 1994-04-19 0
103-hr-4148,F000235 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1994-04-12 0
103-hr-4148,S001040 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1994-04-12 0
103-hr-4148,A000022 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 1994-04-12 0
103-hr-4148,M000725 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 M000725 Rep. Miller, George [D-CA-7] D CA 1994-04-12 0
103-hr-4148,V000081 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 V000081 Rep. Velazquez, Nydia M. [D-NY-12] D NY 1994-04-12 0
103-hr-4148,P000197 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 1994-04-12 0
103-hr-4148,L000090 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 L000090 Rep. Lantos, Tom [D-CA-12] D CA 1994-04-12 0
103-hr-4148,F000339 Gay and Lesbian Youth Suicide Prevention Act 103-hr-4148 F000339 Rep. Frank, Barney [D-MA-4] D MA 1994-04-12 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);