Preview: Gas Ledger — Wells — Texas RRC data

First 100 rows

Out of roughly 141K rows in texas.gas_ledger_well. Version obs-a38d9cb8f45b.

First 100 rows of `texas.gas_ledger_well`, 70 columns wide
`district`	`field_no`	`operator_no`	`gas_rrc_id`	`well_no`	`lease_name`	`county_code`	`well_type`	`gas_gatherer_old`	`gas_gatherer`	`full_stream`	`gas_split`	`gas_gatherer_2`	`gas_gatherer_3`	`liq_gatherer_old`	`liq_gatherer`	`liq_split`	`well_info`	`batch_no`	`exc_14b`	`ex14b_date`	`completion_date`	`depth`	`upper_perf`	`lower_perf`	`commingle_code`	`commingle_no`	`commingle_date`	`dpt_code`	`bhp_code`	`sip_code`	`exc_test`	`g10_due`	`date_last_utilized`	`pa_code`	`pa_date`	`special_allow`	`special_allow_code`	`form_lacking`	`top_pct`	`prior_rinu_yyyymm`	`rinu_yyyymm`	`g1_date`	`open_flow`	`slope`	`ratio`	`gas_gravity`	`oil_gravity`	`beg_gas_status`	`gas_status`	`lmt_allow`
01	2001	36043	273598	1H	WHITWORTH	323	K	null	TXPLL	null	null	null	null	null	null	null	null	null	4	null	Feb. 16, 2013	5940	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	61799	232716	1	REDD STATE	465	K	null	null	null	null	null	null	null	null	null	null	null	4	null	May 22, 2006	15886	14434	15148	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	85408	272110	1P	STS C	311	R	null	null	null	null	null	null	null	null	null	OBSERVATION	null	1	null	Sept. 12, 2014	11565	11115	11228	0	0	null	0	0	0	0	1	null	8	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	100104	299834	A200GR	ASE SOUTH	13	K	null	null	null	null	null	null	null	null	null	null	null	1	null	April 30, 2025	12250	0	0	0	0	null	0	0	0	4	0	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	100351	229750	1	SAN PEDRO RANCH	127	K	null	null	null	null	null	null	null	null	null	null	null	P	null	Sept. 28, 2007	6270	6220	6260	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	100351	264125	32H	BRISCOE COCHINA EAST RANCH	127	(	null	SPRIP	null	null	null	null	EASTC	SPRIP	X	SWR 10	null	(	null	Sept. 27, 2011	8112	13857	13860	0	0	null	5	0	0	1	1	null	0	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	100351	266690	21H	RANCHO ENCANTADO	127	(	null	SPRIP	null	null	null	null	TRIMT	SPRIP	X	SWR 10	null	(	null	March 19, 2012	8197	13758	13820	1	8888	Aug. 1, 2011	0	0	0	0	1	null	0	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	100351	271554	9H	DIAMOND H STATE	127	(	null	null	null	null	null	null	null	null	null	SWR 10	null	(	null	July 23, 2012	7617	8131	13030	0	0	null	5	0	0	1	1	null	0	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	100797	248995	9	WALLACE, J. C.	13	K	null	null	null	null	null	null	null	null	null	null	null	1	null	Feb. 11, 2006	6979	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	101300	272796	A 6V	PILONCILLO	127	K	null	null	null	null	null	null	null	null	null	null	null	1	null	Jan. 1, 2012	8549	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	102824	211602	7	LINDHOLM-HANSON GAS UNIT	311	K	HOUSP	VARAS	null	null	null	null	null	GULFM	null	null	null	1	null	Jan. 25, 2005	14469	12776	12788	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	12718	12718	null
01	2001	103575	285635	02WS	WASHBURN RANCH	283	R	null	null	null	null	null	null	null	null	null	WATER SUPPLY	null	1	null	Aug. 28, 2013	3810	0	0	0	0	null	0	0	0	0	1	null	8	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	103926	252860	8	RUCKMAN	311	Z	null	null	null	null	null	null	null	null	null	null	null	0	null	Nov. 14, 2006	16393	13990	14070	0	0	null	5	0	0	1	1	null	0	null	0	null	0	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	139559	140604	2	RAMSEY	265	K	null	null	null	null	null	null	null	null	null	null	null	H	null	Feb. 20, 1991	1518	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	146369	251750	1	HYDE	137	K	null	null	null	null	null	null	null	null	null	null	null	4	null	Oct. 15, 2008	4655	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	148108	263703	null	CROMWELL	0	null	null	null	null	null	null	null	null	null	null	null	null	0	null	null	0	99999	0	2	5500	May 1, 2013	null	null	null	0	0	null	0	null	0	null	0	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	0
01	2001	172246	172124	1	WARDLAW "52"	465	K	null	null	null	null	null	null	null	null	null	null	null	H	null	Sept. 22, 1998	12730	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	273933	226651	8025	BRISCOE (5140)	127	K	ENTEP	ENTPO	null	null	null	null	null	SHELT	null	null	null	1	null	Aug. 17, 2007	4950	4333	4716	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	273933	233663	8034	BRISCOE (5140)	127	K	null	ENTPO	null	null	null	null	null	SHELT	null	null	null	1	null	null	5500	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	499978	275876	1	HUNTER CREDIT TRUST	283	Z	null	null	null	null	null	null	null	null	null	null	null	1	null	Dec. 22, 2012	8500	7808	7814	0	0	null	5	0	0	1	1	null	0	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	499978	279475	29H	FASKEN STATE 1202	479	(	null	null	null	null	null	null	null	null	null	SWR 10	null	(	null	Aug. 27, 2014	9571	9531	13970	0	0	null	5	0	0	1	1	null	0	null	0	null	0	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	534184	137944	1	STONE 'A'	323	K	null	null	null	null	null	null	null	null	null	null	null	H	null	null	1540	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	703462	270501	A 3H	BRACKEN, R. A.	311	(	EQUTO	ROGUL	null	null	null	null	EQUTO	ROGUL	null	SWR 10	null	(	null	March 12, 2012	11793	12175	12243	1	5672	May 1, 2015	5	0	0	1	0	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	732075	300991	1ST	LINDHOLM-PEARL	311	H	null	null	null	null	null	null	null	null	null	null	null	0	null	March 7, 2026	12900	0	0	0	0	null	5	0	0	1	0	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	2001	875653	234000	801	WARDLAW	137	K	null	null	null	null	null	null	null	null	null	null	null	4	null	Sept. 11, 2006	9971	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	0	0.0000	0	0.000	0.0	0	0	null
01	2001	945936	174590	3	J. HENDERSON ET AL GU #1	13	K	null	null	null	null	null	null	null	null	null	null	null	1	null	May 22, 1999	14080	0	0	0	0	null	0	0	0	0	1	null	0	null	0	null	1	0.00	null	null	null	null	0.0000	0	0.000	0.0	0	0	null
01	256500	38889	134016	37	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	Feb. 22, 1990	9585	9430	9482	1	6772	April 1, 1990	0	0	0	0	0	null	0	null	100	C	0	0.56	null	null	April 2, 1990	null	0.0000	21	0.686	60.7	0	0	null
01	256500	38889	147124	43R	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	Oct. 14, 1993	9600	9417	9465	1	529	Oct. 1, 1993	0	0	0	0	0	null	0	null	1043	null	0	0.62	null	null	Nov. 8, 1993	null	0.0000	26	0.704	62.0	0	0	null
01	256500	38889	157317	55	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	Oct. 3, 1991	9500	9256	9290	1	5016	Feb. 1, 1996	0	0	0	0	0	null	0	null	100	C	0	0.76	null	null	Jan. 26, 1996	null	0.0000	27	0.708	65.3	0	0	null
01	256500	38889	157318	42	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	May 27, 1993	9400	9208	9242	1	5016	Feb. 1, 1996	0	0	0	0	0	null	0	null	100	C	0	0.48	null	null	Jan. 31, 1996	null	0.0000	67	0.708	61.4	0	0	null
01	256500	38889	158147	47	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	March 6, 1996	9700	9344	9383	1	6772	March 1, 1996	0	0	0	0	0	null	0	null	100	C	0	0.70	null	null	April 1, 1996	null	0.0000	21	0.799	57.8	0	0	null
01	256500	38889	161420	48	BRACKEN RANCH	311	null	ELPAF	ENTPO	null	X	ROGUL	null	FLINH	GULFM	null	null	null	0	null	Jan. 7, 1997	9515	9298	9324	1	5016	Jan. 1, 1997	0	0	0	0	0	null	0	null	100	C	0	0.60	null	null	Jan. 15, 1997	null	0.0000	17	0.765	54.1	0	0	null
01	256500	85408	271427	2H	RYAN	311	null	BHPEF	BPXEG	null	null	null	null	SHELT	BPPRN	null	null	null	0	null	July 10, 2013	11532	11715	14194	1	6455	May 1, 2022	0	0	0	0	0	null	0	null	100	C	0	0.00	null	null	July 24, 2013	null	0.0000	56	0.726	51.3	0	0	null
01	256500	85408	272497	18H	RYAN 1795 O	311	null	BHPTX	BPXEG	null	null	null	null	SHELT	BPPRN	null	null	null	0	null	Aug. 19, 2013	11491	11680	14972	0	0	null	0	0	0	0	1	null	0	null	100	C	0	0.00	null	null	Sept. 9, 2013	null	0.0000	31	0.721	53.8	0	0	null
01	256500	85408	273328	1H	RYAN 1795 O	311	null	BHPEF	BPXEG	null	null	null	null	SHELT	BPPRN	null	null	null	0	null	May 29, 2014	11573	12250	16044	0	0	null	0	0	0	0	1	null	0	null	100	C	0	0.00	null	null	June 2, 2014	null	0.0000	37	0.724	53.2	0	0	null
01	256500	85408	273335	1H	RYAN O	311	null	BHPEF	BPXEG	null	null	null	null	BHPTX	BPPRN	null	null	null	0	null	May 10, 2014	11659	11722	14912	0	0	null	0	0	0	0	1	null	0	null	100	C	0	0.00	null	null	June 3, 2014	null	0.0000	818	0.661	40.9	0	0	null
01	256500	102824	106497	5	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Feb. 22, 1983	9720	9539	9578	1	515	July 1, 1983	0	0	1	0	0	null	0	null	100	C	0	0.40	null	null	June 1, 1983	null	0.0000	37	0.693	60.0	0	0	null
01	256500	102824	106498	14	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	March 12, 1983	9768	9549	9606	1	515	July 1, 1983	0	0	1	0	0	null	0	null	1043	null	0	0.35	null	null	June 8, 1983	null	0.0000	89	0.761	62.8	0	0	null
01	256500	102824	106932	11	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	March 29, 1983	10062	9786	9822	1	515	July 1, 1983	0	0	1	0	0	null	0	null	100	C	0	0.40	null	null	Aug. 8, 1983	null	0.0000	358	0.703	58.8	0	0	null
01	256500	102824	106934	15	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	4	null	July 15, 1983	9803	9512	9570	1	515	July 1, 1983	0	0	1	0	0	null	0	null	1043	null	0	0.45	null	null	Aug. 9, 1983	null	0.0000	58	0.710	61.0	0	0	null
01	256500	102824	108219	17	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Sept. 19, 1983	9674	9467	9489	1	515	Nov. 1, 1983	0	0	1	0	0	null	0	null	100	C	0	0.40	null	null	Oct. 24, 1983	null	0.0000	63	0.708	59.1	0	0	null
01	256500	102824	108342	5	MCCLAUGHERTY, L. S.	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	H	null	Oct. 8, 1983	9670	9451	9481	1	515	Nov. 1, 1983	0	0	1	0	0	null	0	null	1043	null	0	0.52	null	null	Nov. 17, 1983	null	0.0000	167	0.720	63.4	0	0	null
01	256500	102824	108684	10	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	null	9880	9728	9757	1	515	Nov. 1, 1983	0	0	1	0	0	null	0	null	100	C	0	0.42	null	null	Dec. 13, 1983	null	0.0000	23	0.713	60.6	0	232	null
01	256500	102824	108827	4	MCCLAUGHERTY, L. S.	311	J	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Nov. 13, 1983	9775	9598	9626	1	515	Nov. 1, 1983	0	0	1	0	0	null	0	null	1043	null	0	0.33	null	null	Dec. 7, 1983	null	0.0000	85	0.740	62.9	0	0	null
01	256500	102824	108828	16	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Dec. 5, 1983	9690	9530	9510	1	515	Jan. 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.35	null	null	Jan. 6, 1984	null	0.0000	36	0.699	59.2	0	0	null
01	256500	102824	109057	18	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	H	null	Dec. 18, 1983	9650	9490	9512	1	515	Jan. 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.38	null	null	Jan. 17, 1984	null	0.0000	32	0.753	63.6	0	96	null
01	256500	102824	110250	27	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	PLAML	TRAFT	X	null	null	1	null	March 18, 1984	9712	9472	9507	1	515	March 1, 1984	0	0	1	0	0	null	0	null	1043	null	1	0.24	null	null	April 18, 1984	null	0.0000	42	0.741	60.8	0	0	null
01	256500	102824	110827	28	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	null	10030	9820	9852	1	515	April 1, 1984	0	0	1	0	0	null	0	null	100	C	0	1.34	null	null	April 27, 1984	null	0.0000	0	0.000	0.0	0	0	null
01	256500	102824	110829	1ST	MCCLAUGHERTY, I. O.	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	null	10332	10090	10150	0	0	null	5	0	1	1	1	null	0	null	100	C	0	0.20	null	null	May 7, 1984	null	0.0000	100	0.656	48.9	0	6	null
01	256500	102824	110831	31	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	April 16, 1984	10000	9752	9794	1	515	April 1, 1984	0	0	1	0	0	null	0	null	1043	null	0	0.38	null	null	May 8, 1984	null	0.0000	19	0.743	61.0	0	0	null
01	256500	102824	110832	109	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	null	10200	9990	10046	1	533	May 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.13	null	null	May 18, 1984	null	0.0000	233	0.783	50.4	1415	0	null
01	256500	102824	111162	1016	BRACKEN "A"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	May 6, 1984	10086	9912	9962	1	533	May 1, 1984	0	0	1	0	0	null	0	null	1043	null	0	0.14	null	null	May 17, 1984	null	0.0000	162	0.663	52.0	0	0	null
01	256500	102824	111163	32	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	April 19, 1984	9730	9531	3564	1	515	May 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.37	null	null	May 9, 1984	null	0.0000	33	0.730	60.3	0	0	null
01	256500	102824	111164	1017	BRACKEN "A"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	April 10, 1984	10200	9973	10025	1	533	May 1, 1984	0	0	1	0	0	null	0	null	1043	null	0	0.27	null	null	May 16, 1984	null	0.0000	56	0.725	51.0	0	0	null
01	256500	102824	111686	101	BRACKEN "G"	311	J	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	July 1, 1984	9900	9732	9768	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.15	null	null	July 12, 1984	null	0.0000	0	0.677	0.0	0	0	null
01	256500	102824	112423	8	MCCLAUGHERTY, L. S.	311	J	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	null	9750	9540	9563	1	515	Dec. 1, 1984	0	0	1	0	0	null	0	null	1043	null	0	0.39	null	null	Aug. 20, 1984	null	0.0000	24	0.700	59.7	0	0	null
01	256500	102824	112491	34	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	July 3, 1984	9730	9551	9586	1	515	Dec. 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.50	null	null	Aug. 20, 1984	null	0.0000	64	0.072	60.1	0	75	null
01	256500	102824	112834	1015	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Sept. 10, 1984	10035	9873	9917	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.12	null	null	Sept. 11, 1984	null	0.0000	140	0.658	50.0	1828	0	null
01	256500	102824	113575	33	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Sept. 29, 1984	9715	9478	9510	1	515	Dec. 1, 1984	0	0	1	0	0	null	0	null	1043	null	0	0.52	null	null	Oct. 17, 1984	null	0.0000	50	0.720	64.1	0	0	null
01	256500	102824	113705	35	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Oct. 19, 1984	9915	9674	9710	1	515	Dec. 1, 1984	0	0	1	0	0	null	0	null	100	C	0	0.55	null	null	Nov. 8, 1984	null	0.0000	17	0.697	58.2	0	0	null
01	256500	102824	114100	2	MCCLAUGHERTY, I. O.	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	H	null	Nov. 15, 1984	10050	9778	9839	1	5038	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.20	null	null	Dec. 10, 1984	null	0.0000	100	0.656	48.0	0	133	null
01	256500	102824	114261	1027	BRACKEN "A"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Nov. 20, 1984	10140	9930	9998	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.13	null	null	Dec. 9, 1984	null	0.0000	66	0.745	50.2	0	0	null
01	256500	102824	114489	1	MCCLAUGHERTY, I. O. "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Jan. 7, 1985	10030	9910	9950	1	5038	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.31	null	null	Jan. 9, 1985	null	8.6900	200	0.656	50.4	0	0	null
01	256500	102824	114862	1025	BRACKEN "A"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Jan. 3, 1985	10060	9840	9890	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.53	null	null	Jan. 28, 1985	null	0.0000	250	0.667	52.1	9	9	null
01	256500	102824	115802	1024	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	March 8, 1985	10025	9803	9848	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.17	null	null	March 28, 1985	null	0.0000	134	0.663	50.5	0	0	null
01	256500	102824	116114	1039	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	March 26, 1985	10010	9909	9951	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.20	null	null	April 19, 1985	null	0.0000	281	0.658	51.0	0	0	null
01	621666	36587	233334	3	MCANELLY, G. C.	325	K	ENTPO	null	null	null	null	null	null	null	null	null	null	1	null	June 14, 2007	923	890	923	0	0	null	0	0	0	0	1	null	0	null	0	null	0	0.00	null	null	June 17, 2007	0	0.0000	0	0.600	0.0	0	0	null
01	256500	102824	116115	1026	BRACKEN "A"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	March 19, 1985	10120	9894	9940	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.33	null	null	April 19, 1985	null	0.0000	77	0.667	52.5	0	0	null
01	256500	102824	116519	1038	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	April 6, 1985	10010	9810	9855	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.20	null	null	May 9, 1985	null	0.0000	126	0.685	53.1	0	0	null
01	256500	102824	116903	1040	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	May 12, 1985	10025	9812	9861	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.18	null	null	June 8, 1985	null	0.0000	196	0.678	51.4	0	0	null
01	256500	102824	117339	1056	BRACKEN "B"	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	June 20, 1985	10330	10110	10159	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.10	null	null	July 12, 1985	null	0.0000	72	0.652	50.9	0	0	null
01	256500	102824	117341	1023	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	June 1, 1985	9975	9741	9790	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.28	null	null	June 18, 1985	null	0.0000	136	0.686	52.7	873	0	null
01	256500	102824	117344	1A	HUFF	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	June 7, 1985	11055	10816	10912	1	5022	March 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.16	null	null	June 28, 1985	null	0.0000	0	0.650	0.0	0	0	null
01	256500	102824	117713	2A	HUFF	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	June 15, 1985	11905	11046	11116	1	5022	Nov. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.00	null	null	June 28, 1985	null	0.0000	0	0.635	0.0	0	0	null
01	256500	102824	118637	1093	BRACKEN "C"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	null	10530	10310	10360	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.20	null	null	Oct. 18, 1985	null	0.0000	180	0.693	48.0	0	0	null
01	256500	102824	119023	1052	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Oct. 29, 1985	10158	9912	9976	1	533	Sept. 1, 1998	0	0	1	0	0	null	0	null	1043	null	0	0.00	null	null	Nov. 16, 1985	null	0.0000	139	0.651	53.0	0	0	null
01	256500	102824	119257	3	WHEELER, CLIFTON	311	K	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	1	null	Aug. 1, 1985	10640	10406	10510	0	0	null	0	0	0	0	1	null	0	null	1043	null	0	0.65	null	null	Sept. 19, 1985	null	0.0000	263	0.644	59.3	0	0	null
01	256500	102824	119258	2	WHEELER, CLIFTON	311	K	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	H	null	Sept. 3, 1985	10680	10442	10544	0	0	null	0	0	0	0	1	null	0	null	1043	null	0	0.81	null	null	Oct. 18, 1985	null	9.3200	203	0.644	57.4	0	0	null
01	256500	102824	119259	5B	WHEELER, CLIFTON	311	null	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	0	null	Oct. 2, 1985	10950	10722	10850	0	0	null	5	0	0	1	1	null	0	null	100	C	0	0.52	null	null	Nov. 10, 1985	null	0.0000	410	0.640	56.5	0	0	null
01	256500	102824	119260	1	WHEELER, CLIFTON	311	K	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	H	null	Aug. 2, 1985	10980	10736	10870	0	0	null	0	0	0	0	1	null	0	null	1043	null	0	0.46	null	null	Oct. 10, 1985	null	0.0000	520	0.645	57.0	0	0	null
01	256500	102824	119998	8B	WHEELER, CLIFTON	311	K	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	H	null	Dec. 14, 1985	10632	10468	10544	0	0	null	0	0	0	0	1	null	0	null	1043	null	0	0.82	null	null	Jan. 2, 1986	null	0.0000	405	0.640	56.0	0	0	null
01	256500	102824	126360	51	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Dec. 19, 1987	9811	9556	9611	1	515	Feb. 1, 1988	0	0	1	0	0	null	0	null	100	C	0	0.42	null	null	Jan. 28, 1988	null	0.0000	95	0.739	63.1	0	0	null
01	256500	102824	126711	9B	WHEELER, CLIFTON	311	null	HOUSP	TARGS	null	null	null	null	GULFM	TRAFT	X	null	null	0	null	Dec. 1, 1987	10660	10450	10530	0	0	null	5	0	0	1	1	null	0	null	100	C	0	0.76	null	null	Jan. 11, 1988	null	0.0000	410	0.640	56.5	0	0	null
01	256500	102824	127233	1041	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	April 12, 1988	10100	9906	9944	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.17	null	null	April 29, 1988	null	0.0000	0	0.600	0.0	137	666	null
01	256500	102824	129182	1076	BRACKEN "E"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Sept. 24, 1988	10788	10525	10547	1	9999	April 1, 2021	0	0	1	0	0	null	0	null	100	C	0	0.07	null	null	March 27, 1998	null	0.0000	0	0.674	0.0	0	0	null
01	256500	102824	129564	1062	BRACKEN "E"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Dec. 14, 1988	10665	10432	10484	1	9999	April 1, 2021	0	0	1	0	0	null	0	null	100	C	0	0.14	null	null	March 30, 1998	null	0.0000	0	0.706	0.0	0	0	null
01	256500	102824	131966	52	BRACKEN	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Aug. 26, 1989	9748	9521	9556	1	515	Sept. 1, 1989	0	0	1	0	0	null	0	null	100	C	0	0.38	null	null	Aug. 31, 1989	null	9.4200	26	0.716	62.1	0	0	null
01	256500	102824	132517	53	BRACKEN	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Oct. 30, 1989	9730	9414	9530	1	515	Sept. 1, 1989	0	0	1	0	0	null	0	null	100	C	0	0.29	null	null	Nov. 3, 1989	null	0.0000	29	0.746	62.0	0	0	null
01	256500	102824	132930	1010O	BRACKEN "D"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Oct. 26, 1989	10750	10454	10475	1	9999	April 1, 2021	0	0	1	0	0	null	0	null	100	C	0	0.15	null	null	Nov. 17, 1989	null	0.0000	135	0.645	43.1	0	0	null
01	256500	102824	132931	1037	BRACKEN "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Nov. 9, 1989	10075	9818	9840	1	533	Feb. 1, 1998	0	0	1	0	0	null	0	null	100	C	0	0.33	null	null	Dec. 11, 1989	null	0.0000	19	0.641	52.1	0	0	null
01	256500	102824	132941	1049	BRACKEN "F"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Nov. 30, 1989	10675	10438	10461	1	9999	April 1, 2021	0	0	1	0	0	null	0	null	100	C	0	0.14	null	null	Dec. 18, 1989	null	0.0000	23	0.718	54.0	0	0	null
01	256500	102824	133373	55	BRACKEN	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Jan. 3, 1990	9715	9486	9514	1	515	Sept. 1, 1989	0	0	1	0	0	null	0	null	100	C	0	0.21	null	null	Jan. 15, 1990	null	0.0000	31	0.701	59.0	0	0	null
01	256500	102824	133562	56	BRACKEN	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Jan. 26, 1990	9800	9543	9576	1	515	Sept. 1, 1989	0	0	1	0	0	null	0	null	100	C	0	0.32	null	null	Jan. 31, 1990	null	0.0000	15	0.715	62.1	0	0	null
01	256500	102824	133674	57	BRACKEN	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Feb. 15, 1990	9800	9567	9597	1	515	Sept. 1, 1989	0	0	1	0	0	null	0	null	100	C	0	0.61	null	null	Feb. 20, 1990	null	0.0000	10	0.710	64.7	0	0	null
01	256500	102824	138511	9	MCCLAUGHERTY, L. S.	311	null	ENTPO	TARGS	null	null	null	null	PLAML	TRAFT	X	null	null	0	null	Feb. 9, 1991	9850	9590	9623	1	515	July 1, 1991	0	0	1	0	0	null	0	null	100	C	0	0.29	null	null	May 29, 1991	null	0.0000	0	0.748	55.4	0	0	null
01	256500	102824	142206	11	MCCLAUGHERTY, L. S.	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	July 26, 1992	9750	9594	9630	1	515	July 1, 1992	0	0	1	0	0	null	0	null	100	C	0	0.31	null	null	Aug. 4, 1992	null	0.0000	15	0.728	56.8	0	0	null
01	256500	102824	142613	60	BRACKEN ET AL	311	K	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	1	null	Aug. 27, 1992	9715	9529	9656	1	515	Sept. 1, 2006	0	0	1	0	0	null	0	null	1043	null	0	1.22	null	null	Sept. 17, 1992	null	0.0000	78	0.732	58.7	0	0	null
01	256500	102824	142648	12	MCCLAUGHERTY, L. S. "A"	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Sept. 5, 1992	9725	9542	9572	1	7903	Sept. 1, 1992	0	0	1	0	0	null	0	null	100	C	0	0.22	null	null	Sept. 16, 1992	null	0.0000	20	0.818	63.6	0	200	null
01	256500	102824	144062	63	BRACKEN ET AL	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Jan. 1, 1993	9897	9681	9717	1	515	Jan. 1, 1993	0	0	1	0	0	null	0	null	100	C	0	1.15	null	null	Jan. 22, 1993	null	0.0000	24	0.761	56.4	0	0	null
01	256500	102824	144631	12	MCCLAUGHERTY, L. S.	311	null	ENTPO	TARGS	null	null	null	null	BPPRN	TRAFT	X	null	null	0	null	Jan. 16, 1993	9806	9622	9660	1	515	Jan. 1, 1993	0	0	1	0	0	null	0	null	100	C	0	0.42	null	null	Feb. 26, 1993	null	0.0000	23	0.692	57.4	0	0	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: 6

04 18.2K
01 10K
05 7.8K
02 7.3K
03 5.9K
06 784

`field_no`

int4

Sampled: 50K
Distinct: 6.1K

12018200 3.9K
39744500 1.8K
86950600 1.7K
27135700 1.1K
88576304 984
27135750 940
32950285 926
5189550 809
67885400 739
93215400 674
34733500 656
24492500 633

`operator_no`

int4

Sampled: 50K
Distinct: 1.4K

386310 9.7K
561136 2.8K
499978 2.6K
220903 2.1K
100351 1.7K
525398 1.4K
102824 975
879035 957
103575 923
85408 867
521544 789
788997 752

`gas_rrc_id`

int4

Sampled: 50K
Distinct: 50K

256120 1
233316 1
257211 1
296863 1
183089 1
210699 1
155703 1
297073 1
73152 1
44342 1
292890 1
158829 1

`well_no`

varchar

Sampled: 50K
Distinct: 5.4K
Empty: 0.0006

1 7.5K
2 3.6K
3 2.5K
4 1.9K
1H 1.6K
5 1.5K
6 1.2K
7 1.1K
8 908
9 822
2H 793
10 682

`lease_name`

varchar

Sampled: 50K
Distinct: 17.5K

PILONCILLO 520
GALVAN RANCH 349
SBR 212
OLD OCEAN UNIT 197
LA PERLA 197
SLICK, T. B. ESTATE 174
HAYNES, L. 171
B.M.T. 169
SOUTH CALLAGHAN RANCH 165
BRISCOE CATARINA NORTH 156
ASCHE 152
BRISCOE CATARINA WEST 146

`county_code`

int2

Sampled: 50K
Distinct: 107

479 8.5K
505 4.1K
161 3.7K
127 2.4K
215 2.3K
283 2.1K
427 2K
255 1.7K
123 1.5K
293 1.5K
311 1.3K
297 1K

`well_type`

varchar

Sampled: 50K
Distinct: 8
Empty: 0.6463

K 12.4K
( 2.6K
J 1.1K
I 388
A 345
R 335
Z 261
H 148

Take it away

Back to everything we know about Gas Ledger — Wells