legislation_subjects

CRS legislative subject terms assigned to bills, useful for filtering by topic.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

19 rows where bill_id = "100-hr-4902"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hr-4902,Administrative procedure A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Administrative procedure
100-hr-4902,Advertising and Marketing A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Advertising and Marketing
100-hr-4902,Air pollution control A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Air pollution control
100-hr-4902,Air pollution measurement A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Air pollution measurement
100-hr-4902,Carbon monoxide A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Carbon monoxide
100-hr-4902,Consumer protection A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Consumer protection
100-hr-4902,Deceptive advertising A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Deceptive advertising
100-hr-4902,Dioxins A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Dioxins
100-hr-4902,Employee training A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Employee training
100-hr-4902,Federal-local relations A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Federal-local relations
100-hr-4902,Fines (Penalties) A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Fines (Penalties)
100-hr-4902,Groundwater A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Groundwater
100-hr-4902,Hazardous waste disposal A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Hazardous waste disposal
100-hr-4902,Incineration A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Incineration
100-hr-4902,Landfills A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Landfills
100-hr-4902,Lead A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Lead
100-hr-4902,Licenses A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Licenses
100-hr-4902,Local and Municipal Government A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Local and Municipal Government
100-hr-4902,Mercury A bill entitled "Municipal Incinerator Act of 1988". 100-hr-4902 Mercury

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE legislation_subjects (
    bill_id TEXT REFERENCES legislation(bill_id),
    subject TEXT,
    PRIMARY KEY (bill_id, subject)
);
CREATE INDEX idx_legsub_subject ON legislation_subjects(subject);