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

10 rows where bill_id = "112-s-3239"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
112-s-3239,Agricultural practices and innovations Egg Products Inspection Act Amendments of 2012 112-s-3239 Agricultural practices and innovations
112-s-3239,Agricultural trade Egg Products Inspection Act Amendments of 2012 112-s-3239 Agricultural trade
112-s-3239,Air quality Egg Products Inspection Act Amendments of 2012 112-s-3239 Air quality
112-s-3239,Animal protection and human-animal relationships Egg Products Inspection Act Amendments of 2012 112-s-3239 Animal protection and human-animal relationships
112-s-3239,Birds Egg Products Inspection Act Amendments of 2012 112-s-3239 Birds
112-s-3239,California Egg Products Inspection Act Amendments of 2012 112-s-3239 California
112-s-3239,Federal preemption Egg Products Inspection Act Amendments of 2012 112-s-3239 Federal preemption
112-s-3239,Food supply, safety, and labeling Egg Products Inspection Act Amendments of 2012 112-s-3239 Food supply, safety, and labeling
112-s-3239,Livestock Egg Products Inspection Act Amendments of 2012 112-s-3239 Livestock
112-s-3239,Trade restrictions Egg Products Inspection Act Amendments of 2012 112-s-3239 Trade restrictions

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