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

6 rows where bill_id = "114-s-2339"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
114-s-2339,Administrative law and regulatory procedures A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Administrative law and regulatory procedures
114-s-2339,Coal A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Coal
114-s-2339,Congressional oversight A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Congressional oversight
114-s-2339,Energy revenues and royalties A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Energy revenues and royalties
114-s-2339,Mining A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Mining
114-s-2339,Trade restrictions A bill to amend the Mineral Leasing Act to increase the royalty rate for coal produced from surface mines on Federal land, to prohibit the export of coal produced on Federal land, and for other purposes. 114-s-2339 Trade restrictions

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