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

7 rows where bill_id = "111-hconres-280"

descending

Link	bill_id	subject
111-hconres-280,Accidents	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Accidents
111-hconres-280,Gulf of Mexico	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Gulf of Mexico
111-hconres-280,Marine and coastal resources, fisheries	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Marine and coastal resources, fisheries
111-hconres-280,Marine pollution	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Marine pollution
111-hconres-280,Oil and gas	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Oil and gas
111-hconres-280,Pollution liability	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Pollution liability
111-hconres-280,Water quality	Expressing the sense of Congress that BP p.l.c. should reimburse all costs incurred by the Federal Government in assisting with cleanup efforts in the Deepwater Horizon oil spill incident in the Gulf of Mexico. 111-hconres-280	Water quality

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