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

14 rows where bill_id = "96-s-2170"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
96-s-2170,Administration of criminal justice Center for Defense Services Act 96-s-2170 Administration of criminal justice
96-s-2170,Corporations and Stocks Center for Defense Services Act 96-s-2170 Corporations and Stocks
96-s-2170,Courts and Civil Procedure Center for Defense Services Act 96-s-2170 Courts and Civil Procedure
96-s-2170,Criminal procedure and sentencing Center for Defense Services Act 96-s-2170 Criminal procedure and sentencing
96-s-2170,Government corporations Center for Defense Services Act 96-s-2170 Government corporations
96-s-2170,Grants-in-aid Center for Defense Services Act 96-s-2170 Grants-in-aid
96-s-2170,Intergovernmental relations Center for Defense Services Act 96-s-2170 Intergovernmental relations
96-s-2170,Lawyers and legal services Center for Defense Services Act 96-s-2170 Lawyers and legal services
96-s-2170,Legal aid Center for Defense Services Act 96-s-2170 Legal aid
96-s-2170,Legal assistance to the poor Center for Defense Services Act 96-s-2170 Legal assistance to the poor
96-s-2170,Legal fees Center for Defense Services Act 96-s-2170 Legal fees
96-s-2170,Legal services Center for Defense Services Act 96-s-2170 Legal services
96-s-2170,State courts Center for Defense Services Act 96-s-2170 State courts
96-s-2170,States Center for Defense Services Act 96-s-2170 States

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