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

16 rows where bill_id = "107-hr-4084"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-4084,Affiliated corporations Corporate Asset Protection Act of 2002 107-hr-4084 Affiliated corporations
107-hr-4084,Commerce Corporate Asset Protection Act of 2002 107-hr-4084 Commerce
107-hr-4084,Consultants Corporate Asset Protection Act of 2002 107-hr-4084 Consultants
107-hr-4084,Contractors Corporate Asset Protection Act of 2002 107-hr-4084 Contractors
107-hr-4084,Corporate collapse Corporate Asset Protection Act of 2002 107-hr-4084 Corporate collapse
107-hr-4084,Corporate finance Corporate Asset Protection Act of 2002 107-hr-4084 Corporate finance
107-hr-4084,Corporate governance Corporate Asset Protection Act of 2002 107-hr-4084 Corporate governance
107-hr-4084,Corporation directors Corporate Asset Protection Act of 2002 107-hr-4084 Corporation directors
107-hr-4084,Executives Corporate Asset Protection Act of 2002 107-hr-4084 Executives
107-hr-4084,Fines (Penalties) Corporate Asset Protection Act of 2002 107-hr-4084 Fines (Penalties)
107-hr-4084,Labor and Employment Corporate Asset Protection Act of 2002 107-hr-4084 Labor and Employment
107-hr-4084,Law Corporate Asset Protection Act of 2002 107-hr-4084 Law
107-hr-4084,Loans Corporate Asset Protection Act of 2002 107-hr-4084 Loans
107-hr-4084,Securities regulation Corporate Asset Protection Act of 2002 107-hr-4084 Securities regulation
107-hr-4084,Stockholders Corporate Asset Protection Act of 2002 107-hr-4084 Stockholders
107-hr-4084,Subsidiary corporations Corporate Asset Protection Act of 2002 107-hr-4084 Subsidiary corporations

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