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

18 rows where bill_id = "112-hconres-98" 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 10
  • 0 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hconres-98,B000213 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 B000213 Rep. Barton, Joe [R-TX-6] R TX 2012-02-08 0
112-hconres-98,H001057 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 H001057 Rep. Huelskamp, Tim [R-KS-1] R KS 2012-02-08 0
112-hconres-98,N000186 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2012-02-08 0
112-hconres-98,S000822 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 2012-02-08 0
112-hconres-98,A000361 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 A000361 Rep. Alexander, Rodney [R-LA-5] R LA 2012-02-06 0
112-hconres-98,P000602 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2012-02-02 0
112-hconres-98,B001274 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 B001274 Rep. Brooks, Mo [R-AL-5] R AL 2012-02-01 0
112-hconres-98,M001158 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2012-02-01 0
112-hconres-98,P000583 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 P000583 Rep. Paul, Ron [R-TX-14] R TX 2012-01-31 1
112-hconres-98,B001273 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 B001273 Rep. Black, Diane [R-TN-6] R TN 2012-01-31 1
112-hconres-98,H001053 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 H001053 Rep. Hartzler, Vicky [R-MO-4] R MO 2012-01-31 1
112-hconres-98,Y000063 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 Y000063 Rep. Yoder, Kevin [R-KS-3] R KS 2012-01-31 1
112-hconres-98,H001059 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2012-01-31 1
112-hconres-98,A000358 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2012-01-31 1
112-hconres-98,S001182 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 S001182 Rep. Schilling, Robert T. [R-IL-17] R IL 2012-01-31 1
112-hconres-98,J000255 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2012-01-31 1
112-hconres-98,H000528 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 H000528 Rep. Herger, Wally [R-CA-2] R CA 2012-01-31 1
112-hconres-98,G000565 To express the sense of the Congress that any Executive order that infringes on the powers and duties of the Congress under article I, section 8 of the Constitution, or that would require the expenditure of Federal funds not specifically appropriated for the purpose of the Executive order, is advisory only and has no force or effect unless enacted as law. 112-hconres-98 G000565 Rep. Gosar, Paul A. [R-AZ-1] R AZ 2012-01-31 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 586.728ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API