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-127"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-sconres-127,Amateur radio stations A concurrent resolution expressing the sense of the Congress concerning support for Amateur Radio and Amateur Radio frequency allocations vital for Public Safety purposes. 100-sconres-127 Amateur radio stations
100-sconres-127,Communications and Broadcasting A concurrent resolution expressing the sense of the Congress concerning support for Amateur Radio and Amateur Radio frequency allocations vital for Public Safety purposes. 100-sconres-127 Communications and Broadcasting
100-sconres-127,Emergency communication systems A concurrent resolution expressing the sense of the Congress concerning support for Amateur Radio and Amateur Radio frequency allocations vital for Public Safety purposes. 100-sconres-127 Emergency communication systems
100-sconres-127,Radio broadcasting A concurrent resolution expressing the sense of the Congress concerning support for Amateur Radio and Amateur Radio frequency allocations vital for Public Safety purposes. 100-sconres-127 Radio broadcasting
100-sconres-127,Radio spectrum allocation A concurrent resolution expressing the sense of the Congress concerning support for Amateur Radio and Amateur Radio frequency allocations vital for Public Safety purposes. 100-sconres-127 Radio spectrum allocation

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