Preview Gas Ledger

First 100 rows

Out of roughly 42.1K rows in texas.gas_ledger_field. Version obs-aac881eb6c20.

First 100 rows of `texas.gas_ledger_field`, 47 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_type`	`allow_class`	`allocation_code`	`spacing_line`	`spacing_well`	`col_head`	`test_codes`	`cum_gas_prod`	`cum_cond_prod`	`unit_acres`	`unit_tol`	`allocation`	`casing`	`diag_type`	`diag_info`	`field_depth`	`wells`	`allow_calc`	`exempt_balance`	`pending_spec_lmt_allow`	`cum_prod_prior_70`	`cum_prod_error_sw`	`line_info_1`	`line_info_2`	`line_info_3`	`line_info_4`
01	2001	WILDCAT	0	13	137	265	311	323	Jan. 3, 1958	19580103	A	S	null	0	0	5	J K	668035	20279	0	0	000000000000000	null	null	null	364	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	256500	A.W.P. (OLMOS)	311	283	0	0	0	0	Sept. 1, 1982	19820901	A	F	null	330	0	1	C C	395845596	7767375	80	0	100190000000000	TDWR	null	03250	9446	447	351989	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	256600	A.W.P. (WALES)	311	0	0	0	0	0	Aug. 31, 2005	20050831	A	O	null	0	0	5	C C	423477	2357	0	0	000000000000000	null	null	null	9629	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	256700	A.W.P. (WILCOX)	311	0	0	0	0	0	Sept. 27, 1987	19870927	A	O	null	0	0	9	C C	107857	1187	0	0	000000000000000	null	null	null	6852	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	256750	A.W.P. (WILCOX 6200)	311	0	0	0	0	0	Feb. 15, 1988	19880215	A	null	null	0	0	9	J K	771141	2503	0	0	000000000000000	null	null	null	6166	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	464100	ACLETO (AUSTIN CHALK)	493	0	0	0	0	0	April 23, 1981	19810423	N	O	null	0	0	9	B B	6248	1516	0	0	000000000000000	null	null	null	7448	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	467500	ACLETO CREEK (POTH SAND)	493	0	0	0	0	0	Feb. 27, 1990	19900227	A	O	null	330	660	9	C C	0	0	40	0	000000000000000	null	null	01100	2812	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	517500	ACORN (EAGLE FORD)	283	479	0	0	0	0	Aug. 26, 2009	20090826	N	O	null	0	0	5	C C	749077	22422	0	0	000000000000000	null	null	null	10978	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	621666	ADAMS (OLMOS NAVARRO)	325	0	0	0	0	0	July 26, 1956	19560726	N	S	null	0	0	5	C C	2018755	25	0	0	000000000000000	null	null	null	850	5	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	925400	AIRPORT (GLEN ROSE)	323	0	0	0	0	0	Nov. 15, 1973	19731115	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	5885	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	930050	AIRSTRIP (BRACERO)	507	0	0	0	0	0	Feb. 23, 1984	19840223	N	O	null	0	0	5	C C	74085	0	0	0	000000000000000	null	null	null	3530	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	930500	AIRSTRIP (3690)	507	0	0	0	0	0	March 25, 1980	19800325	N	O	null	0	0	9	B B	301389	0	0	0	000000000000000	null	null	null	3690	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	931300	AIRSTRIP, E. (ELAINE)	507	0	0	0	0	0	Jan. 12, 1981	19810112	N	S	null	0	0	5	C C	15500	0	0	0	000000000000000	null	null	null	3846	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	1780300	ALLIGATOR SLOUGH (BRACERO)	507	0	0	0	0	0	April 11, 1980	19800411	A	S	null	0	0	5	C C	861138	0	0	0	000000000000000	null	null	null	3455	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	1780500	ALLIGATOR SLOUGH (ELAINE)	507	0	0	0	0	0	Oct. 5, 1982	19821005	A	null	null	0	0	6	J K	10872	117	0	0	000000000000000	null	null	null	3687	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	1780700	ALLIGATOR SLOUGH (OLMOS)	507	0	0	0	0	0	April 11, 1980	19800411	N	O	null	0	0	5	B B	364563	0	0	0	000000000000000	null	null	null	2925	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2075500	ALTIZER (CANYON LOWER)	465	0	0	0	0	0	Jan. 19, 2008	20080119	N	S	null	0	0	9	C C	247774	6	0	0	000000000000000	null	null	null	13436	2	0	0	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2075600	ALTIZER (CANYON UPPER)	465	0	0	0	0	0	April 6, 2007	20070406	N	O	null	0	0	5	C C	10999	0	0	0	000000000000000	null	null	null	12670	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2271500	AMBERSON (WILCOX)	283	0	0	0	0	0	May 21, 1954	19540521	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	4421	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2396500	AMMANN (BUDA)	127	283	311	479	0	0	Aug. 6, 2013	20130806	A	O	null	330	0	5	C C	238976	36524	80	8	100020000000000	null	null	99999	5800	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2414200	AMY-J (ESCONDIDO)	323	0	0	0	0	0	Nov. 25, 1974	19741125	N	S	null	0	0	5	C C	59813	0	0	0	000000000000000	null	null	null	814	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2414300	AMY-J (1590)	323	0	0	0	0	0	Sept. 27, 1977	19770927	N	O	null	467	1200	9	C C	20016	0	40	0	100190000000000	TDWR	null	00000	1584	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2433075	AN EXPLOITED STORM (CARRIZO)	311	0	0	0	0	0	July 8, 2005	20050708	N	O	null	0	0	5	C C	199989	0	0	0	000000000000000	null	null	null	3088	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	2568001	ANCHORAGE, SOUTH	13	0	0	0	0	0	May 30, 1959	19590530	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	3748	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	3008375	ANNA CHAPMAN (SAN MIGUEL)	507	0	0	0	0	0	Aug. 23, 2001	20010823	N	O	null	0	0	5	C C	65731	0	0	0	000000000000000	null	null	null	2414	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	3144500	ANTLER (2800)	127	0	0	0	0	0	Dec. 12, 1955	19551212	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	2869	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	3328600	APPURCEON (OLMOS)	127	0	0	0	0	0	Nov. 3, 1980	19801103	N	S	null	0	0	9	C C	3939982	35931	0	0	000000000000000	null	null	null	4708	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	3650500	ARMER SOUTH (ELLENBURGER)	137	0	0	0	0	0	April 28, 2008	20080428	N	O	null	0	0	5	C C	736397	0	0	0	000000000000000	null	null	null	9215	1	124	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	3950500	ARTESIA WELLS, W. (WILCOX 3630)	283	0	0	0	0	0	Sept. 5, 1967	19670905	N	O	null	0	0	9	B B	3035887	363	0	0	000000000000000	null	null	null	4500	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4078333	ASHERTON (OLMOS 1ST)	127	0	0	0	0	0	Jan. 9, 1968	19680109	N	S	null	0	0	0	C C	242032	943	0	0	000000000000000	null	null	null	3456	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4079500	ASHERTON, E (OLMOS)	127	0	0	0	0	0	Jan. 26, 1968	19680126	N	S	null	0	0	5	C C	76355	767	0	0	000000000000000	null	null	null	4315	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4276400	ATKINSON NW (4000-RECKLAW)	13	0	0	0	0	0	Oct. 21, 1980	19801021	N	S	null	0	0	5	C C	19762	102	0	0	000000000000000	null	null	null	4008	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4300500	ATLEE (OLMOS)	283	311	0	0	0	0	Oct. 13, 1983	19831013	A	F	null	467	0	5	C C	19393032	221877	40	4	050020502100000	TDWR	null	02100	7460	49	14542	1	2	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4391500	AULD-SHIPMAN (PEARSALL)	283	0	0	0	0	0	June 5, 1962	19620605	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	11710	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4462666	AUSTIN PIERCE (EDWARDS LIME)	177	0	0	0	0	0	Aug. 12, 1961	19610812	A	S	null	0	0	5	C C	5652093	61588	0	0	000000000000000	null	null	null	11453	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4488800	AUZIE (SAN MIGUEL-1)	507	0	0	0	0	0	Feb. 28, 1984	19840228	N	O	null	0	0	5	C C	81620	0	0	0	000000000000000	null	null	null	2558	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	4681700	BBJ, N. (WILCOX 5700)	311	0	0	0	0	0	Oct. 14, 2006	20061014	A	O	null	467	1200	1	C C	12918	2169	40	0	100190000000000	null	null	02100	5609	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5122400	BAKER (SLICK)	311	297	0	0	0	0	Sept. 15, 1975	19750915	N	F	null	467	1200	9	C C	31401134	449981	40	4	100190000000000	TDWR	2	100	8000	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5122450	BAKER (1700)	311	0	0	0	0	0	May 31, 2000	20000531	N	O	null	0	0	5	C C	21711	0	0	0	000000000000000	null	null	null	1718	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5122500	BAKER (1800)	311	0	0	0	0	0	Aug. 11, 1951	19510811	N	S	null	0	0	5	C C	284983	0	0	0	000000000000000	null	null	null	1820	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5122750	BAKER (2500)	311	0	0	0	0	0	April 14, 1998	19980414	A	null	null	250	600	6	J K	198951	3271	40	0	000000000000000	null	null	00000	2490	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5123766	BAKER (2100)	311	0	0	0	0	0	July 10, 1994	19940710	N	O	null	0	0	5	C C	1123847	40	0	0	000000000000000	null	null	null	2108	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5127500	BAKER (ESCONDIDO 900)	127	0	0	0	0	0	Aug. 24, 1982	19820824	N	O	null	0	0	5	B B	72187	0	0	0	000000000000000	null	null	null	945	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5410500	BANDERA (ELLENBURGER)	19	0	0	0	0	0	Jan. 3, 2008	20080103	N	O	null	0	0	5	C C	393965	85	0	0	000000000000000	null	null	null	3765	1	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5434500	BANDERA TANK (SAN MIGUEL)	507	0	0	0	0	0	June 11, 1958	19580611	N	S	null	0	0	5	C C	1349191	0	0	0	000000000000000	null	null	null	2536	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5438500	BANDERA TANK, NW. (SAN MIGUEL)	507	0	0	0	0	0	July 31, 1966	19660731	N	F	null	467	1200	9	C C	20629346	139	40	0	100190000000000	TDWR	null	00000	2358	1	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5599400	BARBARAS PATCH (GLENROSE, LO.)	323	0	0	0	0	0	Dec. 1, 1977	19771201	N	S	null	0	0	5	C C	777721	0	0	0	000000000000000	null	null	null	7230	0	0	1	1	1103058	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5630100	BARBER	127	0	0	0	0	0	Jan. 10, 1980	19800110	N	O	null	0	0	9	B B	562936	4746	0	0	000000000000000	null	null	null	3479	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	5809700	BARRANCA (SLICK)	311	0	0	0	0	0	June 21, 1980	19800621	N	O	null	0	0	9	C C	3963083	16290	0	0	000000000000000	null	null	null	8320	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6096500	BATESVILLE (OLMOS)	507	0	0	0	0	0	null	0	N	O	null	0	0	9	B B	1784671	0	0	0	000000000000000	null	null	null	0	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6096750	BATESVILLE (SAN MIGUEL)	507	0	0	0	0	0	Dec. 18, 1969	19691218	N	S	null	0	0	9	C C	3044493	881	0	0	000000000000000	null	null	null	3033	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6099500	BATESVILLE, NE. (ANACACHO)	507	0	0	0	0	0	Jan. 22, 1963	19630122	N	S	null	0	0	5	C C	112719	665	0	0	000000000000000	null	null	null	1910	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6105700	BATESVILLE, SW. (SAN MIGUEL)	507	0	0	0	0	0	April 8, 1976	19760408	A	null	null	0	0	6	J K	120365	503	0	0	000000000000000	null	null	null	3184	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6107250	BATESVILLE, WEST (BRACERO)	507	0	0	0	0	0	Sept. 14, 1977	19770914	N	O	null	0	0	9	B B	256195	0	0	0	000000000000000	null	null	null	3040	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6107300	BATESVILLE, WEST (DEL MONTE)	507	0	0	0	0	0	Oct. 2, 1977	19771002	N	O	null	0	0	5	B B	224609	0	0	0	000000000000000	null	null	null	2926	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6107500	BATESVILLE, WEST (OLMOS)	507	0	0	0	0	0	May 26, 1977	19770526	N	O	null	0	0	5	B B	764063	0	0	0	000000000000000	null	null	null	3200	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	11801370	BRENNAN BROSIER (RODESSA, UP.)	323	0	0	0	0	0	Feb. 14, 1996	19960214	N	O	null	0	0	5	C C	296450	0	0	0	000000000000000	null	null	null	4955	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6262200	BAXTER-WENTWORTH (CANYON SAND)	465	0	0	0	0	0	Sept. 21, 1983	19830921	N	F	null	933	1867	1	C C	8267352	213	160	16	100020000000000	TDWR	null	04500	3700	12	2238	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6457375	BEANO (STRAWN)	137	0	0	0	0	0	Dec. 31, 1997	19971231	N	F	null	0	0	5	C C	5847157	0	0	0	000000000000000	null	null	null	9467	5	186	1	2	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6483500	BEAR SALT (BASALT)	507	0	0	0	0	0	June 11, 1964	19640611	N	S	null	0	0	5	C C	0	0	0	0	000000000000000	null	null	null	2086	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6483600	BEAR SALT (SAN MIGUEL)	507	0	0	0	0	0	Dec. 16, 1981	19811216	N	S	null	0	0	5	C C	1855896	0	0	0	000000000000000	null	null	null	2107	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6490500	BEAR SALT, SOUTH (SAN MIGUEL)	507	0	0	0	0	0	Feb. 15, 1982	19820215	N	O	null	0	0	5	B B	6531	0	0	0	000000000000000	null	null	null	2884	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	6924300	BELLE BRANCH	13	0	0	0	0	0	Sept. 19, 1973	19730919	N	O	null	150	467	1	C C	353172	0	10	1	100020000000000	TDWR	1	500	452	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7210500	BENTON CITY (ANACACHO)	13	325	0	0	0	0	Feb. 9, 1980	19800209	A	S	null	0	0	9	C C	92259	90	0	0	000000000000000	null	null	null	1631	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7210600	BENTON CITY (OLMOS)	13	0	0	0	0	0	Aug. 7, 1980	19800807	N	S	null	0	0	5	C C	57010	0	0	0	000000000000000	null	null	null	1528	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7220500	BENTON CITY S, (ANACACHO)	13	0	0	0	0	0	July 30, 1980	19800730	A	null	null	330	660	6	J K	153605	0	20	10	100020000000000	TDWR	1	500	2007	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7220700	BENTON CITY, SOUTH (SAN MIGUEL)	13	0	0	0	0	0	May 8, 1981	19810508	N	O	null	0	0	5	B B	9439	0	0	0	000000000000000	null	null	null	1774	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7370300	BERRY (FRIO)	163	0	0	0	0	0	Aug. 16, 1977	19770816	N	O	null	0	0	9	C C	1410474	833	0	0	000000000000000	null	null	null	3330	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7516400	BETH (OLMOS 2-B SAND)	127	0	0	0	0	0	Oct. 2, 2018	20181002	N	O	null	0	0	5	C C	100532	0	0	0	000000000000000	null	null	null	2240	1	992	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7516500	BETH (OLMOS 3-B SAND)	127	0	0	0	0	0	April 1, 2016	20160401	N	O	null	0	0	5	C C	174469	0	0	0	000000000000000	null	null	null	2286	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7743400	BIG ALAMO (5550)	283	311	0	0	0	0	March 6, 1987	19870306	N	O	null	0	0	5	C C	457178	4705	0	0	000000000000000	null	null	null	5553	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7743425	BIG ALAMO (5626)	283	0	0	0	0	0	May 16, 1988	19880516	N	O	null	0	0	9	C C	31138	582	0	0	000000000000000	null	null	null	5626	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7743450	BIG ALAMO (5840)	283	0	0	0	0	0	June 24, 1987	19870624	N	O	null	0	0	5	C C	41034	1010	0	0	000000000000000	null	null	null	5839	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7850001	BIG FOOT	163	0	0	0	0	0	May 6, 1980	19800506	A	S	null	330	933	1	C C	371926	0	20	2	000000000000000	null	5	00	3005	1	279	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7850333	BIG FOOT (OLMOS)	163	0	0	0	0	0	Nov. 13, 1952	19521113	N	S	null	0	0	5	C C	118021	0	0	0	000000000000000	null	null	null	3139	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7851270	BIG FOOT, N. (OLMOS)	163	0	0	0	0	0	Feb. 9, 1999	19990209	N	O	null	0	0	5	C C	91285	0	0	0	000000000000000	null	null	null	2701	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	7856250	BIG FOOT, WEST (GAS)	163	0	0	0	0	0	Nov. 13, 1952	19521113	N	F	null	467	2200	1	C C	47759763	644	213	21	100020000000000	SEE FIELD RULES	X	5000	2982	26	0	1	2	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8001600	BIG MULE (WILCOX 5100)	311	0	0	0	0	0	Dec. 1, 1986	19861201	A	O	null	0	0	5	C C	20790	0	0	0	000000000000000	null	null	null	5096	0	0	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8001700	BIG MULE (5500 SAND)	311	0	0	0	0	0	Sept. 8, 1983	19830908	A	null	null	467	933	6	J K	3588032	18490	40	0	000000000000000	TDWR	null	02500	5225	0	0	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8072500	BIG WELLS (SAN MIGUEL)	127	507	0	0	0	0	Jan. 16, 1969	19690116	A	null	null	467	1200	6	J K	30873009	239154	80	40	000000000000000	null	3	250	5360	7	7130	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8075666	BIG WELLS, NE. (SAN MIGUEL)	507	0	0	0	0	0	Jan. 16, 1969	19690116	A	null	null	660	1320	6	J K	0	0	80	40	000000000000000	null	3	250	5360	0	0	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8713499	BLAKEWAY (DIXON SAND)	127	0	0	0	0	0	Oct. 25, 1984	19841025	A	null	null	467	1200	6	J K	389303	10691	80	0	000000000000000	TDWR	null	03500	4461	0	0	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8713600	BLAKEWAY (STRICKLAND SAND)	127	0	0	0	0	0	Jan. 27, 1981	19810127	A	F	null	660	1867	1	C C	1214045	8739	80	10	100190000000000	null	3	500	4573	0	0	1	1	13760538	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8713700	BLAKEWAY (4600 GAS SAND)	127	0	0	0	0	0	Feb. 5, 1982	19820205	N	S	null	467	1200	9	C C	344490	3144	40	0	100190000000000	null	null	00000	4598	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8749333	BLANCH (ESCONDIDO)	127	0	0	0	0	0	May 29, 1961	19610529	N	S	null	0	0	9	C C	308534	0	0	0	000000000000000	null	null	null	1603	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	8749666	BLANCH (OLMOS)	127	0	0	0	0	0	May 30, 1959	19590530	A	null	null	0	0	6	J K	45489	0	0	0	000000000000000	null	null	null	1951	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	9738075	BLUDWORTH (CANYON)	137	0	0	0	0	0	Oct. 8, 2001	20011008	N	O	null	0	0	5	C C	562133	27	0	0	000000000000000	null	null	null	7770	1	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10025300	BOB MATTHEWS (ESCONDIDO B)	507	0	0	0	0	0	March 13, 1979	19790313	N	O	null	467	1200	9	B B	431871	0	40	0	100190000000000	TDWR	null	00000	1668	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10222600	BOLIN (OLMOS)	507	0	0	0	0	0	March 4, 1982	19820304	N	O	null	0	0	9	C C	3980	0	0	0	000000000000000	null	null	null	2256	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440500	BONNE TERRE (MIDDLE HOUSE 8)	311	0	0	0	0	0	Jan. 16, 1988	19880116	N	F	null	660	1320	3	C C	66507601	263505	160	80	100030000000000	TDWR	null	06000	11185	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440600	BONNE TERRE (REAGAN 9700)	311	0	0	0	0	0	Aug. 31, 1988	19880831	N	O	null	0	0	9	C C	2959827	50148	0	0	000000000000000	null	null	null	9719	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440650	BONNE TERRE (9800)	311	0	0	0	0	0	Oct. 15, 1992	19921015	N	F	null	0	0	9	C C	2619682	23053	0	0	000000000000000	null	null	null	9830	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440675	BONNE TERRE (10400)	311	0	0	0	0	0	Jan. 23, 1993	19930123	N	F	null	0	0	5	C C	2227578	26672	0	0	000000000000000	null	null	null	10470	2	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440700	BONNE TERRE (10600)	311	0	0	0	0	0	May 12, 1988	19880512	N	O	null	660	1320	5	C C	19771471	119330	160	80	100020000000000	null	null	06000	10538	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440770	BONNE TERRE (10770)	311	0	0	0	0	0	June 9, 1988	19880609	N	F	null	660	1320	3	C C	21782947	126852	160	80	100030000000000	null	null	06000	10730	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440775	BONNE TERRE (10800)	311	0	0	0	0	0	May 26, 1988	19880526	N	O	null	660	1320	9	C C	16981570	112236	160	80	100030000000000	null	null	06000	10801	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440800	BONNE TERRE (10970)	311	0	0	0	0	0	June 7, 1988	19880607	N	F	null	660	1320	9	C C	39706376	281370	160	80	100030000000000	null	null	06000	10914	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10440900	BONNE TERRE (11750)	311	0	0	0	0	0	Aug. 20, 2002	20020820	N	O	null	0	0	5	C C	633977	1458	0	0	000000000000000	null	null	null	11740	0	0	1	0	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10792267	BOULDIN (1670)	177	0	0	0	0	0	June 5, 1997	19970605	N	O	null	0	0	5	C C	7434	0	0	0	000000000000000	null	null	null	1672	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	null	null	null
01	10792333	BOULDIN (1730)	177	0	0	0	0	0	Nov. 18, 1960	19601118	A	S	null	0	0	5	C C	10408	0	0	0	000000000000000	null	null	null	1731	0	0	1	1	0	null	GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.	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: 42.1K
Distinct: 12

04 13.7K
03 8.6K
02 8.4K
07B 2.8K
06 1.5K
07C 1.4K
08 1.4K
01 1.3K
10 1.2K
09 1.1K
05 654
08A 90

`field_no`

int4

Sampled: 42.1K
Distinct: 42.1K

19469980 1
19463500 1
19028076 1
73293235 1
68227001 1
26937500 1
87482800 1
1889080 1
4640500 1
88733225 1
989111 1
9745900 1

`field_name`

varchar

Sampled: 42.1K
Distinct: 42.1K

WILDCAT 12
POLKSTALK (BEND CONGL.) 2
AGUA PRIETA (3870) 2
JMM (CANYON) 2
EL CINCO (DETRITAL) 2
HOBBLEBUSH (1840) 2
LAKE PASTURE (FS-538) 2
TRINITY BAY (FRIO 5, N) 2
EL CINCO (WICHITA ALBANY) 2
SHRADER 2
HAGIST RANCH (800) 2
HULL, SOUTH (YEGUA 9620) 2

`county_code_1`

int2

Sampled: 42.1K
Distinct: 208

355 1.9K
427 1.6K
469 1.4K
215 1.3K
481 1.3K
239 1.3K
273 1.1K
409 1.1K
131 1.1K
175 1.1K
47 1.1K
321 1K

`county_code_2`

int2

Sampled: 42.1K
Distinct: 184

0 39.3K
704 103
273 89
355 82
469 80
249 64
703 63
708 59
123 54
479 54
391 53
175 52

`county_code_3`

int2

Sampled: 42.1K
Distinct: 75

0 42K
355 11
357 10
255 9
273 5
419 5
363 5
289 4
233 4
247 4
295 3
483 3

`county_code_4`

int2

Sampled: 42.1K
Distinct: 62

0 42K
393 8
469 7
357 5
401 5
497 5
255 4
371 4
293 4
413 3
367 3
704 3

`county_code_5`

int2

Sampled: 42.1K
Distinct: 33

0 42.1K
395 6
311 3
389 2
375 2
461 2
497 2
401 2
205 1
419 1
439 1
347 1

Take it away

Back to everything we know about Gas Ledger