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

26 rows where bill_id = "111-hr-1885" 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 2

  • 1 25
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-1885,Y000033 Private Property Rights Protection Act of 2009 111-hr-1885 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2009-09-22 0
111-hr-1885,S000244 Private Property Rights Protection Act of 2009 111-hr-1885 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2009-04-02 1
111-hr-1885,B001256 Private Property Rights Protection Act of 2009 111-hr-1885 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2009-04-02 1
111-hr-1885,C001049 Private Property Rights Protection Act of 2009 111-hr-1885 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2009-04-02 1
111-hr-1885,C000556 Private Property Rights Protection Act of 2009 111-hr-1885 C000556 Rep. Coble, Howard [R-NC-6] R NC 2009-04-02 1
111-hr-1885,C001068 Private Property Rights Protection Act of 2009 111-hr-1885 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2009-04-02 1
111-hr-1885,C001063 Private Property Rights Protection Act of 2009 111-hr-1885 C001063 Rep. Cuellar, Henry [D-TX-28] D TX 2009-04-02 1
111-hr-1885,C000984 Private Property Rights Protection Act of 2009 111-hr-1885 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2009-04-02 1
111-hr-1885,E000172 Private Property Rights Protection Act of 2009 111-hr-1885 E000172 Rep. Emerson, Jo Ann [R-MO-8] R MO 2009-04-02 1
111-hr-1885,F000448 Private Property Rights Protection Act of 2009 111-hr-1885 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2009-04-02 1
111-hr-1885,G000289 Private Property Rights Protection Act of 2009 111-hr-1885 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2009-04-02 1
111-hr-1885,G000309 Private Property Rights Protection Act of 2009 111-hr-1885 G000309 Rep. Gordon, Bart [D-TN-6] D TN 2009-04-02 1
111-hr-1885,H001041 Private Property Rights Protection Act of 2009 111-hr-1885 H001041 Rep. Heller, Dean [R-NV-2] R NV 2009-04-02 1
111-hr-1885,H000528 Private Property Rights Protection Act of 2009 111-hr-1885 H000528 Rep. Herger, Wally [R-CA-2] R CA 2009-04-02 1
111-hr-1885,H001032 Private Property Rights Protection Act of 2009 111-hr-1885 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2009-04-02 1
111-hr-1885,I000056 Private Property Rights Protection Act of 2009 111-hr-1885 I000056 Rep. Issa, Darrell E. [R-CA-49] R CA 2009-04-02 1
111-hr-1885,K000368 Private Property Rights Protection Act of 2009 111-hr-1885 K000368 Rep. Kirkpatrick, Ann [D-AZ-1] D AZ 2009-04-02 1
111-hr-1885,L000554 Private Property Rights Protection Act of 2009 111-hr-1885 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2009-04-02 1
111-hr-1885,R000395 Private Property Rights Protection Act of 2009 111-hr-1885 R000395 Rep. Rogers, Harold [R-KY-5] R KY 2009-04-02 1
111-hr-1885,R000409 Private Property Rights Protection Act of 2009 111-hr-1885 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2009-04-02 1
111-hr-1885,R000487 Private Property Rights Protection Act of 2009 111-hr-1885 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2009-04-02 1
111-hr-1885,S000250 Private Property Rights Protection Act of 2009 111-hr-1885 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2009-04-02 1
111-hr-1885,S001148 Private Property Rights Protection Act of 2009 111-hr-1885 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2009-04-02 1
111-hr-1885,S001172 Private Property Rights Protection Act of 2009 111-hr-1885 S001172 Rep. Smith, Adrian [R-NE-3] R NE 2009-04-02 1
111-hr-1885,S000583 Private Property Rights Protection Act of 2009 111-hr-1885 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2009-04-02 1
111-hr-1885,W000119 Private Property Rights Protection Act of 2009 111-hr-1885 W000119 Rep. Wamp, Zach [R-TN-3] R TN 2009-04-02 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);