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

19 rows where bill_id = "97-hr-7264" 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

  • 1 14
  • 0 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-7264,S000423 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 S000423 Rep. Simon, Paul [D-IL-24] D IL 1982-11-30 0
97-hr-7264,S000230 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 S000230 Rep. Seiberling, John F. [D-OH-14] D OH 1982-11-30 0
97-hr-7264,S000675 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 S000675 Rep. Solomon, Gerald B. H. [R-NY-29] R NY 1982-11-30 0
97-hr-7264,S000087 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 S000087 Rep. Sawyer, Harold S. [R-MI-5] R MI 1982-11-30 0
97-hr-7264,N000163 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 N000163 Rep. Nowak, Henry [D-NY-37] D NY 1982-11-30 0
97-hr-7264,M001120 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 M001120 Rep. Murtha, John P. [D-PA-12] D PA 1982-10-01 1
97-hr-7264,E000043 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1982-10-01 1
97-hr-7264,M001088 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1982-10-01 1
97-hr-7264,L000516 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 L000516 Rep. Lundine, Stanley N. [D-NY-39] D NY 1982-10-01 1
97-hr-7264,L000116 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 L000116 Rep. Latta, Delbert L. [R-OH-5] R OH 1982-10-01 1
97-hr-7264,S000669 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 S000669 Rep. Snyder, M. G. (Gene) [R-KY-4] R KY 1982-10-01 1
97-hr-7264,F000339 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 F000339 Rep. Frank, Barney [D-MA-4] D MA 1982-10-01 1
97-hr-7264,L000556 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 L000556 Rep. LaFalce, John J. [D-NY-36] D NY 1982-10-01 1
97-hr-7264,A000214 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1982-10-01 1
97-hr-7264,W000235 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 W000235 Rep. Weber, Ed [R-OH-9] R OH 1982-10-01 1
97-hr-7264,F000141 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 F000141 Rep. Fish, Hamilton, Jr. [R-NY-25] R NY 1982-10-01 1
97-hr-7264,R000383 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1982-10-01 1
97-hr-7264,O000001 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1982-10-01 1
97-hr-7264,Y000014 A bill to amend the Natural Gas Policy Act of 1978 to provide that interstate pipelines be subject to a prudence standard for their natural gas purchases in order to pass through the cost of such purchases to their customers if the pipelines are not subject competition for sales to their customers. 97-hr-7264 Y000014 Rep. Yatron, Gus [D-PA-6] D PA 1982-10-01 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 225.283ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API