Preview PDQ Operator Directory

First 100 rows

Out of roughly 78.2K rows in texas.pdq_og_operator_dw. Version obs-a349440fa8f5.

`operator_no`	`operator_name`	`p5_status_code`	`p5_last_filed_dt`	`operator_tax_cert_flag`	`operator_sb639_flag`	`fa_option_code`	`record_status_code`	`efile_status_code`	`efile_effective_dt`	`create_by`	`create_dt`	`modify_by`	`modify_dt`	`ingested_at`
635107	PALADIN PETROLEUM III, L.L.C.	A	20250617	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635108	PALESTINE CONTRACTORS SERV., LTD	I	20000516	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635109	PALESTINE CONTRACTORS OF PAL INC	I	19980505	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635110	PALADIN-HAYES, L.L.C.	I	20000828	Y	Y	42	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635111	PALETTE INVESTMENT COMPANY	I	19890908	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635112	PALADIN PETROLEUM CORPORATION	I	19911015	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635113	PALESTINE ENVIRON. SERV., INC.	I	19940629	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635114	PALAFOX OF MIDLAND, INC.	I	19870928	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635115	PALADIN PIPE LINE COMPANY	I	19930804	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635116	PALEO, INC.	A	20260424	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635117	PALAFOX OF MIDLAND	I	19860228	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635118	PALAURA EXPLORATION COMPANY	I	19881221	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635119	PALESTINE GTM, INC.	I	19850205	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635120	PALAFOX GAS CO.	I	19900731	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635121	PALCO, INC.	I	19870805	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635122	PALEFACE FORTY-FIVE INVESTMENTS	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635123	PALEO OIL & GAS, INC.	I	19971205	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635124	PALEO O&G INC & LND ENERGY DEV.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635125	PALESTINE CONTRACTORS, INC	I	19940627	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635126	PALEO PETROLEUM COMPANY	I	19860924	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635127	PALEO-ENERGY, INC.	I	19870305	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635128	PALFAM, INC.	I	19840726	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635129	PALEOSEARCH	I	19940502	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635130	PALESTINE PETROLEUM SERVICES	I	19821223	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635131	PALEO OIL COMPANY LLC	A	20250910	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635132	PALESTINE OILFIELD SERVICE,LLC	I	20020419	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635133	PALINE PIPELINE COMPANY	I	20110413	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635134	PALEO MIDSTREAM LLC	A	20240711	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635135	PALISADES ASSET HOLDING CO., LLC	I	19990716	Y	Y	42	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635136	PALINE PIPELINE COMPANY, LLC	A	20260324	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635137	PALISADES EXPLORATION, LLC	A	20260317	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635138	PALISADES OPERATING COMPANY	A	20260114	Y	Y	01	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635140	PALM, EDWIN H.	I	19840808	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635200	PALM EXPLORATION, INC.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635215	PALL MALL TRADING, LLC	I	20190424	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635230	PALLETIZED CRUDE TRANSPORT LLC	I	20140206	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635260	PALLETIZED TRUCKING, INC.	D	20250219	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635290	THE PALM CONDOMINIUM COMMUNITY	D	20200213	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635320	PALM PETROLEUM CORPORATION	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635321	PALM PETROLEUM CO.	I	19910906	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635322	THE PALM GARDENS HOA, INC.	D	20231207	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635323	PALM PETROLEUM CORP.	I	20010809	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635324	THE PALM APARTMENTS	I	20170105	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635325	PALM VALLEY CORPORATION	I	19840124	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635350	PALMCO CORPORATION	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635400	PALMCO MANAGEMENT CO.	I	19860801	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635440	PALMER & TYLER OIL CO.	I	19910725	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635445	PALMER AUCTIONEERING	I	19890518	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635449	PALMER BROTHERS	I	20041011	Y	Y	01	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635450	PALMER DRILLING CO.	I	19901127	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635470	PALMER OIL & GAS	I	19890627	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635475	PALMER OIL PROPERTIES	A	20250801	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635488	PALMER OILFIELD CONSTRUCTION	I	19930915	Y	Y	42	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635489	PALMER OILFIELD CONSTRUCTION CO.	I	20030625	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635494	PALMER OPERATING LLC	A	20260107	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635500	PALMER PET.,-CADDO MGMT., INC.	I	19830926	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635630	PALMER, FISHER W.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635700	PALMER, G./VERDAD OIL & GAS CORP	I	19841001	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635720	PALMER, GLENDA MAE	I	19900828	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635800	PALMER, J. A.	I	19930803	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635970	PALMER, J. B.	I	19820729	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635980	PALMER, J. H. OIL CO.	I	19900508	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
635990	PALMER, J. M.	I	20090910	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636010	PALMER, JAMES W.	I	20010824	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636020	PALMER, JOHN INC.	I	19930223	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636025	PALMER, JOHN LLC	A	20260128	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636030	PALMER, JOHN T.	I	19910730	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636040	PALMER, JOHN W. OIL ACCOUNT	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636050	PALMER, JOHNNY	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636140	PALMER, L. FRANK	I	19860722	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636220	PALMER, LELAND L.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636221	PALMER, MIKE OIL	I	20200226	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636222	PALMER PETROLEUM INC.	I	20240916	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636225	PALMER, R. J.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636250	PALMER, ROGER	I	19870812	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636375	PALMER PIPE & SUPPLY,INC.	I	19910829	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636495	PALMER TANK TRUCKS, INC.	I	20060818	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636496	PALMER, ROGER L.	I	20010809	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636497	PALMER, RUDY	I	19860311	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636500	PALMER, T. W.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636512	PALMER, SCOTT OIL	I	20210602	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636525	PALMER'S OILFIELD WATER HAULING	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
636947	PALMERA RESOURCES, LLC	I	20151102	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637370	PALMETTO PRODUCTION CO.	I	19880614	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637372	PALMETTO SERVICES, LLC	A	20260407	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637375	PALMIGO OIL CO.	I	20150214	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637377	PALO DURO EXPLORATON, LLC	I	20141222	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637380	PALO DURO OIL CO.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637381	PALO DURO DISPOSAL, INC.	I	20141108	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637382	PALO DURO BASIN ENERGY COMPANY	I	20060727	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637383	PALO DURO OPERATING (US), INC.	I	20080911	Y	N	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637384	PALO CROSS, LLC	A	20250807	Y	N	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637385	PALO DURO PIPELINE CO.	I	19830801	Y	N	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637386	PALO DURO OIL CO. (B)	I	19920211	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637387	PALO DURO PIPELINE COMPANY, INC.	D	19980629	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637388	PALNG COMMON FACILITIES CO, LLC	I	20200729	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637389	PALO DURO RESOURCES LLC	D	20230929	Y	Y	02	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637390	PALO DURO RIVER AUTHORITY OF TX	I	19891205	Y	Y	NS	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637393	PALO EXPLORATION CORPORATION	I	19920602	Y	Y	03	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 p.m.
637400	PALO PETROLEUM, INC.	A	20250801	Y	Y	99	null	null	null	ORF169 mainframe file	June 18, 2026	null	null	July 26, 2026, 11:01 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.

`operator_no`

varchar

Sampled: 50K
Distinct: 50K

180072 1
103739 1
003732 1
229303 1
575165 1
445569 1
149526 1
003599 1
511722 1
000690 1
000822 1
480552 1

`operator_name`

varchar

Sampled: 50K
Distinct: 50K

WESTERN OIL TRANSPORTATION 1
VICK, WAYNE OIL & GAS ASSOCIATES 1
AMTEXX ENERGY 1
BLOUNT PET., INC. & TEPCO ENG. 1
ROWE, JOE D. 1
TANOS PETROLEUM, INC. 1
CAPROCK DISPOSAL, LLC 1
WHITE, B. D. 1
CHAMBLISS, G.C., JR. 1
DK & DN ASSET HOLDING CO., LLC 1
AFOC, LLC 1
DRENNAN & PETERSON, INC. 1

`p5_status_code`

varchar

Sampled: 50K
Distinct: 7

I 41.8K
A 4.4K
D 3.3K
X 369
S 110
H 6
R 3

`p5_last_filed_dt`

varchar

Sampled: 50K
Distinct: 10K

00000000 8.1K
20250529 101
19901030 77
19910109 68
19911004 64
20260128 60
19910828 56
20260304 55
20251016 48
20260311 48
19901127 48
19901203 46

`operator_tax_cert_flag`

varchar

Sampled: 50K
Distinct: 3

Y 49.3K
N 654
X 46

`operator_sb639_flag`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0007

Y 43.2K
N 6.8K

`fa_option_code`

varchar

Sampled: 50K
Distinct: 7

NS 23.6K
99 9.1K
02 8.6K
03 5.6K
42 2K
01 686
41 500

`record_status_code`

varchar

Sampled: 50K
Distinct: 0
Empty: 1.0

Take it away

Back to everything we know about PDQ Operator Directory