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 = "106-hconres-252"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-hconres-252,Canada Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Canada
106-hconres-252,Commerce Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Commerce
106-hconres-252,Free trade Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Free trade
106-hconres-252,Import quotas Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Import quotas
106-hconres-252,International Affairs Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 International Affairs
106-hconres-252,Lumber trade Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Lumber trade
106-hconres-252,Public Lands and Natural Resources Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Public Lands and Natural Resources
106-hconres-252,Trade agreements Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Trade agreements
106-hconres-252,Trade negotiations Expressing the sense of the Congress regarding ensuring a competitive North American market for softwood lumber. 106-hconres-252 Trade negotiations

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