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

2 rows where bill_type = "hjres", congress = 100 and policy_area = "Commerce" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Commerce · 2 ✖

congress 1

bill_type 1

  • hjres · 2 ✖
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
100-hjres-397 100 hjres 397 A joint resolution expressing the sense of the Congress that the people of the United States should purchase products made in the United States and services provided in the United States, whenever possible, instead of products made or services performed outside the United States. Commerce 1987-11-03 1987-11-16 Referred to Subcommittee on Commerce, Consumer Protection, and Competitiveness. House Rep. Ford, William D. [D-MI-15] MI D F000270 59 Expresses the sense of the Congress that the people of the United States should purchase U.S. products and services whenever possible. Urges the President and the State Governors to issue proclamations calling upon the people to promote this policy with appropriate ceremonies and activities. Requests that leaders of civic and consumer organizations, and of the mass media, assist in: (1) promoting awareness of the importance of selecting U.S. goods and services; and (2) identifying such American goods and services, and the merchants from whom they may be acquired. Requests and encourages U.S. producers and manufacturers to make every effort to label and advertise the U.S. origin of such goods. 2024-02-06T20:04:02Z https://www.congress.gov/bill/100th-congress/house-joint-resolution/397
100-hjres-221 100 hjres 221 A joint resolution to establish a Commission to study the means to revivify and strengthen the National Industrial Base of the United States; and to recommend the proper means of achieving that goal. Commerce 1987-04-01 1987-04-15 Referred to Subcommittee on Economic Stabilization. House Rep. Bentley, Helen Delich [R-MD-2] MD R B000392 14 Establishes a commission to: (1) study the causes of the current decline in the industrial base of the United States; (2) examine and formulate remedies for the decline; and (3) propose to the President and to the Congress programs to remedy the decline and revivify the Nation's industrial manufacturing base. 2024-02-06T19:38:08Z https://www.congress.gov/bill/100th-congress/house-joint-resolution/221

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