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-hr-5259"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-hr-5259,Advisory bodies Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Advisory bodies
99-hr-5259,Alcohol and Alcoholic Beverages Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Alcohol and Alcoholic Beverages
99-hr-5259,Alcoholism Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Alcoholism
99-hr-5259,Animals and Animal Protection Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Animals and Animal Protection
99-hr-5259,Authorization Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Authorization
99-hr-5259,Block grants Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Block grants
99-hr-5259,Child abuse Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Child abuse
99-hr-5259,Child health Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Child health
99-hr-5259,Children and youth Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Children and youth
99-hr-5259,Civil Rights and Liberties Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Civil Rights and Liberties
99-hr-5259,Crime prevention Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Crime prevention
99-hr-5259,Dental care Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Dental care
99-hr-5259,Dentistry Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Dentistry
99-hr-5259,Department of Health and Human Services Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Department of Health and Human Services
99-hr-5259,Drug abuse Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Drug abuse
99-hr-5259,Drug abuse prevention Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Drug abuse prevention
99-hr-5259,Drugs and narcotics Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Drugs and narcotics
99-hr-5259,Economics and Public Finance Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Economics and Public Finance
99-hr-5259,Executive reorganization Alcohol, Drug Abuse, and Mental Health Amendments of 1986 99-hr-5259 Executive reorganization

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