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

14 rows where bill_id = "101-hres-438" 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 11
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
101-hres-438,B000971 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 B000971 Rep. Bruce, Terry L. [D-IL-19] D IL 1990-09-12 0
101-hres-438,D000044 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 D000044 Rep. Dannemeyer, William E. [R-CA-39] R CA 1990-09-12 0
101-hres-438,S000851 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1990-09-12 0
101-hres-438,S001044 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 S001044 Rep. Stump, Bob [R-AZ-3] R AZ 1990-08-03 0
101-hres-438,C000653 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 C000653 Rep. Combest, Larry [R-TX-19] R TX 1990-08-01 0
101-hres-438,E000250 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 E000250 Rep. Evans, Lane [D-IL-17] D IL 1990-08-01 0
101-hres-438,W000654 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 W000654 Rep. Wise, Robert E., Jr. [D-WV-3] D WV 1990-08-01 0
101-hres-438,M001088 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1990-07-27 0
101-hres-438,P000229 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1990-07-27 0
101-hres-438,B000431 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1990-07-26 0
101-hres-438,M000718 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 M000718 Rep. Miller, Clarence E. [R-OH-10] R OH 1990-07-26 0
101-hres-438,R000011 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1990-07-18 1
101-hres-438,C000523 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 C000523 Rep. Clinger, William F., Jr. [R-PA-23] R PA 1990-07-18 1
101-hres-438,B000657 To express the sense of the House of Representatives with respect to the proposals currently before the Congress to place a tax on fuels based on their carbon content or to tax the carbon emissions from the burning of fossil fuels. 101-hres-438 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1990-07-18 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 5.165ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API