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

15 rows where bill_id = "105-s-2179"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-2179,Agriculture and Food Selective Agriculture Embargo Prohibition Act 105-s-2179 Agriculture and Food
105-s-2179,Agriculture in foreign trade Selective Agriculture Embargo Prohibition Act 105-s-2179 Agriculture in foreign trade
105-s-2179,Congress Selective Agriculture Embargo Prohibition Act 105-s-2179 Congress
105-s-2179,Congress and foreign policy Selective Agriculture Embargo Prohibition Act 105-s-2179 Congress and foreign policy
105-s-2179,Congressional oversight Selective Agriculture Embargo Prohibition Act 105-s-2179 Congressional oversight
105-s-2179,Congressional reporting requirements Selective Agriculture Embargo Prohibition Act 105-s-2179 Congressional reporting requirements
105-s-2179,Expedited congressional procedure Selective Agriculture Embargo Prohibition Act 105-s-2179 Expedited congressional procedure
105-s-2179,Export controls Selective Agriculture Embargo Prohibition Act 105-s-2179 Export controls
105-s-2179,Government Operations and Politics Selective Agriculture Embargo Prohibition Act 105-s-2179 Government Operations and Politics
105-s-2179,House rules and procedure Selective Agriculture Embargo Prohibition Act 105-s-2179 House rules and procedure
105-s-2179,International Affairs Selective Agriculture Embargo Prohibition Act 105-s-2179 International Affairs
105-s-2179,Legislative resolutions Selective Agriculture Embargo Prohibition Act 105-s-2179 Legislative resolutions
105-s-2179,President and foreign policy Selective Agriculture Embargo Prohibition Act 105-s-2179 President and foreign policy
105-s-2179,Sanctions (International law) Selective Agriculture Embargo Prohibition Act 105-s-2179 Sanctions (International law)
105-s-2179,Senate rules and procedure Selective Agriculture Embargo Prohibition Act 105-s-2179 Senate rules and procedure

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