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

10 rows where bill_id = "97-s-2965"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2965,American military assistance An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 American military assistance
97-s-2965,Colombia An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Colombia
97-s-2965,Defense articles An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Defense articles
97-s-2965,Dominican Republic An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Dominican Republic
97-s-2965,Ecuador An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Ecuador
97-s-2965,International Affairs An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 International Affairs
97-s-2965,Mexico An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Mexico
97-s-2965,Pakistan An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Pakistan
97-s-2965,Turkey An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Turkey
97-s-2965,Warships An original bill to authorize the transfer of certain naval vessels to foreign countries. 97-s-2965 Warships

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