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

19 rows where bill_id = "100-s-2867"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-2867,Abortion, Birth Control, and Family Planning Global Warming Prevention Act of 1988 100-s-2867 Abortion, Birth Control, and Family Planning
100-s-2867,Administrative procedure Global Warming Prevention Act of 1988 100-s-2867 Administrative procedure
100-s-2867,Advisory bodies Global Warming Prevention Act of 1988 100-s-2867 Advisory bodies
100-s-2867,Aeronautics Global Warming Prevention Act of 1988 100-s-2867 Aeronautics
100-s-2867,Agricultural innovations Global Warming Prevention Act of 1988 100-s-2867 Agricultural innovations
100-s-2867,Agricultural research Global Warming Prevention Act of 1988 100-s-2867 Agricultural research
100-s-2867,Agriculture and Food Global Warming Prevention Act of 1988 100-s-2867 Agriculture and Food
100-s-2867,Agriculture and Rural Affairs Global Warming Prevention Act of 1988 100-s-2867 Agriculture and Rural Affairs
100-s-2867,Air conditioning Global Warming Prevention Act of 1988 100-s-2867 Air conditioning
100-s-2867,Air pollution control Global Warming Prevention Act of 1988 100-s-2867 Air pollution control
100-s-2867,Air quality Global Warming Prevention Act of 1988 100-s-2867 Air quality
100-s-2867,Aircraft Global Warming Prevention Act of 1988 100-s-2867 Aircraft
100-s-2867,Aircraft construction Global Warming Prevention Act of 1988 100-s-2867 Aircraft construction
100-s-2867,Alcohol as fuel Global Warming Prevention Act of 1988 100-s-2867 Alcohol as fuel
100-s-2867,Alternative energy sources Global Warming Prevention Act of 1988 100-s-2867 Alternative energy sources
100-s-2867,American economic assistance Global Warming Prevention Act of 1988 100-s-2867 American economic assistance
100-s-2867,Authorization Global Warming Prevention Act of 1988 100-s-2867 Authorization
100-s-2867,Automobile fuel consumption Global Warming Prevention Act of 1988 100-s-2867 Automobile fuel consumption
100-s-2867,Aviation Global Warming Prevention Act of 1988 100-s-2867 Aviation

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