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 = "hconres", congress = 100 and policy_area = "Crime and Law Enforcement" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Crime and Law Enforcement · 5 ✖

congress 1

bill_type 1

  • hconres · 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
100-hconres-309 100 hconres 309 A concurrent resolution expressing the sense of the Congress that any proposal to legalize illicit drugs as a method to address the problem of illicit drug trafficking and use in the United States should be rejected. Crime and Law Enforcement 1988-06-02 1988-06-13 Referred to Subcommittee on Health and the Environment. House Rep. Armey, Richard K. [R-TX-26] TX R A000217 22 Expresses the sense of the Congress that: (1) any proposal to legalize illicit drugs, as a method to combat their sale and use, should be rejected; and (2) the Congress should explore only those proposals which directly attack the supply of, and demand for, illicit drugs. 2024-02-05T14:30:09Z https://www.congress.gov/bill/100th-congress/house-concurrent-resolution/309
100-hconres-285 100 hconres 285 A concurrent resolution relating to drug trafficking in the Washington Metropolitan Area. Crime and Law Enforcement 1988-04-21 1988-05-05 Referred to Subcommittee on Aviation. House Rep. Parris, Stanford E. (Stan) [R-VA-8] VA R P000080 2 Expresses the sense of the Congress that certain actions should be taken in the Washington, D.C. Metropolitan Area to curtail drug trafficking, including: (1) creating a model drug enterprise control zone; (2) equipping police officers with nonlethal electronic stunning devices; (3) cross-deputizing law enforcement officials; and (4) adopting a metropolitan area-wide drug abuse policy. 2024-02-07T16:02:17Z https://www.congress.gov/bill/100th-congress/house-concurrent-resolution/285
100-hconres-84 100 hconres 84 A concurrent resolution expressing the sense of the Congress that the mail fraud charges brought against Marcus Garvey by the Federal Government were not substantiated and that his conviction on those charges was unjust and unwarranted. Crime and Law Enforcement 1987-03-19 1988-08-11 Forwarded by Subcommittee to Full Committee. House Rep. Rangel, Charles B. [D-NY-16] NY D R000053 30 Expresses the sense of the Congress the mail fraud charges brought against black leader Marcus Garvey in 1923 were not substantiated and that his conviction was unjust and unwarranted. 2021-06-10T20:20:38Z https://www.congress.gov/bill/100th-congress/house-concurrent-resolution/84
100-hconres-58 100 hconres 58 A concurrent resolution expressing the sense of the Congress that the President should grant a posthumous full, free, and absolute pardon to Marcus Garvey for any offenses against the United States for which he was convicted. Crime and Law Enforcement 1987-03-03 1987-03-06 Referred to Subcommittee on Criminal Justice. House Rep. Rangel, Charles B. [D-NY-16] NY D R000053 0 Expresses the sense of the Congress that the President should grant a posthumous full, free, and absolute pardon to Marcus Garvey for any offenses for which he was convicted. 2021-06-10T20:20:30Z https://www.congress.gov/bill/100th-congress/house-concurrent-resolution/58
100-hconres-6 100 hconres 6 A concurrent resolution expressing the sense of the Congress with respect to the right of all Americans to keep and bear arms in defense of life or liberty and in the pursuit of all other legitimate endeavors. Crime and Law Enforcement 1987-01-06 1987-02-10 Referred to Subcommittee on Crime. House Rep. Crane, Philip M. [R-IL-12] IL R C000873 8 Expresses the sense of the Congress that the Constitution provides that all citizens have the right to keep and bear arms and that such right supersedes the power and authority of any government. 2021-06-10T20:20:17Z https://www.congress.gov/bill/100th-congress/house-concurrent-resolution/6

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