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

9 rows where bill_id = "115-s-643"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-s-643,Broadcasting, cable, digital technologies Sunshine in the Courtroom Act of 2017 115-s-643 Broadcasting, cable, digital technologies
115-s-643,Evidence and witnesses Sunshine in the Courtroom Act of 2017 115-s-643 Evidence and witnesses
115-s-643,Federal appellate courts Sunshine in the Courtroom Act of 2017 115-s-643 Federal appellate courts
115-s-643,Federal district courts Sunshine in the Courtroom Act of 2017 115-s-643 Federal district courts
115-s-643,Judicial procedure and administration Sunshine in the Courtroom Act of 2017 115-s-643 Judicial procedure and administration
115-s-643,Photography and imaging Sunshine in the Courtroom Act of 2017 115-s-643 Photography and imaging
115-s-643,Sound recording Sunshine in the Courtroom Act of 2017 115-s-643 Sound recording
115-s-643,Supreme Court Sunshine in the Courtroom Act of 2017 115-s-643 Supreme Court
115-s-643,Television and film Sunshine in the Courtroom Act of 2017 115-s-643 Television and film

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