Operator Classification

This table provides data about the operators classified as either public or private companies.

To refer to the operator classification API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
OPERATOR_NAME	VARCHAR	Operator of the well.	“ABRAXAS PETROLEUM CORPORATION”
TICKER	VARCHAR	If a company is public then the ticker is provided.	“AXAS”
PUBLIC_OR_PRIVATE	VARCHAR	Operator classification as a public or private company.	“PUBLIC”

Example Data

OPERATOR_NAME	TICKER	PUBLIC_OR_PRIVATE
ABRAXAS PETROLEUM CORPORATION	AXAS	PUBLIC
ANTERO RESOURCES CORPORATION	AR	PUBLIC
APACHE CORPORATION	APA	PUBLIC
BHP	BHP	PUBLIC
CAIRN ENERGY PARTNERS LLC		PRIVATE
CALYX ENERGY III, LLC		PRIVATE
CALYX ENERGY LLC		PRIVATE
CAMBRIAN MANAGEMENT LTD		PRIVATE

Usage

In Snowflake, you can write SQL queries to return the data you want.

Sample queries

⮞ Return the total number of operators which are classified as PRIVATE

SELECT COUNT(DIStinct operator_name) AS total_private_operators
FROM operator_tickers
WHERE operator_tickers.public_or_private ILIKE 'PRIVATE';

Output

	TOTAL_PRIVATE_OPERATORS
1	1250

⮞ Return all the records where the operator is “1920 ENERGY, LLC” and classified as “PRIVATE”

SELECT *
FROM operator_tickers
WHERE operator_tickers.operator_name = '1920 ENERGY, LLC'
AND operator_tickers.public_or_private ILIKE 'PRIVATE';

Output

OPERATOR_NAME	TICKER	PUBLIC_OR_PRIVATE
1920 ENERGY, LLC	null	PRIVATE