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

5 rows where bill_type = "hres", congress = 112 and policy_area = "Commerce" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Commerce · 5 ✖

congress 1

bill_type 1

  • hres · 5 ✖
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
112-hres-793 112 hres 793 Expressing support for the designation of a "Small Business Saturday" and supporting efforts to increase awareness of the value of locally owned small businesses. Commerce 2012-09-20 2012-09-20 Referred to the House Committee on Small Business. House Rep. Graves, Sam [R-MO-6] MO R G000546 30 Supports the designation of a Small Business Saturday. Supports efforts to: (1) encourage consumers to shop locally, and (2) increase awareness of the value of locally owned small businesses and their impact on the U.S. economy. 2019-04-11T15:39:50Z https://www.congress.gov/bill/112th-congress/house-resolution/793
112-hres-729 112 hres 729 Reaffirming the commitment of the House of Representatives to American manufacturing and jobs, and for other purposes. Commerce 2012-07-13 2012-07-13 Referred to the Subcommittee on Commerce, Manufacturing, and Trade. House Rep. Israel, Steve [D-NY-2] NY D I000057 15 Expresses: (1) disapproval of the fact that our U.S. Olympic uniforms were made overseas, and (2) support for U.S. manufacturers and their ability to compete in the global marketplace in both price and quality. Urges the U.S. Olympic Committee to pledge to use American designers and manufacturers for Olympic uniforms in the future. 2021-04-19T17:44:44Z https://www.congress.gov/bill/112th-congress/house-resolution/729
112-hres-678 112 hres 678 Congratulating the United States Chamber of Commerce on its 100th anniversary. Commerce 2012-06-05 2012-06-08 Referred to the Subcommittee on Commerce, Manufacturing, and Trade. House Rep. Lungren, Daniel E. [R-CA-3] CA R L000517 7 Congratulates the United States Chamber of Commerce on its 100th anniversary. 2019-11-15T21:19:47Z https://www.congress.gov/bill/112th-congress/house-resolution/678
112-hres-548 112 hres 548 Acknowledging the National Academy of Inventors (NAI) as a driving factor in the world economy and the contributions of scientist-inventors across all disciplines. Commerce 2012-02-15 2012-02-28 Referred to the Subcommittee on Intellectual Property, Competition and the Internet. House Rep. Castor, Kathy [D-FL-11] FL D C001066 0 Acknowledges the National Academy of Inventors (NAI) as a driving factor in the world economy and the contributions of scientist-inventors. Expresses support for university technological developments, promoting entrepreneurship and, support for university innovations in local communities. Recognizes the importance of inventions, patents, and copyrights as part of maintaining U.S. leadership in the world and a competitive global economy. 2019-11-15T21:34:59Z https://www.congress.gov/bill/112th-congress/house-resolution/548
112-hres-468 112 hres 468 Expressing support for the designation of a "Small Business Saturday" and supporting efforts to increase awareness of the value of locally owned small businesses. Commerce 2011-11-16 2011-11-16 Referred to the House Committee on Small Business. House Rep. Graves, Sam [R-MO-6] MO R G000546 23 Supports the designation of a Small Business Saturday. Supports efforts to: (1) encourage consumers to shop locally, and (2) increase awareness of the value of locally owned small businesses and their impact on the U.S. economy. 2019-04-11T15:40:32Z https://www.congress.gov/bill/112th-congress/house-resolution/468

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