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 = "98-s-2802"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
98-s-2802,Administrative procedure Legal Fees Equity Act 98-s-2802 Administrative procedure
98-s-2802,Courts and Civil Procedure Legal Fees Equity Act 98-s-2802 Courts and Civil Procedure
98-s-2802,Criminal law Legal Fees Equity Act 98-s-2802 Criminal law
98-s-2802,Government Operations and Politics Legal Fees Equity Act 98-s-2802 Government Operations and Politics
98-s-2802,Government liability Legal Fees Equity Act 98-s-2802 Government liability
98-s-2802,Government litigation Legal Fees Equity Act 98-s-2802 Government litigation
98-s-2802,Lawyers and legal services Legal Fees Equity Act 98-s-2802 Lawyers and legal services
98-s-2802,Legal fees Legal Fees Equity Act 98-s-2802 Legal fees
98-s-2802,Local and Municipal Government Legal Fees Equity Act 98-s-2802 Local and Municipal Government
98-s-2802,States Legal Fees Equity Act 98-s-2802 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);
Powered by Datasette · Queries took 140.4ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API