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

27 rows where bill_id = "111-hconres-333" 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

  • 1 25
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-333,W000187 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2010-12-02 0
111-hconres-333,E000179 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2010-12-02 0
111-hconres-333,E000290 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 E000290 Rep. Edwards, Donna F. [D-MD-4] D MD 2010-12-01 1
111-hconres-333,R000515 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2010-12-01 1
111-hconres-333,G000551 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2010-12-01 1
111-hconres-333,B001245 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2010-12-01 1
111-hconres-333,F000339 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 F000339 Rep. Frank, Barney [D-MA-4] D MA 2010-12-01 1
111-hconres-333,H000627 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2010-12-01 1
111-hconres-333,N000147 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2010-12-01 1
111-hconres-333,S001175 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 S001175 Rep. Speier, Jackie [D-CA-12] D CA 2010-12-01 1
111-hconres-333,D000610 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 D000610 Rep. Deutch, Theodore E. [D-FL-19] D FL 2010-12-01 1
111-hconres-333,S000810 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2010-12-01 1
111-hconres-333,W000738 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2010-12-01 1
111-hconres-333,R000053 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2010-12-01 1
111-hconres-333,J000288 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2010-12-01 1
111-hconres-333,B001230 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2010-12-01 1
111-hconres-333,P000598 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 P000598 Rep. Polis, Jared [D-CO-2] D CO 2010-12-01 1
111-hconres-333,M001143 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2010-12-01 1
111-hconres-333,D000216 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2010-12-01 1
111-hconres-333,C001068 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2010-12-01 1
111-hconres-333,R000486 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2010-12-01 1
111-hconres-333,S000248 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2010-12-01 1
111-hconres-333,C000714 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 2010-12-01 1
111-hconres-333,M001137 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2010-12-01 1
111-hconres-333,C000380 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2010-12-01 1
111-hconres-333,P000149 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2010-12-01 1
111-hconres-333,E000288 Supporting the goals and ideals of World AIDS Day. 111-hconres-333 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2010-12-01 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);