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-hr-5496"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-5496,Accounting Justice for Victims of Corporate Fraud Act 107-hr-5496 Accounting
107-hr-5496,Accounting and auditing Justice for Victims of Corporate Fraud Act 107-hr-5496 Accounting and auditing
107-hr-5496,Affiliated corporations Justice for Victims of Corporate Fraud Act 107-hr-5496 Affiliated corporations
107-hr-5496,Auditing and auditors Justice for Victims of Corporate Fraud Act 107-hr-5496 Auditing and auditors
107-hr-5496,Campaign funds Justice for Victims of Corporate Fraud Act 107-hr-5496 Campaign funds
107-hr-5496,Collection of accounts Justice for Victims of Corporate Fraud Act 107-hr-5496 Collection of accounts
107-hr-5496,Commerce Justice for Victims of Corporate Fraud Act 107-hr-5496 Commerce
107-hr-5496,Compensation (Law) Justice for Victims of Corporate Fraud Act 107-hr-5496 Compensation (Law)
107-hr-5496,Corporate collapse Justice for Victims of Corporate Fraud Act 107-hr-5496 Corporate collapse
107-hr-5496,Corporate governance Justice for Victims of Corporate Fraud Act 107-hr-5496 Corporate governance
107-hr-5496,Corporation directors Justice for Victims of Corporate Fraud Act 107-hr-5496 Corporation directors
107-hr-5496,Corporations Justice for Victims of Corporate Fraud Act 107-hr-5496 Corporations
107-hr-5496,Economics and Public Finance Justice for Victims of Corporate Fraud Act 107-hr-5496 Economics and Public Finance
107-hr-5496,Employee ownership Justice for Victims of Corporate Fraud Act 107-hr-5496 Employee ownership
107-hr-5496,Employee pensions Justice for Victims of Corporate Fraud Act 107-hr-5496 Employee pensions
107-hr-5496,Executives Justice for Victims of Corporate Fraud Act 107-hr-5496 Executives
107-hr-5496,Fines (Penalties) Justice for Victims of Corporate Fraud Act 107-hr-5496 Fines (Penalties)
107-hr-5496,Gifts Justice for Victims of Corporate Fraud Act 107-hr-5496 Gifts
107-hr-5496,Government Operations and Politics Justice for Victims of Corporate Fraud Act 107-hr-5496 Government Operations and Politics

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