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-2798"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-s-2798,Affiliated corporations Employee Abuse Prevention Act of 2002 107-s-2798 Affiliated corporations
107-s-2798,Annuities Employee Abuse Prevention Act of 2002 107-s-2798 Annuities
107-s-2798,Bankruptcy Employee Abuse Prevention Act of 2002 107-s-2798 Bankruptcy
107-s-2798,Bankruptcy courts Employee Abuse Prevention Act of 2002 107-s-2798 Bankruptcy courts
107-s-2798,Brokers Employee Abuse Prevention Act of 2002 107-s-2798 Brokers
107-s-2798,Change of venue Employee Abuse Prevention Act of 2002 107-s-2798 Change of venue
107-s-2798,Commerce Employee Abuse Prevention Act of 2002 107-s-2798 Commerce
107-s-2798,Consultants Employee Abuse Prevention Act of 2002 107-s-2798 Consultants
107-s-2798,Corporate collapse Employee Abuse Prevention Act of 2002 107-s-2798 Corporate collapse
107-s-2798,Corporate finance Employee Abuse Prevention Act of 2002 107-s-2798 Corporate finance
107-s-2798,Corporate governance Employee Abuse Prevention Act of 2002 107-s-2798 Corporate governance
107-s-2798,Corporation directors Employee Abuse Prevention Act of 2002 107-s-2798 Corporation directors
107-s-2798,Corporations Employee Abuse Prevention Act of 2002 107-s-2798 Corporations
107-s-2798,Debtor and creditor Employee Abuse Prevention Act of 2002 107-s-2798 Debtor and creditor
107-s-2798,District courts Employee Abuse Prevention Act of 2002 107-s-2798 District courts
107-s-2798,Employee pensions Employee Abuse Prevention Act of 2002 107-s-2798 Employee pensions
107-s-2798,Evidence (Law) Employee Abuse Prevention Act of 2002 107-s-2798 Evidence (Law)
107-s-2798,Executive compensation Employee Abuse Prevention Act of 2002 107-s-2798 Executive compensation
107-s-2798,Fraud Employee Abuse Prevention Act of 2002 107-s-2798 Fraud

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