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

19 rows where bill_id = "105-s-1331"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-1331,Access to airports Aviation Competition Enhancement Act of 1997 105-s-1331 Access to airports
105-s-1331,Administrative procedure Aviation Competition Enhancement Act of 1997 105-s-1331 Administrative procedure
105-s-1331,Administrative remedies Aviation Competition Enhancement Act of 1997 105-s-1331 Administrative remedies
105-s-1331,Air routes Aviation Competition Enhancement Act of 1997 105-s-1331 Air routes
105-s-1331,Airline passenger traffic Aviation Competition Enhancement Act of 1997 105-s-1331 Airline passenger traffic
105-s-1331,Airlines Aviation Competition Enhancement Act of 1997 105-s-1331 Airlines
105-s-1331,Airports Aviation Competition Enhancement Act of 1997 105-s-1331 Airports
105-s-1331,Auctions Aviation Competition Enhancement Act of 1997 105-s-1331 Auctions
105-s-1331,Aviation safety Aviation Competition Enhancement Act of 1997 105-s-1331 Aviation safety
105-s-1331,Commerce Aviation Competition Enhancement Act of 1997 105-s-1331 Commerce
105-s-1331,Competition Aviation Competition Enhancement Act of 1997 105-s-1331 Competition
105-s-1331,Competitive bidding Aviation Competition Enhancement Act of 1997 105-s-1331 Competitive bidding
105-s-1331,Congress Aviation Competition Enhancement Act of 1997 105-s-1331 Congress
105-s-1331,Congressional reporting requirements Aviation Competition Enhancement Act of 1997 105-s-1331 Congressional reporting requirements
105-s-1331,Department of Transportation Aviation Competition Enhancement Act of 1997 105-s-1331 Department of Transportation
105-s-1331,Economics and Public Finance Aviation Competition Enhancement Act of 1997 105-s-1331 Economics and Public Finance
105-s-1331,Environmental Protection Aviation Competition Enhancement Act of 1997 105-s-1331 Environmental Protection
105-s-1331,Government Operations and Politics Aviation Competition Enhancement Act of 1997 105-s-1331 Government Operations and Politics
105-s-1331,Government trust funds Aviation Competition Enhancement Act of 1997 105-s-1331 Government trust funds

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