openregs: legislation_subjects: 8 rows where bill

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 = "105-s-2646"

descending

Link	bill_id	subject
105-s-2646,Armed Forces and National Security	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Armed Forces and National Security
105-s-2646,Disabled	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Disabled
105-s-2646,Disabled veterans	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Disabled veterans
105-s-2646,District of Columbia	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	District of Columbia
105-s-2646,Foundations	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Foundations
105-s-2646,Monuments and memorials	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Monuments and memorials
105-s-2646,Public Lands and Natural Resources	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Public Lands and Natural Resources
105-s-2646,Social Welfare	A bill to authorize the Disabled Veterans' LIFE Memorial Foundation to establish a memorial in the District of Columbia or its environs, and for other purposes. 105-s-2646	Social Welfare

Advanced export

JSON shape: default, array, newline-delimited, object

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