Preview Field Oil Rules (Mainframe)

First 100 rows

Out of roughly 8.6K rows in texas.fl_oil_field_rule. Version obs-2fc2454324c1.

First 100 rows of `texas.fl_oil_field_rule`, 22 columns wide
`district_no`	`field_no`	`rule_seq`	`rule_effective_date`	`proration_eff_date`	`rule_suspend_date`	`docket_suffix`	`spacing_to_lease_line`	`spacing_to_well`	`acres_per_unit`	`tolerance_acres_code`	`tolerance_acres`	`casing_code`	`casing_depth`	`casing_remarks`	`diagonal_code`	`diagonal`	`diagonal_remarks`	`allocation_code`	`field_text`	`docket_number`	`rules_not_reliable_flag`
01	256500	1	Jan. 27, 2015	Jan. 1, 2015	null	null	330	0	80.00	L	20.00	null	0	null	null	0	null	B	P15'S, ACRES LIST,LEASE PLATS REQUIRED	01-0292749	null
01	256500	2	Dec. 9, 2014	Dec. 1, 2014	Jan. 27, 2015	null	330	0	80.00	L	40.00	null	0	null	null	0	null	B	P15'S, ACRES LIST,LEASE PLATS REQUIRED	01-0290632	null
01	256500	3	Jan. 29, 2013	Jan. 1, 2013	Dec. 9, 2014	null	467	933	80.00	L	40.00	null	0	null	CC	3250	null	B	NO BETWEEN SPACING BETWEEN VERTICAL AND HORIZONTAL WELLS	01-0277308	null
01	256500	4	Feb. 8, 1988	Nov. 1, 1985	Jan. 29, 2013	null	467	933	80.00	L	40.00	null	0	null	CC	3250	null	B	40 ACRE OPTIONS, WITH 2100 DIAG.	1-82599	null
01	256500	5	null	null	null	null	467	1320	80.00	L	40.00	null	0	null	CC	4000	null	B	null	null	null
01	467500	1	June 27, 1986	null	null	null	233	466	10.00	null	0.00	W	0	null	CC	1100	null	A	05 ACRE UNIT LAST WELL ON LEASE	null	null
01	467505	1	null	null	null	null	233	467	10.00	L	5.00	null	0	null	CC	1100	null	B	null	null	null
01	467510	1	Oct. 1, 1990	null	null	null	233	467	10.00	L	5.00	null	0	null	CC	1100	null	B	null	null	null
01	467515	1	null	null	null	null	233	467	10.00	L	5.00	null	0	null	CC	1100	null	B	null	null	null
01	621200	1	March 8, 2010	March 1, 2010	null	null	233	330	5.00	L	2.00	W	0	LETTER T.D.W.R.	CC	1200	null	B	CORRELATIVE INTERVAL IS 1435' - 1860'	01-0264380	null
01	621200	2	null	null	March 8, 2010	null	233	660	10.00	L	5.00	W	0	LETTER T.D.W.R.	CC	1200	null	B	null	null	null
01	621333	1	null	null	null	null	150	300	2.00	L	1.00	null	0	null	CC	467	null	B	null	null	null
01	2031001	1	null	null	null	null	150	300	2.00	null	0.00	W	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	2396500	1	Aug. 6, 2013	Aug. 1, 2013	null	null	330	0	80.00	L	40.00	null	0	null	null	0	NO MAXIMUM DIAGONAL	B	P-15/AC LIST/LEASE PLAT REQ'D	01-0283008	null
01	4079540	1	null	null	null	null	330	933	20.00	L	10.00	W	0	LETTER T.D.W.R.	CC	1500	null	B	null	null	null
01	4300500	1	May 7, 2013	May 1, 2013	null	null	467	0	40.00	L	20.00	null	0	null	null	0	null	C	P15, AC LIST, LSE PLAT	01-0280555	null
01	4668500	1	July 10, 1989	July 1, 1989	null	null	330	660	20.00	L	10.00	W	0	null	CC	1500	null	B	ADOPTION OF FLD RULES AS PERMANENT	1-93052	null
01	4668500	2	Dec. 14, 1987	Dec. 1, 1987	July 10, 1989	null	330	660	20.00	L	10.00	W	0	null	CC	1500	null	B	null	1-91579	null
01	4680700	1	April 1, 1985	April 1, 1985	Oct. 6, 1986	null	660	1320	80.00	L	40.00	W	0	null	CC	3250	null	B	null	1-84732	null
01	4681700	1	June 1, 1987	June 1, 1987	null	null	467	1200	40.00	L	20.00	W	0	null	CC	2100	null	B	null	1-90547	null
01	5066001	1	March 4, 1984	March 1, 1984	null	null	150	300	2.00	L	1.00	null	0	null	CC	467	null	B	null	1-84576	null
01	5122750	1	Aug. 4, 2020	Aug. 1, 2020	null	null	250	600	20.00	L	10.00	null	0	null	null	0	null	A	null	01-0003333	null
01	5599500	1	null	null	null	null	150	300	3.00	null	0.00	null	0	null	CC	600	null	B	null	null	null
01	6053001	1	Jan. 4, 1985	Jan. 4, 1985	July 14, 1986	null	150	330	2.00	L	1.00	W	0	null	CC	467	null	B	null	1-84124	null
01	6053500	1	Feb. 22, 2011	Feb. 1, 2011	null	null	100	0	5.00	L	2.06	null	0	null	CC	750	null	B	CORRELATIVE INTERVAL IS 2000' - 2525'	01-0268003	null
01	6053500	2	Nov. 2, 1987	Nov. 2, 1987	Feb. 22, 2011	null	150	300	5.00	null	0.00	null	0	null	CC	750	null	B	OPTION 2.06 ACRES, DIAG. 475 FEET	1-90699	null
01	6053500	3	Dec. 12, 1963	Feb. 1, 1984	Nov. 2, 1987	null	150	300	10.00	L	5.00	W	0	null	CC	1100	null	B	TEMPORARY RULES FOR 18 MONTHS	1-84124	null
01	6053500	4	null	null	null	null	150	300	10.00	L	5.00	null	0	null	CC	1100	null	B	null	null	null
01	6469001	1	Dec. 10, 1984	Dec. 1, 1984	null	null	233	467	20.00	L	10.00	W	0	null	CC	1500	null	B	OPTIONAL 10 ACRE UNITS--DIAG. 1100	1-83859	null
01	6469001	2	null	null	null	null	330	880	20.00	L	10.00	F	350	350 FT. OR CEMENT LS	CC	1500	null	C	null	null	null
01	7220500	1	Aug. 1, 1987	Aug. 1, 1987	null	null	330	660	20.00	null	0.00	W	0	null	null	0	null	A	10 ACRE OPT. W/DIAG 1100'	1-76960	null
01	7670001	1	Sept. 12, 1949	Sept. 1, 1949	null	null	233	466	10.00	null	0.00	null	0	null	CC	1100	null	A	null	1-16385	null
01	7850001	1	July 22, 1997	null	null	null	233	330	20.00	E	10.00	W	0	null	CC	1500	null	B	OPTIONAL 10 ACRES W/1100' DIAG	01-0214168	null
01	7850666	1	July 22, 1997	null	null	null	233	330	20.00	L	10.00	W	0	null	CC	1500	null	B	OPTIONAL 10 ACRES	01-0214168	null
01	8001600	1	Sept. 8, 1986	null	null	null	0	0	0.00	null	0.00	null	0	null	null	0	null	B	STATEWIDE FIELD RULES/TEMP RULES CANCELLED	null	null
01	8001700	1	null	null	null	null	467	933	40.00	L	20.00	null	0	null	CC	2500	null	B	null	null	null
01	8072500	1	Feb. 24, 1998	null	null	null	467	1200	80.00	L	40.00	W	0	null	CC	3250	null	B	ON 40 ACRES DIAGONAL IS 2150'	01-0218265	null
01	8072750	1	null	null	null	null	660	1320	80.00	L	40.00	W	0	null	CC	3250	null	B	null	null	null
01	8075666	1	null	null	null	null	660	1320	80.00	L	40.00	W	0	null	CC	3250	null	B	null	null	null
01	8240500	1	null	null	null	null	150	300	2.00	null	0.00	F	0	SWR 13 NOW GOVERNS CASING	null	0	null	A	DKT ASSIGNS SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	8575800	1	April 9, 1984	April 1, 1984	Nov. 4, 1985	null	467	933	40.00	L	20.00	null	0	null	CC	2100	null	A	null	01-85795	null
01	8713499	1	Jan. 28, 1984	Jan. 1, 1984	null	null	467	1200	80.00	L	40.00	null	0	null	CC	3500	null	B	40 ACRE OPITIONAL;DIAG 2100	1-83935	null
01	8713499	2	null	null	null	null	467	1320	80.00	L	40.00	W	0	LETTER T.D.W.R.	CC	3500	null	B	null	null	null
01	8713600	1	null	null	null	null	660	1867	80.00	L	40.00	F	0	SWR 13 NOW GOVERNS CASING	CC	3500	null	B	null	null	null
01	10937250	1	null	null	null	null	150	300	10.00	L	5.00	F	0	SWR 13 NOW GOVWENS CASING	CC	1100	null	C	null	null	null
01	10937500	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	10937750	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	11173568	1	null	null	null	null	467	933	40.00	L	20.00	F	0	SWR 13 NOW GOVERNS CASING	CC	2100	null	B	null	null	null
01	12018200	1	April 9, 2013	July 1, 2011	null	null	330	0	80.00	L	40.00	null	0	null	null	0	null	B	P-16 W/ LEASE PLAT	01-0280513	null
01	12018200	2	Jan. 13, 2011	Jan. 1, 2011	July 26, 2011	null	330	0	80.00	L	40.00	null	0	null	CC	3250	null	B	CORRELATIVE INTERVAL IS 7160' - 7535'	01-0267635	null
01	12018200	3	March 9, 2010	March 1, 2010	Jan. 13, 2011	null	467	0	40.00	L	20.00	null	0	null	CC	2100	null	B	CORRELATIVE INTERVAL IS 7160' - 7535'	01-0263787	null
01	12018200	4	Aug. 1, 2008	Aug. 1, 2008	March 9, 2010	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	PSUEDO RULES TO ACCOMMODATE HORIZ. WELLS	01-00086	null
01	12018666	1	Aug. 14, 2007	Feb. 1, 2006	null	null	330	660	160.00	L	40.00	W	0	null	CC	4500	null	D	CORRELATIVE INTERVAL 4288 FT. TO 5041	01-0251521	null
01	12849001	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	13277500	1	Aug. 8, 1988	Aug. 1, 1988	Aug. 8, 1988	null	467	1200	40.00	null	0.00	W	0	null	null	0	null	B	null	1-88735	null
01	13277500	2	June 17, 1985	June 1, 1985	Aug. 8, 1988	null	330	660	10.00	L	5.00	W	0	null	CC	1500	null	B	null	1-85181	null
01	13277700	1	null	null	null	null	330	660	10.00	L	5.00	F	0	SWR 13 NOW GOVERNS CASING	CC	1100	null	B	null	null	null
01	14297600	1	Sept. 23, 1985	Sept. 1, 1985	null	null	330	660	20.00	null	0.00	null	0	null	CC	1500	null	B	10 ACRE OPTIONS DIAG 1100	1-85917	null
01	14297600	2	April 1, 1984	April 1, 1984	Sept. 23, 1985	null	330	660	20.00	L	10.00	null	0	null	CC	1500	null	B	null	1-81965	null
01	14473300	1	Oct. 1, 1990	null	null	null	467	1200	5.00	L	2.00	F	0	REMOVE CASING REQUIRE	null	0	null	B	null	null	null
01	14862001	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY-DENSITY FROM SWR-38.	null	null
01	15146001	1	null	null	null	null	330	660	20.00	L	10.00	F	300	SWR 13 NOW GOVERNS CASING	CC	1500	null	B	null	null	null
01	15146037	1	null	null	null	null	330	660	20.00	L	10.00	F	300	SWR 13 NOW GOVERNS CASING	CC	1500	null	B	null	null	null
01	15502500	1	Dec. 3, 1984	Dec. 1, 1984	null	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	CANCELS DOCKET # 1-80067	1-83866	null
01	15502500	2	null	June 1, 1984	null	null	150	300	5.00	null	0.00	null	0	null	CC	750	null	B	null	null	null
01	15934001	1	null	null	null	null	150	300	2.00	null	0.00	F	650	650 FT.	null	0	null	A	null	null	null
01	16340800	1	null	null	null	null	660	1320	80.00	L	40.00	W	0	LETTER T.D.W.R.	CC	3250	null	B	null	null	null
01	16341500	1	July 26, 1982	July 26, 1982	null	null	660	1320	80.00	L	40.00	null	0	null	CC	3250	null	B	null	null	null
01	16550001	1	Jan. 12, 1993	Jan. 1, 1993	null	null	150	300	2.00	null	0.00	null	0	null	CC	500	null	A	FROM 1650 FT. TO 1780 FT; TEMP. RULES MADE PERMANENT	01-0200369	null
01	16550001	2	July 22, 1991	July 1, 1991	Jan. 12, 1993	null	150	300	2.00	null	0.00	null	0	null	CC	500	null	A	FROM 1650 FT. TO 1780 FT	1-96314	null
01	16552001	1	Aug. 1, 1987	Aug. 1, 1987	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	B	null	01-12940	null
02	7064001	1	Jan. 13, 1986	null	null	null	330	933	40.00	null	0.00	W	0	null	CC	2100	null	C	null	02-22655	null
01	17047001	1	March 1, 1984	March 1, 1984	null	null	330	933	20.00	L	10.00	W	1	null	CC	1500	null	B	10 ACRE OPT. W/1100' DIAG.	01-81017	null
01	17248001	1	null	null	null	null	467	933	20.00	null	0.00	F	0	SWR 13 NOW GOVERNS CASING	null	0	null	B	null	null	null
01	17248142	1	null	null	null	null	467	933	20.00	L	10.00	F	0	SEE FIELD RULES	CC	1500	null	C	null	null	null
01	17248568	1	null	null	null	null	467	933	20.00	L	10.00	F	0	SEE FIELD RULES	CC	1500	null	C	null	null	null
01	17248710	1	null	null	null	null	467	933	20.00	L	10.00	F	0	SEE FIELD RULES	CC	1500	null	C	null	null	null
01	17250001	1	null	null	null	null	330	933	20.00	L	10.00	F	150	SWR 13 NOW GOVERNS CASINGG	CC	1500	null	C	null	null	null
01	17255500	1	null	null	null	null	330	933	20.00	L	10.00	W	0	LETTER T.D.W.R.	CC	1500	null	B	null	null	null
01	17256001	1	Jan. 24, 1994	null	null	null	330	660	20.00	L	10.00	F	0	SWR 13 NOW GOVERNS CASING	CC	2100	null	B	3900 FT MINIMUM OF CASING	01-0204057	null
01	17466111	1	Nov. 19, 2011	Nov. 1, 2011	null	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	PSUEDO RULES TO ACCOMMODATE HORIZ WELLS	01-00086	null
01	17466333	1	null	null	null	null	467	1200	40.00	L	20.00	F	2150	SWR 13 NOW GOVERNS CASING	CC	2100	null	B	null	null	null
01	17466500	1	null	null	null	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	17668001	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY-DENSITY FROM SWR-38.	null	null
01	17876076	1	null	null	null	null	150	300	2.00	null	0.00	null	0	null	null	0	null	A	DKT ASSIGNED SPACING ONLY/DENSITY FROM SWR-38.	null	null
01	17876228	1	May 1, 2009	May 1, 2009	null	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	PSEUDO RULES TO ACCOMMODATE HORIZ WELLS	01-00086	null
01	17876249	1	Sept. 12, 2005	Sept. 12, 2005	null	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	PSUEDO RULES TO ACCOMODATE HORIZ WELLS	01-00086	null
01	18000500	1	null	null	null	null	467	1320	160.00	L	40.00	W	0	LETTER T.D.W.R.	CC	4500	null	B	null	null	null
01	18156500	1	null	null	null	null	467	933	40.00	L	20.00	F	2500	SWR 13 NOW GOVERNS CASING	CC	2500	null	B	null	null	null
01	18224510	1	April 19, 1982	null	null	null	467	933	80.00	L	40.00	null	0	null	CC	3250	null	B	OP 40 ACRES, DIAG 2100	01-78014	null
01	18596001	1	Oct. 1, 1990	null	null	null	150	300	5.00	L	3.00	W	0	LETTER T.D.W.R.	CC	800	null	B	null	null	null
01	19063500	1	April 11, 1984	null	April 11, 1984	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	null	01-82114	null
01	19794500	1	July 22, 1985	July 1, 1985	null	null	150	300	2.00	null	0.00	null	0	null	CC	600	null	B	null	1-85558	null
01	19794500	2	null	null	null	null	330	933	20.00	L	10.00	F	0	SWR 13 NOW GOVERNS CASING	CC	2500	null	B	null	null	null
01	19890750	1	June 16, 2020	June 1, 2020	null	null	330	0	40.00	L	20.00	W	0	null	CC	2100	null	B	CORRELATIVE INTERVAL 6457-6731, PRO PLATS REQ'D	01-0001984	null
01	19890750	2	July 15, 2008	July 15, 2008	June 16, 2020	null	330	933	40.00	L	20.00	W	0	null	CC	2100	null	B	CORRELATIVE INTERVAL 6457 TO 6731	01-0257034	null
01	19890750	3	Sept. 27, 2005	Sept. 27, 2005	July 15, 2008	null	467	1200	40.00	null	0.00	null	0	null	null	0	null	B	PSUEDO RULES TO ACCOMODATE HORIZ. WELLS	01-00086	null
01	20378001	1	null	null	null	null	233	466	5.00	null	0.00	null	0	null	null	0	null	B	null	null	null
01	20899100	1	null	null	null	null	467	1867	80.00	L	40.00	W	0	LETTER T.D.W.R.	CC	4000	null	B	CONS. TO PILGRIM (AC) PER DKT#1-97362 EFF 3/1/92.	null	null
01	20899200	1	null	null	null	null	660	1320	160.00	L	40.00	W	0	LETTER T.D.W.R.	CC	4500	null	B	80 ACRE OPT. W/3250' DIAG.	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_no`

varchar

Sampled: 8.6K
Distinct: 13

10 1.2K
04 1.2K
03 1.1K
11 809
08 809
13 804
09 576
02 544
06 521
01 456
14 289
05 174

`field_no`

int4

Sampled: 8.6K
Distinct: 7.8K

85279200 8
71052900 8
31913800 8
92100050 6
19665200 6
13147285 5
85280300 5
79905003 5
256500 5
65280200 5
83413500 4
53580650 4

`rule_seq`

int2

Sampled: 8.6K
Distinct: 8

1 7.8K
2 578
3 109
4 28
5 10
6 5
8 3
7 3

`rule_effective_date`

date

Sampled: 8.6K
Distinct: 1.3K
Empty: 0.639

Oct. 1, 1984 30
Feb. 1, 1991 26
Dec. 1, 1984 22
Sept. 1, 1984 21
April 1, 1986 20
Jan. 1, 1986 19
June 1, 1985 18
Aug. 6, 2013 16
Jan. 18, 2023 16
Jan. 1, 1985 16
June 1, 1986 15
April 1, 1985 15

`proration_eff_date`

date

Sampled: 8.6K
Distinct: 674
Empty: 0.6537

April 1, 1986 30
Oct. 1, 1984 29
Dec. 1, 1984 29
June 1, 1985 23
April 1, 1985 22
Sept. 1, 1984 21
Sept. 1, 1989 21
June 1, 1986 20
Feb. 1, 1991 19
March 1, 1984 19
June 1, 1984 19
Sept. 1, 1985 19

`rule_suspend_date`

date

Sampled: 8.6K
Distinct: 645
Empty: 0.8713

Sept. 1, 1993 25
May 9, 2011 9
Jan. 18, 2023 8
Jan. 27, 2015 8
Sept. 29, 2009 8
June 12, 2012 7
Aug. 6, 2013 7
Dec. 8, 2020 6
April 11, 1994 6
Nov. 1, 1985 6
Oct. 1, 1984 6
Nov. 6, 2012 6

`docket_suffix`

varchar

Sampled: 8.6K
Distinct: 0
Empty: 1.0

`spacing_to_lease_line`

int2

Sampled: 8.6K
Distinct: 49

330 3.2K
467 2.9K
660 1.4K
933 233
150 218
466 146
233 92
550 64
0 47
200 41
440 37
560 27

Take it away

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