State of Texas Open Data Portal

Close
Author
TCEQ Information Resources Division
Description
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.
Tags
investigations, violations, program support & environmental assistance division, oce, office of compliance and enforcement
Rating
Current value: 0 out of 5
Data Provided By
Office of Compliance & Enforcement
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Regulated Entity Number
rn_number
Regulated Entity Name
rn_name
Business Type
business
Physical Location
phys_loc
Physical City
phys_city
Physical State
phys_state
Physical Zip Code
phys_zip
County
county
Investigation Number
investigation_no
Investigation Approved Date
invest_approved_dt
NOV Date
violation_status_date
Coordinates (County Centroid)
coordinates_centroid_poly
TCEQ Region
region
Notice of Violation ID
violation_id
Cat. A Violation Tracking Numbers
a_viol_track_num
Cat. A Violation Citations
a_viol_citations
Cat. B Violation Tracking Numbers
b_viol_track_num
Cat. B Violation Citations
b_viol_citations
Cat. C Violation Tracking Numbers
c_viol_track_num
Cat. C Violation Citations
c_viol_citations
Total Violation Count
viol_cnt
Texas Senate Districts Plan S172 (Effective Jan 2013)
:@computed_region_5xir_5pdr
Texas State House Districts Plan H414 (Effective Jan 2021)
:@computed_region_45pq_umjc
Texas U.S. Congressional Districts Plan C2193 (Effective Jan 18, 2022)
:@computed_region_ji3u_dqif
Texas Counties Cartographic Boundary Map
:@computed_region_59h5_km5p

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.