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 = "100-s-2004"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-2004,Air traffic A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Air traffic
100-s-2004,Air traffic controllers A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Air traffic controllers
100-s-2004,Airports A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Airports
100-s-2004,Aviation A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Aviation
100-s-2004,Civil service employment A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Civil service employment
100-s-2004,Collective bargaining A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Collective bargaining
100-s-2004,Collective bargaining in government A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Collective bargaining in government
100-s-2004,District of Columbia A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 District of Columbia
100-s-2004,Federal employees A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Federal employees
100-s-2004,Federal employees and officials A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Federal employees and officials
100-s-2004,Government employee unions A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Government employee unions
100-s-2004,Industrial relations A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Industrial relations
100-s-2004,Labor unions A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Labor unions
100-s-2004,Transportation and Public Works A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Transportation and Public Works
100-s-2004,Transportation workers A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Transportation workers
100-s-2004,Virginia A bill to provide that the provisions of the National Labor Relations Act and the Labor Management Relations Act, 1947, shall apply to employees at the Metropolitan Washington Airports, and for other purposes. 100-s-2004 Virginia

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