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 = 106 and policy_area = "Agriculture and Food" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Agriculture and Food · 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
106-hconres-296 106 hconres 296 Expressing the sense of the Congress regarding the necessity to expedite the settlement process for discrimination claims against the Department of Agriculture brought by African-American farmers. Agriculture and Food 2000-03-30 2000-05-08 On motion to suspend the rules and agree to the resolution Failed by the Yeas and Nays: (2/3 required): 216 - 180 (Roll no. 146). (text: CR H2623-2624) House Rep. Dickey, Jay [R-AR-4] AR R D000312 1 Expresses the sense of Congress that the settlement process and claims of African-American farmers against the Department of Agriculture should be resolved expeditiously. 2025-04-07T13:46:39Z https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/296
106-hconres-113 106 hconres 113 Expressing the commitment of Congress to address the emergency that currently exists in American agriculture. Agriculture and Food 1999-05-25 1999-05-25 Referred to the House Committee on Agriculture. House Rep. Berry, Marion [D-AR-1] AR D B000420 13 Expresses the commitment of Congress to American farmers and the need for future appropriations to address the existing emergency in American agriculture. 2025-01-02T17:07:21Z https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/113
106-hconres-14 106 hconres 14 Expressing the sense of the Congress regarding the actions needed to address the disastrous decline in hog prices for American pork producers and to relieve the wide-spread economic hardship currently being suffered by these producers. Agriculture and Food 1999-01-19 1999-02-11 Referred to the Subcommittee on Livestock and Horticulture. House Rep. Kaptur, Marcy [D-OH-9] OH D K000009 16 Expresses the sense of the Congress that specified further assistance is needed for pork producers. 2025-03-21T14:53:55Z https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/14

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