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-s-1663"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-1663,Adoption Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Adoption
100-s-1663,Advisory bodies Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Advisory bodies
100-s-1663,Alcohol and youth Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Alcohol and youth
100-s-1663,Alcoholism and crime Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Alcoholism and crime
100-s-1663,Authorization Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Authorization
100-s-1663,Child abuse Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Child abuse
100-s-1663,Children and youth Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Children and youth
100-s-1663,Data banks Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Data banks
100-s-1663,Death and dying Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Death and dying
100-s-1663,Department of Health and Human Services Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Department of Health and Human Services
100-s-1663,Disabled Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Disabled
100-s-1663,Domestic Relations and Families Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Domestic Relations and Families
100-s-1663,Drugs and youth Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Drugs and youth
100-s-1663,Economics and Public Finance Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Economics and Public Finance
100-s-1663,Family violence Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Family violence
100-s-1663,Federal advisory bodies Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Federal advisory bodies
100-s-1663,Federal aid to child welfare Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Federal aid to child welfare
100-s-1663,Government paperwork Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Government paperwork
100-s-1663,Government records, documents, and information Child Abuse Prevention and Treatment Act Reauthorization of 1987 100-s-1663 Government records, documents, and information

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