openregs: legislation_subjects: 5 rows where bill

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 = "112-s-2226"

descending

Link	bill_id	subject
112-s-2226,Air quality	A bill to prohibit the Administrator of the Environmental Protection Agency from awarding any grant, contract, cooperative agreement, or other financial assistance under section 103 of the Clean Air Act for any program, project, or activity carried out outside the United States, including the territories and possessions of the United States. 112-s-2226	Air quality
112-s-2226,Environmental Protection Agency (EPA)	A bill to prohibit the Administrator of the Environmental Protection Agency from awarding any grant, contract, cooperative agreement, or other financial assistance under section 103 of the Clean Air Act for any program, project, or activity carried out outside the United States, including the territories and possessions of the United States. 112-s-2226	Environmental Protection Agency (EPA)
112-s-2226,Environmental assessment, monitoring, research	A bill to prohibit the Administrator of the Environmental Protection Agency from awarding any grant, contract, cooperative agreement, or other financial assistance under section 103 of the Clean Air Act for any program, project, or activity carried out outside the United States, including the territories and possessions of the United States. 112-s-2226	Environmental assessment, monitoring, research
112-s-2226,Public contracts and procurement	A bill to prohibit the Administrator of the Environmental Protection Agency from awarding any grant, contract, cooperative agreement, or other financial assistance under section 103 of the Clean Air Act for any program, project, or activity carried out outside the United States, including the territories and possessions of the United States. 112-s-2226	Public contracts and procurement
112-s-2226,Research and development	A bill to prohibit the Administrator of the Environmental Protection Agency from awarding any grant, contract, cooperative agreement, or other financial assistance under section 103 of the Clean Air Act for any program, project, or activity carried out outside the United States, including the territories and possessions of the United States. 112-s-2226	Research and development

Advanced export

JSON shape: default, array, newline-delimited, object

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