Preview: RRC Oil / ICE Inspections (Every Inspection)

First 100 rows

Out of roughly 4M rows in texas.inspections. Version obs-fedf6f5937dc.

First 100 rows of `texas.inspections`, 16 columns wide
`id`	`operator_name`	`p5_operator_no`	`district`	`district_office_inspecting`	`oil_lease_gas_well_id`	`lease_fac_name`	`api_no`	`county`	`well_no`	`inspection_date`	`drilling_permit_no`	`complaint_no`	`compliance`	`field_name`	`ingested_at`
4215407	WILLIAMS, W. R., INC.	925821	10	Pampa	07118	PATRICK "B"	06531990	CARSON	1	Oct. 27, 2016	null	null	Yes	PANHANDLE CARSON COUNTY FIELD	Aug. 21, 2026, 7:42 p.m.
4215408	ROBERTS & HAMMACK INC.	718512	05	Kilgore	02604	LEWIS, C. L.	28930564	LEON	2	Oct. 27, 2016	null	null	Yes	RED OAK (SUB-CLARKSVILLE)	Aug. 21, 2026, 7:42 p.m.
4215409	STRATCO OPERATING CO., INC.	825462	01	San Antonio	13209	JOHNSON	16333084	FRIO	1	Oct. 27, 2016	null	null	Yes	PEARSALL (AUSTIN CHALK)	Aug. 21, 2026, 7:42 p.m.
4215410	PEARL, BILL H. PRODUCTIONS, INC.	647284	04	Corpus Christi	088876	SHAFFER, K.L. NCT-1	35530261	NUECES	32	Nov. 1, 2016	null	null	Yes	LUBY(6050)	Aug. 21, 2026, 7:42 p.m.
4215411	AMERICO ENERGY RESOURCES, LLC	019752	08	Midland	08802	GUITAR TRUST ESTATE -C-	22702781	HOWARD	6W	Nov. 28, 2016	null	null	Yes	VAREL (SAN ANDRES)	Aug. 21, 2026, 7:42 p.m.
4215412	D. & L. OIL PRODUCING CO.	196475	01	San Antonio	08043	D&L OIL PRODUCERS CO.	18733095	GUADALUPE	2	Jan. 23, 2017	null	null	Yes	LA VERNIA	Aug. 21, 2026, 7:42 p.m.
4215413	OXY USA INC.	630591	04	Corpus Christi	109726	SULLIVAN, D. J. "F"	04731314	BROOKS	21 F	Jan. 19, 2017	null	null	Yes	MARIPOSA (C11-N6 CONS. GAS)	Aug. 21, 2026, 7:42 p.m.
4215414	LEGACY RESERVES OPERATING LP	495445	7C	San Angelo	09749	UNIVERSITY -M-	10502362	CROCKETT	7	Feb. 3, 2017	null	null	No	FARMER (SAN ANDRES)	Aug. 21, 2026, 7:42 p.m.
4215415	ANADARKO E&P ONSHORE LLC	020528	01	San Antonio	272162	BRISCOE CATARINA RANCH	12735341	DIMMIT	91H	Feb. 9, 2017	null	null	Yes	BRISCOE RANCH (EAGLEFORD)	Aug. 21, 2026, 7:42 p.m.
4215416	DENNIS & DAVIS OIL CO.	215650	09	Wichita Falls	25549	HOWARD HEIRS	33732766	MONTAGUE	8	March 2, 2017	null	null	No	MONTAGUE COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215417	APACHE CORPORATION	027200	08	Midland	020306	CAMPBELL, SETH	49505524	WINKLER	19 M	Feb. 27, 2017	null	null	Yes	KERMIT (FUSSELMAN)	Aug. 21, 2026, 7:42 p.m.
4215418	TREADSTONE ENERGY PRTNR OP, LLC	866905	03	Houston	23633	BUNDICK-WELLS UNIT	33133507	MILAM	1	Feb. 28, 2017	null	null	Yes	GIDDINGS (AUSTIN CHALK-3)	Aug. 21, 2026, 7:42 p.m.
4215419	BLACK MAC OIL, INC.	072693	01	San Antonio	12302	ADKINS	32533477	MEDINA	50	March 14, 2017	null	null	Yes	TAYLOR-INA	Aug. 21, 2026, 7:42 p.m.
4215420	M. E. OPERATING & SERVICES, INC.	518265	06	Kilgore	158446	NOLAN	36532391	PANOLA	1	March 31, 2017	null	null	Yes	CARTHAGE, SE (CV)	Aug. 21, 2026, 7:42 p.m.
4215421	CITATION OIL & GAS CORP.	154235	7B	Abilene	09713	FLOWERS /CANYON SAND/ UNIT	43333509	STONEWALL	309W	April 24, 2017	null	null	Yes	FLOWERS (CANYON SAND)	Aug. 21, 2026, 7:42 p.m.
4215422	SABINE OIL & GAS CORPORATION	742143	06	Kilgore	221129	TAYLOR, T. J.	20333363	HARRISON	4	May 10, 2017	null	null	Yes	WOODLAWN (COTTON VALLEY)	Aug. 21, 2026, 7:42 p.m.
4215423	SOJOURNER DRILLING CORPORATION	800750	7B	Abilene	31100	FISHER COUNTY DISPOSAL	15130966	FISHER	1 W	June 8, 2017	null	null	Yes	HUNSAKER (STRAWN)	Aug. 21, 2026, 7:42 p.m.
4215424	L.C.S. PRODUCTION COMPANY	479574	7B	Abilene	25134	MCMILLAN, I. S. AC. 7	43301940	STONEWALL	1D	June 20, 2017	null	null	Yes	GUEST (CANYON SAND)	Aug. 21, 2026, 7:42 p.m.
4215425	OCCIDENTAL PERMIAN LTD.	617544	8A	Midland	18910	DENVER UNIT	50134646	YOAKUM	2661	June 29, 2017	null	null	Yes	WASSON	Aug. 21, 2026, 7:42 p.m.
4215426	BLOCK "T" PETROLEUM, INC.	075784	03	Houston	24608	GLADYS CITY #1 UNIT	24532352	JEFFERSON	1	June 27, 2017	null	null	Yes	SPINDLETOP	Aug. 21, 2026, 7:42 p.m.
4215427	WALSH & WATTS, INC.	895060	8A	Midland	09743	FULLER "B"	26300202	KENT	2	July 11, 2017	null	null	Yes	BOOMERANG (PENNSYLVANIAN REEF)	Aug. 21, 2026, 7:42 p.m.
4215428	CONOCOPHILLIPS COMPANY	172232	01	San Antonio	02082	CHITTIM, N. J.	32333180	MAVERICK	6729PR	July 13, 2017	null	null	Yes	SACATOSA (SAN MIGUEL #1 SAND)	Aug. 21, 2026, 7:42 p.m.
4215429	URBAN OIL & GAS GROUP, LLC	879035	04	Corpus Christi	096062	JONES, EVA M. MRS.	35531639	NUECES	2	July 21, 2017	null	null	Yes	STRATTON (CONSOLIDATED)	Aug. 21, 2026, 7:42 p.m.
4215430	GULFTEX ENERGY IV, LP	338747	01	San Antonio	18170	STONE-SCHUBLE	01335139	ATASCOSA	2H	Aug. 14, 2017	null	null	Yes	EAGLEVILLE (EAGLE FORD-1)	Aug. 21, 2026, 7:42 p.m.
4215431	SCOUT ENERGY MANAGEMENT LLC	760218	10	Pampa	163070	THOMPSON	34132492	MOORE	A 10	Feb. 25, 2025	null	null	Yes	PANHANDLE, WEST	Aug. 21, 2026, 7:42 p.m.
4215432	COG OPERATING LLC	166150	7C	San Angelo	17275	NEAL RANCH "47"	46137084	UPTON	5	March 21, 2025	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215433	INEOS USA OIL & GAS LLC	424176	01	San Antonio	15614	THURMAN NORTH LAS	28332638	LA SALLE	A 1H	Feb. 20, 2025	null	null	Yes	EAGLEVILLE (EAGLE FORD-1)	Aug. 21, 2026, 7:42 p.m.
4215434	BREITBURN OPERATING L.P.	090732	6E	Kilgore	07617	SMITH, S. G.	18385960	GREGG	2	Feb. 7, 2018	null	null	Yes	EAST TEXAS	Aug. 21, 2026, 7:42 p.m.
4215435	OCCIDENTAL PERMIAN LTD.	617544	08	Midland	20164	NORTH COWDEN UNIT	13535735	ECTOR	1367	Feb. 28, 2018	null	null	Yes	COWDEN, NORTH	Aug. 21, 2026, 7:42 p.m.
4215436	XTO ENERGY INC.	945936	05	Kilgore	270129	C & W GAS UNIT NO. 1	29331649	LIMESTONE	3	Feb. 22, 2018	null	null	Yes	FARRAR (TRAVIS PEAK)	Aug. 21, 2026, 7:42 p.m.
4215437	GUIDANCE OIL DEVELOPERS	337317	09	Wichita Falls	00571	RICHARDSON, J. T. "ABC"	00981552	ARCHER	2	Feb. 16, 2018	null	null	Yes	ARCHER COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215438	GUIDANCE OIL DEVELOPERS	337317	09	Wichita Falls	00571	RICHARDSON, J. T. "ABC"	00942455	ARCHER	27 A	Feb. 16, 2018	null	null	Yes	ARCHER COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215439	XTO ENERGY INC.	945936	08	Midland	17503	MEANS /SAN ANDRES/ UNIT	00335352	ANDREWS	758	March 12, 2018	null	null	Yes	MEANS	Aug. 21, 2026, 7:42 p.m.
4215440	XTO ENERGY INC.	945936	08	Midland	17503	MEANS /SAN ANDRES/ UNIT	00302473	ANDREWS	808W	March 12, 2018	null	null	Yes	MEANS	Aug. 21, 2026, 7:42 p.m.
4215441	WAKO OIL CO. LLC	891732	09	Wichita Falls	12478	HOLT SAND UNIT	33733511	MONTAGUE	S 16	March 21, 2018	null	null	Yes	MONTAGUE COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215442	SABINE OIL & GAS CORPORATION	742143	06	Kilgore	203278	CAIN, PAULA	20332906	HARRISON	5	April 16, 2018	null	null	Yes	OAK HILL (COTTON VALLEY)	Aug. 21, 2026, 7:42 p.m.
4215443	QUATRO OIL AND GAS, INC.	684588	04	Corpus Christi	12323	ERCK, FRED	24900838	JIM WELLS	8	April 9, 2018	null	null	Yes	CAPTAIN LUCEY (4400)	Aug. 21, 2026, 7:42 p.m.
4215444	PRIMROSE RESOURCES, LLC	678365	03	Houston	02505	DOTY-JACKSON -A-	19900126	HARDIN	3	April 25, 2018	null	null	Yes	JACKSON-DOTY (YEGUA -T- SD.)	Aug. 21, 2026, 7:42 p.m.
4215445	W.T. WAGGONER ESTATE, INC.	887904	09	Wichita Falls	28110	FEE "FLOOD 4 UNIT"	48589108	WICHITA	4242	April 27, 2018	null	null	Yes	WICHITA COUNTY (SPECIAL)	Aug. 21, 2026, 7:42 p.m.
4215446	BLACKBEARD OPERATING, LLC	073056	08	Midland	03218	WALTON, J. B.	49503078	WINKLER	181	April 25, 2018	null	null	Yes	KERMIT	Aug. 21, 2026, 7:42 p.m.
4215447	BASA RESOURCES, INC.	053974	6E	Kilgore	08311	PRICE, J. M.	40185463	RUSK	8	May 10, 2018	null	null	Yes	EAST TEXAS	Aug. 21, 2026, 7:42 p.m.
4215448	MILLENNIUM RESOURCES, LP	567484	08	Midland	28723	HOMAN, EUNICE	22733196	HOWARD	7	May 25, 2018	null	null	Yes	MOORE	Aug. 21, 2026, 7:42 p.m.
4215449	HILCORP ENERGY COMPANY	386310	04	Corpus Christi	123750	VELA, SERAPIO HEIRS "A"	50532279	ZAPATA	20	Oct. 10, 2025	null	null	Yes	ROLETA (WILCOX CONSOLIDATED)	Aug. 21, 2026, 7:42 p.m.
4215450	ROBERT C. BROWER, LLC	100445	7C	San Angelo	140330	SAWYER 146	43533842	SUTTON	6	Oct. 13, 2025	null	null	Yes	SAWYER (CANYON)	Aug. 21, 2026, 7:42 p.m.
4215451	SABINAL ENERGY OPERATING, LLC	742122	8A	Lubbock	03828	COBLE, W. T. "A" NCT-1	21934163	HOCKLEY	46	Oct. 30, 2025	null	null	Yes	LEVELLAND	Aug. 21, 2026, 7:42 p.m.
4215452	PIONEER NATURAL RES. USA, INC.	665748	08	Midland	55605	HAYDEN 14-23-B	31743167	MARTIN	2803VH	Sept. 15, 2025	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215453	UPP OPERATING, LLC	875310	09	Kilgore	216313	ANDRUS/SHELLENBERGER UNIT	25130533	JOHNSON	1H	Oct. 16, 2025	null	null	Yes	NEWARK, EAST (BARNETT SHALE)	Aug. 21, 2026, 7:42 p.m.
4215454	UPP OPERATING, LLC	875310	7C	San Angelo	247454	JONES RANCH 157	43539095	SUTTON	1	Nov. 18, 2025	null	null	Yes	SAWYER (CANYON)	Aug. 21, 2026, 7:42 p.m.
4215455	BASA RESOURCES, INC.	053974	6E	Kilgore	06698	REDWINE -A-	40181379	RUSK	1	Nov. 14, 2025	null	null	Yes	EAST TEXAS	Aug. 21, 2026, 7:42 p.m.
4215456	UNBRIDLED RESOURCES, LLC	875461	10	Pampa	258610	CHILDREN'S HOME 2	48332921	WHEELER	1D	Oct. 14, 2025	null	null	Yes	FRYE RANCH (CONSOLIDATED)	Aug. 21, 2026, 7:42 p.m.
4215457	CAZAR ENERGY INC	140612	7C	San Angelo	15757	DIERSCHKE	09532102	CONCHO	2	Oct. 20, 2025	null	null	Yes	MILLERSVIEW, W. (CROSS CUT SD)	Aug. 21, 2026, 7:42 p.m.
4215458	BLUE RIDGE OPERATING LLC	100436	03	Houston	00463	CLOVER LEAF	15732892	FORT BEND	89	Sept. 23, 2025	null	null	Yes	BLUE RIDGE	Aug. 21, 2026, 7:42 p.m.
4215459	PDEH LLC	646827	08	Midland	44515	P C HILL STATE B 1-12	47536435	WARD	4H	Sept. 23, 2025	null	null	Yes	PHANTOM (WOLFCAMP)	Aug. 21, 2026, 7:42 p.m.
4215460	D10 ENERGY LLC	237972	10	Pampa	06012	BIVINS	37531229	POTTER	1013P	March 2, 2026	null	null	Yes	PANHANDLE POTTER COUNTY FIELD	Aug. 21, 2026, 7:42 p.m.
4215461	OCCIDENTAL PERMIAN LTD.	617544	8A	Lubbock	60000	WASSON ODC UNIT	50132582	YOAKUM	588	Feb. 25, 2026	null	null	Yes	WASSON	Aug. 21, 2026, 7:42 p.m.
4215462	PEGASI OPERATING INC.	650623	06	Kilgore	097480	DAVIS	06730349	CASS	1	Feb. 25, 2026	null	null	No	KILDARE (COTTON VALLEY)	Aug. 21, 2026, 7:42 p.m.
4215463	PROGAS OPERATING, INC	681142	04	Corpus Christi	14008	WENDLING	24932606	JIM WELLS	3	Jan. 29, 2026	null	null	Yes	PREMONT (BARDO SAND)	Aug. 21, 2026, 7:42 p.m.
4215464	JSK OILFIELD SERVICE LLC	101942	7B	Abilene	10055	COLLINS, C. W.	08331321	COLEMAN	16	Feb. 4, 2026	null	null	Yes	COLEMAN COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215465	SCOUT ENERGY MANAGEMENT LLC	760218	08	Midland	16702	DENMAN -A--JONES	22736148	HOWARD	9A	Dec. 17, 2025	null	null	Yes	IATAN, EAST HOWARD	Aug. 21, 2026, 7:42 p.m.
4215466	TESUQUE OIL & GAS LLC	844127	01	San Antonio	17663	PETROFORCE-CARMONA	33134743	MILAM	3	Dec. 18, 2025	null	null	No	MINERVA-ROCKDALE	Aug. 21, 2026, 7:42 p.m.
4215467	BAYLOR OPERATING, LLC	058832	08	Midland	20450	MCKENNEY, T. L. -D-	33530868	MITCHELL	12	Jan. 30, 2026	null	null	Yes	IATAN, EAST HOWARD	Aug. 21, 2026, 7:42 p.m.
4215468	LEWIS PETRO PROPERTIES, INC.	499978	04	Corpus Christi	139722	GARNER, J.N.	47935237	WEBB	9	July 6, 2020	null	null	Yes	TOM WALSH (OLMOS)	Aug. 21, 2026, 7:42 p.m.
4215469	WHITING OIL AND GAS CORPORATION	920478	04	Corpus Christi	13461	DOLLARHIDE	35533297	NUECES	1	July 13, 2020	null	null	Yes	AGUA DULCE (CONSOLIDATED FRIO)	Aug. 21, 2026, 7:42 p.m.
4215470	TREK RESOURCES, INC.	867578	03	Houston	01758	RUCKER-SCHILLING	20107916	HARRIS	5	July 9, 2020	null	null	Yes	GOOSE CREEK	Aug. 21, 2026, 7:42 p.m.
4215471	ROCKCLIFF ENERGY OPERATING LLC	722890	06	Kilgore	228177	LANCASTER GU 1	20333779	HARRISON	1	July 6, 2020	null	null	Yes	WASKOM (COTTON VALLEY)	Aug. 21, 2026, 7:42 p.m.
4215472	JUST OIL & GAS, INC.	448220	09	Wichita Falls	07638	CARPENTER, J. D.	50340742	YOUNG	A 21	Aug. 3, 2020	null	null	No	YOUNG COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215473	BUREAU OF LAND MANAGEMENT	107850	10	Pampa	07411	BIVINS 22	37531640	POTTER	1	Aug. 20, 2020	null	null	Yes	WILDCAT	Aug. 21, 2026, 7:42 p.m.
4215474	LAREDO PETROLEUM, INC.	486610	08	Midland	43849	LANE TR C 42-43 (ALLOC-A)	17335184	GLASSCOCK	1SU	Aug. 13, 2020	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215475	XOG OPERATING LLC	945921	7C	San Angelo	00903	RICKER, R. P. -B-	46104253	UPTON	26	Sept. 1, 2020	null	null	Yes	MCCAMEY	Aug. 21, 2026, 7:42 p.m.
4215476	WEATHERLY OIL & GAS, LLC	902815	06	Kilgore	166422	CHILDRESS	45930915	UPSHUR	1	Aug. 31, 2020	null	null	No	CEDAR SPRINGS (COT. VALLEY, LO.)	Aug. 21, 2026, 7:42 p.m.
4215477	EOG RESOURCES, INC.	253162	08	Midland	45036	PARMER '3-317'	16537786	GAINES	1	Nov. 6, 2020	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215478	LEGACY RESERVES OPERATING LP	495445	7C	San Angelo	16452	UNIV5 HATTIE4	46135425	UPTON	5	June 13, 2018	null	null	Yes	SHEEP MOUNTAIN (CONSOLIDATED)	Aug. 21, 2026, 7:42 p.m.
4215479	POLARIS PRODUCTION CORP.	669000	7C	San Angelo	00400	TIPPS - UNIVERSITY	10501583	CROCKETT	6	June 8, 2018	null	null	Yes	CROCKETT	Aug. 21, 2026, 7:42 p.m.
4215480	MURPHY EXPL. & PROD. CO. - USA	594675	01	San Antonio	15725	JAMBERS	31134569	MCMULLEN	2H	June 15, 2018	null	null	Yes	EAGLEVILLE (EAGLE FORD-1)	Aug. 21, 2026, 7:42 p.m.
4215481	POWELL, GENE INVESTMENTS, INC.	674342	06	Kilgore	149714	JEFFREY	18300091	GREGG	2	June 21, 2018	null	null	No	WILLOW SPRINGS (PETTIT)	Aug. 21, 2026, 7:42 p.m.
4215482	OS&S OPERATING INC.	627119	09	Wichita Falls	05012	WAGGONER, W. T., ESTATE -A-	48530636	WICHITA	21	June 26, 2018	null	null	No	WICHITA COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215483	EAGLERIDGE OPERATING, LLC	238462	09	Abilene	253215	COMANCHE TRAILS	22131766	HOOD	4H	July 17, 2018	null	null	Yes	NEWARK, EAST (BARNETT SHALE)	Aug. 21, 2026, 7:42 p.m.
4215484	SUMMIT PETROLEUM LLC	829221	7C	San Angelo	15569	ELIZABETH	46136462	UPTON	1209	July 16, 2018	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215485	MIKEN OIL, INC.	566783	6E	Kilgore	08390	MOORE, W. P., EST.	40185660	RUSK	16	July 16, 2018	null	null	Yes	EAST TEXAS	Aug. 21, 2026, 7:42 p.m.
4215486	CCI EAST TEXAS UPSTREAM LLC	120023	06	Kilgore	179840	CGU 11	36534274	PANOLA	13	July 16, 2018	null	null	Yes	CARTHAGE (COTTON VALLEY)	Aug. 21, 2026, 7:42 p.m.
4215487	PEBA OIL & GAS, INC.	648640	09	Wichita Falls	04230	KECK, L. -A-	33733340	MONTAGUE	52	Aug. 10, 2018	null	null	Yes	MONTAGUE COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215488	FOREE OIL COMPANY	275700	09	Wichita Falls	19233	KYLE, T.	19730485	HARDEMAN	3	Aug. 7, 2018	null	null	Yes	KYLE & TAPP(MISSISSIPPIAN)	Aug. 21, 2026, 7:42 p.m.
4215489	BASA RESOURCES, INC.	053974	06	Kilgore	02865	MCKENZIE, J. F.	06330281	CAMP	4	Aug. 15, 2018	null	null	Yes	PITTSBURG (SUB-CLARKSVILLE)	Aug. 21, 2026, 7:42 p.m.
4215490	PHOENIX PETROCORP, INC.	664138	09	Wichita Falls	28956	CLARK UNIT	50307459	YOUNG	401	Aug. 28, 2018	null	null	No	YOUNG COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215491	APACHE CORPORATION	027200	8A	Abilene	61806	COBB, TOM "B" R/A "B"	21936662	HOCKLEY	26	Aug. 23, 2018	null	null	Yes	YELLOWHOUSE	Aug. 21, 2026, 7:42 p.m.
4215492	DECKER OPERATING CO., L.L.C.	209347	04	Corpus Christi	175211	CHAPMAN RANCH	35532923	NUECES	874	Aug. 22, 2018	null	null	Yes	CHAPMAN RANCH (MIOCENE CONS.)	Aug. 21, 2026, 7:42 p.m.
4215493	EOG RESOURCES, INC.	253162	09	Wichita Falls	268388	WEBB C UNIT	09734461	COOKE	1H	Sept. 5, 2018	null	null	Yes	NEWARK, EAST (BARNETT SHALE)	Aug. 21, 2026, 7:42 p.m.
4215494	BRIDGEPORT TANK TRUCKS, L.L.C.	091137	09	Kilgore	30824	HANNA	25130815	JOHNSON	1	Sept. 20, 2018	null	null	Yes	NEWARK, EAST (BARNETT SHALE)	Aug. 21, 2026, 7:42 p.m.
4215495	DEVON ENERGY PRODUCTION CO, L.P.	216378	08	Midland	08857	LEA, P. J., ETAL	10332318	CRANE	110	Oct. 9, 2018	null	null	Yes	LEA (TUBB)	Aug. 21, 2026, 7:42 p.m.
4215496	APACHE CORPORATION	027200	7C	San Angelo	16968	SRH NORTH	38336796	REAGAN	1611	Oct. 4, 2018	null	null	Yes	SPRABERRY (TREND AREA)	Aug. 21, 2026, 7:42 p.m.
4215497	REED PRODUCTION, INC.	697666	09	Wichita Falls	23588	MONROE, I. N.	33732127	MONTAGUE	1	Oct. 16, 2018	null	1925	No	MONTAGUE COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215498	REMORA OPERATING, LLC	701613	04	Corpus Christi	242068	WELDER HEIRS 71	13139098	DUVAL	3	Oct. 25, 2018	null	null	Yes	SEVEN SISTERS, S. (WILCOX, LO.)	Aug. 21, 2026, 7:42 p.m.
4215499	FRESNO OIL COMPANY	286110	09	Wichita Falls	05112	RAMMING, L. F.	48581590	WICHITA	53	Nov. 7, 2018	null	null	Yes	WICHITA COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215500	SHILYNN, INC.	777346	7B	Abilene	18578	BROYLES, J. N.	13337672	EASTLAND	8	Nov. 8, 2018	null	null	No	MADEWELL (CROSS CUT)	Aug. 21, 2026, 7:42 p.m.
4215501	L.C.S. PRODUCTION COMPANY	479574	7B	Abilene	30653	CRICKET (STRAWN) UNIT	20732335	HASKELL	10	Feb. 20, 2026	null	null	Yes	CRICKET (STRAWN)	Aug. 21, 2026, 7:42 p.m.
4215502	D90 ENERGY, LLC	195797	04	Corpus Christi	175218	WILLIAM E. BEANE GU	21532569	HIDALGO	2	Dec. 15, 2025	null	null	No	EDINBURG, S. (JAYSIMS)	Aug. 21, 2026, 7:42 p.m.
4215503	BRIDWELL OIL CO.	092480	09	Wichita Falls	32391	BRIDWELL	48545458	WICHITA	8	Jan. 14, 2026	null	null	No	WICHITA COUNTY REGULAR	Aug. 21, 2026, 7:42 p.m.
4215504	HILCORP ENERGY COMPANY	386310	05	Kilgore	183893	ROLKE-CALDWELL	39530628	ROBERTSON	1	Dec. 19, 2025	null	null	Yes	BALD PRAIRIE (CV CONSOLIDATED)	Aug. 21, 2026, 7:42 p.m.
4215505	HILCORP ENERGY COMPANY	386310	8A	Lubbock	05955	COONS, W. A.	21936766	HOCKLEY	66	May 13, 2026	null	null	Yes	SLAUGHTER	Aug. 21, 2026, 7:42 p.m.
4215506	HILCORP ENERGY COMPANY	386310	02	San Antonio	04003	LAMBERT, M. F.	39101219	REFUGIO	U 10	April 29, 2026	null	null	Yes	GRETA (3500)	Aug. 21, 2026, 7:42 p.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.

`id`

int8

Sampled: 50K
Distinct: 50K

3984833 1
4030629 1
3994759 1
4020046 1
3987976 1
4017893 1
3997302 1
3994761 1
3995773 1
4025347 1
4007121 1
3993374 1

`p5_operator_no`

text

Sampled: 50K
Distinct: 282

008555 7.4K
008716 5.1K
013365 3.5K
003312 2.2K
003599 1.6K
003978 1.4K
003577 1.4K
003125 1.3K
010450 1.1K
016944 937
002987 770
008731 596

`district`

text

Sampled: 50K
Distinct: 1

01 50K

`oil_lease_gas_well_id`

text

Sampled: 50K
Distinct: 682

00304 3.5K
00000 2.9K
00365 871
- 777
00106 775
00194 771
00261 578
00142 565
00252 528
00372 516
00123 508
00219 453

`api_no`

text

Sampled: 50K
Distinct: 8.7K

00131263 48
00100882 41
00132074 39
00132303 38
00100046 37
00100680 37
00132213 36
00332980 36
00101023 35
00100681 35
00132246 34
00131195 34

`drilling_permit_no`

text

Sampled: 50K
Distinct: 21.2K

843584 37
886470 37
833387 36
793217 32
770100 32
785154 32
705697 32
682078 30
730239 28
804824 26
772425 26
804912 25

`complaint_no`

int8

Sampled: 50K
Distinct: 364
Empty: 0.9913

4010 4
3471 4
5688 4
898 4
3240 4
375 3
3716 3
1823 3
3029 3
2152 3
1254 3
802 3

`operator_name`

text

Sampled: 50K
Distinct: 4.8K
Empty: 0.0002

XTO ENERGY INC. 1.7K
OCCIDENTAL PERMIAN LTD. 1.4K
HILCORP ENERGY COMPANY 981
BASA RESOURCES, INC. 970
PIONEER NATURAL RES. USA, INC. 927
APACHE CORPORATION 803
SCOUT ENERGY MANAGEMENT LLC 803
EOG RESOURCES, INC. 566
DIAMONDBACK E&P LLC 538
OXY USA WTP LP 439
UPP OPERATING, LLC 396
SABINAL ENERGY OPERATING, LLC 379

Take it away

Back to everything we know about RRC Oil / ICE Inspections (Every Inspection)