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

10 rows where bill_id = "105-sres-252"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-sres-252,Armed Forces and National Security A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Armed Forces and National Security
105-sres-252,Boundary disputes A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Boundary disputes
105-sres-252,Civil Rights and Liberties, Minority Issues A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Civil Rights and Liberties, Minority Issues
105-sres-252,Dispute settlement A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Dispute settlement
105-sres-252,Human rights A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Human rights
105-sres-252,India A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 India
105-sres-252,Pakistan A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Pakistan
105-sres-252,Peace A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 Peace
105-sres-252,South Asia A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 South Asia
105-sres-252,United Nations A resolution expressing the sense of the Senate regarding a resolution to the Kashmir dispute. 105-sres-252 United Nations

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