Preview Oil Ledger

First 100 rows

Out of roughly 33.9K rows in texas.oil_ledger_field. Version obs-d67f9da4b83e.

First 100 rows of `texas.oil_ledger_field`, 53 columns wide
`district`	`field_no`	`field_name`	`county_code_1`	`county_code_2`	`county_code_3`	`county_code_4`	`county_code_5`	`county_code_6`	`disc_date`	`disc_date_raw`	`field_depth`	`oil_gravity`	`exempt`	`yard`	`test_codes`	`alloc_pct_1`	`alloc_code_1`	`alloc_pct_2`	`alloc_code_2`	`gor_amt`	`top_allow_amt`	`unit_net`	`tol_code`	`tol_amt`	`spacing_lease_line`	`spacing_well`	`diagonal`	`cum_prod`	`casing`	`col_head`	`allocation_code`	`remarks_1`	`remarks_2`	`permanent_field_no`	`annual_a`	`annual_b`
01	2001	WILDCAT	0	13	21	27	29	31	April 1, 1972	19720401	99999	0	0	0	100000200000	0.99	1	0.00	0	2000	0	0	0	0	0	0	0	28954	null	A	A	null	null	null	null	null
01	2999	WILDCAT-COMMISSION USE ONLY	137	0	0	0	0	0	Aug. 11, 2004	20040811	0	10	0	2	000100000200	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	0	null	A	A	null	null	null	null	null
01	256500	A.W.P. (OLMOS)	311	283	0	0	0	0	Dec. 20, 1981	19811220	9800	380	0	0	000100000200	0.99	2	0.00	0	2000	272	80	0	20	330	0	0	50259250	null	B	B	null	null	null	null	null
01	256600	A.W.P. (WALES)	311	0	0	0	0	0	March 4, 1988	19880304	6130	480	0	2	000100000200	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	47011	null	A	A	null	null	null	null	null
01	256700	A.W.P. (WILCOX)	311	0	0	0	0	0	Sept. 27, 1987	19870927	6658	386	0	2	000100000200	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	1799	null	A	A	null	null	null	null	null
01	256750	A.W.P. (WILCOX 6200)	311	0	0	0	0	0	Nov. 16, 2002	20021116	6192	340	0	2	000100000200	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	54765	null	A	A	null	null	null	null	null
01	434333	ACEITUNA (HARPER SD.)	127	0	0	0	0	0	Feb. 5, 1958	19580205	4032	490	0	0	000001000002	0.99	1	0.00	0	2000	73	0	0	0	0	0	0	11390	null	A	A	null	null	null	null	null
01	434666	ACEITUNA (OLMOS)	127	0	0	0	0	0	July 29, 1957	19570729	4205	370	0	0	000001000002	0.99	1	0.00	0	2000	73	0	0	0	0	0	0	120231	null	A	A	null	null	null	null	null
01	467500	ACLETO CREEK (POTH SAND)	493	0	0	0	0	0	March 16, 1952	19520316	3068	540	0	0	010000020000	0.99	1	0.00	0	2000	64	10	1	0	233	466	1100	312028	TDWR	A	A	null	null	null	null	null
01	467505	ACLETO CREEK (POTH A)	493	0	0	0	0	0	April 1, 1981	19810401	2838	480	0	2	010000020000	0.99	2	0.00	0	2000	54	10	0	5	233	467	1100	939458	null	A	B	null	null	null	null	null
01	467510	ACLETO CREEK (POTH B)	493	0	0	0	0	0	April 1, 1981	19810401	2881	350	0	2	010000020000	0.99	2	0.00	0	2000	54	10	0	5	233	467	1100	442311	null	A	B	null	null	null	null	null
01	467515	ACLETO CREEK (POTH C)	493	0	0	0	0	0	April 1, 1981	19810401	2915	402	0	2	010000020000	0.99	2	0.00	0	2000	54	10	0	5	233	467	1100	215456	null	A	B	null	null	null	null	null
01	621200	ADAMS (BUDA)	325	0	0	0	0	0	Aug. 20, 1976	19760820	1822	280	0	0	020000010000	0.99	2	0.00	0	2000	21	5	0	2	233	330	1200	509802	TDWR	A	B	null	null	null	null	null
01	621333	ADAMS (NAVARRO, UPPER)	325	0	0	0	0	0	April 2, 1958	19580402	382	220	0	2	020000010000	0.99	2	0.00	0	2000	21	2	0	1	150	300	467	64971	null	A	B	null	null	null	null	null
01	748500	ADDISON (NAVARRO)	21	0	0	0	0	0	March 16, 1956	19560316	4474	430	0	0	000020000010	0.99	1	0.00	0	2000	73	0	0	0	0	0	0	161	null	A	A	null	null	null	null	null
01	1057500	ALAMO, S. (OLMOS-BOOTH)	311	0	0	0	0	0	Jan. 31, 1984	19840131	9768	568	0	2	000100000200	0.99	1	0.00	0	2000	172	0	0	0	0	0	0	1329	null	A	A	null	null	null	null	null
01	1313500	ALDERMAN (AUSTIN)	187	0	0	0	0	0	Feb. 13, 1966	19660213	1949	230	0	0	010000020000	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	1738	null	A	A	null	null	null	null	null
01	1780300	ALLIGATOR SLOUGH (BRACERO)	507	0	0	0	0	0	June 2, 1990	19900602	3589	290	0	2	000001000002	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	1653	null	A	A	null	null	null	null	null
01	1780500	ALLIGATOR SLOUGH (ELAINE)	507	0	0	0	0	0	March 16, 1980	19800316	3691	278	0	2	000001000002	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	533187	null	A	A	null	null	null	null	null
01	2031001	ALTA VISTA	29	0	0	0	0	0	null	19150000	1100	120	0	2	002000001000	0.99	1	0.00	0	2000	74	2	1	0	150	300	0	75970	TDWR	A	A	null	null	null	null	null
01	2396500	AMMANN (BUDA)	127	507	0	0	0	0	Jan. 30, 1977	19770130	5900	380	0	2	000001000002	0.99	2	0.00	0	2000	102	80	0	40	330	0	0	220286	null	A	B	null	null	null	null	null
01	2564001	ANCHORAGE	13	0	0	0	0	0	Jan. 16, 1952	19520116	2298	470	0	0	001000002000	0.99	1	0.00	0	2000	55	0	0	0	0	0	0	87573	null	A	A	null	null	null	null	null
01	2663500	ANDERSON RANCH (SAN MIGUEL)	507	0	0	0	0	0	April 12, 1974	19740412	552	600	0	2	000001000002	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	1688	null	A	A	null	null	null	null	null
01	2769200	ANDY BROWN (BUDA)	493	0	0	0	0	0	April 24, 1985	19850424	5305	199	0	2	010000020000	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	29784	null	A	A	null	null	null	null	null
01	3375500	ARBUCKLE (AUSTIN CHALK)	21	0	0	0	0	0	Jan. 1, 1979	19790101	1749	248	0	2	000020000010	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	306	null	A	A	null	null	null	null	null
01	3806200	ARNOLD-WELDON (B-2)	311	0	0	0	0	0	Aug. 26, 1962	19620826	3481	270	0	0	000100000200	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	232062	null	A	A	null	null	null	null	null
01	3806400	ARNOLD-WELDON (WALES SAND)	311	0	0	0	0	0	July 2, 1963	19630702	5406	400	0	0	000100000200	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	190339	null	A	A	null	null	null	null	null
01	3806600	ARNOLD-WELDON (WRIGHT)	311	0	0	0	0	0	July 10, 1963	19630710	5886	360	0	0	000100000200	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	550331	null	A	A	null	null	null	null	null
01	3806800	ARNOLD-WELDON (WRIGHT S SEG)	311	0	0	0	0	0	Aug. 24, 1963	19630824	5938	380	0	0	000100000200	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	563217	null	A	A	null	null	null	null	null
01	3946500	ARROYO NEGRO (AUSTIN CHALK)	507	0	0	0	0	0	Dec. 12, 1976	19761212	6589	330	0	2	000001000002	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	7073	null	A	A	null	null	null	null	null
01	4078666	ASHERTON (OLMOS 3-A)	127	0	0	0	0	0	Aug. 28, 1955	19550828	3322	400	0	0	000001000002	0.99	1	0.00	0	2000	64	0	0	0	0	0	0	613	null	A	A	null	null	null	null	null
01	4079530	ASHERTON,E. (OLMOS 4500)	127	0	0	0	0	0	Nov. 3, 1981	19811103	4533	484	0	2	000001000002	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	1727	null	A	A	null	null	null	null	null
01	4079540	ASHERTON, E. (OLMOS 4600)	127	0	0	0	0	0	Oct. 11, 1972	19721011	4601	366	0	2	000001000002	0.99	2	0.00	0	2000	93	20	0	10	330	933	1500	60326	TDWR	A	B	null	null	null	null	null
01	4300500	ATLEE (OLMOS)	283	0	0	0	0	0	null	0	7210	459	0	2	000100000200	0.50	1	0.50	2	2000	121	40	0	20	467	0	0	12357	null	A	C	null	null	null	null	null
01	4462333	AUSTIN PIERCE (AUSTIN CHALK)	177	13	123	0	283	0	Dec. 7, 1964	19641207	10856	430	0	0	010000020000	0.99	1	0.00	0	2000	212	0	0	0	0	0	0	264521	null	A	A	null	null	null	null	null
01	4462666	AUSTIN PIERCE (EDWARDS LIME)	177	0	0	0	0	0	Oct. 4, 1978	19781004	11558	380	0	2	010000020000	0.99	1	0.00	0	2000	262	0	0	0	0	0	0	62731	null	A	A	null	null	null	null	null
01	4668500	B B B (OLMOS A)	127	0	0	0	0	0	Sept. 14, 1987	19870914	3714	375	0	2	000001000002	0.99	2	0.00	0	2000	84	20	0	10	330	660	1500	99583	TDWR	A	B	null	null	null	null	null
01	4680700	BBJ (WILCOX 5700)	311	0	0	0	0	0	Nov. 2, 1984	19841102	5782	450	0	2	000100000200	0.00	0	0.00	0	2000	102	0	0	0	0	0	0	173443	null	A	null	null	null	null	null	null
01	4681700	BBJ, N. (WILCOX 5700)	311	0	0	0	0	0	Oct. 5, 1985	19851005	5779	450	0	2	000100000200	0.99	2	0.00	0	2000	135	40	0	20	467	1200	2100	158188	TDWR	A	B	null	null	null	null	null
01	4900500	BACKDRAFT (OLMOS)	163	0	0	0	0	0	Sept. 18, 2008	20080918	5796	340	0	2	000010000020	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	457071	null	A	A	null	null	null	null	null
01	5066001	BAILEYVILLE	331	0	0	0	0	0	null	19520000	630	220	0	0	000200000100	0.99	2	0.00	0	2000	74	2	0	1	150	300	467	405	null	A	B	null	null	null	null	null
01	5122750	BAKER (2500)	311	0	0	0	0	0	Jan. 24, 2013	20130124	2474	204	0	2	000100000200	0.99	1	0.00	0	2000	78	20	0	10	250	600	0	178467	null	A	A	null	null	null	null	null
01	5123444	BAKER (GOVT. WELLS, LOWER)	311	0	0	0	0	0	Jan. 16, 1976	19760116	3114	243	0	2	000100000200	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	17642	null	A	A	null	null	null	null	null
01	23561001	DAY	187	0	0	0	0	0	null	19400000	2640	380	0	0	010000020000	0.99	1	0.00	0	2000	45	0	0	0	0	0	0	6435	null	A	A	null	null	null	null	null
01	5440500	BANDERA TANK, WEST (2400)	507	0	0	0	0	0	Aug. 11, 1984	19840811	2451	227	0	2	000001000002	0.99	1	0.00	0	2000	78	0	0	0	0	0	0	960	null	A	A	null	null	null	null	null
01	5440520	BANDERA TANK, WEST (2500)	507	0	0	0	0	0	Aug. 11, 1984	19840811	2562	225	0	2	000001000002	0.99	1	0.00	0	2000	78	0	0	0	0	0	0	3771	null	A	A	null	null	null	null	null
01	5599500	BARBARAS PATCH (SAN MIGUEL)	323	0	0	0	0	0	July 1, 1964	19640701	1049	350	0	0	000001000002	0.99	2	0.00	0	2000	20	3	1	0	150	300	600	3642	null	A	B	null	null	null	null	null
01	5743500	BARNES (CHALK)	29	0	0	0	0	0	Jan. 5, 1983	19830105	1770	220	0	2	002000001000	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	687	null	A	A	null	null	null	null	null
01	5835700	BARRETT (WILCOX)	331	0	0	0	0	0	Oct. 4, 1982	19821004	2898	265	0	2	000200000100	0.99	1	0.00	0	2000	78	0	0	0	0	0	0	781	null	A	A	null	null	null	null	null
01	6011500	BASTROP (AUSTIN CHALK)	21	0	0	0	0	0	Jan. 26, 1957	19570126	2496	280	0	0	000020000010	0.99	1	0.00	0	2000	55	0	0	0	0	0	0	4236	null	A	A	null	null	null	null	null
01	6053001	BATEMAN	21	0	0	0	0	0	Sept. 4, 1932	19320904	2200	360	0	0	000020000010	0.00	0	0.00	0	2000	5	0	0	0	0	0	0	774053	null	A	null	null	null	null	null	null
01	6053500	BATEMAN (AUSTIN CHALK)	21	55	0	0	0	0	April 3, 1963	19630403	2234	370	0	0	000020000010	0.99	2	0.00	0	2000	45	5	0	2	100	0	750	1078170	null	A	B	null	null	null	null	null
01	6096250	BATESVILLE (BRACERO)	507	0	0	0	0	0	Sept. 1, 1971	19710901	3132	234	0	2	000001000002	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	106524	null	A	A	null	null	null	null	null
01	6101100	BATESVILLE, SOUTH (ANACACHO)	507	0	0	0	0	0	Feb. 2, 1981	19810202	4997	210	0	2	000001000002	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	268295	null	A	A	null	null	null	null	null
01	6101500	BATESVILLE, SOUTH (SAN MIGUEL)	507	0	0	0	0	0	Dec. 8, 1959	19591208	4400	280	0	0	000001000002	0.99	1	0.00	0	2000	73	0	0	0	0	0	0	326227	null	A	A	null	null	null	null	null
01	6101520	BATESVILLE,SOUTH(SAN MIGUEL,SEGA	507	0	0	0	0	0	Feb. 25, 1981	19810225	4390	302	0	2	000001000002	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	222680	null	A	A	null	null	null	null	null
01	6105700	BATESVILLE, SW. (SAN MIGUEL)	507	0	0	0	0	0	April 4, 1976	19760404	3360	270	0	2	000001000002	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	162208	null	A	A	null	null	null	null	null
01	6105750	BATESVILLE, SW. (SAN MIGUEL, LO)	507	0	0	0	0	0	Jan. 30, 1978	19780130	3303	314	0	2	000001000002	0.99	1	0.00	0	2000	84	0	0	0	0	0	0	24501	null	A	A	null	null	null	null	null
01	6469001	BEAR CREEK	325	13	163	0	0	0	Sept. 1, 1947	19470901	2209	390	1	0	020000010000	0.99	2	0.00	0	2000	55	20	0	10	233	467	1500	2751967	TDWR	A	B	null	null	null	null	null
01	6483550	BEAR SALT (OLMOS)	507	0	0	0	0	0	Aug. 2, 1982	19820802	2684	139	0	2	000001000002	0.99	1	0.00	0	2000	78	0	0	0	0	0	0	1	null	A	A	null	null	null	null	null
01	6582500	BEBE (AUSTIN CHALK)	177	0	0	0	0	0	June 2, 1977	19770602	6244	300	0	2	010000020000	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	59386	null	A	A	null	null	null	null	null
01	6727001	BEE CREEK	55	21	0	0	0	0	null	19320000	2095	390	0	0	000020000010	0.99	1	0.00	0	2000	55	0	0	0	0	0	0	391565	null	A	A	null	null	null	null	null
01	6973500	BELMONT (POTH)	177	0	0	0	0	0	April 20, 1968	19680420	1883	210	0	2	010000020000	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	8477	null	A	A	null	null	null	null	null
01	7137500	BENNER (NAVARRO)	55	0	0	0	0	0	Feb. 23, 1969	19690223	794	240	0	2	000020000010	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	0	null	A	A	null	null	null	null	null
01	7210500	BENTON CITY (ANACACHO)	13	0	0	0	0	0	null	0	1853	232	0	2	001000002000	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	352	null	A	A	null	null	null	null	null
01	7220500	BENTON CITY S, (ANACACHO)	13	325	0	0	0	0	Dec. 28, 1980	19801228	2049	232	0	0	001000002000	0.99	1	0.00	0	2000	78	20	1	0	330	660	0	35194	TDWR	A	A	null	null	null	null	null
01	7670001	BEYERSVILLE, SW.	491	0	0	0	0	0	June 12, 1949	19490612	1115	380	0	0	000200000100	0.99	1	0.00	0	2000	37	10	1	0	233	466	1100	28241	null	A	A	null	null	null	null	null
01	7850001	BIG FOOT	163	13	0	325	0	0	Feb. 2, 1949	19490202	3280	440	0	0	000010000020	0.99	2	0.00	0	2000	64	20	1	10	233	330	1500	35400947	TDWR	A	B	null	null	null	null	null
01	7850200	BIG FOOT (AUSTIN CHALK)	13	0	0	0	0	0	Nov. 22, 1976	19761122	5126	340	0	2	001000002000	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	755	null	A	A	null	null	null	null	null
01	7850250	BIG FOOT (GEORGETOWN)	163	0	0	0	0	0	July 19, 2019	20190719	4028	330	0	2	000010000020	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	112	null	A	A	null	null	null	null	null
01	7850666	BIG FOOT (OLMOS D-3 SAND)	163	13	0	325	0	0	June 17, 1953	19530617	3504	390	0	0	000010000020	0.99	2	0.00	0	2000	64	20	0	10	233	330	1500	2291877	TDWR	A	B	null	null	null	null	null
01	8001260	BIG MULE (OLMOS 8850)	311	0	0	0	0	0	null	0	8866	429	0	2	000100000200	0.99	1	0.00	0	2000	142	0	0	0	0	0	0	11967	null	A	A	null	null	null	null	null
01	8001600	BIG MULE (WILCOX 5100)	311	0	0	0	0	0	Nov. 23, 1981	19811123	5102	432	0	2	000100000200	0.99	2	0.00	0	2000	102	0	1	0	0	0	0	104560	null	A	B	null	null	null	null	null
01	8001650	BIG MULE (WILCOX 5600)	311	0	0	0	0	0	Aug. 31, 1983	19830831	5624	430	0	2	000100000200	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	4857	null	A	A	null	null	null	null	null
01	8001700	BIG MULE (5500 SAND)	311	0	0	0	0	0	Jan. 24, 1983	19830124	5556	450	0	2	000100000200	0.99	2	0.00	0	2000	102	40	0	20	467	933	2500	1213060	null	A	B	null	null	null	null	null
01	8034500	BIG SANDY CREEK (DALE)	21	0	0	0	0	0	June 10, 1985	19850610	2716	286	0	2	000020000010	0.99	1	0.00	0	2000	78	0	0	0	0	0	0	1481	null	A	A	null	null	null	null	null
01	8069100	BIG WELLS (AUSTIN CHALK)	127	0	0	0	0	0	Dec. 9, 1976	19761209	6950	330	0	2	000001000002	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	37881	null	A	A	null	null	null	null	null
01	8072250	BIG WELLS (OLMOS SAND)	127	0	0	0	0	0	Aug. 21, 1958	19580821	4249	340	0	0	000001000002	0.99	1	0.00	0	2000	73	0	0	0	0	0	0	29403	null	A	A	null	null	null	null	null
01	8072500	BIG WELLS (SAN MIGUEL)	127	323	507	0	0	0	April 18, 1970	19700418	5425	334	0	0	000001000002	0.99	2	0.00	0	500	171	80	0	40	467	1200	3250	59959503	TDWR	B	B	null	null	null	null	null
01	8072750	BIG WELLS(SAN MIGUEL, LO., EAST)	127	0	0	0	0	0	March 26, 1971	19710326	5754	320	0	2	000001000002	0.99	2	0.00	0	2000	171	80	0	40	660	1320	3250	6738929	TDWR	B	B	null	null	null	null	null
01	8073500	BIG WELLS, E. (UPPER SAN MIGUEL)	127	0	0	0	0	0	April 15, 1987	19870415	5610	340	0	2	000001000002	0.99	1	0.00	0	2000	102	0	0	0	0	0	0	531	null	A	A	null	null	null	null	null
01	8075333	BIG WELLS, NE. (OLMOS)	507	127	0	0	0	0	June 17, 1970	19700617	4708	330	0	2	000001000002	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	824	null	A	A	null	null	null	null	null
01	8075666	BIG WELLS, NE. (SAN MIGUEL)	507	127	0	0	0	0	April 18, 1969	19690418	5435	358	0	2	000001000002	0.99	2	0.00	0	2000	171	80	0	40	660	1320	3250	1340307	TDWR	A	B	null	null	null	null	null
01	8159325	BILL RICHARDSON (ESCONDIDO)	13	0	0	0	0	0	Sept. 3, 1985	19850903	4620	385	0	2	001000002000	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	4189	null	A	A	null	null	null	null	null
01	8159500	BILL RICHARDSON (NAVARRO SD.)	13	0	0	0	0	0	Feb. 20, 1954	19540220	5424	380	0	0	001000002000	0.99	1	0.00	0	2000	82	0	0	0	0	0	0	78982	null	A	A	null	null	null	null	null
01	8240500	BILLY HOLLAND	137	0	0	0	0	0	Dec. 13, 1948	19481213	540	200	0	0	200000100000	0.99	1	0.00	0	2000	18	2	1	0	150	300	0	0	SEE FIELD RULES	A	A	null	null	null	null	null
01	8527400	BLACK HILLS (ANACACHO)	13	0	0	0	0	0	July 29, 1975	19750729	6220	260	0	2	001000002000	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	575	null	A	A	null	null	null	null	null
01	8527500	BLACK HILLS (AUSTIN CHALK)	13	0	0	0	0	0	April 27, 1975	19750427	6384	260	0	2	001000002000	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	8479	null	A	A	null	null	null	null	null
01	8527600	BLACK HILLS (BUDA)	13	493	0	0	0	0	Dec. 20, 1976	19761220	7082	320	0	2	001000002000	0.99	1	0.00	0	2000	121	0	0	0	0	0	0	74252	null	A	A	null	null	null	null	null
01	8532400	BLACK HILLS, SOUTH (BUDA)	13	0	0	0	0	0	Sept. 1, 1977	19770901	7228	360	0	2	001000002000	0.99	1	0.00	0	2000	121	0	0	0	0	0	0	15730	null	A	A	null	null	null	null	null
01	8539500	BLACK ROCK (SAN MIGUEL)	323	0	0	0	0	0	May 31, 1982	19820531	1720	340	0	2	000001000002	0.99	1	0.00	0	2000	74	0	0	0	0	0	0	4944	null	A	A	null	null	null	null	null
01	8575800	BLACKJACK (WILCOX)	13	0	0	0	0	0	Nov. 18, 1983	19831118	5624	413	0	2	001000002000	0.00	0	0.00	0	2000	102	0	0	0	0	0	0	24517	null	A	null	null	null	null	null	null
01	8713499	BLAKEWAY (DIXON SAND)	127	0	0	0	0	0	Sept. 14, 1979	19790914	4546	460	0	2	000001000002	0.99	2	0.00	0	2000	93	80	0	40	467	1200	3500	386818	null	A	B	null	null	null	null	null
01	8713550	BLAKEWAY (OLMOS A)	127	0	0	0	0	0	Jan. 23, 1986	19860123	4492	433	0	2	000001000002	0.99	1	0.00	0	2000	93	0	0	0	0	0	0	24848	null	A	A	null	null	null	null	null
01	8713600	BLAKEWAY (STRICKLAND SAND)	127	0	0	0	0	0	Oct. 1, 1981	19811001	4580	507	0	2	000001000002	0.99	2	0.00	0	2000	93	80	0	40	660	1867	3500	5856	SEE FIELD RULES	A	B	null	null	null	null	null
01	8749666	BLANCH (OLMOS)	127	0	0	0	0	0	May 30, 1959	19590530	1951	390	0	0	000001000002	0.99	1	0.00	0	2000	46	0	0	0	0	0	0	73167	null	A	A	null	null	null	null	null
01	8859100	BLEDSOE-EROG (BUDA)	177	0	0	0	0	0	Aug. 3, 1981	19810803	7300	236	0	2	010000020000	0.99	1	0.00	0	2000	121	0	0	0	0	0	0	1394	null	A	A	null	null	null	null	null
01	9895450	BLUE TIE AFFAIR (W-15)	311	0	0	0	0	0	Nov. 1, 2005	20051101	6414	370	0	2	000100000200	0.99	1	0.00	0	2000	111	0	0	0	0	0	0	6676	null	A	A	null	null	null	null	null
01	10003333	BOB HINDES (2100)	13	0	0	0	0	0	Oct. 16, 1954	19541016	2099	190	0	0	001000002000	0.99	1	0.00	0	2000	55	0	0	0	0	0	0	25234	null	A	A	null	null	null	null	null
01	10003666	BOB HINDES (2100 SEG. B)	13	0	0	0	0	0	Oct. 8, 1962	19621008	2096	190	0	0	001000002000	0.99	1	0.00	0	2000	75	0	0	0	0	0	0	126603	null	A	A	null	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: 33.9K
Distinct: 13

04 5.8K
03 4.8K
07B 4.8K
09 3.9K
02 3.3K
08 3.1K
07C 2.5K
08A 1.9K
06 1.5K
01 1.4K
10 740
05 366

`field_no`

int4

Sampled: 33.9K
Distinct: 33.9K

21023001 1
68227001 1
98085650 1
4640500 1
88733225 1
79002100 1
51152660 1
95122050 1
37167300 1
67623001 1
75961750 1
78459750 1

`operator_no`

int4

Sampled: 33.9K
Distinct: 1

0 33.9K

`lease_no`

int4

Sampled: 33.9K
Distinct: 1

0 33.9K

`offshore`

int2

Sampled: 33.9K
Distinct: 5

0 33.5K
1 295
2 104
4 31
5 2

`field_name`

varchar

Sampled: 33.9K
Distinct: 33.9K

WILDCAT-COMMISSION USE ONLY 21
WILDCAT 12
WEST 2
GREEN LAKE 2
BRIDGES 2
PONLAW (SOMA) 2
SHEPHERD-WOOD (MORRIS) 2
KING 2
BUFFALO CAMP, N (FRIO 10,300-B) 2
MARSTON RANCH (ELLENBURGER) 2
DAY 2
MCELROY (WOLFCAMP) 2

`county_code_1`

int2

Sampled: 33.9K
Distinct: 222

355 1.1K
239 712
399 709
427 699
409 664
273 636
503 634
237 580
131 579
469 537
391 535
71 515

`county_code_2`

int2

Sampled: 33.9K
Distinct: 203

0 31K
273 196
103 90
371 67
249 64
135 64
237 61
3 60
247 58
409 57
475 49
33 47

Take it away

Back to everything we know about Oil Ledger