openregs: legislation_subjects: 8 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

8 rows where bill_id = "101-s-2012"

descending

Link	bill_id	subject
101-s-2012,Auditing	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Auditing
101-s-2012,Bank records	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Bank records
101-s-2012,Business records	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Business records
101-s-2012,Employee benefit plans	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Employee benefit plans
101-s-2012,Finance and Financial Sector	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Finance and Financial Sector
101-s-2012,Financial statements	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Financial statements
101-s-2012,Insurance companies	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Insurance companies
101-s-2012,Pension funds	A bill to amend the Employee Income Security Act of 1974 to require an independent audit of statements prepared by certain financial institutions with respect to assets of employee benefit plans. 101-s-2012	Pension funds

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