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

6 rows where bill_id = "116-sres-710"

descending

Link	bill_id	subject
116-sres-710,Commemorative events and holidays	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Commemorative events and holidays
116-sres-710,Congressional tributes	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Congressional tributes
116-sres-710,Israel	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Israel
116-sres-710,Middle East	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Middle East
116-sres-710,Racial and ethnic relations	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Racial and ethnic relations
116-sres-710,Religion	A resolution commemorating the High Holidays celebrated and commemorated by the Jewish people in the United States, in Israel, and around the world, and recognizing the many accomplishments and contributions of the Jewish community in the United States. 116-sres-710	Religion

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