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

42 rows where bill_id = "112-hr-6038" 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 32
  • 0 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-6038,R000053 Global Conservation Act of 2012 112-hr-6038 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2012-11-30 0
112-hr-6038,N000179 Global Conservation Act of 2012 112-hr-6038 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2012-10-26 0
112-hr-6038,P000597 Global Conservation Act of 2012 112-hr-6038 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2012-09-21 0
112-hr-6038,M001149 Global Conservation Act of 2012 112-hr-6038 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2012-09-21 0
112-hr-6038,S000810 Global Conservation Act of 2012 112-hr-6038 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2012-09-20 0
112-hr-6038,R000462 Global Conservation Act of 2012 112-hr-6038 R000462 Rep. Rothman, Steven R. [D-NJ-9] D NJ 2012-09-20 0
112-hr-6038,L000551 Global Conservation Act of 2012 112-hr-6038 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2012-09-20 0
112-hr-6038,H001054 Global Conservation Act of 2012 112-hr-6038 H001054 Rep. Hayworth, Nan A. S. [R-NY-19] R NY 2012-09-20 0
112-hr-6038,B001232 Global Conservation Act of 2012 112-hr-6038 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2012-09-20 0
112-hr-6038,T000460 Global Conservation Act of 2012 112-hr-6038 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2012-09-20 0
112-hr-6038,C001060 Global Conservation Act of 2012 112-hr-6038 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2012-06-27 1
112-hr-6038,B001243 Global Conservation Act of 2012 112-hr-6038 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2012-06-27 1
112-hr-6038,C001058 Global Conservation Act of 2012 112-hr-6038 C001058 Rep. Chandler, Ben [D-KY-6] D KY 2012-06-27 1
112-hr-6038,B001228 Global Conservation Act of 2012 112-hr-6038 B001228 Rep. Bono Mack, Mary [R-CA-45] R CA 2012-06-27 1
112-hr-6038,C001080 Global Conservation Act of 2012 112-hr-6038 C001080 Rep. Chu, Judy [D-CA-32] D CA 2012-06-27 1
112-hr-6038,C001045 Global Conservation Act of 2012 112-hr-6038 C001045 Rep. Crenshaw, Ander [R-FL-4] R FL 2012-06-27 1
112-hr-6038,C001068 Global Conservation Act of 2012 112-hr-6038 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2012-06-27 1
112-hr-6038,G000569 Global Conservation Act of 2012 112-hr-6038 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-06-27 1
112-hr-6038,D000327 Global Conservation Act of 2012 112-hr-6038 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 2012-06-27 1
112-hr-6038,J000292 Global Conservation Act of 2012 112-hr-6038 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2012-06-27 1
112-hr-6038,E000288 Global Conservation Act of 2012 112-hr-6038 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2012-06-27 1
112-hr-6038,K000220 Global Conservation Act of 2012 112-hr-6038 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2012-06-27 1
112-hr-6038,E000179 Global Conservation Act of 2012 112-hr-6038 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2012-06-27 1
112-hr-6038,M001144 Global Conservation Act of 2012 112-hr-6038 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2012-06-27 1
112-hr-6038,F000030 Global Conservation Act of 2012 112-hr-6038 F000030 Rep. Farr, Sam [D-CA-17] D CA 2012-06-27 1
112-hr-6038,R000578 Global Conservation Act of 2012 112-hr-6038 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2012-06-27 1
112-hr-6038,H001042 Global Conservation Act of 2012 112-hr-6038 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2012-06-27 1
112-hr-6038,R000487 Global Conservation Act of 2012 112-hr-6038 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2012-06-27 1
112-hr-6038,H001032 Global Conservation Act of 2012 112-hr-6038 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2012-06-27 1
112-hr-6038,W000804 Global Conservation Act of 2012 112-hr-6038 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2012-06-27 1
112-hr-6038,J000288 Global Conservation Act of 2012 112-hr-6038 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2012-06-27 1
112-hr-6038,Y000033 Global Conservation Act of 2012 112-hr-6038 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2012-06-27 1
112-hr-6038,K000369 Global Conservation Act of 2012 112-hr-6038 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2012-06-27 1
112-hr-6038,M000087 Global Conservation Act of 2012 112-hr-6038 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2012-06-27 1
112-hr-6038,M001143 Global Conservation Act of 2012 112-hr-6038 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-06-27 1
112-hr-6038,M000312 Global Conservation Act of 2012 112-hr-6038 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2012-06-27 1
112-hr-6038,M001160 Global Conservation Act of 2012 112-hr-6038 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2012-06-27 1
112-hr-6038,M000933 Global Conservation Act of 2012 112-hr-6038 M000933 Rep. Moran, James P. [D-VA-8] D VA 2012-06-27 1
112-hr-6038,S001145 Global Conservation Act of 2012 112-hr-6038 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2012-06-27 1
112-hr-6038,T000266 Global Conservation Act of 2012 112-hr-6038 T000266 Rep. Tierney, John F. [D-MA-6] D MA 2012-06-27 1
112-hr-6038,V000128 Global Conservation Act of 2012 112-hr-6038 V000128 Rep. Van Hollen, Chris [D-MD-8] D MD 2012-06-27 1
112-hr-6038,W000738 Global Conservation Act of 2012 112-hr-6038 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2012-06-27 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);