openregs: legislation_subjects: 8 rows where bill

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

8 rows where bill_id = "96-hr-7204"

descending

Link	bill_id	subject
96-hr-7204,Aliens	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Aliens
96-hr-7204,Education	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Education
96-hr-7204,Foreign-trained physicians	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Foreign-trained physicians
96-hr-7204,Medical education	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Medical education
96-hr-7204,Medical personnel	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Medical personnel
96-hr-7204,Passports	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Passports
96-hr-7204,Physicians	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Physicians
96-hr-7204,Visas	A bill to amend the Health Professions Educational Assistance Act of 1976 to provide for appropriate graduate medical education and training for alien graduates of foreign medical schools, and for other purposes. 96-hr-7204	Visas

Advanced export

JSON shape: default, array, newline-delimited, object

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