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

1 row where bill_id = "103-s-2188"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-2188,Claims A bill for the relief of the Pottawatomi Nation in Canada for the proportionate share of tribal funds and annuities under treaties between the Pottawatomi Nation and the United States, and for other purposes. 103-s-2188 Claims

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 4.526ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API