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

8 rows where bill_id = "94-s-3602"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
94-s-3602,Airlines A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Airlines
94-s-3602,Aviation A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Aviation
94-s-3602,Aviation insurance A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Aviation insurance
94-s-3602,Department of Transportation A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Department of Transportation
94-s-3602,Government Operations and Politics A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Government Operations and Politics
94-s-3602,Insurance A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Insurance
94-s-3602,Insurance law A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 Insurance law
94-s-3602,War risk insurance A bill to extend and expand the authority of the Secretary of Transportation to provide insurance and reinsurance to air carriers under title XIII of the Federal Aviation Act of 1958. 94-s-3602 War risk insurance

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