openregs: legislation_subjects: 5 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

5 rows where bill_id = "114-sres-150"

descending

Link	bill_id	subject
114-sres-150,Constitution and constitutional amendments	A resolution expressing the sense of the Senate about the importance of effective civic and government education programs in schools in the United States. 114-sres-150	Constitution and constitutional amendments
114-sres-150,Elementary and secondary education	A resolution expressing the sense of the Senate about the importance of effective civic and government education programs in schools in the United States. 114-sres-150	Elementary and secondary education
114-sres-150,Public participation and lobbying	A resolution expressing the sense of the Senate about the importance of effective civic and government education programs in schools in the United States. 114-sres-150	Public participation and lobbying
114-sres-150,Teaching, teachers, curricula	A resolution expressing the sense of the Senate about the importance of effective civic and government education programs in schools in the United States. 114-sres-150	Teaching, teachers, curricula
114-sres-150,U.S. history	A resolution expressing the sense of the Senate about the importance of effective civic and government education programs in schools in the United States. 114-sres-150	U.S. history

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