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 = "hconres", congress = 108 and policy_area = "Families" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Families · 3 ✖

congress 1

bill_type 1

  • hconres · 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
108-hconres-157 108 hconres 157 Expressing the sense of Congress supporting education to reduce childhood injuries. Families 2003-04-29 2003-05-09 Referred to the Subcommittee on Health. House Rep. Rogers, Mike J. [R-MI-8] MI R R000572 0 Calls upon all U.S. citizens to support various educational and other efforts and activities to prevent childhood injuries. 2023-01-15T23:03:24Z https://www.congress.gov/bill/108th-congress/house-concurrent-resolution/157
108-hconres-132 108 hconres 132 Calling upon all United States citizens to support the efforts and activities of the National SAFE KIDS Campaign to prevent unintentional childhood injuries. Families 2003-03-31 2003-04-10 Referred to the Subcommittee on Commerce, Trade and Consumer Protection. House Rep. Rogers, Mike J. [R-MI-8] MI R R000572 0 Calls upon all U.S. citizens to support the efforts and activities of the National SAFE KIDS Campaign to prevent unintentional childhood injuries. 2023-01-15T22:18:39Z https://www.congress.gov/bill/108th-congress/house-concurrent-resolution/132
108-hconres-91 108 hconres 91 Expressing the sense of Congress that the Nation should strive to prevent teen pregnancy by encouraging teens to view adolescence as a time for education and growing-up and by educating teens about the negative consequences of early sexual activity. Families 2003-03-12 2003-03-17 Referred to the Subcommittee on Health. House Rep. Castle, Michael N. [R-DE-At Large] DE R C000243 25 Expresses the sense of Congress that the Nation should strive to prevent teen pregnancy by encouraging teens to view adolescence as a time for education and growing-up and by educating teens about the negative consequences of early sexual activity. 2023-01-15T22:18:39Z https://www.congress.gov/bill/108th-congress/house-concurrent-resolution/91

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