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 = "hjres", congress = 103 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

  • hjres · 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
103-hjres-414 103 hjres 414 To authorize and encourage States to adopt interstate compacts for the regulation of interstate insurance. Commerce 1994-09-23 1994-10-03 Referred to the Subcommittee on Commerce, Consumer Protection and Competitiveness. House Rep. McMillan, J. Alex [R-NC-9] NC R M000566 0 Encourages and authorizes the States to study and adopt interstate insurance regulatory compacts to address regulatory issues, including the regulation of alien insurers and reinsurers, insurer solvency, rehabilitation and liquidation, guaranty fund protection, and insurance agent licensing. Declares that the States which have a majority of property and liability insurance premiums paid in the United States should adopt an interstate compact relating to the certification of alien insurers and reinsurers within two years of this Act's enactment. Requires such compact to establish minimum standards for alien insurers and reinsurers to be certified to do business within such States within three years. Sets forth reporting requirements. 2024-02-05T14:30:09Z https://www.congress.gov/bill/103rd-congress/house-joint-resolution/414
103-hjres-402 103 hjres 402 To designate the week beginning March 12, 1995, as "National Manufacturing Week". Commerce 1994-08-12 1994-08-12 Referred to the House Committee on Post Office and Civil Service. House Rep. Franks, Bob [R-NJ-7] NJ R F000349 45 Designates the week of March 12, 1995, as National Manufacturing Week. 2024-02-06T20:04:02Z https://www.congress.gov/bill/103rd-congress/house-joint-resolution/402
103-hjres-397 103 hjres 397 Designating the week beginning September 12, 1994, as "National Hispanic Business Week". Commerce 1994-08-02 1994-08-02 Referred to the House Committee on Post Office and Civil Service. House Rep. Torres, Esteban Edward [D-CA-34] CA D T000316 81 Designates the week beginning September 12, 1994, as National Hispanic Business Week. 2024-02-06T20:04:02Z https://www.congress.gov/bill/103rd-congress/house-joint-resolution/397
103-hjres-285 103 hjres 285 To designate the week beginning March 13, 1994, as "National Manufacturing Week". Commerce 1993-10-28 1993-10-28 Referred to the House Committee on Post Office and Civil Service. House Rep. Valentine, Tim [D-NC-2] NC D V000006 18 Designates the week beginning March 13, 1994, as National Manufacturing Week. 2024-02-06T20:04:02Z https://www.congress.gov/bill/103rd-congress/house-joint-resolution/285
103-hjres-234 103 hjres 234 Designating the week of October 3 through 9, 1993, as "National Customer Service Week". Commerce 1993-07-20 1993-07-20 Referred to the House Committee on Post Office and Civil Service. House Rep. Glickman, Dan [D-KS-4] KS D G000240 121 Designates October 3 through 9, 1993, as National Customer Service Week. 2024-02-06T20:04:02Z https://www.congress.gov/bill/103rd-congress/house-joint-resolution/234

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