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

2 rows where bill_id = "115-hr-3487"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-hr-3487,Federal district courts To amend section 1332 of title 28, United States Code, to provide that the requirement for diversity of citizenship jurisdiction is met if any one party to the case is diverse in citizenship from any one adverse party in the case. 115-hr-3487 Federal district courts
115-hr-3487,Jurisdiction and venue To amend section 1332 of title 28, United States Code, to provide that the requirement for diversity of citizenship jurisdiction is met if any one party to the case is diverse in citizenship from any one adverse party in the case. 115-hr-3487 Jurisdiction and venue

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