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

13 rows where bill_id = "110-s-3136"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-3136,Criminal justice information FIND Act 110-s-3136 Criminal justice information
110-s-3136,Data banks FIND Act 110-s-3136 Data banks
110-s-3136,Economics and Public Finance FIND Act 110-s-3136 Economics and Public Finance
110-s-3136,Extradition FIND Act 110-s-3136 Extradition
110-s-3136,Federal aid to law enforcement FIND Act 110-s-3136 Federal aid to law enforcement
110-s-3136,Federal-local relations FIND Act 110-s-3136 Federal-local relations
110-s-3136,Federal-state relations FIND Act 110-s-3136 Federal-state relations
110-s-3136,Fugitives from justice FIND Act 110-s-3136 Fugitives from justice
110-s-3136,Government Operations and Politics FIND Act 110-s-3136 Government Operations and Politics
110-s-3136,Law FIND Act 110-s-3136 Law
110-s-3136,Prisoners FIND Act 110-s-3136 Prisoners
110-s-3136,Science, Technology, Communications FIND Act 110-s-3136 Science, Technology, Communications
110-s-3136,Warrants (Law) FIND Act 110-s-3136 Warrants (Law)

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 2.867ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API