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

4 rows where bill_id = "93-hr-9155"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
93-hr-9155,Department of State A bill to amend the Immigration and Nationality Act to transfer to the Secretary of State the powers, duties, and functions of consular officers relating to the granting or refusal of visas. 93-hr-9155 Department of State
93-hr-9155,Executive reorganization A bill to amend the Immigration and Nationality Act to transfer to the Secretary of State the powers, duties, and functions of consular officers relating to the granting or refusal of visas. 93-hr-9155 Executive reorganization
93-hr-9155,Passports A bill to amend the Immigration and Nationality Act to transfer to the Secretary of State the powers, duties, and functions of consular officers relating to the granting or refusal of visas. 93-hr-9155 Passports
93-hr-9155,Visas A bill to amend the Immigration and Nationality Act to transfer to the Secretary of State the powers, duties, and functions of consular officers relating to the granting or refusal of visas. 93-hr-9155 Visas

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