Preview Field Gas Information

First 100 rows

Out of roughly 42.1K rows in texas.fl_gas_field. Version obs-de0180f4be2a.

First 100 rows of `texas.fl_gas_field`, 40 columns wide
`district_no`	`field_no`	`disc_date`	`disc_county_code`	`perf_1st_well`	`type_field_code`	`testing_county`	`test_frequency`	`pri_test_g10_required`	`sec_test_g10_required`	`commingling_counter`	`exempt_min_gor`	`offshore_code`	`cum_gas_prod_to_conv`	`cum_cond_prod_to_conv`	`cum_gas_allow_to_conv`	`off_file_cum_gas_allow`	`off_file_cum_gas_prod`	`off_file_cum_cond_prod`	`on_file_cum_gas_allow`	`on_file_cum_gas_prod`	`on_file_cum_cond_prod`	`ytd_cum_gas_allow`	`ytd_cum_gas_prod`	`ytd_cum_cond_prod`	`salt_dome_exemption`	`county_regular_exemption`	`ledger_month`	`new_gas_field_appr_date`	`cum_prod_prior_1970`	`schedule_start_date`	`consolidated_field_flag`	`correlative_interval_from`	`correlative_interval_to`
01	2001	Jan. 3, 1958	0	364	A	0	A	C	K	0	N	L	0	0	0	324214	668035	20279	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	256500	Sept. 1, 1982	311	9446	A	311	S	C	C	9	N	L	0	0	0	507241920	391909706	7690252	10148158	7592928	142856	2329195	1437538	23740	null	null	6	null	0	null	null	null	null
01	256600	Aug. 31, 2005	311	9629	A	311	S	C	C	0	N	L	0	0	0	546351	423477	2357	0	0	0	0	0	0	null	null	6	Nov. 25, 2005	null	Aug. 31, 2005	null	null	null
01	256700	Sept. 27, 1987	311	6852	N	311	S	C	C	0	N	L	0	0	0	331754	107857	1187	0	0	0	0	0	0	null	N	6	Jan. 12, 1988	0	null	null	null	null
01	256750	Feb. 15, 1988	311	6166	N	311	A	J	K	0	N	L	0	0	0	995848	771141	2503	0	0	0	0	0	0	null	N	6	March 22, 1988	0	null	null	null	null
01	464100	April 23, 1981	493	7448	N	493	S	B	B	0	N	L	6248	1516	169953	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	467500	Feb. 27, 1990	493	2812	A	493	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	Feb. 27, 1990	0	null	null	null	null
01	517500	Aug. 26, 2009	283	10978	N	283	S	C	C	0	N	L	0	0	0	1036897	749077	22422	0	0	0	0	0	0	null	N	6	Oct. 6, 2009	null	Aug. 26, 2009	Y	null	null
01	621666	July 26, 1956	325	850	N	325	S	C	C	1	N	L	828231	0	2368890	1804675	1186326	25	8926	8729	0	1843	1833	0	null	null	6	null	0	null	null	null	null
01	925400	Nov. 15, 1973	323	5885	N	323	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	930050	Feb. 23, 1984	507	3530	N	507	S	C	C	0	N	L	0	0	0	108419	74085	0	0	0	0	0	0	0	null	N	6	null	0	null	null	null	null
01	930500	March 25, 1980	507	3690	N	507	S	B	B	0	N	L	237825	0	432838	95319	63564	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	931300	Jan. 12, 1981	507	3846	N	507	S	C	C	0	N	L	15500	0	59882	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	1780300	April 11, 1980	507	3455	N	507	S	C	C	0	N	L	423848	0	541445	645635	437290	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	1780500	Oct. 5, 1982	507	3687	A	507	A	J	K	0	N	L	0	0	8888	43760	10872	117	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	1780700	April 11, 1980	507	2925	N	507	S	B	B	0	N	L	342105	0	570404	37076	22458	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	2075500	Jan. 19, 2008	465	13436	N	465	S	C	C	0	N	L	0	0	0	541009	247774	6	0	0	0	0	0	0	null	N	6	Aug. 8, 2008	null	Jan. 19, 2008	null	null	null
01	2075600	April 6, 2007	465	12670	N	465	S	C	C	0	N	L	0	0	0	37730	10999	0	0	0	0	0	0	0	null	N	6	Aug. 25, 2008	null	April 6, 2007	null	null	null
01	2271500	May 21, 1954	283	4421	N	283	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	2396500	Aug. 6, 2013	127	5800	A	127	S	C	C	0	N	L	0	0	0	198250	238976	36524	0	0	0	0	0	0	null	null	6	Aug. 6, 2013	null	Oct. 1, 2011	null	5800	5940
01	2414200	Nov. 25, 1974	323	814	N	323	S	C	C	0	N	L	54398	0	93263	11762	5415	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	2414300	Sept. 27, 1977	323	1584	N	323	S	C	C	0	N	L	20016	0	50519	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	2433075	July 8, 2005	311	3088	N	311	S	C	C	0	N	L	0	0	0	329920	199989	0	0	0	0	0	0	0	null	N	6	Dec. 15, 2005	null	July 8, 2005	null	null	null
01	2568001	May 30, 1959	13	3748	N	13	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	3008375	Aug. 23, 2001	507	2414	N	507	S	C	C	0	N	L	0	0	0	114376	65731	0	0	0	0	0	0	0	null	N	6	Nov. 14, 2001	null	Aug. 23, 2001	null	null	null
01	3144500	Dec. 12, 1955	127	2869	N	127	S	C	C	0	N	L	0	0	887250	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	3328600	Nov. 3, 1980	127	4708	N	127	S	C	C	0	N	L	0	0	0	4983796	3939982	35931	0	0	0	0	0	0	null	N	6	null	0	null	null	null	null
01	3650500	April 28, 2008	137	9215	N	137	S	C	C	0	N	L	0	0	0	1473683	734062	0	7233	5788	0	2727	2360	0	null	N	6	July 2, 2008	null	April 28, 2008	null	null	null
01	3950500	Sept. 5, 1967	283	4500	N	283	S	B	B	0	N	L	2950576	363	4851405	107808	85311	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4078333	Jan. 9, 1968	127	3456	N	127	S	C	C	0	N	L	242032	943	760141	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4079500	Jan. 26, 1968	127	4315	N	127	S	C	C	0	N	L	76355	767	604984	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4276400	Oct. 21, 1980	13	4008	N	13	S	C	C	0	N	L	19762	102	62535	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4300500	Oct. 13, 1983	283	7460	N	283	S	C	C	2	N	L	0	0	0	22388018	19227106	221726	412842	369148	288	99491	80573	39	null	null	6	null	0	null	null	null	null
01	4391500	June 5, 1962	283	11710	N	283	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4462666	Aug. 12, 1961	177	11453	A	177	S	C	C	0	N	L	5652093	61588	9581210	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	4488800	Feb. 28, 1984	507	2558	N	507	S	C	C	0	N	L	0	0	0	202688	81620	0	0	0	0	0	0	0	null	N	6	null	0	null	null	null	null
01	4681700	Oct. 14, 2006	311	5609	A	311	S	C	C	0	N	L	0	0	0	132966	12918	2169	0	0	0	0	0	0	null	null	6	July 18, 2007	null	Oct. 14, 2006	null	null	null
01	5122400	Sept. 15, 1975	311	8000	N	311	S	C	C	2	N	L	16660972	232345	37270456	20242865	14740162	217636	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5122450	May 31, 2000	311	1718	N	311	S	C	C	0	N	L	0	0	0	315099	21711	0	0	0	0	0	0	0	null	N	6	Aug. 21, 2001	null	May 31, 2000	null	null	null
01	5122500	Aug. 11, 1951	311	1820	N	311	S	C	C	0	N	L	284983	0	2303416	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5122750	April 14, 1998	311	2490	N	311	A	J	K	0	N	L	0	0	0	264898	198951	3271	0	0	0	0	0	0	null	N	6	June 4, 1998	0	April 14, 1998	null	2100	3300
01	5123766	July 10, 1994	311	2108	N	311	S	C	C	0	N	L	0	0	0	1254853	1123847	40	0	0	0	0	0	0	null	N	6	Aug. 25, 1994	0	July 10, 1994	null	null	null
01	5127500	Aug. 24, 1982	127	945	N	127	S	B	B	0	N	L	8164	0	30114	84244	64023	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5410500	Jan. 3, 2008	19	3765	N	19	S	C	C	0	N	L	0	0	0	765983	393965	85	0	0	0	0	0	0	null	N	6	Oct. 7, 2009	null	Jan. 3, 2008	null	null	null
01	5434500	June 11, 1958	507	2536	N	507	S	C	C	0	N	L	840244	0	2453749	630733	508895	0	1054	52	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5438500	July 31, 1966	507	2358	N	507	S	C	C	0	N	L	13840729	0	38647685	8346107	6788425	139	4605	192	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5599400	Dec. 1, 1977	323	7230	N	323	S	C	C	0	N	L	475964	0	702009	412857	301757	0	0	0	0	0	0	0	null	null	6	null	1103058	null	null	null	null
01	5630100	Jan. 10, 1980	127	3479	N	127	S	B	B	0	N	L	137855	858	260935	504630	425081	3888	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	5809700	June 21, 1980	311	8320	N	311	S	C	C	0	N	L	2629775	10244	3715723	1528359	1333308	6046	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6096500	null	507	0	N	507	S	B	B	0	N	L	1557276	0	6186522	433641	227395	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6096750	Dec. 18, 1969	507	3033	N	507	S	C	C	0	N	L	3019987	881	12873299	65674	24506	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6099500	Jan. 22, 1963	507	1910	N	507	S	C	C	0	N	L	0	0	0	209950	112719	665	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6105700	April 8, 1976	507	3184	A	507	A	J	K	0	N	L	108340	503	272354	33172	12025	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6107250	Sept. 14, 1977	507	3040	N	507	S	B	B	0	N	L	256195	0	463214	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6107300	Oct. 2, 1977	507	2926	N	507	S	B	B	0	N	L	224609	0	314563	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6107500	May 26, 1977	507	3200	N	507	S	B	B	0	N	L	764063	0	1990274	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6262200	Sept. 21, 1983	465	3700	N	465	S	C	C	0	N	L	0	0	0	10341841	8242659	213	73241	58031	0	16425	11421	0	null	N	6	null	0	null	null	null	null
01	6457375	Dec. 31, 1997	137	9467	N	137	S	C	C	0	N	L	0	0	0	8998391	5825809	0	50827	46302	0	8829	5707	0	null	N	6	March 9, 1998	0	Dec. 31, 1997	null	null	null
01	6483500	June 11, 1964	507	2086	N	507	S	C	C	0	N	L	0	0	0	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6483600	Dec. 16, 1981	507	2107	N	507	S	C	C	0	N	L	159945	0	150747	1982264	1695951	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6490500	Feb. 15, 1982	507	2884	N	507	S	B	B	0	N	L	2234	0	6995	7047	4297	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	6924300	Sept. 19, 1973	13	452	N	13	S	C	C	0	N	L	353172	0	1062052	0	0	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7210500	Feb. 9, 1980	13	1631	N	13	S	C	C	0	N	L	0	0	0	259324	92259	90	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7210600	Aug. 7, 1980	13	1528	N	13	S	C	C	0	N	L	0	0	0	169542	57010	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7220500	July 30, 1980	13	2007	A	13	A	J	K	0	N	L	0	0	0	324360	153605	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7220700	May 8, 1981	13	1774	N	13	S	B	B	0	N	L	0	0	0	14051	9439	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7370300	Aug. 16, 1977	163	3330	N	163	S	C	C	0	N	L	1058829	833	1350324	469992	351645	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7516400	Oct. 2, 2018	127	2240	N	127	S	C	C	0	N	L	0	0	0	134874	91851	0	22433	20014	0	5771	4775	0	null	N	6	Oct. 2, 2018	null	Oct. 2, 2018	null	2236	2264
01	7516500	April 1, 2016	127	2286	N	127	S	C	C	0	N	L	0	0	0	233956	174469	0	0	0	0	0	0	0	null	N	6	April 1, 2016	null	April 1, 2016	null	2286	2290
01	7743400	March 6, 1987	283	5553	N	283	S	C	C	0	N	L	0	0	0	550567	457178	4705	0	0	0	0	0	0	null	N	6	null	0	null	null	null	null
01	7743425	May 16, 1988	283	5626	N	283	S	C	C	0	N	L	0	0	0	88570	31138	582	0	0	0	0	0	0	null	N	6	Aug. 22, 1988	0	null	null	null	null
01	7743450	June 24, 1987	283	5839	N	283	S	C	C	0	N	L	0	0	0	93571	41034	1010	0	0	0	0	0	0	null	N	6	null	0	null	null	null	null
01	7850001	May 6, 1980	163	3005	A	163	S	C	C	0	N	L	9445	0	17896	407256	359699	0	7115	5933	0	1450	1116	0	null	null	6	null	0	null	null	null	null
01	7850333	Nov. 13, 1952	163	3139	N	163	S	C	C	0	N	L	13700	0	27183	111572	104321	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	7851270	Feb. 9, 1999	163	2701	N	163	S	C	C	0	N	L	0	0	0	158159	91285	0	0	0	0	0	0	0	null	N	6	May 13, 1999	null	Feb. 9, 1999	null	null	null
01	7856250	Nov. 13, 1952	163	2982	N	163	S	C	C	2	N	L	28458806	0	28927872	21399350	19211300	644	193703	179424	0	40866	39338	0	null	null	6	null	0	null	null	null	null
01	8001600	Dec. 1, 1986	311	5096	A	311	S	C	C	0	N	L	0	0	0	34632	20790	0	0	0	0	0	0	0	null	null	6	null	13760538	null	null	null	null
01	8001700	Sept. 8, 1983	311	5225	A	311	A	J	K	2	N	L	0	0	0	4861874	3588032	18490	0	0	0	0	0	0	null	null	6	null	13760538	null	null	null	null
01	8072500	Jan. 16, 1969	127	5360	A	127	A	J	K	8	N	L	7619170	152680	20768476	27177490	23144080	86474	238321	193173	0	45519	33534	0	null	null	6	null	13760538	null	null	null	null
01	8075666	Jan. 16, 1969	507	5360	A	507	A	J	K	0	N	L	0	0	102565	0	0	0	0	0	0	0	0	0	null	null	6	null	13760538	null	null	null	null
01	8713499	Oct. 25, 1984	127	4461	A	127	A	J	K	0	N	L	0	0	0	574616	389303	10691	0	0	0	0	0	0	null	null	6	March 16, 1985	13760538	null	null	null	null
01	8713600	Jan. 27, 1981	127	4573	A	127	S	C	C	0	N	L	387171	3112	448764	1081154	826874	5627	0	0	0	0	0	0	null	null	6	null	13760538	null	null	null	null
01	8713700	Feb. 5, 1982	127	4598	N	127	S	C	C	0	N	L	55246	1338	120480	410656	289244	1806	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	8749333	May 29, 1961	127	1603	N	127	S	C	C	0	N	L	288316	0	633218	43196	20218	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	8749666	May 30, 1959	127	1951	A	127	A	J	K	0	N	L	33035	0	75748	21225	12454	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	9738075	Oct. 8, 2001	137	7770	N	137	S	C	C	0	N	L	0	0	0	833447	554632	27	17053	8880	0	58	28	0	null	N	6	Nov. 26, 2001	null	Oct. 8, 2001	null	null	null
01	10025300	March 13, 1979	507	1668	N	507	S	B	B	0	N	L	342501	0	798530	153043	89370	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	10222600	March 4, 1982	507	2256	N	507	S	C	C	0	N	L	0	0	0	0	3980	0	0	0	0	0	0	0	null	N	6	Oct. 29, 1987	0	null	null	null	null
01	10440500	Jan. 16, 1988	311	11185	N	311	S	C	C	0	N	L	0	0	0	76520941	66507601	263505	0	0	0	0	0	0	null	N	6	Feb. 19, 1988	0	null	null	null	null
01	10440600	Aug. 31, 1988	311	9719	N	311	S	C	C	0	N	L	0	0	0	3677261	2959827	50148	0	0	0	0	0	0	null	N	6	Oct. 7, 1988	0	null	null	null	null
01	10440650	Oct. 15, 1992	311	9830	N	311	S	C	C	0	N	L	0	0	0	4171506	2619682	23053	0	0	0	0	0	0	null	N	6	Nov. 17, 1992	0	Oct. 15, 1992	null	null	null
01	10440675	Jan. 23, 1993	311	10470	N	311	S	C	C	0	N	L	0	0	0	2639959	2227251	26602	645	402	70	293	0	0	null	N	6	Feb. 19, 1993	0	Jan. 23, 1993	null	null	null
01	10440700	May 12, 1988	311	10538	N	311	S	C	C	0	N	L	0	0	0	25181620	19771471	119330	0	0	0	0	0	0	null	N	6	June 8, 1988	0	null	null	null	null
01	10440770	June 9, 1988	311	10730	N	311	S	C	C	0	N	L	0	0	0	25024174	21782947	126852	0	0	0	0	0	0	null	N	6	July 7, 1988	0	null	null	null	null
01	10440775	May 26, 1988	311	10801	N	311	S	C	C	0	N	L	0	0	0	19543318	16981570	112236	0	0	0	0	0	0	null	N	6	June 14, 1988	0	null	null	null	null
01	10440800	June 7, 1988	311	10914	N	311	S	C	C	0	N	L	0	0	0	45417767	39706376	281370	0	0	0	0	0	0	null	N	6	July 7, 1988	0	null	null	null	null
01	10440900	Aug. 20, 2002	311	11740	N	311	S	C	C	0	N	L	0	0	0	729627	633977	1458	0	0	0	0	0	0	null	N	6	Nov. 13, 2002	null	Aug. 20, 2002	null	null	null
01	10792267	June 5, 1997	177	1672	N	177	S	C	C	0	N	L	0	0	0	58719	7434	0	0	0	0	0	0	0	null	N	6	Oct. 27, 1998	0	June 5, 1997	null	null	null
01	10792333	Nov. 18, 1960	177	1731	A	177	S	C	C	0	N	L	3752	0	273510	19164	6656	0	0	0	0	0	0	0	null	null	6	null	0	null	null	null	null
01	10792400	Aug. 18, 1989	177	1924	N	177	S	C	C	0	N	L	0	0	0	9200	1238	0	0	0	0	0	0	0	null	N	6	Sept. 19, 1989	0	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_no`

varchar

Sampled: 42.1K
Distinct: 12

04 13.7K
03 8.6K
02 8.4K
08 2.8K
06 1.5K
09 1.4K
10 1.4K
01 1.3K
14 1.2K
13 1.1K
05 654
11 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

`disc_date`

date

Sampled: 42.1K
Distinct: 17.3K
Empty: 0.018

Jan. 1, 1979 47
Nov. 1, 1978 39
Feb. 1, 1979 34
March 1, 1979 34
Nov. 1, 1979 29
June 1, 1979 24
Jan. 1, 1976 22
Sept. 1, 1979 21
Oct. 1, 1979 21
Dec. 1, 1978 20
May 1, 1979 18
Aug. 1, 1977 18

`disc_county_code`

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

`perf_1st_well`

int4

Sampled: 42.1K
Distinct: 11.7K

0 642
4000 63
1323 38
6000 33
6500 28
7200 28
5400 27
1900 26
7000 26
6200 26
7500 26
6700 25

`type_field_code`

varchar

Sampled: 42.1K
Distinct: 2

N 34.6K
A 7.5K

`testing_county`

int2

Sampled: 42.1K
Distinct: 207

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

`test_frequency`

varchar

Sampled: 42.1K
Distinct: 2

S 39.4K
A 2.8K

Take it away

Back to everything we know about Field Gas Information