home / openregs

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

9 rows where bill_id = "97-s-3003"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-3003,Collective bargaining Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Collective bargaining
97-s-3003,Industrial arbitration Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Industrial arbitration
97-s-3003,Labor disputes Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Labor disputes
97-s-3003,Mediation Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Mediation
97-s-3003,National emergency strikes Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 National emergency strikes
97-s-3003,Presidential powers Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Presidential powers
97-s-3003,Presidents and Vice Presidents Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Presidents and Vice Presidents
97-s-3003,Professional sports Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Professional sports
97-s-3003,Sports and Athletics Organized Professional Team Sports Labor Dispute Resolution Act of 1982 97-s-3003 Sports and Athletics

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);
Powered by Datasette · Queries took 112.932ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API