Preview: RRC Oil / ICE Inspections and Violations

First 22 rows

Out of roughly 22 rows in texas.inspections_violations. Version obs-f6bf6f0ef50e.

`operator_name`	`p5_operator_no`	`district`	`oil_lease_gas_well_id`	`lease_fac_name`	`api_no`	`county`	`well_no`	`drilling_permit_no`	`field_name`	`violated_rule`	`violated_rule_desc`	`major_viol_ind`	`compliant_on_reinsp`	`last_enf_action`	`last_enf_action_date`	`violation_disc_date`	`ingested_at`
Ted Thomas	null	8A	null	Illegal Pit	null	GARZA	null	null	null	SWR 21(j)	Dike or Fire Wall Requirements	N	Y	Notice of Violation	20160721	20160715	May 18, 2026, 1:15 a.m.
HAIR, ROGER D.	343108	8A	61516	SMITH, C. J.	null	SCURRY	null	null	VAREL (GLORIETA)	SWR 3(1)	Entrance Sign	N	Y	Notice of Violation	20230418	20230417	May 18, 2026, 1:15 a.m.
BRIDWELL OIL CO.	092480	8A	66530	SAGE DRAW UNIT	null	DICKENS	null	null	SAGE DRAW (MIDDLE TANNEHILL)	SWR 3(1)	Entrance Sign	N	Y	Notice of Violation	20190426	20190425	May 18, 2026, 1:15 a.m.
VANCO OIL & GAS CORP.	881484	8A	61667	BUTLER	null	LAMB	null	null	ANTON-IRISH	SWR 3(1)	Entrance Sign	N	Y	Notice of Violation	20200424	20191112	May 18, 2026, 1:15 a.m.
HAIR, ROGER D.	343108	8A	61516	SMITH, C. J.	null	SCURRY	null	null	VAREL (GLORIETA)	SWR 21(j)	Dike or Fire Wall Requirements	N	Y	Notice of Violation	20230612	20230417	May 18, 2026, 1:15 a.m.
OCCIDENTAL PERMIAN LTD.	617544	8A	00304	ANTON-IRISH CLEARFORK UNIT	18900165	HALE	65W	null	ANTON-IRISH	SWR 20(a)(1)	Notice of Fire, Leak, Spill	N	Y	Notice of Violation	20170320	20170316	May 18, 2026, 1:15 a.m.
OCCIDENTAL PERMIAN LTD.	617544	8A	19691	WEST RKM UNIT	null	HOCKLEY	null	null	SLAUGHTER	SWR 20(a)(1)	Notice of Fire, Leak, Spill	N	Y	Notice of Violation	20200904	20200901	May 18, 2026, 1:15 a.m.
PILOT WATER SOLUTIONS PERMIANLLC	665593	8A	69641	ERNEST SWD	41534558	SCURRY	1	null	EARNEST (6500 SAND)	SWR 20(a)(1)	Notice of Fire, Leak, Spill	N	Y	Notice of Violation	20221209	20221205	May 18, 2026, 1:15 a.m.
IRA TESTERS, LLC	101853	8A	67084	HOUSE, T. E. #1	null	SCURRY	null	null	SHARON RIDGE (CLEAR FORK)	SWR 21(i)	Rubbish or Debris Might Constitute a Fire Hazard	N	Y	Notice of Violation	20250825	20250822	May 18, 2026, 1:15 a.m.
XTO ENERGY INC.	945936	8A	18607	PRENTICE NORTHEAST UNIT	null	TERRY	null	null	PRENTICE (6700)	SWR 91(d)(1)	Remediation of Soil	N	N	Notice of Violation	20160112	20151211	May 18, 2026, 1:15 a.m.
XTO ENERGY INC.	945936	8A	61083	MAHONEY, H. O.	null	YOAKUM	null	null	WASSON 72	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20170830	20170828	May 18, 2026, 1:15 a.m.
XTO ENERGY INC.	945936	8A	61083	MAHONEY, H. O.	null	YOAKUM	null	null	WASSON 72	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20171005	20171003	May 18, 2026, 1:15 a.m.
WTP ENERGY, INC.	945233	8A	68670	RANDALS	41532829	SCURRY	5	null	REVILO (GLORIETA)	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20170124	20170123	May 18, 2026, 1:15 a.m.
WTP ENERGY, INC.	945233	8A	68976	"RANDALS ""E"""	41503634	SCURRY	3	null	REVILO (GLORIETA)	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20151210	20151029	May 18, 2026, 1:15 a.m.
Q NATURAL RESOURCES, LLC	684427	8A	16149	CREWS, CLARA	null	LYNN	null	null	GUINN (SAN ANDRES)	TNRC 91	False Filing	N	Y	Notice of Violation	20250617	20250605	May 18, 2026, 1:15 a.m.
GAEA SERVICES, INC.	292356	8A	68381	WALLACE	26331739	KENT	5	null	CLAIREMONT, NORTH (STRAWN SD.)	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20160513	20160512	May 18, 2026, 1:15 a.m.
ROBERTSON RESOURCES, INC.	718770	8A	63862	BECK, JIMMY	41532005	SCURRY	1	null	HERMLEIGH (6200)	SWR 91(d)(1)	Remediation of Soil	N	Y	Issued a Severance/Seal Order	20160707	20160614	May 18, 2026, 1:15 a.m.
ROBERTSON RESOURCES, INC.	718770	8A	09614	UNION TEXAS PETROLEUM ODC-FEE	null	GAINES	null	null	SEAGRAVES (SILURO-DEVONIAN)	SWR 91(d)(1)	Remediation of Soil	N	Y	Violation Corrected	20160712	20160517	May 18, 2026, 1:15 a.m.
CROSSROADS ENERGY PARTNERS, LLC	190668	8A	65311	"WRIGHT, D. S. ""C"""	07932103	COCHRAN	1D	null	LEVELLAND	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20150904	20150821	May 18, 2026, 1:15 a.m.
BROWN, GEO. R PARTNERSHIP,LP,THE	099955	8A	60611	POST-MONTGOMERY UNIT 1	null	GARZA	null	null	GARZA	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20170724	20170720	May 18, 2026, 1:15 a.m.
BUCHANAN, BILLY R.	105270	8A	65894	"CONRAD ""C"""	03300454	BORDEN	2	null	VON ROEDER (CLEAR FORK)	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20170706	20170606	May 18, 2026, 1:15 a.m.
UNITEX OIL & GAS, L.L.C.	877921	8A	61958	ELLIS-GRAY UNIT	null	SCURRY	null	null	SHARON RIDGE (1700)	SWR 91(d)(1)	Remediation of Soil	N	Y	Notice of Violation	20170516	20170515	May 18, 2026, 1:15 a.m.

What is in each column

Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.

`p5_operator_no`

varchar

Sampled: 22
Distinct: 15
Empty: 0.0455

945936 3
718770 2
343108 2
945233 2
617544 2
105270 1
101853 1
665593 1
292356 1
881484 1
684427 1
190668 1

`district`

varchar

Sampled: 22
Distinct: 1

8A 22

`api_no`

varchar

Sampled: 22
Distinct: 8
Empty: 0.6364

41532005 1
26331739 1
07932103 1
41534558 1
18900165 1
03300454 1
41532829 1
41503634 1

`drilling_permit_no`

varchar

Sampled: 22
Distinct: 0
Empty: 1.0

`operator_name`

varchar

Sampled: 22
Distinct: 16

XTO ENERGY INC. 3
ROBERTSON RESOURCES, INC. 2
WTP ENERGY, INC. 2
OCCIDENTAL PERMIAN LTD. 2
HAIR, ROGER D. 2
BRIDWELL OIL CO. 1
GAEA SERVICES, INC. 1
Ted Thomas 1
VANCO OIL & GAS CORP. 1
PILOT WATER SOLUTIONS PERMIANLLC 1
Q NATURAL RESOURCES, LLC 1
IRA TESTERS, LLC 1

`oil_lease_gas_well_id`

varchar

Sampled: 22
Distinct: 19
Empty: 0.0455

61083 2
61516 2
18607 1
65311 1
60611 1
67084 1
61667 1
66530 1
69641 1
09614 1
16149 1
19691 1

`lease_fac_name`

varchar

Sampled: 22
Distinct: 20

MAHONEY, H. O. 2
SMITH, C. J. 2
ANTON-IRISH CLEARFORK UNIT 1
WEST RKM UNIT 1
"RANDALS ""E""" 1
PRENTICE NORTHEAST UNIT 1
"CONRAD ""C""" 1
SAGE DRAW UNIT 1
BECK, JIMMY 1
"WRIGHT, D. S. ""C""" 1
UNION TEXAS PETROLEUM ODC-FEE 1
ERNEST SWD 1

`county`

varchar

Sampled: 22
Distinct: 13

SCURRY 8
GARZA 2
YOAKUM 2
LYNN 1
KENT 1
BORDEN 1
LAMB 1
TERRY 1
GAINES 1
COCHRAN 1
HOCKLEY 1
HALE 1

Take it away

Back to everything we know about RRC Oil / ICE Inspections and Violations