Preview RRC Oil / ICE Violations

First 100 rows

Out of roughly 397.7K rows in texas.inspections_violations. Version obs-7cf2de09391e.

First 100 rows of `texas.inspections_violations`, 18 columns wide
`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`
Unknown	null	09	unknown	Dowdy -C-	null	CLAY	F	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20221214	20220927	Sept. 14, 2026, 1:16 a.m.
V S OIL COMPANY	881120	09	30601	FARMOUT, WARREN	48543800	WICHITA	2	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20171213	20171212	Sept. 14, 2026, 1:16 a.m.
Unidentified	876876	01	00000	BTW	05500000	CALDWELL	A1	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20240815	20210114	Sept. 14, 2026, 1:16 a.m.
Unknown	null	02	Unknown	Ryals	null	REFUGIO	1U	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20180207	20171116	Sept. 14, 2026, 1:16 a.m.
VANCO OIL & GAS CORP.	881484	7B	148276	MCLAUGHLIN, J. M.	35331330	NOLAN	1111	null	ADAIR CREEK (COOK SAND)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20240228	20240227	Sept. 14, 2026, 1:16 a.m.
UPLAND OPERATING, LLC	878942	01	00874	CLIFT, BEN W. "A"	18732154	GUADALUPE	2A	null	LA VERNIA	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Issued a Severance/Seal Order	20210309	20200803	Sept. 14, 2026, 1:16 a.m.
Unidentifeid	000000	09	00000	Dowdy Property	null	CLAY	U5	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20230221	20230216	Sept. 14, 2026, 1:16 a.m.
Unknown	Unknown	03	Unknown	Unknown	null	HARRIS	1	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20221005	20221003	Sept. 14, 2026, 1:16 a.m.
Unidentified	null	7B	N/A	Walker-Buckler Trust 367	null	SHACKELFORD	08-08	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20180809	20180808	Sept. 14, 2026, 1:16 a.m.
Unknown	Unknown	03	1011	Wildlife Refuge	N/A	LIBERTY	3	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20231011	20231010	Sept. 14, 2026, 1:16 a.m.
UPLAND OPERATING, LLC	878942	01	10477	MATTKE, ALBERT -A-	18733268	GUADALUPE	9B	null	LA VERNIA	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20221012	20220829	Sept. 14, 2026, 1:16 a.m.
UPP OPERATING, LLC	875310	7C	193602	JENKINS, F. J. "D"	13731646	EDWARDS	1306	null	SAWYER (CANYON)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20220124	20211029	Sept. 14, 2026, 1:16 a.m.
URBAN OIL & GAS GROUP, LLC	879035	04	152997	ELLIFF, J.S. ET AL	35532983	NUECES	44D	null	AGUA DULCE (CONSOLIDATED FRIO)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20190114	20180925	Sept. 14, 2026, 1:16 a.m.
BAR L PRODUCERS	049748	10	07031	BROWN "A"	17984506	GRAY	502	null	PANHANDLE GRAY COUNTY FIELD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20210604	20210513	Sept. 14, 2026, 1:16 a.m.
BASA RESOURCES, INC.	053974	6E	06114	HAYS	18380717	GREGG	86	null	EAST TEXAS	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20200304	20191023	Sept. 14, 2026, 1:16 a.m.
BASA RESOURCES, INC.	053974	05	01943	VAN,SW LEWISVILLE UNIT	46700981	VAN ZANDT	4207	null	VAN,S.W. (LEWISVILLE)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20220329	20220324	Sept. 14, 2026, 1:16 a.m.
BASIN OIL & GAS OPERATING, LLC	054430	08	47085	KEYSTONE HOLT UNIT	49503468	WINKLER	1303W	null	KEYSTONE (CONSOLIDATED)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20251211	20250520	Sept. 14, 2026, 1:16 a.m.
BASIC ENERGY SERVICES, L.P.	054313	08	30444	CRANE BRINE STATION	10311680	CRANE	2D	null	UNIVERSITY WADDELL (PENN.)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20180816	20180806	Sept. 14, 2026, 1:16 a.m.
BASA RESOURCES, INC.	053974	6E	06816	FISHBURN, S. C.	18302284	GREGG	10	null	EAST TEXAS	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20201014	20200727	Sept. 14, 2026, 1:16 a.m.
BASA RESOURCES, INC.	053974	8A	65871	E. RED MUD	12530299	DICKENS	1	null	MICHELLE KAY (CISCO)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250402	20250214	Sept. 14, 2026, 1:16 a.m.
BAYLOR OPERATING, LLC	058832	08	02900	LANE, ROWENA	22701837	HOWARD	5	null	IATAN, EAST HOWARD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20231212	20230403	Sept. 14, 2026, 1:16 a.m.
BAYLOR OPERATING, LLC	058832	08	02900	LANE, ROWENA	22701837	HOWARD	5	null	IATAN, EAST HOWARD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20241104	20240715	Sept. 14, 2026, 1:16 a.m.
BASTROP ENERGY GROUP	055118	01	08489	BLACKWELL, S.M. -B-	05502551	CALDWELL	4	null	LULING-BRANYON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250602	20250331	Sept. 14, 2026, 1:16 a.m.
BAYLOR OPERATING, LLC	058832	08	02906	JONES, PERCY	22734610	HOWARD	2 B	null	IATAN, EAST HOWARD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20241104	20240607	Sept. 14, 2026, 1:16 a.m.
BATTON OIL & GAS, LLC	056384	10	102781	RUPPRECHT, MAY	29580320	LIPSCOMB	1	null	FOLLETT, WEST (CHEROKEE)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20220808	20220804	Sept. 14, 2026, 1:16 a.m.
BAY ROCK CORP.	057850	01	null	BIENHORN, W.A. JR.	32331869	MAVERICK	2	136928	WILDCAT	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20190718	20190623	Sept. 14, 2026, 1:16 a.m.
BAYLOR OPERATING, LLC	058832	01	076702	TURNEY-WINN EXPLORATION CO., INC	32331206	MAVERICK	1	null	LOS CUATROS (LOWER CRETACEOUS)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20210112	20190521	Sept. 14, 2026, 1:16 a.m.
BCP RESOURCES, LLC	040206	08	12215	JOHNSON -E-	30100727	LOVING	1	null	GRICE (DELAWARE)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20251201	20251015	Sept. 14, 2026, 1:16 a.m.
BAYOU COMPANY, THE	058858	02	106040	RYALS, JOHN ESTATE -A-	39102212	REFUGIO	P 1	null	REFUGIO OLD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20151117	20150921	Sept. 14, 2026, 1:16 a.m.
BBHP OILFIELD SERVICES LLC	039996	6E	06705	SNODDY THAD	18382769	GREGG	3	null	EAST TEXAS	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250218	20250214	Sept. 14, 2026, 1:16 a.m.
BCE-MACH III LLC	040209	10	02953	EAST PAMPA UNIT	17984722	GRAY	504	null	PANHANDLE GRAY COUNTY FIELD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250722	20250721	Sept. 14, 2026, 1:16 a.m.
BEACH OIL & GAS, INC.	058921	02	178459	ELEANOR	46933423	VICTORIA	1	null	SALEM (3425)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20161003	20160811	Sept. 14, 2026, 1:16 a.m.
BEEHIVE OPERATING, LLC	061750	06	203000	ARCO NO. 2	41930884	SHELBY	6	null	STOCKMAN (COTTON VALLEY)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250102	20241231	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	04911	KEMPNER -R-	48534554	WICHITA	62	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20190528	20181206	Sept. 14, 2026, 1:16 a.m.
NAILS OPERATING COMPANY LLC	599249	01	04280	BAGGETT, JOHN B.	12730026	DIMMIT	1	null	BIG WELLS (SAN MIGUEL)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20220523	20220511	Sept. 14, 2026, 1:16 a.m.
NEWPORT OPERATING, LLC	607883	09	05286	PRESTON	48546207	WICHITA	185	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20250227	20250225	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	11551	CAMPBELL, R., EST. UNIT NO. 1	00940185	ARCHER	53	null	ARCHER COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Referred to State-Managed Plugging	20210811	20190619	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	11551	CAMPBELL, R., EST. UNIT NO. 1	00942247	ARCHER	4	null	ARCHER COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20210107	20210106	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	22394	JONES	07734367	CLAY	14	null	BANDERA (THOMAS)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20180711	20180413	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	04911	KEMPNER -R-	48580046	WICHITA	2	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20200504	20200422	Sept. 14, 2026, 1:16 a.m.
NHRG INC	598344	09	22084	WOLF, WILLIE	50331804	YOUNG	6	null	YOUNG COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20210106	20210104	Sept. 14, 2026, 1:16 a.m.
N & O OIL CO.	598397	08	28172	IRT "61"	37134220	PECOS	2	null	LEHN-APCO (1600)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20190826	20190703	Sept. 14, 2026, 1:16 a.m.
NORTEX ENERGY, INC.	613523	09	18586	MADDOX, J. W. #4	33732002	MONTAGUE	6	null	MONTAGUE COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20210630	20210511	Sept. 14, 2026, 1:16 a.m.
NORTH TEXAS PLUGGING, LLC	614284	09	108366	HENDERSON-BRIDWELL	23733457	JACK	1	null	JACK COUNTY REGULAR (GAS)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20241119	20241118	Sept. 14, 2026, 1:16 a.m.
NICHOLS TRUCKING, INC.	610398	09	16210	THOMAS, W. H., EST.	00930184	ARCHER	1	null	DOUG PERRYMAN (CADDO)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20191204	20190514	Sept. 14, 2026, 1:16 a.m.
NORDSTRAND ENGINEERING, INC.	612858	08	26851	NEWBY	33532966	MITCHELL	10	null	WESTBROOK, EAST (CLEAR FORK)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20221007	20221005	Sept. 14, 2026, 1:16 a.m.
NWG OPERATING LLC	616947	09	28966	JOHNSON	15530575	FOARD	1	null	NEW BOOTS (GUNSIGHT SAND, UP.)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20211213	20211209	Sept. 14, 2026, 1:16 a.m.
NORTH TEXAS ENERGY,INC.	614190	01	03125	MCGREGOR, A. F.	33131170	MILAM	6	null	MINERVA-ROCKDALE	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20211011	20170508	Sept. 14, 2026, 1:16 a.m.
NOKOTA ENERGY CORPORATION	100471	08	42465	WWJD	37138801	PECOS	4	null	WHITE & BAKER	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20240725	20240723	Sept. 14, 2026, 1:16 a.m.
NOKOTA ENERGY CORPORATION	100471	08	42465	WWJD	37139372	PECOS	16	null	WHITE & BAKER	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20240725	20240723	Sept. 14, 2026, 1:16 a.m.
NORTEX ENERGY, INC.	613523	09	11304	MADDOX, J. W. NO. 3	33733002	MONTAGUE	21	null	MONTAGUE COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Issued a Severance/Seal Order	20250611	20250320	Sept. 14, 2026, 1:16 a.m.
NORTEX ENERGY, INC.	613523	09	11304	MADDOX, J. W. NO. 3	33733685	MONTAGUE	26	null	MONTAGUE COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20230120	20220413	Sept. 14, 2026, 1:16 a.m.
NORTHERN TERRITORY OIL-TEX,INC.	614537	09	14061	BANK	07731319	CLAY	8 A	null	CLAY COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20170424	20160627	Sept. 14, 2026, 1:16 a.m.
ROYKO OIL COMPANY	732198	01	15109	HENRY	31134076	MCMULLEN	1	null	A.W.P. (OLMOS)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20211011	20210917	Sept. 14, 2026, 1:16 a.m.
ROYALTY RESOURCES, L.L.C.	732124	08	02931	FOSTER, W. L. -A-	22734249	HOWARD	4W	null	IATAN, NORTH	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20161115	20161111	Sept. 14, 2026, 1:16 a.m.
ROSE CITY RESOURCES, LLC	727892	06	15844	HARRIS	06730831	CASS	1	null	HIDDEN ROCK (COTTON VALLEY LIME)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20241018	20241016	Sept. 14, 2026, 1:16 a.m.
ROYAL TEXAN RESOURCES CO.	732111	01	04335	BRADY, T. H.	12700098	DIMMIT	1	null	PENA CREEK (SAN MIGUEL 3RD)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20160810	20160728	Sept. 14, 2026, 1:16 a.m.
RUBAC TECHNICAL SERVICES	732293	01	09310	RIDDLE, GEORGE -A-	33131869	MILAM	40	null	MINERVA-ROCKDALE	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20221014	20220823	Sept. 14, 2026, 1:16 a.m.
SAGA PETROLEUM LLC OF COLORADO	743213	08	19827	MARDERS, GORDON	47510726	WARD	101	null	SHIPLEY (GLORIETA)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20210607	20210507	Sept. 14, 2026, 1:16 a.m.
S N D ENERGY COMPANY, INC.	741084	05	01223	MARISA	46700142	VAN ZANDT	1B	null	VAN (SHALLOW)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20230816	20230811	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	05259	FOSTER & ALLEN	48532985	WICHITA	26	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20250716	20250715	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	13674	BOYD, PEARL, EST.	48590098	WICHITA	2	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20211007	20211004	Sept. 14, 2026, 1:16 a.m.
S N D ENERGY COMPANY, INC.	741084	05	02614	CRIM, BILL	46731099	VAN ZANDT	2	null	VAN (SHALLOW)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20210312	20190612	Sept. 14, 2026, 1:16 a.m.
SAGA PETROLEUM LLC OF COLORADO	743213	7C	19128	SHANNON, M. A. EST.	10535358	CROCKETT	4A	null	VAUGHN CONSOLIDATED	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20170601	20170330	Sept. 14, 2026, 1:16 a.m.
S & W OIL & GAS, LLC	741661	10	00677	HOOD	17983557	GRAY	3	null	PANHANDLE GRAY COUNTY FIELD	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20180130	20180126	Sept. 14, 2026, 1:16 a.m.
Rottenburg, Laura Oil Co.	723596	01	04493	Mohle, Paul	05530526	CALDWELL	2	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20221011	20211213	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	05654	ALLEN, R. S.	48532054	WICHITA	44	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20170802	20170711	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	05654	ALLEN, R. S.	48532352	WICHITA	53	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20170425	20170417	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	05654	ALLEN, R. S.	48585549	WICHITA	30	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20170508	20170428	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	05673	MARRIOTT, J. H.	48545981	WICHITA	50	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20241104	20241101	Sept. 14, 2026, 1:16 a.m.
RYHOLLAND FIELDER, INC	740120	7B	30502	SNYDER-SEALES	05936849	CALLAHAN	B 5	null	CALLAHAN COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20160727	20160411	Sept. 14, 2026, 1:16 a.m.
RWJ OPERATING LLC	739805	03	04825	DOOLEY	20102728	HARRIS	4	null	ALCO-MAG (7800)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Notice of Violation	20151207	20150804	Sept. 14, 2026, 1:16 a.m.
S&G OIL LLC	740270	09	28798	DICKINSON	48541242	WICHITA	5	null	TRICORE (GUNSIGHT)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Issued a Severance/Seal Order	20250620	20250311	Sept. 14, 2026, 1:16 a.m.
Unidentified	null	09	00000	Weinzapfel	null	COOKE	U1	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Notice of Violation	20171109	20170912	Sept. 14, 2026, 1:16 a.m.
UPP OPERATING, LLC	875310	7C	215956	CANYON RANCH	43537565	SUTTON	1131S	null	SAWYER (CANYON)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20241024	20241023	Sept. 14, 2026, 1:16 a.m.
US. FUELS, INC.	879264	7B	176072	STROEBEL	13337659	EASTLAND	1C	null	GROVER HART (MISS. REEF)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Notice of Violation	20190607	20190425	Sept. 14, 2026, 1:16 a.m.
Unidentified	00000	09	00000	O'DONOHOE PROPERTY	null	ARCHER	U1	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20210127	20210126	Sept. 14, 2026, 1:16 a.m.
V S OIL COMPANY	881120	09	04988	WAGGONER -E-	48580482	WICHITA	5	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Referred to Austin Field Ops for possible legal enforcement	20160426	20151208	Sept. 14, 2026, 1:16 a.m.
Unidentified	876876	7B	0-7B	Stasney Property	null	SHACKELFORD	3-24	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20260330	20260324	Sept. 14, 2026, 1:16 a.m.
Unidentified	000000	09	00000	WINES PROPERTY	null	ARCHER	U2	null	null	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20210507	20210506	Sept. 14, 2026, 1:16 a.m.
VIEJO SERVICES, LLC	885566	09	07562	MCCLUSKEY	50336007	YOUNG	21	null	YOUNG COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20240503	20240426	Sept. 14, 2026, 1:16 a.m.
VAQUERO OPERATING	882776	08	01487	EMMONS	37106787	PECOS	1	null	FORT STOCKTON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20190227	20190211	Sept. 14, 2026, 1:16 a.m.
VANCO OIL & GAS CORP.	881484	7C	02052	SHANNON, J. M. EST. -B-	10535166	CROCKETT	13	null	VAUGHN	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20210719	20210716	Sept. 14, 2026, 1:16 a.m.
VANCO OIL & GAS CORP.	881484	8A	61667	BUTLER	27930049	LAMB	3	null	ANTON-IRISH	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20191030	20191025	Sept. 14, 2026, 1:16 a.m.
VAQUERO OPERATING	882776	08	23841	KRAMER, LILLY ANNA	37104527	PECOS	1D	null	T. C. I. (YATES)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20241203	20241125	Sept. 14, 2026, 1:16 a.m.
VAQUERO OPERATING	882776	08	32590	UNIVERSITY "A"	47533972	WARD	1	null	CAVEAT EMPTOR (CHERRY CANYON)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20180119	20171116	Sept. 14, 2026, 1:16 a.m.
VIEJO SERVICES, LLC	885566	09	18787	MCCLUSKEY -D-	50333937	YOUNG	6	null	YOUNG COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20231018	20231016	Sept. 14, 2026, 1:16 a.m.
VENETO EXPLORATION, LLC	884504	09	05155	MILLER, R. J.	48581873	WICHITA	9W	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20260721	20260706	Sept. 14, 2026, 1:16 a.m.
VINLAND TEXAS SERVICES LLC	886099	09	05656	BICKLEY, W. P. & J. F.	48537227	WICHITA	99	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20231128	20231127	Sept. 14, 2026, 1:16 a.m.
VERDISYS LLC	884568	01	null	GOODSON	46530880	VAL VERDE	4	863439	WILDCAT	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20240409	20240313	Sept. 14, 2026, 1:16 a.m.
VINLAND TEXAS SERVICES LLC	886099	09	05656	BICKLEY, W. P. & J. F.	48540485	WICHITA	123	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20231128	20231127	Sept. 14, 2026, 1:16 a.m.
VANCO OIL & GAS CORP.	881484	7C	19124	CBS SHANNON ESTATE	10511100	CROCKETT	9	null	VAUGHN CONSOLIDATED	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Notice of Violation	20210719	20210623	Sept. 14, 2026, 1:16 a.m.
VINLAND TEXAS SERVICES LLC	886099	09	05360	REILLY, H.	48540938	WICHITA	53L	null	WICHITA COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20211028	20200529	Sept. 14, 2026, 1:16 a.m.
W & W PRODUCTION, LLC	887867	09	14347	HENDERSON	23782779	JACK	1	null	JACK COUNTY REGULAR	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20210513	20210303	Sept. 14, 2026, 1:16 a.m.
BEEHIVE OPERATING, LLC	061750	7B	28008	WALKER - BUCKLER "A"	41738041	SHACKELFORD	3B	null	BS&T (MISS.)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	N	Notice of Violation	20260813	20260713	Sept. 14, 2026, 1:16 a.m.
BEACH OIL & GAS, INC.	058921	08	26020	OLIX -A-	37133138	PECOS	5	null	PAYTON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Referred to State-Managed Plugging	20230410	20230406	Sept. 14, 2026, 1:16 a.m.
BEACH OIL & GAS, INC.	058921	08	26020	OLIX -A-	37133210	PECOS	25	null	PAYTON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20211112	20210524	Sept. 14, 2026, 1:16 a.m.
BEACH OIL & GAS, INC.	058921	08	26415	SCHARFF, T. O. G.	37133458	PECOS	3	null	PAYTON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Referred to Austin Field Ops for possible legal enforcement	20211115	20201228	Sept. 14, 2026, 1:16 a.m.
BEACH OIL & GAS, INC.	058921	08	26473	OLIX -B-	37133335	PECOS	3	null	PAYTON	SWR 3.13(a)(6)(A)	Surface Control of Well	N	Y	Notice of Violation	20240807	20240802	Sept. 14, 2026, 1:16 a.m.
BENCHMARK TEXAS PETROLEUM, LLC.	064104	01	03964	WEBB OIL UNIT II	05534946	CALDWELL	2R	null	DRUMMOND (AUSTIN 1400)	SWR 3.13(a)(6)(A)	Surface Control of Well	N	--	Notice of Violation	20220809	20220712	Sept. 14, 2026, 1:16 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: 50K
Distinct: 1K

036587 2.1K
053974 1.6K
027200 1.5K
028617 1.4K
040810 1.4K
099955 849
033523 817
003312 659
058832 608
092594 549
090732 540
040209 495

`district`

varchar

Sampled: 50K
Distinct: 1

01 50K

`oil_lease_gas_well_id`

varchar

Sampled: 50K
Distinct: 16.4K
Empty: 0.011

00000 370
14495 328
03380 324
14850 154
03556 132
04911 121
22190 118
08119 111
03061 102
00261 101
07329 100
09310 94

`api_no`

varchar

Sampled: 50K
Distinct: 17K

05500000 225
03930121 53
00332980 36
05731514 34
00938779 34
02331490 32
04930881 31
07734368 29
00942609 28
00905241 27
05532943 26
00000000 26

`drilling_permit_no`

varchar

Sampled: 50K
Distinct: 444
Empty: 0.9885

877678 9
747885 6
811410 5
698365 4
764462 4
730239 4
701501 4
287245 4
863439 3
871647 3
772420 3
739455 3

`operator_name`

varchar

Sampled: 50K
Distinct: 4.7K
Empty: 0.0015

PETROSAURUS, INC. 572
MAVERICK ENERGY GROUP, INC. 370
BJG OPERATING COMPANY 303
SOUTH SAM OPERATING COMPANY, LLC 285
APV MCCAMEY LLC 261
LARGE OPERATING LLC 231
NHRG INC 228
Unidentified 205
RBE WICHITA, LLC 192
ATLAS OPERATING LLC 191
RENEAU OIL CO. 190
SOL OIL CO., L.C. 176

`lease_fac_name`

varchar

Sampled: 50K
Distinct: 15.3K
Empty: 0.0002

BIG FOOT OLMOS B SAND UNIT 321
MCCAMEY UNIT 311
BURNETT 191
MAYFIELD, BRYAN UNIT 132
O NEAL SAN ANDRES UNIT 115
KEMPNER -R- 114
PRIDEAUX, H. O. 113
PAMPA UNIT 103
MAUERMAN 100
RIDDLE, GEORGE -A- 93
JONES 84
THOMPSON 82

`county`

varchar

Sampled: 50K
Distinct: 229

WICHITA 3.4K
ARCHER 2.4K
PECOS 2.1K
CALDWELL 1.8K
YOUNG 1.3K
HUTCHINSON 1.1K
GREGG 993
JACK 920
SHACKELFORD 915
MILAM 875
CALLAHAN 851
GUADALUPE 745

Take it away

Back to everything we know about RRC Oil / ICE Violations