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

43 rows where bill_id = "112-hjres-73" 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

  • 0 23
  • 1 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hjres-73,Q000023 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2011-10-12 0
112-hjres-73,H000528 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 H000528 Rep. Herger, Wally [R-CA-2] R CA 2011-10-05 0
112-hjres-73,N000186 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2011-10-03 0
112-hjres-73,Y000064 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 Y000064 Rep. Young, Todd [R-IN-9] R IN 2011-09-26 0
112-hjres-73,S001171 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 S001171 Rep. Shuler, Heath [D-NC-11] D NC 2011-09-26 0
112-hjres-73,H001057 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 H001057 Rep. Huelskamp, Tim [R-KS-1] R KS 2011-09-22 0
112-hjres-73,W000798 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 W000798 Rep. Walberg, Tim [R-MI-7] R MI 2011-09-21 0
112-hjres-73,B001149 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 B001149 Rep. Burton, Dan [R-IN-5] R IN 2011-09-21 0
112-hjres-73,S000250 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2011-09-21 0
112-hjres-73,P000373 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2011-09-21 0
112-hjres-73,P000587 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 P000587 Rep. Pence, Mike [R-IN-6] R IN 2011-09-21 0
112-hjres-73,G000550 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2011-09-21 0
112-hjres-73,B001275 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 B001275 Rep. Bucshon, Larry [R-IN-8] R IN 2011-09-21 0
112-hjres-73,R000592 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 R000592 Rep. Rokita, Todd [R-IN-4] R IN 2011-09-21 0
112-hjres-73,D000615 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 D000615 Rep. Duncan, Jeff [R-SC-3] R SC 2011-09-21 0
112-hjres-73,Q000024 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 Q000024 Rep. Quayle, Benjamin [R-AZ-3] R AZ 2011-09-15 0
112-hjres-73,F000448 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2011-08-01 0
112-hjres-73,S001188 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 S001188 Rep. Stutzman, Marlin A. [R-IN-3] R IN 2011-08-01 0
112-hjres-73,T000470 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 T000470 Rep. Tipton, Scott R. [R-CO-3] R CO 2011-07-26 0
112-hjres-73,Y000063 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 Y000063 Rep. Yoder, Kevin [R-KS-3] R KS 2011-07-26 0
112-hjres-73,B001250 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2011-07-25 0
112-hjres-73,P000598 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 P000598 Rep. Polis, Jared [D-CO-2] D CO 2011-07-25 0
112-hjres-73,S001184 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 S001184 Rep. Scott, Tim [R-SC-1] R SC 2011-07-25 0
112-hjres-73,B001271 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 B001271 Rep. Benishek, Dan [R-MI-1] R MI 2011-07-21 1
112-hjres-73,C001064 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 C001064 Rep. Campbell, John [R-CA-48] R CA 2011-07-21 1
112-hjres-73,C001048 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2011-07-21 1
112-hjres-73,F000444 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 F000444 Rep. Flake, Jeff [R-AZ-6] R AZ 2011-07-21 1
112-hjres-73,G000562 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000562 Rep. Gardner, Cory [R-CO-4] R CO 2011-07-21 1
112-hjres-73,G000564 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000564 Rep. Gibson, Christopher P. [R-NY-20] R NY 2011-07-21 1
112-hjres-73,G000565 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000565 Rep. Gosar, Paul A. [R-AZ-1] R AZ 2011-07-21 1
112-hjres-73,G000566 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000566 Rep. Gowdy, Trey [R-SC-4] R SC 2011-07-21 1
112-hjres-73,G000560 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 G000560 Rep. Graves, Tom [R-GA-9] R GA 2011-07-21 1
112-hjres-73,H001059 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2011-07-21 1
112-hjres-73,K000220 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2011-07-21 1
112-hjres-73,L000573 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 L000573 Rep. Labrador, Raul R. [R-ID-1] R ID 2011-07-21 1
112-hjres-73,L000563 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2011-07-21 1
112-hjres-73,M001182 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2011-07-21 1
112-hjres-73,N000185 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 N000185 Rep. Nugent, Richard B. [R-FL-5] R FL 2011-07-21 1
112-hjres-73,P000602 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2011-07-21 1
112-hjres-73,R000587 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 R000587 Rep. Ribble, Reid J. [R-WI-8] R WI 2011-07-21 1
112-hjres-73,S001186 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 S001186 Rep. Southerland, Steve II [R-FL-2] R FL 2011-07-21 1
112-hjres-73,W000811 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 W000811 Rep. Walsh, Joe [R-IL-8] R IL 2011-07-21 1
112-hjres-73,W000810 Proposing a spending limit amendment to the Constitution of the United States. 112-hjres-73 W000810 Rep. Woodall, Rob [R-GA-7] R GA 2011-07-21 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);
Powered by Datasette · Queries took 4089.328ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API