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

9 rows where bill_id = "101-sres-252"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
101-sres-252,Airline passenger traffic A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Airline passenger traffic
101-sres-252,Airlines A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Airlines
101-sres-252,Aviation agreements A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Aviation agreements
101-sres-252,Emigration A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Emigration
101-sres-252,Israel A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Israel
101-sres-252,Most favored nation principle A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Most favored nation principle
101-sres-252,Trade agreements A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Trade agreements
101-sres-252,Trade negotiations A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 Trade negotiations
101-sres-252,U.S.S.R. A resolution to express the sense of the Senate regarding refusal by the Soviet Union to implement the commercial airline agreement between El Al and Aeroflot. 101-sres-252 U.S.S.R.

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