Preview P-5 Organization (ASCII)

First 100 rows

Out of roughly 78.3K rows in texas.operators. Version 20260913T233336Z.

First 100 rows of `texas.operators`, 13 columns wide
`id`	`name`	`p5_status`	`org_type`	`address1`	`address2`	`city`	`state`	`zip`	`phone`	`date_built`	`date_inactive`	`ingested_at`
304310	GIFFORD & MITCHELL	I	I	BOX 7040	null	MIDLAND	TX	79701	null	null	null	Sept. 13, 2026, 6:31 p.m.
307380	GIPSON, J. C.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
309370	GLASSCOCK, LONNIE	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
327175	GRAY, INEZ W.	I	I	BOX G	null	CHANNELVIEW	TX	77530	null	null	null	Sept. 13, 2026, 6:31 p.m.
337900	GULF COAST PETROLEUM COMPANY	I	I	BOX 27406	null	HOUSTON	TX	77027	null	March 7, 1979	null	Sept. 13, 2026, 6:31 p.m.
338771	HILLJE INC	I	A	P O BOX 485	null	COTULLA	TX	78014	8308792075	Aug. 25, 1998	Sept. 29, 2006	Sept. 13, 2026, 6:31 p.m.
341545	H & S COMPANY	I	I	BOX 659	null	KILGORE	TX	75662	null	null	null	Sept. 13, 2026, 6:31 p.m.
342850	HAHN, EVA R., MRS.	I	I	808 S. BRUCE	null	MONAHANS	TX	79756	null	March 1, 1979	null	Sept. 13, 2026, 6:31 p.m.
378250	HENDRICKSON, A. N.	I	I	BOX 792	null	MIDLAND	TX	79701	null	null	null	Sept. 13, 2026, 6:31 p.m.
388800	HILLS & HILLS DRLG. CO.	I	I	BOX 2437	null	PAMPA	TX	79065	null	null	null	Sept. 13, 2026, 6:31 p.m.
409505	HUDGENS, B. W., TRUSTEE	I	I	BOX 188	null	SEGUIN	TX	78155	null	null	null	Sept. 13, 2026, 6:31 p.m.
414350	HUNT, A. D. OIL CO.	I	A	BOX 316	null	CROSBY	TX	77532	7133284302	Sept. 2, 1977	null	Sept. 13, 2026, 6:31 p.m.
419425	HUNTLEY, BOB	I	I	BOX 1497	null	VERNON	TX	76384	null	null	null	Sept. 13, 2026, 6:31 p.m.
422889	ILVES, JAN P.	I	C	P.O. BOX 61419	null	DENVER	CO	80206	3033999428	March 4, 1985	Feb. 5, 1987	Sept. 13, 2026, 6:31 p.m.
424619	INLAND OIL CORPORATION	I	C	PO BOX 1015	null	BRISTOW	OK	74010	9183672208	March 4, 1993	Feb. 28, 1994	Sept. 13, 2026, 6:31 p.m.
426520	IRISH OIL CO.	I	I	3213 S. KEATON	null	TYLER	TX	75701	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:31 p.m.
428080	JACKSON, B. M.	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:31 p.m.
429610	JALL OIL CO.	I	F	BOX 774	null	OLNEY	TX	76374	8175642442	July 31, 1981	May 28, 1982	Sept. 13, 2026, 6:31 p.m.
429873	JANWOOD, INC.	I	A	PO BOX 50359	null	DENTON	TX	76206	9037772605	Nov. 10, 2000	Oct. 30, 2009	Sept. 13, 2026, 6:31 p.m.
431365	JENNINGS, K. E.	I	I	1334 SYLVAN	null	ABILENE	TX	79605	null	null	null	Sept. 13, 2026, 6:31 p.m.
28000	APPLING, EUCLID	I	C	BOX 65	null	STAMFORD	TX	79553	3257733654	June 22, 1977	null	Sept. 13, 2026, 6:30 p.m.
445470	JOPLIN, R. B.	I	I	BOX 402	null	GRAHAM	TX	76450	null	null	null	Sept. 13, 2026, 6:31 p.m.
447970	JOY OIL COMPANY	I	I	BOX 1776	null	CORSICANA	TX	75110	null	Jan. 9, 1978	null	Sept. 13, 2026, 6:31 p.m.
257640	F-W & RUFF	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
448950	K P M OIL CO.	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:31 p.m.
453140	KEATHLEY, BRYAN O.	I	I	310 N. WILLIS	null	ABILENE	TX	79603	null	null	null	Sept. 13, 2026, 6:31 p.m.
470540	KLINA OIL CO.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
480130	L. & N. DRILLING CO.	I	I	BOX 921	null	KILGORE	TX	75662	null	March 1, 1978	Dec. 31, 1981	Sept. 13, 2026, 6:32 p.m.
488240	LATIMER BROS.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:32 p.m.
490350	LAWRENCE, JACK G.	I	I	BOX 20335	null	DALLAS	TX	75220	null	null	null	Sept. 13, 2026, 6:32 p.m.
493950	LEE BROS.	I	I	BOX 3031	null	ABILENE	TX	79604	null	July 7, 1978	Dec. 31, 1981	Sept. 13, 2026, 6:32 p.m.
537375	MCATEE, ALPHA TRUST	I	I	BOX 698	null	ARCHER CITY	TX	76351	null	May 2, 1978	null	Sept. 13, 2026, 6:32 p.m.
123500	CAIN, W. L	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:30 p.m.
506515	LOMBARDO, CARLOS R	I	I	240 CROCKETT	null	BEAUMONT	TX	77701	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:32 p.m.
507405	LONE STAR PRODUCTION	A	C	P O BOX 155	null	LAWN	TX	79530	3256653325	Feb. 24, 2004	null	Sept. 13, 2026, 6:32 p.m.
509220	LOST TORTILLA	I	I	BOX 295	null	MONAHANS	TX	79756	null	null	null	Sept. 13, 2026, 6:32 p.m.
529485	MARTIN, EROL M.	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:32 p.m.
154748	CK SERVICES	I	D	PO BOX 603092	null	DALLAS	TX	75360	9724670807	Aug. 5, 2008	June 30, 2010	Sept. 13, 2026, 6:30 p.m.
554890	MCMURREY, ROBERT M. INC.	I	I	BOX 1074	null	KILGORE	TX	75662	null	null	null	Sept. 13, 2026, 6:32 p.m.
167060	COLE, G. E.	I	I	BOX 953	null	MIDLAND	TX	79701	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:30 p.m.
350210	HAMMAX, INC.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
568900	MILLER, RAY	I	I	BOX 751-THELMA BRYAN, AGENT	null	OLNEY	TX	76374	null	null	null	Sept. 13, 2026, 6:32 p.m.
571800	MITCHELL, SAMMY	I	C	P O BOX 921	null	KILGORE	TX	75663	9039843443	April 15, 1991	April 30, 2008	Sept. 13, 2026, 6:32 p.m.
103	A & G OIL COMPANY, LLC	I	H	PO BOX 25	null	BARSTOW	TX	79719	4324483170	Oct. 22, 2007	Feb. 28, 2013	Sept. 13, 2026, 6:30 p.m.
588800	MORRO OIL CO.	I	I	BOX 747	null	KILGORE	TX	75662	null	null	null	Sept. 13, 2026, 6:32 p.m.
350285	HAMMCO	I	D	P O BOX 640	null	MONAHANS	TX	79756	4325472279	May 3, 1994	Dec. 29, 1995	Sept. 13, 2026, 6:31 p.m.
192370	LEB OIL CO.	I	C	BOX 751	null	OLNEY	TX	76374	8175645591	June 10, 1988	May 31, 1990	Sept. 13, 2026, 6:30 p.m.
194820	CURD, W. P. JR. & SONS	I	D	BOX 561	null	KNOX CITY	TX	79529	8176583447	Aug. 9, 1977	null	Sept. 13, 2026, 6:30 p.m.
598305	MYRICK, F. H.	I	I	3005 EL PASO AVE.	null	SNYDER	TX	79549	null	July 12, 1977	null	Sept. 13, 2026, 6:32 p.m.
107	A&A ENERGY SERVICES LLC	A	H	PO BOX 51188	null	MIDLAND	TX	79710	4329785963	Nov. 20, 2018	null	Sept. 13, 2026, 6:30 p.m.
600845	NATURAL GAS & OIL CO	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:32 p.m.
612869	NORED, ANDY	I	C	BOX 1329	null	BOWIE	TX	76230	8178725428	null	null	Sept. 13, 2026, 6:32 p.m.
613775	NORTH CENTRAL & ELLISON, E. P.	I	I	1214 AMERICANA BLDG.	null	HOUSTON	TX	77002	null	null	null	Sept. 13, 2026, 6:32 p.m.
615990	NUECES LAND & LIVESTOCK CO.	I	I	BOX 1127	null	DENISON	TX	75020	null	null	null	Sept. 13, 2026, 6:32 p.m.
616375	NUNLEY & HALE	I	I	BOX 296	null	GRAHAM	TX	76450	null	May 31, 1977	null	Sept. 13, 2026, 6:32 p.m.
623100	189 OIL COMPANY, THE	I	I	316 GUARANTY BANK PLAZA	null	CORPUS CHRIST	TX	78401	null	null	null	Sept. 13, 2026, 6:32 p.m.
227460	DOUGLAS, S.A.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:31 p.m.
238537	E C I	D	C	BOX 426	null	COLEMAN	TX	76834	7134984030	Aug. 18, 1977	null	Sept. 13, 2026, 6:31 p.m.
238608	E. & R EQUIPMENT CO.	I	D	POST 6, BOX 6	null	MAY	TX	76857	3257846092	Oct. 19, 1977	Aug. 31, 1989	Sept. 13, 2026, 6:31 p.m.
637800	PAN OCEAN OIL CORP.-TEXAS-	I	I	BOX 1067	null	OZONA	TX	76943	null	null	null	Sept. 13, 2026, 6:32 p.m.
241000	ECHOLS, P. Q.	I	I	BOX 1132	null	CRANE	TX	79731	null	null	null	Sept. 13, 2026, 6:31 p.m.
641835	PARR, HILDA	I	C	BOX Q	null	BENAVIDES	TX	78341	5122563350	June 1, 1983	Aug. 31, 1987	Sept. 13, 2026, 6:32 p.m.
245770	EGGER, JACK C.	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:31 p.m.
643460	PATTERSON, S. L.	I	C	BOX 322	null	WINK	TX	79789	4325273603	null	Aug. 31, 1982	Sept. 13, 2026, 6:32 p.m.
248580	ELLIS, AMON	I	D	P O BOX 751	null	OLNEY	TX	76374	9405645591	Feb. 27, 1978	March 31, 2000	Sept. 13, 2026, 6:31 p.m.
251275	EMMANUEL ENERGY, INC.	I	I	BOX 1086	null	BORGER	TX	79007	null	null	null	Sept. 13, 2026, 6:31 p.m.
654710	PERKINS, J. G.	I	C	RT. 1	null	DECATUR	TX	76234	8176272521	null	Aug. 31, 1982	Sept. 13, 2026, 6:32 p.m.
660780	PETROLIMA, LLC	I	H	PO BOX 1113	null	MIDLAND	TX	79702	4326959989	May 16, 2016	May 24, 2017	Sept. 13, 2026, 6:32 p.m.
660836	PETROLEUM RESOURCES CORP	I	I	BOX 17142	null	MEMPHIS	TN	38117	null	null	null	Sept. 13, 2026, 6:32 p.m.
663640	PHILLIPS, P. W.	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:32 p.m.
263895	FAYE OIL CO.	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:31 p.m.
665677	PINKSTON & HOOD	I	I	STREET ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	null	null	Sept. 13, 2026, 6:32 p.m.
666185	PITMAN, JOHN D., ET AL	I	I	ADDRESS UNKNOWN	null	UNKNOWN	XX	99999	null	Jan. 1, 1970	Oct. 6, 1983	Sept. 13, 2026, 6:32 p.m.
668220	PLOEGER, MARKUS	I	I	RURAL ROUTE 3	null	YOAKUM	TX	77995	null	null	null	Sept. 13, 2026, 6:32 p.m.
668585	POAGE OILFIELD SERVICE CO.	D	A	PO BOX 850680	null	YUKON	OK	73085	4053242217	July 23, 2013	null	Sept. 13, 2026, 6:32 p.m.
671445	POR-BOY OIL CO.	I	I	BOX 389	null	GRAHAM	TX	76450	null	null	null	Sept. 13, 2026, 6:32 p.m.
683185	PURSLEY, C. P.	I	D	BOX 900	null	PAMPA	TX	79065	8066697353	null	Aug. 31, 1992	Sept. 13, 2026, 6:32 p.m.
687290	R & R DEVELOPMENT CO.	I	I	BOX 407	null	MUNDAY	TX	76371	null	null	null	Sept. 13, 2026, 6:32 p.m.
116	A - Z OPERATING LLC	A	H	PO BOX 314	null	WINTERS	TX	79567	3257232150	Feb. 14, 2018	null	Sept. 13, 2026, 6:30 p.m.
698747	REGAL OPERATING	I	C	PO BOX 671	null	CISCO	TX	76437-0671	8176298595	Oct. 29, 1984	Dec. 30, 2005	Sept. 13, 2026, 6:32 p.m.
699720	REID, A. E.	I	I	401 N. MAIN	null	ELECTRA	TX	76360	null	null	null	Sept. 13, 2026, 6:32 p.m.
704360	REYNOLDS, J. C.	I	I	412 S. MAIN	null	ANDREWS	TX	79714	null	null	null	Sept. 13, 2026, 6:32 p.m.
706405	RIATA	I	C	1503 SKYLES	null	ROCKDALE	TX	76567	5124466311	Feb. 16, 1982	Nov. 18, 1999	Sept. 13, 2026, 6:32 p.m.
714266	RJC	I	C	7115 WINKLEMAN RD.	null	HOUSTON	TX	77083	9722344149	Nov. 24, 1981	March 29, 1996	Sept. 13, 2026, 6:32 p.m.
350365	HAMMER & ANVIL CO	I	A	PO BOX 71	null	KERMIT	TX	79745	4325865409	May 6, 1980	April 30, 1984	Sept. 13, 2026, 6:31 p.m.
339350	GUNBY, MERLE F.	I	I	BOX 356	null	MEGARGEL	TX	76370	null	null	null	Sept. 13, 2026, 6:31 p.m.
722173	ROBOCO, INC.	I	A	P. O. BOX 72400	null	CORPUS CHRSTI	TX	78472	5128526644	Sept. 3, 1985	Aug. 31, 1989	Sept. 13, 2026, 6:32 p.m.
687255	R. & R. CO.	I	I	BOX 1625	null	SHREVEPORT	LA	71165	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:32 p.m.
346900	HALL TRUST	I	I	BOX 1718	null	FORT WORTH	TX	76101	null	null	null	Sept. 13, 2026, 6:31 p.m.
732940	RUBY OIL CO.	I	I	BOX M	null	HAMLIN	TX	79520	null	null	null	Sept. 13, 2026, 6:33 p.m.
360050	HARRIS, JOHN D.	I	I	BOX 684	null	ALICE	TX	78332	null	null	null	Sept. 13, 2026, 6:31 p.m.
740895	S & R, INC.	I	I	BOX 390	null	BRECKENRIDGE	TX	76424	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:33 p.m.
741118	S & T OPERATING	I	C	P.O. BOX 254	null	MALAKOFF	TX	75148	9034891842	June 24, 1988	Aug. 31, 1993	Sept. 13, 2026, 6:33 p.m.
390785	HODGES SERVICES	I	C	PO BOX 453	null	WHITE OAK	TX	75693	9032639644	June 14, 2011	May 31, 2012	Sept. 13, 2026, 6:31 p.m.
767594	SERRA ENERGY, INC.	I	A	PO BOX 850	null	HAILEY	ID	83333	2089287261	Aug. 10, 1987	Aug. 31, 2011	Sept. 13, 2026, 6:33 p.m.
405860	HOWARD, H. B.	I	I	BOX 328	null	MEXIA	TX	76667	null	null	null	Sept. 13, 2026, 6:31 p.m.
406122	HOWELL, C.W.	I	I	BOX 127	null	WALTERS	OK	73572	null	null	Dec. 31, 1981	Sept. 13, 2026, 6:31 p.m.
785246	SIX-S PROPERTIES, INC.	I	A	P O BOX 1016	null	AUSTIN	TX	78767	5124198193	May 14, 1979	Jan. 29, 2016	Sept. 13, 2026, 6:33 p.m.
937405	WOOD, JOE E.	I	I	BOX 365	null	LULING	TX	78648	null	null	null	Sept. 13, 2026, 6:33 p.m.
790800	SMITH, E. H.	I	I	2012 ALAMO NATL BANK BLDG	null	SAN ANTONIO	TX	78205	null	null	null	Sept. 13, 2026, 6:33 p.m.

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.

`id`

int4

Sampled: 50K
Distinct: 50K

35599 1
167276 1
146688 1
250722 1
300840 1
243212 1
196916 1
596865 1
161180 1
37876 1
159965 1
594100 1

`p5_status`

bpchar

Sampled: 50K
Distinct: 4

I 39.1K
A 6K
D 4.9K
H 4

`org_type`

bpchar

Sampled: 50K
Distinct: 9

A 17.7K
C 10.7K
H 8.6K
I 6K
D 3.4K
B 1.7K
F 1.4K
E 233
G 201

`name`

varchar

Sampled: 50K
Distinct: 50K

CJRW OIL & GAS 1
DRENNAN & PETERSON, INC. 1
H A W INVESTMENT 1
AMTEXX ENERGY 1
GULFTEX ENERGY II, LP 1
GLADIATOR ENERGY LLC 1
MOORE & LASITER 1
G. & R. OIL ACCOUNT 1
G & G ENERGY, INC. 1
FLUSCHE, HERB 1
COLUMBIA OIL CORP&UNITED ENERGY 1
I. B. OIL COMPANY 1

`address1`

varchar

Sampled: 50K
Distinct: 35.9K

ADDRESS UNKNOWN 1.4K
STREET ADDRESS UNKNOWN 1.2K
PO BOX 921 98
P O BOX 921 80
PO BOX 1925 67
BOX 747 39
BOX 953 39
P O BOX 1327 37
1001 LOUISIANA ST 36
1300 MAIN ST 34
PO BOX 1327 34
ATTN DAN SAWYER 34

`address2`

varchar

Sampled: 50K
Distinct: 1.6K
Empty: 0.9505

1300 MAIN STREET 46
SUITE 1000 26
200 WEST FOSTER RM 300 22
STE 300 18
P O BOX 2511 17
MD 16-304 16
STE 200 15
STE 1000 15
SUITE 100 14
SUITE 500 13
STE 400 13
SUITE 200 13

`city`

varchar

Sampled: 50K
Distinct: 2.1K
Empty: 0.0002

HOUSTON 5.3K
DALLAS 2.7K
MIDLAND 2.7K
UNKNOWN 2.6K
SAN ANTONIO 1.4K
ABILENE 1.3K
WICHITA FALLS 1.2K
FORT WORTH 1K
AUSTIN 897
ODESSA 829
GRAHAM 805
CORPUS CHRSTI 548

`state`

bpchar

Sampled: 50K
Distinct: 54
Empty: 0.0019

TX 41.5K
XX 2.6K
OK 1.6K
LA 1K
CO 691
NM 597
CA 320
KS 184
IL 105
MS 101
FL 97
AR 94

Take it away

Back to everything we know about P-5 Organization (ASCII)