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

19 rows where bill_id = "99-s-2170"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-2170,Business and commerce Labor Productivity Assistance Act 99-s-2170 Business and commerce
99-s-2170,Business and social problems Labor Productivity Assistance Act 99-s-2170 Business and social problems
99-s-2170,Displaced homemakers Labor Productivity Assistance Act 99-s-2170 Displaced homemakers
99-s-2170,Domestic Relations and Families Labor Productivity Assistance Act 99-s-2170 Domestic Relations and Families
99-s-2170,Economics and Public Finance Labor Productivity Assistance Act 99-s-2170 Economics and Public Finance
99-s-2170,Employee training Labor Productivity Assistance Act 99-s-2170 Employee training
99-s-2170,Employment agencies Labor Productivity Assistance Act 99-s-2170 Employment agencies
99-s-2170,Employment and training programs Labor Productivity Assistance Act 99-s-2170 Employment and training programs
99-s-2170,Government lending Labor Productivity Assistance Act 99-s-2170 Government lending
99-s-2170,Government trust funds Labor Productivity Assistance Act 99-s-2170 Government trust funds
99-s-2170,Hard-core unemployed Labor Productivity Assistance Act 99-s-2170 Hard-core unemployed
99-s-2170,Labor productivity Labor Productivity Assistance Act 99-s-2170 Labor productivity
99-s-2170,Labor unions Labor Productivity Assistance Act 99-s-2170 Labor unions
99-s-2170,Layoffs Labor Productivity Assistance Act 99-s-2170 Layoffs
99-s-2170,Manpower training programs Labor Productivity Assistance Act 99-s-2170 Manpower training programs
99-s-2170,Occupational retraining Labor Productivity Assistance Act 99-s-2170 Occupational retraining
99-s-2170,Plant shutdowns Labor Productivity Assistance Act 99-s-2170 Plant shutdowns
99-s-2170,Relocation of employees Labor Productivity Assistance Act 99-s-2170 Relocation of employees
99-s-2170,Structural unemployment Labor Productivity Assistance Act 99-s-2170 Structural unemployment

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