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

32 rows where bill_id = "112-hconres-144" 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 26
  • 0 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hconres-144,L000566 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2012-12-17 0
112-hconres-144,H000528 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 H000528 Rep. Herger, Wally [R-CA-2] R CA 2012-12-17 0
112-hconres-144,B001256 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2012-12-17 0
112-hconres-144,W000796 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 W000796 Rep. Westmoreland, Lynn A. [R-GA-3] R GA 2012-12-13 0
112-hconres-144,J000174 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2012-12-13 0
112-hconres-144,S001172 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 S001172 Rep. Smith, Adrian [R-NE-3] R NE 2012-12-13 0
112-hconres-144,B001250 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2012-12-07 1
112-hconres-144,F000458 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 F000458 Rep. Fincher, Stephen Lee [R-TN-8] R TN 2012-12-07 1
112-hconres-144,F000459 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 F000459 Rep. Fleischmann, Charles J. "Chuck" [R-TN-3] R TN 2012-12-07 1
112-hconres-144,G000563 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 G000563 Rep. Gibbs, Bob [R-OH-18] R OH 2012-12-07 1
112-hconres-144,G000552 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2012-12-07 1
112-hconres-144,H001057 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 H001057 Rep. Huelskamp, Tim [R-KS-1] R KS 2012-12-07 1
112-hconres-144,J000255 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2012-12-07 1
112-hconres-144,L000574 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 L000574 Rep. Landry, Jeffrey M. [R-LA-3] R LA 2012-12-07 1
112-hconres-144,L000575 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 L000575 Rep. Lankford, James [R-OK-5] R OK 2012-12-07 1
112-hconres-144,C001047 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 C001047 Rep. Capito, Shelley Moore [R-WV-2] R WV 2012-12-07 1
112-hconres-144,O000168 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 O000168 Rep. Olson, Pete [R-TX-22] R TX 2012-12-07 1
112-hconres-144,S001176 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 S001176 Rep. Scalise, Steve [R-LA-1] R LA 2012-12-07 1
112-hconres-144,T000459 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 T000459 Rep. Terry, Lee [R-NE-2] R NE 2012-12-07 1
112-hconres-144,W000795 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2012-12-07 1
112-hconres-144,L000571 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2012-12-07 1
112-hconres-144,S001189 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 S001189 Rep. Scott, Austin [R-GA-8] R GA 2012-12-07 1
112-hconres-144,B001262 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2012-12-07 1
112-hconres-144,W000798 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 W000798 Rep. Walberg, Tim [R-MI-7] R MI 2012-12-07 1
112-hconres-144,N000182 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2012-12-07 1
112-hconres-144,F000461 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 F000461 Rep. Flores, Bill [R-TX-17] R TX 2012-12-07 1
112-hconres-144,M001182 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2012-12-07 1
112-hconres-144,L000564 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2012-12-07 1
112-hconres-144,M001184 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 M001184 Rep. Massie, Thomas [R-KY-4] R KY 2012-12-07 1
112-hconres-144,B001255 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 B001255 Rep. Boustany, Charles W., Jr. [R-LA-7] R LA 2012-12-07 1
112-hconres-144,B000755 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2012-12-07 1
112-hconres-144,N000186 Expressing the sense of Congress that a carbon tax is not in the economic interest of the United States. 112-hconres-144 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2012-12-07 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 1062.644ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API