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

3 rows where bill_type = "sjres", congress = 101 and policy_area = "Native Americans" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, update_date, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Native Americans · 3 ✖

congress 1

  • 101 · 3 ✖

bill_type 1

  • sjres · 3 ✖
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
101-sjres-311 101 sjres 311 A joint resolution to designate the month of November, 1990 as "National American Indian and Alaska Native Heritage Month". Native Americans 1990-05-09 1990-05-09 Read twice and referred to the Committee on Judiciary. Senate Sen. Inouye, Daniel K. [D-HI] HI D I000025 39 Designates the month of November 1990 as National American Indian and Alaska Native Heritage Month. 2025-07-21T19:32:26Z  
101-sjres-218 101 sjres 218 A joint resolution to designate the week of December 3, 1989, through December 9, 1989, as "National American Indian Heritage Week". Native Americans 1989-10-20 1989-11-28 Became Public Law No: 101-188. Senate Sen. Inouye, Daniel K. [D-HI] HI D I000025 51 Designates the period of December 3 through December 9, 1989, as National American Indian Heritage Week. 2025-07-21T19:32:26Z  
101-sjres-119 101 sjres 119 Natural Resources Equity Act of 1989 Native Americans 1989-05-04 1989-05-04 Read twice and referred to the Committee on Indian Affairs. Senate Sen. Kasten, Robert W., Jr. [R-WI] WI R K000019 1 Natural Resources Equity Act of 1989 - Provides for the interpretation of certain provisions of the 1837 and 1842 treaties with the Chippewa Indians in a manner which would result in an Indian tribal beneficiary of such treaties not being allocated over ten percent of the safe harvest from any lake or other discrete fishery of Wisconsin. Provides that to the extent the application of such provisions results in a reduced safe harvest allocation, it shall represent a taking of such right. Requires the cost of such right to be determined pursuant to U.S. Claims Court proceedings and borne equally between the State of Wisconsin and the U.S. Government. 2025-08-26T17:28:00Z  

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 1321.406ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API