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

10 rows where bill_id = "99-hr-5069"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-hr-5069,Administrative procedure Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Administrative procedure
99-hr-5069,Animals and Animal Protection Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Animals and Animal Protection
99-hr-5069,Drug industry Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Drug industry
99-hr-5069,Drug safety and regulation Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Drug safety and regulation
99-hr-5069,Drugs Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Drugs
99-hr-5069,Drugs and narcotics Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Drugs and narcotics
99-hr-5069,Licenses Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Licenses
99-hr-5069,Patents Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Patents
99-hr-5069,Patents, Trademarks, and Copyrights Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Patents, Trademarks, and Copyrights
99-hr-5069,Veterinary medicine Generic Animal Drug and Patent Term Restoration Act 99-hr-5069 Veterinary medicine

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