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 = "hconres", congress = 117 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

  • hconres · 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
117-hconres-47 117 hconres 47 Supporting the designation of August 18, 2021, as "Congressional Startup Day". Commerce 2021-08-17 2021-08-18 Referred to the Subcommittee on Consumer Protection and Commerce. House Rep. Phillips, Dean [D-MN-3] MN D P000616 2 This concurrent resolution recognizes the importance of startups to the U.S. economy, supports assisting startups throughout the economic downturn caused by the COVID-19 pandemic, and commits to promoting equal economic opportunity for underrepresented entrepreneurs of all backgrounds. 2023-01-01T23:41:58Z https://www.congress.gov/bill/117th-congress/house-concurrent-resolution/47
117-hconres-18 117 hconres 18 Expressing the sense of Congress regarding the importance of including small business concerns, especially minority-owned small business concerns, in any efforts to leverage the Defense Production Act in response to the COVID-19 pandemic. Commerce 2021-02-24 2021-02-24 Referred to the House Committee on Financial Services. House Rep. Velazquez, Nydia M. [D-NY-7] NY D V000081 1 This concurrent resolution urges the President to give preference to small businesses—especially those that are minority owned—and ensure their participation in specified efforts to respond to COVID-19 (i.e., coronavirus disease 2019). 2023-01-11T13:47:26Z https://www.congress.gov/bill/117th-congress/house-concurrent-resolution/18

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