home / openregs

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 = "115-s-3271"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-s-3271,Correctional facilities and imprisonment No Money Bail Act 115-s-3271 Correctional facilities and imprisonment
115-s-3271,Criminal justice information and records No Money Bail Act 115-s-3271 Criminal justice information and records
115-s-3271,Criminal procedure and sentencing No Money Bail Act 115-s-3271 Criminal procedure and sentencing
115-s-3271,Detention of persons No Money Bail Act 115-s-3271 Detention of persons
115-s-3271,Government studies and investigations No Money Bail Act 115-s-3271 Government studies and investigations
115-s-3271,Judicial procedure and administration No Money Bail Act 115-s-3271 Judicial procedure and administration
115-s-3271,Law enforcement administration and funding No Money Bail Act 115-s-3271 Law enforcement administration and funding
115-s-3271,Lawyers and legal services No Money Bail Act 115-s-3271 Lawyers and legal services
115-s-3271,Legal fees and court costs No Money Bail Act 115-s-3271 Legal fees and court costs
115-s-3271,State and local courts No Money Bail Act 115-s-3271 State and local courts

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);
Powered by Datasette · Queries took 8.694ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API