home / openregs

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

35 rows where bill_id = "112-hr-991" 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 35
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-991,F000459 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 F000459 Rep. Fleischmann, Charles J. "Chuck" [R-TN-3] R TN 2011-10-06 0
112-hr-991,A000365 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 A000365 Rep. Austria, Steve [R-OH-7] R OH 2011-09-22 0
112-hr-991,H001051 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 H001051 Rep. Hanna, Richard L. [R-NY-24] R NY 2011-09-13 0
112-hr-991,D000612 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 D000612 Rep. Denham, Jeff [R-CA-19] R CA 2011-09-13 0
112-hr-991,N000184 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 N000184 Rep. Noem, Kristi L. [R-SD-At Large] R SD 2011-07-07 0
112-hr-991,T000467 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 T000467 Rep. Thompson, Glenn [R-PA-5] R PA 2011-06-23 0
112-hr-991,P000373 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2011-06-23 0
112-hr-991,H001048 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 H001048 Rep. Hunter, Duncan D. [R-CA-52] R CA 2011-06-23 0
112-hr-991,K000188 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 K000188 Rep. Kind, Ron [D-WI-3] D WI 2011-06-03 0
112-hr-991,M001144 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2011-05-31 0
112-hr-991,P000601 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2011-05-31 0
112-hr-991,B001250 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2011-05-31 0
112-hr-991,L000573 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 L000573 Rep. Labrador, Raul R. [R-ID-1] R ID 2011-05-31 0
112-hr-991,S001186 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 S001186 Rep. Southerland, Steve II [R-FL-2] R FL 2011-05-31 0
112-hr-991,L000571 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2011-05-31 0
112-hr-991,C001059 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 C001059 Rep. Costa, Jim [D-CA-20] D CA 2011-05-31 0
112-hr-991,M001179 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 M001179 Rep. Marino, Tom [R-PA-10] R PA 2011-05-24 0
112-hr-991,L000566 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2011-05-24 0
112-hr-991,K000363 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 K000363 Rep. Kline, John [R-MN-2] R MN 2011-05-13 0
112-hr-991,L000574 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 L000574 Rep. Landry, Jeffrey M. [R-LA-3] R LA 2011-05-13 0
112-hr-991,D000533 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2011-05-13 0
112-hr-991,B001271 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 B001271 Rep. Benishek, Dan [R-MI-1] R MI 2011-05-13 0
112-hr-991,M001158 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2011-05-13 0
112-hr-991,B001254 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 B001254 Rep. Boren, Dan [D-OK-2] D OK 2011-05-10 0
112-hr-991,B001243 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2011-05-10 0
112-hr-991,D000615 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 D000615 Rep. Duncan, Jeff [R-SC-3] R SC 2011-05-10 0
112-hr-991,C001077 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2011-05-10 0
112-hr-991,P000258 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2011-05-10 0
112-hr-991,R000573 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 R000573 Rep. Ross, Mike [D-AR-4] D AR 2011-05-10 0
112-hr-991,W000804 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2011-05-03 0
112-hr-991,C001062 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2011-05-03 0
112-hr-991,C001051 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 C001051 Rep. Carter, John R. [R-TX-31] R TX 2011-05-03 0
112-hr-991,S001148 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2011-05-03 0
112-hr-991,F000461 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 F000461 Rep. Flores, Bill [R-TX-17] R TX 2011-04-06 0
112-hr-991,B001262 Polar Bear Conservation and Fairness Act of 2011 112-hr-991 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2011-04-06 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);
Powered by Datasette · Queries took 249.137ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API