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 = "hjres", congress = 106 and policy_area = "Social Welfare" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Social Welfare · 1 ✖

congress 1

bill_type 1

  • hjres · 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
106-hjres-32 106 hjres 32 Social Security Guarantee Initiative Social Welfare 1999-02-23 1999-03-03 Received in the Senate and read twice and referred to the Committee on Finance. House Rep. Ryan, Paul [R-WI-1] WI R R000570 1 Social Security Guarantee Initiative - Calls for the President and Congress to join in strengthening the social security program and protecting the retirement income security of all Americans for the 21st century in a manner that: (1) ensures equal treatment across generations to all Americans, especially minorities and other low- income workers; (2) recognizes the unique obstacles that women face in ensuring retirement, disability, and survivor security and the essential role that such program plays in protecting women's financial stability; (3) provides a continuous benefit safety net for workers, survivors, their dependents, and the disabled; (4) protects guaranteed lifetime benefits, including cost-of-living adjustments that fully index for inflation, for current and future retirees; and (5) does not increase taxes. 2025-04-07T13:47:02Z https://www.congress.gov/bill/106th-congress/house-joint-resolution/32

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