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

12 rows where bill_id = "107-s-2497"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-s-2497,Air piracy A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Air piracy
107-s-2497,Aircraft pilots A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Aircraft pilots
107-s-2497,Airline passenger traffic A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Airline passenger traffic
107-s-2497,Aviation safety A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Aviation safety
107-s-2497,Commercial aircraft A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Commercial aircraft
107-s-2497,Crime and Law Enforcement A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Crime and Law Enforcement
107-s-2497,Electronic surveillance A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Electronic surveillance
107-s-2497,Flight crews A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Flight crews
107-s-2497,Labor and Employment A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Labor and Employment
107-s-2497,Science, Technology, Communications A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Science, Technology, Communications
107-s-2497,Security measures A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Security measures
107-s-2497,Video tape recording A bill to prohibit the opening of cockpit doors in flight. 107-s-2497 Video tape recording

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