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 = "sjres", congress = 109 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

  • 109 · 1 ✖

bill_type 1

  • sjres · 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
109-sjres-15 109 sjres 15 A joint resolution to acknowledge a long history of official depredations and ill-conceived policies by the United States Government regarding Indian tribes and offer an apology to all Native Peoples on behalf of the United States. Native Americans 2005-04-19 2005-08-31 Star Print ordered on the joint resolution. Senate Sen. Brownback, Sam [R-KS] KS R B000953 12 (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Recognizes the special legal and political relationship the Indian tribes have with the United States and the solemn covenant with the land we share. Commends and honors the Native Peoples for the thousands of years that they have stewarded and protected this land. Recognizes that there have been years of official depredations, ill-conceived policies, and the breaking of covenants by the Federal Government regarding Indian tribes. Apologizes on behalf of the people of the United States to all Native Peoples for the many instances of violence, maltreatment, and neglect inflicted on them by U.S. citizens. Expresses the regret of the United States for the ramifications of former wrongs and its commitment to build on the positive relationships of the past and present to move toward reconciliation. Urges the President to acknowledge the wrongs of the United States against Indian tribes in U.S. history. Commends the State governments that have begun reconciliation efforts with recognized Indian tribes located in their boundaries, and encourages all State governments to do the same. Declares that nothing in this Joint Resolution authorizes any claim against the United States or serves as a settlement of any claim against it. 2023-01-13T04:50:18Z  

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