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

11 rows where bill_id = "111-s-3473"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-s-3473,Accidents A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Accidents
111-s-3473,Budget process A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Budget process
111-s-3473,Coast guard A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Coast guard
111-s-3473,Congressional oversight A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Congressional oversight
111-s-3473,Government trust funds A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Government trust funds
111-s-3473,Gulf of Mexico A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Gulf of Mexico
111-s-3473,Marine and coastal resources, fisheries A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Marine and coastal resources, fisheries
111-s-3473,Marine pollution A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Marine pollution
111-s-3473,Oil and gas A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Oil and gas
111-s-3473,Pollution liability A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Pollution liability
111-s-3473,Water quality A bill to amend the Oil Pollution Act of 1990 to authorize advances from Oil Spill Liability Trust Fund for the Deepwater Horizon oil spill. 111-s-3473 Water quality

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