openregs: legislation: 1 row where bill_type = "sjres", congress = 108 and policy_area = "Native Americans" sorted by introduced

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 = 108 and policy_area = "Native Americans" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
108-sjres-37	108	sjres	37	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	2004-05-06	2004-07-15	Placed on Senate Legislative Calendar under General Orders. Calendar No. 638.	Senate	Sen. Brownback, Sam [R-KS]	KS	R	B000953	6	Declares that the United States acting through Congress: (1) recognizes the special legal and political relationship the Indian tribes have with it, the solemn covenant with the land we share, and that there have been years of official depredations, ill-conceived policies, and the breaking of covenants by the Federal Government regarding Indian tribes; (2) commends and honors the Native Peoples for the thousands of years that they have stewarded and protected this land; (3) 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; (4) expresses its regret for the ramifications of former offenses and its commitment to build on the positive relationships of the past and present to move toward a brighter future where all the people of this land live reconciled as brothers and sisters, and harmoniously steward and protect this land together; (5) urges the President to acknowledge the wrongs of the United States against Indian tribes in U.S. history in order to bring healing to this land by providing a proper foundation for reconciliation between such entities; and (6) commends the State governments that have begun reconciliation efforts with recognized Indian tribes located in their boundaries and encourages all State governments similarly to do the same. Provides 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-15T04:49:08Z

Advanced export

JSON shape: default, array, newline-delimited, object

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);