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 = "99-s-2129"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-2129,Bermuda Risk Retention Amendments of 1986 99-s-2129 Bermuda
99-s-2129,British West Indies Risk Retention Amendments of 1986 99-s-2129 British West Indies
99-s-2129,Business and commerce Risk Retention Amendments of 1986 99-s-2129 Business and commerce
99-s-2129,Business insurance Risk Retention Amendments of 1986 99-s-2129 Business insurance
99-s-2129,Cayman Islands Risk Retention Amendments of 1986 99-s-2129 Cayman Islands
99-s-2129,Consumer protection Risk Retention Amendments of 1986 99-s-2129 Consumer protection
99-s-2129,Federal preemption Risk Retention Amendments of 1986 99-s-2129 Federal preemption
99-s-2129,Foreign Trade and Investments Risk Retention Amendments of 1986 99-s-2129 Foreign Trade and Investments
99-s-2129,Fraud Risk Retention Amendments of 1986 99-s-2129 Fraud
99-s-2129,Government liability Risk Retention Amendments of 1986 99-s-2129 Government liability
99-s-2129,Governmental investigations Risk Retention Amendments of 1986 99-s-2129 Governmental investigations
99-s-2129,Group insurance Risk Retention Amendments of 1986 99-s-2129 Group insurance
99-s-2129,Injunctions Risk Retention Amendments of 1986 99-s-2129 Injunctions
99-s-2129,Insurance Risk Retention Amendments of 1986 99-s-2129 Insurance
99-s-2129,Liability insurance Risk Retention Amendments of 1986 99-s-2129 Liability insurance
99-s-2129,Local and Municipal Government Risk Retention Amendments of 1986 99-s-2129 Local and Municipal Government
99-s-2129,Products liability Risk Retention Amendments of 1986 99-s-2129 Products liability
99-s-2129,Risk management Risk Retention Amendments of 1986 99-s-2129 Risk management
99-s-2129,State laws Risk Retention Amendments of 1986 99-s-2129 State laws

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