openregs: legislation_subjects: 8 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

8 rows where bill_id = "113-s-2136"

descending

Link	bill_id	subject
113-s-2136,Canada	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Canada
113-s-2136,Energy prices	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Energy prices
113-s-2136,Energy storage, supplies, demand	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Energy storage, supplies, demand
113-s-2136,Motor fuels	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Motor fuels
113-s-2136,Oil and gas	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Oil and gas
113-s-2136,Pipelines	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Pipelines
113-s-2136,Presidents and presidential powers, Vice Presidents	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Presidents and presidential powers, Vice Presidents
113-s-2136,Trade restrictions	A bill to ensure that oil transported through the Keystone XL pipeline into the United States is used to reduce United States dependence on Middle Eastern oil. 113-s-2136	Trade restrictions

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