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

1 row where bill_type = "hconres", congress = 100 and policy_area = "Native Americans" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Native Americans · 1 ✖

congress 1

  • 100 · 1 ✖

bill_type 1

  • hconres · 1 ✖
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
100-hconres-331 100 hconres 331 A concurrent resolution to acknowledge the contribution of the Iroquois Confederacy of Nations to the development of the United States Constitution and to reaffirm the continuing government-to-government relationship between Indian tribes and the United States established in the Constitution. Native Americans 1988-07-11 1988-10-21 Resolution agreed to in Senate without amendment and with a preamble by Voice Vote. House Rep. Udall, Morris K. [D-AZ-2] AZ D U000001 2 (Measure passed House, amended, roll call #413 (408-8)) Acknowledges the contributions made by the Iroquois Confederacy and other Indian nations to the formation and development of the United States. Reaffirms the government-to-government relationship between the United States and Indian tribes. Reaffirms the trust responsibility and obligation of the Government to Indian tribes, including Alaska Natives. Acknowledges the need to exercise good faith in upholding treaties with the various tribes. 2025-06-20T19:33:16Z  

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