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

17 rows where bill_id = "102-s-2201"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
102-s-2201,Aliens Soviet Scientists Immigration Act of 1992 102-s-2201 Aliens
102-s-2201,Baltic States Soviet Scientists Immigration Act of 1992 102-s-2201 Baltic States
102-s-2201,CIS countries Soviet Scientists Immigration Act of 1992 102-s-2201 CIS countries
102-s-2201,Education Soviet Scientists Immigration Act of 1992 102-s-2201 Education
102-s-2201,Educational exchanges Soviet Scientists Immigration Act of 1992 102-s-2201 Educational exchanges
102-s-2201,Engineers Soviet Scientists Immigration Act of 1992 102-s-2201 Engineers
102-s-2201,Estonia Soviet Scientists Immigration Act of 1992 102-s-2201 Estonia
102-s-2201,Foreign Trade and International Finance Soviet Scientists Immigration Act of 1992 102-s-2201 Foreign Trade and International Finance
102-s-2201,Foreign trade promotion Soviet Scientists Immigration Act of 1992 102-s-2201 Foreign trade promotion
102-s-2201,International Affairs Soviet Scientists Immigration Act of 1992 102-s-2201 International Affairs
102-s-2201,International competitiveness Soviet Scientists Immigration Act of 1992 102-s-2201 International competitiveness
102-s-2201,Latvia Soviet Scientists Immigration Act of 1992 102-s-2201 Latvia
102-s-2201,Lithuania Soviet Scientists Immigration Act of 1992 102-s-2201 Lithuania
102-s-2201,Nuclear nonproliferation Soviet Scientists Immigration Act of 1992 102-s-2201 Nuclear nonproliferation
102-s-2201,Scholarships Soviet Scientists Immigration Act of 1992 102-s-2201 Scholarships
102-s-2201,Scientific exchanges Soviet Scientists Immigration Act of 1992 102-s-2201 Scientific exchanges
102-s-2201,Scientists Soviet Scientists Immigration Act of 1992 102-s-2201 Scientists

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