Texas Commission on Environmental Quality - Notices Of Violation (NOV)

Approved regional investigations resulting in a Notice of Violation (NOV) and the details associated with each violation that are documented in the Consolidated Compliance and Enforcement Data System (CCEDS). All NOVs displayed were sent as physical letters to the Regulated Entities' business contacts. An NOV may contain multiple violation citations (Category A, B, and C) due to identified noncompliance with different regulatory requirements. Note other databases are utilized within the agency and may contain information on additional violations.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"texas-gov/texas-commission-on-environmental-quality-notices-mwzi-gyw7\".\"texas_commission_on_environmental_quality_notices\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.