Preview Statewide API Data (dBase)

First 100 rows

Out of roughly 1.6M rows in texas.api_well_map. Version obs-5c046640d8e5.

First 100 rows of `texas.api_well_map`, 26 columns wide
`county_code`	`api_no`	`seq`	`api_county`	`api_unique`	`api_number`	`quad_num`	`survey`	`block`	`section`	`abstract`	`operator`	`total_depth`	`well_no`	`lease_name`	`permit_no`	`rrc_lease_id`	`oil_lease_no`	`gas_rrc_id`	`field_name`	`completion_date`	`plug_date`	`refer_to_api`	`on_off_schedule`	`oil_gas_code`	`file_date`
365	36532138	1	365	32138	42-365-32138	3294123	CATHERINE LINDSEY	null	null	386	TGNR EAST TEXAS LLC	9855	5 T	CGU 27	361024	132439	null	132439	CARTHAGE (COTTON VALLEY)	Oct. 20, 1989	null	null	N	G	Aug. 30, 2026
365	36532138	2	365	32138	42-365-32138	3294123	CATHERINE LINDSEY	null	null	386	TGNR EAST TEXAS LLC	9855	1 C	WRIGHT, J. T. -A- UNIT	361024	12647	12647	null	CARTHAGE (TRAVIS PEAK)	Nov. 29, 1989	null	null	N	O	Aug. 30, 2026
365	36532138	3	365	32138	42-365-32138	3294123	CATHERINE LINDSEY	null	null	386	TGNR EAST TEXAS LLC	9855	1 T	WRIGHT, J. T. -A- UNIT	361024	12647	12647	null	CARTHAGE (TRAVIS PEAK)	Nov. 29, 1989	null	null	Y	O	Aug. 30, 2026
365	36532138	4	365	32138	42-365-32138	3294123	CATHERINE LINDSEY	null	null	386	TGNR EAST TEXAS LLC	9855	2705 C	WRIGHT, J. T. -A- UNIT	361024	12647	12647	null	CARTHAGE (TRAVIS PEAK)	Nov. 29, 1989	null	null	N	O	Aug. 30, 2026
365	36532139	1	365	32139	42-365-32139	3294124	WM. D. THOMPSON	null	null	672	TGNR EAST TEXAS LLC	10500	4	CGU 33	361022	136142	null	136142	CARTHAGE (COTTON VALLEY)	June 8, 1990	null	null	N	G	Aug. 30, 2026
365	36532426	2	365	32426	42-365-32426	3294124	WHITE, S	null	null	743	DIVERSIFIED PRODUCTION LLC	6800	7	CHADWICK UNIT	708439	262058	null	262058	CARTHAGE (TRAVIS PEAK 6400)	April 1, 2011	null	null	N	G	Aug. 30, 2026
365	36532427	1	365	32427	42-365-32427	3294124	GEO. B. ROBERTS	null	null	565	PENNZOIL EXPLORATION & PROD. CO.	6850	7	MANGHAM UNIT	383358	137959	null	137959	CARTHAGE (TRAVIS PEAK 6400)	March 27, 1991	null	null	Y	G	Aug. 30, 2026
365	36532427	2	365	32427	42-365-32427	3294124	GEO. B. ROBERTS	null	null	565	PENNZENERGY EXP. & PROD., L.L.C.	6850	7	MANGHAM UNIT	408994	144256	null	144256	CARTHAGE (TRAVIS PEAK-COLLINS)	Jan. 27, 1993	null	null	Y	G	Aug. 30, 2026
365	36532427	3	365	32427	42-365-32427	3294124	GEO. B. ROBERTS	null	null	565	DIVERSIFIED PRODUCTION LLC	6850	7	MANGHAM UNIT	483879	173712	null	173712	CARTHAGE (PETTIT, LOWER GAS)	June 11, 1999	null	null	N	G	Aug. 30, 2026
365	36532428	1	365	32428	42-365-32428	3294121	MATTHEW ASHTON	null	null	8	DIVERSIFIED PRODUCTION LLC	9800	2	SOAPE, C.P.	383324	138768	null	138768	CARTHAGE (COTTON VALLEY)	May 16, 2006	null	null	N	G	Aug. 30, 2026
365	36532429	1	365	32429	42-365-32429	3294131	T. D. MATHEWS	null	null	458	VALENCE OPERATING COMPANY	10125	3	WILSON, HAROLD	383502	139009	null	139009	CARTHAGE (COTTON VALLEY)	July 2, 1991	null	null	N	G	Aug. 30, 2026
365	36532430	1	365	32430	42-365-32430	3294121	WYATT ANDERSON	null	null	4	TGNR EAST TEXAS LLC	9460	5-T	KYLE, FRED "A" UNIT	383580	139426	null	139426	CARTHAGE (COTTON VALLEY)	July 16, 1991	null	null	N	G	Aug. 30, 2026
365	36532430	2	365	32430	42-365-32430	3294121	WYATT ANDERSON	null	null	4	TGNR EAST TEXAS LLC	9460	5-C	KYLE, FRED UNIT "A"	393714	140357	null	140357	CARTHAGE (TRAVIS PEAK)	Feb. 15, 2013	null	null	N	G	Aug. 30, 2026
365	36532431	1	365	32431	42-365-32431	3294131	F. M. CAMPBELL	null	null	151	R. LACY SERVICES, LTD.	8200	8	BURNETT UNIT 10	383586	139166	null	139166	BRIGGS (7800 TRAVIS PEAK)	July 18, 1991	Jan. 8, 2025	null	Y	G	Aug. 30, 2026
365	36532432	1	365	32432	42-365-32432	3294121	MATTHEW ASTON	null	null	8	TGNR EAST TEXAS LLC	9445	5 T	HANCOCK, J.F. UNIT	383695	141447	null	141447	CARTHAGE (COTTON VALLEY)	April 29, 1992	null	null	N	G	Aug. 30, 2026
365	36532432	2	365	32432	42-365-32432	3294121	MATTHEW ASTON	null	null	8	TGNR EAST TEXAS LLC	9445	5-C	HANCOCK, J.F. UNIT	383695	142618	null	142618	CARTHAGE (TRAVIS PEAK-SMITH, S.)	May 12, 1992	null	null	N	G	Aug. 30, 2026
365	36532433	1	365	32433	42-365-32433	3294123	S. PARRISH	null	null	535	TGNR PANOLA LLC	9960	6	POWERS, E. C.	383966	137690	null	137690	CARTHAGE (COTTON VALLEY)	Dec. 19, 1990	null	null	N	G	Aug. 30, 2026
365	36532434	1	365	32434	42-365-32434	3294124	GEO. ROBERTS	null	null	565	PENNZOIL EXPLORATION & PROD. CO.	6900	6	YOUNGBLOOD-ROE UNIT	384299	138065	null	138065	CARTHAGE (TRAVIS PEAK HULL-GAS)	April 11, 1991	null	null	Y	G	Aug. 30, 2026
365	36532434	2	365	32434	42-365-32434	3294124	GEO. ROBERTS	null	null	565	PENNZOIL EXPLORATION & PROD. CO.	6900	6	YOUNGBLOOD-ROE UNIT	396465	140679	null	140679	CARTHAGE (TRAVIS PEAK-COLLINS)	Jan. 13, 1992	null	null	Y	G	Aug. 30, 2026
365	36532434	3	365	32434	42-365-32434	3294124	GEO. ROBERTS	null	null	565	DIVERSIFIED PRODUCTION LLC	6900	6	YOUNGBLOOD-ROE UNIT	476926	169887	null	169887	CARTHAGE (PETTIT, UPPER)	July 1, 1998	null	null	N	G	Aug. 30, 2026
365	36532435	1	365	32435	42-365-32435	3294124	WILLIAM SCANTLEBERRY	null	null	598	PENNZOIL EXPLORATION & PROD. CO.	6900	7	WHITAKER UNIT	384298	138205	null	138205	CARTHAGE (TRAVIS PEAK HULL-GAS)	April 19, 1991	null	null	Y	G	Aug. 30, 2026
365	36532435	2	365	32435	42-365-32435	3294124	WILLIAM SCANTLEBERRY	null	null	598	DIVERSIFIED PRODUCTION LLC	6900	7	WHITAKER UNIT	420091	148130	null	148130	CARTHAGE (TRAVIS PEAK-ALLISON)	Sept. 8, 1999	null	null	N	G	Aug. 30, 2026
365	36532436	1	365	32436	42-365-32436	3294141	ISOM HATCHER	null	null	304	TGNR PANOLA LLC	9700	2	ADAMS, T. C. G/U NO. 1 O/A	384321	144658	null	144658	BETHANY, EAST (COTTON VALLEY)	Feb. 16, 1993	null	null	N	G	Aug. 30, 2026
365	36532437	1	365	32437	42-365-32437	3294141	S. B. LACY	null	null	412	CHEVRON U. S. A. INC.	9570	43 D	ADAMS, T. C., NCT-1	384322	142615	null	142615	BETHANY, EAST (COTTON VALLEY)	Aug. 23, 1992	April 30, 2024	null	Y	G	Aug. 30, 2026
365	36532437	2	365	32437	42-365-32437	3294141	S. B. LACY	null	null	412	CHEVRON U. S. A. INC.	9570	43 F	ADAMS, T. C. NCT-1	510257	185215	null	185215	BETHANY (TRAVIS PEAK CONS.)	null	April 30, 2024	null	Y	G	Aug. 30, 2026
365	36532438	1	365	32438	42-365-32438	3294141	JOHN WOMACK	null	null	703	TGNR PANOLA LLC	9500	2	CRENSHAW GAS UNIT NO. 1	384527	143796	null	143796	BETHANY, EAST (COTTON VALLEY)	Nov. 6, 1992	null	null	N	G	Aug. 30, 2026
365	36532439	1	365	32439	42-365-32439	3294121	WYATT ANDERSON	null	null	4	TGNR EAST TEXAS LLC	9450	4-T	POSS, L.T. UNIT	384577	141001	null	141001	CARTHAGE (COTTON VALLEY)	May 1, 1992	null	null	N	G	Aug. 30, 2026
365	36532439	2	365	32439	42-365-32439	3294121	WYATT ANDERSON	null	null	4	UNION PACIFIC RESOURCES COMPANY	9450	4-C	L. T. POSS UNIT	384577	142249	null	142249	CARTHAGE (TRAVIS PEAK-POSS)	May 1, 1992	null	null	Y	G	Aug. 30, 2026
365	36532439	3	365	32439	42-365-32439	3294121	WYATT ANDERSON	null	null	4	TGNR EAST TEXAS LLC	9450	4-C	POSS, L.T. UNIT	409280	144488	null	144488	CARTHAGE (TRAVIS PEAK-SMITH, S.)	March 31, 2000	null	null	N	G	Aug. 30, 2026
365	36532440	1	365	32440	42-365-32440	3294132	W. M. MCFADDEN	null	null	443	COMSTOCK OIL & GAS, INC.	10120	2-T	FITE, J.B. GAS UNIT	384667	139167	null	139167	CARTHAGE (COTTON VALLEY)	July 8, 1991	June 25, 2011	null	Y	G	Aug. 30, 2026
365	36532440	2	365	32440	42-365-32440	3294132	W. M. MCFADDEN	null	null	443	COMSTOCK OIL & GAS, LP	10120	2 T	FITE, J.B. GAS UNIT	384667	177377	null	177377	CARTHAGE (COTTON VALLEY)	April 12, 2000	June 25, 2011	null	Y	G	Aug. 30, 2026
365	36532440	3	365	32440	42-365-32440	3294132	W. M. MCFADDEN	null	null	443	COMSTOCK OIL & GAS, INC.	10120	2 T	FITE, J. B.	384667	13450	13450	null	CARTHAGE (COTTON VALLEY-OIL)	null	June 25, 2011	null	Y	O	Aug. 30, 2026
365	36532440	4	365	32440	42-365-32440	3294132	W. M. MCFADDEN	null	null	443	COMSTOCK OIL & GAS, LP	10120	2-C	FITE, J.B. GAS UNIT	393506	139893	null	139893	BRIGGS (UPPER TRAVIS PEAK)	Oct. 17, 1991	June 25, 2011	null	Y	G	Aug. 30, 2026
365	36532441	1	365	32441	42-365-32441	3294142	BEN C. JORDAN	null	null	348	PENNZOIL EXPLORATION & PROD. CO.	8000	A 5	STEELE, CORRIE	384720	139293	null	139293	BETHANY (TRAVIS PEAK 6510)	Aug. 9, 1991	Oct. 17, 2018	null	Y	G	Aug. 30, 2026
365	36532441	2	365	32441	42-365-32441	3294142	BEN C. JORDAN	null	null	348	DEVON ENERGY PRODUCTION CO, L.P.	8000	A 5	STEELE, CORRIE	459370	163207	null	163207	BETHANY (TRAVIS PEAK 6100)	April 19, 1997	Oct. 17, 2018	null	Y	G	Aug. 30, 2026
365	36532745	1	365	32745	42-365-32745	3294121	GEORGE WEEDEN	null	null	704	DIVERSIFIED PRODUCTION LLC	9650	7	ROGERS, PAUL	406100	145561	null	145561	CARTHAGE (COTTON VALLEY)	April 7, 1993	null	null	N	G	Aug. 30, 2026
365	36532746	1	365	32746	42-365-32746	3294121	WEEDEN, G	null	null	704	CR2 ENERGY LLC	9650	6	ROGERS, PAUL	406099	145559	null	145559	CARTHAGE (COTTON VALLEY)	April 4, 1993	null	null	N	G	Aug. 30, 2026
365	36532746	2	365	32746	42-365-32746	3294121	WEEDEN, G	null	null	704	TANOS EXPLORATION II, LLC	9650	6	ROGERS, PAUL	843162	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36532747	1	365	32747	42-365-32747	3294131	W.N. RAMEY	null	null	835	SAMSON RESOURCES COMPANY	null	7	ROBERTS GAS UNIT	406212	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36532748	1	365	32748	42-365-32748	3294124	S.W. HIGGINS	null	null	798	SAMSON RESOURCES COMPANY	null	6	ROBERTS GAS UNIT	406213	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36532749	1	365	32749	42-365-32749	3294141	WM GILBERT	null	null	232	FINA OIL & CHEMICAL COMPANY	9670	7	MIDYETT-GULLEY	406193	147452	null	147452	MIDYETT (COTTON VALLEY UPPER)	Aug. 31, 1993	July 19, 2019	null	Y	G	Aug. 30, 2026
365	36532749	2	365	32749	42-365-32749	3294141	WM GILBERT	null	null	232	XTO ENERGY INC.	9670	7	GULLEY, M. E.	433679	13400	13400	null	BETHANY (WERNER)	March 5, 1995	July 19, 2019	null	Y	O	Aug. 30, 2026
365	36532750	1	365	32750	42-365-32750	3294121	MATTHEW ASHTON	null	null	8	XTO ENERGY INC.	9800	6	KYLE, FRED UNIT	406235	145225	null	145225	CARTHAGE (COTTON VALLEY)	Feb. 25, 1993	null	null	N	G	Aug. 30, 2026
365	36532751	1	365	32751	42-365-32751	3294123	JOSEPH A. SPENCER	null	null	589	VALENCE OPERATING COMPANY	10000	5	DANIELS GAS UNIT	406267	145281	null	145281	CARTHAGE (COTTON VALLEY)	Feb. 18, 1993	null	null	N	G	Aug. 30, 2026
365	36532752	1	365	32752	42-365-32752	3294123	JOSEPH A. SPENCER	null	null	589	VALENCE OPERATING COMPANY	10000	6	DANIELS GAS UNIT	406268	146007	null	146007	CARTHAGE (COTTON VALLEY)	May 13, 1993	null	null	N	G	Aug. 30, 2026
365	36532753	1	365	32753	42-365-32753	3294123	T. M. SCOTT	null	null	594	TGNR PANOLA LLC	10050	7	HARRISON, VERA UNIT	406247	145956	null	145956	CARTHAGE (COTTON VALLEY)	April 28, 1993	null	null	N	G	Aug. 30, 2026
365	36532754	1	365	32754	42-365-32754	3294123	W. MCFADDIN	null	null	443	TGNR PANOLA LLC	10000	7	BEALL-BARKSDALE	406246	145476	null	145476	CARTHAGE (COTTON VALLEY)	April 5, 1993	null	null	N	G	Aug. 30, 2026
365	36532755	1	365	32755	42-365-32755	3294121	MATTHEW PAYNE	null	null	526	TGNR EAST TEXAS LLC	9510	7	KYLE, FRED GAS UNIT	406292	144709	null	144709	CARTHAGE (COTTON VALLEY)	Jan. 27, 1993	null	null	N	G	Aug. 30, 2026
365	36532756	1	365	32756	42-365-32756	3294133	SARAH ENGLISH	null	null	189	CHISOS, LTD.	10300	7	RUDMAN	406301	145681	null	145681	OAK HILL (COTTON VALLEY)	May 12, 1993	null	null	N	G	Aug. 30, 2026
365	36532757	1	365	32757	42-365-32757	3294133	SARAH ENGLISH	null	null	189	CHISOS, LTD.	10300	10	RUDMAN	406302	145252	null	145252	OAK HILL (COTTON VALLEY)	April 1, 1993	null	null	N	G	Aug. 30, 2026
365	36532758	1	365	32758	42-365-32758	3294133	SARAH ENGLISH	null	null	189	CHISOS, LTD.	10300	9	RUDMAN	406303	145828	null	145828	OAK HILL (COTTON VALLEY)	May 29, 1993	null	null	N	G	Aug. 30, 2026
365	36532759	1	365	32759	42-365-32759	3294142	A.T. NICHOLSON	null	null	518	ROCKCLIFF ENERGY OPERATING LLC	9875	7	CHRISTIAN	405901	144394	null	144394	CARTHAGE (COTTON VALLEY)	Feb. 10, 1993	Dec. 1, 2022	null	Y	G	Aug. 30, 2026
365	36532760	1	365	32760	42-365-32760	3294133	F.C. BOOKER	null	null	148	CHISOS, LTD.	10300	2	FOSTER	406415	145474	null	145474	OAK HILL (COTTON VALLEY)	March 16, 1993	null	null	N	G	Aug. 30, 2026
365	36532761	1	365	32761	42-365-32761	3294112	THOMAS KELLY	null	null	372	GRACE PETROLEUM CORP.	null	3	CHADWICK GAS UNIT	406421	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36532762	1	365	32762	42-365-32762	3294121	ISABELLE HANKS	null	null	271	XTO ENERGY INC.	9770	6	DAVIS, A.L.	406565	145375	null	145375	CARTHAGE (COTTON VALLEY)	May 9, 2016	null	null	N	G	Aug. 30, 2026
365	36532763	1	365	32763	42-365-32763	3294131	F.G. TIMMIN	null	null	664	XTO ENERGY INC.	9990	4	BLACK, VERA	406560	144822	null	144822	BETHANY (COTTON VALLEY)	Sept. 20, 2013	null	null	N	G	Aug. 30, 2026
365	36532764	1	365	32764	42-365-32764	3294141	JANE THARP	null	null	665	TGNR EAST TEXAS II LLC	9860	3	TILLER	406559	144276	null	144276	BETHANY, EAST (COTTON VALLEY)	null	June 12, 2026	null	Y	G	Aug. 30, 2026
365	36532765	1	365	32765	42-365-32765	3294121	JOHN BOWLING	null	null	50	TGNR EAST TEXAS LLC	9519	6	WILLIAMS-WALL GAS UNIT	406620	144731	null	144731	CARTHAGE (COTTON VALLEY)	March 4, 1993	null	null	N	G	Aug. 30, 2026
365	36532766	1	365	32766	42-365-32766	3294123	A. MOORMAN	null	null	A-427	TGNR EAST TEXAS LLC	9775	6-T	CGU 4	406622	144586	null	144586	CARTHAGE (COTTON VALLEY)	Feb. 18, 1993	null	null	N	G	Aug. 30, 2026
365	36532766	2	365	32766	42-365-32766	3294123	A. MOORMAN	null	null	A-427	UNION PACIFIC RESOURCES COMPANY	9775	6-C	CGU 4	406622	145233	null	145233	CARTHAGE (CHADWICK 2)	April 1, 1993	null	null	Y	G	Aug. 30, 2026
365	36532766	3	365	32766	42-365-32766	3294123	A. MOORMAN	null	null	A-427	TGNR EAST TEXAS LLC	9775	406 C	PIRKLE, L.N. "A"	445175	13572	13572	null	CARTHAGE (TRAVIS PEAK-WOOLWORTH)	April 24, 1996	null	null	N	O	Aug. 30, 2026
365	36532767	1	365	32767	42-365-32767	3294122	U.J. LONGACRE	null	null	403	TGNR EAST TEXAS LLC	9820	7	CGU 8	406623	144584	null	144584	CARTHAGE (COTTON VALLEY)	Feb. 12, 1993	null	null	N	G	Aug. 30, 2026
365	36532768	1	365	32768	42-365-32768	3294123	J.A. WILLIAMS	null	null	717	TGNR EAST TEXAS LLC	10084	1-T	SHIVERS GAS UNIT	406621	144905	null	144905	BECKVILLE (COTTON VALLEY)	March 13, 1993	null	null	N	G	Aug. 30, 2026
365	36532768	2	365	32768	42-365-32768	3294123	J.A. WILLIAMS	null	null	717	TGNR EAST TEXAS LLC	10084	1 C	SHIVERS GAS UNIT	406621	214922	null	214922	CARTHAGE (PETTIT, LOWER)	null	null	null	N	G	Aug. 30, 2026
365	36532768	3	365	32768	42-365-32768	3294123	J.A. WILLIAMS	null	null	717	ANADARKO E&P COMPANY LP	10084	1 C	HOLLOWAY	406621	13150	13150	null	CARTHAGE (PETTIT, LOWER)	March 4, 1993	null	null	Y	O	Aug. 30, 2026
365	36532769	1	365	32769	42-365-32769	3294131	F. G. TIMMIN	null	null	664	SONAT EXPLORATION COMPANY -TYLER	10020	7	HOLCOMBE	406808	144819	null	144819	BETHANY (COTTON VALLEY)	March 2, 1993	July 6, 2015	null	Y	G	Aug. 30, 2026
365	36533036	2	365	33036	42-365-33036	3294121	LUCINDA SHIELDS	null	null	605	EXXON CORP.	9800	7-U	BROWN, J. C.	427234	154079	null	154079	CARTHAGE (TRAVIS PEAK)	Jan. 31, 1995	null	null	Y	G	Aug. 30, 2026
365	36533036	3	365	33036	42-365-33036	3294121	LUCINDA SHIELDS	null	null	605	XTO ENERGY INC.	9800	1 U	BROWN, J. C. OU 1	427234	300028	null	300028	CARTHAGE (TRAVIS PEAK)	Jan. 31, 1995	null	null	N	G	Aug. 30, 2026
365	36533036	4	365	33036	42-365-33036	3294121	LUCINDA SHIELDS	null	null	605	XTO ENERGY INC.	9800	1 U	BROWN, J. C. OU 1	427234	13451	13451	null	CARTHAGE (TRAVIS PEAK)	null	null	null	Y	O	Aug. 30, 2026
365	36533037	1	365	33037	42-365-33037	3294121	JAS. GREEN	null	null	255	TGNR EAST TEXAS LLC	9421	10	HOLMES, PRIESTLY UNIT	427273	155417	null	155417	CARTHAGE (COTTON VALLEY)	March 19, 1999	Feb. 5, 2026	null	Y	G	Aug. 30, 2026
365	36533038	1	365	33038	42-365-33038	null	null	null	null	null	null	null	null	null	null	000000	null	null	null	null	null	36533042	null	null	Aug. 30, 2026
365	36533039	1	365	33039	42-365-33039	3294122	M. A. ROMERO	null	null	1	PRINCESS THREE OPERATING, LLC	7000	1	MORRIS UNIT	427275	152980	null	152980	CARTHAGE (TRAVIS PEAK-REED)	Nov. 5, 1994	April 15, 2011	null	Y	G	Aug. 30, 2026
365	36533040	1	365	33040	42-365-33040	3294112	J.J. SOAPE	null	null	618	TGNR EAST TEXAS LLC	9420	9	NEAL, SALLIE J. UNIT	427274	154938	null	154938	CARTHAGE (COTTON VALLEY)	Feb. 4, 1995	null	null	N	G	Aug. 30, 2026
365	36533041	1	365	33041	42-365-33041	3294121	MATTHEW PAYNE	null	null	526	UNION PACIFIC RESOURCES COMPANY	null	10	J.F. HANCOCK UNIT	427325	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36533042	1	365	33042	42-365-33042	3294124	SAM'L DUNCAN	null	null	158	UNION PACIFIC RESOURCES COMPANY	9719	11	CGU 10	427272	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36533042	2	365	33042	42-365-33042	3294124	SAM'L DUNCAN	null	null	158	TGNR EAST TEXAS LLC	9719	11	CGU 10	427395	153270	null	153270	CARTHAGE (COTTON VALLEY)	Jan. 5, 1995	null	null	N	G	Aug. 30, 2026
365	36533043	1	365	33043	42-365-33043	3294121	WYATT ANDERSON	null	null	4	ANADARKO E&P ONSHORE LLC	9424	11	KYLE, FRED "A" UNIT	427437	155439	null	155439	CARTHAGE (COTTON VALLEY)	June 12, 1995	Nov. 6, 2015	null	Y	G	Aug. 30, 2026
365	36533044	1	365	33044	42-365-33044	3294121	JAS. GREEN	null	null	255	TGNR EAST TEXAS LLC	2250	8	KYLE, J.R.	427435	153450	null	153450	CARTHAGE (BLOSSOM)	Jan. 10, 1995	null	null	N	G	Aug. 30, 2026
365	36533045	1	365	33045	42-365-33045	3294113	MALLORY, J H	null	null	475	SHERIDAN PRODUCTION COMPANY, LLC	9750	12	CUMMINGS	427457	152299	null	152299	CARTHAGE (COTTON VALLEY)	Oct. 29, 1994	null	null	Y	G	Aug. 30, 2026
365	36533045	2	365	33045	42-365-33045	3294113	MALLORY, J H	null	null	475	DIVERSIFIED PRODUCTION LLC	9750	12	CUMMINGS	831566	283237	null	283237	CARTHAGE (PETTIT, LOWER)	Nov. 16, 2017	null	null	N	G	Aug. 30, 2026
365	36533046	1	365	33046	42-365-33046	3294121	JOHN M. BRADLEY	null	null	49	EQV OPERATING LLC	9540	2	DANIEL, Z.L. GAS UNIT	427464	153540	null	153540	CARTHAGE (COTTON VALLEY)	Jan. 16, 1995	null	null	N	G	Aug. 30, 2026
365	36533047	1	365	33047	42-365-33047	3294121	E. W. GRISWOLD	null	null	254	TGNR EAST TEXAS LLC	9501	5	MCDANIEL, J.A.	427531	155251	null	155251	CARTHAGE (COTTON VALLEY)	June 6, 1995	Sept. 19, 2025	null	Y	G	Aug. 30, 2026
365	36533048	1	365	33048	42-365-33048	3294123	SAM'L DUNCAN	null	null	158	TGNR EAST TEXAS LLC	9722	10	CGU 17	427529	155016	null	155016	CARTHAGE (COTTON VALLEY)	May 2, 1995	null	null	N	G	Aug. 30, 2026
365	36533049	1	365	33049	42-365-33049	3294132	WM. W. ALLEN	null	null	16	COMSTOCK OIL & GAS, LLC	10337	1	WYATT	427563	155605	null	155605	BECKVILLE (COTTON VALLEY)	June 27, 1995	Aug. 28, 2024	null	Y	G	Aug. 30, 2026
365	36533050	1	365	33050	42-365-33050	3294121	MATTHEW ASHTON	null	null	8	XTO ENERGY INC.	9800	7-L	KYLE, FRED UNIT	427582	153308	null	153308	CARTHAGE (COTTON VALLEY)	Dec. 17, 1994	null	null	N	G	Aug. 30, 2026
365	36533050	2	365	33050	42-365-33050	3294121	MATTHEW ASHTON	null	null	8	XTO ENERGY INC.	9800	1	LANGFORD, J.E.	427582	13427	13427	null	CARTHAGE (TRAVIS PEAK)	Feb. 22, 1995	null	null	N	O	Aug. 30, 2026
365	36533050	3	365	33050	42-365-33050	3294121	MATTHEW ASHTON	null	null	8	XTO ENERGY INC.	9800	1 U	LANGFORD, J.E.	427582	13427	13427	null	CARTHAGE (TRAVIS PEAK)	Feb. 22, 1995	null	null	N	O	Aug. 30, 2026
365	36533050	4	365	33050	42-365-33050	3294121	MATTHEW ASHTON	null	null	8	XTO ENERGY INC.	9800	7	LANGFORD, J.E.	427582	13427	13427	null	CARTHAGE (TRAVIS PEAK)	null	null	null	N	O	Aug. 30, 2026
365	36533051	1	365	33051	42-365-33051	3294132	JAS. REEL	null	null	564	PRESTON EXPLORATION LLC	10551	1	WILKERSON	427706	155831	null	155831	BECKVILLE (COTTON VALLEY)	Jan. 27, 1995	July 5, 2012	null	Y	G	Aug. 30, 2026
365	36533052	1	365	33052	42-365-33052	3294214	BAINES, W C	null	null	64	XTO ENERGY INC.	10200	1	ADAMS, J.E. DR. GAS UNIT	427853	153939	null	153939	BECKVILLE (COTTON VALLEY)	April 4, 1995	Oct. 29, 2013	null	Y	G	Aug. 30, 2026
365	36533052	2	365	33052	42-365-33052	3294214	BAINES, W C	null	null	64	XTO ENERGY INC.	10200	1	ADAMS, J.E. DR. GAS UNIT	523712	153939	null	153939	BECKVILLE (COTTON VALLEY)	April 4, 1995	Oct. 29, 2013	null	Y	G	Aug. 30, 2026
365	36533052	3	365	33052	42-365-33052	3294214	BAINES, W C	null	null	64	XTO ENERGY INC.	10200	1	DR. J.E. ADAMS GAS UNIT	745522	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36533053	1	365	33053	42-365-33053	3294123	EDWIN SMITH	null	null	601	R. LACY SERVICES, LTD.	10050	6	ROQUEMORE UNIT 1	427883	153483	null	153483	CARTHAGE (COTTON VALLEY)	Jan. 30, 1995	null	null	N	G	Aug. 30, 2026
365	36533054	1	365	33054	42-365-33054	3294113	GEO. GILLASPY	null	null	223	TGNR EAST TEXAS II LLC	7000	3	WIENER ESTATE	427975	152475	null	152475	DEBERRY (TRAVIS PEAK)	March 15, 1997	null	null	N	G	Aug. 30, 2026
365	36533055	1	365	33055	42-365-33055	3294141	BEN C. JORDAN	null	null	348	DIVERSIFIED PRODUCTION LLC	7910	A 8 L	STEELE, CORRIE UNIT A	428007	153744	null	153744	BETHANY (TRAVIS PEAK CONS.)	Feb. 3, 1995	null	null	N	G	Aug. 30, 2026
365	36533055	2	365	33055	42-365-33055	3294141	BEN C. JORDAN	null	null	348	DIVERSIFIED PRODUCTION LLC	7910	A 8-U	STEELE, CORRIE UNIT	435711	155519	null	155519	BETHANY (TRAVIS PEAK)	Dec. 5, 1997	null	null	N	G	Aug. 30, 2026
365	36533056	1	365	33056	42-365-33056	3294124	WALLACE, B R	null	null	710	DEVON ENERGY PRODUCTION CO, L.P.	9680	10	MORGAN UNIT	428010	154512	null	154512	CARTHAGE (COTTON VALLEY)	June 18, 1997	Aug. 26, 2015	null	Y	G	Aug. 30, 2026
365	36533056	2	365	33056	42-365-33056	3294124	WALLACE, B R	null	null	710	DEVON ENERGY PRODUCTION CO, L.P.	9680	10	MORGAN UNIT	748419	000000	null	null	null	null	null	null	null	null	Aug. 30, 2026
365	36533362	1	365	33362	42-365-33362	3294124	T. C. CAROUTH	null	null	888	EQV OPERATING LLC	9750	170	CARTHAGE GAS UNIT	446256	159671	null	159671	CARTHAGE (COTTON VALLEY)	Nov. 9, 2005	null	null	N	G	Aug. 30, 2026
365	36533363	1	365	33363	42-365-33363	3294124	EBENEZER KELLOG	null	null	374	EOG RESOURCES, INC.	9640	135	CARTHAGE GAS UNIT	446257	159888	null	159888	CARTHAGE (COTTON VALLEY)	Aug. 20, 1996	May 17, 2007	null	Y	G	Aug. 30, 2026

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.

`api_no`

varchar

Sampled: 50K
Distinct: 37.2K

00338582 32
00305620 32
00338566 28
00338384 28
00302919 28
00338691 24
00338281 24
00338589 24
00305272 21
00305161 20
00338659 20
00730739 20

`seq`

int2

Sampled: 50K
Distinct: 32

1 37.2K
2 7.6K
3 2.6K
4 1.1K
5 508
6 310
7 161
8 112
9 70
10 59
11 45
12 45

`county_code`

varchar

Sampled: 50K
Distinct: 5

003 42.2K
001 4.9K
007 1.8K
005 548
009 511

`api_county`

varchar

Sampled: 50K
Distinct: 11

391 15.5K
401 13.8K
399 9.6K
393 4.4K
389 3.5K
395 3.2K
397 9
433 3

`api_unique`

varchar

Sampled: 50K
Distinct: 18.4K

30852 27
30588 26
30205 26
00087 24
30520 23
30651 23
30649 23
30669 22
30302 22
30343 22
30546 21
31903 21

`api_number`

varchar

Sampled: 50K
Distinct: 37.2K

42-003-05620 32
42-003-38582 32
42-003-02919 28
42-003-38566 28
42-003-38384 28
42-003-38691 24
42-003-38589 24
42-003-38281 24
42-003-05272 21
42-007-30739 20
42-003-05161 20
42-003-38659 20

`permit_no`

int4

Sampled: 50K
Distinct: 30.9K
Empty: 0.3037

383450 12
425829 9
557607 8
470584 8
453243 7
472335 6
817804 6
433324 6
444681 6
378986 6
397192 6
478177 6

`oil_lease_no`

varchar

Sampled: 50K
Distinct: 7.1K
Empty: 0.5533

01770 453
17503 309
20587 174
00584 169
15874 142
08909 115
20882 100
15638 99
21930 88
11693 84
11267 79
18008 76

Take it away

Back to everything we know about Statewide API Data (dBase)