openregs: legislation_subjects: 6 rows where bill

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 = "95-s-2149"

descending

Link	bill_id	subject
95-s-2149,District courts	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	District courts
95-s-2149,Judges	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	Judges
95-s-2149,Judicial districts	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	Judicial districts
95-s-2149,Jurisdiction	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	Jurisdiction
95-s-2149,Territories (U.S.)	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	Territories (U.S.)
95-s-2149,Trust Territory of the Pacific Islands	A bill to create the district court for the Northern Mariana Islands, implementing article IV of the Covenant to Establish a Commonwealth of the Northern Mariana Islands in Political Union with the United States of America. 95-s-2149	Trust Territory of the Pacific Islands

Advanced export

JSON shape: default, array, newline-delimited, object

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