Preview: Oil Ledger — Wells — Texas RRC data

First 100 rows

Out of roughly 207.5K rows in texas.oil_ledger_well. Version obs-6f16bd63e9f2.

First 100 rows of `texas.oil_ledger_well`, 41 columns wide
`district`	`field_no`	`operator_no`	`lease_no`	`well_no`	`type_well`	`county_code`	`pump`	`depth`	`perf`	`completion_date`	`completion_date_raw`	`ex14b_code`	`sub_well`	`no_prod_code`	`delq_form`	`test_eff`	`exc_test`	`water`	`ex14b_yyyymm`	`remarks`	`test_date`	`date_last_utilized_yyyymm`	`new_wellbore_exc`	`new_wellbore_connect_date`	`ex14b2_type`
01	2001	893	19016	1	S	331	0	4280	4167	Jan. 4, 2017	20170104	4	0	0	1	1	0	0	202109	TRK#166996, NEW	June 1, 2020	null	null	null	null
01	2001	25443	13564	2	S	177	0	5270	0	May 24, 1987	19870524	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	25443	13564	3	S	177	0	3508	0	Dec. 24, 1987	19871224	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	36043	17553	2	S	323	0	3710	0	Aug. 12, 2013	20130812	4	0	0	1	1	0	0	201508	TRK#84760,LACK	null	null	null	null	null
01	2001	46615	21236	1	E	21	0	3286	3020	June 26, 2023	20230626	1	0	0	1	1	0	0	202310	TR296526, APPRO	Nov. 30, 2024	202411	null	null	null
01	2001	64104	17133	6	S	163	0	500	0	April 21, 2012	20120421	H	0	0	1	1	0	0	202107	TRK#67298, LACK	June 1, 2022	null	null	null	null
01	2001	70376	16114	1	S	323	0	4685	4518	Oct. 12, 2010	20101012	4	0	0	0	1	0	0	201707	TRK #41764	June 1, 2013	null	null	null	null
01	2001	70376	17406	1	S	323	0	3785	3675	Feb. 12, 2012	20120212	4	0	0	1	1	0	0	201707	TRK#41741, NEW	null	null	null	null	null
01	2001	73059	18753	5	E	323	0	4300	3540	Nov. 27, 2014	20141127	1	0	0	1	1	0	0	202510	TRK#147847, NEW	June 1, 2025	null	null	null	null
01	2001	73059	18753	7	E	323	0	4600	0	Dec. 11, 2014	20141211	1	0	0	1	1	0	0	202510	TRK#149451, NEW	June 1, 2025	null	null	null	null
01	2001	96690	11948	1	S	271	0	0	0	null	0	H	0	0	0	1	0	0	201009	null	Sept. 1, 1990	null	null	null	null
01	2001	100351	15988	1V	S	283	0	8220	0	Dec. 6, 2010	20101206	1	3	0	0	0	0	0	null	SEE REMARKS	null	null	null	null	null
01	2001	100351	17558	11	E	163	0	5992	0	Nov. 29, 2013	20131129	1	0	0	1	1	0	0	202403	WANTING TO PROD	April 1, 2026	202604	null	null	null
01	2001	100531	21629	1	S	13	0	9603	9496	Oct. 20, 2024	20241020	0	0	0	0	0	0	0	null	NEW GEOTHERMAL	Oct. 20, 2024	null	null	null	null
01	2001	100668	14723	1	E	331	0	12670	4300	null	0	1	0	0	1	1	0	0	202509	null	Sept. 16, 2025	202509	null	null	null
01	2001	101171	15066	1	S	21	0	6960	0	Dec. 8, 2007	20071208	4	0	0	1	1	0	0	202405	W-2,W-12,W-15,L	March 1, 2023	null	null	null	null
01	2001	103891	20081	1801	E	465	0	625	0	March 19, 2019	20190319	1	0	2	1	1	0	0	202611	TRK#228776, NEW	null	null	null	null	null
01	2001	103891	20081	1802	E	465	0	485	0	March 19, 2019	20190319	1	0	2	1	1	0	0	202611	TRK#228794, NEW	null	null	null	null	null
01	2001	103899	16378	1RE	S	177	0	3490	2645	Jan. 10, 2012	20120110	1	2	0	0	0	0	0	202609	TRK #34066, NEW	null	null	null	null	null
01	2001	139559	12866	3	S	265	0	1438	0	June 5, 1991	19910605	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	167047	12634	C 2	S	331	0	5969	4380	null	0	H	0	0	1	1	0	0	201009	null	null	null	null	null	null
01	2001	195770	17949	1H	S	331	0	7199	0	Oct. 12, 2010	20101012	4	0	0	0	1	0	0	202101	TRK#52216, LACK	Dec. 1, 2023	null	null	null	null
01	2001	195770	19532	2	S	331	0	1367	0	Aug. 30, 2018	20180830	4	0	0	1	1	0	0	202101	TRK#204098, NEW	Dec. 1, 2023	null	null	null	null
01	2001	195836	11863	1	S	491	0	300	0	May 28, 1984	19840528	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	195836	11863	3	S	491	0	837	0	Jan. 9, 1985	19850109	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	195836	11864	2	S	491	0	1106	1025	June 7, 1984	19840607	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	224555	12635	1	S	31	0	2140	2140	null	0	H	0	0	1	1	0	0	201009	null	null	null	null	null	null
01	2001	228365	12221	1	S	331	0	2298	0	Nov. 18, 1983	19831118	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	250718	18964	1803E	E	127	0	1700	0	Jan. 18, 2016	20160118	1	0	2	1	1	0	0	202601	TRK#167308, NEW	Dec. 1, 2024	202412	null	null	null
01	2001	251927	12241	1	S	331	0	1532	0	Dec. 14, 1982	19821214	H	0	0	1	1	0	0	201009	null	Sept. 1, 1989	null	null	null	null
01	2001	253162	17680	2	P	13	0	12365	0	Jan. 19, 2013	20130119	1	0	0	0	0	5	0	202509	TRK#66423	null	null	null	null	null
01	2001	254263	14221	1591	S	323	0	5864	0	Nov. 3, 1997	19971103	H	0	0	0	1	0	0	202311	null	June 1, 2023	null	null	null	null
01	2001	254277	15228	2H	S	507	0	4878	4878	July 5, 2009	20090705	0	0	0	1	1	0	0	null	ON BOTH HORIZON	null	null	null	null	null
01	2001	254277	17361	1V	S	507	0	8295	0	Feb. 21, 2012	20120221	4	0	0	1	1	0	0	201108	TRK#53444, NEW	null	null	null	null	null
01	2001	256842	17351	1	S	13	1	8978	7781	Nov. 25, 2011	20111125	1	0	2	1	1	0	20	201303	TRK#60091, NEED	April 25, 2012	null	null	null	null
01	2001	321576	9186	1	S	453	0	2644	0	Sept. 2, 1981	19810902	H	0	0	0	1	0	0	null	null	null	null	null	null	null
01	2001	347151	19514	1	S	331	0	1520	0	May 30, 2017	20170530	0	3	0	0	1	0	0	null	TRK#203668, NEW	null	null	null	null	null
01	2001	347151	19514	2	S	331	0	1520	0	Oct. 20, 2017	20171020	1	3	0	0	0	0	0	202505	TRK#203667, NEW	null	null	null	null	null
01	2001	363086	14728	1	S	163	0	370	0	Feb. 5, 1991	19910205	0	6	0	0	0	0	0	null	CATHODIC PROTEC	null	null	null	null	null
01	2001	385715	17548	3	S	55	0	3658	1507	March 31, 2012	20120331	4	0	0	0	1	0	0	201403	TRK#73634,LACK	null	null	null	null	null
01	2001	402723	19127	1A	S	331	0	5692	0	Dec. 26, 2013	20131226	4	0	0	1	1	0	0	201902	TRK#179754, NEW	Dec. 1, 2024	null	null	null	null
01	2001	429778	12457	1	S	323	0	1601	0	null	0	H	0	0	0	1	0	0	201009	null	Sept. 1, 1989	null	null	null	null
01	2001	525398	19335	71H	E	177	0	100	0	Oct. 26, 2014	20141026	1	0	0	1	1	0	0	202510	178429 LACK IP	Nov. 15, 2025	202511	null	null	null
01	2001	559352	14957	1	S	137	0	1180	0	June 28, 2008	20080628	4	0	0	1	1	0	0	201106	REC'D W-2(NO TE	June 28, 2008	null	null	null	null
01	2001	559352	14973	1091	S	137	0	1102	0	June 28, 2008	20080628	4	0	0	1	1	0	0	201106	REC'D W-2(NO TE	June 28, 2008	null	null	null	null
01	2001	566352	17362	2	S	493	0	1808	1646	Jan. 27, 2012	20120127	4	0	0	1	1	0	0	201506	TRK#39121, NEW	June 1, 2014	null	null	null	null
01	2001	649300	19516	1	S	137	0	696	0	June 10, 2017	20170610	4	0	0	1	1	0	0	202107	TRK#203046, NEW	Jan. 1, 2020	null	null	null	null
01	2001	665698	18079	1	S	29	0	3000	0	June 29, 2014	20140629	0	3	0	0	0	0	0	null	TRK#110093	null	null	null	null	null
01	2001	680845	18639	2	E	187	0	2260	2240	March 17, 2015	20150317	1	0	0	1	1	0	0	202601	TRK#137806, NEW	June 1, 2025	null	null	null	null
01	2001	680845	19996	1	E	187	0	3450	1100	Feb. 25, 2019	20190225	1	0	0	1	1	0	0	202601	TRK#228219, NEW	June 1, 2025	null	null	null	null
01	2001	681459	14388	3	S	163	0	3498	0	April 1, 2001	20010401	4	0	0	1	1	0	0	202107	(SEE REMARKS)	June 1, 2014	null	null	null	null
01	2001	681459	14388	4	S	163	0	3531	0	April 1, 2001	20010401	4	0	0	0	1	0	0	202107	(SEE REMARKS)	June 1, 2014	null	null	null	null
01	2001	684836	20368	1	E	325	0	1220	0	Sept. 1, 2020	20200901	1	0	0	1	1	0	0	202510	TRK#243851, NEW	June 1, 2025	null	null	null	null
01	2001	698761	14611	10	S	325	0	2165	0	null	0	4	0	0	1	1	0	0	201112	null	June 1, 2012	null	null	null	null
01	2001	704799	14044	2	S	163	0	2502	0	null	0	H	0	0	0	1	0	0	201702	null	July 1, 2016	null	null	null	null
01	2001	748764	19438	1	S	177	0	0	0	April 4, 2012	20120404	1	2	0	0	1	0	0	null	TRK#301176, NOW	Sept. 11, 2023	null	null	null	null
01	2001	748764	19515	1	S	177	0	7746	0	Nov. 13, 2011	20111113	0	0	0	1	1	0	0	null	TRK#200577, NEW	June 1, 2025	null	null	null	null
01	2001	767589	12246	1	S	453	0	118	0	null	0	H	0	0	0	1	0	0	201009	null	Sept. 1, 1989	null	null	null	null
01	2001	824758	19932	A 1	E	323	0	5958	5694	May 14, 2019	20190514	1	0	0	1	1	0	0	202305	TRK#223604, NEW	June 1, 2025	null	null	null	null
01	2001	847710	13797	50WS	S	187	0	425	0	March 10, 1994	19940310	1	2	0	0	1	0	0	202509	null	June 1, 2015	null	null	null	null
01	2001	848014	13565	1	S	507	0	1340	0	null	0	H	0	0	0	1	0	0	201009	null	null	null	null	null	null
01	2001	871133	13993	1	S	13	0	7287	0	Aug. 26, 1993	19930826	H	0	0	0	1	0	0	201806	null	June 1, 2014	null	null	null	null
01	2001	931327	19067	C 2	S	331	0	3447	0	Aug. 10, 2010	20100810	4	2	0	0	0	0	0	202403	TRK#183320, NEW	null	null	null	null	null
01	2001	931327	19067	W 5	S	331	0	3497	0	June 28, 2012	20120628	4	2	0	0	0	0	0	202403	TRK#183407, NEW	null	null	null	null	null
01	2001	931327	19068	W 1	S	331	0	3808	0	July 2, 2011	20110702	4	2	0	0	0	0	0	202403	TRK#183401, NEW	null	null	null	null	null
01	2001	931327	19068	W 3	S	331	0	3430	0	Dec. 1, 2011	20111201	4	2	0	0	0	0	0	202403	TRK#183403, NEW	null	null	null	null	null
01	2001	931327	19068	W 4	S	331	0	3218	0	Feb. 10, 2012	20120210	4	2	0	0	0	0	0	202403	TRK#183406, NEW	null	null	null	null	null
01	256500	38889	8593	1	P	311	1	9660	9566	Dec. 12, 1982	19821212	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	2	P	311	0	9674	9539	June 12, 1983	19830612	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	3	P	311	0	9660	9518	July 30, 1983	19830730	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	4	P	311	1	9725	9578	Sept. 4, 1983	19830904	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	6	P	311	1	9655	9510	Jan. 14, 1984	19840114	0	0	0	0	A	4	1	null	REC'D PLAT 60 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	7	P	311	0	9623	9462	Dec. 9, 1983	19831209	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	8	P	311	1	9633	9465	Jan. 20, 1984	19840120	0	0	0	0	A	4	1	null	REC'D PLAT 40 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	9	P	311	0	9636	9500	Feb. 24, 1984	19840224	0	0	0	0	4	0	1	null	REC'D PLAT 80 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	10	P	311	0	9652	9498	March 8, 1984	19840308	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	11	P	311	0	9633	9472	March 25, 1984	19840325	0	0	0	0	A	4	1	null	REC'D PLAT 40 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	13	P	311	1	9620	9474	April 10, 1984	19840410	0	0	0	0	4	0	2	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	14	P	311	0	9583	9424	June 22, 1984	19840622	0	0	0	0	A	4	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	15	P	311	1	9600	9420	Aug. 8, 1984	19840808	0	0	0	0	A	4	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	16	P	311	1	9715	9558	Feb. 20, 1985	19850220	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	17	P	311	1	9701	9544	Dec. 27, 1984	19841227	0	0	0	0	A	4	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	19	P	311	1	9570	9404	Sept. 18, 1984	19840918	0	0	0	0	A	4	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	21	P	311	0	9519	9356	Nov. 13, 1984	19841113	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	22	P	311	1	9495	9340	Dec. 4, 1984	19841204	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	23	P	311	1	9486	9332	March 14, 1985	19850314	0	0	0	0	4	0	1	null	REC'D PLAT 80 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	25	P	311	0	9520	9373	April 19, 1985	19850419	0	0	0	0	A	4	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	26	P	311	0	9770	9622	Dec. 11, 1986	19861211	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	27	P	311	0	9262	9165	Dec. 30, 1985	19851230	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	28	P	311	0	9265	9110	Sept. 5, 1985	19850905	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	29	P	311	0	9372	9232	May 19, 1987	19870519	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	30	P	311	0	9570	9426	June 2, 1987	19870602	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	31	P	311	1	9500	9386	June 18, 1987	19870618	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	32	P	311	0	9420	9254	July 1, 1987	19870701	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	35	P	311	0	9507	9338	April 15, 1988	19880415	0	0	0	0	4	0	1	null	REC'D 40 ACRE P	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	36	P	311	1	9410	9250	April 14, 1988	19880414	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	38	P	311	1	9600	9394	Sept. 2, 1990	19900902	0	0	0	0	4	0	1	null	NOT TO PRODUCE	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	39	P	311	0	9500	9331	Dec. 1, 1990	19901201	0	0	0	0	4	0	1	null	REC'D PLAT 70 A	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	40	P	311	1	9552	9402	Dec. 14, 1990	19901214	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null
01	256500	38889	8593	44	P	311	0	9420	9207	May 1, 1991	19910501	0	0	0	0	4	0	1	null	null	Jan. 15, 2026	null	null	null	null

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.

`district`

varchar

Sampled: 50K
Distinct: 5

01 24.3K
03 12.8K
02 10K
04 2.4K
05 369

`field_no`

int4

Sampled: 50K
Distinct: 2.8K

27135700 8.8K
27135750 6.2K
27302001 4.8K
12018200 2.8K
3446001 1.1K
20350001 554
19665200 546
256500 545
20823500 509
20097700 508
12406001 501
18707001 424

`operator_no`

int4

Sampled: 50K
Distinct: 950

27200 3.9K
53974 3.7K
100852 2.3K
103575 1.8K
102324 1.8K
73056 1.7K
100351 1.4K
101577 1.2K
36587 1.1K
40209 1.1K
100152 1K
20528 908

`lease_no`

int4

Sampled: 50K
Distinct: 16.8K

19054 342
1382 239
8545 234
14952 210
9000 165
7329 154
6557 149
17583 148
8119 146
4530 127
15638 122
1656 118

`well_no`

varchar

Sampled: 50K
Distinct: 5.9K

1 6K
1H 4.2K
2 2.5K
2H 2.3K
3 1.7K
3H 1.6K
4 1.3K
4H 1.2K
5 991
5H 876
6 808
7 689

`offshore`

int2

Sampled: 50K
Distinct: 2

0 50K
2 35

`type_well`

varchar

Sampled: 50K
Distinct: 7

P 33.8K
S 9K
E 7.1K
X 65
M 12
A 10
N 3

`unit_no`

varchar

Sampled: 50K
Distinct: 1
Empty: 0.0106

0 49.5K

Take it away

Back to everything we know about Oil Ledger — Wells