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

21 rows where bill_id = "108-s-1925"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-s-1925,Administrative procedure Employee Free Choice Act 108-s-1925 Administrative procedure
108-s-1925,Administrative remedies Employee Free Choice Act 108-s-1925 Administrative remedies
108-s-1925,Civil Rights and Liberties, Minority Issues Employee Free Choice Act 108-s-1925 Civil Rights and Liberties, Minority Issues
108-s-1925,Collective bargaining Employee Free Choice Act 108-s-1925 Collective bargaining
108-s-1925,Commerce Employee Free Choice Act 108-s-1925 Commerce
108-s-1925,Disciplining of employees Employee Free Choice Act 108-s-1925 Disciplining of employees
108-s-1925,Discrimination in employment Employee Free Choice Act 108-s-1925 Discrimination in employment
108-s-1925,Dismissal of employees Employee Free Choice Act 108-s-1925 Dismissal of employees
108-s-1925,Employee rights Employee Free Choice Act 108-s-1925 Employee rights
108-s-1925,Federal Mediation and Conciliation Service Employee Free Choice Act 108-s-1925 Federal Mediation and Conciliation Service
108-s-1925,Fines (Penalties) Employee Free Choice Act 108-s-1925 Fines (Penalties)
108-s-1925,Government Operations and Politics Employee Free Choice Act 108-s-1925 Government Operations and Politics
108-s-1925,Industrial arbitration Employee Free Choice Act 108-s-1925 Industrial arbitration
108-s-1925,Injunctions Employee Free Choice Act 108-s-1925 Injunctions
108-s-1925,Labor contracts Employee Free Choice Act 108-s-1925 Labor contracts
108-s-1925,Labor unions Employee Free Choice Act 108-s-1925 Labor unions
108-s-1925,Law Employee Free Choice Act 108-s-1925 Law
108-s-1925,Mediation Employee Free Choice Act 108-s-1925 Mediation
108-s-1925,National Labor Relations Board Employee Free Choice Act 108-s-1925 National Labor Relations Board
108-s-1925,Unfair labor practices Employee Free Choice Act 108-s-1925 Unfair labor practices
108-s-1925,Wage restitution Employee Free Choice Act 108-s-1925 Wage restitution

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 5.464ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API