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

6 rows where bill_id = "97-sconres-101"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-sconres-101,Birth defects A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Birth defects
97-sconres-101,Children and youth A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Children and youth
97-sconres-101,Children's rights A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Children's rights
97-sconres-101,Civil Rights and Liberties A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Civil Rights and Liberties
97-sconres-101,Disabled A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Disabled
97-sconres-101,Discrimination against the disabled A concurrent resolution to provide that a handicapped child's right to life should not be abridged or denied on account of age, health, defect, or condition of dependency. 97-sconres-101 Discrimination against the disabled

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