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

6 rows where bill_id = "103-hjres-417"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-hjres-417,Industrial arbitration Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 Industrial arbitration
103-hjres-417,Labor disputes Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 Labor disputes
103-hjres-417,National emergency strikes Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 National emergency strikes
103-hjres-417,Railroad employees Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 Railroad employees
103-hjres-417,Railroad freight operations Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 Railroad freight operations
103-hjres-417,Transportation and Public Works Providing for temporary extension of the application of the final paragraph of section 10 of the Railway Labor Act with respect to the dispute between the Soo Line Railroad Company and certain of its employees. 103-hjres-417 Transportation and Public Works

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