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

16 rows where bill_id = "96-s-2602"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
96-s-2602,Depressed areas Local Hire Preference Act 96-s-2602 Depressed areas
96-s-2602,Employment agencies Local Hire Preference Act 96-s-2602 Employment agencies
96-s-2602,Employment and training programs Local Hire Preference Act 96-s-2602 Employment and training programs
96-s-2602,Federal aid programs Local Hire Preference Act 96-s-2602 Federal aid programs
96-s-2602,Federal-local relations Local Hire Preference Act 96-s-2602 Federal-local relations
96-s-2602,Government Operations and Politics Local Hire Preference Act 96-s-2602 Government Operations and Politics
96-s-2602,Government records, documents, and information Local Hire Preference Act 96-s-2602 Government records, documents, and information
96-s-2602,Information services Local Hire Preference Act 96-s-2602 Information services
96-s-2602,Intergovernmental relations Local Hire Preference Act 96-s-2602 Intergovernmental relations
96-s-2602,Local and Municipal Government Local Hire Preference Act 96-s-2602 Local and Municipal Government
96-s-2602,Manpower training programs Local Hire Preference Act 96-s-2602 Manpower training programs
96-s-2602,Public Contracts, Procurement, and Property Local Hire Preference Act 96-s-2602 Public Contracts, Procurement, and Property
96-s-2602,Recruiting of employees Local Hire Preference Act 96-s-2602 Recruiting of employees
96-s-2602,Standards Local Hire Preference Act 96-s-2602 Standards
96-s-2602,States Local Hire Preference Act 96-s-2602 States
96-s-2602,Unemployment Local Hire Preference Act 96-s-2602 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);