enforcement_actions

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

0 rows where cert_number = "57-H-0112" sorted by action_date descending

✎ View and edit SQL

This data as json

0 records

CREATE TABLE enforcement_actions (
    id TEXT PRIMARY KEY,
    cert_number TEXT REFERENCES facilities(cert_number),
    action_date TEXT,
    action_type TEXT,
    penalty_amount REAL,
    description TEXT,
    outcome TEXT,
    pdf_url TEXT,
    pdf_local_path TEXT
);
CREATE INDEX idx_enforcement_cert ON enforcement_actions(cert_number);
CREATE INDEX idx_enforcement_date ON enforcement_actions(action_date);