home / openregs

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 = "97-s-2879"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2879,Bank holding companies Depository Institutions Amendments of 1982 97-s-2879 Bank holding companies
97-s-2879,Bank mergers Depository Institutions Amendments of 1982 97-s-2879 Bank mergers
97-s-2879,Business and commerce Depository Institutions Amendments of 1982 97-s-2879 Business and commerce
97-s-2879,Consumer credit Depository Institutions Amendments of 1982 97-s-2879 Consumer credit
97-s-2879,Consumer protection Depository Institutions Amendments of 1982 97-s-2879 Consumer protection
97-s-2879,Corporations and Stocks Depository Institutions Amendments of 1982 97-s-2879 Corporations and Stocks
97-s-2879,Credit unions Depository Institutions Amendments of 1982 97-s-2879 Credit unions
97-s-2879,Department of the Treasury Depository Institutions Amendments of 1982 97-s-2879 Department of the Treasury
97-s-2879,Deposit insurance Depository Institutions Amendments of 1982 97-s-2879 Deposit insurance
97-s-2879,District of Columbia Depository Institutions Amendments of 1982 97-s-2879 District of Columbia
97-s-2879,Federal Deposit Insurance Corporation Depository Institutions Amendments of 1982 97-s-2879 Federal Deposit Insurance Corporation
97-s-2879,Federal Reserve System Depository Institutions Amendments of 1982 97-s-2879 Federal Reserve System
97-s-2879,Federal home loan banks Depository Institutions Amendments of 1982 97-s-2879 Federal home loan banks
97-s-2879,Federal-state relations Depository Institutions Amendments of 1982 97-s-2879 Federal-state relations
97-s-2879,Government Operations and Politics Depository Institutions Amendments of 1982 97-s-2879 Government Operations and Politics
97-s-2879,Government corporations Depository Institutions Amendments of 1982 97-s-2879 Government corporations
97-s-2879,Government trust funds Depository Institutions Amendments of 1982 97-s-2879 Government trust funds
97-s-2879,Housing and Housing Finance Depository Institutions Amendments of 1982 97-s-2879 Housing and Housing Finance
97-s-2879,Insurance Depository Institutions Amendments of 1982 97-s-2879 Insurance

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);
Powered by Datasette · Queries took 3.007ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API