Dev Prod by Well

This table returns monthly oil, gas and water production figures for a specific well.

To refer to the Production by Well API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
PRODUCTION_MONTH	NUMBER	Month of gas or oil production. Starts from 1 and increases by 1 for each subsequent month of production.	51
GAS_MONTHLY	FLOAT	Amount of gas produced over one month (in MCF, or 1 thousand cubic feet).	61
OPERATOR_NAME	VARCHAR	Operator of the well.	“South Carlton Operating Company, LLC”
WELL_NO	VARCHAR	The number assigned to a well at a specific site.	“11-8X”
WELL_NAME	VARCHAR	The name assigned to a well at a specific site.	“C. O. OSWELL ET AL #1”
API	NUMBER	An API is a unique, permanent, numeric identifier assigned to each well drilled.	100319955
STATE_AB	VARCHAR	Abbreviation of the state.	“AL”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“909”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“AL”
COUNTY	VARCHAR	County in the state where the well is located.	“Baldwin”
FIELD_NAME	VARCHAR	The name of a specific oil and gas field - as designated by the appropriate state agency.	“South Carlton”
FORMATION	VARCHAR	Definition of the geological makeup (formation) at a specific well.	“Pilot-Massive”
TOWNSHIP	VARCHAR	Townships are divisions of a county, shaped as squares with 6 miles to a side. Township squares are gridded and numbered according to their position north or south of the baseline.	“003N”
RANGE	VARCHAR	Ranges are columns of townships set side-by-side. Range numbers start at the meridian that passes through the point of origin of each system and runs east to west.	“002E”
SECTION	VARCHAR	A section is a further subdivision of a township, represented by a numerical value between 1 and 36. Each section is about 1 square mile.	15
DATE	DATE	Unsynced date on which oil and gas production starts.	2021-09-01
OIL_MONTHLY	FLOAT	The amount of oil produced over one month (in BBLS, or barrels).	1185
WATER_MONTHLY	FLOAT	The amount of water extracted from the well during a one-month production period (in BBLs, or barrels).	2587

Example Data

PRODUCTION_MONTH	GAS_MONTHLY	OPERATOR_NAME	WELL_NO	WELL_NAME	API	STATE_AB	REGION	SUB_REGION	COUNTY	FIELD_NAME	FORMATION	TOWNSHIP	RANGE	SECTION	DATE	OIL_MONTHLY	WATER_MONTHLY
205	43334	HILCORP ENERGY COMPANY	11-8X	KENAI BELUGA UNIT 11-8X	5013320536	AK		Alaska	KENAI	Kenai	KENAI, BELUGA/UP TYONEK GAS	4N	11W	6	2021-06-01	0	221
206	44844	HILCORP ENERGY COMPANY	11-8X	KENAI BELUGA UNIT 11-8X	5013320536	AK		Alaska	KENAI	Kenai	KENAI, BELUGA/UP TYONEK GAS	4N	11W	6	2021-07-01	0	195
207	43095	HILCORP ENERGY COMPANY	11-8X	KENAI BELUGA UNIT 11-8X	5013320536	AK		Alaska	KENAI	Kenai	KENAI, BELUGA/UP TYONEK GAS	4N	11W	6	2021-08-01	0	70
208	41641	HILCORP ENERGY COMPANY	11-8X	KENAI BELUGA UNIT 11-8X	5013320536	AK		Alaska	KENAI	Kenai	KENAI, BELUGA/UP TYONEK GAS	4N	11W	6	2021-09-01	0	259
209	42673	HILCORP ENERGY COMPANY	11-8X	KENAI BELUGA UNIT 11-8X	5013320536	AK		Alaska	KENAI	Kenai	KENAI, BELUGA/UP TYONEK GAS	4N	11W	6	2021-10-01	0	42

Usage

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

Sample queries

⮞ Return the total amount of GAS_MONTHLY production by the operator “HILCORP ENERGY COMPANY”

SELECT
  SUM(dev_prod_by_well.gas_monthly) AS total_gas_production
FROM
  dev_prod_by_well
WHERE
  dev_prod_by_well.operator_name = 'HILCORP ENERGY COMPANY';

Output

	TOTAL_GAS_PRODUCTION
1	76974874154

⮞ Return the column names OPERATOR_NAME, WELL_NO and COUNTY for all the records where GAS_MONTHLY production is over 43000

SELECT
  OPERATOR_NAME,
  WELL_NO,
  COUNTY
FROM
  DEV_PROD_BY_WELL
WHERE
  GAS_MONTHLY > 43000;

Output

OPERATOR_NAME	WELL_NO	COUNTY
ELM III Operating Company LLC	1	Finney
Merit Energy Company, LLC	1	Grant
SCOUT ENERGY MANAGEMENT LLC	1	Grant
ELM III Operating Company LLC	1	Finney