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

14 rows where bill_id = "98-s-3045"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
98-s-3045,Armed Forces and National Security Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Armed Forces and National Security
98-s-3045,Civil service compensation Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Civil service compensation
98-s-3045,Civil service employment Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Civil service employment
98-s-3045,Dentists Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Dentists
98-s-3045,Department of State Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Department of State
98-s-3045,Federal employees Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Federal employees
98-s-3045,Federal employees and officials Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Federal employees and officials
98-s-3045,Foreign service Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Foreign service
98-s-3045,Medical personnel Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Medical personnel
98-s-3045,Nurses Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Nurses
98-s-3045,Physicians Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Physicians
98-s-3045,Recruiting of employees Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Recruiting of employees
98-s-3045,Salaries Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Salaries
98-s-3045,Veterans' medical care Federal Employee Recruitment and Retention Improvement Act of 1984 98-s-3045 Veterans' medical care

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