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 = "99-s-2003"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-2003,Acid precipitation (Meteorology) Acid Rain Control Act of 1986 99-s-2003 Acid precipitation (Meteorology)
99-s-2003,Advisory bodies Acid Rain Control Act of 1986 99-s-2003 Advisory bodies
99-s-2003,Air pollution control Acid Rain Control Act of 1986 99-s-2003 Air pollution control
99-s-2003,Canada Acid Rain Control Act of 1986 99-s-2003 Canada
99-s-2003,Coal Acid Rain Control Act of 1986 99-s-2003 Coal
99-s-2003,Cost effectiveness Acid Rain Control Act of 1986 99-s-2003 Cost effectiveness
99-s-2003,Electric power production Acid Rain Control Act of 1986 99-s-2003 Electric power production
99-s-2003,Energy Acid Rain Control Act of 1986 99-s-2003 Energy
99-s-2003,Energy facilities Acid Rain Control Act of 1986 99-s-2003 Energy facilities
99-s-2003,Federal advisory bodies Acid Rain Control Act of 1986 99-s-2003 Federal advisory bodies
99-s-2003,Federal-state relations Acid Rain Control Act of 1986 99-s-2003 Federal-state relations
99-s-2003,Fees Acid Rain Control Act of 1986 99-s-2003 Fees
99-s-2003,International Affairs Acid Rain Control Act of 1986 99-s-2003 International Affairs
99-s-2003,International environmental cooperation Acid Rain Control Act of 1986 99-s-2003 International environmental cooperation
99-s-2003,Mines and mineral resources Acid Rain Control Act of 1986 99-s-2003 Mines and mineral resources
99-s-2003,Nitrogen oxides Acid Rain Control Act of 1986 99-s-2003 Nitrogen oxides
99-s-2003,Research and development Acid Rain Control Act of 1986 99-s-2003 Research and development
99-s-2003,Standards Acid Rain Control Act of 1986 99-s-2003 Standards
99-s-2003,Sulphur oxides Acid Rain Control Act of 1986 99-s-2003 Sulphur oxides

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