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

4 rows where bill_id = "100-s-2196"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-2196,Hours of labor A bill to amend the Fair Labor Standards Act of 1938 to permit an employee to take compensatory time off in lieu of compensation for overtime hours, and for other purposes. 100-s-2196 Hours of labor
100-s-2196,Overtime A bill to amend the Fair Labor Standards Act of 1938 to permit an employee to take compensatory time off in lieu of compensation for overtime hours, and for other purposes. 100-s-2196 Overtime
100-s-2196,Standards A bill to amend the Fair Labor Standards Act of 1938 to permit an employee to take compensatory time off in lieu of compensation for overtime hours, and for other purposes. 100-s-2196 Standards
100-s-2196,Wages A bill to amend the Fair Labor Standards Act of 1938 to permit an employee to take compensatory time off in lieu of compensation for overtime hours, and for other purposes. 100-s-2196 Wages

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