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 = 97 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 · 3 ✖

congress 1

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
97-sjres-184 97 sjres 184 A joint resolution to designate January 28, 1983 as "Native American Day". Native Americans 1982-04-01 1982-04-21 Referred to House Committee on Post Office and Civil Service. Senate Sen. Inouye, Daniel K. [D-HI] HI D I000025 29 Designates January 28, 1983, as Native American Day. 2025-07-21T19:32:26Z  
97-sjres-136 97 sjres 136 A joint resolution to validate the effectiveness of a plan for the use or distribution of funds appropriated to pay a judgement awarded to the San Carlos Tribe of Arizona. Native Americans 1981-12-15 1981-12-17 Became Public Law No: 97-95. Senate Sen. DeConcini, Dennis [D-AZ] AZ D D000185 0 Validates the effectiveness of a plan for the use or distribution of funds appropriated to pay a judgment awarded to the San Carlos Apache Indian Tribe of Arizona. 2024-02-07T13:32:55Z  
97-sjres-133 97 sjres 133 A joint resolution to authorize and request the President to designate August 14, 1982, as "National Navajo Code Talkers Day". Native Americans 1981-12-10 1982-05-26 Passed Senate without amendment and with a preamble by Voice Vote. Senate Sen. DeConcini, Dennis [D-AZ] AZ D D000185 26 Requests the President to designate August 14, 1982, as "National Navajo Code Talkers Day." 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);