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

19 rows where bill_id = "107-s-1919"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-s-1919,Accounting Retirement Security Protection Act of 2002 107-s-1919 Accounting
107-s-1919,Accounting and auditing Retirement Security Protection Act of 2002 107-s-1919 Accounting and auditing
107-s-1919,Accounting and financial statements Retirement Security Protection Act of 2002 107-s-1919 Accounting and financial statements
107-s-1919,Administrative procedure Retirement Security Protection Act of 2002 107-s-1919 Administrative procedure
107-s-1919,Annuities Retirement Security Protection Act of 2002 107-s-1919 Annuities
107-s-1919,Auditing Retirement Security Protection Act of 2002 107-s-1919 Auditing
107-s-1919,Civil Rights and Liberties, Minority Issues Retirement Security Protection Act of 2002 107-s-1919 Civil Rights and Liberties, Minority Issues
107-s-1919,Civil actions and liability Retirement Security Protection Act of 2002 107-s-1919 Civil actions and liability
107-s-1919,Collective bargaining agreements Retirement Security Protection Act of 2002 107-s-1919 Collective bargaining agreements
107-s-1919,Commerce Retirement Security Protection Act of 2002 107-s-1919 Commerce
107-s-1919,Conflict of interests Retirement Security Protection Act of 2002 107-s-1919 Conflict of interests
107-s-1919,Congress Retirement Security Protection Act of 2002 107-s-1919 Congress
107-s-1919,Congressional reporting requirements Retirement Security Protection Act of 2002 107-s-1919 Congressional reporting requirements
107-s-1919,Corporate accountability Retirement Security Protection Act of 2002 107-s-1919 Corporate accountability
107-s-1919,Corporate collapse Retirement Security Protection Act of 2002 107-s-1919 Corporate collapse
107-s-1919,Corporation directors Retirement Security Protection Act of 2002 107-s-1919 Corporation directors
107-s-1919,Crime and Law Enforcement Retirement Security Protection Act of 2002 107-s-1919 Crime and Law Enforcement
107-s-1919,Damages Retirement Security Protection Act of 2002 107-s-1919 Damages
107-s-1919,Defined benefit pension plans Retirement Security Protection Act of 2002 107-s-1919 Defined benefit pension plans

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