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

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-3617,Accounting Accountability for Accountants Act of 2002 107-hr-3617 Accounting
107-hr-3617,Accounting and auditing Accountability for Accountants Act of 2002 107-hr-3617 Accounting and auditing
107-hr-3617,Accounting and financial statements Accountability for Accountants Act of 2002 107-hr-3617 Accounting and financial statements
107-hr-3617,Auditing Accountability for Accountants Act of 2002 107-hr-3617 Auditing
107-hr-3617,Auditing and auditors Accountability for Accountants Act of 2002 107-hr-3617 Auditing and auditors
107-hr-3617,Bankruptcy Accountability for Accountants Act of 2002 107-hr-3617 Bankruptcy
107-hr-3617,Business records Accountability for Accountants Act of 2002 107-hr-3617 Business records
107-hr-3617,Civil actions and liability Accountability for Accountants Act of 2002 107-hr-3617 Civil actions and liability
107-hr-3617,Class actions (Civil procedure) Accountability for Accountants Act of 2002 107-hr-3617 Class actions (Civil procedure)
107-hr-3617,Commerce Accountability for Accountants Act of 2002 107-hr-3617 Commerce
107-hr-3617,Conflict of interests Accountability for Accountants Act of 2002 107-hr-3617 Conflict of interests
107-hr-3617,Congress Accountability for Accountants Act of 2002 107-hr-3617 Congress
107-hr-3617,Congressional reporting requirements Accountability for Accountants Act of 2002 107-hr-3617 Congressional reporting requirements
107-hr-3617,Consultants Accountability for Accountants Act of 2002 107-hr-3617 Consultants
107-hr-3617,Corporate collapse Accountability for Accountants Act of 2002 107-hr-3617 Corporate collapse
107-hr-3617,Crime and Law Enforcement Accountability for Accountants Act of 2002 107-hr-3617 Crime and Law Enforcement
107-hr-3617,Damages Accountability for Accountants Act of 2002 107-hr-3617 Damages
107-hr-3617,Discovery (Law) Accountability for Accountants Act of 2002 107-hr-3617 Discovery (Law)
107-hr-3617,Financial services Accountability for Accountants Act of 2002 107-hr-3617 Financial services

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