home / openregs

legislation

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

4 rows where bill_type = "sjres", congress = 94 and policy_area = "Public Lands and Natural Resources" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Public Lands and Natural Resources · 4 ✖

congress 1

  • 94 · 4 ✖

bill_type 1

  • sjres · 4 ✖
bill_id congress bill_type bill_number title policy_area introduced_date ▲ latest_action_date latest_action_text origin_chamber sponsor_name sponsor_state sponsor_party sponsor_bioguide_id cosponsor_count summary_text update_date url
94-sjres-207 94 sjres 207 A joint resolution relating to the withdrawal of all minerals in certain areas of the Los Padres National Forest, California, from all forms of appropriation under the mining law and from disposition under all laws pertaining to mineral leasing. Public Lands and Natural Resources 1976-07-22 1976-07-22 Referred to Senate Committee on Interior and Insular Affairs. Senate Sen. Cranston, Alan [D-CA] CA D C000877 1 Withdraws from all forms of appropriation under the mining laws and from disposition under all laws pertaining to mineral leasing and all amendments thereto, all minerals in a specified area within the Los Padres National Forest, California. 2025-04-23T11:41:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/207
94-sjres-197 94 sjres 197 A joint resolution requesting the Secretary of the Interior to take certain action to honor and recognize the role played by James Larkin White in connection with the establishment of Carlsbad Caverns National Park, New Mexico. Public Lands and Natural Resources 1976-05-19 1976-05-19 Referred to Senate Committee on Interior and Insular Affairs. Senate Sen. Montoya, Joseph M. [D-NM] NM D M000876 0 Authorizes and directs the Secretary of the Interior to erect within the Carlsbad Caverns National Park, New Mexico, a monument in honor of James Larkin White. Authorizes necessary appropriations to carry out the provisons of this joint resolution. 2025-04-23T11:41:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/197
94-sjres-139 94 sjres 139 A joint resolution to authorize the Secretary of the Interior to accept Saint Paul's Church, Eastchester. Public Lands and Natural Resources 1975-10-09 1976-08-25 Referred to House Committee on Interior and Insular Affairs. Senate Sen. Javits, Jacob K. [R-NY] NY R J000064 2 (Reported to Senate from the Committee on Interior and Insular Affairs with amendment, S. Rept. 94-1156) Directs the Secretary of the Interior to prepare and transmit to the committees on Interior and Insular Affairs of the Senate and House of Representatives a feasibility-suitability study of St. Paul's Church Eastchester, New York. Requires such study to include cost estimates for any necessary acquisition, operations and maintenance, and development. 2025-04-23T11:41:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/139
94-sjres-20 94 sjres 20 A joint resolution to authorize the establishment of the Tule Elk National Wildlife Refuge and the establishment of a Federal-State management program for the conservation, protection, and enhancement of Tule elk and other species. Public Lands and Natural Resources 1975-01-29 1975-01-29 Referred to Senate Committee on Commerce. Senate Sen. Cranston, Alan [D-CA] CA D C000877 12 Authorizes the establishment of the Tule Elk National Wildlife Refuge in California. Establishes a Federal-State management program for the conservation, protection, and enhancement of tule elk and other species. Authorizes appropriations of such sums as may be necessary to carry out the purposes of this resolution. 2025-01-14T18:51:33Z https://www.congress.gov/bill/94th-congress/senate-joint-resolution/20

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);
Powered by Datasette · Queries took 44.121ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy