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

9 rows where bill_id = "115-s-3650"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-s-3650,Administrative law and regulatory procedures ACCESS Rural America Act 115-s-3650 Administrative law and regulatory procedures
115-s-3650,Congressional oversight ACCESS Rural America Act 115-s-3650 Congressional oversight
115-s-3650,Financial services and investments ACCESS Rural America Act 115-s-3650 Financial services and investments
115-s-3650,Government information and archives ACCESS Rural America Act 115-s-3650 Government information and archives
115-s-3650,Government studies and investigations ACCESS Rural America Act 115-s-3650 Government studies and investigations
115-s-3650,Licensing and registrations ACCESS Rural America Act 115-s-3650 Licensing and registrations
115-s-3650,Securities ACCESS Rural America Act 115-s-3650 Securities
115-s-3650,Securities and Exchange Commission (SEC) ACCESS Rural America Act 115-s-3650 Securities and Exchange Commission (SEC)
115-s-3650,Telecommunication rates and fees ACCESS Rural America Act 115-s-3650 Telecommunication rates and fees

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