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

5 rows where bill_id = "100-sconres-103"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-sconres-103,Afghanistan A concurrent resolution expressing the sense of the Congress that the President should award the Presidential Medal of Freedom to Charles E. Thornton, Lee Shapiro, and Jim Lindelof, citizens of the United States who were killed in Afghanistan. 100-sconres-103 Afghanistan
100-sconres-103,Americans in foreign countries A concurrent resolution expressing the sense of the Congress that the President should award the Presidential Medal of Freedom to Charles E. Thornton, Lee Shapiro, and Jim Lindelof, citizens of the United States who were killed in Afghanistan. 100-sconres-103 Americans in foreign countries
100-sconres-103,Awards, medals, prizes A concurrent resolution expressing the sense of the Congress that the President should award the Presidential Medal of Freedom to Charles E. Thornton, Lee Shapiro, and Jim Lindelof, citizens of the United States who were killed in Afghanistan. 100-sconres-103 Awards, medals, prizes
100-sconres-103,Commemorations A concurrent resolution expressing the sense of the Congress that the President should award the Presidential Medal of Freedom to Charles E. Thornton, Lee Shapiro, and Jim Lindelof, citizens of the United States who were killed in Afghanistan. 100-sconres-103 Commemorations
100-sconres-103,Foreign correspondents A concurrent resolution expressing the sense of the Congress that the President should award the Presidential Medal of Freedom to Charles E. Thornton, Lee Shapiro, and Jim Lindelof, citizens of the United States who were killed in Afghanistan. 100-sconres-103 Foreign correspondents

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