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 = "hjres", congress = 102 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_bioguide_id, update_date, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Native Americans · 4 ✖

congress 1

  • 102 · 4 ✖

bill_type 1

  • hjres · 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
102-hjres-509 102 hjres 509 To extend through September 30, 1992, the period in which there remains available for obligation certain amounts appropriated for the Bureau of Indian Affairs for the school operations costs of Bureau-funded schools. Native Americans 1992-06-18 1992-07-02 Became Public Law No: 102-316. House Rep. Yates, Sidney R. [D-IL-9] IL D Y000013 0 Extends the period that certain funds for Bureau of Indian Affairs' schools shall remain available for obligation. 2024-02-05T11:50:03Z  
102-hjres-358 102 hjres 358 Designating 1992 as the "Year of Reconciliation Between American Indians and Non-Indians". Native Americans 1991-10-22 1992-05-01 For Further Action See S.J.Res.222. House Rep. Johnson, Tim [D-SD-At Large] SD D J000177 221 Designates 1992 as the Year of Reconciliation Between American Indians and Non-Indians. 2024-02-06T20:04:02Z  
102-hjres-342 102 hjres 342 To authorize and request the President to proclaim the year 1992 as the "Year of the American Indian". Native Americans 1991-10-03 1991-12-04 For Further Action See S.J.Res.217. House Del. Faleomavaega, Eni F. H. [D-AS-At Large] AS D F000010 227 Designates 1992 as The Year of the American Indian. 2024-02-06T20:04:02Z  
102-hjres-182 102 hjres 182 To authorize and request the President to proclaim the month of November 1991, and thereafter as "National American Indian Heritage Month". Native Americans 1991-03-07 1991-10-09 For Further Action See S.J.Res.172. House Del. Faleomavaega, Eni F. H. [D-AS-At Large] AS D F000010 231 Designates November 1991 and 1992 as National American Indian Heritage Month. 2025-07-21T19:32:26Z  

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