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). Other databases are utilized within the agency and may contain additional violations. An investigation may be listed more than once if there were multiple violations associated to that investigation. Multiple violations may be due to identified noncompliance with different regulatory requirements (citations).
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:

Customer Number
customer_num
Customer Name
customer
Regulated Entity Number
rn_number
Regulated Entity Name
reg_ent_name
Business Type
business
Mailing Address
mail_addr
Mailing City
mail_city
Mailing State
mail_state
Mailing Zip Code
zip_cd
Physical Location
phys_loc
Physical City
phys_city
Physical Zip Code
phys_zip
County
county
Latitude
lat_dec_coord_num
Longitude
long_dec_coord_num
Investigation Number
investigation_no
Notice of Violation Date
nov_dt
Media
media_name
Violation Category
violation_category
Rule Citation
rule_citation
Violation Track Number
track_num
Violation Status
violation_status
Violation Allegation
allegation_txt
Violation Resolution
violation_resolution_desc
Coordinates (Centroid_Poly)
coordinates_centroid_poly
Contact Name
business_contact_name
Contact Title
business_contact_title
Workplan Activity Code
activity_code
TCEQ Region
region
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.