Preview: Drilling Permit Master and Trailer

First 100 rows

Out of roughly 994.4K rows in texas.dp_permit_root. Version obs-21c8323d7f01.

First 100 rows of `texas.dp_permit_root`, 32 columns wide
`status_no`	`status_seq`	`county_code`	`lease_name`	`district`	`operator_no`	`received_date`	`operator_name`	`app_status`	`not_enough_money_flag`	`too_much_money_flag`	`p5_problem_flag`	`p12_problem_flag`	`plat_problem_flag`	`w1a_problem_flag`	`other_problem_flag`	`rule37_problem_flag`	`rule38_problem_flag`	`rule39_problem_flag`	`no_money_flag`	`permit_no`	`issue_date`	`withdrawn_date`	`walkthrough_flag`	`other_problem_text`	`well_no`	`status_renumbered_to`	`status_renumbered_from`
65981	99	131	D.C.R.C. 97	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66190	Dec. 10, 1979	null	N	null	6	null	null
65982	99	131	D.C.R.C. 97	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66191	Dec. 10, 1979	null	N	null	7	null	null
65983	99	131	D.C.R.C. 97	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66192	Dec. 10, 1979	null	N	null	8	null	null
65984	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66193	Dec. 10, 1979	null	N	null	1	null	null
65985	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66194	Dec. 10, 1979	null	N	null	2	null	null
65986	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66195	Dec. 10, 1979	null	N	null	3	null	null
65987	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66196	Dec. 10, 1979	null	N	null	4	null	null
65988	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66197	Dec. 10, 1979	null	N	null	5	null	null
65989	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66198	Dec. 10, 1979	null	N	null	9	null	null
65990	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66199	Dec. 10, 1979	null	N	null	10	null	null
65991	99	131	D.C.R.C. 263	04	844110	Dec. 10, 1979	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	66200	Dec. 10, 1979	null	N	null	11	null	null
66662	99	049	BELL, RONNIE	08	948600	Dec. 14, 1979	YOUNG, L. M.	A	N	N	N	N	N	N	N	N	N	N	N	66871	Dec. 14, 1979	null	N	null	2B	null	null
67047	99	083	BREWER	08	703365	Dec. 19, 1979	RESERVE OIL, INC.	A	N	N	N	N	N	N	N	N	N	N	N	67256	Dec. 19, 1979	null	N	null	15W	null	null
67706	99	461	AMACKER 46	09	637420	Dec. 31, 1979	PALO-PLACER	A	N	N	N	N	N	N	N	N	N	N	N	67915	Dec. 31, 1979	null	N	null	4	null	null
67762	99	335	SCHATTEL	10	693740	Dec. 31, 1979	RASMUSSEN, TOM	A	N	N	N	N	N	N	N	N	N	N	N	67971	Dec. 31, 1979	null	N	null	1	null	null
68702	99	427	MARGO, R. E.	04	617505	Jan. 8, 1980	OATMAN, W. W.	A	N	N	N	N	N	N	N	N	N	N	N	68911	Jan. 8, 1980	null	N	null	1	null	null
68756	99	485	JENNINGS K	13	834230	Jan. 8, 1980	T W J CO.	A	N	N	N	N	N	N	N	N	N	N	N	68965	Jan. 8, 1980	null	N	null	1	null	null
70682	99	143	ATOR, S. H.	08	888125	Jan. 28, 1980	W.H.D., INC.	A	N	N	N	N	N	N	N	N	N	N	N	70894	Jan. 28, 1980	null	N	null	1	null	null
73151	99	447	TALLEY	08	380295	Feb. 25, 1980	HERRING, RAY	A	N	N	N	N	N	N	N	N	N	N	N	73368	Feb. 25, 1980	null	N	null	3A	null	null
73538	99	211	FEE	14	773840	Feb. 28, 1980	SHELL OIL COMPANY	A	N	N	N	N	N	N	N	N	N	N	N	73755	Feb. 28, 1980	null	N	null	321	null	null
74255	99	399	POPE UNIT	09	679285	March 7, 1980	PRO OIL	A	N	N	N	N	N	N	N	N	N	N	N	74474	March 7, 1980	null	N	null	1	null	null
76346	99	009	HALL	13	724980	March 28, 1980	ROGERS DRILLING CO.	A	N	N	N	N	N	N	N	N	N	N	N	76569	March 28, 1980	null	N	null	2	null	null
77558	99	389	TXL 1	10	626210	April 9, 1980	ORLA PETCO, INC.	A	N	N	N	N	N	N	N	N	N	N	N	77786	April 9, 1980	null	N	null	3	null	null
77559	99	295	LOESCH	14	710590	April 9, 1980	RICKS, RAN JR	A	N	N	N	N	N	N	N	N	N	N	N	77787	April 9, 1980	null	N	null	1	null	null
77783	99	503	CHOATE	13	611020	April 11, 1980	NITSCHKE, DAN E.	A	N	N	N	N	N	N	N	N	N	N	N	78011	April 11, 1980	null	N	null	2	null	null
91701	99	253	CHAPMAN	08	101395	Sept. 9, 1980	BROWN OWL OIL CO.	A	N	N	N	N	N	N	N	N	N	N	N	91941	Sept. 9, 1980	null	N	null	5	null	null
91702	99	253	CHAPMAN	08	101395	Sept. 9, 1980	BROWN OWL OIL CO.	A	N	N	N	N	N	N	N	N	N	N	N	91942	Sept. 9, 1980	null	N	null	6	null	null
91703	99	253	CHAPMAN	08	101395	Sept. 9, 1980	BROWN OWL OIL CO.	A	N	N	N	N	N	N	N	N	N	N	N	91943	Sept. 9, 1980	null	N	null	7	null	null
92033	99	331	BATES	01	367370	Sept. 11, 1980	HAWKINS, N. G.	A	N	N	N	N	N	N	N	N	N	N	N	92273	Sept. 11, 1980	null	N	null	9	null	null
92090	99	447	BROWN	08	855560	Sept. 12, 1980	THOMPSON, J. B.	A	N	N	N	N	N	N	N	N	N	N	N	92331	Sept. 12, 1980	null	N	null	3	null	null
99817	99	337	REYNOLDS	13	922200	Nov. 21, 1980	WIDLAKE, T. E.	A	N	N	N	N	N	N	N	N	N	N	N	100076	Nov. 21, 1980	null	N	null	1	null	null
100204	99	447	DAWS	08	427828	Nov. 26, 1980	J.R. PETROLEUM	A	N	N	N	N	N	N	N	N	N	N	N	100470	Nov. 26, 1980	null	N	null	1	null	null
101583	99	331	BATES	01	367370	Dec. 11, 1980	HAWKINS, N. G.	A	N	N	N	N	N	N	N	N	N	N	N	101853	Dec. 11, 1980	null	N	null	11	null	null
101584	99	331	BATES	01	367370	Dec. 11, 1980	HAWKINS, N. G.	A	N	N	N	N	N	N	N	N	N	N	N	101854	Dec. 11, 1980	null	N	null	12	null	null
103730	99	415	RICHARDSON	11	888125	Dec. 31, 1980	W.H.D., INC.	A	N	N	N	N	N	N	N	N	N	N	N	104010	Dec. 31, 1980	null	N	null	4	null	null
103731	99	415	RICHARDSON	11	888125	Dec. 31, 1980	W.H.D., INC.	A	N	N	N	N	N	N	N	N	N	N	N	104011	Dec. 31, 1980	null	N	null	5	null	null
137549	99	009	KEYESB	13	427701	Oct. 26, 1981	J & M OIL CO.	A	N	N	N	N	N	N	N	N	N	N	N	137940	Oct. 26, 1981	null	N	null	4	null	null
138320	99	003	LIMPIA "14"	10	282620	Oct. 29, 1981	FRAC, INC.	A	N	N	N	N	N	N	N	N	N	N	N	138713	Oct. 29, 1981	null	N	null	2	null	null
139356	99	025	MENA	02	875230	Nov. 5, 1981	TXO PRODUCTION CORP.	A	N	N	N	N	N	N	N	N	N	N	N	139751	Nov. 5, 1981	null	N	null	2	null	null
209194	99	009	SWING "B"	13	455082	Aug. 25, 1983	KEM-GEM INC.	A	N	N	N	N	N	N	N	N	N	N	N	208834	Aug. 31, 1983	null	N	null	36	null	null
209195	99	009	SWING "B"	13	455082	Aug. 25, 1983	KEM-GEM INC.	A	N	N	N	N	N	N	N	N	N	N	N	208836	Aug. 31, 1983	null	N	null	37	null	null
209255	99	021	BAHN, J.	01	685889	Aug. 26, 1983	R.D. OIL COMPANY	A	N	N	N	N	N	N	N	N	N	N	N	215253	Sept. 27, 1983	null	Y	null	U2	null	null
209315	99	021	BAHN, J.	01	685889	Aug. 26, 1983	R.D. OIL COMPANY	A	N	N	N	N	N	N	N	N	N	N	N	210800	Sept. 8, 1983	null	Y	null	W4	null	null
209656	99	059	HOWE	08	212930	Aug. 22, 1983	DEL-MAR PETROLEUM	A	N	N	N	N	N	N	N	N	N	N	N	209109	Sept. 1, 1983	null	N	null	103	null	null
139527	99	287	BRYANT	03	265620	Nov. 6, 1981	FENN, BILL INC.	A	N	N	N	N	N	N	N	N	N	N	N	139924	Nov. 6, 1981	null	N	null	1	null	null
140137	99	483	HELTON	14	126775	Oct. 26, 1981	CAMBRIDGE & NAIL	A	N	N	N	N	N	N	N	N	N	N	N	140536	Oct. 26, 1981	null	N	null	1	null	null
140357	99	447	POAGE	08	366120	Nov. 16, 1981	HATCHER, RAY	A	N	N	N	N	N	N	N	N	N	N	N	140756	Nov. 16, 1981	null	N	null	3	null	null
140414	99	029	WAGNER	01	689495	Nov. 17, 1981	RAMIREZ, VALENTE	A	N	N	N	N	N	N	N	N	N	N	N	140813	Nov. 17, 1981	null	N	null	3	null	null
140634	99	263	SELLARS "36"	11	525320	Nov. 18, 1981	MARALO, INC.	A	N	N	N	N	N	N	N	N	N	N	N	141033	Nov. 18, 1981	null	N	null	1	null	null
140911	99	245	BOLINGER	03	81287	Nov. 20, 1981	BOLINGER OIL CO.	A	N	N	N	N	N	N	N	N	N	N	N	141310	Nov. 20, 1981	null	N	null	4	null	null
145909	99	103	VANCOURT	10	341537	Dec. 31, 1981	HRH ENERGY CO.	A	N	N	N	N	N	N	N	N	N	N	N	146320	Dec. 31, 1981	null	N	null	4	null	null
145910	99	237	SEWELL, S.E.	13	750160	Dec. 31, 1981	SCANDRILL CO.	A	N	N	N	N	N	N	N	N	N	N	N	146321	Dec. 31, 1981	null	N	null	2	null	null
145911	99	103	VANCOURT	10	341537	Dec. 31, 1981	HRH ENERGY CO.	A	N	N	N	N	N	N	N	N	N	N	N	146322	Dec. 31, 1981	null	N	null	5	null	null
145912	99	237	DUERSON	13	750160	Dec. 31, 1981	SCANDRILL CO.	A	N	N	N	N	N	N	N	N	N	N	N	146323	Dec. 31, 1981	null	N	null	5	null	null
145913	99	237	DUERSON	13	750160	Dec. 31, 1981	SCANDRILL CO.	A	N	N	N	N	N	N	N	N	N	N	N	146324	Dec. 31, 1981	null	N	null	4	null	null
145914	99	103	VANCOURT	10	341537	Dec. 31, 1981	HRH ENERGY CO.	A	N	N	N	N	N	N	N	N	N	N	N	146325	Dec. 31, 1981	null	N	null	6	null	null
145915	99	103	VANCOURT	10	341537	Dec. 31, 1981	HRH ENERGY CO.	A	N	N	N	N	N	N	N	N	N	N	N	146326	Dec. 31, 1981	null	N	null	7	null	null
145916	99	103	VANCOURT	10	341537	Dec. 31, 1981	HRH ENERGY CO.	A	N	N	N	N	N	N	N	N	N	N	N	146327	Dec. 31, 1981	null	N	null	8	null	null
146628	99	009	MANKINS "A"	13	471470	Dec. 17, 1981	KNIGHT, MACK	A	N	N	N	N	N	N	N	N	N	N	N	147040	Dec. 17, 1981	null	N	null	14	null	null
156754	99	255	STEWART	02	844110	April 19, 1982	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	157192	April 19, 1982	null	N	null	S-29	null	null
157532	99	253	VESSELS	08	108069	April 26, 1982	BURGER, F.W. INC.	A	N	N	N	N	N	N	N	N	N	N	N	157972	April 26, 1982	null	N	null	1	null	null
157810	99	047	BENNETT	04	172230	April 27, 1982	CONOCO INC.	A	N	N	N	N	N	N	N	N	N	N	N	158250	April 27, 1982	null	N	null	128	null	null
159851	99	479	HEIN	04	875200	May 7, 1982	TXO MINERALS, INC.	A	N	N	N	N	N	N	N	N	N	N	N	160297	May 7, 1982	null	N	null	#11	null	null
159852	99	479	HEIN	04	875200	May 10, 1982	TXO MINERALS, INC.	A	N	N	N	N	N	N	N	N	N	N	N	160298	May 10, 1982	null	N	null	#12	null	null
159853	99	479	HEIN	04	875200	May 10, 1982	TXO MINERALS, INC.	A	N	N	N	N	N	N	N	N	N	N	N	160299	May 10, 1982	null	N	null	#13	null	null
159854	99	479	HEIN	04	875200	May 10, 1982	TXO MINERALS, INC.	A	N	N	N	N	N	N	N	N	N	N	N	160300	May 10, 1982	null	N	null	#1	null	null
159911	99	051	ANT	03	122585	May 10, 1982	CAG PETROLEUM CORP.	A	N	N	N	N	N	N	N	N	N	N	N	160357	May 10, 1982	null	N	null	1	null	null
159912	99	227	WALDRON, S.	10	257097	May 10, 1982	EXXON CORP.	A	N	N	N	N	N	N	N	N	N	N	N	160358	May 10, 1982	null	N	null	4	null	null
160348	99	431	BARBEE	10	890915	May 14, 1982	WAGNER & BROWN	A	N	N	N	N	N	N	N	N	N	N	N	160797	May 14, 1982	null	N	null	206	null	null
161284	99	503	LANCER	13	26645	May 25, 1982	ANTLE, E.	A	N	N	N	N	N	N	N	N	N	N	N	161738	May 25, 1982	null	N	null	1	null	null
161285	99	461	AMACKER	09	451450	May 25, 1982	KASPAR, A. G.	A	N	N	N	N	N	N	N	N	N	N	N	161739	May 25, 1982	null	N	null	2	null	null
162225	99	383	ROCKER B 'N'	09	185980	June 3, 1982	COX, JOHN L.	A	N	N	N	N	N	N	N	N	N	N	N	162679	June 3, 1982	null	N	null	7-X	null	null
162226	99	383	ROCKER B 'N'	09	185980	June 3, 1982	COX, JOHN L.	A	N	N	N	N	N	N	N	N	N	N	N	162680	June 3, 1982	null	N	null	9-X	null	null
162669	99	461	LYON	09	679285	June 8, 1982	PRO OIL	A	N	N	N	N	N	N	N	N	N	N	N	163123	June 8, 1982	null	N	null	1	null	null
162670	99	415	BOLDING	11	165750	June 8, 1982	COFFIELD, H. H.	A	N	N	N	N	N	N	N	N	N	N	N	163124	June 8, 1982	null	N	null	11	null	null
162891	99	041	SIEGERT UNIT	03	556498	June 10, 1982	MCZ, INC.	A	N	N	N	N	N	N	N	N	N	N	N	163347	June 10, 1982	null	N	null	1	null	null
163280	99	059	DYER, B.	08	864023	June 16, 1982	TRACKER MINERAL	A	N	N	N	N	N	N	N	N	N	N	N	163737	June 16, 1982	null	N	null	2	null	null
163281	99	059	DYER, B.	08	864023	June 16, 1982	TRACKER MINERAL	A	N	N	N	N	N	N	N	N	N	N	N	163738	June 16, 1982	null	N	null	3	null	null
165538	99	051	RATHJEN	03	566386	June 22, 1982	MIDWAY OIL CORP.	A	N	N	N	N	N	N	N	N	N	N	N	166003	June 22, 1982	null	N	null	1	null	null
171442	99	049	MOORE, COY L.	08	834233	Nov. 18, 1983	T.O.F.C., INC.	P	N	N	N	N	N	N	N	N	N	N	N	null	null	null	N	null	3	null	null
172600	99	097	PURCELL	13	69066	Oct. 11, 1983	BIFFLE, JIMMY JACK	P	N	N	N	N	N	N	N	N	N	N	N	null	null	null	N	null	2	null	null
175253	99	009	WEINZAPFEL	13	592310	Oct. 28, 1982	MOWREY, S. L.	A	N	N	N	N	N	N	N	N	N	N	N	175751	Oct. 28, 1982	null	N	null	1	null	null
175254	99	009	WEINZAPFEL	13	592310	Oct. 28, 1982	MOWREY, S. L.	A	N	N	N	N	N	N	N	N	N	N	N	175752	Oct. 28, 1982	null	N	null	2	null	null
175311	99	371	HUNT 'C'	10	626240	Oct. 27, 1982	ORMAND, DON R.	A	N	N	N	N	N	N	N	N	N	N	N	175809	Oct. 27, 1982	null	N	null	1	null	null
175755	99	417	SANDERS "1564"	08	440758	Nov. 3, 1982	JONES CO.	A	N	N	N	N	N	N	N	N	N	N	N	176253	Nov. 3, 1982	null	N	null	4	null	null
182821	99	003	BENNETT	10	525320	Jan. 14, 1983	MARALO, INC.	A	N	N	N	N	N	N	N	N	N	N	N	183333	Jan. 14, 1983	null	N	null	1	null	null
183098	99	009	HILBERS	13	157695	Dec. 31, 1982	CLARK OILCO	A	N	N	N	N	N	N	N	N	N	N	N	183610	Dec. 31, 1982	null	N	null	2	null	null
184263	99	133	ELLIOTT	08	660111	Feb. 1, 1983	PETRO-MACK, INC.	A	N	N	N	N	N	N	N	N	N	N	N	184776	Feb. 1, 1983	null	N	null	8	null	null
184264	99	367	LESIKAR	08	496925	Feb. 1, 1983	LESIKAR, L. W.	A	N	N	N	N	N	N	N	N	N	N	N	184777	Feb. 1, 1983	null	N	null	2A	null	null
188340	99	165	WHARTON UNIT	11	844110	March 17, 1983	TEXACO INC.	A	N	N	N	N	N	N	N	N	N	N	N	188860	March 17, 1983	null	N	null	117	null	null
188564	99	433	PITTCOCK	08	20581	March 21, 1983	ANATHEMA, INC.	A	N	N	N	N	N	N	N	N	N	N	N	189085	March 21, 1983	null	N	null	1	null	null
188565	99	003	KNIGHT, ARGO	10	82512	March 21, 1983	BONNER, BOBBY	A	N	N	N	N	N	N	N	N	N	N	N	189086	March 21, 1983	null	N	null	2	null	null
188734	99	503	LAIRD	13	501300	March 23, 1983	LINDSAY, DICK	A	N	N	N	N	N	N	N	N	N	N	N	189255	March 23, 1983	null	N	null	9	null	null
191879	99	009	PARKEY	13	645100	April 11, 1983	PAUTSKY, JIMMY	A	N	N	N	N	N	N	N	N	N	N	N	192408	April 11, 1983	null	N	null	10	null	null
202164	99	399	TARR	08	912970	July 25, 1983	WESTWOOD ENERGY, INC.	A	N	N	N	N	N	N	N	N	N	N	N	202724	July 25, 1983	null	N	null	1	null	null
202609	99	503	BURGESS	13	500200	July 28, 1983	LEWIS, WILLIAM T.	A	N	N	N	N	N	N	N	N	N	N	N	203172	July 28, 1983	null	N	null	6	null	null
203993	99	441	HOLT	08	698100	Aug. 8, 1983	REEF PETROLEUM, INC.	A	N	N	N	N	N	N	N	N	N	N	N	204568	Aug. 8, 1983	null	N	null	38	null	null
203994	99	441	HOLT	08	698100	Aug. 8, 1983	REEF PETROLEUM, INC.	A	N	N	N	N	N	N	N	N	N	N	N	204569	Aug. 8, 1983	null	N	null	39	null	null
204222	99	211	ISAACS '209'	14	338130	Oct. 17, 1983	GULF OIL CORP.	P	N	N	N	N	N	N	N	N	N	N	N	null	null	null	N	null	6209	null	null
204994	99	207	MATHIS, R., JR.	08	884422	Aug. 9, 1983	VEDCO	A	N	N	N	N	N	N	N	N	N	N	N	205623	Aug. 15, 1983	null	N	null	1	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.

`status_no`

int4

Sampled: 50K
Distinct: 49.8K

45849 3
48958 3
6058 3
16988 3
28476 3
20355 3
9456 3
18564 3
33413 3
24986 3
39427 3
39569 3

`status_seq`

int4

Sampled: 50K
Distinct: 3

99 49.8K
98 160
97 13

`permit_no`

int4

Sampled: 50K
Distinct: 49.8K

16988 5
18664 3
39847 3
43810 3
20460 3
33552 3
28597 3
24899 3
39587 3
14554 3
6106 3
46023 3

`county_code`

varchar

Sampled: 50K
Distinct: 260

131 1.4K
485 1.3K
503 1K
367 990
009 943
133 932
237 886
105 886
083 739
429 726
479 724
049 687

`district`

varchar

Sampled: 50K
Distinct: 2

01 50K
00 11

`operator_no`

int4

Sampled: 50K
Distinct: 866

27200 8K
20425 7.6K
20528 4.7K
20572 4.1K
20542 2.7K
20430 1.3K
18900 870
16980 868
20566 853
3125 606
18023 605
15726 585

`lease_name`

varchar

Sampled: 50K
Distinct: 27.7K

DUVAL COUNTY RANCH COMPANY 408
DENVER UNIT 132
KING RANCH BORREGOS 122
HAGIST 118
HOUDMANN 111
YATES FIELD UNIT 108
CHITTIM, N. J. 104
WEST RANCH "A" 100
WALNUT BEND FIELD UNIT NO. 2 94
KING RANCH ALAZAN 87
LYKES BROTHERS, INC. 75
HAGIST RANCH 74

`received_date`

date

Sampled: 50K
Distinct: 528

Jan. 4, 1978 223
Dec. 29, 1978 208
Aug. 21, 1978 208
Dec. 22, 1977 198
Sept. 26, 1978 189
Dec. 30, 1977 187
May 23, 1979 182
Dec. 27, 1977 178
Dec. 11, 1978 177
Dec. 29, 1977 171
Oct. 24, 1978 170
Oct. 17, 1978 168

Take it away

Back to everything we know about Drilling Permit Master and Trailer