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

13 rows where bill_id = "96-s-2986"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
96-s-2986,Americans in foreign countries Foreign Service Act Amendment of 1980 96-s-2986 Americans in foreign countries
96-s-2986,Civil Service pensions Foreign Service Act Amendment of 1980 96-s-2986 Civil Service pensions
96-s-2986,Civil service compensation Foreign Service Act Amendment of 1980 96-s-2986 Civil service compensation
96-s-2986,Civil service employment Foreign Service Act Amendment of 1980 96-s-2986 Civil service employment
96-s-2986,Collective bargaining Foreign Service Act Amendment of 1980 96-s-2986 Collective bargaining
96-s-2986,Department of State Foreign Service Act Amendment of 1980 96-s-2986 Department of State
96-s-2986,Employee-management relations in government Foreign Service Act Amendment of 1980 96-s-2986 Employee-management relations in government
96-s-2986,Federal employees and officials Foreign Service Act Amendment of 1980 96-s-2986 Federal employees and officials
96-s-2986,Foreign service Foreign Service Act Amendment of 1980 96-s-2986 Foreign service
96-s-2986,Government Operations and Politics Foreign Service Act Amendment of 1980 96-s-2986 Government Operations and Politics
96-s-2986,Government employee unions Foreign Service Act Amendment of 1980 96-s-2986 Government employee unions
96-s-2986,Hostages Foreign Service Act Amendment of 1980 96-s-2986 Hostages
96-s-2986,Labor and Employment Foreign Service Act Amendment of 1980 96-s-2986 Labor and Employment

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