Preview Field Gas Rules (Mainframe)

First 100 rows

Out of roughly 14K rows in texas.fl_gas_field_rule. Version obs-5be4b1814c19.

First 100 rows of `texas.fl_gas_field_rule`, 28 columns wide
`district_no`	`field_no`	`rule_seq`	`rule_effective_date`	`proration_eff_date`	`proration_suspend_date`	`rules_rescinded_date`	`docket_suffix`	`spacing_to_lease_line`	`spacing_to_well`	`injection_credit`	`acres_per_unit`	`tolerance_acres`	`casing_code`	`casing_depth`	`casing_remarks`	`diagonal_code`	`diagonal`	`diagonal_remarks`	`field_transfer_allow`	`allowable_basis`	`field_text`	`old_allocation_code`	`class_pending_code`	`docket_number`	`rules_not_reliable_flag`
01	256500	1	Dec. 9, 2014	March 1, 2015	null	null	null	330	0	N	80.00	0.00	W	0	null	CC	3250	null	null	null	SEE REMARKS FOR ENTITY FOR DENSITY FOR SBR LSE ONLY	%	null	01-0290632	null
01	256500	2	Jan. 29, 2013	null	null	null	null	467	933	N	80.00	40.00	W	0	null	CC	3250	null	null	null	SEE REMARKS FOR ENTITY FOR DENSITY FOR SBR LSE ONLY	null	null	01-0277308	null
01	256500	3	Feb. 8, 1988	Feb. 1, 1997	April 29, 1997	null	null	467	933	N	80.00	0.00	W	0	null	CC	3250	null	null	null	SEE REMARKS FOR ENTITY FOR DENSITY FOR SBR LSE ONLY	%	null	01-88712	null
01	256500	4	null	null	null	null	null	467	1320	N	80.00	0.00	null	0	null	CC	4000	4000	N	G	null	null	null	null	null
01	467500	1	July 12, 1954	null	null	null	null	330	660	N	40.00	0.00	null	0	null	CC	1100	null	null	null	10 ACRE UNITS, DIAGONAL 1100' SEE REMARKS	null	null	01-30104	null
01	2396500	1	Aug. 6, 2013	Sept. 1, 2013	null	null	null	330	0	N	80.00	8.00	null	0	null	CC	99999	null	null	null	P-15 AC LIST LEASE PLAT REQ	2	null	01-0283008	null
01	2414300	1	null	null	null	null	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	0	null	N	G	null	%	null	null	null
01	3328600	1	April 7, 1986	April 1, 1986	null	May 1, 2000	null	467	1200	N	40.00	0.00	null	0	null	null	0	null	null	null	FIELD RULES RESCINDED 4/7/86-DKT #1-86978	%	null	01-86978	null
01	3328600	2	Nov. 2, 1984	Nov. 1, 1984	April 1, 1986	null	null	467	1200	N	160.00	16.00	W	0	null	CC	5000	null	null	null	null	%	null	01-82634	null
01	3328600	3	Nov. 1, 1984	Nov. 1, 1984	Nov. 1, 1984	null	null	467	1200	N	0.00	0.00	null	0	null	null	0	null	null	null	null	%	null	null	null
01	3328600	4	Sept. 10, 1984	Nov. 1, 1984	null	null	null	467	1200	N	160.00	16.00	W	0	null	CC	5000	null	null	null	null	2	null	01-82634	null
01	4300500	1	May 17, 2013	March 1, 2015	null	null	null	467	0	N	40.00	4.00	W	0	null	CC	2100	null	null	null	CORR INTERVAL 5,600 TO 8,490 FEET	R	null	01-0280555	null
01	4300500	2	March 26, 2013	null	null	null	null	467	1200	N	40.00	4.00	W	0	null	CC	2100	null	null	null	null	null	null	01-0280555	null
01	4300500	3	Dec. 21, 1999	null	null	null	null	467	1200	N	40.00	0.00	W	0	null	CC	2100	null	null	null	RULES CANCELLED - STATEWIDE RULES IN EFFECT	null	null	01-0223064	null
01	4300500	4	April 16, 1984	Aug. 1, 1984	May 1, 1999	null	null	660	1320	N	320.00	32.00	W	0	null	CC	6500	null	null	null	FIELD IS UNDER STATEWIDE RULES PER FINAL ORD 01-0223064	2	null	01-82403	null
01	4681700	1	June 1, 1987	Oct. 1, 2006	null	null	null	467	1200	N	40.00	0.00	null	0	null	CC	2100	null	null	null	null	%	null	01-90547	null
01	5122400	1	null	null	June 14, 1993	null	null	467	1200	N	40.00	4.00	W	0	TWDB	CC	2100	2100	N	G	null	%	null	null	null
01	5122750	1	Aug. 4, 2020	null	null	null	null	250	600	N	40.00	0.00	null	0	null	null	0	null	null	null	null	null	null	01-0003333	null
01	5438500	1	null	null	Dec. 14, 1992	null	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	0	null	N	G	null	%	null	null	null
01	6262200	1	Nov. 1, 1984	Nov. 1, 1984	April 21, 1995	null	null	933	1867	N	160.00	16.00	W	0	TDWR	CC	4500	null	null	null	null	2	null	01-82435	null
01	6924300	1	null	null	null	null	null	150	467	N	10.00	1.00	W	0	TWDB	CC	1500	1500	N	G	FLD RULES CORRECTED 150/467 W/10 ACR SPAC 4/15/97 DAMEKI	2	null	null	null
01	7220500	1	Nov. 9, 1981	null	null	null	null	330	660	N	20.00	10.00	W	0	TWDB	CC	1100	1500	N	G	MULT 49B MAX 80A/OPT. 10 ACRE W/1100' MAX DIAG.	2	null	01-76960	null
01	7850001	1	null	null	null	null	null	330	933	N	20.00	2.00	null	0	null	CC	500	500	N	G	null	null	null	null	null
01	7856250	1	June 14, 1985	null	Aug. 1, 2002	null	null	467	2200	N	213.00	21.00	F	100	null	WC	5000	X5000	N	G	null	2	null	null	null
01	8001700	1	July 11, 1983	null	null	null	null	467	933	N	40.00	0.00	W	0	null	CC	2500	null	null	null	null	null	null	01-80078	null
01	8072500	1	Feb. 24, 1998	null	null	null	null	467	1200	N	80.00	40.00	null	0	null	CC	3250	3250	N	G	ON 40 ACRES DIAGONAL IS 2150'	null	null	01-0218265	null
01	8075666	1	June 14, 1985	null	null	null	null	660	1320	N	80.00	40.00	null	0	null	CC	3250	3250	N	G	null	null	null	null	null
01	8713499	1	Jan. 28, 1985	null	null	null	null	467	1200	N	80.00	0.00	W	0	TDWR	CC	3500	null	null	null	OPTIONAL 40 ACRE UNITS W/ 2100 FT. DIAG.	null	null	01-83935	null
01	8713600	1	June 14, 1985	null	null	null	null	660	1867	N	80.00	10.00	null	0	null	CC	3500	3500	N	G	MULTI 49B RULES UP TO 160 + 10% TOL AC	%	null	null	null
01	8713700	1	Nov. 1, 1984	Nov. 1, 1984	null	null	null	467	1200	N	40.00	0.00	null	0	null	null	0	null	null	null	FLD UNDER STATEWIDE RULES	%	null	null	null
01	10025300	1	null	null	null	null	null	467	1200	N	40.00	0.00	W	0	TWDB LTR.	CC	0	null	N	G	null	%	null	null	null
01	10440500	1	June 6, 1988	July 1, 1988	March 15, 1993	null	null	660	1320	N	160.00	80.00	W	0	null	CC	6000	null	null	null	160 AC UNITS W/80 ACRES TOL MAX DIAG 6000'	4	null	01-91865	null
01	10440700	1	July 1, 2006	July 1, 2006	null	null	null	660	1320	N	160.00	80.00	null	0	null	CC	6000	null	null	null	NET ACRE FEET ASSIGNED	2	null	01-91979	null
01	10440700	2	Sept. 1, 1989	March 1, 1989	null	null	null	660	1320	N	160.00	80.00	null	0	null	CC	6000	null	null	null	NET ACRE FEET ASSIGNED	4	null	01-91979	null
01	10440700	3	Sept. 1, 1988	Sept. 1, 1988	March 1, 1989	null	null	660	1320	N	160.00	0.00	null	0	null	CC	6000	null	null	null	null	4	null	01-91979	null
01	10440700	4	Aug. 1, 1988	Aug. 1, 1988	Sept. 1, 1988	null	null	467	1200	N	0.00	0.00	null	0	null	null	0	null	null	null	null	4	null	null	null
01	10440770	1	July 1, 1988	Sept. 1, 1988	March 15, 1993	null	null	660	1320	N	160.00	80.00	null	0	null	CC	6000	null	null	null	DIAG OF 6000'. 100% NET ACRE FT ALLOCATION.	4	null	01-91979	null
01	10440770	2	June 1, 1988	Sept. 1, 1988	null	null	null	467	1200	N	0.00	0.00	null	0	null	null	0	null	null	null	null	4	null	null	null
01	10440775	1	July 25, 1988	Sept. 1, 1988	null	null	null	660	1320	N	160.00	80.00	null	0	null	CC	6000	null	null	null	DIAG 6000'. 100% NET ACRE FT ALLOCATION FORMULA.	4	null	01-91979	null
01	10440775	2	June 1, 1988	June 1, 1988	Sept. 1, 1988	null	null	467	1200	N	0.00	0.00	null	0	null	null	0	null	null	null	null	4	null	null	null
01	10440800	1	Jan. 22, 1990	Oct. 1, 1988	Sept. 26, 1996	null	null	660	1320	N	160.00	80.00	null	0	null	CC	6000	null	null	null	DIAG 6000', 100% NET ACRE FT ALLOC/240 MAX TOLERANCE ACS	4	null	01-93648	null
01	10440800	2	Oct. 1, 1988	Oct. 1, 1988	null	null	null	467	1200	N	0.00	0.00	null	0	null	null	0	null	null	null	null	4	null	null	null
01	10951500	1	null	null	null	May 1, 2000	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	8500	8500	N	G	RULES RESCINDED ORD #1-82,463 EFF 4/23/84	2	null	null	null
01	11173568	1	June 14, 1985	null	null	null	null	467	933	N	40.00	4.00	null	0	null	WC	2100	X2100	N	G	RESCINDED CASING & MULTI-STAGE CEMENTING RULES 6/14/85.	null	null	null	null
01	11575250	1	null	null	null	null	null	467	933	N	40.00	4.00	W	0	T.W.D.B.	CC	2100	2100	N	G	null	2	null	null	null
01	11581400	1	null	null	null	null	null	467	933	N	40.00	4.00	W	0	T.W.D.B.	CC	2100	2100	N	G	null	2	null	null	null
01	12018200	1	April 9, 2013	null	null	null	null	330	0	N	80.00	8.00	null	0	null	CC	3250	null	null	null	CORRELATIVE INTERVAL IS 7160' - 7535'	null	null	01-0280513	null
01	12018200	2	July 26, 2011	Aug. 1, 2011	null	null	null	330	0	N	80.00	8.00	null	0	null	CC	3250	null	null	null	CORRELATIVE INTERVAL IS 7160' - 7535'	2	null	01-0270639	null
01	12018200	3	May 24, 2011	null	null	null	null	330	0	N	80.00	8.00	null	0	null	CC	3250	null	null	null	CORRELATIVE INTERVAL IS 7160' - 7535'	null	null	01-0270024	null
01	12018200	4	Jan. 13, 2011	null	null	null	null	330	0	N	80.00	8.00	null	0	null	CC	3250	null	null	null	CORRELATIVE INTERVAL IS 7160' - 7535'	null	null	01-0267635	null
01	12018200	5	March 9, 2010	null	March 16, 2010	null	null	467	0	N	80.00	8.00	null	0	null	CC	3250	null	null	null	CORRELATIVE INTERVAL IS 7160' - 7535'	null	null	01-0263787	null
01	12018666	1	Aug. 14, 2007	Sept. 1, 2007	null	null	null	330	660	N	160.00	0.00	null	0	null	CC	4500	null	null	null	OPTIONAL RULES ADOPTED	X	null	01-0251521	null
01	12018666	2	Feb. 28, 2006	March 1, 2006	April 1, 2007	null	null	467	933	N	160.00	0.00	null	0	null	CC	4500	null	null	null	FINAL ORDER PER DOC.	%	null	01-0245719	null
01	12170300	1	null	null	null	May 1, 2000	null	330	467	N	10.00	5.00	W	0	T.W.D.B.	CC	1100	1100	N	G	FIELD RULES CANCELLED EFF 8/81 DKT 1-81403	null	null	null	null
01	15142666	1	null	null	null	null	null	660	1867	N	160.00	16.00	null	0	null	CC	4500	4500	N	G	OPT. 80 AC W/3250' DIAG.	null	null	null	null
01	15146001	1	Jan. 10, 1977	Jan. 1, 1977	null	null	null	330	660	N	20.00	0.00	W	0	null	CC	1500	null	null	null	10 ACRES MAY BE ASSIGNED TO LAST WELL	2	null	01-66713	null
01	15146148	1	July 2, 1984	Aug. 1, 1984	null	null	null	467	1200	N	40.00	0.00	null	0	null	null	0	null	null	null	DOCKET ASSIGNED ONLY-DENSITY FROM SWR 38	%	null	null	null
01	15146481	1	null	null	null	null	null	467	1200	N	40.00	0.00	F	0	S. W.	CC	0	null	N	G	null	null	null	null	null
01	15146555	1	June 14, 1985	null	null	null	null	467	2640	N	320.00	32.00	null	0	null	CC	5280	5280 FROM WELL BORE	N	G	RESCINDED CASING & MULTI-STAGE CEMENTING 6/14/85	A	null	null	null
01	15146592	1	June 14, 1985	null	null	null	null	467	2640	N	320.00	32.00	null	0	null	CC	5280	5280 FROM WELL BORE	N	G	RESCINDED CASING AND ULTI-STAGE CEMENTING RULES 6/14/85.	A	null	null	null
01	15146600	1	null	null	Feb. 29, 1984	null	null	467	1200	N	40.00	4.00	W	0	TWDB	CC	2100	2100	N	G	null	%	null	null	null
01	15146666	1	null	null	null	null	null	1320	2640	N	320.00	32.00	null	0	null	CC	6000	6000	N	G	ONE WELL FLD EFF 12/1/95/ALLOCATION PREVIOUSLY 100% ACREAGE	2	null	null	null
01	15146814	1	null	null	Sept. 16, 1994	null	null	467	1200	N	40.00	0.00	W	0	T.W.D.B.	CC	0	null	N	G	null	%	null	null	null
01	15153500	1	April 9, 1979	Aug. 1, 1992	March 17, 1995	null	null	933	1867	N	160.00	16.00	W	0	TWDB	CC	4500	4500	N	G	null	%	null	01-71929	null
01	15153500	2	null	Aug. 1, 1992	null	null	null	933	1867	N	160.00	16.00	W	0	TWDB	CC	4500	4500	N	G	null	%	null	null	null
01	15911700	1	null	null	null	null	null	933	1867	N	320.00	32.00	W	0	TWDB	CC	8000	8000	N	G	null	%	null	null	null
01	15911750	1	null	null	null	null	null	933	1867	N	320.00	32.00	W	0	TWDB	CC	6000	6000	N	G	null	2	null	null	null
01	15914500	1	null	null	null	null	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	0	null	N	G	null	%	null	null	null
01	16335500	1	null	null	null	null	null	660	1320	N	80.00	8.00	W	0	TWDB	CC	3250	3250	N	G	null	%	null	null	null
01	16335540	1	null	null	null	null	null	660	1320	N	80.00	8.00	W	0	TWDB	CC	3250	3250	N	G	null	%	null	null	null
01	16340500	1	null	null	June 10, 1997	null	null	467	1200	N	160.00	16.00	W	0	TWDB	CC	5000	5000	N	G	OPTIONAL 80 ACRE UNIT MAX DIAG 4000	R	null	null	null
01	16340900	1	May 21, 1979	null	March 31, 1997	null	null	467	1200	N	80.00	8.00	W	0	TWDB	CC	4000	4000	N	G	null	%	null	01-71666	null
01	16495150	1	null	null	null	null	null	660	1320	N	160.00	16.00	W	0	TWDB	CC	4500	4500	N	G	null	2	null	null	null
01	16495160	1	null	null	null	null	null	660	1320	N	135.00	14.00	W	0	TWDB	CC	4800	4800	N	G	null	2	null	null	null
01	16495250	1	null	null	null	null	null	660	1320	N	160.00	16.00	W	0	TWDB	CC	4500	4500	N	G	null	2	null	null	null
01	16495260	1	null	null	null	null	null	660	1320	N	130.00	13.00	W	0	TWDB	CC	4500	4500	N	G	null	2	null	null	null
01	16495300	1	null	null	null	null	null	660	1320	N	160.00	16.00	W	0	TWDB	CC	4500	4500	N	G	null	2	null	null	null
01	16647568	1	null	Jan. 1, 2019	null	null	null	660	1320	N	320.00	32.00	W	0	TWDB LTR.	CC	9000	9000	N	G	OPT. 160 ACRES W/DIAG. 9000'	%	null	null	null
01	17248710	1	null	null	null	null	null	467	933	N	20.00	0.00	null	0	null	WC	1500	X1500	N	G	null	A	null	null	null
01	17466333	1	null	null	null	null	null	467	1200	N	40.00	32.00	null	0	null	CC	0	null	N	G	null	null	null	null	null
01	17668001	1	May 8, 1941	null	null	null	null	150	300	N	2.00	0.00	null	0	null	null	0	null	null	null	null	null	null	01-02563	null
01	17668001	2	null	null	null	null	null	150	300	N	40.00	0.00	null	0	null	CC	0	null	N	G	null	null	null	null	null
01	17875500	1	April 1, 1995	April 1, 1995	April 6, 1995	null	null	467	1200	N	40.00	0.00	null	0	null	null	0	null	null	null	STATEWIDE RULES IN EFFECT	%	null	null	null
01	18000500	1	null	null	null	null	null	467	1320	N	40.00	0.00	null	0	null	CC	4500	4500	N	G	OPT. 80 ACRE UNITS W/3200' DIAG.	null	null	null	null
01	18224500	1	April 19, 1982	null	null	null	null	467	933	N	80.00	0.00	W	0	T.W.D.B.	CC	3250	3250	N	G	MULT 49B TO 160+10%,OIL WELLS IN CINDY ANN(AUSTIN CHALK OIL)	2	null	01-78014	null
01	20336375	1	Jan. 21, 2003	Jan. 1, 2003	July 24, 2006	null	null	467	933	N	320.00	32.00	null	0	null	CC	6000	0	N	G	SEE ORDER FOR HORIZONTAL RULES, OPTIONAL RULES ADOPTED	%	null	01-0233171	null
01	20336375	2	null	null	April 1, 2004	null	null	660	2640	N	640.00	64.00	F	3655	3655 SEE OPTION	WC	10000	X10000	N	G	null	A	null	null	null
01	20345400	1	null	null	Nov. 1, 1997	null	null	660	2640	N	640.00	64.00	W	0	T.W.D.B.	CC	10000	10000	N	G	FLD CONSOLIDATED INTO COOKE (EDWARDS LIME) DKT 01-233171	2	null	null	null
01	20383475	1	April 8, 2008	May 1, 2008	null	null	null	330	660	N	40.00	4.00	null	0	null	CC	2100	null	null	null	NO MINIMUM SPACING BETWEEN VERTICAL & HORIZ. WELLS	2	null	01-0255292	null
01	21172050	1	null	null	null	null	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	0	null	N	G	null	%	null	null	null
01	21172400	1	null	null	Dec. 1, 1999	null	null	467	1200	N	40.00	0.00	W	0	TWDB	CC	0	null	N	G	null	%	null	null	null
01	22100500	1	null	null	null	null	null	1320	2640	N	320.00	32.00	W	0	TWDB	CC	6000	6000	N	G	null	2	null	null	null
01	24462600	1	null	null	July 14, 1993	null	null	660	1320	N	160.00	16.00	W	0	T.W.D.B.	CC	4500	4500	N	G	null	2	null	null	null
01	24806333	1	null	null	April 1, 2010	null	null	660	1320	N	80.00	8.00	W	0	T.W.D.B.	CC	3250	3250	N	G	null	2	null	null	null
01	24811333	1	null	null	Dec. 14, 1992	null	null	660	1320	N	320.00	32.00	F	5700	5700 SEE OPTION	WC	6000	X6000	N	G	null	2	null	null	null
01	24825200	1	July 1, 1985	null	null	May 1, 2000	null	467	1200	N	40.00	0.00	null	0	null	null	0	null	null	null	STATEWIDE RULES EFF. 7-1-85 DKT 1-85179.	null	null	01-85179	null
01	24825200	2	Dec. 1, 1983	null	null	null	null	467	933	N	40.00	0.00	null	0	null	null	0	null	null	null	null	null	null	01-00000	null
01	25146200	1	null	null	null	null	null	467	1320	N	80.00	8.00	null	0	null	CC	3250	3250	N	G	MULTI 49B TO 320 AC + 10%	null	null	null	null
01	25146230	1	Oct. 2, 2012	null	null	null	null	467	1200	N	320.00	32.00	null	0	null	CC	7500	null	null	null	CORRELATIVE INTERVAL 6190 - 6530	null	null	01-0276980	null
01	25146230	2	Feb. 26, 2009	March 1, 2009	null	null	null	467	1200	N	320.00	352.00	null	0	null	CC	7500	null	null	null	CORRELATIVE INTERVAL 6190 - 6530	A	null	01-0260612	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_no`

varchar

Sampled: 14K
Distinct: 12

04 4K
03 2.5K
02 2.1K
06 964
08 960
10 947
14 722
09 633
05 388
01 360
13 325
11 81

`field_no`

int4

Sampled: 14K
Distinct: 11.4K

66461275 12
98563083 9
13147285 9
67849150 8
98570400 7
16032174 7
64409200 7
9591300 7
97752100 7
7527093 6
13764500 6
60462500 6

`rule_seq`

int2

Sampled: 14K
Distinct: 12

1 11.4K
2 1.9K
3 420
4 119
5 42
6 18
7 9
8 4
9 3
12 1
10 1
11 1

`rule_effective_date`

date

Sampled: 14K
Distinct: 2.1K
Empty: 0.5373

Nov. 1, 1984 59
April 1, 1995 53
Oct. 1, 1984 52
June 4, 1984 38
Jan. 1, 1995 37
Sept. 1, 1984 34
Aug. 1, 1984 34
Feb. 4, 1985 32
April 1, 1985 31
Nov. 23, 2004 30
Feb. 22, 1985 30
May 2, 1985 29

`proration_eff_date`

date

Sampled: 14K
Distinct: 462
Empty: 0.7005

Oct. 1, 1984 106
April 1, 1995 81
July 1, 1984 71
Nov. 1, 1984 66
March 1, 1985 64
May 1, 1984 64
Feb. 1, 1985 59
Jan. 1, 1985 58
Dec. 1, 1984 56
Aug. 1, 1984 55
May 1, 1985 51
June 1, 1985 50

`proration_suspend_date`

date

Sampled: 14K
Distinct: 790
Empty: 0.7855

July 14, 1993 47
April 13, 1995 38
April 14, 1993 37
March 15, 1993 35
Oct. 15, 1992 30
Dec. 14, 1992 30
Oct. 15, 1993 28
July 16, 1992 28
Aug. 16, 1993 27
Feb. 16, 1993 24
April 12, 1995 24
Sept. 16, 1993 24

`rules_rescinded_date`

date

Sampled: 14K
Distinct: 1
Empty: 0.9154

May 1, 2000 1.2K

`docket_suffix`

varchar

Sampled: 14K
Distinct: 0
Empty: 1.0

Take it away

Back to everything we know about Field Gas Rules (Mainframe)