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 = "110-sres-700"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-sres-700,Athletes A resolution congratulating Michael Phelps and the members and coaches of the United States Olympic Swimming Team for their record-breaking performance at the 2008 Summer Olympic Games in Beijing, China. 110-sres-700 Athletes
110-sres-700,Congressional tributes A resolution congratulating Michael Phelps and the members and coaches of the United States Olympic Swimming Team for their record-breaking performance at the 2008 Summer Olympic Games in Beijing, China. 110-sres-700 Congressional tributes
110-sres-700,Olympic games A resolution congratulating Michael Phelps and the members and coaches of the United States Olympic Swimming Team for their record-breaking performance at the 2008 Summer Olympic Games in Beijing, China. 110-sres-700 Olympic games
110-sres-700,Sports and Recreation A resolution congratulating Michael Phelps and the members and coaches of the United States Olympic Swimming Team for their record-breaking performance at the 2008 Summer Olympic Games in Beijing, China. 110-sres-700 Sports and Recreation
110-sres-700,Swimming A resolution congratulating Michael Phelps and the members and coaches of the United States Olympic Swimming Team for their record-breaking performance at the 2008 Summer Olympic Games in Beijing, China. 110-sres-700 Swimming

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