home / openregs

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

16 rows where bill_id = "97-s-2172"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2172,Broadcasting Cable Telecommunications Act of 1982 97-s-2172 Broadcasting
97-s-2172,Cable television Cable Telecommunications Act of 1982 97-s-2172 Cable television
97-s-2172,Civil Rights and Liberties Cable Telecommunications Act of 1982 97-s-2172 Civil Rights and Liberties
97-s-2172,Communications and Broadcasting Cable Telecommunications Act of 1982 97-s-2172 Communications and Broadcasting
97-s-2172,Foreign Trade and Investments Cable Telecommunications Act of 1982 97-s-2172 Foreign Trade and Investments
97-s-2172,Foreign investments Cable Telecommunications Act of 1982 97-s-2172 Foreign investments
97-s-2172,Local and Municipal Government Cable Telecommunications Act of 1982 97-s-2172 Local and Municipal Government
97-s-2172,Municipal ordinances Cable Telecommunications Act of 1982 97-s-2172 Municipal ordinances
97-s-2172,Professional sports Cable Telecommunications Act of 1982 97-s-2172 Professional sports
97-s-2172,Radio broadcasting Cable Telecommunications Act of 1982 97-s-2172 Radio broadcasting
97-s-2172,Right of privacy Cable Telecommunications Act of 1982 97-s-2172 Right of privacy
97-s-2172,Sports and Athletics Cable Telecommunications Act of 1982 97-s-2172 Sports and Athletics
97-s-2172,States Cable Telecommunications Act of 1982 97-s-2172 States
97-s-2172,Telecommunication policy Cable Telecommunications Act of 1982 97-s-2172 Telecommunication policy
97-s-2172,Television broadcasting Cable Telecommunications Act of 1982 97-s-2172 Television broadcasting
97-s-2172,Television broadcasting of sports Cable Telecommunications Act of 1982 97-s-2172 Television broadcasting of sports

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);
Powered by Datasette · Queries took 12.986ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API