Preview PDQ Operator Directory

First 100 rows

Out of roughly 78.3K rows in texas.pdq_og_operator_dw. Version obs-c70cc511483c.

First 100 rows of `texas.pdq_og_operator_dw`, 15 columns wide
`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`
000001	RAILROAD COMMISSION DISTRICT 01	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000002	RAILROAD COMMISSION DISTRICT 02	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000003	RAILROAD COMMISSION DISTRICT 03	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000004	RAILROAD COMMISSION DISTRICT 04	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000005	RAILROAD COMMISSION DISTRICT 05	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000006	RAILROAD COMMISSION DISTRICT 06	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000007	RAILROAD COMMISSION DISTRICT 06E	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000008	RAILROAD COMMISSION DISTRICT 07B	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000009	RAILROAD COMMISSION DISTRICT 07C	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000010	RAILROAD COMMISSION DISTRICT 08	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000011	RAILROAD COMMISSION DISTRICT 08A	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000012	RAILROAD COMMISSION DISTRICT 08B	S	00000000	Y	null	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000013	RAILROAD COMMISSION DISTRICT 09	A	20260712	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000014	RAILROAD COMMISSION DISTRICT 10	A	20220114	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000015	RAILROAD COMMISSION OF TEXAS	A	19840309	Y	null	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000016	A & E MINERALS, LLC	A	20250926	Y	null	01	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000017	A + INVESTMENTS A TEXAS LLC	A	20260605	Y	null	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000020	A & P OIL AND GAS COMPANY, LLC	D	20200928	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000025	A & A ENTERPRISES, L.L.C.	A	20231005	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000036	A&D OILFIELD SERVICES LLC	D	20170315	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000057	A & G FIELD SERVICES	A	20260508	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000100	A-1 CASING PULLERS, INC.	I	00000000	Y	null	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000101	A & G FERNANDEZ TRUCKING	I	20110926	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000102	A & G PRODUCERS, INC.	A	20260305	Y	null	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000103	A & G OIL COMPANY, LLC	I	20111020	Y	null	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000106	A & S VACUUM SERVICE	I	20110613	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000107	A&A ENERGY SERVICES LLC	A	20250915	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000108	A-PLUS WELL SERVICE, INC.	D	20220112	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000109	A Y TRUCKING, INC	I	20200206	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000110	A-1 ROCKET ENERGY SERVICES, LLC	A	20260226	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000111	A & RJ OILFIELD SERVICES LLC	I	20250115	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000112	A & RJ OILFIELD SERVICES	I	20140129	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000113	A AND J PETROLEUM	I	20141204	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000114	A AND C TRANSPORT SERVICE	D	20201210	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000115	A AND O OILFIELD SERVICES	I	20140902	Y	null	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000116	A - Z OPERATING LLC	A	20260128	Y	null	01	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000118	AAA OIL TRUST	D	20101004	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000119	ABBRO LOGISTIC SERV.	I	20120601	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000120	A&A 1TRUCKING LLC	D	20141124	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000121	ABBEY ROAD APARTMENTS	A	20260122	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000122	ABC EXPRESS, INC.	I	20120402	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000123	A&A TRUCKING	I	20110906	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000124	A TO Z MUD CO., INC.	I	20150106	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000125	A-1 CONSTRUCTION COMPANY, INC.	I	19910109	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000126	A-PLUS RIGS & CEMENTING COMPANY	I	20101110	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000127	ABBRO FLUID SERVICES INC.	I	20081001	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000128	A & B OPERATING COMPANY	I	20121024	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000129	A&R DISPOSAL OPERATING CO., LLC	I	20170222	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000130	A-1 DRILLING	I	19860124	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000131	A TO Z PRESSURE PUMP SERVICESLLC	I	20061218	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000132	A & A PUMPING SERVICE	I	20120824	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000133	A T M CORPORATION	I	20020115	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000134	A & A TANK TRUCK CO.	I	20230119	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000135	A-1 LUMBER & HARDWARE, INC.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000136	A.B.C. ENERGY CO.	I	20001018	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000137	ABBOTT, JOHN OPERATING	A	20260306	Y	Y	01	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000138	ABC NITROGEN SERVICE CORP.	D	20130814	Y	Y	99	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000139	A & B WELL SERVICE INC.	I	20051209	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000140	A&B PIPELINE CO. INC.	D	19900507	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000141	A.A.F. PRODUCTION CO., INC.	I	19970326	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000142	A B ENERGY INC.	I	19940713	N	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000143	A.D.H. OPERATING CO., INC.	I	19870817	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000144	A&A SALTWATER HAULER	I	19860717	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000145	A-1 TANK RENTAL & SALES, INC.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000146	A.D.S. RESOURCES, INC.	I	20080424	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000147	A.A. OILFIELD SERVICE, INC.	I	19970117	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000148	AAA OIL COMPANY	A	20260220	Y	Y	01	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000149	A.A. INVESTMENTS	I	19891207	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000150	A - 1 TANK RENTAL & TRUCKING CO.	I	19860106	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000151	A A PRODUCTION INC.	I	19970808	N	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000152	A.W.L. ENTERPRISES	I	19910107	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000153	A & A OIL & GAS	I	19851023	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000154	ABBRO OIL COMPANY	I	19860425	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000155	A & A DRILLING & PRODUCTION	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000156	A.V.G. EXPLORATION, INC.	I	19910308	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000157	A & A PRODUCTION CO.	I	00000000	Y	N	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000158	A.A. DRILLING CO.	I	19840416	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000159	A.B.F.	I	19840322	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000160	A W B OIL CO., INC.	I	19910326	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000161	A-B PRODUCTION COMPANY	I	19830124	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000162	A&B OPERATING	I	19820804	Y	N	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000163	AAA OPERATING COMPANY INC.	I	19871002	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000164	A & A OIL COMPANY	I	19961014	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000165	A & A ENGINEERING SERVICE	I	19831129	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000166	A & A TRANSPORTS, INC.	I	19971118	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000167	AAA PIPE CLEANING CORP.	I	19871217	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000168	A A A WELL SERVICE, INC.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000169	A.B.G. PRODUCTION COMPANY	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000170	A & B ASSOCIATES	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000171	A. & B. OPERATORS	I	19841203	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000172	A & B OIL	A	20260108	Y	Y	02	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000173	A & B OIL COMPANY	I	19880310	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000174	ABC OIL & GAS COMPANY	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000175	A & C PROD. CO.	I	19881215	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000176	A. C. C. VACUUM TRUCKS	I	19930108	Y	Y	03	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000177	A-C OIL COMPANY	I	19891204	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000178	A C DRILLING	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000179	A C A PRODUCTION	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000180	A. C. F. OIL CO.	I	00000000	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 p.m.
000181	A C A PRODUCTION COMPANY	I	19860502	Y	Y	NS	null	null	null	ORF169 mainframe file	Aug. 19, 2026	null	null	Sept. 6, 2026, 11 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

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

`p5_status_code`

varchar

Sampled: 50K
Distinct: 7

I 42.1K
A 4.4K
D 3K
X 318
S 131
H 3
R 2

`p5_last_filed_dt`

varchar

Sampled: 50K
Distinct: 9.9K

00000000 8.3K
20250529 83
19910109 72
19910626 59
20260128 59
20260304 53
19910603 52
19910201 50
19860225 50
19850325 49
19910228 49
19861222 48

`operator_tax_cert_flag`

varchar

Sampled: 50K
Distinct: 3

Y 49.3K
N 652
X 52

`operator_sb639_flag`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0007

Y 43.8K
N 6.2K

`fa_option_code`

varchar

Sampled: 50K
Distinct: 7

NS 24K
99 8.8K
02 8.4K
03 5.6K
42 1.9K
01 757
41 508

`record_status_code`

varchar

Sampled: 50K
Distinct: 0
Empty: 1.0

Take it away

Back to everything we know about PDQ Operator Directory